citydata-mesaaz-gov/streetlight-fixtures-jrtd-htue
Icon for Socrata external plugin
 
Readme
Updated 9 hours ago
Indexed 6 hours ago

Streetlight Fixtures

This feature class identifies all streetlight fixtures within the boundary of the City of Mesa, including portions of other bordering agencies. A streetlight fixture includes the lamp, pole, and photocell, if present. Data are stored as a point geometry type feature class in the City Enterprise Geodatabase. The projected coordinate system is NAD 1983 State Plane Arizona Central FIPS 0202 Feet.

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 \"citydata-mesaaz-gov/streetlight-fixtures-jrtd-htue\".\"streetlight_fixtures\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • streetlight_fixtures
     
Upstream Metadata