Transcript Polling Locator - AIMS

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
• Kept everything web service based
since multiple interfaces needs
access (phone, web)
Process
Process
Process
Process
• Use poll locator webservice w/
address apid to get poll information
Process
Process
Process
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).
1 record per election
> Aug 5 ’08 Primary
> Nov 4 ’08 General
elcElection
ELID (PK)
Status
Description
Start
Finish
1 record per polling place
Hope Alive Christian Center
Blue Valley HS
PollingPlace_PT
elcPollingPlace
1 record per precinct
N616 (OP Ward 6, Precinct 16)
I406 (Lenexa Ward 4, Precinct 6)
PPID (PK)
Status
Description
APID (FK)
Address, City, State, Zip
spX, spY, Longitude, Latitude
VotingPrecinct_PL
Precinct (PK)
PrecinctName
KSSenateDistrict
KSRepresentativeDistrict
KSBOEDistrict
BOCCDistrict
elcElectionPollingPlacePrecinct
ELID (PK)
PPID (PK)
Precinct (PK)
Status
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
elcElection
ELID (PK)
Status
Description
Start
Finish
PollingPlace_PT
elcPollingPlace
VotingPrecinct_PL
PPID (PK)
Status
Description
APID (FK)
Address, City, State, Zip
spX, spY, Longitude, Latitude
Precinct (PK)
PrecinctName
KSSenateDistrict
KSRepresentativeDistrict
KSBOEDistrict
BOCCDistrict
elcElectionPollingPlacePrecinct
ELID (PK)
PPID (PK)
Precinct (PK)
Status
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
PollingPlace_PT_vw1
PollingPlace_PT-elcElectionPollingPlacePrecinctVotingPrecinct_PL
PPID …
Precinct …
Provides precinct(s) for every
polling place (coincident points)
VotingPrecinct_PL_vw5
VotingPrecinct_PL-elcElectionPollingPlacePrecinct
elcPollingPlace
Precinct …
PPID …
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
Browser Access
…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