As of October 30, 2019, this data set will no longer be updated. A new citizen request app, called MyNorfolk, has been implemented and data from that app is available in this Open Data portal. The Norfolk Cares data set provides data from the IMPACT System. The data was collected by phone calls, emails, iPhone requests, and on-line requests. This data set includes service requests from November 2014 to October 2019.
This dataset has the following 16 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
REQUEST ID | ticket_id | number | Ticket Identification Number | 475040 461061 561877 547833 548247 view top 100 |
REQUEST ADDRESS | street_address | text | Request Address | 222 E MAIN STREET 810 UNION STREET 401 MONTICELLO AVENUE 1176 PINERIDGE ROAD 9647 STURGIS STREET view top 100 |
STATUS CODE | status_code | text | Detailed Status Information | CLOSED E-MAILED COMPLETED WITH OPEN VIOLATIONS LOGGED COMPLETED view top 100 |
ACTION DEPARTMENT | secondary_issue_type | text | Secondary Issue Type | WASTE MANAGEMENT NEIGHBORHOOD QUALITY & CODE COMPLIANCE STREETS & BRIDGES RIGHT OF WAY RECYCLING view top 100 |
REQUEST CATEGORY | issue_type | text | Issue Type | WASTE MANAGEMENT NEIGHBORHOOD QUALITY TRANSPORTATION RIGHT OF WAY ISSUES PUBLIC SAFETY view top 100 |
REQUEST STATUS | ticket_status | text | The status of the ticket | CLOSED OPEN view top 100 |
REQUEST DATE | ticket_created_date_time | calendar_date | Date and Time ticket was created | 2017-04-10T00:00:00.000 2018-07-13T00:00:00.000 2018-07-12T00:00:00.000 2017-07-17T00:00:00.000 2018-10-19T00:00:00.000 view top 100 |
STATUS DATE | ticket_closed_date_time | calendar_date | Date and Time ticket was closed | 2019-01-11T00:00:00.000 2017-06-23T00:00:00.000 2018-08-08T00:00:00.000 2018-03-30T00:00:00.000 2018-03-14T00:00:00.000 view top 100 |
CALL TYPE | issue_description | text | Issue Description | MISSED REGULAR TRASH TALL WEEDS AND GRASS MISSED YARD WASTE PICK UP (APOTH) POTHOLE REPAIR MISSED RECYCLING view top 100 |
DEPARTMENT TRACKING NUMBER | dept_tracking_num | text | Hansen and Navaline work order numbers | 462233 460323 438254 460230 438816 view top 100 |
CIVIC LEAGUE | neighborhood_district | text | Non-profit Neighborhood organizations | FAIRMOUNT PARK DOWNTOWN NORFOLK CIVIC LEAGUE BAYVIEW PARK PLACE NORTHSIDE view top 100 |
CENSUS TRACT NUMBER | census_tract_num | number | Census Tract Number | 32 49 61 29 56.01 view top 100 |
PLANNING DISTRICT NUMBER | planning_dist_num | number | Planning District Number | 51 59 52 15 37 view top 100 |
PLANNING DISTRICT NAME | planning_district | text | Planning District Name | LAYFAYETTE DOWNTOWN PARK PLACE NORTH CHESAPEAKE BLVD. EDGEWATER - LARCHMONT view top 100 |
NEIGHBORHOOD DISTRICT SERVICE AREA | neighborhood_district_secondary | text | Neighborhood District Service Area | 5 3 NDSA 5 2 NDSA 3 view top 100 |
LOCATION | location | text | XY coordinate location of the request | (36.8460320308352, -76.2910515321056) (36.851485, -76.28924) (36.8445794768555, -76.2857198637827) (36.8511842692034, -76.2890930441767) (36.8622895540406, -76.2282659949696) view top 100 |