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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42751 | N/A | Point | 1 | 1 | 3800 - 3899 | - | S116200 | 3800-3899 18TH ST | 3800-3899 18TH ST | F | F | - | F | 888000 | 888000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | CHURCH ST | CHURCH ST | 17567 | 17567 | 37.76122253 | -122.42946382 | - | - | 1710539427000 | MTA | LANE ENDS MERGE LEFT | CHURCH ST to SANCHEZ ST (3800 - 3899) | - | WPL #3826/3828 | - | - | - | - | - | 59844 | 1045699200000 | -122.42946382 | 37.76122253 | - | - | - | D8 | - | OTHER WARNING | WARNING | W9-2.0002 | 36X36 | SUP2 | 2IN IRON POST | IS | 1373572620000 | 18TH ST | 3800 - 3899 18TH ST | 3800 - 3899 18TH ST | 3800 18TH ST | - | SANCHEZ ST | SANCHEZ ST |
| 42752 | N/A | Point | - | - | - | - | S116203 | 19TH ST: KANSAS ST | - | F | F | - | F | 23760000 | 23760000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | KANSAS ST | 19TH ST | 17569 | 17569 | 37.76089213 | -122.40317092 | 19TH ST \ KANSAS ST | KANSAS ST \ 19TH ST | 1737500754000 | middleware_editor | ALL WAY | 19TH ST intersection | - | - | - | - | - | - | - | 59845 | 1045872000000 | -122.40317092 | 37.76089213 | - | 1737459000000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373572620000 | KANSAS ST | - | - | - | - | - | - |
| 42753 | N/A | Point | - | - | - | - | S116204 | 19TH ST: KANSAS ST | - | F | F | - | F | 23760000 | 23760000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | KANSAS ST | 19TH ST | 17570 | 17570 | 37.76089213 | -122.40317092 | 19TH ST \ KANSAS ST | KANSAS ST \ 19TH ST | 1737500390000 | middleware_editor | ALL WAY | 19TH ST intersection | - | - | - | - | - | - | - | 59846 | 1045872000000 | -122.40317092 | 37.76089213 | - | 1737453600000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373572620000 | KANSAS ST | - | - | - | - | - | - |
| 42754 | N/A | Point | - | - | - | - | S116205 | 19TH ST: VERMONT ST | - | F | F | - | F | 23764000 | 23764000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | VERMONT ST | 19TH ST | 17571 | 17571 | 37.76083391 | -122.40413449 | 19TH ST \ VERMONT ST | VERMONT ST \ 19TH ST | 1710539427000 | MTA | ALL WAY | 19TH ST intersection | - | - | - | - | - | - | - | 59847 | 1045872000000 | -122.40413449 | 37.76083391 | - | - | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373572620000 | VERMONT ST | - | - | - | - | - | - |
| 42755 | N/A | Point | - | - | - | - | S116207 | VERMONT ST: 19TH ST | - | F | F | - | F | 23764000 | 23764000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | VERMONT ST | 19TH ST | 17572 | 17572 | 37.76083391 | -122.40413449 | 19TH ST \ VERMONT ST | VERMONT ST \ 19TH ST | 1710539427000 | MTA | ALL WAY | 19TH ST intersection | - | - | - | - | - | - | - | 59848 | 1045872000000 | -122.40413449 | 37.76083391 | - | - | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373572620000 | VERMONT ST | - | - | - | - | - | - |
| 42756 | N/A | Point | - | - | - | - | S116209 | 19TH ST: VERMONT ST | - | F | F | - | F | 23764000 | 23764000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | VERMONT ST | 19TH ST | 17573 | 17573 | 37.76083391 | -122.40413449 | 19TH ST \ VERMONT ST | VERMONT ST \ 19TH ST | 1710539427000 | MTA | ALL WAY | 19TH ST intersection | - | - | - | - | - | - | - | 59849 | 1046131200000 | -122.40413449 | 37.76083391 | - | - | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373572620000 | VERMONT ST | - | - | - | - | - | - |
| 42757 | N/A | Point | - | - | - | - | S116210 | 19TH ST: NOE ST | - | F | F | - | F | 25787000 | 25787000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 17574 | 17574 | 37.75942329 | -122.43263777 | NOE ST \ 19TH ST | NOE ST \ 19TH ST | 1712885297000 | middleware_editor | ALL WAY | 19TH ST intersection | - | NECORNER | - | - | - | - | - | 59850 | 1046131200000 | -122.43263777 | 37.75942329 | - | 1579564800000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572620000 | NOE ST | - | - | - | - | - | - |
| 42758 | N/A | Point | - | - | - | - | S116212 | NOE ST: 19TH ST | - | F | F | - | F | 25787000 | 25787000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 17575 | 17575 | 37.75942329 | -122.43263777 | NOE ST \ 19TH ST | NOE ST \ 19TH ST | 1712885300000 | middleware_editor | ALL WAY | 19TH ST intersection | - | - | - | - | - | - | - | 59851 | 1046131200000 | -122.43263777 | 37.75942329 | - | 1579564800000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572620000 | NOE ST | - | - | - | - | - | - |
| 42759 | N/A | Point | - | - | - | - | S116213 | NOE ST: 19TH ST | - | F | F | - | F | 25787000 | 25787000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 17576 | 17576 | 37.75942329 | -122.43263777 | NOE ST \ 19TH ST | NOE ST \ 19TH ST | 1712885329000 | middleware_editor | ALL WAY | 19TH ST intersection | - | SECORNER | - | - | - | - | - | 59852 | 1046131200000 | -122.43263777 | 37.75942329 | - | 1579564800000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572620000 | NOE ST | - | - | - | - | - | - |
| 42760 | N/A | Point | - | - | - | - | S116214 | VERMONT ST: 19TH ST | - | F | F | - | F | 23764000 | 23764000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VERMONT ST | 19TH ST | 17577 | 17577 | 37.76083391 | -122.40413449 | 19TH ST \ VERMONT ST | VERMONT ST \ 19TH ST | 1710539427000 | MTA | ALL WAY | 19TH ST intersection | - | - | - | - | - | - | - | 59853 | 1046131200000 | -122.40413449 | 37.76083391 | - | - | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373572620000 | VERMONT ST | - | - | - | - | - | - |
| 42761 | N/A | Point | - | - | - | - | S116216 | ORTEGA ST: 39TH AVE | - | F | F | - | F | 27750000 | 27750000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ORTEGA ST | 39TH AVE | 17579 | 17579 | 37.75142633 | -122.49777042 | 39TH AVE \ ORTEGA ST | ORTEGA ST \ 39TH AVE | 1710539427000 | MTA | STOP | 39TH AVE intersection | - | - | - | - | - | - | - | 59854 | 1046217600000 | -122.49777042 | 37.75142633 | - | 1511913600000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373572620000 | ORTEGA ST | - | - | - | - | - | - |
| 42762 | N/A | Point | 1 | 1 | 400 - 499 | - | S116488 | 400-499 CARL ST | 400-499 CARL ST | F | F | - | F | 3699000 | 3699000 | - | - | NORTH SIDE | - | - | - | - | HILLWAY AVE | HILLWAY AVE | 17582 | 17582 | 37.76487127 | -122.4572386 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM 1ST THUR OF EVERY MONTH STCL | HILLWAY AVE to ARGUELLO BLVD (400 - 499) | - | WPL #450 | - | - | - | - | - | 59855 | 1050278400000 | -122.4572386 | 37.76487127 | - | - | - | D5 | - | STREET CLEANING | REG | R30B(CA).0290 | 18X18 | SUP1 | MUNI POLE | IS | 1373572680000 | CARL ST | 400 - 499 CARL ST | 400 - 499 CARL ST | 400 CARL ST | - | ARGUELLO BLVD | ARGUELLO BLVD |
| 42763 | N/A | Point | 1 | 1 | 1 - 99 | - | S124307 | 1-99 HILLWAY AVE | 1-99 HILLWAY AVE | F | F | - | F | 6929000 | 6929000 | - | - | EAST SIDE | - | - | - | - | CARL ST | CARL ST | 18290 | 18290 | 37.76437358 | -122.45671446 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES (SYM) | CARL ST to PARNASSUS AVE (1 - 99) | - | IFO #28 | - | - | - | - | - | 59856 | 1151452800000 | -122.45671446 | 37.76437358 | - | - | - | D5 | - | PARKING: PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP1 | LIGHT POLE | IS | 1373575140000 | HILLWAY AVE | 1 - 99 HILLWAY AVE | 1 - 99 HILLWAY AVE | 1 HILLWAY AVE | - | PARNASSUS AVE | PARNASSUS AVE |
| 42764 | N/A | Point | - | - | - | - | S124309 | GREEN ST: JONES ST | - | F | F | - | F | 25271000 | 25271000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GREEN ST | GREEN ST | 18291 | 18291 | 37.79868013 | -122.41557232 | JONES ST \ GREEN ST | JONES ST \ GREEN ST | 1737154893000 | middleware_editor | ALL WAY | GREEN ST intersection | - | - | - | - | - | - | - | 59857 | 1151452800000 | -122.41557232 | 37.79868013 | - | 1737078300000 | - | D3 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575140000 | JONES ST | - | - | - | - | - | - |
| 42765 | N/A | Point | - | - | - | - | S124310 | GREEN ST: JONES ST | - | F | F | - | F | 25271000 | 25271000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GREEN ST | GREEN ST | 18292 | 18292 | 37.79868013 | -122.41557232 | JONES ST \ GREEN ST | JONES ST \ GREEN ST | 1737154466000 | middleware_editor | ALL WAY | GREEN ST intersection | - | - | - | - | - | - | - | 59858 | 1151452800000 | -122.41557232 | 37.79868013 | - | 1737115200000 | - | D3 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575140000 | JONES ST | - | - | - | - | - | - |
| 42766 | N/A | Point | - | - | - | - | S124311 | SACRAMENTO ST: MASON ST | - | F | F | - | F | 25012000 | 25012000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MASON ST | SACRAMENTO ST | 18293 | 18293 | 37.79276178 | -122.41100674 | SACRAMENTO ST \ MASON ST | MASON ST \ SACRAMENTO ST | 1710772406000 | middleware_editor | ALL WAY | SACRAMENTO ST intersection | - | - | - | - | - | - | - | 59859 | 1151452800000 | -122.41100674 | 37.79276178 | - | 1710504000000 | - | D3 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | LIGHT POLE | IS | 1373575140000 | MASON ST | - | - | - | - | - | - |
| 42767 | N/A | Point | - | - | - | - | S124312 | SACRAMENTO ST: MASON ST | - | F | F | - | F | 25012000 | 25012000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MASON ST | SACRAMENTO ST | 18294 | 18294 | 37.79276178 | -122.41100674 | SACRAMENTO ST \ MASON ST | MASON ST \ SACRAMENTO ST | 1710539427000 | MTA | ALL WAY | SACRAMENTO ST intersection | - | - | - | - | - | - | - | 59860 | 1151452800000 | -122.41100674 | 37.79276178 | - | 1557705600000 | - | D3 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575140000 | MASON ST | - | - | - | - | - | - |
| 42768 | N/A | Point | - | - | - | - | S124313 | CABRILLO ST: 18TH AVE | - | F | F | - | F | 27463000 | 27463000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 18TH AVE | CABRILLO ST | 18295 | 18295 | 37.77477883 | -122.47682956 | CABRILLO ST \ 18TH AVE | 18TH AVE \ CABRILLO ST | 1745434183000 | middleware_editor | ALL WAY | CABRILLO ST intersection | - | - | - | - | - | - | - | 59861 | 1151478000000 | -122.47682956 | 37.77477883 | - | 1616482800000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | UTILITY POLE | IS | 1373575140000 | 18TH AVE | - | - | - | - | - | - |
| 42769 | N/A | Point | - | - | - | - | S124314 | CABRILLO ST: 18TH AVE | - | F | F | - | F | 27463000 | 27463000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 18TH AVE | CABRILLO ST | 18296 | 18296 | 37.77477883 | -122.47682956 | CABRILLO ST \ 18TH AVE | 18TH AVE \ CABRILLO ST | 1745434211000 | middleware_editor | ALL WAY | CABRILLO ST intersection | - | - | - | - | - | - | - | 59862 | 1151478000000 | -122.47682956 | 37.77477883 | - | - | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575140000 | 18TH AVE | - | - | - | - | - | - |
| 42770 | N/A | Point | - | - | - | - | S124315 | JONES ST: GREEN ST | - | F | F | - | F | 25271000 | 25271000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GREEN ST | GREEN ST | 18297 | 18297 | 37.79868013 | -122.41557232 | JONES ST \ GREEN ST | JONES ST \ GREEN ST | 1737154647000 | middleware_editor | ALL WAY | GREEN ST intersection | - | - | - | - | - | - | - | 59863 | 1151452800000 | -122.41557232 | 37.79868013 | - | 1737076500000 | - | D3 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575140000 | JONES ST | - | - | - | - | - | - |
| 42771 | N/A | Point | - | - | - | - | S124317 | 18TH AVE: CABRILLO ST | - | F | F | - | F | 27463000 | 27463000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 18TH AVE | CABRILLO ST | 18298 | 18298 | 37.77477883 | -122.47682956 | CABRILLO ST \ 18TH AVE | 18TH AVE \ CABRILLO ST | 1745434209000 | middleware_editor | ALL WAY | CABRILLO ST intersection | - | - | - | - | - | - | - | 59864 | 1151478000000 | -122.47682956 | 37.77477883 | - | - | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575140000 | 18TH AVE | - | - | - | - | - | - |
| 42772 | N/A | Point | - | - | - | - | S124318 | 18TH AVE: CABRILLO ST | - | F | F | - | F | 27463000 | 27463000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 18TH AVE | CABRILLO ST | 18299 | 18299 | 37.77477883 | -122.47682956 | CABRILLO ST \ 18TH AVE | 18TH AVE \ CABRILLO ST | 1745434203000 | middleware_editor | ALL WAY | CABRILLO ST intersection | - | - | - | - | - | - | - | 59865 | 1151478000000 | -122.47682956 | 37.77477883 | - | - | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575140000 | 18TH AVE | - | - | - | - | - | - |
| 42773 | N/A | Point | 1 | 1 | 2900 - 2999 | LEFT ARROW | S124320 | 2900-2999 DIAMOND ST | 2900-2999 DIAMOND ST | F | F | - | F | 4773000 | 4773000 | - | - | EAST SIDE | - | - | - | - | BOSWORTH ST | BOSWORTH ST | 18300 | 18300 | 37.73304217 | -122.43429369 | - | - | 1710539427000 | MTA | NPPZ | BOSWORTH ST to MONTEREY BLVD \ SAN JOSE AV OFF RAMP \ SAN JOSE AVE (2900 - 2999) | - | OPP #2954(225FT. SOUTH OF BOSWORTH ST) | - | - | - | - | - | 59866 | 1151452800000 | -122.43429369 | 37.73304217 | - | - | - | D8 | - | OTHER REGULATORY | REG | R30(SF).0003 | 10X15 | SUP2 | 2IN IRON POST | IS | 1373575140000 | DIAMOND ST | 2900 - 2999 DIAMOND ST | 2900 - 2999 DIAMOND ST | 2900 DIAMOND ST | - | MONTEREY BLVD \ SAN JOSE AV OFF RAMP \ SAN JOSE AVE | MONTEREY BLVD \ SAN JOSE AV OFF RAMP \ SAN JOSE AVE |
| 42774 | N/A | Point | 1 | 1 | 200 - 299 | - | S124321 | 200-299 CLEMENT ST | 200-299 CLEMENT ST | F | F | - | F | 4152000 | 4152000 | - | - | SOUTH SIDE | - | - | - | - | 3RD AVE | 03RD AVE | 18301 | 18301 | 37.78306289 | -122.46174312 | - | - | 1712970816000 | middleware_editor | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | 03RD AVE to 04TH AVE (200 - 299) | - | 100' EAST OF 4TH AVE | - | - | - | - | - | 59867 | 1151452800000 | -122.46174312 | 37.78306289 | - | - | - | D1 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP2 | LIGHT POLE | IS | 1373575140000 | CLEMENT ST | 200 - 299 CLEMENT ST | 200 - 299 CLEMENT ST | 200 CLEMENT ST | - | 04TH AVE | 04TH AVE |
| 42775 | N/A | Point | - | - | - | - | S120781 | DELMAR ST: FREDERICK ST | - | F | F | - | F | 26334000 | 26334000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FREDERICK ST | FREDERICK ST | 18302 | 18302 | 37.76732316 | -122.44554478 | DELMAR ST \ FREDERICK ST | DELMAR ST \ FREDERICK ST | 1710539427000 | MTA | TWO WAY TRAFFIC AHEAD | FREDERICK ST intersection | - | SWCORNER | - | - | - | - | - | 59868 | 1113264000000 | -122.44554478 | 37.76732316 | - | - | - | D5 | - | OTHER REGULATORY | REG | R40(CA).0001 | 24X30 | SUP1 | LIGHT POLE | IS | 1373574060000 | DELMAR ST | - | - | - | - | - | - |
| 42776 | N/A | Point | 1 | 1 | 1200 - 1227 | - | S120782 | 1200-1227 37TH AVE | 1200-1227 37TH AVE | F | F | - | F | 1825000 | 1825000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 18303 | 18303 | 37.76428901 | -122.49652541 | - | - | 1726622230000 | middleware_editor | TWO WAY TRAFFIC AHEAD | LINCOLN WAY to SUNSET BLVD (1200 - 1227) | - | SPL#1287 | - | - | - | - | - | 59869 | 1113264000000 | -122.49652541 | 37.76428901 | - | - | - | D4 | - | OTHER REGULATORY | REG | R40(CA).0001 | 24X30 | SUP2 | 2IN IRON POST | IS | 1373574060000 | 37TH AVE | 1200 - 1227 37TH AVE | 1200 - 1227 37TH AVE | 1200 37TH AVE | - | SUNSET BLVD | SUNSET BLVD |
| 42777 | N/A | Point | 1 | 1 | 600 - 699 | - | S120783 | 600-699 GILMAN AVE | 600-699 GILMAN AVE | T | T | - | F | 6184000 | 6184000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | DONAHUE ST | DONAHUE ST | 18304 | 18304 | 37.71557778 | -122.38346203 | - | - | 1710539427000 | MTA | PEDESTRIAN (SYM) | DONAHUE ST to EARL ST (600 - 699) | 98416 | 600 GILMAN UNDER STREET NAMES | - | - | - | - | - | 59870 | 1113264000000 | -122.38346203 | 37.71557778 | - | 1630281600000 | - | D10 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | LIGHT POLE | IS | 1373574060000 | GILMAN AVE | 600 - 699 GILMAN AVE | 600 - 699 GILMAN AVE | 600 GILMAN AVE | - | EARL ST | EARL ST |
| 42778 | N/A | Point | - | - | - | - | S121067 | 3RD ST: ARMSTRONG AVE | - | F | F | - | F | 20493000 | 20493000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ARMSTRONG AVE | ARMSTRONG AVE | 18313 | 18313 | 37.72697983 | -122.39357016 | 3RD ST \ ARMSTRONG AVE | 03RD ST \ ARMSTRONG AVE | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | ARMSTRONG AVE intersection | - | - | - | - | - | - | - | 59871 | 1116633600000 | -122.39357016 | 37.72697983 | - | - | - | D10 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP1 | OVERHEAD MAST ARM | IS | 1373574120000 | 03RD ST | - | - | - | - | - | - |
| 42779 | N/A | Point | - | - | - | - | S121068 | 3RD ST: ARMSTRONG AVE | - | F | F | - | F | 20493000 | 20493000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ARMSTRONG AVE | ARMSTRONG AVE | 18314 | 18314 | 37.72697983 | -122.39357016 | 3RD ST \ ARMSTRONG AVE | 03RD ST \ ARMSTRONG AVE | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | ARMSTRONG AVE intersection | - | - | - | - | - | - | - | 59872 | 1116633600000 | -122.39357016 | 37.72697983 | - | - | - | D10 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP1 | OVERHEAD MAST ARM | IS | 1373574120000 | 03RD ST | - | - | - | - | - | - |
| 42780 | N/A | Point | - | - | - | - | S124824 | 4TH ST: WELSH ST | - | F | F | - | F | 23833000 | 23833000 | - | - | NORTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WELSH ST | WELSH ST | 19537 | 19537 | 37.77913222 | -122.39753891 | 4TH ST \ WELSH ST | 04TH ST \ WELSH ST | 1710539427000 | MTA | AT&T PARK RIGHT LANES | WELSH ST intersection | - | - | - | - | - | - | - | 59873 | 1155081600000 | -122.39753891 | 37.77913222 | - | - | - | D6 | - | OTHER GUIDE | GUIDE | G-A(SF).0029 | 42X30 | SUP1 | MUNI POLE | IS | 1373575320000 | 04TH ST | - | - | - | - | - | - |
| 42781 | N/A | Point | - | - | - | - | S124825 | DIAMOND ST: 25TH ST | - | F | F | - | F | 25758000 | 25758000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 25TH ST | DIAMOND ST | 19538 | 19538 | 37.74956203 | -122.4361377 | DIAMOND ST \ 25TH ST | 25TH ST \ DIAMOND ST | 1710539427000 | MTA | ALL WAY | DIAMOND ST intersection | - | - | - | - | - | - | - | 59874 | 1155081600000 | -122.4361377 | 37.74956203 | - | - | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575320000 | 25TH ST | - | - | - | - | - | - |
| 42782 | N/A | Point | - | - | - | - | S124666 | FELL ST: SCOTT ST | - | F | F | - | F | 26030000 | 26030000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FELL ST | FELL ST | 19599 | 19599 | 37.77427668 | -122.43594033 | SCOTT ST \ FELL ST | SCOTT ST \ FELL ST | 1710539427000 | MTA | S F BIKE ROUTE (RED SYM) 30 GOLDEN GATE PARK (RA) | FELL ST intersection | - | - | - | - | - | - | - | 59875 | 1154304000000 | -122.43594033 | 37.77427668 | - | - | - | D5 | - | BIKE GUIDE | GUIDE | SG45R(30).0007 | 12X24 | SUP1 | LIGHT POLE | IS | 1373575260000 | SCOTT ST | - | - | - | - | - | - |
| 42783 | N/A | Point | - | - | - | - | S124667 | SCOTT ST: OAK ST | - | F | F | - | F | 26027000 | 26027000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SCOTT ST | SCOTT ST | 19600 | 19600 | 37.77334571 | -122.4357515 | OAK ST \ SCOTT ST | OAK ST \ SCOTT ST | 1710539427000 | MTA | S F BIKE ROUTE (RED SYM) 30,47 | SCOTT ST intersection | - | - | - | - | - | - | - | 59876 | 1154304000000 | -122.4357515 | 37.77334571 | - | - | - | D5 | - | BIKE GUIDE | GUIDE | SG45R(30,47).0001 | 12X22 | SUP1 | LIGHT POLE | IS | 1373575260000 | OAK ST | - | - | - | - | - | - |
| 42784 | N/A | Point | - | - | - | - | S124668 | MARKET ST: ROSE ST | - | F | F | - | F | 30751000 | 30751000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ROSE ST | ROSE ST | 19601 | 19601 | 37.77377475 | -122.42108942 | MARKET ST \ ROSE ST | MARKET ST \ ROSE ST | 1710539427000 | MTA | MERGE AHEAD | ROSE ST intersection | - | - | - | - | - | - | - | 59877 | 1154304000000 | -122.42108942 | 37.77377475 | - | - | - | D5 | - | OTHER WARNING | WARNING | W4-1.0001 | 24X24 | SUP1 | LIGHT POLE | IS | 1373575260000 | MARKET ST | - | - | - | - | - | - |
| 42785 | N/A | Point | - | - | - | - | S124670 | VALLEJO ST: LARKIN ST | - | F | F | - | F | 25312000 | 25312000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LARKIN ST | VALLEJO ST | 19602 | 19602 | 37.79710888 | -122.42031688 | VALLEJO ST \ LARKIN ST | LARKIN ST \ VALLEJO ST | 1710539427000 | MTA | ALL WAY | VALLEJO ST intersection | - | - | - | - | - | - | - | 59878 | 1154390400000 | -122.42031688 | 37.79710888 | - | 1555027200000 | - | D3 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 3IN IRON POST | IS | 1373575260000 | LARKIN ST | - | - | - | - | - | - |
| 42786 | N/A | Point | - | - | - | - | S124671 | SANCHEZ ST: VALLEY ST | - | F | F | - | F | 21912000 | 21912000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SANCHEZ ST | SANCHEZ ST | 19603 | 19603 | 37.74436324 | -122.42895947 | VALLEY ST \ SANCHEZ ST | VALLEY ST \ SANCHEZ ST | 1720575133000 | middleware_editor | ALL WAY | SANCHEZ ST intersection | - | - | - | - | - | - | - | 59879 | 1154390400000 | -122.42895947 | 37.74436324 | - | 1572825600000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1373575260000 | VALLEY ST | - | - | - | - | - | - |
| 42787 | N/A | Point | - | - | - | - | S124672 | SANCHEZ ST: 29TH ST | - | F | F | - | F | 21910000 | 21910000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SANCHEZ ST | 29TH ST | 19604 | 19604 | 37.74356534 | -122.42888269 | 29TH ST \ SANCHEZ ST | SANCHEZ ST \ 29TH ST | 1710539427000 | MTA | ALL WAY | 29TH ST intersection | - | - | - | - | - | - | - | 59880 | 1154390400000 | -122.42888269 | 37.74356534 | - | - | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 3IN IRON POST | IS | 1373575260000 | SANCHEZ ST | - | - | - | - | - | - |
| 42788 | N/A | Point | - | - | - | - | S124677 | VALLEY ST: SANCHEZ ST | - | F | F | - | F | 21912000 | 21912000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SANCHEZ ST | SANCHEZ ST | 19606 | 19606 | 37.74436324 | -122.42895947 | VALLEY ST \ SANCHEZ ST | VALLEY ST \ SANCHEZ ST | 1720575169000 | middleware_editor | ALL WAY | SANCHEZ ST intersection | - | - | - | - | - | - | - | 59881 | 1154390400000 | -122.42895947 | 37.74436324 | - | - | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575260000 | VALLEY ST | - | - | - | - | - | - |
| 42789 | N/A | Point | - | - | - | - | S124830 | SANCHEZ ST: 25TH ST | - | F | F | - | F | 25645000 | 25645000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 25TH ST | 25TH ST | 19607 | 19607 | 37.7499645 | -122.42950009 | SANCHEZ ST \ 25TH ST | SANCHEZ ST \ 25TH ST | 1711491361000 | middleware_editor | ALL WAY | 25TH ST intersection | - | - | - | - | - | - | - | 59882 | 1155081600000 | -122.42950009 | 37.7499645 | - | 1557187200000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575320000 | SANCHEZ ST | - | - | - | - | - | - |
| 42790 | N/A | Point | - | - | - | - | S124833 | FILBERT ST: POLK ST | - | F | F | - | F | 25564000 | 25564000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FILBERT ST | FILBERT ST | 19608 | 19608 | 37.79969367 | -122.42252522 | POLK ST \ FILBERT ST | POLK ST \ FILBERT ST | 1710539427000 | MTA | ALL WAY | FILBERT ST intersection | - | - | - | - | - | - | - | 59883 | 1155081600000 | -122.42252522 | 37.79969367 | - | 1556668800000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 3IN IRON POST | IS | 1373575320000 | POLK ST | - | - | - | - | - | - |
| 42791 | N/A | Point | - | - | - | - | S124834 | FILBERT ST: POLK ST | - | F | F | - | F | 25564000 | 25564000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FILBERT ST | FILBERT ST | 19609 | 19609 | 37.79969367 | -122.42252522 | POLK ST \ FILBERT ST | POLK ST \ FILBERT ST | 1710539427000 | MTA | ALL WAY | FILBERT ST intersection | - | - | - | - | - | - | - | 59884 | 1155081600000 | -122.42252522 | 37.79969367 | - | 1557446400000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575320000 | POLK ST | - | - | - | - | - | - |
| 42792 | N/A | Point | - | 1 | 1800 - 1890 | - | S128858 | 3200-3259 ILLINOIS ST | 1800-1890 ILLINOIS ST | F | F | - | F | 7177000 | 7177000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | MARIN ST | MARIN ST | 19622 | 19622 | 37.74855337 | -122.3863785 | - | - | 1710539427000 | MTA | KEEP LEFT-BIKE(SYM)/RIGHT-PED(SYM) | MARIN ST to ILLINOIS ST (1800 - 1890) | - | 734' SOUTH SOUTH LINE OF BRIDGE ABO..... | - | - | - | - | - | 59885 | 1205712000000 | -122.3863785 | 37.74855337 | - | - | - | D10 | - | OTHER REGULATORY | REG | R4-8A(SF).0001 | 30X36 | SUP1 | LIGHT POLE | IS | 1373576580000 | ILLINOIS ST | 1800 - 1890 ILLINOIS ST | 1800 - 1890 ILLINOIS ST | 1800 ILLINOIS ST | - | ILLINOIS ST | ILLINOIS ST |
| 42793 | N/A | Point | - | - | - | - | S128859 | 25TH AVE: IRVING ST | - | F | F | - | F | 27422000 | 27422000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 25TH AVE | IRVING ST | 19623 | 19623 | 37.76327863 | -122.48355356 | IRVING ST \ 25TH AVE | 25TH AVE \ IRVING ST | 1710539427000 | MTA | ALL WAY | IRVING ST intersection | - | - | - | - | - | - | - | 59886 | 1205798400000 | -122.48355356 | 37.76327863 | - | 1514419200000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373576580000 | 25TH AVE | - | - | - | - | - | - |
| 42794 | N/A | Point | - | - | - | - | S128860 | 25TH AVE: IRVING ST | - | F | F | - | F | 27422000 | 27422000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 25TH AVE | IRVING ST | 19624 | 19624 | 37.76327863 | -122.48355356 | IRVING ST \ 25TH AVE | 25TH AVE \ IRVING ST | 1710539427000 | MTA | ALL WAY | IRVING ST intersection | - | - | - | - | - | - | - | 59887 | 1205798400000 | -122.48355356 | 37.76327863 | - | 1514419200000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373576580000 | 25TH AVE | - | - | - | - | - | - |
| 42795 | N/A | Point | - | - | - | - | S128861 | IRVING ST: 25TH AVE | - | F | F | - | F | 27422000 | 27422000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 25TH AVE | IRVING ST | 19625 | 19625 | 37.76327863 | -122.48355356 | IRVING ST \ 25TH AVE | 25TH AVE \ IRVING ST | 1710539427000 | MTA | ALL WAY | IRVING ST intersection | - | - | - | - | - | - | - | 59888 | 1205798400000 | -122.48355356 | 37.76327863 | - | 1513036800000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373576580000 | 25TH AVE | - | - | - | - | - | - |
| 42796 | N/A | Point | - | - | - | - | S128862 | IRVING ST: 25TH AVE | - | F | F | - | F | 27422000 | 27422000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 25TH AVE | IRVING ST | 19626 | 19626 | 37.76327863 | -122.48355356 | IRVING ST \ 25TH AVE | 25TH AVE \ IRVING ST | 1710539427000 | MTA | ALL WAY | IRVING ST intersection | - | - | - | - | - | - | - | 59889 | 1205798400000 | -122.48355356 | 37.76327863 | - | 1496620800000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1373576580000 | 25TH AVE | - | - | - | - | - | - |
| 42797 | N/A | Point | - | - | - | - | S129872 | ILLINOIS ST: 16TH ST | - | F | F | - | F | 23575000 | 23575000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 16TH ST | 16TH ST | 19629 | 19629 | 37.76695791 | -122.38816414 | ILLINOIS ST \ 16TH ST | ILLINOIS ST \ 16TH ST | 1738856903000 | middleware_editor | STOP | 16TH ST intersection | - | - | - | - | - | - | - | 59890 | 1228780800000 | -122.38816414 | 37.76695791 | - | - | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373576880000 | ILLINOIS ST | - | - | - | - | - | - |
| 42798 | N/A | Point | 1 | 1 | 1 - 55 | - | S123002 | 1-55 9TH ST | 1-55 09TH ST | F | F | - | F | 446000 | 446000 | - | - | EAST SIDE | - | - | - | - | LARKIN ST \ MARKET ST | LARKIN ST \ MARKET ST | 21214 | 21214 | 37.77710578 | -122.41580614 | - | - | 1710539427000 | MTA | TANS 3PM-7PM EXC SAT & SUN | LARKIN ST \ MARKET ST to JESSIE ST (1 - 55) | - | 25' SOUTH OF SPL # 55 | - | - | - | - | - | 59891 | 1142553600000 | -122.41580614 | 37.77710578 | - | - | - | D6 | - | OTHER REGULATORY | REG | R37(CA).0022 | 18X21 | SUP1 | MUNI POLE | IS | 1373574780000 | 09TH ST | 1 - 55 9TH ST | 1 - 55 09TH ST | 1 9TH ST | - | JESSIE ST | JESSIE ST |
| 42799 | N/A | Point | 1 | 1 | 1 - 55 | - | S123003 | 1-55 9TH ST | 1-55 09TH ST | F | F | - | F | 446000 | 446000 | - | - | WEST SIDE | - | - | - | - | LARKIN ST \ MARKET ST | LARKIN ST \ MARKET ST | 21215 | 21215 | 37.77710578 | -122.41580614 | - | - | 1710539427000 | MTA | TANS 3PM-7PM EXC SAT & SUN | LARKIN ST \ MARKET ST to JESSIE ST (1 - 55) | - | 50' SOUTH | - | - | - | - | - | 59892 | 1142553600000 | -122.41580614 | 37.77710578 | - | - | - | D6 | - | OTHER REGULATORY | REG | R37(CA).0022 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1373574780000 | 09TH ST | 1 - 55 9TH ST | 1 - 55 09TH ST | 1 9TH ST | - | JESSIE ST | JESSIE ST |
| 42800 | N/A | Point | 1 | 1 | 100 - 139 | - | S123005 | 100-139 9TH ST | 100-139 09TH ST | F | F | - | F | 448000 | 448000 | - | - | WEST SIDE | - | - | - | - | MISSION ST | MISSION ST | 21216 | 21216 | 37.7760156 | -122.4144421 | - | - | 1710539427000 | MTA | TANS 3PM-7PM EXC SAT & SUN | MISSION ST to MINNA ST (100 - 139) | - | 25' NORTH OF HOWARD | - | - | - | - | - | 59893 | 1142553600000 | -122.4144421 | 37.7760156 | - | - | - | D6 | - | OTHER REGULATORY | REG | R37(CA).0022 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1373574780000 | 09TH ST | 100 - 139 9TH ST | 100 - 139 09TH ST | 100 9TH ST | - | MINNA ST | MINNA ST |
| 42801 | N/A | Point | 1 | 1 | 100 - 139 | - | S123006 | 100-139 9TH ST | 100-139 09TH ST | F | F | - | F | 448000 | 448000 | - | - | EAST SIDE | - | - | - | - | MISSION ST | MISSION ST | 21217 | 21217 | 37.7760156 | -122.4144421 | - | - | 1710539427000 | MTA | TANS 3PM-7PM EXC SAT & SUN | MISSION ST to MINNA ST (100 - 139) | - | 25'NORTH OF HOWARD | - | - | - | - | - | 59894 | 1142553600000 | -122.4144421 | 37.7760156 | - | - | - | D6 | - | OTHER REGULATORY | REG | R37(CA).0022 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373574780000 | 09TH ST | 100 - 139 9TH ST | 100 - 139 09TH ST | 100 9TH ST | - | MINNA ST | MINNA ST |
| 42802 | N/A | Point | 1 | 1 | 100 - 139 | - | S123008 | 100-139 9TH ST | 100-139 09TH ST | F | F | - | F | 448000 | 448000 | - | - | EAST SIDE | - | - | - | - | MISSION ST | MISSION ST | 21218 | 21218 | 37.7760156 | -122.4144421 | - | - | 1710539427000 | MTA | TANS 3PM-7PM EXC SAT & SUN | MISSION ST to MINNA ST (100 - 139) | - | 50' SOUTH OF RINGOLD | - | - | - | - | - | 59895 | 1142553600000 | -122.4144421 | 37.7760156 | - | - | - | D6 | - | OTHER REGULATORY | REG | R37(CA).0022 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1373574780000 | 09TH ST | 100 - 139 9TH ST | 100 - 139 09TH ST | 100 9TH ST | - | MINNA ST | MINNA ST |
| 42803 | N/A | Point | 1 | 1 | 100 - 139 | - | S123009 | 100-139 9TH ST | 100-139 09TH ST | F | F | - | F | 448000 | 448000 | - | - | WEST SIDE | - | - | - | - | MISSION ST | MISSION ST | 21219 | 21219 | 37.7760156 | -122.4144421 | - | - | 1710539427000 | MTA | TANS 3PM-7PM EXC SAT & SUN | MISSION ST to MINNA ST (100 - 139) | - | INFO # 130-132 | - | - | - | - | - | 59896 | 1142553600000 | -122.4144421 | 37.7760156 | - | - | - | D6 | - | OTHER REGULATORY | REG | R37(CA).0022 | 18X21 | SUP1 | LIGHT POLE | IS | 1373574780000 | 09TH ST | 100 - 139 9TH ST | 100 - 139 09TH ST | 100 9TH ST | - | MINNA ST | MINNA ST |
| 42804 | N/A | Point | 1 | 1 | 100 - 139 | - | S123011 | 100-139 9TH ST | 100-139 09TH ST | F | F | - | F | 448000 | 448000 | - | - | EAST SIDE | - | - | - | - | MISSION ST | MISSION ST | 21220 | 21220 | 37.7760156 | -122.4144421 | - | - | 1710539427000 | MTA | TANS 3PM-7PM EXC SAT & SUN | MISSION ST to MINNA ST (100 - 139) | - | NPL # 149 | - | - | - | - | - | 59897 | 1142553600000 | -122.4144421 | 37.7760156 | - | - | - | D6 | - | OTHER REGULATORY | REG | R37(CA).0022 | 18X21 | SUP1 | LIGHT POLE | IS | 1373574780000 | 09TH ST | 100 - 139 9TH ST | 100 - 139 09TH ST | 100 9TH ST | - | MINNA ST | MINNA ST |
| 42805 | N/A | Point | 1 | 1 | 100 - 139 | - | S123012 | 100-139 9TH ST | 100-139 09TH ST | F | F | - | F | 448000 | 448000 | - | - | EAST SIDE | - | - | - | - | MISSION ST | MISSION ST | 21221 | 21221 | 37.7760156 | -122.4144421 | - | - | 1710539427000 | MTA | TANS 3PM-7PM EXC SAT & SUN | MISSION ST to MINNA ST (100 - 139) | - | SPL # 101 | - | - | - | - | - | 59898 | 1142553600000 | -122.4144421 | 37.7760156 | - | - | - | D6 | - | OTHER REGULATORY | REG | R37(CA).0022 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373574780000 | 09TH ST | 100 - 139 9TH ST | 100 - 139 09TH ST | 100 9TH ST | - | MINNA ST | MINNA ST |
| 42806 | N/A | Point | - | - | - | - | S123013 | 42ND AVE: KIRKHAM ST | - | F | F | - | F | 27774000 | 27774000 | - | - | SOUTH WEST CORNER | - | - | - | - | 42ND AVE | 42ND AVE | 21222 | 21222 | 37.75874722 | -122.5015054 | KIRKHAM ST \ 42ND AVE | KIRKHAM ST \ 42ND AVE | 1710539427000 | MTA | BUS STOP TANS (H/C SYM) 7AM-4PM SCHL DAYS | 42ND AVE intersection | - | (PLUS LA) | - | - | - | - | - | 59899 | 1142553600000 | -122.5015054 | 37.75874722 | - | 1424908800000 | - | D4 | - | OTHER REGULATORY | REG | R37(SF).0003 | 18X30 | SUP2 | 2IN IRON POST | IS | 1373574780000 | KIRKHAM ST | - | - | - | - | - | - |
| 42807 | N/A | Point | - | - | - | - | S125255 | PACIFIC AVE: PIERCE ST | - | F | F | - | F | 26675000 | 26675000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PIERCE ST | PACIFIC AVE | 21223 | 21223 | 37.79292692 | -122.43802223 | PACIFIC AVE \ PIERCE ST | PIERCE ST \ PACIFIC AVE | 1710539427000 | MTA | ALL WAY | PACIFIC AVE intersection | - | - | - | - | - | - | - | 59900 | 1156464000000 | -122.43802223 | 37.79292692 | - | 1591920000000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575440000 | PIERCE ST | - | - | - | - | - | - |
| 42808 | N/A | Point | - | - | - | - | S125256 | PACIFIC AVE: SCOTT ST | - | F | F | - | F | 26857000 | 26857000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PACIFIC AVE | SCOTT ST | 21224 | 21224 | 37.79272276 | -122.43966589 | SCOTT ST \ PACIFIC AVE | PACIFIC AVE \ SCOTT ST | 1710539427000 | MTA | ALL WAY | SCOTT ST intersection | - | - | - | - | - | - | - | 59901 | 1156464000000 | -122.43966589 | 37.79272276 | - | 1536278400000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575440000 | PACIFIC AVE | - | - | - | - | - | - |
| 42809 | N/A | Point | - | - | - | - | S125258 | SACRAMENTO ST: PIERCE ST | - | F | F | - | F | 26638000 | 26638000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SACRAMENTO ST | PIERCE ST | 21226 | 21226 | 37.78942163 | -122.43731857 | PIERCE ST \ SACRAMENTO ST | SACRAMENTO ST \ PIERCE ST | 1710539427000 | MTA | ALL WAY | PIERCE ST intersection | - | - | - | - | - | - | - | 59902 | 1156464000000 | -122.43731857 | 37.78942163 | - | 1591228800000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575440000 | SACRAMENTO ST | - | - | - | - | - | - |
| 42810 | N/A | Point | - | - | - | - | S125259 | SACRAMENTO ST: PIERCE ST | - | F | F | - | F | 26638000 | 26638000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SACRAMENTO ST | PIERCE ST | 21227 | 21227 | 37.78942163 | -122.43731857 | PIERCE ST \ SACRAMENTO ST | SACRAMENTO ST \ PIERCE ST | 1710539427000 | MTA | ALL WAY | PIERCE ST intersection | - | - | - | - | - | - | - | 59903 | 1156464000000 | -122.43731857 | 37.78942163 | - | 1591228800000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575440000 | SACRAMENTO ST | - | - | - | - | - | - |
| 42811 | N/A | Point | 1 | 1 | 600 - 634 | - | S127339 | 600-634 MISSION ST | 600-634 MISSION ST | F | F | - | F | 9092000 | 9092000 | - | - | SOUTH SIDE | - | - | - | - | 2ND ST | 02ND ST | 22919 | 22919 | 37.78772883 | -122.40015056 | - | - | 1710539427000 | MTA | TANSAT | 02ND ST to NEW MONTGOMERY ST (600 - 634) | - | 46FT EAST OF 2ND ST | - | - | - | - | - | 59904 | 1175731200000 | -122.40015056 | 37.78772883 | - | - | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373576100000 | MISSION ST | 600 - 634 MISSION ST | 600 - 634 MISSION ST | 600 MISSION ST | - | NEW MONTGOMERY ST | NEW MONTGOMERY ST |
| 42812 | N/A | Point | - | - | - | - | S127341 | ILLINOIS ST: 20TH ST | - | F | F | - | F | 23562000 | 23562000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ILLINOIS ST | 20TH ST | 22921 | 22921 | 37.76055022 | -122.38756878 | 20TH ST \ ILLINOIS ST | ILLINOIS ST \ 20TH ST | 1710539427000 | MTA | FREEWAY (VA) | 20TH ST intersection | - | ABOVE AT&T VA | - | - | - | - | - | 59905 | 1175817600000 | -122.38756878 | 37.76055022 | - | - | - | D10 | - | OTHER GUIDE | GUIDE | G-F(SF).0056 | 48X16 | SUP1 | 2IN IRON POST | IS | 1373576100000 | ILLINOIS ST | - | - | - | - | - | - |
| 42813 | N/A | Point | 1 | 1 | 2500 - 2549 | - | S127342 | 2500-2549 SANTIAGO ST | 2500-2549 SANTIAGO ST | F | F | - | F | 11627000 | 11627000 | - | - | NORTH SIDE | - | - | - | - | 36TH AVE | 36TH AVE | 22922 | 22922 | 37.74410365 | -122.49430616 | - | - | 1710539427000 | MTA | NPRK ANY TIME VEH OVER 22' LONG OR 7' HIGH 12AM-6AM EVERYDAY | 36TH AVE to SUNSET BLVD (2500 - 2549) | - | 25`WEST | - | - | - | - | - | 59906 | 1175817600000 | -122.49430616 | 37.74410365 | - | - | - | D4 | - | PARKING:NPRK ANY TIME | REG | R30(SF).0572 | 18X18 | SUP2 | 2IN IRON POST | IS | 1373576100000 | SANTIAGO ST | 2500 - 2549 SANTIAGO ST | 2500 - 2549 SANTIAGO ST | 2500 SANTIAGO ST | - | SUNSET BLVD | SUNSET BLVD |
| 42814 | N/A | Point | 1 | 1 | 2500 - 2549 | - | S127343 | 2500-2549 SANTIAGO ST | 2500-2549 SANTIAGO ST | F | F | - | F | 11627000 | 11627000 | - | - | SOUTH SIDE | - | - | - | - | 36TH AVE | 36TH AVE | 22923 | 22923 | 37.74410365 | -122.49430616 | - | - | 1710539427000 | MTA | NPRK ANY TIME VEH OVER 22' LONG OR 7' HIGH 12AM-6AM EVERYDAY | 36TH AVE to SUNSET BLVD (2500 - 2549) | - | 25`WEST | - | - | - | - | - | 59907 | 1175817600000 | -122.49430616 | 37.74410365 | - | 1457395200000 | - | D4 | - | PARKING:NPRK ANY TIME | REG | R30(SF).0572 | 18X18 | SUP2 | 2IN IRON POST | IS | 1373576100000 | SANTIAGO ST | 2500 - 2549 SANTIAGO ST | 2500 - 2549 SANTIAGO ST | 2500 SANTIAGO ST | - | SUNSET BLVD | SUNSET BLVD |
| 42815 | N/A | Point | 1 | 1 | 2500 - 2549 | - | S127345 | 2500-2549 WAWONA ST | 2500-2549 WAWONA ST | F | F | - | F | 13489000 | 13489000 | - | - | SOUTH SIDE | - | - | - | - | 36TH AVE | 36TH AVE | 22924 | 22924 | 37.73667042 | -122.493797 | - | - | 1749690858000 | middleware_editor | NPRK ANY TIME VEH OVER 22' LONG OR 7' HIGH 12AM-6AM EVERYDAY | 36TH AVE to SUNSET BLVD (2500 - 2549) | - | 20`WEST | - | - | - | - | - | 59908 | 1175842800000 | -122.493797 | 37.73667042 | - | 1749651600000 | - | D4 | - | PARKING:NPRK ANY TIME | REG | R30(SF).0572 | 18X18 | SUP2 | 2IN IRON POST | IS | 1373576100000 | WAWONA ST | 2500 - 2549 WAWONA ST | 2500 - 2549 WAWONA ST | 2500 WAWONA ST | - | SUNSET BLVD | SUNSET BLVD |
| 42816 | N/A | Point | 1 | 1 | 2600 - 2649 | - | S127346 | 2600-2649 RIVERA ST | 2600-2649 RIVERA ST | F | F | - | F | 11069000 | 11069000 | - | - | NORTH SIDE | - | - | - | - | 36TH AVE | 36TH AVE | 22925 | 22925 | 37.74596346 | -122.49443633 | - | - | 1710539427000 | MTA | NPRK ANY TIME VEH OVER 22' LONG OR 7' HIGH 12AM-6AM EVERYDAY | 36TH AVE to SUNSET BLVD (2600 - 2649) | - | 25`WEST | - | - | - | - | - | 59909 | 1175817600000 | -122.49443633 | 37.74596346 | - | - | - | D4 | - | PARKING:NPRK ANY TIME | REG | R30(SF).0572 | 18X18 | SUP2 | 2IN IRON POST | IS | 1373576100000 | RIVERA ST | 2600 - 2649 RIVERA ST | 2600 - 2649 RIVERA ST | 2600 RIVERA ST | - | SUNSET BLVD | SUNSET BLVD |
| 42817 | N/A | Point | 1 | 1 | 2600 - 2649 | - | S127347 | 2600-2649 RIVERA ST | 2600-2649 RIVERA ST | F | F | - | F | 11069000 | 11069000 | - | - | SOUTH SIDE | - | - | - | - | 36TH AVE | 36TH AVE | 22926 | 22926 | 37.74596346 | -122.49443633 | - | - | 1710539427000 | MTA | NPRK ANY TIME VEH OVER 22' LONG OR 7' HIGH 12AM-6AM EVERYDAY | 36TH AVE to SUNSET BLVD (2600 - 2649) | - | 45`WEST | - | - | - | - | - | 59910 | 1175817600000 | -122.49443633 | 37.74596346 | - | 1453420800000 | - | D4 | - | PARKING:NPRK ANY TIME | REG | R30(SF).0572 | 18X18 | SUP2 | 2IN IRON POST | IS | 1373576100000 | RIVERA ST | 2600 - 2649 RIVERA ST | 2600 - 2649 RIVERA ST | 2600 RIVERA ST | - | SUNSET BLVD | SUNSET BLVD |
| 42818 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S126541 | 1400-1499 RHODE ISLAND ST | 1400-1499 RHODE ISLAND ST | F | F | - | F | 11005000 | 11005000 | - | - | EAST SIDE | - | - | - | - | 25TH ST | 25TH ST | 22927 | 22927 | 37.75132489 | -122.40129816 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "W" PERMITS | 25TH ST to 26TH ST (1400 - 1499) | - | 0 / INSTALL RPP AREA W SIGN BELOW S..... | - | - | - | - | - | 59911 | 1169424000000 | -122.40129816 | 37.75132489 | - | - | - | D10 | - | PARKING:RPP | REG | R32C(CA).0105 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373575860000 | RHODE ISLAND ST | 1400 - 1499 RHODE ISLAND ST | 1400 - 1499 RHODE ISLAND ST | 1400 RHODE ISLAND ST | - | 26TH ST | 26TH ST |
| 42819 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S126542 | 1400-1499 RHODE ISLAND ST | 1400-1499 RHODE ISLAND ST | F | F | - | F | 11005000 | 11005000 | - | - | WEST SIDE | - | - | - | - | 25TH ST | 25TH ST | 22928 | 22928 | 37.75132489 | -122.40129816 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "W" PERMITS | 25TH ST to 26TH ST (1400 - 1499) | - | 0 / INSTALL RPP AREA W SIGN BELOW S..... | - | - | - | - | - | 59912 | 1169424000000 | -122.40129816 | 37.75132489 | - | - | - | D10 | - | PARKING:RPP | REG | R32C(CA).0105 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373575860000 | RHODE ISLAND ST | 1400 - 1499 RHODE ISLAND ST | 1400 - 1499 RHODE ISLAND ST | 1400 RHODE ISLAND ST | - | 26TH ST | 26TH ST |
| 42820 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S126543 | 1400-1499 RHODE ISLAND ST | 1400-1499 RHODE ISLAND ST | F | F | - | F | 11005000 | 11005000 | - | - | EAST SIDE | - | - | - | - | 25TH ST | 25TH ST | 22929 | 22929 | 37.75132489 | -122.40129816 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "W" PERMITS | 25TH ST to 26TH ST (1400 - 1499) | - | 0 / INSTALL RPP AREA W SIGN BELOW S..... | - | - | - | - | - | 59913 | 1169424000000 | -122.40129816 | 37.75132489 | - | - | - | D10 | - | PARKING:RPP | REG | R32C(CA).0105 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373575860000 | RHODE ISLAND ST | 1400 - 1499 RHODE ISLAND ST | 1400 - 1499 RHODE ISLAND ST | 1400 RHODE ISLAND ST | - | 26TH ST | 26TH ST |
| 42821 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S126544 | 1400-1499 RHODE ISLAND ST | 1400-1499 RHODE ISLAND ST | F | F | - | F | 11005000 | 11005000 | - | - | WEST SIDE | - | - | - | - | 25TH ST | 25TH ST | 22930 | 22930 | 37.75132489 | -122.40129816 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "W" PERMITS | 25TH ST to 26TH ST (1400 - 1499) | - | SPL # 1418 RHODE ISLAND | - | - | - | - | - | 59914 | 1169424000000 | -122.40129816 | 37.75132489 | - | 1552348800000 | - | D10 | - | PARKING:RPP | REG | R32C(CA).0105 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373575860000 | RHODE ISLAND ST | 1400 - 1499 RHODE ISLAND ST | 1400 - 1499 RHODE ISLAND ST | 1400 RHODE ISLAND ST | - | 26TH ST | 26TH ST |
| 42822 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S126545 | 1400-1499 RHODE ISLAND ST | 1400-1499 RHODE ISLAND ST | F | F | - | F | 11005000 | 11005000 | - | - | EAST SIDE | - | - | - | - | 25TH ST | 25TH ST | 22931 | 22931 | 37.75132489 | -122.40129816 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "W" PERMITS | 25TH ST to 26TH ST (1400 - 1499) | - | 0 / INSTALL RPP AREA W SIGN BELOW S..... | - | - | - | - | - | 59915 | 1169424000000 | -122.40129816 | 37.75132489 | - | - | - | D10 | - | PARKING:RPP | REG | R32C(CA).0105 | 18X21 | SUP1 | LIGHT POLE | IS | 1373575860000 | RHODE ISLAND ST | 1400 - 1499 RHODE ISLAND ST | 1400 - 1499 RHODE ISLAND ST | 1400 RHODE ISLAND ST | - | 26TH ST | 26TH ST |
| 42823 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S126547 | 1400-1499 RHODE ISLAND ST | 1400-1499 RHODE ISLAND ST | F | F | - | F | 11005000 | 11005000 | - | - | EAST SIDE | - | - | - | - | 25TH ST | 25TH ST | 22932 | 22932 | 37.75132489 | -122.40129816 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "W" PERMITS | 25TH ST to 26TH ST (1400 - 1499) | - | 0 / INSTALL RPP AREA W SIGN BELOW S..... | - | - | - | - | - | 59916 | 1169424000000 | -122.40129816 | 37.75132489 | - | - | - | D10 | - | PARKING:RPP | REG | R32C(CA).0105 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373575860000 | RHODE ISLAND ST | 1400 - 1499 RHODE ISLAND ST | 1400 - 1499 RHODE ISLAND ST | 1400 RHODE ISLAND ST | - | 26TH ST | 26TH ST |
| 42824 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S126548 | 1400-1499 RHODE ISLAND ST | 1400-1499 RHODE ISLAND ST | F | F | - | F | 11005000 | 11005000 | - | - | WEST SIDE | - | - | - | - | 25TH ST | 25TH ST | 22933 | 22933 | 37.75132489 | -122.40129816 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "W" PERMITS | 25TH ST to 26TH ST (1400 - 1499) | - | 0 / INSTALL RPP AREA W SIGN BELOW S..... | - | - | - | - | - | 59917 | 1169424000000 | -122.40129816 | 37.75132489 | - | - | - | D10 | - | PARKING:RPP | REG | R32C(CA).0105 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373575860000 | RHODE ISLAND ST | 1400 - 1499 RHODE ISLAND ST | 1400 - 1499 RHODE ISLAND ST | 1400 RHODE ISLAND ST | - | 26TH ST | 26TH ST |
| 42825 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S136994 | 1300-1399 QUINT ST | 1300-1399 QUINT ST | F | F | - | F | 10832000 | 10832000 | - | - | WEST SIDE | - | - | - | - | NEWCOMB AVE | NEWCOMB AVE | 29354 | 29354 | 37.73809386 | -122.39566337 | - | - | 1710539427000 | MTA | TANP 10PM-6AM EVERYDAY | NEWCOMB AVE to OAKDALE AVE (1300 - 1399) | - | 50N / INSTALL SIGN ON 2IN POST 50FT..... | - | - | - | - | - | 59918 | 1342656000000 | -122.39566337 | 37.73809386 | - | 1660867200000 | - | D10 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0003 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373579100000 | QUINT ST | 1300 - 1399 QUINT ST | 1300 - 1399 QUINT ST | 1300 QUINT ST | - | OAKDALE AVE | OAKDALE 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