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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22576 | N/A | Point | - | - | - | - | S230435 | GIRARD ST: DWIGHT ST | - | F | F | - | F | 20599000 | 20599000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GIRARD ST | DWIGHT ST | 66468 | 66468 | 37.72377503 | -122.40310583 | DWIGHT ST \ GIRARD ST | GIRARD ST \ DWIGHT ST | 1742259135000 | middleware_editor | ALL WAY | DWIGHT ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 39654 | 137919600000 | -122.40310583 | 37.72377503 | - | 1491030000000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1477901340000 | GIRARD ST | - | - | - | - | - | - |
| 22577 | N/A | Point | - | - | - | - | S230437 | DWIGHT ST: GIRARD ST | - | F | F | - | F | 20599000 | 20599000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GIRARD ST | DWIGHT ST | 66469 | 66469 | 37.72377503 | -122.40310583 | DWIGHT ST \ GIRARD ST | GIRARD ST \ DWIGHT ST | 1742259137000 | middleware_editor | ALL WAY | DWIGHT ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 39655 | 180601200000 | -122.40310583 | 37.72377503 | - | 1491030000000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1477902360000 | GIRARD ST | - | - | - | - | - | - |
| 22578 | N/A | Point | - | - | - | - | S230438 | GIRARD ST: OLMSTEAD ST | - | F | F | - | F | 20577000 | 20577000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | OLMSTEAD ST | GIRARD ST | 66470 | 66470 | 37.72257408 | -122.40260482 | GIRARD ST \ OLMSTEAD ST | OLMSTEAD ST \ GIRARD ST | 1710539427000 | MTA | ALL WAY | GIRARD ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 39656 | 86227200000 | -122.40260482 | 37.72257408 | - | 1491004800000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 3IN IRON POST | IS | 1477902600000 | OLMSTEAD ST | - | - | - | - | - | - |
| 22579 | N/A | Point | - | - | - | - | S230439 | GIRARD ST: OLMSTEAD ST | - | F | F | - | F | 20577000 | 20577000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | OLMSTEAD ST | GIRARD ST | 66471 | 66471 | 37.72257408 | -122.40260482 | GIRARD ST \ OLMSTEAD ST | OLMSTEAD ST \ GIRARD ST | 1710539427000 | MTA | ALL WAY | GIRARD ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 39657 | 86227200000 | -122.40260482 | 37.72257408 | - | 1491004800000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1477902900000 | OLMSTEAD ST | - | - | - | - | - | - |
| 22580 | N/A | Point | 1 | 1 | 2500 - 2599 | - | S228339 | 2500-2599 41ST AVE | 2500-2599 41ST AVE | F | F | - | F | 1923000 | 1923000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | ULLOA ST | ULLOA ST | 66473 | 66473 | 37.73921452 | -122.49906643 | - | - | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | ULLOA ST to VICENTE ST (2500 - 2599) | - | IFO#2567 | - | - | - | - | - | 39658 | 1475594940000 | -122.49906643 | 37.73921452 | - | 1475539200000 | - | D4 | - | SPEED LIMIT | REG | SR4-1(CA).0001 | 24X48 | SUP2 | LIGHT POLE | IS | 1471950900000 | 41ST AVE | 2500 - 2599 41ST AVE | 2500 - 2599 41ST AVE | 2500 41ST AVE | - | VICENTE ST | VICENTE ST |
| 22581 | N/A | Point | - | - | - | - | S229879 | BELVEDERE ST: GRATTAN ST | - | F | F | - | F | 26274000 | 26274000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GRATTAN ST | BELVEDERE ST | 66478 | 66478 | 37.76419613 | -122.44827395 | BELVEDERE ST \ GRATTAN ST | GRATTAN ST \ BELVEDERE ST | 1710539427000 | MTA | ALL WAY | BELVEDERE ST intersection | - | 3'N | - | - | - | - | - | 39659 | 871344000000 | -122.44827395 | 37.76419613 | - | 1477612800000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1476700620000 | GRATTAN ST | - | - | - | - | - | - |
| 22582 | N/A | Point | 1 | 1 | 444 - 500 | - | S229880 | 444-500 BELVEDERE ST | 444-500 BELVEDERE ST | F | F | - | F | 2911000 | 2911000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | GRATTAN ST | GRATTAN ST | 66479 | 66479 | 37.76378168 | -122.4481917 | - | - | 1710539427000 | MTA | ALL WAY | GRATTAN ST to ALMA ST (444 - 500) | - | NPL#456 | - | - | - | - | - | 39660 | 871344000000 | -122.4481917 | 37.76378168 | - | 1477612800000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1476700680000 | BELVEDERE ST | 444 - 500 BELVEDERE ST | 444 - 500 BELVEDERE ST | 444 BELVEDERE ST | - | ALMA ST | ALMA ST |
| 22583 | N/A | Point | - | - | - | - | S229881 | GRATTAN ST: BELVEDERE ST | - | F | F | - | F | 26274000 | 26274000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GRATTAN ST | BELVEDERE ST | 66480 | 66480 | 37.76419613 | -122.44827395 | BELVEDERE ST \ GRATTAN ST | GRATTAN ST \ BELVEDERE ST | 1710539427000 | MTA | ALL WAY | BELVEDERE ST intersection | - | - | - | - | - | - | - | 39661 | 871344000000 | -122.44827395 | 37.76419613 | - | 1477612800000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1476700860000 | GRATTAN ST | - | - | - | - | - | - |
| 22584 | N/A | Point | - | - | - | - | S229893 | 2ND AVE: HUGO ST | - | F | F | - | F | 27070000 | 27070000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 2ND AVE | 02ND AVE | 66482 | 66482 | 37.76530432 | -122.45888053 | HUGO ST \ 2ND AVE | HUGO ST \ 02ND AVE | 1710539427000 | MTA | STOP | 02ND AVE intersection | - | X ST IS IRVING | - | - | - | - | - | 39662 | 866073600000 | -122.45888053 | 37.76530432 | - | 1477353600000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1476709620000 | HUGO ST | - | - | - | - | - | - |
| 22585 | N/A | Point | - | - | - | - | S229636 | MARKET ST: 6TH ST \ GOLDEN GAT | - | T | T | - | F | 24922000 | 24922000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 6TH ST \ GOLDEN GATE AVE \ MARKET ST | 06TH ST \ GOLDEN GATE AVE \ TAYLOR ST | 67247 | 67247 | 37.78223058 | -122.41029203 | TAYLOR ST \ 6TH ST \ GOLDEN GATE AVE \ MARKET ST | MARKET ST \ 06TH ST \ GOLDEN GATE AVE \ TAYLOR ST | 1744120901000 | middleware_editor | NO LEFT TURN (SYM) | 06TH ST \ GOLDEN GATE AVE \ TAYLOR ST intersection | - | - | - | - | - | - | - | 39663 | -385488000000 | -122.41029203 | 37.78223058 | - | 1475823600000 | 1744036320000 | D6 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | LIGHT POLE | RETD | 1475829000000 | MARKET ST | - | - | - | - | - | - |
| 22586 | N/A | Point | - | - | - | - | S229662 | TAYLOR ST: GEARY ST | - | F | F | - | F | 24941000 | 24941000 | - | - | SOUTH WEST CORNER | - | - | - | - | TAYLOR ST | GEARY ST | 67248 | 67248 | 37.78693971 | -122.41151577 | GEARY ST \ TAYLOR ST | TAYLOR ST \ GEARY ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | GEARY ST intersection | - | SEE NOTES | - | - | - | - | - | 39664 | 1476889200000 | -122.41151577 | 37.78693971 | - | 1561161600000 | - | D3 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1475838720000 | TAYLOR ST | - | - | - | - | - | - |
| 22587 | N/A | Point | - | - | - | - | S229664 | LARKIN ST: GEARY ST | - | F | F | - | F | 25170000 | 25170000 | - | - | SOUTH WEST CORNER | - | - | - | - | GEARY ST | GEARY ST | 67249 | 67249 | 37.78610104 | -122.4180881 | LARKIN ST \ GEARY ST | LARKIN ST \ GEARY ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | GEARY ST intersection | - | SEE NOTES | - | - | - | - | - | 39665 | 1476889260000 | -122.4180881 | 37.78610104 | - | 1476835200000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1475839020000 | LARKIN ST | - | - | - | - | - | - |
| 22588 | N/A | Point | 1 | 1 | 1 - 99 | - | S229688 | 1-99 CLEMENT ST | 1-99 CLEMENT ST | F | F | - | F | 4150000 | 4150000 | - | - | SOUTH SIDE | - | - | - | - | ARGUELLO BLVD | ARGUELLO BLVD | 67253 | 67253 | 37.78316258 | -122.4595678 | - | - | 1732566098000 | middleware_editor | BIKE RACK | ARGUELLO BLVD to 02ND AVE (1 - 99) | 201600262 | 26 FT EAST OF WPL#9 3FT FROM CRUB | - | - | - | - | - | 39666 | 1478081880000 | -122.4595678 | 37.78316258 | - | 1478044800000 | - | D1 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1476177600000 | CLEMENT ST | 1 - 99 CLEMENT ST | 1 - 99 CLEMENT ST | 1 CLEMENT ST | - | 02ND AVE | 02ND AVE |
| 22589 | N/A | Point | 1 | 1 | 1 - 99 | - | S229691 | 1-99 CLEMENT ST | 1-99 CLEMENT ST | F | F | - | F | 4150000 | 4150000 | - | - | NORTH SIDE | - | - | - | - | ARGUELLO BLVD | ARGUELLO BLVD | 67254 | 67254 | 37.78316258 | -122.4595678 | - | - | 1732567226000 | middleware_editor | BIKE RACK | ARGUELLO BLVD to 02ND AVE (1 - 99) | 201600260 | 7 FT6" EAST OF WPL#24 3FT FROM CRUB | - | - | - | - | - | 39667 | 1478080140000 | -122.4595678 | 37.78316258 | - | 1478044800000 | - | D1 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1476178020000 | CLEMENT ST | 1 - 99 CLEMENT ST | 1 - 99 CLEMENT ST | 1 CLEMENT ST | - | 02ND AVE | 02ND AVE |
| 22590 | N/A | Point | 1 | 1 | 300 - 399 | - | S229693 | 300-399 2ND AVE | 300-399 02ND AVE | F | F | - | F | 122000 | 122000 | - | - | EAST SIDE | - | - | - | - | CLEMENT ST | CLEMENT ST | 67255 | 67255 | 37.78217499 | -122.46006843 | - | - | 1710539427000 | MTA | BIKE RACK | CLEMENT ST to GEARY BLVD (300 - 399) | 201600277 | 11 FT6" NORTH 3FT6" FROM CRUB | - | - | - | - | - | 39668 | 1485129600000 | -122.46006843 | 37.78217499 | - | 1485129600000 | - | D1 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1476178440000 | 02ND AVE | 300 - 399 2ND AVE | 300 - 399 02ND AVE | 300 2ND AVE | - | GEARY BLVD | GEARY BLVD |
| 22591 | N/A | Point | - | - | - | - | S230251 | CRESCENT AVE: FOLSOM ST | - | F | F | - | F | 21046000 | 21046000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CRESCENT AVE | FOLSOM ST | 67256 | 67256 | 37.73473162 | -122.41368902 | FOLSOM ST \ CRESCENT AVE | CRESCENT AVE \ FOLSOM ST | 1734133635000 | middleware_editor | ALL WAY | FOLSOM ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 39669 | 227491200000 | -122.41368902 | 37.73473162 | - | 1490054400000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1477562520000 | CRESCENT AVE | - | - | - | - | - | - |
| 22592 | N/A | Point | - | - | - | - | S230258 | FOLSOM ST: CRESCENT AVE | - | F | F | - | F | 21046000 | 21046000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CRESCENT AVE | FOLSOM ST | 67257 | 67257 | 37.73473162 | -122.41368902 | FOLSOM ST \ CRESCENT AVE | CRESCENT AVE \ FOLSOM ST | 1734133606000 | middleware_editor | ALL WAY | FOLSOM ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 39670 | 132537600000 | -122.41368902 | 37.73473162 | - | 1490140800000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | UTILITY POLE | IS | 1477563240000 | CRESCENT AVE | - | - | - | - | - | - |
| 22593 | N/A | Point | - | - | - | - | S230262 | FOLSOM ST: TOMPKINS AVE | - | F | F | - | F | 21055000 | 21055000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | TOMPKINS AVE | FOLSOM ST | 67258 | 67258 | 37.73706991 | -122.4134776 | FOLSOM ST \ TOMPKINS AVE | TOMPKINS AVE \ FOLSOM ST | 1746473563000 | middleware_editor | ALL WAY | FOLSOM ST intersection | - | BELWO EXISTING STOP SIGN | - | - | - | - | - | 39671 | 124617600000 | -122.4134776 | 37.73706991 | - | 1490079600000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1477564200000 | TOMPKINS AVE | - | - | - | - | - | - |
| 22594 | N/A | Point | - | - | - | - | S230273 | FOLSOM ST: TOMPKINS AVE | - | F | F | - | F | 21055000 | 21055000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TOMPKINS AVE | FOLSOM ST | 67259 | 67259 | 37.73706991 | -122.4134776 | FOLSOM ST \ TOMPKINS AVE | TOMPKINS AVE \ FOLSOM ST | 1746473571000 | middleware_editor | ALL WAY | FOLSOM ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 39672 | 124617600000 | -122.4134776 | 37.73706991 | - | 1597820400000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1477565160000 | TOMPKINS AVE | - | - | - | - | - | - |
| 22595 | N/A | Point | - | - | - | - | S230276 | TOMPKINS AVE: FOLSOM ST | - | F | F | - | F | 21055000 | 21055000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TOMPKINS AVE | FOLSOM ST | 67260 | 67260 | 37.73706991 | -122.4134776 | FOLSOM ST \ TOMPKINS AVE | TOMPKINS AVE \ FOLSOM ST | 1746473567000 | middleware_editor | ALL WAY | FOLSOM ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 39673 | 124617600000 | -122.4134776 | 37.73706991 | - | 1490079600000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1477566120000 | TOMPKINS AVE | - | - | - | - | - | - |
| 22596 | N/A | Point | - | - | - | - | S230277 | TOMPKINS AVE: FOLSOM ST | - | F | F | - | F | 21055000 | 21055000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TOMPKINS AVE | FOLSOM ST | 67261 | 67261 | 37.73706991 | -122.4134776 | FOLSOM ST \ TOMPKINS AVE | TOMPKINS AVE \ FOLSOM ST | 1746473569000 | middleware_editor | ALL WAY | FOLSOM ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 39674 | 124617600000 | -122.4134776 | 37.73706991 | - | 1490079600000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1477566300000 | TOMPKINS AVE | - | - | - | - | - | - |
| 22597 | N/A | Point | - | - | - | - | S230299 | FOLSOM ST: TOMPKINS AVE | - | F | F | - | F | 21055000 | 21055000 | - | - | SOUTH WEST CORNER | - | - | - | - | TOMPKINS AVE | FOLSOM ST | 67262 | 67262 | 37.73706991 | -122.4134776 | FOLSOM ST \ TOMPKINS AVE | TOMPKINS AVE \ FOLSOM ST | 1746473574000 | middleware_editor | FOLSOM ST | FOLSOM ST intersection | - | - | - | - | - | - | - | 39675 | 1516213680000 | -122.4134776 | 37.73706991 | - | 1516176000000 | - | D9 | - | STREET NAME | GUIDE | D3-1.0676 | 36X08 | SUP2 | LIGHT POLE | IS | 1477570080000 | TOMPKINS AVE | - | - | - | - | - | - |
| 22598 | N/A | Point | - | - | - | - | S230300 | TOMPKINS AVE: FOLSOM ST | - | F | F | - | F | 21055000 | 21055000 | - | - | SOUTH WEST CORNER | - | - | - | - | TOMPKINS AVE | FOLSOM ST | 67263 | 67263 | 37.73706991 | -122.4134776 | FOLSOM ST \ TOMPKINS AVE | TOMPKINS AVE \ FOLSOM ST | 1746473560000 | middleware_editor | TOMPKINS AVE | FOLSOM ST intersection | - | - | - | - | - | - | - | 39676 | 1516215000000 | -122.4134776 | 37.73706991 | - | 1516176000000 | - | D9 | - | STREET NAME | GUIDE | D3-1.1736 | 36X08 | SUP2 | LIGHT POLE | IS | 1477570320000 | TOMPKINS AVE | - | - | - | - | - | - |
| 22599 | N/A | Point | 1 | 1 | 3700 - 3799 | - | S233780 | 3700-3799 17TH ST | 3700-3799 17TH ST | F | F | - | F | 805000 | 805000 | - | - | NORTH SIDE | - | - | - | - | CHURCH ST | CHURCH ST | 67264 | 67264 | 37.76282127 | -122.42961774 | - | - | 1729300443000 | middleware_editor | DELINEATOR (W) (SAFE HIT) | CHURCH ST to SANCHEZ ST (3700 - 3799) | - | 32FT. WEST OF CHURCH ST.(6FT. FROM CURB) | - | - | - | - | - | 39677 | - | -122.42961774 | 37.76282127 | - | - | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0001 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | IS | 1487347020000 | 17TH ST | 3700 - 3799 17TH ST | 3700 - 3799 17TH ST | 3700 17TH ST | - | SANCHEZ ST | SANCHEZ ST |
| 22600 | N/A | Point | - | - | - | - | S233845 | BUCHANAN ST: PAGE ST | - | F | F | - | F | 25903000 | 25903000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PAGE ST | BUCHANAN ST | 67265 | 67265 | 37.77345546 | -122.42735744 | BUCHANAN ST \ PAGE ST | PAGE ST \ BUCHANAN ST | 1721765078000 | middleware_editor | ALL WAY | BUCHANAN ST intersection | - | 0 / 0 | - | - | - | - | - | 39678 | 624067200000 | -122.42735744 | 37.77345546 | - | 1721732400000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1487842320000 | PAGE ST | - | - | - | - | - | - |
| 22601 | N/A | Point | - | - | - | - | S233400 | DETROIT ST: JOOST AVE | - | F | F | - | F | 22157000 | 22157000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DETROIT ST | DETROIT ST | 67966 | 67966 | 37.7323469 | -122.44431435 | JOOST AVE \ DETROIT ST | JOOST AVE \ DETROIT ST | 1710539427000 | MTA | LOW GROUND CLEARANCE | DETROIT ST intersection | - | ABOVE STOP SIGN | - | - | - | - | - | 39679 | 1487861880000 | -122.44431435 | 37.7323469 | - | 1672790400000 | - | D7 | - | OTHER WARNING | WARNING | W10-5P.0001 | 24X18 | SUP2 | 2IN IRON POST | IS | 1486547760000 | JOOST AVE | - | - | - | - | - | - |
| 22602 | N/A | Point | 1 | 1 | 200 - 299 | - | S231863 | 200-299 SPEAR ST | 200-299 SPEAR ST | F | F | - | F | 12046000 | 12046000 | - | - | WEST SIDE | - | - | - | - | HOWARD ST | HOWARD ST | 67967 | 67967 | 37.79069039 | -122.39174782 | - | - | 1710539427000 | MTA | TANS EXCEPT CARPOOL 3PM-7PM MON-FRI | HOWARD ST to FOLSOM ST (200 - 299) | - | 100' NORTH OF FOLSOM | - | - | - | - | - | 39680 | - | -122.39174782 | 37.79069039 | - | - | - | D6 | - | OTHER REGULATORY | REG | R37(SF).0322 | 18X21 | SUP1 | 2IN IRON POST | IS | 1481883420000 | SPEAR ST | 200 - 299 SPEAR ST | 200 - 299 SPEAR ST | 200 SPEAR ST | - | FOLSOM ST | FOLSOM ST |
| 22603 | N/A | Point | - | - | - | - | S233906 | REY ST: SUNNYDALE AVE | - | F | F | - | F | 20370000 | 20370000 | - | - | NORTH WEST CORNER | - | - | - | - | REY ST | REY ST | 67968 | 67968 | 37.71086606 | -122.41228115 | SUNNYDALE AVE \ REY ST | SUNNYDALE AVE \ REY ST | 1710539427000 | MTA | STOP | REY ST intersection | - | X ST IS SUNNYDALE | - | - | - | - | - | 39681 | - | -122.41228115 | 37.71086606 | - | 1707480000000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1487928780000 | SUNNYDALE AVE | - | - | - | - | - | - |
| 22604 | N/A | Point | - | - | - | - | S233908 | REY ST: SUNNYDALE AVE | - | F | F | - | F | 20370000 | 20370000 | - | - | NORTH WEST CORNER | - | - | - | - | REY ST | REY ST | 67969 | 67969 | 37.71086606 | -122.41228115 | SUNNYDALE AVE \ REY ST | SUNNYDALE AVE \ REY ST | 1710539427000 | MTA | ALL WAY | REY ST intersection | - | X ST IS SUNNYDALE | - | - | - | - | - | 39682 | 1496481120000 | -122.41228115 | 37.71086606 | - | 1496448000000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1487928840000 | SUNNYDALE AVE | - | - | - | - | - | - |
| 22605 | N/A | Point | - | - | - | - | S233916 | 6TH AVE: LAKE ST | - | F | F | - | F | 27598000 | 27598000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LAKE ST | 06TH AVE | 67973 | 67973 | 37.78667044 | -122.46469346 | 6TH AVE \ LAKE ST | LAKE ST \ 06TH AVE | 1714785128000 | middleware_editor | ALL WAY | 06TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 39683 | 43545600000 | -122.46469346 | 37.78667044 | - | 1491177600000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1487937240000 | LAKE ST | - | - | - | - | - | - |
| 22606 | N/A | Point | - | - | - | - | S233917 | 6TH AVE: LAKE ST | - | F | F | - | F | 27598000 | 27598000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LAKE ST | 06TH AVE | 67974 | 67974 | 37.78667044 | -122.46469346 | 6TH AVE \ LAKE ST | LAKE ST \ 06TH AVE | 1714785132000 | middleware_editor | ALL WAY | 06TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 39684 | 43545600000 | -122.46469346 | 37.78667044 | - | 1491177600000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1487937540000 | LAKE ST | - | - | - | - | - | - |
| 22607 | N/A | Point | - | - | - | - | S233918 | LAKE ST: 6TH AVE | - | F | F | - | F | 27598000 | 27598000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LAKE ST | 06TH AVE | 67975 | 67975 | 37.78667044 | -122.46469346 | 6TH AVE \ LAKE ST | LAKE ST \ 06TH AVE | 1714785168000 | middleware_editor | ALL WAY | 06TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 39685 | 43545600000 | -122.46469346 | 37.78667044 | - | 1491264000000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1487938140000 | LAKE ST | - | - | - | - | - | - |
| 22608 | N/A | Point | - | - | - | - | S233919 | LAKE ST: 6TH AVE | - | F | F | - | F | 27598000 | 27598000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LAKE ST | 06TH AVE | 67976 | 67976 | 37.78667044 | -122.46469346 | 6TH AVE \ LAKE ST | LAKE ST \ 06TH AVE | 1714785160000 | middleware_editor | ALL WAY | 06TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 39686 | 43545600000 | -122.46469346 | 37.78667044 | - | 1491264000000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1487938200000 | LAKE ST | - | - | - | - | - | - |
| 22609 | N/A | Point | - | - | - | - | S233920 | LAKE ST: 12TH AVE | - | F | F | - | F | 27613000 | 27613000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LAKE ST | 12TH AVE | 67977 | 67977 | 37.78638724 | -122.4711146 | 12TH AVE \ LAKE ST | LAKE ST \ 12TH AVE | 1725457054000 | middleware_editor | ALL WAY | 12TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 39687 | 43545600000 | -122.4711146 | 37.78638724 | - | 1491264000000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1487938560000 | LAKE ST | - | - | - | - | - | - |
| 22610 | N/A | Point | - | - | - | - | S233921 | LAKE ST: 12TH AVE | - | F | F | - | F | 27613000 | 27613000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LAKE ST | 12TH AVE | 67978 | 67978 | 37.78638724 | -122.4711146 | 12TH AVE \ LAKE ST | LAKE ST \ 12TH AVE | 1725457234000 | middleware_editor | ALL WAY | 12TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 39688 | 43545600000 | -122.4711146 | 37.78638724 | - | 1491264000000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1487938680000 | LAKE ST | - | - | - | - | - | - |
| 22611 | N/A | Point | - | - | - | - | S233922 | 12TH AVE: LAKE ST | - | F | F | - | F | 27613000 | 27613000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LAKE ST | 12TH AVE | 67979 | 67979 | 37.78638724 | -122.4711146 | 12TH AVE \ LAKE ST | LAKE ST \ 12TH AVE | 1725457233000 | middleware_editor | ALL WAY | 12TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 39689 | 43545600000 | -122.4711146 | 37.78638724 | - | 1491177600000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1487939040000 | LAKE ST | - | - | - | - | - | - |
| 22612 | N/A | Point | - | - | - | - | S233923 | 12TH AVE: LAKE ST | - | F | F | - | F | 27613000 | 27613000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LAKE ST | 12TH AVE | 67980 | 67980 | 37.78638724 | -122.4711146 | 12TH AVE \ LAKE ST | LAKE ST \ 12TH AVE | 1725457242000 | middleware_editor | ALL WAY | 12TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 39690 | 43545600000 | -122.4711146 | 37.78638724 | - | 1491177600000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1487939160000 | LAKE ST | - | - | - | - | - | - |
| 22613 | N/A | Point | 1 | 1 | 2400 - 2499 | - | S234159 | 2400-2499 18TH AVE | 2400-2499 18TH AVE | F | F | - | F | 846000 | 846000 | - | - | EAST SIDE | - | - | - | - | TARAVAL ST | TARAVAL ST | 67982 | 67982 | 37.74216545 | -122.47455903 | - | - | 1751481168000 | middleware_editor | 2 HR PRK 8AM-6PM MON-FRI EXC "O" PERMITS | TARAVAL ST to ULLOA ST (2400 - 2499) | - | SPL #2442 | - | - | - | - | - | 39691 | 1224140400000 | -122.47455903 | 37.74216545 | - | 1490079600000 | - | D7 | - | PARKING:RPP | REG | R32C(CA).0097 | 18X21 | SUP2 | 2IN IRON POST | IS | 1488877020000 | 18TH AVE | 2400 - 2499 18TH AVE | 2400 - 2499 18TH AVE | 2400 18TH AVE | - | ULLOA ST | ULLOA ST |
| 22614 | N/A | Point | 1 | 1 | 100 - 199 | - | S234311 | 100-199 LAGUNA ST | 100-199 LAGUNA ST | F | F | - | F | 7941000 | 7941000 | - | - | WEST SIDE | - | - | - | - | WALLER ST | WALLER ST | 67983 | 67983 | 37.77226483 | -122.42541727 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM FRI STCL | WALLER ST to HAIGHT ST (100 - 199) | - | 20`SOUTH OF HAIGHT | - | - | - | - | - | 39692 | - | -122.42541727 | 37.77226483 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0076 | 18X18 | SUP2 | 2IN IRON POST | IS | 1489494540000 | LAGUNA ST | 100 - 199 LAGUNA ST | 100 - 199 LAGUNA ST | 100 LAGUNA ST | - | HAIGHT ST | HAIGHT ST |
| 22615 | N/A | Point | 1 | 1 | 100 - 199 | - | S234312 | 100-199 LAGUNA ST | 100-199 LAGUNA ST | F | F | - | F | 7941000 | 7941000 | - | - | WEST SIDE | - | - | - | - | WALLER ST | WALLER ST | 67984 | 67984 | 37.77226483 | -122.42541727 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM MON STCL | WALLER ST to HAIGHT ST (100 - 199) | - | IFO DOOR#061 | - | - | - | - | - | 39693 | - | -122.42541727 | 37.77226483 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0078 | 18X18 | SUP2 | 2IN IRON POST | IS | 1489494840000 | LAGUNA ST | 100 - 199 LAGUNA ST | 100 - 199 LAGUNA ST | 100 LAGUNA ST | - | HAIGHT ST | HAIGHT ST |
| 22616 | N/A | Point | - | - | - | - | S234317 | VERMONT ST: 20TH ST | - | F | F | - | F | 23757000 | 23757000 | - | - | SOUTH WEST CORNER | - | - | - | - | VERMONT ST | 20TH ST | 67985 | 67985 | 37.75955913 | -122.4040106 | 20TH ST \ VERMONT ST | VERMONT ST \ 20TH ST | 1710539427000 | MTA | VERMONT ST | 20TH ST intersection | - | VERMONT (800) | - | - | - | - | - | 39694 | - | -122.4040106 | 37.75955913 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.1798 | 36X08 | SUP1 | 3IN IRON POST | IS | 1489496280000 | VERMONT ST | - | - | - | - | - | - |
| 22617 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S238650 | 2300-2399 15TH AVE | 2300-2399 15TH AVE | F | F | - | F | 627000 | 627000 | - | - | EAST SIDE | - | - | - | - | SANTIAGO ST | SANTIAGO ST | 68530 | 68530 | 37.74417454 | -122.47142272 | - | - | 1719623414000 | middleware_editor | BIKE RACK | SANTIAGO ST to TARAVAL ST (2300 - 2399) | 201703261 | 27' NORTH OF TARAVAL ST | - | - | - | - | - | 39695 | 1505214000000 | -122.47142272 | 37.74417454 | - | 1505174400000 | - | D7 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1504186500000 | 15TH AVE | 2300 - 2399 15TH AVE | 2300 - 2399 15TH AVE | 2300 15TH AVE | - | TARAVAL ST | TARAVAL ST |
| 22618 | N/A | Point | - | - | - | - | S238714 | GREAT HWY: ORTEGA ST | - | F | F | - | F | 27926000 | 27926000 | - | - | NORTH EAST CORNER | - | - | - | - | GREAT HWY | GREAT HWY | 68531 | 68531 | 37.7509682 | -122.50818665 | ORTEGA ST \ GREAT HWY | ORTEGA ST \ GREAT HWY | 1729300473000 | middleware_editor | GREAT HWY | GREAT HWY intersection | - | 1900BLK / CROSS ST IS ORTEGA | - | - | - | - | - | 39696 | 1504703760000 | -122.50818665 | 37.7509682 | - | 1504656000000 | - | D4 | - | STREET NAME | GUIDE | D3-1.0770 | 36X08 | SUP2 | 3IN IRON POST | IS | 1504606620000 | ORTEGA ST | - | - | - | - | - | - |
| 22619 | N/A | Point | - | - | - | - | S238715 | ORTEGA ST: GREAT HWY | - | F | F | - | F | 27926000 | 27926000 | - | - | NORTH EAST CORNER | - | - | - | - | GREAT HWY | GREAT HWY | 68532 | 68532 | 37.7509682 | -122.50818665 | ORTEGA ST \ GREAT HWY | ORTEGA ST \ GREAT HWY | 1729300473000 | middleware_editor | ORTEGA ST | GREAT HWY intersection | - | END (@GREAT HWY) | - | - | - | - | - | 39697 | 1504703820000 | -122.50818665 | 37.7509682 | - | 1504656000000 | - | D4 | - | STREET NAME | GUIDE | D3-1.1322 | 36X08 | SUP2 | 3IN IRON POST | IS | 1504606740000 | ORTEGA ST | - | - | - | - | - | - |
| 22620 | N/A | Point | - | - | - | - | S238727 | 11TH AVE: KIRKHAM ST | - | F | F | - | F | 27158000 | 27158000 | - | - | NORTH WEST CORNER | - | - | - | - | KIRKHAM ST | 11TH AVE | 68533 | 68533 | 37.76021765 | -122.46819079 | 11TH AVE \ KIRKHAM ST | KIRKHAM ST \ 11TH AVE | 1710539427000 | MTA | 11TH AVE | 11TH AVE intersection | - | 11TH AVE (1500) | - | - | - | - | - | 39698 | - | -122.46819079 | 37.76021765 | - | - | - | D7 | - | STREET NAME | GUIDE | D3-1.1938 | 36X08 | SUP2 | 3IN IRON POST | IS | 1504619280000 | KIRKHAM ST | - | - | - | - | - | - |
| 22621 | N/A | Point | 1 | 1 | 400 - 499 | - | S235798 | 400-499 DEWEY BLVD | 400-499 DEWEY BLVD | F | F | - | F | 4734000 | 4734000 | - | - | WEST SIDE | - | - | - | - | LAGUNA HONDA BLVD | LAGUNA HONDA BLVD | 68536 | 68536 | 37.74642791 | -122.46027774 | - | - | 1731539373000 | middleware_editor | 2 HR PRK 8AM-3PM MON-FRI EXC "T" PERMITS | LAGUNA HONDA BLVD to PACHECO ST (400 - 499) | - | IFO 428 | - | - | - | - | - | 39699 | 1224547200000 | -122.46027774 | 37.74642791 | - | 1731499500000 | - | D7 | - | PARKING:RPP | REG | R32C(CA).0039 | 18X21 | SUP2 | 2IN IRON POST | IS | 1493724540000 | DEWEY BLVD | 400 - 499 DEWEY BLVD | 400 - 499 DEWEY BLVD | 400 DEWEY BLVD | - | PACHECO ST | PACHECO ST |
| 22622 | N/A | Point | - | - | - | - | S235806 | PAULDING ST: SAN JOSE AVE | - | F | F | - | F | 22118000 | 22118000 | - | - | SOUTH WEST CORNER | - | - | - | - | PAULDING ST | SAN JOSE AVE | 68541 | 68541 | 37.72744684 | -122.44110313 | SAN JOSE AVE \ PAULDING ST | PAULDING ST \ SAN JOSE AVE | 1714785197000 | middleware_editor | PAULDING ST | SAN JOSE AVE intersection | - | 000 | - | - | - | - | - | 39700 | 1494430440000 | -122.44110313 | 37.72744684 | - | 1502064000000 | - | D11 | - | STREET NAME | GUIDE | D3-1.1363 | 36X08 | SUP2 | LIGHT POLE | IS | 1493731440000 | PAULDING ST | - | - | - | - | - | - |
| 22623 | N/A | Point | 1 | 1 | 400 - 437 | - | S231844 | 400-437 WASHINGTON ST | 400-437 WASHINGTON ST | F | F | - | F | 13406000 | 13406000 | - | - | SOUTH SIDE | - | - | - | - | BATTERY ST | BATTERY ST | 68543 | 68543 | 37.79583418 | -122.40079781 | - | - | 1710539427000 | MTA | (H/C SYM) PARK ONLY/MIN FINE $250 | BATTERY ST to CUSTOM HOUSE PL (400 - 437) | - | 15' WEST OF BATTERY ST | - | - | - | - | - | 39701 | 1483091760000 | -122.40079781 | 37.79583418 | - | 1483056000000 | - | D3 | - | OTHER REGULATORY | REG | R99C(CA).0001 | 12X24 | SUP1 | 2IN IRON POST | IS | 1481795700000 | WASHINGTON ST | 400 - 437 WASHINGTON ST | 400 - 437 WASHINGTON ST | 400 WASHINGTON ST | - | CUSTOM HOUSE PL | CUSTOM HOUSE PL |
| 22624 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S231983 | 1400-1499 46TH AVE | 1400-1499 46TH AVE | F | F | - | F | 2022000 | 2022000 | - | - | EAST SIDE | - | - | - | - | JUDAH ST | JUDAH ST | 68544 | 68544 | 37.75949198 | -122.50586248 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM 1ST & 3RD FRI OF MONTH STCL | JUDAH ST to KIRKHAM ST (1400 - 1499) | - | IFO#1486 | - | - | - | - | - | 39702 | 1228348800000 | -122.50586248 | 37.75949198 | - | - | - | D4 | - | STREET CLEANING | REG | R30B(CA).0065 | 18X18 | SUP2 | LIGHT POLE | IS | 1482409920000 | 46TH AVE | 1400 - 1499 46TH AVE | 1400 - 1499 46TH AVE | 1400 46TH AVE | - | KIRKHAM ST | KIRKHAM ST |
| 22625 | N/A | Point | 1 | 1 | 3400 - 3499 | - | S231986 | 3400-3499 MORAGA ST | 3400-3499 MORAGA ST | F | F | - | F | 9366000 | 9366000 | - | - | SOUTH SIDE | - | - | - | - | 40TH AVE | 40TH AVE | 68545 | 68545 | 37.75507765 | -122.49963777 | - | - | 1727140679000 | middleware_editor | NPRK 1PM-3PM 1ST & 3RD THUR OF MONTH STCL | 40TH AVE to 41ST AVE (3400 - 3499) | - | 45`WEST (SEE PAINT) | - | - | - | - | - | 39703 | 1228176000000 | -122.49963777 | 37.75507765 | - | - | - | D4 | - | STREET CLEANING | REG | R30B(CA).0095 | 18X18 | SUP2 | 2IN IRON POST | IS | 1482410940000 | MORAGA ST | 3400 - 3499 MORAGA ST | 3400 - 3499 MORAGA ST | 3400 MORAGA ST | - | 41ST AVE | 41ST AVE |
| 22626 | N/A | Point | - | - | - | - | S232849 | INGALLS ST: HOLLISTER AVE | - | F | F | - | F | 20444000 | 20444000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | INGALLS ST | INGALLS ST | 68546 | 68546 | 37.71973995 | -122.39241823 | HOLLISTER AVE \ INGALLS ST | HOLLISTER AVE \ INGALLS ST | 1710539427000 | MTA | ALL WAY | INGALLS ST intersection | - | 0 / 0 | - | - | - | - | - | 39704 | 245635200000 | -122.39241823 | 37.71973995 | - | 1489449600000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1485246240000 | HOLLISTER AVE | - | - | - | - | - | - |
| 22627 | N/A | Point | - | - | - | - | S232850 | HOLLISTER AVE: INGALLS ST | - | F | F | - | F | 20444000 | 20444000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | INGALLS ST | INGALLS ST | 68547 | 68547 | 37.71973995 | -122.39241823 | HOLLISTER AVE \ INGALLS ST | HOLLISTER AVE \ INGALLS ST | 1710539427000 | MTA | ALL WAY | INGALLS ST intersection | - | 0 / 0 | - | - | - | - | - | 39705 | 364089600000 | -122.39241823 | 37.71973995 | - | 1488844800000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1485246240000 | HOLLISTER AVE | - | - | - | - | - | - |
| 22628 | N/A | Point | - | - | - | - | S232851 | HOLLISTER AVE: INGALLS ST | - | F | F | - | F | 20444000 | 20444000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | INGALLS ST | INGALLS ST | 68548 | 68548 | 37.71973995 | -122.39241823 | HOLLISTER AVE \ INGALLS ST | HOLLISTER AVE \ INGALLS ST | 1710539427000 | MTA | ALL WAY | INGALLS ST intersection | - | 0 / 0 | - | - | - | - | - | 39706 | 364089600000 | -122.39241823 | 37.71973995 | - | 1488844800000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1485246300000 | HOLLISTER AVE | - | - | - | - | - | - |
| 22629 | N/A | Point | - | - | - | - | S234134 | LYELL ST: BOSWORTH ST | - | F | F | - | F | 21788000 | 21788000 | - | - | SOUTH EAST CORNER | - | - | - | - | BOSWORTH ST | BOSWORTH ST | 68550 | 68550 | 37.73299357 | -122.4319566 | LYELL ST \ BOSWORTH ST | LYELL ST \ BOSWORTH ST | 1731290365000 | middleware_editor | ONE WAY (LA) | BOSWORTH ST intersection | - | OF LYELL ST. & BOSWORTH ST.-F/E/B/T | - | - | - | - | - | 39707 | 1489414200000 | -122.4319566 | 37.73299357 | - | 1489363200000 | - | D8 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP2 | 2IN IRON POST | IS | 1488872580000 | LYELL ST | - | - | - | - | - | - |
| 22630 | N/A | Point | - | - | - | - | S234136 | LYELL ST: BOSWORTH ST | - | F | F | - | F | 21788000 | 21788000 | - | - | SOUTH EAST CORNER | - | - | - | - | BOSWORTH ST | BOSWORTH ST | 68551 | 68551 | 37.73299357 | -122.4319566 | LYELL ST \ BOSWORTH ST | LYELL ST \ BOSWORTH ST | 1731290397000 | middleware_editor | DO NOT ENTER | BOSWORTH ST intersection | - | OF LYELL ST. & BOSWORTH ST.-F/S/B/T | - | - | - | - | - | 39708 | - | -122.4319566 | 37.73299357 | - | - | - | D8 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1488873240000 | LYELL ST | - | - | - | - | - | - |
| 22631 | N/A | Point | - | - | - | - | S234138 | LYELL ST: BOSWORTH ST | - | F | F | - | F | 21788000 | 21788000 | - | - | SOUTH WEST CORNER | - | - | - | - | BOSWORTH ST | BOSWORTH ST | 68552 | 68552 | 37.73299357 | -122.4319566 | LYELL ST \ BOSWORTH ST | LYELL ST \ BOSWORTH ST | 1731290394000 | middleware_editor | LYELL ST | BOSWORTH ST intersection | - | OF LYELL ST. & BOSWORTH ST. | - | - | - | - | - | 39709 | 1490704440000 | -122.4319566 | 37.73299357 | - | 1490659200000 | - | D8 | - | STREET NAME | GUIDE | D3-1.1085 | 36X08 | SUP2 | LIGHT POLE | IS | 1488873780000 | LYELL ST | - | - | - | - | - | - |
| 22632 | N/A | Point | - | - | - | - | S234141 | BOSWORTH ST: LYELL ST | - | F | F | - | F | 21788000 | 21788000 | - | - | SOUTH WEST CORNER | - | - | - | - | BOSWORTH ST | BOSWORTH ST | 68553 | 68553 | 37.73299357 | -122.4319566 | LYELL ST \ BOSWORTH ST | LYELL ST \ BOSWORTH ST | 1731290432000 | middleware_editor | BOSWORTH ST | BOSWORTH ST intersection | - | - | - | - | - | - | - | 39710 | 1490704500000 | -122.4319566 | 37.73299357 | - | 1545091200000 | - | D8 | - | STREET NAME | GUIDE | D3-1.0238 | 36X08 | SUP2 | LIGHT POLE | IS | 1488873960000 | LYELL ST | - | - | - | - | - | - |
| 22633 | N/A | Point | - | - | - | - | S230975 | VICENTE ST: 14TH AVE | - | F | F | - | F | 22949000 | 22949000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 14TH AVE | 14TH AVE | 65591 | 65591 | 37.73956433 | -122.4699752 | VICENTE ST \ 14TH AVE | VICENTE ST \ 14TH AVE | 1731083207000 | middleware_editor | ALL WAY | 14TH AVE intersection | - | 00 / 00 | - | - | - | - | - | 39711 | -403660800000 | -122.4699752 | 37.73956433 | - | 1483660800000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479202740000 | VICENTE ST | - | - | - | - | - | - |
| 22634 | N/A | Point | - | - | - | - | S230976 | VICENTE ST: 14TH AVE | - | F | F | - | F | 22949000 | 22949000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 14TH AVE | 14TH AVE | 65592 | 65592 | 37.73956433 | -122.4699752 | VICENTE ST \ 14TH AVE | VICENTE ST \ 14TH AVE | 1731083264000 | middleware_editor | ALL WAY | 14TH AVE intersection | - | - | - | - | - | - | - | 39712 | -403660800000 | -122.4699752 | 37.73956433 | - | 1508371200000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479203160000 | VICENTE ST | - | - | - | - | - | - |
| 22635 | N/A | Point | - | - | - | - | S230977 | 14TH AVE: VICENTE ST | - | F | F | - | F | 22949000 | 22949000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 14TH AVE | 14TH AVE | 65593 | 65593 | 37.73956433 | -122.4699752 | VICENTE ST \ 14TH AVE | VICENTE ST \ 14TH AVE | 1731083261000 | middleware_editor | ALL WAY | 14TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 39713 | -403660800000 | -122.4699752 | 37.73956433 | - | 1483660800000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479203460000 | VICENTE ST | - | - | - | - | - | - |
| 22636 | N/A | Point | - | - | - | - | S230979 | 14TH AVE: WAWONA ST | - | F | F | - | F | 22944000 | 22944000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 14TH AVE | WAWONA ST | 65594 | 65594 | 37.73850527 | -122.46966702 | WAWONA ST \ 14TH AVE | 14TH AVE \ WAWONA ST | 1726017582000 | middleware_editor | ALL WAY | WAWONA ST intersection | - | 0 / 0 | - | - | - | - | - | 39714 | -403660800000 | -122.46966702 | 37.73850527 | - | 1483920000000 | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1479203640000 | 14TH AVE | - | - | - | - | - | - |
| 22637 | N/A | Point | - | 1 | 200 - 216 | RIGHT ARROW | S231529 | 200-216 DIVISION ST | 200-216 DIVISION ST | F | F | - | F | 4845000 | 4844000 | - | - | SOUTH SIDE | - | - | - | - | UTAH ST | 09TH ST | 65596 | 65596 | 37.7693547 | -122.40653685 | - | - | 1710539427000 | MTA | TANSAT | 09TH ST to UTAH ST (200 - 216) | - | 140' EAST OF POTRERO | - | - | - | - | - | 39715 | 1481500800000 | -122.40653685 | 37.7693547 | - | 1481500800000 | - | D10 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1481023020000 | DIVISION ST | 217 - 299 DIVISION ST | 200 - 216 DIVISION ST | 200 DIVISION ST | - | 10TH ST \ BRANNAN ST \ POTRERO AVE | UTAH ST |
| 22638 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S228802 | 1600-1699 PALOU AVE | 1600-1699 PALOU AVE | F | F | - | F | 10223000 | 10223000 | - | - | SOUTH SIDE | - | - | - | - | 3RD ST \ MENDELL ST | 03RD ST \ MENDELL ST | 65644 | 65644 | 37.73452599 | -122.39187191 | - | - | 1710539427000 | MTA | BIKE RACK | 03RD ST \ MENDELL ST to NEWHALL ST (1600 - 1699) | - | 1609 (9'6" EAST OF EPL) | - | - | - | - | - | 39716 | 1473777600000 | -122.39187191 | 37.73452599 | - | 1473724800000 | - | D10 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1473409200000 | PALOU AVE | 1600 - 1699 PALOU AVE | 1600 - 1699 PALOU AVE | 1600 PALOU AVE | - | NEWHALL ST | NEWHALL ST |
| 22639 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S228804 | 1600-1699 PALOU AVE | 1600-1699 PALOU AVE | F | F | - | F | 10223000 | 10223000 | - | - | SOUTH SIDE | - | - | - | - | 3RD ST \ MENDELL ST | 03RD ST \ MENDELL ST | 65645 | 65645 | 37.73452599 | -122.39187191 | - | - | 1710539427000 | MTA | BIKE RACK | 03RD ST \ MENDELL ST to NEWHALL ST (1600 - 1699) | - | 1611 (5' EAST OF WPL) | - | - | - | - | - | 39717 | 1473776760000 | -122.39187191 | 37.73452599 | - | 1473724800000 | - | D10 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1473409440000 | PALOU AVE | 1600 - 1699 PALOU AVE | 1600 - 1699 PALOU AVE | 1600 PALOU AVE | - | NEWHALL ST | NEWHALL ST |
| 22640 | N/A | Point | 1 | 1 | 1 - 99 | - | S227311 | 1-99 DR CARLTON B GOODLETT PL | 1-99 DR CARLTON B GOODLETT PL | F | F | - | F | 10549000 | 10549000 | - | - | WEST SIDE | - | - | - | - | GROVE ST \ POLK ST | GROVE ST \ POLK ST | 65646 | 65646 | 37.77937463 | -122.41841255 | - | - | 1756149010000 | middleware_editor | PERMIT PKG ONLY AT ALL TIMES VEH W/PERMIT ISSUED BY SFMTA | GROVE ST \ POLK ST to MCALLISTER ST \ POLK ST (1 - 99) | #44 | 120' S OF MIDBLOCK CRSSWLK / #44 | - | - | - | - | - | 39718 | - | -122.41841255 | 37.77937463 | - | - | - | D6 | - | OTHER REGULATORY | REG | R32C(SF).0066 | 12X18 | SUP1 | 2IN IRON POST | IS | 1468680180000 | DR CARLTON B GOODLETT PL | 1 - 99 DR CARLTON B GOODLETT PL | 1 - 99 DR CARLTON B GOODLETT PL | 1 DR CARLTON B GOODLETT PL | - | MCALLISTER ST \ POLK ST | MCALLISTER ST \ POLK ST |
| 22641 | N/A | Point | 1 | 1 | 1600 - 1649 | - | S227161 | 1600-1649 LAGUNA ST | 1600-1649 LAGUNA ST | T | T | - | F | 7964000 | 7964000 | - | - | WEST SIDE | - | - | - | - | POST ST | POST ST | 65650 | 65650 | 37.78601553 | -122.42819484 | - | - | 1710539427000 | MTA | PREVENT THEFT REMOVE VALUABLES LOCK YOUR CAR | POST ST to HEMLOCK ST (1600 - 1649) | - | OPP.# 1632 LAGUNA ST | - | - | - | - | - | 39719 | 1468851840000 | -122.42819484 | 37.78601553 | - | 1468800000000 | - | D5 | - | OTHER REGULATORY | REG | SR(SF).0052 | 18X21 | SUP1 | MUNI POLE | IS | 1467977280000 | LAGUNA ST | 1600 - 1649 LAGUNA ST | 1600 - 1649 LAGUNA ST | 1600 LAGUNA ST | - | HEMLOCK ST | HEMLOCK ST |
| 22642 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S227162 | 1600-1699 POST ST | 1600-1699 POST ST | F | F | - | F | 10644000 | 10644000 | - | - | NORTH SIDE | - | - | - | - | LAGUNA ST | LAGUNA ST | 65651 | 65651 | 37.78567417 | -122.42896539 | - | - | 1710539427000 | MTA | PREVENT THEFT REMOVE VALUABLES LOCK YOUR CAR | LAGUNA ST to BUCHANAN ST (1600 - 1699) | - | IFO# 1630 POST ST. | - | - | - | - | - | 39720 | 1468853580000 | -122.42896539 | 37.78567417 | - | 1468800000000 | - | D5 | - | OTHER REGULATORY | REG | SR(SF).0052 | 18X21 | SUP1 | 2IN IRON POST | IS | 1467979560000 | POST ST | 1600 - 1699 POST ST | 1600 - 1699 POST ST | 1600 POST ST | - | BUCHANAN ST | BUCHANAN ST |
| 22643 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S227163 | 1600-1699 POST ST | 1600-1699 POST ST | F | F | - | F | 10644000 | 10644000 | - | - | NORTH SIDE | - | - | - | - | LAGUNA ST | LAGUNA ST | 65652 | 65652 | 37.78567417 | -122.42896539 | - | - | 1710539427000 | MTA | PREVENT THEFT REMOVE VALUABLES LOCK YOUR CAR | LAGUNA ST to BUCHANAN ST (1600 - 1699) | - | IFO# 1672 POST ST. | - | - | - | - | - | 39721 | 1468933560000 | -122.42896539 | 37.78567417 | - | 1468886400000 | - | D5 | - | OTHER REGULATORY | REG | SR(SF).0052 | 18X21 | SUP1 | LIGHT POLE | IS | 1467979980000 | POST ST | 1600 - 1699 POST ST | 1600 - 1699 POST ST | 1600 POST ST | - | BUCHANAN ST | BUCHANAN ST |
| 22644 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S241366 | 1000-1099 STANYAN ST | 1000-1099 STANYAN ST | F | F | - | F | 12095000 | 12095000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | CARL ST | CARL ST | 74373 | 74373 | 37.76497611 | -122.45266389 | - | - | 1738358763000 | middleware_editor | 49 MILE SCENIC DRIVE | CARL ST to PARNASSUS AVE (1000 - 1099) | 86 | IFO#1045 | - | - | - | - | - | 39722 | - | -122.45266389 | 37.76497611 | - | - | - | D5 | - | OTHER GUIDE | GUIDE | G-X(SF).0045 | 24X30 | SUP1 | 2IN IRON POST | IS | 1512731160000 | STANYAN ST | 1000 - 1099 STANYAN ST | 1000 - 1099 STANYAN ST | 1000 STANYAN ST | - | PARNASSUS AVE | PARNASSUS AVE |
| 22645 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S241367 | 1000-1099 STANYAN ST | 1000-1099 STANYAN ST | F | F | - | F | 12095000 | 12095000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | CARL ST | CARL ST | 74374 | 74374 | 37.76497611 | -122.45266389 | - | - | 1738358765000 | middleware_editor | 49 MILE SCENIC DRIVE ARROW (RA) | CARL ST to PARNASSUS AVE (1000 - 1099) | 86 | IFO#1045 | - | - | - | - | - | 39723 | - | -122.45266389 | 37.76497611 | - | - | - | D5 | - | OTHER GUIDE | GUIDE | G-X(SF).0047 | 18X18 | SUP1 | 2IN IRON POST | IS | 1512731280000 | STANYAN ST | 1000 - 1099 STANYAN ST | 1000 - 1099 STANYAN ST | 1000 STANYAN ST | - | PARNASSUS AVE | PARNASSUS AVE |
| 22646 | N/A | Point | 1 | 1 | 700 - 799 | - | S241368 | 700-799 PARNASSUS AVE | 700-799 PARNASSUS AVE | T | T | - | F | 10295000 | 10295000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | 4TH AVE | 04TH AVE | 74375 | 74375 | 37.76249519 | -122.46137177 | - | - | 1710539427000 | MTA | 49 MILE SCENIC DRIVE | 04TH AVE to 05TH AVE \ JUDAH ST (700 - 799) | 87 | IFO#700 | - | - | - | - | - | 39724 | 1581688380000 | -122.46137177 | 37.76249519 | - | - | - | D5 | - | OTHER GUIDE | GUIDE | G-X(SF).0045 | 24X30 | SUP1 | LIGHT POLE | IS | 1512731520000 | PARNASSUS AVE | 700 - 799 PARNASSUS AVE | 700 - 799 PARNASSUS AVE | 700 PARNASSUS AVE | - | 05TH AVE \ JUDAH ST | 05TH AVE \ JUDAH ST |
| 22647 | N/A | Point | - | - | - | - | S238174 | CONGDON ST: ALEMANY BLVD \ JUS | - | F | F | - | F | 33636000 | 33636000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CONGDON ST \ JUSTIN DR | ALEMANY BLVD \ CONGDON ST | 74376 | 74376 | 37.73181577 | -122.42591971 | ALEMANY BLVD \ CONGDON ST \ JUSTIN DR | JUSTIN DR \ ALEMANY BLVD \ CONGDON ST | 1738853370000 | middleware_editor | NO RIGHT TURN (SYM) | ALEMANY BLVD \ CONGDON ST intersection | - | ABOVE STOP SIGN NEED EXT | - | - | - | - | - | 39725 | 1504872300000 | -122.42591971 | 37.73181577 | - | 1504828800000 | - | D11 | - | NO RIGHT TURN | REG | R3-1.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | 1502356380000 | JUSTIN DR | - | - | - | - | - | - |
| 22648 | N/A | Point | 1 | 1 | 600 - 699 | - | S236628 | 600-699 GOLDEN GATE AVE | 600-699 GOLDEN GATE AVE | T | T | - | F | 6266000 | 6266000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 74377 | 74377 | 37.78092595 | -122.42126316 | - | - | 1710539427000 | MTA | GOLDEN GATE AVE CLOSED AT VAN NESS (DATES AND TIMES) | VAN NESS AVE to FRANKLIN ST (600 - 699) | - | 121' W OF VAN NESS ABOVE SCHOOL 25MPH | - | - | - | - | - | 39726 | 1466380800000 | -122.42126316 | 37.78092595 | - | 1466380800000 | - | D5 | - | OTHER GUIDE | GUIDE | G-G(SF).0038 | 48X48 | SUP1 | LIGHT POLE | IS | 1496653140000 | GOLDEN GATE AVE | 600 - 699 GOLDEN GATE AVE | 600 - 699 GOLDEN GATE AVE | 600 GOLDEN GATE AVE | - | FRANKLIN ST | FRANKLIN ST |
| 22649 | N/A | Point | - | - | - | - | S236629 | GOLDEN GATE AVE: VAN NESS AVE | - | T | T | - | F | 24468000 | 24468000 | - | - | NORTH SIDE, NORTHBOUND TRAFFIC | - | - | - | - | VAN NESS AVE | GOLDEN GATE AVE | 74378 | 74378 | 37.78103084 | -122.42043952 | GOLDEN GATE AVE \ VAN NESS AVE | VAN NESS AVE \ GOLDEN GATE AVE | 1710539427000 | MTA | GOLDEN GATE AVE CLOSED AT VAN NESS (DATES AND TIMES) | GOLDEN GATE AVE intersection | - | 2FT WEST | - | - | - | - | - | 39727 | 1466380800000 | -122.42043952 | 37.78103084 | - | 1466380800000 | - | D5 | - | OTHER GUIDE | GUIDE | G-G(SF).0038 | 48X48 | SUP1 | LIGHT POLE | IS | 1496653620000 | VAN NESS AVE | - | - | - | - | - | - |
| 22650 | N/A | Point | 1 | 1 | 200 - 299 | LEFT ARROW | S242601 | 200-299 EDDY ST | 200-299 EDDY ST | F | F | - | F | 5060000 | 5060000 | - | - | NORTH SIDE | - | - | - | - | TAYLOR ST | TAYLOR ST | 74999 | 74999 | 37.7840368 | -122.41177345 | - | - | 1727886566000 | middleware_editor | POLICE VEHICLES ONLY | TAYLOR ST to JONES ST (200 - 299) | - | 45' FT EAST OF JONES | - | - | - | - | - | 39728 | 1248998400000 | -122.41177345 | 37.7840368 | - | 1520294400000 | - | D6 | - | OTHER REGULATORY | REG | R32(SF).0010 | 18X18 | SUP1 | 2IN IRON POST | IS | 1517219460000 | EDDY ST | 200 - 299 EDDY ST | 200 - 299 EDDY ST | 200 EDDY ST | - | JONES ST | JONES 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