SF311 - Dogpatch CBD

data.sfgov.org | Last Updated 6 Sep 2019

SF311 cases created since 7/1/2008 with location information. For more information about Open311, see http://www.open311.org/.

Tags: 311, case, cases, customer service, calls

This dataset has the following 19 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
CaseIDservice_request_idnumberThe unique ID of the service request created.
Openedrequested_datetimecalendar_dateThe date and time when the service request was made
Closedclosed_datecalendar_dateThe date and time when the service request was closed
Updatedupdated_datetimecalendar_dateThe date and time when the service request was last modified. For requests with status=closed, this will be the date the request was closed
Statusstatus_descriptiontextA single-word indicator of the current state of the service request. (Note: GeoReport V2 only permits ‘open’ and ‘closed’)
Status Notesstatus_notestextExplanation of why status was changed to current state or more details on current status than conveyed with status alone
Responsible Agencyagency_responsibletextThe agency responsible for fulfilling or otherwise addressing the service request.
Categoryservice_nametextThe human readable name of the service request type
Request Typeservice_subtypetextThe human readable name of the service request subtype
Request Detailsservice_detailstextThe human readable name of the service request details
AddressaddresstextHuman readable address or description of location
Supervisor Districtsupervisor_districtnumberSan Francisco Supervisor District as defined in 'Supervisor Districts as of April 2012'
Neighborhoodneighborhoods_sffind_boundariestextSan Francisco Neighborhood as defined in 'SF Find Neighborhoods'
Police Districtpolice_districttextSan Francisco Police District as defined in 'Current Police Districts'
LatitudelatnumberLatitude of the location, using the WGS84 projection
LongitudelongnumberLongitude of the location, using the WGS84 projection
PointpointlocationCombination of Latitude and Longitude for Socrata native maps
SourcesourcetextMechanism or path by which the service request was received; typically ‘Phone’, ‘Text/SMS’, ‘Website’, ‘Mobile App’, ‘Twitter’, etc but terms may vary by system.
Media URLmedia_urlurlA URL to media associated with the request, e.g. an image.