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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 101176 | N/A | Point | - | - | - | - | S115397 | - | - | F | F | - | F | 2184010 | - | R1-3P.0001-2002-08-20 00:00:00-37.736671--122.359657 | - | CENTER ISLAND, WESTBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 132534 | 132534 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | ALL WAY | - | - | W-LINE OF E-CI PER PO | - | - | - | - | - | 118451 | 1029801600000 | - | - | - | - | - | D7 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | - | - | 3900-3959 ALEMANY BLVD | - | - | - | - | - |
| 101177 | N/A | Point | - | - | - | - | S114338 | - | - | F | F | - | F | 2183020 | - | R32C(CA).0156-2001-10-25 00:00:00-37.736671--122.359657 | - | SOUTH SIDE | 1689201652000 | MTA | - | - | - | - | 132537 | 132537 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | 2 HR PRK 9AM-5PM MON-FRI EXC "B" PERMITS | - | - | 9`EAST OF WORCESTER | - | - | - | - | - | 118452 | 1003968000000 | - | - | - | - | - | D7 | - | PARKING:RPP | REG | R32C(CA).0156 | 18X21 | SUP2 | 2IN IRON POST | IS | - | - | 3700-3799 ALEMANY BLVD | - | - | - | - | - |
| 101178 | N/A | Point | - | - | - | - | S285669 | - | - | F | F | - | F | 10613000 | - | - | - | NORTH SIDE, WESTBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 141312 | 141312 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | TANSAT | - | - | 160 FEET EAST OF TWIN PEAKS | - | - | - | - | - | 118453 | - | - | - | - | 1668729600000 | - | D8 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | LIGHT POLE | IS | - | - | 450-499 PORTOLA DR | - | - | - | - | - |
| 101179 | N/A | Point | - | - | - | - | S110551 | - | - | F | F | - | F | 2824020 | - | R6-1.0003-1990-10-30 00:00:00-37.736671--122.359657 | - | CENTER ISLAND, EASTBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 140566 | 140566 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | ONE WAY (RA) | - | - | C LINE | - | - | - | - | - | 118454 | 657244800000 | - | - | - | - | - | D10 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | 2IN IRON POST | IS | - | - | 2200-2399 BAYSHORE BLVD | - | - | - | - | - |
| 101180 | N/A | Point | - | - | - | - | S243947 | - | - | F | F | - | F | 99990933 | - | D3-1.1931-2018-03-21 14:06:00-37.736671--122.359657 | - | WEST SIDE | 1689201652000 | MTA | - | - | - | - | 132547 | 132547 | 37.736671 | -122.359657 | - | - | 1757011251000 | middleware_editor | PIERPOINT | - | - | 300 --> W @ TERRY A FRANCIOS | - | - | - | - | - | 118455 | 1521666360000 | - | - | - | 1521615600000 | - | - | - | STREET NAME | GUIDE | D3-1.1931 | 36X08 | - | 3IN IRON POST | IS | - | - | PENDING TERRY A FRANCOIS BLVD | - | - | - | - | - |
| 101181 | N/A | Point | - | - | - | - | S276453 | - | - | F | F | - | F | 99991932 | - | R26(CA).0001-2021-07-27 12:42:00-37.736671--122.359657 | - | SOUTH SIDE | 1689201652000 | MTA | - | - | - | - | 132541 | 132541 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NPRK ANY TIME | - | - | 20' E OF GRANT | - | - | - | - | - | 118456 | 1627389720000 | - | - | - | - | - | - | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | - | LIGHT POLE | IS | - | - | PENDING HARLAN PL | - | - | - | - | - |
| 101182 | N/A | Point | - | - | - | - | S284964 | - | - | F | F | - | F | 14312000 | - | - | - | SOUTH SIDE | 1689201652000 | MTA | - | - | CRAVATH ST | - | 141313 | 141313 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | - | - | S/E CORNER @ JOHNSON (GARDEN WALK) | - | - | - | - | - | 118457 | - | - | - | - | - | - | D6 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP1 | LIGHT POLE | IS | - | - | 400 - 499 GARDEN WALK | - | - | - | JOHNSON ST | - |
| 101183 | N/A | Point | - | - | - | - | S247883 | - | - | F | F | - | F | 13580201 | - | PROVISIONAL CODE-None-37.736671--122.359657 | - | EAST SIDE | 1689201652000 | MTA | - | - | 15TH AVE | - | 132546 | 132546 | 37.7363916925226 | -122.470875668591 | - | - | 1745417792000 | middleware_editor | NPRK 6:30AM-8AM MONDAY STCL | - | - | IFO# 415 | - | - | - | - | - | 118458 | - | - | - | - | - | - | D7 | - | STREET CLEANING | REG | R30B(CA).0341 | 18X18 | SUP2 | 2 POST ALUMINUM | IS | - | - | 400 - 498 WEST PORTAL AVE | - | - | - | JUNIPERO SERRA BLVD \ PORTOLA DR \ SAINT FRANCIS BLVD \ SLOAT BLVD | - |
| 101184 | N/A | Point | - | - | - | - | S112482 | - | - | F | F | - | F | 187000 | - | G-N(SF).0005-2000-03-13 00:00:00-37.736671--122.359657 | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 132538 | 132538 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | (VA) NORTH I-101(SYM) I-280 (SYM)/SOUTH (RA) | - | - | 100'N CI | - | - | - | - | - | 118459 | 952905600000 | - | - | - | - | - | D10 | - | OTHER GUIDE | GUIDE | G-N(SF).0005 | 54X42 | SUP1 | LIGHT POLE | IS | - | - | 2000-2099 3RD ST | - | - | - | - | - |
| 101185 | N/A | Point | - | - | - | - | S279074 | - | - | F | F | - | F | 2484000 | - | SW24-3(CA).0001-None-37.736671--122.359657 | - | NORTH SIDE, WESTBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 132540 | 132540 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | SCHOOL (SYM) AHEAD | - | - | IFO 3050 15 FT WEST OF ALABAMA | - | - | - | - | - | 118460 | - | - | - | - | 1653436800000 | - | D9 | - | SCHOOL AHEAD | WARNING | SW24-3(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | - | - | 3038-3099 CESAR CHAVEZ ST | - | - | - | - | - |
| 101186 | N/A | Point | - | - | - | - | S279994 | - | - | F | F | - | F | 13148010 | - | R30B(CA).0113-None-37.736671--122.359657 | - | EAST SIDE | 1689201652000 | MTA | - | - | - | - | 132544 | 132544 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM EVERYDAY INCLUDING HOLIDAY STCL | - | - | 25' S OF ELM | - | - | - | - | - | 118461 | 1643760000000 | - | - | - | - | - | D6 | - | STREET CLEANING | REG | R30B(CA).0113 | 18X18 | SUP1 | LIGHT POLE | IS | - | - | 600-649 VAN NESS AVE | - | - | - | - | - |
| 101187 | N/A | Point | - | - | - | - | S239360 | - | - | F | F | - | F | 99991020 | - | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | 1689201652000 | MTA | - | - | - | - | 134894 | 134894 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | GROOVED PAVEMENT | - | - | ON LP# 54 | - | - | - | - | - | 118462 | 1514994660000 | - | - | - | 1514937600000 | - | - | - | OTHER WARNING | WARNING | W8-15.0001 | 48X48 | - | LIGHT POLE | IS | - | - | PENDING O SHAUGHNESSY BLVD | - | - | - | - | - |
| 101188 | N/A | Point | 1 | 1 | 1000 - 1199 | - | S287337 | 1000-1199 EDDY ST | 1000-1199 EDDY ST | F | F | - | F | 5068000 | 5068000 | - | - | SOUTH SIDE | - | - | - | - | GOUGH ST | GOUGH ST | 101882 | 101882 | 37.782267 | -122.4257523 | - | - | 1710539427000 | MTA | BIKE RACK | GOUGH ST to LAGUNA ST (1000 - 1199) | 621936 | 442' W OF GOUGH/3' IN FROM CURB | - | - | - | - | - | 118463 | 1675728000000 | -122.4257523 | 37.782267 | - | - | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1675252380000 | EDDY ST | 1000 - 1199 EDDY ST | 1000 - 1199 EDDY ST | 1000 EDDY ST | - | LAGUNA ST | LAGUNA ST |
| 101189 | N/A | Point | 1 | 1 | 3000 - 3099 | - | S148506 | 3000-3099 25TH AVE | 3000-3099 25TH AVE | F | F | - | F | 1396000 | 1396000 | - | - | EAST SIDE | - | - | - | - | OCEAN AVE | OCEAN AVE | 39344 | 39344 | 37.73181462 | -122.48094681 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM 2ND & 4TH WED OF MONTH STCL | OCEAN AVE to EUCALYPTUS DR (3000 - 3099) | - | 3000 25TH AVE | - | - | - | - | - | 118465 | 1225238400000 | -122.48094681 | 37.73181462 | - | 1706097360000 | - | D7 | - | STREET CLEANING | REG | R30B(CA).0258 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375728900000 | 25TH AVE | 3000 - 3099 25TH AVE | 3000 - 3099 25TH AVE | 3000 25TH AVE | - | EUCALYPTUS DR | EUCALYPTUS DR |
| 101190 | N/A | Point | 1 | 1 | 500 - 599 | - | S260244 | 500-599 CAPP ST | 500-599 CAPP ST | F | F | - | F | 3677000 | 3677000 | - | - | WEST SIDE | - | - | - | - | 20TH ST | 20TH ST | 94716 | 94716 | 37.75789961 | -122.4178883 | - | - | 1710539427000 | MTA | BIKE RACK | 20TH ST to 21ST ST (500 - 599) | 91384 | 11' S OF NPL #500/2.5' IN FROM CURB | - | - | - | - | - | 118466 | 1579010820000 | -122.4178883 | 37.75789961 | - | - | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1578898680000 | CAPP ST | 500 - 599 CAPP ST | 500 - 599 CAPP ST | 500 CAPP ST | - | 21ST ST | 21ST ST |
| 101191 | N/A | Point | 1 | 1 | 500 - 599 | - | S288835 | 500-599 CAPP ST | 500-599 CAPP ST | T | T | - | F | 3677000 | 3677000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | 20TH ST | 20TH ST | 97152 | 97152 | 37.75789961 | -122.4178883 | - | - | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | 20TH ST to 21ST ST (500 - 599) | - | SPL# 558 | - | - | - | - | - | 118467 | 1682640000000 | -122.4178883 | 37.75789961 | - | - | - | D9 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | LIGHT POLE | IS | 1682416680000 | CAPP ST | 500 - 599 CAPP ST | 500 - 599 CAPP ST | 500 CAPP ST | - | 21ST ST | 21ST ST |
| 101192 | N/A | Point | 1 | 1 | 500 - 599 | - | S288836 | 500-599 CAPP ST | 500-599 CAPP ST | T | T | - | F | 3677000 | 3677000 | - | - | WEST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 20TH ST | 20TH ST | 97153 | 97153 | 37.75789961 | -122.4178883 | - | - | 1713878366000 | middleware_editor | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | 20TH ST to 21ST ST (500 - 599) | - | SPL# 558 | - | - | - | - | - | 118468 | 1683504000000 | -122.4178883 | 37.75789961 | - | - | - | D9 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | LIGHT POLE | IS | 1682416920000 | CAPP ST | 500 - 599 CAPP ST | 500 - 599 CAPP ST | 500 CAPP ST | - | 21ST ST | 21ST ST |
| 101193 | N/A | Point | 1 | - | - | - | S219442 | 2400-2499 MISSION ST | - | F | F | - | F | 9122000 | 9122000 | - | - | WEST SIDE | - | - | - | - | - | - | 58295 | 58295 | 37.75783399 | -122.41897682 | - | - | 1710539427000 | MTA | BIKE RACK | - | 20154416 | IFO 2430 SEE PAINT | - | - | - | - | - | 118469 | 1443516840000 | -122.41897682 | 37.75783399 | - | 1443484800000 | - | D9 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP2 | BIKE RACK | IS | 1443000060000 | MISSION ST | 2400-2499 MISSION ST | MISSION ST | - | - | - | - |
| 101194 | N/A | Point | 1 | 1 | 300 - 399 | - | S203158 | 300-399 SAN CARLOS ST | 300-399 SAN CARLOS ST | F | F | - | F | 11406000 | 11406000 | - | - | EAST SIDE | - | - | - | - | 20TH ST | 20TH ST | 42820 | 42820 | 37.75778646 | -122.41976522 | - | - | 1754941304000 | middleware_editor | NPRK ANY TIME | 20TH ST to 21ST ST (300 - 399) | - | OPP#378 | - | - | - | - | - | 118470 | 1428611880000 | -122.41976522 | 37.75778646 | - | 1428562800000 | - | D9 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0002 | 18X18 | SUP2 | 2IN IRON POST | IS | 1392886380000 | SAN CARLOS ST | 300 - 399 SAN CARLOS ST | 300 - 399 SAN CARLOS ST | 300 SAN CARLOS ST | - | 21ST ST | 21ST ST |
| 101195 | N/A | Point | 1 | 1 | 300 - 399 | - | S207820 | 300-399 SAN CARLOS ST | 300-399 SAN CARLOS ST | F | F | - | F | 11406000 | 11406000 | - | - | WEST SIDE | - | - | - | - | 20TH ST | 20TH ST | 48061 | 48061 | 37.75778646 | -122.41976522 | - | - | 1710539427000 | MTA | 1 HR PRK 9AM-6PM MON-SAT EXC "I" PERMITS | 20TH ST to 21ST ST (300 - 399) | - | NPL #350 SAN CARLOS ST. | - | - | - | - | - | 118471 | - | -122.41976522 | 37.75778646 | - | - | - | D9 | - | PARKING:RPP | REG | R32C(CA).0018 | 18X21 | SUP2 | 2IN IRON POST | IS | 1406109720000 | SAN CARLOS ST | 300 - 399 SAN CARLOS ST | 300 - 399 SAN CARLOS ST | 300 SAN CARLOS ST | - | 21ST ST | 21ST ST |
| 101196 | N/A | Point | - | - | - | - | S215828 | HAIGHT ST: FILLMORE ST | - | F | F | - | F | 25899000 | 25899000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FILLMORE ST | FILLMORE ST | 53975 | 53975 | 37.77210826 | -122.43043392 | HAIGHT ST \ FILLMORE ST | HAIGHT ST \ FILLMORE ST | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | FILLMORE ST intersection | - | - | - | - | - | - | - | 118472 | - | -122.43043392 | 37.77210826 | - | - | - | D5 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP1 | MUNI POLE | IS | 1430736480000 | HAIGHT ST | - | - | - | - | - | - |
| 101197 | N/A | Point | - | - | - | - | 24236 | - | - | - | T | - | - | 23796000 | - | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | 1695746912000 | smuneno | - | - | BERRY ST | - | 157444 | 157444 | 37.7774184840835 | -122.391106379306 | 03RD ST \ BERRY ST | - | 1710539427000 | MTA | LANE REDUCTION (SYM) LEFT | - | - | LEFT SIDE OF TSUNAMI SIGN/ ORANGE AND BLACK SIGN | - | - | - | - | - | 118473 | 1699440300000 | - | - | - | - | - | 06 | - | OTHER WARNING | WARNING | W4-2.0001 | 30X30 | SUP1 | OVERHEAD MAST ARM | IS | - | 03RD ST | - | - | - | - | - | - |
| 101198 | N/A | Point | - | - | - | - | 24241 | - | - | - | T | - | - | 184201 | - | - | - | EAST SIDE, NORTHBOUND TRAFFIC | 1695747251000 | smuneno | - | - | - | - | 157492 | 157492 | 37.7736122487257 | -122.389895530162 | - | - | 1711747606000 | middleware_editor | LEFT LANE MUST TURN LEFT | - | - | 290' SOUTH OF CHANNEL ST | - | - | - | - | - | 118474 | 1699452900000 | - | - | - | - | 1711548000000 | 06 | - | OTHER REGULATORY | REG | R3-7.0001 | 30X30 | SUP1 | LIGHT POLE | RETD | - | - | - | - | - | - | - | - |
| 101199 | N/A | Point | 1 | 1 | 2800 - 2899 | - | S150132 | 2800-2899 IRVING ST | 2800-2899 IRVING ST | F | F | - | F | 7306000 | 7306000 | - | - | NORTH SIDE | - | - | - | - | 29TH AVE | 29TH AVE | 77918 | 77918 | 37.76306616 | -122.48837422 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM 1ST & 3RD TUE OF MONTH STCL | 29TH AVE to 30TH AVE (2800 - 2899) | - | 2828 IRVING | - | - | - | - | - | 118475 | 1228089600000 | -122.48837422 | 37.76306616 | - | 1666396800000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0288 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375729620000 | IRVING ST | 2800 - 2899 IRVING ST | 2800 - 2899 IRVING ST | 2800 IRVING ST | - | 30TH AVE | 30TH AVE |
| 101200 | N/A | Point | 1 | 1 | 1345 - 1399 | - | S205463 | 1345-1399 FOLSOM ST | 1345-1399 FOLSOM ST | F | F | - | F | 5680000 | 5680000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | DORE ST | DORE ST | 77593 | 77593 | 37.77304847 | -122.41252462 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | DORE ST to 10TH ST (1345 - 1399) | - | 20' NORTH OF CURB AT #1369 | - | - | - | - | - | 118476 | 1474884660000 | -122.41252462 | 37.77304847 | - | 1695723660000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | DELINEATOR BASE SAFE HIT | IS | 1399380180000 | FOLSOM ST | 1345 - 1399 FOLSOM ST | 1345 - 1399 FOLSOM ST | 1345 FOLSOM ST | - | 10TH ST | 10TH ST |
| 101201 | N/A | Point | - | - | - | - | S221882 | 22ND AVE: GEARY BLVD | - | F | F | - | F | 27538000 | 27538000 | - | - | NORTH WEST CORNER | - | - | - | - | 22ND AVE | GEARY BLVD | 56331 | 56331 | 37.78022582 | -122.48151572 | GEARY BLVD \ 22ND AVE | 22ND AVE \ GEARY BLVD | 1711125588000 | middleware_editor | 22ND AVE | GEARY BLVD intersection | - | NWC |<400 SOUTH | - | - | - | - | - | 118477 | - | -122.48151572 | 37.78022582 | - | - | - | D1 | - | STREET NAME | GUIDE | D3-1.0014 | 36X08 | SUP2 | SIGNAL POLE | IS | 1452156900000 | 22ND AVE | - | - | - | - | - | - |
| 101202 | N/A | Point | - | - | - | LEFT ARROW | S240364 | FOLSOM ST: DORE ST | - | F | F | - | F | 24234000 | 24234000 | - | - | SOUTH EAST CORNER | - | - | - | - | DORE ST | DORE ST | 74886 | 74886 | 37.77328478 | -122.41222501 | FOLSOM ST \ DORE ST | FOLSOM ST \ DORE ST | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | DORE ST intersection | - | SEE MAP | - | - | - | - | - | 118478 | 1052352000000 | -122.41222501 | 37.77328478 | - | 1695724560000 | - | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1510223340000 | FOLSOM ST | - | - | - | - | - | - |
| 101203 | N/A | Point | - | 1 | 500 - 599 | - | S129704 | 500-599 TOWNSEND ST | 500-599 TOWNSEND ST | F | F | - | F | 12665000 | 12665000 | - | - | SOUTH SIDE | - | - | - | - | 6TH ST | 06TH ST | 20426 | 20426 | 37.7726953 | -122.40054491 | - | - | 1710539427000 | MTA | VEH MUST FIT WITHIN STALL MARKINGS | 06TH ST to 07TH ST (500 - 599) | - | OPP NEC | - | - | - | - | - | 118479 | 1223942400000 | -122.40054491 | 37.7726953 | - | - | - | D6 | - | OTHER REGULATORY | REG | R32C(SF).0046 | 18X21 | SUP1 | LIGHT POLE | IS | 1373576820000 | TOWNSEND ST | 500 - 599 TOWNSEND ST | 500 - 599 TOWNSEND ST | 500 TOWNSEND ST | - | 07TH ST | 07TH ST |
| 101204 | N/A | Point | - | 1 | 500 - 599 | - | S132449 | 500-599 TOWNSEND ST | 500-599 TOWNSEND ST | F | F | - | F | 12665000 | 12665000 | - | - | NORTH SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 6TH ST | 06TH ST | 27451 | 27451 | 37.7726953 | -122.40054491 | - | - | 1710539427000 | MTA | 10 MIN PRK 9AM-6PM EXC SUN | 06TH ST to 07TH ST (500 - 599) | - | 27FT WEST OF ENTRANCE TO USPS LOT | - | - | - | - | - | 118480 | 1277337600000 | -122.40054491 | 37.7726953 | - | - | - | D6 | - | PARKING | REG | R32(CA).0046 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373577720000 | TOWNSEND ST | 500 - 599 TOWNSEND ST | 500 - 599 TOWNSEND ST | 500 TOWNSEND ST | - | 07TH ST | 07TH ST |
| 101205 | N/A | Point | 1 | 1 | 900 - 947 | - | S231027 | 900-948 INGERSON AVE | 900-947 INGERSON AVE | F | F | - | F | 7249000 | 7249000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | HAWES ST | HAWES ST | 65780 | 65780 | 37.71832032 | -122.39158615 | - | - | 1710539427000 | MTA | SPEED HUMP | HAWES ST to REDONDO ST (900 - 947) | - | OPPL #942 (DIRT) | - | - | - | - | - | 118481 | 1479815940000 | -122.39158615 | 37.71832032 | - | 1479772800000 | - | D10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1479218880000 | INGERSON AVE | 900 - 947 INGERSON AVE | 900 - 947 INGERSON AVE | 900 INGERSON AVE | - | REDONDO ST | REDONDO ST |
| 101206 | N/A | Point | 1 | 1 | 900 - 947 | - | S231026 | 900-948 INGERSON AVE | 900-947 INGERSON AVE | F | F | - | F | 7249000 | 7249000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | HAWES ST | HAWES ST | 117015 | 117015 | 37.71832032 | -122.39158615 | - | - | 1710539427000 | MTA | SPEED HUMP | HAWES ST to REDONDO ST (900 - 947) | - | IFO #900 | - | - | - | - | - | 118482 | 1479809700000 | -122.39158615 | 37.71832032 | - | 1479772800000 | - | D10 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1479218580000 | INGERSON AVE | 900 - 947 INGERSON AVE | 900 - 947 INGERSON AVE | 900 INGERSON AVE | - | REDONDO ST | REDONDO ST |
| 101207 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S226722 | 1200-1299 10TH AVE | 1200-1299 10TH AVE | F | F | - | F | 470000 | 470000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 64823 | 64823 | 37.76493357 | -122.46744917 | - | - | 1729534133000 | middleware_editor | SPEED HUMPS | LINCOLN WAY to IRVING ST (1200 - 1299) | - | IFO #1280 | - | - | - | - | - | 118483 | 1224547200000 | -122.46744917 | 37.76493357 | - | 1466985600000 | - | D5 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1466162640000 | 10TH AVE | 1200 - 1299 10TH AVE | 1200 - 1299 10TH AVE | 1200 10TH AVE | - | IRVING ST | IRVING ST |
| 101208 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S226720 | 1200-1299 10TH AVE | 1200-1299 10TH AVE | F | F | - | F | 470000 | 470000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 64822 | 64822 | 37.76493357 | -122.46744917 | - | - | 1729532637000 | middleware_editor | SPEED HUMPS | LINCOLN WAY to IRVING ST (1200 - 1299) | - | 20' SOUTH OF LINCOLN WAY | - | - | - | - | - | 118484 | 1224201600000 | -122.46744917 | 37.76493357 | - | 1466985600000 | - | D5 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1466162280000 | 10TH AVE | 1200 - 1299 10TH AVE | 1200 - 1299 10TH AVE | 1200 10TH AVE | - | IRVING ST | IRVING ST |
| 101209 | N/A | Point | - | - | - | - | S226726 | FRANCISCO ST: DIVISADERO ST | - | T | T | - | F | 27003000 | 27003000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FRANCISCO ST | DIVISADERO ST | 129598 | 129598 | 37.80090821 | -122.44303462 | DIVISADERO ST \ FRANCISCO ST | FRANCISCO ST \ DIVISADERO ST | 1710539427000 | MTA | SPEED HUMP | DIVISADERO ST intersection | - | - | - | - | - | - | - | 118485 | 1466675940000 | -122.44303462 | 37.80090821 | - | 1466640000000 | - | D2 | - | OTHER WARNING | WARNING | W17-1.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1466164920000 | FRANCISCO ST | - | - | - | - | - | - |
| 101210 | N/A | Point | - | - | - | - | S228374 | FUNSTON AVE: ANZA ST | - | T | T | - | F | 27300000 | 27300000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ANZA ST | FUNSTON AVE | 67413 | 67413 | 37.77875221 | -122.47163857 | FUNSTON AVE \ ANZA ST | ANZA ST \ FUNSTON AVE | 1710539427000 | MTA | SPEED HUMPS | FUNSTON AVE intersection | - | ABOVE"RIGHT TURN ONLY-AT GEARY' SIGN | - | - | - | - | - | 118486 | 1507729860000 | -122.47163857 | 37.77875221 | - | 1507680000000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1472109240000 | ANZA ST | - | - | - | - | - | - |
| 101211 | N/A | Point | 1 | 1 | 3800 - 3899 | - | S231918 | 3800-3899 22ND ST | 3800-3899 22ND ST | T | T | - | F | 1204000 | 1204000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | NOE ST | NOE ST | 66700 | 66700 | 37.75456084 | -122.43328581 | - | - | 1710539427000 | MTA | SPEED HUMPS | NOE ST to CASTRO ST (3800 - 3899) | - | 25FT. EAST OF CASTRO ST. | - | - | - | - | - | 118487 | 1492773300000 | -122.43328581 | 37.75456084 | - | 1492732800000 | - | D8 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1482232020000 | 22ND ST | 3800 - 3899 22ND ST | 3800 - 3899 22ND ST | 3800 22ND ST | - | CASTRO ST | CASTRO ST |
| 101212 | N/A | Point | - | - | - | - | S228415 | 14TH AVE: CALIFORNIA ST | - | T | T | - | F | 27621000 | 27621000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 129722 | 129722 | 37.78442147 | -122.47311981 | 14TH AVE \ CALIFORNIA ST | 14TH AVE \ CALIFORNIA ST | 1747332261000 | middleware_editor | SPEED HUMPS | CALIFORNIA ST intersection | - | 21" SOUTH, BETWEEN GUIDE WIRE & VENT | - | - | - | - | - | 118488 | 1488823320000 | -122.47311981 | 37.78442147 | - | 1488787200000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1472124240000 | 14TH AVE | - | - | - | - | - | - |
| 101213 | N/A | Point | 1 | 1 | 500 - 699 | - | S226707 | 500-699 PENNSYLVANIA AVE | 500-699 PENNSYLVANIA AVE | F | F | - | F | 10335000 | 10335000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | 20TH ST | 20TH ST | 64817 | 64817 | 37.75892636 | -122.39324368 | - | - | 1710539427000 | MTA | SPEED HUMPS | 20TH ST to 22ND ST (500 - 699) | - | SPL #677 | - | - | - | - | - | 118489 | 1466763240000 | -122.39324368 | 37.75892636 | - | 1466726400000 | - | D10 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1466158320000 | PENNSYLVANIA AVE | 500 - 699 PENNSYLVANIA AVE | 500 - 699 PENNSYLVANIA AVE | 500 PENNSYLVANIA AVE | - | 22ND ST | 22ND ST |
| 101214 | N/A | Point | - | - | - | - | S231923 | DORLAND ST: DOLORES ST | - | F | F | - | F | 25691000 | 25691000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | DORLAND ST | DORLAND ST | 116825 | 116825 | 37.76216036 | -122.42614599 | DOLORES ST \ DORLAND ST | DOLORES ST \ DORLAND ST | 1710539427000 | MTA | SPEED HUMPS | DORLAND ST intersection | - | ABOVE ST.CLEANING MON. 8-10AM SIGN | - | - | - | - | - | 118490 | 1492781400000 | -122.42614599 | 37.76216036 | - | 1492732800000 | - | D8 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1482232560000 | DOLORES ST | - | - | - | - | - | - |
| 101215 | N/A | Point | 1 | 1 | 600 - 699 | - | S229517 | 600-699 SPRUCE ST | 600-699 SPRUCE ST | F | F | - | F | 12064000 | 12064000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | EUCLID AVE | EUCLID AVE | 68342 | 68342 | 37.78288611 | -122.45341082 | - | - | 1715909080000 | middleware_editor | SPEED HUMPS | EUCLID AVE to GEARY BLVD (600 - 699) | - | 20' NORTH OF GEARY BLVD. | - | - | - | - | - | 118491 | 1475849280000 | -122.45341082 | 37.78288611 | - | 1475798400000 | - | D2 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1475660280000 | SPRUCE ST | 600 - 699 SPRUCE ST | 600 - 699 SPRUCE ST | 600 SPRUCE ST | - | GEARY BLVD | GEARY BLVD |
| 101216 | N/A | Point | - | - | - | - | S229540 | COLLINS ST: EUCLID AVE | - | F | F | - | F | 26912000 | 26912000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | COLLINS ST | COLLINS ST | 65318 | 65318 | 37.7844809 | -122.45013569 | EUCLID AVE \ COLLINS ST | EUCLID AVE \ COLLINS ST | 1715278443000 | middleware_editor | SPEED HUMPS | COLLINS ST intersection | - | - | - | - | - | - | - | 118492 | 1477486860000 | -122.45013569 | 37.7844809 | - | 1477440000000 | - | D2 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1475664120000 | EUCLID AVE | - | - | - | - | - | - |
| 101217 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S226717 | 1200-1299 8TH AVE | 1200-1299 08TH AVE | T | T | - | F | 395000 | 395000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 64819 | 64819 | 37.76502687 | -122.46531076 | - | - | 1717117925000 | middleware_editor | SPEED HUMPS | LINCOLN WAY to IRVING ST (1200 - 1299) | - | SPL #1288 | - | - | - | - | - | 118493 | 1466503860000 | -122.46531076 | 37.76502687 | - | 1466467200000 | - | D5 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1466161500000 | 08TH AVE | 1200 - 1299 8TH AVE | 1200 - 1299 08TH AVE | 1200 8TH AVE | - | IRVING ST | IRVING ST |
| 101218 | N/A | Point | - | - | - | - | S228431 | 14TH AVE: ANZA ST | - | F | F | - | F | 27476000 | 27476000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ANZA ST | 14TH AVE | 63476 | 63476 | 37.77870384 | -122.47270848 | 14TH AVE \ ANZA ST | ANZA ST \ 14TH AVE | 1710539427000 | MTA | SPEED HUMPS | 14TH AVE intersection | - | ABOVE RIGHT TURN ONLY-AT GEARY SIGN | - | - | - | - | - | 118494 | 1481032140000 | -122.47270848 | 37.77870384 | - | 1480982400000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1472193300000 | ANZA ST | - | - | - | - | - | - |
| 101219 | N/A | Point | - | - | - | - | S228437 | 14TH AVE: FULTON ST | - | T | T | - | F | 27447000 | 27447000 | - | - | NORTH EAST CORNER | - | - | - | - | FULTON ST | FULTON ST | 63482 | 63482 | 37.77311442 | -122.47229734 | 14TH AVE \ FULTON ST | 14TH AVE \ FULTON ST | 1719866245000 | middleware_editor | SPEED HUMPS | FULTON ST intersection | - | OF 14TH AVE & FULTON ST.-F/N/B/T | - | - | - | - | - | 118495 | 1487675100000 | -122.47229734 | 37.77311442 | - | 1487635200000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | LIGHT POLE | IS | 1472194800000 | 14TH AVE | - | - | - | - | - | - |
| 101220 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S231038 | 1100-1199 HOLLISTER AVE | 1100-1199 HOLLISTER AVE | F | F | - | F | 6962000 | 6962000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | INGALLS ST | INGALLS ST | 66144 | 66144 | 37.72027031 | -122.39335389 | - | - | 1710539427000 | MTA | SPEED HUMPS | INGALLS ST to JENNINGS ST (1100 - 1199) | - | WPL #1110 | - | - | - | - | - | 118496 | 1479885060000 | -122.39335389 | 37.72027031 | - | 1479859200000 | - | D10 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1479288420000 | HOLLISTER AVE | 1100 - 1199 HOLLISTER AVE | 1100 - 1199 HOLLISTER AVE | 1100 HOLLISTER AVE | - | JENNINGS ST | JENNINGS ST |
| 101221 | N/A | Point | 1 | 1 | 1100 - 1199 | - | S231039 | 1100-1199 HOLLISTER AVE | 1100-1199 HOLLISTER AVE | F | F | - | F | 6962000 | 6962000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | INGALLS ST | INGALLS ST | 117348 | 117348 | 37.72027031 | -122.39335389 | - | - | 1710539427000 | MTA | SPEED HUMPS | INGALLS ST to JENNINGS ST (1100 - 1199) | - | EPL #1183 | - | - | - | - | - | 118497 | 1479826680000 | -122.39335389 | 37.72027031 | - | 1479772800000 | - | D10 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP1 | 2IN IRON POST | IS | 1479288720000 | HOLLISTER AVE | 1100 - 1199 HOLLISTER AVE | 1100 - 1199 HOLLISTER AVE | 1100 HOLLISTER AVE | - | JENNINGS ST | JENNINGS ST |
| 101222 | N/A | Point | - | - | - | - | S228439 | 15TH AVE: CABRILLO ST | - | F | F | - | F | 27450000 | 27450000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | CABRILLO ST | 15TH AVE | 64510 | 64510 | 37.77492778 | -122.47356298 | 15TH AVE \ CABRILLO ST | CABRILLO ST \ 15TH AVE | 1710539427000 | MTA | SPEED HUMPS | 15TH AVE intersection | - | 25' NORTH | - | - | - | - | - | 118498 | 1474416000000 | -122.47356298 | 37.77492778 | - | 1474416000000 | - | D1 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1472206020000 | CABRILLO ST | - | - | - | - | - | - |
| 101223 | N/A | Point | - | - | - | - | S240647 | WINFIELD ST: VIRGINIA AVE | - | F | F | - | F | 13316000 | 21310000 | - | - | NORTH EAST CORNER | - | - | - | - | WINFIELD ST | VIRGINIA AVE | 74191 | 74191 | 37.74208454 | -122.41891413 | - | WINFIELD ST \ VIRGINIA AVE | 1710539427000 | MTA | WINFIELD ST | VIRGINIA AVE intersection | - | - | - | - | - | - | - | 118499 | 1524825480000 | -122.41891413 | 37.74208454 | - | 1524787200000 | - | D9 | - | STREET NAME | GUIDE | D3-1.1880 | 36X08 | SUP2 | LIGHT POLE | IS | 1510906560000 | WINFIELD ST | 300 - 349 VIRGINIA AVE | - | - | - | ELSIE ST | - |
| 101224 | N/A | Point | - | - | - | - | S111331 | VIRGINIA AVE: WINFIELD ST | - | F | F | - | F | 13316000 | 21310000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | WINFIELD ST | VIRGINIA AVE | 9934 | 9934 | 37.74208454 | -122.41891413 | - | WINFIELD ST \ VIRGINIA AVE | 1710539427000 | MTA | STOP | VIRGINIA AVE intersection | - | - | - | - | - | - | - | 118500 | 776995200000 | -122.41891413 | 37.74208454 | - | - | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571060000 | WINFIELD ST | 300 - 349 VIRGINIA AVE | - | - | - | ELSIE ST | - |
| 101225 | N/A | Point | - | - | - | - | S240648 | WINFIELD ST: VIRGINIA AVE | - | F | F | - | F | 13316000 | 21310000 | - | - | NORTH EAST CORNER | - | - | - | - | WINFIELD ST | VIRGINIA AVE | 74192 | 74192 | 37.74208454 | -122.41891413 | - | WINFIELD ST \ VIRGINIA AVE | 1710539427000 | MTA | VIRGINIA AVE | VIRGINIA AVE intersection | - | - | - | - | - | - | - | 118501 | 1524825540000 | -122.41891413 | 37.74208454 | - | 1524787200000 | - | D9 | - | STREET NAME | GUIDE | D3-1.1811 | 36X08 | SUP2 | LIGHT POLE | IS | 1510906680000 | WINFIELD ST | 300 - 349 VIRGINIA AVE | - | - | - | ELSIE ST | - |
| 101226 | N/A | Point | - | - | - | - | S111332 | VIRGINIA AVE: WINFIELD ST | - | F | F | - | F | 13315000 | 21310000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | PROSPECT AVE | VIRGINIA AVE | 9935 | 9935 | 37.74208454 | -122.41891413 | - | WINFIELD ST \ VIRGINIA AVE | 1710539427000 | MTA | STOP | VIRGINIA AVE intersection | - | - | - | - | - | - | - | 118502 | 776995200000 | -122.41891413 | 37.74208454 | - | - | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373571060000 | WINFIELD ST | 200 - 299 VIRGINIA AVE | - | - | - | WINFIELD ST | - |
| 101227 | N/A | Point | - | - | - | - | S240644 | WINFIELD ST: VIRGINIA AVE | - | F | F | - | F | 13679000 | 21310000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | VIRGINIA AVE | VIRGINIA AVE | 90156 | 90156 | 37.74208454 | -122.41891413 | - | WINFIELD ST \ VIRGINIA AVE | 1710539427000 | MTA | ALL WAY | VIRGINIA AVE intersection | - | - | - | - | - | - | - | 118503 | -394848000000 | -122.41891413 | 37.74208454 | - | 1518566400000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1510906260000 | WINFIELD ST | 200 - 299 WINFIELD ST | - | - | - | EUGENIA AVE | - |
| 101228 | N/A | Point | - | - | - | - | S240642 | VIRGINIA AVE: WINFIELD ST | - | F | F | - | F | 13316000 | 21310000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | WINFIELD ST | VIRGINIA AVE | 74051 | 74051 | 37.74208454 | -122.41891413 | - | WINFIELD ST \ VIRGINIA AVE | 1710539427000 | MTA | ALL WAY | VIRGINIA AVE intersection | - | - | - | - | - | - | - | 118504 | 776995200000 | -122.41891413 | 37.74208454 | - | 1518566400000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1510906020000 | WINFIELD ST | 300 - 349 VIRGINIA AVE | - | - | - | ELSIE ST | - |
| 101229 | N/A | Point | - | - | - | - | S101867 | WINFIELD ST: VIRGINIA AVE | - | F | F | - | F | 13679000 | 21310000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | VIRGINIA AVE | VIRGINIA AVE | 6048 | 6048 | 37.74208454 | -122.41891413 | - | WINFIELD ST \ VIRGINIA AVE | 1710539427000 | MTA | STOP | VIRGINIA AVE intersection | - | - | - | - | - | - | - | 118505 | -394848000000 | -122.41891413 | 37.74208454 | - | - | - | D9 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373566920000 | WINFIELD ST | 200 - 299 WINFIELD ST | - | - | - | EUGENIA AVE | - |
| 101230 | N/A | Point | - | - | - | - | S240646 | WINFIELD ST: VIRGINIA AVE | - | F | F | - | F | 21310000 | 21310000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | VIRGINIA AVE | VIRGINIA AVE | 111361 | 111361 | 37.74208454 | -122.41891413 | WINFIELD ST \ VIRGINIA AVE | WINFIELD ST \ VIRGINIA AVE | 1710539427000 | MTA | ALL WAY | VIRGINIA AVE intersection | - | - | - | - | - | - | - | 118506 | 1518614640000 | -122.41891413 | 37.74208454 | - | 1518566400000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1510906440000 | WINFIELD ST | - | - | - | - | - | - |
| 101231 | N/A | Point | - | - | - | - | S240643 | VIRGINIA AVE: WINFIELD ST | - | F | F | - | F | 13315000 | 21310000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | PROSPECT AVE | VIRGINIA AVE | 74052 | 74052 | 37.74208454 | -122.41891413 | - | WINFIELD ST \ VIRGINIA AVE | 1710539427000 | MTA | ALL WAY | VIRGINIA AVE intersection | - | - | - | - | - | - | - | 118507 | 776995200000 | -122.41891413 | 37.74208454 | - | 1518566400000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1510906080000 | WINFIELD ST | 200 - 299 VIRGINIA AVE | - | - | - | WINFIELD ST | - |
| 101232 | N/A | Point | - | - | - | - | S105643 | 26TH AVE: CABRILLO ST | - | F | F | - | F | 27522000 | 27522000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CABRILLO ST | 26TH AVE | 1846 | 1846 | 37.77438773 | -122.48539727 | 26TH AVE \ CABRILLO ST | CABRILLO ST \ 26TH AVE | 1710539427000 | MTA | STOP | 26TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 118508 | 91411200000 | -122.48539727 | 37.77438773 | - | 1204502400000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569320000 | CABRILLO ST | - | - | - | - | - | - |
| 101233 | N/A | Point | - | - | - | - | S278502 | VIRGINIA AVE: WINFIELD ST | - | F | F | - | F | 13316000 | 21310000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | WINFIELD ST | VIRGINIA AVE | 120837 | 120837 | 37.74208454 | -122.41891413 | - | WINFIELD ST \ VIRGINIA AVE | 1710539427000 | MTA | (90 LA) CURVE (SYM)/15 MPH | VIRGINIA AVE intersection | - | OPP 322 20 FT NORTH OF ELSIE | - | - | - | - | - | 118509 | 776995200000 | -122.41891413 | 37.74208454 | - | 1636416000000 | - | D9 | - | SPEED LIMIT | WARNING | W1-1A.0004 | 30X30 | SUP2 | 2IN IRON POST | IS | 1635414660000 | WINFIELD ST | 300 - 349 VIRGINIA AVE | - | - | - | ELSIE ST | - |
| 101234 | N/A | Point | - | - | - | - | S268345 | 26TH AVE: SEACLIFF AVE | - | F | F | - | F | 27671000 | 27671000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SEACLIFF AVE | 26TH AVE | 87425 | 87425 | 37.78877033 | -122.48701841 | 26TH AVE \ SEACLIFF AVE | SEACLIFF AVE \ 26TH AVE | 1710539427000 | MTA | TYPE P RIGHT | 26TH AVE intersection | - | PLANTER BOX | - | - | - | - | - | 118510 | 1149811200000 | -122.48701841 | 37.78877033 | - | 1600905600000 | - | D2 | - | OTHER WARNING | WARNING | TYPE-P(CA).0002 | 12X36 | SUP1 | UNISTRUT | IS | 1600778460000 | SEACLIFF AVE | - | - | - | - | - | - |
| 101235 | N/A | Point | - | - | - | - | S268346 | 26TH AVE: SEACLIFF AVE | - | F | F | - | F | 27671000 | 27671000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SEACLIFF AVE | 26TH AVE | 87694 | 87694 | 37.78877033 | -122.48701841 | 26TH AVE \ SEACLIFF AVE | SEACLIFF AVE \ 26TH AVE | 1710539427000 | MTA | TYPE P RIGHT | 26TH AVE intersection | - | PLANTER BOX | - | - | - | - | - | 118511 | 1149811200000 | -122.48701841 | 37.78877033 | - | 1600905600000 | - | D2 | - | OTHER WARNING | WARNING | TYPE-P(CA).0002 | 12X36 | SUP1 | UNISTRUT | IS | 1600778520000 | SEACLIFF AVE | - | - | - | - | - | - |
| 101236 | N/A | Point | - | - | - | - | S227286 | GEARY BLVD: LYON ST | - | T | T | - | F | 32825000 | 32825000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LYON ST | GEARY BLVD | 125647 | 125647 | 37.7825697 | -122.44443147 | GEARY BLVD \ LYON ST | LYON ST \ GEARY BLVD | 1710539427000 | MTA | SIGNAL AHEAD (SYM) | GEARY BLVD intersection | - | - | - | - | - | - | - | 118512 | 1469704440000 | -122.44443147 | 37.7825697 | - | 1469664000000 | - | D2 | - | OTHER WARNING | WARNING | W3-3.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1468582740000 | LYON ST | - | - | - | - | - | - |
| 101237 | N/A | Point | 1 | 1 | 1 - 78 | - | S226560 | 1-78 GERMANIA ST | 1-78 GERMANIA ST | F | F | - | F | 6165000 | 6165000 | - | - | NORTH SIDE | - | - | - | - | WEBSTER ST | WEBSTER ST | 63268 | 63268 | 37.77081352 | -122.42934378 | - | - | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | WEBSTER ST to FILLMORE ST (1 - 78) | - | 15' EAST OF FILLMORE | - | - | - | - | - | 118513 | 979084800000 | -122.42934378 | 37.77081352 | - | - | - | D5 | - | OTHER WARNING | WARNING | SW(SF).0009 | 11X14 | SUP1 | 2IN IRON POST | IS | 1465834320000 | GERMANIA ST | 1 - 78 GERMANIA ST | 1 - 78 GERMANIA ST | 1 GERMANIA ST | - | FILLMORE ST | FILLMORE ST |
| 101238 | N/A | Point | - | - | - | - | S228330 | TARAVAL ST: 41ST AVE | - | T | T | - | F | 12418000 | 23444000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 41ST AVE | 41ST AVE | 62327 | 62327 | 37.7419283692422 | -122.49939254712 | - | TARAVAL ST \ 41ST AVE | 1740420738000 | middleware_editor | (45 LA-DN) | 41ST AVE intersection | - | - | - | - | - | - | - | 118514 | 1123200000000 | -122.49926207 | 37.74200717 | - | - | - | D4 | - | OTHER WARNING | WARNING | W16-7P.0001 | 18X18 | SUP2 | 2IN IRON POST | IS | 1471949160000 | TARAVAL ST | 3100 - 3199 TARAVAL ST | - | - | - | 42ND AVE | - |
| 101239 | N/A | Point | - | - | - | - | S283996 | MADRONE AVE: ULLOA ST | - | F | F | - | F | 22948000 | 22948000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ULLOA ST | MADRONE AVE | 91549 | 91549 | 37.74150309 | -122.46763054 | MADRONE AVE \ ULLOA ST | ULLOA ST \ MADRONE AVE | 1726019519000 | middleware_editor | CROSS TRAFFIC DOES NOT STOP | MADRONE AVE intersection | - | - | - | - | - | - | - | 118515 | 1665705600000 | -122.46763054 | 37.74150309 | - | - | - | D7 | - | OTHER WARNING | WARNING | W4-4P.0001 | 24X12 | SUP2 | 2IN IRON POST | IS | 1657633620000 | ULLOA ST | - | - | - | - | - | - |
| 101240 | N/A | Point | - | - | - | - | S228325 | TARAVAL ST: 41ST AVE | - | T | T | - | F | 12417000 | 23444000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 40TH AVE | 41ST AVE | 62007 | 62007 | 37.7421047102308 | -122.49913084641 | - | TARAVAL ST \ 41ST AVE | 1740420741000 | middleware_editor | (45 LA-DN) | 41ST AVE intersection | - | - | - | - | - | - | - | 118516 | 1123200000000 | -122.49926207 | 37.74200717 | - | - | - | D4 | - | OTHER WARNING | WARNING | W16-7P.0001 | 18X18 | SUP2 | MUNI POLE | IS | 1471948320000 | TARAVAL ST | 3000 - 3099 TARAVAL ST | - | - | - | 41ST AVE | - |
| 101241 | N/A | Point | - | - | - | - | S222011 | BRUSSELS ST: WILDE AVE | - | F | F | - | F | 20303000 | 20303000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BRUSSELS ST | BRUSSELS ST | 59183 | 59183 | 37.71631731 | -122.40110453 | WILDE AVE \ BRUSSELS ST | WILDE AVE \ BRUSSELS ST | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | BRUSSELS ST intersection | - | BELOW ST.NAMES SIGNS | - | - | - | - | - | 118517 | 1453387320000 | -122.40110453 | 37.71631731 | - | 1453334400000 | - | D10 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP1 | 3IN IRON POST | IS | 1452589380000 | WILDE AVE | - | - | - | - | - | - |
| 101242 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S258384 | 1400-1499 JONES ST | 1400-1499 JONES ST | F | F | - | F | 7582000 | 7582000 | - | - | WEST SIDE | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 127922 | 127922 | 37.79454898 | -122.41473663 | - | - | 1710539427000 | MTA | ZIPCARS | WASHINGTON ST to JACKSON ST (1400 - 1499) | - | 55' N OF WASHINGTON | - | - | - | - | - | 118518 | 1580991840000 | -122.41473663 | 37.79454898 | - | - | - | D3 | - | OTHER GUIDE | GUIDE | G-Z(SF).0005 | 05X12 | SUP1 | 2IN IRON POST | IS | 1571311500000 | JONES ST | 1400 - 1499 JONES ST | 1400 - 1499 JONES ST | 1400 JONES ST | - | JACKSON ST | JACKSON ST |
| 101243 | N/A | Point | - | - | - | - | S224138 | ANZA ST: COLLINS ST | - | F | F | - | F | 26467000 | 26467000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | COLLINS ST | COLLINS ST | 62414 | 62414 | 37.78075201 | -122.44981745 | ANZA ST \ COLLINS ST | ANZA ST \ COLLINS ST | 1718039531000 | middleware_editor | (45 LA-DN) | COLLINS ST intersection | - | (SEE PAINT) | - | - | - | - | - | 118519 | 1461764520000 | -122.44981745 | 37.78075201 | - | 1461715200000 | - | D1 | - | OTHER WARNING | WARNING | W16-7P.0001 | 18X18 | SUP2 | 2IN IRON POST | IS | 1458126480000 | ANZA ST | - | - | - | - | - | - |
| 101244 | N/A | Point | - | - | - | - | S225399 | STEINER ST: WALLER ST | - | F | F | - | F | 25991000 | 25991000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WALLER ST | WALLER ST | 61865 | 61865 | 37.77096443 | -122.43190432 | STEINER ST \ WALLER ST | STEINER ST \ WALLER ST | 1753213603000 | middleware_editor | DUBOCE PARK HISTORIC DISTRICT | WALLER ST intersection | - | - | - | - | - | - | - | 118520 | 1464722520000 | -122.43190432 | 37.77096443 | - | 1464678000000 | - | D5 | - | OTHER GUIDE | GUIDE | G-D(SF).0014 | 30X08 | SUP1 | 2IN IRON POST | IS | 1462440120000 | STEINER ST | - | - | - | - | - | - |
| 101245 | N/A | Point | - | - | - | - | S225403 | HUGO ST: 6TH AVE | - | F | F | - | F | 27086000 | 27086000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HUGO ST | 06TH AVE | 61867 | 61867 | 37.76511424 | -122.46316737 | 6TH AVE \ HUGO ST | HUGO ST \ 06TH AVE | 1710539427000 | MTA | (LA) WHITE ON GREEN | 06TH AVE intersection | - | - | - | - | - | - | - | 118521 | 1462864140000 | -122.46316737 | 37.76511424 | - | 1462838400000 | - | D5 | - | OTHER GUIDE | GUIDE | M7-1.0002 | 12X09 | SUP1 | LIGHT POLE | IS | 1462444020000 | HUGO ST | - | - | - | - | - | - |
| 101246 | N/A | Point | 1 | 1 | 651 - 699 | - | S277191 | 651-699 27TH ST | 651-699 27TH ST | F | F | - | F | 1571000 | 1571000 | - | - | SOUTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | KRONQUIST CT | KRONQUIST CT | 110137 | 110137 | 37.7464084 | -122.43540472 | - | - | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | KRONQUIST CT to DIAMOND ST (651 - 699) | - | EPL 655 | - | - | - | - | - | 118522 | 1222214400000 | -122.43540472 | 37.7464084 | - | 1632096000000 | - | D8 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | 2IN IRON POST | IS | 1629363660000 | 27TH ST | 651 - 699 27TH ST | 651 - 699 27TH ST | 651 27TH ST | - | DIAMOND ST | DIAMOND ST |
| 101247 | N/A | Point | - | - | - | - | S278678 | 26TH ST: SHOTWELL ST | - | F | F | - | F | 21293000 | 21293000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SHOTWELL ST | 26TH ST | 120470 | 120470 | 37.74923787 | -122.41486125 | 26TH ST \ SHOTWELL ST | SHOTWELL ST \ 26TH ST | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | 26TH ST intersection | - | - | - | - | - | - | - | 118523 | 1642550400000 | -122.41486125 | 37.74923787 | - | - | - | D9 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | 2IN IRON POST | IS | 1636376760000 | SHOTWELL ST | - | - | - | - | - | - |
| 101248 | N/A | Point | 1 | 1 | 2900 - 2998 | - | S231164 | 2900-5989 SAN BRUNO AVE | 2900-2998 SAN BRUNO AVE | F | F | - | F | 11380000 | 11380000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | WOOLSEY ST | WOOLSEY ST | 68419 | 68419 | 37.72463537 | -122.4023544 | - | - | 1710539427000 | MTA | AHEAD | WOOLSEY ST to DWIGHT ST (2900 - 2998) | - | IFO# 2919 | - | - | - | - | - | 118524 | 1485431640000 | -122.4023544 | 37.72463537 | - | 1485388800000 | - | D9 | - | OTHER WARNING | WARNING | W16-9P.0001 | 24X12 | SUP2 | LIGHT POLE | IS | 1479467160000 | SAN BRUNO AVE | 2900 - 2998 SAN BRUNO AVE | 2900 - 2998 SAN BRUNO AVE | 2900 SAN BRUNO AVE | - | DWIGHT ST | DWIGHT ST |
| 101249 | N/A | Point | - | - | - | - | S268348 | 26TH AVE: SEACLIFF AVE | - | F | F | - | F | 27671000 | 27671000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SEACLIFF AVE | 26TH AVE | 87696 | 87696 | 37.78877033 | -122.48701841 | 26TH AVE \ SEACLIFF AVE | SEACLIFF AVE \ 26TH AVE | 1710539427000 | MTA | TYPE P RIGHT | 26TH AVE intersection | - | PLANTER BOX | - | - | - | - | - | 118525 | 1149811200000 | -122.48701841 | 37.78877033 | - | 1600905600000 | - | D2 | - | OTHER WARNING | WARNING | TYPE-P(CA).0002 | 12X36 | SUP1 | UNISTRUT | IS | 1600778820000 | SEACLIFF AVE | - | - | - | - | - | - |
| 101250 | N/A | Point | - | - | - | - | S100990 | MADISON ST: SILVER AVE | - | F | F | - | F | 21662000 | 21662000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SILVER AVE | SILVER AVE | 728 | 728 | 37.72875994 | -122.42373998 | MADISON ST \ SILVER AVE | MADISON ST \ SILVER AVE | 1710539427000 | MTA | STOP | SILVER AVE intersection | - | 0 / 0 | - | - | - | - | - | 118526 | -401500800000 | -122.42373998 | 37.72875994 | - | - | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373566620000 | MADISON 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.