Skip to main content
Chat
Public data · San Francisco

Ask a question about San Francisco city finances.

Answers draw only on the public data behind this site.

Examples

AI-generated answers based on public data. Check the cited sources.

Proof of conceptWork in progress.
Qipu
HomeThe cityPlacesBudgetPayeesContractsPayroll
Qipu
HomeThe cityPlacesBudgetPayeesContractsPayroll
← San Francisco · Contracts

SF Pipelines NO.2 Replace

RANGER PIPELINES INC · PUC Public Utilities Commsn

Register title: “PUC SF PIPELINES NO.2 REPLACE”

Signed by Public Utilities Commsn

Agreed
$29.1M
Paid
$31.6M
more than the recorded base
Remaining (calculated)
$0
Type
Construction — change orders (unilateral)
The money
Paid against the agreed amount

$31.6M paid · $2.6M more than the recorded base amount · Agreed $29.1M

Payments per fiscal year
19202122
Largest year: $25.9M

These bars total $32.8M; the figure above is $31.6M. The first comes from the City’s payment ledger, the second from the contract register’s own paid column. They match on ordinary contracts and drift apart on multi-phase projects, where the work runs through several purchase orders and the ledger counts all of them.

Payment detail begins FY2018 ⓘ
The deal
Contract term
March 11, 2019April 13, 2021
Term ended
Recorded purchasing authority
Purchasing authority, verbatim
CONSTRUCTION SERVICES

See every contract awarded under Competitive bid →

Project team
SupplierRoleAttached $
RANGER PIPELINES INCPrime—
Michael O'Shaughnessy Construction IncSubcontractor$2.7M
MARINA LANDSCAPE, INC.Subcontractor$762,392
MASON PAINTINGSubcontractor$698,859
LEFEVRE WELDINGLBESubcontractor$328,252
BLOCKA CONSTRUCTION INCSubcontractor$296,486
ROADWAY CONSTRUCTION INCLBESubcontractor$268,249
EXARO TECHNOLOGIES CORPLBESubcontractor$264,719
+ 9 more on the team
CRANA TRUCKINGLBESubcontractor$218,835
CMC TRAFFIC CONTROL SPECIALISTS LLCLBESubcontractor$109,417
PERFORMANCE ABATEMENT SERVICES, INC.Subcontractor$109,417
PITCHER DRILLING COSubcontractor$109,417
MUNICON CONSULTANTSSubcontractor$95,299
MISSION CITY REBAR INC.LBESubcontractor$77,651
APEX TESTING LABORATORIES INCLBESubcontractor$56,473
CELL-CRETE CORPORATIONSubcontractor$56,473
COMPASS ENGINEERING CONTRACTORS, INC.Subcontractor$56,473

Attached amounts for subcontractors and JV members live inside the prime's envelope — they are context, never additive with the contract's own amounts.

Sources
Dataset
Supplier Contracts
This contract in the source
Raw rows (JSON, data.sfgov.org)
Qipu.

Public money, made legible. Independent, open source.

Paris·Marseille·San Francisco·Recife

San Francisco

  • The city
  • Places
  • Budget
  • Payees
  • Contracts
  • Payroll

The project

  • Sources
  • For cities
  • Contact

Legal & data

  • License
  • Report an error
© 2026 Qipu · Data: City & County of San Francisco (DataSF)