pa-gov/county-latitude-longitude-points-for-each-county-dvjn-d63b
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 3 years ago
Indexed 1 month ago

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.

 
Preview
  • county_latitude_longitude_points_for_each_county
     
     
     
     
     
Upstream Metadata