Department of Public Works Internal & External Projects (via coordinate application)
A. SUMMARY
This dataset contains Public Works coordinated projects with other city agencies and utilities companies. Each row contains project names, phases, status, contacts, and locations. It is replacing the Envista project datasets.
B. HOW THE DATASET IS CREATED
This dataset is extracted from the DotMaps system via API.
C. UPDATE PROCESS
This datasets is refreshed daily, though the underlying data generally updates on a monthly basis.
D. HOW TO USE THIS DATASET
You can use this dataset to map out coordinated projects between Public Works, other city agencies, and utilities companies around the city of San Francisco.
Complete Metadata
| @type | dcat:Dataset |
|---|---|
| accessLevel | public |
| contactPoint |
{
"fn": "San Francisco Public Works",
"@type": "vcard:Contact",
"hasEmail": "mailto:no-reply@data.sfgov.org"
}
|
| description | <strong>A. SUMMARY</strong> This dataset contains Public Works coordinated projects with other city agencies and utilities companies. Each row contains project names, phases, status, contacts, and locations. It is replacing the <u><a href="https://data.sfgov.org/City-Infrastructure/-DEPRECATED-Envista-Projects-for-Utility-Excavatio/sf93-6dmr/about_data">Envista project datasets</a></u>. <strong>B. HOW THE DATASET IS CREATED</strong> This dataset is extracted from the DotMaps system via API. <strong>C. UPDATE PROCESS</strong> This datasets is refreshed daily, though the underlying data generally updates on a monthly basis. <strong>D. HOW TO USE THIS DATASET</strong> You can use this dataset to map out coordinated projects between Public Works, other city agencies, and utilities companies around the city of San Francisco. |
| distribution |
[
{
"@type": "dcat:Distribution",
"mediaType": "application/json",
"describedBy": "https://data.sfgov.org/api/views/btxj-k9uh/columns.json",
"downloadURL": "https://data.sfgov.org/api/views/btxj-k9uh/rows.json?accessType=DOWNLOAD",
"describedByType": "application/json"
},
{
"@type": "dcat:Distribution",
"mediaType": "application/rdf+xml",
"describedBy": "https://data.sfgov.org/api/views/btxj-k9uh/columns.rdf",
"downloadURL": "https://data.sfgov.org/api/views/btxj-k9uh/rows.rdf?accessType=DOWNLOAD",
"describedByType": "application/rdf+xml"
},
{
"@type": "dcat:Distribution",
"mediaType": "application/xml",
"describedBy": "https://data.sfgov.org/api/views/btxj-k9uh/columns.xml",
"downloadURL": "https://data.sfgov.org/api/views/btxj-k9uh/rows.xml?accessType=DOWNLOAD",
"describedByType": "application/xml"
},
{
"@type": "dcat:Distribution",
"mediaType": "text/csv",
"downloadURL": "https://data.sfgov.org/api/views/btxj-k9uh/rows.csv?accessType=DOWNLOAD"
}
]
|
| identifier | https://data.sfgov.org/api/views/btxj-k9uh |
| issued | 2025-06-25 |
| keyword |
[
"construction",
"excavation",
"noi",
"paving",
"utilities",
"utility"
]
|
| landingPage | https://data.sfgov.org/d/btxj-k9uh |
| license | http://opendatacommons.org/licenses/by/1.0/ |
| modified | 2026-02-20 |
| publisher |
{
"name": "data.sfgov.org",
"@type": "org:Organization"
}
|
| theme |
[
"City Infrastructure"
]
|
| title | Department of Public Works Internal & External Projects (via coordinate application) |
