Import ISO
No additional information has been provided for this dataset.
Between for ranges (e.g., 10,100)Regex for pattern matchingCase sensitive for exact matches
| ID | Feature ID | Geometry Type | ACCEPTED | ACTIVE | ADDRANGE | ARROW DIR | ASSET ID | ASSET NAME | ASSET NAME 1 | BAPA | BOOM TRUCK | CANCEL | CLEARANCE PERMIT | CNN | CNN 1 | COMBOKEY | CONDITION | CORNER SIDE FACING | CREATED DATE | CREATED USER | CURLYIDS | ETL | FROM ST | FROM ST 1 | GISOBJID | GLOBALID UDFCHAR44 | GPS LATITUDE | GPS LONGITUDE | INTERSECTION | INTERSECTION 1 | LAST EDITED DATE | LAST EDITED USER | LEGEND | LIMITS | LOCATION TRACK ID | LOC SPEC | NEW PURPOSE | NEW SIGN CODE | NEW SIGN LEGEND | NEW SIGN SIZE | NUM OF ASSETS | OBJECTID 1 | ORIG INSTALL DATE | POINT X | POINT Y | PURPOSE | REPLACEMENT DATE | RETIREMENT DATE | SF SUP DISTRICT | SHEETING | SIGN CATEGORY | SIGN CLASS | SIGN CODE | SIGN SIZE | SIGN SUPERVISOR | SIGN SUPPORT | STATUS CODE | STATUS DATE | STREETNAME | STREET ADDRESS RANGE | STREET ADDRESS RANGE 1 | STREET BLOCK | STREET VIEW | TO ST | TO ST 1 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100051 | N/A | Point | - | - | - | - | S112704 | ULLOA ST: 15TH AVE | - | T | F | - | F | 22955000 | 22955000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 15TH AVE | ULLOA ST | 9128 | 9128 | 37.74138311 | -122.47122594 | ULLOA ST \ 15TH AVE | 15TH AVE \ ULLOA ST | 1721826984000 | middleware_editor | BIKE (SYM) LANE | ULLOA ST intersection | - | - | - | - | - | - | - | 117318 | 959904000000 | -122.47122594 | 37.74138311 | - | 1721742300000 | - | D7 | - | BIKE REG | REG | R81(CA).0002 | 24X18 | SUP2 | MUNI POLE | IS | 1373571540000 | 15TH AVE | - | - | - | - | - | - |
| 100052 | N/A | Point | 1 | 1 | 1 - 99 | - | S288102 | 1-99 STONEYBROOK AVE | 1-99 STONEYBROOK AVE | F | F | - | F | 12235000 | 12235000 | - | - | WEST SIDE | - | - | - | - | CAMBRIDGE ST \ TRUMBULL ST | CAMBRIDGE ST \ TRUMBULL ST | 102542 | 102542 | 37.73012166 | -122.42193541 | - | - | 1710539427000 | MTA | NPRK 11AM-1PM WED STCL | CAMBRIDGE ST \ TRUMBULL ST to GLADSTONE DR (1 - 99) | - | #2 SPL. | - | - | - | - | - | 117319 | - | -122.42193541 | 37.73012166 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0030 | 18X18 | SUP2 | 2IN IRON POST | IS | 1678891140000 | STONEYBROOK AVE | 1 - 99 STONEYBROOK AVE | 1 - 99 STONEYBROOK AVE | 1 STONEYBROOK AVE | - | GLADSTONE DR | GLADSTONE DR |
| 100053 | N/A | Point | 1 | 1 | 1 - 99 | - | S211368 | 1-99 STONEYFORD AVE | 1-99 STONEYFORD AVE | F | F | - | F | 12236000 | 12236000 | - | - | EAST SIDE | - | - | - | - | CAMBRIDGE ST | CAMBRIDGE ST | 54235 | 54235 | 37.73028937 | -122.42107871 | - | - | 1710539427000 | MTA | NPRK 11AM-1PM WED STCL | CAMBRIDGE ST to GLADSTONE DR (1 - 99) | - | IFO#7 | - | - | - | - | - | 117320 | 304905600000 | -122.42107871 | 37.73028937 | - | 1418169600000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0030 | 18X18 | SUP2 | 2IN IRON POST | IS | 1417685040000 | STONEYFORD AVE | 1 - 99 STONEYFORD AVE | 1 - 99 STONEYFORD AVE | 1 STONEYFORD AVE | - | GLADSTONE DR | GLADSTONE DR |
| 100054 | N/A | Point | - | - | - | - | S230934 | ULLOA ST: 15TH AVE | - | F | F | - | F | 22955000 | 22955000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 15TH AVE | ULLOA ST | 64481 | 64481 | 37.74138311 | -122.47122594 | ULLOA ST \ 15TH AVE | 15TH AVE \ ULLOA ST | 1718911106000 | middleware_editor | ALL WAY | ULLOA ST intersection | - | - | - | - | - | - | - | 117321 | 1484138700000 | -122.47122594 | 37.74138311 | - | 1508889600000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479131400000 | 15TH AVE | - | - | - | - | - | - |
| 100055 | N/A | Point | - | - | - | - | S102006 | TREAT AVE: 20TH ST | - | F | F | - | F | 24036000 | 24036000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 20TH ST | 20TH ST | 7177 | 7177 | 37.7589618 | -122.41359975 | TREAT AVE \ 20TH ST | TREAT AVE \ 20TH ST | 1719364025000 | middleware_editor | STOP | 20TH ST intersection | - | 0 / 00 | - | - | - | - | - | 117322 | -394416000000 | -122.41359975 | 37.7589618 | - | - | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568180000 | TREAT AVE | - | - | - | - | - | - |
| 100056 | N/A | Point | - | - | - | - | S230935 | ULLOA ST: 15TH AVE | - | F | F | - | F | 22955000 | 22955000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 15TH AVE | ULLOA ST | 64482 | 64482 | 37.74138311 | -122.47122594 | ULLOA ST \ 15TH AVE | 15TH AVE \ ULLOA ST | 1718911100000 | middleware_editor | ALL WAY | ULLOA ST intersection | - | - | - | - | - | - | - | 117323 | 1484148120000 | -122.47122594 | 37.74138311 | - | 1484092800000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479131580000 | 15TH AVE | - | - | - | - | - | - |
| 100057 | N/A | Point | - | - | - | - | S112709 | ULLOA ST: 15TH AVE | - | T | F | - | F | 22955000 | 22955000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 15TH AVE | ULLOA ST | 9133 | 9133 | 37.74138311 | -122.47122594 | ULLOA ST \ 15TH AVE | 15TH AVE \ ULLOA ST | 1721826996000 | middleware_editor | END | ULLOA ST intersection | - | - | - | - | - | - | - | 117324 | 959904000000 | -122.47122594 | 37.74138311 | - | 1721737800000 | - | D7 | - | OTHER REGULATORY | REG | R81B(CA).0001 | 08X05 | SUP2 | MUNI POLE | IS | 1373571540000 | 15TH AVE | - | - | - | - | - | - |
| 100058 | N/A | Point | 1 | 1 | 124 - 199 | - | S134083 | 124-199 EUCALYPTUS DR | 124-199 EUCALYPTUS DR | F | F | - | T | 5268000 | 5268000 | - | - | NORTH SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | GLADIOLUS LN | GLADIOLUS LN | 23635 | 23635 | 37.7310823 | -122.47378838 | - | - | 1710539427000 | MTA | ALL WAY | GLADIOLUS LN to 19TH AVE (124 - 199) | - | AT TRAIN TRACKS 30 FT EAST OF 19TH AVE | - | - | - | - | - | 117325 | 1300752000000 | -122.47378838 | 37.7310823 | - | 1658793600000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373578200000 | EUCALYPTUS DR | 124 - 199 EUCALYPTUS DR | 124 - 199 EUCALYPTUS DR | 124 EUCALYPTUS DR | - | 19TH AVE | 19TH AVE |
| 100059 | N/A | Point | 1 | 1 | 124 - 199 | - | S283566 | 124-199 EUCALYPTUS DR | 124-199 EUCALYPTUS DR | F | F | - | T | 5268000 | 5268000 | - | - | SOUTH SIDE, NORTHBOUND TRAFFIC | - | - | - | - | GLADIOLUS LN | GLADIOLUS LN | 95223 | 95223 | 37.7310823 | -122.47378838 | - | - | 1710539427000 | MTA | STOP | GLADIOLUS LN to 19TH AVE (124 - 199) | - | 30 FT EAST OF 19TH AVE AT TRAIN TRACKS | - | - | - | - | - | 117326 | - | -122.47378838 | 37.7310823 | - | 1658793600000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1655462220000 | EUCALYPTUS DR | 124 - 199 EUCALYPTUS DR | 124 - 199 EUCALYPTUS DR | 124 EUCALYPTUS DR | - | 19TH AVE | 19TH AVE |
| 100060 | N/A | Point | 1 | 1 | 124 - 199 | - | S149297 | 124-199 EUCALYPTUS DR | 124-199 EUCALYPTUS DR | F | F | - | F | 5268000 | 5268000 | - | - | SOUTH SIDE | - | - | - | - | GLADIOLUS LN | GLADIOLUS LN | 36510 | 36510 | 37.7310823 | -122.47378838 | - | - | 1749504299000 | middleware_editor | NPRK 8AM-10AM 2ND & 4TH THUR OF MONTH STCL | GLADIOLUS LN to 19TH AVE (124 - 199) | - | EPL 185 EUCALYPTUS DR | - | - | - | - | - | 117327 | 1225436400000 | -122.47378838 | 37.7310823 | - | 1749492900000 | - | D7 | - | STREET CLEANING | REG | R30B(CA).0256 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375729260000 | EUCALYPTUS DR | 124 - 199 EUCALYPTUS DR | 124 - 199 EUCALYPTUS DR | 124 EUCALYPTUS DR | - | 19TH AVE | 19TH AVE |
| 100061 | N/A | Point | 1 | 1 | 124 - 199 | - | S283565 | 124-199 EUCALYPTUS DR | 124-199 EUCALYPTUS DR | F | F | - | T | 5268000 | 5268000 | - | - | NORTH SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | GLADIOLUS LN | GLADIOLUS LN | 95222 | 95222 | 37.7310823 | -122.47378838 | - | - | 1710539427000 | MTA | STOP | GLADIOLUS LN to 19TH AVE (124 - 199) | - | AT TRAIN TRACKS 30 FT EAST OF 19TH AVE | - | - | - | - | - | 117328 | 1300752000000 | -122.47378838 | 37.7310823 | - | 1658793600000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1655461860000 | EUCALYPTUS DR | 124 - 199 EUCALYPTUS DR | 124 - 199 EUCALYPTUS DR | 124 EUCALYPTUS DR | - | 19TH AVE | 19TH AVE |
| 100062 | N/A | Point | 1 | 1 | 100 - 123 | - | S132364 | 100-123 EUCALYPTUS DR | 100-123 EUCALYPTUS DR | F | F | - | F | 5267000 | 5267000 | - | - | NORTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | JUNIPERO SERRA BLVD | JUNIPERO SERRA BLVD | 26299 | 26299 | 37.73106439 | -122.47242441 | - | - | 1710539427000 | MTA | NO U TURN (SYM) | JUNIPERO SERRA BLVD to GLADIOLUS LN (100 - 123) | - | AT MUNI M-LINE CROSSING BETWEEN JUN..... | - | - | - | - | - | 117329 | 1274227200000 | -122.47242441 | 37.73106439 | - | - | - | D7 | - | OTHER REGULATORY | REG | R3-4.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373577660000 | EUCALYPTUS DR | 100 - 123 EUCALYPTUS DR | 100 - 123 EUCALYPTUS DR | 100 EUCALYPTUS DR | - | GLADIOLUS LN | GLADIOLUS LN |
| 100063 | N/A | Point | 1 | 1 | 0 - 0 | - | S226606 | PNDG JUNIPERO SERRA BLVD | 0-0 JUNIPERO SERRA BLVD | F | F | - | F | 12955000 | 12955000 | - | - | EAST SIDE | - | - | - | - | OCEAN AVE | OCEAN AVE | 66011 | 66011 | 37.73113287 | -122.47214626 | - | - | 1710539427000 | MTA | TANSAT | OCEAN AVE to EUCALYPTUS DR (0 - 0) -- WEST -- | - | IFO STEPS TO #175 | - | - | - | - | - | 117330 | 1466164020000 | -122.47214626 | 37.73113287 | - | 1466121600000 | - | D7 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP2 | 2 POST ALUMINUM | IS | 1465909320000 | JUNIPERO SERRA BLVD | PNDG JUNIPERO SERRA BLVD | 0 - 0 JUNIPERO SERRA BLVD | - | - | EUCALYPTUS DR | EUCALYPTUS DR |
| 100064 | N/A | Point | 1 | 1 | 0 - 0 | - | S226607 | PNDG JUNIPERO SERRA BLVD | 0-0 JUNIPERO SERRA BLVD | F | F | - | F | 12955000 | 12955000 | - | - | EAST SIDE | - | - | - | - | OCEAN AVE | OCEAN AVE | 66012 | 66012 | 37.73113287 | -122.47214626 | - | - | 1710539427000 | MTA | TANSAT | OCEAN AVE to EUCALYPTUS DR (0 - 0) -- WEST -- | - | IFO STEPS TO #175 | - | - | - | - | - | 117331 | - | -122.47214626 | 37.73113287 | - | - | - | D7 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP2 | 2 POST ALUMINUM | IS | 1465909560000 | JUNIPERO SERRA BLVD | PNDG JUNIPERO SERRA BLVD | 0 - 0 JUNIPERO SERRA BLVD | - | - | EUCALYPTUS DR | EUCALYPTUS DR |
| 100065 | N/A | Point | 1 | 1 | 0 - 0 | - | S100178 | PNDG JUNIPERO SERRA BLVD | 0-0 JUNIPERO SERRA BLVD | F | F | - | F | 12955000 | 12955000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | OCEAN AVE | OCEAN AVE | 125171 | 125171 | 37.73113287 | -122.47214626 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM) | OCEAN AVE to EUCALYPTUS DR (0 - 0) -- WEST -- | - | E LINE / 20 FEET | - | - | - | - | - | 117332 | -405129600000 | -122.47214626 | 37.73113287 | - | - | - | D7 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP2 | UNKNOWN | IS | 1373566380000 | JUNIPERO SERRA BLVD | PNDG JUNIPERO SERRA BLVD | 0 - 0 JUNIPERO SERRA BLVD | - | - | EUCALYPTUS DR | EUCALYPTUS DR |
| 100066 | N/A | Point | 1 | 1 | 100 - 133 | - | S200311 | 100-133 4TH ST | 100-133 04TH ST | F | F | - | F | 252000 | 252000 | - | - | WEST SIDE | - | - | - | - | MISSION ST | MISSION ST | 45773 | 45773 | 37.78426159 | -122.40398931 | - | - | 1710539427000 | MTA | BIKE RACK | MISSION ST to MINNA ST (100 - 133) | - | 40FT. SOUTH OF MISSION ST | - | - | - | - | - | 117333 | 1384784940000 | -122.40398931 | 37.78426159 | - | 1384732800000 | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BARRICADE | IS | 1384276080000 | 04TH ST | 100 - 133 4TH ST | 100 - 133 04TH ST | 100 4TH ST | - | MINNA ST | MINNA ST |
| 100067 | N/A | Point | 1 | 1 | 100 - 133 | - | S207957 | 100-133 4TH ST | 100-133 04TH ST | F | F | - | F | 252000 | 252000 | - | - | EAST SIDE | - | - | - | - | MISSION ST | MISSION ST | 48595 | 48595 | 37.78426159 | -122.40398931 | - | - | 1710539427000 | MTA | BIKE RACK | MISSION ST to MINNA ST (100 - 133) | - | 55' SOUTH OF MISSION(YERBA BUENA RACK) | - | - | - | - | - | 117334 | 1410271200000 | -122.40398931 | 37.78426159 | - | 1410220800000 | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BARRICADE | IS | 1406623680000 | 04TH ST | 100 - 133 4TH ST | 100 - 133 04TH ST | 100 4TH ST | - | MINNA ST | MINNA ST |
| 100068 | N/A | Point | 1 | 1 | 100 - 133 | - | S207954 | 100-133 4TH ST | 100-133 04TH ST | F | F | - | F | 252000 | 252000 | - | - | EAST SIDE | - | - | - | - | MISSION ST | MISSION ST | 48592 | 48592 | 37.78426159 | -122.40398931 | - | - | 1710539427000 | MTA | BIKE RACK | MISSION ST to MINNA ST (100 - 133) | - | 25' SOUTH OF MISSION(YERBA BUENA RACK) | - | - | - | - | - | 117335 | 1410270960000 | -122.40398931 | 37.78426159 | - | 1410220800000 | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BARRICADE | IS | 1406623200000 | 04TH ST | 100 - 133 4TH ST | 100 - 133 04TH ST | 100 4TH ST | - | MINNA ST | MINNA ST |
| 100069 | N/A | Point | 1 | 1 | 100 - 133 | - | S266794 | 100-133 4TH ST | 100-133 04TH ST | F | F | - | F | 252000 | 252000 | - | - | EAST SIDE | - | - | - | - | MISSION ST | MISSION ST | 101357 | 101357 | 37.78426159 | -122.40398931 | - | - | 1710539427000 | MTA | BIKE RACK (YERBA BUENA) | MISSION ST to MINNA ST (100 - 133) | 132695 | 7' S OF NPL 121/2.5' IN FROM CURB | - | - | - | - | - | 117336 | 1597404000000 | -122.40398931 | 37.78426159 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0345 | 36X36 | SUP1 | BIKE RACK | IS | 1596448560000 | 04TH ST | 100 - 133 4TH ST | 100 - 133 04TH ST | 100 4TH ST | - | MINNA ST | MINNA ST |
| 100070 | N/A | Point | - | - | - | - | S104773 | SUTTER ST: FRANKLIN ST | - | F | F | - | F | 25220000 | 25220000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SUTTER ST | FRANKLIN ST | 128681 | 128681 | 37.78733916 | -122.42340359 | FRANKLIN ST \ SUTTER ST | SUTTER ST \ FRANKLIN ST | 1710539427000 | MTA | ONE WAY (LA) | FRANKLIN ST intersection | - | - | - | - | - | - | - | 117337 | 28080000000 | -122.42340359 | 37.78733916 | - | 1508371200000 | - | D2 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373569020000 | SUTTER ST | - | - | - | - | - | - |
| 100071 | N/A | Point | - | - | - | - | S101476 | FRANKLIN ST: SUTTER ST | - | F | F | - | F | 25220000 | 25220000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SUTTER ST | FRANKLIN ST | 2810 | 2810 | 37.78733916 | -122.42340359 | FRANKLIN ST \ SUTTER ST | SUTTER ST \ FRANKLIN ST | 1710539427000 | MTA | ONE WAY (RA) | FRANKLIN ST intersection | - | 0 / 0 | - | - | - | - | - | 117338 | -397267200000 | -122.42340359 | 37.78733916 | - | - | - | D2 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373566800000 | SUTTER ST | - | - | - | - | - | - |
| 100072 | N/A | Point | - | - | - | - | S101463 | FRANKLIN ST: SUTTER ST | - | F | F | - | F | 25220000 | 25220000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SUTTER ST | FRANKLIN ST | 4638 | 4638 | 37.78733916 | -122.42340359 | FRANKLIN ST \ SUTTER ST | SUTTER ST \ FRANKLIN ST | 1710539427000 | MTA | ONE WAY (LA) | FRANKLIN ST intersection | - | 0 / 0 | - | - | - | - | - | 117339 | -397267200000 | -122.42340359 | 37.78733916 | - | - | - | D2 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373566800000 | SUTTER ST | - | - | - | - | - | - |
| 100073 | N/A | Point | - | - | - | - | S239441 | SUTTER ST: FRANKLIN ST | - | F | F | - | F | 25220000 | 25220000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SUTTER ST | FRANKLIN ST | 85333 | 85333 | 37.78733916 | -122.42340359 | FRANKLIN ST \ SUTTER ST | SUTTER ST \ FRANKLIN ST | 1710539427000 | MTA | FRANKLIN ST | FRANKLIN ST intersection | - | - | - | - | - | - | - | 117340 | 1508509080000 | -122.42340359 | 37.78733916 | - | 1508457600000 | - | D2 | - | STREET NAME | GUIDE | D3-2.0159 | 72X18 | SUP1 | SIGNAL POLE | IS | 1507806840000 | SUTTER ST | - | - | - | - | - | - |
| 100074 | N/A | Point | - | - | - | - | S239442 | FRANKLIN ST: SUTTER ST | - | F | F | - | F | 25220000 | 25220000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SUTTER ST | FRANKLIN ST | 90148 | 90148 | 37.78733916 | -122.42340359 | FRANKLIN ST \ SUTTER ST | SUTTER ST \ FRANKLIN ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) | FRANKLIN ST intersection | - | 10' S OF SUTTER | - | - | - | - | - | 117341 | 1508496360000 | -122.42340359 | 37.78733916 | - | 1508457600000 | - | D2 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP1 | 2 POST ALUMINUM | IS | 1507807860000 | SUTTER ST | - | - | - | - | - | - |
| 100075 | N/A | Point | - | - | - | - | S262878 | SUTTER ST: FRANKLIN ST | - | F | F | - | F | 25220000 | 25220000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SUTTER ST | FRANKLIN ST | 103993 | 103993 | 37.78733916 | -122.42340359 | FRANKLIN ST \ SUTTER ST | SUTTER ST \ FRANKLIN ST | 1710539427000 | MTA | 2 RIGHT LANES MUST TURN RIGHT | FRANKLIN ST intersection | 12403 | - | - | - | - | - | - | 117342 | 159321600000 | -122.42340359 | 37.78733916 | - | - | - | D2 | - | OTHER REGULATORY | REG | R3-7(SF).0005 | 36X36 | SUP1 | LIGHT POLE | IS | 1585641780000 | SUTTER ST | - | - | - | - | - | - |
| 100076 | N/A | Point | - | - | - | - | S250478 | CONNECTICUT ST: 18TH ST | - | F | F | - | F | 23679000 | 23679000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 18TH ST | CONNECTICUT ST | 82622 | 82622 | 37.7625212 | -122.397495 | CONNECTICUT ST \ 18TH ST | 18TH ST \ CONNECTICUT ST | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | CONNECTICUT ST intersection | - | - | - | - | - | - | - | 117343 | 1557140160000 | -122.397495 | 37.7625212 | - | - | - | D10 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP1 | MUNI POLE | IS | 1545817920000 | 18TH ST | - | - | - | - | - | - |
| 100077 | N/A | Point | - | - | - | - | S287300 | 18TH ST: CONNECTICUT ST | - | T | T | - | F | 23679000 | 23679000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 18TH ST | CONNECTICUT ST | 101676 | 101676 | 37.7625212 | -122.397495 | CONNECTICUT ST \ 18TH ST | 18TH ST \ CONNECTICUT ST | 1710539427000 | MTA | SPEED LIMIT 20 | CONNECTICUT ST intersection | - | - | - | - | - | - | - | 117344 | 1680480000000 | -122.397495 | 37.7625212 | - | - | - | D10 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | MUNI POLE | IS | 1675158420000 | 18TH ST | - | - | - | - | - | - |
| 100078 | N/A | Point | 1 | 1 | 1 - 33 | - | S217477 | 1-33 6TH ST | 1-33 06TH ST | T | T | - | F | 326000 | 326000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | GOLDEN GATE AVE \ MARKET ST \ TAYLOR ST | GOLDEN GATE AVE \ MARKET ST \ TAYLOR ST | 55986 | 55986 | 37.78199245 | -122.40999264 | - | - | 1740091511000 | middleware_editor | NO RIGHT TURN (SYM) | GOLDEN GATE AVE \ MARKET ST \ TAYLOR ST to STEVENSON ST (1 - 33) | - | 115' SOUTH OF MARKET | - | - | - | - | - | 117345 | 1438785420000 | -122.40999264 | 37.78199245 | - | 1740057300000 | - | D6 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1435316220000 | 06TH ST | 1 - 33 6TH ST | 1 - 33 06TH ST | 1 6TH ST | - | STEVENSON ST | STEVENSON ST |
| 100079 | N/A | Point | 1 | 1 | 1 - 33 | LEFT ARROW | S260008 | 1-33 6TH ST | 1-33 06TH ST | F | F | - | F | 326000 | 326000 | - | - | EAST SIDE | - | - | - | - | GOLDEN GATE AVE \ MARKET ST \ TAYLOR ST | GOLDEN GATE AVE \ MARKET ST \ TAYLOR ST | 110681 | 110681 | 37.78199245 | -122.40999264 | - | - | 1744837486000 | middleware_editor | TA (SYM) PLO AT ALL TIMES (5 MIN) | GOLDEN GATE AVE \ MARKET ST \ TAYLOR ST to STEVENSON ST (1 - 33) | - | 30' N OF STEVENSON | - | - | - | - | - | 117346 | 1595877540000 | -122.40999264 | 37.78199245 | - | 1744831800000 | - | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0001 | 14X21 | SUP1 | LIGHT POLE | IS | 1577713260000 | 06TH ST | 1 - 33 6TH ST | 1 - 33 06TH ST | 1 6TH ST | - | STEVENSON ST | STEVENSON ST |
| 100080 | N/A | Point | 1 | 1 | 1 - 33 | LEFT ARROW | S260010 | 1-33 6TH ST | 1-33 06TH ST | F | F | - | F | 326000 | 326000 | - | - | EAST SIDE | - | - | - | - | GOLDEN GATE AVE \ MARKET ST \ TAYLOR ST | GOLDEN GATE AVE \ MARKET ST \ TAYLOR ST | 111019 | 111019 | 37.78199245 | -122.40999264 | - | - | 1738968184000 | middleware_editor | TANSAT | GOLDEN GATE AVE \ MARKET ST \ TAYLOR ST to STEVENSON ST (1 - 33) | - | 60' SOUTH OF MARKET | - | - | - | - | - | 117347 | 1441324800000 | -122.40999264 | 37.78199245 | - | 1738939200000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1577713500000 | 06TH ST | 1 - 33 6TH ST | 1 - 33 06TH ST | 1 6TH ST | - | STEVENSON ST | STEVENSON ST |
| 100081 | N/A | Point | 1 | 1 | 1 - 33 | - | S217397 | 1-33 6TH ST | 1-33 06TH ST | T | T | - | F | 326000 | 326000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | GOLDEN GATE AVE \ MARKET ST \ TAYLOR ST | GOLDEN GATE AVE \ MARKET ST \ TAYLOR ST | 128833 | 128833 | 37.78199245 | -122.40999264 | - | - | 1710539427000 | MTA | EXC BUSES BICYCLES TAXIS AND TRUCKS (SYM) | GOLDEN GATE AVE \ MARKET ST \ TAYLOR ST to STEVENSON ST (1 - 33) | - | 115' SOUTH OF MARKET | - | - | - | - | - | 117348 | 1438785480000 | -122.40999264 | 37.78199245 | - | 1438732800000 | - | D6 | - | OTHER REGULATORY | REG | R(SF).0347 | 30X30 | SUP1 | LIGHT POLE | IS | 1435228560000 | 06TH ST | 1 - 33 6TH ST | 1 - 33 06TH ST | 1 6TH ST | - | STEVENSON ST | STEVENSON ST |
| 100082 | N/A | Point | 1 | 1 | 1 - 33 | - | S211110 | 1-33 6TH ST | 1-33 06TH ST | F | F | - | F | 326000 | 326000 | - | - | WEST SIDE | - | - | - | - | GOLDEN GATE AVE \ MARKET ST \ TAYLOR ST | GOLDEN GATE AVE \ MARKET ST \ TAYLOR ST | 51956 | 51956 | 37.78199245 | -122.40999264 | - | - | 1710539427000 | MTA | BIKE RACK | GOLDEN GATE AVE \ MARKET ST \ TAYLOR ST to STEVENSON ST (1 - 33) | - | 35'FROM MARKET 30"FROM CURB @O PM | - | - | - | - | - | 117349 | 1417875420000 | -122.40999264 | 37.78199245 | - | 1417824000000 | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1416823920000 | 06TH ST | 1 - 33 6TH ST | 1 - 33 06TH ST | 1 6TH ST | - | STEVENSON ST | STEVENSON ST |
| 100083 | N/A | Point | - | - | - | - | S102535 | STEVENSON ST: 6TH ST | - | F | F | - | F | 24295000 | 24295000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 6TH ST | 06TH ST | 6142 | 6142 | 37.78175433 | -122.40969326 | STEVENSON ST \ 6TH ST | STEVENSON ST \ 06TH ST | 1710539427000 | MTA | STOP | 06TH ST intersection | - | 0 / 0 | - | - | - | - | - | 117350 | -387763200000 | -122.40969326 | 37.78175433 | - | - | 1706171400000 | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | RETD | 1373568300000 | STEVENSON ST | - | - | - | - | - | - |
| 100084 | N/A | Point | - | - | - | - | S118773 | 6TH ST: STEVENSON ST | - | F | F | - | F | 24295000 | 24295000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 6TH ST | 06TH ST | 14423 | 14423 | 37.78175433 | -122.40969326 | STEVENSON ST \ 6TH ST | STEVENSON ST \ 06TH ST | 1710539427000 | MTA | PEDESTRIAN (SYM) | 06TH ST intersection | - | @ PM | - | - | - | - | - | 117351 | 1082332800000 | -122.40969326 | 37.78175433 | - | - | - | D6 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | 2IN IRON POST | RETD | 1373573400000 | STEVENSON ST | - | - | - | - | - | - |
| 100085 | N/A | Point | - | - | - | - | S257405 | 6TH ST: STEVENSON ST | - | F | F | - | F | 24295000 | 24295000 | - | - | SOUTH WEST CORNER | - | - | - | - | 6TH ST | 06TH ST | 125603 | 125603 | 37.78175433 | -122.40969326 | STEVENSON ST \ 6TH ST | STEVENSON ST \ 06TH ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | 06TH ST intersection | - | 1FT INTO THE ZONE | - | - | - | - | - | 117352 | 1082332800000 | -122.40969326 | 37.78175433 | - | 1568678400000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1566910200000 | STEVENSON ST | - | - | - | - | - | - |
| 100086 | N/A | Point | - | - | - | - | S257407 | 6TH ST: STEVENSON ST | - | F | F | - | F | 24295000 | 24295000 | - | - | SOUTH EAST CORNER | - | - | - | - | 6TH ST | 06TH ST | 89263 | 89263 | 37.78175433 | -122.40969326 | STEVENSON ST \ 6TH ST | STEVENSON ST \ 06TH ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | 06TH ST intersection | - | 1FT INTO THE ZONE | - | - | - | - | - | 117353 | 1082332800000 | -122.40969326 | 37.78175433 | - | 1568678400000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1566910380000 | STEVENSON ST | - | - | - | - | - | - |
| 100087 | N/A | Point | 1 | 1 | 32 - 63 | LEFT ARROW | S260006 | 32-63 6TH ST | 32-63 06TH ST | F | F | - | F | 327000 | 327000 | - | - | EAST SIDE | - | - | - | - | STEVENSON ST | STEVENSON ST | 110679 | 110679 | 37.78157623 | -122.40946935 | - | - | 1710539427000 | MTA | TA (SYM) PLO AT ALL TIMES (5 MIN) | STEVENSON ST to JESSIE ST (32 - 63) | - | 32' NORTH OF JESSIE ST | - | - | - | - | - | 117354 | 1595852160000 | -122.40946935 | 37.78157623 | - | - | - | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0001 | 14X21 | SUP1 | 2IN IRON POST | IS | 1577713140000 | 06TH ST | 32 - 63 6TH ST | 32 - 63 06TH ST | 32 6TH ST | - | JESSIE ST | JESSIE ST |
| 100088 | N/A | Point | 1 | 1 | 32 - 63 | - | S118757 | 32-63 6TH ST | 32-63 06TH ST | T | T | - | F | 327000 | 327000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | STEVENSON ST | STEVENSON ST | 79233 | 79233 | 37.78157623 | -122.40946935 | - | - | 1721159486000 | middleware_editor | PEDESTRIAN (SYM) | STEVENSON ST to JESSIE ST (32 - 63) | - | SPL #55 | - | - | - | - | - | 117355 | 1081900800000 | -122.40946935 | 37.78157623 | - | 1542240000000 | 1716199200000 | D6 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | LIGHT POLE | RETD | 1373573400000 | 06TH ST | 32 - 63 6TH ST | 32 - 63 06TH ST | 32 6TH ST | - | JESSIE ST | JESSIE ST |
| 100089 | N/A | Point | 1 | 1 | 1 - 55 | - | S202029 | 1-55 GROVE ST | 1-55 GROVE ST | F | F | - | F | 6552000 | 6552000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | 8TH ST \ HYDE ST \ MARKET ST | 08TH ST \ HYDE ST \ MARKET ST | 45632 | 45632 | 37.77876455 | -122.41563582 | - | - | 1710539427000 | MTA | WRNG DFSZ..PENLTYS SEVRLY INCRSD FOR SALE ..IN IMMED AREA | 08TH ST \ HYDE ST \ MARKET ST to LARKIN ST (1 - 55) | - | 10'WEST OF HYDE | - | - | - | - | - | 117356 | 1389613200000 | -122.41563582 | 37.77876455 | - | 1389571200000 | - | D6 | - | OTHER WARNING | WARNING | SW(SF).0004 | 24X18 | SUP1 | LIGHT POLE | IS | 1389606360000 | GROVE ST | 1 - 55 GROVE ST | 1 - 55 GROVE ST | 1 GROVE ST | - | LARKIN ST | LARKIN ST |
| 100090 | N/A | Point | - | - | - | - | S101291 | LOOMIS ST: OAKDALE AVE | - | F | F | - | F | 20813000 | 20813000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | OAKDALE AVE | LOOMIS ST | 970 | 970 | 37.74252073 | -122.40430629 | LOOMIS ST \ OAKDALE AVE | OAKDALE AVE \ LOOMIS ST | 1744121938000 | middleware_editor | STOP | LOOMIS ST intersection | - | - | - | - | - | - | - | 117357 | -399340800000 | -122.40430629 | 37.74252073 | - | 1461073800000 | 1733332500000 | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 3IN IRON POST | RETD | 1373566740000 | OAKDALE AVE | - | - | - | - | - | - |
| 100091 | N/A | Point | - | - | - | - | S115424 | LOOMIS ST: OAKDALE AVE | - | F | F | - | F | 20813000 | 20813000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | OAKDALE AVE | LOOMIS ST | 11093 | 11093 | 37.74252073 | -122.40430629 | LOOMIS ST \ OAKDALE AVE | OAKDALE AVE \ LOOMIS ST | 1744121979000 | middleware_editor | ALL WAY | LOOMIS ST intersection | - | 0 / BELOW EXISTING STOP SIGN (SEE PHOTO) | - | - | - | - | - | 117358 | 1030518000000 | -122.40430629 | 37.74252073 | - | 1461049200000 | 1733333400000 | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 3IN IRON POST | RETD | 1373572380000 | OAKDALE AVE | - | - | - | - | - | - |
| 100092 | N/A | Point | - | - | - | - | S101689 | PAGE ST: DIVISADERO ST | - | F | F | - | F | 26029000 | 26029000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 6773 | 6773 | 37.77220371 | -122.43723493 | PAGE ST \ DIVISADERO ST | PAGE ST \ DIVISADERO ST | 1710539427000 | MTA | STOP | DIVISADERO ST intersection | - | 0 / 0 | - | - | - | - | - | 117359 | -395193600000 | -122.43723493 | 37.77220371 | - | - | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373566860000 | PAGE ST | - | - | - | - | - | - |
| 100093 | N/A | Point | - | - | - | - | S288546 | DIVISADERO ST: PAGE ST | - | F | F | - | F | 26029000 | 26029000 | - | - | NORTH WEST CORNER | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 100078 | 100078 | 37.77220371 | -122.43723493 | PAGE ST \ DIVISADERO ST | PAGE ST \ DIVISADERO ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | DIVISADERO ST intersection | - | IN PSZ, SOUTH OF N-LINE X-WALK | - | - | - | - | - | 117360 | 1683676800000 | -122.43723493 | 37.77220371 | - | - | - | D5 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1681474320000 | PAGE ST | - | - | - | - | - | - |
| 100094 | N/A | Point | - | - | - | - | S282611 | DIVISADERO ST: PAGE ST | - | F | F | - | F | 26029000 | 26029000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 93433 | 93433 | 37.77220371 | -122.43723493 | PAGE ST \ DIVISADERO ST | PAGE ST \ DIVISADERO ST | 1710539427000 | MTA | TYPE Q DELINEATOR (IPR) | DIVISADERO ST intersection | - | ON THUMBNAIL | - | - | - | - | - | 117361 | 1656460800000 | -122.43723493 | 37.77220371 | - | - | - | D5 | - | DELINEATOR 5 | WARNING | TYPE-Q(CA).0001 | 02X24 | SUP1 | STANDARD BASE | IS | 1651658820000 | PAGE ST | - | - | - | - | - | - |
| 100095 | N/A | Point | - | - | - | - | S289320 | DIVISADERO ST: PAGE ST | - | F | F | - | F | 26029000 | 26029000 | - | - | CENTER ISLAND, S LINE, SOUTHBOUND | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 97337 | 97337 | 37.77220371 | -122.43723493 | PAGE ST \ DIVISADERO ST | PAGE ST \ DIVISADERO ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | DIVISADERO ST intersection | - | - | - | - | - | - | - | 117362 | 1683849600000 | -122.43723493 | 37.77220371 | - | - | - | D5 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1683645240000 | PAGE ST | - | - | - | - | - | - |
| 100096 | N/A | Point | - | - | - | - | S288550 | PAGE ST: DIVISADERO ST | - | T | T | - | F | 26029000 | 26029000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 102506 | 102506 | 37.77220371 | -122.43723493 | PAGE ST \ DIVISADERO ST | PAGE ST \ DIVISADERO ST | 1710539427000 | MTA | RIGHT TURN ONLY (SYM) | DIVISADERO ST intersection | - | INSTALL ON SIDE BAR NEXT TO SIGNAL | - | - | - | - | - | 117363 | 1683590400000 | -122.43723493 | 37.77220371 | - | - | - | D5 | - | OTHER REGULATORY | REG | R3-5.0001 | 24X30 | SUP1 | SIGNAL POLE | IS | 1681724580000 | PAGE ST | - | - | - | - | - | - |
| 100097 | N/A | Point | - | - | - | - | S289321 | DIVISADERO ST: PAGE ST | - | F | F | - | F | 26029000 | 26029000 | - | - | CENTER ISLAND, S LINE, NORTHBOUND | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 97338 | 97338 | 37.77220371 | -122.43723493 | PAGE ST \ DIVISADERO ST | PAGE ST \ DIVISADERO ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | DIVISADERO ST intersection | - | - | - | - | - | - | - | 117364 | 1683849600000 | -122.43723493 | 37.77220371 | - | - | - | D5 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1683645240000 | PAGE ST | - | - | - | - | - | - |
| 100098 | N/A | Point | - | - | - | - | S259323 | BRYANT ST: 3RD ST | - | F | F | - | F | 23831000 | 23831000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 3RD ST | BRYANT ST | 103242 | 103242 | 37.78132126 | -122.3958435 | BRYANT ST \ 3RD ST | 03RD ST \ BRYANT ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | BRYANT ST intersection | - | - | - | - | - | - | - | 117365 | 1574245200000 | -122.3958435 | 37.78132126 | - | - | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1574089980000 | 03RD ST | - | - | - | - | - | - |
| 100099 | N/A | Point | 1 | 1 | 1 - 35 | - | S147059 | 1-35 ROCKAWAY AVE | 1-35 ROCKAWAY AVE | F | F | - | F | 11101000 | 11101000 | - | - | NORTH SIDE | - | - | - | - | LAGUNA HONDA BLVD \ ULLOA ST | LAGUNA HONDA BLVD \ ULLOA ST | 39114 | 39114 | 37.74339889 | -122.45643006 | - | - | 1747673578000 | middleware_editor | NPRK 9AM-11AM 1ST & 3RD MON OF MONTH STCL | LAGUNA HONDA BLVD \ ULLOA ST to ROCKWOOD CT (1 - 35) | - | 31 FEET WEST OF ULLOA | - | - | - | - | - | 117366 | 1224658800000 | -122.45643006 | 37.74339889 | - | 1747416600000 | - | D7 | - | STREET CLEANING | REG | R30(CA).0036 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375728300000 | ROCKAWAY AVE | 1 - 35 ROCKAWAY AVE | 1 - 35 ROCKAWAY AVE | 1 ROCKAWAY AVE | - | ROCKWOOD CT | ROCKWOOD CT |
| 100100 | N/A | Point | 1 | 1 | 2400 - 2499 | - | S128074 | 2400-2499 GREEN ST | 2400-2499 GREEN ST | F | F | - | F | 6477000 | 6477000 | - | - | SOUTH SIDE | - | - | - | - | PIERCE ST | PIERCE ST | 21844 | 21844 | 37.79563704 | -122.43941279 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES (SYM) | PIERCE ST to SCOTT ST (2400 - 2499) | - | 25'E OF SCOTT | - | - | - | - | - | 117367 | 1192147200000 | -122.43941279 | 37.79563704 | - | 1699020000000 | - | D2 | - | PARKING:PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP1 | LIGHT POLE | IS | 1373576340000 | GREEN ST | 2400 - 2499 GREEN ST | 2400 - 2499 GREEN ST | 2400 GREEN ST | - | SCOTT ST | SCOTT ST |
| 100101 | N/A | Point | 1 | 1 | 196 - 199 | - | S267330 | 196-199 CHURCH ST | 196-199 CHURCH ST | T | T | - | F | 4009000 | 4009000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 14TH ST | 14TH ST | 98867 | 98867 | 37.76761682 | -122.42895867 | - | - | 1710539427000 | MTA | AT MARKET | 14TH ST to MARKET ST (196 - 199) | - | 200 FT WEST OF 14TH | - | - | - | - | - | 117368 | 1597708800000 | -122.42895867 | 37.76761682 | - | 1597881600000 | - | D8 | - | OTHER REGULATORY | REG | R(SF).0359 | 18X30 | SUP2 | LIGHT POLE | IS | 1597918260000 | CHURCH ST | 196 - 199 CHURCH ST | 196 - 199 CHURCH ST | 196 CHURCH ST | - | MARKET ST | MARKET ST |
| 100102 | N/A | Point | 1 | 1 | 196 - 199 | - | S267211 | 196-199 CHURCH ST | 196-199 CHURCH ST | T | T | - | F | 4009000 | 4009000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 14TH ST | 14TH ST | 98088 | 98088 | 37.76761682 | -122.42895867 | - | - | 1710539427000 | MTA | RIGHT TURN ONLY(SYM) | 14TH ST to MARKET ST (196 - 199) | - | 200 FT WEST OF 14TH | - | - | - | - | - | 117369 | 1597761120000 | -122.42895867 | 37.76761682 | - | - | - | D8 | - | OTHER REGULATORY | REG | R3-5.0002 | 30X36 | SUP2 | LIGHT POLE | IS | 1597751040000 | CHURCH ST | 196 - 199 CHURCH ST | 196 - 199 CHURCH ST | 196 CHURCH ST | - | MARKET ST | MARKET ST |
| 100103 | N/A | Point | - | - | - | - | S215992 | MARKET ST: CHURCH ST | - | F | F | - | F | 25881000 | 25881000 | - | - | SOUTH SIDE | - | - | - | - | MARKET ST | CHURCH ST | 54615 | 54615 | 37.76750446 | -122.42894857 | CHURCH ST \ MARKET ST | MARKET ST \ CHURCH ST | 1710539427000 | MTA | SPEED LIMIT 10 WHEN BUS OR STREETCAR STOPPED AT SAFETY ZONE | CHURCH ST intersection | - | 35FT. WEST OF CHURCH ST. | - | - | - | - | - | 117370 | - | -122.42894857 | 37.76750446 | - | - | - | D8 | - | OTHER REGULATORY | REG | R(SF).0245 | 24X36 | SUP2 | 2IN IRON POST | IS | 1431102060000 | MARKET ST | - | - | - | - | - | - |
| 100104 | N/A | Point | 1 | 1 | 2600 - 2699 | - | S288968 | 2600-2699 46TH AVE | 2600-2699 46TH AVE | F | F | - | F | 2034000 | 2034000 | - | - | SOUTH SIDE | - | - | - | - | VICENTE ST | VICENTE ST | 107224 | 107224 | 37.7371165 | -122.50429348 | - | - | 1710539427000 | MTA | BIKE RACK | VICENTE ST to WAWONA ST (2600 - 2699) | - | 55' W OF EPL 2601/3' IN FROM CURB | - | - | - | - | - | 117371 | - | -122.50429348 | 37.7371165 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1682522700000 | 46TH AVE | 2600 - 2699 46TH AVE | 2600 - 2699 46TH AVE | 2600 46TH AVE | - | WAWONA ST | WAWONA ST |
| 100105 | N/A | Point | 1 | 1 | 2600 - 2699 | - | S151885 | 2600-2699 46TH AVE | 2600-2699 46TH AVE | F | F | - | F | 2034000 | 2034000 | - | - | EAST SIDE | - | - | - | - | VICENTE ST | VICENTE ST | 41247 | 41247 | 37.7371165 | -122.50429348 | - | - | 1730328634000 | middleware_editor | NPRK 1PM-3PM 2ND & 4TH TUE OF MONTH STCL | VICENTE ST to WAWONA ST (2600 - 2699) | - | IFO#2634 | - | - | - | - | - | 117372 | 1228867200000 | -122.50429348 | 37.7371165 | - | 1730290920000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0101 | 18X18 | SUP2 | UTILITY POLE | IS | 1375730460000 | 46TH AVE | 2600 - 2699 46TH AVE | 2600 - 2699 46TH AVE | 2600 46TH AVE | - | WAWONA ST | WAWONA ST |
| 100106 | N/A | Point | - | - | - | - | S125663 | PACIFIC AVE: LAGUNA ST | - | F | F | - | F | 26569000 | 26569000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LAGUNA ST | PACIFIC AVE | 23241 | 23241 | 37.79397725 | -122.42980398 | PACIFIC AVE \ LAGUNA ST | LAGUNA ST \ PACIFIC AVE | 1710539427000 | MTA | ALL WAY | PACIFIC AVE intersection | - | - | - | - | - | - | - | 117373 | 1158710400000 | -122.42980398 | 37.79397725 | - | 1556668800000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575560000 | LAGUNA ST | - | - | - | - | - | - |
| 100107 | N/A | Point | - | - | - | DOUBLE ARROW | 25836 | - | - | - | - | - | - | 10420000 | - | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1702325569000 | jsanfel | - | - | PAGE ST | - | 174834 | 174834 | 37.7730508714203 | -122.434082917269 | - | - | 1710539427000 | MTA | PAGE SLOW ST FAMILY,H/C,PED,SKATEBOARD,BIKE (SYM) (COMBO) | - | - | NPL 321 | - | - | - | - | - | 117374 | 1702381380000 | - | - | - | - | - | 05 | - | OTHER REGULATORY | REG | R(SF).0515 | 24X30 | SUP2 | 2IN IRON POST | IS | - | PIERCE ST | 300 - 399 PIERCE ST | - | - | - | OAK ST | - |
| 100108 | N/A | Point | - | - | - | - | 24387 | - | - | F | T | - | F | 24768000 | - | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | 1696262109000 | mmendiet | - | - | MONTGOMERY ST | - | 159697 | 159697 | 37.7981813492764 | -122.403746520465 | BROADWAY \ MONTGOMERY ST | - | 1710539427000 | MTA | SPEED LIMIT 25 | - | - | SOUTHEAST CORNER | - | - | - | - | - | 117375 | 1698416100000 | - | - | - | - | - | 03 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP1 | LIGHT POLE | IS | - | BROADWAY | - | - | - | - | - | - |
| 100109 | N/A | Point | - | - | - | - | S263039 | BROADWAY: COLUMBUS AVE | - | T | T | - | F | 25321000 | 25321000 | R2-1.0005-2020-06-05 13:04:00-37.79786461--122.40666793 | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BROADWAY | COLUMBUS AVE | 98627 | 98627 | 37.79786461 | -122.40666793 | COLUMBUS AVE \ BROADWAY | BROADWAY \ COLUMBUS AVE | 1710539427000 | MTA | SPEED LIMIT 25 | COLUMBUS AVE intersection | - | - | - | - | - | - | - | 117376 | 1591362240000 | -122.40666793 | 37.79786461 | - | - | 1698677100000 | D3 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP1 | SIGNAL POLE | RETD | 1585822140000 | BROADWAY | - | - | - | - | - | - |
| 100110 | N/A | Point | - | - | - | - | 25682 | - | - | F | F | - | F | 3878000 | - | - | - | WEST SIDE | 1701724443000 | MALOPEZ | - | - | TURK BLVD | - | 172883 | 172883 | 37.7774197755759 | -122.451483329037 | - | - | 1747255330000 | middleware_editor | 2 HR PRK 8AM-8PM MON-FRI EXC AREA "BB" PERMITS | - | - | INFO 47 CHABOT TERRACE | - | - | - | - | 1 | 117377 | - | - | - | - | - | - | 01 | - | PARKING:RPP | REG | R32C(CA).0118 | 18X21 | SUP2 | 2IN IRON POST | IS | - | CHABOT TER | 1 - 99 CHABOT TER | - | - | - | GOLDEN GATE AVE | - |
| 100111 | N/A | Point | - | - | - | - | S266575 | SOUTH VAN NESS AVE: 22ND ST | - | T | T | - | F | 24081000 | 24081000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SOUTH VAN NESS AVE | SOUTH VAN NESS AVE | 107638 | 107638 | 37.75556828 | -122.41656664 | 22ND ST \ SOUTH VAN NESS AVE | 22ND ST \ SOUTH VAN NESS AVE | 1710539427000 | MTA | SOUTH VAN NESS AVE | SOUTH VAN NESS AVE intersection | - | - | - | - | - | - | - | 117378 | 1550707200000 | -122.41656664 | 37.75556828 | - | - | - | D9 | - | STREET NAME | GUIDE | D3-2.0319 | 72X18 | SUP2 | MUNI POLE | IS | 1595854080000 | 22ND ST | - | - | - | - | - | - |
| 100112 | N/A | Point | 1 | 1 | 700 - 799 | - | S136260 | 700-799 SHOTWELL ST | 700-799 SHOTWELL ST | F | F | - | F | 11839000 | 11839000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 21ST ST | 21ST ST | 31040 | 31040 | 37.75643326 | -122.41554974 | - | - | 1725999468000 | middleware_editor | SCHOOL (SYM) AHEAD | 21ST ST to 22ND ST (700 - 799) | - | SPL #742 | - | - | - | - | - | 117379 | 1333411200000 | -122.41554974 | 37.75643326 | - | 1570233600000 | - | D9 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1373578860000 | SHOTWELL ST | 700 - 799 SHOTWELL ST | 700 - 799 SHOTWELL ST | 700 SHOTWELL ST | - | 22ND ST | 22ND ST |
| 100113 | N/A | Point | 1 | 1 | 3050 - 3099 | - | S111317 | 3050-3099 22ND ST | 3050-3099 22ND ST | F | F | - | F | 1188000 | 1188000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SHOTWELL ST | SHOTWELL ST | 9612 | 9612 | 37.75560119 | -122.41601996 | - | - | 1756240935000 | middleware_editor | STOP | SHOTWELL ST to SOUTH VAN NESS AVE (3050 - 3099) | - | 12W | - | - | - | - | - | 117380 | 774946800000 | -122.41601996 | 37.75560119 | - | 1744996500000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571060000 | 22ND ST | 3050 - 3099 22ND ST | 3050 - 3099 22ND ST | 3050 22ND ST | - | SOUTH VAN NESS AVE | SOUTH VAN NESS AVE |
| 100114 | N/A | Point | - | - | - | - | S124951 | JERSEY ST: SANCHEZ ST | - | F | F | - | F | 25648000 | 25648000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SANCHEZ ST | SANCHEZ ST | 18735 | 18735 | 37.75076202 | -122.42957654 | JERSEY ST \ SANCHEZ ST | JERSEY ST \ SANCHEZ ST | 1710539427000 | MTA | ALL WAY | SANCHEZ ST intersection | - | - | - | - | - | - | - | 117381 | 1155513600000 | -122.42957654 | 37.75076202 | - | 1531872000000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575320000 | JERSEY ST | - | - | - | - | - | - |
| 100115 | N/A | Point | - | - | - | - | S277725 | SANCHEZ ST: JERSEY ST | - | F | F | - | F | 25648000 | 25648000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SANCHEZ ST | SANCHEZ ST | 123929 | 123929 | 37.75076202 | -122.42957654 | JERSEY ST \ SANCHEZ ST | JERSEY ST \ SANCHEZ ST | 1711491795000 | middleware_editor | FG 300 UR DELINEATOR (W) | SANCHEZ ST intersection | - | 20 FT 6 INCHES FROM CURB | - | - | - | - | - | 117382 | 1638921600000 | -122.42957654 | 37.75076202 | - | 1600905600000 | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1632221340000 | JERSEY ST | - | - | - | - | - | - |
| 100116 | N/A | Point | - | - | - | - | S285719 | STOCKTON ST: 4TH ST \ ELLIS ST | - | F | F | - | F | 24892000 | 24892000 | TYPE-DL.0011-None-37.78574399--122.40583101 | - | CENTER ISLAND, W LINE, SOUTHBOUND | - | - | - | - | 4TH ST \ MARKET ST \ STOCKTON ST | 04TH ST \ ELLIS ST \ MARKET ST | 100379 | 100379 | 37.78574399 | -122.40583101 | ELLIS ST \ 4TH ST \ MARKET ST \ STOCKTON ST | STOCKTON ST \ 04TH ST \ ELLIS ST \ MARKET ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | 04TH ST \ ELLIS ST \ MARKET ST intersection | - | 3 DELINEATORS ON ISLAND | - | - | - | - | - | 117383 | 1667347200000 | -122.40583101 | 37.78574399 | - | - | - | D3 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1666872660000 | STOCKTON ST | - | - | - | - | - | - |
| 100117 | N/A | Point | - | - | - | - | S277724 | SANCHEZ ST: JERSEY ST | - | F | F | - | F | 25648000 | 25648000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SANCHEZ ST | SANCHEZ ST | 123928 | 123928 | 37.75076202 | -122.42957654 | JERSEY ST \ SANCHEZ ST | JERSEY ST \ SANCHEZ ST | 1711472637000 | middleware_editor | FG 300 UR DELINEATOR (W) | SANCHEZ ST intersection | - | 20 FT 6 INCHES FROM CURB | - | - | - | - | - | 117384 | 1638921600000 | -122.42957654 | 37.75076202 | - | 1600905600000 | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1632221280000 | JERSEY ST | - | - | - | - | - | - |
| 100118 | N/A | Point | - | - | - | - | S261139 | SANCHEZ ST: JERSEY ST | - | F | F | - | F | 25648000 | 25648000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SANCHEZ ST | SANCHEZ ST | 98055 | 98055 | 37.75076202 | -122.42957654 | JERSEY ST \ SANCHEZ ST | JERSEY ST \ SANCHEZ ST | 1710539427000 | MTA | BIKE WAYFINDING SIGN | SANCHEZ ST intersection | 1339 | ABOVE STOP SIGN | - | - | - | - | - | 117385 | 513993600000 | -122.42957654 | 37.75076202 | - | 1581292800000 | - | D8 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | 2IN IRON POST | IS | 1580981100000 | JERSEY ST | - | - | - | - | - | - |
| 100119 | N/A | Point | 1 | 1 | 1150 - 1199 | - | S143740 | 1150-1199 SANCHEZ ST | 1150-1199 SANCHEZ ST | F | F | - | F | 11530000 | 11530000 | - | - | WEST SIDE | - | - | - | - | JERSEY ST | JERSEY ST | 34015 | 34015 | 37.75036326 | -122.42953831 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM 2ND & 4TH WED OF MONTH STCL | JERSEY ST to 25TH ST (1150 - 1199) | - | 1174 SANCHEZ | - | - | - | - | - | 117386 | 1222214400000 | -122.42953831 | 37.75036326 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0258 | 18X18 | SUP2 | LIGHT POLE | IS | 1375726860000 | SANCHEZ ST | 1150 - 1199 SANCHEZ ST | 1150 - 1199 SANCHEZ ST | 1150 SANCHEZ ST | - | 25TH ST | 25TH ST |
| 100120 | N/A | Point | - | - | - | - | S226831 | PENNSYLVANIA AVE: 18TH ST | - | T | T | - | F | 23654000 | 23654000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PENNSYLVANIA AVE | 18TH ST | 106632 | 106632 | 37.76275553 | -122.39361254 | 18TH ST \ PENNSYLVANIA AVE | PENNSYLVANIA AVE \ 18TH ST | 1729102582000 | middleware_editor | NO TRUCKS (SYM) OVER 3T EXC 1 BLOCK FOR DELIVERIES | 18TH ST intersection | - | - | - | - | - | - | - | 117387 | 1466690880000 | -122.39361254 | 37.76275553 | - | 1466640000000 | - | D10 | - | OTHER REGULATORY | REG | R5-2.0012 | 30X42 | SUP1 | LIGHT POLE | IS | 1466583840000 | PENNSYLVANIA AVE | - | - | - | - | - | - |
| 100121 | N/A | Point | - | - | - | - | S249755 | - | - | F | F | - | T | 8758020 | - | - | - | NORTH SIDE | 1689201376000 | MTA | - | - | - | - | 131637 | 131637 | 37.77271567 | -122.4224251 | - | - | 1744922341000 | middleware_editor | FG 300 UR DELINEATOR (W) | - | - | FROM 15' WEST TO 270' WEST(10FT. O.C) | - | - | - | - | - | 117388 | 1557522360000 | - | - | - | 1744917300000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | METRO BASE | IS | - | - | 1700 - 1724 MARKET ST | - | - | - | - | - |
| 100122 | N/A | Point | 1 | 1 | 1 - 99 | - | S240763 | 1-99 THERESA ST | 1-99 THERESA ST | F | F | - | F | 12564000 | 12564000 | - | - | SOUTH SIDE | - | - | - | - | MISSION ST | MISSION ST | 75848 | 75848 | 37.7282243 | -122.43342096 | - | - | 1710539427000 | MTA | NPRK 7AM-9AM WED STCL | MISSION ST to ALEMANY BLVD (1 - 99) | - | IFO 93 | - | - | - | - | - | 117389 | 1570492800000 | -122.43342096 | 37.7282243 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0246 | 18X18 | SUP2 | 2IN IRON POST | IS | 1511273940000 | THERESA ST | 1 - 99 THERESA ST | 1 - 99 THERESA ST | 1 THERESA ST | - | ALEMANY BLVD | ALEMANY BLVD |
| 100123 | N/A | Point | - | - | - | - | S123795 | - | - | F | F | - | F | 2177000 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131267 | 131267 | 37.71058004 | -122.45442134 | - | - | 1710539427000 | MTA | BIKE (SYM) LANE | - | - | 25' WEST INFO # 3000 | - | - | - | - | - | 117390 | 1147910400000 | - | - | - | - | - | D11 | - | BIKE REG | REG | R81(CA).0002 | 24X18 | SUP2 | 2 POST ALUMINUM | IS | - | - | 3053 - 3099 ALEMANY BLVD | - | - | - | - | - |
| 100124 | N/A | Point | - | - | - | - | S123796 | - | - | F | F | - | F | 2177000 | - | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131692 | 131692 | 37.71058004 | -122.45442134 | - | - | 1710539427000 | MTA | BIKE (SYM) LANE | - | - | EPL# 3047 | - | - | - | - | - | 117391 | 1147910400000 | - | - | - | - | - | D11 | - | BIKE REG | REG | R81(CA).0002 | 24X18 | SUP2 | 2IN IRON POST | IS | - | - | 3053 - 3099 ALEMANY BLVD | - | - | - | - | - |
| 100125 | N/A | Point | - | - | - | - | 24371 | - | - | F | F | - | F | 3285000 | - | - | - | NORTH SIDE | 1696004256000 | smuneno | - | - | 04TH ST \ I-80 E OFF RAMP | - | 159489 | 159489 | 37.7794559369997 | -122.398377101585 | - | - | 1710539427000 | MTA | CITY POSTS DELINEATOR (W) | - | 3 DELINEATORS AROUND OCS POLE | 5' WEST OF HIGHWAY 101 OFFRAMP/ 4TH ST | - | - | - | - | 3 | 117392 | 1697191860000 | - | - | - | - | - | 06 | - | DELINEATOR 5 | REG | TYPE DL.0026 | 36X03 | SUP1 | DELINEATOR BASE SAFE HIT | IS | - | BRYANT ST | 600 - 699 BRYANT ST | - | - | - | 05TH ST \ I-80 E ON RAMP | - |
Download data as a comma-separated values file with coordinates and properties.
Download CSVDownload data in GeoJSON format, compatible with most GIS applications.
Download GeoJSONDownload data in KML format for use with Google Earth and other mapping applications.
Download KMLDownload data as a shapefile (ZIP format) for use with ArcGIS and other GIS software.
Download ShapefileGet detailed information about this dataset including metadata and available properties.
page - Page number (default: 1)limit - Results per page (max: 1000, default: 100)properties - JSON object for property filteringgeometry_type - Filter by geometry type (Point, LineString, Polygon, etc.)bbox - Bounding box (minX,minY,maxX,maxY)lat - Center latitude for radius searchlon - Center longitude for radius searchradius - Search radius in metersMetadata automatically harvested from the ESRI service during import.