City of Cambridge

Close
Author
Josh Wolff
Description
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)
Category
Public Works
Tags
311, public works, seeclickfix, pothole, snow, streets, vision zero
Rating
Current value: 0 out of 5
Data Provided By
SeeClickFix
Source Link
http://en.seeclickfix.com/cambridge
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

ticket_id
ticket_id
city
city
issue_type
issue_type
ticket_status
ticket_status
issue_description
issue_description
ticket_closed_date_time
ticket_closed_date_time
ticket_created_date_time
ticket_created_date_time
ticket_last_updated_date_time
ticket_last_updated_date_time
address
address
lat
lat
lng
lng
location
location
image
image
cambridge_cdd_zoning
:@computed_region_swkg_bavi
cambridge_neighborhoods
:@computed_region_rffn_qbt6
Police Response Districts
:@computed_region_v7jj_366k
Police Neighborhood Regions
:@computed_region_guic_hr4a
cambridge_zipcodes
:@computed_region_rcj3_ccgu

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.