maricopa county elections & gis at geeknet11
TRANSCRIPT
![Page 1: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/1.jpg)
Maricopa CountyElections DepartmentGeographic Information System
Gary Bilotta – Senior GIS Developer/Manager
![Page 2: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/2.jpg)
Software
• SQL Server 2008 Spatial 64-bit on Windows Server 2008
• ArcGIS Server Basic Enterprise (Database) 64-bit (2)• ArcGIS Server Standard Enterprise (Web) (2)• ArcGIS ArcInfo Concurrent Use (6)• ArcGIS ArcView Single Use (5)
![Page 3: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/3.jpg)
Software & Hardware Deployment
ArcGIS Desktop
GIS Production Database
Primary Node Secondary Node
*SQL Server Spatial*ESRI SDE
*SQL Server Spatial*ESRI SDE
Internet UsersArcGIS ServerWeb Server
Elections Production Database
*SQL Server Spatial*Replicates Address, Street and District datasets for locating voters and assigning voting districts
*Two load balance servers*Interactive Mapping Websites*ESRI ArcGIS Server
Development*Develop ArcGIS Server websites using Visual Studio 2010 ASP.net/Silverlight*Develop ArcGIS Desktop extensions using Visual Studio 2010 VB.net
![Page 4: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/4.jpg)
Software & Hardware Deployment
SQL Server Spatial is utilized to run spatial queries without ESRI software. Using the SQL Server Geometry data type allows us to add/change SQL queries to current programs rather than adding more software layers.
![Page 5: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/5.jpg)
Building Spatially Enabled Datasets
Election District Boundaries (cities, school districts, fire districts, etc…)
GIS datasets help us visualize and programmatically identify spatial relationships
![Page 6: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/6.jpg)
Building Spatially Enabled Datasets
Street Centerlines and Address Points
![Page 7: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/7.jpg)
Assigning Districts to Voters
When a voter registers or changes their address, districts are assigned based on the given address.
Spatial databases can make integrating GIS in existing
applications easier.
![Page 8: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/8.jpg)
Assigning Districts to Voters
When a boundary changes shape or a boundary is added, triggers query the database for addresses that are affected. When complete, the voter records at those addresses are updated with the new district information. In addition, if an address point changes, any voters registered at it will also have their districts updated.
![Page 9: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/9.jpg)
Election Setup
Determine which voting districts fall within a voting precinct for ballot creation.
SQL Spatial Query
![Page 10: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/10.jpg)
Custom Desktop Applications
Address Editing
Customized ArcObjects/VB.net Extensions*Streets
*Addresses
Customized Editing Tools
![Page 11: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/11.jpg)
Custom Desktop Applications
Custom tools to create election delivery routes
![Page 12: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/12.jpg)
Custom Desktop Applications
Tools for generating election maps of an entire election.
Tools for creating maps showing if the voter is in the correct polling location & providing adjacent precinct polling places.
![Page 13: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/13.jpg)
Custom Desktop Applications
Tools for generating election maps for use at the polls in determining ballot style (green or purple stripe) for voters in the precinct
![Page 14: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/14.jpg)
Custom Desktop ApplicationsTools for generating election maps for our field rovers (troubleshooters) of their area of responsibility.
![Page 15: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/15.jpg)
This map shows the correct PP in blue and the wrong PPs in green with a purple line from the voter’s residence to the PP they went to in error.
Custom Desktop Applications
![Page 16: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/16.jpg)
Custom Desktop Applications
Legal Descriptions For DOJ Submissions
Demographics for DOJ Submissions
After each decennial census, the elections department redraws the voting precincts, board of supervisor and justice of the peace boundaries.
![Page 17: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/17.jpg)
Custom Web ApplicationsOnline Reviewer website for the public to lookup district information
http://recorder.maricopa.gov/reviewer
Built using Visual Studio 2010 (vb.net), Silverlight and ArcGIS Server
![Page 18: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/18.jpg)
Custom Web ApplicationsPolling Place Locator
![Page 19: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/19.jpg)
Custom Web ApplicationsOnline Redistricting for the public to make suggestions to district boundaries https://recorder.maricopa.gov/
redistricting
The interactive mapping tool allows for the public to draw their own lines as well as view the corresponding demographic impact of the changes:
![Page 20: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/20.jpg)
Custom Web ApplicationsCandidates, the media, and election officials are interested in knowing which
precincts have reported results on election night. An internet map on election night as well as at the Phoenix Convention Center showing this is very helpful.
![Page 21: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/21.jpg)
Mapping of minority language ballot requests assist in determinations of where to place bilingual pollworkers on Election Day:
Custom Mapping
![Page 22: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/22.jpg)
Custom Mapping
![Page 23: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/23.jpg)
Custom Mapping
Mapping aids in identifying geographic anomalies.
![Page 24: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/24.jpg)
Additional analysis shows that although these 2
precincts seem to stand out because they are not
covered; surveys said no voters came in needing
assistance and they have a very low request rate of
Spanish ballots:
Custom Mapping
![Page 25: Maricopa County Elections & GIS at GeekNet11](https://reader036.vdocuments.us/reader036/viewer/2022081515/559053b21a28ab556d8b4720/html5/thumbnails/25.jpg)
Mapping of Census demographic data aids in demonstrating urban Native American populations to inform redistricting decisions:
Custom Mapping