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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 102301 | N/A | Point | 1 | 1 | 100 - 199 | - | S213521 | 100-199 DIAMOND ST | 100-199 DIAMOND ST | F | F | - | F | 4738000 | 4738000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 18TH ST | 18TH ST | 126923 | 126923 | 37.7593527521926 | -122.437003045949 | - | - | 1743732328000 | middleware_editor | SPEED HUMP | 18TH ST to 19TH ST (100 - 199) | - | 35 FT NORTH OF 19TH ST | - | - | - | - | - | 119584 | 1429029120000 | -122.43711457 | 37.75995777 | - | 1428994800000 | - | D8 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1423822800000 | DIAMOND ST | 100 - 199 DIAMOND ST | 100 - 199 DIAMOND ST | 100 DIAMOND ST | - | 19TH ST | 19TH ST |
| 102302 | N/A | Point | - | - | - | - | S280795 | COLLINS ST: GEARY BLVD | - | T | T | - | F | 26908000 | 26908000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | COLLINS ST | GEARY BLVD | 122010 | 122010 | 37.7821166 | -122.4500923 | GEARY BLVD \ COLLINS ST | COLLINS ST \ GEARY BLVD | 1710539427000 | MTA | SPEED HUMP | GEARY BLVD intersection | - | - | - | - | - | - | - | 119585 | 1674000000000 | -122.4500923 | 37.7821166 | - | - | - | D1 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | SIGNAL POLE | IS | 1644316320000 | COLLINS ST | - | - | - | - | - | - |
| 102303 | N/A | Point | - | - | - | - | S256598 | EXCELSIOR AVE: LISBON ST | - | F | F | - | F | 21687000 | 21687000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LISBON ST | EXCELSIOR AVE | 117350 | 117350 | 37.725211241 | -122.431317773 | EXCELSIOR AVE \ LISBON ST | LISBON ST \ EXCELSIOR AVE | 1710539427000 | MTA | SPEED HUMP | EXCELSIOR AVE intersection | - | - | - | - | - | - | - | 119586 | 765248400000 | -122.4312534 | 37.72510658 | - | 1565136000000 | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1564495860000 | LISBON ST | - | - | - | - | - | - |
| 102304 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S253746 | 2300-2399 36TH AVE | 2300-2399 36TH AVE | F | F | - | F | 1813000 | 1813000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | SANTIAGO ST | SANTIAGO ST | 79442 | 79442 | 37.74318206 | -122.49397276 | - | - | 1717724920000 | middleware_editor | SPEED HUMP | SANTIAGO ST to TARAVAL ST (2300 - 2399) | - | 20`SOUTH OF SANTIAGO | - | - | - | - | - | 119587 | 1228780800000 | -122.49397276 | 37.74318206 | - | 1556236800000 | - | D4 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1556028120000 | 36TH AVE | 2300 - 2399 36TH AVE | 2300 - 2399 36TH AVE | 2300 36TH AVE | - | TARAVAL ST | TARAVAL ST |
| 102305 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S253748 | 2300-2399 36TH AVE | 2300-2399 36TH AVE | F | F | - | F | 1813000 | 1813000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | SANTIAGO ST | SANTIAGO ST | 117349 | 117349 | 37.74318206 | -122.49397276 | - | - | 1717724949000 | middleware_editor | SPEED HUMP | SANTIAGO ST to TARAVAL ST (2300 - 2399) | - | 70FT NORTH OF TARAVAL | - | - | - | - | - | 119588 | 1228780800000 | -122.49397276 | 37.74318206 | - | 1556236800000 | - | D4 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1556029080000 | 36TH AVE | 2300 - 2399 36TH AVE | 2300 - 2399 36TH AVE | 2300 36TH AVE | - | TARAVAL ST | TARAVAL ST |
| 102306 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S256001 | 1700-1799 ANZA ST | 1700-1799 ANZA ST | F | F | - | F | 2325000 | 2325000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | 8TH AVE | 08TH AVE | 90198 | 90198 | 37.77896987 | -122.46682106 | - | - | 1715909050000 | middleware_editor | SPEED HUMP | 08TH AVE to 09TH AVE (1700 - 1799) | - | EPL 1708 | - | - | - | - | - | 119589 | 1565782260000 | -122.46682106 | 37.77896987 | - | - | - | D1 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1562831640000 | ANZA ST | 1700 - 1799 ANZA ST | 1700 - 1799 ANZA ST | 1700 ANZA ST | - | 09TH AVE | 09TH AVE |
| 102307 | N/A | Point | 1 | 1 | 300 - 399 | - | S254375 | 300-399 SANTA ANA AVE | 300-399 SANTA ANA AVE | F | F | - | F | 11566000 | 11566000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | DARIEN WAY | DARIEN WAY | 87853 | 87853 | 37.73067236 | -122.46807536 | - | - | 1710539427000 | MTA | SPEED HUMP | DARIEN WAY to OCEAN AVE (300 - 399) | - | SPL 395 | - | - | - | - | - | 119590 | 1225152000000 | -122.46807536 | 37.73067236 | - | 1567555200000 | - | D7 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1558014120000 | SANTA ANA AVE | 300 - 399 SANTA ANA AVE | 300 - 399 SANTA ANA AVE | 300 SANTA ANA AVE | - | OCEAN AVE | OCEAN AVE |
| 102308 | N/A | Point | - | - | - | - | S281388 | LAKEVIEW AVE: CAINE AVE | - | F | F | - | F | 21594000 | 21594000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LAKEVIEW AVE | CAINE AVE | 93965 | 93965 | 37.71658322 | -122.45115539 | CAINE AVE \ LAKEVIEW AVE | LAKEVIEW AVE \ CAINE AVE | 1710539427000 | MTA | SPEED HUMP | CAINE AVE intersection | - | - | - | - | - | - | - | 119591 | 1654560000000 | -122.45115539 | 37.71658322 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1646820480000 | LAKEVIEW AVE | - | - | - | - | - | - |
| 102309 | N/A | Point | 1 | 1 | 20 - 68 | - | S257798 | 20-68 CAMBRIDGE ST | 20-68 CAMBRIDGE ST | F | F | - | F | 3617000 | 3617000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | STONEYFORD AVE | STONEYFORD AVE | 88676 | 88676 | 37.7313859 | -122.42056502 | - | - | 1718154767000 | middleware_editor | SPEED HUMP | STONEYFORD AVE to GLADSTONE DR (20 - 68) | - | 20 FT EAST OF STONEYFORD | - | - | - | - | - | 119592 | 1067475600000 | -122.42056502 | 37.7313859 | - | 1568937600000 | - | D9 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1568714400000 | CAMBRIDGE ST | 20 - 68 CAMBRIDGE ST | 20 - 68 CAMBRIDGE ST | 20 CAMBRIDGE ST | - | GLADSTONE DR | GLADSTONE DR |
| 102310 | N/A | Point | 1 | 1 | 3000 - 3099 | - | S249389 | 3000-3099 KIRKHAM ST | 3000-3099 KIRKHAM ST | F | F | - | F | 7872000 | 7872000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 34TH AVE | 34TH AVE | 81158 | 81158 | 37.75909921 | -122.49347343 | - | - | 1710539427000 | MTA | SPEED HUMP | 34TH AVE to 35TH AVE (3000 - 3099) | - | 5 FT EAST OF 35TH | - | - | - | - | - | 119593 | 1228176000000 | -122.49347343 | 37.75909921 | - | 1541116800000 | - | D4 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1541068680000 | KIRKHAM ST | 3000 - 3099 KIRKHAM ST | 3000 - 3099 KIRKHAM ST | 3000 KIRKHAM ST | - | 35TH AVE | 35TH AVE |
| 102311 | N/A | Point | 1 | 1 | 300 - 399 | - | S254381 | 300-399 SANTA ANA AVE | 300-399 SANTA ANA AVE | F | F | - | F | 11566000 | 11566000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | DARIEN WAY | DARIEN WAY | 88170 | 88170 | 37.73067236 | -122.46807536 | - | - | 1710539427000 | MTA | SPEED HUMP | DARIEN WAY to OCEAN AVE (300 - 399) | - | SPL 306 | - | - | - | - | - | 119594 | 1225152000000 | -122.46807536 | 37.73067236 | - | 1567555200000 | - | D7 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1558015380000 | SANTA ANA AVE | 300 - 399 SANTA ANA AVE | 300 - 399 SANTA ANA AVE | 300 SANTA ANA AVE | - | OCEAN AVE | OCEAN AVE |
| 102312 | N/A | Point | 1 | 1 | 500 - 599 | - | S254352 | 500-599 PLYMOUTH AVE | 500-599 PLYMOUTH AVE | F | F | - | F | 10516000 | 10516000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | LOBOS ST | LOBOS ST | 90127 | 90127 | 37.71534625 | -122.45607582 | - | - | 1720576254000 | middleware_editor | SPEED HUMP | LOBOS ST to MINERVA ST (500 - 599) | - | 5FT SOUTH OF MINERVA | - | - | - | - | - | 119595 | 1560863760000 | -122.45607582 | 37.71534625 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1557998100000 | PLYMOUTH AVE | 500 - 599 PLYMOUTH AVE | 500 - 599 PLYMOUTH AVE | 500 PLYMOUTH AVE | - | MINERVA ST | MINERVA ST |
| 102313 | N/A | Point | 1 | 1 | 200 - 299 | - | S280796 | 200-299 COLLINS ST | 200-299 COLLINS ST | F | F | - | F | 4276000 | 4276000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | GEARY BLVD | GEARY BLVD | 122011 | 122011 | 37.78143431 | -122.44995488 | - | - | 1753744251000 | middleware_editor | SPEED HUMP | GEARY BLVD to ANZA ST (200 - 299) | - | 60 FT NORTH OF ANZA | - | - | - | - | - | 119596 | 1648623600000 | -122.44995488 | 37.78143431 | - | - | - | D1 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1644316500000 | COLLINS ST | 200 - 299 COLLINS ST | 200 - 299 COLLINS ST | 200 COLLINS ST | - | ANZA ST | ANZA ST |
| 102314 | N/A | Point | 1 | 1 | 10 - 54 | - | S134710 | 10-54 MCALLISTER ST | 10-54 MCALLISTER ST | F | F | - | F | 8888000 | 8888000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | JONES ST | JONES ST | 113191 | 113191 | 37.78106497 | -122.41258606 | - | - | 1710539427000 | MTA | STOP HERE ON RED (45LA) | JONES ST to CHARLES J BRENHAM PL (10 - 54) | - | 18' EAST OF CHARLES J. BREHNAN | - | - | - | - | - | 119597 | 1312416000000 | -122.41258606 | 37.78106497 | - | - | - | D6 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP1 | 2IN FLANGE POST | IS | 1373578380000 | MCALLISTER ST | 10 - 54 MCALLISTER ST | 10 - 54 MCALLISTER ST | 10 MCALLISTER ST | - | CHARLES J BRENHAM PL | CHARLES J BRENHAM PL |
| 102315 | N/A | Point | 1 | 1 | 500 - 599 | - | S200561 | 500-599 COLUMBUS AVE | 500-599 COLUMBUS AVE | F | F | - | F | 4295000 | 4295000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | GREEN ST \ STOCKTON ST | GREEN ST \ STOCKTON ST | 47298 | 47298 | 37.79990266 | -122.40961046 | - | - | 1721159824000 | middleware_editor | STOP HERE ON RED (45RA) | GREEN ST \ STOCKTON ST to UNION ST (500 - 599) | - | AT NORTH LINE OF GREEN ST | - | - | - | - | - | 119598 | - | -122.40961046 | 37.79990266 | - | 1682985600000 | - | D3 | - | OTHER REGULATORY | REG | R10-6.0003 | 24X36 | SUP1 | 2IN IRON POST | IS | 1385050560000 | COLUMBUS AVE | 500 - 599 COLUMBUS AVE | 500 - 599 COLUMBUS AVE | 500 COLUMBUS AVE | - | UNION ST | UNION ST |
| 102316 | N/A | Point | 1 | 1 | 100 - 114 | RIGHT ARROW | S284324 | 100 - 114 1ST ST | 100-114 01ST ST | F | F | - | F | 104001 | 104001 | - | - | EAST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | MISSION ST | MISSION ST | 87648 | 87648 | 37.78964125 | -122.39742215 | - | - | 1710539427000 | MTA | STOP HERE ON RED (45RA) | MISSION ST to TRANSBAY HUMP (100 - 114) | - | 18' NORTH OF CROSSWALK OF MINNA ST. | - | - | - | - | - | 119599 | 1659571200000 | -122.39742215 | 37.78964125 | - | - | - | D6 | - | OTHER REGULATORY | REG | R10-6.0003 | 24X36 | SUP1 | 2IN FLANGE POST | IS | 1659531420000 | 01ST ST | 100 - 114 1ST ST | 100 - 114 01ST ST | 100 1ST ST | - | TRANSBAY HUMP | TRANSBAY HUMP |
| 102317 | N/A | Point | 1 | 1 | 700 - 812 | - | S227076 | 700-812 ARKANSAS ST | 700-812 ARKANSAS ST | F | F | - | F | 2441000 | 2441000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 22ND ST | 22ND ST | 67045 | 67045 | 37.75662875 | -122.39790027 | - | - | 1710539427000 | MTA | SPEED HUMP | 22ND ST to MADERA ST (700 - 812) | - | OPP #758 | - | - | - | - | - | 119600 | - | -122.39790027 | 37.75662875 | - | - | - | D10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1467709980000 | ARKANSAS ST | 700 - 812 ARKANSAS ST | 700 - 812 ARKANSAS ST | 700 ARKANSAS ST | - | MADERA ST | MADERA ST |
| 102318 | N/A | Point | - | - | - | - | S217962 | MARKET ST: DOLORES ST | - | F | F | - | F | 25865000 | 25865000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | MARKET ST | DOLORES ST | 53669 | 53669 | 37.76904239 | -122.42685829 | DOLORES ST \ MARKET ST | MARKET ST \ DOLORES ST | 1729216027000 | middleware_editor | STOP HERE ON RED (45LA) | DOLORES ST intersection | - | E-LINE PG PED X-WALK | - | - | - | - | - | 119601 | - | -122.42685829 | 37.76904239 | - | - | - | D8 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP2 | MUNI POLE | IS | 1437126960000 | MARKET ST | - | - | - | - | - | - |
| 102319 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S212939 | 1000-1099 PACHECO ST | 1000-1099 PACHECO ST | T | T | - | F | 10089000 | 10089000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 14TH AVE \ ORTEGA WAY | 14TH AVE \ ORTEGA WAY | 51710 | 51710 | 37.75162532 | -122.47127778 | - | - | 1714501881000 | middleware_editor | SPEED HUMP | 14TH AVE \ ORTEGA WAY to 15TH AVE \ MANDALAY LN (1000 - 1099) | - | IFO#1083 | - | - | - | - | - | 119602 | 1424166660000 | -122.47127778 | 37.75162532 | - | 1424131200000 | - | D7 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1422360840000 | PACHECO ST | 1000 - 1099 PACHECO ST | 1000 - 1099 PACHECO ST | 1000 PACHECO ST | - | 15TH AVE \ MANDALAY LN | 15TH AVE \ MANDALAY LN |
| 102320 | N/A | Point | - | 1 | 68 - 99 | - | S131563 | PNDG ESSEX ST | 68-99 ESSEX ST | F | F | - | F | 5261000 | 5261000 | - | - | EAST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | LANSING ST | LANSING ST | 21652 | 21652 | 37.78535121 | -122.39435315 | - | - | 1710539427000 | MTA | STOP HERE ON RED (45RA) | LANSING ST to HARRISON ST \ I-80 E ON RAMP (68 - 99) | - | 535'S @PM , 15'N OF HARRISON | - | - | - | - | - | 119603 | 1253664000000 | -122.39435315 | 37.78535121 | - | - | - | D6 | - | OTHER REGULATORY | REG | R10-6.0003 | 24X36 | SUP1 | SIGNAL POLE | IS | 1373577420000 | ESSEX ST | PNDG ESSEX ST | 68 - 99 ESSEX ST | - | - | HARRISON ST \ I-80 E ON RAMP | HARRISON ST \ I-80 E ON RAMP |
| 102321 | N/A | Point | 1 | 1 | 1 - 98 | - | S230082 | 1-98 TOPEKA AVE | 1-98 TOPEKA AVE | F | F | - | F | 12647000 | 12647000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | SILVER AVE | SILVER AVE | 65707 | 65707 | 37.73456462 | -122.40021542 | - | - | 1754425569000 | middleware_editor | SPEED HUMPS | SILVER AVE to QUINT ST (1 - 98) | - | NPL #89 | - | - | - | - | - | 119604 | 1341903600000 | -122.40021542 | 37.73456462 | - | 1477897200000 | - | D10 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1477057200000 | TOPEKA AVE | 1 - 98 TOPEKA AVE | 1 - 98 TOPEKA AVE | 1 TOPEKA AVE | - | QUINT ST | QUINT ST |
| 102322 | N/A | Point | 1 | 1 | 100 - 199 | - | S200538 | 100-199 DRUMM ST | 100-199 DRUMM ST | F | F | - | F | 4971000 | 4971000 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | - | - | - | - | SACRAMENTO ST | SACRAMENTO ST | 46341 | 46341 | 37.79502717 | -122.39667874 | - | - | 1710539427000 | MTA | STOP HERE ON RED (45LA) | SACRAMENTO ST to CLAY ST (100 - 199) | - | INFO #4 EMBARCADERO/ SOUTH LINE OF XWALK | - | - | - | - | - | 119605 | 1388931120000 | -122.39667874 | 37.79502717 | - | 1388880000000 | - | D3 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP1 | LIGHT POLE | IS | 1385020020000 | DRUMM ST | 100 - 199 DRUMM ST | 100 - 199 DRUMM ST | 100 DRUMM ST | - | CLAY ST | CLAY ST |
| 102323 | N/A | Point | - | 1 | 68 - 99 | - | S132685 | PNDG ESSEX ST | 68-99 ESSEX ST | F | F | - | F | 5261000 | 5261000 | - | - | EAST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | LANSING ST | LANSING ST | 25769 | 25769 | 37.78535121 | -122.39435315 | - | - | 1710539427000 | MTA | STOP HERE ON RED (45LA) | LANSING ST to HARRISON ST \ I-80 E ON RAMP (68 - 99) | - | 17FT NORTH OF HARRISON | - | - | - | - | - | 119606 | 1280966400000 | -122.39435315 | 37.78535121 | - | - | - | D6 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP1 | 2IN IRON POST | IS | 1373577780000 | ESSEX ST | PNDG ESSEX ST | 68 - 99 ESSEX ST | - | - | HARRISON ST \ I-80 E ON RAMP | HARRISON ST \ I-80 E ON RAMP |
| 102324 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S208600 | 1400-1499 REVERE AVE | 1400-1499 REVERE AVE | F | F | - | F | 10976000 | 10976000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | JENNINGS ST | JENNINGS ST | 48028 | 48028 | 37.73007441 | -122.38735537 | - | - | 1710539427000 | MTA | SPEED HUMPS | JENNINGS ST to KEITH ST (1400 - 1499) | - | WPL #1414 | - | - | - | - | - | 119607 | 1415354460000 | -122.38735537 | 37.73007441 | - | 1415318400000 | - | D10 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1409232120000 | REVERE AVE | 1400 - 1499 REVERE AVE | 1400 - 1499 REVERE AVE | 1400 REVERE AVE | - | KEITH ST | KEITH ST |
| 102325 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S208467 | 1400-1499 SHAFTER AVE | 1400-1499 SHAFTER AVE | F | F | - | F | 11785000 | 11785000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | JENNINGS ST | JENNINGS ST | 54529 | 54529 | 37.72944954 | -122.38791966 | - | - | 1750083899000 | middleware_editor | SPEED HUMPS | JENNINGS ST to KEITH ST (1400 - 1499) | - | EPL #1406 | - | - | - | - | - | 119608 | 1415831340000 | -122.38791966 | 37.72944954 | - | 1415779200000 | - | D10 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1409041680000 | SHAFTER AVE | 1400 - 1499 SHAFTER AVE | 1400 - 1499 SHAFTER AVE | 1400 SHAFTER AVE | - | KEITH ST | KEITH ST |
| 102326 | N/A | Point | - | - | - | - | S222010 | SCHWERIN ST: GARRISON AVE | - | T | T | - | F | 20369000 | 20369000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SCHWERIN ST | GARRISON AVE | 59182 | 59182 | 37.70921035 | -122.4119682 | GARRISON AVE \ SCHWERIN ST | SCHWERIN ST \ GARRISON AVE | 1710539427000 | MTA | SPEED HUMPS | GARRISON AVE intersection | - | INFO #298 | - | - | - | - | - | 119609 | 1453291200000 | -122.4119682 | 37.70921035 | - | 1453248000000 | - | D10 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1452588600000 | SCHWERIN ST | - | - | - | - | - | - |
| 102327 | N/A | Point | 1 | 1 | 200 - 299 | - | S271953 | 200-299 VERMONT ST | 200-299 VERMONT ST | F | F | - | F | 13210000 | 13210000 | - | - | WEST SIDE | - | - | - | - | 15TH ST | 15TH ST | 92069 | 92069 | 37.76660771 | -122.40468677 | - | - | 1753721699000 | middleware_editor | STOP HERE ON RED (45LA) | 15TH ST to 16TH ST (200 - 299) | - | 50' NORTH OF 16TH ST | - | - | - | - | - | 119610 | 1619193840000 | -122.40468677 | 37.76660771 | - | - | - | D10 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP1 | 2IN IRON POST | IS | 1611832800000 | VERMONT ST | 200 - 299 VERMONT ST | 200 - 299 VERMONT ST | 200 VERMONT ST | - | 16TH ST | 16TH ST |
| 102328 | N/A | Point | 1 | 1 | 351 - 394 | - | S271692 | 351-394 30TH ST | 351-394 30TH ST | F | F | - | F | 1670000 | 1670000 | - | - | SOUTH SIDE | - | - | - | - | WHITNEY ST | WHITNEY ST | 91782 | 91782 | 37.74198972 | -122.42830399 | - | - | 1710539427000 | MTA | BIKE RACK | WHITNEY ST to SANCHEZ ST (351 - 394) | 295798 | 251 E OF WPL 342/3.5' IN FROM CURB | - | - | - | - | - | 119611 | 1611662160000 | -122.42830399 | 37.74198972 | - | - | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1611213540000 | 30TH ST | 351 - 394 30TH ST | 351 - 394 30TH ST | 351 30TH ST | - | SANCHEZ ST | SANCHEZ ST |
| 102329 | N/A | Point | 1 | 1 | 351 - 394 | - | S271691 | 351-394 30TH ST | 351-394 30TH ST | F | F | - | F | 1670000 | 1670000 | - | - | SOUTH SIDE | - | - | - | - | WHITNEY ST | WHITNEY ST | 91781 | 91781 | 37.74198972 | -122.42830399 | - | - | 1710539427000 | MTA | BIKE RACK | WHITNEY ST to SANCHEZ ST (351 - 394) | 295798 | 213 E OF WPL 342/3.5' IN FROM CURB | - | - | - | - | - | 119612 | 1611661320000 | -122.42830399 | 37.74198972 | - | - | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1611213540000 | 30TH ST | 351 - 394 30TH ST | 351 - 394 30TH ST | 351 30TH ST | - | SANCHEZ ST | SANCHEZ ST |
| 102330 | N/A | Point | 1 | 1 | 351 - 394 | - | S271689 | 351-394 30TH ST | 351-394 30TH ST | F | F | - | F | 1670000 | 1670000 | - | - | SOUTH SIDE | - | - | - | - | WHITNEY ST | WHITNEY ST | 91779 | 91779 | 37.74198972 | -122.42830399 | - | - | 1710539427000 | MTA | BIKE RACK | WHITNEY ST to SANCHEZ ST (351 - 394) | 295798 | 119 E OF WPL 342/3.5' IN FROM CURB | - | - | - | - | - | 119613 | 1611656400000 | -122.42830399 | 37.74198972 | - | - | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1611213480000 | 30TH ST | 351 - 394 30TH ST | 351 - 394 30TH ST | 351 30TH ST | - | SANCHEZ ST | SANCHEZ ST |
| 102331 | N/A | Point | 1 | 1 | 351 - 394 | - | S261085 | 351-394 30TH ST | 351-394 30TH ST | F | F | - | F | 1670000 | 1670000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | WHITNEY ST | WHITNEY ST | 112395 | 112395 | 37.74198972 | -122.42830399 | - | - | 1710539427000 | MTA | BIKE (SYM) BIKE ROUTE | WHITNEY ST to SANCHEZ ST (351 - 394) | 1334 | OPP.# 365 UNDER STREET CLEANING SIGN | - | - | - | - | - | 119614 | 1222300800000 | -122.42830399 | 37.74198972 | - | 1581033600000 | - | D8 | - | BIKE GUIDE | GUIDE | D11-1C.0002 | 24X18 | SUP2 | 2IN IRON POST | IS | 1580901120000 | 30TH ST | 351 - 394 30TH ST | 351 - 394 30TH ST | 351 30TH ST | - | SANCHEZ ST | SANCHEZ ST |
| 102332 | N/A | Point | - | - | - | - | S282703 | NORDHOFF ST: MANGELS AVE | - | F | F | - | F | - | 22269000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | - | NORDHOFF ST | 107017 | 107017 | 37.73310384 | -122.44090315 | - | MANGELS AVE \ NORDHOFF ST | 1710539427000 | MTA | ALL WAY | NORDHOFF ST intersection | - | - | - | - | - | - | - | 119615 | 1652054400000 | -122.44090315 | 37.73310384 | - | - | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1652085840000 | MANGELS AVE | - | - | - | - | - | - |
| 102333 | N/A | Point | - | - | - | - | S282702 | NORDHOFF ST: MANGELS AVE | - | F | F | - | F | 22269000 | 22269000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | NORDHOFF ST | NORDHOFF ST | 91152 | 91152 | 37.73310384 | -122.44090315 | MANGELS AVE \ NORDHOFF ST | MANGELS AVE \ NORDHOFF ST | 1710539427000 | MTA | STOP | NORDHOFF ST intersection | - | - | - | - | - | - | - | 119616 | 1652054400000 | -122.44090315 | 37.73310384 | - | - | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1652085840000 | MANGELS AVE | - | - | - | - | - | - |
| 102334 | N/A | Point | 1 | 1 | 151 - 199 | - | S145535 | 151-199 MANGELS AVE | 151-199 MANGELS AVE | F | F | - | F | 8649000 | 8649000 | - | - | SOUTH SIDE | - | - | - | - | NORDHOFF ST | NORDHOFF ST | 79736 | 79736 | 37.7331009 | -122.44145273 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM 2ND & 4TH FRI OF MONTH STCL | NORDHOFF ST to CONGO ST (151 - 199) | - | 183 MANGELS | - | - | - | - | - | 119617 | 1222646400000 | -122.44145273 | 37.7331009 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0071 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375727640000 | MANGELS AVE | 151 - 199 MANGELS AVE | 151 - 199 MANGELS AVE | 151 MANGELS AVE | - | CONGO ST | CONGO ST |
| 102335 | N/A | Point | - | - | - | - | S224487 | BRYANT ST: STERLING ST | - | F | F | - | F | 24491000 | 24491000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | STERLING ST | BRYANT ST | 60105 | 60105 | 37.78369264 | -122.39284005 | BRYANT ST \ STERLING ST | STERLING ST \ BRYANT ST | 1710539427000 | MTA | PEDESTRIAN (SYM) | BRYANT ST intersection | - | ON RAMP ST. TO BAY BRIDE IS STERLING ST. | - | - | - | - | - | 119618 | 1459382400000 | -122.39284005 | 37.78369264 | - | 1459382400000 | - | D6 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | 2IN IRON POST | IS | 1459337040000 | STERLING ST | - | - | - | - | - | - |
| 102336 | N/A | Point | 1 | 1 | 1 - 99 | - | S283430 | 1-99 CHATTANOOGA ST | 1-99 CHATTANOOGA ST | F | F | - | F | 3909000 | 3909000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 21ST ST | 21ST ST | 87661 | 87661 | 37.75576144 | -122.4267106 | - | - | 1727200891000 | middleware_editor | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | 21ST ST to 22ND ST (1 - 99) | - | SPL #18 | - | - | - | - | - | 119619 | - | -122.4267106 | 37.75576144 | - | - | - | D8 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | 2IN IRON POST | IS | 1655220120000 | CHATTANOOGA ST | 1 - 99 CHATTANOOGA ST | 1 - 99 CHATTANOOGA ST | 1 CHATTANOOGA ST | - | 22ND ST | 22ND ST |
| 102337 | N/A | Point | 1 | 1 | 1000 - 1099 | RIGHT ARROW | S228985 | 1000-1099 STANYAN ST | 1000-1099 STANYAN ST | F | F | - | F | 12095000 | 12095000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | CARL ST | CARL ST | 66638 | 66638 | 37.76497611 | -122.45266389 | - | - | 1738358789000 | middleware_editor | 49 MILE SCENIC DRIVE (RA) | CARL ST to PARNASSUS AVE (1000 - 1099) | - | IFO# 1045 STANYAN ST. | - | - | - | - | - | 119620 | 1476358140000 | -122.45266389 | 37.76497611 | - | 1476316800000 | - | D5 | - | OTHER GUIDE | GUIDE | G-X(SF).0015 | 24X30 | SUP1 | 2IN IRON POST | IS | 1474039620000 | STANYAN ST | 1000 - 1099 STANYAN ST | 1000 - 1099 STANYAN ST | 1000 STANYAN ST | - | PARNASSUS AVE | PARNASSUS AVE |
| 102338 | N/A | Point | - | - | - | LEFT ARROW | S258098 | STANYAN ST: BEULAH ST | - | T | T | - | F | 26428000 | 26428000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BEULAH ST | STANYAN ST | 101558 | 101558 | 37.7673069 | -122.45316479 | STANYAN ST \ BEULAH ST | BEULAH ST \ STANYAN ST | 1710539427000 | MTA | KEZAR LOT | STANYAN ST intersection | - | POLE #82 | - | - | - | - | - | 119621 | 1571844660000 | -122.45316479 | 37.7673069 | - | - | - | D5 | - | OTHER GUIDE | GUIDE | G-K(SF).0004 | 30X30 | SUP1 | LIGHT POLE | IS | 1570021500000 | BEULAH ST | - | - | - | - | - | - |
| 102339 | N/A | Point | - | - | - | - | S283980 | 20TH AVE: BALBOA ST | - | F | F | - | F | 27497000 | 27497000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 20TH AVE | BALBOA ST | 112263 | 112263 | 37.77654634 | -122.47910636 | BALBOA ST \ 20TH AVE | 20TH AVE \ BALBOA ST | 1720795772000 | middleware_editor | CROSS TRAFFIC DOES NOT STOP | BALBOA ST intersection | - | - | - | - | - | - | - | 119622 | 1660608000000 | -122.47910636 | 37.77654634 | - | - | - | D1 | - | OTHER WARNING | WARNING | W4-4P.0001 | 24X12 | SUP2 | 2IN IRON POST | IS | 1657621860000 | 20TH AVE | - | - | - | - | - | - |
| 102340 | N/A | Point | 1 | 1 | 2400 - 2472 | - | S255975 | 2400-2472 CLAY ST | 2400-2472 CLAY ST | F | F | - | F | 4111000 | 4110000 | - | - | NORTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | GOLDBERG LN | WEBSTER ST | 94806 | 94806 | 37.7908016451095 | -122.434051993664 | - | - | 1745535436000 | middleware_editor | GETAROUND | WEBSTER ST to GOLDBERG LN (2400 - 2472) | - | 10'E OF FILLMORE | - | - | - | - | - | 119623 | 1317193200000 | -122.43316623 | 37.79084285 | - | 1564470000000 | 1745530800000 | D2 | - | OTHER GUIDE | GUIDE | G-G(SF).0037 | 05X12 | SUP1 | 2IN IRON POST | RETD | 1562759400000 | CLAY ST | 2451 - 2499 CLAY ST | 2400 - 2472 CLAY ST | 2400 CLAY ST | - | FILLMORE ST | GOLDBERG LN |
| 102341 | N/A | Point | - | - | - | - | S255970 | 250-299 OCTAVIA ST | - | F | F | - | F | 9879101 | 9879000 | - | - | WEST SIDE | - | - | - | - | LILY ST | - | 94804 | 94804 | 37.7744097294087 | -122.424251256389 | - | - | 1742340145000 | middleware_editor | GETAROUND | - | - | 31' N OF LILY | - | - | - | - | - | 119624 | 1562962620000 | -122.42419493 | 37.77457651 | - | - | 1742315400000 | D5 | - | OTHER GUIDE | GUIDE | G-G(SF).0037 | 05X12 | SUP1 | 2IN IRON POST | RETD | 1562757420000 | OCTAVIA ST | 251 - 299 OCTAVIA ST | OCTAVIA ST | - | - | OAK ST | - |
| 102342 | N/A | Point | - | - | - | - | S224488 | BRYANT ST: RINCON ST | - | F | F | - | F | 24481000 | 24481000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BRYANT ST | BRYANT ST | 60393 | 60393 | 37.78420531 | -122.39211877 | RINCON ST \ BRYANT ST | RINCON ST \ BRYANT ST | 1710539427000 | MTA | AHEAD | BRYANT ST intersection | - | ON RAMP ST. TO BAY BRIDE IS STERLING ST. | - | - | - | - | - | 119625 | 1459436580000 | -122.39211877 | 37.78420531 | - | 1459382400000 | - | D6 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP1 | 2IN IRON POST | IS | 1459337280000 | RINCON ST | - | - | - | - | - | - |
| 102343 | N/A | Point | - | - | - | - | S226499 | DIVISADERO ST: BROADWAY | - | T | T | - | F | 26864000 | 26864000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BROADWAY | DIVISADERO ST | 64859 | 64859 | 37.79343659 | -122.44152048 | DIVISADERO ST \ BROADWAY | BROADWAY \ DIVISADERO ST | 1710539427000 | MTA | SHARP CREST AHEAD - TRUCKS NOT ADVISED | DIVISADERO ST intersection | - | - | - | - | - | - | - | 119626 | - | -122.44152048 | 37.79343659 | - | - | - | D2 | - | OTHER WARNING | WARNING | W(SF).0045 | 30X48 | SUP1 | LIGHT POLE | IS | 1465574160000 | BROADWAY | - | - | - | - | - | - |
| 102344 | N/A | Point | 1 | 1 | 2400 - 2472 | - | S255977 | 2400-2472 CLAY ST | 2400-2472 CLAY ST | F | F | - | F | 4111000 | 4110000 | - | - | NORTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | GOLDBERG LN | WEBSTER ST | 94808 | 94808 | 37.790805348877 | -122.434020621923 | - | - | 1745535449000 | middleware_editor | GETAROUND | WEBSTER ST to GOLDBERG LN (2400 - 2472) | - | 19' E OF FILLMORE | - | - | - | - | - | 119627 | 1317193200000 | -122.43316623 | 37.79084285 | - | 1564470000000 | 1745530140000 | D2 | - | OTHER GUIDE | GUIDE | G-G(SF).0037 | 05X12 | SUP1 | 2IN IRON POST | RETD | 1562759520000 | CLAY ST | 2451 - 2499 CLAY ST | 2400 - 2472 CLAY ST | 2400 CLAY ST | - | FILLMORE ST | GOLDBERG LN |
| 102345 | N/A | Point | 1 | 1 | 4400 - 4499 | - | S223766 | 4400-4499 ANZA ST | 4400-4499 ANZA ST | F | F | - | F | 2351000 | 2351000 | - | - | SOUTH SIDE | - | - | - | - | 35TH AVE | 35TH AVE | 59963 | 59963 | 37.77765249 | -122.49584493 | - | - | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | 35TH AVE to 36TH AVE (4400 - 4499) | - | 4417 ANZA | - | - | - | - | - | 119628 | 1221523200000 | -122.49584493 | 37.77765249 | - | - | - | D1 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | 2IN IRON POST | IS | 1456831800000 | ANZA ST | 4400 - 4499 ANZA ST | 4400 - 4499 ANZA ST | 4400 ANZA ST | - | 36TH AVE | 36TH AVE |
| 102346 | N/A | Point | - | - | - | - | S224031 | CLAYTON ST: 17TH ST | - | T | T | - | F | 26200000 | 26200000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 17TH ST | CLAYTON ST | 63152 | 63152 | 37.76178141 | -122.4467834 | CLAYTON ST \ 17TH ST | 17TH ST \ CLAYTON ST | 1749501936000 | middleware_editor | NEW | CLAYTON ST intersection | - | - | - | - | - | - | - | 119629 | 1460138100000 | -122.4467834 | 37.76178141 | - | 1460098800000 | - | D5 | - | OTHER WARNING | WARNING | W(SF).0079 | 30X12 | SUP1 | MUNI POLE | IS | 1457606760000 | 17TH ST | - | - | - | - | - | - |
| 102347 | N/A | Point | - | - | - | - | S258097 | STANYAN ST: BEULAH ST | - | T | T | - | F | 26428000 | 26428000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BEULAH ST | STANYAN ST | 101557 | 101557 | 37.7673069 | -122.45316479 | STANYAN ST \ BEULAH ST | BEULAH ST \ STANYAN ST | 1710539427000 | MTA | "P" (WHITE-BLUE) | STANYAN ST intersection | - | POLE #82 | - | - | - | - | - | 119630 | 1571788800000 | -122.45316479 | 37.7673069 | - | - | - | D5 | - | OTHER GUIDE | GUIDE | G-P(SF).0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1570021440000 | BEULAH ST | - | - | - | - | - | - |
| 102348 | N/A | Point | - | - | - | - | S256041 | COLEMAN ST: INNES AVE \ INNES | - | F | F | - | F | 35034000 | 35034000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | COLEMAN ST \ INNES CT | COLEMAN ST \ INNES CT | 86326 | 86326 | 37.72784493 | -122.36842998 | INNES AVE \ COLEMAN ST \ INNES CT | INNES AVE \ COLEMAN ST \ INNES CT | 1710539427000 | MTA | PEDESTRIAN (SYM) | COLEMAN ST \ INNES CT intersection | - | 1' NORTH OF X-WALK @ INNES CT. | - | - | - | - | - | 119631 | 1558569600000 | -122.36842998 | 37.72784493 | - | 1563148800000 | - | D10 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | 2IN IRON POST | IS | 1562854980000 | INNES AVE | - | - | - | - | - | - |
| 102349 | N/A | Point | - | - | - | - | S110479 | FLORIDA ST: MARIPOSA ST | - | F | F | - | F | 5621000 | 24046000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 17TH ST | FLORIDA ST | 8703 | 8703 | 37.76297273 | -122.41120684 | - | MARIPOSA ST \ FLORIDA ST | 1710539427000 | MTA | STOP | FLORIDA ST intersection | - | - | - | - | - | - | - | 119632 | 645235200000 | -122.41120684 | 37.76297273 | - | - | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570820000 | MARIPOSA ST | 400 - 499 FLORIDA ST | - | - | - | MARIPOSA ST | - |
| 102350 | N/A | Point | - | - | - | - | S110480 | FLORIDA ST: MARIPOSA ST | - | F | F | - | F | 5622000 | 24046000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MARIPOSA ST | FLORIDA ST | 10416 | 10416 | 37.76297273 | -122.41120684 | - | MARIPOSA ST \ FLORIDA ST | 1710539427000 | MTA | STOP | FLORIDA ST intersection | - | 0 / 0 | - | - | - | - | - | 119633 | 645235200000 | -122.41120684 | 37.76297273 | - | 1594684800000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570820000 | MARIPOSA ST | 500 - 599 FLORIDA ST | - | - | - | 18TH ST | - |
| 102351 | N/A | Point | - | - | - | - | S119419 | MARIPOSA ST: FLORIDA ST | - | F | F | - | F | 8734000 | 24046000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FLORIDA ST | FLORIDA ST | 15395 | 15395 | 37.76297273 | -122.41120684 | - | MARIPOSA ST \ FLORIDA ST | 1710539427000 | MTA | ALL WAY | FLORIDA ST intersection | - | SWCORNER | - | - | - | - | - | 119634 | 1095120000000 | -122.41120684 | 37.76297273 | - | - | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573640000 | MARIPOSA ST | 2800 - 2899 MARIPOSA ST | - | - | - | ALABAMA ST | - |
| 102352 | N/A | Point | - | - | - | - | S119420 | FLORIDA ST: MARIPOSA ST | - | F | F | - | F | 5621000 | 24046000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 17TH ST | FLORIDA ST | 15396 | 15396 | 37.76297273 | -122.41120684 | - | MARIPOSA ST \ FLORIDA ST | 1710539427000 | MTA | ALL WAY | FLORIDA ST intersection | - | NWCORNER | - | - | - | - | - | 119635 | 1095120000000 | -122.41120684 | 37.76297273 | - | - | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573640000 | MARIPOSA ST | 400 - 499 FLORIDA ST | - | - | - | MARIPOSA ST | - |
| 102353 | N/A | Point | - | - | - | - | S119421 | FLORIDA ST: MARIPOSA ST | - | F | F | - | F | 5622000 | 24046000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MARIPOSA ST | FLORIDA ST | 15397 | 15397 | 37.76297273 | -122.41120684 | - | MARIPOSA ST \ FLORIDA ST | 1710539427000 | MTA | ALL WAY | FLORIDA ST intersection | - | SECORNER | - | - | - | - | - | 119636 | 1095120000000 | -122.41120684 | 37.76297273 | - | - | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573640000 | MARIPOSA ST | 500 - 599 FLORIDA ST | - | - | - | 18TH ST | - |
| 102354 | N/A | Point | - | - | - | - | S225586 | MIDDLE POINT RD: EVANS AVE \ J | - | F | F | - | F | 20177000 | 20177000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | EVANS AVE \ MIDDLE POINT RD | EVANS AVE \ MIDDLE POINT RD | 62703 | 62703 | 37.73768029 | -122.37910965 | JENNINGS ST \ EVANS AVE \ MIDDLE POINT RD | JENNINGS ST \ EVANS AVE \ MIDDLE POINT RD | 1710539427000 | MTA | STOP | EVANS AVE \ MIDDLE POINT RD intersection | - | CROSS ST IS EVANS | - | - | - | - | - | 119637 | 1501670280000 | -122.37910965 | 37.73768029 | - | 1501632000000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1463051220000 | JENNINGS ST | - | - | - | - | - | - |
| 102355 | N/A | Point | - | - | - | - | S225587 | JENNINGS ST: EVANS AVE \ MIDDL | - | F | F | - | F | 20177000 | 20177000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | EVANS AVE \ MIDDLE POINT RD | EVANS AVE \ MIDDLE POINT RD | 62704 | 62704 | 37.73768029 | -122.37910965 | JENNINGS ST \ EVANS AVE \ MIDDLE POINT RD | JENNINGS ST \ EVANS AVE \ MIDDLE POINT RD | 1710539427000 | MTA | STOP | EVANS AVE \ MIDDLE POINT RD intersection | - | OF JENNINGS ST & EVANS AVE F/S/B/T | - | - | - | - | - | 119638 | - | -122.37910965 | 37.73768029 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1463051520000 | JENNINGS ST | - | - | - | - | - | - |
| 102356 | N/A | Point | - | - | - | - | S243782 | MIDDLE POINT RD: EVANS AVE \ J | - | F | F | - | F | 20177000 | 20177000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | EVANS AVE \ MIDDLE POINT RD | EVANS AVE \ MIDDLE POINT RD | 82112 | 82112 | 37.73768029 | -122.37910965 | JENNINGS ST \ EVANS AVE \ MIDDLE POINT RD | JENNINGS ST \ EVANS AVE \ MIDDLE POINT RD | 1710539427000 | MTA | ALL WAY | EVANS AVE \ MIDDLE POINT RD intersection | - | CROSS ST IS EVANS | - | - | - | - | - | 119639 | 1501632000000 | -122.37910965 | 37.73768029 | - | 1521158400000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1521201300000 | JENNINGS ST | - | - | - | - | - | - |
| 102357 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S266747 | 1800-1899 BROADWAY | 1800-1899 BROADWAY | F | F | - | F | 3173000 | 3173000 | - | - | SOUTH SIDE | - | - | - | - | GOUGH ST | GOUGH ST | 99878 | 99878 | 37.79521094 | -122.42752204 | - | - | 1732232609000 | middleware_editor | 2 HR PRK 8AM-6PM MON-FRI EXC "KG" PERMITS | GOUGH ST to OCTAVIA ST (1800 - 1899) | - | WPL # 1889 BROADWAY | - | - | - | - | - | 119640 | 1597318920000 | -122.42752204 | 37.79521094 | - | 1701862200000 | - | D2 | - | PARKING:RPP | REG | R32C(CA).0093 | 18X21 | SUP1 | LIGHT POLE | IS | 1596190080000 | BROADWAY | 1800 - 1899 BROADWAY | 1800 - 1899 BROADWAY | 1800 BROADWAY | - | OCTAVIA ST | OCTAVIA ST |
| 102358 | N/A | Point | 1 | 1 | 1100 - 1138 | - | S254319 | 1100-1138 CAYUGA AVE | 1100-1138 CAYUGA AVE | F | F | - | F | 3837000 | 3836000 | - | - | WEST SIDE | - | - | - | - | SUNBEAM LN | ONEIDA AVE | 88100 | 88100 | 37.72055858 | -122.44070871 | - | - | 1710539427000 | MTA | NPRK 6AM-8AM MON THUR STCL | ONEIDA AVE to SUNBEAM LN (1100 - 1138) | - | 40 FT NORTH OF JUNIOR TERRACE OPP 1141 | - | - | - | - | - | 119641 | 1158537600000 | -122.44070871 | 37.72055858 | - | 1557964800000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0187 | 18X18 | SUP2 | 2IN IRON POST | IS | 1557831420000 | CAYUGA AVE | 1133 - 1149 CAYUGA AVE | 1100 - 1138 CAYUGA AVE | 1100 CAYUGA AVE | - | JUNIOR TER | SUNBEAM LN |
| 102359 | N/A | Point | 1 | 1 | 1000 - 1043 | - | S252718 | 1000-1043 CAYUGA AVE | 1000-1043 CAYUGA AVE | F | F | - | F | 3834000 | 3834000 | - | - | EAST SIDE | - | - | - | - | ONONDAGA AVE | ONONDAGA AVE | 101483 | 101483 | 37.72179285 | -122.43993694 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM THUR STCL | ONONDAGA AVE to BALHI CT (1000 - 1043) | - | IFO#1021 | - | - | - | - | - | 119642 | 1158537600000 | -122.43993694 | 37.72179285 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0304 | 18X18 | SUP2 | 2IN IRON POST | IS | 1553261580000 | CAYUGA AVE | 1000 - 1043 CAYUGA AVE | 1000 - 1043 CAYUGA AVE | 1000 CAYUGA AVE | - | BALHI CT | BALHI CT |
| 102360 | N/A | Point | 1 | 1 | 100 - 199 | - | S226826 | 100-199 PALM AVE | 100-199 PALM AVE | F | F | - | F | 10191000 | 10191000 | - | - | WEST SIDE | - | - | - | - | EUCLID AVE | EUCLID AVE | 64636 | 64636 | 37.78259446 | -122.45782793 | - | - | 1710539427000 | MTA | NPRK 7AM-9AM 1ST & 3RD TUE OF MONTH STCL | EUCLID AVE to GEARY BLVD (100 - 199) | - | 50FT. NORTH OF GEARY BLVD. | - | - | - | - | - | 119643 | 1220572800000 | -122.45782793 | 37.78259446 | - | 1698920700000 | - | D2 | - | STREET CLEANING | REG | R30B(CA).0229 | 18X18 | SUP1 | 2IN IRON POST | IS | 1466527020000 | PALM AVE | 100 - 199 PALM AVE | 100 - 199 PALM AVE | 100 PALM AVE | - | GEARY BLVD | GEARY BLVD |
| 102361 | N/A | Point | - | - | - | - | S242396 | PARKER AVE: EUCLID AVE | - | F | F | - | F | 26931000 | 26931000 | - | - | CENTER ISLAND, S LINE, NORTHBOUND | - | - | - | - | EUCLID AVE | EUCLID AVE | 75404 | 75404 | 37.78402999 | -122.4546178 | PARKER AVE \ EUCLID AVE | PARKER AVE \ EUCLID AVE | 1710539427000 | MTA | ROUNDABOUT ARROWS | EUCLID AVE intersection | - | - | - | - | - | - | - | 119644 | 1516369200000 | -122.4546178 | 37.78402999 | - | 1698918300000 | - | D2 | - | OTHER REGULATORY | REG | R7(SF).0001 | 18X24 | SUP1 | 2IN IRON POST | IS | 1516281960000 | PARKER AVE | - | - | - | - | - | - |
| 102362 | N/A | Point | 1 | 1 | 300 - 399 | - | S118120 | 300-399 14TH AVE | 300-399 14TH AVE | F | F | - | F | 555000 | 555000 | - | - | EAST SIDE | - | - | - | - | CLEMENT ST | CLEMENT ST | 12867 | 12867 | 37.78159239 | -122.47291424 | - | - | 1710539427000 | MTA | 2 HR PRK 9AM-6PM MON-FRI EXC "N" PERMITS | CLEMENT ST to GEARY BLVD (300 - 399) | - | 75`SOUTH OF CLEMENT | - | - | - | - | - | 119645 | 1073001600000 | -122.47291424 | 37.78159239 | - | - | - | D1 | - | PARKING:RPP | REG | R32C(CA).0169 | 18X21 | SUP2 | LIGHT POLE | IS | 1373573220000 | 14TH AVE | 300 - 399 14TH AVE | 300 - 399 14TH AVE | 300 14TH AVE | - | GEARY BLVD | GEARY BLVD |
| 102363 | N/A | Point | - | - | - | - | S107486 | FILLMORE ST: GREENWICH ST | - | F | F | - | F | 26747000 | 26747000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GREENWICH ST | FILLMORE ST | 10461 | 10461 | 37.79895185 | -122.43586632 | FILLMORE ST \ GREENWICH ST | GREENWICH ST \ FILLMORE ST | 1710539427000 | MTA | STOP | FILLMORE ST intersection | - | 0 / 0 | - | - | - | - | - | 119646 | 229824000000 | -122.43586632 | 37.79895185 | - | 1593993600000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | MUNI POLE | IS | 1373569860000 | GREENWICH ST | - | - | - | - | - | - |
| 102364 | N/A | Point | - | - | - | - | S122256 | GREENWICH ST: FILLMORE ST | - | F | F | - | F | 26747000 | 26747000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GREENWICH ST | FILLMORE ST | 15225 | 15225 | 37.79895185 | -122.43586632 | FILLMORE ST \ GREENWICH ST | GREENWICH ST \ FILLMORE ST | 1710539427000 | MTA | ALL WAY | FILLMORE ST intersection | - | - | - | - | - | - | - | 119647 | 1134691200000 | -122.43586632 | 37.79895185 | - | - | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 3IN IRON POST | IS | 1373574540000 | GREENWICH ST | - | - | - | - | - | - |
| 102365 | N/A | Point | - | - | - | - | S279537 | FILLMORE ST: GREENWICH ST | - | T | T | - | F | 26747000 | 26747000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GREENWICH ST | FILLMORE ST | 120241 | 120241 | 37.79895185 | -122.43586632 | FILLMORE ST \ GREENWICH ST | GREENWICH ST \ FILLMORE ST | 1710539427000 | MTA | SPEED LIMIT 20 | FILLMORE ST intersection | - | - | - | - | - | - | - | 119648 | 1560470400000 | -122.43586632 | 37.79895185 | - | 1560470400000 | - | D2 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1639131360000 | GREENWICH ST | - | - | - | - | - | - |
| 102366 | N/A | Point | - | - | - | - | S136015 | FILLMORE ST: GREENWICH ST | - | F | F | - | F | 26747000 | 26747000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GREENWICH ST | FILLMORE ST | 125371 | 125371 | 37.79895185 | -122.43586632 | FILLMORE ST \ GREENWICH ST | GREENWICH ST \ FILLMORE ST | 1710539427000 | MTA | LOMBARD (LA) | FILLMORE ST intersection | - | - | - | - | - | - | - | 119649 | 1330387200000 | -122.43586632 | 37.79895185 | - | - | - | D2 | - | OTHER GUIDE | GUIDE | G-L(SF).0016 | 30X30 | SUP1 | MUNI POLE | IS | 1373578800000 | GREENWICH ST | - | - | - | - | - | - |
| 102367 | N/A | Point | - | - | - | - | S136030 | GREENWICH ST: FILLMORE ST | - | F | F | - | F | 26747000 | 26747000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GREENWICH ST | FILLMORE ST | 26229 | 26229 | 37.79895185 | -122.43586632 | FILLMORE ST \ GREENWICH ST | GREENWICH ST \ FILLMORE ST | 1710539427000 | MTA | "P" (WHITE-BLUE) | FILLMORE ST intersection | - | - | - | - | - | - | - | 119650 | 1330387200000 | -122.43586632 | 37.79895185 | - | - | - | D2 | - | OTHER GUIDE | GUIDE | G-P(SF).0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373578800000 | GREENWICH ST | - | - | - | - | - | - |
| 102368 | N/A | Point | - | - | - | - | S136035 | FILLMORE ST: GREENWICH ST | - | F | F | - | F | 26747000 | 26747000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GREENWICH ST | FILLMORE ST | 25370 | 25370 | 37.79895185 | -122.43586632 | FILLMORE ST \ GREENWICH ST | GREENWICH ST \ FILLMORE ST | 1710539427000 | MTA | "P" (WHITE-BLUE) | FILLMORE ST intersection | - | - | - | - | - | - | - | 119651 | 1330387200000 | -122.43586632 | 37.79895185 | - | - | - | D2 | - | OTHER GUIDE | GUIDE | G-P(SF).0001 | 30X30 | SUP1 | MUNI POLE | IS | 1373578800000 | GREENWICH ST | - | - | - | - | - | - |
| 102369 | N/A | Point | - | - | - | - | S251700 | SHRADER ST: GRATTAN ST | - | F | F | - | F | 26283000 | 26283000 | - | - | NORTH WEST CORNER | - | - | - | - | SHRADER ST | GRATTAN ST | 117575 | 117575 | 37.763892943 | -122.451113797 | GRATTAN ST \ SHRADER ST | SHRADER ST \ GRATTAN ST | 1710539427000 | MTA | GRATTAN ST | GRATTAN ST intersection | - | - | - | - | - | - | - | 119652 | 1550742900000 | -122.45104229 | 37.76384265 | - | 1697802000000 | - | D5 | - | STREET NAME | GUIDE | D3-1.0768 | 36X08 | SUP1 | 3IN IRON POST | IS | 1550582520000 | SHRADER ST | - | - | - | - | - | - |
| 102370 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S275624 | 1200-1299 HOLLISTER AVE | 1200-1299 HOLLISTER AVE | F | F | - | F | 6963000 | 6963000 | - | - | SOUTH SIDE | - | - | - | - | JENNINGS ST | JENNINGS ST | 106904 | 106904 | 37.72124947 | -122.39512289 | - | - | 1710539427000 | MTA | (H/C SYM) PARK ONLY/MIN FINE $250 | JENNINGS ST to 03RD ST (1200 - 1299) | - | 25' EAST OF 3RD ST. | - | - | - | - | - | 119653 | 1626357420000 | -122.39512289 | 37.72124947 | - | - | - | D10 | - | OTHER REGULATORY | REG | R99C(CA).0001 | 12X24 | SUP1 | 2IN IRON POST | IS | 1624438560000 | HOLLISTER AVE | 1200 - 1299 HOLLISTER AVE | 1200 - 1299 HOLLISTER AVE | 1200 HOLLISTER AVE | - | 03RD ST | 03RD ST |
| 102371 | N/A | Point | 1 | 1 | 500 - 599 | - | S280582 | 500-699 BERRY ST | 500-599 BERRY ST | F | F | - | F | 2957000 | 2957000 | - | - | NORTH SIDE | - | - | - | - | 7TH ST | 07TH ST | 120596 | 120596 | 37.76975226 | -122.40099196 | - | - | 1710539427000 | MTA | (H/C SYM) PARK ONLY/MIN FINE $250 | 07TH ST to DE HARO ST (500 - 599) | - | 238' E OF DE HARO (X IS 7TH ST) | - | - | - | - | - | 119654 | 1644278400000 | -122.40099196 | 37.76975226 | - | - | - | D10 | - | OTHER REGULATORY | REG | R99C(CA).0001 | 12X24 | SUP1 | 2IN IRON POST | IS | 1643031300000 | BERRY ST | 500 - 599 BERRY ST | 500 - 599 BERRY ST | 500 BERRY ST | - | DE HARO ST | DE HARO ST |
| 102372 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S280636 | 1100-1199 INGERSON AVE | 1100-1199 INGERSON AVE | F | F | - | F | 7252000 | 7252000 | - | - | SOUTH SIDE | - | - | - | - | JENNINGS ST | JENNINGS ST | 121966 | 121966 | 37.72057838 | -122.39556245 | - | - | 1710539427000 | MTA | (H/C SYM) PARK ONLY/MIN FINE $250 | JENNINGS ST to 03RD ST (1100 - 1199) | - | 22' E OF 3RD | - | - | - | - | - | 119655 | 1646092800000 | -122.39556245 | 37.72057838 | - | - | - | D10 | - | OTHER REGULATORY | REG | R99C(CA).0001 | 12X24 | SUP1 | 2IN IRON POST | IS | 1643362080000 | INGERSON AVE | 1100 - 1199 INGERSON AVE | 1100 - 1199 INGERSON AVE | 1100 INGERSON AVE | - | 03RD ST | 03RD ST |
| 102373 | N/A | Point | - | - | - | - | 25007 | - | - | F | F | - | F | 5661000 | - | - | - | - | 1698784107000 | wdwilli | - | - | HAWTHORNE ST | - | 166106 | 166106 | 37.7838258758103 | -122.398741167637 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | - | - | EAST OF 3RD @ BIKE CORRAL S/S | - | - | - | - | 10 | 119656 | - | - | - | - | - | - | 06 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | PI | - | FOLSOM ST | 645 - 699 FOLSOM ST | - | - | - | 03RD ST | - |
| 102374 | N/A | Point | - | - | - | - | 24868 | - | - | - | - | - | - | 3151000 | - | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | 1698250215000 | wdwilli | - | - | KEARNY ST | - | 164833 | 164833 | 37.7979450277865 | -122.405608780677 | - | - | 1710539427000 | MTA | EXC BUSES | - | - | - | - | - | - | - | - | 119657 | - | - | - | - | 1698749100000 | - | 03 | - | OTHER REGULATORY | REG | R(SF).0059 | 12X18 | SUP1 | SIGNAL POLE | IS | - | BROADWAY | 500 - 544 BROADWAY | - | - | - | ROMOLO ST | - |
| 102375 | N/A | Point | - | - | - | - | S107798 | BROADWAY: KEARNY ST | - | F | F | - | F | 3151000 | 24795000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | KEARNY ST | BROADWAY | 121110 | 121110 | 37.79801696 | -122.40547307 | - | KEARNY ST \ BROADWAY | 1710539427000 | MTA | NO LEFT TURN (SYM) | BROADWAY intersection | - | 0 / 0 | - | - | - | - | - | 119658 | 256348800000 | -122.40547307 | 37.79801696 | - | 1698751800000 | - | D3 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1373569980000 | KEARNY ST | 500 - 544 BROADWAY | - | - | - | ROMOLO ST | - |
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.