MTA.signshop_assets
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 70651 | N/A | Point | - | - | - | - | S273175 | 28TH ST: DOLORES ST | - | F | F | - | F | 21896000 | 21896000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | DOLORES ST | DOLORES ST | 119942 | 119942 | 37.74543572 | -122.42453897 | 28TH ST \ DOLORES ST | 28TH ST \ DOLORES ST | 1720575797000 | middleware_editor | SPEED HUMPS AHEAD | DOLORES ST intersection | - | - | - | - | - | - | - | 87767 | -379641600000 | -122.42453897 | 37.74543572 | - | 1615852800000 | - | D8 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1615553100000 | 28TH ST | - | - | - | - | - | - |
| 70652 | N/A | Point | - | - | - | - | S273176 | 28TH ST: DOLORES ST | - | F | F | - | F | 21896000 | 21896000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | DOLORES ST | DOLORES ST | 119943 | 119943 | 37.74543572 | -122.42453897 | 28TH ST \ DOLORES ST | 28TH ST \ DOLORES ST | 1720575827000 | middleware_editor | SPEED HUMPS AHEAD | DOLORES ST intersection | - | 25 FT EAST OF CHURCH ST | - | - | - | - | - | 87768 | -379641600000 | -122.42453897 | 37.74543572 | - | 1615852800000 | - | D8 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1615553280000 | 28TH ST | - | - | - | - | - | - |
| 70653 | N/A | Point | - | - | - | - | S273894 | LEVANT ST: STATES ST | - | F | F | - | F | 26167000 | 26167000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | LEVANT ST | STATES ST | 120098 | 120098 | 37.76500272 | -122.4423173 | STATES ST \ LEVANT ST | LEVANT ST \ STATES ST | 1746462779000 | middleware_editor | SPEED HUMPS AHEAD | STATES ST intersection | - | IFO 10 | - | - | - | - | - | 87769 | 310809600000 | -122.4423173 | 37.76500272 | - | 1621407600000 | - | D8 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1618218300000 | LEVANT ST | - | - | - | - | - | - |
| 70654 | N/A | Point | - | - | - | - | S273895 | LEVANT ST: LOWER TER | - | F | F | - | F | 26177000 | 26177000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LOWER TER | LEVANT ST | 120099 | 120099 | 37.76325181 | -122.44198742 | LEVANT ST \ LOWER TER | LOWER TER \ LEVANT ST | 1710539427000 | MTA | SPEED HUMPS AHEAD | LEVANT ST intersection | - | X IS LOWER TERRACE | - | - | - | - | - | 87770 | 310780800000 | -122.44198742 | 37.76325181 | - | 1621382400000 | - | D8 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1618218480000 | LOWER TER | - | - | - | - | - | - |
| 70655 | N/A | Point | - | - | - | - | S230578 | HAMPSHIRE ST: CESAR CHAVEZ ON | - | F | F | - | F | 33287000 | 33287000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CESAR CHAVEZ ON RAMP \ CESAR CHAVEZ ST | CESAR CHAVEZ ON RAMP \ CESAR CHAVEZ ST | 120112 | 120112 | 37.74876648 | -122.40675778 | HAMPSHIRE ST \ CESAR CHAVEZ ON RAMP \ CESAR CHAVEZ ST | HAMPSHIRE ST \ CESAR CHAVEZ ON RAMP \ CESAR CHAVEZ ST | 1755015162000 | middleware_editor | SPEED HUMP | CESAR CHAVEZ ON RAMP \ CESAR CHAVEZ ST intersection | - | - | - | - | - | - | - | 87771 | 1479249720000 | -122.40675778 | 37.74876648 | - | 1479196800000 | - | D9 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1478012400000 | HAMPSHIRE ST | - | - | - | - | - | - |
| 70656 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S288747 | 2200-2299 MISSION ST | 2200-2299 MISSION ST | F | F | - | F | 9120000 | 9120000 | - | - | EAST SIDE | - | - | - | - | 18TH ST | 18TH ST | 120150 | 120150 | 37.76103561 | -122.41928266 | - | - | 1710539427000 | MTA | BIKE RACK | 18TH ST to 19TH ST (2200 - 2299) | - | 3' N OF SPL 2267/3'6" IN FROM CURB | - | - | - | - | - | 87772 | - | -122.41928266 | 37.76103561 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1681912620000 | MISSION ST | 2200 - 2299 MISSION ST | 2200 - 2299 MISSION ST | 2200 MISSION ST | - | 19TH ST | 19TH ST |
| 70657 | N/A | Point | 1 | 1 | 100 - 199 | - | S280833 | 100-199 PARIS ST | 100-199 PARIS ST | F | F | - | F | 10251000 | 10251000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | AVALON AVE | AVALON AVE | 120340 | 120340 | 37.72620688 | -122.4315095 | - | - | 1710539427000 | MTA | SPEED HUMP | AVALON AVE to EXCELSIOR AVE (100 - 199) | - | 25 FT NORTH OF EXCELSIOR | - | - | - | - | - | 87773 | 1646092800000 | -122.4315095 | 37.72620688 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1644483060000 | PARIS ST | 100 - 199 PARIS ST | 100 - 199 PARIS ST | 100 PARIS ST | - | EXCELSIOR AVE | EXCELSIOR AVE |
| 70658 | N/A | Point | - | - | - | - | S280835 | LONDON ST: EXCELSIOR AVE | - | F | F | - | F | 21760000 | 21760000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | EXCELSIOR AVE | EXCELSIOR AVE | 120342 | 120342 | 37.725894964 | -122.432753348 | LONDON ST \ EXCELSIOR AVE | LONDON ST \ EXCELSIOR AVE | 1710539427000 | MTA | SPEED HUMP | EXCELSIOR AVE intersection | - | - | - | - | - | - | - | 87774 | 1646006400000 | -122.43285706 | 37.72587092 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1644484800000 | LONDON ST | - | - | - | - | - | - |
| 70659 | N/A | Point | 1 | 1 | 1000 - 1049 | - | S279866 | 1000-1049 VALENCIA ST | 1000-1049 VALENCIA ST | F | F | - | F | 13069000 | 13069000 | - | - | EAST SIDE | - | - | - | - | 21ST ST | 21ST ST | 120393 | 120393 | 37.756795967 | -122.421007814 | - | - | 1744380587000 | middleware_editor | BIKE RACK | 21ST ST to HILL ST (1000 - 1049) | - | IFO1001/ 6.5' FROM N LINE SEE WO | - | - | - | - | - | 87775 | 1641888000000 | -122.42107934 | 37.75650191 | - | - | 1744318500000 | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | DELINEATOR BASE SAFE HIT | RETD | 1639752240000 | VALENCIA ST | 1000 - 1049 VALENCIA ST | 1000 - 1049 VALENCIA ST | 1000 VALENCIA ST | - | HILL ST | HILL ST |
| 70660 | N/A | Point | 1 | 1 | 1000 - 1049 | - | S279867 | 1000-1049 VALENCIA ST | 1000-1049 VALENCIA ST | F | F | - | F | 13069000 | 13069000 | - | - | EAST SIDE | - | - | - | - | 21ST ST | 21ST ST | 120394 | 120394 | 37.75676298 | -122.421009007 | - | - | 1744380580000 | middleware_editor | BIKE RACK | 21ST ST to HILL ST (1000 - 1049) | - | IFO1001/ 9.5' FROM N LINE SEE WO | - | - | - | - | - | 87776 | 1641888000000 | -122.42107934 | 37.75650191 | - | - | 1744317300000 | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | DELINEATOR BASE SAFE HIT | RETD | 1639752240000 | VALENCIA ST | 1000 - 1049 VALENCIA ST | 1000 - 1049 VALENCIA ST | 1000 VALENCIA ST | - | HILL ST | HILL ST |
| 70661 | N/A | Point | 1 | 1 | 1000 - 1049 | - | S279868 | 1000-1049 VALENCIA ST | 1000-1049 VALENCIA ST | F | F | - | F | 13069000 | 13069000 | - | - | EAST SIDE | - | - | - | - | 21ST ST | 21ST ST | 120395 | 120395 | 37.75676675 | -122.421010199 | - | - | 1744380585000 | middleware_editor | BIKE RACK | 21ST ST to HILL ST (1000 - 1049) | - | IFO1001/ 12.5' FROM N LINE SEE WO | - | - | - | - | - | 87777 | 1641888000000 | -122.42107934 | 37.75650191 | - | - | 1744314900000 | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | DELINEATOR BASE SAFE HIT | RETD | 1639752300000 | VALENCIA ST | 1000 - 1049 VALENCIA ST | 1000 - 1049 VALENCIA ST | 1000 VALENCIA ST | - | HILL ST | HILL ST |
| 70662 | N/A | Point | 1 | 1 | 200 - 299 | - | S287607 | 200-299 JOOST AVE | 200-299 JOOST AVE | F | F | - | F | 7608000 | 7608000 | - | - | SOUTH SIDE | - | - | - | - | BADEN ST | BADEN ST | 120431 | 120431 | 37.73236245 | -122.44088741 | - | - | 1734374431000 | middleware_editor | 4 HR PRK 9AM-5PM MON-FRI EXC "D" PERMITS | BADEN ST to CONGO ST (200 - 299) | - | EPL OF 241 JOOST | - | - | - | - | - | 87778 | 1222819200000 | -122.44088741 | 37.73236245 | - | - | - | D7 | - | PARKING:RPP | REG | R32C(CA).0201 | 18X21 | SUP2 | 2IN IRON POST | IS | 1676970720000 | JOOST AVE | 200 - 299 JOOST AVE | 200 - 299 JOOST AVE | 200 JOOST AVE | - | CONGO ST | CONGO ST |
| 70663 | N/A | Point | - | - | - | - | S280422 | JERSEY ST: CASTRO ST | - | F | F | - | F | 25739000 | 25739000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CASTRO ST | CASTRO ST | 120507 | 120507 | 37.75049493 | -122.43400652 | JERSEY ST \ CASTRO ST | JERSEY ST \ CASTRO ST | 1736796834000 | middleware_editor | SPEED HUMPS AHEAD | CASTRO ST intersection | - | - | - | - | - | - | - | 87779 | 1644278400000 | -122.43400652 | 37.75049493 | - | - | - | D8 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1642070040000 | JERSEY ST | - | - | - | - | - | - |
| 70664 | N/A | Point | - | - | - | - | S278501 | MISSION ST: RANDALL ST | - | F | F | - | F | 21836000 | 21836000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | MISSION ST | MISSION ST | 120514 | 120514 | 37.739972795 | -122.423590969 | RANDALL ST \ MISSION ST | RANDALL ST \ MISSION ST | 1739979924000 | middleware_editor | KEEP RIGHT (SYM) | MISSION ST intersection | - | TOP OF SIGN 5FT FROM GROUND | - | - | - | - | - | 87780 | 903398400000 | -122.42358024 | 37.73988371 | - | 1739886300000 | - | D8 | - | OTHER REGULATORY | REG | R4-7A.0002 | 24X30 | SUP2 | 2IN IRON POST | IS | 1635411000000 | RANDALL ST | - | - | - | - | - | - |
| 70665 | N/A | Point | - | - | - | - | S100256 | 46TH AVE: JUDAH ST | - | F | F | - | F | 27947000 | 27947000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | JUDAH ST | 46TH AVE | 120517 | 120517 | 37.760334663 | -122.50585122 | 46TH AVE \ JUDAH ST | JUDAH ST \ 46TH AVE | 1710539427000 | MTA | STOP | 46TH AVE intersection | - | 0 / 00 | - | - | - | - | - | 87781 | -404870400000 | -122.50592811 | 37.76042443 | - | 1494547200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566380000 | JUDAH ST | - | - | - | - | - | - |
| 70666 | N/A | Point | - | - | - | - | S100524 | 11TH AVE: LINCOLN WAY | - | F | F | - | F | 27172000 | 27172000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LINCOLN WAY | 11TH AVE | 1 | 1 | 37.7657165916162 | -122.468514604131 | 11TH AVE \ LINCOLN WAY | LINCOLN WAY \ 11TH AVE | 1754603018000 | middleware_editor | STOP | 11TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 87782 | -403632000000 | -122.468583 | 37.76583003 | - | 1754597700000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566500000 | LINCOLN WAY | - | - | - | - | - | - |
| 70667 | N/A | Point | - | - | - | - | S100525 | 15TH AVE: LINCOLN WAY | - | F | F | - | F | 27358000 | 27358000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 15TH AVE | 15TH AVE | 2 | 2 | 37.76564119 | -122.47292273 | LINCOLN WAY \ 15TH AVE | LINCOLN WAY \ 15TH AVE | 1710539427000 | MTA | STOP | 15TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 87783 | -403657200000 | -122.47292273 | 37.76564119 | - | 1528070400000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373566500000 | LINCOLN WAY | - | - | - | - | - | - |
| 70668 | N/A | Point | - | - | - | - | S100526 | FUNSTON AVE: LINCOLN WAY | - | F | F | - | F | 27176000 | 27176000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FUNSTON AVE | FUNSTON AVE | 3 | 3 | 37.76573925 | -122.47072726 | LINCOLN WAY \ FUNSTON AVE | LINCOLN WAY \ FUNSTON AVE | 1710539427000 | MTA | STOP | FUNSTON AVE intersection | - | 0 / 0 | - | - | - | - | - | 87784 | -403657200000 | -122.47072726 | 37.76573925 | - | 622771200000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373566500000 | LINCOLN WAY | - | - | - | - | - | - |
| 70669 | N/A | Point | - | - | - | - | S100527 | 12TH AVE: JUDAH ST | - | F | F | - | F | 27161000 | 27161000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | JUDAH ST | JUDAH ST | 4 | 4 | 37.76203411 | -122.46939183 | 12TH AVE \ JUDAH ST | 12TH AVE \ JUDAH ST | 1746054786000 | middleware_editor | STOP | JUDAH ST intersection | - | 0 / 0 | - | - | - | - | - | 87785 | -403632000000 | -122.46939183 | 37.76203411 | - | 1443078000000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566500000 | 12TH AVE | - | - | - | - | - | - |
| 70670 | N/A | Point | - | - | - | - | S100529 | 14TH AVE: JUDAH ST | - | F | F | - | F | 27169000 | 27169000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 14TH AVE | 14TH AVE | 5 | 5 | 37.76193989 | -122.47153761 | JUDAH ST \ 14TH AVE | JUDAH ST \ 14TH AVE | 1744809122000 | middleware_editor | STOP | 14TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 87786 | -403632000000 | -122.47153761 | 37.76193989 | - | 1555398000000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373566500000 | JUDAH ST | - | - | - | - | - | - |
| 70671 | N/A | Point | - | - | - | - | S100262 | JUDAH ST: 46TH AVE | - | F | F | - | F | 27947000 | 27947000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | JUDAH ST | 46TH AVE | 273 | 273 | 37.760342084 | -122.506050598 | 46TH AVE \ JUDAH ST | JUDAH ST \ 46TH AVE | 1710539427000 | MTA | STOP | 46TH AVE intersection | - | 0 / 00 | - | - | - | - | - | 87787 | -404870400000 | -122.50592811 | 37.76042443 | - | 1510531200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373566380000 | JUDAH ST | - | - | - | - | - | - |
| 70672 | N/A | Point | - | - | - | - | S100265 | JOOST AVE: FOERSTER ST | - | F | F | - | F | 22233000 | 22233000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | JOOST AVE | FOERSTER ST | 275 | 275 | 37.73232632 | -122.44886866 | FOERSTER ST \ JOOST AVE | JOOST AVE \ FOERSTER ST | 1710539427000 | MTA | STOP | FOERSTER ST intersection | - | 0 / 00 | - | - | - | - | - | 87788 | -404870400000 | -122.44886866 | 37.73232632 | - | 1114473600000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373566380000 | JOOST AVE | - | - | - | - | - | - |
| 70673 | N/A | Point | - | - | - | - | S100968 | BOCANA ST: CORTLAND AVE | - | F | F | - | F | 21246000 | 21246000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CORTLAND AVE | BOCANA ST | 315 | 315 | 37.73929728 | -122.41858438 | BOCANA ST \ CORTLAND AVE | CORTLAND AVE \ BOCANA ST | 1710539427000 | MTA | STOP | BOCANA ST intersection | - | - | - | - | - | - | - | 87789 | -401612400000 | -122.41858438 | 37.73929728 | - | 1540364400000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566620000 | CORTLAND AVE | - | - | - | - | - | - |
| 70674 | N/A | Point | - | - | - | - | S100982 | KINGSTON ST: MISSION ST | - | F | F | - | F | 21327000 | 21327000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | KINGSTON ST | KINGSTON ST | 323 | 323 | 37.741733336 | -122.42221266 | MISSION ST \ KINGSTON ST | MISSION ST \ KINGSTON ST | 1710539427000 | MTA | DO NOT ENTER | KINGSTON ST intersection | - | AT EAST END OF H/C RAMP | - | - | - | - | - | 87790 | -401587200000 | -122.42236646 | 37.74176049 | - | 1524528000000 | - | D9 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566620000 | MISSION ST | - | - | - | - | - | - |
| 70675 | N/A | Point | - | - | - | - | S100986 | KINGSTON ST: MISSION ST | - | F | F | - | F | 21327000 | 21327000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | KINGSTON ST | KINGSTON ST | 325 | 325 | 37.741733071 | -122.42221266 | MISSION ST \ KINGSTON ST | MISSION ST \ KINGSTON ST | 1710539427000 | MTA | ONE WAY (LA) | KINGSTON ST intersection | - | AT EAST END OF H/C RAMP | - | - | - | - | - | 87791 | -401587200000 | -122.42236646 | 37.74176049 | - | 1524528000000 | - | D9 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | 2IN IRON POST | IS | 1373566620000 | MISSION ST | - | - | - | - | - | - |
| 70676 | N/A | Point | - | - | - | - | S100987 | KINGSTON ST: MISSION ST | - | F | F | - | F | 21327000 | 21327000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | KINGSTON ST | KINGSTON ST | 326 | 326 | 37.741687412 | -122.422253755 | MISSION ST \ KINGSTON ST | MISSION ST \ KINGSTON ST | 1742305797000 | middleware_editor | ONE WAY (RA) | KINGSTON ST intersection | - | 0 / 0 | - | - | - | - | - | 87792 | -401562000000 | -122.42236646 | 37.74176049 | - | 1742233500000 | - | D9 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | 2IN IRON POST | IS | 1373566620000 | MISSION ST | - | - | - | - | - | - |
| 70677 | N/A | Point | - | - | - | - | S100634 | CLAUDE LN: SUTTER ST | - | F | F | - | F | 24665000 | 24665000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SUTTER ST | CLAUDE LN | 336 | 336 | 37.789865976 | -122.404257811 | CLAUDE LN \ SUTTER ST | SUTTER ST \ CLAUDE LN | 1710539427000 | MTA | ONE WAY (LA) | CLAUDE LN intersection | - | 0 / 0 | - | - | - | - | - | 87793 | -403056000000 | -122.40420819 | 37.78978278 | - | 1690454700000 | - | D3 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP1 | 2IN FLANGE POST | IS | 1373566500000 | SUTTER ST | - | - | - | - | - | - |
| 70678 | N/A | Point | - | - | - | - | S101175 | FERN ST: POLK ST | - | F | F | - | F | 25209000 | 25209000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FERN ST | FERN ST | 355 | 355 | 37.7882227 | -122.42021044 | POLK ST \ FERN ST | POLK ST \ FERN ST | 1710539427000 | MTA | STOP | FERN ST intersection | - | - | - | - | - | - | - | 87794 | -400057199000 | -122.42021044 | 37.7882227 | - | 1664323200000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566680000 | POLK ST | - | - | - | - | - | - |
| 70679 | N/A | Point | - | - | - | - | S101158 | CLAUDE LN: SUTTER ST | - | F | F | - | F | 24665000 | 24665000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SUTTER ST | CLAUDE LN | 431 | 431 | 37.789864387 | -122.40425647 | CLAUDE LN \ SUTTER ST | SUTTER ST \ CLAUDE LN | 1710539427000 | MTA | DO NOT ENTER | CLAUDE LN intersection | - | 0 / 0 | - | - | - | - | - | 87795 | -400291200000 | -122.40420819 | 37.78978278 | - | 1690457400000 | - | D3 | - | OTHER REGULATORY | REG | R5-1.0002 | 24X24 | SUP1 | UNKNOWN | IS | 1373566680000 | SUTTER ST | - | - | - | - | - | - |
| 70680 | N/A | Point | - | - | - | - | S100032 | BYXBEE ST: GARFIELD ST | - | F | F | - | F | 22723000 | 22723000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GARFIELD ST | BYXBEE ST | 450 | 450 | 37.71965223 | -122.46985226 | BYXBEE ST \ GARFIELD ST | GARFIELD ST \ BYXBEE ST | 1710539427000 | MTA | STOP | BYXBEE ST intersection | - | - | - | - | - | - | - | 87796 | -407203200000 | -122.46985226 | 37.71965223 | - | 1573171200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566320000 | GARFIELD ST | - | - | - | - | - | - |
| 70681 | N/A | Point | - | - | - | - | S100039 | GOETHE ST: SAN JOSE AVE | - | F | F | - | F | 22464000 | 22464000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GOETHE ST | GOETHE ST | 456 | 456 | 37.708520963 | -122.459021285 | SAN JOSE AVE \ GOETHE ST | SAN JOSE AVE \ GOETHE ST | 1710539427000 | MTA | STOP | GOETHE ST intersection | - | 0 / 0 | - | - | - | - | - | 87797 | -406944000000 | -122.45882474 | 37.70844468 | - | - | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373566320000 | SAN JOSE AVE | - | - | - | - | - | - |
| 70682 | N/A | Point | - | - | - | - | S100794 | 42ND AVE: BALBOA ST | - | F | F | - | F | 27907000 | 27907000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | 42ND AVE | 461 | 461 | 37.775573393 | -122.502754118 | 42ND AVE \ BALBOA ST | BALBOA ST \ 42ND AVE | 1710539427000 | MTA | STOP | 42ND AVE intersection | - | 0 / 0 | - | - | - | - | - | 87798 | -402451200000 | -122.50267097 | 37.77547057 | - | 1183939200000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566560000 | BALBOA ST | - | - | - | - | - | - |
| 70683 | N/A | Point | - | - | - | - | S100795 | 42ND AVE: BALBOA ST | - | F | F | - | F | 27907000 | 27907000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | 42ND AVE | 462 | 462 | 37.775381527 | -122.502599892 | 42ND AVE \ BALBOA ST | BALBOA ST \ 42ND AVE | 1710539427000 | MTA | STOP | 42ND AVE intersection | - | 0 / 0 | - | - | - | - | - | 87799 | -402451200000 | -122.50267097 | 37.77547057 | - | 1184112000000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566560000 | BALBOA ST | - | - | - | - | - | - |
| 70684 | N/A | Point | - | - | - | - | S100796 | 44TH AVE: BALBOA ST | - | F | F | - | F | 27983000 | 27983000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | 44TH AVE | 463 | 463 | 37.775474213 | -122.504896826 | 44TH AVE \ BALBOA ST | BALBOA ST \ 44TH AVE | 1731018519000 | middleware_editor | STOP | 44TH AVE intersection | - | 0 / 00 | - | - | - | - | - | 87800 | -402451200000 | -122.50481636 | 37.77537245 | - | 1730982480000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UTILITY POLE | IS | 1373566560000 | BALBOA ST | - | - | - | - | - | - |
| 70685 | N/A | Point | - | - | - | - | S100797 | 44TH AVE: BALBOA ST | - | F | F | - | F | 27983000 | 27983000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | 44TH AVE | 464 | 464 | 37.775275987 | -122.504741258 | 44TH AVE \ BALBOA ST | BALBOA ST \ 44TH AVE | 1731018524000 | middleware_editor | STOP | 44TH AVE intersection | - | 0 / 00 | - | - | - | - | - | 87801 | -402451200000 | -122.50481636 | 37.77537245 | - | 1730982180000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566560000 | BALBOA ST | - | - | - | - | - | - |
| 70686 | N/A | Point | - | - | - | - | S100657 | HYDE ST: TURK ST | - | F | F | - | F | 24933000 | 24933000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HYDE ST | TURK ST | 505 | 505 | 37.78262688 | -122.415811372 | TURK ST \ HYDE ST | HYDE ST \ TURK ST | 1711748413000 | middleware_editor | ONE WAY (LA) | TURK ST intersection | - | 0 / 0 | - | - | - | - | - | 87802 | -402969600000 | -122.41569387 | 37.78258503 | - | 1702294200000 | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373566500000 | HYDE ST | - | - | - | - | - | - |
| 70687 | N/A | Point | - | - | - | - | S100998 | LISBON ST: PERSIA AVE | - | F | F | - | F | 21719000 | 21719000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | PERSIA AVE | LISBON ST | 734 | 734 | 37.721908991 | -122.433595611 | LISBON ST \ PERSIA AVE | PERSIA AVE \ LISBON ST | 1710539427000 | MTA | STOP | LISBON ST intersection | - | 0 / 0 | - | - | - | - | - | 87803 | -401241600000 | -122.43360634 | 37.72200022 | - | 1049328000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373566620000 | PERSIA AVE | - | - | - | - | - | - |
| 70688 | N/A | Point | - | - | - | - | S100999 | LONDON ST: PERSIA AVE | - | F | F | - | F | 21725000 | 21725000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LONDON ST | PERSIA AVE | 735 | 735 | 37.722669673 | -122.435195883 | PERSIA AVE \ LONDON ST | LONDON ST \ PERSIA AVE | 1710539427000 | MTA | STOP | PERSIA AVE intersection | - | - | - | - | - | - | - | 87804 | -401266800000 | -122.4352084 | 37.72276373 | - | 1594696200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566620000 | LONDON ST | - | - | - | - | - | - |
| 70689 | N/A | Point | - | - | - | - | S101000 | PARIS ST: PERSIA AVE | - | F | F | - | F | 21724000 | 21724000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PERSIA AVE | PERSIA AVE | 736 | 736 | 37.722477849 | -122.434428168 | PARIS ST \ PERSIA AVE | PARIS ST \ PERSIA AVE | 1710539427000 | MTA | STOP | PERSIA AVE intersection | - | 0 / 0 | - | - | - | - | - | 87805 | -401241600000 | -122.43440671 | 37.72238167 | - | 1666051200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373566620000 | PARIS ST | - | - | - | - | - | - |
| 70690 | N/A | Point | - | - | - | - | S105810 | 15TH AVE: WEST PORTAL AVE | - | F | F | - | F | 22940000 | 22940000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WEST PORTAL AVE | 15TH AVE | 2478 | 2478 | 37.736570647 | -122.470427463 | 15TH AVE \ WEST PORTAL AVE | WEST PORTAL AVE \ 15TH AVE | 1747758157000 | middleware_editor | STOP | 15TH AVE intersection | - | - | - | - | - | - | - | 87806 | 103852800000 | -122.47057409 | 37.73658903 | - | - | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569320000 | WEST PORTAL AVE | - | - | - | - | - | - |
| 70691 | N/A | Point | - | - | - | - | S105172 | 26TH AVE: ANZA ST | - | F | F | - | F | 27548000 | 27548000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ANZA ST | ANZA ST | 2481 | 2481 | 37.7782108587594 | -122.48575419187 | 26TH AVE \ ANZA ST | 26TH AVE \ ANZA ST | 1752780223000 | middleware_editor | STOP | ANZA ST intersection | - | - | - | - | - | - | - | 87807 | 57369600000 | -122.4856674 | 37.77811725 | - | 1657004400000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569140000 | 26TH AVE | - | - | - | - | - | - |
| 70692 | N/A | Point | - | - | - | - | S105585 | PARIS ST: BRAZIL AVE | - | F | F | - | F | 21717000 | 21717000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | PARIS ST | BRAZIL AVE | 2504 | 2504 | 37.723836263 | -122.433217185 | BRAZIL AVE \ PARIS ST | PARIS ST \ BRAZIL AVE | 1710539427000 | MTA | STOP | BRAZIL AVE intersection | - | 0 / 00 | - | - | - | - | - | 87808 | 86227200000 | -122.43323149 | 37.72393244 | - | 1398988800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | PARIS ST | - | - | - | - | - | - |
| 70693 | N/A | Point | - | - | - | - | S105587 | PANORAMA DR: DELLBROOK AVE | - | F | F | - | F | 26246000 | 26246000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DELLBROOK AVE | DELLBROOK AVE | 2506 | 2506 | 37.753460777 | -122.452633759 | PANORAMA DR \ DELLBROOK AVE | PANORAMA DR \ DELLBROOK AVE | 1717706667000 | middleware_editor | STOP | DELLBROOK AVE intersection | - | 0 / 0 | - | - | - | - | - | 87809 | 86227200000 | -122.45257028 | 37.75354207 | - | 1717666800000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569260000 | PANORAMA DR | - | - | - | - | - | - |
| 70694 | N/A | Point | - | - | - | - | S105595 | 21ST AVE: LAWTON ST | - | F | F | - | F | 27346000 | 27346000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LAWTON ST | 21ST AVE | 2512 | 2512 | 37.7578726 | -122.47887452 | 21ST AVE \ LAWTON ST | LAWTON ST \ 21ST AVE | 1744744195000 | middleware_editor | STOP | 21ST AVE intersection | - | - | - | - | - | - | - | 87810 | 86918400000 | -122.47887452 | 37.7578726 | - | 1467120780000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | LAWTON ST | - | - | - | - | - | - |
| 70695 | N/A | Point | - | - | - | - | S105608 | AMAZON AVE: LISBON ST | - | F | F | - | F | 21443000 | 21443000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | AMAZON AVE | AMAZON AVE | 2521 | 2521 | 37.716322429 | -122.437762873 | LISBON ST \ AMAZON AVE | LISBON ST \ AMAZON AVE | 1733268408000 | middleware_editor | STOP | AMAZON AVE intersection | - | 0 / 0 | - | - | - | - | - | 87811 | 87523200000 | -122.43790056 | 37.7163196 | - | 1733227800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569260000 | LISBON ST | - | - | - | - | - | - |
| 70696 | N/A | Point | - | - | - | - | S106220 | EXCELSIOR AVE: LONDON ST | - | F | F | - | F | 21760000 | 21760000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | EXCELSIOR AVE | EXCELSIOR AVE | 2600 | 2600 | 37.725868091 | -122.43275156 | LONDON ST \ EXCELSIOR AVE | LONDON ST \ EXCELSIOR AVE | 1710539427000 | MTA | STOP | EXCELSIOR AVE intersection | - | 0 / 0 | - | - | - | - | - | 87812 | 130032000000 | -122.43285706 | 37.72587092 | - | 1452643200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569500000 | LONDON ST | - | - | - | - | - | - |
| 70697 | N/A | Point | - | - | - | - | S106227 | EXCELSIOR AVE: LONDON ST | - | F | F | - | F | 21760000 | 21760000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | EXCELSIOR AVE | EXCELSIOR AVE | 2606 | 2606 | 37.725868091 | -122.432980442 | LONDON ST \ EXCELSIOR AVE | LONDON ST \ EXCELSIOR AVE | 1710539427000 | MTA | STOP | EXCELSIOR AVE intersection | - | 0 / 0 | - | - | - | - | - | 87813 | 130032000000 | -122.43285706 | 37.72587092 | - | 1034812800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569500000 | LONDON ST | - | - | - | - | - | - |
| 70698 | N/A | Point | - | - | - | - | S106228 | LONDON ST: EXCELSIOR AVE | - | F | F | - | F | 21760000 | 21760000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | EXCELSIOR AVE | EXCELSIOR AVE | 2607 | 2607 | 37.72597558 | -122.432878518 | LONDON ST \ EXCELSIOR AVE | LONDON ST \ EXCELSIOR AVE | 1710539427000 | MTA | STOP | EXCELSIOR AVE intersection | - | 00 / 0 | - | - | - | - | - | 87814 | 130032000000 | -122.43285706 | 37.72587092 | - | 1540857600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373569500000 | LONDON ST | - | - | - | - | - | - |
| 70699 | N/A | Point | - | - | - | - | S104072 | SAN JOSE AVE: 23RD ST | - | F | F | - | F | 24110000 | 24110000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 23RD ST | 23RD ST | 2644 | 2644 | 37.753741046 | -122.421586266 | SAN JOSE AVE \ 23RD ST | SAN JOSE AVE \ 23RD ST | 1710539427000 | MTA | STOP | 23RD ST intersection | - | 0 / 0 | - | - | - | - | - | 87815 | -56419200000 | -122.42151787 | 37.75366046 | - | 1226448000000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568840000 | SAN JOSE AVE | - | - | - | - | - | - |
| 70700 | N/A | Point | - | - | - | - | S105931 | SACRAMENTO ST: GOUGH ST | - | T | T | - | F | 26542000 | 26542000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SACRAMENTO ST | GOUGH ST | 2663 | 2663 | 37.79087443 | -122.42580214 | GOUGH ST \ SACRAMENTO ST | SACRAMENTO ST \ GOUGH ST | 1748539951000 | middleware_editor | DO NOT ENTER | GOUGH ST intersection | - | - | - | - | - | - | - | 87816 | 108086400000 | -122.42580214 | 37.79087443 | - | 1411049280000 | - | D2 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | MUNI POLE | IS | 1373569380000 | SACRAMENTO ST | - | - | - | - | - | - |
| 70701 | N/A | Point | - | - | - | - | S107990 | TEDDY AVE: ALPHA ST | - | F | F | - | F | 20322000 | 20322000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TEDDY AVE | ALPHA ST | 2697 | 2697 | 37.713849449 | -122.404478457 | ALPHA ST \ TEDDY AVE | TEDDY AVE \ ALPHA ST | 1710539427000 | MTA | ONE WAY (LA) | ALPHA ST intersection | - | 0 / MADE TEDDY ONE-WAY WB SANBRUNO-..... | - | - | - | - | - | 87817 | 272505600000 | -122.40445834 | 37.71383937 | - | - | - | D10 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | 2IN IRON POST | D | 1373570040000 | TEDDY AVE | - | - | - | - | - | - |
| 70702 | N/A | Point | - | - | - | - | S107775 | SACRAMENTO ST: LEAVENWORTH ST | - | F | F | - | F | 25248000 | 25248000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LEAVENWORTH ST | SACRAMENTO ST | 2717 | 2717 | 37.792193348 | -122.41583329 | SACRAMENTO ST \ LEAVENWORTH ST | LEAVENWORTH ST \ SACRAMENTO ST | 1710539427000 | MTA | STOP | SACRAMENTO ST intersection | - | 0 / 00 | - | - | - | - | - | 87818 | 253843200000 | -122.41593622 | 37.79213294 | - | 1417478400000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569980000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 70703 | N/A | Point | - | - | - | - | S104490 | GIRARD ST: BACON ST | - | F | F | - | F | 20638000 | 20638000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GIRARD ST | GIRARD ST | 2739 | 2739 | 37.727307121 | -122.404502634 | BACON ST \ GIRARD ST | BACON ST \ GIRARD ST | 1710539427000 | MTA | STOP | GIRARD ST intersection | - | 0 / 0 | - | - | - | - | - | 87819 | 2160000000 | -122.40459383 | 37.7273743 | - | - | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568960000 | BACON ST | - | - | - | - | - | - |
| 70704 | N/A | Point | - | - | - | - | S101480 | 9TH ST: HOWARD ST | - | F | F | - | F | 24305000 | 24305000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 9TH ST | 09TH ST | 2813 | 2813 | 37.77499069 | -122.413159768 | HOWARD ST \ 9TH ST | HOWARD ST \ 09TH ST | 1732142029000 | middleware_editor | ONE WAY (LA) | 09TH ST intersection | - | 0 / 0 | - | - | - | - | - | 87820 | -397267200000 | -122.41316111 | 37.77499175 | - | 1732112400000 | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | LIGHT POLE | IS | 1373566800000 | HOWARD ST | - | - | - | - | - | - |
| 70705 | N/A | Point | - | - | - | - | S103989 | ROLPH ST: PRAGUE ST | - | F | F | - | F | 21391000 | 21391000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ROLPH ST | ROLPH ST | 2830 | 2830 | 37.71175817 | -122.432545934 | PRAGUE ST \ ROLPH ST | PRAGUE ST \ ROLPH ST | 1710539427000 | MTA | STOP | ROLPH ST intersection | - | 0 / 00 | - | - | - | - | - | 87821 | -66700800000 | -122.43264607 | 37.71175817 | - | 1553126400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373568780000 | PRAGUE ST | - | - | - | - | - | - |
| 70706 | N/A | Point | - | - | - | - | S103990 | ROLPH ST: PRAGUE ST | - | F | F | - | F | 21391000 | 21391000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ROLPH ST | ROLPH ST | 2831 | 2831 | 37.711766657 | -122.432758723 | PRAGUE ST \ ROLPH ST | PRAGUE ST \ ROLPH ST | 1710539427000 | MTA | STOP | ROLPH ST intersection | - | 0 / 00 | - | - | - | - | - | 87822 | -66700800000 | -122.43264607 | 37.71175817 | - | 1553126400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568780000 | PRAGUE ST | - | - | - | - | - | - |
| 70707 | N/A | Point | - | - | - | - | S107852 | 47TH AVE: RIVERA ST | - | F | F | - | F | 23510000 | 23510000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | RIVERA ST | 47TH AVE | 2850 | 2850 | 37.745574425 | -122.506035716 | 47TH AVE \ RIVERA ST | RIVERA ST \ 47TH AVE | 1710539427000 | MTA | STOP | 47TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 87823 | 258768000000 | -122.50595817 | 37.74545666 | - | 1494892800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569980000 | RIVERA ST | - | - | - | - | - | - |
| 70708 | N/A | Point | - | - | - | - | S107853 | 47TH AVE: RIVERA ST | - | F | F | - | F | 23510000 | 23510000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | RIVERA ST | 47TH AVE | 2851 | 2851 | 37.745366574 | -122.505880147 | 47TH AVE \ RIVERA ST | RIVERA ST \ 47TH AVE | 1710539427000 | MTA | STOP | 47TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 87824 | 258768000000 | -122.50595817 | 37.74545666 | - | 1494892800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569980000 | RIVERA ST | - | - | - | - | - | - |
| 70709 | N/A | Point | - | - | - | - | S107605 | LAGUNA ST: WASHINGTON ST | - | F | F | - | F | 26558000 | 26558000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LAGUNA ST | WASHINGTON ST | 2878 | 2878 | 37.792140681 | -122.429369465 | WASHINGTON ST \ LAGUNA ST | LAGUNA ST \ WASHINGTON ST | 1710539427000 | MTA | STOP | WASHINGTON ST intersection | - | 0 / 0 | - | - | - | - | - | 87825 | 239932800000 | -122.42944719 | 37.7922169 | - | 1509580800000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569920000 | LAGUNA ST | - | - | - | - | - | - |
| 70710 | N/A | Point | 1 | 1 | 100 - 199 | - | S113511 | 100-199 EXCELSIOR AVE | 100-199 EXCELSIOR AVE | F | F | - | F | 5360000 | 5360000 | - | - | NORTH SIDE | - | - | - | - | LONDON ST | LONDON ST | 9179 | 9179 | 37.725806789 | -122.432614585 | - | - | 1710539427000 | MTA | NPPZ 9AM-10AM/3PM-4PM SCHL DAYS (LA) | LONDON ST to PARIS ST (100 - 199) | - | 73`EAST | - | - | - | - | - | 87826 | 990489600000 | -122.43245544 | 37.7256795 | - | - | - | D11 | - | OTHER REGULATORY | REG | R30(SF).0446 | 12X18 | SUP2 | 2IN IRON POST | IS | 1373571780000 | EXCELSIOR AVE | 100 - 199 EXCELSIOR AVE | 100 - 199 EXCELSIOR AVE | 100 EXCELSIOR AVE | - | PARIS ST | PARIS ST |
| 70711 | N/A | Point | 1 | 1 | 100 - 199 | - | S113512 | 100-199 EXCELSIOR AVE | 100-199 EXCELSIOR AVE | F | F | - | F | 5360000 | 5360000 | - | - | NORTH SIDE | - | - | - | - | LONDON ST | LONDON ST | 9180 | 9180 | 37.725835076 | -122.432661076 | - | - | 1710539427000 | MTA | NPPZ 9AM-10AM/3PM-4PM SCHL DAYS (RA) | LONDON ST to PARIS ST (100 - 199) | - | 55`EAST | - | - | - | - | - | 87827 | 990489600000 | -122.43245544 | 37.7256795 | - | - | - | D11 | - | OTHER REGULATORY | REG | R30(SF).0447 | 12X18 | SUP2 | 2IN IRON POST | IS | 1373571780000 | EXCELSIOR AVE | 100 - 199 EXCELSIOR AVE | 100 - 199 EXCELSIOR AVE | 100 EXCELSIOR AVE | - | PARIS ST | PARIS ST |
| 70712 | N/A | Point | - | - | - | - | S112183 | FILLMORE ST: WASHINGTON ST | - | F | F | - | F | 26649000 | 26649000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WASHINGTON ST | FILLMORE ST | 9390 | 9390 | 37.791549964 | -122.434342035 | FILLMORE ST \ WASHINGTON ST | WASHINGTON ST \ FILLMORE ST | 1710539427000 | MTA | STOP | FILLMORE ST intersection | - | - | - | - | - | - | - | 87828 | 932342400000 | -122.43438048 | 37.79159165 | - | 1557273600000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373571360000 | WASHINGTON ST | - | - | - | - | - | - |
| 70713 | N/A | Point | - | - | - | - | S112184 | FILLMORE ST: WASHINGTON ST | - | F | F | - | F | 26649000 | 26649000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WASHINGTON ST | FILLMORE ST | 9391 | 9391 | 37.79164252 | -122.434268721 | FILLMORE ST \ WASHINGTON ST | WASHINGTON ST \ FILLMORE ST | 1710539427000 | MTA | STOP | FILLMORE ST intersection | - | - | - | - | - | - | - | 87829 | 932342400000 | -122.43438048 | 37.79159165 | - | 1557273600000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | MUNI POLE | IS | 1373571360000 | WASHINGTON ST | - | - | - | - | - | - |
| 70714 | N/A | Point | - | - | - | - | S115659 | 17TH ST: MISSISSIPPI ST | - | F | T | - | F | 23675000 | 23675000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 17TH ST | MISSISSIPPI ST | 9403 | 9403 | 37.765187965 | -122.394960188 | MISSISSIPPI ST \ 17TH ST | 17TH ST \ MISSISSIPPI ST | 1725468922000 | middleware_editor | FREEWAY (RA) | MISSISSIPPI ST intersection | - | - | - | - | - | - | - | 87830 | 1037145600000 | -122.39482876 | 37.7652476 | - | 1725443100000 | - | D10 | - | OTHER GUIDE | GUIDE | G-F(SF).0054 | 48X16 | SUP1 | UTILITY POLE | IS | 1373572440000 | 17TH ST | - | - | - | - | - | - |
| 70715 | N/A | Point | - | - | - | - | S112131 | IRVING ST: 12TH AVE | - | F | F | - | F | 27171000 | 27171000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 12TH AVE | 12TH AVE | 11559 | 11559 | 37.763986057 | -122.469413778 | IRVING ST \ 12TH AVE | IRVING ST \ 12TH AVE | 1710539427000 | MTA | STOP | 12TH AVE intersection | - | - | - | - | - | - | - | 87831 | 918691200000 | -122.46952196 | 37.76389594 | - | 1471478400000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373571360000 | IRVING ST | - | - | - | - | - | - |
| 70716 | N/A | Point | 1 | 1 | 100 - 199 | - | S117775 | 100-199 DE HARO ST | 100-199 DE HARO ST | T | T | - | F | 4628000 | 4628000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | ALAMEDA ST | ALAMEDA ST | 11591 | 11591 | 37.7680685 | -122.40190243 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | ALAMEDA ST to 15TH ST (100 - 199) | - | 100' NORTH OF 15TH ST | - | - | - | - | - | 87832 | 1065571200000 | -122.40190243 | 37.7680685 | - | - | - | D10 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373573100000 | DE HARO ST | 100 - 199 DE HARO ST | 100 - 199 DE HARO ST | 100 DE HARO ST | - | 15TH ST | 15TH ST |
| 70717 | N/A | Point | - | - | - | - | S115571 | EXCELSIOR AVE: LONDON ST | - | F | F | - | F | 21760000 | 21760000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | EXCELSIOR AVE | EXCELSIOR AVE | 11655 | 11655 | 37.725882235 | -122.432731891 | LONDON ST \ EXCELSIOR AVE | LONDON ST \ EXCELSIOR AVE | 1710539427000 | MTA | ALL WAY | EXCELSIOR AVE intersection | - | - | - | - | - | - | - | 87833 | 1034812800000 | -122.43285706 | 37.72587092 | - | 1685664000000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572380000 | LONDON ST | - | - | - | - | - | - |
| 70718 | N/A | Point | - | - | - | - | S115575 | LONDON ST: EXCELSIOR AVE | - | F | F | - | F | 21760000 | 21760000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | EXCELSIOR AVE | EXCELSIOR AVE | 11658 | 11658 | 37.725986894 | -122.43288567 | LONDON ST \ EXCELSIOR AVE | LONDON ST \ EXCELSIOR AVE | 1710539427000 | MTA | ALL WAY | EXCELSIOR AVE intersection | - | - | - | - | - | - | - | 87834 | 1034812800000 | -122.43285706 | 37.72587092 | - | 1685664000000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572380000 | LONDON ST | - | - | - | - | - | - |
| 70719 | N/A | Point | - | - | - | - | S115576 | LONDON ST: EXCELSIOR AVE | - | F | F | - | F | 21760000 | 21760000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | EXCELSIOR AVE | EXCELSIOR AVE | 11659 | 11659 | 37.725790303 | -122.432830238 | LONDON ST \ EXCELSIOR AVE | LONDON ST \ EXCELSIOR AVE | 1710539427000 | MTA | ALL WAY | EXCELSIOR AVE intersection | - | - | - | - | - | - | - | 87835 | 1034812800000 | -122.43285706 | 37.72587092 | - | 1685664000000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572380000 | LONDON ST | - | - | - | - | - | - |
| 70720 | N/A | Point | - | - | - | - | S114467 | ALEMANY BLVD: GENEVA AVE | - | F | F | - | F | 22052000 | 22052000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ALEMANY BLVD | GENEVA AVE | 11769 | 11769 | 37.717667956 | -122.442342465 | GENEVA AVE \ ALEMANY BLVD | ALEMANY BLVD \ GENEVA AVE | 1710539427000 | MTA | COW PALACE (RA) | GENEVA AVE intersection | - | - | - | - | - | - | - | 87836 | 1006992000000 | -122.44232816 | 37.71783345 | - | - | - | D11 | - | OTHER GUIDE | GUIDE | G-C(SF).0069 | 48X18 | SUP2 | LIGHT POLE | IS | 1373572080000 | ALEMANY BLVD | - | - | - | - | - | - |
| 70721 | N/A | Point | - | - | - | - | S117228 | NAPLES ST: AMAZON AVE | - | F | F | - | F | 21412000 | 21412000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | AMAZON AVE | NAPLES ST | 11901 | 11901 | 37.715290642 | -122.435340336 | NAPLES ST \ AMAZON AVE | AMAZON AVE \ NAPLES ST | 1710539427000 | MTA | ALL WAY | NAPLES ST intersection | - | - | - | - | - | - | - | 87837 | 1057968000000 | -122.4353457 | 37.71537905 | - | 1591315200000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572920000 | AMAZON AVE | - | - | - | - | - | - |
| 70722 | N/A | Point | 1 | 1 | 1400 - 1449 | - | S121963 | 1400-1425 SANCHEZ ST | 1400-1449 SANCHEZ ST | F | F | - | F | 11535000 | 11535000 | - | - | EAST SIDE | - | - | - | - | 27TH ST | 27TH ST | 14135 | 14135 | 37.746224692 | -122.429068219 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "Z" PERMITS | 27TH ST to DUNCAN ST (1400 - 1449) | - | SPL #1423/#1425 | - | - | - | - | - | 87838 | 1130889600000 | -122.42915472 | 37.74636149 | - | 1702550151000 | - | D8 | - | PARKING:RPP | REG | R32C(CA).0107 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373574420000 | SANCHEZ ST | 1400 - 1449 SANCHEZ ST | 1400 - 1449 SANCHEZ ST | 1400 SANCHEZ ST | - | DUNCAN ST | DUNCAN ST |
| 70723 | N/A | Point | - | - | - | - | S116038 | MISSISSIPPI ST: 17TH ST | - | F | F | - | F | 23675000 | 23675000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 17TH ST | MISSISSIPPI ST | 14198 | 14198 | 37.765165701 | -122.394750641 | MISSISSIPPI ST \ 17TH ST | 17TH ST \ MISSISSIPPI ST | 1721159709000 | middleware_editor | TRUCK ROUTE (LA VA) | MISSISSIPPI ST intersection | - | ABOVE R1 | - | - | - | - | - | 87839 | 1044403200000 | -122.39482876 | 37.7652476 | - | - | 1716372000000 | D10 | - | OTHER REGULATORY | REG | R14-1(CA).0006 | 24X24 | SUP1 | 2IN IRON POST | RETD | 1373572560000 | 17TH ST | - | - | - | - | - | - |
| 70724 | N/A | Point | - | - | - | - | S116699 | PERSIA AVE: LISBON ST | - | F | F | - | F | 21719000 | 21719000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PERSIA AVE | LISBON ST | 14325 | 14325 | 37.721997391 | -122.43348117 | LISBON ST \ PERSIA AVE | PERSIA AVE \ LISBON ST | 1710539427000 | MTA | ALL WAY | LISBON ST intersection | - | - | - | - | - | - | - | 87840 | 1052179200000 | -122.43360634 | 37.72200022 | - | 1570492800000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572740000 | PERSIA AVE | - | - | - | - | - | - |
| 70725 | N/A | Point | - | - | - | - | S116701 | LISBON ST: PERSIA AVE | - | F | F | - | F | 21719000 | 21719000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PERSIA AVE | LISBON ST | 14326 | 14326 | 37.722091449 | -122.433631374 | LISBON ST \ PERSIA AVE | PERSIA AVE \ LISBON ST | 1710539427000 | MTA | ALL WAY | LISBON ST intersection | - | - | - | - | - | - | - | 87841 | 1052179200000 | -122.43360634 | 37.72200022 | - | 1570492800000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572740000 | PERSIA AVE | - | - | - | - | - | - |
Download data as a comma-separated values file with coordinates and properties.
Download CSVDownload data in GeoJSON format, compatible with most GIS applications.
Download GeoJSONDownload data in KML format for use with Google Earth and other mapping applications.
Download KMLDownload data as a shapefile (ZIP format) for use with ArcGIS and other GIS software.
Download ShapefileGet detailed information about this dataset including metadata and available properties.
page - Page number (default: 1)limit - Results per page (max: 1000, default: 100)properties - JSON object for property filteringgeometry_type - Filter by geometry type (Point, LineString, Polygon, etc.)bbox - Bounding box (minX,minY,maxX,maxY)lat - Center latitude for radius searchlon - Center longitude for radius searchradius - Search radius in meters