Building and Safety Customer Service Request (Closed)

A Customer Service Request is a request received by the Department of Building and Safety from the City's constituents to investigate a site/property for a possible violation of the City's building, electrical, mechanical and zoning regulations, which are elements of the Los Angeles Municipal Code. Any investigative action taken by a Building and Safety inspector constitutes the opening of a case. Where no Code violation is found, the case is immediately closed. If a Code violation is found, the case remains open until the site/property satisfies the requirements for Code compliance.

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 \"lacity/building-and-safety-customer-service-request-8qjh-sbs9\".\"building_and_safety_customer_service_request\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.