cambridgema-gov/commonwealth-connect-service-requests-2z9k-mv9g
Icon for Socrata external plugin
 
Preview
  • commonwealth_connect_service_requests
     
 
Readme
Updated 8 hours ago
Indexed 1 hour ago

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

NameSocrata field nameColumn name in sgr mountData typeDescription
ticket_statusticket_statusticket_statusTextEach ticket's current status. Closed tickets have been resolved.
Police Neighborhood Regions:@computed_region_guic_hr4a:@computed_region_guic_hr4aNumber
cambridge_neighborhoods:@computed_region_rffn_qbt6:@computed_region_rffn_qbt6Number
latlatlatNumberThe latitude for each ticket.
ticket_closed_date_timeticket_closed_date_timeticket_closed_date_timeCalendar dateThe date and time when each closed ticket was resolved. Not applicable for open tickets.
ticket_created_date_timeticket_created_date_timeticket_created_date_timeCalendar dateThe date and time when each ticket was opened.
ticket_last_updated_date_timeticket_last_updated_date_timeticket_last_updated_date_timeCalendar date
cambridge_cdd_zoning:@computed_region_swkg_bavi:@computed_region_swkg_baviNumber
cambridge_zipcodes:@computed_region_rcj3_ccgu:@computed_region_rcj3_ccguNumber
lnglnglngNumberthe longitude for each ticket.
location (address)location_addresslocation_addressText
location (zip)location_ziplocation_zipText
issue_descriptionissue_descriptionissue_descriptionTextUser submitted description of the issue associated with each ticket.
addressaddressaddressTextThe relevant address for each ticket.
location (state)location_statelocation_stateText
issue_typeissue_typeissue_typeTextThe subject of each SeeClickFix ticket.
imageimageimageTextAn image associated with the ticket. SeeClickFix users have the option of submitting a photo when submitting a ticket.
locationlocationlocationPointThe lat/lon coordinates for each ticket.
citycitycityText
location (city)location_citylocation_cityText
ticket_idticket_idticket_idTextThe unique ID associated with each SeeClickFix ticket
Police Response Districts:@computed_region_v7jj_366k:@computed_region_v7jj_366kNumber
Upstream Metadata