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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100201 | N/A | Point | - | - | - | - | S277815 | SHOTWELL ST: 22ND ST | - | F | F | - | F | 24078000 | 24078000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 22ND ST | SHOTWELL ST | 126249 | 126249 | 37.75563411 | -122.41547327 | SHOTWELL ST \ 22ND ST | 22ND ST \ SHOTWELL ST | 1738699403000 | middleware_editor | FG 300 UR DELINEATOR (W) | SHOTWELL ST intersection | - | 10 FT FROM CURB | - | - | - | - | - | 117469 | 1634169600000 | -122.41547327 | 37.75563411 | - | 1738572300000 | - | D9 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP2 | STANDARD BASE | IS | 1632396600000 | 22ND ST | - | - | - | - | - | - |
| 100202 | N/A | Point | - | - | - | - | S101999 | SHOTWELL ST: 22ND ST | - | F | F | - | F | 24078000 | 24078000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 22ND ST | SHOTWELL ST | 128949 | 128949 | 37.75563411 | -122.41547327 | SHOTWELL ST \ 22ND ST | 22ND ST \ SHOTWELL ST | 1710539427000 | MTA | STOP | SHOTWELL ST intersection | - | 0 / 0 | - | - | - | - | - | 117470 | -394416000000 | -122.41547327 | 37.75563411 | - | 1583193600000 | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566920000 | 22ND ST | - | - | - | - | - | - |
| 100203 | N/A | Point | 1 | 1 | 600 - 699 | - | S264867 | 600-699 SHOTWELL ST | 600-699 SHOTWELL ST | F | F | - | F | 11838000 | 11838000 | - | - | EAST SIDE | - | - | - | - | 20TH ST | 20TH ST | 110334 | 110334 | 37.75803133 | -122.41570275 | - | - | 1710539427000 | MTA | 1 HR PRK 9AM-6PM MON-SAT EXC "I" PERMITS | 20TH ST to 21ST ST (600 - 699) | - | NPL# 651 SHOTWELL ST. | - | - | - | - | - | 117471 | - | -122.41570275 | 37.75803133 | - | - | - | D9 | - | PARKING:RPP | REG | R32C(CA).0018 | 18X21 | SUP2 | 2IN IRON POST | IS | 1591193340000 | SHOTWELL ST | 600 - 699 SHOTWELL ST | 600 - 699 SHOTWELL ST | 600 SHOTWELL ST | - | 21ST ST | 21ST ST |
| 100204 | N/A | Point | 1 | 1 | 422 - 499 | - | S289287 | 422-499 FOLSOM ST | 422-499 FOLSOM ST | T | T | - | F | 5656000 | 5656000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | GROTE PL | GROTE PL | 97163 | 97163 | 37.78750326 | -122.3942216 | - | - | 1710539427000 | MTA | SPEED LIMIT 20 | GROTE PL to 01ST ST (422 - 499) | - | 89" EAST OF 1ST ST | - | - | - | - | - | 117472 | 1692370140000 | -122.3942216 | 37.78750326 | - | - | - | D6 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1683542280000 | FOLSOM ST | 422 - 499 FOLSOM ST | 422 - 499 FOLSOM ST | 422 FOLSOM ST | - | 01ST ST | 01ST ST |
| 100205 | N/A | Point | 1 | 1 | 40 - 99 | - | S289301 | 40-99 FOLSOM ST | 40-99 FOLSOM ST | T | T | - | F | 5650000 | 5650000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | THE EMBARCADERO | THE EMBARCADERO | 101277 | 101277 | 37.79044838 | -122.39049168 | - | - | 1710539427000 | MTA | SPEED LIMIT 20 | THE EMBARCADERO to SPEAR ST (40 - 99) | - | 157' WEST OF THE EMBARCADERO | - | - | - | - | - | 117473 | 1692615720000 | -122.39049168 | 37.79044838 | - | - | - | D6 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1683545280000 | FOLSOM ST | 40 - 99 FOLSOM ST | 40 - 99 FOLSOM ST | 40 FOLSOM ST | - | SPEAR ST | SPEAR ST |
| 100206 | N/A | Point | 1 | 1 | 500 - 599 | LEFT ARROW | S261645 | 500-599 STEVENSON ST | 500-599 STEVENSON ST | F | F | - | F | 12171000 | 12171000 | - | - | NORTH SIDE | - | - | - | - | 6TH ST | 06TH ST | 126971 | 126971 | 37.78088745 | -122.41082115 | - | - | 1710539427000 | MTA | TANP ANY TIME | 06TH ST to 07TH ST \ ODD FELLOWS WAY (500 - 599) | - | 34' EAST OF 7TH ST. | - | - | - | - | - | 117474 | 1586953140000 | -122.41082115 | 37.78088745 | - | - | - | D6 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP1 | 2IN IRON POST | IS | 1582197480000 | STEVENSON ST | 500 - 599 STEVENSON ST | 500 - 599 STEVENSON ST | 500 STEVENSON ST | - | 07TH ST \ ODD FELLOWS WAY | 07TH ST \ ODD FELLOWS WAY |
| 100207 | N/A | Point | - | - | - | - | S255116 | THE EMBARCADERO: CHESTNUT ST \ | - | F | F | - | F | 34013000 | 34013000 | - | - | CENTER ISLAND, S LINE, EASTBOUND | - | - | - | - | CHESTNUT ST \ THE EMBARCADERO | CHESTNUT ST \ THE EMBARCADERO | 126983 | 126983 | 37.8051849 | -122.40343573 | SANSOME ST \ CHESTNUT ST \ THE EMBARCADERO | SANSOME ST \ CHESTNUT ST \ THE EMBARCADERO | 1710539427000 | MTA | FG 300 EFX DELINEATOR (Y) | CHESTNUT ST \ THE EMBARCADERO intersection | - | ON SOUTH SIDE THE ISLAND | - | - | - | - | - | 117475 | 1417996800000 | -122.40343573 | 37.8051849 | - | 1564531200000 | - | D3 | - | DELINEATOR 5 | WARNING | TYPE-DL.0014 | 03X36 | SUP1 | INTERSTATE BASE | IS | 1560158400000 | SANSOME ST | - | - | - | - | - | - |
| 100208 | N/A | Point | - | - | - | - | S275803 | PACHECO ST: MAGELLAN AVE | - | F | F | - | F | 22894000 | 22894000 | - | - | CENTER ISLAND, E LINE, WESTBOUND | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | PACHECO ST | PACHECO ST | 121503 | 121503 | 37.74636151 | -122.46171004 | MAGELLAN AVE \ PACHECO ST | MAGELLAN AVE \ PACHECO ST | 1717084389000 | middleware_editor | OBJECT MARKER - YELLOW | PACHECO ST intersection | - | EAST TIP OF ISLAND | - | - | - | - | - | 117476 | 811987200000 | -122.46171004 | 37.74636151 | - | 1625011200000 | - | D7 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP2 | 2IN IRON POST | IS | 1624884480000 | MAGELLAN AVE | - | - | - | - | - | - |
| 100209 | N/A | Point | - | - | - | - | S264767 | - | - | F | F | - | F | 2487000 | - | - | - | SOUTH SIDE, SOUTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | - | - | 138012 | 138012 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | - | - | IFO 3291 | - | - | - | - | - | 117477 | 1410998400000 | - | - | - | 1591228800000 | - | D9 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP2 | 2IN IRON POST | IS | - | - | 3225-3298 CESAR CHAVEZ ST | - | - | - | - | - |
| 100210 | N/A | Point | 1 | 1 | 600 - 655 | - | S113227 | 600-655 DUNCAN ST | 600-655 DUNCAN ST | F | F | - | F | 5006000 | 5006000 | - | - | EAST SIDE, EASTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | CASTRO ST | CASTRO ST | 7352 | 7352 | 37.74564914 | -122.43413413 | - | - | 1725560028000 | middleware_editor | OBJECT MARKER - YELLOW | CASTRO ST to NEWBURG ST (600 - 655) | - | CENTER LINE OF CUL-DU SAC IN DIRT | - | - | - | - | - | 117478 | 984700800000 | -122.43413413 | 37.74564914 | - | - | - | D8 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571660000 | DUNCAN ST | 600 - 655 DUNCAN ST | 600 - 655 DUNCAN ST | 600 DUNCAN ST | - | NEWBURG ST | NEWBURG ST |
| 100211 | N/A | Point | 1 | - | - | - | S116376 | 3200-3299 VAN NESS AVE | - | F | F | - | F | 13174000 | 13174000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | - | - | 16403 | 16403 | 37.80663475 | -122.42588422 | - | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | - | - | 180N / BACK TO BACK | - | - | - | - | - | 117479 | 1048723200000 | -122.42588422 | 37.80663475 | - | - | - | D2 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP1 | UNKNOWN | IS | 1373572680000 | VAN NESS AVE | 3200-3299 VAN NESS AVE | VAN NESS AVE | - | - | - | - |
| 100212 | N/A | Point | 1 | - | - | - | S116379 | 3200-3299 VAN NESS AVE | - | F | F | - | F | 13174000 | 13174000 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | - | - | 16406 | 16406 | 37.80663475 | -122.42588422 | - | - | 1710539427000 | MTA | OBJECT MARKER - YELLOW | - | - | 90N / BELOW R32(4) 8A6P | - | - | - | - | - | 117480 | 1048723200000 | -122.42588422 | 37.80663475 | - | - | - | D2 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP1 | UNKNOWN | IS | 1373572680000 | VAN NESS AVE | 3200-3299 VAN NESS AVE | VAN NESS AVE | - | - | - | - |
| 100213 | N/A | Point | - | - | - | - | S287318 | 26TH ST: WISCONSIN ST | - | F | F | - | F | 23686000 | 23686000 | - | - | SOUTH SIDE, SOUTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | 26TH ST | 26TH ST | 106103 | 106103 | 37.75105461 | -122.39834078 | WISCONSIN ST \ 26TH ST | WISCONSIN ST \ 26TH ST | 1710539427000 | MTA | OBJECT MARKER - YELLOW | 26TH ST intersection | - | OPPO C/L OF WISCONSIN ST | - | - | - | - | - | 117481 | 1675728000000 | -122.39834078 | 37.75105461 | - | - | - | D10 | - | OTHER WARNING | WARNING | TYPE-N(CA).0004 | 30X30 | SUP1 | 2IN IRON POST | IS | 1675180020000 | WISCONSIN ST | - | - | - | - | - | - |
| 100214 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S138619 | 2200-2299 FILBERT ST | 2200-2299 FILBERT ST | F | F | - | F | 5522000 | 5522000 | - | - | NORTH SIDE | - | - | - | - | FILLMORE ST | FILLMORE ST | 28896 | 28896 | 37.79791629 | -122.43650219 | - | - | 1741907741000 | middleware_editor | NPRK 9AM-11AM 1ST & 3RD TUE OF MONTH STCL | FILLMORE ST to STEINER ST (2200 - 2299) | - | 2258 FILBERT | - | - | - | - | - | 117482 | 1219734000000 | -122.43650219 | 37.79791629 | - | 1741884060000 | - | D2 | - | STREET CLEANING | REG | R30B(CA).0288 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1375724040000 | FILBERT ST | 2200 - 2299 FILBERT ST | 2200 - 2299 FILBERT ST | 2200 FILBERT ST | - | STEINER ST | STEINER ST |
| 100215 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S139289 | 2200-2299 FILBERT ST | 2200-2299 FILBERT ST | F | F | - | F | 5522000 | 5522000 | - | - | SOUTH SIDE | - | - | - | - | FILLMORE ST | FILLMORE ST | 30671 | 30671 | 37.79791629 | -122.43650219 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM 1ST & 3RD FRI OF MONTH STCL | FILLMORE ST to STEINER ST (2200 - 2299) | - | 2287 FILBERT | - | - | - | - | - | 117483 | 1219622400000 | -122.43650219 | 37.79791629 | - | 1520553600000 | - | D2 | - | STREET CLEANING | REG | R30(CA).0035 | 18X18 | SUP1 | 2IN IRON POST | IS | 1375724580000 | FILBERT ST | 2200 - 2299 FILBERT ST | 2200 - 2299 FILBERT ST | 2200 FILBERT ST | - | STEINER ST | STEINER ST |
| 100216 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S139290 | 2200-2299 FILBERT ST | 2200-2299 FILBERT ST | F | F | - | F | 5522000 | 5522000 | - | - | SOUTH SIDE | - | - | - | - | FILLMORE ST | FILLMORE ST | 30672 | 30672 | 37.79791629 | -122.43650219 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM 1ST & 3RD FRI OF MONTH STCL | FILLMORE ST to STEINER ST (2200 - 2299) | - | 2257 FILBERT | - | - | - | - | - | 117484 | 1219622400000 | -122.43650219 | 37.79791629 | - | - | - | D2 | - | STREET CLEANING | REG | R30(CA).0035 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1375724580000 | FILBERT ST | 2200 - 2299 FILBERT ST | 2200 - 2299 FILBERT ST | 2200 FILBERT ST | - | STEINER ST | STEINER ST |
| 100217 | N/A | Point | 1 | 1 | 200 - 299 | - | S139341 | 200-299 PIXLEY ST | 200-299 PIXLEY ST | F | F | - | F | 10505000 | 10505000 | - | - | NORTH SIDE | - | - | - | - | FILLMORE ST | FILLMORE ST | 32486 | 32486 | 37.79838236 | -122.43659641 | - | - | 1724184071000 | middleware_editor | NPRK 9AM-11AM 1ST & 3RD FRI OF MONTH STCL | FILLMORE ST to STEINER ST (200 - 299) | - | WPL #224 | - | - | - | - | - | 117485 | 1219708800000 | -122.43659641 | 37.79838236 | - | 1416182400000 | - | D2 | - | STREET CLEANING | REG | R30(CA).0035 | 18X18 | SUP1 | 2IN IRON POST | IS | 1375724580000 | PIXLEY ST | 200 - 299 PIXLEY ST | 200 - 299 PIXLEY ST | 200 PIXLEY ST | - | STEINER ST | STEINER ST |
| 100218 | N/A | Point | - | - | - | - | S119562 | GELLERT DR: CLEARFIELD DR | - | F | F | - | F | 28260000 | 28260000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CLEARFIELD DR | GELLERT DR | 16952 | 16952 | 37.72974543 | -122.49076132 | GELLERT DR \ CLEARFIELD DR | CLEARFIELD DR \ GELLERT DR | 1710539427000 | MTA | STOP | GELLERT DR intersection | - | - | - | - | - | - | - | 117486 | 1097625600000 | -122.49076132 | 37.72974543 | - | 1230681600000 | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373573700000 | CLEARFIELD DR | - | - | - | - | - | - |
| 100219 | N/A | Point | - | - | - | - | S225542 | LAKE MERCED BLVD: CLEARFIELD D | - | F | F | - | F | 33508000 | 33508000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | CLEARFIELD DR | CLEARFIELD DR | 63427 | 63427 | 37.72965202 | -122.49054679 | LAKE MERCED BLVD \ CLEARFIELD DR | LAKE MERCED BLVD \ CLEARFIELD DR | 1710539427000 | MTA | NO U TURN (SYM) | CLEARFIELD DR intersection | - | - | - | - | - | - | - | 117487 | 1463753040000 | -122.49054679 | 37.72965202 | - | 1463702400000 | - | D7 | - | OTHER REGULATORY | REG | R3-4.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1462959660000 | LAKE MERCED BLVD | - | - | - | - | - | - |
| 100220 | N/A | Point | 1 | 1 | 3400 - 3499 | - | S149967 | 3400-3499 ORTEGA ST | 3400-3499 ORTEGA ST | F | F | - | F | 10030000 | 10030000 | - | - | SOUTH SIDE | - | - | - | - | 41ST AVE | 41ST AVE | 38435 | 38435 | 37.75131008 | -122.50045097 | - | - | 1710539427000 | MTA | NPRK 1PM-3PM 1ST & 3RD MON OF MONTH STCL | 41ST AVE to 42ND AVE (3400 - 3499) | - | 3427 ORTEGA | - | - | - | - | - | 117488 | 1228176000000 | -122.50045097 | 37.75131008 | - | - | - | D4 | - | STREET CLEANING | REG | R30B(CA).0094 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375729500000 | ORTEGA ST | 3400 - 3499 ORTEGA ST | 3400 - 3499 ORTEGA ST | 3400 ORTEGA ST | - | 42ND AVE | 42ND AVE |
| 100221 | N/A | Point | 1 | 1 | 1 - 32 | - | S259222 | 1-32 5TH ST | 1-32 05TH ST | F | F | - | F | 289000 | 289000 | - | - | EAST SIDE | - | - | - | - | CYRIL MAGNIN ST \ MARKET ST | CYRIL MAGNIN ST \ MARKET ST | 86065 | 86065 | 37.7837602 | -122.40777468 | - | - | 1730738439000 | middleware_editor | FG 300 UR DELINEATOR (W) | CYRIL MAGNIN ST \ MARKET ST to STEVENSON ST (1 - 32) | - | 10 OC | - | - | - | - | - | 117489 | 1576837320000 | -122.40777468 | 37.7837602 | - | 1647216000000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1573728540000 | 05TH ST | 1 - 32 05TH ST | 1 - 32 05TH ST | 1 5TH ST | - | STEVENSON ST | STEVENSON ST |
| 100222 | N/A | Point | - | - | - | - | 24462 | - | - | F | F | - | F | 289000 | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1696445265000 | smuneno | - | - | CYRIL MAGNIN ST \ MARKET ST | - | 160465 | 160465 | 37.7838864314781 | -122.407803779099 | - | - | 1744121870000 | middleware_editor | FG 300 UR DELINEATOR (W) | - | - | BETWEEN MARKET ST AND STEVENSON 20' OC | - | - | - | - | 6 | 117490 | - | - | - | - | 1733848500000 | - | 06 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | TURNPIKE BASE | IS | - | 05TH ST | 1 - 32 05TH ST | - | - | - | STEVENSON ST | - |
| 100223 | N/A | Point | - | - | - | - | S262290 | ALEMANY BLVD: COTTER ST | - | F | F | - | F | 21777000 | 21777000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ALEMANY BLVD | COTTER ST | 96656 | 96656 | 37.7281713 | -122.43497335 | COTTER ST \ ALEMANY BLVD | ALEMANY BLVD \ COTTER ST | 1727313991000 | middleware_editor | BIKE WAYFINDING SIGN | COTTER ST intersection | 1424 | ABOVE SIGN 2 SIGNS | - | - | - | - | - | 117491 | 1176163200000 | -122.43497335 | 37.7281713 | - | 1583884800000 | - | D11 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | 2IN IRON POST | IS | 1583488020000 | ALEMANY BLVD | - | - | - | - | - | - |
| 100224 | N/A | Point | - | - | - | - | S262281 | ALEMANY BLVD: COTTER ST | - | F | F | - | F | 21777000 | 21777000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | ALEMANY BLVD | COTTER ST | 96652 | 96652 | 37.7281713 | -122.43497335 | COTTER ST \ ALEMANY BLVD | ALEMANY BLVD \ COTTER ST | 1727313985000 | middleware_editor | BIKE WAYFINDING SIGN | COTTER ST intersection | 1418 | 20`NORTH OF COTTER ABOVE SIGN | - | - | - | - | - | 117492 | 1147910400000 | -122.43497335 | 37.7281713 | - | 1583884800000 | - | D11 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | 2IN IRON POST | IS | 1583484540000 | ALEMANY BLVD | - | - | - | - | - | - |
| 100225 | N/A | Point | - | - | - | - | S250809 | ALEMANY BLVD: COTTER ST | - | F | F | - | F | 21777000 | 21777000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ALEMANY BLVD | COTTER ST | 80480 | 80480 | 37.7281713 | -122.43497335 | COTTER ST \ ALEMANY BLVD | ALEMANY BLVD \ COTTER ST | 1727313984000 | middleware_editor | SCHOOL (SYM)/ 45 LEFT DN ARROW (COMBO) | COTTER ST intersection | - | - | - | - | - | - | - | 117493 | 1176163200000 | -122.43497335 | 37.7281713 | - | 1558051200000 | - | D11 | - | SCHOOL | WARNING | SW24-2(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1547543580000 | ALEMANY BLVD | - | - | - | - | - | - |
| 100226 | N/A | Point | - | - | - | - | S275595 | ALEMANY BLVD: COTTER ST | - | F | F | - | F | 21777000 | 21777000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ALEMANY BLVD | COTTER ST | 123639 | 123639 | 37.7281713 | -122.43497335 | COTTER ST \ ALEMANY BLVD | ALEMANY BLVD \ COTTER ST | 1727313980000 | middleware_editor | SCHOOL (SYM)/ 45 LEFT DN ARROW (COMBO) | COTTER ST intersection | - | - | - | - | - | - | - | 117494 | 1176163200000 | -122.43497335 | 37.7281713 | - | - | - | D11 | - | SCHOOL | WARNING | SW24-2(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1624357320000 | ALEMANY BLVD | - | - | - | - | - | - |
| 100227 | N/A | Point | - | - | - | - | S262282 | ALEMANY BLVD: COTTER ST | - | F | F | - | F | 21777000 | 21777000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ALEMANY BLVD | COTTER ST | 96653 | 96653 | 37.7281713 | -122.43497335 | COTTER ST \ ALEMANY BLVD | ALEMANY BLVD \ COTTER ST | 1727313984000 | middleware_editor | BIKE WAYFINDING SIGN | COTTER ST intersection | 1419 | ABOVE SIGN | - | - | - | - | - | 117495 | 1176163200000 | -122.43497335 | 37.7281713 | - | 1583884800000 | - | D11 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | 2IN IRON POST | IS | 1583484780000 | ALEMANY BLVD | - | - | - | - | - | - |
| 100228 | N/A | Point | - | - | - | - | S229459 | ALEMANY BLVD: COTTER ST | - | F | F | - | F | 21777000 | 21777000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ALEMANY BLVD | COTTER ST | 64702 | 64702 | 37.7281713 | -122.43497335 | COTTER ST \ ALEMANY BLVD | ALEMANY BLVD \ COTTER ST | 1727313981000 | middleware_editor | BIKE (SYM) LANE | COTTER ST intersection | - | - | - | - | - | - | - | 117496 | 1147910400000 | -122.43497335 | 37.7281713 | - | 1476835200000 | - | D11 | - | BIKE REG | REG | R81(CA).0002 | 24X18 | SUP2 | 2IN IRON POST | IS | 1475577300000 | ALEMANY BLVD | - | - | - | - | - | - |
| 100229 | N/A | Point | - | - | - | - | S107288 | COTTER ST: ALEMANY BLVD | - | F | F | - | F | 21777000 | 21777000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ALEMANY BLVD | COTTER ST | 2709 | 2709 | 37.7281713 | -122.43497335 | COTTER ST \ ALEMANY BLVD | ALEMANY BLVD \ COTTER ST | 1727313982000 | middleware_editor | DO NOT ENTER | COTTER ST intersection | - | 0 / MAKE ONE WAY EASTBOUND | - | - | - | - | - | 117497 | 213235200000 | -122.43497335 | 37.7281713 | - | - | - | D11 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP2 | 3IN IRON POST | IS | 1373569800000 | ALEMANY BLVD | - | - | - | - | - | - |
| 100230 | N/A | Point | - | - | - | - | S278006 | COTTER ST: ALEMANY BLVD | - | F | F | - | F | 21777000 | 21777000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ALEMANY BLVD | COTTER ST | 121053 | 121053 | 37.7281713 | -122.43497335 | COTTER ST \ ALEMANY BLVD | ALEMANY BLVD \ COTTER ST | 1727298622000 | middleware_editor | RIGHT TURN ONLY (SYM) | COTTER ST intersection | - | ABOVE STOP SIGN | - | - | - | - | - | 117498 | 213235200000 | -122.43497335 | 37.7281713 | - | 1634256000000 | - | D11 | - | OTHER REGULATORY | REG | R3-5.0001 | 24X30 | SUP2 | 2IN IRON POST | IS | 1633008660000 | ALEMANY BLVD | - | - | - | - | - | - |
| 100231 | N/A | Point | - | - | - | - | S278011 | COTTER ST: ALEMANY BLVD | - | F | F | - | F | 21777000 | 21777000 | - | - | NORTH EAST CORNER | - | - | - | - | ALEMANY BLVD | COTTER ST | 121057 | 121057 | 37.7281713 | -122.43497335 | COTTER ST \ ALEMANY BLVD | ALEMANY BLVD \ COTTER ST | 1727313982000 | middleware_editor | ALEMANY BLVD | COTTER ST intersection | - | - | - | - | - | - | - | 117499 | 213235200000 | -122.43497335 | 37.7281713 | - | 1634688000000 | - | D11 | - | STREET NAME | GUIDE | D3-1.0076 | 36X08 | SUP2 | 3IN IRON POST | IS | 1633009560000 | ALEMANY BLVD | - | - | - | - | - | - |
| 100232 | N/A | Point | - | - | - | - | S278010 | COTTER ST: ALEMANY BLVD | - | F | F | - | F | 21777000 | 21777000 | - | - | SOUTH EAST CORNER | - | - | - | - | ALEMANY BLVD | COTTER ST | 123122 | 123122 | 37.7281713 | -122.43497335 | COTTER ST \ ALEMANY BLVD | ALEMANY BLVD \ COTTER ST | 1727313982000 | middleware_editor | ALEMANY BLVD | COTTER ST intersection | - | - | - | - | - | - | - | 117500 | 213235200000 | -122.43497335 | 37.7281713 | - | 1635206400000 | - | D11 | - | STREET NAME | GUIDE | D3-1.0076 | 36X08 | SUP2 | 3IN IRON POST | IS | 1633009440000 | ALEMANY BLVD | - | - | - | - | - | - |
| 100233 | N/A | Point | - | - | - | - | S107285 | COTTER ST: ALEMANY BLVD | - | F | F | - | F | 21777000 | 21777000 | - | - | NORTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ALEMANY BLVD | COTTER ST | 105919 | 105919 | 37.7281713 | -122.43497335 | COTTER ST \ ALEMANY BLVD | ALEMANY BLVD \ COTTER ST | 1727313983000 | middleware_editor | STOP | COTTER ST intersection | - | - | - | - | - | - | - | 117501 | 213235200000 | -122.43497335 | 37.7281713 | - | 1597363200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569800000 | ALEMANY BLVD | - | - | - | - | - | - |
| 100234 | N/A | Point | - | - | - | - | S275593 | ALEMANY BLVD: COTTER ST | - | F | F | - | F | 21777000 | 21777000 | - | - | CENTER ISLAND, N LINE, SOUTHBOUND | - | - | - | - | ALEMANY BLVD | COTTER ST | 115184 | 115184 | 37.7281713 | -122.43497335 | COTTER ST \ ALEMANY BLVD | ALEMANY BLVD \ COTTER ST | 1727313983000 | middleware_editor | SCHOOL (SYM)/ 45 LEFT DN ARROW (COMBO) | COTTER ST intersection | - | - | - | - | - | - | - | 117502 | 1176163200000 | -122.43497335 | 37.7281713 | - | 1441152000000 | - | D11 | - | SCHOOL | WARNING | SW24-2(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1624356960000 | ALEMANY BLVD | - | - | - | - | - | - |
| 100235 | N/A | Point | - | - | - | - | S290322 | DIAMOND ST: 27TH ST | - | F | F | - | F | 22040000 | 22040000 | - | - | SOUTH WEST CORNER | - | - | - | - | DIAMOND ST | 27TH ST | 103945 | 103945 | 37.74637267 | -122.43584086 | 27TH ST \ DIAMOND ST | DIAMOND ST \ 27TH ST | 1710539427000 | MTA | DIAMOND ST | 27TH ST intersection | - | <1400 SOUTH | - | - | - | - | - | 117503 | 1502064000000 | -122.43584086 | 37.74637267 | - | 1697204100000 | - | D8 | - | STREET NAME | GUIDE | D3-1.0529 | 36X08 | SUP2 | 3IN IRON POST | IS | 1688128560000 | DIAMOND ST | - | - | - | - | - | - |
| 100236 | N/A | Point | - | - | - | - | 24652 | - | - | F | F | - | F | 2162101 | - | - | - | NORTH EAST CORNER | 1697232219000 | MMENDIET | - | - | TINGLEY ST | - | 162417 | 162417 | 37.7287346010792 | -122.434319250142 | - | - | 1710539427000 | MTA | THERESA ST | - | - | W <--100 | - | - | - | - | - | 117504 | - | - | - | - | 1703170500000 | 1703170500000 | 11 | - | STREET NAME | GUIDE | D3-1.1722 | 36X08 | SUP3 | SIGNAL POLE | RETD | - | ALEMANY BLVD | 1401 - 1459 ALEMANY BLVD | - | - | - | THERESA ST | - |
| 100237 | N/A | Point | 1 | - | - | LEFT ARROW | S207549 | 1-99 RICHLAND AVE | - | F | F | - | F | 11011002 | 11011000 | - | - | NORTH SIDE | - | - | - | - | MIGUEL ST | - | 48228 | 48228 | 37.73615237 | -122.4258687 | - | - | 1710539427000 | MTA | TANP ANY TIME | - | - | IFO #29 / 62FT EAST OF C.WALK (LA) | - | - | - | - | - | 117505 | 1405390380000 | -122.4258687 | 37.73615237 | - | 1639008000000 | - | D8 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP2 | 2IN IRON POST | IS | 1404910080000 | RICHLAND AVE | 1 - 99 RICHLAND AVE | RICHLAND AVE | - | - | MISSION ST | - |
| 100238 | N/A | Point | - | - | - | - | 25129 | - | - | - | - | - | - | 24498000 | - | - | - | CENTER ISLAND, W LINE, WESTBOUND | 1699029350000 | smuneno | - | - | FOLSOM ST | - | 167081 | 167081 | 37.787982552923 | -122.393780238921 | FREMONT ST \ FOLSOM ST | - | 1710539427000 | MTA | DETOUR (RA) | - | - | FOLSOM ST @ FREMONT , WEST SIDE OF W-LINE, X-WALK FOR WESTBOUND TRAFFIC | - | - | - | - | - | 117506 | 1700481600000 | - | - | - | - | - | 06 | - | OTHER GUIDE | GUIDE | M4-10.0001 | 48X16 | SUP1 | TYPE III BARRICADE | IS | - | FREMONT ST | - | - | - | - | - | - |
| 100239 | N/A | Point | - | - | - | - | 24235 | - | - | - | - | - | - | 34155000 | - | - | - | CENTER ISLAND, N LINE, NORTHBOUND | 1695745988000 | smuneno | - | - | CHANNEL ST | - | 157474 | 157474 | 37.7746330676662 | -122.389805428964 | 03RD ST \ CHANNEL ST | - | 1710539427000 | MTA | NO U TURN (SYM) | - | - | NORTH SIDE OF N-LINE, X-WALK | - | - | - | - | - | 117507 | - | - | - | - | 1699445700000 | - | 06 | - | OTHER REGULATORY | REG | R3-4.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | - | 03RD ST | - | - | - | - | - | - |
| 100240 | N/A | Point | 1 | 1 | 449 - 499 | - | S247102 | 449-499 CALIFORNIA ST | 449-499 CALIFORNIA ST | F | F | - | F | 3529000 | 3529000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | LEIDESDORFF ST | LEIDESDORFF ST | 83402 | 83402 | 37.79290278 | -122.40236226 | - | - | 1710539427000 | MTA | NO TURNS | LEIDESDORFF ST to MONTGOMERY ST (449 - 499) | - | 40 FT EAST OF MONTGOMERY | - | - | - | - | - | 117508 | - | -122.40236226 | 37.79290278 | - | 1703839500000 | - | D3 | - | OTHER REGULATORY | REG | R3-3.0001 | 30X30 | SUP1 | 2IN FLANGE POST | IS | 1531995120000 | CALIFORNIA ST | 449 - 499 CALIFORNIA ST | 449 - 499 CALIFORNIA ST | 449 CALIFORNIA ST | - | MONTGOMERY ST | MONTGOMERY ST |
| 100241 | N/A | Point | - | - | - | - | 25748 | - | - | F | F | - | F | 7166000 | - | - | - | WEST SIDE | 1701900388000 | elclark | - | - | MARIPOSA ST \ TERRY A FRANCOIS BLVD | - | 173571 | 173571 | 37.7642395832397 | -122.387999690331 | - | - | 1712785265000 | middleware_editor | FG 300 INTERSTATE GRADE CURB/FG 300 UR DELINEATOR(WHITE) | - | - | 5'-20' SOUTH OF XING | - | - | - | - | 5 | 117509 | 1712759400000 | - | - | - | - | - | 10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0017 | 36X03 | SUP1 | INTERSTATE BASE | IS | - | ILLINOIS ST | 600 - 699 ILLINOIS ST | - | - | - | 18TH ST | - |
| 100242 | N/A | Point | - | - | - | - | 25735 | - | - | F | F | - | F | 3529000 | - | - | - | NORTH SIDE | 1701890018000 | APADILLA | - | - | LEIDESDORFF ST | - | 173521 | 173521 | 37.7929537439781 | -122.402513112002 | - | - | 1710539427000 | MTA | TANSAT | - | - | 50FT EAST OF MONTGOMERY | - | - | - | - | - | 117510 | - | - | - | - | 1703843100000 | - | 03 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | - | CALIFORNIA ST | 449 - 499 CALIFORNIA ST | - | - | - | MONTGOMERY ST | - |
| 100243 | N/A | Point | - | - | - | - | 25774 | - | - | F | T | - | F | 22105000 | - | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | 1701971472000 | mmendiet | - | - | SAN JOSE AVE | - | 173841 | 173841 | 37.7208512990954 | -122.446656861387 | GENEVA AVE \ SAN JOSE AVE | - | 1710539427000 | MTA | (LA) TURNING VEHICLES YIELD(SYM) TO PED(SYM) | - | - | ABOVE SIGNAL HEAD. | - | - | - | - | - | 117511 | 1709286600000 | - | - | - | - | - | 11 | - | OTHER REGULATORY | REG | R10-15.0001 | 30X30 | SUP3 | MUNI POLE | IS | - | GENEVA AVE | - | - | - | - | - | - |
| 100244 | N/A | Point | 1 | 1 | 2100 - 2199 | LEFT ARROW | S284365 | 2100-2199 NORTH POINT ST | 2100-2199 NORTH POINT ST | F | F | - | F | 9701000 | 9701000 | - | - | NORTH SIDE | - | - | - | - | SCOTT ST | SCOTT ST | 91381 | 91381 | 37.80287972 | -122.44258373 | - | - | 1710539427000 | MTA | TA(SYM)PLO 8:45A9:45A M-F/3:30P4:30P MTTHF/2P3P W SCHL DAYS | SCOTT ST to DIVISADERO ST (2100 - 2199) | - | WPL # 2128 | - | - | - | - | - | 117512 | 1660262400000 | -122.44258373 | 37.80287972 | - | 1701951300000 | - | D2 | - | OTHER REGULATORY | REG | R38(SF)6.0115 | 14X21 | SUP1 | 2IN IRON POST | IS | 1659960480000 | NORTH POINT ST | 2100 - 2199 NORTH POINT ST | 2100 - 2199 NORTH POINT ST | 2100 NORTH POINT ST | - | DIVISADERO ST | DIVISADERO ST |
| 100245 | N/A | Point | - | - | - | - | S254719 | LAKE MERCED BLVD: WINSTON DR | - | F | F | - | F | 33512000 | 33512000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WINSTON DR | LAKE MERCED BLVD | 129823 | 129823 | 37.72701952 | -122.4838644 | LAKE MERCED BLVD \ WINSTON DR | WINSTON DR \ LAKE MERCED BLVD | 1710539427000 | MTA | BIKE WAYFINDING SIGN | LAKE MERCED BLVD intersection | 1000 | FOR MULTI USE PATH ADJACENT TO L.M.BLVD | - | - | - | - | - | 117513 | 1561561320000 | -122.4838644 | 37.72701952 | - | - | - | D7 | - | BIKE GUIDE | GUIDE | G-B(SF).0049 | 24X30 | SUP2 | SIGNAL POLE | IS | 1559218500000 | WINSTON DR | - | - | - | - | - | - |
| 100246 | N/A | Point | - | - | - | - | S212338 | LAKE MERCED BLVD: WINSTON DR | - | F | F | - | F | 33512000 | 33512000 | - | - | CENTER ISLAND, N LINE, SOUTHBOUND | - | - | - | - | WINSTON DR | LAKE MERCED BLVD | 51808 | 51808 | 37.72701952 | -122.4838644 | LAKE MERCED BLVD \ WINSTON DR | WINSTON DR \ LAKE MERCED BLVD | 1752876349000 | middleware_editor | 2 LEFT LANES MUST TURN LEFT | LAKE MERCED BLVD intersection | - | - | - | - | - | - | - | 117514 | - | -122.4838644 | 37.72701952 | - | 1752873900000 | - | D7 | - | OTHER REGULATORY | REG | R3-7(SF).0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1420540620000 | WINSTON DR | - | - | - | - | - | - |
| 100247 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S245980 | 2000-2099 GREEN ST | 2000-2099 GREEN ST | F | F | - | F | 6473000 | 6473000 | - | - | NORTH SIDE | - | - | - | - | BUCHANAN ST | BUCHANAN ST | 83709 | 83709 | 37.7964707 | -122.4328369 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "K" PERMITS | BUCHANAN ST to WEBSTER ST (2000 - 2099) | - | 2090 GREEN | - | - | - | - | - | 117515 | 1219881600000 | -122.4328369 | 37.7964707 | - | 1702651200000 | - | D2 | - | PARKING:RPP | REG | R32C(CA).0092 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1527851340000 | GREEN ST | 2000 - 2099 GREEN ST | 2000 - 2099 GREEN ST | 2000 GREEN ST | - | WEBSTER ST | WEBSTER ST |
| 100248 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S206909 | 2000-2099 GREEN ST | 2000-2099 GREEN ST | F | F | - | F | 6473000 | 6473000 | - | - | NORTH SIDE | - | - | - | - | BUCHANAN ST | BUCHANAN ST | 79765 | 79765 | 37.7964707 | -122.4328369 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "K" PERMITS | BUCHANAN ST to WEBSTER ST (2000 - 2099) | - | IFO 2060 | - | - | - | - | - | 117516 | 1405610640000 | -122.4328369 | 37.7964707 | - | 1405555200000 | - | D2 | - | PARKING:RPP | REG | R32C(CA).0092 | 18X21 | SUP1 | LIGHT POLE | IS | 1402934580000 | GREEN ST | 2000 - 2099 GREEN ST | 2000 - 2099 GREEN ST | 2000 GREEN ST | - | WEBSTER ST | WEBSTER ST |
| 100249 | N/A | Point | - | - | - | - | S105235 | WEBSTER ST: GREEN ST | - | F | F | - | F | 26661000 | 26661000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WEBSTER ST | GREEN ST | 1138 | 1138 | 37.79636664 | -122.4336579 | GREEN ST \ WEBSTER ST | WEBSTER ST \ GREEN ST | 1753977306000 | middleware_editor | STOP | GREEN ST intersection | - | 0 / 0 | - | - | - | - | - | 117517 | 61804800000 | -122.4336579 | 37.79636664 | - | 1142924400000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569140000 | WEBSTER ST | - | - | - | - | - | - |
| 100250 | N/A | Point | 1 | 1 | 100 - 199 | - | S255950 | 100-199 AVALON AVE | 100-199 AVALON AVE | F | F | - | F | 2556000 | 2556000 | - | - | SOUTH SIDE | - | - | - | - | LONDON ST | LONDON ST | 80944 | 80944 | 37.72711818 | -122.43136616 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM WED STCL | LONDON ST to PARIS ST (100 - 199) | - | EPL 118 | - | - | - | - | - | 117518 | 1570101600000 | -122.43136616 | 37.72711818 | - | - | - | D11 | - | STREET CLEANING | REG | R30B(CA).0273 | 18X18 | SUP2 | 2IN IRON POST | IS | 1562748840000 | AVALON AVE | 100 - 199 AVALON AVE | 100 - 199 AVALON AVE | 100 AVALON AVE | - | PARIS ST | PARIS ST |
| 100251 | N/A | Point | 1 | 1 | 100 - 199 | LEFT ARROW | S268121 | 100-199 AVALON AVE | 100-199 AVALON AVE | F | F | - | F | 2556000 | 2556000 | - | - | NORTH SIDE | - | - | - | - | LONDON ST | LONDON ST | 113372 | 113372 | 37.72711818 | -122.43136616 | - | - | 1710539427000 | MTA | TANS EXC 30 MIN 6 WHEEL COM VEH 6AM-1PM MON-SAT | LONDON ST to PARIS ST (100 - 199) | - | MIDDLE OF INTERSECTION OF PARIS | - | - | - | - | - | 117519 | 1570060800000 | -122.43136616 | 37.72711818 | - | 1600905600000 | - | D11 | - | OTHER REGULATORY | REG | R37(SF).0427 | 18X21 | SUP2 | 2IN IRON POST | IS | 1600331100000 | AVALON AVE | 100 - 199 AVALON AVE | 100 - 199 AVALON AVE | 100 AVALON AVE | - | PARIS ST | PARIS ST |
| 100252 | N/A | Point | - | - | - | - | S127607 | PARIS ST: AVALON AVE | - | F | F | - | F | 21690000 | 21690000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | PARIS ST | AVALON AVE | 20859 | 20859 | 37.72692568 | -122.43096519 | AVALON AVE \ PARIS ST | PARIS ST \ AVALON AVE | 1710539427000 | MTA | STOP | AVALON AVE intersection | - | - | - | - | - | - | - | 117520 | 1180569600000 | -122.43096519 | 37.72692568 | - | 1517961600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373576160000 | PARIS ST | - | - | - | - | - | - |
| 100253 | N/A | Point | 1 | 1 | 200 - 299 | - | S257714 | 200-299 AVALON AVE | 200-299 AVALON AVE | F | F | - | F | 2557000 | 2557000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | PARIS ST | PARIS ST | 86670 | 86670 | 37.72673473 | -122.43056744 | - | - | 1710539427000 | MTA | SCHOOL (SYM) AHEAD | PARIS ST to LISBON ST (200 - 299) | - | EPL 206 | - | - | - | - | - | 117521 | 1568645100000 | -122.43056744 | 37.72673473 | - | - | - | D11 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1568280300000 | AVALON AVE | 200 - 299 AVALON AVE | 200 - 299 AVALON AVE | 200 AVALON AVE | - | LISBON ST | LISBON ST |
| 100254 | N/A | Point | - | - | - | - | S269437 | MONTEREY BLVD: EDNA ST | - | F | F | - | F | 22162000 | 22162000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | MONTEREY BLVD | EDNA ST | 110291 | 110291 | 37.73154905 | -122.4465784 | EDNA ST \ MONTEREY BLVD | MONTEREY BLVD \ EDNA ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) | EDNA ST intersection | - | ABOVE STOP SIGN | - | - | - | - | - | 117522 | 1603980900000 | -122.4465784 | 37.73154905 | - | 1685491200000 | - | D7 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1603357920000 | MONTEREY BLVD | - | - | - | - | - | - |
| 100255 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S102836 | 2300-2399 OFARRELL ST | 2300-2399 OFARRELL ST | F | F | - | F | 9744000 | 9744000 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | SAINT JOSEPHS AVE | SAINT JOSEPHS AVE | 113437 | 113437 | 37.78199568 | -122.4427148 | - | - | 1744067016000 | middleware_editor | DO NOT ENTER | SAINT JOSEPHS AVE to LYON ST \ VICHA RATANAPAKDEE WAY (2300 - 2399) | - | W LINE / MADE EASTBOUND ONE WAY | - | - | - | - | - | 117523 | -379958400000 | -122.4427148 | 37.78199568 | - | 1744059840000 | - | D2 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373568420000 | OFARRELL ST | 2300 - 2399 OFARRELL ST | 2300 - 2399 OFARRELL ST | 2300 OFARRELL ST | - | LYON ST \ VICHA RATANAPAKDEE WAY | LYON ST \ VICHA RATANAPAKDEE WAY |
| 100256 | N/A | Point | - | - | - | - | S279317 | OCEAN AVE: LEE AVE | - | T | T | - | F | 22223000 | 22223000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LEE AVE | LEE AVE | 109230 | 109230 | 37.72345701 | -122.45411575 | OCEAN AVE \ LEE AVE | OCEAN AVE \ LEE AVE | 1721351736000 | middleware_editor | SPEED LIMIT 20 | LEE AVE intersection | - | - | - | - | - | - | - | 117524 | 1054252800000 | -122.45411575 | 37.72345701 | - | 1568937600000 | - | D7 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP2 | OVERHEAD MAST ARM | IS | 1638866820000 | OCEAN AVE | - | - | - | - | - | - |
| 100257 | N/A | Point | - | - | - | - | 21531 | - | - | NO | NO | - | - | - | - | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1690927613000 | MTA | - | - | 22ND ST | - | 143919 | 143919 | 37.754637 | -122.418671 | - | - | 1722531297000 | middleware_editor | NO DBL PKG ANY TIME COMMERCIAL VEH INCLUDED | - | - | 20FT NORTH OF 23RD ST | - | - | - | - | - | 117525 | - | -122.418671 | 37.754637 | - | - | - | 09 | - | OTHER REGULATORY | REG | R39-2(CA).0001 | 18X18 | SUP3 | LIGHT POLE | D | - | - | - | - | - | - | 23RD ST | - |
| 100258 | N/A | Point | - | - | - | - | 21780 | - | - | NO | NO | - | - | - | - | - | - | WEST SIDE | 1690927613000 | MTA | - | - | 22ND ST | - | 144172 | 144172 | 37.754637 | -122.418671 | - | - | 1722531297000 | middleware_editor | NO DBL PKG ANY TIME COMMERCIAL VEH INCLUDED | - | - | IFO #2698 | - | - | - | - | - | 117526 | - | -122.418671 | 37.754637 | - | - | - | 09 | - | OTHER REGULATORY | REG | R39-2(CA).0001 | 18X18 | SUP3 | LIGHT POLE | D | - | - | - | - | - | - | 23RD ST | - |
| 100259 | N/A | Point | - | - | - | - | 21841 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1690927613000 | MTA | - | - | 22ND ST | - | 144206 | 144206 | 37.754637 | -122.418671 | - | - | 1722531297000 | middleware_editor | NO DBL PKG ANY TIME COMMERCIAL VEH INCLUDED | - | - | IFO #2631 | - | - | - | - | - | 117527 | - | -122.418671 | 37.754637 | - | - | - | 09 | - | OTHER REGULATORY | REG | R39-2(CA).0001 | 18X18 | SUP3 | LIGHT POLE | D | - | - | - | - | - | - | 23RD ST | - |
| 100260 | N/A | Point | - | - | - | - | 21825 | - | - | NO | NO | - | - | - | - | - | - | EAST SIDE | 1690927613000 | MTA | - | - | 22ND ST | - | 144208 | 144208 | 37.754637 | -122.418671 | - | - | 1722531297000 | middleware_editor | NO DBL PKG ANY TIME COMMERCIAL VEH INCLUDED | - | - | IFO #2695 | - | - | - | - | - | 117528 | - | -122.418671 | 37.754637 | - | - | - | 09 | - | OTHER REGULATORY | REG | R39-2(CA).0001 | 18X18 | SUP3 | LIGHT POLE | D | - | - | - | - | - | - | 23RD ST | - |
| 100261 | N/A | Point | - | - | - | - | S273976 | EVANS AVE: JENNINGS ST \ MIDDL | - | F | F | - | F | 20177000 | 20177000 | - | - | CENTER ISLAND, S LINE, EASTBOUND | - | - | - | - | EVANS AVE \ MIDDLE POINT RD | EVANS AVE \ MIDDLE POINT RD | 114622 | 114622 | 37.73768029 | -122.37910965 | JENNINGS ST \ EVANS AVE \ MIDDLE POINT RD | JENNINGS ST \ EVANS AVE \ MIDDLE POINT RD | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | EVANS AVE \ MIDDLE POINT RD intersection | - | AT END OF TRANSIT ISL, 95' W OF MIDD PNT | - | - | - | - | - | 117529 | 1618580760000 | -122.37910965 | 37.73768029 | - | - | - | D10 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1618399980000 | JENNINGS ST | - | - | - | - | - | - |
| 100262 | N/A | Point | - | - | - | - | S117197 | PERU AVE: MADRID ST | - | F | F | - | F | 21681000 | 21681000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | PERU AVE | PERU AVE | 11926 | 11926 | 37.72784593 | -122.42811583 | MADRID ST \ PERU AVE | MADRID ST \ PERU AVE | 1751387452000 | middleware_editor | STOP | PERU AVE intersection | - | - | - | - | - | - | - | 117530 | 1057820400000 | -122.42811583 | 37.72784593 | - | 1751305500000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373572920000 | MADRID ST | - | - | - | - | - | - |
| 100263 | N/A | Point | - | - | - | - | S109147 | POWELL ST: SUTTER ST | - | F | F | - | F | 24909000 | 24909000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | POWELL ST | SUTTER ST | 6886 | 6886 | 37.78922562 | -122.40859505 | SUTTER ST \ POWELL ST | POWELL ST \ SUTTER ST | 1729098012000 | middleware_editor | NO LEFT TURN (SYM) | SUTTER ST intersection | - | DURING CABLE CAR CONSTRUCTION | - | - | - | - | - | 117531 | 406771200000 | -122.40859505 | 37.78922562 | - | - | 1729072740000 | D3 | - | NO LEFT TURN | REG | R3-2.0001 | 24X24 | SUP1 | SIGNAL POLE | RETD | 1373570400000 | POWELL ST | - | - | - | - | - | - |
| 100264 | N/A | Point | - | - | - | - | S110814 | MISSION ST: FOOTE AVE | - | F | F | - | F | 21505000 | 21505000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FOOTE AVE | FOOTE AVE | 9511 | 9511 | 37.71262222 | -122.44474329 | MISSION ST \ FOOTE AVE | MISSION ST \ FOOTE AVE | 1710539427000 | MTA | STOP | FOOTE AVE intersection | - | - | - | - | - | - | - | 117532 | 707011200000 | -122.44474329 | 37.71262222 | - | - | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | MUNI POLE | IS | 1373570940000 | MISSION ST | - | - | - | - | - | - |
| 100265 | N/A | Point | - | - | - | - | S273435 | SUTTER ST: FRANKLIN ST | - | F | F | - | F | 25220000 | 25220000 | - | - | NORTH WEST CORNER | - | - | - | - | SUTTER ST | FRANKLIN ST | 111693 | 111693 | 37.78733916 | -122.42340359 | FRANKLIN ST \ SUTTER ST | SUTTER ST \ FRANKLIN ST | 1710539427000 | MTA | SUTTER ST | FRANKLIN ST intersection | - | I<1400BLK | - | - | - | - | - | 117533 | 1508457600000 | -122.42340359 | 37.78733916 | - | 1616630400000 | - | D2 | - | STREET NAME | GUIDE | D3-1.1694 | 36X08 | SUP1 | LIGHT POLE | IS | 1616425800000 | SUTTER ST | - | - | - | - | - | - |
| 100266 | N/A | Point | - | - | - | - | S284756 | MISSION ST: FOOTE AVE | - | T | T | - | F | 21505000 | 21505000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FOOTE AVE | FOOTE AVE | 122824 | 122824 | 37.71262222 | -122.44474329 | MISSION ST \ FOOTE AVE | MISSION ST \ FOOTE AVE | 1710539427000 | MTA | SPEED LIMIT 25 | FOOTE AVE intersection | - | - | - | - | - | - | - | 117534 | 1666569600000 | -122.44474329 | 37.71262222 | - | - | - | D11 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP2 | LIGHT POLE | IS | 1661425020000 | MISSION ST | - | - | - | - | - | - |
| 100267 | N/A | Point | - | - | - | - | S117978 | MISSION ST: FOOTE AVE | - | F | F | - | F | 21505000 | 21505000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | FOOTE AVE | FOOTE AVE | 11117 | 11117 | 37.71262222 | -122.44474329 | MISSION ST \ FOOTE AVE | MISSION ST \ FOOTE AVE | 1710539427000 | MTA | NO LEFT TURN (SYM) | FOOTE AVE intersection | - | - | - | - | - | - | - | 117535 | 1069286400000 | -122.44474329 | 37.71262222 | - | - | - | D11 | - | NO LEFT TURN | REG | R3-2.0003 | 36X36 | SUP2 | LIGHT POLE | IS | 1373573160000 | MISSION ST | - | - | - | - | - | - |
| 100268 | N/A | Point | - | - | - | - | S231659 | PARKER AVE: GOLDEN GATE AVE | - | F | F | - | F | 26473000 | 26473000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PARKER AVE | GOLDEN GATE AVE | 64248 | 64248 | 37.77685343 | -122.45318833 | GOLDEN GATE AVE \ PARKER AVE | PARKER AVE \ GOLDEN GATE AVE | 1710539427000 | MTA | ALL WAY | GOLDEN GATE AVE intersection | - | - | - | - | - | - | - | 117536 | 304128000000 | -122.45318833 | 37.77685343 | - | 1559606400000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1481213640000 | PARKER AVE | - | - | - | - | - | - |
| 100269 | N/A | Point | - | - | - | - | S107078 | FOOTE AVE: MISSION ST | - | F | F | - | F | 21505000 | 21505000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FOOTE AVE | FOOTE AVE | 6320 | 6320 | 37.71262222 | -122.44474329 | MISSION ST \ FOOTE AVE | MISSION ST \ FOOTE AVE | 1710539427000 | MTA | STOP | FOOTE AVE intersection | - | 0 / 00 | - | - | - | - | - | 117537 | 189734400000 | -122.44474329 | 37.71262222 | - | 657504000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373569740000 | MISSION ST | - | - | - | - | - | - |
| 100270 | N/A | Point | - | - | - | - | S200212 | PARKER AVE: GOLDEN GATE AVE | - | F | F | - | F | 26473000 | 26473000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | PARKER AVE | GOLDEN GATE AVE | 46089 | 46089 | 37.77685343 | -122.45318833 | GOLDEN GATE AVE \ PARKER AVE | PARKER AVE \ GOLDEN GATE AVE | 1710539427000 | MTA | STOP | GOLDEN GATE AVE intersection | - | 311#3035563 | - | - | - | - | - | 117538 | - | -122.45318833 | 37.77685343 | - | - | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN FLANGE POST | IS | 1383824520000 | PARKER AVE | - | - | - | - | - | - |
| 100271 | N/A | Point | - | - | - | - | S231660 | PARKER AVE: GOLDEN GATE AVE | - | F | F | - | F | 26473000 | 26473000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | PARKER AVE | GOLDEN GATE AVE | 64249 | 64249 | 37.77685343 | -122.45318833 | GOLDEN GATE AVE \ PARKER AVE | PARKER AVE \ GOLDEN GATE AVE | 1710539427000 | MTA | ALL WAY | GOLDEN GATE AVE intersection | - | - | - | - | - | - | - | 117539 | -395020800000 | -122.45318833 | 37.77685343 | - | 1492041600000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1481214000000 | PARKER AVE | - | - | - | - | - | - |
| 100272 | N/A | Point | - | - | - | - | S117977 | MISSION ST: FOOTE AVE | - | F | F | - | F | 21505000 | 21505000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FOOTE AVE | FOOTE AVE | 11116 | 11116 | 37.71262222 | -122.44474329 | MISSION ST \ FOOTE AVE | MISSION ST \ FOOTE AVE | 1710539427000 | MTA | NO RIGHT TURN (SYM) | FOOTE AVE intersection | - | OPP.C-LINE | - | - | - | - | - | 117540 | 1069286400000 | -122.44474329 | 37.71262222 | - | - | - | D11 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP2 | SIGNAL POLE | IS | 1373573160000 | MISSION ST | - | - | - | - | - | - |
| 100273 | N/A | Point | 1 | 1 | 5420 - 5499 | - | S209478 | 5420-5499 MISSION ST | 5420-5499 MISSION ST | T | T | - | F | 9186000 | 9186000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | FLORENTINE AVE | FLORENTINE AVE | 50733 | 50733 | 37.71307276 | -122.44426136 | - | - | 1710539427000 | MTA | YIELD HERE TO PED (SYM) (LA) | FLORENTINE AVE to GUTTENBERG ST (5420 - 5499) | - | 50`NORT OF CROSSWALK (OPP SHARK TEETH) | - | - | - | - | - | 117541 | 1419855000000 | -122.44426136 | 37.71307276 | - | 1419811200000 | - | D11 | - | PEDESTRIAN | REG | R1-5.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1411648980000 | MISSION ST | 5420 - 5499 MISSION ST | 5420 - 5499 MISSION ST | 5420 MISSION ST | - | GUTTENBERG ST | GUTTENBERG ST |
| 100274 | N/A | Point | 1 | 1 | 2100 - 2199 | - | S207671 | 2100-2199 FILBERT ST | 2100-2199 FILBERT ST | F | F | - | F | 5521000 | 5521000 | - | - | SOUTH SIDE | - | - | - | - | WEBSTER ST | WEBSTER ST | 48171 | 48171 | 37.7981256 | -122.43485696 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "K" PERMITS | WEBSTER ST to FILLMORE ST (2100 - 2199) | - | 75 FEET WEST OF WEBSTER | - | - | - | - | - | 117542 | 1219622400000 | -122.43485696 | 37.7981256 | - | 1495065600000 | - | D2 | - | PARKING:RPP | REG | R32C(CA).0092 | 18X21 | SUP1 | 2IN IRON POST | IS | 1405441080000 | FILBERT ST | 2100 - 2199 FILBERT ST | 2100 - 2199 FILBERT ST | 2100 FILBERT ST | - | FILLMORE ST | FILLMORE ST |
| 100275 | N/A | Point | 1 | 1 | 2100 - 2199 | - | S139294 | 2100-2199 FILBERT ST | 2100-2199 FILBERT ST | F | F | - | F | 5521000 | 5521000 | - | - | SOUTH SIDE | - | - | - | - | WEBSTER ST | WEBSTER ST | 30962 | 30962 | 37.7981256 | -122.43485696 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM 1ST & 3RD FRI OF MONTH STCL | WEBSTER ST to FILLMORE ST (2100 - 2199) | - | 75 FEET WEST OF WEBSTER | - | - | - | - | - | 117543 | 1219622400000 | -122.43485696 | 37.7981256 | - | 1542240000000 | - | D2 | - | STREET CLEANING | REG | R30(CA).0035 | 18X18 | SUP1 | 2IN IRON POST | IS | 1375724580000 | FILBERT ST | 2100 - 2199 FILBERT ST | 2100 - 2199 FILBERT ST | 2100 FILBERT ST | - | FILLMORE ST | FILLMORE 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 metersMetadata automatically harvested from the ESRI service during import.