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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 60301 | N/A | Point | 1 | 1 | 172 - 199 | - | S267204 | 172-199 8TH ST | 172-199 08TH ST | F | F | - | F | 408000 | 408000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | NATOMA ST | NATOMA ST | 98736 | 98736 | 37.77644117 | -122.41188203 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | NATOMA ST to HOWARD ST (172 - 199) | - | START SOUTH OF NATOMA ST, 10' OC | - | - | - | - | - | 77409 | 1597845420000 | -122.41188203 | 37.77644117 | - | 1702907100000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | TURNPIKE BASE | IS | 1597749720000 | 08TH ST | 172 - 199 8TH ST | 172 - 199 08TH ST | 172 8TH ST | - | HOWARD ST | HOWARD ST |
| 60302 | N/A | Point | 1 | 1 | 172 - 199 | - | S267205 | 172-199 8TH ST | 172-199 08TH ST | F | F | - | F | 408000 | 408000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | NATOMA ST | NATOMA ST | 98737 | 98737 | 37.77644117 | -122.41188203 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | NATOMA ST to HOWARD ST (172 - 199) | - | START 10' NORTH OF HOWARD ST, 10' OC | - | - | - | - | - | 77410 | 1597846800000 | -122.41188203 | 37.77644117 | - | - | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | TURNPIKE BASE | IS | 1597749840000 | 08TH ST | 172 - 199 8TH ST | 172 - 199 08TH ST | 172 8TH ST | - | HOWARD ST | HOWARD ST |
| 60303 | N/A | Point | 1 | 1 | 600 - 699 | LEFT ARROW | S267227 | 600-699 7TH ST | 600-699 07TH ST | F | F | - | F | 376000 | 376000 | - | - | WEST SIDE | - | - | - | - | BRANNAN ST | BRANNAN ST | 98738 | 98738 | 37.77243412 | -122.40243088 | - | - | 1743440596000 | middleware_editor | TA (SYM) PLO 9AM-7PM MON-SAT (5 MIN) | BRANNAN ST to TOWNSEND ST (600 - 699) | - | 150' NORTH OF TOWNSEND | - | - | - | - | - | 77411 | - | -122.40243088 | 37.77243412 | - | - | 1743439500000 | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0022 | 14X21 | SUP1 | 2IN IRON POST | RETD | 1597754160000 | 07TH ST | 600 - 699 7TH ST | 600 - 699 07TH ST | 600 7TH ST | - | TOWNSEND ST | TOWNSEND ST |
| 60304 | N/A | Point | - | - | - | - | S267233 | LEAVENWORTH ST: ELLIS ST | - | F | F | - | F | 25139000 | 25139000 | - | - | SOUTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ELLIS ST | ELLIS ST | 98739 | 98739 | 37.78465714 | -122.4144302 | LEAVENWORTH ST \ ELLIS ST | LEAVENWORTH ST \ ELLIS ST | 1726090245000 | middleware_editor | FG 300 UR DELINEATOR (W) | ELLIS ST intersection | - | START @ S-LINE, X-WALK, 8' OC | - | - | - | - | - | 77412 | 1598017260000 | -122.4144302 | 37.78465714 | - | 1726064520000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1597761120000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 60305 | N/A | Point | - | - | - | - | S267239 | SACRAMENTO ST: GOUGH ST | - | F | F | - | F | 26542000 | 26542000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SACRAMENTO ST | GOUGH ST | 98745 | 98745 | 37.79087443 | -122.42580214 | GOUGH ST \ SACRAMENTO ST | SACRAMENTO ST \ GOUGH ST | 1748539958000 | middleware_editor | FG 300 UR DELINEATOR (W) | GOUGH ST intersection | - | START @ E-LINE, X-WALK, 8' OC | - | - | - | - | - | 77413 | 1598389500000 | -122.42580214 | 37.79087443 | - | - | - | D2 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1597764360000 | SACRAMENTO ST | - | - | - | - | - | - |
| 60306 | N/A | Point | - | - | - | - | S267240 | GOUGH ST: SACRAMENTO ST | - | F | F | - | F | 26542000 | 26542000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SACRAMENTO ST | GOUGH ST | 98746 | 98746 | 37.79087443 | -122.42580214 | GOUGH ST \ SACRAMENTO ST | SACRAMENTO ST \ GOUGH ST | 1748539964000 | middleware_editor | FG 300 UR DELINEATOR (W) | GOUGH ST intersection | - | START @ S-LINE, X-WALK, 8' OC | - | - | - | - | - | 77414 | 1598389800000 | -122.42580214 | 37.79087443 | - | - | - | D2 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1597764540000 | SACRAMENTO ST | - | - | - | - | - | - |
| 60307 | N/A | Point | - | - | - | - | S267247 | LINCOLN WAY: 17TH AVE | - | F | F | - | F | 27362000 | 27362000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | - | - | - | - | LINCOLN WAY | 17TH AVE | 98748 | 98748 | 37.76554442 | -122.47511856 | 17TH AVE \ LINCOLN WAY | LINCOLN WAY \ 17TH AVE | 1710539427000 | MTA | FG 300 UR DELINEATOR (Y) | 17TH AVE intersection | - | START WEST END OF CENTER ISLAND, 7' OC | - | - | - | - | - | 77415 | 1598313600000 | -122.47511856 | 37.76554442 | - | - | - | D4 | - | DELINEATOR 5 | WARNING | TYPE-DL.0008 | 03X36 | SUP2 | STANDARD BASE | IS | 1597794720000 | LINCOLN WAY | - | - | - | - | - | - |
| 60308 | N/A | Point | 1 | 1 | 1201 - 1299 | - | S260671 | 1100-1199 MARKET ST | 1201-1299 MARKET ST | F | F | - | F | 8752101 | 8752101 | - | - | NORTH SIDE | - | - | - | - | 8TH ST \ GROVE ST \ HYDE ST | 08TH ST \ GROVE ST \ HYDE ST | 98750 | 98750 | 37.77807696 | -122.41547968 | - | - | 1753801629000 | middleware_editor | NPRK 2AM-6AM EVERYDAY INCLUDING HOLIDAY STCL | 08TH ST \ GROVE ST \ HYDE ST to 09TH ST \ LARKIN ST (1201 - 1299) -- SOUTH -- | - | 200' EAST OF 8TH ST. | - | - | - | - | - | 77416 | 1580941500000 | -122.41547968 | 37.77807696 | - | - | - | D6 | - | STREET CLEANING | REG | R30B(CA).0113 | 18X18 | SUP1 | LIGHT POLE | IS | 1580120040000 | MARKET ST | 1201 - 1299 MARKET ST | 1201 - 1299 MARKET ST | 1201 MARKET ST | - | 09TH ST \ LARKIN ST | 09TH ST \ LARKIN ST |
| 60309 | N/A | Point | 1 | 1 | 400 - 499 | - | S263048 | 400-499 FAIR OAKS ST | 400-499 FAIR OAKS ST | F | F | - | F | 5385000 | 5385000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 25TH ST | 25TH ST | 98751 | 98751 | 37.74950771 | -122.42375354 | - | - | 1734619597000 | middleware_editor | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | 25TH ST to 26TH ST (400 - 499) | 134957 | NPL #421 | - | - | - | - | - | 77417 | 1333411200000 | -122.42375354 | 37.74950771 | - | 1489017600000 | - | D8 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP2 | 2IN IRON POST | IS | 1585824240000 | FAIR OAKS ST | 400 - 499 FAIR OAKS ST | 400 - 499 FAIR OAKS ST | 400 FAIR OAKS ST | - | 26TH ST | 26TH ST |
| 60310 | N/A | Point | 1 | 1 | 1890 - 1907 | - | S114534 | 1890-1907 SAN JOSE AVE | 1890-1907 SAN JOSE AVE | F | F | - | F | 11451000 | 11451000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | SAN JUAN AVE | SAN JUAN AVE | 98752 | 98752 | 37.72684949 | -122.44150964 | - | - | 1721179013000 | middleware_editor | (45 LA-DN) | SAN JUAN AVE to HAVELOCK ST (1890 - 1907) | - | OPP.NE CORNOR IFO 1884 | - | - | - | - | - | 77418 | 1008892800000 | -122.44150964 | 37.72684949 | - | 1631577600000 | - | D11 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP2 | 2IN IRON POST | IS | 1373572080000 | SAN JOSE AVE | 1890 - 1907 SAN JOSE AVE | 1890 - 1907 SAN JOSE AVE | 1890 SAN JOSE AVE | - | HAVELOCK ST | HAVELOCK ST |
| 60311 | N/A | Point | 1 | 1 | 2800 - 2899 | - | S113745 | 2800-2899 CALIFORNIA ST | 2800-2899 CALIFORNIA ST | F | F | - | F | 3562000 | 3562000 | - | - | SOUTH SIDE | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 98753 | 98753 | 37.78796137 | -122.44127482 | - | - | 1710539427000 | MTA | NPPZ 8:30AM-3PM SAT | DIVISADERO ST to BRODERICK ST (2800 - 2899) | - | ON PM#2841 | - | - | - | - | - | 77419 | 995846400000 | -122.44127482 | 37.78796137 | - | - | - | D2 | - | OTHER REGULATORY | REG | R30(SF).0345 | 12X18 | SUP1 | PARKING METER | IS | 1373571840000 | CALIFORNIA ST | 2800 - 2899 CALIFORNIA ST | 2800 - 2899 CALIFORNIA ST | 2800 CALIFORNIA ST | - | BRODERICK ST | BRODERICK ST |
| 60312 | N/A | Point | 1 | 1 | 100 - 130 | - | S282422 | 100-130 2ND ST | 100-130 02ND ST | F | F | - | F | 132000 | 132000 | - | - | EAST SIDE | - | - | - | - | MISSION ST | MISSION ST | 99821 | 99821 | 37.78779322 | -122.39952654 | - | - | 1710539427000 | MTA | TRANSIT WAYFINDING | MISSION ST to MINNA ST (100 - 130) | - | 90FT SOUTH OF MISSION | - | - | - | - | - | 77420 | 1652400000000 | -122.39952654 | 37.78779322 | - | - | - | D6 | - | OTHER GUIDE | GUIDE | G-T(SF).0030 | 96X24 | SUP1 | GUIDE POLE | IS | 1650632520000 | 02ND ST | 100 - 130 2ND ST | 100 - 130 02ND ST | 100 2ND ST | - | MINNA ST | MINNA ST |
| 60313 | N/A | Point | 1 | 1 | 1 - 99 | - | S282423 | 1-99 BEALE ST | 1-99 BEALE ST | F | F | - | F | 2863000 | 2863000 | - | - | WEST SIDE | - | - | - | - | DAVIS ST \ MARKET ST \ PINE ST | DAVIS ST \ MARKET ST \ PINE ST | 99822 | 99822 | 37.79177917 | -122.39659843 | - | - | 1752679472000 | middleware_editor | TRANSIT WAYFINDING | DAVIS ST \ MARKET ST \ PINE ST to MISSION ST (1 - 99) | - | 30FT NORTH OF MISSION | - | - | - | - | - | 77421 | 1652425200000 | -122.39659843 | 37.79177917 | - | - | - | D6 | - | OTHER GUIDE | GUIDE | G-T(SF).0030 | 96X24 | SUP1 | GUIDE POLE | IS | 1650632580000 | BEALE ST | 1 - 99 BEALE ST | 1 - 99 BEALE ST | 1 BEALE ST | - | MISSION ST | MISSION ST |
| 60314 | N/A | Point | - | - | - | - | S282801 | VAN NESS AVE: PINE ST | - | T | T | - | F | 25226000 | 25226000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 99826 | 99826 | 37.78941206 | -122.42213521 | PINE ST \ VAN NESS AVE | PINE ST \ VAN NESS AVE | 1710539427000 | MTA | PINE ST | VAN NESS AVE intersection | - | - | - | - | - | - | - | 77422 | - | -122.42213521 | 37.78941206 | - | 1666742400000 | - | D2 | - | STREET NAME | GUIDE | D3-2.0279 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1652700720000 | PINE ST | - | - | - | - | - | - |
| 60315 | N/A | Point | - | - | - | - | S282802 | VAN NESS AVE: PINE ST | - | F | F | - | F | 25226000 | 25226000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 99827 | 99827 | 37.78941206 | -122.42213521 | PINE ST \ VAN NESS AVE | PINE ST \ VAN NESS AVE | 1710539427000 | MTA | PINE ST | VAN NESS AVE intersection | - | 1600--->[] | - | - | - | - | - | 77423 | - | -122.42213521 | 37.78941206 | - | 1675209600000 | - | D2 | - | STREET NAME | GUIDE | D3-1.1390 | 36X08 | SUP1 | SIGNAL POLE | IS | 1652700960000 | PINE ST | - | - | - | - | - | - |
| 60316 | N/A | Point | - | - | - | - | S282803 | VAN NESS AVE: PINE ST | - | F | F | - | F | 25226000 | 25226000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 99828 | 99828 | 37.78941206 | -122.42213521 | PINE ST \ VAN NESS AVE | PINE ST \ VAN NESS AVE | 1710539427000 | MTA | PINE ST | VAN NESS AVE intersection | - | 1600<---[] | - | - | - | - | - | 77424 | - | -122.42213521 | 37.78941206 | - | 1675209600000 | - | D2 | - | STREET NAME | GUIDE | D3-1.1390 | 36X08 | SUP1 | SIGNAL POLE | IS | 1652701080000 | PINE ST | - | - | - | - | - | - |
| 60317 | N/A | Point | - | - | - | - | S282804 | VAN NESS AVE: PINE ST | - | F | F | - | F | 25226000 | 25226000 | - | - | SOUTH EAST CORNER | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 99829 | 99829 | 37.78941206 | -122.42213521 | PINE ST \ VAN NESS AVE | PINE ST \ VAN NESS AVE | 1710539427000 | MTA | VAN NESS AVE | VAN NESS AVE intersection | - | []<---1500 | - | - | - | - | - | 77425 | - | -122.42213521 | 37.78941206 | - | 1675296000000 | - | D2 | - | STREET NAME | GUIDE | D3-1.1784 | 36X08 | SUP1 | LIGHT POLE | IS | 1652701200000 | PINE ST | - | - | - | - | - | - |
| 60318 | N/A | Point | - | - | - | - | S282805 | VAN NESS AVE: PINE ST | - | F | F | - | F | 25226000 | 25226000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 99830 | 99830 | 37.78941206 | -122.42213521 | PINE ST \ VAN NESS AVE | PINE ST \ VAN NESS AVE | 1710539427000 | MTA | VAN NESS AVE | VAN NESS AVE intersection | - | []--->1500 | - | - | - | - | - | 77426 | - | -122.42213521 | 37.78941206 | - | 1675382400000 | - | D2 | - | STREET NAME | GUIDE | D3-1.1784 | 36X08 | SUP1 | SIGNAL POLE | IS | 1652701320000 | PINE ST | - | - | - | - | - | - |
| 60319 | N/A | Point | - | - | - | - | S282808 | REDWOOD ST: VAN NESS AVE | - | F | F | - | F | 24469000 | 24469000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | REDWOOD ST | VAN NESS AVE | 99831 | 99831 | 37.78057622 | -122.42025546 | VAN NESS AVE \ REDWOOD ST | REDWOOD ST \ VAN NESS AVE | 1710539427000 | MTA | REDWOOD ST | VAN NESS AVE intersection | - | 200<---[] | - | - | - | - | - | 77427 | - | -122.42025546 | 37.78057622 | - | 1677542400000 | - | D6 | - | STREET NAME | GUIDE | D3-1.1461 | 36X08 | SUP1 | LIGHT POLE | IS | 1652703960000 | REDWOOD ST | - | - | - | - | - | - |
| 60320 | N/A | Point | - | - | - | - | S282809 | ELM ST: VAN NESS AVE | - | F | F | - | F | 24475000 | 24475000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ELM ST | VAN NESS AVE | 99832 | 99832 | 37.78150997 | -122.4204519 | VAN NESS AVE \ ELM ST | ELM ST \ VAN NESS AVE | 1710539427000 | MTA | ELM ST | VAN NESS AVE intersection | - | 200<---[] | - | - | - | - | - | 77428 | - | -122.4204519 | 37.78150997 | - | 1667952000000 | - | D6 | - | STREET NAME | GUIDE | D3-1.0601 | 36X08 | SUP1 | LIGHT POLE | IS | 1652704200000 | ELM ST | - | - | - | - | - | - |
| 60321 | N/A | Point | - | - | - | - | S282811 | VAN NESS AVE: TURK ST | - | T | T | - | F | 25184000 | 25184000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VAN NESS AVE | TURK ST | 99833 | 99833 | 37.78196077 | -122.42063825 | TURK ST \ VAN NESS AVE | VAN NESS AVE \ TURK ST | 1710539427000 | MTA | TURK ST | TURK ST intersection | - | - | - | - | - | - | - | 77429 | - | -122.42063825 | 37.78196077 | - | 1662940800000 | - | D5 | - | STREET NAME | GUIDE | D3-2.0340 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1652710500000 | VAN NESS AVE | - | - | - | - | - | - |
| 60322 | N/A | Point | 1 | 1 | 3900 - 3999 | - | S270856 | 3900-3999 26TH ST | 3900-3999 26TH ST | F | F | - | F | 1536000 | 1536000 | - | - | NORTH SIDE | - | - | - | - | CHURCH ST | CHURCH ST | 99834 | 99834 | 37.74842905 | -122.42823463 | - | - | 1710539427000 | MTA | BIKE RACK | CHURCH ST to SANCHEZ ST (3900 - 3999) | 271009 | 21' E OF WPL 3986/3' IN FROM CURB | - | - | - | - | - | 77430 | 1608284280000 | -122.42823463 | 37.74842905 | - | - | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1608192960000 | 26TH ST | 3900 - 3999 26TH ST | 3900 - 3999 26TH ST | 3900 26TH ST | - | SANCHEZ ST | SANCHEZ ST |
| 60323 | N/A | Point | 1 | 1 | 3900 - 3999 | - | S270858 | 3900-3999 26TH ST | 3900-3999 26TH ST | F | F | - | F | 1536000 | 1536000 | - | - | NORTH SIDE | - | - | - | - | CHURCH ST | CHURCH ST | 99835 | 99835 | 37.74842905 | -122.42823463 | - | - | 1710539427000 | MTA | BIKE RACK | CHURCH ST to SANCHEZ ST (3900 - 3999) | 271009 | 46' E OF WPL 3986/6' IN FROM CURB | - | - | - | - | - | 77431 | 1608286380000 | -122.42823463 | 37.74842905 | - | - | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1608192960000 | 26TH ST | 3900 - 3999 26TH ST | 3900 - 3999 26TH ST | 3900 26TH ST | - | SANCHEZ ST | SANCHEZ ST |
| 60324 | N/A | Point | 1 | 1 | 3900 - 3999 | - | S270859 | 3900-3999 26TH ST | 3900-3999 26TH ST | F | F | - | F | 1536000 | 1536000 | - | - | NORTH SIDE | - | - | - | - | CHURCH ST | CHURCH ST | 99836 | 99836 | 37.74842905 | -122.42823463 | - | - | 1710539427000 | MTA | BIKE RACK | CHURCH ST to SANCHEZ ST (3900 - 3999) | 271009 | 46' E OF WPL 3986/3' IN FROM CURB | - | - | - | - | - | 77432 | 1608288480000 | -122.42823463 | 37.74842905 | - | - | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1608193020000 | 26TH ST | 3900 - 3999 26TH ST | 3900 - 3999 26TH ST | 3900 26TH ST | - | SANCHEZ ST | SANCHEZ ST |
| 60325 | N/A | Point | - | - | - | - | S267126 | MARKET ST: 15TH ST | - | T | T | - | F | 25880000 | 25880000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 15TH ST | 15TH ST | 99837 | 99837 | 37.76601373 | -122.4308244 | MARKET ST \ 15TH ST | MARKET ST \ 15TH ST | 1713922419000 | middleware_editor | NO LEFT TURN (SYM) | 15TH ST intersection | - | - | - | - | - | - | - | 77433 | 1431475200000 | -122.4308244 | 37.76601373 | - | 1597795200000 | - | D8 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1597398900000 | MARKET ST | - | - | - | - | - | - |
| 60326 | N/A | Point | 1 | 1 | 200 - 299 | - | S267128 | 200-299 CHURCH ST | 200-299 CHURCH ST | T | T | - | F | 4010000 | 4010000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | MARKET ST | MARKET ST | 99838 | 99838 | 37.76681724 | -122.42888386 | - | - | 1721057915000 | middleware_editor | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | MARKET ST to 15TH ST (200 - 299) | - | IFO #218/ LEFT TURN OK EXCEPT 7AM7PM | - | - | - | - | - | 77434 | 1364169600000 | -122.42888386 | 37.76681724 | - | - | - | D8 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP2 | MUNI POLE | IS | 1597399560000 | CHURCH ST | 200 - 299 CHURCH ST | 200 - 299 CHURCH ST | 200 CHURCH ST | - | 15TH ST | 15TH ST |
| 60327 | N/A | Point | 1 | 1 | 200 - 299 | - | S267129 | 200-299 CHURCH ST | 200-299 CHURCH ST | T | T | - | F | 4010000 | 4010000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | MARKET ST | MARKET ST | 99839 | 99839 | 37.76681724 | -122.42888386 | - | - | 1721351431000 | middleware_editor | LEFT LANE BUSES TAXI ONLY AT ALL TIMES | MARKET ST to 15TH ST (200 - 299) | - | SPL 253 / REMOVE EXT | - | - | - | - | - | 77435 | 1364169600000 | -122.42888386 | 37.76681724 | - | - | - | D8 | - | TRANSIT ONLY(LEFT LANE) | REG | SR60-4(CA).0002 | 30X42 | SUP2 | 2IN IRON POST | IS | 1597399800000 | CHURCH ST | 200 - 299 CHURCH ST | 200 - 299 CHURCH ST | 200 CHURCH ST | - | 15TH ST | 15TH ST |
| 60328 | N/A | Point | - | - | - | - | S267131 | CHURCH ST: 15TH ST | - | T | T | - | F | 25727000 | 25727000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 15TH ST | 15TH ST | 99840 | 99840 | 37.76613001 | -122.42881915 | CHURCH ST \ 15TH ST | CHURCH ST \ 15TH ST | 1721265614000 | middleware_editor | NO LEFT TURN (SYM) | 15TH ST intersection | - | - | - | - | - | - | - | 77436 | 1353974400000 | -122.42881915 | 37.76613001 | - | 1597881600000 | - | D8 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | MUNI POLE | IS | 1597400220000 | CHURCH ST | - | - | - | - | - | - |
| 60329 | N/A | Point | - | - | - | - | S267134 | CHURCH ST: 15TH ST | - | T | T | - | F | 25727000 | 25727000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 15TH ST | 15TH ST | 99841 | 99841 | 37.76613001 | -122.42881915 | CHURCH ST \ 15TH ST | CHURCH ST \ 15TH ST | 1722958439000 | middleware_editor | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | 15TH ST intersection | - | LEFTTURNS OK EXCEPT 7AM 7PM M-F/ NPL355 | - | - | - | - | - | 77437 | 1364169600000 | -122.42881915 | 37.76613001 | - | - | - | D8 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP2 | MUNI POLE | IS | 1597401000000 | CHURCH ST | - | - | - | - | - | - |
| 60330 | N/A | Point | - | - | - | - | S252471 | HARRISON ST: 23RD ST | - | F | F | - | F | 23979000 | 23979000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 23RD ST | 23RD ST | 100859 | 100859 | 37.75423033 | -122.41204727 | HARRISON ST \ 23RD ST | HARRISON ST \ 23RD ST | 1742908905000 | middleware_editor | BIKE WAYFINDING SIGN | 23RD ST intersection | 0568 | ABOVE STOP SIGN | - | - | - | - | - | 77438 | 264409200000 | -122.41204727 | 37.75423033 | - | 1553842800000 | - | D9 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | 2IN IRON POST | IS | 1552648020000 | HARRISON ST | - | - | - | - | - | - |
| 60331 | N/A | Point | - | - | - | - | S252472 | HARRISON ST: 23RD ST | - | F | F | - | F | 23979000 | 23979000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 23RD ST | 23RD ST | 100860 | 100860 | 37.75423033 | -122.41204727 | HARRISON ST \ 23RD ST | HARRISON ST \ 23RD ST | 1743544831000 | middleware_editor | BIKE WAYFINDING SIGN | 23RD ST intersection | 0569 | UTILITY POLE BEFORE STOP SIGN | - | - | - | - | - | 77439 | 264409200000 | -122.41204727 | 37.75423033 | - | 1553842800000 | - | D9 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | UTILITY POLE | IS | 1552648200000 | HARRISON ST | - | - | - | - | - | - |
| 60332 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S252476 | 1200-1299 VALENCIA ST | 1200-1299 VALENCIA ST | F | F | - | F | 13072000 | 13072000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 23RD ST | 23RD ST | 100862 | 100862 | 37.75290337 | -122.42073847 | - | - | 1710539427000 | MTA | BIKE WAYFINDING SIGN | 23RD ST to 24TH ST (1200 - 1299) | 0601 | 125`NORTH OF 24TH ST UNDER BIKE SIGN | - | - | - | - | - | 77440 | 1540252800000 | -122.42073847 | 37.75290337 | - | 1554163200000 | - | D9 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | LIGHT POLE | IS | 1552650060000 | VALENCIA ST | 1200 - 1299 VALENCIA ST | 1200 - 1299 VALENCIA ST | 1200 VALENCIA ST | - | 24TH ST | 24TH ST |
| 60333 | N/A | Point | - | - | - | - | S252480 | CESAR CHAVEZ ST: VALENCIA ST | - | F | F | - | F | 21345000 | 21345000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | VALENCIA ST | CESAR CHAVEZ ST | 100864 | 100864 | 37.74812528 | -122.42027883 | CESAR CHAVEZ ST \ VALENCIA ST | VALENCIA ST \ CESAR CHAVEZ ST | 1710539427000 | MTA | BIKE WAYFINDING SIGN | CESAR CHAVEZ ST intersection | 0595 | VALENCIA SWC 2 | - | - | - | - | - | 77441 | 1554292800000 | -122.42027883 | 37.74812528 | - | - | - | D9 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | SIGNAL POLE | IS | 1552654380000 | VALENCIA ST | - | - | - | - | - | - |
| 60334 | N/A | Point | - | - | - | - | S252483 | CESAR CHAVEZ ST: VALENCIA ST | - | F | F | - | F | 21345000 | 21345000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | VALENCIA ST | CESAR CHAVEZ ST | 100865 | 100865 | 37.74812528 | -122.42027883 | CESAR CHAVEZ ST \ VALENCIA ST | VALENCIA ST \ CESAR CHAVEZ ST | 1710539427000 | MTA | BIKE WAYFINDING SIGN | CESAR CHAVEZ ST intersection | 0594 | VALENCIA NEC 1 | - | - | - | - | - | 77442 | 1554297600000 | -122.42027883 | 37.74812528 | - | - | - | D9 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | SIGNAL POLE | IS | 1552654800000 | VALENCIA ST | - | - | - | - | - | - |
| 60335 | N/A | Point | - | - | - | - | S252491 | SANCHEZ ST: CESAR CHAVEZ ST | - | F | F | - | F | 21921000 | 21921000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CESAR CHAVEZ ST | CESAR CHAVEZ ST | 100866 | 100866 | 37.74756447 | -122.42927003 | SANCHEZ ST \ CESAR CHAVEZ ST | SANCHEZ ST \ CESAR CHAVEZ ST | 1754919386000 | middleware_editor | STOP | CESAR CHAVEZ ST intersection | - | - | - | - | - | - | - | 77443 | 1155020400000 | -122.42927003 | 37.74756447 | - | 1561359600000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1552657080000 | SANCHEZ ST | - | - | - | - | - | - |
| 60336 | N/A | Point | - | - | - | - | S252493 | SANCHEZ ST: CESAR CHAVEZ ST | - | F | F | - | F | 21921000 | 21921000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CESAR CHAVEZ ST | CESAR CHAVEZ ST | 100867 | 100867 | 37.74756447 | -122.42927003 | SANCHEZ ST \ CESAR CHAVEZ ST | SANCHEZ ST \ CESAR CHAVEZ ST | 1754919437000 | middleware_editor | BIKE WAYFINDING SIGN | CESAR CHAVEZ ST intersection | 0591 | ABOVE STOP SIGN | - | - | - | - | - | 77444 | 1155020400000 | -122.42927003 | 37.74756447 | - | 1554274800000 | - | D8 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | 2IN IRON POST | IS | 1552657260000 | SANCHEZ ST | - | - | - | - | - | - |
| 60337 | N/A | Point | 1 | 1 | 218 - 299 | - | S252890 | 218-299 UNION ST | 218-299 UNION ST | F | F | - | F | 12836000 | 12836000 | - | - | CENTER ISLAND | - | - | - | - | CALHOUN TER | CALHOUN TER | 100869 | 100869 | 37.80108978 | -122.40402213 | - | - | 1710539427000 | MTA | DEAD END | CALHOUN TER to MONTGOMERY ST (218 - 299) | - | 36' W OF CALHOUN TER | - | - | - | - | - | 77445 | - | -122.40402213 | 37.80108978 | - | - | - | D3 | - | OTHER WARNING | WARNING | W14-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1553853120000 | UNION ST | 218 - 299 UNION ST | 218 - 299 UNION ST | 218 UNION ST | - | MONTGOMERY ST | MONTGOMERY ST |
| 60338 | N/A | Point | - | - | - | - | S252932 | AVENUE H: 4TH TI ST | - | F | F | - | F | 34048000 | 34048000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 4TH TI ST | AVENUE H | 100870 | 100870 | 37.82188396 | -122.36771095 | AVENUE H \ 4TH TI ST | 04TH TI ST \ AVENUE H | 1710539427000 | MTA | STOP | AVENUE H intersection | - | - | - | - | - | - | - | 77446 | - | -122.36771095 | 37.82188396 | - | - | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1553937540000 | 04TH TI ST | - | - | - | - | - | - |
| 60339 | N/A | Point | - | - | - | - | S252933 | AVENUE H: 4TH TI ST | - | F | F | - | F | 34048000 | 34048000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 4TH TI ST | AVENUE H | 100871 | 100871 | 37.82188396 | -122.36771095 | AVENUE H \ 4TH TI ST | 04TH TI ST \ AVENUE H | 1710539427000 | MTA | STOP | AVENUE H intersection | - | - | - | - | - | - | - | 77447 | 1553932440000 | -122.36771095 | 37.82188396 | - | 1614816000000 | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1553937600000 | 04TH TI ST | - | - | - | - | - | - |
| 60340 | N/A | Point | - | - | - | - | S252936 | AVENUE D: 11TH TI ST | - | F | F | - | F | 34082000 | 34082000 | - | - | NORTH EAST CORNER | - | - | - | - | 11TH TI ST | AVENUE D | 100872 | 100872 | 37.82577348 | -122.37375292 | AVENUE D \ 11TH TI ST | 11TH TI ST \ AVENUE D | 1710539427000 | MTA | AVENUE D (TI) | AVENUE D intersection | - | - | - | - | - | - | - | 77448 | 1562577300000 | -122.37375292 | 37.82577348 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.1961 | 36X08 | SUP1 | 2IN IRON POST | IS | 1553938260000 | 11TH TI ST | - | - | - | - | - | - |
| 60341 | N/A | Point | - | - | - | - | S252937 | AVENUE D: 11TH TI ST | - | F | F | - | F | 34082000 | 34082000 | - | - | NORTH EAST CORNER | - | - | - | - | 11TH TI ST | AVENUE D | 100873 | 100873 | 37.82577348 | -122.37375292 | AVENUE D \ 11TH TI ST | 11TH TI ST \ AVENUE D | 1710539427000 | MTA | 11TH ST (TI) | AVENUE D intersection | - | - | - | - | - | - | - | 77449 | 1562577120000 | -122.37375292 | 37.82577348 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.1974 | 36X08 | SUP1 | 2IN IRON POST | IS | 1553938380000 | 11TH TI ST | - | - | - | - | - | - |
| 60342 | N/A | Point | - | - | - | - | S252939 | AVENUE D: 11TH TI ST | - | F | F | - | F | 34082000 | 34082000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 11TH TI ST | AVENUE D | 100874 | 100874 | 37.82577348 | -122.37375292 | AVENUE D \ 11TH TI ST | 11TH TI ST \ AVENUE D | 1710539427000 | MTA | STOP | AVENUE D intersection | - | - | - | - | - | - | - | 77450 | 1562577420000 | -122.37375292 | 37.82577348 | - | - | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1553938440000 | 11TH TI ST | - | - | - | - | - | - |
| 60343 | N/A | Point | - | - | - | - | S252535 | AVENUE H: 8TH TI ST | - | F | F | - | F | 34068000 | 34068000 | - | - | NORTH EAST CORNER | - | - | - | - | AVENUE H | AVENUE H | 100896 | 100896 | 37.82445119 | -122.36942895 | 8TH TI ST \ AVENUE H | 08TH TI ST \ AVENUE H | 1710539427000 | MTA | AVENUE H (TI) | AVENUE H intersection | - | - | - | - | - | - | - | 77451 | 1562574840000 | -122.36942895 | 37.82445119 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.1964 | 36X03 | SUP1 | 2IN IRON POST | IS | 1552738620000 | 08TH TI ST | - | - | - | - | - | - |
| 60344 | N/A | Point | - | - | - | - | S252536 | AVENUE H: 8TH TI ST | - | F | F | - | F | 34068000 | 34068000 | - | - | NORTH EAST CORNER | - | - | - | - | AVENUE H | AVENUE H | 100897 | 100897 | 37.82445119 | -122.36942895 | 8TH TI ST \ AVENUE H | 08TH TI ST \ AVENUE H | 1710539427000 | MTA | 8TH ST (TI) | AVENUE H intersection | - | - | - | - | - | - | - | 77452 | 1562574660000 | -122.36942895 | 37.82445119 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.1971 | 36X08 | SUP1 | 2IN IRON POST | IS | 1552738620000 | 08TH TI ST | - | - | - | - | - | - |
| 60345 | N/A | Point | - | - | - | - | S252537 | AVENUE I: 11TH TI ST | - | F | F | - | F | 34086000 | 34086000 | - | - | NORTH EAST CORNER | - | - | - | - | AVENUE I | 11TH TI ST | 100898 | 100898 | 37.8273816 | -122.36996948 | 11TH TI ST \ AVENUE I | AVENUE I \ 11TH TI ST | 1710539427000 | MTA | AVENUE H (TI) | 11TH TI ST intersection | - | - | - | - | - | - | - | 77453 | 1562573760000 | -122.36996948 | 37.8273816 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.1964 | 36X03 | SUP1 | 2IN IRON POST | IS | 1552739100000 | AVENUE I | - | - | - | - | - | - |
| 60346 | N/A | Point | - | - | - | - | S252538 | AVENUE I: 11TH TI ST | - | F | F | - | F | 34086000 | 34086000 | - | - | NORTH EAST CORNER | - | - | - | - | AVENUE I | 11TH TI ST | 100899 | 100899 | 37.8273816 | -122.36996948 | 11TH TI ST \ AVENUE I | AVENUE I \ 11TH TI ST | 1710539427000 | MTA | 11TH ST (TI) | 11TH TI ST intersection | - | - | - | - | - | - | - | 77454 | 1562573640000 | -122.36996948 | 37.8273816 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.1974 | 36X08 | SUP1 | 2IN IRON POST | IS | 1552739160000 | AVENUE I | - | - | - | - | - | - |
| 60347 | N/A | Point | - | - | - | - | S258765 | MARKET ST: VALENCIA ST | - | T | T | - | F | 30755000 | 30755000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MARKET ST | VALENCIA ST | 100900 | 100900 | 37.77250282 | -122.42261969 | VALENCIA ST \ MARKET ST | MARKET ST \ VALENCIA ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) | VALENCIA ST intersection | - | - | - | - | - | - | - | 77455 | 1171324800000 | -122.42261969 | 37.77250282 | - | 1580342400000 | - | D6 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP1 | OVERHEAD MAST ARM | IS | 1572344460000 | MARKET ST | - | - | - | - | - | - |
| 60348 | N/A | Point | - | 1 | 1400 - 1499 | - | S254413 | 1400-1499 FITCH ST | 1400-1499 ARELIOUS WALKER DR | F | F | - | F | 5583000 | 5583000 | - | - | EAST SIDE | - | - | - | - | QUESADA AVE | QUESADA AVE | 100955 | 100955 | 37.72561829 | -122.37867171 | - | - | 1710539427000 | MTA | NPRK 6PM-7AM | QUESADA AVE to REVERE AVE (1400 - 1499) | - | 20' SOUTH OF QUESADA AVE./SHOULD BE 1300 | - | - | - | - | - | 77456 | 1560867840000 | -122.37867171 | 37.72561829 | - | 1590710400000 | - | D10 | - | PARKING | REG | R30(CA).0022 | 12X18 | SUP1 | 2IN IRON POST | IS | 1558100460000 | ARELIOUS WALKER DR | 1400 - 1499 ARELIOUS WALKER DR | 1400 - 1499 ARELIOUS WALKER DR | 1400 ARELIOUS WALKER DR | - | REVERE AVE | REVERE AVE |
| 60349 | N/A | Point | - | - | - | - | S258084 | ELLIS ST: JONES ST | - | T | T | - | F | 24936000 | 24936000 | - | - | NORTH WEST CORNER | - | - | - | - | JONES ST | ELLIS ST | 101549 | 101549 | 37.78486625 | -122.41278213 | ELLIS ST \ JONES ST | JONES ST \ ELLIS ST | 1737648579000 | middleware_editor | JONES ST | ELLIS ST intersection | - | 400<---[] | - | - | - | - | - | 77457 | 1609163220000 | -122.41278213 | 37.78486625 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.0935 | 36X08 | SUP1 | LIGHT POLE | IS | 1570013880000 | JONES ST | - | - | - | - | - | - |
| 60350 | N/A | Point | 1 | 1 | 1701 - 1799 | - | S258088 | 1675-1799 HAIGHT ST | 1701-1799 HAIGHT ST | T | T | - | F | 6623000 | 6623000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | COLE ST | COLE ST | 101550 | 101550 | 37.76945235 | -122.45128795 | - | - | 1755539270000 | middleware_editor | "P" (WHITE-BLUE) | COLE ST to SHRADER ST (1701 - 1799) | - | WPL# 1772 HAIGHT ST. POLE# 174 | - | - | - | - | - | 77458 | 1571434200000 | -122.45128795 | 37.76945235 | - | - | - | D5 | - | OTHER GUIDE | GUIDE | G-P(SF).0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1570020060000 | HAIGHT ST | 1701 - 1799 HAIGHT ST | 1701 - 1799 HAIGHT ST | 1701 HAIGHT ST | - | SHRADER ST | SHRADER ST |
| 60351 | N/A | Point | 1 | 1 | 1701 - 1799 | VERTICAL ARROW | S258089 | 1675-1799 HAIGHT ST | 1701-1799 HAIGHT ST | T | T | - | F | 6623000 | 6623000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | COLE ST | COLE ST | 101551 | 101551 | 37.76945235 | -122.45128795 | - | - | 1755539265000 | middleware_editor | KEZAR LOT | COLE ST to SHRADER ST (1701 - 1799) | - | WPL# 1772 HAIGHT ST. POLE# 174 | - | - | - | - | - | 77459 | 1571434260000 | -122.45128795 | 37.76945235 | - | - | - | D5 | - | OTHER GUIDE | GUIDE | G-K(SF).0004 | 30X30 | SUP1 | LIGHT POLE | IS | 1570020180000 | HAIGHT ST | 1701 - 1799 HAIGHT ST | 1701 - 1799 HAIGHT ST | 1701 HAIGHT ST | - | SHRADER ST | SHRADER ST |
| 60352 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S258090 | 1800-1899 HAIGHT ST | 1800-1899 HAIGHT ST | T | T | - | F | 6624000 | 6624000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | SHRADER ST | SHRADER ST | 101552 | 101552 | 37.76927195 | -122.4527013 | - | - | 1755539301000 | middleware_editor | "P" (WHITE-BLUE) | SHRADER ST to STANYAN ST (1800 - 1899) | - | 25' EAST OF STANYAN ST. POLE# T1876 | - | - | - | - | - | 77460 | 1571434320000 | -122.4527013 | 37.76927195 | - | - | - | D5 | - | OTHER GUIDE | GUIDE | G-P(SF).0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1570020240000 | HAIGHT ST | 1800 - 1899 HAIGHT ST | 1800 - 1899 HAIGHT ST | 1800 HAIGHT ST | - | STANYAN ST | STANYAN ST |
| 60353 | N/A | Point | 1 | 1 | 1800 - 1899 | LEFT ARROW | S258091 | 1800-1899 HAIGHT ST | 1800-1899 HAIGHT ST | T | T | - | F | 6624000 | 6624000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | SHRADER ST | SHRADER ST | 101553 | 101553 | 37.76927195 | -122.4527013 | - | - | 1710539427000 | MTA | KEZAR LOT | SHRADER ST to STANYAN ST (1800 - 1899) | - | 25' EAST OF STANYAN ST. POLE# T1876 | - | - | - | - | - | 77461 | 1571356800000 | -122.4527013 | 37.76927195 | - | - | - | D5 | - | OTHER GUIDE | GUIDE | G-K(SF).0004 | 30X30 | SUP1 | LIGHT POLE | IS | 1570020360000 | HAIGHT ST | 1800 - 1899 HAIGHT ST | 1800 - 1899 HAIGHT ST | 1800 HAIGHT ST | - | STANYAN ST | STANYAN ST |
| 60354 | N/A | Point | - | - | - | - | S284975 | 12TH ST: SOUTH VAN NESS AVE | - | F | F | - | F | 24358000 | 24358000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 12TH ST | 12TH ST | 101601 | 101601 | 37.77222218 | -122.41835203 | SOUTH VAN NESS AVE \ 12TH ST | SOUTH VAN NESS AVE \ 12TH ST | 1710539427000 | MTA | STOP | 12TH ST intersection | - | - | - | - | - | - | - | 77462 | 1664409600000 | -122.41835203 | 37.77222218 | - | - | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1662649620000 | SOUTH VAN NESS AVE | - | - | - | - | - | - |
| 60355 | N/A | Point | - | - | - | - | S284976 | 12TH ST: SOUTH VAN NESS AVE | - | F | F | - | F | 24358000 | 24358000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 12TH ST | 12TH ST | 101602 | 101602 | 37.77222218 | -122.41835203 | SOUTH VAN NESS AVE \ 12TH ST | SOUTH VAN NESS AVE \ 12TH ST | 1756224964000 | middleware_editor | RIGHT TURN ONLY (SYM) | 12TH ST intersection | - | - | - | - | - | - | - | 77463 | 1665558000000 | -122.41835203 | 37.77222218 | - | - | - | D6 | - | OTHER REGULATORY | REG | R3-5.0001 | 24X30 | SUP1 | 2IN IRON POST | IS | 1662649680000 | SOUTH VAN NESS AVE | - | - | - | - | - | - |
| 60356 | N/A | Point | 1 | 1 | 40 - 99 | - | S284977 | 40-99 12TH ST | 40-99 12TH ST | F | F | - | F | 541000 | 541000 | - | - | WEST SIDE | - | - | - | - | STEVENSON ST | STEVENSON ST | 101603 | 101603 | 37.77346728 | -122.41914825 | - | - | 1752093802000 | middleware_editor | NPRK 12MN-6AM MON WED FRI STCL | STEVENSON ST to MISSION ST \ OTIS ST \ SOUTH VAN NESS AVE (40 - 99) | - | 30' NORTH OF SOUTH VAN NESS | - | - | - | - | - | 77464 | 1682492400000 | -122.41914825 | 37.77346728 | - | - | 1752079200000 | D6 | - | STREET CLEANING | REG | R30B(CA).0051 | 18X18 | SUP1 | 2IN IRON POST | RETD | 1662649980000 | 12TH ST | 40 - 99 12TH ST | 40 - 99 12TH ST | 40 12TH ST | - | MISSION ST \ OTIS ST \ SOUTH VAN NESS AVE | MISSION ST \ OTIS ST \ SOUTH VAN NESS AVE |
| 60357 | N/A | Point | - | - | - | - | S284978 | MANSELL ST: GIRARD ST | - | F | F | - | F | 20572000 | 20572000 | - | - | NORTH WEST CORNER | - | - | - | - | MANSELL ST | GIRARD ST | 101604 | 101604 | 37.72127745 | -122.40205647 | GIRARD ST \ MANSELL ST | MANSELL ST \ GIRARD ST | 1716395347000 | middleware_editor | MANSELL ST | GIRARD ST intersection | - | 100--->WEST | - | - | - | - | - | 77465 | - | -122.40205647 | 37.72127745 | - | 1671408000000 | - | D10 | - | STREET NAME | GUIDE | D3-1.1110 | 36X08 | SUP1 | 3IN IRON POST | IS | 1662652080000 | MANSELL ST | - | - | - | - | - | - |
| 60358 | N/A | Point | - | - | - | - | S284979 | MANSELL ST: GIRARD ST | - | F | F | - | F | 20572000 | 20572000 | - | - | NORTH WEST CORNER | - | - | - | - | MANSELL ST | GIRARD ST | 101605 | 101605 | 37.72127745 | -122.40205647 | GIRARD ST \ MANSELL ST | MANSELL ST \ GIRARD ST | 1716427409000 | middleware_editor | GIRARD ST | GIRARD ST intersection | - | SOUTH<---900 | - | - | - | - | - | 77466 | - | -122.40205647 | 37.72127745 | - | 1671408000000 | - | D10 | - | STREET NAME | GUIDE | D3-1.0735 | 36X08 | SUP1 | 3IN IRON POST | IS | 1662652080000 | MANSELL ST | - | - | - | - | - | - |
| 60359 | N/A | Point | - | - | - | - | S284678 | BONVIEW ST: EUGENIA AVE | - | F | F | - | F | 21249000 | 21249000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | EUGENIA AVE | BONVIEW ST | 101606 | 101606 | 37.74078867 | -122.41834709 | BONVIEW ST \ EUGENIA AVE | EUGENIA AVE \ BONVIEW ST | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | BONVIEW ST intersection | - | ABOVE DEAD END SIGN | - | - | - | - | - | 77467 | 1661385600000 | -122.41834709 | 37.74078867 | - | - | - | D9 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | 2IN IRON POST | IS | 1661335380000 | EUGENIA AVE | - | - | - | - | - | - |
| 60360 | N/A | Point | 1 | 1 | 100 - 199 | - | S284680 | 100-199 BONVIEW ST | 100-199 BONVIEW ST | F | F | - | F | 3013000 | 3013000 | - | - | EAST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | START: 100-199 BLOCK | START: 100-199 BLOCK | 101607 | 101607 | 37.74150871 | -122.41783042 | - | - | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | START: 100-199 BLOCK to EUGENIA AVE (100 - 199) | - | OPP 144 IN DIRT ON TRAIL | - | - | - | - | - | 77468 | 1661385600000 | -122.41783042 | 37.74150871 | - | - | - | D9 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | 2IN IRON POST | IS | 1661336220000 | BONVIEW ST | 100 - 199 BONVIEW ST | 100 - 199 BONVIEW ST | 100 BONVIEW ST | - | EUGENIA AVE | EUGENIA AVE |
| 60361 | N/A | Point | 1 | 1 | 500 - 599 | - | S278326 | 500-599 HARMONIA ST | 500-599 HARMONIA ST | F | F | - | F | 15260000 | 15260000 | - | - | SOUTH SIDE | - | - | - | - | HAHN ST | HAHN ST | 108320 | 108320 | 37.71135377 | -122.41702209 | - | - | 1710539427000 | MTA | NPRK 8AM-11AM WED STCL | HAHN ST to MALOSI ST (500 - 599) | - | 75' EAST OF MALOSI | - | - | - | - | - | 77469 | 1634653320000 | -122.41702209 | 37.71135377 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0278 | 18X18 | SUP1 | 2IN IRON POST | IS | 1634635920000 | HARMONIA ST | 500 - 599 HARMONIA ST | 500 - 599 HARMONIA ST | 500 HARMONIA ST | - | MALOSI ST | MALOSI ST |
| 60362 | N/A | Point | 1 | 1 | 500 - 599 | RIGHT ARROW | S278327 | 500-599 HARMONIA ST | 500-599 HARMONIA ST | F | F | - | F | 15260000 | 15260000 | - | - | SOUTH SIDE | - | - | - | - | HAHN ST | HAHN ST | 108321 | 108321 | 37.71135377 | -122.41702209 | - | - | 1710539427000 | MTA | NPRK 8AM-11AM WED STCL | HAHN ST to MALOSI ST (500 - 599) | - | 150' WEST OF HAHN ST | - | - | - | - | - | 77470 | 1634653500000 | -122.41702209 | 37.71135377 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0278 | 18X18 | SUP1 | 2IN IRON POST | IS | 1634635980000 | HARMONIA ST | 500 - 599 HARMONIA ST | 500 - 599 HARMONIA ST | 500 HARMONIA ST | - | MALOSI ST | MALOSI ST |
| 60363 | N/A | Point | 1 | 1 | 500 - 599 | - | S278329 | 500-599 HARMONIA ST | 500-599 HARMONIA ST | F | F | - | F | 15260000 | 15260000 | - | - | SOUTH SIDE | - | - | - | - | HAHN ST | HAHN ST | 108322 | 108322 | 37.71135377 | -122.41702209 | - | - | 1710539427000 | MTA | NO STOPPING ANYTIME | HAHN ST to MALOSI ST (500 - 599) | - | 70' WEST OF HAHN ST | - | - | - | - | - | 77471 | 1636027980000 | -122.41702209 | 37.71135377 | - | 1707221700000 | - | D10 | - | OTHER REGULATORY | REG | R26S(CA).0001 | 18X18 | SUP1 | 2IN IRON POST | IS | 1634636100000 | HARMONIA ST | 500 - 599 HARMONIA ST | 500 - 599 HARMONIA ST | 500 HARMONIA ST | - | MALOSI ST | MALOSI ST |
| 60364 | N/A | Point | - | - | - | - | S278330 | HAHN ST: SUNRISE WAY | - | F | F | - | F | 20406000 | 20406000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HAHN ST | HAHN ST | 108323 | 108323 | 37.70995038 | -122.41688355 | SUNRISE WAY \ HAHN ST | SUNRISE WAY \ HAHN ST | 1750785658000 | middleware_editor | STOP | HAHN ST intersection | - | 10' WEST OF HAHN ST. | - | - | - | - | - | 77472 | 1635836400000 | -122.41688355 | 37.70995038 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1634636460000 | SUNRISE WAY | - | - | - | - | - | - |
| 60365 | N/A | Point | - | - | - | - | S278331 | HAHN ST: SUNRISE WAY | - | F | F | - | F | 20406000 | 20406000 | - | - | SOUTH WEST CORNER | - | - | - | - | HAHN ST | HAHN ST | 108324 | 108324 | 37.70995038 | -122.41688355 | SUNRISE WAY \ HAHN ST | SUNRISE WAY \ HAHN ST | 1710539427000 | MTA | HARMONIA | HAHN ST intersection | - | X-ST IS HARMONIA ST/5' SOUTH OF HARMONIA | - | - | - | - | - | 77473 | 1634515200000 | -122.41688355 | 37.70995038 | - | 1654128000000 | - | D10 | - | STREET NAME | GUIDE | D3-1.2020 | 38X08 | SUP1 | LIGHT POLE | IS | 1634636940000 | SUNRISE WAY | - | - | - | - | - | - |
| 60366 | N/A | Point | - | - | - | - | S278332 | HAHN ST: SUNRISE WAY | - | F | F | - | F | 20406000 | 20406000 | - | - | SOUTH WEST CORNER | - | - | - | - | HAHN ST | HAHN ST | 108325 | 108325 | 37.70995038 | -122.41688355 | SUNRISE WAY \ HAHN ST | SUNRISE WAY \ HAHN ST | 1710539427000 | MTA | HAHN ST | HAHN ST intersection | - | X-ST IS HARMONIA/5' SOUTH OF HARMONIA | - | - | - | - | - | 77474 | 1634601600000 | -122.41688355 | 37.70995038 | - | 1654128000000 | - | D10 | - | STREET NAME | GUIDE | D3-1.0783 | 36X08 | SUP1 | LIGHT POLE | IS | 1634637000000 | SUNRISE WAY | - | - | - | - | - | - |
| 60367 | N/A | Point | - | - | - | - | S278338 | SUNRISE WAY: END | - | F | F | - | F | 51044000 | 51044000 | - | - | SOUTH EAST CORNER | - | - | - | - | START: 324-399 BLOCK | START: 324-399 BLOCK | 108327 | 108327 | 37.70957921 | -122.41551859 | SUNRISE WAY \ START: 324-399 BLOCK | SUNRISE WAY \ START: 324-399 BLOCK | 1710539427000 | MTA | MALOSI | START: 324-399 BLOCK intersection | - | - | - | - | - | - | - | 77475 | 1634515200000 | -122.41551859 | 37.70957921 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.2021 | 38X08 | SUP1 | 3IN IRON POST | IS | 1634637660000 | SUNRISE WAY | - | - | - | - | - | - |
| 60368 | N/A | Point | - | - | - | - | S275539 | RIVERA ST: 38TH AVE | - | F | F | - | F | 23465000 | 23465000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | RIVERA ST | 38TH AVE | 108330 | 108330 | 37.74588052 | -122.49630947 | 38TH AVE \ RIVERA ST | RIVERA ST \ 38TH AVE | 1744399639000 | middleware_editor | SCHOOL (SYM)/ 45 LEFT DN ARROW (COMBO) | 38TH AVE intersection | - | - | - | - | - | - | - | 77476 | 1044950400000 | -122.49630947 | 37.74588052 | - | 1739223420000 | - | D4 | - | SCHOOL | WARNING | SW24-2(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1623926460000 | RIVERA ST | - | - | - | - | - | - |
| 60369 | N/A | Point | - | - | - | - | S275681 | LAPU-LAPU ST: HARRISON ST | - | F | F | - | F | 24579000 | 24579000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LAPU-LAPU ST | HARRISON ST | 108333 | 108333 | 37.78179877 | -122.39834111 | LAPU-LAPU ST: HARRISON ST | LAPU-LAPU ST \ HARRISON ST | 1716471411000 | middleware_editor | LOCAL TRAFFIC ONLY/ BIKE, PED (SYM)(COMBO) | HARRISON ST intersection | - | 12"6 FT FROM FROM CURB MIDDLE OF STREET | - | - | - | - | - | 77477 | 738028800000 | -122.39834111 | 37.78179877 | - | 1681689600000 | - | D6 | - | PEDESTRIAN | REG | R(SF).0453 | 12X36 | SUP1 | STANDARD BASE | IS | 1624525560000 | LAPU-LAPU ST | - | - | - | - | - | - |
| 60370 | N/A | Point | - | - | - | - | S275686 | LAPU-LAPU ST: HARRISON ST | - | F | F | - | F | 24579000 | 24579000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LAPU-LAPU ST | HARRISON ST | 108334 | 108334 | 37.78179877 | -122.39834111 | LAPU-LAPU ST: HARRISON ST | LAPU-LAPU ST \ HARRISON ST | 1716471407000 | middleware_editor | FG 300 UR DELINEATOR (W) | HARRISON ST intersection | - | 14 FT FROM FROM CURB MIDDLE OF STREET | - | - | - | - | - | 77478 | 738028800000 | -122.39834111 | 37.78179877 | - | 1625702400000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1624525980000 | LAPU-LAPU ST | - | - | - | - | - | - |
| 60371 | N/A | Point | 1 | 1 | 4300 - 4399 | - | S277274 | 4300-4399 OCEAN AVE | 4300-4399 OCEAN AVE | F | F | - | F | 9867000 | 9867000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | HAVENSIDE DR | HAVENSIDE DR | 109077 | 109077 | 37.73206596 | -122.49016761 | - | - | 1724344939000 | middleware_editor | (45 LA-DN) | HAVENSIDE DR to WESTMOORLAND DR (4300 - 4399) | - | OPP.SE CORNOR | - | - | - | - | - | 77479 | 1253577600000 | -122.49016761 | 37.73206596 | - | 1632787200000 | - | D7 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP2 | LIGHT POLE | IS | 1630330260000 | OCEAN AVE | 4300 - 4399 OCEAN AVE | 4300 - 4399 OCEAN AVE | 4300 OCEAN AVE | - | WESTMOORLAND DR | WESTMOORLAND DR |
| 60372 | N/A | Point | - | - | - | - | S277275 | OCEAN AVE: HAVENSIDE DR | - | F | F | - | F | 23303000 | 23303000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HAVENSIDE DR | OCEAN AVE | 109078 | 109078 | 37.73208457 | -122.489744 | OCEAN AVE \ HAVENSIDE DR | HAVENSIDE DR \ OCEAN AVE | 1724375225000 | middleware_editor | (45 LA-DN) | OCEAN AVE intersection | - | - | - | - | - | - | - | 77480 | 1253577600000 | -122.489744 | 37.73208457 | - | 1632873600000 | - | D7 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP2 | 2IN IRON POST | IS | 1630330440000 | HAVENSIDE DR | - | - | - | - | - | - |
| 60373 | N/A | Point | - | 1 | 1 - 99 | - | S277276 | 1-99 HARDING RD | 1-99 HARDING RD | F | F | - | F | 6674000 | 6674000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | SKYLINE BLVD | SKYLINE BLVD | 109079 | 109079 | 37.7250493 | -122.49783833 | - | - | 1710539427000 | MTA | (45 LA-DN) | SKYLINE BLVD to END: 1-99 BLOCK (1 - 99) | - | 150' EAST OF ENTRANCE TO GOLF COURS..... | - | - | - | - | - | 77481 | 1136937600000 | -122.49783833 | 37.7250493 | - | 1632700800000 | - | D7 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP2 | 2IN IRON POST | IS | 1630331340000 | HARDING RD | 1 - 99 HARDING RD | 1 - 99 HARDING RD | 1 HARDING RD | - | END: 1-99 BLOCK | END: 1-99 BLOCK |
| 60374 | N/A | Point | - | - | - | - | S235214 | ADDISON ST: DIAMOND HEIGHTS BL | - | F | F | - | F | 21990000 | 21990000 | - | - | NORTH EAST CORNER | - | - | - | - | DIAMOND HEIGHTS BLVD \ GOLD MINE DR | DIAMOND HEIGHTS BLVD \ GOLD MINE DR | 109763 | 109763 | 37.74015348 | -122.43583958 | ADDISON ST \ DIAMOND HEIGHTS BLVD \ GOLD MINE DR | ADDISON ST \ DIAMOND HEIGHTS BLVD \ GOLD MINE DR | 1710539427000 | MTA | ALL WAY | DIAMOND HEIGHTS BLVD \ GOLD MINE DR intersection | - | OF ADDISON ST & DIAMOND HGTS. -F/W/B/T | - | - | - | - | - | 77482 | - | -122.43583958 | 37.74015348 | - | - | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 3IN IRON POST | IS | 1492155540000 | ADDISON ST | - | - | - | - | - | - |
| 60375 | N/A | Point | - | - | - | - | S231999 | KISKA RD: DORMITORY RD \ KIRKW | - | F | F | - | F | 20046000 | 20046000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | DORMITORY RD \ KISKA RD | DORMITORY RD \ KIRKWOOD AVE | 109764 | 109764 | 37.72965969 | -122.37492808 | KIRKWOOD AVE \ DORMITORY RD \ KISKA RD | KISKA RD \ DORMITORY RD \ KIRKWOOD AVE | 1710539427000 | MTA | (45 LA-DN) | DORMITORY RD \ KIRKWOOD AVE intersection | - | - | - | - | - | - | - | 77483 | 1483613940000 | -122.37492808 | 37.72965969 | - | 1483574400000 | - | D10 | - | OTHER WARNING | WARNING | W16-7P.0001 | 18X18 | SUP1 | 2IN IRON POST | IS | 1482418800000 | KISKA RD | - | - | - | - | - | - |
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.