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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 51076 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S284411 | 1600-1699 EVANS AVE | 1600-1699 EVANS AVE | F | F | - | F | 5335000 | 5335000 | - | - | NORTH SIDE | - | - | - | - | PHELPS ST | PHELPS ST | 91925 | 91925 | 37.74351328 | -122.38939149 | - | - | 1710539427000 | MTA | TANSAT | PHELPS ST to QUINT ST (1600 - 1699) | - | 38' WEST OF PHELPS ST | - | - | - | - | - | 68179 | 1661212800000 | -122.38939149 | 37.74351328 | - | - | - | D10 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1660061640000 | EVANS AVE | 1600 - 1699 EVANS AVE | 1600 - 1699 EVANS AVE | 1600 EVANS AVE | - | QUINT ST | QUINT ST |
| 51077 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S284413 | 1600-1699 EVANS AVE | 1600-1699 EVANS AVE | F | F | - | F | 5335000 | 5335000 | - | - | NORTH SIDE | - | - | - | - | PHELPS ST | PHELPS ST | 91926 | 91926 | 37.74351328 | -122.38939149 | - | - | 1710539427000 | MTA | TANSAT | PHELPS ST to QUINT ST (1600 - 1699) | - | 15' WEST OF WPL# 1650 EVANS AVE. | - | - | - | - | - | 68180 | 1661212800000 | -122.38939149 | 37.74351328 | - | - | - | D10 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1660062000000 | EVANS AVE | 1600 - 1699 EVANS AVE | 1600 - 1699 EVANS AVE | 1600 EVANS AVE | - | QUINT ST | QUINT ST |
| 51078 | N/A | Point | - | - | - | - | S284418 | 23RD AVE: BALBOA ST | - | F | F | - | F | 27533000 | 27533000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | BALBOA ST | 91929 | 91929 | 37.77639989 | -122.48231845 | 23RD AVE \ BALBOA ST | 23RD AVE \ BALBOA ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | BALBOA ST intersection | - | 17 FT FROM CURB | - | - | - | - | - | 68181 | 1660089600000 | -122.48231845 | 37.77639989 | - | 1709301600000 | - | D1 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1660120380000 | 23RD AVE | - | - | - | - | - | - |
| 51079 | N/A | Point | - | - | - | - | S284419 | 23RD AVE: BALBOA ST | - | F | F | - | F | 27533000 | 27533000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | BALBOA ST | 91930 | 91930 | 37.77639989 | -122.48231845 | 23RD AVE \ BALBOA ST | 23RD AVE \ BALBOA ST | 1751058717000 | middleware_editor | SLOW STREETS FAMILY, H/C, PED, SKATEBOARD, BIKE (SYM)(COMBO) | BALBOA ST intersection | - | 9 FT AND 15 FT FROM CURB | - | - | - | - | - | 68182 | 1660114800000 | -122.48231845 | 37.77639989 | - | 1751044500000 | - | D1 | - | OTHER REGULATORY | REG | R(SF).0451 | 12X36 | SUP2 | CITY POST EMBEDDED ACHOR CUP 4 | IS | 1660120440000 | 23RD AVE | - | - | - | - | - | - |
| 51080 | N/A | Point | - | - | - | - | S284420 | 23RD AVE: BALBOA ST | - | F | F | - | F | 27533000 | 27533000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | BALBOA ST | 91931 | 91931 | 37.77639989 | -122.48231845 | 23RD AVE \ BALBOA ST | 23RD AVE \ BALBOA ST | 1734717335000 | middleware_editor | SLOW STREETS FAMILY, H/C, PED, SKATEBOARD, BIKE (SYM)(COMBO) | BALBOA ST intersection | - | 9 FT AND 15 FT FROM CURB | - | - | - | - | - | 68183 | 1660089600000 | -122.48231845 | 37.77639989 | - | 1734603000000 | - | D1 | - | OTHER REGULATORY | REG | R(SF).0451 | 12X36 | SUP2 | CITY POST EMBEDDED ACHOR CUP 4 | IS | 1660121040000 | 23RD AVE | - | - | - | - | - | - |
| 51081 | N/A | Point | - | - | - | - | S284422 | 23RD AVE: BALBOA ST | - | F | F | - | F | 27533000 | 27533000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BALBOA ST | BALBOA ST | 91932 | 91932 | 37.77639989 | -122.48231845 | 23RD AVE \ BALBOA ST | 23RD AVE \ BALBOA ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | BALBOA ST intersection | - | 17 FT FROM CURB | - | - | - | - | - | 68184 | 1660089600000 | -122.48231845 | 37.77639989 | - | - | - | D1 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1660121160000 | 23RD AVE | - | - | - | - | - | - |
| 51082 | N/A | Point | - | - | - | - | S284423 | 23RD AVE: CALIFORNIA ST | - | F | F | - | F | 27647000 | 27647000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 23RD AVE | CALIFORNIA ST | 91933 | 91933 | 37.78397927 | -122.48287005 | CALIFORNIA ST \ 23RD AVE | 23RD AVE \ CALIFORNIA ST | 1715390207000 | middleware_editor | FG 300 UR DELINEATOR (W) | CALIFORNIA ST intersection | - | 17 FT FROM CURB | - | - | - | - | - | 68185 | 1660176000000 | -122.48287005 | 37.78397927 | - | 1679011200000 | - | D1 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1660121340000 | 23RD AVE | - | - | - | - | - | - |
| 51083 | N/A | Point | - | - | - | - | S284424 | 23RD AVE: CALIFORNIA ST | - | F | F | - | F | 1211000 | 27647000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LAKE ST | CALIFORNIA ST | 91934 | 91934 | 37.7840994151015 | -122.482811138029 | - | 23RD AVE \ CALIFORNIA ST | 1749690826000 | middleware_editor | SLOW STREETS FAMILY, H/C, PED, SKATEBOARD, BIKE (SYM)(COMBO) | CALIFORNIA ST intersection | - | 9 FT AND 15 FT FROM CURB | - | - | - | - | - | 68186 | 1660201200000 | -122.48287005 | 37.78397927 | - | 1749662400000 | - | D1 | - | OTHER REGULATORY | REG | R(SF).0451 | 12X36 | SUP2 | CITY POST EMBEDDED ACHOR CUP 4 | IS | 1660121460000 | 23RD AVE | 100 - 199 23RD AVE | - | - | - | CALIFORNIA ST | - |
| 51084 | N/A | Point | - | - | - | - | S284427 | 23RD AVE: CLEMENT ST | - | F | F | - | F | 27543000 | 27543000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CLEMENT ST | CLEMENT ST | 91935 | 91935 | 37.78212176 | -122.4827352 | 23RD AVE \ CLEMENT ST | 23RD AVE \ CLEMENT ST | 1749504300000 | middleware_editor | SLOW STREETS FAMILY, H/C, PED, SKATEBOARD, BIKE (SYM)(COMBO) | CLEMENT ST intersection | - | 9 FT AND 15 FT FROM CURB | - | - | - | - | - | 68187 | 1660201200000 | -122.4827352 | 37.78212176 | - | 1749500100000 | - | D1 | - | OTHER REGULATORY | REG | R(SF).0451 | 12X36 | SUP2 | CITY POST EMBEDDED ACHOR CUP 4 | IS | 1660121640000 | 23RD AVE | - | - | - | - | - | - |
| 51085 | N/A | Point | - | - | - | - | S269322 | EDDY ST: TAYLOR ST | - | F | F | - | F | 24925000 | 24925000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TAYLOR ST | EDDY ST | 91936 | 91936 | 37.78414101 | -122.41095162 | EDDY ST \ TAYLOR ST | TAYLOR ST \ EDDY ST | 1710539427000 | MTA | ROAD CLOSED | EDDY ST intersection | - | MIDDLE OF STREET | - | - | - | - | - | 68188 | 1571270400000 | -122.41095162 | 37.78414101 | - | 1603324800000 | - | D6 | - | OTHER REGULATORY | REG | R11-2.0001 | 48X30 | SUP1 | TYPE III BARRICADE | IS | 1603183380000 | TAYLOR ST | - | - | - | - | - | - |
| 51086 | N/A | Point | - | - | - | - | S269323 | EDDY ST: TAYLOR ST | - | F | F | - | F | 24925000 | 24925000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TAYLOR ST | EDDY ST | 91937 | 91937 | 37.78414101 | -122.41095162 | EDDY ST \ TAYLOR ST | TAYLOR ST \ EDDY ST | 1710539427000 | MTA | ROAD CLOSED | EDDY ST intersection | - | MIDDLE OF STREET | - | - | - | - | - | 68189 | 1571270400000 | -122.41095162 | 37.78414101 | - | 1603324800000 | - | D6 | - | OTHER REGULATORY | REG | R11-2.0001 | 48X30 | SUP1 | TYPE III BARRICADE | IS | 1603183440000 | TAYLOR ST | - | - | - | - | - | - |
| 51087 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S281980 | 2300-2399 41ST AVE | 2300-2399 41ST AVE | F | F | - | F | 1921000 | 1921000 | - | - | WEST SIDE | - | - | - | - | SANTIAGO ST | SANTIAGO ST | 92671 | 92671 | 37.7429433 | -122.49932766 | - | - | 1710539427000 | MTA | TA (SYM) NO STOPPING EXC PERMITTED CSV - TRUQIT CAR SHARE | SANTIAGO ST to TARAVAL ST (2300 - 2399) | - | 47' SOUTH OF SANTIAGO ST | - | - | - | - | - | 68190 | 1652140800000 | -122.49932766 | 37.7429433 | - | - | - | D4 | - | OTHER REGULATORY | REG | R37(SF).0435 | 05X12 | SUP2 | 2IN IRON POST | IS | 1648719000000 | 41ST AVE | 2300 - 2399 41ST AVE | 2300 - 2399 41ST AVE | 2300 41ST AVE | - | TARAVAL ST | TARAVAL ST |
| 51088 | N/A | Point | - | - | - | - | S281981 | LINCOLN WAY: LA PLAYA \ MARTIN | - | F | F | - | F | 8387201 | 27964000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | LA PLAYA \ MARTIN LUTHER KING JR DR | LA PLAYA \ MARTIN LUTHER KING JR DR | 92672 | 92672 | 37.7640508423785 | -122.509622912566 | - | LINCOLN WAY \ LA PLAYA \ MARTIN LUTHER KING JR DR | 1738341710000 | middleware_editor | EXC BICYCLES | LA PLAYA \ MARTIN LUTHER KING JR DR intersection | - | ABOVE STOP SIGN | - | - | - | - | - | 68191 | 1649980800000 | -122.50940219 | 37.76403274 | - | - | - | D4 | - | OTHER REGULATORY | REG | R(SF).0057 | 18X12 | SUP2 | 2IN IRON POST | IS | 1648724880000 | LINCOLN WAY | 4800 - 4898 LINCOLN WAY | - | - | - | GREAT HWY | - |
| 51089 | N/A | Point | - | - | - | - | S271662 | LINCOLN WAY: 48TH AVE | - | F | F | - | F | 27957000 | 27957000 | - | - | SOUTH EAST CORNER | - | - | - | - | LINCOLN WAY | 48TH AVE | 92673 | 92673 | 37.7639965768615 | -122.508224397893 | 48TH AVE \ LINCOLN WAY | LINCOLN WAY \ 48TH AVE | 1750780852000 | middleware_editor | 48TH AVE | 48TH AVE intersection | - | SEC 1200>S | - | - | - | - | - | 68192 | - | -122.50833137 | 37.76407602 | - | - | - | D4 | - | STREET NAME | GUIDE | D3-1.0038 | 36X08 | SUP2 | 3IN IRON POST | IS | 1611141060000 | LINCOLN WAY | - | - | - | - | - | - |
| 51090 | N/A | Point | 1 | 1 | 1 - 99 | - | S271719 | 1-99 KITTREDGE TER | 1-99 KITTREDGE TER | F | F | - | F | 7904000 | 7904000 | - | - | EAST SIDE | - | - | - | - | TURK BLVD | TURK BLVD | 92676 | 92676 | 37.77768461 | -122.4505565 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM FRI STCL | TURK BLVD to GOLDEN GATE AVE (1 - 99) | - | NPL #52 | - | - | - | - | - | 68193 | 1471305600000 | -122.4505565 | 37.77768461 | - | 1613952000000 | - | D1 | - | STREET CLEANING | REG | R30B(CA).0298 | 18X18 | SUP2 | 2 POST ALUMINUM | IS | 1611222660000 | KITTREDGE TER | 1 - 99 KITTREDGE TER | 1 - 99 KITTREDGE TER | 1 KITTREDGE TER | - | GOLDEN GATE AVE | GOLDEN GATE AVE |
| 51091 | N/A | Point | - | - | - | - | S271814 | HARRISON ST: 18TH ST | - | F | F | - | F | 24040000 | 24040000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 18TH ST | 18TH ST | 92677 | 92677 | 37.76159849 | -122.41277977 | HARRISON ST \ 18TH ST | HARRISON ST \ 18TH ST | 1739551733000 | middleware_editor | STOP | 18TH ST intersection | - | - | - | - | - | - | - | 68194 | 1423094400000 | -122.41277977 | 37.76159849 | - | 1614124800000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1611573360000 | HARRISON ST | - | - | - | - | - | - |
| 51092 | N/A | Point | - | - | - | - | S271815 | HARRISON ST: 18TH ST | - | F | F | - | F | 24040000 | 24040000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 18TH ST | 18TH ST | 92678 | 92678 | 37.76159849 | -122.41277977 | HARRISON ST \ 18TH ST | HARRISON ST \ 18TH ST | 1739551741000 | middleware_editor | ALL WAY | 18TH ST intersection | - | - | - | - | - | - | - | 68195 | 1423094400000 | -122.41277977 | 37.76159849 | - | 1614124800000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1611573540000 | HARRISON ST | - | - | - | - | - | - |
| 51093 | N/A | Point | 1 | 1 | 2500 - 2599 | - | S271076 | 2500-2599 KIRKHAM ST | 2500-2599 KIRKHAM ST | F | F | - | F | 7867000 | 7867000 | - | - | NORTH SIDE | - | - | - | - | 29TH AVE | 29TH AVE | 92680 | 92680 | 37.75933585 | -122.48811377 | - | - | 1721711409000 | middleware_editor | BIKE RACK | 29TH AVE to 30TH AVE (2500 - 2599) | - | 73' E OF 30TH/3' IN FROM CURB | - | - | - | - | - | 68196 | 1609251780000 | -122.48811377 | 37.75933585 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1609154640000 | KIRKHAM ST | 2500 - 2599 KIRKHAM ST | 2500 - 2599 KIRKHAM ST | 2500 KIRKHAM ST | - | 30TH AVE | 30TH AVE |
| 51094 | N/A | Point | 1 | 1 | 2600 - 2699 | - | S271077 | 2600-2699 KIRKHAM ST | 2600-2699 KIRKHAM ST | F | F | - | F | 7868000 | 7868000 | - | - | SOUTH SIDE | - | - | - | - | 30TH AVE | 30TH AVE | 92681 | 92681 | 37.75928857 | -122.48918509 | - | - | 1710539427000 | MTA | BIKE RACK | 30TH AVE to 31ST AVE (2600 - 2699) | - | 100' E OF 31ST/3.5' IN FROM CURB | - | - | - | - | - | 68197 | 1609251840000 | -122.48918509 | 37.75928857 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1609154880000 | KIRKHAM ST | 2600 - 2699 KIRKHAM ST | 2600 - 2699 KIRKHAM ST | 2600 KIRKHAM ST | - | 31ST AVE | 31ST AVE |
| 51095 | N/A | Point | 1 | 1 | 2800 - 2899 | - | S271078 | 2800-2899 KIRKHAM ST | 2800-2899 KIRKHAM ST | F | F | - | F | 7870000 | 7870000 | - | - | SOUTH SIDE | - | - | - | - | 32ND AVE | 32ND AVE | 92682 | 92682 | 37.75919385 | -122.49133068 | - | - | 1711741275000 | middleware_editor | BIKE RACK | 32ND AVE to 33RD AVE (2800 - 2899) | - | 91' W OF 32ND/2.5' IN FROM CURB | - | - | - | - | - | 68198 | 1609340280000 | -122.49133068 | 37.75919385 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1609155120000 | KIRKHAM ST | 2800 - 2899 KIRKHAM ST | 2800 - 2899 KIRKHAM ST | 2800 KIRKHAM ST | - | 33RD AVE | 33RD AVE |
| 51096 | N/A | Point | 1 | 1 | 2800 - 2899 | - | S271079 | 2800-2899 KIRKHAM ST | 2800-2899 KIRKHAM ST | F | F | - | F | 7870000 | 7870000 | - | - | NORTH SIDE | - | - | - | - | 32ND AVE | 32ND AVE | 92683 | 92683 | 37.75919385 | -122.49133068 | - | - | 1711768446000 | middleware_editor | BIKE RACK | 32ND AVE to 33RD AVE (2800 - 2899) | - | 30' E OF 33RD/ 3.5' IN FROM CURB | - | - | - | - | - | 68199 | 1609256220000 | -122.49133068 | 37.75919385 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1609160160000 | KIRKHAM ST | 2800 - 2899 KIRKHAM ST | 2800 - 2899 KIRKHAM ST | 2800 KIRKHAM ST | - | 33RD AVE | 33RD AVE |
| 51097 | N/A | Point | 1 | 1 | 3200 - 3249 | - | S271084 | 3200-3249 KIRKHAM ST | 3200-3249 KIRKHAM ST | F | F | - | F | 7875000 | 7875000 | - | - | SOUTH SIDE | - | - | - | - | 36TH AVE | 36TH AVE | 92684 | 92684 | 37.75901632 | -122.49534981 | - | - | 1740162598000 | middleware_editor | BIKE RACK | 36TH AVE to SUNSET BLVD (3200 - 3249) | - | 50' W OF 36TH/3' IN FROM CURB | - | - | - | - | - | 68200 | 1609233480000 | -122.49534981 | 37.75901632 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1609161780000 | KIRKHAM ST | 3200 - 3249 KIRKHAM ST | 3200 - 3249 KIRKHAM ST | 3200 KIRKHAM ST | - | SUNSET BLVD | SUNSET BLVD |
| 51098 | N/A | Point | 1 | 1 | 3250 - 3299 | - | S271087 | 3250-3299 KIRKHAM ST | 3250-3299 KIRKHAM ST | F | F | - | F | 7876000 | 7876000 | - | - | NORTH SIDE | - | - | - | - | SUNSET BLVD | SUNSET BLVD | 92685 | 92685 | 37.75899281 | -122.49588485 | - | - | 1740161422000 | middleware_editor | BIKE RACK | SUNSET BLVD to 37TH AVE (3250 - 3299) | - | 38' E OF 37TH AVE/3' IN FROM CURB | - | - | - | - | - | 68201 | 1609235220000 | -122.49588485 | 37.75899281 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1609166580000 | KIRKHAM ST | 3250 - 3299 KIRKHAM ST | 3250 - 3299 KIRKHAM ST | 3250 KIRKHAM ST | - | 37TH AVE | 37TH AVE |
| 51099 | N/A | Point | - | - | - | - | S272300 | JONES ST: STEVELOE PL | - | F | F | - | F | 24927000 | 24927000 | - | - | EAST SIDE | - | - | - | - | STEVELOE PL | STEVELOE PL | 92686 | 92686 | 37.78535382 | -122.41288124 | JONES ST \ STEVELOE PL | JONES ST \ STEVELOE PL | 1729606164000 | middleware_editor | NPRK 6AM-8AM EVERYDAY INCL HOLIDAY STCL | STEVELOE PL intersection | - | 40' SOUTH OF OFARRELL ST | - | - | - | - | - | 68202 | 1413331200000 | -122.41288124 | 37.78535382 | - | 1632355200000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0183 | 18X18 | SUP1 | 2IN IRON POST | IS | 1612947420000 | JONES ST | - | - | - | - | - | - |
| 51100 | N/A | Point | 1 | 1 | 200 - 299 | - | S272307 | 200-299 JONES ST | 200-299 JONES ST | F | F | - | F | 7565000 | 7565000 | - | - | EAST SIDE | - | - | - | - | TURK ST | TURK ST | 92687 | 92687 | 37.78346833 | -122.41250351 | - | - | 1727918924000 | middleware_editor | NPRK 6AM-8AM EVERYDAY INCL HOLIDAY STCL | TURK ST to EDDY ST (200 - 299) | - | 150 SOUTH OF EDDY | - | - | - | - | - | 68203 | 1632404460000 | -122.41250351 | 37.78346833 | - | - | - | D6 | - | STREET CLEANING | REG | R30B(CA).0183 | 18X18 | SUP1 | 2IN IRON POST | IS | 1612949040000 | JONES ST | 200 - 299 JONES ST | 200 - 299 JONES ST | 200 JONES ST | - | EDDY ST | EDDY ST |
| 51101 | N/A | Point | 1 | 1 | 500 - 551 | - | S258758 | 500-551 NOE ST | 500-551 NOE ST | F | F | - | F | 9616000 | 9615000 | - | - | WEST SIDE | - | - | - | - | HANCOCK ST | 18TH ST | 92705 | 92705 | 37.7596982544329 | -122.432746434206 | - | - | 1754067375000 | middleware_editor | NPRK 9AM-11AM FRI STCL | 18TH ST to HANCOCK ST (500 - 551) | - | #578 SPL | - | - | - | - | - | 68204 | 1420444800000 | -122.43275463 | 37.76062244 | - | 1753983900000 | - | D8 | - | STREET CLEANING | REG | R30B(CA).0298 | 18X18 | SUP2 | 2IN IRON POST | IS | 1572343560000 | NOE ST | 546 - 599 NOE ST | 500 - 551 NOE ST | 500 NOE ST | - | 19TH ST | HANCOCK ST |
| 51102 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S272242 | 1600-1699 PALOU AVE | 1600-1699 PALOU AVE | F | F | - | F | 10223000 | 10223000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 3RD ST \ MENDELL ST | 03RD ST \ MENDELL ST | 93127 | 93127 | 37.73452599 | -122.39187191 | - | - | 1710539427000 | MTA | BIKE WAYFINDING SIGN | 03RD ST \ MENDELL ST to NEWHALL ST (1600 - 1699) | 1129 | IFO 1621 | - | - | - | - | - | 68205 | 1612780500000 | -122.39187191 | 37.73452599 | - | - | - | D10 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | MUNI POLE | IS | 1612534500000 | PALOU AVE | 1600 - 1699 PALOU AVE | 1600 - 1699 PALOU AVE | 1600 PALOU AVE | - | NEWHALL ST | NEWHALL ST |
| 51103 | N/A | Point | - | - | - | - | S272246 | PALOU AVE: LANE ST | - | F | F | - | F | 20210000 | 20210000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | PALOU AVE | PALOU AVE | 93128 | 93128 | 37.7329189 | -122.38903507 | LANE ST \ PALOU AVE | LANE ST \ PALOU AVE | 1710539427000 | MTA | BIKE WAYFINDING SIGN | PALOU AVE intersection | 1130 | ABOVE STOP | - | - | - | - | - | 68206 | 1612775340000 | -122.38903507 | 37.7329189 | - | - | - | D10 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | LIGHT POLE | IS | 1612535580000 | LANE ST | - | - | - | - | - | - |
| 51104 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S272248 | 1400-1499 PALOU AVE | 1400-1499 PALOU AVE | F | F | - | F | 10221000 | 10221000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | KEITH ST | KEITH ST | 93129 | 93129 | 37.73238819 | -122.38810079 | - | - | 1710539427000 | MTA | BIKE WAYFINDING SIGN | KEITH ST to LANE ST (1400 - 1499) | 1131 | WPL 1470 | - | - | - | - | - | 68207 | 1612776600000 | -122.38810079 | 37.73238819 | - | - | - | D10 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP1 | LIGHT POLE | IS | 1612537260000 | PALOU AVE | 1400 - 1499 PALOU AVE | 1400 - 1499 PALOU AVE | 1400 PALOU AVE | - | LANE ST | LANE ST |
| 51105 | N/A | Point | - | - | - | - | S272249 | LANE ST: REVERE AVE | - | F | F | - | F | 20499000 | 20499000 | - | - | NORTH WEST CORNER | - | - | - | - | LANE ST | LANE ST | 93130 | 93130 | 37.73166294 | -122.3901644 | REVERE AVE \ LANE ST | REVERE AVE \ LANE ST | 1710539427000 | MTA | (RA) WHITE ON GREEN | LANE ST intersection | 1132 | ABOVE STOP | - | - | - | - | - | 68208 | 1612775280000 | -122.3901644 | 37.73166294 | - | - | - | D10 | - | OTHER GUIDE | GUIDE | M7-1.0001 | 12X09 | SUP1 | 2IN IRON POST | IS | 1612537560000 | REVERE AVE | - | - | - | - | - | - |
| 51106 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S272670 | 2300-2399 24TH AVE | 2300-2399 24TH AVE | F | F | - | F | 1309000 | 1309000 | - | - | WEST SIDE | - | - | - | - | SANTIAGO ST | SANTIAGO ST | 93131 | 93131 | 37.7437478 | -122.48111538 | - | - | 1719943661000 | middleware_editor | RESTRICTED AREA AUTHORIZED PERSONNEL ONLY | SANTIAGO ST to TARAVAL ST (2300 - 2399) | - | POLICE STATION | - | - | - | - | - | 68209 | 1228867200000 | -122.48111538 | 37.7437478 | - | 1614556800000 | - | D4 | - | OTHER REGULATORY | REG | R(SF).0197 | 30X24 | SUP2 | RETAINING WALL | IS | 1614330420000 | 24TH AVE | 2300 - 2399 24TH AVE | 2300 - 2399 24TH AVE | 2300 24TH AVE | - | TARAVAL ST | TARAVAL ST |
| 51107 | N/A | Point | - | - | - | - | S283225 | CLEMENT ST: 3RD AVE | - | F | F | - | F | 27247000 | 27247000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 3RD AVE | CLEMENT ST | 93132 | 93132 | 37.78308744 | -122.46120748 | CLEMENT ST \ 3RD AVE | 03RD AVE \ CLEMENT ST | 1739479399000 | middleware_editor | STOP | CLEMENT ST intersection | - | - | - | - | - | - | - | 68210 | 1655942400000 | -122.46120748 | 37.78308744 | - | 1739448960000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1654511760000 | 03RD AVE | - | - | - | - | - | - |
| 51108 | N/A | Point | - | - | - | - | S283226 | CLEMENT ST: 3RD AVE | - | F | F | - | F | 27247000 | 27247000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 3RD AVE | CLEMENT ST | 93133 | 93133 | 37.78308744 | -122.46120748 | CLEMENT ST \ 3RD AVE | 03RD AVE \ CLEMENT ST | 1710539427000 | MTA | ALL WAY | CLEMENT ST intersection | - | - | - | - | - | - | - | 68211 | 1655942400000 | -122.46120748 | 37.78308744 | - | - | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1654511820000 | 03RD AVE | - | - | - | - | - | - |
| 51109 | N/A | Point | - | - | - | - | S283227 | CLEMENT ST: 3RD AVE | - | F | F | - | F | 27247000 | 27247000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 3RD AVE | CLEMENT ST | 93134 | 93134 | 37.78308744 | -122.46120748 | CLEMENT ST \ 3RD AVE | 03RD AVE \ CLEMENT ST | 1739479359000 | middleware_editor | STOP | CLEMENT ST intersection | - | - | - | - | - | - | - | 68212 | 1655942400000 | -122.46120748 | 37.78308744 | - | 1739449080000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1654512120000 | 03RD AVE | - | - | - | - | - | - |
| 51110 | N/A | Point | - | - | - | - | S283228 | CLEMENT ST: 3RD AVE | - | F | F | - | F | 27247000 | 27247000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 3RD AVE | CLEMENT ST | 93135 | 93135 | 37.78308744 | -122.46120748 | CLEMENT ST \ 3RD AVE | 03RD AVE \ CLEMENT ST | 1710539427000 | MTA | ALL WAY | CLEMENT ST intersection | - | - | - | - | - | - | - | 68213 | 1655942400000 | -122.46120748 | 37.78308744 | - | - | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1654512180000 | 03RD AVE | - | - | - | - | - | - |
| 51111 | N/A | Point | - | - | - | - | S283232 | JOHN F KENNEDY DR: CONSERVATOR | - | F | F | - | F | 27187000 | 27187000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CONSERVATORY DR | CONSERVATORY DR | 93136 | 93136 | 37.77177649 | -122.46204713 | JOHN F KENNEDY DR \ CONSERVATORY DR | JOHN F KENNEDY DR \ CONSERVATORY DR | 1710539427000 | MTA | ALL WAY | CONSERVATORY DR intersection | - | X IS CONSERVATORY DR WEST | - | - | - | - | - | 68214 | - | -122.46204713 | 37.77177649 | - | 1655769600000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1654514340000 | JOHN F KENNEDY DR | - | - | - | - | - | - |
| 51112 | N/A | Point | - | - | - | - | S283233 | JOHN F KENNEDY DR: CONSERVATOR | - | F | F | - | F | 27187000 | 27187000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CONSERVATORY DR | CONSERVATORY DR | 93137 | 93137 | 37.77177649 | -122.46204713 | JOHN F KENNEDY DR \ CONSERVATORY DR | JOHN F KENNEDY DR \ CONSERVATORY DR | 1710539427000 | MTA | STOP | CONSERVATORY DR intersection | - | X IS CONSERVATORY DR WEST | - | - | - | - | - | 68215 | - | -122.46204713 | 37.77177649 | - | 1655769600000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1654514460000 | JOHN F KENNEDY DR | - | - | - | - | - | - |
| 51113 | N/A | Point | - | - | - | - | S269651 | SACRAMENTO ST: WAVERLY PL | - | F | F | - | F | 24988000 | 24988000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | WAVERLY PL | WAVERLY PL | 93139 | 93139 | 37.79331488 | -122.40664329 | SACRAMENTO ST \ WAVERLY PL | SACRAMENTO ST \ WAVERLY PL | 1710539427000 | MTA | PLAYGROUND (SYM) | WAVERLY PL intersection | - | - | - | - | - | - | - | 68216 | 1604309820000 | -122.40664329 | 37.79331488 | - | - | - | D3 | - | OTHER WARNING | WARNING | W15-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1603972260000 | SACRAMENTO ST | - | - | - | - | - | - |
| 51114 | N/A | Point | - | - | - | RIGHT ARROW | S269658 | ELLIS ST: FRANKLIN ST | - | F | F | - | F | 26489000 | 26489000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 93140 | 93140 | 37.7836191 | -122.42265254 | ELLIS ST \ FRANKLIN ST | ELLIS ST \ FRANKLIN ST | 1710539427000 | MTA | TA (SYM) PLO 7:30AM-3:30PM SCHOOL DAYS (5 MIN) | FRANKLIN ST intersection | - | - | - | - | - | - | - | 68217 | 1604661300000 | -122.42265254 | 37.7836191 | - | - | - | D5 | - | OTHER REGULATORY | REG | R38(SF)6.0089 | 14X21 | SUP1 | SIGNAL POLE | IS | 1603977960000 | ELLIS ST | - | - | - | - | - | - |
| 51115 | N/A | Point | - | - | - | - | S269659 | ELLIS ST: FRANKLIN ST | - | F | F | - | F | 26489000 | 26489000 | - | - | SOUTH SIDE | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 93141 | 93141 | 37.7836191 | -122.42265254 | ELLIS ST \ FRANKLIN ST | ELLIS ST \ FRANKLIN ST | 1710539427000 | MTA | TA (SYM) PLO 7:30AM-3:30PM SCHOOL DAYS (5 MIN) | FRANKLIN ST intersection | - | 73' W OF FRANKLIN | - | - | - | - | - | 68218 | 1604661420000 | -122.42265254 | 37.7836191 | - | - | - | D5 | - | OTHER REGULATORY | REG | R38(SF)6.0089 | 14X21 | SUP1 | 2IN IRON POST | IS | 1603978080000 | ELLIS ST | - | - | - | - | - | - |
| 51116 | N/A | Point | - | - | - | - | S282736 | WEBSTER ST: HERMANN ST | - | F | F | - | F | 25887000 | 25887000 | - | - | EAST SIDE | - | - | - | - | WEBSTER ST | WEBSTER ST | 93145 | 93145 | 37.77045176 | -122.42842618 | HERMANN ST \ WEBSTER ST | HERMANN ST \ WEBSTER ST | 1710539427000 | MTA | TANP ANY TIME | WEBSTER ST intersection | - | 200'SOUTH OF HERMANN ST | - | - | - | - | - | 68219 | - | -122.42842618 | 37.77045176 | - | - | - | D5 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP1 | 2IN IRON POST | IS | 1652181060000 | HERMANN ST | - | - | - | - | - | - |
| 51117 | N/A | Point | - | - | - | - | S258754 | LAGUNA ST: IVY ST | - | F | F | - | F | 25935000 | 25935000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | IVY ST | LAGUNA ST | 93618 | 93618 | 37.77693018 | -122.42635904 | LAGUNA ST \ IVY ST | IVY ST \ LAGUNA ST | 1710539427000 | MTA | (45 LA-DN) | LAGUNA ST intersection | - | 7' S OF IVY | - | - | - | - | - | 68220 | 1572437340000 | -122.42635904 | 37.77693018 | - | - | - | D5 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP1 | LIGHT POLE | IS | 1572343080000 | IVY ST | - | - | - | - | - | - |
| 51118 | N/A | Point | - | - | - | - | S258755 | LAGUNA ST: IVY ST | - | F | F | - | F | 25935000 | 25935000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | IVY ST | LAGUNA ST | 93619 | 93619 | 37.77693018 | -122.42635904 | LAGUNA ST \ IVY ST | IVY ST \ LAGUNA ST | 1710539427000 | MTA | PEDESTRIAN (SYM) | LAGUNA ST intersection | - | 10' N OF IVY | - | - | - | - | - | 68221 | 1572442020000 | -122.42635904 | 37.77693018 | - | - | - | D5 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | 2IN IRON POST | IS | 1572343260000 | IVY ST | - | - | - | - | - | - |
| 51119 | N/A | Point | - | - | - | - | S258757 | LAGUNA ST: IVY ST | - | F | F | - | F | 25935000 | 25935000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | IVY ST | LAGUNA ST | 93620 | 93620 | 37.77693018 | -122.42635904 | LAGUNA ST \ IVY ST | IVY ST \ LAGUNA ST | 1710539427000 | MTA | (45 LA-DN) | LAGUNA ST intersection | - | 10' N OF IVY | - | - | - | - | - | 68222 | 1572442200000 | -122.42635904 | 37.77693018 | - | - | - | D5 | - | OTHER WARNING | WARNING | W16-7P.0004 | 24X12 | SUP1 | 2IN IRON POST | IS | 1572343320000 | IVY ST | - | - | - | - | - | - |
| 51120 | N/A | Point | 1 | 1 | 3300 - 3349 | - | S258842 | 3300-3349 20TH ST | 3300-3349 20TH ST | F | F | - | F | 1052000 | 1052000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | FOLSOM ST | FOLSOM ST | 93622 | 93622 | 37.75886311 | -122.41523467 | - | - | 1710539427000 | MTA | SCHOOL (SYM) AHEAD | FOLSOM ST to SHOTWELL ST (3300 - 3349) | - | WPL 3333 | - | - | - | - | - | 68223 | 947289600000 | -122.41523467 | 37.75886311 | - | 1572825600000 | - | D9 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1572431400000 | 20TH ST | 3300 - 3349 20TH ST | 3300 - 3349 20TH ST | 3300 20TH ST | - | SHOTWELL ST | SHOTWELL ST |
| 51121 | N/A | Point | - | - | - | - | S267573 | FOLSOM ST: SPEAR ST | - | T | T | - | F | 23607000 | 23607000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SPEAR ST | FOLSOM ST | 93728 | 93728 | 37.7900698 | -122.39097102 | FOLSOM ST \ SPEAR ST | SPEAR ST \ FOLSOM ST | 1710539427000 | MTA | EXCEPT BIKE (SYM) | FOLSOM ST intersection | - | BELOW NO RIGHT TURN ELECTRONIC SIGN | - | - | - | - | - | 68224 | 1610635500000 | -122.39097102 | 37.7900698 | - | - | - | D6 | - | OTHER REGULATORY | REG | R(SF).0362 | 24X18 | SUP1 | OVERHEAD MAST ARM | IS | 1598442120000 | SPEAR ST | - | - | - | - | - | - |
| 51122 | N/A | Point | 1 | 1 | 300 - 351 | - | S268116 | 300-351 FOLSOM ST | 300-351 FOLSOM ST | F | F | - | F | 5653000 | 5653000 | - | - | SOUTH SIDE | - | - | - | - | BEALE ST | BEALE ST | 93729 | 93729 | 37.78845656 | -122.39301426 | - | - | 1715288967000 | middleware_editor | FG 300 UR DELINEATOR (W) | BEALE ST to ZENO PL (300 - 351) | - | START 25' WEST OF BEALE ST | - | - | - | - | - | 68225 | 1607424360000 | -122.39301426 | 37.78845656 | - | 1629158400000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1600270500000 | FOLSOM ST | 300 - 351 FOLSOM ST | 300 - 351 FOLSOM ST | 300 FOLSOM ST | - | ZENO PL | ZENO PL |
| 51123 | N/A | Point | - | - | - | - | S272219 | 15TH AVE: ALOHA AVE | - | F | F | - | F | 27164000 | 27164000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | ALOHA AVE | ALOHA AVE | 93731 | 93731 | 37.75816378 | -122.47157442 | 15TH AVE \ ALOHA AVE | 15TH AVE \ ALOHA AVE | 1710539427000 | MTA | KEEP RIGHT (SYM) | ALOHA AVE intersection | - | IFO 1607 | - | - | - | - | - | 68226 | 208483200000 | -122.47157442 | 37.75816378 | - | 1621296000000 | - | D7 | - | OTHER REGULATORY | REG | R4-7A.0001 | 18X24 | SUP2 | 2IN IRON POST | IS | 1612522260000 | 15TH AVE | - | - | - | - | - | - |
| 51124 | N/A | Point | 1 | 1 | 564 - 698 | - | S272220 | PNDG ORTEGA ST | 564-698 ORTEGA ST | F | F | - | F | 10000102 | 10000102 | - | - | NORTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SELMA WAY | SELMA WAY | 93732 | 93732 | 37.75473706 | -122.47010592 | - | - | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | SELMA WAY to 14TH AVE (564 - 698) -- NORTH -- | - | WPL 650 | - | - | - | - | - | 68227 | 1614773700000 | -122.47010592 | 37.75473706 | - | - | - | D7 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | 2IN IRON POST | IS | 1612522980000 | ORTEGA ST | PNDG ORTEGA ST | 564 - 698 ORTEGA ST | - | - | 14TH AVE | 14TH AVE |
| 51125 | N/A | Point | 1 | 1 | 564 - 698 | - | S272221 | PNDG ORTEGA ST | 564-698 ORTEGA ST | F | F | - | F | 10000102 | 10000102 | - | - | NORTH SIDE | - | - | - | - | SELMA WAY | SELMA WAY | 93733 | 93733 | 37.75473706 | -122.47010592 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM 1ST & 3RD TUE OF MONTH STCL | SELMA WAY to 14TH AVE (564 - 698) -- NORTH -- | - | WPL 650 | - | - | - | - | - | 68228 | 1626686760000 | -122.47010592 | 37.75473706 | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0288 | 18X18 | SUP2 | 2IN IRON POST | IS | 1612523280000 | ORTEGA ST | PNDG ORTEGA ST | 564 - 698 ORTEGA ST | - | - | 14TH AVE | 14TH AVE |
| 51126 | N/A | Point | - | - | - | - | S272240 | SAN CARLOS ST: SYCAMORE ST | - | F | F | - | F | 24167000 | 24167000 | - | - | SOUTH EAST CORNER | - | - | - | - | SYCAMORE ST | SYCAMORE ST | 93734 | 93734 | 37.76266632 | -122.4202144 | SAN CARLOS ST \ SYCAMORE ST | SAN CARLOS ST \ SYCAMORE ST | 1717599256000 | middleware_editor | SAN CARLOS ST | SYCAMORE ST intersection | - | - | - | - | - | - | - | 68229 | 1014336000000 | -122.4202144 | 37.76266632 | - | 1618790400000 | - | D9 | - | STREET NAME | GUIDE | D3-1.1558 | 36X08 | SUP2 | 3IN IRON POST | IS | 1612531380000 | SAN CARLOS ST | - | - | - | - | - | - |
| 51127 | N/A | Point | - | - | - | - | S272241 | CLARION ALY: MISSION ST | - | F | F | - | F | 24164000 | 24164000 | - | - | EAST SIDE | - | - | - | - | CLARION ALY | CLARION ALY | 93735 | 93735 | 37.76305084 | -122.41947629 | MISSION ST \ CLARION ALY | MISSION ST \ CLARION ALY | 1717680900000 | middleware_editor | CLARION ALY | CLARION ALY intersection | - | X IS VALENCIA SPL 603 | - | - | - | - | - | 68230 | 185587200000 | -122.41947629 | 37.76305084 | - | 1485302400000 | - | D9 | - | STREET NAME | GUIDE | D3-1.0389 | 36X08 | SUP2 | 3IN IRON POST | IS | 1612532100000 | MISSION ST | - | - | - | - | - | - |
| 51128 | N/A | Point | - | - | - | - | S272368 | DIVISION ST: DE HARO ST | - | F | F | - | F | 23867000 | 23867000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | DE HARO ST | DIVISION ST | 93736 | 93736 | 37.76988504 | -122.40207313 | DIVISION ST \ DE HARO ST | DE HARO ST \ DIVISION ST | 1753724003000 | middleware_editor | (45 LA-UP) KING / DE HARO (RA) | DIVISION ST intersection | 120042728 | IFO # 11 / ABOVE STOP SIGN | - | - | - | - | - | 68231 | 1613666880000 | -122.40207313 | 37.76988504 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-2.0479 | 36X24 | SUP1 | 2IN IRON POST | IS | 1613038260000 | DE HARO ST | - | - | - | - | - | - |
| 51129 | N/A | Point | 1 | 1 | 432 - 467 | - | S272406 | 432-467 BERRY ST | 432-467 BERRY ST | F | F | - | F | 2956004 | 2956004 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | KING ST | KING ST | 93737 | 93737 | 37.771328 | -122.39899486 | - | - | 1753728910000 | middleware_editor | (90 RA) CURVE (SYM) | KING ST to BERRY EXTENSION ST (432 - 467) | - | 275FT NORTH OF MISSION BAY DR | - | - | - | - | - | 68232 | - | -122.39899486 | 37.771328 | - | - | - | D6 | - | OTHER WARNING | WARNING | W1-1.0005 | 30X30 | SUP1 | LIGHT POLE | IS | 1613470620000 | BERRY ST | 432 - 467 BERRY ST | 432 - 467 BERRY ST | 432 BERRY ST | - | BERRY EXTENSION ST | BERRY EXTENSION ST |
| 51130 | N/A | Point | - | - | - | - | S272466 | 47TH AVE: ULLOA ST | - | F | F | - | F | 23501000 | 23501000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 47TH AVE | 47TH AVE | 93738 | 93738 | 37.73985924 | -122.50555976 | ULLOA ST \ 47TH AVE | ULLOA ST \ 47TH AVE | 1710539427000 | MTA | ALL WAY | 47TH AVE intersection | - | - | - | - | - | - | - | 68233 | 218851200000 | -122.50555976 | 37.73985924 | - | 1614816000000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1613557200000 | ULLOA ST | - | - | - | - | - | - |
| 51131 | N/A | Point | - | - | - | - | S272467 | 47TH AVE: ULLOA ST | - | F | F | - | F | 23501000 | 23501000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 47TH AVE | 47TH AVE | 93739 | 93739 | 37.73985924 | -122.50555976 | ULLOA ST \ 47TH AVE | ULLOA ST \ 47TH AVE | 1710539427000 | MTA | ALL WAY | 47TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 68234 | 218851200000 | -122.50555976 | 37.73985924 | - | 1614816000000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1613557320000 | ULLOA ST | - | - | - | - | - | - |
| 51132 | N/A | Point | - | 1 | 90 - 198 | - | S283480 | 90-198 THE EMBARCADERO | 90-198 THE EMBARCADERO | F | F | - | F | 12553201 | 12553201 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | MISSION ST | MISSION ST | 93740 | 93740 | 37.79527839 | -122.39389252 | - | - | 1723669025000 | middleware_editor | WHEELCHAIR-PED YIELD (SYM) YIELD TO PEDESTRIANS | MISSION ST to WASHINGTON ST (90 - 198) -- EAST -- | - | LIGHT POLE 09 | - | - | - | - | - | 68235 | 1657843200000 | -122.39389252 | 37.79527839 | - | - | - | D3 | - | PEDESTRIAN | GUIDE | G-Y(SF).0002 | 24X24 | SUP1 | LIGHT POLE | IS | 1655296740000 | THE EMBARCADERO | 90 - 198 THE EMBARCADERO | 90 - 198 THE EMBARCADERO | 90 THE EMBARCADERO | - | WASHINGTON ST | WASHINGTON ST |
| 51133 | N/A | Point | 1 | 1 | 3300 - 3595 | - | S281490 | 3300-3595 FULTON ST | 3300-3595 FULTON ST | T | T | - | F | 5915000 | 5915000 | - | - | SOUTH SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 9TH AVE | 09TH AVE | 94307 | 94307 | 37.77332747 | -122.46748781 | - | - | 1710539427000 | MTA | FULTON ST | 09TH AVE to 10TH AVE (3300 - 3595) | 121531285 | 35 FEET EAST OF 10 TH AVE | - | - | - | - | - | 68236 | 1220572800000 | -122.46748781 | 37.77332747 | - | - | - | D1 | - | STREET NAME | GUIDE | D3-2.0164 | 72X18 | SUP2 | LIGHT POLE | IS | 1647260100000 | FULTON ST | 3300 - 3595 FULTON ST | 3300 - 3595 FULTON ST | 3300 FULTON ST | - | 10TH AVE | 10TH AVE |
| 51134 | N/A | Point | 1 | 1 | 3000 - 3099 | - | S281523 | 3000-3099 PIERCE ST | 3000-3099 PIERCE ST | F | F | - | F | 10443000 | 10443000 | - | - | WEST SIDE | - | - | - | - | FILBERT ST | FILBERT ST | 94308 | 94308 | 37.7977740755163 | -122.439074306653 | - | - | 1742832323000 | middleware_editor | 2 HR PRK 8AM-6PM MON-FRI EXC "K" PERMITS | FILBERT ST to GREENWICH ST (3000 - 3099) | - | 68 FEET NORTH OF FILBERT | - | - | - | - | - | 68237 | 1219734000000 | -122.43906208 | 37.79806794 | - | 1647414000000 | - | D2 | - | PARKING:RPP | REG | R32C(CA).0092 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1647354120000 | PIERCE ST | 3000 - 3099 PIERCE ST | 3000 - 3099 PIERCE ST | 3000 PIERCE ST | - | GREENWICH ST | GREENWICH ST |
| 51135 | N/A | Point | - | 1 | 1 - 99 | - | S281605 | 1-99 DANTON ST | 1-99 DANTON ST | F | F | - | F | 4578000 | 4578000 | - | - | EAST SIDE | - | - | - | - | CAYUGA AVE | CAYUGA AVE | 94309 | 94309 | 37.73117009 | -122.43239081 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM WED STCL | CAYUGA AVE to STILL ST (1 - 99) | - | SPL 61 | - | - | - | - | - | 68238 | 1647475200000 | -122.43239081 | 37.73117009 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0312 | 18X18 | SUP2 | 2IN IRON POST | IS | 1647510660000 | DANTON ST | 1 - 99 DANTON ST | 1 - 99 DANTON ST | 1 DANTON ST | - | STILL ST | STILL ST |
| 51136 | N/A | Point | - | 1 | 1 - 99 | - | S281606 | 1-99 DANTON ST | 1-99 DANTON ST | F | F | - | F | 4578000 | 4578000 | - | - | EAST SIDE | - | - | - | - | CAYUGA AVE | CAYUGA AVE | 94310 | 94310 | 37.73117009 | -122.43239081 | - | - | 1710539427000 | MTA | 4 HR PRK 9AM-5PM MON-FRI EXC "D" PERMITS | CAYUGA AVE to STILL ST (1 - 99) | - | SPL 61 | - | - | - | - | - | 68239 | 1647475200000 | -122.43239081 | 37.73117009 | - | 1647475200000 | - | D8 | - | PARKING:RPP | REG | R32C(CA).0201 | 18X21 | SUP2 | 2IN IRON POST | IS | 1647510720000 | DANTON ST | 1 - 99 DANTON ST | 1 - 99 DANTON ST | 1 DANTON ST | - | STILL ST | STILL ST |
| 51137 | N/A | Point | 1 | 1 | 400 - 499 | - | S281670 | 400-499 BALBOA ST | 400-499 BALBOA ST | F | F | - | F | 2649000 | 2649000 | - | - | NORTH SIDE | - | - | - | - | 5TH AVE | 05TH AVE | 94311 | 94311 | 37.77725876 | -122.4634757 | - | - | 1718328167000 | middleware_editor | BIKE RACK | 05TH AVE to 06TH AVE (400 - 499) | 512931 | 6'E OF EPL 402/3.5' IN FROM CURB | - | - | - | - | - | 68240 | 1647993600000 | -122.4634757 | 37.77725876 | - | - | - | D1 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1647604920000 | BALBOA ST | 400 - 499 BALBOA ST | 400 - 499 BALBOA ST | 400 BALBOA ST | - | 06TH AVE | 06TH AVE |
| 51138 | N/A | Point | 1 | 1 | 1 - 99 | - | S266898 | 1-99 HOFFMAN AVE | 1-99 HOFFMAN AVE | F | F | - | F | 6937000 | 6937000 | - | - | EAST SIDE | - | - | - | - | 22ND ST | 22ND ST | 94313 | 94313 | 37.75370285 | -122.4408917 | - | - | 1755180247000 | middleware_editor | NPRK 12NN-2PM 2ND & 4TH WED OF MONTH STCL | 22ND ST to ALVARADO ST (1 - 99) | - | 10 FT N OF 22ND ST | - | - | - | - | - | 68241 | 1222239600000 | -122.4408917 | 37.75370285 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0075 | 18X18 | SUP2 | 2IN IRON POST | IS | 1596629340000 | HOFFMAN AVE | 1 - 99 HOFFMAN AVE | 1 - 99 HOFFMAN AVE | 1 HOFFMAN AVE | - | ALVARADO ST | ALVARADO ST |
| 51139 | N/A | Point | 1 | 1 | 700 - 748 | - | S266914 | 700-748 PACIFIC AVE | 700-748 PACIFIC AVE | F | F | - | F | 10127000 | 10127000 | - | - | NORTH SIDE | - | - | - | - | GRANT AVE | GRANT AVE | 94314 | 94314 | 37.79685299 | -122.40722374 | - | - | 1710539427000 | MTA | TANS 4PM-6PM EXC SAT & SUN | GRANT AVE to PELTON PL (700 - 748) | - | 50' W OF GRANT | - | - | - | - | - | 68242 | 1597308060000 | -122.40722374 | 37.79685299 | - | - | - | D3 | - | OTHER REGULATORY | REG | R37(CA).0026 | 18X21 | SUP1 | LIGHT POLE | IS | 1596709020000 | PACIFIC AVE | 700 - 748 PACIFIC AVE | 700 - 748 PACIFIC AVE | 700 PACIFIC AVE | - | PELTON PL | PELTON PL |
| 51140 | N/A | Point | 1 | 1 | 600 - 699 | - | S266918 | 600-699 FRONT ST | 600-699 FRONT ST | F | F | - | F | 5872000 | 5872000 | - | - | WEST SIDE | - | - | - | - | JACKSON ST | JACKSON ST | 94315 | 94315 | 37.79736653 | -122.39959658 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM MON WED FRI STCL | JACKSON ST to PACIFIC AVE (600 - 699) | - | 25' N OF JACKSON | - | - | - | - | - | 68243 | - | -122.39959658 | 37.79736653 | - | - | - | D3 | - | STREET CLEANING | REG | R30B(CA).0123 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1596715560000 | FRONT ST | 600 - 699 FRONT ST | 600 - 699 FRONT ST | 600 FRONT ST | - | PACIFIC AVE | PACIFIC AVE |
| 51141 | N/A | Point | 1 | 1 | 534 - 599 | - | S266920 | 534-599 WASHINGTON ST | 534-599 WASHINGTON ST | F | F | - | F | 13409000 | 13409000 | - | - | NORTH SIDE | - | - | - | - | HOTALING PL | HOTALING PL | 94316 | 94316 | 37.79556468 | -122.40302956 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM MON WED FRI STCL | HOTALING PL to COLUMBUS AVE \ MONTGOMERY ST (534 - 599) | - | 58' W OF HOTALING PL | - | - | - | - | - | 68244 | 1597227660000 | -122.40302956 | 37.79556468 | - | - | - | D3 | - | STREET CLEANING | REG | R30B(CA).0123 | 18X18 | SUP1 | 2IN IRON POST | IS | 1596716820000 | WASHINGTON ST | 534 - 599 WASHINGTON ST | 534 - 599 WASHINGTON ST | 534 WASHINGTON ST | - | COLUMBUS AVE \ MONTGOMERY ST | COLUMBUS AVE \ MONTGOMERY ST |
| 51142 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S266924 | 1200-1299 PINE ST | 1200-1299 PINE ST | F | F | - | F | 10474000 | 10474000 | - | - | NORTH SIDE | - | - | - | - | LEAVENWORTH ST | LEAVENWORTH ST | 94317 | 94317 | 37.79014972 | -122.41638194 | - | - | 1710539427000 | MTA | NPRK 6AM-8AM FRI STCL | LEAVENWORTH ST to HYDE ST (1200 - 1299) | - | IFO # 264 PINE | - | - | - | - | - | 68245 | 1597654440000 | -122.41638194 | 37.79014972 | - | - | - | D3 | - | STREET CLEANING | REG | R30B(CA).0184 | 18X18 | SUP1 | 2IN IRON POST | IS | 1596719880000 | PINE ST | 1200 - 1299 PINE ST | 1200 - 1299 PINE ST | 1200 PINE ST | - | HYDE ST | HYDE ST |
| 51143 | N/A | Point | - | - | - | - | S266976 | JUNIPERO SERRA BLVD: 19TH AVE | - | T | T | - | F | 22556000 | 22556000 | - | - | SOUTH WEST CORNER | - | - | - | - | 19TH AVE | 19TH AVE | 94318 | 94318 | 37.71717387 | -122.47257245 | JUNIPERO SERRA BLVD \ 19TH AVE | JUNIPERO SERRA BLVD \ 19TH AVE | 1713315726000 | middleware_editor | 19TH AVE | 19TH AVE intersection | - | - | - | - | - | - | - | 68246 | - | -122.47257245 | 37.71717387 | - | - | - | D11 | - | STREET NAME | GUIDE | D3-2.0018 | 72X18 | SUP2 | SIGNAL POLE | IS | 1597047300000 | JUNIPERO SERRA BLVD | - | - | - | - | - | - |
| 51144 | N/A | Point | - | - | - | - | S266977 | VIDAL DR: HIGUERA AVE | - | F | F | - | F | 23108000 | 23108000 | - | - | SOUTH WEST CORNER | - | - | - | - | HIGUERA AVE | VIDAL DR | 94319 | 94319 | 37.71832261 | -122.48478112 | VIDAL DR \ HIGUERA AVE | HIGUERA AVE \ VIDAL DR | 1710539427000 | MTA | TANSAT | VIDAL DR intersection | - | - | - | - | - | - | - | 68247 | 1225411200000 | -122.48478112 | 37.71832261 | - | 1655856000000 | - | D7 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | LIGHT POLE | IS | 1597050900000 | HIGUERA AVE | - | - | - | - | - | - |
| 51145 | N/A | Point | 1 | 1 | 131 - 199 | - | S266985 | 131-199 CAMBRIDGE ST | 131-199 CAMBRIDGE ST | F | F | - | F | 3620000 | 3620000 | - | - | WEST SIDE | - | - | - | - | SWEENY ST | SWEENY ST | 94323 | 94323 | 37.72973439 | -122.41945827 | - | - | 1718068699000 | middleware_editor | NPRK 10AM-12NN WED STCL | SWEENY ST to SILVER AVE (131 - 199) | - | SPL 180 | - | - | - | - | - | 68248 | 1598623800000 | -122.41945827 | 37.72973439 | - | - | - | D9 | - | STREET CLEANING | REG | R30B(CA).0014 | 18X18 | SUP2 | 2IN IRON POST | IS | 1597064280000 | CAMBRIDGE ST | 131 - 199 CAMBRIDGE ST | 131 - 199 CAMBRIDGE ST | 131 CAMBRIDGE ST | - | SILVER AVE | SILVER AVE |
| 51146 | N/A | Point | 1 | 1 | 3600 - 3699 | - | S282174 | 3600-3699 BUCHANAN ST | 3600-3699 BUCHANAN ST | F | F | - | F | 3356000 | 3356000 | - | - | WEST SIDE | - | - | - | - | BAY ST | BAY ST | 95009 | 95009 | 37.80354517 | -122.43342633 | - | - | 1710539427000 | MTA | NPRK 6AM-8AM MON WED FRI STCL | BAY ST to NORTH POINT ST (3600 - 3699) | - | SPL # 3643 BUCHANAN | - | - | - | - | - | 68249 | - | -122.43342633 | 37.80354517 | - | 1651104000000 | - | D2 | - | STREET CLEANING | REG | R30B(CA).0192 | 18X18 | SUP1 | LIGHT POLE | IS | 1649769120000 | BUCHANAN ST | 3600 - 3699 BUCHANAN ST | 3600 - 3699 BUCHANAN ST | 3600 BUCHANAN ST | - | NORTH POINT ST | NORTH POINT ST |
| 51147 | N/A | Point | 1 | 1 | 3600 - 3699 | - | S282175 | 3600-3699 BUCHANAN ST | 3600-3699 BUCHANAN ST | F | F | - | F | 3356000 | 3356000 | - | - | WEST SIDE | - | - | - | - | BAY ST | BAY ST | 95010 | 95010 | 37.80354517 | -122.43342633 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "M" PERMITS | BAY ST to NORTH POINT ST (3600 - 3699) | - | SPL # 3643 BUCHANAN | - | - | - | - | - | 68250 | - | -122.43342633 | 37.80354517 | - | 1650585600000 | - | D2 | - | PARKING:RPP | REG | R32C(CA).0096 | 18X21 | SUP1 | LIGHT POLE | IS | 1649769300000 | BUCHANAN ST | 3600 - 3699 BUCHANAN ST | 3600 - 3699 BUCHANAN ST | 3600 BUCHANAN ST | - | NORTH POINT ST | NORTH POINT ST |
| 51148 | N/A | Point | 1 | 1 | 2229 - 2299 | - | S282176 | 2229-2299 POWELL ST | 2229-2299 POWELL ST | F | F | - | F | 10703000 | 10703000 | - | - | WEST SIDE | - | - | - | - | VANDEWATER ST | VANDEWATER ST | 95011 | 95011 | 37.80559316 | -122.41190428 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-SAT EXC "A" PERMITS | VANDEWATER ST to BAY ST (2229 - 2299) | - | 12' N OF VANDEWATER | - | - | - | - | - | 68251 | - | -122.41190428 | 37.80559316 | - | 1652227200000 | - | D3 | - | PARKING:RPP | REG | R32C(CA).0129 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1649770620000 | POWELL ST | 2229 - 2299 POWELL ST | 2229 - 2299 POWELL ST | 2229 POWELL ST | - | BAY ST | BAY ST |
| 51149 | N/A | Point | 1 | 1 | 2100 - 2199 | - | S282178 | 2100-2199 STOCKTON ST | 2100-2199 STOCKTON ST | F | F | - | F | 12221000 | 12221000 | - | - | WEST SIDE | - | - | - | - | FRANCISCO ST | FRANCISCO ST | 95012 | 95012 | 37.80556295 | -122.41021722 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-9PM MON-SAT EXC "A" PERMITS | FRANCISCO ST to BAY ST (2100 - 2199) | - | 35FT. NORTH OF FRANCISCO ST. | - | - | - | - | - | 68252 | 1421971200000 | -122.41021722 | 37.80556295 | - | 1650931200000 | - | D3 | - | PARKING:RPP | REG | R32C(CA).0129 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1649771040000 | STOCKTON ST | 2100 - 2199 STOCKTON ST | 2100 - 2199 STOCKTON ST | 2100 STOCKTON ST | - | BAY ST | BAY ST |
| 51150 | N/A | Point | 1 | 1 | 500 - 599 | RIGHT ARROW | S282261 | 500-699 BERRY ST | 500-599 BERRY ST | F | F | - | F | 2957000 | 2957000 | - | - | NORTH SIDE | - | - | - | - | 7TH ST | 07TH ST | 95014 | 95014 | 37.76975226 | -122.40099196 | - | - | 1753725266000 | middleware_editor | PARK PARALLEL | 07TH ST to DE HARO ST (500 - 599) | - | 130' EAST OF DE HARO ST | - | - | - | - | - | 68253 | 1650956400000 | -122.40099196 | 37.76975226 | - | - | - | D10 | - | PARKING:PARALLEL | REG | R24(CA).0001 | 18X18 | SUP1 | LIGHT POLE | IS | 1649944860000 | BERRY ST | 500 - 599 BERRY ST | 500 - 599 BERRY ST | 500 BERRY ST | - | DE HARO ST | DE HARO ST |
Download data as a comma-separated values file with coordinates and properties.
Download CSVDownload data in GeoJSON format, compatible with most GIS applications.
Download GeoJSONDownload data in KML format for use with Google Earth and other mapping applications.
Download KMLDownload data as a shapefile (ZIP format) for use with ArcGIS and other GIS software.
Download ShapefileGet detailed information about this dataset including metadata and available properties.
page - Page number (default: 1)limit - Results per page (max: 1000, default: 100)properties - JSON object for property filteringgeometry_type - Filter by geometry type (Point, LineString, Polygon, etc.)bbox - Bounding box (minX,minY,maxX,maxY)lat - Center latitude for radius searchlon - Center longitude for radius searchradius - Search radius in meters