310 likes | 441 Views
Polling Locator. Johnson County Election Office Poll locator for mobile or web based access. Solution. Polls Locator Webservice Address Web Service based. Process. Prepopulate poll id for every address point. Process. Process. Use address webservice to get apid
E N D
Polling Locator • Johnson County Election Office • Poll locator for mobile or web based access
Solution • Polls Locator Webservice • Address Web Service based
Process • Prepopulate poll id for every address point
Process • Use address webservice to get apid • Kept everything web service based since multiple interfaces needs access (phone, web)
Process • Use poll locator webservice w/ address apid to get poll information
Data • Data published from Election Office • Voting Precincts (polygons) • Elections (temporal event) • Polling Location (points)
From the shapefiles and comma-delimited text files that the Election Office provides, AIMS creates the following tables (aimsAppProd) and feature classes (jocoPub). PollingPlace_PT elcPollingPlace elcElection PPID (PK) Status Description APID (FK) Address, City, State, Zip spX, spY, Longitude, Latitude ELID (PK) Status Description Start Finish elcElectionPollingPlacePrecinct ELID (PK) PPID (PK) Precinct (PK) Status VotingPrecinct_PL Precinct (PK) PrecinctName KSSenateDistrict KSRepresentativeDistrict KSBOEDistrict BOCCDistrict • 1 record per polling place • Hope Alive Christian Center • Blue Valley HS • 1 record per precinct • N616 (OP Ward 6, Precinct 16) • I406 (Lenexa Ward 4, Precinct 6) 1 record per election > Aug 5 ’08 Primary > Nov 4 ’08 General • Intersection table (polling place for a voting precinct in a given election • In the Aug 5 ’08 Primary, the polling place for precinct I406 is VFW Post #7397 • In the Aug 5 ’08 Primary, the polling place for precinct H406 is Church of the Resurrection
PollingPlace_PT elcPollingPlace elcElection PPID (PK) Status Description APID (FK) Address, City, State, Zip spX, spY, Longitude, Latitude ELID (PK) Status Description Start Finish elcElectionPollingPlacePrecinct ELID (PK) PPID (PK) Precinct (PK) Status VotingPrecinct_PL Precinct (PK) PrecinctName KSSenateDistrict KSRepresentativeDistrict KSBOEDistrict BOCCDistrict PollingPlace_PT_vw1 VotingPrecinct_PL_vw5 PollingPlace_PT-elcElectionPollingPlacePrecinct- VotingPrecinct_PL VotingPrecinct_PL-elcElectionPollingPlacePrecinct- elcPollingPlace Precinct … PPID … PPID … Precinct … From these (and other) tables/FCs, AIMS derives various SQL Server views and SDE Views: vwAddptPollingPlace Addpt-AddptIntersect-elcPollingPlacePrecinct APID … Precinct … PPID … Provides precinct and polling place for every address Provides precinct(s) for every polling place (coincident points) Provides polling place for every precinct
Data • Data and Webservices are available to AIMS data licensees
Process • Create web page for presentation layer • Display poll information and map www.jocopolo.com
…and the mobile piece? • Text Messaging • To: 74574 • Text: voteks 12878 Bond
Voters in Johnson County, Kansas are able to use their cell phones to easily locate the polling place that corresponds to their address. Text the “keyword” VOTEKS along with their address to short code 74574. This information is sent through the TextCaster servers and a secure inquiry is made into AIMS’ information Database. TextCaster AIMS
Address information is processed by the AIMS Address Webservice and the location of the Voter Polling Place is returned to the cell phone of person making the inquiry. AIMS TextCaster
It’s also possible to collaborate with an online mapping service to return a link within the text message that, when clicked, will launch a cell phone’s web browser and show the actual location of the polling place. We can even show the address entered by the voter and provide detailed directions to the voter’s polling place!
Highlights • Embedded iframe – development between 2 locations • Use of AJAX on main page • AWS to optimally match addresses • Don’t return multi address at single location • Do return multi address at multi location • Webservice performance – resolve addr & poll location • Maps for point to point driving directions
Hurdles • Routing Points • Lat/lon doesn’t always get you to a street • AIMS addresses more accurate than google/virtual earth