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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 69001 | N/A | Point | - | - | - | - | S240736 | PALMETTO AVE: OCEANVIEW TER \ | - | F | F | - | F | 22517000 | 22517000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | PALMETTO AVE \ RAMSELL ST \ WORCESTER AVE | PALMETTO AVE \ RAMSELL ST \ WORCESTER AVE | 124844 | 124844 | 37.71068225 | -122.4661607 | OCEANVIEW TER \ PALMETTO AVE \ RAMSELL ST \ WORCESTER AVE | OCEANVIEW TER \ PALMETTO AVE \ RAMSELL ST \ WORCESTER AVE | 1710539427000 | MTA | STOP | PALMETTO AVE \ RAMSELL ST \ WORCESTER AVE intersection | - | OCEANVIEW TERR AND PALMETTO | - | - | - | - | - | 86117 | 105753600000 | -122.4661607 | 37.71068225 | - | 1517184000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1511264340000 | OCEANVIEW TER | - | - | - | - | - | - |
| 69002 | N/A | Point | - | - | - | - | S243541 | MARKET ST: SOUTH VAN NESS AVE | - | T | T | - | F | 30748000 | 30748000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SOUTH VAN NESS AVE \ VAN NESS AVE | SOUTH VAN NESS AVE \ VAN NESS AVE | 124846 | 124846 | 37.77514707 | -122.41925561 | MARKET ST \ SOUTH VAN NESS AVE \ VAN NESS AVE | MARKET ST \ SOUTH VAN NESS AVE \ VAN NESS AVE | 1710539427000 | MTA | NO LEFT TURN (SYM) | SOUTH VAN NESS AVE \ VAN NESS AVE intersection | - | - | - | - | - | - | - | 86118 | - | -122.41925561 | 37.77514707 | - | - | - | D6 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1520424540000 | MARKET ST | - | - | - | - | - | - |
| 69003 | N/A | Point | - | - | - | - | S240183 | DUBOCE AVE: BUENA VISTA AVE \ | - | F | F | - | F | 26021000 | 26021000 | - | - | NORTH EAST CORNER | - | - | - | - | BUENA VISTA AVE \ DUBOCE AVE | BUENA VISTA AVE \ DUBOCE AVE | 124847 | 124847 | 37.7690066 | -122.43833833 | BUENA VISTA TER \ BUENA VISTA AVE \ DUBOCE AVE | BUENA VISTA TER \ BUENA VISTA AVE \ DUBOCE AVE | 1710539427000 | MTA | DUBOCE AVE | BUENA VISTA AVE \ DUBOCE AVE intersection | - | DUBOCE AVE & BUENA VISTA EAST | - | - | - | - | - | 86119 | 1516707000000 | -122.43833833 | 37.7690066 | - | 1516665600000 | - | D8 | - | STREET NAME | GUIDE | D3-1.0563 | 36X08 | SUP2 | LIGHT POLE | IS | 1509706680000 | BUENA VISTA TER | - | - | - | - | - | - |
| 69004 | N/A | Point | - | - | - | - | S280911 | FREDERICK ST: ARGUELLO BLVD \ | - | F | F | - | F | 27178000 | 27178000 | - | - | NORTH EAST CORNER | - | - | - | - | ARGUELLO BLVD \ FREDERICK ST | ARGUELLO BLVD \ FREDERICK ST | 124848 | 124848 | 37.76601477 | -122.45778962 | LINCOLN WAY \ ARGUELLO BLVD \ FREDERICK ST | LINCOLN WAY \ ARGUELLO BLVD \ FREDERICK ST | 1710539427000 | MTA | COMMEMORATIVE/POLYTECHNIC WAY | ARGUELLO BLVD \ FREDERICK ST intersection | - | - | - | - | - | - | - | 86120 | - | -122.45778962 | 37.76601477 | - | - | - | D5 | - | OTHER MISC | MISC | D(SF).0003 | 36X08 | SUP1 | LIGHT POLE | IS | 1644923880000 | LINCOLN WAY | - | - | - | - | - | - |
| 69005 | N/A | Point | - | - | - | - | S254606 | SAN JOSE AVE: FARALLONES ST \ | - | F | F | - | F | 21592000 | 21592000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FARALLONES ST \ WHIPPLE AVE | FARALLONES ST \ WHIPPLE AVE | 124849 | 124849 | 37.71410376 | -122.45217408 | SAN JOSE AVE \ FARALLONES ST \ WHIPPLE AVE | SAN JOSE AVE \ FARALLONES ST \ WHIPPLE AVE | 1710539427000 | MTA | PEDESTRIAN (SYM) | FARALLONES ST \ WHIPPLE AVE intersection | - | ON NEW SIGNAL POLE CROSS IS FARALLONES | - | - | - | - | - | 86121 | 1572393600000 | -122.45217408 | 37.71410376 | - | - | - | D11 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | SIGNAL POLE | IS | 1558687140000 | SAN JOSE AVE | - | - | - | - | - | - |
| 69006 | N/A | Point | - | - | - | - | S102156 | OTIS ST: 12TH ST \ MISSION ST | - | F | F | - | F | 24388000 | 24388000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE | 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE | 124850 | 124850 | 37.77305345 | -122.41861822 | MISSION ST \ 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE | MISSION ST \ 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE | 1710539427000 | MTA | ONE WAY (RA) | 12TH ST \ OTIS ST \ SOUTH VAN NESS AVE intersection | - | 0 / 0 | - | - | - | - | - | 86122 | -391824000000 | -122.41861822 | 37.77305345 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373568240000 | MISSION ST | - | - | - | - | - | - |
| 69007 | N/A | Point | - | - | - | - | S226491 | DIVISADERO ST: CLAY ST | - | T | T | - | F | 26824000 | 26824000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CLAY ST | DIVISADERO ST | 124851 | 124851 | 37.7898723 | -122.44080557 | DIVISADERO ST \ CLAY ST | CLAY ST \ DIVISADERO ST | 1722303134000 | middleware_editor | NO TRUCKS (SYM) OVER 9 TONS | DIVISADERO ST intersection | - | +"4 BLOCKS AHEAD" | - | - | - | - | - | 86123 | 1349913600000 | -122.44080557 | 37.7898723 | - | 1469145600000 | - | D2 | - | OTHER REGULATORY | REG | R5-2.0013 | 36X36 | SUP1 | LIGHT POLE | IS | 1465563720000 | CLAY ST | - | - | - | - | - | - |
| 69008 | N/A | Point | 1 | 1 | 300 - 399 | - | S119596 | 300-399 CAPP ST | 300-399 CAPP ST | F | F | - | F | 3675000 | 3675000 | - | - | WEST SIDE | - | - | - | - | 18TH ST | 18TH ST | 129964 | 129964 | 37.76110132 | -122.41819472 | - | - | 1715700696000 | middleware_editor | NPRK 8AM-10AM TUE FRI STCL | 18TH ST to 19TH ST (300 - 399) | - | NPL #392 | - | - | - | - | - | 86124 | 1098144000000 | -122.41819472 | 37.76110132 | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0268 | 18X18 | SUP2 | 2IN IRON POST | IS | 1373573700000 | CAPP ST | 300 - 399 CAPP ST | 300 - 399 CAPP ST | 300 CAPP ST | - | 19TH ST | 19TH ST |
| 69009 | N/A | Point | 1 | 1 | 700 - 799 | - | S120604 | 700-799 CLEMENT ST | 700-799 CLEMENT ST | F | F | - | F | 4157000 | 4157000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | 8TH AVE | 08TH AVE | 129965 | 129965 | 37.78282583 | -122.46709588 | - | - | 1710539427000 | MTA | SCHOOL (SYM) AHEAD | 08TH AVE to 09TH AVE (700 - 799) | - | WPL#718 | - | - | - | - | - | 86125 | 1110844800000 | -122.46709588 | 37.78282583 | - | - | - | D1 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1373574000000 | CLEMENT ST | 700 - 799 CLEMENT ST | 700 - 799 CLEMENT ST | 700 CLEMENT ST | - | 09TH AVE | 09TH AVE |
| 69010 | N/A | Point | 1 | 1 | 1 - 199 | - | S118612 | 1-199 PHELAN AVE | 1-199 FRIDA KAHLO WAY | F | F | - | F | - | 10390000 | - | SHOULD BE RETIRED | WEST SIDE, WESTBOUND TRAFFIC | - | - | - | - | - | GENEVA AVE \ OCEAN AVE | 129966 | 129966 | 37.72569285 | -122.45235638 | - | - | 1746135179000 | middleware_editor | NO LEFT TURN (SYM) 7AM-12PM | GENEVA AVE \ OCEAN AVE to JUDSON AVE (1 - 199) | - | N-LINE OF DRIVEWAY OF CCSF OPPOSITE..... | - | - | - | - | - | 86126 | 1080630000000 | -122.45235638 | 37.72569285 | - | - | - | D7 | - | NO LEFT TURN | REG | R33(CA).0021 | 24X36 | SUP2 | 2IN IRON POST | RETD | 1373573340000 | FRIDA KAHLO WAY | - | 1 - 199 FRIDA KAHLO WAY | 1 FRIDA KAHLO WAY | - | - | JUDSON AVE |
| 69011 | N/A | Point | 1 | 1 | 400 - 499 | - | S121288 | 400-499 FRANCISCO ST | 400-499 FRANCISCO ST | F | F | - | F | 5761000 | 5761000 | - | - | NORTH SIDE | - | - | - | - | POWELL ST | POWELL ST | 129967 | 129967 | 37.80479009 | -122.41259752 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM WED STCL | POWELL ST to MASON ST (400 - 499) | - | EAST LINE OF ENT # 444 | - | - | - | - | - | 86127 | 1121212800000 | -122.41259752 | 37.80479009 | - | - | - | D3 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373574240000 | FRANCISCO ST | 400 - 499 FRANCISCO ST | 400 - 499 FRANCISCO ST | 400 FRANCISCO ST | - | MASON ST | MASON ST |
| 69012 | N/A | Point | - | - | - | - | S256300 | MISSION ST: WHIPPLE AVE | - | F | F | - | F | 21540000 | 21540000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MISSION ST \ WHIPPLE ST | WHIPPLE AVE \ WHIPPLE ST | 129968 | 129968 | 37.71074852 | -122.44767244 | WHIPPLE AVE \ MISSION ST \ WHIPPLE ST | MISSION ST \ WHIPPLE AVE \ WHIPPLE ST | 1710539427000 | MTA | (45 LA-DN) | WHIPPLE AVE \ WHIPPLE ST intersection | - | - | - | - | - | - | - | 86128 | 1572965100000 | -122.44767244 | 37.71074852 | - | - | - | D11 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP2 | SIGNAL POLE | IS | 1563786120000 | MISSION ST | - | - | - | - | - | - |
| 69013 | N/A | Point | - | - | - | - | S254951 | CONSERVATORY ACCESS RD: END | - | F | F | - | F | 27190000 | 27190000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CONSERVATORY ACCESS RD | CONSERVATORY ACCESS RD | 129970 | 129970 | 37.77245614 | -122.45876428 | CONSERVATORY ACCESS RD \ CONSERVATORY ACCESS RD | CONSERVATORY ACCESS RD \ CONSERVATORY ACCESS RD | 1710539427000 | MTA | BIKE WAYFINDING SIGN | CONSERVATORY ACCESS RD intersection | 1059 | CONSERVATORY DR WEST AND ARGUELLO | - | - | - | - | - | 86129 | 1570459140000 | -122.45876428 | 37.77245614 | - | - | - | D1 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | 2IN IRON POST | IS | 1559564700000 | CONSERVATORY ACCESS RD | - | - | - | - | - | - |
| 69014 | N/A | Point | - | - | - | - | S109996 | GOETTINGEN ST: MANSELL ST | - | F | F | - | F | 20589000 | 20589000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MANSELL ST | GOETTINGEN ST | 129971 | 129971 | 37.72076685 | -122.40401775 | GOETTINGEN ST \ MANSELL ST | MANSELL ST \ GOETTINGEN ST | 1716427497000 | middleware_editor | STOP | GOETTINGEN ST intersection | - | - | - | - | - | - | - | 86130 | 579225600000 | -122.40401775 | 37.72076685 | - | 1344297600000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 3IN IRON POST | IS | 1373570640000 | MANSELL ST | - | - | - | - | - | - |
| 69015 | N/A | Point | - | - | - | - | S110181 | SEARS ST: SICKLES AVE | - | F | F | - | F | 21583000 | 21583000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SICKLES AVE | SICKLES AVE | 129972 | 129972 | 37.70967877 | -122.45388758 | SEARS ST \ SICKLES AVE | SEARS ST \ SICKLES AVE | 1754577483000 | middleware_editor | STOP | SICKLES AVE intersection | - | - | - | - | - | - | - | 86131 | 601804800000 | -122.45388758 | 37.70967877 | - | 1661324400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570700000 | SEARS ST | - | - | - | - | - | - |
| 69016 | N/A | Point | - | - | - | - | S110208 | KEARNY ST: BAY ST | - | F | F | - | F | 25384000 | 25384000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BAY ST | BAY ST | 129973 | 129973 | 37.80642781 | -122.40714628 | KEARNY ST \ BAY ST | KEARNY ST \ BAY ST | 1710539427000 | MTA | ONE WAY (LA) | BAY ST intersection | - | 0 / MADE ONE-WAY NB | - | - | - | - | - | 86132 | 602294400000 | -122.40714628 | 37.80642781 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | SIGNAL POLE | IS | 1373570760000 | KEARNY ST | - | - | - | - | - | - |
| 69017 | N/A | Point | - | - | - | - | S110238 | BYXBEE ST: SHIELDS ST | - | F | F | - | F | 22721000 | 22721000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BYXBEE ST | BYXBEE ST | 129974 | 129974 | 37.71788816 | -122.46983763 | SHIELDS ST \ BYXBEE ST | SHIELDS ST \ BYXBEE ST | 1710539427000 | MTA | STOP | BYXBEE ST intersection | - | 0 / 0 | - | - | - | - | - | 86133 | 607737600000 | -122.46983763 | 37.71788816 | - | 1587340800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570760000 | SHIELDS ST | - | - | - | - | - | - |
| 69018 | N/A | Point | - | - | - | - | S109138 | HYDE ST: BAY ST | - | F | F | - | F | 25577000 | 25577000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BAY ST | BAY ST | 129975 | 129975 | 37.80479031 | -122.42017813 | HYDE ST \ BAY ST | HYDE ST \ BAY ST | 1715006365000 | middleware_editor | ONE WAY (RA) | BAY ST intersection | - | 0 / CABLE CAR CONSTRUCTION | - | - | - | - | - | 86134 | 404265600000 | -122.42017813 | 37.80479031 | - | - | - | D2 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | 2IN IRON POST | IS | 1373570400000 | HYDE ST | - | - | - | - | - | - |
| 69019 | N/A | Point | - | - | - | - | S111892 | SPRUCE ST: MAYFAIR DR | - | F | F | - | F | 12062000 | 26944000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | SPRUCE ST | 129976 | 129976 | 37.78572237 | -122.45325549 | - | MAYFAIR DR \ SPRUCE ST | 1737558949000 | middleware_editor | STOP | SPRUCE ST intersection | - | - | - | - | - | - | - | 86135 | 874368000000 | -122.45325549 | 37.78572237 | - | 1737474240000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373571240000 | MAYFAIR DR | 500 - 528 SPRUCE ST | - | - | - | MAYFAIR DR | - |
| 69020 | N/A | Point | - | - | - | - | S112198 | DETROIT ST: MANGELS AVE | - | F | F | - | F | 22273000 | 22273000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DETROIT ST | DETROIT ST | 129977 | 129977 | 37.73308769 | -122.4443204 | MANGELS AVE \ DETROIT ST | MANGELS AVE \ DETROIT ST | 1738175967000 | middleware_editor | STOP | DETROIT ST intersection | - | - | - | - | - | - | - | 86136 | 932342400000 | -122.4443204 | 37.73308769 | - | 1610323200000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571360000 | MANGELS AVE | - | - | - | - | - | - |
| 69021 | N/A | Point | - | - | - | - | S113532 | MASON ST: BROADWAY | - | F | F | - | F | 25115000 | 25115000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MASON ST | BROADWAY | 129978 | 129978 | 37.79713219 | -122.41188814 | BROADWAY \ MASON ST | MASON ST \ BROADWAY | 1750690059000 | middleware_editor | STOP | BROADWAY intersection | - | @ PM | - | - | - | - | - | 86137 | 991206000000 | -122.41188814 | 37.79713219 | - | 1595228400000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373571780000 | MASON ST | - | - | - | - | - | - |
| 69022 | N/A | Point | - | - | - | - | S110265 | LELAND AVE: PEABODY ST | - | F | F | - | F | 20347000 | 20347000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LELAND AVE | LELAND AVE | 129979 | 129979 | 37.71228275 | -122.4065286 | PEABODY ST \ LELAND AVE | PEABODY ST \ LELAND AVE | 1710539427000 | MTA | DO NOT ENTER | LELAND AVE intersection | - | TO 199 / MAKE ONE WAY WB/CONSTR/DPW #151 | - | - | - | - | - | 86138 | 610934400000 | -122.4065286 | 37.71228275 | - | - | - | D10 | - | OTHER REGULATORY | REG | R5-1.0002 | 24X24 | SUP1 | UNKNOWN | IS | 1373570760000 | PEABODY ST | - | - | - | - | - | - |
| 69023 | N/A | Point | - | - | - | - | S109453 | 15TH AVE: RIVERA ST | - | F | F | - | F | 23000000 | 23000000 | - | - | SOUTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 15TH AVE | RIVERA ST | 129981 | 129981 | 37.74698422 | -122.47131912 | RIVERA ST \ 15TH AVE | 15TH AVE \ RIVERA ST | 1733237972000 | middleware_editor | STOP | RIVERA ST intersection | - | 0 / MAKE ONE WAY NORTHBOUND WAY NOR..... | - | - | - | - | - | 86139 | 489628800000 | -122.47131912 | 37.74698422 | - | 1733139000000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570520000 | 15TH AVE | - | - | - | - | - | - |
| 69024 | N/A | Point | - | - | - | - | S227347 | - | - | F | F | - | F | 9112000 | - | - | - | WEST SIDE | 1689201376000 | MTA | - | - | - | - | 131256 | 131256 | 37.76957775 | -122.42012139 | - | - | 1715218867000 | middleware_editor | BIKE RACK | - | 20154832 | 25 FT SOUTH OF NPL#1710 - 3`6" FROM CRUB | - | - | - | - | - | 86140 | 1470657720000 | - | - | - | 1470614400000 | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | - | - | 1700 - 1750 MISSION ST | - | - | - | - | - |
| 69025 | N/A | Point | - | - | - | - | S255217 | - | - | F | F | - | F | 11963101 | - | - | - | CENTER ISLAND | 1689201376000 | MTA | - | - | 45TH AVE | - | 131257 | 131257 | 37.73555571 | -122.50474279 | - | - | 1711051304000 | evillan | NPRK 5AM-7AM EVERYDAY INCL HOLIDAY STCL | - | - | 120FT WEST | - | - | - | - | - | 86141 | 1560505200000 | - | - | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0154 | 18X18 | SUP2 | LIGHT POLE | IS | - | - | 2701 - 2899 SLOAT BLVD | - | - | - | 47TH AVE | - |
| 69026 | N/A | Point | - | - | - | - | S221489 | - | - | F | F | - | F | 2161000 | - | - | - | EAST SIDE | 1689201376000 | MTA | - | - | - | - | 131258 | 131258 | 37.72951483 | -122.4336499 | - | - | 1710539427000 | MTA | NPRK 7AM-9AM FRI STCL | - | - | IFO#1315 | - | - | - | - | - | 86142 | - | - | - | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0235 | 18X18 | SUP2 | 2IN IRON POST | IS | - | - | 1301 - 1399 ALEMANY BLVD | - | - | - | - | - |
| 69027 | N/A | Point | - | - | - | - | S238892 | - | - | F | F | - | F | 10669000 | - | - | - | EAST SIDE | 1689201376000 | MTA | - | - | - | - | 131259 | 131259 | 37.75536319 | -122.40661026 | - | - | 1731971318000 | middleware_editor | TANSAT | - | - | 104' NORTH OF 23RD ST | - | - | - | - | - | 86143 | 1505913420000 | - | - | - | 1505865600000 | - | D9 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP2 | LIGHT POLE | IS | - | - | 1000 - 1098 POTRERO AVE | - | - | - | - | - |
| 69028 | N/A | Point | - | - | - | - | S236527 | - | - | F | F | - | F | 12561000 | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131260 | 131260 | 37.80773312 | -122.40818257 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | - | - | - | - | - | - | - | - | 86144 | 1496102400000 | - | - | - | 1496361600000 | - | D3 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | LIGHT POLE | IS | - | - | 1501 - 1599 THE EMBARCADERO | - | - | - | - | - |
| 69029 | N/A | Point | - | - | - | DOWN ARROW | S237788 | - | - | F | F | - | F | 6128000 | - | - | - | NORTH SIDE | 1689201376000 | MTA | - | - | - | - | 131261 | 131261 | 37.72188461 | -122.44972686 | - | - | 1710539427000 | MTA | TA (SYM) PLO 7:30AM-8:30AM/2:30PM-6PM SCHOOL DAYS (5 MIN) | - | - | 25FT WEST OF LOUISBURG | - | - | - | - | - | 86145 | 1501845600000 | - | - | - | 1501804800000 | - | D11 | - | OTHER REGULATORY | REG | R38(SF)6.0054 | 14X21 | SUP2 | 2IN IRON POST | IS | - | - | 100 - 198 GENEVA AVE | - | - | - | - | - |
| 69030 | N/A | Point | - | - | - | RIGHT ARROW | S285323 | - | - | F | F | - | F | 155270019 | - | - | - | WEST SIDE | 1689201376000 | MTA | - | - | - | - | 131262 | 131262 | 37.78545158 | -122.42140517 | - | - | 1710539427000 | MTA | TA (SYM) PLO AT ALL TIMES (5 MIN) H/C (SYM) | - | - | 16' NORTH OF MYRTLE ST. | - | - | - | - | - | 86146 | 1665446400000 | - | - | - | - | - | D5 | - | OTHER REGULATORY | REG | R38(SF)1.0152 | 14X21 | SUP1 | 2IN IRON POST | IS | - | - | 1015 - 1099 VAN NESS AVE | - | - | - | - | - |
| 69031 | N/A | Point | - | - | - | - | S216197 | - | - | F | F | - | F | 2489000 | - | - | - | NORTH SIDE | 1689201376000 | MTA | - | - | - | - | 131264 | 131264 | 37.7480926 | -122.41925067 | - | - | 1727186364000 | middleware_editor | NPRK 6AM-8AM TUE THUR STCL | - | - | IFO #3458 WEST OF BARTLETT ST | - | - | - | - | - | 86147 | 1433772780000 | - | - | - | 1433721600000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0195 | 18X18 | SUP2 | 2IN IRON POST | IS | - | - | 3401 - 3499 CESAR CHAVEZ ST | - | - | - | - | - |
| 69032 | N/A | Point | - | - | - | - | S278119 | - | - | F | F | - | F | 155270014 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131265 | 131265 | 37.73554803 | -122.50362691 | - | - | 1754505818000 | middleware_editor | YIELD HERE TO PED (SYM) (LA) | - | - | 35'EAST OF 46TH AVE. | - | - | - | - | - | 86148 | - | - | - | - | - | - | D7 | - | PEDESTRIAN | REG | R1-5.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | - | - | 2700 - 2798 SLOAT BLVD | - | - | - | - | - |
| 69033 | N/A | Point | - | - | - | - | S277765 | - | - | F | F | - | F | 8749000 | - | - | - | SOUTH SIDE | 1689201376000 | MTA | - | - | - | - | 131266 | 131266 | 37.78273169 | -122.40958718 | - | - | 1738878999000 | middleware_editor | BIKE RACK | - | - | EPL 995/ 8' IN FROM CURB | - | - | - | - | - | 86149 | - | - | - | - | 1684972800000 | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | - | - | 943 - 999 MARKET ST | - | - | - | - | - |
| 69034 | N/A | Point | - | - | - | - | S209471 | - | - | F | F | - | F | 9173000 | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131369 | 131369 | 37.71967616 | -122.43862356 | - | - | 1726762190000 | middleware_editor | YIELD HERE TO PED (SYM) (LA) | - | - | 25`SOUTH OPP.(NEW SHARK TEETH) | - | - | - | - | - | 86150 | 1125532800000 | - | - | - | - | 1726562700000 | D11 | - | PEDESTRIAN | REG | R1-5.0002 | 30X30 | SUP2 | 2IN IRON POST | RETD | - | - | 4900 - 4950 MISSION ST | - | - | - | - | - |
| 69035 | N/A | Point | - | - | - | - | S209555 | - | - | F | F | - | F | 9281000 | - | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131370 | 131370 | 37.73137962 | -122.45533326 | - | - | 1735942230000 | middleware_editor | YIELD HERE TO PED (SYM) (RA) | - | - | 5 FT WEST OF HAZELWOOD | - | - | - | - | - | 86151 | 1224806400000 | - | - | - | 1735914000000 | - | D7 | - | PEDESTRIAN | REG | R1-5.0003 | 30X30 | SUP2 | 2IN IRON POST | IS | - | - | 851 - 899 MONTEREY BLVD | - | - | - | - | - |
| 69036 | N/A | Point | - | - | - | - | S211939 | - | - | F | F | - | F | 6437000 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131371 | 131371 | 37.74817974 | -122.50781822 | - | - | 1713298193000 | middleware_editor | OBSOLETE GUIDE SIGNS | - | - | 152`WEST OF SKYLINE | - | - | - | - | - | 86152 | - | - | - | - | - | - | D7 | - | OTHER GUIDE | GUIDE | G-O(SF).0003 | 36X30 | SUP2 | LIGHT POLE | IS | - | - | 2000 - 2099 GREAT HWY | - | - | - | - | - |
| 69037 | N/A | Point | - | - | - | - | S208344 | - | - | F | F | - | F | 11437000 | - | - | - | EAST SIDE | 1689201376000 | MTA | - | - | - | - | 131372 | 131372 | 37.743106 | -122.42291592 | - | - | 1745939592000 | middleware_editor | NPRK 9AM-11AM FRI STCL | - | - | 230' SOUTH OF 29TH ST | - | - | - | - | - | 86153 | 1234425600000 | - | - | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0298 | 18X18 | SUP2 | 2IN IRON POST | IS | - | - | 701 - 799 SAN JOSE AVE | - | - | - | - | - |
| 69038 | N/A | Point | - | - | - | - | S148633 | - | - | F | F | - | F | 9281000 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131373 | 131373 | 37.73137962 | -122.45533326 | - | - | 1710539427000 | MTA | NPRK 1PM-3PM 2ND & 4TH MON OF MONTH STCL | - | - | 25`EAST (#32 ON LIST) | - | - | - | - | - | 86154 | 1224806400000 | - | - | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0099 | 18X18 | SUP2 | 2IN IRON POST | IS | - | - | 851 - 899 MONTEREY BLVD | - | - | - | - | - |
| 69039 | N/A | Point | - | - | - | - | S245559 | - | - | F | F | - | F | 8843000 | - | - | - | WEST SIDE | 1689201376000 | MTA | - | - | - | - | 131609 | 131609 | 37.78173382 | -122.4475608 | - | - | 1710539427000 | MTA | TANSAT | - | - | 90'S OF GEARY | - | - | - | - | - | 86155 | 1412035200000 | - | - | - | 1527206400000 | - | D1 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | LIGHT POLE | IS | - | - | 5 - 99 MASONIC AVE | - | - | - | - | - |
| 69040 | N/A | Point | - | - | - | - | S283158 | - | - | F | F | - | F | 27819000 | - | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | 1689201376000 | MTA | - | - | SUNSET BLVD | - | 131753 | 131753 | 37.76409681 | -122.49604244 | MARTIN LUTHER KING JR DR \ SUNSET BLVD | - | 1730923457000 | middleware_editor | PEDESTRIAN (SYM) | - | - | 30 FT SOUTH OF MARTIN LUTHER KING | - | - | - | - | - | 86156 | 1656460800000 | - | - | - | - | - | D4 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | LIGHT POLE | IS | - | - | - | - | - | - | - | - |
| 69041 | N/A | Point | - | - | - | - | S124500 | - | - | F | F | - | F | 9173000 | - | - | SHOULD BE RETIRED | EAST SIDE | 1689201376000 | MTA | - | - | - | - | 131756 | 131756 | 37.71967616 | -122.43862356 | - | - | 1746135001000 | middleware_editor | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | - | - | SPL OF #4949 | - | - | - | - | - | 86157 | 1153119600000 | - | - | - | - | - | D11 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP2 | LIGHT POLE | RETD | - | - | 4900 - 4950 MISSION ST | - | - | - | - | - |
| 69042 | N/A | Point | - | - | - | - | S123737 | - | - | F | F | - | F | 2161000 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1689201376000 | MTA | - | - | - | - | 131757 | 131757 | 37.72951483 | -122.4336499 | - | - | 1727312901000 | middleware_editor | BIKE (SYM) LANE | - | - | 10' EAST OF TINGLEY ABOVE BIKE RTE 70 | - | - | - | - | - | 86158 | 1147737600000 | - | - | - | - | - | D11 | - | BIKE REG | REG | R81(CA).0002 | 24X18 | SUP2 | 2IN IRON POST | IS | - | - | 1301 - 1399 ALEMANY BLVD | - | - | - | - | - |
| 69043 | N/A | Point | 1 | 1 | 900 - 999 | - | S252660 | 900-999 MOSCOW ST | 900-999 MOSCOW ST | F | F | - | F | 9405000 | 9405000 | - | - | WEST SIDE | - | - | - | - | AMAZON AVE | AMAZON AVE | 91275 | 91275 | 37.713806096 | -122.433348213 | - | - | 1710539427000 | MTA | NPRK 11AM-1PM THUR STCL | AMAZON AVE to GENEVA AVE \ SOUTH HILL BLVD (900 - 999) | - | SPL 954 | - | - | - | - | - | 86159 | 1525910400000 | -122.4332597 | 37.71379867 | - | 1577059200000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0028 | 18X18 | SUP2 | LIGHT POLE | IS | 1553071200000 | MOSCOW ST | 900 - 999 MOSCOW ST | 900 - 999 MOSCOW ST | 900 MOSCOW ST | - | GENEVA AVE \ SOUTH HILL BLVD | GENEVA AVE \ SOUTH HILL BLVD |
| 69044 | N/A | Point | 1 | 1 | 200 - 299 | - | S270387 | 200-299 CALIFORNIA ST | 200-299 CALIFORNIA ST | F | F | - | F | 3526000 | 3526000 | - | - | SOUTH SIDE | - | - | - | - | FRONT ST | FRONT ST | 91368 | 91368 | 37.793225812 | -122.399287042 | - | - | 1710539427000 | MTA | BIKE RACK | FRONT ST to BATTERY ST (200 - 299) | 288131 | 22' E OF WPL 201/3' IN FROM CURB | - | - | - | - | - | 86160 | 1606917780000 | -122.39937019 | 37.7932841 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1606199040000 | CALIFORNIA ST | 200 - 299 CALIFORNIA ST | 200 - 299 CALIFORNIA ST | 200 CALIFORNIA ST | - | BATTERY ST | BATTERY ST |
| 69045 | N/A | Point | 1 | 1 | 200 - 299 | - | S270388 | 200-299 CALIFORNIA ST | 200-299 CALIFORNIA ST | F | F | - | F | 3526000 | 3526000 | - | - | SOUTH SIDE | - | - | - | - | FRONT ST | FRONT ST | 91369 | 91369 | 37.79323694 | -122.399191823 | - | - | 1710539427000 | MTA | BIKE RACK | FRONT ST to BATTERY ST (200 - 299) | 288131 | 32' E OF WPL 201/3' IN FROM CURB | - | - | - | - | - | 86161 | 1606917720000 | -122.39937019 | 37.7932841 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1606199100000 | CALIFORNIA ST | 200 - 299 CALIFORNIA ST | 200 - 299 CALIFORNIA ST | 200 CALIFORNIA ST | - | BATTERY ST | BATTERY ST |
| 69046 | N/A | Point | - | - | - | - | S269801 | TURK ST: HYDE ST | - | F | F | - | F | 24933000 | 24933000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HYDE ST | TURK ST | 91375 | 91375 | 37.782564891 | -122.415448448 | TURK ST \ HYDE ST | HYDE ST \ TURK ST | 1710539427000 | MTA | PED (SYM) 6FT | TURK ST intersection | - | - | - | - | - | - | - | 86162 | 1477612800000 | -122.41569387 | 37.78258503 | - | 1604534400000 | - | D6 | - | PEDESTRIAN | REG | R(SF).0426 | 30X12 | SUP1 | SIGNAL POLE | IS | 1604394120000 | HYDE ST | - | - | - | - | - | - |
| 69047 | N/A | Point | - | - | - | - | S269802 | TURK ST: HYDE ST | - | F | F | - | F | 24933000 | 24933000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HYDE ST | TURK ST | 91376 | 91376 | 37.782565951 | -122.415563783 | TURK ST \ HYDE ST | HYDE ST \ TURK ST | 1710539427000 | MTA | PED (SYM) 6FT | TURK ST intersection | - | - | - | - | - | - | - | 86163 | 1477612800000 | -122.41569387 | 37.78258503 | - | 1604534400000 | - | D6 | - | PEDESTRIAN | REG | R(SF).0426 | 30X12 | SUP1 | SIGNAL POLE | IS | 1604394180000 | HYDE ST | - | - | - | - | - | - |
| 69048 | N/A | Point | - | - | - | - | S269810 | TURK ST: HYDE ST | - | F | F | - | F | 24933000 | 24933000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | HYDE ST | TURK ST | 91377 | 91377 | 37.782511895 | -122.415869555 | TURK ST \ HYDE ST | HYDE ST \ TURK ST | 1710539427000 | MTA | PED (SYM) 6FT | TURK ST intersection | - | 20 FT WEST | - | - | - | - | - | 86164 | 1477612800000 | -122.41569387 | 37.78258503 | - | 1604620800000 | - | D6 | - | PEDESTRIAN | REG | R(SF).0426 | 30X12 | SUP1 | 2IN IRON POST | IS | 1604395140000 | HYDE ST | - | - | - | - | - | - |
| 69049 | N/A | Point | - | - | - | - | S269811 | TURK ST: HYDE ST | - | F | F | - | F | 24933000 | 24933000 | - | - | SOUTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | HYDE ST | TURK ST | 91378 | 91378 | 37.782512425 | -122.415857485 | TURK ST \ HYDE ST | HYDE ST \ TURK ST | 1710539427000 | MTA | PED (SYM) 6FT | TURK ST intersection | - | 20 FT WEST | - | - | - | - | - | 86165 | 1477612800000 | -122.41569387 | 37.78258503 | - | 1604620800000 | - | D6 | - | PEDESTRIAN | REG | R(SF).0426 | 30X12 | SUP1 | 2IN IRON POST | IS | 1604395140000 | HYDE ST | - | - | - | - | - | - |
| 69050 | N/A | Point | 1 | 1 | 50 - 99 | - | S270010 | 50-99 HOWARD ST | 50-99 HOWARD ST | F | F | - | F | 7028000 | 7028000 | - | - | NORTH SIDE | - | - | - | - | STEUART LN \ STEUART ST | STEUART LN \ STEUART ST | 91406 | 91406 | 37.791457507 | -122.392454349 | - | - | 1710539427000 | MTA | MUNI LANDOR FLAG - TYPE 6 | STEUART LN \ STEUART ST to SPEAR ST (50 - 99) | - | 10 FT' EAST OF SPEAR | - | - | - | - | - | 86166 | - | -122.39208521 | 37.79165834 | - | - | - | D6 | - | OTHER REGULATORY | REG | R(SF).0334 | 15X39 | SUP1 | MUNI LANDOR POLE 3" X135" | IS | 1605008220000 | HOWARD ST | 50 - 99 HOWARD ST | 50 - 99 HOWARD ST | 50 HOWARD ST | - | SPEAR ST | SPEAR ST |
| 69051 | N/A | Point | - | - | - | - | S271984 | COOK ST: GEARY BLVD | - | F | F | - | F | 26924000 | 26924000 | - | - | SOUTH WEST CORNER | - | - | - | - | GEARY BLVD | GEARY BLVD | 91414 | 91414 | 37.781805593 | -122.452128815 | COOK ST \ GEARY BLVD | COOK ST \ GEARY BLVD | 1710539427000 | MTA | GEARY ST | GEARY BLVD intersection | - | - | - | - | - | - | - | 86167 | 1611878400000 | -122.45214312 | 37.78185329 | - | - | - | D1 | - | STREET NAME | GUIDE | D3-1.0718 | 36X08 | SUP2 | SIGNAL POLE | IS | 1611907740000 | COOK ST | - | - | - | - | - | - |
| 69052 | N/A | Point | - | - | - | - | S272635 | MOSCOW ST: FRANCE AVE | - | F | F | - | F | 21398000 | 21398000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FRANCE AVE | FRANCE AVE | 91426 | 91426 | 37.716689089 | -122.43117798 | MOSCOW ST \ FRANCE AVE | MOSCOW ST \ FRANCE AVE | 1710539427000 | MTA | ALL WAY | FRANCE AVE intersection | - | - | - | - | - | - | - | 86168 | 1565568000000 | -122.43115384 | 37.71659361 | - | 1617062400000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1614242100000 | MOSCOW ST | - | - | - | - | - | - |
| 69053 | N/A | Point | - | - | - | - | S272636 | MOSCOW ST: FRANCE AVE | - | F | F | - | F | 21398000 | 21398000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FRANCE AVE | FRANCE AVE | 91427 | 91427 | 37.716506618 | -122.431148476 | MOSCOW ST \ FRANCE AVE | MOSCOW ST \ FRANCE AVE | 1710539427000 | MTA | STOP | FRANCE AVE intersection | - | - | - | - | - | - | - | 86169 | 1565568000000 | -122.43115384 | 37.71659361 | - | 1617062400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1614242280000 | MOSCOW ST | - | - | - | - | - | - |
| 69054 | N/A | Point | - | - | - | - | S272637 | MOSCOW ST: FRANCE AVE | - | F | F | - | F | 21398000 | 21398000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FRANCE AVE | FRANCE AVE | 91428 | 91428 | 37.716502375 | -122.431132382 | MOSCOW ST \ FRANCE AVE | MOSCOW ST \ FRANCE AVE | 1710539427000 | MTA | ALL WAY | FRANCE AVE intersection | - | - | - | - | - | - | - | 86170 | 1565568000000 | -122.43115384 | 37.71659361 | - | 1617062400000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1614242340000 | MOSCOW ST | - | - | - | - | - | - |
| 69055 | N/A | Point | - | - | - | - | S272638 | FRANCE AVE: MOSCOW ST | - | F | F | - | F | 21398000 | 21398000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FRANCE AVE | FRANCE AVE | 91429 | 91429 | 37.716597854 | -122.431030458 | MOSCOW ST \ FRANCE AVE | MOSCOW ST \ FRANCE AVE | 1710539427000 | MTA | ALL WAY | FRANCE AVE intersection | - | - | - | - | - | - | - | 86171 | 712972800000 | -122.43115384 | 37.71659361 | - | 1617062400000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1614242640000 | MOSCOW ST | - | - | - | - | - | - |
| 69056 | N/A | Point | - | - | - | - | S272639 | FRANCE AVE: MOSCOW ST | - | F | F | - | F | 21398000 | 21398000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FRANCE AVE | FRANCE AVE | 91430 | 91430 | 37.716604219 | -122.431022412 | MOSCOW ST \ FRANCE AVE | MOSCOW ST \ FRANCE AVE | 1710539427000 | MTA | DEAD END | FRANCE AVE intersection | - | - | - | - | - | - | - | 86172 | 712972800000 | -122.43115384 | 37.71659361 | - | 1299456000000 | - | D11 | - | OTHER WARNING | WARNING | W14-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1614242820000 | MOSCOW ST | - | - | - | - | - | - |
| 69057 | N/A | Point | - | - | - | - | S272640 | FRANCE AVE: MOSCOW ST | - | F | F | - | F | 21398000 | 21398000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FRANCE AVE | FRANCE AVE | 91431 | 91431 | 37.716585123 | -122.431274539 | MOSCOW ST \ FRANCE AVE | MOSCOW ST \ FRANCE AVE | 1710539427000 | MTA | ALL WAY | FRANCE AVE intersection | - | - | - | - | - | - | - | 86173 | 712972800000 | -122.43115384 | 37.71659361 | - | 1617062400000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1614243120000 | MOSCOW ST | - | - | - | - | - | - |
| 69058 | N/A | Point | 1 | 1 | 1 - 99 | - | S271821 | 1-99 PAUL AVE | 1-99 PAUL AVE | F | F | - | F | 10306000 | 10306000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | 3RD ST \ GILMAN AVE | 03RD ST \ GILMAN AVE | 91618 | 91618 | 37.72251167 | -122.39612781 | - | - | 1710539427000 | MTA | SPEED HUMPS | 03RD ST \ GILMAN AVE to CARR ST (1 - 99) | - | 65' WEST OF 3RD ST. | - | - | - | - | - | 86174 | 1612429380000 | -122.39612781 | 37.72251167 | - | - | - | D10 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1611590100000 | PAUL AVE | 1 - 99 PAUL AVE | 1 - 99 PAUL AVE | 1 PAUL AVE | - | CARR ST | CARR ST |
| 69059 | N/A | Point | 1 | 1 | 700 - 799 | - | S270794 | 700-799 38TH AVE | 700-799 38TH AVE | F | F | - | F | 1849000 | 1849000 | - | - | WEST SIDE | - | - | - | - | BALBOA ST | BALBOA ST | 92811 | 92811 | 37.77473328 | -122.49831762 | - | - | 1715823192000 | middleware_editor | BIKE RACK | BALBOA ST to CABRILLO ST (700 - 799) | 285951 | 31' S OF NPL 701/ 2.5' IN FROM CURB | - | - | - | - | - | 86175 | 1608133680000 | -122.49831762 | 37.77473328 | - | - | - | D1 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1608022680000 | 38TH AVE | 700 - 799 38TH AVE | 700 - 799 38TH AVE | 700 38TH AVE | - | CABRILLO ST | CABRILLO ST |
| 69060 | N/A | Point | - | - | - | - | S266565 | GUERRERO ST: 19TH ST | - | T | T | - | F | 25676000 | 25676000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 19TH ST | GUERRERO ST | 92833 | 92833 | 37.760059563 | -122.423548401 | GUERRERO ST \ 19TH ST | 19TH ST \ GUERRERO ST | 1710539427000 | MTA | 19TH ST | GUERRERO ST intersection | - | - | - | - | - | - | - | 86176 | 1503446400000 | -122.42364131 | 37.75996738 | - | 1635379200000 | - | D8 | - | STREET NAME | GUIDE | D3-2.0019 | 72X18 | SUP2 | OVERHEAD MAST ARM | IS | 1595849340000 | 19TH ST | - | - | - | - | - | - |
| 69061 | N/A | Point | - | - | - | - | S266566 | GUERRERO ST: 19TH ST | - | T | T | - | F | 6581201 | 25676000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 19TH ST | GUERRERO ST | 92834 | 92834 | 37.759875242 | -122.423753049 | - | 19TH ST \ GUERRERO ST | 1710539427000 | MTA | 19TH ST | GUERRERO ST intersection | - | - | - | - | - | - | - | 86177 | 1503446400000 | -122.42364131 | 37.75996738 | - | 1503446400000 | - | D8 | - | STREET NAME | GUIDE | D3-2.0019 | 72X18 | SUP2 | OVERHEAD MAST ARM | IS | 1595849460000 | 19TH ST | 700 - 748 GUERRERO ST | - | - | - | CUMBERLAND ST | - |
| 69062 | N/A | Point | 1 | 1 | 1 - 99 | - | S281136 | 1-99 HAVELOCK ST | 1-99 HAVELOCK ST | F | F | - | F | 6778000 | 6778000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | SAN JOSE AVE | SAN JOSE AVE | 92841 | 92841 | 37.72675117 | -122.44259658 | - | - | 1714698856000 | middleware_editor | SPEED HUMPS AHEAD | SAN JOSE AVE to ARAGO ST (1 - 99) | - | EPL 16 | - | - | - | - | - | 86178 | 1646179200000 | -122.44259658 | 37.72675117 | - | - | - | D11 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1645789740000 | HAVELOCK ST | 1 - 99 HAVELOCK ST | 1 - 99 HAVELOCK ST | 1 HAVELOCK ST | - | ARAGO ST | ARAGO ST |
| 69063 | N/A | Point | - | - | - | - | S281861 | HAYES ST: VAN NESS AVE | - | T | T | - | F | 24450000 | 24450000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | VAN NESS AVE | HAYES ST | 92861 | 92861 | 37.77729986 | -122.41969357 | HAYES ST \ VAN NESS AVE | VAN NESS AVE \ HAYES ST | 1710539427000 | MTA | VAN NESS AVE | HAYES ST intersection | - | - | - | - | - | - | - | 86179 | 1648425600000 | -122.41969357 | 37.77729986 | - | - | - | D5 | - | STREET NAME | GUIDE | D3-2.0347 | 72X18 | SUP1 | MUNI POLE | IS | 1648206840000 | VAN NESS AVE | - | - | - | - | - | - |
| 69064 | N/A | Point | - | - | - | - | S259330 | OCTAVIA ST: LINDEN ST | - | F | F | - | F | 35011000 | 35011000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | OCTAVIA ST | LINDEN ST | 92891 | 92891 | 37.7762386 | -122.42427319 | LINDEN ST \ OCTAVIA ST | OCTAVIA ST \ LINDEN ST | 1710539427000 | MTA | RIGHT TURN ONLY(SYM) | LINDEN ST intersection | - | - | - | - | - | - | - | 86180 | 1575590400000 | -122.42427319 | 37.7762386 | - | - | - | D5 | - | OTHER REGULATORY | REG | R3-5.0002 | 30X36 | SUP1 | LIGHT POLE | IS | 1574163300000 | OCTAVIA ST | - | - | - | - | - | - |
| 69065 | N/A | Point | 1 | 1 | 200 - 299 | - | S282094 | 200-299 AUSTIN ST | 200-299 AUSTIN ST | - | - | - | F | 5792000 | 5792000 | - | - | NORTH SIDE | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 92917 | 92917 | 37.7888442 | -122.42291692 | - | - | 1710539427000 | MTA | WHEEL STOP | VAN NESS AVE to FRANKLIN ST (200 - 299) | - | EAST END OF CORRAL/ 6" OFF CURB | - | - | - | - | - | 86181 | 1650499200000 | -122.42291692 | 37.7888442 | - | - | - | D2 | - | OTHER WARNING | WARNING | W(SF).0072 | 36X08 | SUP1 | SPIKE | IS | 1649175060000 | AUSTIN ST | 200 - 299 AUSTIN ST | 200 - 299 AUSTIN ST | 200 AUSTIN ST | - | FRANKLIN ST | FRANKLIN ST |
| 69066 | N/A | Point | 1 | 1 | 1 - 45 | - | S260368 | 1-45 PAGE ST | 1-45 PAGE ST | F | F | - | F | 10168000 | 10168000 | - | - | EAST SIDE | - | - | - | - | 12TH ST \ MARKET ST | 12TH ST \ MARKET ST | 92940 | 92940 | 37.77432654 | -122.42050709 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (Y) | 12TH ST \ MARKET ST to FRANKLIN ST (1 - 45) | - | (6) DELINEATORS SEPERATING BIKE LANES | - | - | - | - | - | 86182 | 1551744000000 | -122.42050709 | 37.77432654 | - | 1642982400000 | - | D5 | - | DELINEATOR 5 | WARNING | TYPE-DL.0008 | 03X36 | SUP1 | STANDARD BASE | IS | 1579084920000 | PAGE ST | 1 - 45 PAGE ST | 1 - 45 PAGE ST | 1 PAGE ST | - | FRANKLIN ST | FRANKLIN ST |
| 69067 | N/A | Point | 1 | 1 | 700 - 799 | - | S272192 | 700-799 EDDY ST | 700-799 EDDY ST | F | F | - | F | 5065000 | 5065000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | POLK ST | POLK ST | 92975 | 92975 | 37.78299776 | -122.41999935 | - | - | 1710539427000 | MTA | SPEED LIMIT 20 | POLK ST to VAN NESS AVE (700 - 799) | - | IFO #790 | - | - | - | - | - | 86183 | 1191542400000 | -122.41999935 | 37.78299776 | - | 1621814400000 | - | D6 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1612514760000 | EDDY ST | 700 - 799 EDDY ST | 700 - 799 EDDY ST | 700 EDDY ST | - | VAN NESS AVE | VAN NESS AVE |
| 69068 | N/A | Point | 1 | 1 | 100 - 199 | - | S283484 | 100-199 COLBY ST | 100-199 COLBY ST | F | F | - | F | 4230000 | 4230000 | - | - | EAST SIDE | - | - | - | - | SILLIMAN ST | SILLIMAN ST | 93078 | 93078 | 37.72831485 | -122.41372291 | - | - | 1733767340000 | middleware_editor | NPRK 8AM-11AM THUR STCL | SILLIMAN ST to FELTON ST (100 - 199) | - | SPL 175 | - | - | - | - | - | 86184 | - | -122.41372291 | 37.72831485 | - | 1656028800000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0276 | 18X18 | SUP2 | 2IN IRON POST | IS | 1655298120000 | COLBY ST | 100 - 199 COLBY ST | 100 - 199 COLBY ST | 100 COLBY ST | - | FELTON ST | FELTON ST |
| 69069 | N/A | Point | - | - | - | - | S281938 | VAN NESS AVE: CALIFORNIA ST | - | F | F | - | F | 25225000 | 25225000 | - | - | CENTER ISLAND, N LINE, SOUTHBOUND | - | - | - | - | VAN NESS AVE | CALIFORNIA ST | 93090 | 93090 | 37.79036966 | -122.42232896 | CALIFORNIA ST \ VAN NESS AVE | VAN NESS AVE \ CALIFORNIA ST | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) EXC MUNI | CALIFORNIA ST intersection | - | - | - | - | - | - | - | 86185 | 1649203200000 | -122.42232896 | 37.79036966 | - | - | - | D2 | - | NO LEFT TURN | REG | R3-18(SF).0011 | 24X30 | SUP1 | SIGNAL POLE | IS | 1648593240000 | VAN NESS AVE | - | - | - | - | - | - |
| 69070 | N/A | Point | - | 1 | 400 - 459 | - | S270841 | 400-459 2ND ST | 400-459 02ND ST | F | F | - | F | 140000 | 140000 | - | - | WEST SIDE | - | - | - | - | HARRISON ST | HARRISON ST | 93109 | 93109 | 37.78390726 | -122.39465557 | - | - | 1710539427000 | MTA | TANSAT | HARRISON ST to STILLMAN ST (400 - 459) | - | 45' SOUTH OF HARRISON ST | - | - | - | - | - | 86186 | 1609772400000 | -122.39465557 | 37.78390726 | - | - | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1608134700000 | 02ND ST | 400 - 459 2ND ST | 400 - 459 02ND ST | 400 2ND ST | - | STILLMAN ST | STILLMAN ST |
| 69071 | N/A | Point | - | - | - | - | S269646 | COLUMBUS AVE: MASON ST | - | F | F | - | F | 25462000 | 25462000 | - | - | NORTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | COLUMBUS AVE | COLUMBUS AVE | 93138 | 93138 | 37.80218377 | -122.41290809 | MASON ST \ COLUMBUS AVE | MASON ST \ COLUMBUS AVE | 1712626721000 | middleware_editor | NO PED XING-USE CROSSWALK (RA) | COLUMBUS AVE intersection | - | - | - | - | - | - | - | 86187 | 1604051760000 | -122.41290809 | 37.80218377 | - | - | - | D3 | - | PEDESTRIAN | REG | R49(CA).0006 | 36X18 | SUP1 | 2 POST ALUMINUM | IS | 1603969800000 | MASON ST | - | - | - | - | - | - |
| 69072 | N/A | Point | 1 | 1 | 100 - 199 | - | S282207 | 100-199 DIAMOND ST | 100-199 DIAMOND ST | F | F | - | F | 4738000 | 4738000 | - | - | EAST SIDE | - | - | - | - | 18TH ST | 18TH ST | 93151 | 93151 | 37.7597939067993 | -122.437045361841 | - | - | 1743732270000 | middleware_editor | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | 18TH ST to 19TH ST (100 - 199) | - | 230 FT SOUTH OF 18TH ST OPP 156 | - | - | - | - | - | 86188 | - | -122.43711457 | 37.75995777 | - | 1656399600000 | - | D8 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP2 | 2IN IRON POST | IS | 1649848560000 | DIAMOND ST | 100 - 199 DIAMOND ST | 100 - 199 DIAMOND ST | 100 DIAMOND ST | - | 19TH ST | 19TH ST |
| 69073 | N/A | Point | 1 | 1 | 400 - 448 | LEFT ARROW | S259331 | PNDG OCTAVIA ST | 400-448 OCTAVIA ST | F | F | - | F | 9882201 | 9882201 | - | - | EAST SIDE | - | - | - | - | FELL ST | FELL ST | 93172 | 93172 | 37.77597854 | -122.42423954 | - | - | 1710539427000 | MTA | MOTORCYCLE ONLY | FELL ST to LINDEN ST (400 - 448) -- NORTH -- | - | 30' NORTH OF FELL ST. | - | - | - | - | - | 86189 | 1575640320000 | -122.42423954 | 37.77597854 | - | - | - | D5 | - | OTHER REGULATORY | REG | R32F(SF).0002 | 12X18 | SUP1 | 2IN IRON POST | IS | 1574163720000 | OCTAVIA ST | PNDG OCTAVIA ST | 400 - 448 OCTAVIA ST | - | - | LINDEN ST | LINDEN ST |
| 69074 | N/A | Point | 1 | 1 | 900 - 999 | - | S263337 | 900-999 VIENNA ST | 900-999 VIENNA ST | F | F | - | F | 13306000 | 13306000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | AMAZON AVE | AMAZON AVE | 96867 | 96867 | 37.714122021 | -122.435100643 | - | - | 1710539427000 | MTA | SCHOOL (SYM) AHEAD | AMAZON AVE to GENEVA AVE (900 - 999) | 135441 | NPL #985 | - | - | - | - | - | 86190 | 1331683200000 | -122.4349263 | 37.71445444 | - | - | - | D11 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1586944680000 | VIENNA ST | 900 - 999 VIENNA ST | 900 - 999 VIENNA ST | 900 VIENNA ST | - | GENEVA AVE | GENEVA AVE |
| 69075 | N/A | Point | 1 | 1 | 1000 - 1099 | RIGHT ARROW | S269444 | 1000-1099 POST ST | 1000-1099 POST ST | F | F | - | F | - | 10639000 | - | - | SOUTH SIDE | - | - | - | - | - | LARKIN ST | 96935 | 96935 | 37.78693698 | -122.419194679 | - | - | 1710539427000 | MTA | NO STOPPING FIRE LANE | LARKIN ST to POLK ST (1000 - 1099) | - | EPL OF FIRE STATION 3 | - | - | - | - | - | 86191 | 1603968600000 | -122.41909946 | 37.78693274 | - | - | - | D6 | - | OTHER REGULATORY | REG | R26F.0003 | 12X18 | SUP1 | 2IN IRON POST | IS | 1603360500000 | POST ST | - | 1000 - 1099 POST ST | 1000 POST ST | - | - | POLK 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.