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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64426 | N/A | Point | 1 | 1 | 3400 - 3435 | - | S274608 | 3400-3435 19TH ST | 3400-3435 19TH ST | F | F | - | F | 972000 | 972000 | - | - | NORTH SIDE | - | - | - | - | MISSION ST | MISSION ST | 110756 | 110756 | 37.760253932 | -122.419758228 | - | - | 1710539427000 | MTA | NPRK 6AM-8AM MON WED FRI STCL | MISSION ST to SAN CARLOS ST (3400 - 3435) | - | IFO 3426 | - | - | - | - | - | 81538 | 1621351080000 | -122.4195905 | 37.76021213 | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0192 | 18X18 | SUP2 | 2IN IRON POST | IS | 1620641940000 | 19TH ST | 3400 - 3435 19TH ST | 3400 - 3435 19TH ST | 3400 19TH ST | - | SAN CARLOS ST | SAN CARLOS ST |
| 64427 | N/A | Point | - | - | - | - | S274609 | MISSION ST: 26TH ST | - | F | F | - | F | 1526000 | 21306000 | - | - | NORTH WEST CORNER | - | - | - | - | MISSION ST | MISSION ST | 110757 | 110757 | 37.74908512 | -122.418285454 | - | 26TH ST \ MISSION ST | 1743692032000 | middleware_editor | MISSION ST | MISSION ST intersection | - | - | - | - | - | - | - | 81539 | 1459148400000 | -122.41813525 | 37.74904129 | - | 1743466500000 | - | D9 | - | STREET NAME | GUIDE | D3-1.1207 | 36X08 | SUP2 | LIGHT POLE | IS | 1620643620000 | 26TH ST | 3400 - 3423 26TH ST | - | - | - | OSAGE ALY | - |
| 64428 | N/A | Point | - | - | - | - | S279760 | SAN JOSE AVE: RANDALL ST | - | F | F | - | F | 21838000 | 21838000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | RANDALL ST | RANDALL ST | 110766 | 110766 | 37.739966799 | -122.42432954 | SAN JOSE AVE \ RANDALL ST | SAN JOSE AVE \ RANDALL ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | RANDALL ST intersection | - | - | - | - | - | - | - | 81540 | 1640736000000 | -122.42414715 | 37.73986923 | - | - | - | D8 | - | NO RIGHT TURN | REG | R13A(CA).0002 | 24X30 | SUP2 | SIGNAL POLE | IS | 1639646820000 | SAN JOSE AVE | - | - | - | - | - | - |
| 64429 | N/A | Point | - | - | - | - | S279761 | SAN JOSE AVE: RANDALL ST | - | F | F | - | F | 21838000 | 21838000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | RANDALL ST | RANDALL ST | 110767 | 110767 | 37.739929682 | -122.423963419 | SAN JOSE AVE \ RANDALL ST | SAN JOSE AVE \ RANDALL ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | RANDALL ST intersection | - | - | - | - | - | - | - | 81541 | 1640736000000 | -122.42414715 | 37.73986923 | - | - | - | D8 | - | NO RIGHT TURN | REG | R13A(CA).0002 | 24X30 | SUP2 | SIGNAL POLE | IS | 1639647120000 | SAN JOSE AVE | - | - | - | - | - | - |
| 64430 | N/A | Point | 1 | 1 | 3153 - 3199 | - | S279299 | 3140-3199 16TH ST | 3153-3199 16TH ST | F | F | - | F | 734000 | 734000 | - | - | NORTH SIDE | - | - | - | - | ALBION ST | ALBION ST | 110790 | 110790 | 37.764904556 | -122.423346035 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM TUE THUR SUN STCL | ALBION ST to GUERRERO ST (3153 - 3199) | - | IFO #3160 | - | - | - | - | - | 81542 | 1467763200000 | -122.42360755 | 37.76481338 | - | 1647388800000 | - | D8 | - | STREET CLEANING | REG | R30B(CA).0134 | 18X18 | SUP2 | LIGHT POLE | IS | 1638786240000 | 16TH ST | 3153 - 3199 16TH ST | 3153 - 3199 16TH ST | 3153 16TH ST | - | GUERRERO ST | GUERRERO ST |
| 64431 | N/A | Point | 1 | 1 | 600 - 699 | - | S132750 | 600-699 CLARENDON AVE | 600-699 CLARENDON AVE | F | F | - | F | 4076000 | 4076000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | OLYMPIA WAY | OLYMPIA WAY | 110805 | 110805 | 37.751546599 | -122.456461927 | - | - | 1710539427000 | MTA | KEEP RIGHT (SYM) | OLYMPIA WAY to LAGUNA HONDA BLVD (600 - 699) | - | 12`EAST | - | - | - | - | - | 81543 | 1282003200000 | -122.45900215 | 37.75171522 | - | - | - | D7 | - | OTHER REGULATORY | REG | R4-7A.0001 | 18X24 | SUP2 | LIGHT POLE | IS | 1373577780000 | CLARENDON AVE | 600 - 699 CLARENDON AVE | 600 - 699 CLARENDON AVE | 600 CLARENDON AVE | - | LAGUNA HONDA BLVD | LAGUNA HONDA BLVD |
| 64432 | N/A | Point | - | - | - | - | S261841 | 24TH AVE: RIVERA ST | - | F | F | - | F | 23268000 | 23268000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | RIVERA ST | 24TH AVE | 110857 | 110857 | 37.74654333 | -122.48131042 | 24TH AVE \ RIVERA ST | RIVERA ST \ 24TH AVE | 1719944932000 | middleware_editor | SPEED HUMPS | 24TH AVE intersection | - | - | - | - | - | - | - | 81544 | 1102982400000 | -122.48131042 | 37.74654333 | - | 1582848000000 | - | D4 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1582624020000 | RIVERA ST | - | - | - | - | - | - |
| 64433 | N/A | Point | - | - | - | - | S100967 | BOCANA ST: CORTLAND AVE | - | F | F | - | F | 21246000 | 21246000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CORTLAND AVE | BOCANA ST | 113477 | 113477 | 37.73929728 | -122.41858438 | BOCANA ST \ CORTLAND AVE | CORTLAND AVE \ BOCANA ST | 1710539427000 | MTA | STOP | BOCANA ST intersection | - | - | - | - | - | - | - | 81545 | -401612400000 | -122.41858438 | 37.73929728 | - | 1399427100000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566620000 | CORTLAND AVE | - | - | - | - | - | - |
| 64434 | N/A | Point | - | - | - | - | S101004 | MADRID ST: PERSIA AVE | - | F | F | - | F | 21718000 | 21718000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MADRID ST | MADRID ST | 113493 | 113493 | 37.721717071 | -122.432833696 | PERSIA AVE \ MADRID ST | PERSIA AVE \ MADRID ST | 1710539427000 | MTA | STOP | MADRID ST intersection | - | 0 / 0 | - | - | - | - | - | 81546 | -401241600000 | -122.43280598 | 37.72161877 | - | 1166140800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373566620000 | PERSIA AVE | - | - | - | - | - | - |
| 64435 | N/A | Point | - | - | - | - | S273044 | 25TH AVE: ULLOA ST | - | T | T | - | F | 23239000 | 23239000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 25TH AVE | 25TH AVE | 113495 | 113495 | 37.7409001 | -122.48198944 | ULLOA ST \ 25TH AVE | ULLOA ST \ 25TH AVE | 1721956559000 | middleware_editor | SPEED HUMPS AHEAD | 25TH AVE intersection | - | ABOVE SIGNS | - | - | - | - | - | 81547 | 1319500800000 | -122.48198944 | 37.7409001 | - | 1618358400000 | - | D4 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1615201440000 | ULLOA ST | - | - | - | - | - | - |
| 64436 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S130154 | 1000-1099 POST ST | 1000-1099 POST ST | F | F | - | F | 10639000 | 10639000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | LARKIN ST | LARKIN ST | 113506 | 113506 | 37.786820394 | -122.419525931 | - | - | 1710539427000 | MTA | RIGHT LANE BUSES AND RIGHT TURNS ONLY AT ALL TIMES | LARKIN ST to POLK ST (1000 - 1099) | - | IFO # 1077 | - | - | - | - | - | 81548 | 1233273600000 | -122.41909946 | 37.78693274 | - | - | - | D6 | - | TRANSIT ONLY(RIGHT LANE) | REG | SR60-6(CA).0003 | 30X42 | SUP1 | MUNI POLE | IS | 1373577000000 | POST ST | 1000 - 1099 POST ST | 1000 - 1099 POST ST | 1000 POST ST | - | POLK ST | POLK ST |
| 64437 | N/A | Point | - | - | - | - | S130442 | DELLBROOK AVE: PANORAMA DR | - | F | F | - | F | 26246000 | 26246000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DELLBROOK AVE | DELLBROOK AVE | 113507 | 113507 | 37.753489053 | -122.452405771 | PANORAMA DR \ DELLBROOK AVE | PANORAMA DR \ DELLBROOK AVE | 1710539427000 | MTA | ALL WAY | DELLBROOK AVE intersection | - | - | - | - | - | - | - | 81549 | 1237766400000 | -122.45257028 | 37.75354207 | - | - | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373577060000 | PANORAMA DR | - | - | - | - | - | - |
| 64438 | N/A | Point | 1 | 1 | 300 - 399 | - | S282180 | 300-399 RAYMOND AVE | 300-399 RAYMOND AVE | F | F | - | F | 10945000 | 10945000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | DELTA ST | DELTA ST | 113550 | 113550 | 37.71408269 | -122.41025486 | - | - | 1710539427000 | MTA | SPEED HUMPS AHEAD | DELTA ST to ELLIOT ST (300 - 399) | - | WPL #300 | - | - | - | - | - | 81550 | 1649808000000 | -122.41025486 | 37.71408269 | - | - | - | D10 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1649800200000 | RAYMOND AVE | 300 - 399 RAYMOND AVE | 300 - 399 RAYMOND AVE | 300 RAYMOND AVE | - | ELLIOT ST | ELLIOT ST |
| 64439 | N/A | Point | - | - | - | - | S264102 | 1600-1720 HOLLOWAY AVE | - | F | F | - | F | 6997000 | - | - | - | SOUTH SIDE | - | - | - | - | - | - | 113568 | 113568 | 37.7209524 | -122.479339 | - | - | 1710539427000 | MTA | 1 HR PRK 8AM-6PM MON-FRI EXC "E" PERMITS | - | 324577 | IFO #1605 | - | - | - | - | - | 81551 | 1332720000000 | -122.479339 | 37.7209524 | - | - | - | D7 | - | PARKING:RPP | REG | R32C(CA).0008 | 18X21 | SUP2 | 2IN IRON POST | IS | 1589273880000 | - | 1600-1720 HOLLOWAY AVE | - | - | - | - | - |
| 64440 | N/A | Point | - | - | - | - | S265354 | SANCHEZ ST: 30TH ST | - | F | F | - | F | 21907000 | 21907000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 30TH ST | SANCHEZ ST | 113581 | 113581 | 37.74195291 | -122.42891142 | SANCHEZ ST \ 30TH ST | 30TH ST \ SANCHEZ ST | 1754493489000 | middleware_editor | SPEED HUMPS | SANCHEZ ST intersection | - | - | - | - | - | - | - | 81552 | -397242000000 | -122.42891142 | 37.74195291 | - | 1593068400000 | - | D8 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1592907300000 | 30TH ST | - | - | - | - | - | - |
| 64441 | N/A | Point | - | - | - | - | S265356 | SANCHEZ ST: 30TH ST | - | F | F | - | F | 21907000 | 21907000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 30TH ST | SANCHEZ ST | 113583 | 113583 | 37.74195291 | -122.42891142 | SANCHEZ ST \ 30TH ST | 30TH ST \ SANCHEZ ST | 1754493486000 | middleware_editor | SPEED HUMPS | SANCHEZ ST intersection | - | CROSS STREET IS RANDALL | - | - | - | - | - | 81553 | -397242000000 | -122.42891142 | 37.74195291 | - | 1593068400000 | - | D8 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1592907720000 | 30TH ST | - | - | - | - | - | - |
| 64442 | N/A | Point | - | - | - | - | S265357 | SANCHEZ ST: 30TH ST | - | F | F | - | F | 21907000 | 21907000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 30TH ST | SANCHEZ ST | 113584 | 113584 | 37.74195291 | -122.42891142 | SANCHEZ ST \ 30TH ST | 30TH ST \ SANCHEZ ST | 1754493548000 | middleware_editor | AHEAD | SANCHEZ ST intersection | - | CROSS STREET IS RANDALL | - | - | - | - | - | 81554 | -397242000000 | -122.42891142 | 37.74195291 | - | 1593068400000 | - | D8 | - | OTHER WARNING | WARNING | W(SF).0106 | 18X06 | SUP2 | 2IN IRON POST | IS | 1592907960000 | 30TH ST | - | - | - | - | - | - |
| 64443 | N/A | Point | - | - | - | - | S265368 | 26TH ST: SANCHEZ ST | - | F | F | - | F | 21922000 | 21922000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 26TH ST | 26TH ST | 113587 | 113587 | 37.74836226 | -122.4293465 | SANCHEZ ST \ 26TH ST | SANCHEZ ST \ 26TH ST | 1711491539000 | middleware_editor | SPEED HUMPS | 26TH ST intersection | - | ABOVE SIGN | - | - | - | - | - | 81555 | 67910400000 | -122.4293465 | 37.74836226 | - | 1593043200000 | - | D8 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1592910120000 | SANCHEZ ST | - | - | - | - | - | - |
| 64444 | N/A | Point | - | - | - | - | S265399 | 15TH ST: SANCHEZ ST | - | T | T | - | F | 25975000 | 25975000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SANCHEZ ST | 15TH ST | 113589 | 113589 | 37.76599633 | -122.43103778 | 15TH ST \ SANCHEZ ST | SANCHEZ ST \ 15TH ST | 1710539427000 | MTA | SPEED HUMPS | 15TH ST intersection | - | ABOVE STREET CLEANING SIGNS | - | - | - | - | - | 81556 | 1116288000000 | -122.43103778 | 37.76599633 | - | 1593043200000 | - | D8 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1592918400000 | SANCHEZ ST | - | - | - | - | - | - |
| 64445 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S260843 | 2000-2099 41ST AVE | 2000-2099 41ST AVE | F | F | - | F | 1918000 | 1918000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | PACHECO ST | PACHECO ST | 113604 | 113604 | 37.7484096045084 | -122.499647367079 | - | - | 1747942666000 | middleware_editor | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | PACHECO ST to QUINTARA ST (2000 - 2099) | - | 200 FT SOUTH OF PACHECO OPP 2057 | - | - | - | - | - | 81557 | 1317106800000 | -122.49971931 | 37.74853856 | - | - | - | D4 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP2 | LIGHT POLE | IS | 1580307900000 | 41ST AVE | 2000 - 2099 41ST AVE | 2000 - 2099 41ST AVE | 2000 41ST AVE | - | QUINTARA ST | QUINTARA ST |
| 64446 | N/A | Point | 1 | 1 | 500 - 599 | - | S261892 | 500-599 WILDE AVE | 500-599 WILDE AVE | F | F | - | F | 13630000 | 13630000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | DELTA ST | DELTA ST | 113613 | 113613 | 37.71795499 | -122.40776325 | - | - | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | DELTA ST to ERVINE ST (500 - 599) | 132568 | EPL# 535 | - | - | - | - | - | 81558 | 1316995200000 | -122.40776325 | 37.71795499 | - | - | - | D10 | - | SPEED LIMIT | REG | SR4-1(CA).0001 | 24X48 | SUP1 | 2IN IRON POST | IS | 1582645260000 | WILDE AVE | 500 - 599 WILDE AVE | 500 - 599 WILDE AVE | 500 WILDE AVE | - | ERVINE ST | ERVINE ST |
| 64447 | N/A | Point | 1 | 1 | 300 - 432 | - | S261583 | 300-432 GONZALEZ DR | 300-432 GONZALEZ DR | F | F | - | F | 6298000 | 6298000 | - | - | SOUTH SIDE | - | - | - | - | FONT BLVD | FONT BLVD | 113614 | 113614 | 37.71627192 | -122.4766145 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "E" PERMITS | FONT BLVD to JOSEPHA AVE (300 - 432) | - | 307 GONZALEZ | - | - | - | - | - | 81559 | 1225411200000 | -122.4766145 | 37.71627192 | - | - | - | D7 | - | PARKING:RPP | REG | R32C(CA).0082 | 18X21 | SUP2 | 2IN IRON POST | IS | 1582108680000 | GONZALEZ DR | 300 - 432 GONZALEZ DR | 300 - 432 GONZALEZ DR | 300 GONZALEZ DR | - | JOSEPHA AVE | JOSEPHA AVE |
| 64448 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S261584 | 1500-1599 PAGE ST | 1500-1599 PAGE ST | F | F | - | F | 10184000 | 10184000 | - | - | SOUTH SIDE | - | - | - | - | MASONIC AVE | MASONIC AVE | 113615 | 113615 | 37.77103829 | -122.44632899 | - | - | 1750974576000 | middleware_editor | TANP PZ 7:30AM-9AM/2:30PM-4PM SCHL DAYS | MASONIC AVE to ASHBURY ST (1500 - 1599) | - | 93FT EAST OF ASHBURY | - | - | - | - | - | 81560 | - | -122.44632899 | 37.77103829 | - | - | 1750972500000 | D5 | - | TOW (TANP ANY TIME) | REG | R26K(SF).0077 | 10X15 | SUP1 | 2IN IRON POST | RETD | 1582110900000 | PAGE ST | 1500 - 1599 PAGE ST | 1500 - 1599 PAGE ST | 1500 PAGE ST | - | ASHBURY ST | ASHBURY ST |
| 64449 | N/A | Point | - | 1 | 400 - 499 | - | S261639 | 400-499 SAN BRUNO AVE | 400-499 SAN BRUNO AVE | F | F | - | F | 11353000 | 11353000 | - | - | EAST SIDE | - | - | - | - | 17TH ST | 17TH ST | 113616 | 113616 | 37.76394505 | -122.40543691 | - | - | 1756153646000 | middleware_editor | PARK AT 90 DEGREES | 17TH ST to MARIPOSA ST (400 - 499) | - | 25FT SOUTH OF 17TH ST | - | - | - | - | - | 81561 | - | -122.40543691 | 37.76394505 | - | - | - | D10 | - | PARKING:PARK AT 90 | REG | R(SF).0372 | 18X18 | SUP1 | 2IN IRON POST | IS | 1582195560000 | SAN BRUNO AVE | 400 - 499 SAN BRUNO AVE | 400 - 499 SAN BRUNO AVE | 400 SAN BRUNO AVE | - | MARIPOSA ST | MARIPOSA ST |
| 64450 | N/A | Point | - | 1 | 400 - 499 | - | S261640 | 400-499 SAN BRUNO AVE | 400-499 SAN BRUNO AVE | F | F | - | F | 11353000 | 11353000 | - | - | EAST SIDE | - | - | - | - | 17TH ST | 17TH ST | 113617 | 113617 | 37.76394505 | -122.40543691 | - | - | 1756153403000 | middleware_editor | NPRK 9AM-11AM MON STCL | 17TH ST to MARIPOSA ST (400 - 499) | - | 25FT SOUTH OF 17TH ST | - | - | - | - | - | 81562 | 1410850800000 | -122.40543691 | 37.76394505 | - | 1410850800000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0300 | 18X18 | SUP1 | 2IN IRON POST | IS | 1582195860000 | SAN BRUNO AVE | 400 - 499 SAN BRUNO AVE | 400 - 499 SAN BRUNO AVE | 400 SAN BRUNO AVE | - | MARIPOSA ST | MARIPOSA ST |
| 64451 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S262625 | 1100-1199 BRAZIL AVE | 1100-1199 BRAZIL AVE | F | F | - | F | 3104000 | 3104000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | PRAGUE ST | PRAGUE ST | 114110 | 114110 | 37.720346954 | -122.425817211 | - | - | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | PRAGUE ST to LA GRANDE AVE (1100 - 1199) | 133551 | 80' WEST OF LA GRANDE AVE. | - | - | - | - | - | 81563 | 1319587200000 | -122.42575105 | 37.72036322 | - | - | - | D11 | - | SPEED LIMIT | REG | SR4-1(CA).0001 | 24X48 | SUP2 | 2IN IRON POST | IS | 1584970980000 | BRAZIL AVE | 1100 - 1199 BRAZIL AVE | 1100 - 1199 BRAZIL AVE | 1100 BRAZIL AVE | - | LA GRANDE AVE | LA GRANDE AVE |
| 64452 | N/A | Point | - | - | - | - | S262854 | BROTHERHOOD WAY: ARCH ST | - | F | F | - | F | 22524000 | 22524000 | - | - | CENTER ISLAND, E LINE, EASTBOUND | - | - | - | - | ARCH ST | ARCH ST | 114116 | 114116 | 37.712424345 | -122.467203057 | BROTHERHOOD WAY \ ARCH ST | BROTHERHOOD WAY \ ARCH ST | 1748012291000 | middleware_editor | NO LEFT TURN (SYM) | ARCH ST intersection | - | - | - | - | - | - | - | 81564 | 267174000000 | -122.46707269 | 37.71242187 | - | 1689373200000 | 1747934100000 | D11 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | LIGHT POLE | RETD | 1585565520000 | BROTHERHOOD WAY | - | - | - | - | - | - |
| 64453 | N/A | Point | - | - | - | - | S271927 | GEARY BLVD: COOK ST | - | F | F | - | F | 26924000 | 26924000 | - | - | NORTH WEST CORNER | - | - | - | - | GEARY BLVD | GEARY BLVD | 114138 | 114138 | 37.781807713 | -122.452173965 | COOK ST \ GEARY BLVD | COOK ST \ GEARY BLVD | 1710539427000 | MTA | COOK ST | GEARY BLVD intersection | - | - | - | - | - | - | - | 81565 | 1611792000000 | -122.45214312 | 37.78185329 | - | 1611878400000 | - | D1 | - | STREET NAME | GUIDE | D3-1.0436 | 36X08 | SUP2 | SIGNAL POLE | IS | 1611753480000 | COOK ST | - | - | - | - | - | - |
| 64454 | N/A | Point | - | - | - | - | S271928 | COOK ST: GEARY BLVD | - | F | F | - | F | 26924000 | 26924000 | - | - | NORTH EAST CORNER | - | - | - | - | GEARY BLVD | GEARY BLVD | 114139 | 114139 | 37.781826438 | -122.452097075 | COOK ST \ GEARY BLVD | COOK ST \ GEARY BLVD | 1710539427000 | MTA | GEARY ST | GEARY BLVD intersection | - | - | - | - | - | - | - | 81566 | 1611792000000 | -122.45214312 | 37.78185329 | - | 1611878400000 | - | D1 | - | STREET NAME | GUIDE | D3-1.0718 | 36X08 | SUP2 | SIGNAL POLE | IS | 1611753600000 | COOK ST | - | - | - | - | - | - |
| 64455 | N/A | Point | - | - | - | - | S273137 | HAWES ST: HUDSON AVE \ HUNTERS | - | F | F | - | F | 20164000 | 20164000 | - | - | NORTH WEST CORNER | - | - | - | - | HAWES ST \ HUNTERS POINT BLVD | HAWES ST \ HUNTERS POINT BLVD | 114619 | 114619 | 37.73361635 | -122.37697386 | HUDSON AVE \ HAWES ST \ HUNTERS POINT BLVD | HUDSON AVE \ HAWES ST \ HUNTERS POINT BLVD | 1741809455000 | middleware_editor | TREE TOP 6FT SPEED BUMP | HAWES ST \ HUNTERS POINT BLVD intersection | - | - | - | - | - | - | - | 81567 | 1618605660000 | -122.37697386 | 37.73361635 | - | - | 1741809420000 | D10 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP1 | BARRICADE | RETD | 1615379820000 | HUDSON AVE | - | - | - | - | - | - |
| 64456 | N/A | Point | 1 | 1 | 600 - 699 | - | S266137 | 600-699 17TH AVE | 600-699 17TH AVE | F | F | - | F | 755000 | 755000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | BALBOA ST | 114632 | 114632 | 37.7757605 | -122.47581962 | - | - | 1710539427000 | MTA | SPEED HUMPS | BALBOA ST to CABRILLO ST (600 - 699) | - | SPL#680 | - | - | - | - | - | 81568 | 1305676800000 | -122.47581962 | 37.7757605 | - | 1594944000000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1594632780000 | 17TH AVE | 600 - 699 17TH AVE | 600 - 699 17TH AVE | 600 17TH AVE | - | CABRILLO ST | CABRILLO ST |
| 64457 | N/A | Point | - | - | - | - | S288094 | POPE ST: BRUNSWICK ST | - | F | F | - | F | 21453000 | 21453000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BRUNSWICK ST | BRUNSWICK ST | 114638 | 114638 | 37.71147717 | -122.44010846 | POPE ST \ BRUNSWICK ST | POPE ST \ BRUNSWICK ST | 1739213257000 | middleware_editor | SPEED HUMP | BRUNSWICK ST intersection | - | - | - | - | - | - | - | 81569 | 1684800000000 | -122.44010846 | 37.71147717 | - | 1738919700000 | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 3IN IRON POST | IS | 1678887780000 | POPE ST | - | - | - | - | - | - |
| 64458 | N/A | Point | - | - | - | - | S110511 | LISBON ST: BRAZIL AVE | - | F | F | - | F | 21716000 | 21716000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BRAZIL AVE | BRAZIL AVE | 114663 | 114663 | 37.723645897 | -122.432457988 | LISBON ST \ BRAZIL AVE | LISBON ST \ BRAZIL AVE | 1710539427000 | MTA | STOP | BRAZIL AVE intersection | - | 0 / 0 | - | - | - | - | - | 81570 | 650592000000 | -122.43243206 | 37.72354972 | - | - | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570820000 | LISBON ST | - | - | - | - | - | - |
| 64459 | N/A | Point | 1 | 1 | 2700 - 2799 | - | S284266 | 2700-2799 16TH ST | 2700-2799 16TH ST | F | F | - | F | 720000 | 720000 | - | - | NORTH SIDE | - | - | - | - | HARRISON ST \ TREAT AVE | HARRISON ST \ TREAT AVE | 114670 | 114670 | 37.765269448 | -122.413757997 | - | - | 1710539427000 | MTA | BIKE RACK | HARRISON ST \ TREAT AVE to FOLSOM ST (2700 - 2799) | - | 10' E FOLSOM/7.5' E OF LINE/2' FROM CURB | - | - | - | - | - | 81571 | 1668556800000 | -122.41420682 | 37.76538112 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1659425820000 | 16TH ST | 2700 - 2799 16TH ST | 2700 - 2799 16TH ST | 2700 16TH ST | - | FOLSOM ST | FOLSOM ST |
| 64460 | N/A | Point | - | - | - | - | S283329 | RICHARDS CIR: MABREY CT \ WHIT | - | F | F | - | F | 28166000 | 28166000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MABREY CT \ RICHARDS CIR | MABREY CT \ WHITNEY YOUNG CIR | 114677 | 114677 | 37.735711839 | -122.38583268 | WHITNEY YOUNG CIR \ MABREY CT \ RICHARDS CIR | RICHARDS CIR \ MABREY CT \ WHITNEY YOUNG CIR | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | MABREY CT \ WHITNEY YOUNG CIR intersection | - | - | - | - | - | - | - | 81572 | 1074643200000 | -122.38577233 | 37.73578396 | - | - | - | D10 | - | OTHER WARNING | WARNING | SW(SF).0003 | 24X18 | SUP1 | 2IN IRON POST | IS | 1654767600000 | RICHARDS CIR | - | - | - | - | - | - |
| 64461 | N/A | Point | - | - | - | - | S265283 | BUENA VISTA AVE EAST: BUENA VI | - | T | T | - | F | 26022000 | 26022000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BUENA VISTA AVE \ WALLER ST | BUENA VISTA AVE \ WALLER ST | 114686 | 114686 | 37.77002493 | -122.43925429 | BUENA VISTA AVE EAST \ BUENA VISTA AVE \ WALLER ST | BUENA VISTA AVE EAST \ BUENA VISTA AVE \ WALLER ST | 1710539427000 | MTA | SPEED HUMP | BUENA VISTA AVE \ WALLER ST intersection | - | - | - | - | - | - | - | 81573 | 1593607560000 | -122.43925429 | 37.77002493 | - | - | - | D8 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1592558340000 | BUENA VISTA AVE EAST | - | - | - | - | - | - |
| 64462 | N/A | Point | - | - | - | - | S265284 | BUENA VISTA AVE EAST: BUENA VI | - | F | F | - | F | 26022000 | 26022000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BUENA VISTA AVE \ WALLER ST | BUENA VISTA AVE \ WALLER ST | 114687 | 114687 | 37.77002493 | -122.43925429 | BUENA VISTA AVE EAST \ BUENA VISTA AVE \ WALLER ST | BUENA VISTA AVE EAST \ BUENA VISTA AVE \ WALLER ST | 1710539427000 | MTA | SPEED HUMP | BUENA VISTA AVE \ WALLER ST intersection | - | ABOVE STOP SIGN | - | - | - | - | - | 81574 | 1144886400000 | -122.43925429 | 37.77002493 | - | 1593561600000 | - | D8 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1592558460000 | BUENA VISTA AVE EAST | - | - | - | - | - | - |
| 64463 | N/A | Point | - | - | - | - | S265285 | BUENA VISTA AVE EAST: BUENA VI | - | T | T | - | F | 26022000 | 26022000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BUENA VISTA AVE \ WALLER ST | BUENA VISTA AVE \ WALLER ST | 114688 | 114688 | 37.77002493 | -122.43925429 | BUENA VISTA AVE EAST \ BUENA VISTA AVE \ WALLER ST | BUENA VISTA AVE EAST \ BUENA VISTA AVE \ WALLER ST | 1710539427000 | MTA | SPEED HUMPS | BUENA VISTA AVE \ WALLER ST intersection | - | - | - | - | - | - | - | 81575 | 1593612840000 | -122.43925429 | 37.77002493 | - | - | - | D8 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1592558640000 | BUENA VISTA AVE EAST | - | - | - | - | - | - |
| 64464 | N/A | Point | 1 | 1 | 1 - 99 | - | S265287 | 1-99 BUENA VISTA EAST AVE | 1-99 BUENA VISTA AVE EAST | T | T | - | F | 3362000 | 3362000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | BAKER ST \ BUENA VISTA AVE \ HAIGHT ST | BAKER ST \ BUENA VISTA AVE \ HAIGHT ST | 114690 | 114690 | 37.77048804 | -122.43973981 | - | - | 1717724314000 | middleware_editor | SPEED HUMPS | BAKER ST \ BUENA VISTA AVE \ HAIGHT ST to BUENA VISTA AVE \ WALLER ST (1 - 99) | - | 30' SOUTH OF HAIGHT ST. | - | - | - | - | - | 81576 | 1593614160000 | -122.43973981 | 37.77048804 | - | - | - | D5 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1592559060000 | BUENA VISTA AVE EAST | 1-99 BUENA VISTA EAST AVE | 1 - 99 BUENA VISTA AVE EAST | - | - | BUENA VISTA AVE \ WALLER ST | BUENA VISTA AVE \ WALLER ST |
| 64465 | N/A | Point | 1 | 1 | 450 - 499 | - | S235997 | 450-499 VALENCIA ST | 450-499 VALENCIA ST | F | F | - | F | 13059000 | 13059000 | - | - | EAST SIDE | - | - | - | - | SPARROW ST | SPARROW ST | 117225 | 117225 | 37.76518054 | -122.421820773 | - | - | 1710539427000 | MTA | NPRK 6AM-8AM TUE THUR SUN STCL | SPARROW ST to 16TH ST (450 - 499) | - | 50FT. NORTH OF 16TH ST. | - | - | - | - | - | 81577 | 1497970680000 | -122.42192538 | 37.76531907 | - | 1497916800000 | - | D8 | - | STREET CLEANING | REG | R30B(CA).0196 | 18X18 | SUP2 | LIGHT POLE | IS | 1494410100000 | VALENCIA ST | 450 - 499 VALENCIA ST | 450 - 499 VALENCIA ST | 450 VALENCIA ST | - | 16TH ST | 16TH ST |
| 64466 | N/A | Point | - | - | - | - | S256652 | SAN JOSE AVE: RANDALL ST | - | F | F | - | T | 21838000 | 21838000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | RANDALL ST | RANDALL ST | 117245 | 117245 | 37.740028311 | -122.424114963 | SAN JOSE AVE \ RANDALL ST | SAN JOSE AVE \ RANDALL ST | 1742482303000 | middleware_editor | DELINEATOR (Y) (SAFE HIT) | RANDALL ST intersection | - | 3 YELLOW SAFE HITS ON ISLAND | - | - | - | - | - | 81578 | 794476800000 | -122.42414715 | 37.73986923 | - | 1589180400000 | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0002 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | 1564657020000 | SAN JOSE AVE | - | - | - | - | - | - |
| 64467 | N/A | Point | 1 | 1 | 600 - 699 | RIGHT ARROW | S245319 | 600-699 18TH ST | 600-699 18TH ST | F | F | - | F | 850000 | 850000 | - | - | SOUTH SIDE | - | - | - | - | 03RD ST | 03RD ST | 117279 | 117279 | 37.762958349 | -122.389385614 | - | - | 1710539427000 | MTA | 2HR PRK 8AM-6PM MON-FRI EXC "EE" PERMITS | 03RD ST to TENNESSEE ST (600 - 699) | - | 140' WEST OF 3RD ST | - | - | - | - | - | 81579 | 1040169600000 | -122.38923541 | 37.76301719 | - | 1646784000000 | 1665532800000 | D10 | - | PARKING:RPP | REG | R32C(CA).0240 | 18X21 | SUP1 | 2IN IRON POST | RETD | 1525424340000 | 18TH ST | 600 - 699 18TH ST | 600 - 699 18TH ST | 600 18TH ST | - | TENNESSEE ST | TENNESSEE ST |
| 64468 | N/A | Point | 1 | 1 | 200 - 299 | - | S267097 | 200-299 LISBON ST | 200-299 LISBON ST | F | F | - | F | 8407000 | 8407000 | - | - | WEST SIDE | - | - | - | - | EXCELSIOR AVE | EXCELSIOR AVE | 117332 | 117332 | 37.724302692 | -122.431946442 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM MON STCL | EXCELSIOR AVE to BRAZIL AVE (200 - 299) | - | SPL 250 | - | - | - | - | - | 81580 | 1542067200000 | -122.43184273 | 37.72432815 | - | 1600300800000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0261 | 18X18 | SUP2 | 2IN IRON POST | IS | 1597393920000 | LISBON ST | 200 - 299 LISBON ST | 200 - 299 LISBON ST | 200 LISBON ST | - | BRAZIL AVE | BRAZIL AVE |
| 64469 | N/A | Point | 1 | 1 | 250 - 323 | - | S265261 | 250-323 ANZAVISTA AVE | 250-323 ANZAVISTA AVE | F | F | - | F | 2369000 | 2369000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | VEGA ST | VEGA ST | 117337 | 117337 | 37.78050398 | -122.44546547 | - | - | 1736877681000 | middleware_editor | SPEED HUMP | VEGA ST to TERRA VISTA AVE (250 - 323) | - | 30' SOUTH OF TERRA VISTA/ 5' S OF DWAY | - | - | - | - | - | 81581 | 1592913780000 | -122.44546547 | 37.78050398 | - | - | - | D2 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1592482140000 | ANZAVISTA AVE | 250 - 323 ANZAVISTA AVE | 250 - 323 ANZAVISTA AVE | 250 ANZAVISTA AVE | - | TERRA VISTA AVE | TERRA VISTA AVE |
| 64470 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S261877 | 2200-2299 14TH AVE | 2200-2299 14TH AVE | F | F | - | F | 571000 | 571000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | RIVERA ST | RIVERA ST | 117346 | 117346 | 37.745551418 | -122.470466233 | - | - | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | RIVERA ST to SANTIAGO ST (2200 - 2299) | - | NPL 2283 | - | - | - | - | - | 81582 | 1321401600000 | -122.47043047 | 37.74609013 | - | - | - | D7 | - | SPEED LIMIT | REG | SR4-1(CA).0001 | 24X48 | SUP2 | LIGHT POLE | IS | 1582637040000 | 14TH AVE | 2200 - 2299 14TH AVE | 2200 - 2299 14TH AVE | 2200 14TH AVE | - | SANTIAGO ST | SANTIAGO ST |
| 64471 | N/A | Point | - | - | - | - | S276680 | JUDAH ST: 48TH AVE | - | T | T | - | F | - | 27951000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | - | JUDAH ST | 117352 | 117352 | 37.76032982 | -122.50806756 | - | 48TH AVE \ JUDAH ST | 1715390512000 | middleware_editor | SPEED HUMPS AHEAD | JUDAH ST intersection | - | OPP SEC | - | - | - | - | - | 81583 | 1582243200000 | -122.50806756 | 37.76032982 | - | 1628035200000 | - | D4 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | MUNI POLE | IS | 1627559460000 | 48TH AVE | - | - | - | - | - | - |
| 64472 | N/A | Point | - | - | - | - | S270746 | GREAT HWY: 48TH AVE \ TARAVAL | - | T | T | - | F | 23506000 | 23506000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 48TH AVE \ GREAT HWY | 48TH AVE \ GREAT HWY | 117363 | 117363 | 37.74167302 | -122.50686545 | TARAVAL ST \ 48TH AVE \ GREAT HWY | TARAVAL ST \ 48TH AVE \ GREAT HWY | 1755107210000 | middleware_editor | SPEED HUMP | 48TH AVE \ GREAT HWY intersection | - | - | - | - | - | - | - | 81584 | 1439535600000 | -122.50686545 | 37.74167302 | - | 1677571200000 | - | D4 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1607676360000 | TARAVAL ST | - | - | - | - | - | - |
| 64473 | N/A | Point | 1 | 1 | 706 - 799 | - | S206661 | 706-799 HOLLY PARK CIR | 706-799 HOLLY PARK CIR | F | F | - | F | 7007000 | 7007000 | - | - | SOUTH SIDE | - | - | - | - | APPLETON AVE | APPLETON AVE | 117370 | 117370 | 37.737713314 | -122.42092856 | - | - | 1710539427000 | MTA | NPRK ANY TIME VEH OVER 22' LONG OR 7' HIGH 12AM-6AM EVERYDAY | APPLETON AVE to ELSIE ST (706 - 799) | - | OPP C-LINE OF PARK | - | - | - | - | - | 81585 | 1405435740000 | -122.42079445 | 37.73776811 | - | 1405382400000 | - | D9 | - | PARKING:NPRK ANY TIME | REG | R30(SF).0572 | 18X18 | SUP2 | LIGHT POLE | IS | 1402406460000 | HOLLY PARK CIR | 706 - 799 HOLLY PARK CIR | 706 - 799 HOLLY PARK CIR | 706 HOLLY PARK CIR | - | ELSIE ST | ELSIE ST |
| 64474 | N/A | Point | - | - | - | - | S213358 | 16TH ST: SHOTWELL ST | - | F | F | - | F | 24141000 | 24141000 | - | - | SOUTH WEST CORNER | - | - | - | - | 16TH ST | 16TH ST | 117399 | 117399 | 37.76517245 | -122.416434906 | SHOTWELL ST \ 16TH ST | SHOTWELL ST \ 16TH ST | 1710539427000 | MTA | 16TH ST | 16TH ST intersection | - | 2850 BLK | - | - | - | - | - | 81586 | 1574861520000 | -122.41638752 | 37.76524949 | - | - | - | D9 | - | STREET NAME | GUIDE | D3-1.0007 | 36X08 | SUP2 | 3IN IRON POST | IS | 1423560120000 | SHOTWELL ST | - | - | - | - | - | - |
| 64475 | N/A | Point | - | - | - | - | S241654 | 10TH ST: FOLSOM ST | - | T | T | - | F | 24233000 | 24233000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FOLSOM ST | 10TH ST | 117423 | 117423 | 37.772808979 | -122.412825571 | 10TH ST \ FOLSOM ST | FOLSOM ST \ 10TH ST | 1710539427000 | MTA | SPEED LIMIT 25 | 10TH ST intersection | - | - | - | - | - | - | - | 81587 | 1470096000000 | -122.41282423 | 37.77281216 | - | 1515110400000 | - | D6 | - | SPEED LIMIT | REG | R2-1.0006 | 36X45 | SUP1 | LIGHT POLE | IS | 1513679280000 | FOLSOM ST | - | - | - | - | - | - |
| 64476 | N/A | Point | - | - | - | - | S239397 | NAPLES ST: BRAZIL AVE | - | F | F | - | F | 21643000 | 21643000 | - | - | SOUTH WEST CORNER | - | - | - | - | NAPLES ST | BRAZIL AVE | 117429 | 117429 | 37.72238514 | -122.430148638 | BRAZIL AVE \ NAPLES ST | NAPLES ST \ BRAZIL AVE | 1710539427000 | MTA | NAPLES ST | BRAZIL AVE intersection | - | - | - | - | - | - | - | 81588 | 1518431400000 | -122.43002615 | 37.72239787 | - | 1518393600000 | - | D11 | - | STREET NAME | GUIDE | D3-1.1256 | 36X08 | SUP2 | 3IN IRON POST | IS | 1507717740000 | NAPLES ST | - | - | - | - | - | - |
| 64477 | N/A | Point | - | - | - | - | S106639 | GARDENSIDE DR: BURNETT AVE | - | F | F | - | F | 26124000 | 26124000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BURNETT AVE | BURNETT AVE | 105907 | 105907 | 37.75558386 | -122.44421891 | GARDENSIDE DR \ BURNETT AVE | GARDENSIDE DR \ BURNETT AVE | 1747153985000 | middleware_editor | STOP | BURNETT AVE intersection | - | SOUTHERN INTERSECTION | - | - | - | - | - | 81589 | 154339200000 | -122.44421891 | 37.75558386 | - | 1747066500000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569620000 | GARDENSIDE DR | - | - | - | - | - | - |
| 64478 | N/A | Point | - | - | - | - | S106947 | VICTORIA ST: SARGENT ST | - | F | F | - | F | 22693000 | 22693000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SARGENT ST | SARGENT ST | 105908 | 105908 | 37.71611762 | -122.46532107 | VICTORIA ST \ SARGENT ST | VICTORIA ST \ SARGENT ST | 1737650875000 | APADILLA | STOP | SARGENT ST intersection | - | - | - | - | - | - | - | 81590 | 180835200000 | -122.46532107 | 37.71611762 | - | 1553212800000 | - | D11 | - | STOP | REG | R1-3P.0001 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373569680000 | VICTORIA ST | - | - | - | - | - | - |
| 64479 | N/A | Point | - | - | - | - | S107260 | ALABAMA ST: MONTCALM ST | - | F | F | - | F | 21130000 | 21130000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ALABAMA ST | ALABAMA ST | 105909 | 105909 | 37.74557116 | -122.41049838 | MONTCALM ST \ ALABAMA ST | MONTCALM ST \ ALABAMA ST | 1710539427000 | MTA | STOP | ALABAMA ST intersection | - | 0 / 0 | - | - | - | - | - | 81591 | 209865600000 | -122.41049838 | 37.74557116 | - | 1540944000000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569800000 | MONTCALM ST | - | - | - | - | - | - |
| 64480 | N/A | Point | - | - | - | - | S103063 | GOLD ST: SANSOME ST | - | F | F | - | F | 24713000 | 24713000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SANSOME ST | GOLD ST | 105910 | 105910 | 37.79687571 | -122.40190695 | GOLD ST \ SANSOME ST | SANSOME ST \ GOLD ST | 1730386289000 | middleware_editor | ONE WAY (RA) | GOLD ST intersection | - | 0 / 0 | - | - | - | - | - | 81592 | -313200000000 | -122.40190695 | 37.79687571 | - | - | 1730255400000 | D3 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | BUILDING | RETD | 1373568480000 | SANSOME ST | - | - | - | - | - | - |
| 64481 | N/A | Point | - | - | - | - | S103094 | 42ND AVE: NORIEGA ST | - | F | F | - | F | 27766000 | 27766000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 42ND AVE | 42ND AVE | 105911 | 105911 | 37.75315365 | -122.50111792 | NORIEGA ST \ 42ND AVE | NORIEGA ST \ 42ND AVE | 1710539427000 | MTA | STOP | 42ND AVE intersection | - | 0 / 0 | - | - | - | - | - | 81593 | -310867200000 | -122.50111792 | 37.75315365 | - | 1490227200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568480000 | NORIEGA ST | - | - | - | - | - | - |
| 64482 | N/A | Point | - | - | - | - | S103126 | DIAMOND ST: CLIPPER ST | - | F | F | - | F | 25757000 | 25757000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CLIPPER ST | DIAMOND ST | 105912 | 105912 | 37.74876204 | -122.43606717 | DIAMOND ST \ CLIPPER ST | CLIPPER ST \ DIAMOND ST | 1712069238000 | middleware_editor | STOP | DIAMOND ST intersection | - | - | - | - | - | - | - | 81594 | -307497600000 | -122.43606717 | 37.74876204 | - | 1711984200000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568540000 | CLIPPER ST | - | - | - | - | - | - |
| 64483 | N/A | Point | - | - | - | - | S101748 | TURK ST: LAGUNA ST | - | F | F | - | F | 25962000 | 25962000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LAGUNA ST | TURK ST | 105913 | 105913 | 37.7811962686501 | -122.427121102805 | TURK ST \ LAGUNA ST | LAGUNA ST \ TURK ST | 1737052647000 | middleware_editor | ONE WAY (LA) | TURK ST intersection | - | 0 / 0 | - | - | - | - | - | 81595 | -395107200000 | -122.42720276 | 37.78111713 | - | - | - | D5 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373566860000 | LAGUNA ST | - | - | - | - | - | - |
| 64484 | N/A | Point | - | - | - | - | S101778 | WILLOW ST: LARKIN ST | - | F | F | - | F | 25150000 | 25150000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LARKIN ST | WILLOW ST | 105914 | 105914 | 37.78377752 | -122.41761857 | WILLOW ST \ LARKIN ST | LARKIN ST \ WILLOW ST | 1710539427000 | MTA | STOP | WILLOW ST intersection | - | 0 / 0 | - | - | - | - | - | 81596 | -395020800000 | -122.41761857 | 37.78377752 | - | 862185600000 | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373566860000 | LARKIN ST | - | - | - | - | - | - |
| 64485 | N/A | Point | - | - | - | - | S102088 | CLINTON PARK: GUERRERO ST | - | F | F | - | F | 25844000 | 25844000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GUERRERO ST | CLINTON PARK | 105915 | 105915 | 37.76914818 | -122.42447502 | CLINTON PARK \ GUERRERO ST | GUERRERO ST \ CLINTON PARK | 1721683493000 | middleware_editor | STOP | CLINTON PARK intersection | - | 0 / 00 | - | - | - | - | - | 81597 | -392601600000 | -122.42447502 | 37.76914818 | - | 881280000000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568180000 | GUERRERO ST | - | - | - | - | - | - |
| 64486 | N/A | Point | - | - | - | - | S107788 | 40TH AVE: WAWONA ST | - | F | F | - | F | 23429000 | 23429000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WAWONA ST | 40TH AVE | 105916 | 105916 | 37.7364644 | -122.49779797 | 40TH AVE \ WAWONA ST | WAWONA ST \ 40TH AVE | 1710539427000 | MTA | STOP | 40TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 81598 | 255830400000 | -122.49779797 | 37.7364644 | - | 1489968000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569980000 | WAWONA ST | - | - | - | - | - | - |
| 64487 | N/A | Point | - | - | - | - | S107814 | VELASCO AVE: CASTILLO ST | - | F | F | - | F | 20412000 | 20412000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CASTILLO ST | CASTILLO ST | 105917 | 105917 | 37.70947143 | -122.41765694 | VELASCO AVE \ CASTILLO ST | VELASCO AVE \ CASTILLO ST | 1715712557000 | middleware_editor | STOP | CASTILLO ST intersection | - | 0 / 0 | - | - | - | - | - | 81599 | 256953600000 | -122.41765694 | 37.70947143 | - | 1715593500000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569980000 | VELASCO AVE | - | - | - | - | - | - |
| 64488 | N/A | Point | - | - | - | - | S107844 | KIRKHAM ST: 34TH AVE | - | F | F | - | F | 27723000 | 27723000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 34TH AVE | KIRKHAM ST | 105918 | 105918 | 37.75912292 | -122.49293687 | KIRKHAM ST \ 34TH AVE | 34TH AVE \ KIRKHAM ST | 1710539427000 | MTA | STOP | KIRKHAM ST intersection | - | 0 / 0 | - | - | - | - | - | 81600 | 257990400000 | -122.49293687 | 37.75912292 | - | 1511222400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569980000 | 34TH AVE | - | - | - | - | - | - |
| 64489 | N/A | Point | - | - | - | - | S103151 | FRANKLIN ST: SACRAMENTO ST | - | F | F | - | F | 26537000 | 26537000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SACRAMENTO ST | FRANKLIN ST | 105921 | 105921 | 37.7910813 | -122.42416146 | FRANKLIN ST \ SACRAMENTO ST | SACRAMENTO ST \ FRANKLIN ST | 1710539427000 | MTA | ONE WAY (RA) | FRANKLIN ST intersection | - | 0 / 0 | - | - | - | - | - | 81601 | -300499200000 | -122.42416146 | 37.7910813 | - | 1446508800000 | - | D2 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373568540000 | SACRAMENTO ST | - | - | - | - | - | - |
| 64490 | N/A | Point | - | - | - | - | S103184 | LANE ST: VAN DYKE AVE | - | F | F | - | F | 20505000 | 20505000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | VAN DYKE AVE | VAN DYKE AVE | 105922 | 105922 | 37.72915975 | -122.39241507 | LANE ST \ VAN DYKE AVE | LANE ST \ VAN DYKE AVE | 1710539427000 | MTA | STOP | VAN DYKE AVE intersection | - | 0 / 00 | - | - | - | - | - | 81602 | -295747200000 | -122.39241507 | 37.72915975 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373568540000 | LANE ST | - | - | - | - | - | - |
| 64491 | N/A | Point | 1 | 1 | 100 - 199 | LEFT ARROW | S270418 | 100-199 FOLSOM ST | 100-199 FOLSOM ST | F | F | - | F | 5651000 | 5651000 | - | - | SOUTH SIDE | - | - | - | - | SPEAR ST | SPEAR ST | 105923 | 105923 | 37.78971954 | -122.39141465 | - | - | 1715264908000 | middleware_editor | TA (SYM) PLO AT ALL TIMES (5 MIN) | SPEAR ST to MAIN ST (100 - 199) | - | 91' EAST OF MAIN ST | - | - | - | - | - | 81603 | 1608634920000 | -122.39141465 | 37.78971954 | - | - | - | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0001 | 14X21 | SUP1 | 2IN IRON POST | IS | 1606221480000 | FOLSOM ST | 100 - 199 FOLSOM ST | 100 - 199 FOLSOM ST | 100 FOLSOM ST | - | MAIN ST | MAIN ST |
| 64492 | N/A | Point | - | - | - | - | S282857 | DANIEL BURNHAM CT: VAN NESS AV | - | F | F | - | F | 30079000 | 30079000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DANIEL BURNHAM CT | DANIEL BURNHAM CT | 105924 | 105924 | 37.78706158 | -122.42176481 | VAN NESS AVE \ DANIEL BURNHAM CT | VAN NESS AVE \ DANIEL BURNHAM CT | 1710539427000 | MTA | DANIEL BURNHAM | DANIEL BURNHAM CT intersection | - | []<---000 | - | - | - | - | - | 81604 | - | -122.42176481 | 37.78706158 | - | 1677542400000 | - | D2 | - | STREET NAME | GUIDE | D3-1.2040 | 36X08 | SUP1 | LIGHT POLE | IS | 1652866500000 | VAN NESS AVE | - | - | - | - | - | - |
| 64493 | N/A | Point | 1 | 1 | 645 - 699 | - | S271818 | 645-699 FOLSOM ST | 645-699 FOLSOM ST | F | F | - | F | 5661000 | 5661000 | - | - | SOUTH SIDE | - | - | - | - | HAWTHORNE ST | HAWTHORNE ST | 105925 | 105925 | 37.78422576 | -122.39837097 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | HAWTHORNE ST to 03RD ST (645 - 699) | - | START 235' EAST OF 3RD ST. | - | - | - | - | - | 81605 | 1615546800000 | -122.39837097 | 37.78422576 | - | - | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1611577380000 | FOLSOM ST | 645 - 699 FOLSOM ST | 645 - 699 FOLSOM ST | 645 FOLSOM ST | - | 03RD ST | 03RD ST |
| 64494 | N/A | Point | - | - | - | - | S250903 | JUDAH ST: 29TH AVE | - | T | T | - | F | 27432000 | 27432000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 29TH AVE | JUDAH ST | 105926 | 105926 | 37.76122857 | -122.48770816 | JUDAH ST \ 29TH AVE | 29TH AVE \ JUDAH ST | 1710539427000 | MTA | NO LEFT TURN (SYM) 7AM-9AM/4PM-6PM EXC SAT & SUN | JUDAH ST intersection | - | - | - | - | - | - | - | 81606 | 1544572800000 | -122.48770816 | 37.76122857 | - | 1621555200000 | - | D4 | - | NO LEFT TURN | REG | R33A(CA).0014 | 30X48 | SUP2 | LIGHT POLE | IS | 1547720940000 | 29TH AVE | - | - | - | - | - | - |
| 64495 | N/A | Point | - | 1 | 800 - 848 | - | S253438 | 800-899 MISSION BAY BLVD NORTH | 800-848 MISSION BAY BLVD NORTH | F | F | - | F | 15022201 | 15022201 | - | - | EAST SIDE, EASTBOUND TRAFFIC | - | - | - | - | LONG BRIDGE ST \ MISSION BAY BLVD | LONG BRIDGE ST \ MISSION BAY BLVD | 106370 | 106370 | 37.77067351 | -122.39501986 | - | - | 1710539427000 | MTA | ONE WAY (RA) | LONG BRIDGE ST \ MISSION BAY BLVD to MISSION BAY BLVD \ MISSION BAY CIR (800 - 848) | - | OPPO CI, X-STREET IS MISSION BAY DR. | - | - | - | - | - | 81607 | 1556544900000 | -122.39501986 | 37.77067351 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | 2IN IRON POST | IS | 1554971820000 | MISSION BAY BLVD NORTH | 800 - 848 MISSION BAY BLVD NORTH | 800 - 848 MISSION BAY BLVD NORTH | 800 MISSION BAY BLVD NORTH | - | MISSION BAY BLVD \ MISSION BAY CIR | MISSION BAY BLVD \ MISSION BAY CIR |
| 64496 | N/A | Point | - | - | - | - | S253451 | MISSION BAY BLVD SOUTH: LONG B | - | T | T | - | F | 34180000 | 34180000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LONG BRIDGE ST \ MISSION BAY BLVD \ SIXTH ST | LONG BRIDGE ST \ MISSION BAY BLVD \ SIXTH ST | 106371 | 106371 | 37.77037102 | -122.39422549 | MISSION BAY BLVD SOUTH \ LONG BRIDGE ST \ MISSION BAY BLVD \ SIXTH ST | MISSION BAY BLVD SOUTH \ LONG BRIDGE ST \ MISSION BAY BLVD \ SIXTH ST | 1710539427000 | MTA | (45 LA-DN) | LONG BRIDGE ST \ MISSION BAY BLVD \ SIXTH ST intersection | - | - | - | - | - | - | - | 81608 | 1556288040000 | -122.39422549 | 37.77037102 | - | - | - | D6 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP1 | LIGHT POLE | IS | 1554978060000 | MISSION BAY BLVD SOUTH | - | - | - | - | - | - |
| 64497 | N/A | Point | - | - | - | - | S231146 | DIAMOND ST: 17TH ST | - | F | F | - | F | 25828000 | 25828000 | - | - | SOUTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DIAMOND ST | DIAMOND ST | 106373 | 106373 | 37.76235475 | -122.43734237 | 17TH ST \ DIAMOND ST | 17TH ST \ DIAMOND ST | 1715046038000 | middleware_editor | ALL WAY | DIAMOND ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 81609 | 326505600000 | -122.43734237 | 37.76235475 | - | - | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 3IN IRON POST | IS | 1479457920000 | 17TH ST | - | - | - | - | - | - |
| 64498 | N/A | Point | - | - | - | - | S234264 | LYON ST: CHESTNUT ST | - | F | F | - | F | 27021000 | 27021000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LYON ST | CHESTNUT ST | 106376 | 106376 | 37.79938989 | -122.44746603 | CHESTNUT ST \ LYON ST | LYON ST \ CHESTNUT ST | 1710539427000 | MTA | ALL WAY | CHESTNUT ST intersection | - | X ST IS CHESTNUT | - | - | - | - | - | 81610 | 896140800000 | -122.44746603 | 37.79938989 | - | 1494374400000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 3IN IRON POST | IS | 1489396500000 | LYON ST | - | - | - | - | - | - |
| 64499 | N/A | Point | - | - | - | - | S234712 | MERRIE WAY: POINT LOBOS AVE | - | F | F | - | F | 10544000 | 51560000 | - | - | NORTH EAST CORNER | - | - | - | - | MERRIE WAY | MERRIE WAY | 106378 | 106378 | 37.7794511629343 | -122.511600477593 | - | POINT LOBOS AVE \ MERRIE WAY | 1745864373000 | middleware_editor | MERRIE WAY | MERRIE WAY intersection | - | 5TH LP W. OF EL CAM DEL MAR | - | - | - | - | - | 81611 | 1504729080000 | -122.51142414 | 37.77940966 | - | 1504681200000 | - | D1 | - | STREET NAME | GUIDE | D3-1.1171 | 36X08 | SUP2 | LIGHT POLE | IS | 1490785740000 | POINT LOBOS AVE | 700 - 1299 POINT LOBOS AVE | - | - | - | GREAT HWY | - |
| 64500 | N/A | Point | - | - | - | - | S233627 | LEESE ST: PARK ST | - | F | F | - | F | 21821000 | 21821000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LEESE ST | PARK ST | 106379 | 106379 | 37.73669014 | -122.42364033 | PARK ST \ LEESE ST | LEESE ST \ PARK ST | 1710539427000 | MTA | ALL WAY | PARK ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 81612 | 1503532800000 | -122.42364033 | 37.73669014 | - | 1503532800000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1487153940000 | LEESE 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.