Description:
Since July 2004, the Controller's Office's City Services Auditor (CSA) Division has worked with the Department of Public Works (DPW) to develop maintenance standards for streets and sidewalks and schedules and inspect for compliance. This data file consolidates street and sidewalk inspection results from FY06-07 through March FY09-10.
Agency Name: Controller's Office & Department of Public Works
Date Released: July 30, 2010
Time Period: FY06-07 through FY09-10
Frequency: Month
Location of dataset: http://sfcontroller.org/Modules/ShowDocument.aspx?documentid=950
Format: Excel
Location of Data Dictionary: http://sfcontroller.org/Modules/ShowDocument.aspx?documentid=950
Street and Sidewalk Inspection Results Data FY07 - FY10Q3
Categorized under Public Works Views: 342 (http://sfcontroller.org)Utility Excavation and Paving Five Year Plan
Categorized under Public Works Views: 268 (ftp://bsm.sfdpw.org)
Description:
Utility Excavation and Paving Five Year Plan by location including utility name, project name, start date and project duration.
This data set is for planning purposes only and is subject to change without notice.
Agency Name: Department of Public Works - Bureau of Street-Use & Mapping
Frequency: Daily
Location of dataset: http://bsm.sfdpw.org/datasf/fiveyearplan.txt
Format: CSV
Location of Data Dictionary: N/A
This data set is for planning purposes only and is subject to change without notice.
Agency Name: Department of Public Works - Bureau of Street-Use & Mapping
Frequency: Daily
Location of dataset: http://bsm.sfdpw.org/datasf/fiveyearplan.txt
Format: CSV
Location of Data Dictionary: N/A
List of Blocks Where DPW Has a Tree Maintenance Agreement
Categorized under Public Works Views: 215 (ftp://bsm.sfdpw.org)
Description:
Location and count of trees by block where DPW has a tree maintenance agreement.
Agency Name: Department of Public Works - Bureau of Urban Forestry
Frequency: Daily
Location of dataset: http://bsm.sfdpw.org/datasf/sfdpw_maintained_trees.txt
Format: CSV
Location of Data Dictionary: N/A
Agency Name: Department of Public Works - Bureau of Urban Forestry
Frequency: Daily
Location of dataset: http://bsm.sfdpw.org/datasf/sfdpw_maintained_trees.txt
Format: CSV
Location of Data Dictionary: N/A
Paving PCI Scores
Categorized under Public Works Views: 356 (ftp://bsm.sfdpw.org)
Description:
Pavement Condition Index Rating Scores by location
Agency Name: Department of Public Works - Bureau of Engineering
Frequency: Daily
Location of dataset: http://bsm.sfdpw.org/datasf/paving_pciscores.txt
Format: CSV
Location of Data Dictionary: N/A
Agency Name: Department of Public Works - Bureau of Engineering
Frequency: Daily
Location of dataset: http://bsm.sfdpw.org/datasf/paving_pciscores.txt
Format: CSV
Location of Data Dictionary: N/A
Curb Ramps
Categorized under Public Works Views: 221 (ftp://bsm.sfdpw.org)
Description:
Location of Curb Ramps with California State Plane III coordinates
Agency Name: Department of Public Works - Bureau of Engineering
Frequency: Daily
Location of dataset: http://bsm.sfdpw.org/datasf/curbramps.txt
Format: CSV
Location of Data Dictionary: N/A
Agency Name: Department of Public Works - Bureau of Engineering
Frequency: Daily
Location of dataset: http://bsm.sfdpw.org/datasf/curbramps.txt
Format: CSV
Location of Data Dictionary: N/A
SFPUC Construction Bid Opportunities
Categorized under Public Works Views: 231 (http://sfwater.org)
Description:
The San Francisco Public Utilities Commission (SFPUC) is undertaking a major water system improvement program to repair and improve the Hetch Hetchy water delivery system. The SFPUC will let construction contracts valuing $2.3 billion, between now and 2013.
Agency Name: San Francisco Public Utilities Commission
Date Released: Periodic
Time Period: 2007-Current
Frequency: Periodic
Location of dataset: http://sfwater.org/detail.cfm/MC_ID/15/MSC_ID/150/C_ID/4210
Agency Name: San Francisco Public Utilities Commission
Date Released: Periodic
Time Period: 2007-Current
Frequency: Periodic
Location of dataset: http://sfwater.org/detail.cfm/MC_ID/15/MSC_ID/150/C_ID/4210
SFPUC Design Build Agreements
Categorized under Public Works Views: 208 (http://sfwater.org)
Description:
Posting for Design Build Agreements contracting opportunities
Agency Name: San Francisco Public Utilities Commission
Time Period: 2008-Current
Frequency: Periodic
Location of dataset: http://sfwater.org/custom/bid/planlist.cfm/bidtype/3/MC_ID/15/MSC_ID/157
Agency Name: San Francisco Public Utilities Commission
Time Period: 2008-Current
Frequency: Periodic
Location of dataset: http://sfwater.org/custom/bid/planlist.cfm/bidtype/3/MC_ID/15/MSC_ID/157
Street Sweeper Schedule and Route
Categorized under Public Works Views: 6241 (http://apps.sfgov.org)
Description:
Street sweeper schedule that includes: when and where.
Agency Name: Department of Public Works
Date Released: Periodically
Frequency: Feed is published daily but changes to the data occur on average a few a month.
Location of dataset: http://apps.sfgov.org/datafiles/index.php?dir=PublicWorks
Format: KML, Shape file
Location of Data Dictionary: http://apps.sfgov.org/datafiles/index.php?dir=PublicWorks
Agency Name: Department of Public Works
Date Released: Periodically
Frequency: Feed is published daily but changes to the data occur on average a few a month.
Location of dataset: http://apps.sfgov.org/datafiles/index.php?dir=PublicWorks
Format: KML, Shape file
Location of Data Dictionary: http://apps.sfgov.org/datafiles/index.php?dir=PublicWorks
311 Requests - Volunteer Request
Categorized under Public Works Views: 169 (Editorial)
Description:
KML/shapefile
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
311 Requests - Tree Maintenance or Damage
Categorized under Public Works Views: 163 (Editorial)
Description:
KML/shapefile
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
311 Requests - Street Defect
Categorized under Public Works Views: 176 (Editorial)
Description:
KML/shapefile
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
311 Requests - Sidewalk and Curb Issues
Categorized under Public Works Views: 166 (Editorial)
Description:
KML/shapefile
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
311 Requests - Sewer Issues
Categorized under Public Works Views: 179 (Editorial)
Description:
KML/shapefile
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
311 Requests - Request for City Services
Categorized under Public Works Views: 169 (Editorial)
Description:
KML/shapefile
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
311 Requests - Blocked Street or Sidewalk
Categorized under Public Works Views: 202 (Editorial)
Description:
KML/shapefile
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-prior day
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-prior day
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
311 Requests - Catch Basin Maintenance
Categorized under Public Works Views: 193 (Editorial)
Description:
KML/shapefile
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
311 Requests - Damaged Property
Categorized under Public Works Views: 190 (Editorial)
Description:
KML/shapefile
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
311 Requests - Graffiti Complaint Public Property
Categorized under Public Works Views: 227 (Editorial)
Description:
KML/shapefile
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
311 Requests - Graffiti Complaint Private Property
Categorized under Public Works Views: 224 (Editorial)
Description:
KML/shapefile
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
311 Requests - Illegal Postings
Categorized under Public Works Views: 215 (Editorial)
Description:
KML/shapefile
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
Web service
Agency Name: Department of Public Works
Time Period: 2/15/07-yesterday
Frequency: Daily
Location of dataset: See description
Format: KML, shapefile, RESTful web service
Location of Data Dictionary: KML/shapefile Web service
Additional Details: These are public requests that may or may not result in a work order, or result in a work order under a different classification.
DataSF is a clearinghouse of datasets available from the City & County of San Francisco. Our goal in releasing this site is:
(1) improve access to data
(2) help our community create innovative apps
(3) understand what datasets you'd like to see
(4) get feedback on the quality of our datasets.
(1) improve access to data
(2) help our community create innovative apps
(3) understand what datasets you'd like to see
(4) get feedback on the quality of our datasets.
Sort Datasets
