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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 61276 | N/A | Point | - | - | - | - | S287476 | PNDG TERRY A FRANCOIS BLVD | - | F | F | - | F | 12532000 | 12532000 | - | - | EAST SIDE | - | - | - | - | - | - | 101686 | 101686 | 37.76873346 | -122.38636338 | - | - | 1710539427000 | MTA | TA (SYM) NO STOPPING 12MID- 6AM DAILY | - | - | 305 FT SOUTH / FLAG OUT | - | - | - | - | - | 78384 | 1677024000000 | -122.38636338 | 37.76873346 | - | - | - | D6 | - | OTHER REGULATORY | REG | R37(CA).0109 | 18X21 | SUP1 | LIGHT POLE | IS | 1675954920000 | TERRY A FRANCOIS BLVD | PNDG TERRY A FRANCOIS BLVD | TERRY A FRANCOIS BLVD | - | - | - | - |
| 61277 | N/A | Point | - | - | - | - | S205235 | OCEAN AVE: ONONDAGA AVE | - | F | F | - | F | 22077000 | 22077000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | OCEAN AVE | OCEAN AVE | 109164 | 109164 | 37.72316832 | -122.44255366 | ONONDAGA AVE \ OCEAN AVE | ONONDAGA AVE \ OCEAN AVE | 1714786043000 | middleware_editor | SPEED LIMIT 25 | OCEAN AVE intersection | - | - | - | - | - | - | - | 78385 | 948672000000 | -122.44255366 | 37.72316832 | - | 1399248000000 | - | D11 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP2 | MUNI POLE | IS | 1398680460000 | ONONDAGA AVE | - | - | - | - | - | - |
| 61278 | N/A | Point | - | - | - | - | S203824 | MARINA BLVD: BEACH ST \ BUCHAN | - | F | F | - | F | 26758000 | 26758000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BEACH ST \ BUCHANAN ST \ MARINA BLVD | BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST | 109165 | 109165 | 37.80504329 | -122.43379794 | LOWER FORT MASON ST \ BEACH ST \ BUCHANAN ST \ MARINA BLVD | MARINA BLVD \ BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST | 1710539427000 | MTA | 49 MILE SCENIC DRIVE (RA) | BEACH ST \ BUCHANAN ST \ LOWER FORT MASON ST intersection | 43 | - | - | - | - | - | - | 78386 | 1465998300000 | -122.43379794 | 37.80504329 | - | 1465948800000 | - | D2 | - | OTHER GUIDE | GUIDE | G-X(SF).0009 | 24X42 | SUP1 | 2IN IRON POST | IS | 1394634780000 | MARINA BLVD | - | - | - | - | - | - |
| 61279 | N/A | Point | - | - | - | - | S200912 | BRYANT ST: 10TH ST \ HWY 101 S | - | T | T | - | F | 24192000 | 24192000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BRYANT ST \ HWY 101 S ON RAMP | BRYANT ST \ HWY 101 S ON RAMP | 109166 | 109166 | 37.77034852 | -122.40973589 | 10TH ST \ BRYANT ST \ HWY 101 S ON RAMP | 10TH ST \ BRYANT ST \ HWY 101 S ON RAMP | 1710539427000 | MTA | SPEED LIMIT 25 | BRYANT ST \ HWY 101 S ON RAMP intersection | - | CROSS ST. IS 10TH ST | - | - | - | - | - | 78387 | - | -122.40973589 | 37.77034852 | - | - | - | D6 | - | SPEED LIMIT | REG | R2-1.0006 | 36X45 | SUP1 | LIGHT POLE | IS | 1386670380000 | 10TH ST | - | - | - | - | - | - |
| 61280 | N/A | Point | - | - | - | - | S105232 | CLEMENT ST: 10TH AVE | - | F | F | - | F | 27303000 | 27303000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CLEMENT ST | 10TH AVE | 109167 | 109167 | 37.78275092 | -122.46870448 | 10TH AVE \ CLEMENT ST | CLEMENT ST \ 10TH AVE | 1740413151000 | middleware_editor | STOP | 10TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 78388 | 60307200000 | -122.46870448 | 37.78275092 | - | 1740128580000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569140000 | CLEMENT ST | - | - | - | - | - | - |
| 61281 | N/A | Point | - | - | - | - | S105253 | GIRARD ST: WAYLAND ST | - | F | F | - | F | 20633000 | 20633000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GIRARD ST | WAYLAND ST | 109168 | 109168 | 37.72617321 | -122.40410076 | WAYLAND ST \ GIRARD ST | GIRARD ST \ WAYLAND ST | 1757019844000 | middleware_editor | STOP | WAYLAND ST intersection | - | 0 / 0 | - | - | - | - | - | 78389 | 64569600000 | -122.40410076 | 37.72617321 | - | 1539068400000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569140000 | GIRARD ST | - | - | - | - | - | - |
| 61282 | N/A | Point | - | - | - | - | S104746 | STOCKTON ST: GEARY ST | - | F | F | - | F | 24901000 | 24901000 | - | - | NORTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GEARY ST | STOCKTON ST | 109169 | 109169 | 37.78756803 | -122.40658988 | STOCKTON ST \ GEARY ST | GEARY ST \ STOCKTON ST | 1726104597000 | middleware_editor | NO LEFT TURN (SYM) | STOCKTON ST intersection | - | 0 / MADE GEARY 1-WAY SB | - | - | - | - | - | 78390 | 28080000000 | -122.40658988 | 37.78756803 | - | - | - | D3 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | UNKNOWN | IS | 1373569020000 | GEARY ST | - | - | - | - | - | - |
| 61283 | N/A | Point | - | - | - | - | S105073 | LA SALLE AVE: NEWHALL ST | - | F | F | - | F | 20669000 | 20669000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LA SALLE AVE | LA SALLE AVE | 109171 | 109171 | 37.73754173 | -122.3905211 | NEWHALL ST \ LA SALLE AVE | NEWHALL ST \ LA SALLE AVE | 1710539427000 | MTA | STOP | LA SALLE AVE intersection | - | 0 / 0 | - | - | - | - | - | 78391 | 44150400000 | -122.3905211 | 37.73754173 | - | 803520000000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569140000 | NEWHALL ST | - | - | - | - | - | - |
| 61284 | N/A | Point | 1 | 1 | 3700 - 3799 | - | S119443 | 3700-3799 CESAR CHAVEZ ST | 3700-3799 CESAR CHAVEZ ST | F | F | - | F | 2491000 | 2491000 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | GUERRERO ST | GUERRERO ST | 109196 | 109196 | 37.74790737 | -122.42362504 | - | - | 1756400501000 | middleware_editor | (LA) ONLY (LA-VA) | GUERRERO ST to DOLORES ST (3700 - 3799) | - | CENTER ISLAND OF EAST LINE, ABOVE SIGNAL | - | - | - | - | - | 78392 | 1095404400000 | -122.42362504 | 37.74790737 | - | - | - | D8 | - | OTHER REGULATORY | REG | R61-1(CA).0001 | 36X30 | SUP2 | LIGHT POLE | IS | 1373573640000 | CESAR CHAVEZ ST | 3700 - 3799 CESAR CHAVEZ ST | 3700 - 3799 CESAR CHAVEZ ST | 3700 CESAR CHAVEZ ST | - | DOLORES ST | DOLORES ST |
| 61285 | N/A | Point | 1 | 1 | 300 - 399 | - | S116577 | 300-399 SPEAR ST | 300-399 SPEAR ST | F | F | - | F | 12047000 | 12047000 | - | - | EAST SIDE | - | - | - | - | FOLSOM ST | FOLSOM ST | 109197 | 109197 | 37.78945379 | -122.39019998 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM THUR STCL | FOLSOM ST to HARRISON ST (300 - 399) | - | 200'N OF HARRISON ST SEE PM | - | - | - | - | - | 78393 | 1050969600000 | -122.39019998 | 37.78945379 | - | 1410912000000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0054 | 18X18 | SUP1 | LIGHT POLE | IS | 1373572740000 | SPEAR ST | 300 - 399 SPEAR ST | 300 - 399 SPEAR ST | 300 SPEAR ST | - | HARRISON ST | HARRISON ST |
| 61286 | N/A | Point | - | - | - | - | S119493 | MARKET ST: 16TH ST \ NOE ST | - | F | F | - | F | 25804000 | 25804000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 16TH ST \ MARKET ST | 16TH ST \ MARKET ST | 109198 | 109198 | 37.76419571 | -122.43307447 | NOE ST \ 16TH ST \ MARKET ST | NOE ST \ 16TH ST \ MARKET ST | 1715007634000 | middleware_editor | START PED CROSSING (SYM)/DON'T START (HAND SYM)/ETC | 16TH ST \ MARKET ST intersection | - | - | - | - | - | - | - | 78394 | 1096934400000 | -122.43307447 | 37.76419571 | - | - | - | D8 | - | PEDESTRIAN | REG | R10-3.0002 | 09X12 | SUP2 | SIGNAL POLE | IS | 1373573640000 | NOE ST | - | - | - | - | - | - |
| 61287 | N/A | Point | - | - | - | - | S119522 | OAK ST: OAK ACCESS RD \ STANYA | - | F | F | - | F | 26441000 | 26441000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | OAK ST \ STANYAN ST | OAK ACCESS RD \ STANYAN ST | 109199 | 109199 | 37.77105384 | -122.45390246 | OAK ACCESS RD \ OAK ST \ STANYAN ST | OAK ST \ OAK ACCESS RD \ STANYAN ST | 1735666532000 | middleware_editor | START PED CROSSING (SYM)/DON'T START (HAND SYM)/ETC | OAK ACCESS RD \ STANYAN ST intersection | - | - | - | - | - | - | - | 78395 | 1097107200000 | -122.45390246 | 37.77105384 | - | - | - | D5 | - | PEDESTRIAN | REG | R10-3.0002 | 09X12 | SUP1 | LIGHT POLE | IS | 1373573640000 | OAK ST | - | - | - | - | - | - |
| 61288 | N/A | Point | - | - | - | - | S120517 | BALBOA ST: 22ND AVE | - | F | F | - | F | 27530000 | 27530000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BALBOA ST | 22ND AVE | 109200 | 109200 | 37.77644876 | -122.48124685 | 22ND AVE \ BALBOA ST | BALBOA ST \ 22ND AVE | 1731508883000 | middleware_editor | PEDESTRIAN (SYM) | 22ND AVE intersection | - | BELOW ST.NAME SIGNS | - | - | - | - | - | 78396 | 1109894400000 | -122.48124685 | 37.77644876 | - | 1685923200000 | - | D1 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373574000000 | BALBOA ST | - | - | - | - | - | - |
| 61289 | N/A | Point | - | - | - | - | S110560 | LELAND AVE: SCHWERIN ST | - | F | F | - | F | 20380000 | 20380000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LELAND AVE | SCHWERIN ST | 109205 | 109205 | 37.71330426 | -122.41015039 | SCHWERIN ST \ LELAND AVE | LELAND AVE \ SCHWERIN ST | 1710539427000 | MTA | STOP | SCHWERIN ST intersection | - | - | - | - | - | - | - | 78397 | 660268800000 | -122.41015039 | 37.71330426 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570820000 | LELAND AVE | - | - | - | - | - | - |
| 61290 | N/A | Point | - | - | - | - | S110710 | DETROIT ST: HEARST AVE | - | F | F | - | F | 22155000 | 22155000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DETROIT ST | DETROIT ST | 109208 | 109208 | 37.73070822 | -122.44429841 | HEARST AVE \ DETROIT ST | HEARST AVE \ DETROIT ST | 1710539427000 | MTA | STOP | DETROIT ST intersection | - | - | - | - | - | - | - | 78398 | 687657600000 | -122.44429841 | 37.73070822 | - | 1387843200000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373570880000 | HEARST AVE | - | - | - | - | - | - |
| 61291 | N/A | Point | - | - | - | - | S214522 | HYDE ST: WASHINGTON ST | - | T | T | - | F | 25261000 | 25261000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HYDE ST | WASHINGTON ST | 110140 | 110140 | 37.79368379 | -122.41793576 | WASHINGTON ST \ HYDE ST | HYDE ST \ WASHINGTON ST | 1710539427000 | MTA | WASHINGTON ST | WASHINGTON ST intersection | - | - | - | - | - | - | - | 78399 | 1463661960000 | -122.41793576 | 37.79368379 | - | 1463616000000 | - | D3 | - | STREET NAME | GUIDE | D3-2.0355 | 72X18 | SUP1 | LIGHT POLE | IS | 1427214720000 | HYDE ST | - | - | - | - | - | - |
| 61292 | N/A | Point | - | - | - | RIGHT ARROW | S213806 | STEINER ST: WILMOT ST | - | F | F | - | F | 26630000 | 26630000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WILMOT ST | WILMOT ST | 110142 | 110142 | 37.78727505 | -122.43519929 | STEINER ST \ WILMOT ST | STEINER ST \ WILMOT ST | 1710539427000 | MTA | ONE WAY (RA) | WILMOT ST intersection | - | UNDER STREET NAME | - | - | - | - | - | 78400 | - | -122.43519929 | 37.78727505 | - | 1706281500000 | - | D5 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | 3IN IRON POST | IS | 1424943840000 | STEINER ST | - | - | - | - | - | - |
| 61293 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S211488 | 1800-1899 HAIGHT ST | 1800-1899 HAIGHT ST | F | F | - | F | 6624000 | 6624000 | - | - | SOUTH SIDE | - | - | - | - | SHRADER ST | SHRADER ST | 110143 | 110143 | 37.76927195 | -122.4527013 | - | - | 1710539427000 | MTA | BIKE RACK | SHRADER ST to STANYAN ST (1800 - 1899) | - | WPL #1811 32" FROM CURB @W PM | - | - | - | - | - | 78401 | 1419984000000 | -122.4527013 | 37.76927195 | - | 1419984000000 | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1418031000000 | HAIGHT ST | 1800 - 1899 HAIGHT ST | 1800 - 1899 HAIGHT ST | 1800 HAIGHT ST | - | STANYAN ST | STANYAN ST |
| 61294 | N/A | Point | - | - | - | - | S213042 | HAVENS ST: LEAVENWORTH ST | - | F | F | - | F | 25510000 | 25510000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LEAVENWORTH ST | LEAVENWORTH ST | 110144 | 110144 | 37.79990626 | -122.41749254 | HAVENS ST \ LEAVENWORTH ST | HAVENS ST \ LEAVENWORTH ST | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | LEAVENWORTH ST intersection | - | BELOW ST.NAME SIGN "HAVEN" | - | - | - | - | - | 78402 | 1423230240000 | -122.41749254 | 37.79990626 | - | 1423180800000 | - | D2 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP1 | BUILDING | IS | 1422530400000 | HAVENS ST | - | - | - | - | - | - |
| 61295 | N/A | Point | - | - | - | - | S109539 | THE EMBARCADERO: KING ST \ TOW | - | F | F | - | F | 23592000 | 23592000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | THE EMBARCADERO \ TOWNSEND ST | THE EMBARCADERO \ TOWNSEND ST | 110428 | 110428 | 37.78179824 | -122.38830607 | KING ST \ THE EMBARCADERO \ TOWNSEND ST | THE EMBARCADERO \ TOWNSEND ST intersection | 1756240670000 | middleware_editor | STOP | THE EMBARCADERO \ TOWNSEND ST intersection | - | 0 / REMOVE EXISTING PED XING SIGN | - | - | - | - | - | 78403 | 511430400000 | -122.38830607 | 37.78179824 | - | 625388400000 | 1756240620000 | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | RETD | 1373570520000 | KING ST | - | - | - | - | - | - |
| 61296 | N/A | Point | - | - | - | - | S111575 | THE EMBARCADERO: BRYANT ST | - | F | F | - | F | 23601000 | 23601000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | THE EMBARCADERO | BRYANT ST | 110429 | 110429 | 37.78709724 | -122.38779489 | BRYANT ST \ THE EMBARCADERO | THE EMBARCADERO \ BRYANT ST | 1710539427000 | MTA | DO NOT ENTER | BRYANT ST intersection | - | WEST LP | - | - | - | - | - | 78404 | 828144000000 | -122.38779489 | 37.78709724 | - | - | - | D6 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1373571180000 | THE EMBARCADERO | - | - | - | - | - | - |
| 61297 | N/A | Point | - | - | - | - | S122963 | 3RD ST: 20TH ST | - | F | F | - | F | 23564000 | 23564000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 20TH ST | 03RD ST | 110430 | 110430 | 37.76049101 | -122.3885564 | 3RD ST \ 20TH ST | 20TH ST \ 03RD ST | 1710539427000 | MTA | 19TH ST | 03RD ST intersection | - | - | - | - | - | - | - | 78405 | 1142294400000 | -122.3885564 | 37.76049101 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-2.0019 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1373574720000 | 20TH ST | - | - | - | - | - | - |
| 61298 | N/A | Point | - | - | - | - | S121022 | 3RD ST: KIRKWOOD AVE | - | F | F | - | F | 20223000 | 20223000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 3RD ST | 03RD ST | 110431 | 110431 | 37.7379554 | -122.38958738 | KIRKWOOD AVE \ 3RD ST | KIRKWOOD AVE \ 03RD ST | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | 03RD ST intersection | - | - | - | - | - | - | - | 78406 | 1116028800000 | -122.38958738 | 37.7379554 | - | - | - | D10 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP1 | OVERHEAD MAST ARM | IS | 1373574120000 | KIRKWOOD AVE | - | - | - | - | - | - |
| 61299 | N/A | Point | - | - | - | - | S136634 | VAN NESS AVE: BAY ST | - | F | F | - | F | 26705000 | 26705000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VAN NESS AVE | BAY ST | 110432 | 110432 | 37.80414585 | -122.42510952 | BAY ST \ VAN NESS AVE | VAN NESS AVE \ BAY ST | 1721158546000 | middleware_editor | COMMERCIAL VEH OVER 3 TONS PROHIBITED ON BAY ST-USE LOMBARD | BAY ST intersection | - | - | - | - | - | - | - | 78407 | 1338249600000 | -122.42510952 | 37.80414585 | - | - | 1721041200000 | D2 | - | OTHER REGULATORY | REG | R36(CA).0003 | 30X42 | SUP1 | LIGHT POLE | RETD | 1373578980000 | VAN NESS AVE | - | - | - | - | - | - |
| 61300 | N/A | Point | - | - | - | - | S207269 | CESAR CHAVEZ ST: PRECITA AVE \ | - | F | F | - | F | 21125000 | 21125000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PRECITA AVE \ YORK ST | CESAR CHAVEZ ST \ YORK ST | 110433 | 110433 | 37.748405 | -122.40788203 | CESAR CHAVEZ ST \ PRECITA AVE \ YORK ST | PRECITA AVE \ CESAR CHAVEZ ST \ YORK ST | 1710539427000 | MTA | CESAR CHAVEZ ST | CESAR CHAVEZ ST \ YORK ST intersection | - | CESAR CHAVEZ AT ALABAMA | - | - | - | - | - | 78408 | 1404743820000 | -122.40788203 | 37.748405 | - | 1404691200000 | - | D9 | - | STREET NAME | GUIDE | D3-2.0107 | 72X18 | SUP2 | OVERHEAD MAST ARM | IS | 1403693760000 | PRECITA AVE | - | - | - | - | - | - |
| 61301 | N/A | Point | - | - | - | - | S216188 | ULLOA ST: 16TH AVE | - | F | F | - | F | 23155000 | 23155000 | - | - | SOUTH SIDE | - | - | - | - | ULLOA ST | ULLOA ST | 110434 | 110434 | 37.7413318 | -122.47235282 | 16TH AVE \ ULLOA ST | 16TH AVE \ ULLOA ST | 1719018475000 | middleware_editor | TA (SYM) NO STOPPING EXC PERMITTED CSV- ZIPCARS | ULLOA ST intersection | - | 38FT. EAST OF 16TH AVE | - | - | - | - | - | 78409 | 1432030920000 | -122.47235282 | 37.7413318 | - | 1431993600000 | - | D7 | - | OTHER REGULATORY | REG | R37(SF).0291 | 05X12 | SUP2 | 2IN IRON POST | IS | 1431937800000 | 16TH AVE | - | - | - | - | - | - |
| 61302 | N/A | Point | - | - | - | - | S218023 | LINCOLN WAY: 9TH AVE | - | T | T | - | F | 27156000 | 27156000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | LINCOLN WAY | 09TH AVE | 110435 | 110435 | 37.76592466 | -122.46644249 | 9TH AVE \ LINCOLN WAY | LINCOLN WAY \ 09TH AVE | 1720662079000 | middleware_editor | OBSOLETE GUIDE SIGNS | 09TH AVE intersection | - | (VA)SIGN@WEST LINE OF 9TH AVE | - | - | - | - | - | 78410 | - | -122.46644249 | 37.76592466 | - | - | - | D5 | - | OTHER GUIDE | GUIDE | G-O(SF).0003 | 36X30 | SUP1 | LIGHT POLE | IS | 1437495720000 | LINCOLN WAY | - | - | - | - | - | - |
| 61303 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S278673 | 2200-2299 RIVERA ST | 2200-2299 RIVERA ST | F | F | - | F | 11065000 | 11065000 | - | - | SOUTH SIDE | - | - | - | - | 32ND AVE | 32ND AVE | 110436 | 110436 | 37.7460863314089 | -122.49025464613 | - | - | 1754934708000 | middleware_editor | BIKE RACK | 32ND AVE to 33RD AVE (2200 - 2299) | - | 88' W FOF 32ND AVE/3' IN FROM CURB | - | - | - | - | - | 78411 | 1637222400000 | -122.49041531 | 37.74614123 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1636375440000 | RIVERA ST | 2200 - 2299 RIVERA ST | 2200 - 2299 RIVERA ST | 2200 RIVERA ST | - | 33RD AVE | 33RD AVE |
| 61304 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S278674 | 2200-2299 RIVERA ST | 2200-2299 RIVERA ST | F | F | - | F | 11065000 | 11065000 | - | - | NORTH SIDE | - | - | - | - | 32ND AVE | 32ND AVE | 110437 | 110437 | 37.7460683028762 | -122.490682315415 | - | - | 1755015071000 | middleware_editor | BIKE RACK | 32ND AVE to 33RD AVE (2200 - 2299) | - | 80 E OF 33RD AVE/ 3' IN FROM CURB | - | - | - | - | - | 78412 | 1637222400000 | -122.49041531 | 37.74614123 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1636375500000 | RIVERA ST | 2200 - 2299 RIVERA ST | 2200 - 2299 RIVERA ST | 2200 RIVERA ST | - | 33RD AVE | 33RD AVE |
| 61305 | N/A | Point | 1 | 1 | 2400 - 2499 | - | S278675 | 2400-2499 RIVERA ST | 2400-2499 RIVERA ST | F | F | - | F | 11067000 | 11067000 | - | - | NORTH SIDE | - | - | - | - | 34TH AVE | 34TH AVE | 110438 | 110438 | 37.74604632 | -122.49256247 | - | - | 1753130500000 | middleware_editor | BIKE RACK | 34TH AVE to 35TH AVE (2400 - 2499) | - | 76 E OF 35TH AVE/ 3' IN FROM CURB | - | - | - | - | - | 78413 | 1637222400000 | -122.49256247 | 37.74604632 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1636376160000 | RIVERA ST | 2400 - 2499 RIVERA ST | 2400 - 2499 RIVERA ST | 2400 RIVERA ST | - | 35TH AVE | 35TH AVE |
| 61306 | N/A | Point | 1 | 1 | 2500 - 2599 | - | S278680 | 2500-2599 RIVERA ST | 2500-2599 RIVERA ST | F | F | - | F | 11068000 | 11068000 | - | - | SOUTH SIDE | - | - | - | - | 35TH AVE | 35TH AVE | 110439 | 110439 | 37.74599901 | -122.49363251 | - | - | 1710539427000 | MTA | BIKE RACK | 35TH AVE to 36TH AVE (2500 - 2599) | - | 71 E OF 36TH AVE/ 3' IN FROM CURB | - | - | - | - | - | 78414 | 1637193600000 | -122.49363251 | 37.74599901 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1636377900000 | RIVERA ST | 2500 - 2599 RIVERA ST | 2500 - 2599 RIVERA ST | 2500 RIVERA ST | - | 36TH AVE | 36TH AVE |
| 61307 | N/A | Point | 1 | 1 | 2100 - 2199 | - | S278687 | 2100-2199 37TH AVE | 2100-2199 37TH AVE | F | F | - | F | 1835000 | 1835000 | - | - | WEST SIDE | - | - | - | - | QUINTARA ST | QUINTARA ST | 110440 | 110440 | 37.74686074 | -122.49530468 | - | - | 1710539427000 | MTA | BIKE RACK | QUINTARA ST to RIVERA ST (2100 - 2199) | - | 37.5' N OF RIVERA/ 3' IN FROM CURB | - | - | - | - | - | 78415 | 1637280000000 | -122.49530468 | 37.74686074 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1636379820000 | 37TH AVE | 2100 - 2199 37TH AVE | 2100 - 2199 37TH AVE | 2100 37TH AVE | - | RIVERA ST | RIVERA ST |
| 61308 | N/A | Point | - | - | - | - | S269878 | FULTON ST: 48TH AVE | - | F | F | - | F | 27976000 | 27976000 | - | - | NORTH WEST CORNER | - | - | - | - | 48TH AVE | FULTON ST | 111574 | 111574 | 37.771525180854 | -122.5089110434 | FULTON ST \ 48TH AVE | 48TH AVE \ FULTON ST | 1752530441000 | middleware_editor | 48TH AVE | FULTON ST intersection | - | NWC 900> SOUTH | - | - | - | - | - | 78416 | - | -122.50882317 | 37.77144552 | - | 1751397600000 | - | D1 | - | STREET NAME | GUIDE | D3-1.0038 | 36X08 | SUP2 | 3IN IRON POST | IS | 1604483880000 | 48TH AVE | - | - | - | - | - | - |
| 61309 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S266244 | 1400-1499 TAYLOR ST | 1400-1499 TAYLOR ST | F | F | - | F | 12446000 | 12446000 | - | - | WEST SIDE | - | - | - | - | JACKSON ST | JACKSON ST | 111577 | 111577 | 37.79564069 | -122.41327698 | - | - | 1710539427000 | MTA | TANP EXC MOTORCYCLES | JACKSON ST to PACIFIC AVE (1400 - 1499) | - | 15' S OF PACIFIC | - | - | - | - | - | 78417 | 1595420580000 | -122.41327698 | 37.79564069 | - | - | - | D3 | - | TOW (TANP ANY TIME) | REG | R26K(SF).0039 | 10X15 | SUP1 | 2IN IRON POST | IS | 1594723680000 | TAYLOR ST | 1400 - 1499 TAYLOR ST | 1400 - 1499 TAYLOR ST | 1400 TAYLOR ST | - | PACIFIC AVE | PACIFIC AVE |
| 61310 | N/A | Point | 1 | 1 | 2400 - 2499 | - | S266260 | 2400-2499 MASON ST | 2400-2499 MASON ST | F | F | - | F | 8838000 | 8838000 | - | - | EAST SIDE | - | - | - | - | BAY ST | BAY ST | 111580 | 111580 | 37.80608656 | -122.41369541 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM TUE THUR STCL | BAY ST to NORTH POINT ST (2400 - 2499) | - | 65' S OF NORTH POINT | - | - | - | - | - | 78418 | - | -122.41369541 | 37.80608656 | - | - | - | D3 | - | STREET CLEANING | REG | R30B(CA).0133 | 18X18 | SUP1 | 2IN IRON POST | IS | 1594727820000 | MASON ST | 2400 - 2499 MASON ST | 2400 - 2499 MASON ST | 2400 MASON ST | - | NORTH POINT ST | NORTH POINT ST |
| 61311 | N/A | Point | 1 | 1 | 100 - 199 | - | S266263 | 100-199 HAIGHT ST | 100-199 HAIGHT ST | F | F | - | F | 6604000 | 6604000 | - | - | SOUTH SIDE | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 111581 | 111581 | 37.77284585 | -122.42463522 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM TUE STCL | OCTAVIA ST to LAGUNA ST (100 - 199) | - | 40' W OF THE WPL #119 HAIGHT | - | - | - | - | - | 78419 | 1594894320000 | -122.42463522 | 37.77284585 | - | - | - | D5 | - | STREET CLEANING | REG | R30B(CA).0083 | 18X18 | SUP1 | MUNI POLE | IS | 1594734060000 | HAIGHT ST | 100 - 199 HAIGHT ST | 100 - 199 HAIGHT ST | 100 HAIGHT ST | - | LAGUNA ST | LAGUNA ST |
| 61312 | N/A | Point | - | - | - | - | S266290 | 22ND ST: POTRERO AVE | - | F | F | - | F | 23967000 | 23967000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | POTRERO AVE | 22ND ST | 111583 | 111583 | 37.75683374 | -122.406699 | 22ND ST \ POTRERO AVE | POTRERO AVE \ 22ND ST | 1710539427000 | MTA | AHEAD | 22ND ST intersection | - | 100`EAST OF POTRERO AVE, | - | - | - | - | - | 78420 | 1137628800000 | -122.406699 | 37.75683374 | - | 1600300800000 | - | D9 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP2 | 2IN IRON POST | IS | 1594805640000 | POTRERO AVE | - | - | - | - | - | - |
| 61313 | N/A | Point | 1 | 1 | 33 - 70 | - | S266292 | 33-70 OCEAN AVE | 33-70 OCEAN AVE | F | F | - | F | 9805000 | 9805000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | PERSIA AVE | PERSIA AVE | 111584 | 111584 | 37.72375526 | -122.4367346 | - | - | 1715822856000 | middleware_editor | AHEAD | PERSIA AVE to WATTSON PL (33 - 70) | - | 15' EAST OF WATTSON | - | - | - | - | - | 78421 | 1109030400000 | -122.4367346 | 37.72375526 | - | 1601251200000 | - | D11 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP2 | 2IN IRON POST | IS | 1594808040000 | OCEAN AVE | 33 - 70 OCEAN AVE | 33 - 70 OCEAN AVE | 33 OCEAN AVE | - | WATTSON PL | WATTSON PL |
| 61314 | N/A | Point | 1 | 1 | 38 - 99 | - | S266293 | 38-99 STEVENSON ST | 38-99 STEVENSON ST | T | T | - | F | 12165000 | 12165000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | ECKER ST | ECKER ST | 111585 | 111585 | 37.789393 | -122.40008118 | - | - | 1710539427000 | MTA | AHEAD | ECKER ST to 02ND ST (38 - 99) | - | EPL# 55 | - | - | - | - | - | 78422 | 1111536000000 | -122.40008118 | 37.789393 | - | 1601942400000 | - | D6 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP1 | LIGHT POLE | IS | 1594808580000 | STEVENSON ST | 38 - 99 STEVENSON ST | 38 - 99 STEVENSON ST | 38 STEVENSON ST | - | 02ND ST | 02ND ST |
| 61315 | N/A | Point | 1 | 1 | 100 - 199 | - | S263328 | 100-199 CENTRAL AVE | 100-199 CENTRAL AVE | F | F | - | F | 3861000 | 3861000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | HAIGHT ST | HAIGHT ST | 111617 | 111617 | 37.77089224 | -122.44374262 | - | - | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | HAIGHT ST to PAGE ST (100 - 199) | - | SPL #137 | - | - | - | - | - | 78423 | 1184630400000 | -122.44374262 | 37.77089224 | - | 1709905380000 | - | D5 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP1 | 2IN IRON POST | IS | 1586870640000 | CENTRAL AVE | 100 - 199 CENTRAL AVE | 100 - 199 CENTRAL AVE | 100 CENTRAL AVE | - | PAGE ST | PAGE ST |
| 61316 | N/A | Point | - | - | - | - | S263395 | DOLORES ST: 17TH ST | - | F | F | - | F | 25703000 | 25703000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | 17TH ST | DOLORES ST | 111618 | 111618 | 37.76303087 | -122.42622848 | DOLORES ST \ 17TH ST | 17TH ST \ DOLORES ST | 1714179858000 | middleware_editor | SCHOOL (SYM)/SCHOOL | DOLORES ST intersection | 184887 | OPP #380 | - | - | - | - | - | 78424 | 1116460800000 | -122.42622848 | 37.76303087 | - | - | - | D8 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1587373920000 | 17TH ST | - | - | - | - | - | - |
| 61317 | N/A | Point | 1 | 1 | 3800 - 3840 | - | S263407 | 3800-3840 17TH ST | 3800-3840 17TH ST | F | F | - | F | 806000 | 806000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SANCHEZ ST | SANCHEZ ST | 111619 | 111619 | 37.76272792 | -122.43113578 | - | - | 1714760534000 | middleware_editor | SCHOOL (SYM)/SCHOOL | SANCHEZ ST to PROSPER ST (3800 - 3840) | 099313 | EPL #3839 | - | - | - | - | - | 78425 | 1116460800000 | -122.43113578 | 37.76272792 | - | - | - | D8 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | MUNI POLE | IS | 1587378420000 | 17TH ST | 3800 - 3840 17TH ST | 3800 - 3840 17TH ST | 3800 17TH ST | - | PROSPER ST | PROSPER ST |
| 61318 | N/A | Point | - | - | - | - | S263409 | 17TH ST: POND ST | - | T | T | - | F | 25801000 | 25801000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 17TH ST | 17TH ST | 111620 | 111620 | 37.76266813 | -122.43212406 | POND ST \ 17TH ST | POND ST \ 17TH ST | 1714760291000 | middleware_editor | SCHOOL (SYM)/SCHOOL | 17TH ST intersection | 099315 | - | - | - | - | - | - | 78426 | 1116460800000 | -122.43212406 | 37.76266813 | - | - | - | D8 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | LIGHT POLE | IS | 1587378660000 | POND ST | - | - | - | - | - | - |
| 61319 | N/A | Point | 1 | 1 | 1 - 99 | - | S263411 | 1-99 DORLAND ST | 1-99 DORLAND ST | T | T | - | F | 4934000 | 4934000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | GUERRERO ST | GUERRERO ST | 111621 | 111621 | 37.76227657 | -122.42504591 | - | - | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | GUERRERO ST to DOLORES ST (1 - 99) | 099316 | WPL #60 | - | - | - | - | - | 78427 | 1116460800000 | -122.42504591 | 37.76227657 | - | - | - | D8 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | LIGHT POLE | IS | 1587382920000 | DORLAND ST | 1 - 99 DORLAND ST | 1 - 99 DORLAND ST | 1 DORLAND ST | - | DOLORES ST | DOLORES ST |
| 61320 | N/A | Point | 1 | 1 | 200 - 299 | - | S263414 | 200-299 DORLAND ST | 200-299 DORLAND ST | F | F | - | F | 4935000 | 4935000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | CHURCH ST | CHURCH ST | 111622 | 111622 | 37.76208429 | -122.42954676 | - | - | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | CHURCH ST to SANCHEZ ST (200 - 299) | 099319 | EPL #238 (CROSS STREET SANCHEZ ST) | - | - | - | - | - | 78428 | 1116460800000 | -122.42954676 | 37.76208429 | - | - | - | D8 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1587383640000 | DORLAND ST | 200 - 299 DORLAND ST | 200 - 299 DORLAND ST | 200 DORLAND ST | - | SANCHEZ ST | SANCHEZ ST |
| 61321 | N/A | Point | - | - | - | LEFT ARROW | S267173 | ULLOA ST: WEST PORTAL AVE | - | F | F | - | F | 22928000 | 22928000 | - | - | SOUTH EAST CORNER | - | - | - | - | ULLOA ST | ULLOA ST | 113045 | 113045 | 37.74089198 | -122.46582902 | WEST PORTAL AVE \ ULLOA ST | WEST PORTAL AVE \ ULLOA ST | 1727469570000 | middleware_editor | TA (SYM) PLO 7AM-7PM MON-SAT (5 MIN) | ULLOA ST intersection | - | - | - | - | - | - | - | 78429 | 1499644800000 | -122.46582902 | 37.74089198 | - | 1499644800000 | - | D7 | - | OTHER REGULATORY | REG | R38(SF)1.0014 | 14X21 | SUP2 | MUNI POLE | IS | 1597661040000 | WEST PORTAL AVE | - | - | - | - | - | - |
| 61322 | N/A | Point | 1 | 1 | 876 - 899 | - | S267177 | 876-899 ULLOA ST | 876-899 ULLOA ST | F | F | - | F | 12785000 | 12785000 | - | - | NORTH SIDE | - | - | - | - | WEST PORTAL AVE | WEST PORTAL AVE | 113046 | 113046 | 37.74096777 | -122.46597591 | - | - | 1710539427000 | MTA | TANSAT | WEST PORTAL AVE to LENOX WAY (876 - 899) | - | 15 FT WEST | - | - | - | - | - | 78430 | 1273536000000 | -122.46597591 | 37.74096777 | - | - | - | D7 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | 2IN IRON POST | IS | 1597662180000 | ULLOA ST | 876 - 899 ULLOA ST | 876 - 899 ULLOA ST | 876 ULLOA ST | - | LENOX WAY | LENOX WAY |
| 61323 | N/A | Point | 1 | 1 | 876 - 899 | - | S267178 | 876-899 ULLOA ST | 876-899 ULLOA ST | F | F | - | F | 12785000 | 12785000 | - | - | NORTH SIDE | - | - | - | - | WEST PORTAL AVE | WEST PORTAL AVE | 113047 | 113047 | 37.74096777 | -122.46597591 | - | - | 1728417058000 | middleware_editor | LRV (SYM) DO NOT PASS | WEST PORTAL AVE to LENOX WAY (876 - 899) | - | 15 FT WEST | - | - | - | - | - | 78431 | 1273536000000 | -122.46597591 | 37.74096777 | - | 1710763200000 | 1727965500000 | D7 | - | OTHER REGULATORY | REG | R15-5.0001 | 24X30 | SUP2 | 2IN IRON POST | RETD | 1597662300000 | ULLOA ST | 876 - 899 ULLOA ST | 876 - 899 ULLOA ST | 876 ULLOA ST | - | LENOX WAY | LENOX WAY |
| 61324 | N/A | Point | 1 | 1 | 876 - 899 | - | S267179 | 876-899 ULLOA ST | 876-899 ULLOA ST | F | F | - | F | 12785000 | 12785000 | - | - | NORTH SIDE | - | - | - | - | WEST PORTAL AVE | WEST PORTAL AVE | 113048 | 113048 | 37.74096777 | -122.46597591 | - | - | 1728417057000 | middleware_editor | SKEWED RAILROAD CROSSING (L TO R) | WEST PORTAL AVE to LENOX WAY (876 - 899) | - | 15 FT WEST | - | - | - | - | - | 78432 | 1273536000000 | -122.46597591 | 37.74096777 | - | - | 1727965800000 | D7 | - | OTHER WARNING | WARNING | W10-12.0001 | 30X30 | SUP2 | 2IN IRON POST | RETD | 1597662360000 | ULLOA ST | 876 - 899 ULLOA ST | 876 - 899 ULLOA ST | 876 ULLOA ST | - | LENOX WAY | LENOX WAY |
| 61325 | N/A | Point | - | - | - | - | S265155 | POST ST: GOUGH ST | - | F | F | - | F | 26501000 | 26501000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GOUGH ST | GOUGH ST | 113050 | 113050 | 37.78619643 | -122.42485842 | POST ST \ GOUGH ST | POST ST \ GOUGH ST | 1746192911000 | middleware_editor | (45 LA-DN) | GOUGH ST intersection | - | X-STREET IS OCTAVIA ST. | - | - | - | - | - | 78433 | - | -122.42485842 | 37.78619643 | - | - | - | D5 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP1 | LIGHT POLE | IS | 1592228460000 | POST ST | - | - | - | - | - | - |
| 61326 | N/A | Point | - | - | - | - | S266274 | WALLER ST: LAGUNA ST | - | F | F | - | F | 25868000 | 25868000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | WALLER ST | WALLER ST | 113052 | 113052 | 37.77179535 | -122.42532248 | LAGUNA ST \ WALLER ST | LAGUNA ST \ WALLER ST | 1710539427000 | MTA | NO FREEWAY ACCESS | WALLER ST intersection | - | 5' E OF LAGUNA | - | - | - | - | - | 78434 | - | -122.42532248 | 37.77179535 | - | - | - | D8 | - | OTHER WARNING | WARNING | W(SF).0030 | 24X30 | SUP2 | 2IN IRON POST | IS | 1594737960000 | LAGUNA ST | - | - | - | - | - | - |
| 61327 | N/A | Point | 1 | 1 | 300 - 399 | - | S262063 | 300-399 TOWNSEND ST | 300-399 TOWNSEND ST | F | F | - | F | 12663000 | 12663000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 4TH ST | 04TH ST | 113053 | 113053 | 37.77621079 | -122.3960939 | - | - | 1710539427000 | MTA | POST-GAME TAXI STAND | 04TH ST to 05TH ST (300 - 399) | - | 150`WEST | - | - | - | - | - | 78435 | 1341792000000 | -122.3960939 | 37.77621079 | - | - | - | D6 | - | OTHER GUIDE | GUIDE | G-P(SF).0132 | 24X18 | SUP1 | 2IN IRON POST | IS | 1583144100000 | TOWNSEND ST | 300 - 399 TOWNSEND ST | 300 - 399 TOWNSEND ST | 300 TOWNSEND ST | - | 05TH ST | 05TH ST |
| 61328 | N/A | Point | - | - | - | - | S261759 | LAKE ST: 25TH AVE | - | F | F | - | F | 27655000 | 27655000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | LAKE ST | 25TH AVE | 113070 | 113070 | 37.78574601 | -122.48514794 | 25TH AVE \ LAKE ST | LAKE ST \ 25TH AVE | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | 25TH AVE intersection | 133856 | WPL #2401 | - | - | - | - | - | 78436 | 1321920000000 | -122.48514794 | 37.78574601 | - | - | - | D1 | - | SPEED LIMIT | REG | SR4-1(CA).0001 | 24X48 | SUP2 | 2IN IRON POST | IS | 1582531260000 | LAKE ST | - | - | - | - | - | - |
| 61329 | N/A | Point | 1 | 1 | 900 - 923 | - | S261781 | 900-923 HARRISON ST | 900-923 HARRISON ST | F | F | - | F | 6720000 | 6720000 | - | - | NORTH SIDE | - | - | - | - | 5TH ST \ I-8 W OFF RAMP | 05TH ST \ I-80 W OFF RAMP | 113072 | 113072 | 37.77881821 | -122.40211405 | - | - | 1710539427000 | MTA | NPRK 4AM-6AM MON WED FRI STCL | 05TH ST \ I-80 W OFF RAMP to MERLIN ST (900 - 923) | - | 20FT EAST OF 6TH ST | - | - | - | - | - | 78437 | - | -122.40211405 | 37.77881821 | - | - | - | D6 | - | STREET CLEANING | REG | R30B(CA).0144 | 18X18 | SUP1 | 2IN IRON POST | IS | 1582542120000 | HARRISON ST | 900 - 923 HARRISON ST | 900 - 923 HARRISON ST | 900 HARRISON ST | - | MERLIN ST | MERLIN ST |
| 61330 | N/A | Point | 1 | 1 | 1100 - 1299 | - | S261782 | 1100-1299 ELLIS ST | 1100-1299 ELLIS ST | F | F | - | F | 5182000 | 5182000 | - | - | NORTH SIDE | - | - | - | - | GOUGH ST | GOUGH ST | 113073 | 113073 | 37.78319295 | -122.42593957 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM TUE STCL | GOUGH ST to LAGUNA ST (1100 - 1299) | - | INFO #1220 | - | - | - | - | - | 78438 | 1427241600000 | -122.42593957 | 37.78319295 | - | 1427241600000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0308 | 18X18 | SUP1 | 2IN IRON POST | IS | 1582542840000 | ELLIS ST | 1100 - 1299 ELLIS ST | 1100 - 1299 ELLIS ST | 1100 ELLIS ST | - | LAGUNA ST | LAGUNA ST |
| 61331 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S261808 | 1300-1399 SHRADER ST | 1300-1399 SHRADER ST | F | F | - | F | 11862000 | 11862000 | - | - | WEST SIDE | - | - | - | - | ALMA ST | ALMA ST | 113074 | 113074 | 37.7626788 | -122.45080546 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM 1ST WED OF MONTH STCL | ALMA ST to RIVOLI ST (1300 - 1399) | - | 20FT NORTH OF RIVOLI | - | - | - | - | - | 78439 | 1307059200000 | -122.45080546 | 37.7626788 | - | 1582502400000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0292 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1582550880000 | SHRADER ST | 1300 - 1399 SHRADER ST | 1300 - 1399 SHRADER ST | 1300 SHRADER ST | - | RIVOLI ST | RIVOLI ST |
| 61332 | N/A | Point | - | - | - | - | S261809 | MARKET ST: SHORT ST | - | F | F | - | F | 26152000 | 26152000 | - | - | EAST SIDE | - | - | - | - | MARKET ST | MARKET ST | 113075 | 113075 | 37.75779863 | -122.44321651 | SHORT ST \ MARKET ST | SHORT ST \ MARKET ST | 1710539427000 | MTA | NPRK 12NN-2PM FRI STCL | MARKET ST intersection | - | INFO # 3621 | - | - | - | - | - | 78440 | - | -122.44321651 | 37.75779863 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0076 | 18X18 | SUP2 | LIGHT POLE | IS | 1582551600000 | SHORT ST | - | - | - | - | - | - |
| 61333 | N/A | Point | 1 | 1 | 400 - 421 | - | S268219 | 400-421 FOLSOM ST | 400-421 FOLSOM ST | F | F | - | F | 5655000 | 5655000 | - | - | NORTH SIDE | - | - | - | - | FREMONT ST | FREMONT ST | 114551 | 114551 | 37.78785231 | -122.39377954 | - | - | 1715264021000 | middleware_editor | FG 300 UR DELINEATOR (W) | FREMONT ST to GROTE PL (400 - 421) | - | START 20' WEST OF FREMONT ST, 10' OC | - | - | - | - | - | 78441 | 1607351400000 | -122.39377954 | 37.78785231 | - | 1656633600000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1600436460000 | FOLSOM ST | 400 - 421 FOLSOM ST | 400 - 421 FOLSOM ST | 400 FOLSOM ST | - | GROTE PL | GROTE PL |
| 61334 | N/A | Point | 1 | 1 | 400 - 421 | - | S268220 | 400-421 FOLSOM ST | 400-421 FOLSOM ST | F | F | - | F | 5655000 | 5655000 | - | - | NORTH SIDE | - | - | - | - | FREMONT ST | FREMONT ST | 114552 | 114552 | 37.78785231 | -122.39377954 | - | - | 1715291045000 | middleware_editor | FG 300 UR DELINEATOR (W) | FREMONT ST to GROTE PL (400 - 421) | - | START 20' EAST OF 1ST ST. | - | - | - | - | - | 78442 | 1607351460000 | -122.39377954 | 37.78785231 | - | - | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1600436640000 | FOLSOM ST | 400 - 421 FOLSOM ST | 400 - 421 FOLSOM ST | 400 FOLSOM ST | - | GROTE PL | GROTE PL |
| 61335 | N/A | Point | 1 | 1 | 100 - 199 | - | S268298 | 100-199 SANSOME ST | 100-199 SANSOME ST | F | F | - | F | 11543000 | 11543000 | - | - | WEST SIDE | - | - | - | - | BUSH ST | BUSH ST | 114553 | 114553 | 37.79164279 | -122.40083855 | - | - | 1738173008000 | middleware_editor | NPRK 2AM-6AM MON THRU FRI STCL | BUSH ST to PINE ST (100 - 199) | - | 20' SOUTH OF PINE ST. | - | - | - | - | - | 78443 | 963619200000 | -122.40083855 | 37.79164279 | - | 1601337600000 | - | D3 | - | STREET CLEANING | REG | R30B(CA).0120 | 18X18 | SUP1 | 2IN FLANGE POST | IS | 1600769520000 | SANSOME ST | 100 - 199 SANSOME ST | 100 - 199 SANSOME ST | 100 SANSOME ST | - | PINE ST | PINE ST |
| 61336 | N/A | Point | 1 | 1 | 100 - 199 | LEFT ARROW | S268308 | 100-199 SANSOME ST | 100-199 SANSOME ST | F | F | - | F | 11543000 | 11543000 | - | - | WEST SIDE | - | - | - | - | BUSH ST | BUSH ST | 114554 | 114554 | 37.79164279 | -122.40083855 | - | - | 1738174889000 | middleware_editor | TANS 3P-8P EXC SAT & SUN NPRK TAXI ZONE ALL OTHER TIMES | BUSH ST to PINE ST (100 - 199) | - | 91' SOUTH OF PINE ST. | - | - | - | - | - | 78444 | 1601291760000 | -122.40083855 | 37.79164279 | - | - | - | D3 | - | PARKING | REG | R37(SF).0428 | 18X21 | SUP1 | LIGHT POLE | IS | 1600770420000 | SANSOME ST | 100 - 199 SANSOME ST | 100 - 199 SANSOME ST | 100 SANSOME ST | - | PINE ST | PINE ST |
| 61337 | N/A | Point | 1 | 1 | 100 - 199 | RIGHT ARROW | S268309 | 100-199 SANSOME ST | 100-199 SANSOME ST | F | F | - | F | 11543000 | 11543000 | - | - | WEST SIDE | - | - | - | - | BUSH ST | BUSH ST | 114555 | 114555 | 37.79164279 | -122.40083855 | - | - | 1738173061000 | middleware_editor | TANS 3P-8P EXC SAT & SUN NPRK TAXI ZONE ALL OTHER TIMES | BUSH ST to PINE ST (100 - 199) | - | 135' SOUTH OF PINE ST. | - | - | - | - | - | 78445 | 1601291940000 | -122.40083855 | 37.79164279 | - | - | - | D3 | - | PARKING | REG | R37(SF).0428 | 18X21 | SUP1 | 2IN FLANGE POST | IS | 1600770480000 | SANSOME ST | 100 - 199 SANSOME ST | 100 - 199 SANSOME ST | 100 SANSOME ST | - | PINE ST | PINE ST |
| 61338 | N/A | Point | - | - | - | - | S261682 | PINE ST: LARKIN ST | - | T | T | - | F | 25206000 | 25206000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LARKIN ST | LARKIN ST | 114556 | 114556 | 37.78982994 | -122.41884265 | PINE ST \ LARKIN ST | PINE ST \ LARKIN ST | 1710539427000 | MTA | SPEED LIMIT 25 | LARKIN ST intersection | - | - | - | - | - | - | - | 78446 | 1586343240000 | -122.41884265 | 37.78982994 | - | - | - | D3 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP1 | SIGNAL POLE | IS | 1582205580000 | PINE ST | - | - | - | - | - | - |
| 61339 | N/A | Point | 1 | 1 | 645 - 646 | - | S268199 | 645-646 BUSH ST | 645-646 BUSH ST | F | F | - | F | 3435000 | 3435000 | - | - | NORTH SIDE | - | - | - | - | DASHIELL HAMMETT ST | DASHIELL HAMMETT ST | 114557 | 114557 | 37.79026895 | -122.40791968 | - | - | 1710539427000 | MTA | NPRK 7AM-9AM MON FRI STCL | DASHIELL HAMMETT ST to TIMOTHY PFLUEGER PL (645 - 646) | - | 50' EAST OF POWELL ST | - | - | - | - | - | 78447 | 1601640060000 | -122.40791968 | 37.79026895 | - | - | - | D3 | - | STREET CLEANING | REG | R30B(CA).0236 | 18X18 | SUP1 | 2IN IRON POST | IS | 1600416240000 | BUSH ST | 645 - 646 BUSH ST | 645 - 646 BUSH ST | 645 BUSH ST | - | TIMOTHY PFLUEGER PL | TIMOTHY PFLUEGER PL |
| 61340 | N/A | Point | - | - | - | - | S268234 | CALEDONIA ST: 15TH ST | - | F | F | - | F | 24375000 | 24375000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 15TH ST | CALEDONIA ST | 114562 | 114562 | 37.76657054 | -122.4215313 | CALEDONIA ST \ 15TH ST | 15TH ST \ CALEDONIA ST | 1755265718000 | middleware_editor | ONE WAY (LA) | CALEDONIA ST intersection | - | BACK TO BACK D N E | - | - | - | - | - | 78448 | -391971600000 | -122.4215313 | 37.76657054 | - | 1601276400000 | - | D9 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP2 | 3IN IRON POST | IS | 1600681860000 | 15TH ST | - | - | - | - | - | - |
| 61341 | N/A | Point | 1 | 1 | 500 - 599 | - | S267895 | 500-599 BIRCH ST | 500-599 BIRCH ST | F | F | - | F | 2971000 | 2971000 | - | - | SOUTH SIDE | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 114565 | 114565 | 37.77796716 | -122.4257258 | - | - | 1710539427000 | MTA | NPRK ANY TIME | OCTAVIA ST to LAGUNA ST (500 - 599) | - | 74' E OF LAGUNA | - | - | - | - | - | 78449 | 1599571500000 | -122.4257258 | 37.77796716 | - | - | - | D5 | - | PARKING: NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | 2IN IRON POST | IS | 1599213480000 | BIRCH ST | 500 - 599 BIRCH ST | 500 - 599 BIRCH ST | 500 BIRCH ST | - | LAGUNA ST | LAGUNA ST |
| 61342 | N/A | Point | 1 | 1 | 500 - 599 | - | S267896 | 500-599 BIRCH ST | 500-599 BIRCH ST | F | F | - | F | 2971000 | 2971000 | - | - | SOUTH SIDE | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 114566 | 114566 | 37.77796716 | -122.4257258 | - | - | 1710539427000 | MTA | NPRK ANY TIME | OCTAVIA ST to LAGUNA ST (500 - 599) | - | 220' E OF LAGUNA | - | - | - | - | - | 78450 | 1599571620000 | -122.4257258 | 37.77796716 | - | - | - | D5 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | 2IN IRON POST | IS | 1599213540000 | BIRCH ST | 500 - 599 BIRCH ST | 500 - 599 BIRCH ST | 500 BIRCH ST | - | LAGUNA ST | LAGUNA ST |
| 61343 | N/A | Point | 1 | 1 | 500 - 599 | - | S267897 | 500-599 BIRCH ST | 500-599 BIRCH ST | F | F | - | F | 2971000 | 2971000 | - | - | SOUTH SIDE | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 114567 | 114567 | 37.77796716 | -122.4257258 | - | - | 1710539427000 | MTA | NPRK ANY TIME | OCTAVIA ST to LAGUNA ST (500 - 599) | - | 56' W OF OCTAVIA | - | - | - | - | - | 78451 | 1599571860000 | -122.4257258 | 37.77796716 | - | - | - | D5 | - | PARKING: NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | 2IN IRON POST | IS | 1599213600000 | BIRCH ST | 500 - 599 BIRCH ST | 500 - 599 BIRCH ST | 500 BIRCH ST | - | LAGUNA ST | LAGUNA ST |
| 61344 | N/A | Point | 1 | 1 | 500 - 599 | - | S267906 | 500-599 BIRCH ST | 500-599 BIRCH ST | F | F | - | F | 2971000 | 2971000 | - | - | NORTH SIDE | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 114568 | 114568 | 37.77796716 | -122.4257258 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM TUE STCL | OCTAVIA ST to LAGUNA ST (500 - 599) | - | 74' E OF LAGUNA | - | - | - | - | - | 78452 | 1599572340000 | -122.4257258 | 37.77796716 | - | - | - | D5 | - | STREET CLEANING | REG | R30B(CA).0270 | 18X18 | SUP1 | 2IN IRON POST | IS | 1599215700000 | BIRCH ST | 500 - 599 BIRCH ST | 500 - 599 BIRCH ST | 500 BIRCH ST | - | LAGUNA ST | LAGUNA ST |
| 61345 | N/A | Point | 1 | 1 | 1 - 99 | - | S202830 | 1-99 LANGTON ST | 1-99 LANGTON ST | F | F | - | F | 8098000 | 8098000 | - | - | WEST SIDE | - | - | - | - | HOWARD ST | HOWARD ST | 116767 | 116767 | 37.7769345 | -122.40915312 | - | - | 1724461287000 | middleware_editor | TANS EXC 30 MIN COMMERCIAL VEH 9AM-4PM MON-FRI | HOWARD ST to FOLSOM ST (1 - 99) | - | SPL #80/THIS IS A (RA) SIGN | - | - | - | - | - | 78453 | 1393859760000 | -122.40915312 | 37.7769345 | - | 1393804800000 | - | D6 | - | OTHER REGULATORY | REG | R37(SF).0188 | 10X15 | SUP1 | 2IN IRON POST | IS | 1391604420000 | LANGTON ST | 1 - 99 LANGTON ST | 1 - 99 LANGTON ST | 1 LANGTON ST | - | FOLSOM ST | FOLSOM ST |
| 61346 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S151545 | 2200-2299 47TH AVE | 2200-2299 47TH AVE | F | F | - | F | 2053000 | 2053000 | - | - | EAST SIDE | - | - | - | - | RIVERA ST | RIVERA ST | 116768 | 116768 | 37.74452615 | -122.50589099 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM 2ND & 4TH MON OF MONTH STCL | RIVERA ST to SANTIAGO ST (2200 - 2299) | - | 2290 47TH AVE | - | - | - | - | - | 78454 | 1228694400000 | -122.50589099 | 37.74452615 | - | 1628726400000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0072 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375730280000 | 47TH AVE | 2200 - 2299 47TH AVE | 2200 - 2299 47TH AVE | 2200 47TH AVE | - | SANTIAGO ST | SANTIAGO ST |
| 61347 | N/A | Point | - | - | - | - | S212040 | SAINT JOSEPHS AVE: OFARRELL ST | - | F | F | - | F | 26812000 | 26812000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SAINT JOSEPHS AVE | SAINT JOSEPHS AVE | 116793 | 116793 | 37.78223395 | -122.44167164 | OFARRELL ST \ SAINT JOSEPHS AVE | OFARRELL ST \ SAINT JOSEPHS AVE | 1710539427000 | MTA | DEAD END (RA) | SAINT JOSEPHS AVE intersection | - | INSTALL BELOW ALL WAY | - | - | - | - | - | 78455 | 1420761600000 | -122.44167164 | 37.78223395 | - | 1420761600000 | - | D2 | - | OTHER WARNING | WARNING | W14-1A.0003 | 24X06 | SUP1 | LIGHT POLE | IS | 1419412140000 | OFARRELL ST | - | - | - | - | - | - |
| 61348 | N/A | Point | - | - | - | - | S220758 | BONVIEW ST: CORTLAND AVE | - | F | F | - | F | 21248000 | 21248000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BONVIEW ST | CORTLAND AVE | 116794 | 116794 | 37.73953344 | -122.41916532 | CORTLAND AVE \ BONVIEW ST | BONVIEW ST \ CORTLAND AVE | 1710539427000 | MTA | STOP | CORTLAND AVE intersection | - | X ST IS CORTLAND | - | - | - | - | - | 78456 | - | -122.41916532 | 37.73953344 | - | - | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1448012520000 | BONVIEW ST | - | - | - | - | - | - |
| 61349 | N/A | Point | - | - | - | - | S287616 | SARGENT ST: RAMSELL ST | - | F | F | - | F | 22694000 | 22694000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SARGENT ST | SARGENT ST | 116798 | 116798 | 37.71611251 | -122.46622006 | RAMSELL ST \ SARGENT ST | RAMSELL ST \ SARGENT ST | 1737583695000 | middleware_editor | NO U TURN (SYM) 7AM-9AM/12PM-2:30PM SCHOOL DAYS | SARGENT ST intersection | - | BACK OF STOP SIGN | - | - | - | - | - | 78457 | 1678665600000 | -122.46622006 | 37.71611251 | - | - | - | D11 | - | OTHER REGULATORY | REG | R3-4(SF).0009 | 30X42 | SUP2 | 2IN IRON POST | IS | 1677057300000 | RAMSELL ST | - | - | - | - | - | - |
| 61350 | N/A | Point | - | - | - | - | S287608 | SAN ANSELMO AVE: MONTEREY BLVD | - | F | F | - | F | 22903000 | 22903000 | - | - | NORTH EAST CORNER | - | - | - | - | MONTEREY BLVD \ SAN ANSELMO AVE | MONTEREY BLVD \ SANTA CLARA AVE | 116799 | 116799 | 37.7331529 | -122.46565868 | SANTA CLARA AVE \ MONTEREY BLVD \ SAN ANSELMO AVE | SAN ANSELMO AVE \ MONTEREY BLVD \ SANTA CLARA AVE | 1710539427000 | MTA | NO TRUCKS (SYM) OVER 3 TONS | MONTEREY BLVD \ SANTA CLARA AVE intersection | - | - | - | - | - | - | - | 78458 | - | -122.46565868 | 37.7331529 | - | 1680134400000 | - | D7 | - | OTHER REGULATORY | REG | R5-2.0006 | 30X36 | SUP2 | 3IN IRON POST | IS | 1676973360000 | SAN ANSELMO AVE | - | - | - | - | - | - |
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.