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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 102451 | N/A | Point | 1 | 1 | 500 - 599 | - | S262045 | 500-599 30TH AVE | 500-599 30TH AVE | T | T | - | F | 1642000 | 1642000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | GEARY BLVD | GEARY BLVD | 111330 | 111330 | 37.77888144 | -122.49002381 | - | - | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | GEARY BLVD to ANZA ST (500 - 599) | 133737 | SPL #525 | - | - | - | - | - | 119734 | 1322611200000 | -122.49002381 | 37.77888144 | - | - | - | D1 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP2 | LIGHT POLE | IS | 1583135940000 | 30TH AVE | 500 - 599 30TH AVE | 500 - 599 30TH AVE | 500 30TH AVE | - | ANZA ST | ANZA ST |
| 102452 | N/A | Point | 1 | 1 | 500 - 599 | - | S261761 | 500-599 30TH AVE | 500-599 30TH AVE | F | F | - | F | 1642000 | 1642000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | GEARY BLVD | GEARY BLVD | 113071 | 113071 | 37.77888144 | -122.49002381 | - | - | 1736813351000 | middleware_editor | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | GEARY BLVD to ANZA ST (500 - 599) | 133735 | NPL #574 | - | - | - | - | - | 119735 | 1322438400000 | -122.49002381 | 37.77888144 | - | - | - | D1 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP2 | 2IN IRON POST | IS | 1582532220000 | 30TH AVE | 500 - 599 30TH AVE | 500 - 599 30TH AVE | 500 30TH AVE | - | ANZA ST | ANZA ST |
| 102453 | N/A | Point | - | - | - | - | S279209 | LINCOLN WAY: 33RD AVE | - | F | F | - | F | 27740000 | 27740000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LINCOLN WAY | 33RD AVE | 115010 | 115010 | 37.76477952 | -122.49225762 | 33RD AVE \ LINCOLN WAY | LINCOLN WAY \ 33RD AVE | 1710539427000 | MTA | YIELD HERE TO PED (SYM) (LA) | 33RD AVE intersection | - | - | - | - | - | - | - | 119736 | - | -122.49225762 | 37.76477952 | - | 1683072000000 | - | D4 | - | PEDESTRIAN | REG | R1-5.0001 | 18X24 | SUP2 | 2IN IRON POST | IS | 1638282240000 | LINCOLN WAY | - | - | - | - | - | - |
| 102454 | N/A | Point | - | - | - | - | 25016 | - | - | - | T | - | - | 24908000 | - | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | 1698787913000 | smuneno | - | - | POST ST | - | 166110 | 166110 | 37.7884661091942 | -122.406661212439 | STOCKTON ST \ POST ST | - | 1722531702000 | middleware_editor | STOCKTON CLOSED AT ELLIS NOV 13TH TO 19TH + (LA) DETOUR | - | - | NEXT TO SIGNAL, POST @ STOCKTON | - | - | - | - | - | 119737 | - | - | - | - | - | - | 03 | - | OTHER MISC | MISC | M4-1.0002 | 48X48 | SUP1 | SIGNAL POLE | IS | - | STOCKTON ST | - | - | - | - | - | - |
| 102455 | N/A | Point | - | - | - | - | S102696 | 3RD ST: BRYANT ST | - | F | F | - | F | 23831000 | 23831000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 3RD ST | BRYANT ST | 2869 | 2869 | 37.78132126 | -122.3958435 | BRYANT ST \ 3RD ST | 03RD ST \ BRYANT ST | 1710539427000 | MTA | ONE WAY (LA) | BRYANT ST intersection | - | 0 / 0 | - | - | - | - | - | 119738 | -386208000000 | -122.3958435 | 37.78132126 | - | - | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373568360000 | 03RD ST | - | - | - | - | - | - |
| 102456 | N/A | Point | - | - | - | - | S221417 | 3RD ST: BRYANT ST | - | F | F | - | F | 23831000 | 23831000 | - | - | NORTH WEST CORNER | - | - | - | - | 3RD ST | BRYANT ST | 57463 | 57463 | 37.78132126 | -122.3958435 | BRYANT ST \ 3RD ST | 03RD ST \ BRYANT ST | 1746731236000 | middleware_editor | NO PED CROSSING | BRYANT ST intersection | - | - | - | - | - | - | - | 119739 | - | -122.3958435 | 37.78132126 | - | 1746729000000 | - | D6 | - | PEDESTRIAN | REG | R(SF).0147 | 36X18 | SUP1 | 2 POST ALUMINUM | IS | 1450361760000 | 03RD ST | - | - | - | - | - | - |
| 102457 | N/A | Point | - | - | - | - | S134158 | BRYANT ST: 3RD ST | - | F | F | - | F | 23831000 | 23831000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 3RD ST | BRYANT ST | 25619 | 25619 | 37.78132126 | -122.3958435 | BRYANT ST \ 3RD ST | 03RD ST \ BRYANT ST | 1710539427000 | MTA | "P" (WHITE-BLUE) | BRYANT ST intersection | - | INFO# 514 | - | - | - | - | - | 119740 | 1302220800000 | -122.3958435 | 37.78132126 | - | - | - | D6 | - | OTHER GUIDE | GUIDE | G-P(SF).0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1373578200000 | 03RD ST | - | - | - | - | - | - |
| 102458 | N/A | Point | - | - | - | - | S116292 | BRYANT ST: 3RD ST | - | F | F | - | F | 23831000 | 23831000 | - | - | NORTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 3RD ST | BRYANT ST | 16666 | 16666 | 37.78132126 | -122.3958435 | BRYANT ST \ 3RD ST | 03RD ST \ BRYANT ST | 1710539427000 | MTA | (LA) ONLY (LA) ONLY | BRYANT ST intersection | - | - | - | - | - | - | - | 119741 | 1047081600000 | -122.3958435 | 37.78132126 | - | - | - | D6 | - | OTHER REGULATORY | REG | R61(SF).0028 | 36X30 | SUP1 | LIGHT POLE | IS | 1373572620000 | 03RD ST | - | - | - | - | - | - |
| 102459 | N/A | Point | - | - | - | - | S112452 | 3RD ST: BRYANT ST | - | F | F | - | F | 23831000 | 23831000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 3RD ST | BRYANT ST | 10785 | 10785 | 37.78132126 | -122.3958435 | BRYANT ST \ 3RD ST | 03RD ST \ BRYANT ST | 1710539427000 | MTA | (VA) I-101(SYM) I-80 (SYM)/BAY BRIDGE | BRYANT ST intersection | - | ABOVE MAST ARM | - | - | - | - | - | 119742 | 952732800000 | -122.3958435 | 37.78132126 | - | - | - | D6 | - | OTHER GUIDE | GUIDE | G-I(SF).0021 | 54X40 | SUP1 | LIGHT POLE | IS | 1373571420000 | 03RD ST | - | - | - | - | - | - |
| 102460 | N/A | Point | - | - | - | - | S236538 | 3RD ST: BRYANT ST | - | F | F | - | F | 23831000 | 23831000 | - | - | NORTH EAST CORNER | - | - | - | - | 3RD ST | BRYANT ST | 70684 | 70684 | 37.78132126 | -122.3958435 | BRYANT ST \ 3RD ST | 03RD ST \ BRYANT ST | 1710539427000 | MTA | NO PED XING-USE CROSSWALK | BRYANT ST intersection | - | - | - | - | - | - | - | 119743 | 1496838120000 | -122.3958435 | 37.78132126 | - | 1496793600000 | - | D6 | - | PEDESTRIAN | REG | R49(CA).0002 | 36X18 | SUP1 | 2 POST ALUMINUM | IS | 1496308440000 | 03RD ST | - | - | - | - | - | - |
| 102461 | N/A | Point | - | - | - | - | S256124 | BRYANT ST: 3RD ST | - | T | T | - | F | 23831000 | 23831000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 3RD ST | BRYANT ST | 91270 | 91270 | 37.78132126 | -122.3958435 | BRYANT ST \ 3RD ST | 03RD ST \ BRYANT ST | 1710539427000 | MTA | MOSCONE CENTER (LA) JESSIE SQUARE (LA) | BRYANT ST intersection | - | - | - | - | - | - | - | 119744 | 1324425600000 | -122.3958435 | 37.78132126 | - | - | - | D6 | - | OTHER GUIDE | GUIDE | G-M(SF).0018 | 30X30 | SUP1 | SIGNAL POLE | IS | 1563275520000 | 03RD ST | - | - | - | - | - | - |
| 102462 | N/A | Point | - | - | - | - | 24510 | - | - | F | F | - | F | 3526000 | - | - | - | SOUTH SIDE | 1696527150000 | wdwilli | - | - | FRONT ST | - | 160774 | 160774 | 37.793237575 | -122.399185379759 | - | - | 1755628262000 | middleware_editor | NPRK 2AM-6AM TUE THUR STCL | - | - | 60' W. FRONT | - | - | - | - | - | 119745 | - | - | - | - | 1698787800000 | - | 03 | - | STREET CLEANING | REG | R30B(CA).0133 | 18X18 | SUP1 | 2IN FLANGE POST | IS | - | - | 200 - 299 CALIFORNIA ST | - | - | - | BATTERY ST | - |
| 102463 | N/A | Point | - | - | - | - | 25019 | - | - | F | F | - | F | 27740000 | - | - | - | SOUTH EAST CORNER | 1698789222000 | elclark | - | - | LINCOLN WAY | - | 166120 | 166120 | 37.7646998815359 | -122.49216953292 | 33RD AVE \ LINCOLN WAY | - | 1716305330000 | middleware_editor | LINCOLN BLVD | - | - | SEC <3200 WEST | - | - | - | - | - | 119746 | - | - | - | - | 1716213900000 | - | 04 | - | STREET NAME | GUIDE | D3-1.1045 | 36X08 | SUP2 | 3IN IRON POST | IS | - | 33RD AVE | - | - | - | - | - | - |
| 102464 | N/A | Point | - | - | - | - | S111902 | 3RD ST: BRYANT ST | - | F | F | - | F | 23831000 | 23831000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 3RD ST | BRYANT ST | 127693 | 127693 | 37.78132126 | -122.3958435 | BRYANT ST \ 3RD ST | 03RD ST \ BRYANT ST | 1710539427000 | MTA | ONE WAY (LA) | BRYANT ST intersection | - | - | - | - | - | - | - | 119747 | 874713600000 | -122.3958435 | 37.78132126 | - | - | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | LIGHT POLE | IS | 1373571240000 | 03RD ST | - | - | - | - | - | - |
| 102465 | N/A | Point | - | - | - | - | S256126 | 3RD ST: BRYANT ST | - | T | T | - | F | 23831000 | 23831000 | - | - | SOUTH WEST CORNER | - | - | - | - | 3RD ST | BRYANT ST | 101848 | 101848 | 37.78132126 | -122.3958435 | BRYANT ST \ 3RD ST | 03RD ST \ BRYANT ST | 1710539427000 | MTA | BRYANT ST | BRYANT ST intersection | - | []--->500 | - | - | - | - | - | 119748 | 1600852500000 | -122.3958435 | 37.78132126 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.0273 | 36X08 | SUP1 | LIGHT POLE | IS | 1563275940000 | 03RD ST | - | - | - | - | - | - |
| 102466 | N/A | Point | - | - | - | - | S266574 | BRYANT ST: 3RD ST | - | T | T | - | F | 23831000 | 23831000 | - | - | NORTH WEST CORNER | - | - | - | - | 3RD ST | BRYANT ST | 102593 | 102593 | 37.78132126 | -122.3958435 | BRYANT ST \ 3RD ST | 03RD ST \ BRYANT ST | 1710539427000 | MTA | 3RD ST | BRYANT ST intersection | - | []<---500 | - | - | - | - | - | 119749 | 1600856100000 | -122.3958435 | 37.78132126 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.0030 | 36X08 | SUP1 | LIGHT POLE | IS | 1595852820000 | 03RD ST | - | - | - | - | - | - |
| 102467 | N/A | Point | - | - | - | - | S122890 | GREEN ST: OCTAVIA ST | - | F | F | - | F | 26576000 | 26576000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | OCTAVIA ST | GREEN ST | 21408 | 21408 | 37.79699173 | -122.4287254 | GREEN ST \ OCTAVIA ST | OCTAVIA ST \ GREEN ST | 1710539427000 | MTA | ALL WAY | GREEN ST intersection | - | - | - | - | - | - | - | 119750 | 1141603200000 | -122.4287254 | 37.79699173 | - | - | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373574720000 | OCTAVIA ST | - | - | - | - | - | - |
| 102468 | N/A | Point | - | - | - | - | S122894 | 15TH AVE: CLEMENT ST | - | F | F | - | F | 27489000 | 27489000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CLEMENT ST | CLEMENT ST | 78987 | 78987 | 37.78250908 | -122.47411059 | 15TH AVE \ CLEMENT ST | 15TH AVE \ CLEMENT ST | 1710539427000 | MTA | ALL WAY | CLEMENT ST intersection | - | - | - | - | - | - | - | 119751 | 1141603200000 | -122.47411059 | 37.78250908 | - | 1573516800000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373574720000 | 15TH AVE | - | - | - | - | - | - |
| 102469 | N/A | Point | 1 | 1 | 100 - 199 | - | S141749 | 100-199 PALM AVE | 100-199 PALM AVE | F | F | - | F | 10191000 | 10191000 | - | - | WEST SIDE | - | - | - | - | EUCLID AVE | EUCLID AVE | 32377 | 32377 | 37.78259446 | -122.45782793 | - | - | 1710539427000 | MTA | NPRK 7AM-9AM 1ST & 3RD TUE OF MONTH STCL | EUCLID AVE to GEARY BLVD (100 - 199) | - | 186 FEET NORTH OF GEARY | - | - | - | - | - | 119752 | 1220572800000 | -122.45782793 | 37.78259446 | - | - | - | D2 | - | STREET CLEANING | REG | R30B(CA).0229 | 18X18 | SUP1 | 2IN IRON POST | IS | 1375725960000 | PALM AVE | 100 - 199 PALM AVE | 100 - 199 PALM AVE | 100 PALM AVE | - | GEARY BLVD | GEARY BLVD |
| 102470 | N/A | Point | - | - | - | - | S236647 | CORTLAND AVE: PUTNAM ST | - | T | T | - | F | 21061000 | 21061000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | PUTNAM ST | CORTLAND AVE | 73814 | 73814 | 37.73979248 | -122.41073334 | CORTLAND AVE \ PUTNAM ST | PUTNAM ST \ CORTLAND AVE | 1710539427000 | MTA | NO RIGHT TURN (SYM) | CORTLAND AVE intersection | - | 17' WEST OF PUTNUM (S/S OF CORTLAND) | - | - | - | - | - | 119753 | 1508412720000 | -122.41073334 | 37.73979248 | - | 1508371200000 | - | D9 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP2 | MUNI POLE | IS | 1496657760000 | PUTNAM ST | - | - | - | - | - | - |
| 102471 | N/A | Point | 1 | 1 | 301 - 399 | - | S232976 | 301-399 MAGELLAN AVE | 301-399 MAGELLAN AVE | F | F | - | F | 8620000 | 8620000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | DORANTES AVE \ PACHECO ST | DORANTES AVE \ PACHECO ST | 69142 | 69142 | 37.74516186 | -122.46324684 | - | - | 1710539427000 | MTA | SPEED HUMPS | DORANTES AVE \ PACHECO ST to MONTALVO AVE (301 - 399) | - | OPP. WPL# 370(ABOVE ST.CLEANING SIGN) | - | - | - | - | - | 119754 | 1486478280000 | -122.46324684 | 37.74516186 | - | 1486425600000 | - | D7 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1485350460000 | MAGELLAN AVE | 301 - 399 MAGELLAN AVE | 301 - 399 MAGELLAN AVE | 301 MAGELLAN AVE | - | MONTALVO AVE | MONTALVO AVE |
| 102472 | N/A | Point | 1 | 1 | 400 - 499 | - | S230129 | 400-499 HEARST AVE | 400-499 HEARST AVE | F | F | - | F | 6865000 | 6865000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | EDNA ST | EDNA ST | 67108 | 67108 | 37.73069472 | -122.44771697 | - | - | 1710539427000 | MTA | SPEED HUMPS | EDNA ST to FOERSTER ST (400 - 499) | - | 45`WEST | - | - | - | - | - | 119755 | 1106265600000 | -122.44771697 | 37.73069472 | - | 1480550400000 | - | D7 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1477388340000 | HEARST AVE | 400 - 499 HEARST AVE | 400 - 499 HEARST AVE | 400 HEARST AVE | - | FOERSTER ST | FOERSTER ST |
| 102473 | N/A | Point | 1 | 1 | 1 - 99 | - | S232060 | 1-99 CURTIS ST | 1-99 CURTIS ST | F | F | - | F | 4552000 | 4552000 | - | - | SOUTH SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | ROLPH ST | ROLPH ST | 69347 | 69347 | 37.71410889 | -122.43989364 | - | - | 1720663596000 | middleware_editor | SPEED HUMPS | ROLPH ST to MORSE ST (1 - 99) | - | EPL#24 | - | - | - | - | - | 119756 | 1486380120000 | -122.43989364 | 37.71410889 | - | 1486339200000 | - | D11 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1482913200000 | CURTIS ST | 1 - 99 CURTIS ST | 1 - 99 CURTIS ST | 1 CURTIS ST | - | MORSE ST | MORSE ST |
| 102474 | N/A | Point | - | 1 | 200 - 299 | - | S230393 | 1700-1799 JOHN F KENNEDY DR (G | 200-299 CHAIN OF LAKES DR | F | F | - | F | 3883000 | 3883000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | JOHN F KENNEDY DR | JOHN F KENNEDY DR | 64961 | 64961 | 37.76716112 | -122.50019662 | - | - | 1710539427000 | MTA | SPEED HUMPS | JOHN F KENNEDY DR to GGP ACCESS ROAD (200 - 299) | - | 30`EAST | - | - | - | - | - | 119757 | 57283200000 | -122.50019662 | 37.76716112 | - | 1477872000000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1477655400000 | CHAIN OF LAKES DR | 1700-1799 JOHN F KENNEDY DR (G | 200 - 299 CHAIN OF LAKES DR | - | - | GGP ACCESS ROAD | GGP ACCESS ROAD |
| 102475 | N/A | Point | 1 | 1 | 1 - 296 | - | S234825 | 1-279 ADDISON ST | 1-296 ADDISON ST | F | F | - | F | 2093000 | 2093000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | BEMIS ST | BEMIS ST | 66936 | 66936 | 37.73827069 | -122.43213109 | - | - | 1712627274000 | middleware_editor | SPEED HUMPS | BEMIS ST to DIGBY ST (1 - 296) | - | IFO #24 | - | - | - | - | - | 119758 | 1278374400000 | -122.43213109 | 37.73827069 | - | 1495152000000 | - | D8 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1491222420000 | ADDISON ST | 1 - 296 ADDISON ST | 1 - 296 ADDISON ST | 1 ADDISON ST | - | DIGBY ST | DIGBY ST |
| 102476 | N/A | Point | 1 | 1 | 1 - 99 | - | S236567 | 1-99 MARSILY ST | 1-99 MARSILY ST | F | F | - | F | 8781000 | 8781000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | SAINT MARYS AVE | SAINT MARYS AVE | 119030 | 119030 | 37.73405946 | -122.42767314 | - | - | 1710539427000 | MTA | SPEED HUMPS | SAINT MARYS AVE to BOSWORTH ST (1 - 99) | - | 5FT.NORTH OF BOSWORTH | - | - | - | - | - | 119759 | 1497960000000 | -122.42767314 | 37.73405946 | - | 1497916800000 | - | D8 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1496331060000 | MARSILY ST | 1 - 99 MARSILY ST | 1 - 99 MARSILY ST | 1 MARSILY ST | - | BOSWORTH ST | BOSWORTH ST |
| 102477 | N/A | Point | 1 | 1 | 900 - 955 | - | S231583 | 900-955 CAYUGA AVE | 900-955 CAYUGA AVE | F | F | - | F | 3832000 | 3832000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | OCEAN AVE | OCEAN AVE | 66668 | 66668 | 37.723399318 | -122.439004218 | - | - | 1710539427000 | MTA | SPEED HUMPS | OCEAN AVE to VALERTON CT (900 - 955) | - | 50`SOUTH | - | - | - | - | - | 119760 | 1482398580000 | -122.43907932 | 37.72316736 | - | 1482364800000 | - | D11 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1481107320000 | CAYUGA AVE | 900 - 955 CAYUGA AVE | 900 - 955 CAYUGA AVE | 900 CAYUGA AVE | - | VALERTON CT | VALERTON CT |
| 102478 | N/A | Point | 1 | 1 | 800 - 899 | - | S230980 | 800-899 SHOTWELL ST | 800-899 SHOTWELL ST | F | F | - | F | 11840000 | 11840000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 22ND ST | 22ND ST | 65595 | 65595 | 37.75483383 | -122.41539671 | - | - | 1710539427000 | MTA | SPEED HUMPS | 22ND ST to 23RD ST (800 - 899) | - | AT SPL# 814 | - | - | - | - | - | 119761 | 1481020440000 | -122.41539671 | 37.75483383 | - | 1480982400000 | - | D9 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1479203700000 | SHOTWELL ST | 800 - 899 SHOTWELL ST | 800 - 899 SHOTWELL ST | 800 SHOTWELL ST | - | 23RD ST | 23RD ST |
| 102479 | N/A | Point | - | 1 | 1 - 99 | - | S230359 | 1000-1299 JOHN F KENNEDY DR (G | 1-99 OVERLOOK DR | F | F | - | F | 10063000 | 10063000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | TRANSVERSE DR | TRANSVERSE DR | 66433 | 66433 | 37.76915207 | -122.48242928 | - | - | 1710539427000 | MTA | SPEED HUMPS | TRANSVERSE DR to MIDDLE WEST DR (1 - 99) | - | 150`EAST OF SPEED HUMPS EAST OF 30TH AVE | - | - | - | - | - | 119762 | 57283200000 | -122.48242928 | 37.76915207 | - | 1477958400000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1477650120000 | OVERLOOK DR | 1000-1299 JOHN F KENNEDY DR (G | 1 - 99 OVERLOOK DR | - | - | MIDDLE WEST DR | MIDDLE WEST DR |
| 102480 | N/A | Point | - | - | - | - | S100540 | FUNSTON AVE: TARAVAL ST | - | F | F | - | F | 22987000 | 22987000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TARAVAL ST | FUNSTON AVE | 127507 | 127507 | 37.74333608 | -122.46916505 | FUNSTON AVE \ TARAVAL ST | TARAVAL ST \ FUNSTON AVE | 1710539427000 | MTA | STOP | FUNSTON AVE intersection | - | 0 / 0 | - | - | - | - | - | 119763 | -403660800000 | -122.46916505 | 37.74333608 | - | 1555977600000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566500000 | TARAVAL ST | - | - | - | - | - | - |
| 102481 | N/A | Point | - | - | - | - | S114736 | FUNSTON AVE: TARAVAL ST | - | F | F | - | F | 22987000 | 22987000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TARAVAL ST | FUNSTON AVE | 12259 | 12259 | 37.74333608 | -122.46916505 | FUNSTON AVE \ TARAVAL ST | TARAVAL ST \ FUNSTON AVE | 1710539427000 | MTA | DEAD END | FUNSTON AVE intersection | - | - | - | - | - | - | - | 119764 | 1014681600000 | -122.46916505 | 37.74333608 | - | - | - | D7 | - | OTHER WARNING | WARNING | W14-1.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | 1373572140000 | TARAVAL ST | - | - | - | - | - | - |
| 102482 | N/A | Point | - | - | - | - | S275757 | TARAVAL ST: FUNSTON AVE | - | T | T | - | F | 22987000 | 22987000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | FUNSTON AVE | 119720 | 119720 | 37.74333608 | -122.46916505 | FUNSTON AVE \ TARAVAL ST | TARAVAL ST \ FUNSTON AVE | 1710539427000 | MTA | SCHOOL (SYM)/ 45 LEFT DN ARROW (COMBO) | FUNSTON AVE intersection | - | - | - | - | - | - | - | 119765 | 1129593600000 | -122.46916505 | 37.74333608 | - | 1676332800000 | - | D7 | - | SCHOOL | WARNING | SW24-2(CA).0001 | 30X42 | SUP2 | LIGHT POLE | IS | 1624615320000 | TARAVAL ST | - | - | - | - | - | - |
| 102483 | N/A | Point | - | - | - | - | S275755 | TARAVAL ST: FUNSTON AVE | - | F | F | - | F | 22987000 | 22987000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | FUNSTON AVE | 119719 | 119719 | 37.74333608 | -122.46916505 | FUNSTON AVE \ TARAVAL ST | TARAVAL ST \ FUNSTON AVE | 1710539427000 | MTA | SCHOOL (SYM)/ 45 LEFT DN ARROW (COMBO) | FUNSTON AVE intersection | - | - | - | - | - | - | - | 119766 | 1129593600000 | -122.46916505 | 37.74333608 | - | 1632268800000 | - | D7 | - | SCHOOL | WARNING | SW24-2(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1624615200000 | TARAVAL ST | - | - | - | - | - | - |
| 102484 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S150987 | 1300-1399 32ND AVE | 1300-1399 32ND AVE | F | F | - | F | 1708000 | 1708000 | - | - | EAST SIDE | - | - | - | - | IRVING ST | IRVING ST | 42852 | 42852 | 37.76201744 | -122.49098822 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM 1ST & 3RD FRI OF MONTH STCL | IRVING ST to JUDAH ST (1300 - 1399) | - | 1376 32ND AVE | - | - | - | - | - | 119767 | 1228694400000 | -122.49098822 | 37.76201744 | - | - | - | D4 | - | STREET CLEANING | REG | R30(CA).0035 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375730040000 | 32ND AVE | 1300 - 1399 32ND AVE | 1300 - 1399 32ND AVE | 1300 32ND AVE | - | JUDAH ST | JUDAH ST |
| 102485 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S150156 | 1300-1399 32ND AVE | 1300-1399 32ND AVE | F | F | - | F | 1708000 | 1708000 | - | - | WEST SIDE | - | - | - | - | IRVING ST | IRVING ST | 38214 | 38214 | 37.76201744 | -122.49098822 | - | - | 1733268747000 | middleware_editor | NPRK 9AM-11AM 1ST & 3RD TUE OF MONTH STCL | IRVING ST to JUDAH ST (1300 - 1399) | - | 169 FEET SOUTH OF IRVING | - | - | - | - | - | 119768 | 1228176000000 | -122.49098822 | 37.76201744 | - | 1733225100000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0288 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375729620000 | 32ND AVE | 1300 - 1399 32ND AVE | 1300 - 1399 32ND AVE | 1300 32ND AVE | - | JUDAH ST | JUDAH ST |
| 102486 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S150988 | 1300-1399 32ND AVE | 1300-1399 32ND AVE | F | F | - | F | 1708000 | 1708000 | - | - | EAST SIDE | - | - | - | - | IRVING ST | IRVING ST | 42853 | 42853 | 37.76201744 | -122.49098822 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM 1ST & 3RD FRI OF MONTH STCL | IRVING ST to JUDAH ST (1300 - 1399) | - | 1354 32ND AVE | - | - | - | - | - | 119769 | 1228694400000 | -122.49098822 | 37.76201744 | - | - | - | D4 | - | STREET CLEANING | REG | R30(CA).0035 | 18X18 | SUP2 | UTILITY POLE | IS | 1375730040000 | 32ND AVE | 1300 - 1399 32ND AVE | 1300 - 1399 32ND AVE | 1300 32ND AVE | - | JUDAH ST | JUDAH ST |
| 102487 | N/A | Point | - | - | - | - | S273476 | ASHBURY ST: HAIGHT ST | - | F | F | - | F | 2513000 | 26338000 | - | - | SOUTH WEST CORNER | - | - | - | - | HAIGHT ST | ASHBURY ST | 100497 | 100497 | 37.77000761 | -122.44693382 | - | HAIGHT ST \ ASHBURY ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | ASHBURY ST intersection | - | 28' S OF S CROSSWALK | - | - | - | - | - | 119770 | - | -122.44693382 | 37.77000761 | - | - | - | D5 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | INTERSTATE BASE | IS | 1616506080000 | HAIGHT ST | 600 - 699 ASHBURY ST | - | - | - | WALLER ST | - |
| 102488 | N/A | Point | 1 | 1 | 100 - 199 | - | S201961 | 100-199 TALBERT ST | 100-199 TALBERT ST | F | F | - | F | 12370000 | 12370000 | - | - | WEST SIDE | - | - | - | - | VISITACION AVE | VISITACION AVE | 46187 | 46187 | 37.71014401 | -122.40647048 | - | - | 1722978591000 | middleware_editor | NPRK 8AM-11AM MON STCL | VISITACION AVE to SUNNYDALE AVE (100 - 199) | - | SPL #180 | - | - | - | - | - | 119771 | - | -122.40647048 | 37.71014401 | - | 1722953340000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0275 | 18X18 | SUP1 | 2IN IRON POST | IS | 1389344760000 | TALBERT ST | 100 - 199 TALBERT ST | 100 - 199 TALBERT ST | 100 TALBERT ST | - | SUNNYDALE AVE | SUNNYDALE AVE |
| 102489 | N/A | Point | 1 | 1 | 2100 - 2131 | - | S200454 | 2100-2131 MISSION ST | 2100-2131 MISSION ST | F | F | - | F | 9117000 | 9117000 | - | - | WEST SIDE | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | 17TH ST | 17TH ST | 127883 | 127883 | 37.76324006 | -122.41949451 | - | - | 1717681111000 | middleware_editor | BIKE CORRAL (SEE NOTES FOR CONFIGURATION) | 17TH ST to CLARION ALY (2100 - 2131) | - | IFO #2140 | - | - | - | - | - | 119772 | 1386932640000 | -122.41949451 | 37.76324006 | - | 1386892800000 | - | D9 | - | BIKE | MISC | BIKE-CORRAL | N/A | SUP2 | 2IN IRON POST | IS | 1384779480000 | MISSION ST | 2100 - 2131 MISSION ST | 2100 - 2131 MISSION ST | 2100 MISSION ST | - | CLARION ALY | CLARION ALY |
| 102490 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S205103 | 1300-1399 HAIGHT ST | 1300-1399 HAIGHT ST | F | F | - | F | 6617000 | 6617000 | - | - | NORTH SIDE | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | CENTRAL AVE | CENTRAL AVE | 45183 | 45183 | 37.77031827 | -122.44449704 | - | - | 1710539427000 | MTA | BIKE CORRAL (SEE NOTES FOR CONFIGURATION) | CENTRAL AVE to MASONIC AVE (1300 - 1399) | - | FROM 11'-6" TO 25' EAST OF MASONIC | - | - | - | - | - | 119773 | 1400857200000 | -122.44449704 | 37.77031827 | - | 1400803200000 | - | D5 | - | BIKE | MISC | BIKE-CORRAL | N/A | SUP1 | BARRICADE | IS | 1398193560000 | HAIGHT ST | 1300 - 1399 HAIGHT ST | 1300 - 1399 HAIGHT ST | 1300 HAIGHT ST | - | MASONIC AVE | MASONIC AVE |
| 102491 | N/A | Point | - | 1 | 980 - 999 | - | S200365 | 980-999 BRYANT ST | 980-999 BRYANT ST | F | F | - | F | 3296001 | 3296001 | - | - | SOUTH SIDE | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | I-80 E ON RAMP | I-80 E ON RAMP | 45320 | 45320 | 37.77267568 | -122.40677929 | - | - | 1710539427000 | MTA | BIKE CORRAL (SEE NOTES FOR CONFIGURATION) | I-80 E ON RAMP to 08TH ST (980 - 999) | - | INFO #739 | - | - | - | - | - | 119774 | 1387461120000 | -122.40677929 | 37.77267568 | - | 1387411200000 | - | 06 | - | BIKE | MISC | BIKE-CORRAL | N/A | SUP1 | 2IN IRON POST | IS | 1384424160000 | BRYANT ST | 980 - 999 BRYANT ST | 980 - 999 BRYANT ST | 980 BRYANT ST | - | 08TH ST | 08TH ST |
| 102492 | N/A | Point | 1 | 1 | 3000 - 3037 | - | S207985 | 3000-3037 16TH ST | 3000-3037 16TH ST | F | F | - | F | 726000 | 726000 | - | - | SOUTH SIDE | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | MISSION ST | MISSION ST | 51120 | 51120 | 37.76502677 | -122.42007573 | - | - | 1710539427000 | MTA | BIKE CORRAL (SEE NOTES FOR CONFIGURATION) | MISSION ST to WIESE ST (3000 - 3037) | - | WPL #2973/CROSS ST IS CAPP ST | - | - | - | - | - | 119775 | - | -122.42007573 | 37.76502677 | - | - | - | D9 | - | BIKE | MISC | BIKE-CORRAL | N/A | SUP2 | 2IN IRON POST | IS | 1406708640000 | 16TH ST | 3000 - 3037 16TH ST | 3000 - 3037 16TH ST | 3000 16TH ST | - | WIESE ST | WIESE ST |
| 102493 | N/A | Point | 1 | 1 | 3000 - 3037 | - | S207986 | 3000-3037 16TH ST | 3000-3037 16TH ST | F | F | - | F | 726000 | 726000 | - | - | SOUTH SIDE | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | MISSION ST | MISSION ST | 51121 | 51121 | 37.76502677 | -122.42007573 | - | - | 1710539427000 | MTA | BIKE CORRAL (SEE NOTES FOR CONFIGURATION) | MISSION ST to WIESE ST (3000 - 3037) | - | INFO #2973/CROSS ST IS CAPP ST | - | - | - | - | - | 119776 | 1406902680000 | -122.42007573 | 37.76502677 | - | 1406851200000 | - | D9 | - | BIKE | MISC | BIKE-CORRAL | N/A | SUP2 | 2IN IRON POST | IS | 1406708700000 | 16TH ST | 3000 - 3037 16TH ST | 3000 - 3037 16TH ST | 3000 16TH ST | - | WIESE ST | WIESE ST |
| 102494 | N/A | Point | - | - | - | - | S107986 | HURON AVE: SICKLES AVE | - | F | F | - | F | 21581000 | 21581000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HURON AVE | SICKLES AVE | 130059 | 130059 | 37.70916687 | -122.45324912 | SICKLES AVE \ HURON AVE | HURON AVE \ SICKLES AVE | 1710539427000 | MTA | ONE WAY (LA) | SICKLES AVE intersection | - | 0 / MADE HURON ONE-WAY SB BETSICKLE..... | - | - | - | - | - | 119777 | 271900800000 | -122.45324912 | 37.70916687 | - | - | - | D11 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | MUNI POLE | IS | 1373570040000 | HURON AVE | - | - | - | - | - | - |
| 102495 | N/A | Point | - | - | - | - | S105619 | HURON AVE: SICKLES AVE | - | F | F | - | F | 21581000 | 21581000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HURON AVE | SICKLES AVE | 105248 | 105248 | 37.70916687 | -122.45324912 | SICKLES AVE \ HURON AVE | HURON AVE \ SICKLES AVE | 1710539427000 | MTA | STOP | SICKLES AVE intersection | - | - | - | - | - | - | - | 119778 | 90547200000 | -122.45324912 | 37.70916687 | - | 1663113600000 | 1675123200000 | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | RETD | 1373569260000 | HURON AVE | - | - | - | - | - | - |
| 102496 | N/A | Point | - | - | - | - | 24731 | - | - | F | T | - | F | - | - | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | 1697730940000 | mmendiet | - | - | - | - | 163522 | 163522 | 37.7287367224831 | -122.434328246303 | - | - | 1722531702000 | middleware_editor | THERESA | - | - | OVERHEAD MAST ARM SIGNAL POLE. | - | - | - | - | - | 119779 | - | - | - | - | - | - | 11 | - | STREET NAME | GUIDE | D3-2.0503 | 72X18 | SUP3 | SIGNAL POLE | IS | - | - | - | - | - | - | - | - |
| 102497 | N/A | Point | - | - | - | - | 24732 | - | - | F | F | - | F | 7111000 | - | - | - | WEST SIDE | 1697732920000 | jsanfel | - | - | SICKLES AVE | - | 163523 | 163523 | 37.7085712959516 | -122.454086687957 | - | - | 1722531702000 | middleware_editor | NPRK 8AM-10AM THUR STCL | - | - | SPL 1062 | - | - | - | - | - | 119780 | - | - | - | - | - | - | 11 | - | STREET CLEANING | REG | R30B(CA).0267 | 18X18 | SUP3 | LIGHT POLE | IS | - | HURON AVE | 1000 - 1099 HURON AVE | - | - | - | MISSION ST | - |
| 102498 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S128137 | 2000-2099 BEACH ST | 2000-2099 BEACH ST | F | F | - | F | 2856000 | 2856000 | - | - | SOUTH SIDE | - | - | - | - | SCOTT ST | SCOTT ST | 79398 | 79398 | 37.80381073 | -122.44277106 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "M" PERMITS | SCOTT ST to DIVISADERO ST (2000 - 2099) | - | OPPOSITE # 2064 | - | - | - | - | - | 119781 | 1194220800000 | -122.44277106 | 37.80381073 | - | - | - | D2 | - | PARKING:RPP | REG | R32C(CA).0096 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373576340000 | BEACH ST | 2000 - 2099 BEACH ST | 2000 - 2099 BEACH ST | 2000 BEACH ST | - | DIVISADERO ST | DIVISADERO ST |
| 102499 | N/A | Point | 1 | 1 | 1 - 99 | - | S214535 | 1-99 SANTA ROSA AVE | 1-99 SANTA ROSA AVE | F | F | - | F | 11589000 | 11589000 | - | - | SOUTH SIDE | - | - | - | - | MISSION ST | MISSION ST | 118936 | 118936 | 37.725853518 | -122.434247566 | - | - | 1710539427000 | MTA | NPRK 7AM-9AM MON STCL | MISSION ST to ALEMANY BLVD (1 - 99) | - | 45`WEST IFO 5 | - | - | - | - | - | 119782 | 1450778340000 | -122.43498665 | 37.72624051 | - | 1694012400000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0237 | 18X18 | SUP2 | 2IN IRON POST | IS | 1427276040000 | SANTA ROSA AVE | 1 - 99 SANTA ROSA AVE | 1 - 99 SANTA ROSA AVE | 1 SANTA ROSA AVE | - | ALEMANY BLVD | ALEMANY BLVD |
| 102500 | N/A | Point | - | - | - | - | 25549 | - | - | F | F | - | F | 12082000 | - | - | - | NORTH SIDE | 1701284041000 | malopez | - | - | MCALLISTER ST | - | 171868 | 171868 | 37.7757037308281 | -122.453851282106 | - | - | 1747255360000 | middleware_editor | NPRK 8AM-10AM FRI STCL | - | - | WPL 2538 | - | - | - | - | - | 119783 | - | - | - | - | - | - | 01 | - | STREET CLEANING | REG | R30B(CA).0259 | 18X18 | SUP2 | 2IN IRON POST | IS | - | - | 277 - 299 STANYAN ST | - | - | - | MCALLISTER ST | - |
| 102501 | N/A | Point | - | - | - | - | 25489 | - | - | F | F | - | F | 13720000 | - | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | 1701191099000 | mmendiet | - | - | EUGENIA AVE | - | 171521 | 171521 | 37.7392106331468 | -122.417180557509 | - | - | 1710539427000 | MTA | STOP | - | - | NWCORNER | - | - | - | - | - | 119784 | - | - | - | - | 1701852420000 | - | 09 | - | STOP | REG | R1-1.0002 | 30X30 | SUP3 | 2IN IRON POST | IS | - | WOOL ST | 100 - 199 WOOL ST | - | - | - | CORTLAND AVE | - |
| 102502 | N/A | Point | - | - | - | - | S111693 | CLAY ST: LOCUST ST | - | F | F | - | F | 26940000 | 26940000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CLAY ST | CLAY ST | 12338 | 12338 | 37.78843749 | -122.45212644 | LOCUST ST \ CLAY ST | LOCUST ST \ CLAY ST | 1710539427000 | MTA | STOP | CLAY ST intersection | - | - | - | - | - | - | - | 119785 | 842227200000 | -122.45212644 | 37.78843749 | - | 1592265600000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373571180000 | LOCUST ST | - | - | - | - | - | - |
| 102503 | N/A | Point | - | - | - | - | S125412 | CLAY ST: LOCUST ST | - | F | F | - | F | 26940000 | 26940000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CLAY ST | CLAY ST | 20904 | 20904 | 37.78843749 | -122.45212644 | LOCUST ST \ CLAY ST | LOCUST ST \ CLAY ST | 1710539427000 | MTA | ALL WAY | CLAY ST intersection | - | - | - | - | - | - | - | 119786 | 1157068800000 | -122.45212644 | 37.78843749 | - | 1592265600000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | LIGHT POLE | IS | 1373575500000 | LOCUST ST | - | - | - | - | - | - |
| 102504 | N/A | Point | - | - | - | - | S125484 | LOCUST ST: CLAY ST | - | F | F | - | F | 26940000 | 26940000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CLAY ST | CLAY ST | 21876 | 21876 | 37.78843749 | -122.45212644 | LOCUST ST \ CLAY ST | LOCUST ST \ CLAY ST | 1710539427000 | MTA | ALL WAY | CLAY ST intersection | - | - | - | - | - | - | - | 119787 | 1157587200000 | -122.45212644 | 37.78843749 | - | 1510704000000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575500000 | LOCUST ST | - | - | - | - | - | - |
| 102505 | N/A | Point | - | - | - | - | S276492 | CLAY ST: LOCUST ST | - | F | F | - | F | 26940000 | 26940000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CLAY ST | CLAY ST | 108916 | 108916 | 37.78843749 | -122.45212644 | LOCUST ST \ CLAY ST | LOCUST ST \ CLAY ST | 1710539427000 | MTA | SLOW STREETS FAMILY, H/C, PED, SKATEBOARD, BIKE (SYM)(COMBO) | CLAY ST intersection | - | 9FT AND 14 " 9 FROM CURB | - | - | - | - | - | 119788 | 1583884800000 | -122.45212644 | 37.78843749 | - | 1703081820000 | - | D2 | - | OTHER REGULATORY | REG | R(SF).0451 | 12X36 | SUP1 | CITY POST EMBEDDED ACHOR CUP 4 | IS | 1627305000000 | LOCUST ST | - | - | - | - | - | - |
| 102506 | N/A | Point | - | - | - | - | S125451 | CLAY ST: LAUREL ST | - | F | F | - | F | 26921000 | 26921000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CLAY ST | CLAY ST | 17538 | 17538 | 37.78864713 | -122.45048025 | LAUREL ST \ CLAY ST | LAUREL ST \ CLAY ST | 1710539427000 | MTA | ALL WAY | CLAY ST intersection | - | - | - | - | - | - | - | 119789 | 1157500800000 | -122.45048025 | 37.78864713 | - | 1542067200000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | LIGHT POLE | IS | 1373575500000 | LAUREL ST | - | - | - | - | - | - |
| 102507 | N/A | Point | - | - | - | - | S120547 | - | - | F | F | - | F | 11951102 | - | - | - | SOUTH SIDE | 1689201376000 | MTA | - | - | 20TH AVE | - | 131833 | 131833 | 37.73471185 | -122.47610274 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM WED STCL | - | - | 15`WEST | - | - | - | - | - | 119790 | 1110240000000 | - | - | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP2 | 2IN IRON POST | IS | - | - | 401 - 499 SLOAT BLVD | - | - | - | 21ST AVE | - |
| 102508 | N/A | Point | - | - | - | - | S250601 | - | - | F | F | - | F | 11952201 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | 21ST AVE | - | 132071 | 132071 | 37.73471185 | -122.47610274 | - | - | 1710539427000 | MTA | BIKE WAYFINDING SIGN | - | 0342 | 86' E OF 21ST AVE | - | - | - | - | - | 119791 | 1546939980000 | - | - | - | - | - | D7 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | 2IN IRON POST | IS | - | - | 500 - 698 SLOAT BLVD | - | - | - | 23RD AVE \ CRESTLAKE DR | - |
| 102509 | N/A | Point | - | - | - | - | S288293 | - | - | F | F | - | F | 11952201 | - | - | - | NORTH SIDE | 1689201376000 | MTA | - | - | 21ST AVE | - | 131629 | 131629 | 37.73453386 | -122.477512 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM WED STCL | - | - | OPP. 555 SLOAT UNDER MERGE LEFT (SYM) | - | - | - | - | - | 119792 | - | - | - | - | 1680652800000 | - | D7 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP2 | LIGHT POLE | IS | - | - | 500 - 698 SLOAT BLVD | - | - | - | 23RD AVE \ CRESTLAKE DR | - |
| 102510 | N/A | Point | - | - | - | - | S120608 | - | - | F | F | - | F | - | - | - | - | SOUTH SIDE | 1689201376000 | MTA | - | - | - | - | 131337 | 131337 | 37.73454984 | -122.47663665 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "H" PERMITS | - | - | 20`EAST OF 21ST AVE | - | - | - | - | - | 119793 | 1110931200000 | - | - | - | - | - | D7 | - | PARKING:RPP | REG | R32C(CA).0088 | 18X21 | SUP2 | 2IN IRON POST | IS | - | - | - | - | - | - | - | - |
| 102511 | N/A | Point | - | - | - | - | S221037 | BROADWAY: POWELL ST \ ROBERT C | - | F | F | - | F | 3186201 | 25111000 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | BROADWAY \ POWELL ST | BROADWAY \ POWELL ST | 112831 | 112831 | 37.79742019 | -122.41026353 | - | ROBERT C LEVY TUNL \ BROADWAY \ POWELL ST | 1710539427000 | MTA | KEEP RIGHT (SYM) | BROADWAY \ POWELL ST intersection | - | THUMBNAIL AT WEST LINE OF POWELL ST. | - | - | - | - | - | 119794 | 1476921600000 | -122.41026353 | 37.79742019 | - | 1533081600000 | - | D3 | - | OTHER REGULATORY | REG | R4-7A.0002 | 24X30 | SUP1 | 2IN IRON POST | IS | 1449068280000 | ROBERT C LEVY TUNL | 0 - 0 ROBERT C LEVY TUNL | - | - | - | BROADWAY \ LARKIN ST | - |
| 102512 | N/A | Point | - | - | - | - | S247346 | BROADWAY: POWELL ST \ ROBERT C | - | T | T | - | F | 12753000 | 25111000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | - | BROADWAY \ POWELL ST | 77684 | 77684 | 37.79742019 | -122.41026353 | - | ROBERT C LEVY TUNL \ BROADWAY \ POWELL ST | 1710539427000 | MTA | NO U TURN (SYM) | BROADWAY \ POWELL ST intersection | - | OF BROADWAY & POWELL | - | - | - | - | - | 119795 | 1532698860000 | -122.41026353 | 37.79742019 | - | - | - | D3 | - | OTHER REGULATORY | REG | R3-4.0002 | 30X30 | SUP1 | OVERHEAD MAST ARM | IS | 1532684880000 | ROBERT C LEVY TUNL | - | - | - | - | - | - |
| 102513 | N/A | Point | - | - | - | - | S263248 | BROADWAY: POWELL ST \ ROBERT C | - | T | T | - | F | 25111000 | 25111000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BROADWAY \ ROBERT C LEVY TUNL | BROADWAY \ POWELL ST | 105846 | 105846 | 37.79742019 | -122.41026353 | POWELL ST \ BROADWAY \ ROBERT C LEVY TUNL | ROBERT C LEVY TUNL \ BROADWAY \ POWELL ST | 1729110541000 | middleware_editor | SCHOOL (SYM)/SCHOOL | BROADWAY \ POWELL ST intersection | 112653 | - | - | - | - | - | - | 119796 | - | -122.41026353 | 37.79742019 | - | - | 1729085280000 | D3 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP1 | LIGHT POLE | RETD | 1586355720000 | ROBERT C LEVY TUNL | - | - | - | - | - | - |
| 102514 | N/A | Point | - | - | - | - | S223261 | BROADWAY: POWELL ST \ ROBERT C | - | T | T | - | F | 3186101 | 25111000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BROADWAY \ POWELL ST | BROADWAY \ POWELL ST | 105938 | 105938 | 37.79742019 | -122.41026353 | - | ROBERT C LEVY TUNL \ BROADWAY \ POWELL ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | BROADWAY \ POWELL ST intersection | - | OF BROADWAY & POWELL | - | - | - | - | - | 119797 | 1532698740000 | -122.41026353 | 37.79742019 | - | - | - | D3 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1455012840000 | ROBERT C LEVY TUNL | 0 - 0 ROBERT C LEVY TUNL | - | - | - | BROADWAY \ LARKIN ST | - |
| 102515 | N/A | Point | - | - | - | - | S247493 | BROADWAY: POWELL ST \ ROBERT C | - | T | T | - | F | 3186201 | 25111000 | - | - | CENTER ISLAND, E LINE, EASTBOUND | - | - | - | - | BROADWAY \ POWELL ST | BROADWAY \ POWELL ST | 80917 | 80917 | 37.79742019 | -122.41026353 | - | ROBERT C LEVY TUNL \ BROADWAY \ POWELL ST | 1710539427000 | MTA | SIGNAL AHEAD (SYM) | BROADWAY \ POWELL ST intersection | - | 5FT IN TUNNEL | - | - | - | - | - | 119798 | 1532649600000 | -122.41026353 | 37.79742019 | - | 1533168000000 | - | D3 | - | OTHER WARNING | WARNING | W3-3.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1533202020000 | ROBERT C LEVY TUNL | 0 - 0 ROBERT C LEVY TUNL | - | - | - | BROADWAY \ LARKIN ST | - |
| 102516 | N/A | Point | - | - | - | - | S247374 | BROADWAY: POWELL ST \ ROBERT C | - | F | F | - | F | 3186201 | 25111000 | - | - | CENTER ISLAND, N LINE, WESTBOUND | - | - | - | - | BROADWAY \ POWELL ST | BROADWAY \ POWELL ST | 77962 | 77962 | 37.79742019 | -122.41026353 | - | ROBERT C LEVY TUNL \ BROADWAY \ POWELL ST | 1710539427000 | MTA | (45 LA-DN/45 RA-DN) (SYM) | BROADWAY \ POWELL ST intersection | - | 200FT WEST OF POWELL | - | - | - | - | - | 119799 | 1532649600000 | -122.41026353 | 37.79742019 | - | 1624924800000 | - | D3 | - | OTHER WARNING | WARNING | W12-1.0001 | 24X24 | SUP1 | 2IN IRON POST | IS | 1532701200000 | ROBERT C LEVY TUNL | 0 - 0 ROBERT C LEVY TUNL | - | - | - | BROADWAY \ LARKIN ST | - |
| 102517 | N/A | Point | - | - | - | - | S234956 | BROADWAY: POWELL ST \ ROBERT C | - | T | T | - | F | - | 25111000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | - | BROADWAY \ POWELL ST | 126979 | 126979 | 37.79742019 | -122.41026353 | - | ROBERT C LEVY TUNL \ BROADWAY \ POWELL ST | 1710539427000 | MTA | "P" (WHITE-BLUE) | BROADWAY \ POWELL ST intersection | - | CROSS ST IS POWELL | - | - | - | - | - | 119800 | 1497013140000 | -122.41026353 | 37.79742019 | - | 1496966400000 | - | D3 | - | OTHER GUIDE | GUIDE | G-P(SF).0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1491483960000 | ROBERT C LEVY TUNL | - | - | - | - | - | - |
| 102518 | N/A | Point | - | - | - | - | S234955 | POWELL ST: BROADWAY \ ROBERT C | - | T | T | - | F | 25111000 | 25111000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BROADWAY \ ROBERT C LEVY TUNL | BROADWAY \ POWELL ST | 70692 | 70692 | 37.79742019 | -122.41026353 | POWELL ST \ BROADWAY \ ROBERT C LEVY TUNL | ROBERT C LEVY TUNL \ BROADWAY \ POWELL ST | 1744122159000 | middleware_editor | "P" (WHITE-BLUE) | BROADWAY \ POWELL ST intersection | - | CROSS ST IS BROADWAY ST | - | - | - | - | - | 119801 | 1496958660000 | -122.41026353 | 37.79742019 | - | 1496905200000 | - | D3 | - | OTHER GUIDE | GUIDE | G-P(SF).0001 | 30X30 | SUP1 | SIGNAL POLE | IS | 1491483120000 | ROBERT C LEVY TUNL | - | - | - | - | - | - |
| 102519 | N/A | Point | - | - | - | - | S234817 | BROADWAY: POWELL ST \ ROBERT C | - | F | F | - | F | - | 25111000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | - | BROADWAY \ POWELL ST | 110775 | 110775 | 37.79742019 | -122.41026353 | - | ROBERT C LEVY TUNL \ BROADWAY \ POWELL ST | 1710539427000 | MTA | (LA) NORTH BEACH GARAGE | BROADWAY \ POWELL ST intersection | - | CROSS ST IS POWELL | - | - | - | - | - | 119802 | 1497013080000 | -122.41026353 | 37.79742019 | - | 1496966400000 | - | D3 | - | OTHER GUIDE | GUIDE | G-P(SF).0141 | 30X30 | SUP1 | LIGHT POLE | IS | 1491217740000 | ROBERT C LEVY TUNL | - | - | - | - | - | - |
| 102520 | N/A | Point | 1 | 1 | 200 - 230 | - | S204930 | 200-230 FILLMORE ST | 200-230 FILLMORE ST | F | F | - | F | 5532000 | 5532000 | - | - | EAST SIDE | - | - | - | - | WALLER ST | WALLER ST | 45066 | 45066 | 37.77140675 | -122.43030768 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | WALLER ST to LAUSSAT ST (200 - 230) | - | IFO# 232 | - | - | - | - | - | 119803 | 993772800000 | -122.43030768 | 37.77140675 | - | 1398384000000 | - | D5 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP1 | MUNI POLE | IS | 1397644800000 | FILLMORE ST | 200 - 230 FILLMORE ST | 200 - 230 FILLMORE ST | 200 FILLMORE ST | - | LAUSSAT ST | LAUSSAT ST |
| 102521 | N/A | Point | - | - | - | - | S230416 | JOHN F KENNEDY DR: 47TH AVE \ | - | F | F | - | F | 27967000 | 27967000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GOLF COURSE ACCESS RD \ JOHN F KENNEDY DR | 47TH AVE \ GOLF COURSE ACCESS RD | 64971 | 64971 | 37.7693662784536 | -122.508296817536 | 47TH AVE \ GOLF COURSE ACCESS RD \ JOHN F KENNEDY DR | JOHN F KENNEDY DR \ 47TH AVE \ GOLF COURSE ACCESS RD | 1741622060000 | jsanfel | SPEED HUMPS | 47TH AVE \ GOLF COURSE ACCESS RD intersection | - | IFO WINDMILL | - | - | - | - | - | 119804 | 57308400000 | -122.50827667 | 37.76923392 | - | 1477897200000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1477660680000 | JOHN F KENNEDY DR | - | - | - | - | - | - |
| 102522 | N/A | Point | - | - | - | - | S230580 | HAMPSHIRE ST: 25TH ST | - | F | F | - | F | 23950000 | 23950000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 25TH ST | 25TH ST | 130209 | 130209 | 37.75131023 | -122.40713901 | HAMPSHIRE ST \ 25TH ST | HAMPSHIRE ST \ 25TH ST | 1714770165000 | middleware_editor | SPEED HUMPS | 25TH ST intersection | - | AT PAINT MARK | - | - | - | - | - | 119805 | 1479220620000 | -122.40713901 | 37.75131023 | - | 1479168000000 | - | D9 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1478013120000 | HAMPSHIRE ST | - | - | - | - | - | - |
| 102523 | N/A | Point | - | - | - | RIGHT ARROW | S230130 | HEARST AVE: FOERSTER ST | - | F | F | - | F | 22231000 | 22231000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HEARST AVE | FOERSTER ST | 68554 | 68554 | 37.73069019 | -122.44886046 | FOERSTER ST \ HEARST AVE | HEARST AVE \ FOERSTER ST | 1710539427000 | MTA | SPEED HUMPS | FOERSTER ST intersection | - | ABOVE PASSENGER LOADING SIGN | - | - | - | - | - | 119806 | 1480896000000 | -122.44886046 | 37.73069019 | - | 1480896000000 | - | D7 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1477388880000 | HEARST AVE | - | - | - | - | - | - |
| 102524 | N/A | Point | - | 1 | 1 - 99 | - | S230348 | 1000-1299 JOHN F KENNEDY DR (G | 1-99 OVERLOOK DR | F | F | - | F | 10063000 | 10063000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | TRANSVERSE DR | TRANSVERSE DR | 66431 | 66431 | 37.76915207 | -122.48242928 | - | - | 1710539427000 | MTA | SPEED HUMPS | TRANSVERSE DR to MIDDLE WEST DR (1 - 99) | - | OPP POND (SEE PAINT) | - | - | - | - | - | 119807 | 57283200000 | -122.48242928 | 37.76915207 | - | - | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1477648860000 | OVERLOOK DR | 1000-1299 JOHN F KENNEDY DR (G | 1 - 99 OVERLOOK DR | - | - | MIDDLE WEST DR | MIDDLE WEST DR |
| 102525 | N/A | Point | - | 1 | 1 - 99 | - | S230372 | 1000-1299 JOHN F KENNEDY DR (G | 1-99 OVERLOOK DR | F | F | - | F | 10063000 | 10063000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | TRANSVERSE DR | TRANSVERSE DR | 64667 | 64667 | 37.76915207 | -122.48242928 | - | - | 1710539427000 | MTA | SPEED HUMPS | TRANSVERSE DR to MIDDLE WEST DR (1 - 99) | - | 20`WEST OF 30TH AVE | - | - | - | - | - | 119808 | 57283200000 | -122.48242928 | 37.76915207 | - | 1477958400000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1477651380000 | OVERLOOK DR | 1000-1299 JOHN F KENNEDY DR (G | 1 - 99 OVERLOOK DR | - | - | MIDDLE WEST DR | MIDDLE WEST DR |
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.