311 Service Requests for Fiscal Year 2020 - 2021 Obstruction

There are over 400 service requests types that are reported in the 311 system that affect the quality of life of our citizens, neighborhoods, and communities. The most popular service requests include but are not limited to animal services requests, high weeds, junk motor vehicles, and a number of other code compliance-related issues. Requests regarding streets and mobility (such as street and pot hole repair) are also common as well as requests to address environmental issues such as water conservation and air quality concerns.

This dataset represents all Service Requests related to obstruction City code compliance violations for the fiscal year time period of October 1, 2020 to September 30, 2021.

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 \"dallasopendata/311-service-requests-for-fiscal-year-2020-2021-ujvd-bzsr\".\"311_service_requests_for_fiscal_year_2020_2021\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.