Import ISO
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 76051 | N/A | Point | 1 | 1 | 5062 - 5149 | LEFT ARROW | S286088 | 5062-5149 MISSION ST | 5062-5149 MISSION ST | F | F | - | F | 9177000 | 9177000 | - | - | WEST SIDE | - | - | - | - | AMAZON AVE | AMAZON AVE | 97906 | 97906 | 37.716972312 | -122.440754413 | - | - | 1710539427000 | MTA | TANSAT | AMAZON AVE to GENEVA AVE (5062 - 5149) | - | IFO 5090 | - | - | - | - | - | 93169 | 1669766400000 | -122.44071865 | 37.71685208 | - | - | - | D11 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | 2IN IRON POST | IS | 1669036500000 | MISSION ST | 5062 - 5149 MISSION ST | 5062 - 5149 MISSION ST | 5062 MISSION ST | - | GENEVA AVE | GENEVA AVE |
| 76052 | N/A | Point | 1 | 1 | 5062 - 5149 | - | S286089 | 5062-5149 MISSION ST | 5062-5149 MISSION ST | F | F | - | F | 9177000 | 9177000 | - | - | WEST SIDE | - | - | - | - | AMAZON AVE | AMAZON AVE | 97907 | 97907 | 37.716791257 | -122.44090104 | - | - | 1710539427000 | MTA | TANSAT | AMAZON AVE to GENEVA AVE (5062 - 5149) | - | 62 FT NORTH OF GENEVA IFO GAS STATION | - | - | - | - | - | 93170 | 1669766400000 | -122.44071865 | 37.71685208 | - | - | - | D11 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | LIGHT POLE | IS | 1669036620000 | MISSION ST | 5062 - 5149 MISSION ST | 5062 - 5149 MISSION ST | 5062 MISSION ST | - | GENEVA AVE | GENEVA AVE |
| 76053 | N/A | Point | 1 | 1 | 400 - 453 | - | S289198 | 400-453 VALENCIA ST | 400-453 VALENCIA ST | T | T | - | F | 13058000 | 13058000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 15TH ST | 15TH ST | 98237 | 98237 | 37.765777134 | -122.422067092 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | 15TH ST to SPARROW ST (400 - 453) | - | IFO 446 | - | - | - | - | - | 93171 | 1683158400000 | -122.42200406 | 37.76613017 | - | - | - | D8 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1683020400000 | VALENCIA ST | 400 - 453 VALENCIA ST | 400 - 453 VALENCIA ST | 400 VALENCIA ST | - | SPARROW ST | SPARROW ST |
| 76054 | N/A | Point | - | - | - | - | S289209 | VALENCIA ST: 15TH ST | - | T | T | - | F | 24377000 | 24377000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 15TH ST | VALENCIA ST | 98240 | 98240 | 37.766629693 | -122.421952168 | VALENCIA ST \ 15TH ST | 15TH ST \ VALENCIA ST | 1753130629000 | middleware_editor | NO LEFT TURN (SYM)/NO U TURN (SYM) | VALENCIA ST intersection | - | - | - | - | - | - | - | 93172 | 1683270000000 | -122.42204381 | 37.76653958 | - | - | - | D8 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP2 | OVERHEAD MAST ARM | IS | 1683024360000 | 15TH ST | - | - | - | - | - | - |
| 76055 | N/A | Point | - | - | - | - | S289210 | VALENCIA ST: 15TH ST | - | T | T | - | F | 24377000 | 24377000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 15TH ST | VALENCIA ST | 98241 | 98241 | 37.76662881 | -122.421951051 | VALENCIA ST \ 15TH ST | 15TH ST \ VALENCIA ST | 1710539427000 | MTA | NEW | VALENCIA ST intersection | - | - | - | - | - | - | - | 93173 | - | -122.42204381 | 37.76653958 | - | - | 1710149760000 | D8 | - | OTHER WARNING | WARNING | W(SF).0079 | 30X12 | SUP2 | OVERHEAD MAST ARM | RETD | 1683024420000 | 15TH ST | - | - | - | - | - | - |
| 76056 | N/A | Point | - | - | - | - | S289213 | VALENCIA ST: 15TH ST | - | T | T | - | F | 24377000 | 24377000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 15TH ST | VALENCIA ST | 98242 | 98242 | 37.766631902 | -122.421952727 | VALENCIA ST \ 15TH ST | 15TH ST \ VALENCIA ST | 1753222002000 | middleware_editor | BIKE (SYM) USE BIKE SIGNAL | VALENCIA ST intersection | - | - | - | - | - | - | - | 93174 | 1683270000000 | -122.42204381 | 37.76653958 | - | - | 1753221840000 | D8 | - | OTHER REGULATORY | REG | R(SF).0418 | 24X30 | SUP2 | OVERHEAD MAST ARM | RETD | 1683024780000 | 15TH ST | - | - | - | - | - | - |
| 76057 | N/A | Point | - | - | - | - | S289217 | VALENCIA ST: 15TH ST | - | T | T | - | F | 24377000 | 24377000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 15TH ST | VALENCIA ST | 98245 | 98245 | 37.766453 | -122.422137129 | VALENCIA ST \ 15TH ST | 15TH ST \ VALENCIA ST | 1753222000000 | middleware_editor | BIKE (SYM) USE BIKE SIGNAL | VALENCIA ST intersection | - | - | - | - | - | - | - | 93175 | 1683270000000 | -122.42204381 | 37.76653958 | - | - | 1753216080000 | D8 | - | OTHER REGULATORY | REG | R(SF).0418 | 24X30 | SUP2 | SIGNAL POLE | RETD | 1683025140000 | 15TH ST | - | - | - | - | - | - |
| 76058 | N/A | Point | - | - | - | - | S287721 | 5TH ST: NATOMA ST | - | F | F | - | F | 23945000 | 23945000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | NATOMA ST | 05TH ST | 98304 | 98304 | 37.78192502 | -122.40546628 | 5TH ST \ NATOMA ST | NATOMA ST \ 05TH ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | 05TH ST intersection | - | INSIDE CHEVRON, 20' OC | - | - | - | - | - | 93176 | 1678233600000 | -122.40546628 | 37.78192502 | - | - | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | TURNPIKE BASE | IS | 1677236580000 | NATOMA ST | - | - | - | - | - | - |
| 76059 | N/A | Point | 1 | 1 | 100 - 199 | - | S264966 | 100-199 LEAVENWORTH ST | 100-199 LEAVENWORTH ST | F | F | - | F | 8239000 | 8239000 | - | - | WEST SIDE | - | - | - | - | GOLDEN GATE AVE | GOLDEN GATE AVE | 98531 | 98531 | 37.782572675 | -122.414085744 | - | - | 1710539427000 | MTA | NPRK 6AM-8AM MON WED FRI SAT STCL | GOLDEN GATE AVE to TURK ST (100 - 199) | - | 50FT SOUTH OF TURK | - | - | - | - | - | 93177 | - | -122.41395968 | 37.78232889 | - | 1666569600000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0189 | 18X18 | SUP1 | 2IN IRON POST | IS | 1591618980000 | LEAVENWORTH ST | 100 - 199 LEAVENWORTH ST | 100 - 199 LEAVENWORTH ST | 100 LEAVENWORTH ST | - | TURK ST | TURK ST |
| 76060 | N/A | Point | - | - | - | - | S289218 | 15TH ST: VALENCIA ST | - | T | T | - | F | 24377000 | 24377000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 15TH ST | VALENCIA ST | 98547 | 98547 | 37.766592146 | -122.422186861 | VALENCIA ST \ 15TH ST | 15TH ST \ VALENCIA ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) ON RED | VALENCIA ST intersection | - | - | - | - | - | - | - | 93178 | 1683244800000 | -122.42204381 | 37.76653958 | - | - | - | D8 | - | NO RIGHT TURN | REG | R13A(CA).0003 | 24X36 | SUP2 | SIGNAL POLE | IS | 1683025260000 | 15TH ST | - | - | - | - | - | - |
| 76061 | N/A | Point | 1 | 1 | 800 - 847 | - | S287862 | 800-847 VALENCIA ST | 800-847 VALENCIA ST | F | F | - | F | 13065000 | 13065000 | - | - | WEST SIDE | - | - | - | - | 19TH ST | 19TH ST | 101427 | 101427 | 37.759842906 | -122.421523089 | - | - | 1710539427000 | MTA | BIKE RACK | 19TH ST to CUNNINGHAM PL (800 - 847) | - | 10' N OF SPL 820/ 3' IN FROM CURB | - | - | - | - | - | 93179 | 1678233600000 | -122.42139032 | 37.75973688 | - | - | - | D8 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1678163760000 | VALENCIA ST | 800 - 847 VALENCIA ST | 800 - 847 VALENCIA ST | 800 VALENCIA ST | - | CUNNINGHAM PL | CUNNINGHAM PL |
| 76062 | N/A | Point | - | - | - | - | S286819 | 10TH ST: HOWARD ST | - | F | F | - | F | 24248000 | 24248000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | HOWARD ST | 10TH ST | 101433 | 101433 | 37.77404333 | -122.41436769 | 10TH ST \ HOWARD ST | HOWARD ST \ 10TH ST | 1711768959000 | middleware_editor | FG 300 UR DELINEATOR (W) | 10TH ST intersection | - | KHAKI BOX | - | - | - | - | 4 | 93180 | 1675296000000 | -122.41436769 | 37.77404333 | - | - | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1672221300000 | HOWARD ST | - | - | - | - | - | - |
| 76063 | N/A | Point | - | - | - | - | S109735 | 40TH AVE: MORAGA ST | - | F | F | - | F | 27761000 | 27761000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 40TH AVE | 40TH AVE | 101452 | 101452 | 37.75510251 | -122.49910255 | MORAGA ST \ 40TH AVE | MORAGA ST \ 40TH AVE | 1710539427000 | MTA | STOP | 40TH AVE intersection | - | 0 / 00 | - | - | - | - | - | 93181 | 542332800000 | -122.49910255 | 37.75510251 | - | 1489708800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570580000 | MORAGA ST | - | - | - | - | - | - |
| 76064 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S252968 | 1100-1199 CALIFORNIA ST | 1100-1199 CALIFORNIA ST | F | F | - | F | 3543000 | 3543000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | TAYLOR ST | TAYLOR ST | 101470 | 101470 | 37.79152178 | -122.41328409 | - | - | 1710539427000 | MTA | BIKE (SYM) BIKE ROUTE | TAYLOR ST to JONES ST (1100 - 1199) | 0857 | 35 FEET WEST OF TAYLOR ABOE LRV SIGN | - | - | - | - | - | 93182 | 1323734400000 | -122.41328409 | 37.79152178 | - | 1572393600000 | - | D3 | - | BIKE GUIDE | GUIDE | D11-1C.0002 | 24X18 | SUP1 | 2IN IRON POST | IS | 1553951100000 | CALIFORNIA ST | 1100 - 1199 CALIFORNIA ST | 1100 - 1199 CALIFORNIA ST | 1100 CALIFORNIA ST | - | JONES ST | JONES ST |
| 76065 | N/A | Point | - | - | - | - | S253670 | 23RD ST: ARKANSAS ST | - | F | F | - | F | 23642000 | 23642000 | - | - | NORTH WEST CORNER | - | - | - | - | 23RD ST | ARKANSAS ST | 101477 | 101477 | 37.75482658 | -122.39772873 | ARKANSAS ST \ 23RD ST | 23RD ST \ ARKANSAS ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | ARKANSAS ST intersection | - | 2 DEL WEST OF X-WALK 5' OC | - | - | - | - | - | 93183 | 1559743560000 | -122.39772873 | 37.75482658 | - | - | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1555928520000 | 23RD ST | - | - | - | - | - | - |
| 76066 | N/A | Point | 1 | 1 | 76 - 99 | RIGHT ARROW | S252734 | 76-99 SYCAMORE ST | 76-99 SYCAMORE ST | F | F | - | F | 12361000 | 12361000 | - | - | NORTH SIDE | - | - | - | - | LEXINGTON ST | LEXINGTON ST | 101485 | 101485 | 37.762626588 | -122.421357546 | - | - | 1721427803000 | middleware_editor | 1 HR PRK 9AM-6PM MON-FRI EXC "I" PERMITS | LEXINGTON ST to VALENCIA ST (76 - 99) | - | 60 FEET EAST OF VALENCIA | - | - | - | - | - | 93184 | 1140480000000 | -122.42128155 | 37.76260185 | - | 1559088000000 | - | D9 | - | PARKING:RPP | REG | R32C(CA).0017 | 18X21 | SUP2 | 2IN IRON POST | IS | 1553519640000 | SYCAMORE ST | 76 - 99 SYCAMORE ST | 76 - 99 SYCAMORE ST | 76 SYCAMORE ST | - | VALENCIA ST | VALENCIA ST |
| 76067 | N/A | Point | - | - | - | - | S253285 | SKYLINE BLVD: JOHN MUIR DR | - | T | T | - | F | - | 23323000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | - | SKYLINE BLVD | 101495 | 101495 | 37.7190608098809 | -122.49986596405 | - | JOHN MUIR DR \ SKYLINE BLVD | 1735056954000 | middleware_editor | BIKE WAYFINDING SIGN | SKYLINE BLVD intersection | 0563 | - | - | - | - | - | - | 93185 | 1272499200000 | -122.50022095 | 37.71895556 | - | 1554768000000 | - | D7 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | SIGNAL POLE | IS | 1554467160000 | JOHN MUIR DR | 200 - 699 JOHN MUIR DR | - | - | - | - | - |
| 76068 | N/A | Point | - | - | - | - | S255665 | BRAZIL AVE: PARIS ST | - | F | F | - | F | 21717000 | 21717000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | PARIS ST | BRAZIL AVE | 101513 | 101513 | 37.723906982 | -122.433360236 | BRAZIL AVE \ PARIS ST | PARIS ST \ BRAZIL AVE | 1710539427000 | MTA | ALL WAY | BRAZIL AVE intersection | - | - | - | - | - | - | - | 93186 | 1563535440000 | -122.43323149 | 37.72393244 | - | - | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1561541760000 | PARIS ST | - | - | - | - | - | - |
| 76069 | N/A | Point | - | - | - | - | S255667 | BRAZIL AVE: PARIS ST | - | F | F | - | F | 21717000 | 21717000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PARIS ST | BRAZIL AVE | 101514 | 101514 | 37.723940927 | -122.433118838 | BRAZIL AVE \ PARIS ST | PARIS ST \ BRAZIL AVE | 1710539427000 | MTA | STOP | BRAZIL AVE intersection | - | - | - | - | - | - | - | 93187 | 1563535560000 | -122.43323149 | 37.72393244 | - | - | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1561542060000 | PARIS ST | - | - | - | - | - | - |
| 76070 | N/A | Point | - | - | - | - | S255668 | BRAZIL AVE: PARIS ST | - | F | F | - | F | 21717000 | 21717000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PARIS ST | BRAZIL AVE | 101515 | 101515 | 37.723952241 | -122.433120626 | BRAZIL AVE \ PARIS ST | PARIS ST \ BRAZIL AVE | 1710539427000 | MTA | ALL WAY | BRAZIL AVE intersection | - | - | - | - | - | - | - | 93188 | 1563535620000 | -122.43323149 | 37.72393244 | - | - | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1561542180000 | PARIS ST | - | - | - | - | - | - |
| 76071 | N/A | Point | 1 | 1 | 100 - 199 | - | S255678 | 100-199 HERMANN ST | 100-199 HERMANN ST | F | F | - | F | 6886000 | 6886000 | - | - | SOUTH SIDE | - | - | - | - | BUCHANAN ST | BUCHANAN ST | 101517 | 101517 | 37.77055597 | -122.42760347 | - | - | 1746134566000 | middleware_editor | NPRK 8AM-10AM THUR STCL | BUCHANAN ST to WEBSTER ST (100 - 199) | 119986936 | 50FT EAST TO 55FT EAST OF BUCHANNAN | - | - | - | - | - | 93189 | - | -122.42760347 | 37.77055597 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0267 | 18X18 | SUP2 | LIGHT POLE | RETD | 1561546080000 | HERMANN ST | 100 - 199 HERMANN ST | 100 - 199 HERMANN ST | 100 HERMANN ST | - | WEBSTER ST | WEBSTER ST |
| 76072 | N/A | Point | 1 | 1 | 200 - 299 | - | S280898 | 200-299 BROADWAY | 200-299 BROADWAY | F | F | - | F | 3145000 | 3145000 | - | - | SOUTH SIDE | - | - | - | - | BATTERY ST | BATTERY ST | 101529 | 101529 | 37.798416332 | -122.401905656 | - | - | 1710539427000 | MTA | BIKE RACK | BATTERY ST to SANSOME ST (200 - 299) | 486175 | 54' E OF WPL 295/ 3' IN FROM CURB | - | - | - | - | - | 93190 | 1667433600000 | -122.40163997 | 37.79850488 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1644910380000 | BROADWAY | 200 - 299 BROADWAY | 200 - 299 BROADWAY | 200 BROADWAY | - | SANSOME ST | SANSOME ST |
| 76073 | N/A | Point | - | - | - | - | S258068 | 46TH AVE: SANTIAGO ST | - | F | F | - | F | 23507000 | 23507000 | - | - | SOUTH EAST CORNER | - | - | - | - | 46TH AVE | 46TH AVE | 101544 | 101544 | 37.74364293 | -122.50475258 | SANTIAGO ST \ 46TH AVE | SANTIAGO ST \ 46TH AVE | 1710539427000 | MTA | NPRK 12NN-2PM 2ND & 4TH THUR OF MONTH STCL | 46TH AVE intersection | - | - | - | - | - | - | - | 93191 | 1228953600000 | -122.50475258 | 37.74364293 | - | - | - | D4 | - | STREET CLEANING | REG | R30B(CA).0073 | 18X18 | SUP2 | 2IN IRON POST | IS | 1569855540000 | SANTIAGO ST | - | - | - | - | - | - |
| 76074 | N/A | Point | 1 | 1 | 700 - 749 | - | S258093 | 700-749 STANYAN ST | 700-749 STANYAN ST | T | T | - | F | 12091000 | 12091000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | HAIGHT ST | HAIGHT ST | 101554 | 101554 | 37.76870563 | -122.45344458 | - | - | 1710539427000 | MTA | "P" (WHITE-BLUE) | HAIGHT ST to WALLER ST (700 - 749) | - | 60' NORTH OF WALLER ST. POLE# T1737 | - | - | - | - | - | 93192 | 1571842260000 | -122.45344458 | 37.76870563 | - | - | - | D5 | - | OTHER GUIDE | GUIDE | G-P(SF).0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1570020540000 | STANYAN ST | 700 - 749 STANYAN ST | 700 - 749 STANYAN ST | 700 STANYAN ST | - | WALLER ST | WALLER ST |
| 76075 | N/A | Point | 1 | 1 | 1000 - 1049 | - | S289352 | 1000-1049 VALENCIA ST | 1000-1049 VALENCIA ST | F | F | - | F | 13069000 | 13069000 | - | SHOULD BE RETIRED | EAST SIDE | - | - | - | - | 21ST ST | 21ST ST | 101563 | 101563 | 37.756292735 | -122.421103108 | - | - | 1743712436000 | middleware_editor | BUS LANE CURB | 21ST ST to HILL ST (1000 - 1049) | - | SECTION 2 ( 105--195 FT ) FROM 21ST ST | - | - | - | - | - | 93193 | 1686553200000 | -122.42107934 | 37.75650191 | - | - | 1743712380000 | D9 | - | OTHER WARNING | WARNING | W(SF).0118 | 72X18 | SUP2 | ANCHORS | RETD | 1683716460000 | VALENCIA ST | 1000 - 1049 VALENCIA ST | 1000 - 1049 VALENCIA ST | 1000 VALENCIA ST | - | HILL ST | HILL ST |
| 76076 | N/A | Point | 1 | 1 | 1000 - 1049 | - | S289354 | 1000-1049 VALENCIA ST | 1000-1049 VALENCIA ST | F | F | - | F | 13069000 | 13069000 | - | SHOULD BE RETIRED | WEST SIDE | - | - | - | - | 21ST ST | 21ST ST | 101564 | 101564 | 37.756294326 | -122.421060565 | - | - | 1743712403000 | middleware_editor | BUS LANE CURB | 21ST ST to HILL ST (1000 - 1049) | - | SECTION 2 ( 105--195 FT ) FROM 21ST ST | - | - | - | - | - | 93194 | 1686553200000 | -122.42107934 | 37.75650191 | - | - | 1743712380000 | D9 | - | OTHER WARNING | WARNING | W(SF).0118 | 72X18 | SUP2 | ANCHORS | RETD | 1683716760000 | VALENCIA ST | 1000 - 1049 VALENCIA ST | 1000 - 1049 VALENCIA ST | 1000 VALENCIA ST | - | HILL ST | HILL ST |
| 76077 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S289333 | 1100-1199 VALENCIA ST | 1100-1199 VALENCIA ST | F | F | - | F | 13071000 | 13071000 | - | SHOULD BE RETIRED | WEST SIDE | - | - | - | - | 22ND ST | 22ND ST | 102577 | 102577 | 37.753881294 | -122.420861297 | - | - | 1743701958000 | middleware_editor | BUS LANE CURB | 22ND ST to 23RD ST (1100 - 1199) | - | SECTION 5 ( 405--495 FT ) FROM 22ND ST | - | - | - | - | - | 93195 | 1686207600000 | -122.42088812 | 37.75449894 | - | - | 1743701880000 | D8 | - | OTHER WARNING | WARNING | W(SF).0118 | 72X18 | SUP2 | ANCHORS | RETD | 1683708540000 | VALENCIA ST | 1100 - 1199 VALENCIA ST | 1100 - 1199 VALENCIA ST | 1100 VALENCIA ST | - | 23RD ST | 23RD ST |
| 76078 | N/A | Point | 1 | 1 | 1050 - 1099 | - | S289006 | 1050-1099 VALENCIA ST | 1050-1099 VALENCIA ST | F | F | - | F | 13070000 | 13070000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | HILL ST | HILL ST | 102606 | 102606 | 37.756049853 | -122.420937055 | - | - | 1719263286000 | middleware_editor | NO LEFT TURN (SYM)/NO U TURN (SYM) | HILL ST to 22ND ST (1050 - 1099) | - | NPL 1057 ( USE METER POLE ) | - | - | - | - | - | 93196 | 1682640000000 | -122.42100262 | 37.7556983 | - | - | - | D8 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1682586360000 | VALENCIA ST | 1050 - 1099 VALENCIA ST | 1050 - 1099 VALENCIA ST | 1050 VALENCIA ST | - | 22ND ST | 22ND ST |
| 76079 | N/A | Point | - | - | - | - | S286621 | CLARENDON AVE: GALEWOOD CIR | - | F | F | - | F | 52177000 | 52177000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CLARENDON AVE | CLARENDON AVE | 102619 | 102619 | 37.752464144 | -122.45617926 | GALEWOOD CIR \ CLARENDON AVE | CLARENDON AVE intersection | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | CLARENDON AVE intersection | - | - | - | - | - | - | - | 93197 | 1671494400000 | -122.45713055 | 37.7527667 | - | - | - | D7 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | 2IN IRON POST | IS | 1671096480000 | GALEWOOD CIR | - | - | - | - | - | - |
| 76080 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S255015 | 1100-1199 TENNESSEE ST | 1100-1199 TENNESSEE ST | F | F | - | F | 12486000 | 12486000 | - | - | WEST SIDE | - | - | - | - | 22ND ST | 22ND ST | 102688 | 102688 | 37.75712013 | -122.38917728 | - | - | 1710539427000 | MTA | 2HR PRK 8AM-10PM MON-SAT EXC "EE" PERMITS | 22ND ST to TUBBS ST (1100 - 1199) | - | NPL #1102 | - | - | - | - | - | 93198 | 1464048000000 | -122.38917728 | 37.75712013 | - | 1535414400000 | - | D10 | - | PARKING:RPP | REG | R32C(CA).0245 | 18X21 | SUP1 | 2IN IRON POST | IS | 1559646240000 | TENNESSEE ST | 1100 - 1199 TENNESSEE ST | 1100 - 1199 TENNESSEE ST | 1100 TENNESSEE ST | - | TUBBS ST | TUBBS ST |
| 76081 | N/A | Point | 1 | 1 | 500 - 599 | RIGHT ARROW | S253714 | 500-599 TURK ST | 500-599 TURK ST | F | F | - | F | 12722000 | 12722000 | - | - | NORTH SIDE | - | - | - | - | LARKIN ST | LARKIN ST | 102724 | 102724 | 37.782252911 | -122.418863454 | - | - | 1747344061000 | middleware_editor | TA (SYM) PLO AT ALL TIMES (5 MIN) | LARKIN ST to POLK ST (500 - 599) | - | 7' E OF POLK | - | - | - | - | - | 93199 | 1556310300000 | -122.41816608 | 37.78227411 | - | - | 1747256700000 | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0001 | 14X21 | SUP1 | 2IN IRON POST | RETD | 1556016960000 | TURK ST | 500 - 599 TURK ST | 500 - 599 TURK ST | 500 TURK ST | - | POLK ST | POLK ST |
| 76082 | N/A | Point | 1 | 1 | 500 - 599 | LEFT ARROW | S253715 | 500-599 TURK ST | 500-599 TURK ST | F | F | - | F | 12722000 | 12722000 | - | - | NORTH SIDE | - | - | - | - | LARKIN ST | LARKIN ST | 102725 | 102725 | 37.78227411 | -122.418717274 | - | - | 1747343908000 | middleware_editor | TA (SYM) PLO AT ALL TIMES (5 MIN) | LARKIN ST to POLK ST (500 - 599) | - | 51' E OF POLK ST | - | - | - | - | - | 93200 | 1556313000000 | -122.41816608 | 37.78227411 | - | - | 1747256100000 | D6 | - | OTHER REGULATORY | REG | R38(SF)1.0001 | 14X21 | SUP1 | 2IN IRON POST | RETD | 1556017080000 | TURK ST | 500 - 599 TURK ST | 500 - 599 TURK ST | 500 TURK ST | - | POLK ST | POLK ST |
| 76083 | N/A | Point | - | - | - | - | S263309 | IRVING ST: 12TH AVE | - | T | T | - | F | 27171000 | 27171000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 12TH AVE | 12TH AVE | 102872 | 102872 | 37.764003373 | -122.46946474 | IRVING ST \ 12TH AVE | IRVING ST \ 12TH AVE | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | 12TH AVE intersection | - | - | - | - | - | - | - | 93201 | 1104883200000 | -122.46952196 | 37.76389594 | - | 1630281600000 | - | D5 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP1 | LIGHT POLE | IS | 1586855100000 | IRVING ST | - | - | - | - | - | - |
| 76084 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S289314 | 1100-1199 VALENCIA ST | 1100-1199 VALENCIA ST | F | F | - | F | 13071000 | 13071000 | - | SHOULD BE RETIRED | EAST SIDE | - | - | - | - | 22ND ST | 22ND ST | 102905 | 102905 | 37.755218373 | -122.421004797 | - | - | 1743702353000 | middleware_editor | BUS LANE CURB | 22ND ST to 23RD ST (1100 - 1199) | - | SECTION 1 ( 5--95 FT ) FROM 22ND ST | - | - | - | - | - | 93202 | 1686207600000 | -122.42088812 | 37.75449894 | - | - | 1743702300000 | D8 | - | OTHER WARNING | WARNING | W(SF).0118 | 72X18 | SUP2 | ANCHORS | RETD | 1683628980000 | VALENCIA ST | 1100 - 1199 VALENCIA ST | 1100 - 1199 VALENCIA ST | 1100 VALENCIA ST | - | 23RD ST | 23RD ST |
| 76085 | N/A | Point | 1 | 1 | 1 - 99 | - | S289561 | 1-99 GLORIA CT | 1-99 GLORIA CT | F | F | - | F | 6226000 | 6226000 | - | - | EAST SIDE | - | - | - | - | START: 1-99 BLOCK | START: 1-99 BLOCK | 102913 | 102913 | 37.71756205 | -122.441173962 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM FRI STCL | START: 1-99 BLOCK to GENEVA AVE (1 - 99) | - | IFO 25 GLORIA CT | - | - | - | - | - | 93203 | - | -122.44127231 | 37.71753376 | - | 1684800000000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0259 | 18X18 | SUP2 | LIGHT POLE | IS | 1684314960000 | GLORIA CT | 1 - 99 GLORIA CT | 1 - 99 GLORIA CT | 1 GLORIA CT | - | GENEVA AVE | GENEVA AVE |
| 76086 | N/A | Point | 1 | 1 | 1 - 99 | - | S289562 | 1-99 GLORIA CT | 1-99 GLORIA CT | F | F | - | F | 6226000 | 6226000 | - | - | WEST SIDE | - | - | - | - | START: 1-99 BLOCK | START: 1-99 BLOCK | 102914 | 102914 | 37.717552148 | -122.441334895 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM FRI STCL | START: 1-99 BLOCK to GENEVA AVE (1 - 99) | - | IFO 36 GLORIA CT | - | - | - | - | - | 93204 | - | -122.44127231 | 37.71753376 | - | 1684800000000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0259 | 18X18 | SUP2 | 2IN IRON POST | IS | 1684315200000 | GLORIA CT | 1 - 99 GLORIA CT | 1 - 99 GLORIA CT | 1 GLORIA CT | - | GENEVA AVE | GENEVA AVE |
| 76087 | N/A | Point | - | - | - | - | S256721 | PNDG TERRY A FRANCOIS BLVD | - | F | F | - | F | 12532000 | 12532000 | - | - | EAST SIDE | - | - | - | - | - | - | 102973 | 102973 | 37.76873346 | -122.38636338 | - | - | 1710539427000 | MTA | TA (SYM) NO STOPPING 12MID- 6AM DAILY | - | - | 830FT SOUTH / FLAG OUT | - | - | - | - | - | 93205 | 1565101260000 | -122.38636338 | 37.76873346 | - | - | - | D6 | - | OTHER REGULATORY | REG | R37(CA).0109 | 18X21 | SUP1 | LIGHT POLE | IS | 1564742820000 | TERRY A FRANCOIS BLVD | PNDG TERRY A FRANCOIS BLVD | TERRY A FRANCOIS BLVD | - | - | - | - |
| 76088 | N/A | Point | - | - | - | - | S256655 | SAN JOSE AVE: RANDALL ST | - | F | F | - | T | 21838000 | 21838000 | - | - | CENTER ISLAND, S LINE, SOUTHBOUND | - | - | - | - | RANDALL ST | RANDALL ST | 102986 | 102986 | 37.739806658 | -122.424131057 | SAN JOSE AVE \ RANDALL ST | SAN JOSE AVE \ RANDALL ST | 1746054750000 | middleware_editor | DELINEATOR (Y) (SAFE HIT) | RANDALL ST intersection | - | 3 YELLOW SAFE HITS ON EACH ISLAND | - | - | - | - | - | 93206 | 794476800000 | -122.42414715 | 37.73986923 | - | 1589180400000 | 1746042720000 | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0002 | 03X36 | SUP2 | DELINEATOR BASE SAFE HIT | RETD | 1564657200000 | SAN JOSE AVE | - | - | - | - | - | - |
| 76089 | N/A | Point | 1 | 1 | 100 - 199 | - | S251798 | 100-199 THERESA ST | 100-199 THERESA ST | F | F | - | F | 12565000 | 12565000 | - | - | NORTH SIDE | - | - | - | - | ALEMANY BLVD | ALEMANY BLVD | 103006 | 103006 | 37.729045548 | -122.434920417 | - | - | 1717024623000 | middleware_editor | NPRK 9AM-11AM MON STCL | ALEMANY BLVD to CAYUGA AVE (100 - 199) | - | IFO 122 | - | - | - | - | - | 93207 | 1516320000000 | -122.43487929 | 37.72899322 | - | 1582675200000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0300 | 18X18 | SUP2 | 2IN IRON POST | IS | 1550840520000 | THERESA ST | 100 - 199 THERESA ST | 100 - 199 THERESA ST | 100 THERESA ST | - | CAYUGA AVE | CAYUGA AVE |
| 76090 | N/A | Point | - | - | - | - | S252704 | GENEVA AVE: ESQUINA DR | - | F | F | - | F | 20427000 | 20427000 | - | - | CENTER ISLAND, W LINE, WESTBOUND | - | - | - | - | ESQUINA DR | GENEVA AVE | 103017 | 103017 | 37.708760393 | -122.421662137 | GENEVA AVE \ ESQUINA DR | ESQUINA DR \ GENEVA AVE | 1710539427000 | MTA | FG 300 EFX DELINEATOR (Y) | GENEVA AVE intersection | - | W-LINE OF INTERECT/ EAST SIDE OF ISLAND | - | - | - | - | - | 93208 | 1553598180000 | -122.42161733 | 37.70874305 | - | - | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0014 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1553247420000 | ESQUINA DR | - | - | - | - | - | - |
| 76091 | N/A | Point | 1 | 1 | 450 - 499 | - | S265909 | 450-499 POPE ST | 450-499 POPE ST | F | F | - | F | 10600000 | 10600000 | - | - | EAST SIDE | - | - | - | - | POLARIS WAY | POLARIS WAY | 104408 | 104408 | 37.708811981 | -122.440074686 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM TUE STCL | POLARIS WAY to BELLEVUE AVE (450 - 499) | - | SPL 455 | - | - | - | - | - | 93209 | 1522800000000 | -122.44027993 | 37.70859775 | - | 1594252800000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0083 | 18X18 | SUP2 | 2IN IRON POST | IS | 1594127040000 | POPE ST | 450 - 499 POPE ST | 450 - 499 POPE ST | 450 POPE ST | - | BELLEVUE AVE | BELLEVUE AVE |
| 76092 | N/A | Point | 1 | 1 | 450 - 499 | - | S265911 | 450-499 POPE ST | 450-499 POPE ST | F | F | - | F | 10600000 | 10600000 | - | - | WEST SIDE | - | - | - | - | POLARIS WAY | POLARIS WAY | 104409 | 104409 | 37.708875969 | -122.440171698 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM THUR STCL | POLARIS WAY to BELLEVUE AVE (450 - 499) | - | SPL 454 | - | - | - | - | - | 93210 | 1522800000000 | -122.44027993 | 37.70859775 | - | 1522800000000 | - | D11 | - | STREET CLEANING | REG | R30B(CA).0080 | 18X18 | SUP2 | 2IN IRON POST | IS | 1594127460000 | POPE ST | 450 - 499 POPE ST | 450 - 499 POPE ST | 450 POPE ST | - | BELLEVUE AVE | BELLEVUE AVE |
| 76093 | N/A | Point | - | - | - | - | S256578 | NEY ST: CRAUT ST | - | F | F | - | F | 21695000 | 21695000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | NEY ST | CRAUT ST | 104484 | 104484 | 37.73002139 | -122.428328 | CRAUT ST \ NEY ST | NEY ST \ CRAUT ST | 1710539427000 | MTA | SPEED HUMPS | CRAUT ST intersection | - | - | - | - | - | - | - | 93211 | 1509408000000 | -122.428328 | 37.73002139 | - | 1566777600000 | - | D11 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1564491360000 | NEY ST | - | - | - | - | - | - |
| 76094 | N/A | Point | - | - | - | - | S256579 | NEY ST: CRAUT ST | - | F | F | - | F | 21695000 | 21695000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | NEY ST | CRAUT ST | 104485 | 104485 | 37.73002139 | -122.428328 | CRAUT ST \ NEY ST | NEY ST \ CRAUT ST | 1710539427000 | MTA | SPEED HUMPS | CRAUT ST intersection | - | WPL 191 | - | - | - | - | - | 93212 | 1509408000000 | -122.428328 | 37.73002139 | - | 1566777600000 | - | D11 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1564491960000 | NEY ST | - | - | - | - | - | - |
| 76095 | N/A | Point | - | - | - | - | S256580 | NEY ST: CRAUT ST | - | F | F | - | F | 21695000 | 21695000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | NEY ST | CRAUT ST | 104486 | 104486 | 37.73002139 | -122.428328 | CRAUT ST \ NEY ST | NEY ST \ CRAUT ST | 1710539427000 | MTA | SPEED HUMPS | CRAUT ST intersection | - | - | - | - | - | - | - | 93213 | 1509408000000 | -122.428328 | 37.73002139 | - | 1566777600000 | - | D11 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1564492140000 | NEY ST | - | - | - | - | - | - |
| 76096 | N/A | Point | 1 | 1 | 300 - 399 | - | S268597 | 300-399 ARKANSAS ST | 300-399 ARKANSAS ST | F | F | - | F | 2438000 | 2438000 | - | - | EAST SIDE | - | - | - | - | 18TH ST | 18TH ST | 104525 | 104525 | 37.76182346 | -122.3983997 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "X" PERMITS | 18TH ST to 19TH ST (300 - 399) | - | 90' SOUTH OF 18TH ST. | - | - | - | - | - | 93214 | 1615285560000 | -122.3983997 | 37.76182346 | - | - | - | D10 | - | PARKING:RPP | REG | R32C(CA).0106 | 18X21 | SUP1 | 2IN IRON POST | IS | 1601392620000 | ARKANSAS ST | 300 - 399 ARKANSAS ST | 300 - 399 ARKANSAS ST | 300 ARKANSAS ST | - | 19TH ST | 19TH ST |
| 76097 | N/A | Point | 1 | 1 | 2500 - 2599 | - | S290027 | 2500-2599 VALLEJO ST | 2500-2599 VALLEJO ST | T | T | - | F | 13118000 | 13118000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | PIERCE ST | PIERCE ST | 104601 | 104601 | 37.79470237 | -122.43922385 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | PIERCE ST to SCOTT ST (2500 - 2599) | - | 145' WEST OF PIERCE ST | - | - | - | - | - | 93215 | 1686614400000 | -122.43922385 | 37.79470237 | - | - | - | D2 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1686585120000 | VALLEJO ST | 2500 - 2599 VALLEJO ST | 2500 - 2599 VALLEJO ST | 2500 VALLEJO ST | - | SCOTT ST | SCOTT ST |
| 76098 | N/A | Point | 1 | 1 | 2400 - 2499 | - | S290028 | 2400-2499 VALLEJO ST | 2400-2499 VALLEJO ST | T | T | - | F | 13117000 | 13117000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | STEINER ST | STEINER ST | 104602 | 104602 | 37.7949115 | -122.43758173 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | STEINER ST to PIERCE ST (2400 - 2499) | - | 125' EAST OF PIERCE ST | - | - | - | - | - | 93216 | 1686614400000 | -122.43758173 | 37.7949115 | - | - | - | D2 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1686585180000 | VALLEJO ST | 2400 - 2499 VALLEJO ST | 2400 - 2499 VALLEJO ST | 2400 VALLEJO ST | - | PIERCE ST | PIERCE ST |
| 76099 | N/A | Point | - | - | - | - | S287435 | HAZELWOOD AVE: CASITAS AVE \ Y | - | F | F | - | F | 22810000 | 22810000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CASITAS AVE \ YERBA BUENA AVE | CASITAS AVE \ YERBA BUENA AVE | 104660 | 104660 | 37.73429057 | -122.45950454 | HAZELWOOD AVE \ CASITAS AVE \ YERBA BUENA AVE | HAZELWOOD AVE \ CASITAS AVE \ YERBA BUENA AVE | 1710539427000 | MTA | SPEED HUMP | CASITAS AVE \ YERBA BUENA AVE intersection | - | 15 FT EAST OF YERBA BUENA | - | - | - | - | - | 93217 | 1680566400000 | -122.45950454 | 37.73429057 | - | - | - | D7 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1675771440000 | HAZELWOOD AVE | - | - | - | - | - | - |
| 76100 | N/A | Point | - | - | - | - | S289100 | VALENCIA ST: 19TH ST | - | F | F | - | F | 24158000 | 24158000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 104665 | 104665 | 37.76001647 | -122.421323286 | VALENCIA ST \ 19TH ST | VALENCIA ST \ 19TH ST | 1753295820000 | middleware_editor | NO LEFT TURN (SYM)/NO U TURN (SYM) | 19TH ST intersection | - | - | - | - | - | - | - | 93218 | 1682924400000 | -122.42142521 | 37.76010129 | - | - | 1753294800000 | D8 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP2 | SIGNAL POLE | RETD | 1682674260000 | VALENCIA ST | - | - | - | - | - | - |
| 76101 | N/A | Point | - | - | - | - | S259256 | 15TH ST: CASTRO ST | - | T | T | - | F | 25824000 | 25824000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CASTRO ST | 15TH ST | 104843 | 104843 | 37.76572747 | -122.43547195 | 15TH ST \ CASTRO ST | CASTRO ST \ 15TH ST | 1710539427000 | MTA | SPEED HUMPS | 15TH ST intersection | - | ABOVE SIGNAL LIGHT | - | - | - | - | - | 93219 | -394416000000 | -122.43547195 | 37.76572747 | - | 1575331200000 | - | D8 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1573816500000 | CASTRO ST | - | - | - | - | - | - |
| 76102 | N/A | Point | - | - | - | - | S265391 | ASHBURY ST: WALLER ST | - | T | T | - | F | 26337000 | 26337000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | WALLER ST | WALLER ST | 104901 | 104901 | 37.76907436 | -122.44674489 | ASHBURY ST \ WALLER ST | ASHBURY ST \ WALLER ST | 1727399036000 | middleware_editor | SPEED HUMPS | WALLER ST intersection | - | 5`SOUTH | - | - | - | - | - | 93220 | 1329350400000 | -122.44674489 | 37.76907436 | - | 1593043200000 | - | D5 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | MUNI POLE | IS | 1592915820000 | ASHBURY ST | - | - | - | - | - | - |
| 76103 | N/A | Point | - | - | - | - | S265393 | ASHBURY ST: FREDERICK ST | - | T | T | - | F | 26335000 | 26335000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FREDERICK ST | FREDERICK ST | 104903 | 104903 | 37.76722026 | -122.44636926 | ASHBURY ST \ FREDERICK ST | ASHBURY ST \ FREDERICK ST | 1743011120000 | middleware_editor | SPEED HUMPS | FREDERICK ST intersection | - | - | - | - | - | - | - | 93221 | 1329379200000 | -122.44636926 | 37.76722026 | - | 1593068400000 | - | D5 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | MUNI POLE | IS | 1592916120000 | ASHBURY ST | - | - | - | - | - | - |
| 76104 | N/A | Point | 1 | 1 | 2700 - 2799 | - | S275269 | 2700-2799 16TH ST | 2700-2799 16TH ST | - | - | - | F | 720000 | 720000 | - | - | NORTH SIDE | - | - | - | - | HARRISON ST \ TREAT AVE | HARRISON ST \ TREAT AVE | 107200 | 107200 | 37.765293479 | -122.413806277 | - | - | 1710539427000 | MTA | DELINEATOR (W) (SAFE HIT) | HARRISON ST \ TREAT AVE to FOLSOM ST (2700 - 2799) | - | W END OF CORRAL | - | - | - | - | - | 93222 | 1673222400000 | -122.41420682 | 37.76538112 | - | - | - | D9 | - | DELINEATOR 5 | WARNING | TYPE-DL.0001 | 03X36 | SUP2 | BIKE RACK | IS | 1622734020000 | 16TH ST | 2700 - 2799 16TH ST | 2700 - 2799 16TH ST | 2700 16TH ST | - | FOLSOM ST | FOLSOM ST |
| 76105 | N/A | Point | - | - | - | - | S233168 | TARAVAL ST: 18TH AVE | - | T | T | - | F | 23182000 | 23182000 | - | - | NORTH SIDE | - | - | - | - | TARAVAL ST | 18TH AVE | 107245 | 107245 | 37.74309662 | -122.47462383 | 18TH AVE \ TARAVAL ST | TARAVAL ST \ 18TH AVE | 1716416872000 | middleware_editor | TANSAT | 18TH AVE intersection | - | IFO#820 | - | - | - | - | - | 93223 | 997142400000 | -122.47462383 | 37.74309662 | - | - | - | D7 | - | TOW (TANSAT) | REG | R37(CA).0089 | 14X21 | SUP2 | MUNI POLE | IS | 1485940380000 | TARAVAL ST | - | - | - | - | - | - |
| 76106 | N/A | Point | - | - | - | - | S232742 | TARAVAL ST: 19TH AVE | - | T | T | - | F | 23183000 | 23183000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 19TH AVE | 107246 | 107246 | 37.74305181 | -122.47564447 | 19TH AVE \ TARAVAL ST | TARAVAL ST \ 19TH AVE | 1722648181000 | middleware_editor | NO RIGHT TURN (SYM) ON RED | 19TH AVE intersection | - | ON MAST ARM | - | - | - | - | - | 93224 | 1486996800000 | -122.47564447 | 37.74305181 | - | 1486944000000 | - | D4 | - | NO RIGHT TURN | REG | R13A(CA).0002 | 24X30 | SUP2 | MUNI POLE | IS | 1484824860000 | TARAVAL ST | - | - | - | - | - | - |
| 76107 | N/A | Point | 1 | 1 | 2300 - 2399 | RIGHT ARROW | S233691 | 2300-2399 31ST AVE | 2300-2399 31ST AVE | F | F | - | F | 1694000 | 1694000 | - | - | EAST SIDE | - | - | - | - | SANTIAGO ST | SANTIAGO ST | 107248 | 107248 | 37.74341809 | -122.48861243 | - | - | 1727141824000 | middleware_editor | 1 HR PRK 8AM-1PM SCHL DAYS EXC "T" PERMITS | SANTIAGO ST to TARAVAL ST (2300 - 2399) | - | 60`NORTH OF TARAVAL | - | - | - | - | - | 93225 | 1487937480000 | -122.48861243 | 37.74341809 | - | 1487894400000 | - | D4 | - | PARKING:RPP | REG | R32C(CA).0005 | 18X21 | SUP2 | 2IN IRON POST | IS | 1487244540000 | 31ST AVE | 2300 - 2399 31ST AVE | 2300 - 2399 31ST AVE | 2300 31ST AVE | - | TARAVAL ST | TARAVAL ST |
| 76108 | N/A | Point | - | - | - | - | S233800 | 22ND ST: SAN BRUNO AVE | - | F | F | - | F | 23731000 | 23731000 | - | - | NORTH WEST CORNER | - | - | - | - | SAN BRUNO AVE | 22ND ST | 107249 | 107249 | 37.75695219 | -122.40473227 | 22ND ST \ SAN BRUNO AVE | SAN BRUNO AVE \ 22ND ST | 1710539427000 | MTA | ALL WAY | 22ND ST intersection | - | X ST IS 22N D ST | - | - | - | - | - | 93226 | 1492867740000 | -122.40473227 | 37.75695219 | - | 1492819200000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1487670300000 | SAN BRUNO AVE | - | - | - | - | - | - |
| 76109 | N/A | Point | - | - | - | - | S235178 | 8TH ST: TEHAMA ST | - | F | F | - | F | 24298000 | 24298000 | - | - | NORTH WEST CORNER | - | - | - | - | TEHAMA ST | 08TH ST | 107250 | 107250 | 37.7757938 | -122.41106944 | 8TH ST \ TEHAMA ST | TEHAMA ST \ 08TH ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | 08TH ST intersection | - | FOR RIGHT TURN ONTO TEHAMA | - | - | - | - | - | 93227 | 1492784880000 | -122.41106944 | 37.7757938 | - | 1492732800000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1492079820000 | TEHAMA ST | - | - | - | - | - | - |
| 76110 | N/A | Point | - | - | - | - | S232566 | TARAVAL ST: 31ST AVE | - | T | T | - | F | 12406000 | 23387000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 30TH AVE | 31ST AVE | 107251 | 107251 | 37.74248467 | -122.48854722 | - | TARAVAL ST \ 31ST AVE | 1723856740000 | middleware_editor | STATE LAW STOP HERE WHEN LRV(SYM) & PED(SYM) (45LA-DN) | 31ST AVE intersection | - | 112`EAST | - | - | - | - | - | 93228 | 1486997700000 | -122.48854722 | 37.74248467 | - | 1486944000000 | - | D4 | - | PEDESTRIAN(LA DN) | REG | R10-6.0007 | 30X48 | SUP2 | MUNI POLE | IS | 1484204820000 | TARAVAL ST | 2000 - 2099 TARAVAL ST | - | - | - | 31ST AVE | - |
| 76111 | N/A | Point | - | - | - | LEFT ARROW | S234378 | 7TH ST: CLEVELAND ST | - | F | F | - | F | 24257000 | 24257000 | - | - | NORTH EAST CORNER | - | - | - | - | CLEVELAND ST | 07TH ST | 107253 | 107253 | 37.77630595 | -122.40728966 | 7TH ST \ CLEVELAND ST | CLEVELAND ST \ 07TH ST | 1710539427000 | MTA | TANSAT | 07TH ST intersection | - | - | - | - | - | - | - | 93229 | 1489677660000 | -122.40728966 | 37.77630595 | - | 1489622400000 | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1489588740000 | CLEVELAND ST | - | - | - | - | - | - |
| 76112 | N/A | Point | - | 1 | 3700 - 3799 | - | S231853 | 3700-3799 BUCHANAN ST | 3700-3799 BUCHANAN ST | F | F | - | F | 3357000 | 3357000 | - | - | WEST SIDE | - | - | - | - | NORTH POINT ST | NORTH POINT ST | 107254 | 107254 | 37.80454948 | -122.43363199 | - | - | 1710539427000 | MTA | TA (SYM) PLO 9AM-6PM MON-FRI (5 MIN) | NORTH POINT ST to BEACH ST \ LOWER FORT MASON ST \ MARINA BLVD (3700 - 3799) | - | IFO #3727 | - | - | - | - | - | 93230 | 1482921840000 | -122.43363199 | 37.80454948 | - | 1680048000000 | - | D2 | - | OTHER REGULATORY | REG | R38(SF)1.0054 | 14X21 | SUP1 | 2IN FLANGE POST | IS | 1481808000000 | BUCHANAN ST | 3700 - 3799 BUCHANAN ST | 3700 - 3799 BUCHANAN ST | 3700 BUCHANAN ST | - | BEACH ST \ LOWER FORT MASON ST \ MARINA BLVD | BEACH ST \ LOWER FORT MASON ST \ MARINA BLVD |
| 76113 | N/A | Point | - | - | - | - | S232164 | HILLWAY AVE: CARL ST | - | F | F | - | F | 27061000 | 27061000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CARL ST | CARL ST | 107256 | 107256 | 37.76493246 | -122.45675901 | HILLWAY AVE \ CARL ST | HILLWAY AVE \ CARL ST | 1710539427000 | MTA | PEDESTRIAN (SYM) | CARL ST intersection | - | - | - | - | - | - | - | 93231 | 1483962420000 | -122.45675901 | 37.76493246 | - | 1483920000000 | - | D5 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP1 | LIGHT POLE | IS | 1483012680000 | HILLWAY AVE | - | - | - | - | - | - |
| 76114 | N/A | Point | 1 | 1 | 101 - 199 | - | S234497 | 12-161 JUNIPERO SERRA BLVD | 101-199 JUNIPERO SERRA BLVD | F | F | - | F | 7704000 | 7704000 | - | - | WEST SIDE | - | - | - | - | MONTEREY BLVD | MONTEREY BLVD | 107257 | 107257 | 37.73258646 | -122.47136117 | - | - | 1710539427000 | MTA | TANSAT | MONTEREY BLVD to DARIEN WAY (101 - 199) -- EAST -- | - | 357' SOUTH OF WOODACRE | - | - | - | - | - | 93232 | 1490702100000 | -122.47136117 | 37.73258646 | - | 1490659200000 | - | D7 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | 2IN IRON POST | IS | 1490005200000 | JUNIPERO SERRA BLVD | 101 - 199 JUNIPERO SERRA BLVD | 101 - 199 JUNIPERO SERRA BLVD | 101 JUNIPERO SERRA BLVD | - | DARIEN WAY | DARIEN WAY |
| 76115 | N/A | Point | - | - | - | - | S102172 | HOFF ST: 16TH ST | - | F | F | - | F | 24175000 | 24175000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 16TH ST | 16TH ST | 107265 | 107265 | 37.765085325 | -122.420459911 | HOFF ST \ 16TH ST | HOFF ST \ 16TH ST | 1710539427000 | MTA | ONE WAY (LA) | 16TH ST intersection | - | 0 / 0 | - | - | - | - | - | 93233 | -390096000000 | -122.42058061 | 37.76499627 | - | - | - | D9 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | UNKNOWN | IS | 1373568240000 | HOFF ST | - | - | - | - | - | - |
| 76116 | N/A | Point | - | - | - | - | S219942 | COLE ST: 17TH ST | - | F | F | - | F | 26266000 | 26266000 | - | - | NORTH EAST CORNER | - | - | - | - | COLE ST | COLE ST | 107290 | 107290 | 37.76164813 | -122.44912021 | 17TH ST \ COLE ST | 17TH ST \ COLE ST | 1710539427000 | MTA | NPRK 8AM-10AM 1ST TUE OF EVERY MONTH STCL | COLE ST intersection | - | - | - | - | - | - | - | 93234 | - | -122.44912021 | 37.76164813 | - | - | - | D5 | - | STREET CLEANING | REG | R30B(CA).0253 | 18X18 | SUP1 | LIGHT POLE | IS | 1444820160000 | 17TH ST | - | - | - | - | - | - |
| 76117 | N/A | Point | 1 | 1 | 400 - 499 | - | S220218 | 400-499 JEFFERSON ST | 400-499 JEFFERSON ST | F | F | - | F | 7459000 | 7459000 | - | - | NORTH SIDE | - | - | - | - | LEAVENWORTH ST \ RICHARD HENRY DANA PL | LEAVENWORTH ST \ RICHARD HENRY DANA PL | 107291 | 107291 | 37.80769661 | -122.41991467 | - | - | 1710539427000 | MTA | BIKE RACK | LEAVENWORTH ST \ RICHARD HENRY DANA PL to HYDE ST (400 - 499) | 20154603 | EPL #490 | - | - | - | - | - | 93235 | 1445688180000 | -122.41991467 | 37.80769661 | - | 1445644800000 | - | D2 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1445511120000 | JEFFERSON ST | 400 - 499 JEFFERSON ST | 400 - 499 JEFFERSON ST | 400 JEFFERSON ST | - | HYDE ST | HYDE ST |
| 76118 | N/A | Point | - | - | - | - | S220472 | SANTA FE AVE: SILVER AVE | - | F | F | - | F | 20744000 | 20744000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SANTA FE AVE | SANTA FE AVE | 107292 | 107292 | 37.73488449 | -122.40155621 | SILVER AVE \ SANTA FE AVE | SILVER AVE \ SANTA FE AVE | 1751401315000 | middleware_editor | STOP | SANTA FE AVE intersection | - | BACK TO BACK WITH R11 | - | - | - | - | - | 93236 | 1130137200000 | -122.40155621 | 37.73488449 | - | 1450857600000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1446452640000 | SILVER AVE | - | - | - | - | - | - |
| 76119 | N/A | Point | - | - | - | - | S276007 | HEARST AVE: CONGO ST | - | F | F | - | F | 22139000 | 22139000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HEARST AVE | CONGO ST | 107950 | 107950 | 37.73072177 | -122.44201566 | CONGO ST \ HEARST AVE | HEARST AVE \ CONGO ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | CONGO ST intersection | - | 9FT FRFOM CURB | - | - | - | - | - | 93237 | -181699200000 | -122.44201566 | 37.73072177 | - | 1629676800000 | - | D7 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1625649960000 | HEARST AVE | - | - | - | - | - | - |
| 76120 | N/A | Point | 1 | 1 | 800 - 831 | - | S275637 | 800-831 HEAD ST | 800-831 HEAD ST | F | F | - | F | 6859000 | 6859000 | - | - | SOUTH SIDE, NORTHBOUND TRAFFIC | - | - | - | - | HOLLOWAY AVE | HOLLOWAY AVE | 107951 | 107951 | 37.72203384 | -122.46429865 | - | - | 1710539427000 | MTA | SCHOOL (SYM) AHEAD | HOLLOWAY AVE to WALKWAY (800 - 831) | - | NPL #870 | - | - | - | - | - | 93238 | 1099872000000 | -122.46429865 | 37.72203384 | - | 1632441600000 | - | D7 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP2 | LIGHT POLE | IS | 1624443660000 | HEAD ST | 800 - 831 HEAD ST | 800 - 831 HEAD ST | 800 HEAD ST | - | WALKWAY | WALKWAY |
| 76121 | N/A | Point | - | - | - | - | S125905 | 46TH AVE: ULLOA ST | - | F | F | - | F | 23499000 | 23499000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 46TH AVE | ULLOA ST | 107952 | 107952 | 37.73990658 | -122.50448974 | ULLOA ST \ 46TH AVE | 46TH AVE \ ULLOA ST | 1710539427000 | MTA | ALL WAY | ULLOA ST intersection | - | - | - | - | - | - | - | 93239 | 1161129600000 | -122.50448974 | 37.73990658 | - | - | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373575620000 | 46TH AVE | - | - | - | - | - | - |
| 76122 | N/A | Point | - | - | - | - | S129371 | TARAVAL ST: 35TH AVE | - | F | F | - | F | 23375000 | 23375000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TARAVAL ST | 35TH AVE | 107953 | 107953 | 37.74229579 | -122.49283694 | 35TH AVE \ TARAVAL ST | TARAVAL ST \ 35TH AVE | 1723593403000 | middleware_editor | ALL WAY | 35TH AVE intersection | - | - | - | - | - | - | - | 93240 | 1215475200000 | -122.49283694 | 37.74229579 | - | 1723553520000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373576760000 | TARAVAL ST | - | - | - | - | - | - |
| 76123 | N/A | Point | - | - | - | - | S240972 | COLUMBUS AVE: GRANT AVE | - | T | T | - | F | 25330000 | 25330000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GRANT AVE | COLUMBUS AVE | 107955 | 107955 | 37.79815206 | -122.40708293 | COLUMBUS AVE \ GRANT AVE | GRANT AVE \ COLUMBUS AVE | 1710539427000 | MTA | 49 MILE SCENIC DRIVE ARROW (RA) | COLUMBUS AVE intersection | 28 | - | - | - | - | - | - | 93241 | 1565103720000 | -122.40708293 | 37.79815206 | - | - | - | D3 | - | OTHER GUIDE | GUIDE | G-X(SF).0047 | 18X18 | SUP1 | LIGHT POLE | IS | 1511955540000 | GRANT AVE | - | - | - | - | - | - |
| 76124 | N/A | Point | - | 1 | 2560 - 2598 | - | S241029 | 0-2599 CESAR CHAVEZ ST | 2560-2598 CESAR CHAVEZ ST | F | F | - | F | 2479201 | 2479201 | - | - | SOUTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | BAY SHORE BLVD \ VERMONT ST | BAY SHORE BLVD \ VERMONT ST | 107958 | 107958 | 37.74953196 | -122.40305214 | - | - | 1710539427000 | MTA | WRONG WAY | BAY SHORE BLVD \ VERMONT ST to HWY 101 N ON RAMP (2560 - 2598) -- NORTH -- | - | WPL TO DRIVEWAY OF STORAGE BUILDING | - | - | - | - | - | 93242 | 1512050580000 | -122.40305214 | 37.74953196 | - | 1512000000000 | - | D10 | - | OTHER REGULATORY | REG | R5-1A.0002 | 36X21 | SUP1 | LIGHT POLE | IS | 1512035340000 | CESAR CHAVEZ ST | 2560 - 2598 CESAR CHAVEZ ST | 2560 - 2598 CESAR CHAVEZ ST | 2560 CESAR CHAVEZ ST | - | HWY 101 N ON RAMP | HWY 101 N ON RAMP |
| 76125 | N/A | Point | - | - | - | - | S239681 | JOHN F KENNEDY DR: 36TH AVE | - | F | F | - | F | 27826000 | 27826000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 36TH AVE | 36TH AVE | 107959 | 107959 | 37.77019808 | -122.4949103 | JOHN F KENNEDY DR \ 36TH AVE | JOHN F KENNEDY DR \ 36TH AVE | 1710539427000 | MTA | STOP | 36TH AVE intersection | - | GG EQUESTRIAN/SPRECKELS LAKE | - | - | - | - | - | 93243 | - | -122.4949103 | 37.77019808 | - | - | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1508502060000 | JOHN F KENNEDY DR | - | - | - | - | - | - |
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 metersMetadata automatically harvested from the ESRI service during import.