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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 140851 | N/A | Point | - | - | - | - | 42727 | - | - | F | F | - | F | 25080000 | - | - | - | NORTH WEST CORNER, EASTBOUND TRAFFIC | 1727366708000 | jsanfel | - | - | MASON ST | - | 234932 | {81DD3727-2E96-4F15-9EA3-02B306759A38} | 37.7936754079194 | -122.4112964619 | CLAY ST \ MASON ST | - | 1727473637000 | middleware_editor | (45 RA-DN) | - | - | NW EBT | - | - | - | - | - | 234932 | 1727438400000 | - | - | - | - | - | 03 | - | OTHER WARNING | WARNING | W16-7P.0005 | 18X18 | SUP1 | 2IN IRON POST | IS | - | CLAY ST | - | - | - | - | - | - |
| 140852 | N/A | Point | - | - | - | - | 42728 | - | - | F | F | - | F | - | - | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | 1727367254000 | APADILLA | - | - | - | - | 234933 | {FD81901A-7B22-4476-BF26-D1D932CD4F3E} | 37.789121141 | -122.405393692 | - | - | 1746134677000 | middleware_editor | ONE WAY (RA) | - | - | ABOVE DO NOT ENTER | - | - | - | - | - | 234933 | - | - | - | - | - | - | 03 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | 2IN FLANGE POST | RETD | - | - | - | - | - | - | - | - |
| 140853 | N/A | Point | - | - | - | - | 42731 | - | - | T | T | - | F | 24701000 | - | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | 1727371856000 | mmadsen | - | - | SANSOME ST | - | 234934 | {03DA493A-D8F8-45C7-B2F2-1721C827208B} | 37.7940511851499 | -122.401223355035 | SACRAMENTO ST \ SANSOME ST | - | 1733182441000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 234934 | 1729862700000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | MUNI POLE | IS | - | SACRAMENTO ST | - | - | - | - | - | - |
| 140854 | N/A | Point | - | - | - | - | 42734 | - | - | F | F | - | F | 24701000 | - | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | 1727372785000 | mmadsen | - | - | SANSOME ST | - | 234935 | {0307EC91-5D5F-48AC-A47F-3D5D8E04F3B8} | 37.7939424266061 | -122.401419130909 | SACRAMENTO ST \ SANSOME ST | - | 1733182362000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 234935 | 1730722140000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | 2IN FLANGE POST | IS | - | SACRAMENTO ST | - | - | - | - | - | - |
| 140855 | N/A | Point | - | - | - | - | 42732 | - | - | T | T | - | F | 24701000 | - | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | 1727371917000 | mmadsen | - | - | SANSOME ST | - | 234945 | {D490E75E-6BAD-4548-82FB-93F71A311B1A} | 37.7940347587784 | -122.401423824775 | SACRAMENTO ST \ SANSOME ST | - | 1733182458000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 234945 | 1730717640000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | MUNI POLE | IS | - | SACRAMENTO ST | - | - | - | - | - | - |
| 140856 | N/A | Point | - | - | - | - | 42735 | - | - | F | T | - | F | 22516000 | - | - | - | CENTER ISLAND, W LINE, EASTBOUND | 1727382471000 | evillan | - | - | ARCH ST \ RALSTON ST \ WORCESTER AVE | - | 235201 | {DCD5FCB4-41D4-4BD7-8A25-8E640EFCA625} | 37.7114251609489 | -122.466883120514 | ALEMANY BLVD \ ARCH ST \ RALSTON ST \ WORCESTER AVE | - | 1734447499000 | middleware_editor | SPEED LIMIT 30 | - | - | - | - | - | - | - | - | 235201 | 1734360660000 | - | - | - | - | - | 07 | - | SPEED LIMIT | REG | R2-1.0009 | 36X45 | SUP3 | LIGHT POLE | IS | - | ALEMANY BLVD | - | - | - | - | - | - |
| 140857 | N/A | Point | - | - | - | - | 42736 | - | - | F | T | - | F | 22533000 | - | - | - | NORTH SIDE, EASTBOUND TRAFFIC | 1727382914000 | evillan | - | - | ALEMANY BLVD | - | 235202 | {D9CD3C47-241A-40B7-8B8C-2E4CC8D1719E} | 37.7098729750238 | -122.470347640872 | CHESTER AVE \ ALEMANY BLVD | - | 1734447511000 | middleware_editor | SPEED LIMIT 35 | - | - | ON EASTBOUND ALEMANY AT INTERSECTION | - | - | - | - | - | 235202 | - | - | - | - | - | 1734359040000 | 07 | - | SPEED LIMIT | REG | R2-1.0010 | 36X45 | SUP3 | LIGHT POLE | RETD | - | CHESTER AVE | - | - | - | - | - | - |
| 140858 | N/A | Point | - | - | - | - | 42738 | - | - | F | T | - | F | 2178201 | - | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1727384964000 | evillan | - | - | SICKLES AVE | - | 235203 | {44C29F9D-3C91-4EBE-A036-1E3C2BECA50E} | 37.7101700466193 | -122.456436810516 | - | - | 1734533565000 | middleware_editor | SPEED LIMIT 30 | - | - | 100 FT EAST OF SAN JOSE OPP 3153 | - | - | - | - | - | 235203 | 1734435300000 | - | - | - | - | - | 11 | - | SPEED LIMIT | REG | R2-1.0008 | 24X30 | SUP3 | LIGHT POLE | IS | - | - | 3100 - 3156 ALEMANY BLVD | - | - | - | I-280 N ON RAMP \ REGENT ST \ SAN JOSE AVE | - |
| 140859 | N/A | Point | - | - | - | - | 42737 | - | - | F | T | - | F | 22533000 | - | - | - | NORTH SIDE, EASTBOUND TRAFFIC | 1727383061000 | evillan | - | - | ALEMANY BLVD | - | 235217 | {5D3A77DB-7BF2-4842-9C4B-AF305F3A48BC} | 37.7098708530795 | -122.470351664186 | CHESTER AVE \ ALEMANY BLVD | - | 1734447514000 | middleware_editor | SPEED LIMIT 30 | - | - | ON ALEMANY EASTBOUND AT INTERSECTION | - | - | - | - | - | 235217 | 1734359220000 | - | - | - | - | - | 07 | - | SPEED LIMIT | REG | R2-1.0009 | 36X45 | SUP3 | LIGHT POLE | IS | - | - | - | - | - | - | - | - |
| 140860 | N/A | Point | - | - | - | - | 42739 | - | - | F | T | - | F | 2178101 | - | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1727385027000 | evillan | - | - | SICKLES AVE | - | 235218 | {8629BEE5-A976-491D-826C-8D8DAD112A19} | 37.7101619125427 | -122.456504312749 | - | - | 1734533554000 | middleware_editor | SPEED LIMIT 35 | - | - | 100 FT EAST OF SAN JOSE OPP 3153 | - | - | - | - | - | 235218 | - | - | - | - | - | 1734432600000 | 11 | - | SPEED LIMIT | REG | R2-1.0010 | 36X45 | SUP3 | LIGHT POLE | RETD | - | - | 3101 - 3155 ALEMANY BLVD | - | - | - | I-280 N ON RAMP \ REGENT ST \ SAN JOSE AVE | - |
| 140861 | N/A | Point | - | - | - | - | 42740 | - | - | F | F | - | F | 9284104 | - | - | - | SOUTH SIDE | 1727445092000 | evillan | - | - | FAXON AVE | - | 235521 | {70D85FF4-406A-4962-9908-C2C06FFC249D} | 37.7304200256869 | -122.460408077959 | - | - | 1727987249000 | middleware_editor | NPRK 1PM-3PM 2ND & 4TH TUE OF MONTH STCL | - | - | IFO 1055 | - | - | - | - | - | 235521 | - | - | - | - | 1727784000000 | - | 07 | - | STREET CLEANING | REG | R30B(CA).0101 | 18X18 | SUP3 | LIGHT POLE | IS | - | MONTEREY BLVD | 1051 - 1099 MONTEREY BLVD | - | - | - | SAINT ELMO WAY | - |
| 140862 | N/A | Point | - | - | - | - | 42741 | - | - | F | F | - | F | 4327000 | - | - | - | CENTER ISLAND, E LINE, WESTBOUND | 1727451288000 | jsanfel | - | - | ALEMANY BLVD \ JUSTIN DR | - | 235537 | {9659B602-D30D-4E1E-9147-F37C2D2C72DE} | 37.7312906179532 | -122.426120779676 | - | - | 1727732895000 | middleware_editor | NO LEFT TURN (SYM) | - | - | e line | - | - | - | - | - | 235537 | - | - | - | - | - | 1727428800000 | 11 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP3 | SIGNAL POLE | RETD | - | CONGDON ST | 1 - 49 CONGDON ST | - | - | - | ALEMANY BLVD | - |
| 140863 | N/A | Point | - | - | - | - | 42742 | - | - | F | F | - | F | 4327000 | - | - | - | CENTER ISLAND, W LINE, EASTBOUND | 1727451313000 | jsanfel | - | - | ALEMANY BLVD \ JUSTIN DR | - | 235538 | {42FB377A-1B04-45BB-BE6C-37D4EF22945E} | 37.7312778899674 | -122.426096639794 | - | - | 1727732897000 | middleware_editor | NO LEFT TURN (SYM) | - | - | w line | - | - | - | - | - | 235538 | - | - | - | - | - | 1727432460000 | 11 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP3 | SIGNAL POLE | RETD | - | CONGDON ST | 1 - 49 CONGDON ST | - | - | - | ALEMANY BLVD | - |
| 140864 | N/A | Point | - | - | - | - | 42744 | - | - | F | F | - | F | 5555000 | - | - | - | EAST SIDE | 1727455211000 | MALOPEZ | - | - | CLAY ST | - | 235539 | {BF53127E-3F72-43A4-B59B-11C6D52A690A} | 37.7913616557794 | -122.434273437697 | - | - | 1728333229000 | middleware_editor | NPRK 6AM-8AM TUE THUR SUN STCL | - | - | IFO 2330 FILLMORE | - | - | - | - | 1 | 235539 | - | - | - | - | 1728051960000 | - | 02 | - | STREET CLEANING | REG | R30B(CA).0196 | 18X18 | SUP2 | 2 POST ALUMINUM | IS | - | FILLMORE ST | 2300 - 2399 FILLMORE ST | - | - | - | WASHINGTON ST | - |
| 140865 | N/A | Point | - | - | - | - | 42745 | - | - | F | F | - | F | 6052201 | - | - | - | NORTH SIDE | 1727457562000 | MALOPEZ | - | - | PARKER AVE | - | 235540 | {13C48961-EDE0-41AD-9FDD-9CC5874F8F9B} | 37.7816775243539 | -122.454677392927 | - | - | 1729010019000 | middleware_editor | NPRK 7AM-8AM TUE THUR STCL | - | - | IFO 3330 GEARY | - | - | - | - | 1 | 235540 | - | - | - | - | 1507161600000 | 1675296000000 | 02 | - | STREET CLEANING | REG | R30B(CA).0222 | 18X18 | SUP2 | 2 POST ALUMINUM | RETD | - | GEARY BLVD | 3300 - 3360 GEARY BLVD | - | - | - | BEAUMONT AVE | - |
| 140866 | N/A | Point | - | - | - | - | 42743 | - | - | T | T | - | F | 21964000 | - | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | 1727452822000 | jsanfel | - | - | LIPPARD AVE | - | 235553 | {90722AE6-3ADD-4364-9CC4-77CEA3531D5D} | 37.7339584450884 | -122.435749071853 | BOSWORTH ST \ LIPPARD AVE | - | 1727732894000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | ne | - | - | - | - | - | 235553 | 1727438400000 | - | - | - | - | - | 08 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP3 | 2IN IRON POST | IS | - | BOSWORTH ST | - | - | - | - | - | - |
| 140867 | N/A | Point | - | - | - | - | 42746 | - | - | F | F | - | F | 5336000 | - | - | - | EAST SIDE | 1727458442000 | jsanfel | - | - | QUINT ST | - | 235554 | {2E7D885A-512C-448F-9027-A4655383D519} | 37.7442328012329 | -122.390472538811 | - | - | 1728424090000 | middleware_editor | TANSAT | - | - | 50' NORTH OF QUINT | - | - | - | - | - | 235554 | - | - | - | - | 1728378000000 | - | 10 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | - | EVANS AVE | 1700 - 1799 EVANS AVE | - | - | - | RANKIN ST | - |
| 140868 | N/A | Point | - | - | - | - | 42747 | - | - | F | F | - | F | 24685000 | - | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | 1727461446000 | mmadsen | - | - | CALIFORNIA ST | - | 235569 | {EF14A3E4-A7CC-4C23-900A-FAB094B92877} | 37.7931569784238 | -122.401238262991 | SANSOME ST \ CALIFORNIA ST | - | 1733182375000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 235569 | 1730296920000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | 2IN FLANGE POST | IS | - | SANSOME ST | - | - | - | - | - | - |
| 140869 | N/A | Point | - | - | - | - | 42748 | - | - | T | T | - | F | 24685000 | - | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | 1727461479000 | mmadsen | - | - | CALIFORNIA ST | - | 235570 | {58650044-57CB-4B48-9D2D-B8A1025F5EC7} | 37.7931153821016 | -122.401249997655 | SANSOME ST \ CALIFORNIA ST | - | 1731442576000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 235570 | 1729677840000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | LIGHT POLE | IS | - | SANSOME ST | - | - | - | - | - | - |
| 140870 | N/A | Point | - | - | - | - | 42749 | - | - | T | T | - | F | 24685000 | - | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | 1727461573000 | mmadsen | - | - | CALIFORNIA ST | - | 235571 | {AC15F671-86F7-4E5C-BD12-EDBB398983FE} | 37.7931747297134 | -122.40108336542 | SANSOME ST \ CALIFORNIA ST | - | 1727461660000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 235571 | - | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | LIGHT POLE | PI | - | SANSOME ST | - | - | - | - | - | - |
| 140871 | N/A | Point | - | - | - | - | 42752 | - | - | F | F | - | F | 24685000 | - | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | 1727461791000 | mmadsen | - | - | CALIFORNIA ST | - | 235572 | {67A3E5DB-7924-43AC-9FD9-51A0341BC086} | 37.7929728416605 | -122.401043970475 | SANSOME ST \ CALIFORNIA ST | - | 1731437239000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | 8' S OF CALIFORNIA | - | - | - | - | - | 235572 | 1730290800000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | 2IN FLANGE POST | IS | - | SANSOME ST | - | - | - | - | - | - |
| 140872 | N/A | Point | - | - | - | - | 42755 | - | - | F | F | - | F | 3528000 | - | - | - | SOUTH SIDE | 1727461899000 | mmadsen | - | - | SANSOME ST | - | 235573 | {7DB2F904-0E28-407D-835E-F4E86B4F7BA3} | 37.7929888708503 | -122.401262738148 | - | - | 1731437262000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | 35' W OF SANSOME | - | - | - | - | - | 235573 | 1729853400000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | 2IN IRON POST | IS | - | CALIFORNIA ST | 400 - 448 CALIFORNIA ST | - | - | - | LEIDESDORFF ST | - |
| 140873 | N/A | Point | - | - | - | - | 42758 | - | - | T | T | - | F | 24686000 | - | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | 1727462045000 | mmadsen | - | - | PINE ST | - | 235574 | {CC88A217-7A8D-409B-B209-D40350D2CE7B} | 37.7920088978951 | -122.401004753239 | SANSOME ST \ PINE ST | - | 1731437255000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 235574 | 1729510380000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | LIGHT POLE | IS | - | SANSOME ST | - | - | - | - | - | - |
| 140874 | N/A | Point | - | - | - | - | 42759 | - | - | T | T | - | F | 24679000 | - | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | 1727462117000 | mmadsen | - | - | SANSOME ST | - | 235575 | {1277274A-840C-4AC1-82D6-51B22B610EF5} | 37.7912698002046 | -122.400697063742 | BUSH ST \ SANSOME ST | - | 1731437217000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 235575 | 1729522440000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | SIGNAL POLE | IS | - | BUSH ST | - | - | - | - | - | - |
| 140875 | N/A | Point | - | - | - | - | 42760 | - | - | T | T | - | F | 24679000 | - | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | 1727462148000 | mmadsen | - | - | SANSOME ST | - | 235576 | {4485BC73-5FE6-4E1E-BB0B-8897EA8FAB4E} | 37.7910967867246 | -122.400662865578 | BUSH ST \ SANSOME ST | - | 1731437252000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 235576 | 1729518180000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | LIGHT POLE | IS | - | BUSH ST | - | - | - | - | - | - |
| 140876 | N/A | Point | - | - | - | - | 42762 | - | - | T | T | - | F | 24679000 | - | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | 1727462244000 | mmadsen | - | - | SANSOME ST | - | 235577 | {C458A0E5-5C7B-4816-9439-44CD387B9D1C} | 37.7911407687503 | -122.400652472018 | BUSH ST \ SANSOME ST | - | 1731437257000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 235577 | 1729591380000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | LIGHT POLE | IS | - | BUSH ST | - | - | - | - | - | - |
| 140877 | N/A | Point | - | - | - | - | 42750 | - | - | F | F | - | F | 24685000 | - | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | 1727461630000 | mmadsen | - | - | CALIFORNIA ST | - | 235585 | {F10B4EA4-1DE3-493F-9C21-3671A6BE21BB} | 37.7931549913389 | -122.401045479218 | SANSOME ST \ CALIFORNIA ST | - | 1731437245000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 235585 | 1730299320000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | 2IN IRON POST | IS | - | SANSOME ST | - | - | - | - | - | - |
| 140878 | N/A | Point | - | - | - | - | 42751 | - | - | - | T | - | - | 24685000 | - | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | 1727461718000 | mmadsen | - | - | CALIFORNIA ST | - | 235586 | {03224EE0-48A7-45DA-A0F1-A8EBAE158D8E} | 37.7929693973714 | -122.401043970475 | SANSOME ST \ CALIFORNIA ST | - | 1731437229000 | middleware_editor | DO NOT ENTER 7AM-8PM EVERYDAY | - | - | - | - | - | - | - | - | 235586 | - | - | - | - | - | - | 03 | - | OTHER REGULATORY | REG | R5-1(SF).0013 | 30X42 | SUP1 | LIGHT POLE | PI | - | SANSOME ST | - | - | - | - | - | - |
| 140879 | N/A | Point | - | - | - | - | 42753 | - | - | T | T | - | F | 24685000 | - | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | 1727461746000 | mmadsen | - | - | CALIFORNIA ST | - | 235587 | {C5EF801A-56BB-478B-BDF3-4AEFCB1E72B7} | 37.7929815848554 | -122.401042629371 | SANSOME ST \ CALIFORNIA ST | - | 1731437265000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 235587 | 1729777080000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | LIGHT POLE | IS | - | SANSOME ST | - | - | - | - | - | - |
| 140880 | N/A | Point | - | - | - | - | 42754 | - | - | T | T | - | F | 24685000 | - | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | 1727461832000 | mmadsen | - | - | CALIFORNIA ST | - | 235588 | {11FDC822-2C40-4B60-8D2C-7AC245935E28} | 37.7929633036287 | -122.401197191665 | SANSOME ST \ CALIFORNIA ST | - | 1731437231000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 235588 | 1729693320000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | LIGHT POLE | IS | - | SANSOME ST | - | - | - | - | - | - |
| 140881 | N/A | Point | - | - | - | - | 42756 | - | - | F | F | - | F | 24686000 | - | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | 1727461999000 | mmadsen | - | - | PINE ST | - | 235589 | {712282DD-51A3-4E3C-9BDC-B809BFB4BC0F} | 37.7921819092392 | -122.400840635575 | SANSOME ST \ PINE ST | - | 1731437224000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 235589 | 1729249980000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | 2IN IRON POST | IS | - | - | - | - | - | - | - | - |
| 140882 | N/A | Point | - | - | - | - | 42757 | - | - | T | T | - | F | 24686000 | - | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | 1727462018000 | mmadsen | - | - | PINE ST | - | 235590 | {A62D159D-005B-4CB8-81FE-0F2172205E2E} | 37.792157004109 | -122.401063929475 | SANSOME ST \ PINE ST | - | 1731437248000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 235590 | 1729253040000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | LIGHT POLE | IS | - | SANSOME ST | - | - | - | - | - | - |
| 140883 | N/A | Point | - | - | - | - | 42761 | - | - | F | F | - | F | 24679000 | - | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | 1727462199000 | mmadsen | - | - | SANSOME ST | - | 235591 | {A82D5E5B-2FDD-4535-96F7-EFC5A5CA424C} | 37.7911073848055 | -122.400831174193 | BUSH ST \ SANSOME ST | - | 1731437266000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 235591 | 1729605660000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | 2IN FLANGE POST | IS | - | BUSH ST | - | - | - | - | - | - |
| 140884 | N/A | Point | - | - | - | - | 42765 | - | - | F | F | - | F | 13328000 | - | - | - | NORTH SIDE | 1727465749000 | jsanfel | - | - | REY ST | - | 235602 | {B77E47CB-3DF2-4516-BFBF-0BB67C1E4133} | 37.7126170622194 | -122.411857916838 | - | - | 1728667242000 | middleware_editor | NPRK 8AM-11AM MON STCL | - | - | 60' WEST OF REY | - | - | - | - | - | 235602 | - | - | - | - | - | - | 10 | - | STREET CLEANING | REG | R30B(CA).0275 | 18X18 | SUP1 | 2IN IRON POST | PI | - | VISITACION AVE | 1300 - 1399 VISITACION AVE | - | - | - | BRITTON ST | - |
| 140885 | N/A | Point | - | - | - | - | 42767 | - | - | F | F | - | F | 13328000 | - | - | - | NORTH SIDE | 1727465925000 | jsanfel | - | - | REY ST | - | 235604 | {5D37823A-98FC-422A-A469-7DFC61E1D650} | 37.7127101295529 | -122.412187455986 | - | - | 1728668045000 | middleware_editor | NPRK 8AM-11AM MON STCL | - | - | WPL 1334 | - | - | - | - | - | 235604 | 1728642780000 | - | - | - | 1536278400000 | 1679443200000 | 10 | - | STREET CLEANING | REG | R30B(CA).0275 | 18X18 | SUP1 | 2IN IRON POST | RETD | - | VISITACION AVE | 1300 - 1399 VISITACION AVE | - | - | - | BRITTON ST | - |
| 140886 | N/A | Point | - | - | - | - | 42764 | - | - | - | - | - | - | 24686000 | - | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | 1727464987000 | mmadsen | - | - | PINE ST | - | 235617 | {3CBB541C-C841-4D3A-87F0-90D3E3432D65} | 37.7921815697916 | -122.400849635148 | SANSOME ST \ PINE ST | - | 1731437208000 | middleware_editor | TOW AWAY LANE MUST TURN RIGHT | - | - | - | - | - | - | - | - | 235617 | - | - | - | - | - | - | 03 | - | OTHER REGULATORY | REG | R(SF).0280 | 30X42 | SUP1 | 2IN IRON POST | PI | - | SANSOME ST | - | - | - | - | - | - |
| 140887 | N/A | Point | - | - | - | - | 42768 | - | - | T | T | - | F | 6384001 | - | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | 1727472851000 | APADILLA | - | - | POST ST | - | 235841 | {5786F9A3-B802-4A7D-851A-6FC859DEE51D} | 37.7887946606909 | -122.405185662205 | - | - | 1733182364000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 235841 | 1727775900000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | SIGNAL POLE | IS | - | GRANT AVE | 200 - 218 GRANT AVE | - | - | - | ASHBURTON PL | - |
| 140888 | N/A | Point | - | - | - | - | 42769 | - | - | F | F | - | F | 24660000 | - | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | 1727472955000 | APADILLA | - | - | POST ST | - | 235842 | {A175C128-705B-4F28-BDC3-34F66C773045} | 37.78862296622 | -122.405152469868 | GRANT AVE \ POST ST | - | 1733182244000 | middleware_editor | ONE WAY (LA) | - | - | - | - | - | - | - | - | 235842 | - | - | - | - | - | 1727777700000 | 03 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP1 | 3IN IRON POST | RETD | - | GRANT AVE | - | - | - | - | - | - |
| 140889 | N/A | Point | - | - | - | - | 42770 | - | - | F | F | - | F | 24660000 | - | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | 1727473299000 | APADILLA | - | - | POST ST | - | 235843 | {AFA82AC5-5236-4B8E-BD0D-D477C2F9026F} | 37.7886356843426 | -122.405151128764 | GRANT AVE \ POST ST | - | 1733182234000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 235843 | 1727779500000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | 3IN IRON POST | IS | - | GRANT AVE | - | - | - | - | - | - |
| 140890 | N/A | Point | - | - | - | - | 42772 | - | - | T | T | - | F | 24662000 | - | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | 1727473405000 | APADILLA | - | - | SUTTER ST | - | 235857 | {860AAC36-C2EE-4C54-BF72-B95B81ADD730} | 37.789679759536 | -122.405543120546 | GRANT AVE \ SUTTER ST | - | 1733182250000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 235857 | 1727694000000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | SIGNAL POLE | IS | - | GRANT AVE | - | - | - | - | - | - |
| 140891 | N/A | Point | - | - | - | - | 42771 | - | - | T | T | - | F | 24662000 | - | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | 1727473459000 | APADILLA | - | - | SUTTER ST | - | 235858 | {DF1E1161-DD7F-4D31-8AC0-A2C6EFFDBE73} | 37.7895609218922 | -122.405503839249 | GRANT AVE \ SUTTER ST | - | 1733182230000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 235858 | 1727775000000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | SIGNAL POLE | IS | - | GRANT AVE | - | - | - | - | - | - |
| 140892 | N/A | Point | - | - | - | - | 42773 | - | - | F | F | - | F | 24662000 | - | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | 1727473545000 | APADILLA | - | - | SUTTER ST | - | 235859 | {38D68F77-0216-4457-8C37-D4D0797FCA32} | 37.7897114176261 | -122.405506521458 | GRANT AVE \ SUTTER ST | - | 1733182240000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | - | - | - | - | - | - | 235859 | 1727700300000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | 2IN FLANGE POST | IS | - | GRANT AVE | - | - | - | - | - | - |
| 140893 | N/A | Point | - | - | - | - | 42774 | - | - | F | F | - | F | 12320000 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1727473679000 | APADILLA | - | - | CLAUDE LN | - | 235860 | {3E7018DC-DCA2-414B-9809-2A958CDF4CCA} | 37.7897094127083 | -122.405262962417 | - | - | 1733182258000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | - | - | 12FT EAST OF GRANT | - | - | - | - | - | 235860 | 1727688600000 | - | - | - | - | - | 03 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP1 | 2IN FLANGE POST | IS | - | SUTTER ST | 216 - 299 SUTTER ST | - | - | - | GRANT AVE | - |
| 140894 | N/A | Point | - | - | - | - | 42775 | - | - | F | F | - | F | 27249000 | - | - | - | NORTH WEST CORNER | 1727474698000 | elclark | - | - | GEARY BLVD | - | 235873 | {F9F7274D-524E-4440-BDBA-803CAB94C04E} | 37.7812301870472 | -122.463298067445 | 05TH AVE \ GEARY BLVD | - | 1727991056000 | middleware_editor | 15TH AVE | - | - | NWC 400>| SOUTH | - | - | - | - | - | 235873 | - | - | - | - | 1727965800000 | - | 01 | - | STREET NAME | GUIDE | D3-1.0005 | 36X08 | SUP2 | SIGNAL POLE | IS | - | 05TH AVE | - | - | - | - | - | - |
| 140895 | N/A | Point | - | - | - | - | 42776 | - | - | F | F | - | F | 27284000 | - | - | - | NORTH WEST CORNER | 1727475446000 | elclark | - | - | GEARY BLVD | - | 235874 | {6F06EDB4-EC39-4490-BEB1-5D69D8947D1B} | 37.7811758646068 | -122.464372292156 | 06TH AVE \ GEARY BLVD | - | 1728573220000 | middleware_editor | 6TH AVE | - | - | NWC 400> SOUTH | - | - | - | - | - | 235874 | - | - | - | - | 1728483600000 | - | 01 | - | STREET NAME | GUIDE | D3-1.1929 | 36X08 | SUP2 | SIGNAL POLE | IS | - | 06TH AVE | - | - | - | - | - | - |
| 140896 | N/A | Point | - | - | - | - | 42780 | - | - | F | T | - | F | 22928000 | - | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | 1727475961000 | evillan | - | - | WEST PORTAL AVE | - | 235875 | {92265C69-BDC6-4CC7-B3FA-4BC9DEE71BAE} | 37.7407762570491 | -122.465725207651 | ULLOA ST \ WEST PORTAL AVE | - | 1728417101000 | middleware_editor | EXCEPT MUNI | - | - | - | - | - | - | - | - | 235875 | 1728039240000 | - | - | - | - | - | 07 | - | OTHER REGULATORY | REG | R(SF).0357 | 30X08 | SUP3 | MUNI POLE | IS | - | ULLOA ST | - | - | - | - | - | - |
| 140897 | N/A | Point | - | - | - | - | 42781 | - | - | F | F | - | F | 27223000 | - | - | - | NORTH WEST CORNER, EASTBOUND TRAFFIC | 1727475998000 | elclark | - | - | GEARY BLVD | - | 235876 | {B94FCBC0-85A9-4DFD-B77A-16E72AA3A858} | 37.7815105432021 | -122.456752471621 | JORDAN AVE \ GEARY BLVD | - | 1727904739000 | middleware_editor | JORDAN AVE | - | - | NWC -END- | - | - | - | - | - | 235876 | - | - | - | - | 1727878800000 | - | 02 | - | STREET NAME | GUIDE | D3-1.0937 | 36X08 | SUP2 | 3IN IRON POST | IS | - | JORDAN AVE | - | - | - | - | - | - |
| 140898 | N/A | Point | - | - | - | - | 42777 | - | - | F | F | - | F | 27284000 | - | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | 1727475483000 | elclark | - | - | GEARY BLVD | - | 236161 | {9DB08246-E28C-47DF-ACD3-5593EEC81E27} | 37.7808878225122 | -122.464192584152 | 06TH AVE \ GEARY BLVD | - | 1727990719000 | middleware_editor | 6TH AVE | - | - | SEC 400> SOUTH | - | - | - | - | - | 236161 | - | - | - | - | 1727964000000 | - | 01 | - | STREET NAME | GUIDE | D3-1.1929 | 36X08 | SUP2 | SIGNAL POLE | IS | - | 06TH AVE | - | - | - | - | - | - |
| 140899 | N/A | Point | - | - | - | - | 42778 | - | - | F | F | - | F | 27288000 | - | - | - | NORTH WEST CORNER | 1727475657000 | elclark | - | - | GEARY BLVD | - | 236162 | {4A8A3B3C-5C76-4181-9D12-9D085910B360} | 37.7810698694863 | -122.466522082681 | 08TH AVE \ GEARY BLVD | - | 1727990537000 | middleware_editor | 8TH AVE | - | - | NWC 400> SOUTH | - | - | - | - | - | 236162 | - | - | - | - | 1727962200000 | - | 01 | - | STREET NAME | GUIDE | D3-1.0046 | 36X08 | SUP2 | SIGNAL POLE | IS | - | 08TH AVE | - | - | - | - | - | - |
| 140900 | N/A | Point | - | - | - | - | 42779 | - | - | F | F | - | F | 27223000 | - | - | - | NORTH WEST CORNER | 1727475809000 | elclark | - | - | GEARY BLVD | - | 236163 | {73B11DCD-95F6-4051-816A-94018FDAE768} | 37.7815068333923 | -122.456759512419 | JORDAN AVE \ GEARY BLVD | - | 1727904708000 | middleware_editor | GEARY ST | - | - | NWC 3500> WEST | - | - | - | - | - | 236163 | - | - | - | - | 1727878800000 | - | 02 | - | STREET NAME | GUIDE | D3-1.0718 | 36X08 | SUP2 | 3IN IRON POST | IS | - | JORDAN AVE | - | - | - | - | - | - |
| 140901 | N/A | Point | - | - | - | - | 42782 | - | - | F | F | - | F | 2460000 | - | - | - | - | 1727479525000 | eams_editor | - | - | JENNINGS ST | - | 236164 | {778E27EE-7BD8-4577-8113-B54CC9B023AD} | 37.7252889599251 | -122.390831049106 | - | - | 1727479572000 | middleware_editor | ALL WAY | - | - | - | - | - | - | - | - | 236164 | - | - | - | - | - | - | 10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | PI | - | - | 1500 - 1599 ARMSTRONG AVE | - | - | - | KEITH ST | - |
| 140902 | N/A | Point | - | - | - | - | 42784 | - | - | - | - | - | - | 6043201 | - | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | 1727711356000 | MALOPEZ | - | - | SCOTT ST | - | 236482 | {5985B480-F882-423F-88B9-40426C0927FD} | 37.7834765015502 | -122.43935611211 | - | - | 1729637649000 | middleware_editor | MUNI LOCAL (FLAG) BLUE | - | 14293 | NEXT TO SHELTER IFO XFINITY | - | - | - | - | 1 | 236482 | 1729597500000 | - | - | - | - | - | 05 | - | OTHER GUIDE | GUIDE | G-L(SF).0036 | 18X30 | SUP2 | LIGHT POLE | IS | - | GEARY BLVD | 2100 - 2198 GEARY BLVD | - | - | - | DIVISADERO ST | - |
| 140903 | N/A | Point | - | - | - | - | 42785 | - | - | - | - | - | - | 6045201 | - | - | - | NORTH SIDE | 1727712150000 | MALOPEZ | - | - | BAKER ST \ SAINT JOSEPHS AVE | - | 236483 | {2F98F370-F0A7-4C81-ADAF-C1EBB19A3AC1} | 37.7829979472388 | -122.443084382824 | - | - | 1729637643000 | middleware_editor | MUNI LANDOR FLAG - TYPE 6 | - | 14289 | 42' W OF BAKER | - | - | - | - | 1 | 236483 | - | - | - | - | - | 1729246800000 | 02 | - | OTHER REGULATORY | REG | R(SF).0334 | 15X39 | SUP2 | MUNI LANDOR POLE 3" X121" | RETD | - | - | 2400 - 2498 GEARY BLVD | - | - | - | LYON ST | - |
| 140904 | N/A | Point | - | - | - | - | 42786 | - | - | - | - | - | - | 6045201 | - | - | - | NORTH SIDE | 1727712223000 | MALOPEZ | - | - | BAKER ST \ SAINT JOSEPHS AVE | - | 236484 | {5292BC1F-6CE4-4A79-8CDA-F7E4A4B0E129} | 37.782998477201 | -122.44307432454 | - | - | 1729637651000 | middleware_editor | MUNI LOCAL (FLAG) BLUE | - | 14289 | 42' W OF BAKER | - | - | - | - | 1 | 236484 | 1729246980000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | G-L(SF).0036 | 18X30 | SUP2 | UNISTRUT | IS | - | GEARY BLVD | 2400 - 2498 GEARY BLVD | - | - | - | LYON ST | - |
| 140905 | N/A | Point | - | - | - | - | 42788 | - | - | - | - | - | - | 6105000 | - | - | - | NORTH SIDE | 1727712916000 | MALOPEZ | - | - | BAKER ST \ SAINT JOSEPHS AVE | - | 236485 | {C84DED34-F60C-4764-BBF7-908617DAA9A3} | 37.7825378644927 | -122.447022340401 | - | - | 1729807046000 | middleware_editor | MUNI LOCAL (FLAG) BLUE | - | 14758 | 78' E OF MASONIC NEXT TO SHELTER | - | - | - | - | 1 | 236485 | 1729776360000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | G-L(SF).0036 | 18X30 | SUP2 | LIGHT POLE | IS | - | GEARY BLVD | 8400 - 8499 GEARY BLVD | - | - | - | COLLINS ST | - |
| 140906 | N/A | Point | - | - | - | - | 42790 | - | - | - | - | - | - | 6050201 | - | - | - | NORTH SIDE | 1727713898000 | MALOPEZ | - | - | COOK ST | - | 236486 | {B7AF3F77-0F03-4FE8-92E0-AA99110FA7CD} | 37.7818804393027 | -122.453067927726 | - | - | 1729637573000 | middleware_editor | MUNI LANDOR FLAG - TYPE 6 | - | 14762 | 8' E OF SPRUCE NEXT TO SHELTER | - | - | - | - | 1 | 236486 | - | - | - | - | - | 1729597680000 | 02 | - | OTHER REGULATORY | REG | R(SF).0334 | 15X39 | SUP2 | MUNI LANDOR POLE 3" X121" | RETD | - | GEARY BLVD | 3100 - 3198 GEARY BLVD | - | - | - | SPRUCE ST | - |
| 140907 | N/A | Point | - | - | - | - | 42792 | - | - | - | - | - | - | 6050201 | - | - | - | NORTH SIDE | 1727714060000 | MALOPEZ | - | - | COOK ST | - | 236487 | {A8D86A15-CB10-470F-BC43-346E57EC69B8} | 37.7818788493922 | -122.453076980181 | - | - | 1729637568000 | middleware_editor | SOLAR LANTERN WHITE (V5) | - | - | 8' E OF SPRUCE NEXT TO SHELTER | - | - | - | - | 1 | 236487 | 1729597860000 | - | - | - | - | - | 02 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP2 | UNISTRUT | IS | - | GEARY BLVD | 3100 - 3198 GEARY BLVD | - | - | - | SPRUCE ST | - |
| 140908 | N/A | Point | - | - | - | - | 42793 | - | - | - | - | - | - | 6054201 | - | - | - | NORTH SIDE | 1727714764000 | MALOPEZ | - | - | COMMONWEALTH AVE | - | 236488 | {15477DE4-B827-46E2-81B3-23969232E106} | 37.7815434216816 | -122.455911907704 | - | - | 1729637602000 | middleware_editor | MUNI LANDOR FLAG - TYPE 6 | - | 14292 | 70' W OFCOMMONWEALTH / IFO 3416 | - | - | - | - | 1 | 236488 | - | - | - | - | - | 1729602000000 | 02 | - | OTHER REGULATORY | REG | R(SF).0334 | 15X39 | SUP2 | MUNI LANDOR POLE 3" X121" | RETD | - | GEARY BLVD | 3400 - 3448 GEARY BLVD | - | - | - | STANYAN BLVD | - |
| 140909 | N/A | Point | - | - | - | - | 42800 | - | - | F | F | - | T | 22928000 | - | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | 1727718261000 | evillan | - | - | WEST PORTAL AVE | - | 236489 | {A995D3FB-C2EA-46FC-9F14-D45C25C35FAA} | 37.7408899103234 | -122.465992906491 | ULLOA ST \ WEST PORTAL AVE | - | 1728417100000 | middleware_editor | DO NOT ENTER | - | - | - | - | - | - | - | - | 236489 | 1727965920000 | - | - | - | - | - | 07 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP3 | 2IN IRON POST | IS | - | ULLOA ST | - | - | - | - | - | - |
| 140910 | N/A | Point | - | - | - | - | 42802 | - | - | F | T | - | T | 22928000 | - | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | 1727718363000 | evillan | - | - | WEST PORTAL AVE | - | 236490 | {C9D446ED-3E5F-4499-8CFA-DCC961825418} | 37.7408773607316 | -122.465990894875 | ULLOA ST \ WEST PORTAL AVE | - | 1728417099000 | middleware_editor | EXCEPT MUNI | - | - | - | - | - | - | - | - | 236490 | 1727966340000 | - | - | - | - | - | 07 | - | OTHER REGULATORY | REG | R(SF).0357 | 30X08 | SUP3 | MUNI POLE | IS | - | ULLOA ST | - | - | - | - | - | - |
| 140911 | N/A | Point | - | - | - | - | 42804 | - | - | F | T | - | F | 22928000 | - | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | 1727718697000 | evillan | - | - | WEST PORTAL AVE | - | 236491 | {EB6470DD-8C25-41F7-8B8A-FBB033DF7B58} | 37.7408671089542 | -122.465987095066 | ULLOA ST \ WEST PORTAL AVE | - | 1727718765000 | middleware_editor | RIGHT TURN ONLY (SYM) | - | - | - | - | - | - | - | - | 236491 | - | - | - | - | - | - | 07 | - | OTHER REGULATORY | REG | R3-5.0001 | 24X30 | SUP3 | MUNI POLE | PI | - | ULLOA ST | - | - | - | - | - | - |
| 140912 | N/A | Point | - | - | - | - | 42805 | - | - | F | F | - | F | 10278000 | - | - | - | EAST SIDE | 1727718701000 | MALOPEZ | - | - | TURK BLVD | - | 236492 | {87521668-7F45-4B67-A94D-6EECB86C3A32} | 37.777372797422 | -122.453201340717 | - | - | 1727962100000 | middleware_editor | NPRK 9AM-11AM WED STCL | - | - | IFO 520 | - | - | - | - | 1 | 236492 | - | - | - | - | 1727880480000 | - | 01 | - | STREET CLEANING | REG | R30B(CA).0312 | 18X18 | SUP2 | LIGHT POLE | IS | - | PARKER AVE | 500 - 599 PARKER AVE | - | - | - | GOLDEN GATE AVE | - |
| 140913 | N/A | Point | - | - | - | - | 42807 | - | - | F | F | - | F | 26908000 | - | - | - | NORTH WEST CORNER | 1727719188000 | elclark | - | - | GEARY BLVD | - | 236493 | {11981B2D-DADA-452D-86F2-E2B0782EA76F} | 37.7822617758608 | -122.450187765057 | COLLINS ST \ GEARY BLVD | - | 1727904373000 | middleware_editor | COLLINS ST | - | - | NWC 200>| SOUTH | - | - | - | - | - | 236493 | - | - | - | - | 1727869800000 | - | 02 | - | STREET NAME | GUIDE | D3-1.0416 | 36X08 | SUP2 | SIGNAL POLE | IS | - | COLLINS ST | - | - | - | - | - | - |
| 140914 | N/A | Point | - | - | - | - | 42787 | - | - | - | - | - | - | 6045201 | - | - | - | NORTH SIDE | 1727712272000 | MALOPEZ | - | - | BAKER ST \ SAINT JOSEPHS AVE | - | 236497 | {C016082A-7A9A-42E4-B671-F0191036B5FC} | 37.7830005970496 | -122.443064936809 | - | - | 1729637609000 | middleware_editor | SOLAR LANTERN WHITE (V5) | - | - | 42' W OF BAKER | - | - | - | - | 1 | 236497 | 1729246080000 | - | - | - | - | - | 02 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP2 | UNISTRUT | IS | - | - | 2400 - 2498 GEARY BLVD | - | - | - | LYON ST | - |
| 140915 | N/A | Point | - | - | - | - | 42789 | - | - | - | - | - | - | 26908000 | - | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | 1727713423000 | MALOPEZ | - | - | GEARY BLVD | - | 236498 | {CCFAD7D0-170C-44B4-A075-F9A5BF788A4D} | 37.78226678662 | -122.450018144366 | COLLINS ST \ GEARY BLVD | - | 1729637570000 | middleware_editor | MUNI LOCAL (FLAG) BLUE | - | 14290 | NEXT TO SHELTER | - | - | - | - | 1 | 236498 | 1729597620000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | G-L(SF).0036 | 18X30 | SUP2 | LIGHT POLE | IS | - | COLLINS ST | - | - | - | - | - | - |
| 140916 | N/A | Point | - | - | - | - | 42791 | - | - | - | - | - | - | 6050201 | - | - | - | NORTH EAST CORNER | 1727713965000 | MALOPEZ | - | - | COOK ST | - | 236499 | {D145A0BB-B8C6-42C5-AEE6-FF178F4204EA} | 37.7818799093326 | -122.453073292144 | - | - | 1729637564000 | middleware_editor | MUNI LOCAL (FLAG) BLUE | - | 14762 | 8' E OF SPRUCE NEXT TO SHELTER | - | - | - | - | 1 | 236499 | 1729597740000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | G-L(SF).0036 | 18X30 | SUP2 | UNISTRUT | IS | - | GEARY BLVD | 3100 - 3198 GEARY BLVD | - | - | - | SPRUCE ST | - |
| 140917 | N/A | Point | - | - | - | - | 42794 | - | - | - | - | - | - | 6054201 | - | - | - | NORTH SIDE | 1727714845000 | MALOPEZ | - | - | COMMONWEALTH AVE | - | 236500 | {30DB8838-7EE7-4C72-B76F-4211C76BC9A8} | 37.7815432450348 | -122.455924424652 | - | - | 1729637612000 | middleware_editor | MUNI LOCAL (FLAG) BLUE | - | 14292 | 70' W OF COMMONWEALTH / IFO 3416 | - | - | - | - | 1 | 236500 | 1729602240000 | - | - | - | - | - | 02 | - | OTHER GUIDE | GUIDE | G-L(SF).0036 | 18X30 | SUP2 | UNISTRUT | IS | - | - | 3400 - 3448 GEARY BLVD | - | - | - | STANYAN BLVD | - |
| 140918 | N/A | Point | - | - | - | - | 42795 | - | - | - | - | - | - | 6054201 | - | - | - | NORTH SIDE | 1727714909000 | MALOPEZ | - | - | COMMONWEALTH AVE | - | 236501 | {76A2D201-5A88-40E5-960B-164B19FE5364} | 37.7815432450348 | -122.455932471279 | - | - | 1729637577000 | middleware_editor | SOLAR LANTERN WHITE (V5) | - | - | 70' W OF COMMONWEALTH / /IFO 3416 | - | - | - | - | 1 | 236501 | 1729602420000 | - | - | - | - | - | 02 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP2 | UNISTRUT | IS | - | - | 3400 - 3448 GEARY BLVD | - | - | - | STANYAN BLVD | - |
| 140919 | N/A | Point | - | - | - | - | 42797 | - | - | - | - | - | - | 6057201 | - | - | - | NORTH SIDE | 1727717183000 | MALOPEZ | - | - | ARGUELLO BLVD | - | 236502 | {7BECEBF4-5BAD-4E74-8D3C-1E21D10BA435} | 37.7813632307824 | -122.459406379103 | - | - | 1729717494000 | middleware_editor | SOLAR LANTERN WHITE (V5) | - | - | 100' W OF ARGUELLO | - | - | - | - | 1 | 236502 | 1729683240000 | - | - | - | - | - | 01 | - | OTHER MISC | MISC | SOLAR-WHITE.0001 | 14X11 | SUP2 | UNISTRUT | IS | - | GEARY BLVD | 3700 - 3798 GEARY BLVD | - | - | - | 02ND AVE | - |
| 140920 | N/A | Point | - | - | - | - | 42798 | - | - | F | T | - | F | 22928000 | - | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | 1727717826000 | evillan | - | - | WEST PORTAL AVE | - | 236503 | {C92D09B5-A0FD-4F8A-A2D5-6CAEF8C9DA2B} | 37.7407755499836 | -122.465723344506 | ULLOA ST \ WEST PORTAL AVE | - | 1728417106000 | middleware_editor | LEFT TURN ONLY (SYM) | - | - | - | - | - | - | - | - | 236503 | 1727966280000 | - | - | - | - | - | 07 | - | OTHER REGULATORY | REG | R3-5.0003 | 24X30 | SUP3 | MUNI POLE | IS | - | ULLOA ST | - | - | - | - | - | - |
| 140921 | N/A | Point | - | - | - | - | 42799 | - | - | F | T | - | T | 22928000 | - | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | 1727718188000 | evillan | - | - | WEST PORTAL AVE | - | 236504 | {E35E7674-BB26-4825-857D-E74DB1ADE5EF} | 37.7409031669208 | -122.465998270909 | ULLOA ST \ WEST PORTAL AVE | - | 1728417104000 | middleware_editor | DO NOT ENTER | - | - | - | - | - | - | - | - | 236504 | 1727966460000 | - | - | - | - | - | 07 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP3 | MUNI POLE | IS | - | ULLOA ST | - | - | - | - | - | - |
| 140922 | N/A | Point | - | - | - | - | 42801 | - | - | F | F | - | T | 22928000 | - | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | 1727718394000 | evillan | - | - | WEST PORTAL AVE | - | 236505 | {80698883-A8FA-4118-8DD4-163C957E00D3} | 37.7408672857143 | -122.46598620101 | ULLOA ST \ WEST PORTAL AVE | - | 1728417066000 | middleware_editor | EXCEPT MUNI | - | - | - | - | - | - | - | - | 236505 | 1727965740000 | - | - | - | - | - | 07 | - | OTHER REGULATORY | REG | R(SF).0357 | 30X08 | SUP3 | 2IN IRON POST | IS | - | ULLOA ST | - | - | - | - | - | - |
| 140923 | N/A | Point | - | - | - | - | 42803 | - | - | F | T | - | F | 22928000 | - | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | 1727718642000 | evillan | - | - | WEST PORTAL AVE | - | 236506 | {28196AE3-2402-42B4-9E0B-2A6DFBADAD81} | 37.7408793050276 | -122.465992459484 | ULLOA ST \ WEST PORTAL AVE | - | 1727759196000 | middleware_editor | EXCEPT MUNI | - | - | - | - | - | - | - | - | 236506 | - | - | - | - | - | - | 07 | - | OTHER REGULATORY | REG | R(SF).0357 | 30X08 | SUP3 | MUNI POLE | PI | - | ULLOA ST | - | - | - | - | - | - |
| 140924 | N/A | Point | - | - | - | - | 42806 | - | - | F | F | - | F | 27221000 | - | - | - | NORTH WEST CORNER | 1727719042000 | elclark | - | - | GEARY BLVD | - | 236507 | {7DB638F4-1343-4A57-93B9-5BD24B7628E2} | 37.7815223976908 | -122.456417679375 | STANYAN BLVD \ GEARY BLVD | - | 1727904497000 | middleware_editor | STANYAN ST | - | - | NWC 000>| SOUTH | - | - | - | - | - | 236507 | - | - | - | - | 1727872500000 | - | 02 | - | STREET NAME | GUIDE | D3-1.1663 | 36X08 | SUP2 | SIGNAL POLE | IS | - | STANYAN BLVD | - | - | - | - | - | - |
| 140925 | N/A | Point | - | - | - | - | 42796 | - | - | - | - | - | - | 6057201 | - | - | - | NORTH SIDE | 1727717148000 | MALOPEZ | - | - | ARGUELLO BLVD | - | 236513 | {FB32D98B-2A17-4A4F-9983-216307DDC093} | 37.7813637607563 | -122.459396991372 | - | - | 1729637561000 | middleware_editor | MUNI LOCAL (FLAG) BLUE | - | 17854 | 100' W OF ARGUELLO | - | - | - | - | 1 | 236513 | 1729602600000 | - | - | - | - | - | 01 | - | OTHER GUIDE | GUIDE | G-L(SF).0036 | 18X30 | SUP2 | UNISTRUT | IS | - | GEARY BLVD | 3700 - 3798 GEARY BLVD | - | - | - | 02ND 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