PUBLICSAFETY_FireLadderDistricts

Fire Ladder Districts are areas which represent both Cambridge Ladder companies housed in fire stations and areas which each ladder truck will be dispatched. Each fire station has Engine companies. Some have Ladder companies. Each Ladder District is used by the Emergency Communication Center (ECC) to dispatch emergency vehicles and first responders.

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/publicsafetyfireladderdistricts-34x4-d6nv\".\"publicsafetyfireladderdistricts\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.