County Latitude & Longitude Points For Each County Static
A generic latitude and longitude for each county. These points are provided so a map layer can be developed using files with aggregated data grouped by county name. Use this generic latitude and longitude georeferenced point file and assign any information to the correct county showing on a boundary map layer. If totals are shown in a file for the Commonwealth of Pennsylvania and the desire is to show the total for the state on a map layer, there is a generic latitude and longitude point given for Pennsylvania that will show in the South East corner of the map visual actually landing in the state of Maryland. This is provided for visualizing and displaying the state information on the map layer along with county information.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \ -H "Content-Type: application/json" \ -d@-<<EOF {"sql": " SELECT * FROM \"pa-gov/county-latitude-longitude-points-for-each-county-dvjn-d63b\".\"county_latitude_longitude_points_for_each_county\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.