MTA.signshop_assets
No additional information has been provided for this dataset.
Between for ranges (e.g., 10,100)Regex for pattern matchingCase sensitive for exact matches
| ID | Feature ID | Geometry Type | ACCEPTED | ACTIVE | ADDRANGE | ARROW DIR | ASSET ID | ASSET NAME | ASSET NAME 1 | BAPA | BOOM TRUCK | CANCEL | CLEARANCE PERMIT | CNN | CNN 1 | COMBOKEY | CONDITION | CORNER SIDE FACING | CREATED DATE | CREATED USER | CURLYIDS | ETL | FROM ST | FROM ST 1 | GISOBJID | GLOBALID UDFCHAR44 | GPS LATITUDE | GPS LONGITUDE | INTERSECTION | INTERSECTION 1 | LAST EDITED DATE | LAST EDITED USER | LEGEND | LIMITS | LOCATION TRACK ID | LOC SPEC | NEW PURPOSE | NEW SIGN CODE | NEW SIGN LEGEND | NEW SIGN SIZE | NUM OF ASSETS | OBJECTID 1 | ORIG INSTALL DATE | POINT X | POINT Y | PURPOSE | REPLACEMENT DATE | RETIREMENT DATE | SF SUP DISTRICT | SHEETING | SIGN CATEGORY | SIGN CLASS | SIGN CODE | SIGN SIZE | SIGN SUPERVISOR | SIGN SUPPORT | STATUS CODE | STATUS DATE | STREETNAME | STREET ADDRESS RANGE | STREET ADDRESS RANGE 1 | STREET BLOCK | STREET VIEW | TO ST | TO ST 1 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 144601 | N/A | Point | - | - | - | - | 46569 | - | - | - | - | - | - | 4408000 | - | - | - | SOUTH SIDE | 1741107544000 | MALOPEZ | - | - | 05TH AVE | - | 296673 | {44F01BB8-FA10-4FF9-BE9E-C4662462E3BB} | 37.784984635273034 | -122.46412038959843 | - | - | 1741301430000 | middleware_editor | MUNI LOCAL (FLAG) BLUE | - | 17844 | 97' E OF 6TH AVE | - | - | - | - | 1 | 296673 | 1741283100000 | - | - | - | - | - | 01 | - | OTHER GUIDE | GUIDE | G-L(SF).0036 | 18X30 | SUP2 | 2IN FLANGE POST | IS | - | CORNWALL ST | 4300 CALIFORNIA ST | - | - | - | 06TH AVE | - |
| 144602 | N/A | Point | - | - | - | - | 46606 | - | - | - | - | - | - | 7359000 | - | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | 1741107544000 | MALOPEZ | - | - | DRUMM ST | - | 296674 | {1D4034A8-A154-47F6-8114-52A2E2CC50AC} | 37.7971576451701 | -122.397393902017 | - | - | 1744121419000 | middleware_editor | (45 LA-DN) | - | - | 25' W OF DRUMM | - | - | - | - | - | 296674 | - | - | - | - | 1742406300000 | - | 03 | - | OTHER WARNING | WARNING | W16-7P.0001 | 18X18 | SUP1 | 2IN IRON POST | IS | - | JACKSON ST | 1 - 99 JACKSON ST | - | - | - | DAVIS CT \ DAVIS ST | - |
| 144603 | N/A | Point | - | - | - | - | 46571 | - | - | F | F | - | F | 27793000 | - | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | 1741107561000 | elclark | - | - | MARTIN LUTHER KING JR DR | - | 296689 | {CD5DB4E4-9A52-4C30-849A-B79CF03CFF5B} | 37.76498781042176 | -122.50093951820814 | CHAIN OF LAKES DR \ MARTIN LUTHER KING JR DR | - | 1742340214000 | middleware_editor | (LA) SOUTHBOUND TRAFFIC USE MLK TO SUNSET | - | - | NWC ABOVE STOP SIGN | - | - | - | - | - | 296689 | 1742331180000 | - | - | - | - | - | 04 | - | OTHER GUIDE | GUIDE | G-S(SF).0081 | 30X30 | SUP2 | 2IN IRON POST | IS | - | CHAIN OF LAKES DR | - | - | - | - | - | - |
| 144604 | N/A | Point | - | - | - | - | 46589 | - | - | F | F | - | F | 20172000 | - | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | 1741107561000 | elclark | - | - | CATALINA ST | - | 296690 | {881D4FAF-6B52-4E7D-86D2-C8C959790080} | 37.73618792672166 | -122.37936252445016 | MIDDLE POINT RD \ CATALINA ST | - | 1741126077000 | middleware_editor | ALL WAY | - | - | - | - | - | - | - | - | 296690 | - | - | - | - | 1741117800000 | - | 10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | - | MIDDLE POINT RD | - | - | - | - | - | - |
| 144605 | N/A | Point | - | - | - | - | 46570 | - | - | - | - | - | - | 4408000 | - | - | - | SOUTH SIDE | 1741102829000 | evillan | - | - | 05TH AVE | - | 296705 | {664AD774-F338-46DA-958E-7F271B5DFD20} | 37.784983575377204 | -122.46413648285251 | - | - | 1741301475000 | middleware_editor | SOLAR LANTERN WHITE (V5) | - | - | 97' E OF 6TH AVE | - | - | - | - | 1 | 296705 | 1741286880000 | - | - | - | - | - | 01 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP2 | 2IN FLANGE POST | IS | - | CORNWALL ST | 4300 CALIFORNIA ST | - | - | - | 06TH AVE | - |
| 144606 | N/A | Point | - | - | - | - | 46580 | - | - | - | - | - | - | 25243000 | - | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | 1741102829000 | evillan | - | - | JONES ST | - | 296706 | {2A6D8E3F-0488-4C5E-BD5B-14165160819F} | 37.79317686676935 | -122.41455817705977 | CLAY ST \ JONES ST | - | 1741219565000 | middleware_editor | MUNI LOCAL (FLAG) BLUE | - | 14020 | ABOVE STOP SIGN NEXT TO ONE WAY | - | - | - | - | 1 | 296706 | 1741215120000 | - | - | - | - | - | 03 | - | OTHER GUIDE | GUIDE | G-L(SF).0036 | 18X30 | SUP1 | 2IN IRON POST | IS | - | CLAY ST | - | - | - | - | - | - |
| 144607 | N/A | Point | - | - | - | - | 46583 | - | - | F | T | - | F | 3873000 | - | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | 1741102829000 | evillan | - | - | BAY ST \ FILLMORE ST | - | 296707 | {7E1B0859-91A9-4983-94F6-96A659215A45} | 37.80289002033559 | -122.43715423009871 | - | - | 1741626282000 | middleware_editor | LEAVING TSUNAMI HAZARD ZONE | - | - | EPL #25 CERVANTE BELOW SCHOOL AHEAD | - | - | - | - | - | 296707 | 1741387800000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | EM-1A.0003 | 24X24 | SUP2 | LIGHT POLE | IS | - | CERVANTES BLVD | 1 - 25 CERVANTES BLVD | - | - | - | ALHAMBRA ST | - |
| 144608 | N/A | Point | - | - | - | - | 46591 | - | - | F | F | - | F | 20175000 | - | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | 1741102829000 | evillan | - | - | INGALLS ST \ INNES AVE | - | 296708 | {A4E7A4DC-E7BC-4537-B92A-E8C9C582DE4E} | 37.734191624378525 | -122.37951323389497 | MIDDLE POINT RD \ INGALLS ST \ INNES AVE | - | 1741127927000 | middleware_editor | ALL WAY | - | - | - | - | - | - | - | - | 296708 | - | - | - | - | - | - | 10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | LIGHT POLE | PI | - | MIDDLE POINT RD | - | - | - | - | - | - |
| 144609 | N/A | Point | - | - | - | - | 46572 | - | - | F | F | - | T | 22928000 | - | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | 1741108189000 | evillan | - | - | WEST PORTAL AVE | - | 296721 | {9EECF2FB-CC59-4F4D-BEB3-48351D8B9EF5} | 37.74088246707156 | -122.4659928442202 | ULLOA ST \ WEST PORTAL AVE | - | 1741881822000 | middleware_editor | TREE TOP 6FT SPEED BUMP | - | - | MIDDLE OF STREET 1 OF 5 | - | - | - | - | - | 296721 | 1741795200000 | - | - | - | - | - | 07 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP3 | ANCHORS | IS | - | ULLOA ST | - | - | - | - | - | - |
| 144610 | N/A | Point | - | - | - | - | 46588 | - | - | - | - | - | - | 13171201 | - | - | - | EAST SIDE | 1741108189000 | evillan | - | - | CHESTNUT ST | - | 296722 | {0CA063C3-D8C8-42C5-BFCE-E308EFD5C763} | 37.802502189437945 | -122.42461871168571 | - | - | 1741219571000 | middleware_editor | SOLAR LANTERN WHITE (V5) | - | - | IFO 2096 VAN NESS | - | - | - | - | 1 | 296722 | 1741215240000 | - | - | - | - | - | 02 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP2 | 2IN FLANGE POST | IS | - | VAN NESS AVE | 2900 - 2998 VAN NESS AVE | - | - | - | FRANCISCO ST | - |
| 144611 | N/A | Point | - | - | - | - | 46590 | - | - | F | F | - | F | 20175000 | - | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | 1741108189000 | evillan | - | - | INGALLS ST \ INNES AVE | - | 296723 | {E5A7ABAD-35A9-4F7A-AD64-57A0AD447030} | 37.734191624378525 | -122.37951323389497 | MIDDLE POINT RD \ INGALLS ST \ INNES AVE | - | 1741129719000 | middleware_editor | STOP | - | - | - | - | - | - | - | - | 296723 | - | - | - | - | - | - | 10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | PI | - | MIDDLE POINT RD | - | - | - | - | - | - |
| 144612 | N/A | Point | - | - | - | - | 46609 | - | - | F | T | - | F | 7987000 | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1741108189000 | evillan | - | - | NORTH POINT ST | - | 296724 | {E587B552-B3FB-47B7-93E1-1BA7668A920E} | 37.804452456815675 | -122.43182273694866 | - | - | 1741626443000 | middleware_editor | ENTERING TSUNAMI HAZAED ZONE | - | - | 60' N OF NORTH POINT | - | - | - | - | - | 296724 | 1741383600000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | EM-1A.0002 | 24X24 | SUP2 | LIGHT POLE | IS | - | LAGUNA ST | 3600 - 3699 LAGUNA ST | - | - | - | MARINA BLVD | - |
| 144613 | N/A | Point | - | - | - | - | 46574 | - | - | F | F | - | T | 22928000 | - | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | 1741108391000 | evillan | - | - | WEST PORTAL AVE | - | 296737 | {8F55F0DE-20A3-4FE5-AC02-8173F799009D} | 37.740879285487516 | -122.46599016201118 | ULLOA ST \ WEST PORTAL AVE | - | 1741881693000 | middleware_editor | TREE TOP 6FT SPEED BUMP | - | - | MIDDLE OF STREET 3 OF 5 | - | - | - | - | - | 296737 | 1741798800000 | - | - | - | - | - | 07 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP3 | ANCHORS | IS | - | ULLOA ST | - | - | - | - | - | - |
| 144614 | N/A | Point | - | - | - | - | 46575 | - | - | F | F | - | T | 22928000 | - | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | 1741102849000 | evillan | - | - | WEST PORTAL AVE | - | 296753 | {FFCED5E9-9886-43D2-9009-29732294C1F5} | 37.74086496835763 | -122.46598479759315 | ULLOA ST \ WEST PORTAL AVE | - | 1741881700000 | middleware_editor | TREE TOP 6FT SPEED BUMP | - | - | MIDDLE OF STREET 4 OF 5 | - | - | - | - | - | 296753 | 1741800600000 | - | - | - | - | - | 07 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP3 | ANCHORS | IS | - | ULLOA ST | - | - | - | - | - | - |
| 144615 | N/A | Point | - | - | - | - | 46577 | - | - | F | F | - | T | 22928000 | - | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | 1741108546000 | evillan | - | - | WEST PORTAL AVE | - | 296769 | {A64810BC-6A04-4A2B-856F-37250D0886CF} | 37.74087451311119 | -122.46598882090666 | ULLOA ST \ WEST PORTAL AVE | - | 1741881737000 | middleware_editor | TREE TOP 6FT SPEED BUMP | - | - | MIDDLE OF STREET 5 OF 5 | - | - | - | - | - | 296769 | 1741802400000 | - | - | - | - | - | 07 | - | OTHER WARNING | WARNING | W(SF).0109 | 72X18 | SUP3 | ANCHORS | IS | - | ULLOA ST | - | - | - | - | - | - |
| 144616 | N/A | Point | - | - | - | - | 46576 | - | - | F | F | - | F | 3555000 | - | - | - | SOUTH SIDE | 1741108554000 | MALOPEZ | - | - | BUCHANAN ST | - | 296785 | {1D01FD34-B565-45BF-8E21-43CB4E2FA796} | 37.78907607325829 | -122.43192794523385 | - | - | 1741108747000 | middleware_editor | SCHOOL (SYM)/SCHOOL | - | - | WPL 2977 CALIFORNIA | - | - | - | - | 1 | 296785 | - | - | - | - | - | 1741108680000 | 02 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | RETD | - | CALIFORNIA ST | 2200 - 2299 CALIFORNIA ST | - | - | - | WEBSTER ST | - |
| 144617 | N/A | Point | - | - | - | - | 46608 | - | - | F | T | - | F | 25458000 | - | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | 1741108554000 | MALOPEZ | - | - | POWELL ST | - | 296786 | {D9428479-2F17-4C3F-AEA0-DFA67A70CA55} | 37.804863406697635 | -122.4116519483194 | FRANCISCO ST \ POWELL ST | - | 1746044453000 | middleware_editor | SCHOOL (SYM)/SCHOOL | - | - | - | - | - | - | - | - | 296786 | - | - | - | - | 1746043200000 | - | 03 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP1 | LIGHT POLE | IS | - | FRANCISCO ST | - | - | - | - | - | - |
| 144618 | N/A | Point | - | - | - | - | 46578 | - | - | F | T | - | F | 26764000 | - | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | 1741108318000 | evillan | - | - | BAY ST \ FILLMORE ST | - | 296801 | {01E15084-2170-4F06-8FF6-B2FAE5E5E55B} | 37.80282621995837 | -122.43659714228491 | CERVANTES BLVD \ BAY ST \ FILLMORE ST | - | 1741626286000 | middleware_editor | ENTERING TSUNAMI HAZARD ZONE | - | - | NEC FILLMORE / BAY | - | - | - | - | - | 296801 | 1741388280000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | EM-1A.0002 | 24X24 | SUP2 | MUNI POLE | IS | - | CERVANTES BLVD | - | - | - | - | - | - |
| 144619 | N/A | Point | - | - | - | - | 46579 | - | - | F | T | - | F | 5568101 | - | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1741108318000 | evillan | - | - | CHESTNUT ST | - | 296802 | {E23C64EB-F1D7-4F6D-ABDF-B2C4B716AAEF} | 37.8024836858866 | -122.436810367267 | - | - | 1741626238000 | middleware_editor | LEAVING TSUNAMI HAZARD ZONE | - | - | SPL #3575 FILLMORE | - | - | - | - | - | 296802 | 1741388100000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | EM-1A.0003 | 24X24 | SUP2 | MUNI POLE | IS | - | FILLMORE ST | 3401 - 3599 FILLMORE ST | - | - | - | BAY ST \ CERVANTES BLVD | - |
| 144620 | N/A | Point | - | - | - | - | 46582 | - | - | F | F | - | F | 3873000 | - | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | 1741103860000 | gorr | - | - | BAY ST \ FILLMORE ST | - | 296817 | {D64897A5-87DC-4C48-94B3-7B5B3863AFF8} | 37.803006336093404 | -122.43710251294364 | - | - | 1741626265000 | middleware_editor | ENTERING TSUNAMI HAZARD ZONE | - | - | NWC 5' E OF FIRE HYDRANT | - | - | - | - | - | 296817 | 1741387980000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | EM-1A.0002 | 24X24 | SUP2 | 2IN IRON POST | IS | - | CERVANTES BLVD | 1 - 25 CERVANTES BLVD | - | - | - | ALHAMBRA ST | - |
| 144621 | N/A | Point | - | - | - | - | 46584 | - | - | F | T | - | F | 15101000 | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1741110925000 | elclark | - | - | BEACH ST | - | 296833 | {10AD17B6-A04D-4A63-A615-E4C7CC0A4BB9} | 37.80543794894382 | -122.42521077341391 | - | - | 1741626279000 | middleware_editor | ENTERING TSUNAMI HAZARD ZONE | - | - | 87' N OF NORTH POINT | - | - | - | - | - | 296833 | 1741386900000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | EM-1A.0002 | 24X24 | SUP2 | MUNI POLE | IS | - | VAN NESS AVE | 3300 - 3399 VAN NESS AVE | - | - | - | END: 3200-3299 BLOCK | - |
| 144622 | N/A | Point | - | - | - | - | 46585 | - | - | - | - | - | - | 13171201 | - | - | - | EAST SIDE | 1741102872000 | evillan | - | - | CHESTNUT ST | - | 296849 | {5A338B29-9892-4898-8931-2A416AF4C11D} | 37.8025115024854 | -122.42461954950755 | - | - | 1741219589000 | middleware_editor | MUNI LOCAL (FLAG) BLUE | - | 16800 | IFO 2096 VAN NESS | - | - | - | - | 1 | 296849 | 1741214520000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | G-L(SF).0036 | 18X30 | SUP2 | 2IN FLANGE POST | IS | - | VAN NESS AVE | 2900 - 2998 VAN NESS AVE | - | - | - | FRANCISCO ST | - |
| 144623 | N/A | Point | - | - | - | - | 46593 | - | - | - | - | - | - | 8761101 | - | - | - | CENTER ISLAND, W LINE, EASTBOUND | 1741102872000 | evillan | - | - | GUERRERO ST \ LAGUNA ST | - | 296850 | {A4E317FB-7E15-4CA8-9958-31CBD52043FA} | 37.77055253532807 | -122.42491871224772 | - | - | 1741113927000 | middleware_editor | MUNI LOCAL (FLAG) BLUE | - | 15675 | 5' E OF SHELTER | - | - | - | - | 1 | 296850 | - | - | - | - | - | 1741113840000 | 08 | - | OTHER GUIDE | GUIDE | G-L(SF).0036 | 18X30 | SUP3 | 2IN FLANGE POST | RETD | - | MARKET ST | 1901 - 1963 MARKET ST | - | - | - | BUCHANAN ST \ DUBOCE AVE | - |
| 144624 | N/A | Point | - | - | - | - | 46586 | - | - | F | T | - | F | 13173101 | - | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1741102885000 | evillan | - | - | BAY ST | - | 296865 | {A1347078-534E-43C6-A5CC-E203CFAFEB46} | 37.8044429973822 | -122.425337769925 | - | - | 1741626276000 | middleware_editor | LEAVING TSUNAMI HAZARD ZONE | - | - | 82' N OF BAY | - | - | - | - | - | 296865 | 1741386660000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | EM-1A.0003 | 24X24 | SUP2 | LIGHT POLE | IS | - | VAN NESS AVE | 3101 - 3199 VAN NESS AVE | - | - | - | NORTH POINT ST | - |
| 144625 | N/A | Point | - | - | - | - | 46592 | - | - | - | - | - | T | 8761101 | - | - | - | CENTER ISLAND, W LINE, EASTBOUND | 1741102885000 | evillan | - | - | GUERRERO ST \ LAGUNA ST | - | 296866 | {1F62EC15-E799-418E-9BDE-EDE0124D1FEB} | 37.77055253532807 | -122.42491871224772 | - | - | 1741872121000 | middleware_editor | MUNI LOCAL (FLAG) BLUE | - | 15675 | 5' E OF SHELTER | - | - | - | - | 1 | 296866 | 1741803180000 | - | - | - | - | - | 08 | - | OTHER GUIDE | GUIDE | G-L(SF).0036 | 18X30 | SUP3 | 2IN FLANGE POST | IS | - | MARKET ST | 1901 - 1963 MARKET ST | - | - | - | BUCHANAN ST \ DUBOCE AVE | - |
| 144626 | N/A | Point | - | - | - | - | 46600 | - | - | F | F | - | F | 13212000 | - | - | - | WEST SIDE | 1741102885000 | evillan | - | - | 17TH ST | - | 296867 | {90257468-F52F-46EE-BB5E-A7DFB9A85287} | 37.76413393321185 | -122.40453899963633 | - | - | 1741635810000 | middleware_editor | NPRK 9AM-11AM WED STCL | - | - | 123' N OF NPL #460 | - | - | - | - | - | 296867 | - | - | - | - | 1741628700000 | - | 10 | - | STREET CLEANING | REG | R30B(CA).0312 | 18X18 | SUP1 | 2IN IRON POST | IS | - | VERMONT ST | 400 - 499 VERMONT ST | - | - | - | MARIPOSA ST | - |
| 144627 | N/A | Point | - | - | - | - | 46595 | - | - | - | - | - | T | 810000 | - | - | - | CENTER ISLAND, E LINE, EASTBOUND | 1741102841000 | evillan | - | - | HARTFORD ST | - | 296881 | {656A5DAD-ED5E-4A3E-B771-09B80B3953E3} | 37.7624513453583 | -122.434862943475 | - | - | 1741794354000 | middleware_editor | MUNI LOCAL (FLAG) BLUE | - | 13311 | 100' E OF CASTRO ACROSS 3989 17TH ST. | - | - | - | - | 1 | 296881 | 1741716000000 | - | - | - | - | - | 08 | - | OTHER GUIDE | GUIDE | G-L(SF).0036 | 18X30 | SUP3 | 2IN FLANGE POST | IS | - | - | 3951 - 3999 17TH ST | - | - | - | CASTRO ST \ MARKET ST | - |
| 144628 | N/A | Point | - | - | - | - | 46615 | - | - | F | T | - | F | 26972000 | - | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | 1741102841000 | evillan | - | - | SCOTT ST | - | 296882 | {D2E1EA8B-D773-4E73-9F42-F778332FA5EB} | 37.80011412652656 | -122.44124366035668 | CHESTNUT ST \ SCOTT ST | - | 1741645630000 | middleware_editor | LEAVING TSUNAMI HAZARD ZONE | - | - | SWC | - | - | - | - | - | 296882 | 1741641060000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | EM-1A.0003 | 24X24 | SUP2 | LIGHT POLE | IS | - | CHESTNUT ST | - | - | - | - | - | - |
| 144629 | N/A | Point | - | - | - | - | 46596 | - | - | - | - | - | T | 810000 | - | - | - | CENTER ISLAND, E LINE, EASTBOUND | 1741108669000 | elclark | - | - | HARTFORD ST | - | 296897 | {168DC6A5-7AB8-4AD6-AB9F-7CDF32B4C9A3} | 37.762451718386764 | -122.43486995941056 | - | - | 1741794349000 | middleware_editor | SOLAR LANTERN WHITE (V5) | - | - | 10 E OF CASTRO ACROSS 3989 17TH | - | - | - | - | 1 | 296897 | 1741716120000 | - | - | - | - | - | 08 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP3 | 2IN FLANGE POST | IS | - | 17TH ST | 3951 - 3999 17TH ST | - | - | - | CASTRO ST \ MARKET ST | - |
| 144630 | N/A | Point | - | - | - | - | 46597 | - | - | F | F | - | F | 23796000 | - | - | - | SOUTH EAST CORNER | 1741115348000 | APADILLA | - | - | BERRY ST | - | 296913 | {FD5F760C-3FFB-44AA-8A32-43703EC42007} | 37.77757258503679 | -122.39099515821167 | 03RD ST \ BERRY ST | - | 1741132734000 | middleware_editor | TANSAT | - | - | - | - | - | - | - | - | 296913 | - | - | - | - | 1741120200000 | - | 06 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | SIGNAL POLE | IS | - | 03RD ST | - | - | - | - | - | - |
| 144631 | N/A | Point | - | - | - | - | 46620 | - | - | - | - | - | - | 12267000 | - | - | - | SOUTH SIDE | 1741115348000 | APADILLA | - | - | HAHN ST \ MRS. JACKSON WAY | - | 296914 | {215A51F4-8FA5-4D36-967A-144E60FCB20F} | 37.71210022600001 | -122.41688337300002 | - | - | 1742856299000 | middleware_editor | TA (SYM) PLO 7AM-10PM DAILY (5 MIN) H/C | - | - | 240W OF HAHN | - | - | - | - | - | 296914 | 1742853600000 | - | - | - | - | - | 10 | - | OTHER REGULATORY | REG | R38(SF)1.0216 | 14X21 | SUP1 | 2IN IRON POST | IS | - | SUNNYDALE AVE | 1500 - 2099 SUNNYDALE AVE | - | - | - | SANTOS ST | - |
| 144632 | N/A | Point | - | - | - | - | 46598 | - | - | F | T | - | F | 26756000 | - | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | 1741115460000 | elclark | - | - | NORTH POINT ST | - | 296929 | {CE2EAFC9-CCCE-4DAD-BDDE-62DA8B557089} | 37.80413338290442 | -122.43347873929149 | BUCHANAN ST \ NORTH POINT ST | - | 1741626284000 | middleware_editor | ENTERING TSUNAMI HAZARD ZONE | - | - | NEC | - | - | - | - | - | 296929 | 1741383900000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | EM-1A.0002 | 24X24 | SUP2 | LIGHT POLE | IS | - | BUCHANAN ST | - | - | - | - | - | - |
| 144633 | N/A | Point | - | - | - | - | 46607 | - | - | F | F | - | F | 7359000 | - | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | 1741115460000 | elclark | - | - | DRUMM ST | - | 296930 | {4946924E-D30D-457E-85B7-EEF6073342A5} | 37.7971696553538 | -122.397297839268 | - | - | 1741216387000 | middleware_editor | PEDESTRIAN (SYM) XING/(45 LA-DN) | - | - | 25' W OF DRUMM | - | - | - | - | - | 296930 | - | - | - | - | - | - | 03 | - | PEDESTRIAN(LA DN) | WARNING | W11-2+SW44(CA).01 | 30X30 | SUP1 | 2IN IRON POST | D | - | JACKSON ST | 1 - 99 JACKSON ST | - | - | - | DAVIS CT \ DAVIS ST | - |
| 144634 | N/A | Point | - | - | - | - | 46610 | - | - | F | T | - | F | 26757000 | - | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | 1741115460000 | elclark | - | - | NORTH POINT ST | - | 296931 | {F352AE8C-4518-4648-BDA3-36EFC8C35329} | 37.8041541741328 | -122.431932036966 | LAGUNA ST \ NORTH POINT ST | - | 1741626294000 | middleware_editor | LEAVING TSUNAMI HAZARD ZONE | - | - | SWC ABOVE SPEED LIMIT | - | - | - | - | - | 296931 | 1741383360000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | EM-1A.0003 | 24X24 | SUP2 | LIGHT POLE | IS | - | LAGUNA ST | - | - | - | - | - | - |
| 144635 | N/A | Point | - | - | - | - | 46599 | - | - | F | F | - | F | 3356000 | - | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1741102780000 | evillan | - | - | BAY ST | - | 296945 | {6F92342F-AD20-4A94-9A1D-7C9AAB704B3D} | 37.80365938366188 | -122.43351988134044 | - | - | 1741116096000 | middleware_editor | LEAVING TSUNAMI HAZARD ZONE | - | - | IFO #3645 BUCHANAN | - | - | - | - | - | 296945 | - | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | EM-1A.0003 | 24X24 | SUP2 | 2IN IRON POST | PI | - | BUCHANAN ST | 3600 - 3699 BUCHANAN ST | - | - | - | NORTH POINT ST | - |
| 144636 | N/A | Point | - | - | - | - | 46614 | - | - | F | T | - | F | 26972000 | - | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | 1741102780000 | evillan | - | - | SCOTT ST | - | 296946 | {420E609A-0F83-4C97-A830-FAA215DF755F} | 37.80028924651379 | -122.44112363432336 | CHESTNUT ST \ SCOTT ST | - | 1741645624000 | middleware_editor | ENTERING TSUNAMI HAZARD ZONE | - | - | NEC | - | - | - | - | - | 296946 | 1741641420000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | EM1A-0002 | 24X24 | SUP2 | LIGHT POLE | IS | - | CHESTNUT ST | - | - | - | - | - | - |
| 144637 | N/A | Point | - | - | - | - | 46602 | - | - | F | F | - | F | 3356000 | - | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1741115947000 | elclark | - | - | BAY ST | - | 296961 | {50A31A2C-2156-4BA1-A7FD-06263911562F} | 37.80365938366188 | -122.43351988134044 | - | - | 1741626290000 | middleware_editor | LEAVING TSUNAMI HAZARD ZONE | - | - | IFO #3645 BUCHANAN | - | - | - | - | - | 296961 | 1741383720000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | EM-1A.0003 | 24X24 | SUP2 | 2IN IRON POST | IS | - | BUCHANAN ST | 3600 - 3699 BUCHANAN ST | - | - | - | NORTH POINT ST | - |
| 144638 | N/A | Point | - | - | - | - | 46601 | - | - | F | F | - | F | 13212000 | - | - | - | WEST SIDE | 1741115958000 | mmadsen | - | - | 17TH ST | - | 296977 | {D6D301B0-D585-4483-ABAF-78F10838AD40} | 37.76443015886344 | -122.40456830527454 | - | - | 1741635634000 | middleware_editor | NPRK 9AM-11AM WED STCL | - | - | 83' S OF 17TH ST | - | - | - | - | - | 296977 | - | - | - | - | 1741625100000 | - | 10 | - | STREET CLEANING | REG | R30B(CA).0312 | 18X18 | SUP1 | 2IN IRON POST | IS | - | VERMONT ST | 400 - 499 VERMONT ST | - | - | - | MARIPOSA ST | - |
| 144639 | N/A | Point | - | - | - | - | 46604 | - | - | F | F | - | F | 22375000 | - | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | 1741102690000 | evillan | - | - | MYRA WAY | - | 296993 | {868F6258-EAF2-4003-9DE4-112F589EA3F4} | 37.74015926933979 | -122.45063801409052 | REPOSA WAY \ MYRA WAY | - | 1741116366000 | middleware_editor | ALL WAY | - | - | NEXT TO STREET NAMES | - | - | - | - | - | 296993 | - | - | - | - | - | - | 07 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP3 | 2IN IRON POST | PI | - | REPOSA WAY | - | - | - | - | - | - |
| 144640 | N/A | Point | - | - | - | - | 46605 | - | - | F | F | - | F | 22375000 | - | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | 1741112812000 | APADILLA | - | - | MYRA WAY | - | 297009 | {F1A61FB3-3ACF-4142-A640-A6852BC9AF53} | 37.7401580909643 | -122.450648922966 | REPOSA WAY \ MYRA WAY | - | 1741116485000 | middleware_editor | STOP | - | - | - | - | - | - | - | - | 297009 | - | - | - | - | - | - | 07 | - | STOP | REG | R1-1.0002 | 30X30 | SUP3 | 2IN IRON POST | PI | - | - | - | - | - | - | - | - |
| 144641 | N/A | Point | - | - | - | - | 46611 | - | - | F | T | - | F | 13562000 | - | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1741112812000 | APADILLA | - | - | BAY ST | - | 297010 | {F691C7A2-60DD-4D31-AB63-78D00F32C1E2} | 37.8033875344687 | -122.43515169285537 | - | - | 1741794351000 | middleware_editor | LEAVING TSUNAMI HAZARD ZONE | - | - | NPL #3533 WEBSTER | - | - | - | - | - | 297010 | 1741730100000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | EM-1A.0003 | 24X24 | SUP2 | LIGHT POLE | IS | - | WEBSTER ST | 3500 - 3599 WEBSTER ST | - | - | - | NORTH POINT ST | - |
| 144642 | N/A | Point | - | - | - | - | 46613 | - | - | F | T | - | F | 26964000 | - | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | 1741122269000 | MALOPEZ | - | - | PIERCE ST | - | 297025 | {86700546-3E68-455E-BB26-D1D109FA63E0} | 37.8003003647943 | -122.439583708294 | CHESTNUT ST \ PIERCE ST | - | 1741794363000 | middleware_editor | LEAVING TSUNAMI HAZARD ZONE | - | - | SWC ABOVE ST NAMES | - | - | - | - | - | 297025 | 1741723080000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | EM-1A.0003 | 24X24 | SUP2 | LIGHT POLE | IS | - | CHESTNUT ST | - | - | - | - | - | - |
| 144643 | N/A | Point | - | - | - | - | 46616 | - | - | F | T | - | F | 27023000 | - | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | 1741122880000 | elclark | - | - | RICHARDSON AVE | - | 297041 | {8D6C197F-6FC7-42E4-830E-31A42E19402B} | 37.8004861550571 | -122.447063186745 | FRANCISCO ST \ RICHARDSON AVE | - | 1741645628000 | middleware_editor | ENTERING TSUNAMI HAZARD ZONE | - | - | NEC | - | - | - | - | - | 297041 | 1741640940000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | EM-1A.0002 | 24X24 | SUP2 | LIGHT POLE | IS | - | RICHARDSON AVE | - | - | - | - | - | - |
| 144644 | N/A | Point | - | - | - | - | 46617 | - | - | F | T | - | F | 27023000 | - | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | 1741102665000 | evillan | - | - | RICHARDSON AVE | - | 297057 | {6C4FBACB-7D67-4102-AA07-0D295B170DCA} | 37.8002905280666 | -122.447204379905 | FRANCISCO ST \ RICHARDSON AVE | - | 1741645632000 | middleware_editor | LEAVING TSUNAMI HAZARD ZONE | - | - | 70' S OF FRANCISCO (IFO #155) | - | - | - | - | - | 297057 | 1741640760000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | EM-1A.0003 | 24X24 | SUP2 | 2IN IRON POST | IS | - | RICHARDSON AVE | - | - | - | - | - | - |
| 144645 | N/A | Point | - | - | - | - | 46618 | - | - | F | T | - | F | 26774000 | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1741112766000 | APADILLA | - | - | TOLEDO WAY | - | 297073 | {347DB68A-F7B2-4F66-9A55-18C352479EB1} | 37.801613633837775 | -122.43743355613309 | MALLORCA WAY \ TOLEDO WAY | - | 1741645626000 | middleware_editor | ENTERING TSUNAMI HAZARD ZONE | - | - | EAST SIDE MALLORC @ CENTERLINE TOLEDO | - | - | - | - | - | 297073 | 1741635900000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | EM-1A.0002 | 24X24 | SUP2 | LIGHT POLE | IS | - | MALLORCA WAY | - | - | - | - | - | - |
| 144646 | N/A | Point | - | - | - | - | 46619 | - | - | F | T | - | F | 8635000 | - | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1741114447000 | evillan | - | - | CHESTNUT ST | - | 297089 | {DF9DF710-C9F0-4EC1-891F-A780E9B3ACDE} | 37.80121538945814 | -122.43747347952998 | - | - | 1741645620000 | middleware_editor | LEAVING TSUNAMI HAZARD ZONE | - | - | SPL #33 MALLORCA | - | - | - | - | - | 297089 | 1741634880000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | EM-1A.0003 | 24X24 | SUP2 | LIGHT POLE | IS | - | MALLORCA WAY | 1 - 99 MALLORCA WAY | - | - | - | TOLEDO WAY | - |
| 144647 | N/A | Point | - | - | - | - | 46621 | - | - | - | - | - | - | 12267000 | - | - | - | SOUTH SIDE | 1741113816000 | MALOPEZ | - | - | HAHN ST \ MRS. JACKSON WAY | - | 297105 | {BAB1143B-9127-44DF-B599-CFA2D423396C} | 37.71202065499999 | -122.41659101300002 | - | - | 1742857691000 | middleware_editor | TA (SYM) PLO 7AM-10PM DAILY (5 MIN) H/C | - | - | 169W OF HAHN | - | - | - | - | - | 297105 | 1742857200000 | - | - | - | - | - | 10 | - | OTHER REGULATORY | REG | R38(SF)1.0216 | 14X21 | SUP1 | LIGHT POLE | IS | - | SUNNYDALE AVE | 1500 - 2099 SUNNYDALE AVE | - | - | - | SANTOS ST | - |
| 144648 | N/A | Point | - | - | - | - | 46622 | - | - | - | - | - | - | 8048103 | - | - | - | CENTER ISLAND, S LINE, NORTHBOUND | 1741187447000 | MALOPEZ | - | - | STATE DR | - | 297121 | {13FC26BB-2385-4F38-AD99-F880C23856E8} | 37.72466728270153 | -122.48464741859809 | - | - | 1741219583000 | middleware_editor | MUNI LOCAL (FLAG) BLUE | - | 14833 | 153' N OF FONT | - | - | - | - | 1 | 297121 | 1741210560000 | - | - | - | - | - | 07 | - | OTHER GUIDE | GUIDE | G-L(SF).0036 | 18X30 | SUP3 | 2IN FLANGE POST | IS | - | LAKE MERCED BLVD | 712 - 722 LAKE MERCED BLVD | - | - | - | FONT BLVD | - |
| 144649 | N/A | Point | - | - | - | - | 46685 | - | - | F | F | - | F | 23058000 | - | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | 1741278473000 | jsanfel | - | - | HOLLOWAY AVE | - | 297122 | {3BBD4907-EADA-4CD2-B514-280DBDB6CF2D} | 37.72096354573937 | -122.47890159597706 | ARELLANO AVE \ HOLLOWAY AVE | - | 1741730760000 | middleware_editor | PEDESTRIAN (SYM) | - | - | - | - | - | - | - | - | 297122 | 1741716900000 | - | - | - | - | - | 07 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP3 | 2IN IRON POST | IS | - | ARELLANO AVE | - | - | - | - | - | - |
| 144650 | N/A | Point | - | - | - | - | 46703 | - | - | F | F | - | F | 1551000 | - | - | - | EAST SIDE | 1741278473000 | jsanfel | - | - | LINCOLN WAY | - | 297123 | {9EDBD4E6-08C7-435B-8EC5-AD9C4E7F26C7} | 37.76344462713494 | -122.48565334315835 | - | - | 1742851093000 | middleware_editor | NPRK 8AM-10AM 1ST & 3RD TUE OF MONTH STCL | - | - | 50' N OF IRVING | - | - | - | - | 1 | 297123 | - | - | - | - | 1742590980000 | - | 04 | - | STREET CLEANING | REG | R30B(CA).0250 | 18X18 | SUP2 | LIGHT POLE | IS | - | 27TH AVE | 1200 - 1299 27TH AVE | - | - | - | IRVING ST | - |
| 144651 | N/A | Point | - | - | - | - | 46705 | - | - | F | F | - | F | 8363101 | - | - | - | SOUTH SIDE | 1741278473000 | jsanfel | - | - | 25TH AVE | - | 297124 | {6FFDF1D2-60B4-463D-8B75-06E4E110845C} | 37.7650556291198 | -122.484302418997 | - | - | 1756315378000 | middleware_editor | NPRK 8AM-10AM 1ST & 3RD FRI OF MONTH STCL | - | - | EPL 2431 | - | - | - | - | 1 | 297124 | - | - | - | - | 1742236800000 | - | 04 | - | STREET CLEANING | REG | R30B(CA).0247 | 18X18 | SUP2 | 2IN IRON POST | IS | - | LINCOLN WAY | 2401 - 2499 LINCOLN WAY | - | - | - | 26TH AVE | - |
| 144652 | N/A | Point | - | - | - | - | 46623 | - | - | - | - | - | - | 24130000 | - | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | 1741187561000 | jsanfel | - | - | CAPP ST | - | 297137 | {199DE90E-84C3-4FBE-A90A-3ACF54DF485B} | 37.758771605650125 | -122.41789635572152 | 20TH ST \ CAPP ST | - | 1741730769000 | middleware_editor | ROAD CLOSED | - | - | NE NB | - | - | - | - | - | 297137 | - | - | - | - | 1741716000000 | - | 09 | - | OTHER REGULATORY | REG | R11-2.0001 | 48X30 | SUP3 | 2IN IRON POST | IS | - | 20TH ST | - | - | - | - | - | - |
| 144653 | N/A | Point | - | - | - | - | 46684 | - | - | - | - | - | - | 6755000 | - | - | - | EAST SIDE | 1741278714000 | jsanfel | - | - | 22ND ST | - | 297138 | {1226F1FC-D1A5-4B72-9C97-EC13EA77A539} | 37.7551051597303 | -122.412053850671 | - | - | 1743544757000 | middleware_editor | BIKE (SYM) BIKE LANE | - | - | IFO 2635 | - | - | - | - | - | 297138 | - | - | - | - | - | 1743457200000 | 09 | - | BIKE REG | REG | R81(CA).0003 | 24X08 | SUP3 | LIGHT POLE | RETD | - | HARRISON ST | 2600 - 2699 HARRISON ST | - | - | - | 23RD ST | - |
| 144654 | N/A | Point | - | - | - | - | 46624 | - | - | - | - | - | - | 7681000 | - | - | - | SOUTH SIDE | 1741188105000 | MALOPEZ | - | - | 44TH AVE | - | 297153 | {73133558-8C2F-4CF9-AE7D-E35FF4765BB8} | 37.760416463415304 | -122.50440674328001 | - | - | 1741188133000 | middleware_editor | SIGNAL AHEAD (SYM) STOP WHEN FLASHING | - | - | EPL 3529 | - | - | - | - | 1 | 297153 | - | - | - | - | - | - | 04 | - | OTHER WARNING | WARNING | W3-3(SF).0003 | 36X36 | SUP2 | LIGHT POLE | PI | - | JUDAH ST | 3900 - 3999 JUDAH ST | - | - | - | 45TH AVE | - |
| 144655 | N/A | Point | - | - | - | - | 46668 | - | - | F | F | - | F | 26921000 | - | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | 1741270378000 | MALOPEZ | - | - | LAUREL ST | - | 297154 | {0C93109B-AEC3-4DE5-9B93-B55ED0C13D4F} | 37.78856580261702 | -122.45040052883823 | CLAY ST \ LAUREL ST | - | 1744067155000 | middleware_editor | ALL WAY | - | - | PREVIOUS LOCATION NIN ROADWAY | - | - | - | - | 1 | 297154 | 1744061940000 | - | - | - | - | - | 02 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | BARRICADE | IS | - | CLAY ST | - | - | - | - | - | - |
| 144656 | N/A | Point | - | - | - | - | 46669 | - | - | - | - | - | - | 8172000 | - | - | - | EAST SIDE | 1741270378000 | MALOPEZ | - | - | CLAY ST | - | 297155 | {093B10A5-9B9B-4E61-B9D2-E2F946DFCEDB} | 37.78809880717459 | -122.4503071544369 | - | - | 1744067158000 | middleware_editor | STOP AHEAD (SYM) | - | - | 170' S OF CLAY IFO 316/318 LAUREL | - | - | - | - | 1 | 297155 | 1744061880000 | - | - | - | - | - | 02 | - | OTHER WARNING | WARNING | W3-1.0003 | 36X36 | SUP2 | BARRICADE | IS | - | LAUREL ST | 300 - 399 LAUREL ST | - | - | - | SACRAMENTO ST | - |
| 144657 | N/A | Point | - | - | - | - | 46625 | - | - | F | T | - | F | 27168000 | - | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | 1741188164000 | MALOPEZ | - | - | JUDAH ST | - | 297169 | {89E53AEB-7882-425D-8E0B-DCFA36030575} | 37.7620760072488 | -122.47057797502289 | FUNSTON AVE \ JUDAH ST | - | 1741794365000 | middleware_editor | JUDAH ST | - | - | NWC | - | - | - | - | 1 | 297169 | - | - | - | - | - | 1741726440000 | 07 | - | STREET NAME | GUIDE | D3-2.0205 | 72X18 | SUP3 | LIGHT POLE | RETD | - | FUNSTON AVE | - | - | - | - | - | - |
| 144658 | N/A | Point | - | - | - | - | 46657 | - | - | F | F | - | F | 26775000 | - | - | - | NORTH EAST CORNER | 1741188164000 | MALOPEZ | - | - | PIERCE ST | - | 297170 | {251F091F-889B-478C-95BD-17B982E6202A} | 37.80108859040008 | -122.43955079465593 | TOLEDO WAY \ PIERCE ST | - | 1742568542000 | middleware_editor | PIERCE ST | - | - | NEC 3350> NORTH | - | - | - | - | - | 297170 | - | - | - | - | 1742419200000 | - | 02 | - | STREET NAME | GUIDE | D3-1.1388 | 36X08 | SUP2 | 3IN IRON POST | IS | - | TOLEDO WAY | - | - | - | - | - | - |
| 144659 | N/A | Point | - | - | - | - | 46679 | - | - | F | F | - | F | 27693000 | - | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | 1741270201000 | MALOPEZ | - | - | 36TH AVE | - | 297171 | {28E8D435-04DA-496E-9FCC-A27E99C334B8} | 37.751513827368555 | -122.49443516134704 | ORTEGA ST \ 36TH AVE | - | 1741794290000 | middleware_editor | SPEED HUMPS AHEAD | - | - | SEC ORTEGA / 36TH AV | - | - | - | - | - | 297171 | 1741711260000 | - | - | - | - | - | 04 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | - | ORTEGA ST | - | - | - | - | - | - |
| 144660 | N/A | Point | - | - | - | - | 46626 | - | - | F | T | - | F | 811000 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1741190408000 | jsanfel | - | - | CASTRO ST \ MARKET ST | - | 297185 | {2276F6E2-8DFA-4F6B-8F50-A1CC86F550D0} | 37.762312312072574 | -122.43611900706716 | - | - | 1741730782000 | middleware_editor | SPEED LIMIT 30 | - | - | 40' EAST OF NE CORNER COLLINGWOOD/MARKET | - | - | - | - | - | 297185 | - | - | - | - | - | 1741721400000 | 08 | - | SPEED LIMIT | REG | R2-1.0008 | 24X30 | SUP3 | LIGHT POLE | RETD | - | 17TH ST | 4000 - 4056 17TH ST | - | - | - | 17TH ST | - |
| 144661 | N/A | Point | - | - | - | - | 46632 | - | - | - | T | - | - | 8771101 | - | - | - | SOUTH SIDE | 1741190408000 | jsanfel | - | - | EUREKA ST | - | 297186 | {5E960694-B33F-4D7D-B8EE-9170CE460F93} | 37.7614931807323 | -122.438893484127 | - | - | 1741730778000 | middleware_editor | SPEED LIMIT 30 | - | - | WPL 2727 MARKET | - | - | - | - | - | 297186 | - | - | - | - | - | 1741714200000 | 08 | - | SPEED LIMIT | REG | R2-1.0008 | 24X30 | SUP3 | LIGHT POLE | RETD | - | - | 2701 - 2799 MARKET ST | - | - | - | DOUGLASS ST | - |
| 144662 | N/A | Point | - | - | - | - | 46651 | - | - | F | F | - | F | 4322000 | - | - | - | EAST SIDE | 1741190408000 | jsanfel | - | - | PRETOR WAY | - | 297187 | {E13B9E9B-1A11-4550-AA72-2D3DC80D9A4A} | 37.71022618561412 | -122.44180651161523 | - | - | 1750694692000 | middleware_editor | NPRK 9AM-11AM TUE STCL | - | - | NPL 251 | - | - | - | - | - | 297187 | - | - | - | - | 1750452300000 | - | 11 | - | STREET CLEANING | REG | R30B(CA).0308 | 18X18 | SUP3 | 2IN IRON POST | IS | - | CONCORD ST | 250 - 299 CONCORD ST | - | - | - | HANOVER ST | - |
| 144663 | N/A | Point | - | - | - | - | 46667 | - | - | F | F | - | F | 26921000 | - | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | 1741270330000 | MALOPEZ | - | - | LAUREL ST | - | 297188 | {BC00A58F-7051-4106-8762-67CBED6497DB} | 37.7885673923837 | -122.450401031752 | CLAY ST \ LAUREL ST | - | 1744067141000 | middleware_editor | STOP | - | - | PREVIOUS LOCATIION IN ROADWAY | - | - | - | - | 1 | 297188 | 1744062060000 | - | - | - | - | - | 02 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | BARRICADE | IS | - | CLAY ST | - | - | - | - | - | - |
| 144664 | N/A | Point | - | - | - | - | 46676 | - | - | F | F | - | F | 10019000 | - | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | 1741270330000 | MALOPEZ | - | - | 31ST AVE | - | 297189 | {31B9F18D-7E6B-4BB5-AF21-5E13F70C432E} | 37.75187806551054 | -122.48932018875561 | - | - | 1741794292000 | middleware_editor | SPEED HUMPS AHEAD | - | - | NWC ORTEGA / 31ST AV | - | - | - | - | - | 297189 | 1741727460000 | - | - | - | - | - | 04 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | - | ORTEGA ST | 2400 - 2499 ORTEGA ST | - | - | - | 32ND AVE | - |
| 144665 | N/A | Point | - | - | - | - | 46680 | - | - | F | F | - | F | 27750000 | - | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | 1741270330000 | MALOPEZ | - | - | ORTEGA ST | - | 297190 | {BB3D68A4-C323-470D-BA18-58113A1AB099} | 37.75149898210786 | -122.49789789318524 | 39TH AVE \ ORTEGA ST | - | 1741794317000 | middleware_editor | SPEED HUMPS AHEAD | - | - | NWC ORTEGA / 39TH AV | - | - | - | - | - | 297190 | 1741722600000 | - | - | - | - | - | 04 | - | OTHER WARNING | WARNING | W17-1B.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | - | 39TH AVE | - | - | - | - | - | - |
| 144666 | N/A | Point | - | - | - | - | 46627 | - | - | - | T | - | - | 811000 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1741188279000 | MALOPEZ | - | - | CASTRO ST \ MARKET ST | - | 297201 | {5AAC0B39-0083-44CA-8441-7F54C03DAFC9} | 37.7623114639088 | -122.436121152802 | - | - | 1741730776000 | middleware_editor | SPEED LIMIT 25 | - | - | 40' EAST OF NE CORNER COLLINGWOOD/MARKET | - | - | - | - | - | 297201 | 1741725900000 | - | - | - | - | - | 08 | - | SPEED LIMIT | REG | R2-1.0006 | 36X45 | SUP3 | LIGHT POLE | IS | - | 17TH ST | 4000 - 4056 17TH ST | - | - | - | 17TH ST | - |
| 144667 | N/A | Point | - | - | - | - | 46644 | - | - | - | - | - | - | 11956201 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1741188279000 | MALOPEZ | - | - | EL MIRASOL PL | - | 297202 | {A7DD0971-54AA-4EF7-BB1A-289A29097883} | 37.73434870326555 | -122.48738184213214 | - | - | 1741301468000 | middleware_editor | SAN FRANCISCO ZOO (LOGO) | - | - | WPL 1370 | - | - | - | - | 1 | 297202 | - | - | - | - | - | 1741299840000 | 04 | - | OTHER GUIDE | GUIDE | G-S(SF).0051 | 36X24 | SUP2 | LIGHT POLE | RETD | - | SLOAT BLVD | 1300 - 1498 SLOAT BLVD | - | - | - | CONSTANSO WAY \ EVERGLADE DR | - |
| 144668 | N/A | Point | - | - | - | - | 46673 | - | - | F | T | - | F | 3872000 | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1741273068000 | evillan | - | - | MONCADA WAY | - | 297203 | {6CCC185B-C0E6-4DB5-A575-70829B7466A7} | 37.72646904178145 | -122.4704789847445 | - | - | 1742832664000 | middleware_editor | NO TRUCKS EXC 1 BLOCK FOR PICKUP & DELIVERY | - | - | - | - | - | - | - | - | 297203 | - | - | - | - | - | 1742592300000 | 07 | - | OTHER REGULATORY | REG | R(SF).0158 | 30X30 | SUP3 | LIGHT POLE | RETD | - | CERRITOS AVE | 100 - 199 CERRITOS AVE | - | - | - | LUNADO WAY \ MERCEDES WAY | - |
| 144669 | N/A | Point | - | - | - | - | 46628 | - | - | F | T | - | F | 23163000 | - | - | - | CENTER ISLAND, W LINE, NORTHBOUND | 1741188879000 | MALOPEZ | - | - | SLOAT BLVD | - | 297217 | {DF2D245B-6553-4553-A081-FE3BF65F17A7} | 37.7344862306523 | -122.4771661509189 | 21ST AVE \ SLOAT BLVD | - | 1741626263000 | middleware_editor | SLOAT BLVD | - | - | - | - | - | - | - | 1 | 297217 | - | - | - | - | - | 1741370460000 | 04 | - | STREET NAME | GUIDE | D3-2.0318 | 72X18 | SUP2 | LIGHT POLE | RETD | - | 21ST AVE | - | - | - | - | - | - |
| 144670 | N/A | Point | - | - | - | - | 46639 | - | - | F | F | - | F | 3260000 | - | - | - | SOUTH SIDE | 1741188879000 | MALOPEZ | - | - | WHITTIER ST | - | 297218 | {7E1C4F95-EC3E-412C-AB25-5B465FCED9BB} | 37.70838393612323 | -122.44955934094605 | - | - | 1752271926000 | middleware_editor | NPRK 12NN-2PM FRI STCL | - | - | WPL 787 | - | - | - | - | - | 297218 | - | - | - | - | 1752259200000 | - | 11 | - | STREET CLEANING | REG | R30B(CA).0076 | 18X18 | SUP3 | UTILITY POLE | IS | - | BRUNSWICK ST | 700 - 799 BRUNSWICK ST | - | - | - | OLIVER ST | - |
| 144671 | N/A | Point | - | - | - | - | 46641 | - | - | F | F | - | F | 13620000 | - | - | - | WEST SIDE | 1741188879000 | MALOPEZ | - | - | MISSION ST \ MORSE ST | - | 297219 | {8D766EE8-B040-461B-A6A4-54077E64CE65} | 37.70980980890842 | -122.44813375915261 | - | - | 1752271938000 | middleware_editor | NPRK 12NN-2PM FRI STCL | - | - | SPL 28 | - | - | - | - | - | 297219 | - | - | - | - | 1752267300000 | - | 11 | - | STREET CLEANING | REG | R30B(CA).0076 | 18X18 | SUP3 | 2IN IRON POST | IS | - | WHITTIER ST | 1 - 43 WHITTIER ST | - | - | - | CASSANDRA CT | - |
| 144672 | N/A | Point | - | - | - | - | 46671 | - | - | F | F | - | F | 22755000 | - | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | 1741272713000 | evillan | - | - | CERRITOS AVE \ WESTGATE DR | - | 297220 | {E81F5782-65AF-4469-A960-3C5D8B8AD000} | 37.727179730459554 | -122.46676412526003 | OCEAN AVE \ CERRITOS AVE \ WESTGATE DR | - | 1742832692000 | middleware_editor | NO TRUCKS (SYM) OVER 3 TONS | - | - | - | - | - | - | - | - | 297220 | 1742588400000 | - | - | - | - | - | 07 | - | OTHER REGULATORY | REG | R5-2.0005 | 30X30 | SUP3 | 2IN IRON POST | IS | - | OCEAN AVE | - | - | - | - | - | - |
| 144673 | N/A | Point | - | - | - | - | 46659 | - | - | F | F | - | F | 34014000 | - | - | - | NORTH EAST CORNER | 1741188164000 | MALOPEZ | - | - | GREEN ST | - | 297234 | {B9C09CEB-7EF7-4323-AAF9-E4A10E70285B} | 37.8010120884323 | -122.399000674436 | THE EMBARCADERO \ GREEN ST | - | 1744121424000 | middleware_editor | THE EMBARCADERO | - | - | - | - | - | - | - | - | 297234 | - | - | - | - | - | - | 03 | - | STREET NAME | GUIDE | D3-1.1721 | 36X08 | SUP1 | OVERHEAD MAST ARM | PI | - | THE EMBARCADERO | - | - | - | - | - | - |
| 144674 | N/A | Point | - | - | - | - | 46630 | - | - | - | T | - | - | 25830000 | - | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | 1741188172000 | MALOPEZ | - | - | MARKET ST | - | 297249 | {12E5008A-D62C-4026-950A-4C0233F8DF44} | 37.761632283095366 | -122.43828100162047 | EUREKA ST \ MARKET ST | - | 1741372181000 | middleware_editor | SPEED LIMIT 30 | - | - | SE EB | - | - | - | - | - | 297249 | - | - | - | - | - | - | 08 | - | SPEED LIMIT | REG | R2-1.0009 | 36X45 | SUP3 | SIGNAL POLE | D | - | EUREKA ST | - | - | - | - | - | - |
| 144675 | N/A | Point | - | - | - | - | 46670 | - | - | - | - | - | - | 7677000 | - | - | - | SOUTH SIDE | 1741270271000 | elclark | - | - | 40TH AVE | - | 297250 | {1CDCA270-9F3C-486F-9DB8-78E02E1F7C3A} | 37.76059943633979 | -122.50019325059833 | - | - | 1741301465000 | middleware_editor | STOP AHEAD (SYM) | - | - | EPL 3529 | - | - | - | - | 1 | 297250 | - | - | - | - | - | 1741294380000 | 04 | - | OTHER WARNING | WARNING | W3-1.0003 | 36X36 | SUP2 | LIGHT POLE | RETD | - | JUDAH ST | 3500 - 3599 JUDAH ST | - | - | - | 41ST AVE | - |
Download data as a comma-separated values file with coordinates and properties.
Download CSVDownload data in GeoJSON format, compatible with most GIS applications.
Download GeoJSONDownload data in KML format for use with Google Earth and other mapping applications.
Download KMLDownload data as a shapefile (ZIP format) for use with ArcGIS and other GIS software.
Download ShapefileGet detailed information about this dataset including metadata and available properties.
page - Page number (default: 1)limit - Results per page (max: 1000, default: 100)properties - JSON object for property filteringgeometry_type - Filter by geometry type (Point, LineString, Polygon, etc.)bbox - Bounding box (minX,minY,maxX,maxY)lat - Center latitude for radius searchlon - Center longitude for radius searchradius - Search radius in meters