sfproj. every fact links to its evidence

← all projects

2274I_PW_Automated_Photo_Enforcement_System_Upgrade_Contract_2

candidate project Construction d39379f6-a8db-4297-837a-c8b562b4f561

This is an active San Francisco Public Works project (managed by its Electrical division) to install and upgrade Automated Photo Enforcement red light camera systems at six locations across the city, along corridors including Divisadero Street, Franklin Street, and Presidio Avenue. The work adds new camera systems and modifies existing ones to enforce additional approaches at intersections flagged for safety needs. The contractor's base bid came to about $735,000, with an alternate bid of roughly $197,000, below the engineer's estimate of about $1 million. The project is in the construction phase, scheduled to run from late October 2025 through early November 2026.AI-generated

Current record

FieldValueProvenance
agency.owner SF DPW IDC - Electrical reported socrata:btxj-k9uh · retrieved 2026-07-17
“agency_name: SF DPW IDC - Electrical”
contact.email John.Sylvester@sfdpw.org reported socrata:btxj-k9uh · retrieved 2026-07-17
“project_manager_email: John.Sylvester@sfdpw.org”
contact.name John Sylvester reported socrata:btxj-k9uh · retrieved 2026-07-17
“project_manager_name: John Sylvester”
description Project total contractor base bid Cost is $735,425 with (1) alternate bid cost of $197,175 Project Engineer Estimate for base bid and one alternate construction cost was $1,022,278 Total of (6) six sites due to incidents of safety needs and requiring control. Automated Photo Enforcement Systems as New Red Light Camera (RLC) and/or modify (E) systems to add hardware for enforcement of addition approaches. Design-Built typical RLC system has 1 front pole/camera and 1 rear pole/camera approach. W reported socrata:btxj-k9uh · retrieved 2026-07-17
“description: Project total contractor base bid Cost is $735,425 with (1) alternate bid cost of $197,175 Project Engineer Estimate for base bid and one...”
location.geometry 7 geometries reported socrata:btxj-k9uh · retrieved 2026-08-27
“7 published segment geometries”
location.street_limits Divisadero St; Divisadero St from Page St to Oak St; Fell St; Franklin St; Franklin St from Blackstone Ct to Lombard St; Harrison St from 06th St to Harriet St; Presidio Ave from Masonic Ave \ Pine St to Bush St \ Euclid Ave derived socrata:btxj-k9uh · retrieved 2026-07-17
“assembled from segment on/from/to street fields”
name 2274I_PW_Automated_Photo_Enforcement_System_Upgrade_Contract_2 reported socrata:btxj-k9uh · retrieved 2026-07-17
“name: 2274I_PW_Automated_Photo_Enforcement_System_Upgrade_Contract_2”
phase Construction reported socrata:btxj-k9uh · retrieved 2026-07-17
“project_phase: Construction”
project_type Roadway reported socrata:btxj-k9uh · retrieved 2026-07-17
“facility_type: Roadway”
schedule.end 2026-11-02 reported socrata:btxj-k9uh · retrieved 2026-07-17
“end_date: 2026-11-02T00:00:00.000”
schedule.start 2025-10-27 reported socrata:btxj-k9uh · retrieved 2026-07-17
“start_date: 2025-10-27T00:00:00.000”
source.project_id 52829 reported socrata:btxj-k9uh · retrieved 2026-07-17
“dotmapsid: 52829”
status Active reported socrata:btxj-k9uh · retrieved 2026-07-17
“project_status: Active”
summary This is an active San Francisco Public Works project (managed by its Electrical division) to install and upgrade... generated llm:summarize · retrieved 2026-08-11
“generated from 13 resolved fields; input sha256-v2=415ee6cb3524d7649630482e7e1709f2762df49b872268bac716fb7c5bcefa05”

Changes

