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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 87076 | N/A | Point | - | - | - | - | S253719 | RUSSIA AVE: EDINBURGH ST | - | F | F | - | F | 21712000 | 21712000 | - | - | SOUTH WEST CORNER | - | - | - | - | RUSSIA AVE | EDINBURGH ST | 79438 | 79438 | 37.71968064 | -122.43318514 | EDINBURGH ST \ RUSSIA AVE | RUSSIA AVE \ EDINBURGH ST | 1710539427000 | MTA | EDINBURGH ST | EDINBURGH ST intersection | - | - | - | - | - | - | - | 104263 | 1555939020000 | -122.43318514 | 37.71968064 | - | - | - | D11 | - | STREET NAME | GUIDE | D3-1.0580 | 36X08 | SUP2 | 3IN IRON POST | IS | 1556017620000 | RUSSIA AVE | - | - | - | - | - | - |
| 87077 | N/A | Point | - | - | - | - | S200839 | MADRID ST: RUSSIA AVE | - | F | F | - | F | 21720000 | 21720000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 109387 | 109387 | 37.72006281 | -122.43398511 | MADRID ST \ RUSSIA AVE | MADRID ST \ RUSSIA AVE | 1732726299000 | middleware_editor | STOP | RUSSIA AVE intersection | - | - | - | - | - | - | - | 104264 | - | -122.43398511 | 37.72006281 | - | 1089417600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1386575520000 | MADRID ST | - | - | - | - | - | - |
| 87078 | N/A | Point | - | - | - | - | S219100 | EDINBURGH ST: RUSSIA AVE | - | F | F | - | F | 21712000 | 21712000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | RUSSIA AVE | EDINBURGH ST | 56423 | 56423 | 37.71968064 | -122.43318514 | EDINBURGH ST \ RUSSIA AVE | RUSSIA AVE \ EDINBURGH ST | 1750285436000 | middleware_editor | STOP | EDINBURGH ST intersection | - | - | - | - | - | - | - | 104265 | - | -122.43318514 | 37.71968064 | - | - | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1441359120000 | RUSSIA AVE | - | - | - | - | - | - |
| 87079 | N/A | Point | - | - | - | - | S106123 | RUSSIA AVE: MADRID ST | - | F | F | - | F | 21720000 | 21720000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 90302 | 90302 | 37.72006281 | -122.43398511 | MADRID ST \ RUSSIA AVE | MADRID ST \ RUSSIA AVE | 1710539427000 | MTA | STOP | RUSSIA AVE intersection | - | 0 / 0 | - | - | - | - | - | 104266 | 124329600000 | -122.43398511 | 37.72006281 | - | 1089417600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569440000 | MADRID ST | - | - | - | - | - | - |
| 87080 | N/A | Point | 1 | 1 | 3600 - 3629 | - | S114870 | 3600-3635 23RD ST | 3600-3629 23RD ST | F | F | - | F | 1269000 | 1269000 | - | - | NORTH SIDE | - | - | - | - | GUERRERO ST | GUERRERO ST | 13808 | 13808 | 37.75355211 | -122.42331461 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "Z" PERMITS | GUERRERO ST to AMES ST (3600 - 3629) | - | 45' W OF GURRERO | - | - | - | - | - | 104267 | 1018396800000 | -122.42331461 | 37.75355211 | - | - | - | D8 | - | PARKING:RPP | REG | R32C(CA).0107 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373572200000 | 23RD ST | 3600 - 3629 23RD ST | 3600 - 3629 23RD ST | 3600 23RD ST | - | AMES ST | AMES ST |
| 87081 | N/A | Point | - | - | - | RIGHT ARROW | S282187 | MISSION ST: MARY ST | - | F | F | - | F | 9099000 | 24883000 | - | - | SOUTH SIDE | - | - | - | - | MARY ST | MISSION ST | 94193 | 94193 | 37.782034625 | -122.407244622 | - | MARY ST \ MISSION ST | 1710539427000 | MTA | TANS 7AM-10AM 3PM-7PM EVERYDAY/ PLO ALL OTHER TIMES | MISSION ST intersection | - | 10' WEST OF MARY ST | - | - | - | - | - | 104268 | 1653350400000 | -122.40725468 | 37.78211942 | - | 1684800000000 | - | D6 | - | OTHER REGULATORY | REG | R37(SF).0460 | 18X24 | SUP1 | 2IN IRON POST | IS | 1649839620000 | MARY ST | 935 - 999 MISSION ST | - | - | - | 06TH ST | - |
| 87082 | N/A | Point | - | - | - | - | S219641 | 23RD ST: CAPP ST | - | F | F | - | F | 1264000 | 24076000 | - | - | NORTH SIDE | - | - | - | - | CAPP ST | CAPP ST | 56670 | 56670 | 37.75390205 | -122.4175059 | - | 23RD ST \ CAPP ST | 1710539427000 | MTA | NPRK 6AM-8AM MON WED FRI STCL | CAPP ST intersection | - | IFO 3282 | - | - | - | - | - | 104269 | - | -122.4175059 | 37.75390205 | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0192 | 18X18 | SUP2 | 2IN IRON POST | IS | 1443617340000 | 23RD ST | 3250 - 3299 23RD ST | - | - | - | MISSION ST | - |
| 87083 | N/A | Point | 1 | 1 | 500 - 599 | - | S271991 | 500-599 LISBON ST | 500-599 LISBON ST | F | F | - | F | 8410000 | 8410000 | - | - | EAST SIDE | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 130031 | 130031 | 37.71966758 | -122.43537191 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM FRI STCL | RUSSIA AVE to FRANCE AVE (500 - 599) | - | 515 | - | - | - | - | - | 104270 | 1615542300000 | -122.43537191 | 37.71966758 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0298 | 18X18 | SUP2 | 2IN IRON POST | IS | 1611911940000 | LISBON ST | 500 - 599 LISBON ST | 500 - 599 LISBON ST | 500 LISBON ST | - | FRANCE AVE | FRANCE AVE |
| 87084 | N/A | Point | - | - | - | - | 22076 | - | - | F | F | - | F | 3300000 | - | - | - | NORTH SIDE | 1691619571000 | APADILLA | - | - | DORE ST | - | 145730 | 145730 | 37.770599804372 | -122.409589578216 | - | - | 1721266187000 | middleware_editor | NPRK 4AM-6AM MON WED FRI STCL | - | - | 55FT EAST OF 10TH ST | - | - | - | - | - | 104271 | - | - | - | - | - | - | 06 | - | STREET CLEANING | REG | R30B(CA).0144 | 18X18 | SUP1 | 2IN IRON POST | PI | - | BRYANT ST | 1150 - 1199 BRYANT ST | - | - | - | 10TH ST \ HWY 101 S ON RAMP | - |
| 87085 | N/A | Point | - | - | - | - | S109366 | HYDE ST: LOMBARD ST | - | F | F | - | F | 25565000 | 25565000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | HYDE ST | HYDE ST | 129685 | 129685 | 37.80199486 | -122.41961397 | LOMBARD ST \ HYDE ST | LOMBARD ST \ HYDE ST | 1710539427000 | MTA | STOP | HYDE ST intersection | - | 0 / 0 | - | - | - | - | - | 104272 | 466646400000 | -122.41961397 | 37.80199486 | - | 1087776000000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570460000 | LOMBARD ST | - | - | - | - | - | - |
| 87086 | N/A | Point | - | - | - | - | S246511 | HYDE ST: LOMBARD ST | - | F | F | - | F | 25565000 | 25565000 | - | - | NORTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HYDE ST | HYDE ST | 76268 | 76268 | 37.80199486 | -122.41961397 | LOMBARD ST \ HYDE ST | LOMBARD ST \ HYDE ST | 1711747832000 | middleware_editor | NO LEFT TURN (SYM) | HYDE ST intersection | - | - | - | - | - | - | - | 104273 | 209001600000 | -122.41961397 | 37.80199486 | - | 1709114400000 | - | D2 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | LIGHT POLE | IS | 1529667840000 | LOMBARD ST | - | - | - | - | - | - |
| 87087 | N/A | Point | - | - | - | - | S201845 | HYDE ST: LOMBARD ST | - | F | F | - | F | 25565000 | 25565000 | - | - | SOUTH EAST CORNER | - | - | - | - | HYDE ST | HYDE ST | 47703 | 47703 | 37.80199486 | -122.41961397 | LOMBARD ST \ HYDE ST | LOMBARD ST \ HYDE ST | 1710539427000 | MTA | CABLE CAR STOP | HYDE ST intersection | - | 10FT. SOUTH OF LOMBARD ST | - | - | - | - | - | 104274 | 1391438700000 | -122.41961397 | 37.80199486 | - | 1391385600000 | - | D2 | - | OTHER REGULATORY | REG | R(SF).0336 | 12X18 | SUP1 | 2IN IRON POST | IS | 1389167940000 | LOMBARD ST | - | - | - | - | - | - |
| 87088 | N/A | Point | - | - | - | - | S246512 | HYDE ST: LOMBARD ST | - | T | T | - | F | 25565000 | 25565000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | HYDE ST | HYDE ST | 76269 | 76269 | 37.80199486 | -122.41961397 | LOMBARD ST \ HYDE ST | LOMBARD ST \ HYDE ST | 1710539427000 | MTA | 11AM-8PM E/EXC RESIDENTS OF 1000 LOMBARD | HYDE ST intersection | - | BACK TO BACK W/ NO LEFT TURN | - | - | - | - | - | 104275 | 1530102780000 | -122.41961397 | 37.80199486 | - | - | - | D2 | - | OTHER REGULATORY | REG | R3-1(SF).0019 | 30X24 | SUP1 | LIGHT POLE | IS | 1529668380000 | LOMBARD ST | - | - | - | - | - | - |
| 87089 | N/A | Point | - | - | - | - | S222758 | LOMBARD ST: HYDE ST | - | F | F | - | F | 25565000 | 25565000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HYDE ST | HYDE ST | 60750 | 60750 | 37.80199486 | -122.41961397 | LOMBARD ST \ HYDE ST | LOMBARD ST \ HYDE ST | 1710539427000 | MTA | TRAFFIC FROM THE LEFT DOES NOT STOP | HYDE ST intersection | - | - | - | - | - | - | - | 104276 | 106531200000 | -122.41961397 | 37.80199486 | - | 1596585600000 | - | D2 | - | OTHER WARNING | WARNING | W4-4AP.0001 | 30X18 | SUP1 | 2IN IRON POST | IS | 1453892880000 | LOMBARD ST | - | - | - | - | - | - |
| 87090 | N/A | Point | - | - | - | - | S246513 | HYDE ST: LOMBARD ST | - | T | T | - | F | 25565000 | 25565000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | HYDE ST | HYDE ST | 76270 | 76270 | 37.80199486 | -122.41961397 | LOMBARD ST \ HYDE ST | LOMBARD ST \ HYDE ST | 1710539427000 | MTA | 11AM-8PM E/EXC RESIDENTS OF 1000 LOMBARD | HYDE ST intersection | - | ON TOP OF STOP SIGN | - | - | - | - | - | 104277 | 1530102840000 | -122.41961397 | 37.80199486 | - | - | - | D2 | - | OTHER REGULATORY | REG | R3-1(SF).0019 | 30X24 | SUP1 | LIGHT POLE | IS | 1529668500000 | LOMBARD ST | - | - | - | - | - | - |
| 87091 | N/A | Point | - | - | - | - | S214878 | LOMBARD ST: HYDE ST | - | T | T | - | F | 25565000 | 25565000 | - | - | NORTH WEST CORNER | - | - | - | - | HYDE ST | HYDE ST | 56342 | 56342 | 37.80199486 | -122.41961397 | LOMBARD ST \ HYDE ST | LOMBARD ST \ HYDE ST | 1710539427000 | MTA | LOMBARD ST | HYDE ST intersection | - | - | - | - | - | - | - | 104278 | 1430920980000 | -122.41961397 | 37.80199486 | - | 1430870400000 | - | D2 | - | STREET NAME | GUIDE | D3-1.1058 | 36X08 | SUP1 | LIGHT POLE | IS | 1427897520000 | LOMBARD ST | - | - | - | - | - | - |
| 87092 | N/A | Point | - | - | - | - | S246604 | HYDE ST: LOMBARD ST | - | T | T | - | F | 25565000 | 25565000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | HYDE ST | HYDE ST | 82933 | 82933 | 37.80199486 | -122.41961397 | LOMBARD ST \ HYDE ST | LOMBARD ST \ HYDE ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) | HYDE ST intersection | - | BACK TO BACK W/ NO LEFT TURN | - | - | - | - | - | 104279 | 1530057600000 | -122.41961397 | 37.80199486 | - | - | - | D2 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1530095940000 | LOMBARD ST | - | - | - | - | - | - |
| 87093 | N/A | Point | - | - | - | - | S109343 | HYDE ST: LOMBARD ST | - | F | F | - | F | 25565000 | 25565000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HYDE ST | HYDE ST | 76919 | 76919 | 37.80199486 | -122.41961397 | LOMBARD ST \ HYDE ST | LOMBARD ST \ HYDE ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | HYDE ST intersection | - | 0 / CONSTRUCTION COMPLETED | - | - | - | - | - | 104280 | 459043200000 | -122.41961397 | 37.80199486 | - | - | - | D2 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | 2IN IRON POST | IS | 1373570460000 | LOMBARD ST | - | - | - | - | - | - |
| 87094 | N/A | Point | - | - | - | - | S201844 | HYDE ST: LOMBARD ST | - | F | F | - | F | 25565000 | 25565000 | - | - | NORTH EAST CORNER | - | - | - | - | HYDE ST | HYDE ST | 113715 | 113715 | 37.80199486 | -122.41961397 | LOMBARD ST \ HYDE ST | LOMBARD ST \ HYDE ST | 1710539427000 | MTA | CABLE CAR STOP | HYDE ST intersection | - | 0/0 | - | - | - | - | - | 104281 | - | -122.41961397 | 37.80199486 | - | - | - | D2 | - | OTHER REGULATORY | REG | R(SF).0336 | 12X18 | SUP1 | 2IN IRON POST | IS | 1389167460000 | LOMBARD ST | - | - | - | - | - | - |
| 87095 | N/A | Point | - | - | - | - | S281221 | VAN NESS AVE: VALLEJO ST | - | F | F | - | F | 26552000 | 26552000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | VALLEJO ST | VALLEJO ST | 94351 | 94351 | 37.79669106 | -122.4236013 | VAN NESS AVE \ VALLEJO ST | VAN NESS AVE \ VALLEJO ST | 1710539427000 | MTA | SOLAR LANTERN WHITE (V5) | VALLEJO ST intersection | 18095 | 129 FT NORTH ON VALLEJO / EAST SIDE | - | - | - | - | - | 104282 | 1646265600000 | -122.4236013 | 37.79669106 | - | - | - | D2 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | UNISTRUT | IS | 1646302860000 | VAN NESS AVE | - | - | - | - | - | - |
| 87096 | N/A | Point | 1 | 1 | 500 - 598 | - | S226268 | 500-598 BROTHERHOOD WAY | 500-598 BROTHERHOOD WAY | F | F | - | F | 3240201 | 3240201 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | ARCH ST | ARCH ST | 61133 | 61133 | 37.71255557 | -122.46853402 | - | - | 1710539427000 | MTA | PEDESTRIAN (SYM) | ARCH ST to JUNIPERO SERRA BLVD ON RAMP (500 - 598) -- NORTH -- | - | AT CROSS WALK NB ON RAMP | - | - | - | - | - | 104283 | 1469536980000 | -122.46853402 | 37.71255557 | - | 1469491200000 | - | D11 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | 2IN IRON POST | IS | 1465216920000 | BROTHERHOOD WAY | 500 - 598 BROTHERHOOD WAY | 500 - 598 BROTHERHOOD WAY | 500 BROTHERHOOD WAY | - | JUNIPERO SERRA BLVD ON RAMP | JUNIPERO SERRA BLVD ON RAMP |
| 87097 | N/A | Point | - | - | - | - | S230269 | THE EMBARCADERO: GREEN ST | - | F | F | - | F | 34014000 | 34014000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | GREEN ST | GREEN ST | 64322 | 64322 | 37.80089648 | -122.39913024 | THE EMBARCADERO \ GREEN ST | THE EMBARCADERO \ GREEN ST | 1724420863000 | middleware_editor | SOLAR LANTERN WHITE (V5) | GREEN ST intersection | 14529 | 80' SOUTH OF X WALK | - | - | - | - | - | 104284 | - | -122.39913024 | 37.80089648 | - | - | - | D3 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | 2IN FLANGE POST | IS | 1477564860000 | THE EMBARCADERO | - | - | - | - | - | - |
| 87098 | N/A | Point | 1 | 1 | 1 - 99 | - | S289799 | 1-99 SPEAR ST | 1-99 SPEAR ST | F | F | - | F | 12044000 | 12044000 | - | - | WEST SIDE | - | - | - | - | MARKET ST | MARKET ST | 103342 | 103342 | 37.79314589 | -122.39482159 | - | - | 1710539427000 | MTA | SOLAR LANTERN WHITE (V5) | MARKET ST to MISSION ST (1 - 99) | 16475 | 117' SOUTH OF MARKET/ BUS STOP | - | - | - | - | - | 104285 | 1704277560000 | -122.39482159 | 37.79314589 | - | - | - | D6 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | UNISTRUT | IS | 1684922280000 | SPEAR ST | 1 - 99 SPEAR ST | 1 - 99 SPEAR ST | 1 SPEAR ST | - | MISSION ST | MISSION ST |
| 87099 | N/A | Point | 1 | 1 | 100 - 119 | - | S115127 | 100-119 SAN JOSE AVE | 100-119 SAN JOSE AVE | F | F | - | F | 11428000 | 11428000 | - | - | EAST SIDE | - | - | - | - | 23RD ST | 23RD ST | 115597 | 115597 | 37.75325922 | -122.42151803 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "Z" PERMITS | 23RD ST to ELIZABETH ST (100 - 119) | - | IFO#123 | - | - | - | - | - | 104286 | 1022112000000 | -122.42151803 | 37.75325922 | - | - | - | D8 | - | PARKING:RPP | REG | R32C(CA).0107 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373572260000 | SAN JOSE AVE | 100 - 119 SAN JOSE AVE | 100 - 119 SAN JOSE AVE | 100 SAN JOSE AVE | - | ELIZABETH ST | ELIZABETH ST |
| 87100 | N/A | Point | - | - | - | - | S230000 | THE EMBARCADERO: BROADWAY | - | F | F | - | F | 24570000 | 24570000 | - | - | CENTER ISLAND, W LINE, WESTBOUND | - | - | - | - | BROADWAY | BROADWAY | 65754 | 65754 | 37.79923448 | -122.39766995 | THE EMBARCADERO \ BROADWAY | THE EMBARCADERO \ BROADWAY | 1724167385000 | middleware_editor | SOLAR LANTERN WHITE (V5) | BROADWAY intersection | 14504 | 80' SOUTH OF X WALK | - | - | - | - | - | 104287 | - | -122.39766995 | 37.79923448 | - | - | - | D3 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | 2IN FLANGE POST | IS | 1476958020000 | THE EMBARCADERO | - | - | - | - | - | - |
| 87101 | N/A | Point | - | - | - | - | S230035 | THE EMBARCADERO: GREEN ST | - | F | F | - | F | 12556202 | 34014000 | - | - | CENTER ISLAND, E LINE, NORTHBOUND | - | - | - | - | GREEN ST | GREEN ST | 66457 | 66457 | 37.80089648 | -122.39913024 | - | THE EMBARCADERO \ GREEN ST | 1724699356000 | middleware_editor | SOLAR LANTERN WHITE (V5) | GREEN ST intersection | 14517 | 80' NORTH OF X WALK | - | - | - | - | - | 104288 | - | -122.39913024 | 37.80089648 | - | - | 1724674080000 | D3 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | 2IN FLANGE POST | RETD | 1476974820000 | THE EMBARCADERO | 600 - 1098 THE EMBARCADERO | - | - | - | BATTERY ST \ LOMBARD ST | - |
| 87102 | N/A | Point | - | - | - | - | S255166 | 6150-6198 MISSION ST | - | F | F | - | F | 51142000 | 51142000 | - | - | CENTER ISLAND | - | - | - | - | COUNTY LINE | COUNTY LINE | 86099 | 86099 | 37.70736274 | -122.45999474 | - | FLOURNOY ST \ COUNTY LINE | 1710539427000 | MTA | SOLAR LANTERN WHITE (V5) | COUNTY LINE intersection | - | OPP 6229 70 FT SOUTH OF FLOURNOY | - | - | - | - | - | 104289 | 1298937600000 | -122.45999474 | 37.70736274 | - | - | - | - | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | - | MUNI LANDOR POLE 3" X135" | IS | 1560175560000 | FLOURNOY ST | 6150-6198 MISSION ST | - | - | - | - | - |
| 87103 | N/A | Point | - | - | - | - | S229162 | 24TH ST: BARTLETT ST | - | T | T | - | F | 24092000 | 24092000 | - | - | SOUTH WEST CORNER | - | - | - | - | 24TH ST | BARTLETT ST | 56810 | 56810 | 37.75217141 | -122.41955737 | BARTLETT ST \ 24TH ST | 24TH ST \ BARTLETT ST | 1710539427000 | MTA | 24TH ST/CALLE 24 LATINO CULTURAL DISTRICT | BARTLETT ST intersection | - | 3350 | - | - | - | - | - | 104290 | 1477296660000 | -122.41955737 | 37.75217141 | - | 1477267200000 | - | D9 | - | STREET NAME | GUIDE | D3-1.1920 | 36X18 | SUP2 | LIGHT POLE | IS | 1474617840000 | 24TH ST | - | - | - | - | - | - |
| 87104 | N/A | Point | 1 | 1 | 3323 - 3361 | - | S288592 | 3323-3361 24TH ST | 3323-3361 24TH ST | F | F | - | F | 1347000 | 1347000 | - | - | SOUTH SIDE | - | - | - | - | OSAGE ALY | OSAGE ALY | 109251 | 109251 | 37.75218793 | -122.41928745 | - | - | 1710539427000 | MTA | BIKE RACK | OSAGE ALY to BARTLETT ST (3323 - 3361) | - | 4.5' W OF EPL 3327/3.5' IN FROM CURB | - | - | - | - | - | 104291 | - | -122.41928745 | 37.75218793 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1681826040000 | 24TH ST | 3323 - 3361 24TH ST | 3323 - 3361 24TH ST | 3323 24TH ST | - | BARTLETT ST | BARTLETT ST |
| 87105 | N/A | Point | - | - | - | - | S261986 | BARTLETT ST: 24TH ST | - | T | T | - | F | 24092000 | 24092000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | BARTLETT ST | 112474 | 112474 | 37.75217141 | -122.41955737 | BARTLETT ST \ 24TH ST | 24TH ST \ BARTLETT ST | 1710539427000 | MTA | SPEED HUMPS | BARTLETT ST intersection | - | ABOVE SCHOOL SPEED LIMIT | - | - | - | - | - | 104292 | -392601600000 | -122.41955737 | 37.75217141 | - | 1583366400000 | - | D9 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1582807860000 | 24TH ST | - | - | - | - | - | - |
| 87106 | N/A | Point | 1 | 1 | 3323 - 3361 | - | S278280 | 3323-3361 24TH ST | 3323-3361 24TH ST | T | T | - | F | 1347000 | 1347000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | OSAGE ALY | OSAGE ALY | 105167 | 105167 | 37.75218793 | -122.41928745 | - | - | 1710539427000 | MTA | MISSION ST | OSAGE ALY to BARTLETT ST (3323 - 3361) | - | IFO 3327 | - | - | - | - | - | 104293 | 1522195200000 | -122.41928745 | 37.75218793 | - | 1523059200000 | - | D9 | - | STREET NAME | GUIDE | D3-2.0247 | 72X18 | SUP2 | LIGHT POLE | IS | 1634548980000 | 24TH ST | 3323 - 3361 24TH ST | 3323 - 3361 24TH ST | 3323 24TH ST | - | BARTLETT ST | BARTLETT ST |
| 87107 | N/A | Point | 1 | 1 | 3323 - 3361 | - | S118461 | 3323-3361 24TH ST | 3323-3361 24TH ST | F | F | - | F | 1347000 | 1347000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | OSAGE ALY | OSAGE ALY | 15212 | 15212 | 37.75218793 | -122.41928745 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | OSAGE ALY to BARTLETT ST (3323 - 3361) | - | INFO #3328 | - | - | - | - | - | 104294 | 1078358400000 | -122.41928745 | 37.75218793 | - | 1592352000000 | - | D9 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373573340000 | 24TH ST | 3323 - 3361 24TH ST | 3323 - 3361 24TH ST | 3323 24TH ST | - | BARTLETT ST | BARTLETT ST |
| 87108 | N/A | Point | - | - | - | - | S261987 | BARTLETT ST: 24TH ST | - | T | T | - | F | 24092000 | 24092000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | BARTLETT ST | 112475 | 112475 | 37.75217141 | -122.41955737 | BARTLETT ST \ 24TH ST | 24TH ST \ BARTLETT ST | 1710539427000 | MTA | AHEAD | BARTLETT ST intersection | - | ABOVE SCHOOL SPEED LIMIT | - | - | - | - | - | 104295 | -392601600000 | -122.41955737 | 37.75217141 | - | 1583366400000 | - | D9 | - | OTHER WARNING | WARNING | W(SF).0106 | 18X06 | SUP2 | LIGHT POLE | IS | 1582807980000 | 24TH ST | - | - | - | - | - | - |
| 87109 | N/A | Point | - | - | - | - | S238119 | OSAGE ALY: 24TH ST | - | F | F | - | F | 24089000 | 24089000 | - | - | NORTH WEST CORNER | - | - | - | - | OSAGE ALY | 24TH ST | 74435 | 74435 | 37.75220444 | -122.41901754 | 24TH ST \ OSAGE ALY | OSAGE ALY \ 24TH ST | 1710539427000 | MTA | OSAGE ALY | 24TH ST intersection | - | - | - | - | - | - | - | 104296 | 1477267200000 | -122.41901754 | 37.75220444 | - | 1477267200000 | - | D9 | - | STREET NAME | GUIDE | D3-1.1323 | 36X08 | SUP2 | 3IN IRON POST | IS | 1502121840000 | OSAGE ALY | - | - | - | - | - | - |
| 87110 | N/A | Point | 1 | 1 | 3323 - 3361 | - | S243437 | 3323-3361 24TH ST | 3323-3361 24TH ST | F | F | - | F | 1347000 | 1347000 | - | - | SOUTH SIDE | - | - | - | - | OSAGE ALY | OSAGE ALY | 118028 | 118028 | 37.75218793 | -122.41928745 | - | - | 1710539427000 | MTA | BIKE RACK | OSAGE ALY to BARTLETT ST (3323 - 3361) | 06792 | 14' WEST OF OSAGE/ 3.5' IN FROM CURB | - | - | - | - | - | 104297 | 1522226400000 | -122.41928745 | 37.75218793 | - | 1523059200000 | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1519988520000 | 24TH ST | 3323 - 3361 24TH ST | 3323 - 3361 24TH ST | 3323 24TH ST | - | BARTLETT ST | BARTLETT ST |
| 87111 | N/A | Point | 1 | 1 | 3323 - 3361 | - | S280271 | 3323-3361 24TH ST | 3323-3361 24TH ST | F | F | - | F | 1347000 | 1347000 | - | - | NORTH SIDE | - | - | - | - | OSAGE ALY | OSAGE ALY | 124192 | 124192 | 37.75218793 | -122.41928745 | - | - | 1710539427000 | MTA | NPRK 6AM-8AM TUE THUR STCL | OSAGE ALY to BARTLETT ST (3323 - 3361) | - | EPL 3340 | - | - | - | - | - | 104298 | - | -122.41928745 | 37.75218793 | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0195 | 18X18 | SUP2 | 2IN IRON POST | IS | 1641551220000 | 24TH ST | 3323 - 3361 24TH ST | 3323 - 3361 24TH ST | 3323 24TH ST | - | BARTLETT ST | BARTLETT ST |
| 87112 | N/A | Point | - | - | - | - | S229216 | SHOTWELL ST: 24TH ST | - | F | F | - | F | 24064000 | 24064000 | - | - | SOUTH WEST CORNER | - | - | - | - | 24TH ST | 24TH ST | 80585 | 80585 | 37.75243965 | -122.41517229 | SHOTWELL ST \ 24TH ST | SHOTWELL ST \ 24TH ST | 1710539427000 | MTA | SHOTWELL ST | 24TH ST intersection | - | 1000 | - | - | - | - | - | 104299 | 1478691000000 | -122.41517229 | 37.75243965 | - | 1643932800000 | - | D9 | - | STREET NAME | GUIDE | D3-1.1629 | 36X08 | SUP2 | 3IN IRON POST | IS | 1474882620000 | SHOTWELL ST | - | - | - | - | - | - |
| 87113 | N/A | Point | - | - | - | - | S221261 | 24TH ST: SHOTWELL ST | - | F | F | - | F | 24064000 | 24064000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 57886 | 57886 | 37.75243965 | -122.41517229 | SHOTWELL ST \ 24TH ST | SHOTWELL ST \ 24TH ST | 1710539427000 | MTA | STOP | 24TH ST intersection | - | - | - | - | - | - | - | 104300 | 1222300800000 | -122.41517229 | 37.75243965 | - | 1633996800000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1449743640000 | SHOTWELL ST | - | - | - | - | - | - |
| 87114 | N/A | Point | - | - | - | - | S102003 | SHOTWELL ST: 24TH ST | - | F | F | - | F | 24064000 | 24064000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 7174 | 7174 | 37.75243965 | -122.41517229 | SHOTWELL ST \ 24TH ST | SHOTWELL ST \ 24TH ST | 1710539427000 | MTA | STOP | 24TH ST intersection | - | - | - | - | - | - | - | 104301 | -394416000000 | -122.41517229 | 37.75243965 | - | 1633996800000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568180000 | SHOTWELL ST | - | - | - | - | - | - |
| 87115 | N/A | Point | - | - | - | - | S229176 | 24TH ST: SOUTH VAN NESS AVE | - | T | T | - | F | 24063000 | 24063000 | - | - | NORTH EAST CORNER | - | - | - | - | 24TH ST | 24TH ST | 65559 | 65559 | 37.75237279 | -122.41626551 | SOUTH VAN NESS AVE \ 24TH ST | SOUTH VAN NESS AVE \ 24TH ST | 1710539427000 | MTA | 24TH ST/CALLE 24 LATINO CULTURAL DISTRICT | 24TH ST intersection | - | 3200 | - | - | - | - | - | 104302 | 1476979860000 | -122.41626551 | 37.75237279 | - | 1674604800000 | - | D9 | - | STREET NAME | GUIDE | D3-1.1920 | 36X18 | SUP2 | MUNI POLE | IS | 1474625040000 | SOUTH VAN NESS AVE | - | - | - | - | - | - |
| 87116 | N/A | Point | - | - | - | - | S221265 | 24TH ST: SHOTWELL ST | - | F | F | - | F | 24064000 | 24064000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 24TH ST | 24TH ST | 57889 | 57889 | 37.75243965 | -122.41517229 | SHOTWELL ST \ 24TH ST | SHOTWELL ST \ 24TH ST | 1710539427000 | MTA | ALL WAY | 24TH ST intersection | - | - | - | - | - | - | - | 104303 | 1222300800000 | -122.41517229 | 37.75243965 | - | 1597363200000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1449744060000 | SHOTWELL ST | - | - | - | - | - | - |
| 87117 | N/A | Point | 1 | 1 | 3150 - 3199 | - | S288593 | 3150-3199 24TH ST | 3150-3199 24TH ST | F | F | - | F | 1341000 | 1341000 | - | - | NORTH SIDE | - | - | - | - | SHOTWELL ST | SHOTWELL ST | 119103 | 119103 | 37.75240622 | -122.4157189 | - | - | 1710539427000 | MTA | BIKE RACK | SHOTWELL ST to SOUTH VAN NESS AVE (3150 - 3199) | - | 8' E OF WPL 3166/3.5' IN FROM CURB | - | - | - | - | - | 104304 | - | -122.4157189 | 37.75240622 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1681826220000 | 24TH ST | 3150 - 3199 24TH ST | 3150 - 3199 24TH ST | 3150 24TH ST | - | SOUTH VAN NESS AVE | SOUTH VAN NESS AVE |
| 87118 | N/A | Point | 1 | 1 | 3150 - 3199 | - | S279049 | 3150-3199 24TH ST | 3150-3199 24TH ST | F | F | - | F | 1341000 | 1341000 | - | - | NORTH SIDE | - | - | - | - | SHOTWELL ST | SHOTWELL ST | 119785 | 119785 | 37.75240622 | -122.4157189 | - | - | 1710539427000 | MTA | BIKE RACK | SHOTWELL ST to SOUTH VAN NESS AVE (3150 - 3199) | 429194 | 10' E OF WPL 3198/3.5' IN FROM CURB | - | - | - | - | - | 104305 | 1638403200000 | -122.4157189 | 37.75240622 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1637573760000 | 24TH ST | 3150 - 3199 24TH ST | 3150 - 3199 24TH ST | 3150 24TH ST | - | SOUTH VAN NESS AVE | SOUTH VAN NESS AVE |
| 87119 | N/A | Point | 1 | 1 | 400 - 550 | - | S147372 | 400-499 CASTENADA AVE | 400-550 CASTENADA AVE | F | F | - | F | 3777000 | 3777000 | - | - | NORTH SIDE | - | - | - | - | MONTALVO AVE | MONTALVO AVE | 117632 | 117632 | 37.74566673 | -122.46682398 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM 1ST & 3RD TUE OF MONTH STCL | MONTALVO AVE to END: BLOCK (400 - 550) | - | 414 CASTENADA | - | - | - | - | - | 104306 | 1224547200000 | -122.46682398 | 37.74566673 | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0288 | 18X18 | SUP2 | 2 POST ALUMINUM | IS | 1375728420000 | CASTENADA AVE | 400 - 550 CASTENADA AVE | 400 - 550 CASTENADA AVE | 400 CASTENADA AVE | - | END: BLOCK | END: BLOCK |
| 87120 | N/A | Point | 1 | 1 | 900 - 999 | - | S214671 | 900-999 QUINTARA ST | 900-999 QUINTARA ST | F | F | - | F | 10854000 | 10854000 | - | - | NORTH SIDE | - | - | - | - | 18TH AVE | 18TH AVE | 51892 | 51892 | 37.7486699 | -122.47552502 | - | - | 1710539427000 | MTA | SOLAR LANTERN BLUE (V5) | 18TH AVE to 19TH AVE (900 - 999) | 16140 | 10' EAST OF 19TH AVE/SOLAR-SOUTHWEST | - | - | - | - | - | 104307 | 1429628940000 | -122.47552502 | 37.7486699 | - | 1429574400000 | - | D7 | - | OTHER MISC | MISC | SOLAR-BLUE.0001 | 14X11 | SUP2 | UNISTRUT | IS | 1427456880000 | QUINTARA ST | 900 - 999 QUINTARA ST | 900 - 999 QUINTARA ST | 900 QUINTARA ST | - | 19TH AVE | 19TH AVE |
| 87121 | N/A | Point | - | - | - | - | S101014 | RUSSIA AVE: NAPLES ST | - | F | F | - | F | 21711000 | 21711000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | NAPLES ST | RUSSIA AVE | 120363 | 120363 | 37.71929846 | -122.43238519 | RUSSIA AVE \ NAPLES ST | NAPLES ST \ RUSSIA AVE | 1710539427000 | MTA | STOP | RUSSIA AVE intersection | - | 0 / 00 | - | - | - | - | - | 104308 | -401241600000 | -122.43238519 | 37.71929846 | - | 1089417600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373566620000 | NAPLES ST | - | - | - | - | - | - |
| 87122 | N/A | Point | - | - | - | - | S277945 | PARIS ST: RUSSIA AVE | - | F | F | - | F | 21738000 | 21738000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 123813 | 123813 | 37.72082715 | -122.43558471 | PARIS ST \ RUSSIA AVE | PARIS ST \ RUSSIA AVE | 1710539427000 | MTA | ALL WAY | RUSSIA AVE intersection | - | 0 / 0 | - | - | - | - | - | 104309 | 119750400000 | -122.43558471 | 37.72082715 | - | 1576022400000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1632820980000 | PARIS ST | - | - | - | - | - | - |
| 87123 | N/A | Point | - | - | - | - | S230785 | RUSSIA AVE: NAPLES ST | - | F | F | - | F | 21711000 | 21711000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | NAPLES ST | RUSSIA AVE | 68216 | 68216 | 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 | - | - | - | - | - | - | - | 104310 | 1479306000000 | -122.43238519 | 37.71929846 | - | 1479254400000 | - | D11 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP2 | 2IN IRON POST | IS | 1478687160000 | NAPLES ST | - | - | - | - | - | - |
| 87124 | N/A | Point | - | - | - | - | S230735 | NAPLES ST: RUSSIA AVE | - | F | F | - | F | 21711000 | 21711000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | NAPLES ST | RUSSIA AVE | 68567 | 68567 | 37.71929846 | -122.43238519 | RUSSIA AVE \ NAPLES ST | NAPLES ST \ RUSSIA AVE | 1710539427000 | MTA | ROUNDABOUT ARROWS | RUSSIA AVE intersection | - | N-LINE | - | - | - | - | - | 104311 | 1479389580000 | -122.43238519 | 37.71929846 | - | 1479340800000 | - | D11 | - | OTHER REGULATORY | REG | R7(SF).0001 | 18X24 | SUP2 | 2IN IRON POST | IS | 1478615220000 | NAPLES ST | - | - | - | - | - | - |
| 87125 | N/A | Point | - | - | - | - | S116385 | VIENNA ST: RUSSIA AVE | - | F | F | - | F | 21710000 | 21710000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VIENNA ST | VIENNA ST | 16412 | 16412 | 37.7189161 | -122.43158486 | RUSSIA AVE \ VIENNA ST | RUSSIA AVE \ VIENNA ST | 1710539427000 | MTA | ALL WAY | VIENNA ST intersection | - | - | - | - | - | - | - | 104312 | 1049068800000 | -122.43158486 | 37.7189161 | - | - | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572680000 | RUSSIA AVE | - | - | - | - | - | - |
| 87126 | N/A | Point | - | - | - | - | S101013 | RUSSIA AVE: NAPLES ST | - | F | F | - | F | 21711000 | 21711000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | NAPLES ST | RUSSIA AVE | 594 | 594 | 37.71929846 | -122.43238519 | RUSSIA AVE \ NAPLES ST | NAPLES ST \ RUSSIA AVE | 1710539427000 | MTA | STOP | RUSSIA AVE intersection | - | 0 / 00 | - | - | - | - | - | 104313 | -401241600000 | -122.43238519 | 37.71929846 | - | 1026950400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373566620000 | NAPLES ST | - | - | - | - | - | - |
| 87127 | N/A | Point | - | - | - | - | S106268 | ATHENS ST: RUSSIA AVE | - | F | F | - | F | 21634000 | 21634000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ATHENS ST | ATHENS ST | 1430 | 1430 | 37.7185302 | -122.43077802 | RUSSIA AVE \ ATHENS ST | RUSSIA AVE \ ATHENS ST | 1710539427000 | MTA | STOP | ATHENS ST intersection | - | 0 / 0 | - | - | - | - | - | 104314 | 132364800000 | -122.43077802 | 37.7185302 | - | 1194393600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569500000 | RUSSIA AVE | - | - | - | - | - | - |
| 87128 | N/A | Point | 1 | 1 | 400 - 499 | - | S211522 | 400-499 RUSSIA AVE | 400-499 RUSSIA AVE | F | F | - | F | 11192000 | 11192000 | - | - | SOUTH SIDE | - | - | - | - | MADRID ST | MADRID ST | 52552 | 52552 | 37.71987172 | -122.43358513 | - | - | 1727987241000 | middleware_editor | NPRK 11AM-1PM MON STCL | MADRID ST to EDINBURGH ST (400 - 499) | - | IFO#422 | - | - | - | - | - | 104315 | 124329600000 | -122.43358513 | 37.71987172 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0027 | 18X18 | SUP2 | 2IN IRON POST | IS | 1418047740000 | RUSSIA AVE | 400 - 499 RUSSIA AVE | 400 - 499 RUSSIA AVE | 400 RUSSIA AVE | - | EDINBURGH ST | EDINBURGH ST |
| 87129 | N/A | Point | - | - | - | - | S230738 | RUSSIA AVE: NAPLES ST | - | F | F | - | F | 21711000 | 21711000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | NAPLES ST | RUSSIA AVE | 68625 | 68625 | 37.71929846 | -122.43238519 | RUSSIA AVE \ NAPLES ST | NAPLES ST \ RUSSIA AVE | 1710539427000 | MTA | ROUNDABOUT ARROWS | RUSSIA AVE intersection | - | W-LINE | - | - | - | - | - | 104316 | 1479389100000 | -122.43238519 | 37.71929846 | - | 1479340800000 | - | D11 | - | OTHER REGULATORY | REG | R7(SF).0001 | 18X24 | SUP2 | 2IN IRON POST | IS | 1478615640000 | NAPLES ST | - | - | - | - | - | - |
| 87130 | N/A | Point | - | - | - | - | S231891 | RUSSIA AVE: MOSCOW ST | - | F | F | - | F | 21631000 | 21631000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MOSCOW ST | RUSSIA AVE | 66920 | 66920 | 37.71814756 | -122.42997803 | RUSSIA AVE \ MOSCOW ST | MOSCOW ST \ RUSSIA AVE | 1710539427000 | MTA | ALL WAY | RUSSIA AVE intersection | - | 0 / 0 | - | - | - | - | - | 104317 | 2160000000 | -122.42997803 | 37.71814756 | - | 1488326400000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1482157320000 | MOSCOW ST | - | - | - | - | - | - |
| 87131 | N/A | Point | 1 | 1 | 900 - 999 | - | S281255 | 900-999 RUSSIA AVE | 900-999 RUSSIA AVE | F | F | - | F | 11196000 | 11197000 | - | - | SOUTH SIDE | - | - | - | - | ATHENS ST | MOSCOW ST | 94301 | 94301 | 37.71795464 | -122.42957469 | - | - | 1718042775000 | middleware_editor | NPRK 11AM-1PM MON STCL | MOSCOW ST to MUNICH ST (900 - 999) | - | EPL 824 | - | - | - | - | - | 104318 | - | -122.42957469 | 37.71795464 | - | 1717761000000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0027 | 18X18 | SUP2 | LIGHT POLE | IS | 1646315340000 | RUSSIA AVE | 800 - 899 RUSSIA AVE | 900 - 999 RUSSIA AVE | 900 RUSSIA AVE | - | MOSCOW ST | MUNICH ST |
| 87132 | N/A | Point | - | - | - | - | S267088 | RUSSIA AVE: MOSCOW ST | - | F | F | - | F | 21631000 | 21631000 | - | - | SOUTH SIDE | - | - | - | - | MOSCOW ST | RUSSIA AVE | 92782 | 92782 | 37.71814756 | -122.42997803 | RUSSIA AVE \ MOSCOW ST | MOSCOW ST \ RUSSIA AVE | 1710539427000 | MTA | NPRK 11AM-1PM MON STCL | RUSSIA AVE intersection | - | WPL 632 | - | - | - | - | - | 104319 | 2160000000 | -122.42997803 | 37.71814756 | - | 1599091200000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0027 | 18X18 | SUP2 | LIGHT POLE | IS | 1597392960000 | MOSCOW ST | - | - | - | - | - | - |
| 87133 | N/A | Point | - | - | - | - | S127689 | MOSCOW ST: RUSSIA AVE | - | F | F | - | F | 21631000 | 21631000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MOSCOW ST | RUSSIA AVE | 21316 | 21316 | 37.71814756 | -122.42997803 | RUSSIA AVE \ MOSCOW ST | MOSCOW ST \ RUSSIA AVE | 1710539427000 | MTA | SPEED HUMP | RUSSIA AVE intersection | - | - | - | - | - | - | - | 104320 | 1182384000000 | -122.42997803 | 37.71814756 | - | 1494806400000 | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373576220000 | MOSCOW ST | - | - | - | - | - | - |
| 87134 | N/A | Point | - | - | - | - | S116381 | RUSSIA AVE: VIENNA ST | - | F | F | - | F | 21710000 | 21710000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | VIENNA ST | VIENNA ST | 16408 | 16408 | 37.7189161 | -122.43158486 | RUSSIA AVE \ VIENNA ST | RUSSIA AVE \ VIENNA ST | 1710539427000 | MTA | STOP | VIENNA ST intersection | - | - | - | - | - | - | - | 104321 | 1049068800000 | -122.43158486 | 37.7189161 | - | - | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373572680000 | RUSSIA AVE | - | - | - | - | - | - |
| 87135 | N/A | Point | - | - | - | - | S119185 | PRAGUE ST: RUSSIA AVE | - | F | F | - | F | 21624000 | 21624000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | RUSSIA AVE | RUSSIA AVE | 15874 | 15874 | 37.71737953 | -122.42837146 | PRAGUE ST \ RUSSIA AVE | PRAGUE ST \ RUSSIA AVE | 1720791604000 | middleware_editor | ALL WAY | RUSSIA AVE intersection | - | - | - | - | - | - | - | 104322 | 1089676800000 | -122.42837146 | 37.71737953 | - | 1720690500000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1373573580000 | PRAGUE ST | - | - | - | - | - | - |
| 87136 | N/A | Point | - | - | - | - | S110698 | MUNICH ST: RUSSIA AVE | - | F | F | - | F | 21625000 | 21625000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MUNICH ST | MUNICH ST | 8468 | 8468 | 37.71776172 | -122.42917136 | RUSSIA AVE \ MUNICH ST | RUSSIA AVE \ MUNICH ST | 1754433671000 | middleware_editor | STOP | MUNICH ST intersection | - | BACK TO BACK WITH EXIST W53 | - | - | - | - | - | 104323 | 687078000000 | -122.42917136 | 37.71776172 | - | 1754419800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570880000 | RUSSIA AVE | - | - | - | - | - | - |
| 87137 | N/A | Point | - | - | - | - | S229951 | KING ST: 2ND ST | - | F | F | - | F | 23589000 | 23589000 | - | - | CENTER ISLAND, N LINE, WESTBOUND | - | - | - | - | 2ND ST | KING ST | 64895 | 64895 | 37.77986129 | -122.3895907 | KING ST \ 2ND ST | 02ND ST \ KING ST | 1710539427000 | MTA | SOLAR LANTERN WHITE (V5) | KING ST intersection | 15234 | 80' WEST OF MID BLOCK X WALK | - | - | - | - | - | 104324 | 1481009220000 | -122.3895907 | 37.77986129 | - | 1480982400000 | - | D6 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | 2IN FLANGE POST | IS | 1476872280000 | 02ND ST | - | - | - | - | - | - |
| 87138 | N/A | Point | 1 | 1 | 600 - 699 | - | S221211 | 600-699 DUBOCE AVE | 600-699 DUBOCE AVE | F | F | - | F | 4991000 | 4991000 | - | - | NORTH SIDE | - | - | - | - | NOE ST | NOE ST | 57304 | 57304 | 37.76914608 | -122.4342327 | - | - | 1710539427000 | MTA | SOLAR LANTERN RED (V5) | NOE ST to SCOTT ST (600 - 699) | 17318 | OPP. CENTER LINE OF NOE/SOUTH OF TRACKS | - | - | - | - | - | 104325 | - | -122.4342327 | 37.76914608 | - | - | - | D8 | - | OTHER MISC | MISC | SOLAR-RED.0001 | 14X11 | SUP2 | MUNI LANDOR POLE 3" X121" | IS | 1449584160000 | DUBOCE AVE | 600 - 699 DUBOCE AVE | 600 - 699 DUBOCE AVE | 600 DUBOCE AVE | - | SCOTT ST | SCOTT ST |
| 87139 | N/A | Point | - | - | - | - | S110802 | 16TH ST: MISSION ST | - | T | T | - | F | 24170000 | 24170000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MISSION ST | 16TH ST | 9502 | 9502 | 37.764875329 | -122.419832558 | 16TH ST \ MISSION ST | MISSION ST \ 16TH ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | 16TH ST intersection | - | - | - | - | - | - | - | 104326 | 706320000000 | -122.41966897 | 37.76505134 | - | 1474329600000 | - | D9 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | SIGNAL POLE | IS | 1373570940000 | MISSION ST | - | - | - | - | - | - |
| 87140 | N/A | Point | - | - | - | - | S118919 | HYDE ST: LOMBARD ST | - | F | F | - | F | 25565000 | 25565000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HYDE ST | HYDE ST | 13646 | 13646 | 37.80199486 | -122.41961397 | LOMBARD ST \ HYDE ST | LOMBARD ST \ HYDE ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | HYDE ST intersection | - | - | - | - | - | - | - | 104327 | 1084924800000 | -122.41961397 | 37.80199486 | - | 1703079060000 | - | D2 | - | NO LEFT TURN | REG | R3-2.0003 | 36X36 | SUP1 | LIGHT POLE | IS | 1373573460000 | LOMBARD ST | - | - | - | - | - | - |
| 87141 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S202855 | 1100-1199 LOMBARD ST | 1100-1199 LOMBARD ST | F | F | - | F | 8450000 | 8450000 | - | - | SOUTH SIDE | - | - | - | - | HYDE ST | HYDE ST | 42080 | 42080 | 37.80189129 | -122.42044191 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-SAT EXC "A" PERMITS | HYDE ST to LARKIN ST (1100 - 1199) | - | 50FT. EAST OF LARKIN ST | - | - | - | - | - | 104328 | - | -122.42044191 | 37.80189129 | - | - | - | D2 | - | PARKING:RPP | REG | R32C(CA).0129 | 18X21 | SUP1 | 2IN IRON POST | IS | 1391672760000 | LOMBARD ST | 1100 - 1199 LOMBARD ST | 1100 - 1199 LOMBARD ST | 1100 LOMBARD ST | - | LARKIN ST | LARKIN ST |
| 87142 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S250234 | 1100-1199 LOMBARD ST | 1100-1199 LOMBARD ST | F | F | - | F | 8450000 | 8450000 | - | - | NORTH SIDE | - | - | - | - | HYDE ST | HYDE ST | 81428 | 81428 | 37.80189129 | -122.42044191 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-SAT EXC "A" PERMITS | HYDE ST to LARKIN ST (1100 - 1199) | - | 60' WEST OF HYDE ST. | - | - | - | - | - | 104329 | - | -122.42044191 | 37.80189129 | - | - | - | D2 | - | PARKING:RPP | REG | R32C(CA).0129 | 18X21 | SUP1 | 2IN IRON POST | IS | 1544689560000 | LOMBARD ST | 1100 - 1199 LOMBARD ST | 1100 - 1199 LOMBARD ST | 1100 LOMBARD ST | - | LARKIN ST | LARKIN ST |
| 87143 | N/A | Point | - | - | - | - | S111671 | NIAGARA AVE: DELANO AVE | - | F | F | - | F | 22098000 | 22098000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DELANO AVE | DELANO AVE | 8324 | 8324 | 37.7188277 | -122.4459092 | NIAGARA AVE \ DELANO AVE | NIAGARA AVE \ DELANO AVE | 1710539427000 | MTA | STOP | DELANO AVE intersection | - | - | - | - | - | - | - | 104330 | 839376000000 | -122.4459092 | 37.7188277 | - | 1692085200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571180000 | NIAGARA AVE | - | - | - | - | - | - |
| 87144 | N/A | Point | - | - | - | - | S106486 | ADDISON ST: BEMIS ST | - | F | F | - | F | 21883000 | 21883000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BEMIS ST | ADDISON ST | 5033 | 5033 | 37.73782383 | -122.42949633 | ADDISON ST \ BEMIS ST | BEMIS ST \ ADDISON ST | 1710539427000 | MTA | STOP | ADDISON ST intersection | - | 0 / 0 | - | - | - | - | - | 104331 | 143942400000 | -122.42949633 | 37.73782383 | - | 1692105600000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569560000 | BEMIS ST | - | - | - | - | - | - |
| 87145 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S284529 | 1300-1399 HAYES ST | 1300-1399 HAYES ST | F | F | - | F | 6825000 | 6825000 | - | - | SOUTH SIDE | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 102585 | 102585 | 37.77488509 | -122.43863248 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | DIVISADERO ST to BRODERICK ST (1300 - 1399) | - | 45' WEST OF DIVISADERO ST. | - | - | - | - | - | 104332 | - | -122.43863248 | 37.77488509 | - | - | 1692112260000 | D5 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | TURNPIKE BASE | RETD | 1660646580000 | HAYES ST | 1300 - 1399 HAYES ST | 1300 - 1399 HAYES ST | 1300 HAYES ST | - | BRODERICK ST | BRODERICK ST |
| 87146 | N/A | Point | 1 | 1 | 1 - 99 | - | S115088 | 1-99 ELIZABETH ST | 1-99 ELIZABETH ST | F | F | - | F | 5141000 | 5141000 | - | - | NORTH SIDE | - | - | - | - | SAN JOSE AVE | SAN JOSE AVE | 12647 | 12647 | 37.75281685 | -122.42222754 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "Z" PERMITS | SAN JOSE AVE to GUERRERO ST (1 - 99) | - | 50' E OF GURRERO | - | - | - | - | - | 104333 | 1021420800000 | -122.42222754 | 37.75281685 | - | - | - | D8 | - | PARKING:RPP | REG | R32C(CA).0107 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373572260000 | ELIZABETH ST | 1 - 99 ELIZABETH ST | 1 - 99 ELIZABETH ST | 1 ELIZABETH ST | - | GUERRERO ST | GUERRERO ST |
| 87147 | N/A | Point | - | - | - | - | S230245 | THE EMBARCADERO: GREEN ST | - | F | F | - | F | 34014000 | 34014000 | - | - | CENTER ISLAND, W LINE, SOUTHBOUND | - | - | - | - | GREEN ST | GREEN ST | 66445 | 66445 | 37.80089648 | -122.39913024 | THE EMBARCADERO \ GREEN ST | THE EMBARCADERO \ GREEN ST | 1724420808000 | middleware_editor | SOLAR LANTERN WHITE (V5) | GREEN ST intersection | 14518 | 80' SOUTH OF X WALK | - | - | - | - | - | 104334 | - | -122.39913024 | 37.80089648 | - | - | - | D3 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | 2IN FLANGE POST | IS | 1477561260000 | THE EMBARCADERO | - | - | - | - | - | - |
| 87148 | N/A | Point | - | - | - | - | S230246 | THE EMBARCADERO: GREEN ST | - | F | F | - | T | 12556202 | 34014000 | - | - | CENTER ISLAND, E LINE, NORTHBOUND | - | - | - | - | GREEN ST | GREEN ST | 66446 | 66446 | 37.80089648 | -122.39913024 | - | THE EMBARCADERO \ GREEN ST | 1727392196000 | middleware_editor | SOLAR LANTERN WHITE (V5) | GREEN ST intersection | 14517 | 80' NORTH OF X WALK | - | - | - | - | - | 104335 | 1727362860000 | -122.39913024 | 37.80089648 | - | - | - | D3 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | 2IN FLANGE POST | IS | 1477561380000 | THE EMBARCADERO | 600 - 1098 THE EMBARCADERO | - | - | - | BATTERY ST \ LOMBARD ST | - |
| 87149 | N/A | Point | - | - | - | - | S230031 | THE EMBARCADERO: GREEN ST | - | F | F | - | F | 34014000 | 34014000 | - | - | CENTER ISLAND, W LINE, SOUTHBOUND | - | - | - | - | GREEN ST | GREEN ST | 66155 | 66155 | 37.80089648 | -122.39913024 | THE EMBARCADERO \ GREEN ST | THE EMBARCADERO \ GREEN ST | 1750181692000 | middleware_editor | SOLAR LANTERN WHITE (V5) | GREEN ST intersection | 14518 | 80' SOUTH OF X WALK | - | - | - | - | - | 104336 | - | -122.39913024 | 37.80089648 | - | - | - | D3 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | 2IN FLANGE POST | IS | 1476973920000 | THE EMBARCADERO | - | - | - | - | - | - |
| 87150 | N/A | Point | - | - | - | - | S229934 | KING ST: 4TH ST | - | F | F | - | F | 23798000 | 23798000 | - | - | CENTER ISLAND, N LINE, EASTBOUND | - | - | - | - | 4TH ST | 04TH ST | 65356 | 65356 | 37.77633298 | -122.39403507 | KING ST \ 4TH ST | KING ST \ 04TH ST | 1737676113000 | middleware_editor | SOLAR LANTERN WHITE (V5) | 04TH ST intersection | 14506 | 75' EAST OF X WALK OPP #600 | - | - | - | - | - | 104337 | 1481009580000 | -122.39403507 | 37.77633298 | - | 1480982400000 | - | D6 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP1 | 2IN FLANGE POST | IS | 1476797040000 | KING 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.