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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87001 | N/A | Point | - | - | - | - | S239291 | 24TH ST: SAN JOSE AVE | - | F | F | - | F | 24104000 | 24104000 | - | - | SOUTH WEST CORNER | - | - | - | - | 24TH ST | 24TH ST | 85336 | 85336 | 37.75204681 | -122.42159515 | SAN JOSE AVE \ 24TH ST | SAN JOSE AVE \ 24TH ST | 1710539427000 | MTA | 24TH ST | 24TH ST intersection | - | - | - | - | - | - | - | 104188 | 1518446400000 | -122.42159515 | 37.75204681 | - | 1518393600000 | - | D8 | - | STREET NAME | GUIDE | D3-1.0018 | 36X08 | SUP2 | 3IN IRON POST | IS | 1507036800000 | SAN JOSE AVE | - | - | - | - | - | - |
| 87002 | N/A | Point | - | - | - | - | S128608 | 24TH ST: SAN JOSE AVE | - | F | F | - | F | 24104000 | 24104000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 20544 | 20544 | 37.75204681 | -122.42159515 | SAN JOSE AVE \ 24TH ST | SAN JOSE AVE \ 24TH ST | 1710539427000 | MTA | SCHOOL (SYM)/ 45 LEFT DN ARROW (COMBO) | 24TH ST intersection | - | - | - | - | - | - | - | 104189 | 1200614400000 | -122.42159515 | 37.75204681 | - | 1508889600000 | - | D8 | - | SCHOOL | WARNING | SW24-2(CA).0001 | 30X42 | SUP2 | LIGHT POLE | IS | 1373576520000 | SAN JOSE AVE | - | - | - | - | - | - |
| 87003 | N/A | Point | 1 | 1 | 3350 - 3375 | - | S288573 | 3350-3375 24TH ST | 3350-3375 24TH ST | F | F | - | F | 1348000 | 1348000 | - | - | SOUTH SIDE | - | - | - | - | BARTLETT ST | BARTLETT ST | 106622 | 106622 | 37.7521553 | -122.41982076 | - | - | 1710539427000 | MTA | BIKE RACK | BARTLETT ST to ORANGE ALY (3350 - 3375) | - | 50'/68' E OF ORANGE STREET/5' IN FROM CU | - | - | - | - | - | 104190 | - | -122.41982076 | 37.7521553 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1681821720000 | 24TH ST | 3350 - 3375 24TH ST | 3350 - 3375 24TH ST | 3350 24TH ST | - | ORANGE ALY | ORANGE ALY |
| 87004 | N/A | Point | 1 | 1 | 3350 - 3375 | - | S283278 | 3350-3375 24TH ST | 3350-3375 24TH ST | F | F | - | F | 1348000 | 1348000 | - | - | SOUTH SIDE | - | - | - | - | BARTLETT ST | BARTLETT ST | 93847 | 93847 | 37.7521553 | -122.41982076 | - | - | 1710539427000 | MTA | BIKE RACK | BARTLETT ST to ORANGE ALY (3350 - 3375) | 527452 | 9' W OF EPL 3401/3.5' IN FROM CURB | - | - | - | - | - | 104191 | 1656374400000 | -122.41982076 | 37.7521553 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1654617420000 | 24TH ST | 3350 - 3375 24TH ST | 3350 - 3375 24TH ST | 3350 24TH ST | - | ORANGE ALY | ORANGE ALY |
| 87005 | N/A | Point | 1 | 1 | 3350 - 3375 | - | S288574 | 3350-3375 24TH ST | 3350-3375 24TH ST | F | F | - | F | 1348000 | 1348000 | - | - | NORTH SIDE | - | - | - | - | BARTLETT ST | BARTLETT ST | 106623 | 106623 | 37.7521553 | -122.41982076 | - | - | 1710539427000 | MTA | BIKE RACK | BARTLETT ST to ORANGE ALY (3350 - 3375) | - | 4'/23' W OF EPL 3372/3.5' IN FROM CURB | - | - | - | - | - | 104192 | - | -122.41982076 | 37.7521553 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1681821960000 | 24TH ST | 3350 - 3375 24TH ST | 3350 - 3375 24TH ST | 3350 24TH ST | - | ORANGE ALY | ORANGE ALY |
| 87006 | N/A | Point | 1 | 1 | 3350 - 3375 | - | S124233 | 3350-3375 24TH ST | 3350-3375 24TH ST | F | F | - | F | 1348000 | 1348000 | - | - | NORTH SIDE | - | - | - | - | BARTLETT ST | BARTLETT ST | 125591 | 125591 | 37.7521553 | -122.41982076 | - | - | 1710539427000 | MTA | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | BARTLETT ST to ORANGE ALY (3350 - 3375) | - | 40`WEST | - | - | - | - | - | 104193 | 1150934400000 | -122.41982076 | 37.7521553 | - | - | - | D9 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP2 | 2 POST ALUMINUM | IS | 1373575140000 | 24TH ST | 3350 - 3375 24TH ST | 3350 - 3375 24TH ST | 3350 24TH ST | - | ORANGE ALY | ORANGE ALY |
| 87007 | N/A | Point | - | - | - | - | S118438 | 24TH ST: BARTLETT ST | - | F | F | - | F | 24092000 | 24092000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 24TH ST | BARTLETT ST | 16480 | 16480 | 37.75217141 | -122.41955737 | BARTLETT ST \ 24TH ST | 24TH ST \ BARTLETT ST | 1710539427000 | MTA | STOP | BARTLETT ST intersection | - | NECORNER | - | - | - | - | - | 104194 | 1078272000000 | -122.41955737 | 37.75217141 | - | 1424995200000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373573280000 | 24TH ST | - | - | - | - | - | - |
| 87008 | N/A | Point | - | - | - | - | S118446 | 24TH ST: BARTLETT ST | - | F | F | - | F | 24092000 | 24092000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 24TH ST | BARTLETT ST | 16486 | 16486 | 37.75217141 | -122.41955737 | BARTLETT ST \ 24TH ST | 24TH ST \ BARTLETT ST | 1710539427000 | MTA | ALL WAY | BARTLETT ST intersection | - | SWCORNER | - | - | - | - | - | 104195 | 1078272000000 | -122.41955737 | 37.75217141 | - | 1591920000000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1373573280000 | 24TH ST | - | - | - | - | - | - |
| 87009 | N/A | Point | - | - | - | - | S116339 | BARTLETT ST: 24TH ST | - | F | F | - | F | 24092000 | 24092000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | BARTLETT ST | 13932 | 13932 | 37.75217141 | -122.41955737 | BARTLETT ST \ 24TH ST | 24TH ST \ BARTLETT ST | 1755032973000 | middleware_editor | STOP | BARTLETT ST intersection | - | NB AND EB | - | - | - | - | - | 104196 | 1047970800000 | -122.41955737 | 37.75217141 | - | 1755018780000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373572620000 | 24TH ST | - | - | - | - | - | - |
| 87010 | N/A | Point | - | - | - | - | S102089 | BARTLETT ST: 24TH ST | - | F | F | - | F | 24092000 | 24092000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | BARTLETT ST | 3428 | 3428 | 37.75217141 | -122.41955737 | BARTLETT ST \ 24TH ST | 24TH ST \ BARTLETT ST | 1710539427000 | MTA | STOP | BARTLETT ST intersection | - | 0 / 0 | - | - | - | - | - | 104197 | -392601600000 | -122.41955737 | 37.75217141 | - | - | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568180000 | 24TH ST | - | - | - | - | - | - |
| 87011 | N/A | Point | - | - | - | - | S262236 | BARTLETT ST: 24TH ST | - | F | F | - | F | 24092000 | 24092000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | BARTLETT ST | 96880 | 96880 | 37.75217141 | -122.41955737 | BARTLETT ST \ 24TH ST | 24TH ST \ BARTLETT ST | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | BARTLETT ST intersection | 133618 | - | - | - | - | - | - | 104198 | 1319414400000 | -122.41955737 | 37.75217141 | - | - | - | D9 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP2 | 2IN IRON POST | IS | 1583398140000 | 24TH ST | - | - | - | - | - | - |
| 87012 | N/A | Point | - | - | - | - | S104204 | BARTLETT ST: 24TH ST | - | F | F | - | F | 24092000 | 24092000 | - | - | SOUTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | BARTLETT ST | 77148 | 77148 | 37.75217141 | -122.41955737 | BARTLETT ST \ 24TH ST | 24TH ST \ BARTLETT ST | 1710539427000 | MTA | STOP | BARTLETT ST intersection | - | 0 / 0 | - | - | - | - | - | 104199 | -42422400000 | -122.41955737 | 37.75217141 | - | 1400112000000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568840000 | 24TH ST | - | - | - | - | - | - |
| 87013 | N/A | Point | 1 | 1 | 800 - 899 | - | S146120 | 800-899 SHIELDS ST | 800-899 SHIELDS ST | F | F | - | F | 11815000 | 11815000 | - | - | SOUTH SIDE | - | - | - | - | BYXBEE ST | BYXBEE ST | 34505 | 34505 | 37.71788517 | -122.4702853 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM 1ST & 3RD WED OF MONTH STCL | BYXBEE ST to MONTICELLO ST (800 - 899) | - | 100 FEET EAST OF MONTICELLO OPP 824 | - | - | - | - | - | 104200 | 1223337600000 | -122.4702853 | 37.71788517 | - | 1670284800000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0069 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375727880000 | SHIELDS ST | 800 - 899 SHIELDS ST | 800 - 899 SHIELDS ST | 800 SHIELDS ST | - | MONTICELLO ST | MONTICELLO ST |
| 87014 | N/A | Point | - | - | - | - | S109059 | MONTICELLO ST: SHIELDS ST | - | F | F | - | F | 22726000 | 22726000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SHIELDS ST | SHIELDS ST | 5878 | 5878 | 37.71788217 | -122.47073297 | MONTICELLO ST \ SHIELDS ST | MONTICELLO ST \ SHIELDS ST | 1710539427000 | MTA | STOP | SHIELDS ST intersection | - | 0 / 0 | - | - | - | - | - | 104201 | 398995200000 | -122.47073297 | 37.71788217 | - | 1548806400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570400000 | MONTICELLO ST | - | - | - | - | - | - |
| 87015 | N/A | Point | - | - | - | - | S131848 | BEVERLY ST: SHIELDS ST | - | F | F | - | F | 22725000 | 22725000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SHIELDS ST | BEVERLY ST | 26632 | 26632 | 37.71787615 | -122.47163218 | BEVERLY ST \ SHIELDS ST | SHIELDS ST \ BEVERLY ST | 1710539427000 | MTA | ALL WAY | BEVERLY ST intersection | - | - | - | - | - | - | - | 104202 | 1261440000000 | -122.47163218 | 37.71787615 | - | 1590537600000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373577480000 | SHIELDS ST | - | - | - | - | - | - |
| 87016 | N/A | Point | - | - | - | - | S118287 | CABRILLO ST: 45TH AVE | - | F | F | - | F | 27972000 | 27972000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 45TH AVE | CABRILLO ST | 12509 | 12509 | 37.77345628 | -122.50574708 | CABRILLO ST \ 45TH AVE | 45TH AVE \ CABRILLO ST | 1710539427000 | MTA | ALL WAY | CABRILLO ST intersection | - | - | - | - | - | - | - | 104203 | 1075334400000 | -122.50574708 | 37.77345628 | - | 1639440000000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573280000 | 45TH AVE | - | - | - | - | - | - |
| 87017 | N/A | Point | - | - | - | - | S131849 | SHIELDS ST: BEVERLY ST | - | F | F | - | F | 22725000 | 22725000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SHIELDS ST | BEVERLY ST | 121718 | 121718 | 37.71787615 | -122.47163218 | BEVERLY ST \ SHIELDS ST | SHIELDS ST \ BEVERLY ST | 1731076544000 | middleware_editor | ALL WAY | BEVERLY ST intersection | - | - | - | - | - | - | - | 104204 | 1261440000000 | -122.47163218 | 37.71787615 | - | 1730978700000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373577480000 | SHIELDS ST | - | - | - | - | - | - |
| 87018 | N/A | Point | 1 | 1 | 1000 - 1089 | - | S146117 | 1000-1089 SHIELDS ST | 1000-1089 SHIELDS ST | F | F | - | F | 11817000 | 11817000 | - | - | SOUTH SIDE | - | - | - | - | BEVERLY ST | BEVERLY ST | 35381 | 35381 | 37.71787411 | -122.47193768 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM 1ST & 3RD WED OF MONTH STCL | BEVERLY ST to SHIELDS ST (1000 - 1089) | - | 714 SHIELDS | - | - | - | - | - | 104205 | 1223337600000 | -122.47193768 | 37.71787411 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0069 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375727880000 | SHIELDS ST | 1000 - 1089 SHIELDS ST | 1000 - 1089 SHIELDS ST | 1000 SHIELDS ST | - | SHIELDS ST | SHIELDS ST |
| 87019 | N/A | Point | - | - | - | - | S107241 | 45TH AVE: CABRILLO ST | - | F | F | - | F | 27972000 | 27972000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 45TH AVE | CABRILLO ST | 5934 | 5934 | 37.77345628 | -122.50574708 | CABRILLO ST \ 45TH AVE | 45TH AVE \ CABRILLO ST | 1710539427000 | MTA | STOP | CABRILLO ST intersection | - | 0 / 0 | - | - | - | - | - | 104206 | 209347200000 | -122.50574708 | 37.77345628 | - | 1075334400000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569800000 | 45TH AVE | - | - | - | - | - | - |
| 87020 | N/A | Point | - | - | - | - | S109064 | SHIELDS ST: MONTICELLO ST | - | F | F | - | F | 22726000 | 22726000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SHIELDS ST | SHIELDS ST | 7393 | 7393 | 37.71788217 | -122.47073297 | MONTICELLO ST \ SHIELDS ST | MONTICELLO ST \ SHIELDS ST | 1710539427000 | MTA | STOP | SHIELDS ST intersection | - | 0 / 0 | - | - | - | - | - | 104207 | 398995200000 | -122.47073297 | 37.71788217 | - | 1553558400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570400000 | MONTICELLO ST | - | - | - | - | - | - |
| 87021 | N/A | Point | 1 | 1 | 1 - 99 | - | S113950 | 1-99 LOWELL ST | 1-99 LOWELL ST | F | F | - | F | 8503000 | 8503000 | - | - | NORTH SIDE | - | - | - | - | MISSION ST | MISSION ST | 12902 | 12902 | 37.71123772 | -122.44627574 | - | - | 1710539427000 | MTA | TANSAT | MISSION ST to MORSE ST (1 - 99) | - | IFO#5 | - | - | - | - | - | 104208 | 999129600000 | -122.44627574 | 37.71123772 | - | - | - | D11 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | MUNI POLE | IS | 1373571900000 | LOWELL ST | 1 - 99 LOWELL ST | 1 - 99 LOWELL ST | 1 LOWELL ST | - | MORSE ST | MORSE ST |
| 87022 | N/A | Point | - | - | - | - | S281231 | VAN NESS AVE: GEARY BLVD \ GEA | - | F | F | - | F | 25197000 | 25197000 | - | - | CENTER ISLAND, N LINE, SOUTHBOUND | - | - | - | - | GEARY BLVD \ VAN NESS AVE | GEARY BLVD \ VAN NESS AVE | 95390 | 95390 | 37.7856858 | -122.42139331 | GEARY ST \ GEARY BLVD \ VAN NESS AVE | GEARY ST \ GEARY BLVD \ VAN NESS AVE | 1710539427000 | MTA | SOLAR LANTERN WHITE (V5) | GEARY BLVD \ VAN NESS AVE intersection | 18091 | 9FT SOUTH OF GEARY | - | - | - | - | - | 104209 | 1646265600000 | -122.42139331 | 37.7856858 | - | - | - | D5 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | UNISTRUT | IS | 1646308380000 | GEARY ST | - | - | - | - | - | - |
| 87023 | N/A | Point | - | - | - | - | 22201 | - | - | - | - | - | T | 13580101 | - | - | - | CENTER ISLAND, E LINE, NORTHBOUND | 1692209782000 | malopez | - | - | 15TH AVE | - | 147011 | 147011 | 37.735503914795 | -122.471178062101 | - | - | 1741634519000 | middleware_editor | MUNI LOCAL (FLAG) T- LINE | - | 17109 | 10' SOUTH OF RAMP IN FRONT OF STOP BAR | - | - | - | - | 1 | 104210 | 1741632900000 | - | - | - | - | - | 07 | - | OTHER GUIDE | GUIDE | G-L(SF).0046 | 18X24 | SUP3 | UNISTRUT | IS | - | WEST PORTAL AVE | 401 - 499 WEST PORTAL AVE | - | - | - | JUNIPERO SERRA BLVD \ PORTOLA DR \ SAINT FRANCIS BLVD \ SLOAT BLVD | - |
| 87024 | N/A | Point | - | - | - | - | S220318 | VERMONT ST: 23RD ST | - | F | F | - | F | 13220000 | 23727000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | HUMBOLDT ST | 23RD ST | 57987 | 57987 | 37.75447539 | -122.403548581 | - | VERMONT ST \ 23RD ST | 1710539427000 | MTA | STOP | 23RD ST intersection | - | - | - | - | - | - | - | 104211 | 191635200000 | -122.4035231 | 37.75445383 | - | 1446163200000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1445868300000 | VERMONT ST | 1100 - 1199 VERMONT ST | - | - | - | 23RD ST | - |
| 87025 | N/A | Point | 1 | 1 | 600 - 699 | - | S267082 | 600-699 NAPLES ST | 600-699 NAPLES ST | F | F | - | F | 9493000 | 9493000 | - | - | EAST SIDE | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 92778 | 92778 | 37.71852124 | -122.43297027 | - | - | 1710539427000 | MTA | NPRK 10AM-12NN TUE STCL | RUSSIA AVE to FRANCE AVE (600 - 699) | - | 40 FT NORTH OF FRANCE | - | - | - | - | - | 104212 | 947721600000 | -122.43297027 | 37.71852124 | - | 1531094400000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0013 | 18X18 | SUP2 | 2IN IRON POST | IS | 1597392060000 | NAPLES ST | 600 - 699 NAPLES ST | 600 - 699 NAPLES ST | 600 NAPLES ST | - | FRANCE AVE | FRANCE AVE |
| 87026 | N/A | Point | 1 | 1 | 500 - 599 | - | S256810 | 500-599 PARIS ST | 500-599 PARIS ST | F | F | - | F | 10255000 | 10255000 | - | - | WEST SIDE | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 88059 | 88059 | 37.72004798 | -122.43617052 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM WED STCL | RUSSIA AVE to FRANCE AVE (500 - 599) | - | SPL 558 | - | - | - | - | - | 104213 | -401241600000 | -122.43617052 | 37.72004798 | - | 1576022400000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP2 | LIGHT POLE | IS | 1564994280000 | PARIS ST | 500 - 599 PARIS ST | 500 - 599 PARIS ST | 500 PARIS ST | - | FRANCE AVE | FRANCE AVE |
| 87027 | N/A | Point | 1 | 1 | 600 - 699 | - | S267083 | 600-699 NAPLES ST | 600-699 NAPLES ST | F | F | - | F | 9493000 | 9493000 | - | - | EAST SIDE | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 92779 | 92779 | 37.71852124 | -122.43297027 | - | - | 1710539427000 | MTA | NPRK 10AM-12NN TUE STCL | RUSSIA AVE to FRANCE AVE (600 - 699) | - | NPL 651 | - | - | - | - | - | 104214 | 947721600000 | -122.43297027 | 37.71852124 | - | 1597622400000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0013 | 18X18 | SUP2 | 2IN IRON POST | IS | 1597392240000 | NAPLES ST | 600 - 699 NAPLES ST | 600 - 699 NAPLES ST | 600 NAPLES ST | - | FRANCE AVE | FRANCE AVE |
| 87028 | N/A | Point | 1 | 1 | 500 - 599 | - | S248934 | 500-599 LONDON ST | 500-599 LONDON ST | F | F | - | F | 8474000 | 8474000 | - | - | EAST SIDE | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 129776 | 129776 | 37.72042956 | -122.43697164 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM WED STCL | RUSSIA AVE to FRANCE AVE (500 - 599) | - | SPL# 583 LONDON ST | - | - | - | - | - | 104215 | - | -122.43697164 | 37.72042956 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP2 | 2IN IRON POST | IS | 1539619440000 | LONDON ST | 500 - 599 LONDON ST | 500 - 599 LONDON ST | 500 LONDON ST | - | FRANCE AVE | FRANCE AVE |
| 87029 | N/A | Point | 1 | 1 | 1 - 99 | - | S121760 | 1-99 FRANCE AVE | 1-99 FRANCE AVE | F | F | - | F | 5743000 | 5743000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | MISSION ST | MISSION ST | 20035 | 20035 | 37.71983261 | -122.43794407 | - | - | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | MISSION ST to LONDON ST (1 - 99) | 100886 | IFO#32 | - | - | - | - | - | 104216 | 1128470400000 | -122.43794407 | 37.71983261 | - | - | - | D11 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1373574360000 | FRANCE AVE | 1 - 99 FRANCE AVE | 1 - 99 FRANCE AVE | 1 FRANCE AVE | - | LONDON ST | LONDON ST |
| 87030 | N/A | Point | 1 | 1 | 500 - 599 | - | S272028 | 500-599 LISBON ST | 500-599 LISBON ST | F | F | - | F | 8410000 | 8410000 | - | - | WEST SIDE | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 92997 | 92997 | 37.71966758 | -122.43537191 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM MON STCL | RUSSIA AVE to FRANCE AVE (500 - 599) | - | SPL 586 | - | - | - | - | - | 104217 | 1486080000000 | -122.43537191 | 37.71966758 | - | 1615507200000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0261 | 18X18 | SUP2 | 2IN IRON POST | IS | 1611921840000 | LISBON ST | 500 - 599 LISBON ST | 500 - 599 LISBON ST | 500 LISBON ST | - | FRANCE AVE | FRANCE AVE |
| 87031 | N/A | Point | 1 | 1 | 500 - 599 | - | S283716 | 500-599 PARIS ST | 500-599 PARIS ST | F | F | - | F | 10255000 | 10255000 | - | - | WEST SIDE | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 94258 | 94258 | 37.72004798 | -122.43617052 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM WED STCL | RUSSIA AVE to FRANCE AVE (500 - 599) | - | NPL 534 | - | - | - | - | - | 104218 | - | -122.43617052 | 37.72004798 | - | 1656374400000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP2 | LIGHT POLE | IS | 1656407880000 | PARIS ST | 500 - 599 PARIS ST | 500 - 599 PARIS ST | 500 PARIS ST | - | FRANCE AVE | FRANCE AVE |
| 87032 | N/A | Point | 1 | 1 | 935 - 999 | RIGHT ARROW | S282189 | 935-999 MISSION ST | 935-999 MISSION ST | F | F | - | F | 9099000 | 9099000 | - | - | SOUTH SIDE | - | - | - | - | MARY ST | MARY ST | 125668 | 125668 | 37.781947018 | -122.407354033 | - | - | 1710539427000 | MTA | TANSAT | MARY ST to 06TH ST (935 - 999) | - | 54' WEST OF MARY ST. | - | - | - | - | - | 104219 | 1653350400000 | -122.40798167 | 37.7815453 | - | - | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1649839740000 | MISSION ST | 935 - 999 MISSION ST | 935 - 999 MISSION ST | 935 MISSION ST | - | 06TH ST | 06TH ST |
| 87033 | N/A | Point | - | - | - | - | S281227 | VAN NESS AVE: BUSH ST | - | F | F | - | F | 25223000 | 25223000 | - | - | CENTER ISLAND, S LINE, NORTHBOUND | - | - | - | - | VAN NESS AVE | BUSH ST | 95225 | 95225 | 37.78848964 | -122.42194859 | BUSH ST \ VAN NESS AVE | VAN NESS AVE \ BUSH ST | 1710539427000 | MTA | SOLAR LANTERN WHITE (V5) | BUSH ST intersection | 18092 | 8FT SOUTH OF BUSH/ EAST SIDE | - | - | - | - | - | 104220 | 1646265600000 | -122.42194859 | 37.78848964 | - | - | - | D2 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | UNISTRUT | IS | 1646305440000 | VAN NESS AVE | - | - | - | - | - | - |
| 87034 | N/A | Point | 1 | 1 | 300 - 399 | - | S262059 | 300-399 TOWNSEND ST | 300-399 TOWNSEND ST | F | F | - | F | 12663000 | 12663000 | - | - | SOUTH SIDE | - | - | - | - | 4TH ST | 04TH ST | 126786 | 126786 | 37.77621079 | -122.3960939 | - | - | 1721697510000 | middleware_editor | SOLAR LANTERN WHITE (V5) | 04TH ST to 05TH ST (300 - 399) | - | 160 FT WEST OF 4TH | - | - | - | - | - | 104221 | 1567641600000 | -122.3960939 | 37.77621079 | - | 1583884800000 | - | D6 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | UNISTRUT | IS | 1583143500000 | TOWNSEND ST | 300 - 399 TOWNSEND ST | 300 - 399 TOWNSEND ST | 300 TOWNSEND ST | - | 05TH ST | 05TH ST |
| 87035 | N/A | Point | - | - | - | - | S230255 | THE EMBARCADERO: GREEN ST | - | F | F | - | T | 12556202 | 34014000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | GREEN ST | GREEN ST | 66453 | 66453 | 37.80089648 | -122.39913024 | - | THE EMBARCADERO \ GREEN ST | 1727358407000 | middleware_editor | SOLAR LANTERN WHITE (V5) | GREEN ST intersection | 14515 | 80' NORTH OF X WALK X ST IS GREENWICH | - | - | - | - | - | 104222 | 1727274180000 | -122.39913024 | 37.80089648 | - | - | - | D3 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | 2IN FLANGE POST | IS | 1477562820000 | THE EMBARCADERO | 600 - 1098 THE EMBARCADERO | - | - | - | BATTERY ST \ LOMBARD ST | - |
| 87036 | N/A | Point | 1 | 1 | 4650 - 4699 | - | S265306 | 4650-4699 MISSION ST | 4650-4699 MISSION ST | F | F | - | F | 9167000 | 9167000 | - | - | WEST SIDE | - | - | - | - | OCEAN AVE | OCEAN AVE | 113266 | 113266 | 37.72351968 | -122.43568099 | - | - | 1717809052000 | middleware_editor | SOLAR LANTERN WHITE (V5) | OCEAN AVE to PERSIA AVE (4650 - 4699) | - | 25 FT NORTH OF PERSIA | - | - | - | - | - | 104223 | - | -122.43568099 | 37.72351968 | - | - | - | D11 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP2 | UNISTRUT | IS | 1592570040000 | MISSION ST | 4650 - 4699 MISSION ST | 4650 - 4699 MISSION ST | 4650 MISSION ST | - | PERSIA AVE | PERSIA AVE |
| 87037 | N/A | Point | - | - | - | - | S286658 | STOCKTON ST: WASHINGTON ST | - | F | F | - | F | 25026000 | 25026000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | STOCKTON ST | WASHINGTON ST | 99147 | 99147 | 37.79494069 | -122.4080791 | WASHINGTON ST \ STOCKTON ST | STOCKTON ST \ WASHINGTON ST | 1710539427000 | MTA | SOLAR LANTERN WHITE (V5) | WASHINGTON ST intersection | - | 8FT SOUTH OF WASHINGTON INFO ( B OF A) | - | - | - | - | - | 104224 | 1671235200000 | -122.4080791 | 37.79494069 | - | - | - | D3 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | UNISTRUT | IS | 1671200100000 | STOCKTON ST | - | - | - | - | - | - |
| 87038 | N/A | Point | - | - | - | - | S118444 | BARTLETT ST: 24TH ST | - | F | F | - | F | 24092000 | 24092000 | - | - | SOUTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | BARTLETT ST | 16484 | 16484 | 37.75217141 | -122.41955737 | BARTLETT ST \ 24TH ST | 24TH ST \ BARTLETT ST | 1710539427000 | MTA | ALL WAY | BARTLETT ST intersection | - | SWCORNER | - | - | - | - | - | 104225 | 1078272000000 | -122.41955737 | 37.75217141 | - | 1573689600000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573280000 | 24TH ST | - | - | - | - | - | - |
| 87039 | N/A | Point | - | - | - | - | S118445 | 24TH ST: BARTLETT ST | - | F | F | - | F | 24092000 | 24092000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 24TH ST | BARTLETT ST | 16485 | 16485 | 37.75217141 | -122.41955737 | BARTLETT ST \ 24TH ST | 24TH ST \ BARTLETT ST | 1710539427000 | MTA | ALL WAY | BARTLETT ST intersection | - | NECORNER | - | - | - | - | - | 104226 | 1078272000000 | -122.41955737 | 37.75217141 | - | 1575504000000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573280000 | 24TH ST | - | - | - | - | - | - |
| 87040 | N/A | Point | - | - | - | - | S249522 | BROADWAY: KEARNY ST | - | F | F | - | F | 3151000 | 24795000 | - | - | NORTH SIDE | - | - | - | - | KEARNY ST | BROADWAY | 84491 | 84491 | 37.79801696 | -122.40547307 | - | KEARNY ST \ BROADWAY | 1710539427000 | MTA | TANP (SYM) 11:30PM-4AM FRI & SAT NIGHTS | BROADWAY intersection | - | 88' WEST OF KEARNY ST | - | - | - | - | - | 104227 | 1333324800000 | -122.40547307 | 37.79801696 | - | - | - | D3 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0051 | 14X21 | SUP1 | LIGHT POLE | IS | 1541664180000 | KEARNY ST | 500 - 544 BROADWAY | - | - | - | ROMOLO ST | - |
| 87041 | N/A | Point | 1 | 1 | 3150 - 3199 | DOWN ARROW | S282315 | 3150-3199 24TH ST | 3150-3199 24TH ST | F | F | - | F | 1341000 | 1341000 | - | - | SOUTH SIDE | - | - | - | - | SHOTWELL ST | SHOTWELL ST | 91595 | 91595 | 37.75240622 | -122.4157189 | - | - | 1710539427000 | MTA | NPRK 6AM-8AM MON WED FRI STCL | SHOTWELL ST to SOUTH VAN NESS AVE (3150 - 3199) | - | IFO 3169 UNDER SIGN | - | - | - | - | - | 104228 | - | -122.4157189 | 37.75240622 | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0192 | 18X18 | SUP2 | LIGHT POLE | IS | 1650364500000 | 24TH ST | 3150 - 3199 24TH ST | 3150 - 3199 24TH ST | 3150 24TH ST | - | SOUTH VAN NESS AVE | SOUTH VAN NESS AVE |
| 87042 | N/A | Point | 1 | 1 | 3150 - 3199 | - | S280726 | 3150-3199 24TH ST | 3150-3199 24TH ST | F | F | - | F | 1341000 | 1341000 | - | - | SOUTH SIDE | - | - | - | - | SHOTWELL ST | SHOTWELL ST | 123049 | 123049 | 37.75240622 | -122.4157189 | - | - | 1710539427000 | MTA | BIKE RACK | SHOTWELL ST to SOUTH VAN NESS AVE (3150 - 3199) | 495662 | 11' E OF WPL 3174/ 3.5' IN FROM CURB | - | - | - | - | - | 104229 | 1649808000000 | -122.4157189 | 37.75240622 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1643792580000 | 24TH ST | 3150 - 3199 24TH ST | 3150 - 3199 24TH ST | 3150 24TH ST | - | SOUTH VAN NESS AVE | SOUTH VAN NESS AVE |
| 87043 | N/A | Point | - | - | - | - | S118439 | 24TH ST: BARTLETT ST | - | F | F | - | F | 24092000 | 24092000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 24TH ST | BARTLETT ST | 16481 | 16481 | 37.75217141 | -122.41955737 | BARTLETT ST \ 24TH ST | 24TH ST \ BARTLETT ST | 1710539427000 | MTA | STOP | BARTLETT ST intersection | - | SWCORNER | - | - | - | - | - | 104230 | 1078272000000 | -122.41955737 | 37.75217141 | - | 1536796800000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373573280000 | 24TH ST | - | - | - | - | - | - |
| 87044 | N/A | Point | - | - | - | - | S216714 | BARTLETT ST: 24TH ST | - | T | T | - | F | 24092000 | 24092000 | - | - | SOUTH WEST CORNER | - | - | - | - | 24TH ST | BARTLETT ST | 53743 | 53743 | 37.75217141 | -122.41955737 | BARTLETT ST \ 24TH ST | 24TH ST \ BARTLETT ST | 1710539427000 | MTA | BARTLETT ST | BARTLETT ST intersection | - | 300 | - | - | - | - | - | 104231 | 1477296840000 | -122.41955737 | 37.75217141 | - | 1477267200000 | - | D9 | - | STREET NAME | GUIDE | D3-1.0173 | 36X08 | SUP2 | LIGHT POLE | IS | 1433240340000 | 24TH ST | - | - | - | - | - | - |
| 87045 | N/A | Point | - | - | - | - | S118443 | BARTLETT ST: 24TH ST | - | F | F | - | F | 24092000 | 24092000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | BARTLETT ST | 16483 | 16483 | 37.75217141 | -122.41955737 | BARTLETT ST \ 24TH ST | 24TH ST \ BARTLETT ST | 1710539427000 | MTA | ALL WAY | BARTLETT ST intersection | - | SECORNER | - | - | - | - | - | 104232 | 1078272000000 | -122.41955737 | 37.75217141 | - | 1573689600000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573280000 | 24TH ST | - | - | - | - | - | - |
| 87046 | N/A | Point | - | - | - | - | S229205 | OSAGE ALY: 24TH ST | - | F | F | - | F | 24089000 | 24089000 | - | - | SOUTH WEST CORNER | - | - | - | - | OSAGE ALY | 24TH ST | 66647 | 66647 | 37.75220444 | -122.41901754 | 24TH ST \ OSAGE ALY | OSAGE ALY \ 24TH ST | 1710539427000 | MTA | OSAGE ALY | 24TH ST intersection | - | 000 | - | - | - | - | - | 104233 | 1477296960000 | -122.41901754 | 37.75220444 | - | 1477267200000 | - | D9 | - | STREET NAME | GUIDE | D3-1.1323 | 36X08 | SUP2 | LIGHT POLE | IS | 1474880040000 | OSAGE ALY | - | - | - | - | - | - |
| 87047 | N/A | Point | - | - | - | - | S249624 | OSAGE ALY: 24TH ST | - | F | F | - | F | 24089000 | 24089000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | OSAGE ALY | 24TH ST | 84848 | 84848 | 37.75220444 | -122.41901754 | 24TH ST \ OSAGE ALY | OSAGE ALY \ 24TH ST | 1710539427000 | MTA | ONE WAY (RA) | 24TH ST intersection | - | - | - | - | - | - | - | 104234 | 1543933200000 | -122.41901754 | 37.75220444 | - | 1557964800000 | - | D9 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | LIGHT POLE | IS | 1542204480000 | OSAGE ALY | - | - | - | - | - | - |
| 87048 | N/A | Point | 1 | 1 | 3300 - 3322 | - | S124231 | 3300-3322 24TH ST | 3300-3322 24TH ST | F | F | - | F | 1346000 | 1346000 | - | - | NORTH SIDE | - | - | - | - | MISSION ST | MISSION ST | 17079 | 17079 | 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) | - | 40`WEST | - | - | - | - | - | 104235 | 1150934400000 | -122.41873141 | 37.75222195 | - | - | - | D9 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP2 | 2 POST ALUMINUM | IS | 1373575140000 | 24TH ST | 3300 - 3322 24TH ST | 3300 - 3322 24TH ST | 3300 24TH ST | - | OSAGE ALY | OSAGE ALY |
| 87049 | N/A | Point | - | - | - | - | S238120 | OSAGE ALY: 24TH ST | - | F | F | - | F | 24089000 | 24089000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | OSAGE ALY | 24TH ST | 74436 | 74436 | 37.75220444 | -122.41901754 | 24TH ST \ OSAGE ALY | OSAGE ALY \ 24TH ST | 1710539427000 | MTA | ONE WAY (LA) | 24TH ST intersection | - | - | - | - | - | - | - | 104236 | 1477267200000 | -122.41901754 | 37.75220444 | - | 1506902400000 | - | D9 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP2 | 3IN IRON POST | IS | 1502122020000 | OSAGE ALY | - | - | - | - | - | - |
| 87050 | N/A | Point | 1 | 1 | 3300 - 3322 | - | S263436 | 3300-3322 24TH ST | 3300-3322 24TH ST | F | F | - | F | 1346000 | 1346000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | MISSION ST | MISSION ST | 102253 | 102253 | 37.75222195 | -122.41873141 | - | - | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | MISSION ST to OSAGE ALY (3300 - 3322) | 263890 | 65' WEST OF MISSION ST. | - | - | - | - | - | 104237 | 1249948800000 | -122.41873141 | 37.75222195 | - | - | - | D9 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1587468240000 | 24TH ST | 3300 - 3322 24TH ST | 3300 - 3322 24TH ST | 3300 24TH ST | - | OSAGE ALY | OSAGE ALY |
| 87051 | N/A | Point | 1 | 1 | 3300 - 3322 | RIGHT ARROW | S286867 | 3300-3322 24TH ST | 3300-3322 24TH ST | F | F | - | F | 1346000 | 1346000 | - | - | NORTH SIDE | - | - | - | - | MISSION ST | MISSION ST | 96193 | 96193 | 37.75222195 | -122.41873141 | - | - | 1710539427000 | MTA | TA (SYM) PLO AT ALL TIMES (5 MIN) H/C (SYM ) | MISSION ST to OSAGE ALY (3300 - 3322) | - | 54' WEST OF MISSION ST. | - | - | - | - | - | 104238 | 1675036800000 | -122.41873141 | 37.75222195 | - | - | - | D9 | - | OTHER REGULATORY | REG | R38(SF)1.0056 | 14X21 | SUP2 | 2IN IRON POST | IS | 1672754760000 | 24TH ST | 3300 - 3322 24TH ST | 3300 - 3322 24TH ST | 3300 24TH ST | - | OSAGE ALY | OSAGE ALY |
| 87052 | N/A | Point | - | - | - | - | S222741 | MISSION ST: 24TH ST | - | F | F | - | F | 24088000 | 24088000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 59326 | 59326 | 37.75223946 | -122.41844527 | MISSION ST \ 24TH ST | MISSION ST \ 24TH ST | 1710539427000 | MTA | EXC BUSES BICYCLES TAXIS AND TRUCKS (SYM) | 24TH ST intersection | - | - | - | - | - | - | - | 104239 | 1457913600000 | -122.41844527 | 37.75223946 | - | 1457913600000 | - | D9 | - | OTHER REGULATORY | REG | R(SF).0347 | 30X30 | SUP2 | LIGHT POLE | IS | 1453883100000 | MISSION ST | - | - | - | - | - | - |
| 87053 | N/A | Point | - | - | - | - | S222738 | MISSION ST: 24TH ST | - | F | F | - | F | 24088000 | 24088000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 59325 | 59325 | 37.75223946 | -122.41844527 | MISSION ST \ 24TH ST | MISSION ST \ 24TH ST | 1710539427000 | MTA | RIGHT TURN ONLY(SYM) | 24TH ST intersection | - | - | - | - | - | - | - | 104240 | 1457913600000 | -122.41844527 | 37.75223946 | - | 1457913600000 | - | D9 | - | OTHER REGULATORY | REG | R3-5.0002 | 30X36 | SUP2 | LIGHT POLE | IS | 1453882020000 | MISSION ST | - | - | - | - | - | - |
| 87054 | N/A | Point | - | - | - | - | S224518 | MISSION ST: 24TH ST | - | F | F | - | F | 24088000 | 24088000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 61914 | 61914 | 37.75223946 | -122.41844527 | MISSION ST \ 24TH ST | MISSION ST \ 24TH ST | 1710539427000 | MTA | RIGHT TURN ONLY(SYM) | 24TH ST intersection | - | INSTALL ON NEW 2IN /5FT SOUTH | - | - | - | - | - | 104241 | - | -122.41844527 | 37.75223946 | - | - | - | D9 | - | OTHER REGULATORY | REG | R3-5.0002 | 30X36 | SUP2 | 2IN IRON POST | IS | 1459414560000 | MISSION ST | - | - | - | - | - | - |
| 87055 | N/A | Point | - | - | - | - | S224519 | MISSION ST: 24TH ST | - | F | F | - | F | 24088000 | 24088000 | - | - | NORTH SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 61915 | 61915 | 37.75223946 | -122.41844527 | MISSION ST \ 24TH ST | MISSION ST \ 24TH ST | 1710539427000 | MTA | EXC BUSES BICYCLES TAXIS AND TRUCKS (SYM) | 24TH ST intersection | - | RELOCATE ON 2IN /5FT SOUTH | - | - | - | - | - | 104242 | - | -122.41844527 | 37.75223946 | - | - | - | D9 | - | OTHER REGULATORY | REG | R(SF).0347 | 30X30 | SUP2 | 2IN IRON POST | IS | 1459414740000 | MISSION ST | - | - | - | - | - | - |
| 87056 | N/A | Point | - | - | - | - | S227252 | MISSION ST: 24TH ST | - | F | F | - | F | 24088000 | 24088000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 66597 | 66597 | 37.75223946 | -122.41844527 | MISSION ST \ 24TH ST | MISSION ST \ 24TH ST | 1710539427000 | MTA | RIGHT TURN ONLY(SYM) | 24TH ST intersection | - | - | - | - | - | - | - | 104243 | 1470311820000 | -122.41844527 | 37.75223946 | - | 1470268800000 | - | D9 | - | OTHER REGULATORY | REG | R3-5.0002 | 30X36 | SUP2 | SIGNAL POLE | IS | 1468484700000 | MISSION ST | - | - | - | - | - | - |
| 87057 | N/A | Point | - | - | - | - | S222724 | MISSION ST: 24TH ST | - | F | F | - | F | 24088000 | 24088000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 62277 | 62277 | 37.75223946 | -122.41844527 | MISSION ST \ 24TH ST | MISSION ST \ 24TH ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | 24TH ST intersection | - | - | - | - | - | - | - | 104244 | 1096588800000 | -122.41844527 | 37.75223946 | - | 1459123200000 | - | D9 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1453820940000 | MISSION ST | - | - | - | - | - | - |
| 87058 | N/A | Point | - | - | - | - | S225289 | MISSION ST: 24TH ST | - | F | F | - | F | 24088000 | 24088000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 63956 | 63956 | 37.75223946 | -122.41844527 | MISSION ST \ 24TH ST | MISSION ST \ 24TH ST | 1710539427000 | MTA | EXCEPT MUNI | 24TH ST intersection | - | - | - | - | - | - | - | 104245 | 1096588800000 | -122.41844527 | 37.75223946 | - | 1462492800000 | - | D9 | - | OTHER REGULATORY | REG | R(SF).0357 | 30X08 | SUP2 | LIGHT POLE | IS | 1462273620000 | MISSION ST | - | - | - | - | - | - |
| 87059 | N/A | Point | - | - | - | - | S229197 | MISSION ST: 24TH ST | - | T | T | - | F | 24088000 | 24088000 | - | - | NORTH EAST CORNER | - | - | - | - | 24TH ST | 24TH ST | 67095 | 67095 | 37.75223946 | -122.41844527 | MISSION ST \ 24TH ST | MISSION ST \ 24TH ST | 1710539427000 | MTA | MISSION ST | 24TH ST intersection | - | 2800 | - | - | - | - | - | 104246 | 1477267200000 | -122.41844527 | 37.75223946 | - | 1477267200000 | - | D9 | - | STREET NAME | GUIDE | D3-1.1207 | 36X08 | SUP2 | LIGHT POLE | IS | 1474875300000 | MISSION ST | - | - | - | - | - | - |
| 87060 | N/A | Point | - | - | - | INBOUND | S240772 | MISSION ST: 24TH ST | - | F | F | - | F | 24088000 | 24088000 | - | - | EAST SIDE | - | - | - | - | 24TH ST | 24TH ST | 83151 | 83151 | 37.75223946 | -122.41844527 | MISSION ST \ 24TH ST | MISSION ST \ 24TH ST | 1710539427000 | MTA | BIKE RACK RAPID | 24TH ST intersection | 15565 | INFO 2777/ PAINT MARK | - | - | - | - | - | 104247 | 1517993400000 | -122.41844527 | 37.75223946 | - | 1517961600000 | - | D9 | - | BIKE RACK | REG | R(SF).0353 | 02X36 | SUP2 | BIKE RACK | IS | 1511291700000 | MISSION ST | - | - | - | - | - | - |
| 87061 | N/A | Point | - | - | - | - | S251120 | MISSION ST: LOWELL ST | - | F | F | - | F | 21502000 | 21502000 | - | - | NORTH WEST CORNER | - | - | - | - | LOWELL ST | LOWELL ST | 77131 | 77131 | 37.71143615 | -122.44638335 | MISSION ST \ LOWELL ST | MISSION ST \ LOWELL ST | 1724698055000 | middleware_editor | MISSION ST | LOWELL ST intersection | - | NWC 5600> EAST | - | - | - | - | - | 104248 | 1551364620000 | -122.44638335 | 37.71143615 | - | 1724250300000 | - | D11 | - | STREET NAME | GUIDE | D3-1.1207 | 36X08 | SUP2 | SIGNAL POLE | IS | 1548682920000 | MISSION ST | - | - | - | - | - | - |
| 87062 | N/A | Point | 1 | 1 | 1 - 99 | - | S113949 | 1-99 LOWELL ST | 1-99 LOWELL ST | F | F | - | F | 8503000 | 8503000 | - | - | NORTH SIDE | - | - | - | - | MISSION ST | MISSION ST | 12319 | 12319 | 37.71123772 | -122.44627574 | - | - | 1710539427000 | MTA | TANSAT | MISSION ST to MORSE ST (1 - 99) | - | IFO#1 | - | - | - | - | - | 104249 | 999129600000 | -122.44627574 | 37.71123772 | - | - | - | D11 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373571900000 | LOWELL ST | 1 - 99 LOWELL ST | 1 - 99 LOWELL ST | 1 LOWELL ST | - | MORSE ST | MORSE ST |
| 87063 | N/A | Point | - | - | - | - | S104362 | LONDON ST: RUSSIA AVE | - | F | F | - | F | 21739000 | 21739000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LONDON ST | LONDON ST | 1259 | 1259 | 37.7212094 | -122.43638454 | RUSSIA AVE \ LONDON ST | RUSSIA AVE \ LONDON ST | 1710539427000 | MTA | STOP | LONDON ST intersection | - | 0 / 0 | - | - | - | - | - | 104250 | -13996800000 | -122.43638454 | 37.7212094 | - | 1540944000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568900000 | RUSSIA AVE | - | - | - | - | - | - |
| 87064 | N/A | Point | - | - | - | - | S112873 | RUSSIA AVE: LONDON ST | - | F | F | - | F | 21739000 | 21739000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LONDON ST | LONDON ST | 8511 | 8511 | 37.7212094 | -122.43638454 | RUSSIA AVE \ LONDON ST | RUSSIA AVE \ LONDON ST | 1710539427000 | MTA | STOP | LONDON ST intersection | - | - | - | - | - | - | - | 104251 | 971827200000 | -122.43638454 | 37.7212094 | - | 1540944000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571540000 | RUSSIA AVE | - | - | - | - | - | - |
| 87065 | N/A | Point | 1 | 1 | 100 - 199 | - | S200364 | 100-199 RUSSIA AVE | 100-199 RUSSIA AVE | F | F | - | F | 11189000 | 11189000 | - | - | SOUTH SIDE | - | - | - | - | LONDON ST | LONDON ST | 46447 | 46447 | 37.72101828 | -122.43598463 | - | - | 1710539427000 | MTA | NPRK 5AM-7AM TUE STCL | LONDON ST to PARIS ST (100 - 199) | - | 10`EAST OF MISSION ST | - | - | - | - | - | 104252 | 1384855620000 | -122.43598463 | 37.72101828 | - | 1384819200000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0164 | 18X18 | SUP2 | LIGHT POLE | IS | 1384421940000 | RUSSIA AVE | 100 - 199 RUSSIA AVE | 100 - 199 RUSSIA AVE | 100 RUSSIA AVE | - | PARIS ST | PARIS ST |
| 87066 | N/A | Point | 1 | 1 | 100 - 199 | - | S215498 | 100-199 RUSSIA AVE | 100-199 RUSSIA AVE | F | F | - | F | 11189000 | 11189000 | - | - | NORTH SIDE | - | - | - | - | LONDON ST | LONDON ST | 56117 | 56117 | 37.72101828 | -122.43598463 | - | - | 1723610375000 | middleware_editor | NPRK 8AM-10AM MON STCL | LONDON ST to PARIS ST (100 - 199) | - | 75`EAST | - | - | - | - | - | 104253 | - | -122.43598463 | 37.72101828 | - | 1723455660000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0261 | 18X18 | SUP2 | 2IN IRON POST | IS | 1429626900000 | RUSSIA AVE | 100 - 199 RUSSIA AVE | 100 - 199 RUSSIA AVE | 100 RUSSIA AVE | - | PARIS ST | PARIS ST |
| 87067 | N/A | Point | - | - | - | - | S200705 | LONDON ST: RUSSIA AVE | - | F | F | - | F | 21739000 | 21739000 | - | - | SOUTH WEST CORNER | - | - | - | - | LONDON ST | LONDON ST | 49241 | 49241 | 37.7212094 | -122.43638454 | RUSSIA AVE \ LONDON ST | RUSSIA AVE \ LONDON ST | 1710539427000 | MTA | LONDON ST | LONDON ST intersection | - | - | - | - | - | - | - | 104254 | - | -122.43638454 | 37.7212094 | - | - | - | D11 | - | STREET NAME | GUIDE | D3-1.1060 | 36X08 | SUP2 | 3IN IRON POST | IS | 1386058920000 | RUSSIA AVE | - | - | - | - | - | - |
| 87068 | N/A | Point | - | - | - | - | S277940 | RUSSIA AVE: PARIS ST | - | F | F | - | F | 21738000 | 21738000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 107084 | 107084 | 37.72082715 | -122.43558471 | PARIS ST \ RUSSIA AVE | PARIS ST \ RUSSIA AVE | 1710539427000 | MTA | STOP | RUSSIA AVE intersection | - | - | - | - | - | - | - | 104255 | 971827200000 | -122.43558471 | 37.72082715 | - | 1540944000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1632820140000 | PARIS ST | - | - | - | - | - | - |
| 87069 | N/A | Point | - | - | - | - | S125577 | LONDON ST: RUSSIA AVE | - | F | F | - | F | 21739000 | 21739000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LONDON ST | LONDON ST | 23534 | 23534 | 37.7212094 | -122.43638454 | RUSSIA AVE \ LONDON ST | RUSSIA AVE \ LONDON ST | 1710539427000 | MTA | ALL WAY | LONDON ST intersection | - | - | - | - | - | - | - | 104256 | 1158105600000 | -122.43638454 | 37.7212094 | - | 1480982400000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575560000 | RUSSIA AVE | - | - | - | - | - | - |
| 87070 | N/A | Point | - | - | - | - | S106132 | LISBON ST: RUSSIA AVE | - | F | F | - | F | 21721000 | 21721000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LISBON ST | LISBON ST | 2201 | 2201 | 37.72044491 | -122.43478496 | RUSSIA AVE \ LISBON ST | RUSSIA AVE \ LISBON ST | 1710539427000 | MTA | STOP | LISBON ST intersection | - | 0 / 00 | - | - | - | - | - | 104257 | 124416000000 | -122.43478496 | 37.72044491 | - | 1439769600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569440000 | RUSSIA AVE | - | - | - | - | - | - |
| 87071 | N/A | Point | - | - | - | - | S125511 | LONDON ST: RUSSIA AVE | - | F | F | - | F | 21739000 | 21739000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LONDON ST | LONDON ST | 21828 | 21828 | 37.7212094 | -122.43638454 | RUSSIA AVE \ LONDON ST | RUSSIA AVE \ LONDON ST | 1710539427000 | MTA | ALL WAY | LONDON ST intersection | - | - | - | - | - | - | - | 104258 | 1157673600000 | -122.43638454 | 37.7212094 | - | 1540944000000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 3IN IRON POST | IS | 1373575500000 | RUSSIA AVE | - | - | - | - | - | - |
| 87072 | N/A | Point | - | - | - | - | S277943 | RUSSIA AVE: PARIS ST | - | F | F | - | F | 21738000 | 21738000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 107087 | 107087 | 37.72082715 | -122.43558471 | PARIS ST \ RUSSIA AVE | PARIS ST \ RUSSIA AVE | 1710539427000 | MTA | STOP | RUSSIA AVE intersection | - | - | - | - | - | - | - | 104259 | 1643760000000 | -122.43558471 | 37.72082715 | - | 1540944000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UTILITY POLE | IS | 1632820500000 | PARIS ST | - | - | - | - | - | - |
| 87073 | N/A | Point | - | - | - | - | S125385 | LISBON ST: RUSSIA AVE | - | F | F | - | F | 21721000 | 21721000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LISBON ST | LISBON ST | 19227 | 19227 | 37.72044491 | -122.43478496 | RUSSIA AVE \ LISBON ST | RUSSIA AVE \ LISBON ST | 1710539427000 | MTA | ALL WAY | LISBON ST intersection | - | - | - | - | - | - | - | 104260 | 1156982400000 | -122.43478496 | 37.72044491 | - | 1541030400000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575500000 | RUSSIA AVE | - | - | - | - | - | - |
| 87074 | N/A | Point | - | - | - | - | S106126 | RUSSIA AVE: LISBON ST | - | F | F | - | F | 21721000 | 21721000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LISBON ST | LISBON ST | 2197 | 2197 | 37.72044491 | -122.43478496 | RUSSIA AVE \ LISBON ST | RUSSIA AVE \ LISBON ST | 1710539427000 | MTA | STOP | LISBON ST intersection | - | 0 / 0 | - | - | - | - | - | 104261 | 124416000000 | -122.43478496 | 37.72044491 | - | 1541030400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569440000 | RUSSIA AVE | - | - | - | - | - | - |
| 87075 | N/A | Point | - | - | - | - | S119171 | MADRID ST: RUSSIA AVE | - | F | F | - | F | 21720000 | 21720000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 17187 | 17187 | 37.72006281 | -122.43398511 | MADRID ST \ RUSSIA AVE | MADRID ST \ RUSSIA AVE | 1710539427000 | MTA | ALL WAY | RUSSIA AVE intersection | - | - | - | - | - | - | - | 104262 | 1089417600000 | -122.43398511 | 37.72006281 | - | - | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 3IN IRON POST | IS | 1373573580000 | MADRID 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.