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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87151 | N/A | Point | 1 | 1 | 3300 - 3322 | - | S288589 | 3300-3322 24TH ST | 3300-3322 24TH ST | F | F | - | F | 1346000 | 1346000 | - | - | NORTH SIDE | - | - | - | - | MISSION ST | MISSION ST | 109249 | 109249 | 37.75222195 | -122.41873141 | - | - | 1710539427000 | MTA | BIKE RACK | MISSION ST to OSAGE ALY (3300 - 3322) | - | 20.5' E OF EPL 3318/4' IN FROM CURB | - | - | - | - | - | 104338 | - | -122.41873141 | 37.75222195 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1681824420000 | 24TH ST | 3300 - 3322 24TH ST | 3300 - 3322 24TH ST | 3300 24TH ST | - | OSAGE ALY | OSAGE ALY |
| 87152 | N/A | Point | 1 | 1 | 3300 - 3322 | - | S124258 | 3300-3322 24TH ST | 3300-3322 24TH ST | F | F | - | F | 1346000 | 1346000 | - | - | SOUTH SIDE | - | - | - | - | MISSION ST | MISSION ST | 18836 | 18836 | 37.75222195 | -122.41873141 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | MISSION ST to OSAGE ALY (3300 - 3322) | - | 15`WEST OF ORANGE | - | - | - | - | - | 104339 | 1151020800000 | -122.41873141 | 37.75222195 | - | - | - | D9 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP2 | LIGHT POLE | IS | 1373575140000 | 24TH ST | 3300 - 3322 24TH ST | 3300 - 3322 24TH ST | 3300 24TH ST | - | OSAGE ALY | OSAGE ALY |
| 87153 | N/A | Point | - | - | - | - | S249888 | OSAGE ALY: 24TH ST | - | F | F | - | F | 24089000 | 24089000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | OSAGE ALY | 24TH ST | 84433 | 84433 | 37.75220444 | -122.41901754 | 24TH ST \ OSAGE ALY | OSAGE ALY \ 24TH ST | 1710539427000 | MTA | ONE WAY (LA) | 24TH ST intersection | - | - | - | - | - | - | - | 104340 | 1543934100000 | -122.41901754 | 37.75220444 | - | - | - | D9 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | LIGHT POLE | IS | 1543504740000 | OSAGE ALY | - | - | - | - | - | - |
| 87154 | N/A | Point | 1 | 1 | 3300 - 3322 | - | S124232 | 3300-3322 24TH ST | 3300-3322 24TH ST | F | F | - | F | 1346000 | 1346000 | - | - | NORTH SIDE | - | - | - | - | MISSION ST | MISSION ST | 77582 | 77582 | 37.75222195 | -122.41873141 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | MISSION ST to OSAGE ALY (3300 - 3322) | - | IFO#3340 | - | - | - | - | - | 104341 | 1150934400000 | -122.41873141 | 37.75222195 | - | - | - | D9 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373575140000 | 24TH ST | 3300 - 3322 24TH ST | 3300 - 3322 24TH ST | 3300 24TH ST | - | OSAGE ALY | OSAGE ALY |
| 87155 | N/A | Point | - | - | - | - | S222742 | MISSION ST: 24TH ST | - | F | F | - | F | 24088000 | 24088000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 58187 | 58187 | 37.75223946 | -122.41844527 | MISSION ST \ 24TH ST | MISSION ST \ 24TH ST | 1717521627000 | middleware_editor | RIGHT LANE, BUSES AND TAXIS, RIGHT TURN ONLY, AT ALL TIMES | 24TH ST intersection | - | - | - | - | - | - | - | 104342 | 1460505600000 | -122.41844527 | 37.75223946 | - | 1460505600000 | - | D9 | - | TRANSIT ONLY(RIGHT LANE) | REG | SR60-3(SF).0001 | 30X42 | SUP2 | OVERHEAD MAST ARM | IS | 1453883880000 | MISSION ST | - | - | - | - | - | - |
| 87156 | N/A | Point | - | - | - | - | S124528 | MISSION ST: 24TH ST | - | F | F | - | F | 24088000 | 24088000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 17067 | 17067 | 37.75223946 | -122.41844527 | MISSION ST \ 24TH ST | MISSION ST \ 24TH ST | 1710539427000 | MTA | EXC MUNI | 24TH ST intersection | - | - | - | - | - | - | - | 104343 | 1153353600000 | -122.41844527 | 37.75223946 | - | - | - | D9 | - | OTHER REGULATORY | REG | R(SF).0072 | 30X12 | SUP2 | SIGNAL POLE | IS | 1373575200000 | MISSION ST | - | - | - | - | - | - |
| 87157 | N/A | Point | 1 | 1 | 3300 - 3322 | LEFT ARROW | S286868 | 3300-3322 24TH ST | 3300-3322 24TH ST | F | F | - | F | 1346000 | 1346000 | - | - | NORTH SIDE | - | - | - | - | MISSION ST | MISSION ST | 96803 | 96803 | 37.75222195 | -122.41873141 | - | - | 1710539427000 | MTA | TA (SYM) PLO AT ALL TIMES (5 MIN) H/C (SYM ) | MISSION ST to OSAGE ALY (3300 - 3322) | - | 2' WEST OF HYDRANT RED ZONE. | - | - | - | - | - | 104344 | 1675036800000 | -122.41873141 | 37.75222195 | - | - | - | D9 | - | OTHER REGULATORY | REG | R38(SF)1.0056 | 14X21 | SUP2 | 2IN IRON POST | IS | 1672755240000 | 24TH ST | 3300 - 3322 24TH ST | 3300 - 3322 24TH ST | 3300 24TH ST | - | OSAGE ALY | OSAGE ALY |
| 87158 | N/A | Point | 1 | 1 | 3150 - 3199 | - | S278467 | 3150-3199 24TH ST | 3150-3199 24TH ST | - | - | - | F | 1341000 | 1341000 | - | - | SOUTH SIDE | - | - | - | - | SHOTWELL ST | SHOTWELL ST | 108000 | 108000 | 37.75240622 | -122.4157189 | - | - | 1710539427000 | MTA | BIKE RACK | SHOTWELL ST to SOUTH VAN NESS AVE (3150 - 3199) | 390238 | 16' 1 OF EPL 3151/ 3.5' IN FROM CURB | - | - | - | - | - | 104345 | 1635248700000 | -122.4157189 | 37.75240622 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1634904600000 | 24TH ST | 3150 - 3199 24TH ST | 3150 - 3199 24TH ST | 3150 24TH ST | - | SOUTH VAN NESS AVE | SOUTH VAN NESS AVE |
| 87159 | N/A | Point | 1 | 1 | 3200 - 3224 | - | S124230 | 3200-3224 24TH ST | 3200-3224 24TH ST | F | F | - | F | 1342000 | 1342000 | - | - | NORTH SIDE | - | - | - | - | SOUTH VAN NESS AVE | SOUTH VAN NESS AVE | 17078 | 17078 | 37.75235481 | -122.4165458 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | SOUTH VAN NESS AVE to CYPRESS ST (3200 - 3224) | - | IFO#3214 | - | - | - | - | - | 104346 | 1150934400000 | -122.4165458 | 37.75235481 | - | - | - | D9 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP2 | 2 POST ALUMINUM | IS | 1373575140000 | 24TH ST | 3200 - 3224 24TH ST | 3200 - 3224 24TH ST | 3200 24TH ST | - | CYPRESS ST | CYPRESS ST |
| 87160 | N/A | Point | - | - | - | - | S229217 | 24TH ST: SHOTWELL ST | - | F | F | - | F | 24064000 | 24064000 | - | - | SOUTH WEST CORNER | - | - | - | - | 24TH ST | 24TH ST | 66648 | 66648 | 37.75243965 | -122.41517229 | SHOTWELL ST \ 24TH ST | SHOTWELL ST \ 24TH ST | 1710539427000 | MTA | 24TH ST/CALLE 24 LATINO CULTURAL DISTRICT | 24TH ST intersection | - | 3150 | - | - | - | - | - | 104347 | 1477297500000 | -122.41517229 | 37.75243965 | - | 1477267200000 | - | D9 | - | STREET NAME | GUIDE | D3-1.1920 | 36X18 | SUP2 | 3IN IRON POST | IS | 1474882800000 | SHOTWELL ST | - | - | - | - | - | - |
| 87161 | N/A | Point | - | - | - | - | S101984 | SHOTWELL ST: 24TH ST | - | F | F | - | F | 24064000 | 24064000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 7100 | 7100 | 37.75243965 | -122.41517229 | SHOTWELL ST \ 24TH ST | SHOTWELL ST \ 24TH ST | 1755880651000 | middleware_editor | STOP | 24TH ST intersection | - | - | - | - | - | - | - | 104348 | -394390800000 | -122.41517229 | 37.75243965 | - | 1634022000000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566920000 | SHOTWELL ST | - | - | - | - | - | - |
| 87162 | N/A | Point | - | - | - | - | S229222 | 24TH ST: CAPP ST | - | T | T | - | F | 24070000 | 24070000 | - | - | SOUTH WEST CORNER | - | - | - | - | CAPP ST | CAPP ST | 66650 | 66650 | 37.75230598 | -122.41735782 | 24TH ST \ CAPP ST | 24TH ST \ CAPP ST | 1710539427000 | MTA | 24TH ST/CALLE 24 LATINO CULTURAL DISTRICT | CAPP ST intersection | - | 3250 | - | - | - | - | - | 104349 | 1476947640000 | -122.41735782 | 37.75230598 | - | 1476921600000 | - | D9 | - | STREET NAME | GUIDE | D3-1.1920 | 36X18 | SUP2 | LIGHT POLE | IS | 1474883520000 | 24TH ST | - | - | - | - | - | - |
| 87163 | N/A | Point | - | - | - | - | S102025 | CAPP ST: 24TH ST | - | F | F | - | F | 24070000 | 24070000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CAPP ST | CAPP ST | 6013 | 6013 | 37.75230598 | -122.41735782 | 24TH ST \ CAPP ST | 24TH ST \ CAPP ST | 1710539427000 | MTA | STOP | CAPP ST intersection | - | - | - | - | - | - | - | 104350 | -393897600000 | -122.41735782 | 37.75230598 | - | 640310400000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568180000 | 24TH ST | - | - | - | - | - | - |
| 87164 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S214910 | 2200-2299 MISSION ST | 2200-2299 MISSION ST | F | F | - | F | 9120000 | 9120000 | - | - | WEST SIDE | - | - | - | - | 18TH ST | 18TH ST | 128241 | 128241 | 37.76103561 | -122.41928266 | - | - | 1710539427000 | MTA | SOLAR LANTERN BLUE (V5) | 18TH ST to 19TH ST (2200 - 2299) | 15554 | INFO #2208/SOLAR PANEL-SOUTH WEST | - | - | - | - | - | 104351 | 1429613580000 | -122.41928266 | 37.76103561 | - | 1429574400000 | - | D9 | - | OTHER MISC | MISC | SOLAR-BLUE.0001 | 14X11 | SUP2 | UNISTRUT | IS | 1427971680000 | MISSION ST | 2200 - 2299 MISSION ST | 2200 - 2299 MISSION ST | 2200 MISSION ST | - | 19TH ST | 19TH ST |
| 87165 | N/A | Point | - | - | - | - | S229920 | KING ST: 4TH ST | - | F | F | - | F | 23798000 | 23798000 | - | - | CENTER ISLAND, S LINE, EASTBOUND | - | - | - | - | 4TH ST | 04TH ST | 65047 | 65047 | 37.77633298 | -122.39403507 | KING ST \ 4TH ST | KING ST \ 04TH ST | 1737676140000 | middleware_editor | SOLAR LANTERN WHITE (V5) | 04TH ST intersection | 17795 | 80' EAST OF X WALK | - | - | - | - | - | 104352 | 1481009880000 | -122.39403507 | 37.77633298 | - | 1480982400000 | - | D6 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | 2IN FLANGE POST | IS | 1476791760000 | KING ST | - | - | - | - | - | - |
| 87166 | N/A | Point | - | - | - | - | S281217 | VAN NESS AVE: UNION ST | - | F | F | - | F | 26686000 | 26686000 | - | - | CENTER ISLAND, N LINE, SOUTHBOUND | - | - | - | - | UNION ST | VAN NESS AVE | 94072 | 94072 | 37.79855245 | -122.42398215 | VAN NESS AVE \ UNION ST | UNION ST \ VAN NESS AVE | 1710539427000 | MTA | SOLAR LANTERN WHITE (V5) | VAN NESS AVE intersection | 18097 | 13 FT NORTH OF UNION | - | - | - | - | - | 104353 | 1646265600000 | -122.42398215 | 37.79855245 | - | - | - | D2 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | UNISTRUT | IS | 1646301780000 | UNION ST | - | - | - | - | - | - |
| 87167 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S214640 | 1300-1399 16TH ST | 1300-1399 16TH ST | F | F | - | F | 707000 | 707000 | - | - | NORTH SIDE | - | - | - | - | WISCONSIN ST | WISCONSIN ST | 114977 | 114977 | 37.76622037 | -122.400258 | - | - | 1710539427000 | MTA | SOLAR LANTERN BLUE (V5) | WISCONSIN ST to CAROLINA ST (1300 - 1399) | 17762 | 80' W OF WISCONSIN/SOLAR PANEL-SOUTHWEST | - | - | - | - | - | 104354 | 1429610520000 | -122.400258 | 37.76622037 | - | 1429574400000 | - | D10 | - | OTHER MISC | MISC | SOLAR-BLUE.0001 | 14X11 | SUP1 | UNISTRUT | IS | 1427449620000 | 16TH ST | 1300 - 1399 16TH ST | 1300 - 1399 16TH ST | 1300 16TH ST | - | CAROLINA ST | CAROLINA ST |
| 87168 | N/A | Point | - | - | - | - | S119182 | RUSSIA AVE: PRAGUE ST | - | F | F | - | F | 21624000 | 21624000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 15871 | 15871 | 37.71737953 | -122.42837146 | PRAGUE ST \ RUSSIA AVE | PRAGUE ST \ RUSSIA AVE | 1720791644000 | middleware_editor | ALL WAY | RUSSIA AVE intersection | - | - | - | - | - | - | - | 104355 | 1089676800000 | -122.42837146 | 37.71737953 | - | 1720693500000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573580000 | PRAGUE ST | - | - | - | - | - | - |
| 87169 | N/A | Point | - | - | - | - | S131974 | DUBLIN ST: RUSSIA AVE | - | F | F | - | F | 21622000 | 21622000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DUBLIN ST | DUBLIN ST | 24838 | 24838 | 37.71699738 | -122.42757165 | RUSSIA AVE \ DUBLIN ST | RUSSIA AVE \ DUBLIN ST | 1710539427000 | MTA | DEAD END | DUBLIN ST intersection | - | - | - | - | - | - | - | 104356 | 1264723200000 | -122.42757165 | 37.71699738 | - | - | - | D11 | - | OTHER WARNING | WARNING | W14-1.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | 1373577540000 | RUSSIA AVE | - | - | - | - | - | - |
| 87170 | N/A | Point | - | - | - | - | S256605 | RUSSIA AVE: EDINBURGH ST | - | F | F | - | F | 21712000 | 21712000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | RUSSIA AVE | EDINBURGH ST | 86886 | 86886 | 37.71968064 | -122.43318514 | EDINBURGH ST \ RUSSIA AVE | RUSSIA AVE \ EDINBURGH ST | 1710539427000 | MTA | SPEED HUMP | EDINBURGH ST intersection | - | - | - | - | - | - | - | 104357 | 1555891200000 | -122.43318514 | 37.71968064 | - | 1565568000000 | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1564563180000 | RUSSIA AVE | - | - | - | - | - | - |
| 87171 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S281259 | 1100-1199 RUSSIA AVE | 1100-1199 RUSSIA AVE | F | F | - | F | 11199000 | 11199000 | - | - | SOUTH SIDE | - | - | - | - | PRAGUE ST | PRAGUE ST | 94305 | 94305 | 37.71718846 | -122.42797156 | - | - | 1710539427000 | MTA | NPRK 11AM-1PM MON STCL | PRAGUE ST to DUBLIN ST (1100 - 1199) | - | EPL 1118 | - | - | - | - | - | 104358 | - | -122.42797156 | 37.71718846 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0027 | 18X18 | SUP2 | 2IN IRON POST | IS | 1646315820000 | RUSSIA AVE | 1100 - 1199 RUSSIA AVE | 1100 - 1199 RUSSIA AVE | 1100 RUSSIA AVE | - | DUBLIN ST | DUBLIN ST |
| 87172 | N/A | Point | 1 | 1 | 900 - 999 | - | S281142 | 900-999 RUSSIA AVE | 900-999 RUSSIA AVE | F | F | - | F | 11197000 | 11197000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | MOSCOW ST | MOSCOW ST | 125670 | 125670 | 37.71795464 | -122.42957469 | - | - | 1710539427000 | MTA | SPEED HUMP | MOSCOW ST to MUNICH ST (900 - 999) | - | IFO 902 ABOVE SIGN | - | - | - | - | - | 104359 | 1645833600000 | -122.42957469 | 37.71795464 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1645795740000 | RUSSIA AVE | 900 - 999 RUSSIA AVE | 900 - 999 RUSSIA AVE | 900 RUSSIA AVE | - | MUNICH ST | MUNICH ST |
| 87173 | N/A | Point | 1 | 1 | 600 - 699 | - | S274732 | 600-699 LA GRANDE AVE | 600-699 LA GRANDE AVE | F | F | - | F | 7918000 | 7918000 | - | - | WEST SIDE | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 121179 | 121179 | 37.71619982 | -122.42701853 | - | - | 1710539427000 | MTA | NPRK 11AM-1PM MON STCL | RUSSIA AVE to END: 600-699 BLOCK (600 - 699) | - | NPL 650 | - | - | - | - | - | 104360 | 1452729600000 | -122.42701853 | 37.71619982 | - | 1622592000000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0027 | 18X18 | SUP2 | LIGHT POLE | IS | 1621241340000 | LA GRANDE AVE | 600 - 699 LA GRANDE AVE | 600 - 699 LA GRANDE AVE | 600 LA GRANDE AVE | - | END: 600-699 BLOCK | END: 600-699 BLOCK |
| 87174 | N/A | Point | - | - | - | - | S230780 | RUSSIA AVE: NAPLES ST | - | F | F | - | F | 21711000 | 21711000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | NAPLES ST | RUSSIA AVE | 68214 | 68214 | 37.71929846 | -122.43238519 | RUSSIA AVE \ NAPLES ST | NAPLES ST \ RUSSIA AVE | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | RUSSIA AVE intersection | - | - | - | - | - | - | - | 104361 | 1479305820000 | -122.43238519 | 37.71929846 | - | 1479254400000 | - | D11 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP2 | 2IN IRON POST | IS | 1478686260000 | NAPLES ST | - | - | - | - | - | - |
| 87175 | N/A | Point | 1 | 1 | 500 - 599 | - | S210915 | 500-599 MUNICH ST | 500-599 MUNICH ST | F | F | - | F | 9450000 | 9450000 | - | - | EAST SIDE | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 53459 | 53459 | 37.71707793 | -122.42968846 | - | - | 1754433639000 | middleware_editor | NPRK 11AM-1PM THUR STCL | RUSSIA AVE to END: 500-599 BLOCK (500 - 599) | - | IFO#567 | - | - | - | - | - | 104362 | 1416867900000 | -122.42968846 | 37.71707793 | - | 1754423100000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0028 | 18X18 | SUP2 | LIGHT POLE | IS | 1416298740000 | MUNICH ST | 500 - 599 MUNICH ST | 500 - 599 MUNICH ST | 500 MUNICH ST | - | END: 500-599 BLOCK | END: 500-599 BLOCK |
| 87176 | N/A | Point | - | - | - | - | S125384 | LISBON ST: RUSSIA AVE | - | F | F | - | F | 21721000 | 21721000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LISBON ST | LISBON ST | 109829 | 109829 | 37.72044491 | -122.43478496 | RUSSIA AVE \ LISBON ST | RUSSIA AVE \ LISBON ST | 1710539427000 | MTA | ALL WAY | LISBON ST intersection | - | - | - | - | - | - | - | 104363 | 1156982400000 | -122.43478496 | 37.72044491 | - | 1541030400000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575500000 | RUSSIA AVE | - | - | - | - | - | - |
| 87177 | N/A | Point | 1 | 1 | 300 - 399 | - | S128432 | 300-399 PRAGUE ST | 300-399 PRAGUE ST | F | F | - | F | 10731000 | 10731000 | - | - | CENTER ISLAND | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 22408 | 22408 | 37.71679643 | -122.42881319 | - | - | 1710539427000 | MTA | TANP ANY TIME | RUSSIA AVE to END: 300-399 BLOCK (300 - 399) | - | IFO#382 (ON FENCE) | - | - | - | - | - | 104364 | 1197417600000 | -122.42881319 | 37.71679643 | - | - | - | D11 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP2 | FENCE | IS | 1373576460000 | PRAGUE ST | 300 - 399 PRAGUE ST | 300 - 399 PRAGUE ST | 300 PRAGUE ST | - | END: 300-399 BLOCK | END: 300-399 BLOCK |
| 87178 | N/A | Point | - | - | - | - | S231890 | RUSSIA AVE: MOSCOW ST | - | F | F | - | F | 21631000 | 21631000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MOSCOW ST | RUSSIA AVE | 66919 | 66919 | 37.71814756 | -122.42997803 | RUSSIA AVE \ MOSCOW ST | MOSCOW ST \ RUSSIA AVE | 1731712859000 | middleware_editor | ALL WAY | RUSSIA AVE intersection | - | - | - | - | - | - | - | 104365 | 2160000000 | -122.42997803 | 37.71814756 | - | 1731677400000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | UTILITY POLE | IS | 1482157140000 | MOSCOW ST | - | - | - | - | - | - |
| 87179 | N/A | Point | 1 | 1 | 600 - 699 | - | S274733 | 600-699 LA GRANDE AVE | 600-699 LA GRANDE AVE | F | F | - | F | 7918000 | 7918000 | - | - | WEST SIDE | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 121452 | 121452 | 37.71619982 | -122.42701853 | - | - | 1710539427000 | MTA | NPRK 11AM-1PM MON STCL | RUSSIA AVE to END: 600-699 BLOCK (600 - 699) | - | NPL 612 | - | - | - | - | - | 104366 | 1452729600000 | -122.42701853 | 37.71619982 | - | 1622592000000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0027 | 18X18 | SUP2 | 2IN IRON POST | IS | 1621241520000 | LA GRANDE AVE | 600 - 699 LA GRANDE AVE | 600 - 699 LA GRANDE AVE | 600 LA GRANDE AVE | - | END: 600-699 BLOCK | END: 600-699 BLOCK |
| 87180 | N/A | Point | - | - | - | - | S230725 | RUSSIA AVE: NAPLES ST | - | F | F | - | F | 21711000 | 21711000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | NAPLES ST | RUSSIA AVE | 125846 | 125846 | 37.71929846 | -122.43238519 | RUSSIA AVE \ NAPLES ST | NAPLES ST \ RUSSIA AVE | 1710539427000 | MTA | NO LEFT TURN (SYM) | RUSSIA AVE intersection | - | - | - | - | - | - | - | 104367 | 1479307320000 | -122.43238519 | 37.71929846 | - | 1479254400000 | - | D11 | - | NO LEFT TURN | REG | R3-2.0003 | 36X36 | SUP2 | 3IN IRON POST | IS | 1478613000000 | NAPLES ST | - | - | - | - | - | - |
| 87181 | N/A | Point | 1 | 1 | 600 - 699 | - | S252661 | 600-699 MOSCOW ST | 600-699 MOSCOW ST | F | F | - | F | 9402000 | 9402000 | - | - | WEST SIDE | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 91276 | 91276 | 37.71737059 | -122.43056593 | - | - | 1710539427000 | MTA | NPRK 11AM-1PM THUR STCL | RUSSIA AVE to FRANCE AVE (600 - 699) | - | SPL 678 | - | - | - | - | - | 104368 | 1525910400000 | -122.43056593 | 37.71737059 | - | 1577059200000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0028 | 18X18 | SUP2 | 2IN IRON POST | IS | 1553072040000 | MOSCOW ST | 600 - 699 MOSCOW ST | 600 - 699 MOSCOW ST | 600 MOSCOW ST | - | FRANCE AVE | FRANCE AVE |
| 87182 | N/A | Point | - | - | - | - | S230728 | RUSSIA AVE: NAPLES ST | - | F | F | - | F | 21711000 | 21711000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | NAPLES ST | RUSSIA AVE | 68562 | 68562 | 37.71929846 | -122.43238519 | RUSSIA AVE \ NAPLES ST | NAPLES ST \ RUSSIA AVE | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | RUSSIA AVE intersection | - | - | - | - | - | - | - | 104369 | 1479307680000 | -122.43238519 | 37.71929846 | - | 1479254400000 | - | D11 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP2 | 2IN IRON POST | IS | 1478613720000 | NAPLES ST | - | - | - | - | - | - |
| 87183 | N/A | Point | 1 | 1 | 200 - 299 | - | S221212 | 200-299 CARL ST | 200-299 CARL ST | F | F | - | F | 3697000 | 3697000 | - | - | SOUTH SIDE | - | - | - | - | STANYAN ST | STANYAN ST | 57305 | 57305 | 37.76533789 | -122.45358122 | - | - | 1710539427000 | MTA | SOLAR LANTERN RED (V5) | STANYAN ST to WILLARD ST (200 - 299) | 13915 | 10' WEST OF STANYAN/9' FROM CURB | - | - | - | - | - | 104370 | - | -122.45358122 | 37.76533789 | - | - | - | D5 | - | OTHER MISC | MISC | SOLAR-RED.0001 | 14X11 | SUP1 | MUNI LANDOR POLE 3" X121" | IS | 1449584220000 | CARL ST | 200 - 299 CARL ST | 200 - 299 CARL ST | 200 CARL ST | - | WILLARD ST | WILLARD ST |
| 87184 | N/A | Point | 1 | 1 | 3500 - 3599 | - | S114869 | 3500-3599 23RD ST | 3500-3599 23RD ST | F | F | - | F | 1268000 | 1268000 | - | - | NORTH SIDE | - | - | - | - | SAN JOSE AVE | SAN JOSE AVE | 13807 | 13807 | 37.75361482 | -122.42227317 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "Z" PERMITS | SAN JOSE AVE to GUERRERO ST (3500 - 3599) | - | EPL #3542 | - | - | - | - | - | 104371 | 1018396800000 | -122.42227317 | 37.75361482 | - | 1626220800000 | - | D8 | - | PARKING:RPP | REG | R32C(CA).0107 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373572200000 | 23RD ST | 3500 - 3599 23RD ST | 3500 - 3599 23RD ST | 3500 23RD ST | - | GUERRERO ST | GUERRERO ST |
| 87185 | N/A | Point | 1 | 1 | 1 - 99 | - | S221216 | 1-99 IRVING ST | 1-99 IRVING ST | F | F | - | F | 7278000 | 7278000 | - | - | SOUTH SIDE | - | - | - | - | ARGUELLO BLVD | ARGUELLO BLVD | 57618 | 57618 | 37.76440398 | -122.45821914 | - | - | 1710539427000 | MTA | SOLAR LANTERN RED (V5) | ARGUELLO BLVD to 02ND AVE (1 - 99) | 15124 | 70' WEST OF ARGUELLO | - | - | - | - | - | 104372 | - | -122.45821914 | 37.76440398 | - | - | - | D5 | - | OTHER MISC | MISC | SOLAR-RED.0001 | 14X11 | SUP1 | MUNI LANDOR POLE 3" X121" | IS | 1449585060000 | IRVING ST | 1 - 99 IRVING ST | 1 - 99 IRVING ST | 1 IRVING ST | - | 02ND AVE | 02ND AVE |
| 87186 | N/A | Point | - | - | - | - | 21079 | - | - | F | T | - | - | 27833000 | - | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | 1689345493000 | elclark | - | - | 30TH AVE | - | 141538 | 141538 | 37.776001889 | -122.489679184 | BALBOA ST \ 30TH AVE | - | 1710539427000 | MTA | 30th Ave | - | - | - | - | - | - | - | - | 104373 | - | - | - | - | - | 1692107400000 | 01 | DIAMOND GRADE (TYPE XI OMNICUBE WITH OL-1000 ANTI GRAFFITI OVERLAY FILM) | OTHER GUIDE | GUIDE | D3-2.0040 | 72X18 | SUP2 | LIGHT POLE | RETD | - | BALBOA ST | - | - | - | - | - | - |
| 87187 | N/A | Point | - | - | - | - | 21077 | - | - | F | T | - | - | 27814000 | - | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | 1689343722000 | elclark | - | - | 30TH AVE | - | 141522 | 141522 | 37.774124872 | -122.489815925 | CABRILLO ST \ 30TH AVE | - | 1710539427000 | MTA | CABRILLO ST | - | - | - | - | - | - | - | - | 104374 | - | - | - | - | - | 1692099840000 | 01 | DIAMOND GRADE (TYPE XI OMNICUBE WITH OL-1000 ANTI GRAFFITI OVERLAY FILM) | STREET NAME | GUIDE | D3-2.0098 | 72X18 | SUP2 | UTILITY POLE | RETD | - | CABRILLO ST | - | - | - | - | - | - |
| 87188 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S250237 | 1100-1199 LOMBARD ST | 1100-1199 LOMBARD ST | F | F | - | F | 8450000 | 8450000 | - | - | SOUTH SIDE | - | - | - | - | HYDE ST | HYDE ST | 82406 | 82406 | 37.80189129 | -122.42044191 | - | - | 1710539427000 | MTA | PARK SMART | HYDE ST to LARKIN ST (1100 - 1199) | - | 183' E LARKIN | - | - | - | - | - | 104375 | 1545227880000 | -122.42044191 | 37.80189129 | - | - | - | D2 | - | OTHER REGULATORY | REG | R(SF).0377 | 18X21 | SUP1 | 2IN IRON POST | IS | 1544689920000 | LOMBARD ST | 1100 - 1199 LOMBARD ST | 1100 - 1199 LOMBARD ST | 1100 LOMBARD ST | - | LARKIN ST | LARKIN ST |
| 87189 | N/A | Point | 1 | 1 | 100 - 119 | - | S152672 | 100-119 SAN JOSE AVE | 100-119 SAN JOSE AVE | F | F | - | F | 11428000 | 11428000 | - | - | WEST SIDE | - | - | - | - | 23RD ST | 23RD ST | 43735 | 43735 | 37.75325922 | -122.42151803 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM 2ND & 4TH WED OF MONTH STCL | 23RD ST to ELIZABETH ST (100 - 119) | - | NPL #120 | - | - | - | - | - | 104376 | 1238976000000 | -122.42151803 | 37.75325922 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0258 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375730760000 | SAN JOSE AVE | 100 - 119 SAN JOSE AVE | 100 - 119 SAN JOSE AVE | 100 SAN JOSE AVE | - | ELIZABETH ST | ELIZABETH ST |
| 87190 | N/A | Point | - | - | - | - | S281226 | VAN NESS AVE: SACRAMENTO ST | - | F | F | - | F | 26536000 | 26536000 | - | - | CENTER ISLAND, N LINE, SOUTHBOUND | - | - | - | - | SACRAMENTO ST | VAN NESS AVE | 95224 | 95224 | 37.79128889 | -122.42251494 | VAN NESS AVE \ SACRAMENTO ST | SACRAMENTO ST \ VAN NESS AVE | 1732121248000 | middleware_editor | SOLAR LANTERN WHITE (V5) | VAN NESS AVE intersection | 18100 | 13 FT NORTH OF SACRAMENTO | - | - | - | - | - | 104377 | 1646265600000 | -122.42251494 | 37.79128889 | - | - | - | D2 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | UNISTRUT | IS | 1646305020000 | SACRAMENTO ST | - | - | - | - | - | - |
| 87191 | N/A | Point | - | - | - | - | S229991 | THE EMBARCADERO: WASHINGTON ST | - | F | F | - | T | 12554201 | 24572000 | - | - | CENTER ISLAND, E LINE, NORTHBOUND | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 65460 | 65460 | 37.7966829 | -122.39540527 | - | THE EMBARCADERO \ WASHINGTON ST | 1727392194000 | middleware_editor | SOLAR LANTERN WHITE (V5) | WASHINGTON ST intersection | 14532 | 80' NORTH OF X WALK | - | - | - | - | - | 104378 | 1727361660000 | -122.39540527 | 37.7966829 | - | - | - | D3 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | 2IN FLANGE POST | IS | 1476956460000 | THE EMBARCADERO | 200 - 498 THE EMBARCADERO | - | - | - | BROADWAY | - |
| 87192 | N/A | Point | - | - | - | INBOUND | S240793 | MISSION ST: 24TH ST | - | F | F | - | F | 24088000 | 24088000 | - | - | EAST SIDE | - | - | - | - | 24TH ST | 24TH ST | 126999 | 126999 | 37.75223946 | -122.41844527 | MISSION ST \ 24TH ST | MISSION ST \ 24TH ST | 1710539427000 | MTA | SOLAR LANTERN WHITE (V5) | 24TH ST intersection | 15565 | IFO #2777 | - | - | - | - | - | 104379 | 1517905380000 | -122.41844527 | 37.75223946 | - | 1517875200000 | - | D9 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP2 | UNISTRUT | IS | 1511291700000 | MISSION ST | - | - | - | - | - | - |
| 87193 | N/A | Point | 1 | 1 | 700 - 799 | - | S221215 | 700-799 IRVING ST | 700-799 IRVING ST | F | F | - | F | 7285000 | 7285000 | - | - | NORTH SIDE | - | - | - | - | 8TH AVE | 08TH AVE | 57308 | 57308 | 37.76406038 | -122.46577776 | - | - | 1710539427000 | MTA | SOLAR LANTERN RED (V5) | 08TH AVE to 09TH AVE (700 - 799) | 15123 | 6' EAST OF 9TH AVE | - | - | - | - | - | 104380 | - | -122.46577776 | 37.76406038 | - | - | - | D5 | - | OTHER MISC | MISC | SOLAR-RED.0001 | 14X11 | SUP1 | MUNI LANDOR POLE 3" X121" | IS | 1449584880000 | IRVING ST | 700 - 799 IRVING ST | 700 - 799 IRVING ST | 700 IRVING ST | - | 09TH AVE | 09TH AVE |
| 87194 | N/A | Point | - | - | - | - | 22146 | - | - | F | F | - | F | 25909000 | - | - | - | CENTER ISLAND | 1692026832000 | malopez | - | - | OCTAVIA ST | - | 146577 | 146577 | 37.7739485041869 | -122.423973530526 | PAGE ST \ OCTAVIA ST | - | 1744234854000 | middleware_editor | FG 300 UR DELINEATOR (Y) | - | - | INTERSECTION PAGE AND OCTAVIA | - | - | - | - | 14 | 104381 | - | - | - | - | 1744230300000 | - | 06 | - | DELINEATOR 5 | WARNING | TYPE-DL.0008 | 03X36 | SUP1 | STANDARD BASE | IS | - | PAGE ST | - | - | - | - | - | - |
| 87195 | N/A | Point | - | - | - | - | 21486 | - | - | F | F | - | F | 24149000 | - | - | - | SOUTH EAST CORNER | 1690916458000 | elclark | - | - | MISSION ST | - | 143842 | 143842 | 37.761791335 | -122.419259548 | 18TH ST \ MISSION ST | - | 1710539427000 | MTA | MISSION ST | - | - | <2200| | - | - | - | - | - | 104382 | - | - | - | - | 1692099000000 | - | 09 | - | STREET NAME | GUIDE | D3-1.1207 | 36X08 | SUP3 | SIGNAL POLE | IS | - | - | - | - | - | - | - | - |
| 87196 | N/A | Point | - | - | - | - | S239232 | MIGUEL ST: BEACON ST | - | F | F | - | F | 21885000 | 21885000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MIGUEL ST | BEACON ST | 111349 | 111349 | 37.73915252 | -122.43117463 | BEACON ST \ MIGUEL ST | MIGUEL ST \ BEACON ST | 1710539427000 | MTA | STOP | BEACON ST intersection | - | AT PAINT MARK | - | - | - | - | - | 104383 | 1461801600000 | -122.43117463 | 37.73915252 | - | 1508716800000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1506926040000 | MIGUEL ST | - | - | - | - | - | - |
| 87197 | N/A | Point | - | - | - | - | S234812 | MIGUEL ST: BEACON ST | - | F | F | - | F | 21885000 | 21885000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MIGUEL ST | BEACON ST | 66697 | 66697 | 37.73915252 | -122.43117463 | BEACON ST \ MIGUEL ST | MIGUEL ST \ BEACON ST | 1750259429000 | middleware_editor | NEXT 1/4 MILE | BEACON ST intersection | - | IFO#1 | - | - | - | - | - | 104384 | 1494528540000 | -122.43117463 | 37.73915252 | - | 1750179000000 | - | D8 | - | OTHER WARNING | WARNING | W7-3.0005 | 24X18 | SUP2 | 2IN IRON POST | IS | 1491216600000 | MIGUEL ST | - | - | - | - | - | - |
| 87198 | N/A | Point | - | - | - | - | S205723 | BEACON ST: MIGUEL ST | - | F | F | - | F | 21885000 | 21885000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | MIGUEL ST | BEACON ST | 46860 | 46860 | 37.73915252 | -122.43117463 | BEACON ST \ MIGUEL ST | MIGUEL ST \ BEACON ST | 1718216572000 | middleware_editor | BUMP AHEAD | BEACON ST intersection | - | 50`NORTH | - | - | - | - | - | 104385 | - | -122.43117463 | 37.73915252 | - | 1718113500000 | - | D8 | - | OTHER WARNING | WARNING | W8-1(SF).0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1400058180000 | MIGUEL ST | - | - | - | - | - | - |
| 87199 | N/A | Point | 1 | 1 | 200 - 499 | - | S145037 | 200-499 BEACON ST | 200-499 BEACON ST | F | F | - | F | 2862000 | 2862000 | - | - | NORTH SIDE | - | - | - | - | HARRY ST | HARRY ST | 34454 | 34454 | 37.7412314 | -122.43365512 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM 2ND & 4TH THUR OF MONTH STCL | HARRY ST to DIAMOND ST (200 - 499) | - | 290 BEACON | - | - | - | - | - | 104386 | 1222646400000 | -122.43365512 | 37.7412314 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0295 | 18X18 | SUP2 | LIGHT POLE | IS | 1375727460000 | BEACON ST | 200 - 499 BEACON ST | 200 - 499 BEACON ST | 200 BEACON ST | - | DIAMOND ST | DIAMOND ST |
| 87200 | N/A | Point | 1 | 1 | 160 - 199 | - | S122432 | 160-199 BEACON ST | 160-199 BEACON ST | F | F | - | F | 2861000 | 2861000 | - | - | EAST SIDE | - | - | - | - | MIGUEL ST | MIGUEL ST | 15649 | 15649 | 37.73947369 | -122.43147372 | - | - | 1710539427000 | MTA | TANSAT | MIGUEL ST to HARRY ST (160 - 199) | - | OPP.60`SOUTH OF #383 | - | - | - | - | - | 104387 | 1137456000000 | -122.43147372 | 37.73947369 | - | - | - | D8 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP2 | LIGHT POLE | IS | 1373574600000 | BEACON ST | 160 - 199 BEACON ST | 160 - 199 BEACON ST | 160 BEACON ST | - | HARRY ST | HARRY ST |
| 87201 | N/A | Point | - | - | - | - | S222723 | MISSION ST: 24TH ST | - | F | F | - | F | 24088000 | 24088000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 59067 | 59067 | 37.75223946 | -122.41844527 | MISSION ST \ 24TH ST | MISSION ST \ 24TH ST | 1710539427000 | MTA | NO LEFT TURN (SYM) EXC MUNI | 24TH ST intersection | - | - | - | - | - | - | - | 104388 | 1096588800000 | -122.41844527 | 37.75223946 | - | 1459123200000 | - | D9 | - | NO LEFT TURN | REG | R3-2(SF).0022 | 30X30 | SUP2 | LIGHT POLE | IS | 1453818720000 | MISSION ST | - | - | - | - | - | - |
| 87202 | N/A | Point | - | - | - | - | S225288 | MISSION ST: 24TH ST | - | F | F | - | F | 24088000 | 24088000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 63955 | 63955 | 37.75223946 | -122.41844527 | MISSION ST \ 24TH ST | MISSION ST \ 24TH ST | 1710539427000 | MTA | EXCEPT MUNI | 24TH ST intersection | - | - | - | - | - | - | - | 104389 | 1096588800000 | -122.41844527 | 37.75223946 | - | 1462492800000 | - | D9 | - | OTHER REGULATORY | REG | R(SF).0357 | 30X08 | SUP2 | LIGHT POLE | IS | 1462273440000 | MISSION ST | - | - | - | - | - | - |
| 87203 | N/A | Point | - | - | - | - | S227253 | MISSION ST: 24TH ST | - | F | F | - | F | 24088000 | 24088000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 66598 | 66598 | 37.75223946 | -122.41844527 | MISSION ST \ 24TH ST | MISSION ST \ 24TH ST | 1710539427000 | MTA | EXC BUSES BICYCLES TAXIS AND TRUCKS (SYM) | 24TH ST intersection | - | - | - | - | - | - | - | 104390 | 1470311940000 | -122.41844527 | 37.75223946 | - | 1470268800000 | - | D9 | - | OTHER REGULATORY | REG | R(SF).0347 | 30X30 | SUP2 | SIGNAL POLE | IS | 1468484940000 | MISSION ST | - | - | - | - | - | - |
| 87204 | N/A | Point | - | - | - | INBOUND | S242851 | MISSION ST: 24TH ST | - | F | F | - | F | 24088000 | 24088000 | - | - | EAST SIDE | - | - | - | - | 24TH ST | 24TH ST | 74115 | 74115 | 37.75223946 | -122.41844527 | MISSION ST \ 24TH ST | MISSION ST \ 24TH ST | 1710539427000 | MTA | BIKE RACK RAPID | 24TH ST intersection | 15565 | 11 FT NORTH OF 24TH | - | - | - | - | - | 104391 | 1556755200000 | -122.41844527 | 37.75223946 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0353 | 02X36 | SUP2 | BIKE RACK | IS | 1517924340000 | MISSION ST | - | - | - | - | - | - |
| 87205 | N/A | Point | - | - | - | - | S225284 | MISSION ST: 24TH ST | - | F | F | - | F | 24088000 | 24088000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 113144 | 113144 | 37.75223946 | -122.41844527 | MISSION ST \ 24TH ST | MISSION ST \ 24TH ST | 1710539427000 | MTA | EXCEPT MUNI | 24TH ST intersection | - | - | - | - | - | - | - | 104392 | 1096588800000 | -122.41844527 | 37.75223946 | - | 1462492800000 | - | D9 | - | OTHER REGULATORY | REG | R(SF).0357 | 30X08 | SUP2 | LIGHT POLE | IS | 1462273140000 | MISSION ST | - | - | - | - | - | - |
| 87206 | N/A | Point | 1 | 1 | 1 - 99 | - | S241068 | 1-99 CARL ST | 1-99 CARL ST | F | F | - | F | 3694000 | 3694000 | - | - | NORTH SIDE | - | - | - | - | CLAYTON ST | CLAYTON ST | 126958 | 126958 | 37.76593612 | -122.44889096 | - | - | 1753286074000 | middleware_editor | SOLAR LANTERN BLUE (V5) | CLAYTON ST to COLE ST (1 - 99) | - | INBOUND MUNI RAMP (SEE NOTES) | - | - | - | - | - | 104394 | - | -122.44889096 | 37.76593612 | - | - | - | D5 | - | OTHER MISC | MISC | SOLAR-BLUE.0001 | 14X11 | SUP1 | LIGHT POLE WITH 2 INCH POST | IS | 1512121560000 | CARL ST | 1 - 99 CARL ST | 1 - 99 CARL ST | 1 CARL ST | - | COLE ST | COLE ST |
| 87207 | N/A | Point | 1 | 1 | 2100 - 2199 | - | S214677 | 2100-2199 30TH AVE | 2100-2199 30TH AVE | F | F | - | F | 1657000 | 1657000 | - | - | WEST SIDE | - | - | - | - | QUINTARA ST | QUINTARA ST | 51876 | 51876 | 37.74719246 | -122.48780117 | - | - | 1751307495000 | middleware_editor | SOLAR LANTERN BLUE (V5) | QUINTARA ST to RIVERA ST (2100 - 2199) | 13527 | INFO #2111/SOLAR PANEL-WEST | - | - | - | - | - | 104395 | 1429650300000 | -122.48780117 | 37.74719246 | - | 1429599600000 | - | D4 | - | OTHER MISC | MISC | SOLAR-BLUE.0001 | 14X11 | SUP2 | UNISTRUT | IS | 1427463420000 | 30TH AVE | 2100 - 2199 30TH AVE | 2100 - 2199 30TH AVE | 2100 30TH AVE | - | RIVERA ST | RIVERA ST |
| 87208 | N/A | Point | 1 | 1 | 400 - 499 | - | S219873 | 400-499 RUSSIA AVE | 400-499 RUSSIA AVE | F | F | - | F | 11192000 | 11192000 | - | - | NORTH SIDE | - | - | - | - | MADRID ST | MADRID ST | 59700 | 59700 | 37.71987172 | -122.43358513 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM WED STCL | MADRID ST to EDINBURGH ST (400 - 499) | - | OPP#426 | - | - | - | - | - | 104396 | - | -122.43358513 | 37.71987172 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0086 | 18X18 | SUP2 | 2IN IRON POST | IS | 1444298340000 | RUSSIA AVE | 400 - 499 RUSSIA AVE | 400 - 499 RUSSIA AVE | 400 RUSSIA AVE | - | EDINBURGH ST | EDINBURGH ST |
| 87209 | N/A | Point | - | - | - | - | S105175 | MADRID ST: RUSSIA AVE | - | F | F | - | F | 21720000 | 21720000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 2484 | 2484 | 37.72006281 | -122.43398511 | MADRID ST \ RUSSIA AVE | MADRID ST \ RUSSIA AVE | 1710539427000 | MTA | STOP | RUSSIA AVE intersection | - | 0 / 0 | - | - | - | - | - | 104397 | 57369600000 | -122.43398511 | 37.72006281 | - | 1089417600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569140000 | MADRID ST | - | - | - | - | - | - |
| 87210 | N/A | Point | - | - | - | - | S235163 | MOSCOW ST: RUSSIA AVE | - | F | F | - | F | 21631000 | 21631000 | - | - | SOUTH WEST CORNER | - | - | - | - | MOSCOW ST | RUSSIA AVE | 70909 | 70909 | 37.71814756 | -122.42997803 | RUSSIA AVE \ MOSCOW ST | MOSCOW ST \ RUSSIA AVE | 1710539427000 | MTA | MOSCOW ST | RUSSIA AVE intersection | - | 600 | - | - | - | - | - | 104398 | 1494855960000 | -122.42997803 | 37.71814756 | - | 1494806400000 | - | D11 | - | STREET NAME | GUIDE | D3-1.1238 | 36X08 | SUP2 | 3IN IRON POST | IS | 1492072080000 | MOSCOW ST | - | - | - | - | - | - |
| 87211 | N/A | Point | - | - | - | - | S254230 | RUSSIA AVE: MOSCOW ST | - | F | F | - | F | 21631000 | 21631000 | - | - | SOUTH SIDE | - | - | - | - | MOSCOW ST | RUSSIA AVE | 117862 | 117862 | 37.71814756 | -122.42997803 | RUSSIA AVE \ MOSCOW ST | MOSCOW ST \ RUSSIA AVE | 1710539427000 | MTA | NPRK 11AM-1PM MON STCL | RUSSIA AVE intersection | - | WPL 926 | - | - | - | - | - | 104399 | 2160000000 | -122.42997803 | 37.71814756 | - | 1585612800000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0027 | 18X18 | SUP2 | 2IN IRON POST | IS | 1557320700000 | MOSCOW ST | - | - | - | - | - | - |
| 87212 | N/A | Point | 1 | 1 | 600 - 699 | - | S215514 | 600-699 ATHENS ST | 600-699 ATHENS ST | F | F | - | F | 2538000 | 2538000 | - | - | WEST SIDE | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 117755 | 117755 | 37.71775326 | -122.43136537 | - | - | 1710539427000 | MTA | NPRK 10AM-12NN FRI STCL | RUSSIA AVE to FRANCE AVE (600 - 699) | - | NPL 610 | - | - | - | - | - | 104400 | - | -122.43136537 | 37.71775326 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0010 | 18X18 | SUP2 | 2IN IRON POST | IS | 1429699380000 | ATHENS ST | 600 - 699 ATHENS ST | 600 - 699 ATHENS ST | 600 ATHENS ST | - | FRANCE AVE | FRANCE AVE |
| 87213 | N/A | Point | - | - | - | - | S108704 | RUSSIA AVE: PRAGUE ST | - | F | F | - | F | 21624000 | 21624000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 5869 | 5869 | 37.71737953 | -122.42837146 | PRAGUE ST \ RUSSIA AVE | PRAGUE ST \ RUSSIA AVE | 1720791593000 | middleware_editor | STOP | RUSSIA AVE intersection | - | 0 / 0 | - | - | - | - | - | 104401 | 338774400000 | -122.42837146 | 37.71737953 | - | 1720692300000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570280000 | PRAGUE ST | - | - | - | - | - | - |
| 87214 | N/A | Point | - | - | - | - | S104697 | VIENNA ST: RUSSIA AVE | - | F | F | - | F | 21710000 | 21710000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VIENNA ST | VIENNA ST | 5135 | 5135 | 37.7189161 | -122.43158486 | RUSSIA AVE \ VIENNA ST | RUSSIA AVE \ VIENNA ST | 1710539427000 | MTA | STOP | VIENNA ST intersection | - | 0 / 0 | - | - | - | - | - | 104402 | 24624000000 | -122.43158486 | 37.7189161 | - | 1049068800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569020000 | RUSSIA AVE | - | - | - | - | - | - |
| 87215 | N/A | Point | - | - | - | - | S230787 | NAPLES ST: RUSSIA AVE | - | F | F | - | F | 21711000 | 21711000 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | - | - | - | - | NAPLES ST | RUSSIA AVE | 68217 | 68217 | 37.71929846 | -122.43238519 | RUSSIA AVE \ NAPLES ST | NAPLES ST \ RUSSIA AVE | 1710539427000 | MTA | ROUNDABOUT ARROWS | RUSSIA AVE intersection | - | S-LINE | - | - | - | - | - | 104403 | 1479306120000 | -122.43238519 | 37.71929846 | - | 1502755200000 | - | D11 | - | OTHER REGULATORY | REG | R7(SF).0001 | 18X24 | SUP2 | 2IN IRON POST | IS | 1478687520000 | NAPLES ST | - | - | - | - | - | - |
| 87216 | N/A | Point | 1 | 1 | 900 - 999 | - | S281256 | 900-999 RUSSIA AVE | 900-999 RUSSIA AVE | F | F | - | F | 11197000 | 11197000 | - | - | NORTH SIDE | - | - | - | - | MOSCOW ST | MOSCOW ST | 94302 | 94302 | 37.71795464 | -122.42957469 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM WED STCL | MOSCOW ST to MUNICH ST (900 - 999) | - | WPL 931 | - | - | - | - | - | 104404 | - | -122.42957469 | 37.71795464 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0086 | 18X18 | SUP2 | 2IN IRON POST | IS | 1646315460000 | RUSSIA AVE | 900 - 999 RUSSIA AVE | 900 - 999 RUSSIA AVE | 900 RUSSIA AVE | - | MUNICH ST | MUNICH ST |
| 87217 | N/A | Point | - | - | - | - | S105174 | MADRID ST: RUSSIA AVE | - | F | F | - | F | 21720000 | 21720000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 2483 | 2483 | 37.72006281 | -122.43398511 | MADRID ST \ RUSSIA AVE | MADRID ST \ RUSSIA AVE | 1710539427000 | MTA | STOP | RUSSIA AVE intersection | - | 0 / 0 | - | - | - | - | - | 104405 | 57369600000 | -122.43398511 | 37.72006281 | - | 1089417600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569140000 | MADRID ST | - | - | - | - | - | - |
| 87218 | N/A | Point | 1 | 1 | 200 - 299 | - | S129793 | 200-299 DUBLIN ST | 200-299 DUBLIN ST | F | F | - | F | 4977000 | 4977000 | - | - | SOUTH SIDE | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 19621 | 19621 | 37.71650147 | -122.42794914 | - | - | 1754433680000 | middleware_editor | NPRK ANY TIME | RUSSIA AVE to END: 200-299 BLOCK (200 - 299) | - | IFO#263 (S-END OF BLOCK) | - | - | - | - | - | 104406 | 1226304000000 | -122.42794914 | 37.71650147 | - | - | - | D11 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP2 | 2IN IRON POST | IS | 1373576880000 | DUBLIN ST | 200 - 299 DUBLIN ST | 200 - 299 DUBLIN ST | 200 DUBLIN ST | - | END: 200-299 BLOCK | END: 200-299 BLOCK |
| 87219 | N/A | Point | 1 | 1 | 400 - 499 | - | S205938 | 400-499 RUSSIA AVE | 400-499 RUSSIA AVE | F | F | - | F | 11192000 | 11192000 | - | - | NORTH SIDE | - | - | - | - | MADRID ST | MADRID ST | 44559 | 44559 | 37.71987172 | -122.43358513 | - | - | 1710539427000 | MTA | NPRK ANY TIME VEH OVER 22' LONG OR 7' HIGH 12AM-6AM EVERYDAY | MADRID ST to EDINBURGH ST (400 - 499) | - | OPP#426 | - | - | - | - | - | 104407 | 124329600000 | -122.43358513 | 37.71987172 | - | 1406073600000 | - | D11 | - | PARKING:NPRK ANY TIME | REG | R30(SF).0572 | 18X18 | SUP2 | 2IN IRON POST | IS | 1400659800000 | RUSSIA AVE | 400 - 499 RUSSIA AVE | 400 - 499 RUSSIA AVE | 400 RUSSIA AVE | - | EDINBURGH ST | EDINBURGH ST |
| 87220 | N/A | Point | - | - | - | - | S110541 | DUBLIN ST: RUSSIA AVE | - | F | F | - | F | 21622000 | 21622000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DUBLIN ST | DUBLIN ST | 8106 | 8106 | 37.71699738 | -122.42757165 | RUSSIA AVE \ DUBLIN ST | RUSSIA AVE \ DUBLIN ST | 1710539427000 | MTA | STOP | DUBLIN ST intersection | - | - | - | - | - | - | - | 104408 | 655516800000 | -122.42757165 | 37.71699738 | - | 1553212800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570820000 | RUSSIA AVE | - | - | - | - | - | - |
| 87221 | N/A | Point | - | - | - | - | S250642 | NAPLES ST: RUSSIA AVE | - | F | F | - | F | 21711000 | 21711000 | - | - | SOUTH WEST CORNER | - | - | - | - | NAPLES ST | RUSSIA AVE | 79558 | 79558 | 37.71929846 | -122.43238519 | RUSSIA AVE \ NAPLES ST | NAPLES ST \ RUSSIA AVE | 1710539427000 | MTA | NPRK 10AM-12NN FRI STCL | RUSSIA AVE intersection | - | UNDER STREET NAMES | - | - | - | - | - | 104409 | 1558098660000 | -122.43238519 | 37.71929846 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0010 | 18X18 | SUP2 | 3IN IRON POST | IS | 1546946100000 | NAPLES ST | - | - | - | - | - | - |
| 87222 | N/A | Point | - | - | - | - | S267089 | RUSSIA AVE: MOSCOW ST | - | F | F | - | F | 21631000 | 21631000 | - | - | SOUTH SIDE | - | - | - | - | MOSCOW ST | RUSSIA AVE | 92783 | 92783 | 37.71814756 | -122.42997803 | RUSSIA AVE \ MOSCOW ST | MOSCOW ST \ RUSSIA AVE | 1710539427000 | MTA | NPRK 11AM-1PM MON STCL | RUSSIA AVE intersection | - | EPL 318 | - | - | - | - | - | 104410 | 2160000000 | -122.42997803 | 37.71814756 | - | 1599091200000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0027 | 18X18 | SUP2 | LIGHT POLE | IS | 1597393200000 | MOSCOW ST | - | - | - | - | - | - |
| 87223 | N/A | Point | - | - | - | - | S116387 | RUSSIA AVE: VIENNA ST | - | F | F | - | F | 21710000 | 21710000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | VIENNA ST | VIENNA ST | 16414 | 16414 | 37.7189161 | -122.43158486 | RUSSIA AVE \ VIENNA ST | RUSSIA AVE \ VIENNA ST | 1710539427000 | MTA | ALL WAY | VIENNA ST intersection | - | - | - | - | - | - | - | 104411 | 1049068800000 | -122.43158486 | 37.7189161 | - | - | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572680000 | RUSSIA AVE | - | - | - | - | - | - |
| 87224 | N/A | Point | - | - | - | RIGHT ARROW | S256618 | RUSSIA AVE: MOSCOW ST | - | F | F | - | F | 21631000 | 21631000 | - | - | SOUTH SIDE | - | - | - | - | MOSCOW ST | RUSSIA AVE | 117538 | 117538 | 37.71814756 | -122.42997803 | RUSSIA AVE \ MOSCOW ST | MOSCOW ST \ RUSSIA AVE | 1710539427000 | MTA | NPRK ANY TIME | RUSSIA AVE intersection | - | IFO 900 | - | - | - | - | - | 104412 | 2160000000 | -122.42997803 | 37.71814756 | - | 1565049600000 | - | D11 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0002 | 18X18 | SUP2 | 2IN IRON POST | IS | 1564572120000 | MOSCOW ST | - | - | - | - | - | - |
| 87225 | N/A | Point | 1 | 1 | 400 - 499 | - | S271769 | 400-499 RUSSIA AVE | 400-499 RUSSIA AVE | F | F | - | F | 11192000 | 11192000 | - | - | NORTH SIDE | - | - | - | - | MADRID ST | MADRID ST | 86146 | 86146 | 37.71987172 | -122.43358513 | - | - | 1710539427000 | MTA | BIKE RACK | MADRID ST to EDINBURGH ST (400 - 499) | 296553 | 87' E OF EDINGBURGH/3' IN FORM CURB | - | - | - | - | - | 104413 | 1611915300000 | -122.43358513 | 37.71987172 | - | - | - | D11 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1611239940000 | RUSSIA AVE | 400 - 499 RUSSIA AVE | 400 - 499 RUSSIA AVE | 400 RUSSIA AVE | - | EDINBURGH ST | EDINBURGH ST |
Download data as a comma-separated values file with coordinates and properties.
Download CSVDownload data in GeoJSON format, compatible with most GIS applications.
Download GeoJSONDownload data in KML format for use with Google Earth and other mapping applications.
Download KMLDownload data as a shapefile (ZIP format) for use with ArcGIS and other GIS software.
Download ShapefileGet detailed information about this dataset including metadata and available properties.
page - Page number (default: 1)limit - Results per page (max: 1000, default: 100)properties - JSON object for property filteringgeometry_type - Filter by geometry type (Point, LineString, Polygon, etc.)bbox - Bounding box (minX,minY,maxX,maxY)lat - Center latitude for radius searchlon - Center longitude for radius searchradius - Search radius in metersMetadata automatically harvested from the ESRI service during import.