2026-08-27 field changed immaterial {'type': 'GeometryCollection', 'geometries': [{'type': 'LineString', 'coordinates': [[-122.44661046569048, 37.786302298351416], [-122.44642170930278, 37.78537026470908]]}, {'type': 'Point', 'coordinates': [-122.43742293963572, 37.77313349255008]}, {'type': 'Point', 'coordinates': [-122.445902365921, 37.77299540589092]}, {'type': 'Point', 'coordinates': [-122.42618004414055, 37.80109545532504]}, {'type': 'LineString', 'coordinates': [[-122.43723493165446, 37.77220371243836], [-122.43729783097459, 37.77227428065427], [-122.4374552162731, 37.77304998017973], [-122.4374229396927, 37.77313349266008]]}, {'type': 'LineString', 'coordinates': [[-122.42610916817623, 37.80074122519449], [-122.42618004397153, 37.80109545526293]]}, {'type': 'LineString', 'coordinates': [[-122.40407025683353, 37.77727270250076], [-122.40461003015258, 37.776846234834046]]}]} → {'type': 'GeometryCollection', 'geometries': [{'type': 'LineString', 'coordinates': [[-122.44661047, 37.7863023], [-122.44642171, 37.78537026]]}, {'type': 'Point', 'coordinates': [-122.43742294, 37.77313349]}, {'type': 'Point', 'coordinates': [-122.44590237, 37.77299541]}, {'type': 'Point', 'coordinates': [-122.42618004, 37.80109546]}, {'type': 'LineString', 'coordinates': [[-122.43723493, 37.77220371], [-122.43729783, 37.77227428], [-122.43745522, 37.77304998], [-122.43742294, 37.77313349]]}, {'type': 'LineString', 'coordinates': [[-122.42610917, 37.80074123], [-122.42618004, 37.80109546]]}, {'type': 'LineString', 'coordinates': [[-122.40407026, 37.7772727], [-122.40461003, 37.77684623]]}]}
2026-08-11 field changed immaterial {'type': 'GeometryCollection', 'geometries': [{'type': 'LineString', 'coordinates': [[-122.44661046569048, 37.786302298351416], [-122.44642170930278, 37.78537026470908]]}, {'type': 'Point', 'coordinates': [-122.42208679251306, 37.78082104786609]}, {'type': 'Point', 'coordinates': [-122.43742293963572, 37.77313349255008]}, {'type': 'Point', 'coordinates': [-122.445902365921, 37.77299540589092]}, {'type': 'Point', 'coordinates': [-122.42618004414055, 37.80109545532504]}, {'type': 'LineString', 'coordinates': [[-122.43723493165446, 37.77220371243836], [-122.43729783097459, 37.77227428065427], [-122.4374552162731, 37.77304998017973], [-122.4374229396927, 37.77313349266008]]}, {'type': 'LineString', 'coordinates': [[-122.42610916817623, 37.80074122519449], [-122.42618004397153, 37.80109545526293]]}, {'type': 'LineString', 'coordinates': [[-122.40407025683353, 37.77727270250076], [-122.40461003015258, 37.776846234834046]]}]} → {'type': 'GeometryCollection', 'geometries': [{'type': 'LineString', 'coordinates': [[-122.44661046569048, 37.786302298351416], [-122.44642170930278, 37.78537026470908]]}, {'type': 'Point', 'coordinates': [-122.43742293963572, 37.77313349255008]}, {'type': 'Point', 'coordinates': [-122.445902365921, 37.77299540589092]}, {'type': 'Point', 'coordinates': [-122.42618004414055, 37.80109545532504]}, {'type': 'LineString', 'coordinates': [[-122.43723493165446, 37.77220371243836], [-122.43729783097459, 37.77227428065427], [-122.4374552162731, 37.77304998017973], [-122.4374229396927, 37.77313349266008]]}, {'type': 'LineString', 'coordinates': [[-122.42610916817623, 37.80074122519449], [-122.42618004397153, 37.80109545526293]]}, {'type': 'LineString', 'coordinates': [[-122.40407025683353, 37.77727270250076], [-122.40461003015258, 37.776846234834046]]}]}

Source records

Public Works coordinated projects (DotMaps) key 52829 primary · rule:dotmaps-group-by-dotmapsid dataset page ↗ · this record’s data ↗

Assertion history (latest 100, including superseded)

PredicateValueClassRecordedState
location.geometry 7 geometries reported 2026-08-27 live
summary This is an active San Francisco Public Works project (managed by its Electrical division) to install and upgrade Automated Photo Enforcement red light camera systems at six locations across the city, along corridors including Divisadero Street, Franklin Street, and Presidio Avenue. The work adds new camera systems and modifies existing ones to enforce additional approaches at intersections flagged for safety needs. The contractor's base bid came to about $735,000, with an alternate bid of roughly $197,000, below the engineer's estimate of about $1 million. The project is in the construction phase, scheduled to run from late October 2025 through early November 2026. generated 2026-08-11 live
location.geometry 7 geometries reported 2026-08-11 superseded
summary This project is an upgrade of San Francisco's automated red light camera enforcement systems, managed by the Public Works electrical division. Work covers six sites across the city, including locations along Divisadero, Fell, Franklin, Harrison, and Presidio streets, where new red light cameras will be installed or existing systems modified to add enforcement hardware and cameras for additional approaches. The contract carries a base bid of about $735,000 plus an alternate bid of roughly $197,000, below the engineer's estimate of about $1.02 million. The project is currently in construction, scheduled to run from late October 2025 to early November 2026. generated 2026-07-18 superseded
location.geometry 8 geometries reported 2026-07-17 superseded
location.street_limits Divisadero St; Divisadero St from Page St to Oak St; Fell St; Franklin St; Franklin St from Blackstone Ct to Lombard St; Harrison St from 06th St to Harriet St; Presidio Ave from Masonic Ave \ Pine St to Bush St \ Euclid Ave derived 2026-07-17 live
schedule.end 2026-11-02 reported 2026-07-17 live
schedule.start 2025-10-27 reported 2026-07-17 live
source.project_id 52829 reported 2026-07-17 live
contact.email John.Sylvester@sfdpw.org reported 2026-07-17 live
contact.name John Sylvester reported 2026-07-17 live
agency.owner SF DPW IDC - Electrical reported 2026-07-17 live
project_type Roadway reported 2026-07-17 live
phase Construction reported 2026-07-17 live
status Active reported 2026-07-17 live
description Project total contractor base bid Cost is $735,425 with (1) alternate bid cost of $197,175 Project Engineer Estimate for base bid and one alternate construction cost was $1,022,278 Total of (6) six sites due to incidents of safety needs and requiring control. Automated Photo Enforcement Systems as New Red Light Camera (RLC) and/or modify (E) systems to add hardware for enforcement of addition approaches. Design-Built typical RLC system has 1 front pole/camera and 1 rear pole/camera approach. W reported 2026-07-17 live
name 2274I_PW_Automated_Photo_Enforcement_System_Upgrade_Contract_2 reported 2026-07-17 live