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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 85126 | N/A | Point | - | - | - | - | S252273 | CALIFORNIA ST: 16TH AVE | - | F | F | - | F | 27624000 | 27624000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 16TH AVE | CALIFORNIA ST | 88746 | 88746 | 37.78431946 | -122.47537073 | CALIFORNIA ST \ 16TH AVE | 16TH AVE \ CALIFORNIA ST | 1710539427000 | MTA | (45 LA-DN) | CALIFORNIA ST intersection | - | - | - | - | - | - | - | 102247 | 1552473600000 | -122.47537073 | 37.78431946 | - | - | - | D1 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP2 | UTILITY POLE | IS | 1552296660000 | 16TH AVE | - | - | - | - | - | - |
| 85127 | N/A | Point | 1 | 1 | 341 - 489 | - | S234459 | 0-489 BAYSHORE BLVD | 341-489 BAY SHORE BLVD | F | F | - | F | 2800102 | 2800102 | - | - | CENTER ISLAND | - | - | - | - | FLOWER ST | FLOWER ST | 69060 | 69060 | 37.7410481 | -122.40642678 | - | - | 1710539427000 | MTA | MUNI LANDOR FLAG - TYPE 6 | FLOWER ST to CORTLAND AVE (341 - 489) -- EAST -- | - | 15' SOUTH OF FLOWER | - | - | - | - | - | 102248 | 1490261640000 | -122.40642678 | 37.7410481 | - | 1490227200000 | - | D10 | - | OTHER REGULATORY | REG | R(SF).0334 | 15X39 | SUP1 | MUNI LANDOR POLE 3" X121" | IS | 1489755240000 | BAY SHORE BLVD | 341 - 489 BAY SHORE BLVD | 341 - 489 BAY SHORE BLVD | 341 BAY SHORE BLVD | - | CORTLAND AVE | CORTLAND AVE |
| 85128 | N/A | Point | - | - | - | - | S120853 | NAPLES ST: EXCELSIOR AVE | - | F | F | - | F | 21642000 | 21642000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | NAPLES ST | EXCELSIOR AVE | 20108 | 20108 | 37.724063476 | -122.428879445 | EXCELSIOR AVE \ NAPLES ST | NAPLES ST \ EXCELSIOR AVE | 1710539427000 | MTA | ALL WAY | EXCELSIOR AVE intersection | - | - | - | - | - | - | - | 102249 | 1113868800000 | -122.42883653 | 37.72395457 | - | 1540857600000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373574060000 | NAPLES ST | - | - | - | - | - | - |
| 85129 | N/A | Point | - | - | - | - | S117164 | 23RD ST: ALABAMA ST | - | F | F | - | F | 23977000 | 23977000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 23RD ST | ALABAMA ST | 12436 | 12436 | 37.75428677 | -122.41112013 | ALABAMA ST \ 23RD ST | 23RD ST \ ALABAMA ST | 1710539427000 | MTA | ALL WAY | ALABAMA ST intersection | - | NECORNER | - | - | - | - | - | 102250 | 1057622400000 | -122.41112013 | 37.75428677 | - | - | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572920000 | 23RD ST | - | - | - | - | - | - |
| 85130 | N/A | Point | - | - | - | - | S120293 | AVALON AVE: NAPLES ST | - | F | F | - | F | 21646000 | 21646000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | NAPLES ST | AVALON AVE | 14463 | 14463 | 37.72551991 | -122.42768438 | AVALON AVE \ NAPLES ST | NAPLES ST \ AVALON AVE | 1751406683000 | middleware_editor | ALL WAY | AVALON AVE intersection | - | - | - | - | - | - | - | 102251 | 1107504000000 | -122.42768438 | 37.72551991 | - | 1751405700000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573880000 | NAPLES ST | - | - | - | - | - | - |
| 85131 | N/A | Point | - | - | - | - | S110466 | NAPLES ST: AVALON AVE | - | F | F | - | F | 21646000 | 21646000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | NAPLES ST | AVALON AVE | 7138 | 7138 | 37.72551991 | -122.42768438 | AVALON AVE \ NAPLES ST | NAPLES ST \ AVALON AVE | 1751406689000 | middleware_editor | STOP | AVALON AVE intersection | - | 18S / 0 | - | - | - | - | - | 102252 | 642236400000 | -122.42768438 | 37.72551991 | - | 1751398800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570820000 | NAPLES ST | - | - | - | - | - | - |
| 85132 | N/A | Point | - | - | - | - | S110465 | NAPLES ST: AVALON AVE | - | F | F | - | F | 21646000 | 21646000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | NAPLES ST | AVALON AVE | 7137 | 7137 | 37.72551991 | -122.42768438 | AVALON AVE \ NAPLES ST | NAPLES ST \ AVALON AVE | 1751406694000 | middleware_editor | STOP | AVALON AVE intersection | - | 0 / NPL 198 | - | - | - | - | - | 102253 | 642236400000 | -122.42768438 | 37.72551991 | - | 1751393400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570820000 | NAPLES ST | - | - | - | - | - | - |
| 85133 | N/A | Point | - | - | - | - | S104419 | ALABAMA ST: 23RD ST | - | F | F | - | F | 23977000 | 23977000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 23RD ST | ALABAMA ST | 5131 | 5131 | 37.75428677 | -122.41112013 | ALABAMA ST \ 23RD ST | 23RD ST \ ALABAMA ST | 1710539427000 | MTA | STOP | ALABAMA ST intersection | - | 0 / 0 | - | - | - | - | - | 102254 | -4233600000 | -122.41112013 | 37.75428677 | - | 724464000000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568900000 | 23RD ST | - | - | - | - | - | - |
| 85134 | N/A | Point | - | - | - | - | S106459 | AVALON AVE: NAPLES ST | - | F | F | - | F | 21646000 | 21646000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | NAPLES ST | AVALON AVE | 78339 | 78339 | 37.72551991 | -122.42768438 | AVALON AVE \ NAPLES ST | NAPLES ST \ AVALON AVE | 1751406717000 | middleware_editor | STOP | AVALON AVE intersection | - | 0 / 0 | - | - | - | - | - | 102255 | 141289200000 | -122.42768438 | 37.72551991 | - | 1751395800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373569560000 | NAPLES ST | - | - | - | - | - | - |
| 85135 | N/A | Point | 1 | 1 | 400 - 499 | - | S262470 | 400-499 PARIS ST | 400-499 PARIS ST | F | F | - | F | 10254000 | 10254000 | - | - | WEST SIDE | - | - | - | - | PERSIA AVE | PERSIA AVE | 103469 | 103469 | 37.72160441 | -122.43499571 | - | - | 1710539427000 | MTA | BIKE RACK | PERSIA AVE to RUSSIA AVE (400 - 499) | 146216 | 25 N OF PERSIA/4' IN FROM CURB | - | - | - | - | - | 102256 | 1585578000000 | -122.43499571 | 37.72160441 | - | - | - | D11 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1583921820000 | PARIS ST | 400 - 499 PARIS ST | 400 - 499 PARIS ST | 400 PARIS ST | - | RUSSIA AVE | RUSSIA AVE |
| 85136 | N/A | Point | 1 | 1 | 400 - 499 | - | S262467 | 400-499 PARIS ST | 400-499 PARIS ST | F | F | - | F | 10254000 | 10254000 | - | - | WEST SIDE | - | - | - | - | PERSIA AVE | PERSIA AVE | 103466 | 103466 | 37.72160441 | -122.43499571 | - | - | 1710539427000 | MTA | BIKE RACK | PERSIA AVE to RUSSIA AVE (400 - 499) | 146216 | 7' N OF PERSIA/4' IN FROM CURB | - | - | - | - | - | 102257 | 1585573200000 | -122.43499571 | 37.72160441 | - | - | - | D11 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1583921520000 | PARIS ST | 400 - 499 PARIS ST | 400 - 499 PARIS ST | 400 PARIS ST | - | RUSSIA AVE | RUSSIA AVE |
| 85137 | N/A | Point | 1 | 1 | 500 - 599 | - | S127681 | 500-599 MADRID ST | 500-599 MADRID ST | F | F | - | F | 8608000 | 8608000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | PERSIA AVE | PERSIA AVE | 21250 | 21250 | 37.72084079 | -122.43339554 | - | - | 1710539427000 | MTA | SPEED HUMP | PERSIA AVE to RUSSIA AVE (500 - 599) | - | 20`SOUTH | - | - | - | - | - | 102258 | 1182297600000 | -122.43339554 | 37.72084079 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373576220000 | MADRID ST | 500 - 599 MADRID ST | 500 - 599 MADRID ST | 500 MADRID ST | - | RUSSIA AVE | RUSSIA AVE |
| 85138 | N/A | Point | 1 | 1 | 500 - 599 | - | S127680 | 500-599 MADRID ST | 500-599 MADRID ST | F | F | - | F | 8608000 | 8608000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | PERSIA AVE | PERSIA AVE | 21249 | 21249 | 37.72084079 | -122.43339554 | - | - | 1710539427000 | MTA | SPEED HUMP | PERSIA AVE to RUSSIA AVE (500 - 599) | - | 6`NORTH OF RUSSIA (IFO TREE) | - | - | - | - | - | 102259 | 1182297600000 | -122.43339554 | 37.72084079 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373576220000 | MADRID ST | 500 - 599 MADRID ST | 500 - 599 MADRID ST | 500 MADRID ST | - | RUSSIA AVE | RUSSIA AVE |
| 85139 | N/A | Point | - | - | - | - | S266638 | ORTEGA ST: 20TH AVE | - | F | F | - | F | 27334000 | 27334000 | - | - | NORTH WEST CORNER | - | - | - | - | ORTEGA ST | 20TH AVE | 100712 | 100712 | 37.7523291 | -122.47741498 | 20TH AVE \ ORTEGA ST | ORTEGA ST \ 20TH AVE | 1710539427000 | MTA | ORTEGA ST | 20TH AVE intersection | - | 1300 | - | - | - | - | - | 102260 | 1546560000000 | -122.47741498 | 37.7523291 | - | 1603324800000 | - | D4 | - | STREET NAME | GUIDE | D3-1.1322 | 36X08 | SUP2 | 3IN IRON POST | IS | 1595935080000 | ORTEGA ST | - | - | - | - | - | - |
| 85140 | N/A | Point | - | - | - | - | S281049 | 20TH AVE: ORTEGA ST | - | F | F | - | F | 27334000 | 27334000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ORTEGA ST | 20TH AVE | 115656 | 115656 | 37.7523291 | -122.47741498 | 20TH AVE \ ORTEGA ST | ORTEGA ST \ 20TH AVE | 1710539427000 | MTA | STOP | 20TH AVE intersection | 122047752 | - | - | - | - | - | - | 102261 | 1099699200000 | -122.47741498 | 37.7523291 | - | - | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1645522380000 | ORTEGA ST | - | - | - | - | - | - |
| 85141 | N/A | Point | - | - | - | - | S266648 | 20TH AVE: ORTEGA ST | - | F | F | - | F | 27334000 | 27334000 | - | - | NORTH WEST CORNER | - | - | - | - | ORTEGA ST | 20TH AVE | 100714 | 100714 | 37.7523291 | -122.47741498 | 20TH AVE \ ORTEGA ST | ORTEGA ST \ 20TH AVE | 1710539427000 | MTA | 20TH AVE | 20TH AVE intersection | - | - | - | - | - | - | - | 102262 | 1546560000000 | -122.47741498 | 37.7523291 | - | 1603411200000 | - | D4 | - | STREET NAME | GUIDE | D3-1.1944 | 36X08 | SUP2 | 3IN IRON POST | IS | 1595940780000 | ORTEGA ST | - | - | - | - | - | - |
| 85142 | N/A | Point | - | - | - | - | S250342 | 20TH AVE: ORTEGA ST | - | T | T | - | F | 27334000 | 27334000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ORTEGA ST | 20TH AVE | 84856 | 84856 | 37.7523291 | -122.47741498 | 20TH AVE \ ORTEGA ST | ORTEGA ST \ 20TH AVE | 1710539427000 | MTA | BIKE WAYFINDING SIGN | 20TH AVE intersection | 0331 | ON TOP OF STOP SIGN ADD EXTENSION | - | - | - | - | - | 102263 | 1546609680000 | -122.47741498 | 37.7523291 | - | - | - | D4 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | 2IN IRON POST | IS | 1545130800000 | ORTEGA ST | - | - | - | - | - | - |
| 85143 | N/A | Point | - | - | - | - | S119698 | 20TH AVE: ORTEGA ST | - | F | F | - | F | 27334000 | 27334000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ORTEGA ST | 20TH AVE | 13888 | 13888 | 37.7523291 | -122.47741498 | 20TH AVE \ ORTEGA ST | ORTEGA ST \ 20TH AVE | 1721136077000 | middleware_editor | ALL WAY | 20TH AVE intersection | 122047752 | - | - | - | - | - | - | 102264 | 1099699200000 | -122.47741498 | 37.7523291 | - | 1721057100000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573700000 | ORTEGA ST | - | - | - | - | - | - |
| 85144 | N/A | Point | - | - | - | - | S100461 | 20TH AVE: ORTEGA ST | - | F | F | - | F | 27334000 | 27334000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ORTEGA ST | 20TH AVE | 567 | 567 | 37.7523291 | -122.47741498 | 20TH AVE \ ORTEGA ST | ORTEGA ST \ 20TH AVE | 1750771348000 | middleware_editor | STOP | 20TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 102265 | -403981200000 | -122.47741498 | 37.7523291 | - | 1464850800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373566440000 | ORTEGA ST | - | - | - | - | - | - |
| 85145 | N/A | Point | - | - | - | - | 22144 | - | - | F | F | - | F | 33284000 | - | - | - | WEST SIDE | 1691792954000 | APADILLA | - | - | BAY SHORE BLVD | - | 146290 | 146290 | 37.7424255678881 | -122.405912879454 | COSGROVE ST \ BAY SHORE BLVD | - | 1710539427000 | MTA | NPRK 12MN-6AM MON WED FRI SAT STCL | - | - | 310FT SOUT OF OAKDALE | - | - | - | - | - | 102266 | - | - | - | - | - | - | 09 | - | STREET CLEANING | REG | R30B(CA).0050 | 18X18 | SUP3 | LIGHT POLE | PI | - | COSGROVE ST | - | - | - | - | - | - |
| 85146 | N/A | Point | - | - | - | - | S261938 | CYRIL MAGNIN ST: ELLIS ST | - | F | F | - | F | 5170000 | 24895000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | POWELL ST | ELLIS ST | 98978 | 98978 | 37.78538825 | -122.40866708 | - | CYRIL MAGNIN ST \ ELLIS ST | 1729127849000 | middleware_editor | NO RIGHT TURN (SYM) | ELLIS ST intersection | - | - | - | - | - | - | - | 102267 | 1323129600000 | -122.40866708 | 37.78538825 | - | 1682467200000 | - | D6 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1582719840000 | CYRIL MAGNIN ST | 100 - 148 ELLIS ST | - | - | - | CYRIL MAGNIN ST | - |
| 85147 | N/A | Point | 1 | 1 | 1296 - 1365 | - | S121211 | 1296-1365 POTRERO AVE | 1296-1365 POTRERO AVE | F | F | - | F | 10673000 | 10673000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 25TH ST | 25TH ST | 17951 | 17951 | 37.75154656 | -122.40620299 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM) | 25TH ST to 25TH ST \ CESAR CHAVEZ ON RAMP (1296 - 1365) | - | APPROXIMATELY 75' S OF 25TH ST | - | - | - | - | - | 102268 | 1120089600000 | -122.40620299 | 37.75154656 | - | - | - | D10 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373574180000 | POTRERO AVE | 1296 - 1365 POTRERO AVE | 1296 - 1365 POTRERO AVE | 1296 POTRERO AVE | - | 25TH ST \ CESAR CHAVEZ ON RAMP | 25TH ST \ CESAR CHAVEZ ON RAMP |
| 85148 | N/A | Point | 1 | 1 | 1296 - 1365 | - | S128328 | 1296-1365 POTRERO AVE | 1296-1365 POTRERO AVE | F | F | - | F | 10673000 | 10673000 | - | - | EAST SIDE | - | - | - | - | 25TH ST | 25TH ST | 21938 | 21938 | 37.75154656 | -122.40620299 | - | - | 1710539427000 | MTA | NPRK 6AM-8AM TUE THUR STCL | 25TH ST to 25TH ST \ CESAR CHAVEZ ON RAMP (1296 - 1365) | - | 150FT.NORTH OF C.CHAVEZ | - | - | - | - | - | 102269 | 1196812800000 | -122.40620299 | 37.75154656 | - | 1660694400000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0195 | 18X18 | SUP1 | LIGHT POLE | IS | 1373576400000 | POTRERO AVE | 1296 - 1365 POTRERO AVE | 1296 - 1365 POTRERO AVE | 1296 POTRERO AVE | - | 25TH ST \ CESAR CHAVEZ ON RAMP | 25TH ST \ CESAR CHAVEZ ON RAMP |
| 85149 | N/A | Point | - | - | - | - | S283240 | MONTEREY BLVD: FAXON AVE | - | F | F | - | F | 33598000 | 33598000 | - | - | NORTH SIDE, NORTHBOUND TRAFFIC | - | - | - | - | FAXON AVE | FAXON AVE | 93451 | 93451 | 37.730760005 | -122.458628143 | MONTEREY BLVD \ FAXON AVE | MONTEREY BLVD \ FAXON AVE | 1710539427000 | MTA | ONE WAY (RA) | FAXON AVE intersection | - | AT INTERSECTION ON EASTBOUND SIDE | - | - | - | - | - | 102270 | - | -122.45868894 | 37.73075152 | - | 1667779200000 | - | 07 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP3 | RETAINING WALL | IS | 1654525020000 | MONTEREY BLVD | - | - | - | - | - | - |
| 85150 | N/A | Point | - | - | - | - | S253168 | GREAT HWY: SLOAT BLVD | - | F | F | - | F | 32904000 | 32904000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SLOAT BLVD | GREAT HWY | 95141 | 95141 | 37.7352936043524 | -122.506576180453 | GREAT HWY \ SLOAT BLVD | SLOAT BLVD \ GREAT HWY | 1738353086000 | middleware_editor | BIKE WAYFINDING SIGN | GREAT HWY intersection | 0542 | 0 / 00 | - | - | - | - | - | 102271 | 538617600000 | -122.50671743 | 37.73546976 | - | 1554768000000 | - | 07 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP3 | 2IN IRON POST | IS | 1554373800000 | SLOAT BLVD | - | - | - | - | - | - |
| 85151 | N/A | Point | - | - | - | - | S266068 | INDIANA ST: TULARE ST | - | F | F | - | F | 51875000 | 51875000 | - | - | WEST SIDE | - | - | - | - | INDIANA ST | TULARE ST | 96339 | 96339 | 37.74760674 | -122.39017488 | TULARE ST \ INDIANA ST | INDIANA ST \ TULARE ST | 1710539427000 | MTA | TANSAT | TULARE ST intersection | - | X-ST IS TULARE, 5' NORTH OF TULARE ST. | - | - | - | - | - | 102272 | 1594718700000 | -122.39017488 | 37.74760674 | - | - | - | 10 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1594377300000 | INDIANA ST | - | - | - | - | - | - |
| 85152 | N/A | Point | 1 | 1 | 1500 - 1588 | - | S264124 | PNDG MARKET ST | 1500-1588 MARKET ST | F | F | - | T | 8755201 | 8755201 | - | - | CENTER ISLAND | - | - | - | - | SOUTH VAN NESS AVE \ VAN NESS AVE | SOUTH VAN NESS AVE \ VAN NESS AVE | 97348 | 97348 | 37.77478137 | -122.41979084 | - | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | SOUTH VAN NESS AVE \ VAN NESS AVE to 12TH ST \ PAGE ST (1500 - 1588) -- NORTH -- | 15692 | BUS ISLAND | - | - | - | - | - | 102273 | 1431475200000 | -122.41979084 | 37.77478137 | - | 1431475200000 | - | 06 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP1 | UNISTRUT | IS | 1589281200000 | MARKET ST | PNDG MARKET ST | 1500 - 1588 MARKET ST | - | - | 12TH ST \ PAGE ST | 12TH ST \ PAGE ST |
| 85153 | N/A | Point | 1 | 1 | 600 - 699 | - | S264127 | PNDG MARKET ST | 600-699 ODD FELLOWS WAY | F | F | - | T | 12172000 | 12172000 | - | - | SOUTH SIDE | - | - | - | - | 07TH ST \ STEVENSON ST | 07TH ST \ STEVENSON ST | 97626 | 97626 | 37.77948434 | -122.41259035 | - | - | 1710539427000 | MTA | MUNI LANDOR FLAG - TYPE 6 | 07TH ST \ STEVENSON ST to END: 600-699 BLOCK (600 - 699) | 15649 | IFO 1139 | - | - | - | - | - | 102274 | 1431475200000 | -122.41259035 | 37.77948434 | - | 1431475200000 | - | 06 | - | OTHER REGULATORY | REG | R(SF).0334 | 15X39 | SUP1 | UNISTRUT | IS | 1589281860000 | ODD FELLOWS WAY | PNDG MARKET ST | 600 - 699 ODD FELLOWS WAY | - | - | END: 600-699 BLOCK | END: 600-699 BLOCK |
| 85154 | N/A | Point | 1 | 1 | 1590 - 1598 | - | S261525 | 1600-1660 MARKET ST | 1590-1598 MARKET ST | T | T | - | F | 8756201 | 8756201 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 12TH ST \ PAGE ST | 12TH ST \ PAGE ST | 97751 | 97751 | 37.774370028 | -122.42064356 | - | - | 1710539427000 | MTA | LEFT LANE MUNI, AC TRANSIT & TAXIS ONLY AHEAD | 12TH ST \ PAGE ST to FRANKLIN ST (1590 - 1598) -- NORTH -- | - | IFO# 1621 MARKET ST/ LOCAL 38 BUILDING | - | - | - | - | - | 102275 | - | -122.42050945 | 37.77420678 | - | - | - | 06 | - | TRANSIT ONLY(LEFT LANE) | REG | SR60-1(SF).0009 | 30X42 | SUP1 | LIGHT POLE | IS | 1581686940000 | MARKET ST | 1590 - 1598 MARKET ST | 1590 - 1598 MARKET ST | 1590 MARKET ST | - | FRANKLIN ST | FRANKLIN ST |
| 85155 | N/A | Point | - | - | - | - | S261923 | MANSELL ST: BRAZIL AVE | - | T | T | - | F | 33338000 | 33338000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | MANSELL ST | BRAZIL AVE | 97762 | 97762 | 37.71788738 | -122.42247299 | BRAZIL AVE \ MANSELL ST | MANSELL ST \ BRAZIL AVE | 1710539427000 | MTA | BIKE WAYFINDING SIGN | BRAZIL AVE intersection | 1466 | ABOVE SIGN AND BOX | - | - | - | - | - | 102276 | 1583405460000 | -122.42247299 | 37.71788738 | - | - | - | 10 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | LIGHT POLE | IS | 1582714020000 | MANSELL ST | - | - | - | - | - | - |
| 85156 | N/A | Point | - | - | - | - | S261933 | MANSELL ST: VISITACION AVE | - | F | F | - | F | 33350000 | 33350000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VISITACION AVE | VISITACION AVE | 97765 | 97765 | 37.7187541 | -122.41167332 | MANSELL ST \ VISITACION AVE | MANSELL ST \ VISITACION AVE | 1730737633000 | middleware_editor | BIKE (SYM) BIKE ROUTE | VISITACION AVE intersection | 1469 | BIKE PATH ABOVE MINI STOP SIGN | - | - | - | - | - | 102277 | 1583323380000 | -122.41167332 | 37.7187541 | - | - | - | 09 | - | BIKE GUIDE | GUIDE | D11-1C.0002 | 24X18 | SUP3 | 2IN IRON POST | IS | 1582716900000 | MANSELL ST | - | - | - | - | - | - |
| 85157 | N/A | Point | - | - | - | - | S266937 | ROMAIN ST: MARKET ST | - | F | F | - | F | 26105000 | 26105000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MARKET ST | MARKET ST | 98631 | 98631 | 37.75621849 | -122.44099876 | ROMAIN ST \ MARKET ST | ROMAIN ST \ MARKET ST | 1710539427000 | MTA | REMOVE (SF BIKE ROUTE) GREEN (SYM) # | MARKET ST intersection | 1540 | RPLC EXISTNG;DO NOT RMV 'MUST USE OVRPS' | - | - | - | - | - | 102278 | - | -122.44099876 | 37.75621849 | - | - | - | 08 | - | BIKE REG | REG | R(SF).0388 | 12X24 | SUP3 | LIGHT POLE | IS | 1596784200000 | ROMAIN ST | - | - | - | - | - | - |
| 85158 | N/A | Point | - | - | - | - | S285995 | MIRANDO WAY: ROTTECK ST | - | F | F | - | F | 21924000 | 21924000 | - | - | EAST SIDE | - | - | - | - | ROTTECK ST | ROTTECK ST | 98926 | 98926 | 37.73269355 | -122.43105067 | MIRANDO WAY \ ROTTECK ST | MIRANDO WAY \ ROTTECK ST | 1755102615000 | middleware_editor | NPRK ANY TIME | ROTTECK ST intersection | - | 130FT NORTH | - | - | - | - | - | 102279 | - | -122.43105067 | 37.73269355 | - | 1671004800000 | - | 08 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0002 | 18X18 | SUP3 | 2IN IRON POST | IS | 1668604380000 | MIRANDO WAY | - | - | - | - | - | - |
| 85159 | N/A | Point | - | - | - | - | S287313 | MANSELL ST: BRAZIL AVE | - | T | T | - | F | 33338000 | 33338000 | - | - | NORTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | MANSELL ST | BRAZIL AVE | 99095 | 99095 | 37.71788738 | -122.42247299 | BRAZIL AVE \ MANSELL ST | MANSELL ST \ BRAZIL AVE | 1710539427000 | MTA | (90 RA) CURVE (SYM) | BRAZIL AVE intersection | - | 125FT EAST OF BRAZIL/PERSIA | - | - | - | - | - | 102280 | 1490140800000 | -122.42247299 | 37.71788738 | - | - | - | 10 | - | OTHER WARNING | WARNING | W1-1.0005 | 30X30 | SUP1 | LIGHT POLE | IS | 1675177260000 | MANSELL ST | - | - | - | - | - | - |
| 85160 | N/A | Point | - | - | - | - | S287525 | 20TH ST: SAN BRUNO AVE | - | F | F | - | F | 23766000 | 23766000 | - | - | SOUTH EAST CORNER | - | - | - | - | 20TH ST | 20TH ST | 99420 | 99420 | 37.7595025 | -122.40497186 | SAN BRUNO AVE \ 20TH ST | SAN BRUNO AVE \ 20TH ST | 1710539427000 | MTA | 20TH ST | 20TH ST intersection | - | - | - | - | - | - | - | 102281 | - | -122.40497186 | 37.7595025 | - | 1676246400000 | - | 10 | - | STREET NAME | GUIDE | D3-1.0012 | 36X08 | SUP1 | LIGHT POLE | IS | 1676374560000 | SAN BRUNO AVE | - | - | - | - | - | - |
| 85161 | N/A | Point | 1 | 1 | 400 - 499 | LEFT ARROW | S260607 | 400-499 HANOVER ST | 400-499 HANOVER ST | F | F | - | F | 6670000 | 6670000 | - | - | EAST SIDE | - | - | - | - | LOWELL ST | LOWELL ST | 100242 | 100242 | 37.708271606 | -122.44563797 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM TUE STCL | LOWELL ST to WHITTIER ST (400 - 499) | - | 100 FT SOUTH OF LOWELL OPP 434 | - | - | - | - | - | 102282 | 1590157440000 | -122.44592586 | 37.70821502 | - | - | - | 11 | - | STREET CLEANING | REG | R30B(CA).0308 | 18X18 | SUP3 | 2IN IRON POST | IS | 1579689660000 | HANOVER ST | 400 - 499 HANOVER ST | 400 - 499 HANOVER ST | 400 HANOVER ST | - | WHITTIER ST | WHITTIER ST |
| 85162 | N/A | Point | 1 | 1 | 400 - 499 | RIGHT ARROW | S260609 | 400-499 HANOVER ST | 400-499 HANOVER ST | F | F | - | F | 6670000 | 6670000 | - | - | WEST SIDE | - | - | - | - | LOWELL ST | LOWELL ST | 100243 | 100243 | 37.708355071 | -122.445663898 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM FRI STCL | LOWELL ST to WHITTIER ST (400 - 499) | - | IFO 434 | - | - | - | - | - | 102283 | - | -122.44592586 | 37.70821502 | - | - | - | 11 | - | STREET CLEANING | REG | R30B(CA).0076 | 18X18 | SUP3 | 2IN IRON POST | IS | 1579689900000 | HANOVER ST | 400 - 499 HANOVER ST | 400 - 499 HANOVER ST | 400 HANOVER ST | - | WHITTIER ST | WHITTIER ST |
| 85163 | N/A | Point | - | - | - | - | 21035 | - | - | F | F | - | F | 11975000 | - | - | - | - | 1689262588000 | wdwilli | - | - | CAMPBELL AVE | - | 141315 | 141315 | 37.71438137 | -122.402481349 | - | - | 1747257851000 | middleware_editor | NPRK 9AM-11AM 2ND & 4TH MON OF MONTH STCL | - | - | - | - | - | - | - | - | 102284 | - | - | - | - | - | - | 10 | - | STREET CLEANING | REG | R30B(CA).0294 | 18X18 | SUP1 | - | RETD | - | SOMERSET ST | 1400 - 1499 SOMERSET ST | - | - | - | SAN BRUNO AVE | - |
| 85164 | N/A | Point | - | - | - | - | 21036 | - | - | F | F | - | F | - | - | - | - | - | 1689262735000 | wdwilli | - | - | - | - | 141425 | 141425 | 37.714401528 | -122.402397529 | - | - | 1736201795000 | middleware_editor | NPRK 12NN-3PM MON STCL | - | - | 100'S.CAMPBELL ST | - | - | - | - | - | 102285 | - | - | - | - | 1690362960000 | - | 10 | - | STREET CLEANING | REG | R30B(CA).0088 | 18X18 | SUP1 | 2IN IRON POST | IS | - | - | - | - | - | - | - | - |
| 85165 | N/A | Point | - | - | - | - | S249067 | - | - | NO | NO | - | - | - | - | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1691445421000 | MTA | - | - | CORAL RD | - | 145383 | 145383 | 37.752612 | -122.39926 | - | - | 1710539427000 | MTA | SCHOOL (SYM) | - | - | - | - | - | - | - | - | 102286 | - | -122.39926 | 37.752612 | - | - | - | 10 | - | SCHOOL | WARNING | S1-1.0002 | 30X30 | SUP1 | LIGHT POLE | In Service | - | - | - | - | - | - | CAIRE TER | - |
| 85166 | N/A | Point | - | - | - | - | S250712 | - | - | NO | NO | - | - | - | - | - | - | NORTH SIDE | 1691445421000 | MTA | - | - | JENNINGS ST | - | 145387 | 145387 | 37.725074 | -122.391858 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM DAILY | - | - | - | - | - | - | - | - | 102287 | - | -122.391858 | 37.725074 | - | - | - | 10 | - | PARKING | REG | R30(CA).0045 | 18X18 | SUP1 | 2IN IRON POST | In Service | - | - | - | - | - | - | KEITH ST | - |
| 85167 | N/A | Point | - | - | - | - | S101670 | - | - | NO | NO | - | - | - | - | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | 1691445421000 | MTA | - | - | SAN JOSE AVE | - | 145421 | 145421 | 37.755268 | -122.421435 | 22ND ST \ SAN JOSE AVE | - | 1710539427000 | MTA | STOP | - | - | - | - | - | - | - | - | 102288 | - | -122.421435 | 37.755268 | - | - | - | 09 | - | STOP | REG | R1-1.0002 | 30X30 | SUP3 | UNKNOWN | In Service | - | - | - | - | - | - | - | - |
| 85168 | N/A | Point | - | - | - | - | S119476 | - | - | NO | NO | - | - | - | - | - | - | WEST SIDE | 1691445421000 | MTA | - | - | - | - | 145429 | 145429 | 37.757834 | -122.418977 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $100 FINE IMPOSED ETC | - | - | - | - | - | - | - | - | 102289 | - | -122.418977 | 37.757834 | - | - | - | 09 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0001 | 18X21 | SUP3 | LIGHT POLE | In Service | - | - | - | - | - | - | - | - |
| 85169 | N/A | Point | - | - | - | - | S282269 | ACACIA AVE: FAIRFAX AVE | - | F | F | - | F | 35017000 | - | - | - | SOUTH EAST CORNER | - | - | - | - | FAIRFAX AVE | - | 114712 | 114712 | 37.7368 | -122.381 | ACACIA AVE \ FAIRFAX AVE | - | 1710539427000 | MTA | NPRK 8AM-10AM THUR STCL | - | - | - | - | - | - | - | - | 102290 | 1652227200000 | -122.381 | 37.7368 | - | - | - | 10 | - | STREET CLEANING | REG | R30B(CA).0267 | 18X18 | SUP1 | LIGHT POLE | IS | 1650019800000 | - | - | - | - | - | - | - |
| 85170 | N/A | Point | - | - | - | - | S287129 | MANSELL ST: BRAZIL AVE | - | T | T | - | F | 33338000 | 33338000 | - | - | NORTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | MANSELL ST | BRAZIL AVE | 116518 | 116518 | 37.71788738 | -122.42247299 | BRAZIL AVE \ MANSELL ST | MANSELL ST \ BRAZIL AVE | 1710539427000 | MTA | SPEED LIMIT 30 | BRAZIL AVE intersection | - | 125FT EAST OF PERSIA/BRAZIL | - | - | - | - | - | 102291 | 1674086400000 | -122.42247299 | 37.71788738 | - | - | - | 10 | - | SPEED LIMIT | REG | R2-1.0009 | 36X45 | SUP1 | LIGHT POLE | IS | 1674139380000 | MANSELL ST | - | - | - | - | - | - |
| 85171 | N/A | Point | 1 | 1 | 700 - 799 | - | S262080 | 700-773 4TH ST | 700-799 04TH ST | F | F | - | F | 267001 | 267001 | - | - | WEST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | TOWNSEND ST | TOWNSEND ST | 116721 | 116721 | 37.77671116 | -122.39450827 | - | - | 1710539427000 | MTA | PASSENGER LOADING PICK-UP DROPP-OFF A TO Z | TOWNSEND ST to KING ST (700 - 799) | - | 85' SOUTH OF TOWNSEND ( E ) | - | - | - | - | - | 102292 | 1406678400000 | -122.39450827 | 37.77671116 | - | 1583712000000 | - | 06 | - | OTHER GUIDE | GUIDE | G-W(SF).0006 | 24X24 | SUP1 | 2IN IRON POST | IS | 1583151840000 | 04TH ST | 700-773 4TH ST | 700 - 799 04TH ST | - | - | KING ST | KING ST |
| 85172 | N/A | Point | - | - | - | - | S242415 | PENNSYLVANIA AVE: I-280 S OFF | - | F | F | - | F | 52251000 | 52251000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PENNSYLVANIA AVE | PENNSYLVANIA AVE | 116732 | 116732 | 37.76329621 | -122.39366263 | \PENNSYLVANIA AVE: I-280 S OFF | I-280 S OFF RAMP \ PENNSYLVANIA AVE | 1710539427000 | MTA | ALL WAY | PENNSYLVANIA AVE intersection | - | X ST IS I-280 OFF- RAMP | - | - | - | - | - | 102293 | 1516881420000 | -122.39366263 | 37.76329621 | - | 1516838400000 | - | 10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1516356600000 | I-280 S OFF RAMP | - | - | - | - | - | - |
| 85173 | N/A | Point | - | - | - | - | S254092 | HOLLOWAY AVE: TAPIA DR | - | F | F | - | F | 23102000 | 23102000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HOLLOWAY AVE | TAPIA DR | 116927 | 116927 | 37.72097222 | -122.48066941 | TAPIA DR \ HOLLOWAY AVE | HOLLOWAY AVE \ TAPIA DR | 1710539427000 | MTA | BIKE (SYM) BIKE ROUTE | TAPIA DR intersection | 0723 | IFO 603 FONT | - | - | - | - | - | 102294 | 1578308160000 | -122.48066941 | 37.72097222 | - | - | - | 07 | - | BIKE GUIDE | GUIDE | D11-1C.0002 | 24X18 | SUP3 | LIGHT POLE | IS | 1556889240000 | HOLLOWAY AVE | - | - | - | - | - | - |
| 85174 | N/A | Point | 1 | - | - | - | S122575 | 1-299 TELEGRAPH HILL BLVD | - | F | F | - | F | 12479000 | 12479000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | - | - | 117406 | 117406 | 37.80258264 | -122.40606944 | - | - | 1710539427000 | MTA | PEDESTRIAN (SYM) XING/(45 LA-DN) | - | - | 80'SOUTH OF SPL # 201 @ X-WALK | - | - | - | - | - | 102295 | 1138320000000 | -122.40606944 | 37.80258264 | - | - | - | 03 | - | PEDESTRIAN(LA DN) | WARNING | W11-2+SW44(CA).01 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373574600000 | TELEGRAPH HILL BLVD | 1-299 TELEGRAPH HILL BLVD | TELEGRAPH HILL BLVD | - | - | - | - |
| 85175 | N/A | Point | - | - | - | - | S277049 | SAN JOSE AVE: TINGLEY ST | - | F | F | - | F | 52093000 | 52093000 | - | - | EAST SIDE, EASTBOUND TRAFFIC | - | - | - | - | TINGLEY ST | TINGLEY ST | 117744 | 117744 | 37.7311206 | -122.43614692 | SAN JOSE AVE \ TINGLEY ST | SAN JOSE AVE \ TINGLEY ST | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | TINGLEY ST intersection | - | EASTSIDE OF TRACK IN MUNI YARD. | - | - | - | - | - | 102296 | 1628726400000 | -122.43614692 | 37.7311206 | - | 1628726400000 | - | 11 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP3 | MUNI POLE | IS | 1628594100000 | SAN JOSE AVE | - | - | - | - | - | - |
| 85176 | N/A | Point | 1 | 1 | 1 - 199 | - | S212317 | 1-99 VELASCO AVE | 1-199 VELASCO AVE | F | F | - | F | 13189000 | 13189000 | - | - | NORTH SIDE | - | - | - | - | SCHWERIN ST | SCHWERIN ST | 118738 | 118738 | 37.708324928 | -122.413401438 | - | - | 1745441103000 | middleware_editor | NPRK 8AM-11AM MON STCL | SCHWERIN ST to ACACIA ST \ KELLOCH AVE (1 - 199) | - | 150' EAST OF KELLOCH | - | - | - | - | - | 102297 | 1423603560000 | -122.41332109 | 37.70825203 | - | 1745440500000 | - | 10 | - | STREET CLEANING | REG | R30B(CA).0275 | 18X18 | SUP1 | 2IN IRON POST | IS | 1420534740000 | VELASCO AVE | 1 - 199 VELASCO AVE | 1 - 199 VELASCO AVE | 1 VELASCO AVE | - | ACACIA ST \ KELLOCH AVE | ACACIA ST \ KELLOCH AVE |
| 85177 | N/A | Point | 1 | 1 | 1804 - 1896 | - | S247831 | 1800-1899 MARKET ST | 1804-1896 MARKET ST | F | F | - | F | 8760203 | 8760203 | - | - | SOUTH SIDE | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 118924 | 118924 | 37.77125261 | -122.4242868 | - | - | 1710539427000 | MTA | BIKE RACK | OCTAVIA ST to GUERRERO ST \ LAGUNA ST (1804 - 1896) -- NORTH -- | 27869 | 12' W OF EPL#1831/4' IN FROM CURB | - | - | - | - | - | 102298 | 1536062280000 | -122.4242868 | 37.77125261 | - | - | - | 08 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP3 | BIKE RACK | IS | 1534518600000 | MARKET ST | 1804 - 1896 MARKET ST | 1804 - 1896 MARKET ST | 1804 MARKET ST | - | GUERRERO ST \ LAGUNA ST | GUERRERO ST \ LAGUNA ST |
| 85178 | N/A | Point | 1 | 1 | 501 - 599 | - | S218228 | 501-599 MARKET ST | 501-599 MARKET ST | F | F | - | F | 8742101 | 8742101 | - | - | SOUTH SIDE | - | - | - | - | 1ST ST \ BUSH ST | 01ST ST \ BUSH ST | 119074 | 119074 | 37.79010997 | -122.40022309 | - | - | 1710539427000 | MTA | BIKE RACK (YERBA BUENA) | 01ST ST \ BUSH ST to 02ND ST (501 - 599) -- SOUTH -- | - | 165' WEST OF 1ST ST/CHIPOTLE | - | - | - | - | - | 102299 | - | -122.40022309 | 37.79010997 | - | - | - | 06 | - | BIKE RACK | REG | R(SF).0345 | 36X36 | SUP1 | BIKE RACK | IS | 1438166880000 | MARKET ST | 501 - 599 MARKET ST | 501 - 599 MARKET ST | 501 MARKET ST | - | 02ND ST | 02ND ST |
| 85179 | N/A | Point | 1 | 1 | 1400 - 1498 | - | S222788 | 1400-1498 MARKET ST | 1400-1498 MARKET ST | F | F | - | F | 8754201 | 8754201 | - | - | SOUTH SIDE | - | - | - | - | 10TH ST \ FELL ST \ POLK ST | 10TH ST \ FELL ST \ POLK ST | 119373 | 119373 | 37.77587096 | -122.41841244 | - | - | 1740604964000 | middleware_editor | FG 300 UR DELINEATOR (W) | 10TH ST \ FELL ST \ POLK ST to SOUTH VAN NESS AVE \ VAN NESS AVE (1400 - 1498) -- NORTH -- | - | FROM 10TH ST GOING WEST | - | - | - | - | - | 102300 | 1464172380000 | -122.41841244 | 37.77587096 | - | 1740572100000 | - | 06 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1453966200000 | MARKET ST | 1400 - 1498 MARKET ST | 1400 - 1498 MARKET ST | 1400 MARKET ST | - | SOUTH VAN NESS AVE \ VAN NESS AVE | SOUTH VAN NESS AVE \ VAN NESS AVE |
| 85180 | N/A | Point | - | - | - | - | S277046 | SAN JOSE AVE: TINGLEY ST | - | F | F | - | F | 52093000 | 52093000 | - | - | WEST SIDE, WESTBOUND TRAFFIC | - | - | - | - | TINGLEY ST | TINGLEY ST | 120204 | 120204 | 37.7311206 | -122.43614692 | SAN JOSE AVE \ TINGLEY ST | SAN JOSE AVE \ TINGLEY ST | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | TINGLEY ST intersection | - | MUNI YARD PLATFORM | - | - | - | - | - | 102301 | 1628726400000 | -122.43614692 | 37.7311206 | - | 1628726400000 | - | 11 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP3 | 2IN IRON POST | IS | 1628593800000 | SAN JOSE AVE | - | - | - | - | - | - |
| 85181 | N/A | Point | - | - | - | - | S277047 | SAN JOSE AVE: TINGLEY ST | - | F | F | - | F | 52093000 | 52093000 | - | - | WEST SIDE, WESTBOUND TRAFFIC | - | - | - | - | TINGLEY ST | TINGLEY ST | 120205 | 120205 | 37.7311206 | -122.43614692 | SAN JOSE AVE \ TINGLEY ST | SAN JOSE AVE \ TINGLEY ST | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | TINGLEY ST intersection | - | MUNI YARD PLATFORM. | - | - | - | - | - | 102302 | 1628726400000 | -122.43614692 | 37.7311206 | - | 1628726400000 | - | 11 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP3 | 2IN IRON POST | IS | 1628593800000 | SAN JOSE AVE | - | - | - | - | - | - |
| 85182 | N/A | Point | - | - | - | - | S278114 | SLOAT BLVD: 46TH AVE | - | F | F | - | F | 23456000 | 23456000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SLOAT BLVD | SLOAT BLVD | 120825 | 120825 | 37.73555788 | -122.50418533 | 46TH AVE \ SLOAT BLVD | 46TH AVE \ SLOAT BLVD | 1742261351000 | middleware_editor | PEDESTRIAN (SYM) | SLOAT BLVD intersection | - | - | - | - | - | - | - | 102303 | 1560409200000 | -122.50418533 | 37.73555788 | - | 1633676400000 | - | 07 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP3 | 2IN IRON POST | IS | 1633601520000 | 46TH AVE | - | - | - | - | - | - |
| 85183 | N/A | Point | - | - | - | - | S274207 | ROTTECK ST: MIRANDO WAY | - | F | F | - | F | 21924000 | 21924000 | - | - | SOUTH EAST CORNER | - | - | - | - | ROTTECK ST | ROTTECK ST | 123332 | 123332 | 37.73269355 | -122.43105067 | MIRANDO WAY \ ROTTECK ST | MIRANDO WAY \ ROTTECK ST | 1755102641000 | middleware_editor | MIRANDO WAY | ROTTECK ST intersection | - | X IS ROTTECK | - | - | - | - | - | 102304 | 1626979500000 | -122.43105067 | 37.73269355 | - | - | - | 08 | - | STREET NAME | GUIDE | D3-1.1201 | 36X08 | SUP3 | 3IN IRON POST | IS | 1619099220000 | MIRANDO WAY | - | - | - | - | - | - |
| 85184 | N/A | Point | - | - | - | - | 21277 | - | - | - | - | - | - | 6184000 | - | - | - | EAST SIDE, EASTBOUND TRAFFIC | 1689959921000 | smuneno | - | - | DONAHUE ST | - | 142450 | 142450 | 37.714944875 | -122.382237536 | - | - | 1710539427000 | MTA | ROAD CLOSED | - | - | 70' EAST OF DONAHUE ST./ @ K-RAILS 2 | - | - | - | - | - | 102305 | 1690292760000 | - | - | - | - | - | 10 | - | OTHER REGULATORY | REG | R11-2.0001 | 48X30 | SUP1 | UNISTRUT | IS | - | GILMAN AVE | 600 - 699 GILMAN AVE | - | - | - | EARL ST | - |
| 85185 | N/A | Point | - | - | - | - | 21284 | - | - | - | - | - | - | 6184000 | - | - | - | NORTH SIDE | 1689961085000 | smuneno | - | - | DONAHUE ST | - | 142465 | 142465 | 37.714842659 | -122.381621561 | - | - | 1710539427000 | MTA | NO STOPPING FIRE LANE | - | - | 40' EAST OF BAYVIEW VTC | - | - | - | - | - | 102306 | 1690294320000 | - | - | - | - | - | 10 | - | OTHER REGULATORY | REG | R26F.0003 | 12X18 | SUP1 | UNISTRUT | IS | - | GILMAN AVE | 600 - 699 GILMAN AVE | - | - | - | EARL ST | - |
| 85186 | N/A | Point | - | - | - | RIGHT ARROW | 21289 | - | - | F | T | - | - | 22448000 | - | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | 1689968951000 | elclark | - | - | WOODSIDE AVE | - | 142514 | 142514 | 37.74607285 | -122.454765715 | IDORA AVE \ WOODSIDE AVE | - | 1753805022000 | middleware_editor | IDORA | - | - | - | - | - | - | - | - | 102307 | - | - | - | - | - | - | 07 | HIGH INTENSITY PRISMATIC (TYPE IV WITH OL-1000 ANTI GRAFFITI OVERLAY FILM) | STREET NAME | GUIDE | D3-2.0472 | 72X18 | SUP3 | LIGHT POLE | RETD | - | IDORA AVE | - | - | - | - | - | - |
| 85187 | N/A | Point | - | - | - | RIGHT ARROW | 21302 | - | - | F | F | - | F | 12374000 | - | - | - | WEST SIDE | 1690220710000 | smuneno | - | - | BONIFACIO ST | - | 142738 | 142738 | 37.781658372 | -122.400080537 | - | - | 1710539427000 | MTA | TANSAT | - | - | 108' SOUTH OF BONIFACIO NORTH SIDEWALK | - | - | - | - | - | 102308 | 1690371000000 | - | - | - | - | - | 06 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | - | TANDANG SORA | 1 - 99 TANDANG SORA | - | - | - | RIZAL ST | - |
| 85188 | N/A | Point | - | - | - | - | 21348 | - | - | - | - | - | - | 25116000 | - | - | - | NORTH EAST CORNER | 1690389664000 | APADILLA | - | - | MASON ST | - | 143155 | 143155 | 37.798266752 | -122.412057302 | VALLEJO ST \ MASON ST | - | 1710539427000 | MTA | MISCELLANEOUS SIGNS | - | - | - | - | - | - | - | - | 102313 | - | - | - | - | - | - | 03 | - | OTHER GUIDE | GUIDE | G-M(SF).0038 | N/A | SUP1 | 2IN IRON POST | PI | - | VALLEJO ST | - | - | - | - | - | - |
| 85189 | N/A | Point | - | - | - | - | 21349 | - | - | F | T | - | F | 6268000 | - | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | 1690390307000 | APADILLA | - | - | GOUGH ST | - | 143174 | 143174 | 37.780533128 | -122.423833138 | - | - | 1710539427000 | MTA | GOLDEN GATE AVE | - | - | - | - | - | - | - | - | 102314 | - | - | - | - | - | - | 05 | - | STREET NAME | GUIDE | D3-2.0172 | 72X18 | SUP2 | LIGHT POLE | PI | - | GOLDEN GATE AVE | 800 - 999 GOLDEN GATE AVE | - | - | - | LAGUNA ST | - |
| 85190 | N/A | Point | 1 | 1 | 1201 - 1299 | - | S208961 | 1100-1199 MARKET ST | 1201-1299 MARKET ST | F | F | - | F | 8752101 | 8752101 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 8TH ST \ GROVE ST \ HYDE ST | 08TH ST \ GROVE ST \ HYDE ST | 49093 | 49093 | 37.77807696 | -122.41547968 | - | - | 1710539427000 | MTA | SPEED LIMIT 10 | 08TH ST \ GROVE ST \ HYDE ST to 09TH ST \ LARKIN ST (1201 - 1299) -- SOUTH -- | - | 100' WEST OF 9TH ST | - | - | - | - | - | 102315 | - | -122.41547968 | 37.77807696 | - | - | - | 06 | - | SPEED LIMIT | REG | R2-1.0002 | 24X30 | SUP1 | 2IN IRON POST | IS | 1410448080000 | MARKET ST | 1201 - 1299 MARKET ST | 1201 - 1299 MARKET ST | 1201 MARKET ST | - | 09TH ST \ LARKIN ST | 09TH ST \ LARKIN ST |
| 85191 | N/A | Point | - | 1 | 50 - 99 | - | S208450 | 1-99 DUNSHEE ST | 50-99 DUNSHEE ST | F | F | - | F | 5017000 | 5017000 | - | - | WEST SIDE | - | - | - | - | DRUMMOND ALY | DRUMMOND ALY | 49659 | 49659 | 37.7368426 | -122.39554452 | - | - | 1710539427000 | MTA | TANP ANY TIME | DRUMMOND ALY to PALOU AVE (50 - 99) | - | 42' NORTH FROM PALOU | - | - | - | - | - | 102316 | 1416578820000 | -122.39554452 | 37.7368426 | - | 1416528000000 | - | 10 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0039 | 14X21 | SUP1 | 2IN IRON POST | IS | 1408974180000 | DUNSHEE ST | 50 - 99 DUNSHEE ST | 50 - 99 DUNSHEE ST | 50 DUNSHEE ST | - | PALOU AVE | PALOU AVE |
| 85192 | N/A | Point | 1 | 1 | 700 - 799 | - | S207921 | 700-773 4TH ST | 700-799 04TH ST | F | F | - | F | 267001 | 267001 | - | - | WEST SIDE | - | - | - | - | TOWNSEND ST | TOWNSEND ST | 50831 | 50831 | 37.77671116 | -122.39450827 | - | - | 1710539427000 | MTA | MUNI LANDOR FLAG - TYPE 6 | TOWNSEND ST to KING ST (700 - 799) | - | 100' SOUTH OF TOWNSEND | - | - | - | - | - | 102317 | 1406732280000 | -122.39450827 | 37.77671116 | - | 1406678400000 | - | 06 | - | OTHER REGULATORY | REG | R(SF).0334 | 15X39 | SUP1 | MUNI POLE | IS | 1406535000000 | 04TH ST | 700-773 4TH ST | 700 - 799 04TH ST | - | - | KING ST | KING ST |
| 85193 | N/A | Point | - | - | - | - | S213078 | BAY SHORE BLVD: CORTLAND AVE | - | F | F | - | F | 21023000 | 21023000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | CORTLAND AVE | CORTLAND AVE | 51562 | 51562 | 37.73956627 | -122.40697859 | BAY SHORE BLVD \ CORTLAND AVE | BAY SHORE BLVD \ CORTLAND AVE | 1710539427000 | MTA | KEEP RIGHT (SYM) | CORTLAND AVE intersection | - | - | - | - | - | - | - | 102318 | 1456216860000 | -122.40697859 | 37.73956627 | - | 1456185600000 | - | 10 | - | OTHER REGULATORY | REG | R4-7A.0002 | 24X30 | SUP1 | 2IN IRON POST | IS | 1422613200000 | BAY SHORE BLVD | - | - | - | - | - | - |
| 85194 | N/A | Point | 1 | - | - | - | S211630 | 1-299 TELEGRAPH HILL BLVD | - | F | F | - | F | 12479000 | 12479000 | - | - | NORTH LINE | - | - | - | - | - | - | 52553 | 52553 | 37.80258264 | -122.40606944 | - | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | - | - | ON CENTER LINE OF TELEGRAPH HILL BLVD | - | - | - | - | - | 102319 | 1418811420000 | -122.40606944 | 37.80258264 | - | 1418774400000 | - | 03 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP1 | 2IN IRON POST | IS | 1418284740000 | TELEGRAPH HILL BLVD | 1-299 TELEGRAPH HILL BLVD | TELEGRAPH HILL BLVD | - | - | - | - |
| 85195 | N/A | Point | 1 | 1 | 1 - 199 | RIGHT ARROW | S212318 | 1-99 VELASCO AVE | 1-199 VELASCO AVE | F | F | - | F | - | 13189000 | - | - | SOUTH SIDE | - | - | - | - | - | SCHWERIN ST | 53623 | 53623 | 37.708107967 | -122.412978865 | - | - | 1710539427000 | MTA | NPRK 8AM-11AM WED STCL | SCHWERIN ST to ACACIA ST \ KELLOCH AVE (1 - 199) | - | 100' WEST OF SCHWERIN | - | - | - | - | - | 102320 | - | -122.41332109 | 37.70825203 | - | - | - | - | - | STREET CLEANING | REG | R30B(CA).0278 | 18X18 | - | 2IN IRON POST | IS | 1420534920000 | VELASCO AVE | - | 1 - 199 VELASCO AVE | 1 VELASCO AVE | - | - | ACACIA ST \ KELLOCH AVE |
| 85196 | N/A | Point | 1 | 1 | 801 - 863 | - | S217556 | 800-899 MARKET ST | 801-863 MARKET ST | F | F | - | F | 8747102 | 8747102 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | 4TH ST \ ELLIS ST \ STOCKTON ST | 04TH ST \ ELLIS ST \ STOCKTON ST | 53646 | 53646 | 37.78512171 | -122.40654805 | - | - | 1710539427000 | MTA | CHEVRON - LEFT/RIGHT | 04TH ST \ ELLIS ST \ STOCKTON ST to POWELL ST (801 - 863) -- SOUTH -- | - | OPP #776 | - | - | - | - | - | 102321 | - | -122.40654805 | 37.78512171 | - | - | - | 06 | - | OTHER WARNING | WARNING | TYPE-R(CA).0001 | 24X30 | SUP1 | 2IN IRON POST | IS | 1435676640000 | MARKET ST | 801 - 863 MARKET ST | 801 - 863 MARKET ST | 801 MARKET ST | - | POWELL ST | POWELL ST |
| 85197 | N/A | Point | - | - | - | - | S218551 | CLINTON PARK: DOLORES ST | - | F | F | - | F | 25875000 | 25875000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CLINTON PARK | DOLORES ST | 53955 | 53955 | 37.768957697 | -122.426715912 | DOLORES ST \ CLINTON PARK | CLINTON PARK \ DOLORES ST | 1710539427000 | MTA | ONE WAY (RA) | DOLORES ST intersection | - | OFF DOLRES ST RELOCATE EAST | - | - | - | - | - | 102322 | 1441184220000 | -122.42671323 | 37.76898208 | - | 1441152000000 | - | 08 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP3 | 2IN IRON POST | IS | 1439558940000 | CLINTON PARK | - | - | - | - | - | - |
| 85198 | N/A | Point | 1 | 1 | 1400 - 1498 | - | S218852 | 1400-1498 MARKET ST | 1400-1498 MARKET ST | F | F | - | F | 8754201 | 8754201 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 10TH ST \ FELL ST \ POLK ST | 10TH ST \ FELL ST \ POLK ST | 54358 | 54358 | 37.77587096 | -122.41841244 | - | - | 1710539427000 | MTA | DELINEATOR (W) (SAFE HIT) | 10TH ST \ FELL ST \ POLK ST to SOUTH VAN NESS AVE \ VAN NESS AVE (1400 - 1498) -- NORTH -- | - | EAST OF 11TH ST | - | - | - | - | - | 102323 | - | -122.41841244 | 37.77587096 | - | - | - | 06 | - | DELINEATOR 5 | WARNING | TYPE-DL.0001 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1440753540000 | MARKET ST | 1400 - 1498 MARKET ST | 1400 - 1498 MARKET ST | 1400 MARKET ST | - | SOUTH VAN NESS AVE \ VAN NESS AVE | SOUTH VAN NESS AVE \ VAN NESS AVE |
| 85199 | N/A | Point | - | - | - | - | S218685 | BERKELEY WAY: DIAMOND HEIGHTS | - | F | F | - | F | 22281000 | 22281000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | BERKELEY WAY | BERKELEY WAY | 57102 | 57102 | 37.73894629 | -122.43968001 | \BERKELEY WAY: DIAMOND HEIGHTS | ONIQUE LN \ BERKELEY WAY | 1710539427000 | MTA | WRONG WAY | BERKELEY WAY intersection | - | SPL OF 289 | - | - | - | - | - | 102324 | 1445424960000 | -122.43968001 | 37.73894629 | - | 1445385600000 | - | 08 | - | OTHER REGULATORY | REG | R5-1A.0002 | 36X21 | SUP3 | 2IN IRON POST | IS | 1440068940000 | ONIQUE LN | - | - | - | - | - | - |
| 85200 | N/A | Point | 1 | 1 | 1400 - 1498 | - | S222787 | 1400-1498 MARKET ST | 1400-1498 MARKET ST | F | F | - | F | 8754201 | 8754201 | - | - | SOUTH SIDE | - | - | - | - | 10TH ST \ FELL ST \ POLK ST | 10TH ST \ FELL ST \ POLK ST | 57848 | 57848 | 37.77587096 | -122.41841244 | - | - | 1710539427000 | MTA | DELINEATOR (W) (SAFE HIT) | 10TH ST \ FELL ST \ POLK ST to SOUTH VAN NESS AVE \ VAN NESS AVE (1400 - 1498) -- NORTH -- | - | 7 POSTS FROM 10TH ST GOING WEST | - | - | - | - | - | 102325 | - | -122.41841244 | 37.77587096 | - | - | - | 06 | - | DELINEATOR 5 | WARNING | TYPE-DL.0001 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1453966080000 | MARKET ST | 1400 - 1498 MARKET ST | 1400 - 1498 MARKET ST | 1400 MARKET ST | - | SOUTH VAN NESS AVE \ VAN NESS AVE | SOUTH VAN NESS AVE \ VAN NESS 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.