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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | N/A | Point | 1 | 1 | 951 - 1000 | - | S244783 | 951-1000 CORBETT AVE | 951-1000 CORBETT AVE | F | F | - | F | 4394000 | 4394000 | - | - | WEST SIDE | - | - | - | - | GOLDING LN | GOLDING LN | 81102 | 81102 | 37.75113562 | -122.44386647 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM FRI STCL | GOLDING LN to CUESTA CT \ PORTOLA DR (951 - 1000) | - | NPL 958 | - | - | - | - | - | 17072 | 1525170000000 | -122.44386647 | 37.75113562 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0298 | 18X18 | SUP2 | 2IN IRON POST | IS | 1523967000000 | CORBETT AVE | 951 - 1000 CORBETT AVE | 951 - 1000 CORBETT AVE | 951 CORBETT AVE | - | CUESTA CT \ PORTOLA DR | CUESTA CT \ PORTOLA DR |
| 2 | N/A | Point | - | - | - | - | S244788 | PORTOLA DR: TERESITA BLVD | - | F | F | - | F | 22437000 | 22437000 | - | - | WEST SIDE | - | - | - | - | PORTOLA DR | TERESITA BLVD | 81103 | 81103 | 37.74517381 | -122.45226886 | TERESITA BLVD \ PORTOLA DR | PORTOLA DR \ TERESITA BLVD | 1710539427000 | MTA | NPRK 7AM-8AM TUE THUR STCL | TERESITA BLVD intersection | - | 60 SOUTH OF TERESITA/ IN PARKING LOT | - | - | - | - | - | 17073 | -403488000000 | -122.45226886 | 37.74517381 | - | 1524528000000 | - | D7 | - | STREET CLEANING | REG | R30B(CA).0222 | 18X18 | SUP2 | A FRAME BARRICADE | IS | 1523968620000 | PORTOLA DR | - | - | - | - | - | - |
| 3 | N/A | Point | 1 | 1 | 1 - 99 | - | S244793 | 1-99 SAINT ELMO WAY | 1-99 SAINT ELMO WAY | F | F | - | F | 11292000 | 11292000 | - | - | SOUTH SIDE | - | - | - | - | PLYMOUTH AVE \ YERBA BUENA AVE | PLYMOUTH AVE \ YERBA BUENA AVE | 81104 | 81104 | 37.73225117 | -122.45918978 | - | - | 1710539427000 | MTA | NPRK 1PM-3PM 2ND & 4TH TUE OF MONTH STCL | PLYMOUTH AVE \ YERBA BUENA AVE to EL VERANO WAY (1 - 99) | - | 90 FT WEST OF YERBA | - | - | - | - | - | 17074 | 1225152000000 | -122.45918978 | 37.73225117 | - | 1524614400000 | - | D7 | - | STREET CLEANING | REG | R30B(CA).0101 | 18X18 | SUP2 | 2IN IRON POST | IS | 1523970600000 | SAINT ELMO WAY | 1 - 99 SAINT ELMO WAY | 1 - 99 SAINT ELMO WAY | 1 SAINT ELMO WAY | - | EL VERANO WAY | EL VERANO WAY |
| 4 | N/A | Point | 1 | 1 | 1061 - 1078 | - | S244803 | 1061-1078 FOLSOM ST | 1061-1078 FOLSOM ST | F | F | - | F | 5671000 | 5671000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SHERMAN ST | SHERMAN ST | 81105 | 81105 | 37.77728947 | -122.40715422 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | SHERMAN ST to MOSS ST (1061 - 1078) | - | 125FT EAST OF 7TH ST/ 20FT O.C | - | - | - | - | - | 17075 | 1524050460000 | -122.40715422 | 37.77728947 | - | 1524009600000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1523971980000 | FOLSOM ST | 1061 - 1078 FOLSOM ST | 1061 - 1078 FOLSOM ST | 1061 FOLSOM ST | - | MOSS ST | MOSS ST |
| 5 | N/A | Point | 1 | 1 | 300 - 399 | - | S244804 | 300-399 KEARNY ST | 300-399 KEARNY ST | F | F | - | F | 7753000 | 7753000 | - | - | EAST SIDE | - | - | - | - | BUSH ST | BUSH ST | 81106 | 81106 | 37.79122534 | -122.40412528 | - | - | 1728683829000 | middleware_editor | BIKE RACK | BUSH ST to PINE ST (300 - 399) | 04647 | 3' SOUT OF SPL#356/3' IN FROM CURB | - | - | - | - | - | 17076 | 1524235380000 | -122.40412528 | 37.79122534 | - | 1524182400000 | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1523972040000 | KEARNY ST | 300 - 399 KEARNY ST | 300 - 399 KEARNY ST | 300 KEARNY ST | - | PINE ST | PINE ST |
| 6 | N/A | Point | 1 | 1 | 1061 - 1078 | - | S244805 | 1061-1078 FOLSOM ST | 1061-1078 FOLSOM ST | F | F | - | F | 5671000 | 5671000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SHERMAN ST | SHERMAN ST | 81107 | 81107 | 37.77728947 | -122.40715422 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | SHERMAN ST to MOSS ST (1061 - 1078) | - | 98FT WEST OF SHERMANN | - | - | - | - | - | 17077 | 1524050460000 | -122.40715422 | 37.77728947 | - | 1524009600000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1523972160000 | FOLSOM ST | 1061 - 1078 FOLSOM ST | 1061 - 1078 FOLSOM ST | 1061 FOLSOM ST | - | MOSS ST | MOSS ST |
| 7 | N/A | Point | 1 | 1 | 1061 - 1078 | - | S244806 | 1061-1078 FOLSOM ST | 1061-1078 FOLSOM ST | F | F | - | F | 5671000 | 5671000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SHERMAN ST | SHERMAN ST | 81108 | 81108 | 37.77728947 | -122.40715422 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | SHERMAN ST to MOSS ST (1061 - 1078) | - | START 80FT WEST OF SHERMANN/20FT O.C | - | - | - | - | - | 17078 | 1524050700000 | -122.40715422 | 37.77728947 | - | 1611619200000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1523972400000 | FOLSOM ST | 1061 - 1078 FOLSOM ST | 1061 - 1078 FOLSOM ST | 1061 FOLSOM ST | - | MOSS ST | MOSS ST |
| 8 | N/A | Point | 1 | 1 | 1038 - 1051 | - | S244807 | 1038-1051 FOLSOM ST | 1038-1051 FOLSOM ST | F | F | - | F | 5669000 | 5669000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | COLUMBIA SQUARE ST | COLUMBIA SQUARE ST | 81109 | 81109 | 37.77774274 | -122.4065804 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | COLUMBIA SQUARE ST to RUSS ST (1038 - 1051) | - | START 8FT EAST OF SHERMANN/20FT O.C | - | - | - | - | - | 17079 | 1524050760000 | -122.4065804 | 37.77774274 | - | 1611619200000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1523972520000 | FOLSOM ST | 1038 - 1051 FOLSOM ST | 1038 - 1051 FOLSOM ST | 1038 FOLSOM ST | - | RUSS ST | RUSS ST |
| 9 | N/A | Point | - | 1 | 400 - 499 | - | S244808 | 410-499 DE LONG ST | 400-499 DE LONG ST | F | F | - | F | 4654000 | 4654000 | - | - | SOUTH SIDE | - | - | - | - | SANTA CRUZ AVE | SANTA CRUZ AVE | 81110 | 81110 | 37.70908298 | -122.46606639 | - | - | 1710539427000 | MTA | 2 HR PRK 9AM-5PM MON-FRI EXC "B" PERMITS | SANTA CRUZ AVE to SAN DIEGO AVE (400 - 499) | - | IFO 491 | - | - | - | - | - | 17080 | 1223510400000 | -122.46606639 | 37.70908298 | - | 1524614400000 | - | D11 | - | PARKING:RPP | REG | R32C(CA).0156 | 18X21 | SUP2 | UTILITY POLE | IS | 1523972580000 | DE LONG ST | 400 - 499 DE LONG ST | 400 - 499 DE LONG ST | 400 DE LONG ST | - | SAN DIEGO AVE | SAN DIEGO AVE |
| 10 | N/A | Point | 1 | 1 | 700 - 799 | - | S258885 | 700-799 CLEMENT ST | 700-799 CLEMENT ST | F | F | - | F | 4157000 | 4157000 | - | - | SOUTH SIDE | - | - | - | - | 8TH AVE | 08TH AVE | 86083 | 86083 | 37.78282583 | -122.46709588 | - | - | 1710539427000 | MTA | BIKE RACK | 08TH AVE to 09TH AVE (700 - 799) | 76735 | 19' E OF EPL #745/ 3.5' IN FROM CURB | - | - | - | - | - | 17081 | 1573727940000 | -122.46709588 | 37.78282583 | - | - | - | D1 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1572443580000 | CLEMENT ST | 700 - 799 CLEMENT ST | 700 - 799 CLEMENT ST | 700 CLEMENT ST | - | 09TH AVE | 09TH AVE |
| 11 | N/A | Point | 1 | 1 | 900 - 935 | - | S256937 | 900-935 HOWARD ST | 900-935 HOWARD ST | T | T | - | F | 7041000 | 7041000 | - | - | SOUTH SIDE | - | - | - | - | 5TH ST | 05TH ST | 86085 | 86085 | 37.78118894 | -122.40532604 | - | - | 1753133409000 | middleware_editor | LEFT LANE MUST TURN LEFT | 05TH ST to MARY ST (900 - 935) | - | EPL# 933 HOWARD ST. | - | - | - | - | - | 17082 | 1565792040000 | -122.40532604 | 37.78118894 | - | - | - | D6 | - | OTHER REGULATORY | REG | R3-7.0003 | 36X36 | SUP1 | LIGHT POLE | IS | 1565265120000 | HOWARD ST | 900 - 935 HOWARD ST | 900 - 935 HOWARD ST | 900 HOWARD ST | - | MARY ST | MARY ST |
| 12 | N/A | Point | - | - | - | - | S256940 | 17TH ST: CAROLINA ST | - | F | F | - | F | 23750000 | 23750000 | - | - | SOUTH SIDE | - | - | - | - | CAROLINA ST | 17TH ST | 86086 | 86086 | 37.76489751 | -122.40063332 | 17TH ST \ CAROLINA ST | CAROLINA ST \ 17TH ST | 1721159713000 | middleware_editor | FG 300 UR DELINEATOR (W) | 17TH ST intersection | - | START @ W-LINE, X-WALK 5' OC | - | - | - | - | - | 17083 | 1576496280000 | -122.40063332 | 37.76489751 | - | - | 1717679400000 | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | RETD | 1565270040000 | CAROLINA ST | - | - | - | - | - | - |
| 13 | N/A | Point | 1 | 1 | 200 - 299 | - | S257160 | 200-299 DRUMM ST | 200-299 DRUMM ST | F | T | - | F | 4972000 | 4972000 | - | - | EAST SIDE | - | - | - | - | CLAY ST | CLAY ST | 86088 | 86088 | 37.79590649 | -122.39686471 | - | - | 1747426592000 | middleware_editor | RIGHT LANE MUST TURN RIGHT | CLAY ST to WASHINGTON ST (200 - 299) | - | 117' N OF CLAY | - | - | - | - | - | 17084 | - | -122.39686471 | 37.79590649 | - | - | - | D3 | - | OTHER REGULATORY | REG | R3-7.0005 | 30X30 | SUP1 | LIGHT POLE | IS | 1566213060000 | DRUMM ST | 200 - 299 DRUMM ST | 200 - 299 DRUMM ST | 200 DRUMM ST | - | WASHINGTON ST | WASHINGTON ST |
| 14 | N/A | Point | 1 | 1 | 1 - 199 | - | S256951 | 1-199 MENDELL ST | 1-199 MENDELL ST | F | F | - | F | 8954000 | 8954000 | - | - | EAST SIDE | - | - | - | - | CARGO WAY | CARGO WAY | 86089 | 86089 | 37.74315699 | -122.38356386 | - | - | 1736812019000 | middleware_editor | NPRK 2AM-6AM THUR STCL | CARGO WAY to NEWHALL ST (1 - 199) | - | 90' SOUTH OF CARGO WAY | - | - | - | - | - | 17085 | 1258329600000 | -122.38356386 | 37.74315699 | - | 1736732700000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0129 | 18X18 | SUP1 | 2IN IRON POST | IS | 1565344440000 | MENDELL ST | 1 - 199 MENDELL ST | 1 - 199 MENDELL ST | 1 MENDELL ST | - | NEWHALL ST | NEWHALL ST |
| 15 | N/A | Point | 1 | 1 | 100 - 199 | - | S256967 | 100-199 EDDY ST | 100-199 EDDY ST | F | F | - | F | 5059000 | 5059000 | - | - | NORTH SIDE | - | - | - | - | MASON ST | MASON ST | 86090 | 86090 | 37.78424514 | -122.4101304 | - | - | 1722992442000 | middleware_editor | TANP ANY TIME | MASON ST to TAYLOR ST (100 - 199) | - | 25' EAST OF TAYLOR ST. | - | - | - | - | - | 17086 | 1447977600000 | -122.4101304 | 37.78424514 | - | 1565568000000 | - | D6 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP1 | LIGHT POLE | IS | 1565347740000 | EDDY ST | 100 - 199 EDDY ST | 100 - 199 EDDY ST | 100 EDDY ST | - | TAYLOR ST | TAYLOR ST |
| 16 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S268838 | 1700-1799 BALBOA ST | 1700-1799 BALBOA ST | F | F | - | F | 2663000 | 2663000 | - | - | SOUTH SIDE | - | - | - | - | 18TH AVE | 18TH AVE | 86094 | 86094 | 37.77661959 | -122.47749906 | - | - | 1720832268000 | middleware_editor | BIKE RACK | 18TH AVE to 19TH AVE (1700 - 1799) | 222048 | 44' E OF WPL 1709/3' IN FROM CURB | - | - | - | - | - | 17087 | 1601983620000 | -122.47749906 | 37.77661959 | - | - | - | D1 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1601907600000 | BALBOA ST | 1700 - 1799 BALBOA ST | 1700 - 1799 BALBOA ST | 1700 BALBOA ST | - | 19TH AVE | 19TH AVE |
| 17 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S268839 | 1200-1299 20TH AVE | 1200-1299 20TH AVE | F | F | - | F | 1005000 | 1005000 | - | - | EAST SIDE | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 86095 | 86095 | 37.76445695 | -122.47825782 | - | - | 1710539427000 | MTA | BIKE RACK | LINCOLN WAY to IRVING ST (1200 - 1299) | 210851 | 3' N OF SPL 1258/3' IN FROM CURB | - | - | - | - | - | 17088 | 1601942400000 | -122.47825782 | 37.76445695 | - | - | - | D4 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1601907720000 | 20TH AVE | 1200 - 1299 20TH AVE | 1200 - 1299 20TH AVE | 1200 20TH AVE | - | IRVING ST | IRVING ST |
| 18 | N/A | Point | 1 | 1 | 600 - 699 | LEFT ARROW | S258901 | 600-699 34TH AVE | 600-699 34TH AVE | F | F | - | F | 1743000 | 1743000 | - | - | WEST SIDE | - | - | - | - | ANZA ST | ANZA ST | 86098 | 86098 | 37.77679376 | -122.49417175 | - | - | 1710539427000 | MTA | TA (SYM) PLO 7:30AM-9:30AM/4:30PM-6:30PM MON -FRI (5 MIN) | ANZA ST to BALBOA ST (600 - 699) | - | 98 FT NORTH OF BALBOA SPL 679 | - | - | - | - | - | 17089 | 1221523200000 | -122.49417175 | 37.77679376 | - | 1572566400000 | - | D1 | - | OTHER REGULATORY | REG | R38(SF)1.0181 | 14X21 | SUP2 | 2IN IRON POST | IS | 1572600660000 | 34TH AVE | 600 - 699 34TH AVE | 600 - 699 34TH AVE | 600 34TH AVE | - | BALBOA ST | BALBOA ST |
| 19 | N/A | Point | - | - | - | - | S255295 | DOLORES ST: CESAR CHAVEZ ST | - | F | F | - | F | 21901000 | 21901000 | - | - | WEST SIDE | - | - | - | - | CESAR CHAVEZ ST | DOLORES ST | 86101 | 86101 | 37.7478303 | -122.42476828 | DOLORES ST \ CESAR CHAVEZ ST | CESAR CHAVEZ ST \ DOLORES ST | 1710539427000 | MTA | NPRK 7AM-9AM WED STCL | DOLORES ST intersection | - | NPL 1342 | - | - | - | - | - | 17090 | 1456185600000 | -122.42476828 | 37.7478303 | - | 1569974400000 | - | D8 | - | STREET CLEANING | REG | R30B(CA).0246 | 18X18 | SUP2 | 2 POST ALUMINUM | IS | 1560424140000 | CESAR CHAVEZ ST | - | - | - | - | - | - |
| 20 | N/A | Point | 1 | 1 | 100 - 199 | - | S257708 | 100-199 ARKANSAS ST | 100-199 ARKANSAS ST | F | F | - | F | 2436000 | 2436000 | - | - | EAST SIDE | - | - | - | - | 17TH ST | 17TH ST | 86102 | 86102 | 37.76437484 | -122.39864189 | - | - | 1738192467000 | middleware_editor | NPRK 8AM-10AM WED STCL | 17TH ST to MARIPOSA ST (100 - 199) | - | SPL#151 | - | - | - | - | - | 17091 | 1053302400000 | -122.39864189 | 37.76437484 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP1 | 2IN IRON POST | IS | 1568214780000 | ARKANSAS ST | 100 - 199 ARKANSAS ST | 100 - 199 ARKANSAS ST | 100 ARKANSAS ST | - | MARIPOSA ST | MARIPOSA ST |
| 21 | N/A | Point | - | - | - | - | S257709 | POTRERO AVE: 17TH ST | - | T | T | - | F | 24020000 | 24020000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 17TH ST | 17TH ST | 86103 | 86103 | 37.76448783 | -122.40741974 | POTRERO AVE \ 17TH ST | POTRERO AVE \ 17TH ST | 1710539427000 | MTA | POTRERO AVE | 17TH ST intersection | - | - | - | - | - | - | - | 17092 | 952732800000 | -122.40741974 | 37.76448783 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-2.0284 | 72X18 | SUP1 | LIGHT POLE | IS | 1568215080000 | POTRERO AVE | - | - | - | - | - | - |
| 22 | N/A | Point | - | - | - | - | S282364 | MARKET ST: 16TH ST \ NOE ST | - | T | T | - | F | 25804000 | 25804000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 16TH ST \ MARKET ST | 16TH ST \ MARKET ST | 86764 | 86764 | 37.76419571 | -122.43307447 | NOE ST \ 16TH ST \ MARKET ST | NOE ST \ 16TH ST \ MARKET ST | 1715044064000 | middleware_editor | SPEED LIMIT 20 | 16TH ST \ MARKET ST intersection | - | MARKET AND NOE | - | - | - | - | - | 17093 | 1650499200000 | -122.43307447 | 37.76419571 | - | - | - | D8 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP2 | OVERHEAD MAST ARM | IS | 1650533580000 | NOE ST | - | - | - | - | - | - |
| 23 | N/A | Point | - | - | - | - | S282366 | MARKET ST: 16TH ST \ NOE ST | - | T | T | - | F | 25804000 | 25804000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 16TH ST \ MARKET ST | 16TH ST \ MARKET ST | 86765 | 86765 | 37.76419571 | -122.43307447 | NOE ST \ 16TH ST \ MARKET ST | NOE ST \ 16TH ST \ MARKET ST | 1715044067000 | middleware_editor | SPEED LIMIT 20 | 16TH ST \ MARKET ST intersection | - | MARKET AND NOE | - | - | - | - | - | 17094 | 1650499200000 | -122.43307447 | 37.76419571 | - | - | - | D8 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP2 | OVERHEAD MAST ARM | IS | 1650533760000 | NOE ST | - | - | - | - | - | - |
| 24 | N/A | Point | - | - | - | - | S282375 | MARKET ST: RESERVOIR ST | - | T | T | - | F | 25877000 | 25877000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MARKET ST | MARKET ST | 86769 | 86769 | 37.7687705 | -122.42746206 | RESERVOIR ST \ MARKET ST | RESERVOIR ST \ MARKET ST | 1729216087000 | middleware_editor | SPEED LIMIT 20 | MARKET ST intersection | - | - | - | - | - | - | - | 17095 | 1650499200000 | -122.42746206 | 37.7687705 | - | - | - | D8 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP2 | OVERHEAD MAST ARM | IS | 1650535020000 | RESERVOIR ST | - | - | - | - | - | - |
| 25 | N/A | Point | - | - | - | - | S258824 | 5TH ST: MINNA ST | - | F | F | - | F | 24633000 | 24633000 | - | - | NORTH EAST CORNER | - | - | - | - | 5TH ST | 05TH ST | 86771 | 86771 | 37.78229614 | -122.40593133 | MINNA ST \ 5TH ST | MINNA ST \ 05TH ST | 1721159205000 | middleware_editor | MINNA ST | 05TH ST intersection | - | - | - | - | - | - | - | 17096 | 1323820800000 | -122.40593133 | 37.78229614 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.1194 | 36X08 | SUP1 | 3IN IRON POST | IS | 1572428040000 | MINNA ST | - | - | - | - | - | - |
| 26 | N/A | Point | - | - | - | - | S258825 | 5TH ST: MINNA ST | - | F | F | - | F | 24633000 | 24633000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 5TH ST | 05TH ST | 86772 | 86772 | 37.78229614 | -122.40593133 | MINNA ST \ 5TH ST | MINNA ST \ 05TH ST | 1724081302000 | middleware_editor | ONE WAY (RA) | 05TH ST intersection | - | - | - | - | - | - | - | 17097 | 1323820800000 | -122.40593133 | 37.78229614 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | 3IN IRON POST | IS | 1572428100000 | MINNA ST | - | - | - | - | - | - |
| 27 | N/A | Point | - | - | - | - | S258826 | 5TH ST: MINNA ST | - | F | F | - | F | 24633000 | 24633000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 5TH ST | 05TH ST | 86773 | 86773 | 37.78229614 | -122.40593133 | MINNA ST \ 5TH ST | MINNA ST \ 05TH ST | 1724115734000 | middleware_editor | (RA) TURNING VEHICLES YIELD (SYM) TO PED & BIKE (SYM) | 05TH ST intersection | - | - | - | - | - | - | - | 17098 | 1323820800000 | -122.40593133 | 37.78229614 | - | 1576627200000 | - | D6 | - | PEDESTRIAN | REG | R10-15.0003 | 30X30 | SUP1 | 3IN IRON POST | IS | 1572428160000 | MINNA ST | - | - | - | - | - | - |
| 28 | N/A | Point | - | - | - | - | S258828 | 5TH ST: MINNA ST | - | F | F | - | F | 24633000 | 24633000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 5TH ST | 05TH ST | 86774 | 86774 | 37.78229614 | -122.40593133 | MINNA ST \ 5TH ST | MINNA ST \ 05TH ST | 1724115733000 | middleware_editor | (LA) TURNING VEHICLES YIELD (SYM) TO PED & BIKE (SYM) | 05TH ST intersection | - | - | - | - | - | - | - | 17099 | 1323820800000 | -122.40593133 | 37.78229614 | - | 1576627200000 | - | D6 | - | PEDESTRIAN | REG | R10-15.0004 | 30X30 | SUP1 | 2IN FLANGE POST | IS | 1572428340000 | MINNA ST | - | - | - | - | - | - |
| 29 | N/A | Point | - | - | - | - | S258829 | 5TH ST: MINNA ST | - | F | F | - | F | 24633000 | 24633000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 5TH ST | 05TH ST | 86775 | 86775 | 37.78229614 | -122.40593133 | MINNA ST \ 5TH ST | MINNA ST \ 05TH ST | 1724115733000 | middleware_editor | NO LEFT TURN (SYM) | 05TH ST intersection | - | - | - | - | - | - | - | 17100 | 1323820800000 | -122.40593133 | 37.78229614 | - | 1576627200000 | - | D6 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1572428460000 | MINNA ST | - | - | - | - | - | - |
| 30 | N/A | Point | - | - | - | - | S258655 | 11TH ST: FOLSOM ST | - | T | T | - | F | 24238000 | 24238000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FOLSOM ST | FOLSOM ST | 86777 | 86777 | 37.77186371 | -122.41402671 | 11TH ST \ FOLSOM ST | 11TH ST \ FOLSOM ST | 1710539427000 | MTA | 11TH ST | FOLSOM ST intersection | - | - | - | - | - | - | - | 17101 | 1513296000000 | -122.41402671 | 37.77186371 | - | 1513296000000 | - | D6 | - | STREET NAME | GUIDE | D3-1.1987 | 36X08 | SUP1 | SIGNAL POLE | IS | 1571930700000 | 11TH ST | - | - | - | - | - | - |
| 31 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S151092 | 1300-1399 40TH AVE | 1300-1399 40TH AVE | F | F | - | F | 1890000 | 1890000 | - | - | EAST SIDE | - | - | - | - | IRVING ST | IRVING ST | 86778 | 86778 | 37.76163901 | -122.49956205 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM 1ST & 3RD FRI OF MONTH STCL | IRVING ST to JUDAH ST (1300 - 1399) | - | 1378 40TH AVE | - | - | - | - | - | 17102 | 1228262400000 | -122.49956205 | 37.76163901 | - | 1686787200000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0065 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375730100000 | 40TH AVE | 1300 - 1399 40TH AVE | 1300 - 1399 40TH AVE | 1300 40TH AVE | - | JUDAH ST | JUDAH ST |
| 32 | N/A | Point | - | - | - | - | S272744 | POLK ST: SUTTER ST | - | T | T | - | F | 25208000 | 25208000 | - | - | SOUTH WEST CORNER | - | - | - | - | SUTTER ST | SUTTER ST | 86782 | 86782 | 37.78775665 | -122.42011608 | POLK ST \ SUTTER ST | POLK ST \ SUTTER ST | 1710539427000 | MTA | SUTTER ST | SUTTER ST intersection | - | - | - | - | - | - | - | 17103 | 1585267200000 | -122.42011608 | 37.78775665 | - | - | - | D3 | - | STREET NAME | GUIDE | D3-1.1694 | 36X08 | SUP1 | LIGHT POLE | IS | 1614604440000 | POLK ST | - | - | - | - | - | - |
| 33 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S268619 | 1600-1699 STEINER ST | 1600-1699 STEINER ST | F | F | - | F | 12134000 | 12134000 | - | - | EAST SIDE | - | - | - | - | GEARY BLVD | GEARY BLVD | 87381 | 87381 | 37.78454794 | -122.43464605 | - | - | 1710539427000 | MTA | (H/C SYM) PARK ONLY/MIN FINE $250 | GEARY BLVD to POST ST (1600 - 1699) | - | 17' NORTH OF GEARY | - | - | - | - | - | 17104 | 1601596800000 | -122.43464605 | 37.78454794 | - | - | - | D5 | - | OTHER REGULATORY | REG | R99C(CA).0001 | 12X24 | SUP1 | 2IN IRON POST | IS | 1601466000000 | STEINER ST | 1600 - 1699 STEINER ST | 1600 - 1699 STEINER ST | 1600 STEINER ST | - | POST ST | POST ST |
| 34 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S268621 | 1600-1699 STEINER ST | 1600-1699 STEINER ST | F | F | - | F | 12134000 | 12134000 | - | - | WEST SIDE | - | - | - | - | GEARY BLVD | GEARY BLVD | 87383 | 87383 | 37.78454794 | -122.43464605 | - | - | 1710539427000 | MTA | NPRK 6AM-8AM TUE STCL | GEARY BLVD to POST ST (1600 - 1699) | - | 40' SOUTH OF POST | - | - | - | - | - | 17105 | - | -122.43464605 | 37.78454794 | - | 1708007820000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0191 | 18X18 | SUP1 | 2IN IRON POST | IS | 1601466840000 | STEINER ST | 1600 - 1699 STEINER ST | 1600 - 1699 STEINER ST | 1600 STEINER ST | - | POST ST | POST ST |
| 35 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S268622 | 1500-1599 SCOTT ST | 1500-1599 SCOTT ST | F | F | - | F | 11698000 | 11698000 | - | - | EAST SIDE | - | - | - | - | GEARY BLVD | GEARY BLVD | 87384 | 87384 | 37.78412428 | -122.43793381 | - | - | 1710539427000 | MTA | (H/C SYM) PARK ONLY/MIN FINE $250 | GEARY BLVD to POST ST (1500 - 1599) | - | 47' N OF GEARY | - | - | - | - | - | 17106 | - | -122.43793381 | 37.78412428 | - | - | - | D5 | - | OTHER REGULATORY | REG | R99C(CA).0001 | 12X24 | SUP1 | 2IN IRON POST | IS | 1601467920000 | SCOTT ST | 1500 - 1599 SCOTT ST | 1500 - 1599 SCOTT ST | 1500 SCOTT ST | - | POST ST | POST ST |
| 36 | N/A | Point | - | - | - | - | S268750 | VAN NESS AVE: FILBERT ST | - | T | T | - | F | 26685000 | 26685000 | - | - | WEST SIDE | - | - | - | - | FILBERT ST | FILBERT ST | 87385 | 87385 | 37.79948453 | -122.42417056 | VAN NESS AVE \ FILBERT ST | VAN NESS AVE \ FILBERT ST | 1710539427000 | MTA | VAN NESS AVE | FILBERT ST intersection | - | CENTER LINE OF NORTH POINT/ I>3200 | - | - | - | - | - | 17107 | 1500336000000 | -122.42417056 | 37.79948453 | - | 1500336000000 | - | D2 | - | STREET NAME | GUIDE | D3-1.1784 | 36X08 | SUP1 | MUNI POLE | IS | 1601649600000 | VAN NESS AVE | - | - | - | - | - | - |
| 37 | N/A | Point | - | - | - | - | S258450 | BAY SHORE BLVD: LOIS LN | - | F | F | - | F | 53016000 | 53016000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LOIS LN | BAY SHORE BLVD | 87386 | 87386 | 37.71385776 | -122.39975545 | BAY SHORE BLVD \ LOIS LN | LOIS LN \ BAY SHORE BLVD | 1710539427000 | MTA | ONE WAY (RA) | BAY SHORE BLVD intersection | - | X-STREET IS LOIS LN | - | - | - | - | - | 17108 | 1571928840000 | -122.39975545 | 37.71385776 | - | - | - | D10 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | 3IN IRON POST | IS | 1571471220000 | LOIS LN | - | - | - | - | - | - |
| 38 | N/A | Point | - | - | - | - | S283412 | MARKET ST: GUERRERO ST \ LAGUN | - | T | T | - | F | 30757000 | 30757000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GUERRERO ST \ MARKET ST | LAGUNA ST \ MARKET ST | 87387 | 87387 | 37.77074775 | -122.4248526 | LAGUNA ST \ GUERRERO ST \ MARKET ST | GUERRERO ST \ LAGUNA ST \ MARKET ST | 1710539427000 | MTA | GUERRERO ST | LAGUNA ST \ MARKET ST intersection | - | - | - | - | - | - | - | 17109 | 1656547200000 | -122.4248526 | 37.77074775 | - | - | - | D8 | - | STREET NAME | GUIDE | D3-2.0178 | 72X18 | SUP2 | OVERHEAD MAST ARM | IS | 1655206260000 | GUERRERO ST | - | - | - | - | - | - |
| 39 | N/A | Point | - | - | - | - | S283414 | GUERRERO ST: LAGUNA ST \ MARKE | - | F | F | - | F | 30757000 | 30757000 | - | - | SOUTH EAST CORNER | - | - | - | - | GUERRERO ST \ MARKET ST | LAGUNA ST \ MARKET ST | 87388 | 87388 | 37.77074775 | -122.4248526 | LAGUNA ST \ GUERRERO ST \ MARKET ST | GUERRERO ST \ LAGUNA ST \ MARKET ST | 1710539427000 | MTA | GUERRERO ST | LAGUNA ST \ MARKET ST intersection | - | - | - | - | - | - | - | 17110 | - | -122.4248526 | 37.77074775 | - | 1686182400000 | - | D8 | - | STREET NAME | GUIDE | D3-1.0779 | 36X08 | SUP2 | SIGNAL POLE | IS | 1655206860000 | GUERRERO ST | - | - | - | - | - | - |
| 40 | N/A | Point | 1 | 1 | 2500 - 2599 | - | S283415 | 2500-2599 MORAGA ST | 2500-2599 MORAGA ST | F | F | - | F | 9356000 | 9356000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | 31ST AVE | 31ST AVE | 87389 | 87389 | 37.7555169 | -122.48999654 | - | - | 1727139795000 | middleware_editor | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | 31ST AVE to 32ND AVE (2500 - 2599) | - | EPL# 2530 MORAGA | - | - | - | - | - | 17111 | - | -122.48999654 | 37.7555169 | - | - | - | D4 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | 2IN IRON POST | IS | 1655206860000 | MORAGA ST | 2500 - 2599 MORAGA ST | 2500 - 2599 MORAGA ST | 2500 MORAGA ST | - | 32ND AVE | 32ND AVE |
| 41 | N/A | Point | - | - | - | - | S281417 | VAN NESS AVE: GROVE ST | - | F | F | - | F | 24459000 | 24459000 | - | - | CENTER ISLAND, S LINE, NORTHBOUND | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 87390 | 87390 | 37.77825102 | -122.41988323 | GROVE ST \ VAN NESS AVE | GROVE ST \ VAN NESS AVE | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | VAN NESS AVE intersection | - | - | - | - | - | - | - | 17112 | 1654300800000 | -122.41988323 | 37.77825102 | - | - | - | D5 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1646837220000 | GROVE ST | - | - | - | - | - | - |
| 42 | N/A | Point | 1 | 1 | 627 - 649 | - | S270596 | 627-649 HOWARD ST | 627-649 HOWARD ST | T | T | - | F | 7036000 | 7036000 | - | - | NORTH SIDE | - | - | - | - | NEW MONTGOMERY ST | NEW MONTGOMERY ST | 87391 | 87391 | 37.78605437 | -122.39917335 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM MON WED FRI STCL | NEW MONTGOMERY ST to HAWTHORNE ST (627 - 649) | - | 50 FT WEST OF | - | - | - | - | - | 17113 | 1546473600000 | -122.39917335 | 37.78605437 | - | - | - | D6 | - | STREET CLEANING | REG | R30B(CA).0123 | 18X18 | SUP1 | LIGHT POLE | IS | 1606910340000 | HOWARD ST | 627 - 649 HOWARD ST | 627 - 649 HOWARD ST | 627 HOWARD ST | - | HAWTHORNE ST | HAWTHORNE ST |
| 43 | N/A | Point | 1 | 1 | 300 - 399 | RIGHT ARROW | S270777 | 300-399 VERMONT ST | 300-399 VERMONT ST | F | F | - | F | 13211000 | 13211000 | - | - | EAST SIDE | - | - | - | - | 16TH ST | 16TH ST | 87392 | 87392 | 37.76531126 | -122.40456016 | - | - | 1710539427000 | MTA | TANS EXC 30 MIN COMMERCIAL VEH 8AM-5PM MON-FRI | 16TH ST to 17TH ST (300 - 399) | - | NPL# 343 VERMONT ST. | - | - | - | - | - | 17114 | 1611831960000 | -122.40456016 | 37.76531126 | - | - | - | D10 | - | OTHER REGULATORY | REG | R37(SF).0345 | 18X21 | SUP1 | 2IN IRON POST | IS | 1607944860000 | VERMONT ST | 300 - 399 VERMONT ST | 300 - 399 VERMONT ST | 300 VERMONT ST | - | 17TH ST | 17TH ST |
| 44 | N/A | Point | 1 | 1 | 300 - 399 | LEFT ARROW | S270778 | 300-399 VERMONT ST | 300-399 VERMONT ST | F | F | - | F | 13211000 | 13211000 | - | - | EAST SIDE | - | - | - | - | 16TH ST | 16TH ST | 87393 | 87393 | 37.76531126 | -122.40456016 | - | - | 1710539427000 | MTA | TANS EXC 30 MIN COMMERCIAL VEH 8AM-5PM MON-FRI | 16TH ST to 17TH ST (300 - 399) | - | 8' SOUTH OF SPL# 345 VERMONT ST. | - | - | - | - | - | 17115 | 1614949920000 | -122.40456016 | 37.76531126 | - | - | - | D10 | - | OTHER REGULATORY | REG | R37(SF).0345 | 18X21 | SUP1 | 2IN IRON POST | IS | 1607945220000 | VERMONT ST | 300 - 399 VERMONT ST | 300 - 399 VERMONT ST | 300 VERMONT ST | - | 17TH ST | 17TH ST |
| 45 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S284176 | 1300-1399 9TH AVE | 1300-1399 09TH AVE | T | T | - | F | 432000 | 432000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | IRVING ST | IRVING ST | 87394 | 87394 | 37.76310602 | -122.46624559 | - | - | 1710539427000 | MTA | SPEED LIMIT 20 | IRVING ST to JUDAH ST (1300 - 1399) | - | NPL#1319 (INSTALL NOT LESS OF 13' HGT) | - | - | - | - | - | 17116 | 1670371200000 | -122.46624559 | 37.76310602 | - | - | - | D5 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | MUNI POLE | IS | 1659007740000 | 09TH AVE | 1300 - 1399 9TH AVE | 1300 - 1399 09TH AVE | 1300 9TH AVE | - | JUDAH ST | JUDAH ST |
| 46 | N/A | Point | 1 | 1 | 50 - 99 | - | S284177 | 50-99 ROSSMOOR DR | 50-99 ROSSMOOR DR | T | T | - | F | 11171000 | 11171000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | ELMHURST DR | ELMHURST DR | 87395 | 87395 | 37.73054658 | -122.47403982 | - | - | 1710539427000 | MTA | RAILROAD CROSSING ADVANCE | ELMHURST DR to 19TH AVE (50 - 99) | - | EPL 88 | - | - | - | - | - | 17117 | 1666051200000 | -122.47403982 | 37.73054658 | - | - | - | D7 | - | OTHER WARNING | WARNING | W10-1.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1659008340000 | ROSSMOOR DR | 50 - 99 ROSSMOOR DR | 50 - 99 ROSSMOOR DR | 50 ROSSMOOR DR | - | 19TH AVE | 19TH AVE |
| 47 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S284178 | 1400-1499 9TH AVE | 1400-1499 09TH AVE | T | T | - | F | 433000 | 433000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | JUDAH ST | JUDAH ST | 87396 | 87396 | 37.76124331 | -122.46611547 | - | - | 1710539427000 | MTA | SPEED LIMIT 25 | JUDAH ST to KIRKHAM ST (1400 - 1499) | - | 1417 9TH AVE ABOVE STREET CLEANING SIGN. | - | - | - | - | - | 17118 | 1224547200000 | -122.46611547 | 37.76124331 | - | - | - | D5 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP1 | MUNI POLE | IS | 1659008520000 | 09TH AVE | 1400 - 1499 9TH AVE | 1400 - 1499 09TH AVE | 1400 9TH AVE | - | KIRKHAM ST | KIRKHAM ST |
| 48 | N/A | Point | - | - | - | - | S106888 | PLYMOUTH AVE: LOBOS ST | - | F | F | - | F | 21596000 | 21596000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PLYMOUTH AVE | PLYMOUTH AVE | 4417 | 4417 | 37.71490467 | -122.456072 | LOBOS ST \ PLYMOUTH AVE | LOBOS ST \ PLYMOUTH AVE | 1720573295000 | middleware_editor | STOP | PLYMOUTH AVE intersection | - | - | - | - | - | - | - | 17119 | 179366400000 | -122.456072 | 37.71490467 | - | 1636934400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569680000 | LOBOS ST | - | - | - | - | - | - |
| 49 | N/A | Point | - | - | - | - | S106889 | PLYMOUTH AVE: LOBOS ST | - | F | F | - | F | 21596000 | 21596000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | PLYMOUTH AVE | PLYMOUTH AVE | 4418 | 4418 | 37.71490467 | -122.456072 | LOBOS ST \ PLYMOUTH AVE | LOBOS ST \ PLYMOUTH AVE | 1750714096000 | middleware_editor | STOP | PLYMOUTH AVE intersection | - | 0 / 0 | - | - | - | - | - | 17120 | 179391600000 | -122.456072 | 37.71490467 | - | 1750703400000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569680000 | LOBOS ST | - | - | - | - | - | - |
| 50 | N/A | Point | - | - | - | - | S106890 | LOBOS ST: PLYMOUTH AVE | - | F | F | - | F | 21596000 | 21596000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PLYMOUTH AVE | PLYMOUTH AVE | 4419 | 4419 | 37.71490467 | -122.456072 | LOBOS ST \ PLYMOUTH AVE | LOBOS ST \ PLYMOUTH AVE | 1720573331000 | middleware_editor | STOP | PLYMOUTH AVE intersection | - | 0 / 0 | - | - | - | - | - | 17121 | 179366400000 | -122.456072 | 37.71490467 | - | 1191196800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569680000 | LOBOS ST | - | - | - | - | - | - |
| 51 | N/A | Point | - | - | - | - | S106891 | LOBOS ST: PLYMOUTH AVE | - | F | F | - | F | 21596000 | 21596000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | PLYMOUTH AVE | PLYMOUTH AVE | 4420 | 4420 | 37.71490467 | -122.456072 | LOBOS ST \ PLYMOUTH AVE | LOBOS ST \ PLYMOUTH AVE | 1720647693000 | middleware_editor | STOP | PLYMOUTH AVE intersection | - | 0 / 0 | - | - | - | - | - | 17122 | 179366400000 | -122.456072 | 37.71490467 | - | 1720604100000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569680000 | LOBOS ST | - | - | - | - | - | - |
| 52 | N/A | Point | - | - | - | - | S106895 | MURRAY ST: RICHLAND AVE | - | F | F | - | F | 21232000 | 21232000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MURRAY ST | MURRAY ST | 4423 | 4423 | 37.73577688 | -122.42016347 | RICHLAND AVE \ MURRAY ST | RICHLAND AVE \ MURRAY ST | 1713298821000 | middleware_editor | STOP | MURRAY ST intersection | - | - | - | - | - | - | - | 17123 | 179539200000 | -122.42016347 | 37.73577688 | - | - | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569680000 | RICHLAND AVE | - | - | - | - | - | - |
| 53 | N/A | Point | - | - | - | - | S106896 | ASHTON AVE: HOLLOWAY AVE | - | F | F | - | F | 22613000 | 22613000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HOLLOWAY AVE | ASHTON AVE | 4424 | 4424 | 37.7218278 | -122.46226549 | ASHTON AVE \ HOLLOWAY AVE | HOLLOWAY AVE \ ASHTON AVE | 1710539427000 | MTA | STOP | ASHTON AVE intersection | - | 0 / 0 | - | - | - | - | - | 17124 | 180057600000 | -122.46226549 | 37.7218278 | - | 1156723200000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569680000 | HOLLOWAY AVE | - | - | - | - | - | - |
| 54 | N/A | Point | - | - | - | - | S106898 | BROAD ST: CAPITOL AVE | - | F | F | - | F | 22476000 | 22476000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BROAD ST | BROAD ST | 4426 | 4426 | 37.71317205 | -122.45902444 | CAPITOL AVE \ BROAD ST | CAPITOL AVE \ BROAD ST | 1710539427000 | MTA | STOP | BROAD ST intersection | - | 0 / 0 | - | - | - | - | - | 17125 | 180057600000 | -122.45902444 | 37.71317205 | - | 1485388800000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | MUNI POLE | IS | 1373569680000 | CAPITOL AVE | - | - | - | - | - | - |
| 55 | N/A | Point | - | - | - | - | S106899 | BROAD ST: CAPITOL AVE | - | F | F | - | F | 22476000 | 22476000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BROAD ST | BROAD ST | 4427 | 4427 | 37.71317205 | -122.45902444 | CAPITOL AVE \ BROAD ST | CAPITOL AVE \ BROAD ST | 1710539427000 | MTA | STOP | BROAD ST intersection | - | 0 / 0 | - | - | - | - | - | 17126 | 180057600000 | -122.45902444 | 37.71317205 | - | 1439424000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | MUNI POLE | IS | 1373569680000 | CAPITOL AVE | - | - | - | - | - | - |
| 56 | N/A | Point | - | - | - | - | S107396 | 20TH AVE: RIVERA ST | - | F | F | - | F | 23203000 | 23203000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 20TH AVE | 20TH AVE | 4605 | 4605 | 37.74673252 | -122.47702389 | RIVERA ST \ 20TH AVE | RIVERA ST \ 20TH AVE | 1710539427000 | MTA | STOP | 20TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 17127 | 223603200000 | -122.47702389 | 37.74673252 | - | 1464307200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569860000 | RIVERA ST | - | - | - | - | - | - |
| 57 | N/A | Point | - | - | - | - | S106429 | SANTA CLARA AVE: TERRACE DR | - | F | F | - | F | 22917000 | 22917000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TERRACE DR | SANTA CLARA AVE | 4606 | 4606 | 37.73739231 | -122.46571546 | SANTA CLARA AVE \ TERRACE DR | TERRACE DR \ SANTA CLARA AVE | 1710539427000 | MTA | STOP | SANTA CLARA AVE intersection | - | 0 / 0 | - | - | - | - | - | 17128 | 139190400000 | -122.46571546 | 37.73739231 | - | 1304380800000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569560000 | TERRACE DR | - | - | - | - | - | - |
| 58 | N/A | Point | - | - | - | - | S106430 | 20TH AVE: VICENTE ST | - | F | F | - | F | 23168000 | 23168000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VICENTE ST | 20TH AVE | 4607 | 4607 | 37.73927734 | -122.47648597 | 20TH AVE \ VICENTE ST | VICENTE ST \ 20TH AVE | 1719277352000 | middleware_editor | STOP | 20TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 17129 | 139190400000 | -122.47648597 | 37.73927734 | - | 1677024000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569560000 | VICENTE ST | - | - | - | - | - | - |
| 59 | N/A | Point | - | - | - | - | S106431 | 20TH AVE: VICENTE ST | - | F | F | - | F | 23168000 | 23168000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | VICENTE ST | 20TH AVE | 4608 | 4608 | 37.73927734 | -122.47648597 | 20TH AVE \ VICENTE ST | VICENTE ST \ 20TH AVE | 1719277383000 | middleware_editor | STOP | 20TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 17130 | 139190400000 | -122.47648597 | 37.73927734 | - | 1464134400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569560000 | VICENTE ST | - | - | - | - | - | - |
| 60 | N/A | Point | - | - | - | - | S106432 | 22ND AVE: VICENTE ST | - | F | F | - | F | 23174000 | 23174000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VICENTE ST | 22ND AVE | 4609 | 4609 | 37.73918307 | -122.47864437 | 22ND AVE \ VICENTE ST | VICENTE ST \ 22ND AVE | 1710539427000 | MTA | STOP | 22ND AVE intersection | - | 0 / 0 | - | - | - | - | - | 17131 | 139190400000 | -122.47864437 | 37.73918307 | - | 1467244800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569560000 | VICENTE ST | - | - | - | - | - | - |
| 61 | N/A | Point | - | - | - | - | S106436 | ARKANSAS ST: MADERA ST | - | F | F | - | F | 23706000 | 23706000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | MADERA ST | ARKANSAS ST | 4611 | 4611 | 37.75589827 | -122.3978302 | ARKANSAS ST \ MADERA ST | MADERA ST \ ARKANSAS ST | 1730760072000 | middleware_editor | STOP | ARKANSAS ST intersection | - | 0 / 0 | - | - | - | - | - | 17132 | 139708800000 | -122.3978302 | 37.75589827 | - | 1730200500000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569560000 | MADERA ST | - | - | - | - | - | - |
| 62 | N/A | Point | - | - | - | - | S106437 | ARKANSAS ST: MADERA ST | - | F | F | - | F | 23706000 | 23706000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MADERA ST | ARKANSAS ST | 4612 | 4612 | 37.75589827 | -122.3978302 | ARKANSAS ST \ MADERA ST | MADERA ST \ ARKANSAS ST | 1734718193000 | middleware_editor | STOP | ARKANSAS ST intersection | - | 0 / 0 | - | - | - | - | - | 17133 | 139708800000 | -122.3978302 | 37.75589827 | - | 1734688500000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569560000 | MADERA ST | - | - | - | - | - | - |
| 63 | N/A | Point | - | - | - | - | S102258 | CLAY ST: MONTGOMERY ST | - | T | T | - | F | 24756000 | 24756000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CLAY ST | MONTGOMERY ST | 4686 | 4686 | 37.79466628 | -122.4031393 | MONTGOMERY ST \ CLAY ST | CLAY ST \ MONTGOMERY ST | 1722348520000 | middleware_editor | ONE WAY (LA) | MONTGOMERY ST intersection | - | 0 / 0 | - | - | - | - | - | 17134 | -389491200000 | -122.4031393 | 37.79466628 | - | - | - | D3 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP1 | LIGHT POLE | IS | 1373568240000 | CLAY ST | - | - | - | - | - | - |
| 64 | N/A | Point | - | - | - | - | S110183 | TALBERT ST: TALBERT CT \ VISIT | - | F | F | - | F | 20345000 | 20345000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TALBERT ST | VISITACION AVE | 9063 | 9063 | 37.71095727 | -122.40618513 | VISITACION AVE \ TALBERT ST | TALBERT ST \ VISITACION AVE | 1710539427000 | MTA | STOP | VISITACION AVE intersection | - | - | - | - | - | - | - | 17135 | 601776000000 | -122.40618513 | 37.71095727 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570700000 | TALBERT ST | - | - | - | - | - | - |
| 65 | N/A | Point | - | - | - | - | S110184 | DELTA ST: TEDDY AVE | - | F | F | - | F | 20360000 | 20360000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | TEDDY AVE | DELTA ST | 9064 | 9064 | 37.71515568 | -122.40860338 | DELTA ST \ TEDDY AVE | TEDDY AVE \ DELTA ST | 1710539427000 | MTA | STOP | DELTA ST intersection | - | - | - | - | - | - | - | 17136 | 601776000000 | -122.40860338 | 37.71515568 | - | 1159401600000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570700000 | TEDDY AVE | - | - | - | - | - | - |
| 66 | N/A | Point | - | - | - | - | S110185 | DELTA ST: TEDDY AVE | - | F | F | - | F | 20360000 | 20360000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TEDDY AVE | DELTA ST | 9065 | 9065 | 37.71515568 | -122.40860338 | DELTA ST \ TEDDY AVE | TEDDY AVE \ DELTA ST | 1710539427000 | MTA | STOP | DELTA ST intersection | - | - | - | - | - | - | - | 17137 | 601776000000 | -122.40860338 | 37.71515568 | - | 1159401600000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570700000 | TEDDY AVE | - | - | - | - | - | - |
| 67 | N/A | Point | - | - | - | - | S110188 | SOMERSET ST: WOOLSEY ST | - | F | F | - | F | 20885000 | 20885000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WOOLSEY ST | WOOLSEY ST | 9066 | 9066 | 37.72419423 | -122.40655319 | SOMERSET ST \ WOOLSEY ST | SOMERSET ST \ WOOLSEY ST | 1752608678000 | middleware_editor | STOP | WOOLSEY ST intersection | - | - | - | - | - | - | - | 17138 | 601804800000 | -122.40655319 | 37.72419423 | - | 905929200000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570700000 | SOMERSET ST | - | - | - | - | - | - |
| 68 | N/A | Point | - | - | - | - | S110189 | SOMERSET ST: WOOLSEY ST | - | F | F | - | F | 20885000 | 20885000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WOOLSEY ST | WOOLSEY ST | 9067 | 9067 | 37.72419423 | -122.40655319 | SOMERSET ST \ WOOLSEY ST | SOMERSET ST \ WOOLSEY ST | 1752608813000 | middleware_editor | STOP | WOOLSEY ST intersection | - | - | - | - | - | - | - | 17139 | 601804800000 | -122.40655319 | 37.72419423 | - | - | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570700000 | SOMERSET ST | - | - | - | - | - | - |
| 69 | N/A | Point | - | - | - | - | S110194 | ULLOA ST: WOODSIDE AVE | - | F | F | - | F | 22444000 | 22444000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WOODSIDE AVE | WOODSIDE AVE | 9071 | 9071 | 37.74569992 | -122.45391643 | ULLOA ST \ WOODSIDE AVE | ULLOA ST \ WOODSIDE AVE | 1710539427000 | MTA | STOP | WOODSIDE AVE intersection | - | - | - | - | - | - | - | 17140 | 602294400000 | -122.45391643 | 37.74569992 | - | 1521763200000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570760000 | ULLOA ST | - | - | - | - | - | - |
| 70 | N/A | Point | - | - | - | - | S110195 | ESTERO AVE: LUNADO WAY | - | F | F | - | F | 22741000 | 22741000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ESTERO AVE | ESTERO AVE | 9072 | 9072 | 37.72372007 | -122.47130404 | LUNADO WAY \ ESTERO AVE | LUNADO WAY \ ESTERO AVE | 1710539427000 | MTA | STOP | ESTERO AVE intersection | - | - | - | - | - | - | - | 17141 | 602294400000 | -122.47130404 | 37.72372007 | - | 1090972800000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570760000 | LUNADO WAY | - | - | - | - | - | - |
| 71 | N/A | Point | - | - | - | - | S110902 | DOLORES ST: 23RD ST | - | F | F | - | F | 25617000 | 25617000 | - | SHOULD BE RETIRED | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | DOLORES ST | DOLORES ST | 9073 | 9073 | 37.75343159 | -122.42530262 | 23RD ST \ DOLORES ST | 23RD ST \ DOLORES ST | 1715964874000 | middleware_editor | STOP | DOLORES ST intersection | - | SOUTH CENTER ISLAND | - | - | - | - | - | 17142 | 716169600000 | -122.42530262 | 37.75343159 | - | - | 1715939640000 | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | RETD | 1373570940000 | 23RD ST | - | - | - | - | - | - |
| 72 | N/A | Point | - | - | - | - | S110904 | 47TH AVE: SUTRO HEIGHTS AVE | - | F | F | - | F | 27991000 | 27991000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SUTRO HEIGHTS AVE | 47TH AVE | 9075 | 9075 | 37.77614912 | -122.50809174 | 47TH AVE \ SUTRO HEIGHTS AVE | SUTRO HEIGHTS AVE \ 47TH AVE | 1710539427000 | MTA | STOP | 47TH AVE intersection | - | - | - | - | - | - | - | 17143 | 716601600000 | -122.50809174 | 37.77614912 | - | 1461542400000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570940000 | SUTRO HEIGHTS AVE | - | - | - | - | - | - |
| 73 | N/A | Point | - | - | - | - | S110906 | BRUSSELS ST: WAYLAND ST | - | F | F | - | F | 20637000 | 20637000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WAYLAND ST | BRUSSELS ST | 9076 | 9076 | 37.72591546 | -122.405086 | BRUSSELS ST \ WAYLAND ST | WAYLAND ST \ BRUSSELS ST | 1754683431000 | middleware_editor | STOP | BRUSSELS ST intersection | - | - | - | - | - | - | - | 17144 | 716799600000 | -122.405086 | 37.72591546 | - | - | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570940000 | WAYLAND ST | - | - | - | - | - | - |
| 74 | N/A | Point | - | - | - | - | S110907 | BRUSSELS ST: WAYLAND ST | - | F | F | - | F | 20637000 | 20637000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WAYLAND ST | BRUSSELS ST | 9077 | 9077 | 37.72591546 | -122.405086 | BRUSSELS ST \ WAYLAND ST | WAYLAND ST \ BRUSSELS ST | 1754683425000 | middleware_editor | STOP | BRUSSELS ST intersection | - | - | - | - | - | - | - | 17145 | 716799600000 | -122.405086 | 37.72591546 | - | 1575878400000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570940000 | WAYLAND ST | - | - | - | - | - | - |
| 75 | N/A | Point | - | - | - | - | S110910 | WALLER ST: CASTRO ST \ DIVISAD | - | F | F | - | F | 26011000 | 26011000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | DIVISADERO ST \ WALLER ST | CASTRO ST \ WALLER ST | 9079 | 9079 | 37.7703429 | -122.43684894 | CASTRO ST \ DIVISADERO ST \ WALLER ST | DIVISADERO ST \ CASTRO ST \ WALLER ST | 1724192167000 | middleware_editor | NO LEFT TURN (SYM) | CASTRO ST \ WALLER ST intersection | - | - | - | - | - | - | - | 17146 | 717724800000 | -122.43684894 | 37.7703429 | - | - | - | D5 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373570940000 | DIVISADERO 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