MyNorfolk
This dataset provides data from MyNorfolk, a citizen services portal that delegates and tracks requests and questions about the city of Norfolk and the services we provide to our residents, businesses, and visitors. Data for the service requests is collected from phone calls, emails, an app for smart phones and on-line. The portal is managed by the Norfolk Cares Center; its mission is to provide a single point of contact for visitors, residents, businesses and city staff to request a city service, report a concern, seek information about Norfolk, or follow-up on a previous request for service.
**Disclaimer - With the current process in place, not all tickets are closed automatically. There could be tickets shown as open in this dataset that are closed in our other systems. We are working to address the issue.
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 \"norfolk-gov/mynorfolk-nbyu-xjez\".\"mynorfolk\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.