cambridgema-gov/commonwealth-connect-service-requests-2z9k-mv9g
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 day ago
Indexed 4 hours ago

Commonwealth Connect Service Requests

Non-emergency service requests submitted through Cambridge's Commonwealth Connect application powered by SeeClickFix Open311.

Please note that the City of Cambridge uses Commonwealth Connect to track both public and internal work orders. Occasionally, a ticket will change from internal to public, or vice-versa. All tickets that originated as public requests are included in this dataset. However, technical constraints prevent us from displaying information for tickets that originated as internal work orders.

Prior to using Commonwealth Connect, the City utilized iReport. Three open datasets derive from historical iReport data:

-Pothole Repair Requests (https://data.cambridgema.gov/Public-Works/Pothole-Repair-Requests/h2y4-rf5c)

-Graffiti Cleanup Requests (https://data.cambridgema.gov/Public-Works/Graffiti-Clean-Up-Requests/hk2d-8z9b)

-Unshoveled/Icy Sidewalk Complaints (https://data.cambridgema.gov/Public-Works/Unshoveled-Icy-Sidewalk-Complaints/72bt-ct3c)

-Snow/Ice Sidewalk Ordinance Violations (https://data.cambridgema.gov/Public-Works/Snow-Ice-Sidewalk-Ordinance-Violations/q8b2-58ab)

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 \"cambridgema-gov/commonwealth-connect-service-requests-2z9k-mv9g\".\"commonwealth_connect_service_requests\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • commonwealth_connect_service_requests
     
     
     
     
     
Upstream Metadata