Commonwealth Connect Service Requests
Commonwealth Connect Service Requests
Non-emergency service requests submitted through Cambridge's Commonwealth Connect application powered by SeeClickFix Open311.
Please note that the City of Cambridge uses Commonwealth Connect to track both public and internal work orders. Occasionally, a ticket will change from internal to public, or vice-versa. All tickets that originated as public requests are included in this dataset. However, technical constraints prevent us from displaying information for tickets that originated as internal work orders.
Prior to using Commonwealth Connect, the City utilized iReport. Three open datasets derive from historical iReport data:
-Pothole Repair Requests (https://data.cambridgema.gov/Public-Works/Pothole-Repair-Requests/h2y4-rf5c)
-Graffiti Cleanup Requests (https://data.cambridgema.gov/Public-Works/Graffiti-Clean-Up-Requests/hk2d-8z9b)
-Unshoveled/Icy Sidewalk Complaints (https://data.cambridgema.gov/Public-Works/Unshoveled-Icy-Sidewalk-Complaints/72bt-ct3c)
-Snow/Ice Sidewalk Ordinance Violations (https://data.cambridgema.gov/Public-Works/Snow-Ice-Sidewalk-Ordinance-Violations/q8b2-58ab)
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| issue_type | issue_type | issue_type | Text | The subject of each SeeClickFix ticket. |
| location | location | location | Point | The lat/lon coordinates for each ticket. |
| lng | lng | lng | Number | the longitude for each ticket. |
| ticket_created_date_time | ticket_created_date_time | ticket_created_date_time | Calendar date | The date and time when each ticket was opened. |
| lat | lat | lat | Number | The latitude for each ticket. |
| issue_description | issue_description | issue_description | Text | User submitted description of the issue associated with each ticket. |
| ticket_status | ticket_status | ticket_status | Text | Each ticket's current status. Closed tickets have been resolved. |
| cambridge_cdd_zoning | :@computed_region_swkg_bavi | :@computed_region_swkg_bavi | Number | |
| Police Response Districts | :@computed_region_v7jj_366k | :@computed_region_v7jj_366k | Number | |
| cambridge_zipcodes | :@computed_region_rcj3_ccgu | :@computed_region_rcj3_ccgu | Number | |
| cambridge_neighborhoods | :@computed_region_rffn_qbt6 | :@computed_region_rffn_qbt6 | Number | |
| Police Neighborhood Regions | :@computed_region_guic_hr4a | :@computed_region_guic_hr4a | Number | |
| location (zip) | location_zip | location_zip | Text | |
| location (address) | location_address | location_address | Text | |
| location (city) | location_city | location_city | Text | |
| city | city | city | Text | |
| image | image | image | Text | An image associated with the ticket. SeeClickFix users have the option of submitting a photo when submitting a ticket. |
| address | address | address | Text | The relevant address for each ticket. |
| ticket_last_updated_date_time | ticket_last_updated_date_time | ticket_last_updated_date_time | Calendar date | |
| location (state) | location_state | location_state | Text | |
| ticket_id | ticket_id | ticket_id | Text | The unique ID associated with each SeeClickFix ticket |
| ticket_closed_date_time | ticket_closed_date_time | ticket_closed_date_time | Calendar date | The date and time when each closed ticket was resolved. Not applicable for open tickets. |