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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 102676 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S152302 | 1300-1399 WAWONA ST | 1300-1399 WAWONA ST | F | F | - | F | 13480000 | 13480000 | - | - | NORTH SIDE | - | - | - | - | 24TH AVE | 24TH AVE | 41679 | 41679 | 37.73719549 | -122.48119108 | - | - | 1754148050000 | middleware_editor | NPRK 7AM-9AM 2ND & 4TH FRI OF MONTH STCL | 24TH AVE to 25TH AVE (1300 - 1399) | - | 1408 WAWONA | - | - | - | - | 1 | 119963 | 1228896000000 | -122.48119108 | 37.73719549 | - | - | - | D4 | - | STREET CLEANING | REG | R30B(CA).0231 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375730640000 | WAWONA ST | 1300 - 1399 WAWONA ST | 1300 - 1399 WAWONA ST | 1300 WAWONA ST | - | 25TH AVE | 25TH AVE |
| 102677 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S255302 | 1300-1399 WAWONA ST | 1300-1399 WAWONA ST | F | F | - | F | 13480000 | 13480000 | - | - | NORTH SIDE | - | - | - | - | 24TH AVE | 24TH AVE | 89381 | 89381 | 37.73719549 | -122.48119108 | - | - | 1754068337000 | middleware_editor | NPRK 7AM-9AM 2ND & 4TH FRI OF MONTH STCL | 24TH AVE to 25TH AVE (1300 - 1399) | - | 60FT WEST | - | - | - | - | - | 119964 | 1228896000000 | -122.48119108 | 37.73719549 | - | 1576742400000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0231 | 18X18 | SUP2 | 2IN IRON POST | IS | 1560434220000 | WAWONA ST | 1300 - 1399 WAWONA ST | 1300 - 1399 WAWONA ST | 1300 WAWONA ST | - | 25TH AVE | 25TH AVE |
| 102678 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S152307 | 1300-1399 WAWONA ST | 1300-1399 WAWONA ST | F | F | - | F | 13480000 | 13480000 | - | - | SOUTH SIDE | - | - | - | - | 24TH AVE | 24TH AVE | 42833 | 42833 | 37.73719549 | -122.48119108 | - | - | 1710539427000 | MTA | NPRK 7AM-9AM 2ND & 4TH FRI OF MONTH STCL | 24TH AVE to 25TH AVE (1300 - 1399) | - | 2487 WAWONA | - | - | - | - | - | 119965 | 1228867200000 | -122.48119108 | 37.73719549 | - | - | - | D4 | - | STREET CLEANING | REG | R30B(CA).0231 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375730640000 | WAWONA ST | 1300 - 1399 WAWONA ST | 1300 - 1399 WAWONA ST | 1300 WAWONA ST | - | 25TH AVE | 25TH AVE |
| 102679 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S152305 | 1300-1399 WAWONA ST | 1300-1399 WAWONA ST | F | F | - | F | - | 13480000 | - | - | SOUTH SIDE | - | - | - | - | - | 24TH AVE | 78528 | 78528 | 37.7372293144822 | -122.480903248474 | - | - | 1756242839000 | middleware_editor | NPRK 7AM-9AM 2ND & 4TH FRI OF MONTH STCL | 24TH AVE to 25TH AVE (1300 - 1399) | - | 2425 WAWONA | - | - | - | - | - | 119966 | 1228896000000 | -122.48119108 | 37.73719549 | - | - | - | D4 | - | STREET CLEANING | REG | R30B(CA).0231 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375730640000 | WAWONA ST | - | 1300 - 1399 WAWONA ST | 1300 WAWONA ST | - | - | 25TH AVE |
| 102680 | N/A | Point | 1 | 1 | 3351 - 3399 | - | S223398 | 3351-3399 19TH ST | 3351-3399 19TH ST | F | F | - | F | 971000 | 971000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | CAPP ST | CAPP ST | 61562 | 61562 | 37.76026821 | -122.41866208 | - | - | 1710539427000 | MTA | STOP HERE ON RED (45LA) | CAPP ST to MISSION ST (3351 - 3399) | - | 25FT EAST OF MISSION ST | - | - | - | - | - | 119967 | - | -122.41866208 | 37.76026821 | - | - | - | D9 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP2 | UTILITY POLE | IS | 1455277200000 | 19TH ST | 3351 - 3399 19TH ST | 3351 - 3399 19TH ST | 3351 19TH ST | - | MISSION ST | MISSION ST |
| 102681 | N/A | Point | - | - | - | - | 23725 | - | - | F | F | - | F | 34013000 | - | - | - | SOUTH WEST CORNER | 1694039132000 | elclark | - | - | SANSOME ST \ THE EMBARCADERO | - | 153889 | 153889 | 37.8049068845224 | -122.403620217925 | CHESTNUT ST \ SANSOME ST \ THE EMBARCADERO | - | 1710539427000 | MTA | SANSOME ST | - | - | SWC |-END- | - | - | - | - | - | 119968 | - | - | - | - | 1702996800000 | - | 03 | HIGH INTENSITY PRISMATIC (TYPE IV WITH OL-1000 ANTI GRAFFITI OVERLAY FILM) | STREET NAME | GUIDE | D3-1.1574 | 36X08 | SUP1 | SIGNAL POLE | IS | - | CHESTNUT ST | - | - | - | - | - | - |
| 102682 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S266366 | 1600-1699 WALLACE AVE | 1600-1699 WALLACE AVE | F | F | - | F | 13357000 | 13357000 | - | - | SOUTH SIDE | - | - | - | - | KEITH ST | KEITH ST | 99849 | 99849 | 37.72798297 | -122.39200352 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM WED STCL | KEITH ST to 03RD ST \ LANE ST (1600 - 1699) | - | WPL 1647 | - | - | - | - | - | 119969 | 1515715200000 | -122.39200352 | 37.72798297 | - | 1597708800000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0086 | 18X18 | SUP1 | UTILITY POLE | IS | 1595235960000 | WALLACE AVE | 1600 - 1699 WALLACE AVE | 1600 - 1699 WALLACE AVE | 1600 WALLACE AVE | - | 03RD ST \ LANE ST | 03RD ST \ LANE ST |
| 102683 | N/A | Point | - | - | - | - | S103324 | 23RD ST: NOE ST | - | F | F | - | F | 25741000 | 25741000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 23RD ST | 23RD ST | 2898 | 2898 | 37.75302491 | -122.43202355 | NOE ST \ 23RD ST | NOE ST \ 23RD ST | 1710539427000 | MTA | STOP | 23RD ST intersection | - | 0 / 00 | - | - | - | - | - | 119970 | -250560000000 | -122.43202355 | 37.75302491 | - | 899424000000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568600000 | NOE ST | - | - | - | - | - | - |
| 102684 | N/A | Point | - | - | - | - | S205340 | BUCHANAN ST: DUBOCE AVE \ MARK | - | F | F | - | F | 30758000 | 30758000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | DUBOCE AVE \ MARKET ST | BUCHANAN ST \ DUBOCE AVE | 46048 | 46048 | 37.7696026 | -122.42630944 | BUCHANAN ST \ DUBOCE AVE \ MARKET ST | MARKET ST \ BUCHANAN ST \ DUBOCE AVE | 1729216026000 | middleware_editor | BICYCLES USE PED SIGNAL | BUCHANAN ST \ DUBOCE AVE intersection | - | NORTH CROSSWALK DUBOCE CROSSWALK | - | - | - | - | - | 119971 | 1399911720000 | -122.42630944 | 37.7696026 | - | 1399852800000 | - | D8 | - | PEDESTRIAN | REG | R(SF).0016 | 12X18 | SUP2 | LIGHT POLE | IS | 1398929160000 | MARKET ST | - | - | - | - | - | - |
| 102685 | N/A | Point | - | - | - | - | S123082 | SCOTT ST: FILBERT ST | - | F | F | - | F | 26874000 | 26874000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SCOTT ST | FILBERT ST | 19008 | 19008 | 37.79739359 | -122.44061008 | FILBERT ST \ SCOTT ST | SCOTT ST \ FILBERT ST | 1710539427000 | MTA | ALL WAY | FILBERT ST intersection | - | - | - | - | - | - | - | 119972 | 1142985600000 | -122.44061008 | 37.79739359 | - | 1702895880000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373574780000 | SCOTT ST | - | - | - | - | - | - |
| 102686 | N/A | Point | - | - | - | - | S215897 | LAKE MERCED BLVD: BROTHERHOOD | - | F | F | - | F | 33540000 | 33540000 | - | - | EAST SIDE | - | - | - | - | BROTHERHOOD WAY | BROTHERHOOD WAY | 54311 | 54311 | 37.71469451 | -122.48522894 | \LAKE MERCED BLVD: BROTHERHOOD | LAKE MERCED BLVD \ BROTHERHOOD WAY | 1710539427000 | MTA | MERGING TRAFFIC FROM RIGHT (SYM) | BROTHERHOOD WAY intersection | - | 100FT. NORTH | - | - | - | - | - | 119973 | - | -122.48522894 | 37.71469451 | - | - | - | D7 | - | OTHER WARNING | WARNING | W4-1.0006 | 30X30 | SUP2 | 2IN IRON POST | IS | 1430896320000 | LAKE MERCED BLVD | - | - | - | - | - | - |
| 102687 | N/A | Point | - | - | - | - | S200902 | DORE ST: HARRISON ST | - | F | F | - | F | 24230000 | 24230000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | DORE ST | DORE ST | 47694 | 47694 | 37.77205207 | -122.41067849 | HARRISON ST \ DORE ST | HARRISON ST \ DORE ST | 1717706759000 | middleware_editor | DORE ST | DORE ST intersection | - | 0 / 0 | - | - | - | - | - | 119974 | -386035200000 | -122.41067849 | 37.77205207 | - | 1717582800000 | - | D6 | - | STREET NAME | GUIDE | D3-1.0549 | 36X08 | SUP1 | 3IN IRON POST | IS | 1386667560000 | HARRISON ST | - | - | - | - | - | - |
| 102688 | N/A | Point | - | - | - | - | S246850 | HARRISON ST: DORE ST | - | F | F | - | F | 24230000 | 24230000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | DORE ST | DORE ST | 74129 | 74129 | 37.77205207 | -122.41067849 | HARRISON ST \ DORE ST | HARRISON ST \ DORE ST | 1710539427000 | MTA | ONE WAY (LA) | DORE ST intersection | - | - | - | - | - | - | - | 119975 | 1531398900000 | -122.41067849 | 37.77205207 | - | - | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | 3IN IRON POST | IS | 1531305120000 | HARRISON ST | - | - | - | - | - | - |
| 102689 | N/A | Point | 1 | 1 | 1335 - 1399 | - | S281504 | 1335-1399 HARRISON ST | 1335-1399 HARRISON ST | F | F | - | F | 6735000 | 6735000 | - | - | NORTH SIDE | - | - | - | - | DORE ST | DORE ST | 90670 | 90670 | 37.77181537 | -122.41097822 | - | - | 1710539427000 | MTA | BIKE RACK | DORE ST to 10TH ST (1335 - 1399) | 489547 | 18' E OF EPL 1354/ 2' IN FROM CURB | - | - | - | - | - | 119976 | 1660089600000 | -122.41097822 | 37.77181537 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1647337800000 | HARRISON ST | 1335 - 1399 HARRISON ST | 1335 - 1399 HARRISON ST | 1335 HARRISON ST | - | 10TH ST | 10TH ST |
| 102690 | N/A | Point | - | - | - | - | 24160 | - | - | F | F | - | F | 6735000 | - | - | - | SOUTH SIDE | 1695395209000 | smuneno | - | - | DORE ST | - | 156850 | 156850 | 37.771959345807 | -122.410857702175 | - | - | 1711748505000 | middleware_editor | 2 HR PRK 7AM-6PM EXC SUN | - | - | 20' WEST OF DORE ST | - | - | - | - | - | 119977 | - | - | - | - | - | 1706017500000 | 06 | - | PARKING | REG | R32(CA).0071 | 18X18 | SUP1 | 2IN IRON POST | RETD | - | - | 1335 - 1399 HARRISON ST | - | - | - | 10TH ST | - |
| 102691 | N/A | Point | - | - | - | - | 24162 | - | - | F | F | - | F | 6734000 | - | - | - | SOUTH SIDE | 1695395527000 | smuneno | - | - | 09TH ST | - | 156834 | 156834 | 37.772079135 | -122.410500298 | - | - | 1710539427000 | MTA | NPRK 4AM-6AM TUE THUR STCL | - | - | 30' EAST OF DORE ST | - | - | - | - | - | 119978 | - | - | - | - | - | - | 06 | - | STREET CLEANING | REG | R30B(CA).0150 | 18X18 | SUP1 | LIGHT POLE | PI | - | HARRISON ST | 1300 - 1348 HARRISON ST | - | - | - | DORE ST | - |
| 102692 | N/A | Point | - | - | - | - | 24163 | - | - | F | F | - | F | 6735000 | - | - | - | SOUTH SIDE | 1695395622000 | smuneno | - | - | DORE ST | - | 156835 | 156835 | 37.77170247 | -122.410974867 | - | - | 1710539427000 | MTA | NPRK 4AM-6AM TUE THUR STCL | - | - | 55' EAST OF 10TH ST | - | - | - | - | - | 119979 | - | - | - | - | - | - | 06 | - | STREET CLEANING | REG | R30B(CA).0150 | 18X18 | SUP1 | 2IN IRON POST | PI | - | HARRISON ST | 1335 - 1399 HARRISON ST | - | - | - | 10TH ST | - |
| 102693 | N/A | Point | - | - | - | - | S238198 | KEARNY ST: CLAY ST | - | T | T | - | F | 24770000 | 24770000 | - | - | NORTH EAST CORNER | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | KEARNY ST | CLAY ST | 72287 | 72287 | 37.794453 | -122.40479647 | CLAY ST \ KEARNY ST | KEARNY ST \ CLAY ST | 1710539427000 | MTA | BLUETOOTH SENSOR BOX | CLAY ST intersection | 09 | ABOVE G-7 | - | - | - | - | - | 119980 | 1487721600000 | -122.40479647 | 37.794453 | - | 1505174400000 | - | D3 | - | OTHER MISC | MISC | BLUETOOTH-SENSOR | 12X12 | SUP1 | SIGNAL POLE | IS | 1502368380000 | KEARNY ST | - | - | - | - | - | - |
| 102694 | N/A | Point | - | - | - | - | S233441 | SUTTER ST: KEARNY ST | - | T | T | - | F | 24720000 | 24720000 | - | - | NORTH EAST CORNER | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | KEARNY ST | SUTTER ST | 78886 | 78886 | 37.78982934 | -122.40384156 | SUTTER ST \ KEARNY ST | KEARNY ST \ SUTTER ST | 1710539427000 | MTA | BLUETOOTH SENSOR BOX | SUTTER ST intersection | 014 | - | - | - | - | - | - | 119981 | 1491405900000 | -122.40384156 | 37.78982934 | - | 1491350400000 | - | D3 | - | OTHER MISC | MISC | BLUETOOTH-SENSOR | 12X12 | SUP1 | GUIDE POLE | IS | 1486563720000 | KEARNY ST | - | - | - | - | - | - |
| 102695 | N/A | Point | - | - | - | - | S238201 | CALIFORNIA ST: GRANT AVE | - | T | T | - | F | 24751000 | 24751000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | GRANT AVE | CALIFORNIA ST | 114879 | 114879 | 37.79245075 | -122.40593812 | CALIFORNIA ST \ GRANT AVE | GRANT AVE \ CALIFORNIA ST | 1710539427000 | MTA | BLUETOOTH SENSOR BOX | CALIFORNIA ST intersection | 011 | - | - | - | - | - | - | 119982 | 1488240000000 | -122.40593812 | 37.79245075 | - | 1505174400000 | - | D3 | - | OTHER MISC | MISC | BLUETOOTH-SENSOR | 12X12 | SUP1 | SIGNAL POLE | IS | 1502370600000 | GRANT AVE | - | - | - | - | - | - |
| 102696 | N/A | Point | - | - | - | - | S233437 | - | - | T | T | - | F | 99991028 | - | - | - | WEST SIDE | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | - | - | 139790 | 139790 | 37.736671 | -122.359657 | - | - | 1710539427000 | MTA | BLUETOOTH SENSOR BOX | - | 012 | IFO # 429 X ST IS SUTTER | - | - | - | - | - | 119983 | 1488153600000 | - | - | - | 1488153600000 | - | - | - | OTHER MISC | MISC | BLUETOOTH-SENSOR | 12X12 | - | LIGHT POLE | IS | - | - | PENDING STOCKTON ST | - | - | - | - | - |
| 102697 | N/A | Point | 1 | 1 | 200 - 299 | - | S233435 | 200-299 POWELL ST | 200-299 POWELL ST | T | T | - | F | 10677000 | 10677000 | - | - | WEST SIDE | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | OFARRELL ST | OFARRELL ST | 69705 | 69705 | 37.78688444 | -122.40813148 | - | - | 1710539427000 | MTA | BLUETOOTH SENSOR BOX | OFARRELL ST to GEARY ST (200 - 299) | 02 | IFO #225 | - | - | - | - | - | 119984 | 1487938260000 | -122.40813148 | 37.78688444 | - | 1487894400000 | - | D3 | - | OTHER MISC | MISC | BLUETOOTH-SENSOR | 12X12 | SUP1 | LIGHT POLE | IS | 1486562880000 | POWELL ST | 200 - 299 POWELL ST | 200 - 299 POWELL ST | 200 POWELL ST | - | GEARY ST | GEARY ST |
| 102698 | N/A | Point | 1 | 1 | 333 - 399 | - | S233440 | 333-399 GRANT AVE | 333-399 GRANT AVE | T | T | - | F | 6388000 | 6388000 | - | - | EAST SIDE | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | HARLAN PL | HARLAN PL | 69707 | 69707 | 37.79032239 | -122.40554636 | - | - | 1710539427000 | MTA | BLUETOOTH SENSOR BOX | HARLAN PL to BUSH ST (333 - 399) | 013 | 25' NORTH OF HARLAN PL | - | - | - | - | - | 119985 | 1487894400000 | -122.40554636 | 37.79032239 | - | 1487894400000 | - | D3 | - | OTHER MISC | MISC | BLUETOOTH-SENSOR | 12X12 | SUP1 | LIGHT POLE | IS | 1486563540000 | GRANT AVE | 333 - 399 GRANT AVE | 333 - 399 GRANT AVE | 333 GRANT AVE | - | BUSH ST | BUSH ST |
| 102699 | N/A | Point | - | - | - | - | S233484 | MASON ST: SUTTER ST | - | T | T | - | F | 24920000 | 24920000 | - | - | EAST SIDE | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | MASON ST | SUTTER ST | 69716 | 69716 | 37.78901634 | -122.41024244 | SUTTER ST \ MASON ST | MASON ST \ SUTTER ST | 1730742782000 | middleware_editor | BLUETOOTH SENSOR BOX | SUTTER ST intersection | 04 | OPP C/L OF JESSIE | - | - | - | - | - | 119986 | 1488292260000 | -122.41024244 | 37.78901634 | - | 1488240000000 | - | D3 | - | OTHER MISC | MISC | BLUETOOTH-SENSOR | 12X12 | SUP1 | LIGHT POLE | IS | 1486637220000 | MASON ST | - | - | - | - | - | - |
| 102700 | N/A | Point | - | - | - | - | S238206 | 3RD ST: MISSION ST | - | T | T | - | F | 24613000 | 24613000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | 3RD ST | 03RD ST | 72292 | 72292 | 37.78624815 | -122.40202542 | MISSION ST \ 3RD ST | MISSION ST \ 03RD ST | 1726190880000 | middleware_editor | BLUETOOTH SENSOR BOX | 03RD ST intersection | 016 | - | - | - | - | - | - | 119987 | 1488412800000 | -122.40202542 | 37.78624815 | - | 1505174400000 | - | D6 | - | OTHER MISC | MISC | BLUETOOTH-SENSOR | 12X12 | SUP1 | SIGNAL POLE | IS | 1502371800000 | MISSION ST | - | - | - | - | - | - |
| 102701 | N/A | Point | - | - | - | - | S238191 | POWELL ST: CLAY ST | - | T | T | - | F | 25014000 | 25014000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | POWELL ST | CLAY ST | 109659 | 109659 | 37.79385193 | -122.40954105 | CLAY ST \ POWELL ST | POWELL ST \ CLAY ST | 1717032027000 | middleware_editor | BLUETOOTH SENSOR BOX | CLAY ST intersection | 02 | - | - | - | - | - | - | 119988 | 1487894400000 | -122.40954105 | 37.79385193 | - | 1505088000000 | - | D3 | - | OTHER MISC | MISC | BLUETOOTH-SENSOR | 12X12 | SUP1 | SIGNAL POLE | IS | 1502363520000 | POWELL ST | - | - | - | - | - | - |
| 102702 | N/A | Point | 1 | 1 | 300 - 399 | - | S233434 | 300-399 POWELL ST | 300-399 POWELL ST | T | T | - | F | 10678000 | 10678000 | - | - | EAST SIDE | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | GEARY ST | GEARY ST | 69704 | 69704 | 37.78782623 | -122.40831414 | - | - | 1751561730000 | middleware_editor | BLUETOOTH SENSOR BOX | GEARY ST to POST ST (300 - 399) | 03 | 85' SOUTH OF POST | - | - | - | - | - | 119989 | 1487890920000 | -122.40831414 | 37.78782623 | - | 1487836800000 | - | D3 | - | OTHER MISC | MISC | BLUETOOTH-SENSOR | 12X12 | SUP1 | LIGHT POLE | IS | 1486562760000 | POWELL ST | 300 - 399 POWELL ST | 300 - 399 POWELL ST | 300 POWELL ST | - | POST ST | POST ST |
| 102703 | N/A | Point | 1 | 1 | 100 - 199 | - | S233436 | 100-199 POWELL ST | 100-199 POWELL ST | T | T | - | F | 10676000 | 10676000 | - | - | EAST SIDE | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | ELLIS ST | ELLIS ST | 69706 | 69706 | 37.78595059 | -122.40794438 | - | - | 1710539427000 | MTA | BLUETOOTH SENSOR BOX | ELLIS ST to OFARRELL ST (100 - 199) | 01 | 90 FT SOUTH OF OFARRELL | - | - | - | - | - | 119990 | 1491487440000 | -122.40794438 | 37.78595059 | - | 1491436800000 | - | D3 | - | OTHER MISC | MISC | BLUETOOTH-SENSOR | 12X12 | SUP1 | LIGHT POLE | IS | 1486563060000 | POWELL ST | 100 - 199 POWELL ST | 100 - 199 POWELL ST | 100 POWELL ST | - | OFARRELL ST | OFARRELL ST |
| 102704 | N/A | Point | - | - | - | - | S238192 | STOCKTON ST: JACKSON ST | - | T | T | - | F | 25027000 | 25027000 | - | - | NORTH EAST CORNER | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | JACKSON ST | JACKSON ST | 72227 | 72227 | 37.79582371 | -122.4082532 | STOCKTON ST \ JACKSON ST | STOCKTON ST \ JACKSON ST | 1710539427000 | MTA | BLUETOOTH SENSOR BOX | JACKSON ST intersection | 03 | - | - | - | - | - | - | 119991 | 1487808000000 | -122.4082532 | 37.79582371 | - | 1505088000000 | - | D3 | - | OTHER MISC | MISC | BLUETOOTH-SENSOR | 12X12 | SUP1 | SIGNAL POLE | IS | 1502364060000 | STOCKTON ST | - | - | - | - | - | - |
| 102705 | N/A | Point | - | - | - | - | S238193 | POWELL ST: PACIFIC AVE | - | T | T | - | F | 25064000 | 25064000 | - | - | NORTH WEST CORNER | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | PACIFIC AVE | PACIFIC AVE | 72282 | 72282 | 37.79649276 | -122.41007597 | POWELL ST \ PACIFIC AVE | POWELL ST \ PACIFIC AVE | 1710539427000 | MTA | BLUETOOTH SENSOR BOX | PACIFIC AVE intersection | 04 | - | - | - | - | - | - | 119992 | 1488240000000 | -122.41007597 | 37.79649276 | - | 1505088000000 | - | D3 | - | OTHER MISC | MISC | BLUETOOTH-SENSOR | 12X12 | SUP1 | LIGHT POLE | IS | 1502364540000 | POWELL ST | - | - | - | - | - | - |
| 102706 | N/A | Point | - | - | - | - | S238204 | KEARNY ST: SACRAMENTO ST | - | T | T | - | F | 24733000 | 24733000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | SACRAMENTO ST | KEARNY ST | 72290 | 72290 | 37.79356508 | -122.40461342 | KEARNY ST \ SACRAMENTO ST | SACRAMENTO ST \ KEARNY ST | 1719364052000 | middleware_editor | BLUETOOTH SENSOR BOX | KEARNY ST intersection | 014 | - | - | - | - | - | - | 119993 | 1491350400000 | -122.40461342 | 37.79356508 | - | 1505174400000 | - | D3 | - | OTHER MISC | MISC | BLUETOOTH-SENSOR | 12X12 | SUP1 | SIGNAL POLE | IS | 1502371200000 | SACRAMENTO ST | - | - | - | - | - | - |
| 102707 | N/A | Point | - | - | - | - | S233418 | OFARRELL ST: TAYLOR ST | - | T | T | - | F | 24942000 | 24942000 | - | - | NORTH WEST CORNER | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | OFARRELL ST | TAYLOR ST | 70394 | 70394 | 37.78599624 | -122.41132558 | TAYLOR ST \ OFARRELL ST | OFARRELL ST \ TAYLOR ST | 1722368584000 | middleware_editor | BLUETOOTH SENSOR BOX | TAYLOR ST intersection | 07 | - | - | - | - | - | - | 119994 | 1487863260000 | -122.41132558 | 37.78599624 | - | 1487808000000 | - | D3 | - | OTHER MISC | MISC | BLUETOOTH-SENSOR | 12X12 | SUP1 | LIGHT POLE | IS | 1486554840000 | OFARRELL ST | - | - | - | - | - | - |
| 102708 | N/A | Point | - | - | - | - | S238196 | COLUMBUS AVE: KEARNY ST | - | T | T | - | F | 24791000 | 24791000 | - | - | NORTH EAST CORNER | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | KEARNY ST | COLUMBUS AVE | 72285 | 72285 | 37.79690906 | -122.4052884 | COLUMBUS AVE \ KEARNY ST | KEARNY ST \ COLUMBUS AVE | 1711769366000 | middleware_editor | BLUETOOTH SENSOR BOX | COLUMBUS AVE intersection | 07 | ABOVE G-7 | - | - | - | - | - | 119995 | 1487808000000 | -122.4052884 | 37.79690906 | - | 1487808000000 | - | D3 | - | OTHER MISC | MISC | BLUETOOTH-SENSOR | 12X12 | SUP1 | SIGNAL POLE | IS | 1502367540000 | KEARNY ST | - | - | - | - | - | - |
| 102709 | N/A | Point | - | - | - | - | S238205 | MARKET ST: MONTGOMERY ST \ NEW | - | T | T | - | F | 30735000 | 30735000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | 1695770401000 | MTA | - | No Sign Code Match in Ref Table | MONTGOMERY ST \ NEW MONTGOMERY ST | MARKET ST \ MONTGOMERY ST | 72291 | 72291 | 37.78872115 | -122.40206573 | MARKET ST \ MONTGOMERY ST \ NEW MONTGOMERY ST | NEW MONTGOMERY ST \ MARKET ST \ MONTGOMERY ST | 1710539427000 | MTA | BLUETOOTH SENSOR BOX | MARKET ST \ MONTGOMERY ST intersection | 015 | 80' WEST OF MOMTGOMERY | - | - | - | - | - | 119996 | 1487808000000 | -122.40206573 | 37.78872115 | - | 1505174400000 | - | D3 | - | OTHER MISC | MISC | BLUETOOTH-SENSOR | 12X12 | SUP1 | LIGHT POLE | IS | 1502371560000 | NEW MONTGOMERY ST | - | - | - | - | - | - |
| 102710 | N/A | Point | 1 | 1 | 1900 - 1999 | LEFT ARROW | S271529 | 1900-1999 MISSION ST | 1900-1999 MISSION ST | F | F | - | F | 9115000 | 9115000 | - | - | WEST SIDE | - | - | - | - | 15TH ST | 15TH ST | 91673 | 91673 | 37.76586247 | -122.4197471 | - | - | 1710539427000 | MTA | TA (SYM) PLO AT ALL TIMES (5 MIN) H/C (SYM ) | 15TH ST to 16TH ST (1900 - 1999) | - | IFO #1950 314 FT NORTH OF 16TH NPL 1950 | - | - | - | - | - | 119998 | 1250812800000 | -122.4197471 | 37.76586247 | - | 1613088000000 | - | D9 | - | OTHER REGULATORY | REG | R38(SF)1.0056 | 14X21 | SUP2 | 2IN IRON POST | IS | 1610624040000 | MISSION ST | 1900 - 1999 MISSION ST | 1900 - 1999 MISSION ST | 1900 MISSION ST | - | 16TH ST | 16TH ST |
| 102711 | N/A | Point | - | - | - | - | S243865 | GEARY BLVD: 7TH AVE | - | F | F | - | F | 27285000 | 27285000 | - | SHOULD BE RETIRED | CENTER ISLAND, W LINE, WESTBOUND | - | - | - | - | 7TH AVE | GEARY BLVD | 84745 | 84745 | 37.78096549 | -122.46535287 | GEARY BLVD \ 7TH AVE | 07TH AVE \ GEARY BLVD | 1710539427000 | MTA | NO LEFT TURN (SYM) | GEARY BLVD intersection | - | WEST LINE | - | - | - | - | - | 119999 | - | -122.46535287 | 37.78096549 | - | - | - | D1 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | LIGHT POLE | RETD | 1521538440000 | 07TH AVE | - | - | - | - | - | - |
| 102712 | N/A | Point | - | - | - | - | S239284 | PRAGUE ST: GENEVA AVE | - | F | F | - | F | 21379000 | 21379000 | - | - | NORTH WEST CORNER | - | - | - | - | GENEVA AVE | PRAGUE ST | 83820 | 83820 | 37.7127666 | -122.43192724 | PRAGUE ST \ GENEVA AVE | GENEVA AVE \ PRAGUE ST | 1710539427000 | MTA | PRAGUE ST | PRAGUE ST intersection | - | SIGNAL POLE | - | - | - | - | - | 120000 | 1459296000000 | -122.43192724 | 37.7127666 | - | 1459296000000 | - | D11 | - | STREET NAME | GUIDE | D3-1.1420 | 36X08 | SUP2 | SIGNAL POLE | IS | 1507029420000 | GENEVA AVE | - | - | - | - | - | - |
| 102713 | N/A | Point | - | - | - | - | S234633 | GENEVA AVE: PRAGUE ST | - | T | T | - | F | 21379000 | 21379000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GENEVA AVE | PRAGUE ST | 69165 | 69165 | 37.7127666 | -122.43192724 | PRAGUE ST \ GENEVA AVE | GENEVA AVE \ PRAGUE ST | 1710539427000 | MTA | PRAGUE ST | PRAGUE ST intersection | - | ON MAST ARM | - | - | - | - | - | 120001 | 1511958600000 | -122.43192724 | 37.7127666 | - | 1707128520000 | - | D11 | - | STREET NAME | GUIDE | D3-2.0286 | 72X18 | SUP2 | OVERHEAD MAST ARM | IS | 1490621880000 | GENEVA AVE | - | - | - | - | - | - |
| 102714 | N/A | Point | - | - | - | - | S239283 | PRAGUE ST: GENEVA AVE | - | F | F | - | F | 21379000 | 21379000 | - | SHOULD BE RETIRED | SOUTH WEST CORNER | - | - | - | - | GENEVA AVE | PRAGUE ST | 83819 | 83819 | 37.7127666 | -122.43192724 | PRAGUE ST \ GENEVA AVE | GENEVA AVE \ PRAGUE ST | 1710539427000 | MTA | PRAGUE ST | PRAGUE ST intersection | - | SIGNAL POLE | - | - | - | - | - | 120002 | 1459296000000 | -122.43192724 | 37.7127666 | - | 1459296000000 | - | D11 | - | STREET NAME | GUIDE | D3-1.1420 | 36X08 | SUP2 | 2IN IRON POST | RETD | 1507029240000 | GENEVA AVE | - | - | - | - | - | - |
| 102715 | N/A | Point | - | - | - | - | S242918 | PRAGUE ST: GENEVA AVE | - | F | F | - | F | 21379000 | 21379000 | - | SHOULD BE RETIRED | SOUTH WEST CORNER | - | - | - | - | GENEVA AVE | PRAGUE ST | 81955 | 81955 | 37.7127666 | -122.43192724 | PRAGUE ST \ GENEVA AVE | GENEVA AVE \ PRAGUE ST | 1710539427000 | MTA | GENEVA AVE | PRAGUE ST intersection | - | - | - | - | - | - | - | 120003 | 1459296000000 | -122.43192724 | 37.7127666 | - | 1519344000000 | - | D11 | - | STREET NAME | GUIDE | D3-1.0722 | 36X08 | SUP2 | SIGNAL POLE | RETD | 1518085860000 | GENEVA AVE | - | - | - | - | - | - |
| 102716 | N/A | Point | 1 | 1 | 300 - 399 | - | S144946 | 300-399 RICHLAND AVE | 300-399 RICHLAND AVE | F | F | - | F | 11014000 | 11014000 | - | - | SOUTH SIDE | - | - | - | - | MURRAY ST | MURRAY ST | 38418 | 38418 | 37.73569077 | -122.41846149 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM 2ND & 4TH THUR OF MONTH STCL | MURRAY ST to ANDOVER ST (300 - 399) | - | 342 RICHLAND | - | - | - | - | - | 120004 | 1222819200000 | -122.41846149 | 37.73569077 | - | 1709634600000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0256 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375727400000 | RICHLAND AVE | 300 - 399 RICHLAND AVE | 300 - 399 RICHLAND AVE | 300 RICHLAND AVE | - | ANDOVER ST | ANDOVER ST |
| 102717 | N/A | Point | 1 | 1 | 300 - 399 | - | S144943 | 300-399 RICHLAND AVE | 300-399 RICHLAND AVE | F | F | - | F | 11014000 | 11014000 | - | - | SOUTH SIDE | - | - | - | - | MURRAY ST | MURRAY ST | 38415 | 38415 | 37.73569077 | -122.41846149 | - | - | 1749140591000 | middleware_editor | NPRK 8AM-10AM 2ND & 4TH THUR OF MONTH STCL | MURRAY ST to ANDOVER ST (300 - 399) | - | 364 RICHLAND | - | - | - | - | - | 120005 | 1222844400000 | -122.41846149 | 37.73569077 | - | 1749057900000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0256 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375727400000 | RICHLAND AVE | 300 - 399 RICHLAND AVE | 300 - 399 RICHLAND AVE | 300 RICHLAND AVE | - | ANDOVER ST | ANDOVER ST |
| 102718 | N/A | Point | 1 | 1 | 3500 - 3535 | - | S134606 | 3500-3535 18TH ST | 3500-3535 18TH ST | F | F | - | F | 881000 | 881000 | - | - | NORTH SIDE | - | - | - | - | VALENCIA ST | VALENCIA ST | 115466 | 115466 | 37.76167556 | -122.42199491 | - | - | 1741730738000 | middleware_editor | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | VALENCIA ST to LAPIDGE ST (3500 - 3535) | - | IFO #3538 | - | - | - | - | - | 120006 | 1310626800000 | -122.42199491 | 37.76167556 | - | 1741729200000 | - | D8 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP2 | LIGHT POLE | IS | 1373578380000 | 18TH ST | 3500 - 3535 18TH ST | 3500 - 3535 18TH ST | 3500 18TH ST | - | LAPIDGE ST | LAPIDGE ST |
| 102719 | N/A | Point | 1 | 1 | 172 - 199 | - | S288487 | 172-199 CLARA ST | 172-199 CLARA ST | F | F | - | F | 4058000 | 4058000 | - | - | SOUTH SIDE | - | - | - | - | HULBERT ALY | HULBERT ALY | 98479 | 98479 | 37.77958181 | -122.40222158 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | HULBERT ALY to 05TH ST (172 - 199) | - | E END OF CORRAL | - | - | - | - | 1 | 120007 | - | -122.40222158 | 37.77958181 | - | 1707827100000 | 1681344000000 | D6 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1681286880000 | CLARA ST | 172 - 199 CLARA ST | 172 - 199 CLARA ST | 172 CLARA ST | - | 05TH ST | 05TH ST |
| 102720 | N/A | Point | 1 | 1 | 172 - 199 | - | S273404 | 172-199 CLARA ST | 172-199 CLARA ST | F | F | - | F | 4058000 | 4058000 | - | - | SOUTH SIDE | - | - | - | - | HULBERT ALY | HULBERT ALY | 101870 | 101870 | 37.77958181 | -122.40222158 | - | - | 1710539427000 | MTA | BIKE RACK | HULBERT ALY to 05TH ST (172 - 199) | - | 32' E OF WPL 185/ FIRST RACK IN CORRAL | - | - | - | - | - | 120008 | - | -122.40222158 | 37.77958181 | - | 1707821100000 | 1681344000000 | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1616410980000 | CLARA ST | 172 - 199 CLARA ST | 172 - 199 CLARA ST | 172 CLARA ST | - | 05TH ST | 05TH ST |
| 102721 | N/A | Point | - | - | - | - | 24361 | - | - | F | F | - | F | 6079201 | - | - | - | CENTER ISLAND, W LINE, EASTBOUND | 1695996697000 | evillan | - | - | 22ND AVE | - | 159377 | 159377 | 37.7802500729951 | -122.481662265245 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM) | - | - | CENTER ISLAND W LINE EB | - | - | - | - | - | 120009 | - | - | - | - | - | - | 01 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP2 | LIGHT POLE | PI | - | - | 5800 - 5898 GEARY BLVD | - | - | - | 23RD AVE | - |
| 102722 | N/A | Point | - | - | - | - | S109974 | ARMSTRONG AVE: JENNINGS ST | - | F | F | - | F | 20481000 | 20481000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | JENNINGS ST | ARMSTRONG AVE | 8554 | 8554 | 37.725041285 | -122.390387697 | ARMSTRONG AVE \ JENNINGS ST | JENNINGS ST \ ARMSTRONG AVE | 1735068013000 | middleware_editor | STOP | ARMSTRONG AVE intersection | - | 0 / 0 | - | - | - | - | - | 120010 | 578534400000 | -122.39036271 | 37.72516721 | - | 1735036200000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570640000 | JENNINGS ST | - | - | - | - | - | - |
| 102723 | N/A | Point | - | - | - | - | 24367 | - | - | F | F | - | F | 6074101 | - | - | - | CENTER ISLAND, E LINE, EASTBOUND | 1695997174000 | evillan | - | - | 17TH AVE | - | 159426 | 159426 | 37.7804309732703 | -122.477114132933 | - | - | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | - | - | CENTER ISLAND E LINE EB | - | - | - | - | - | 120011 | - | - | - | - | - | - | 01 | - | NO LEFT TURN | REG | R3-18.0002 | 30X30 | SUP2 | LIGHT POLE | PI | - | - | 5301 - 5399 GEARY BLVD | - | - | - | 18TH AVE | - |
| 102724 | N/A | Point | - | - | - | - | S268474 | JEFFERSON ST: TAYLOR ST | - | F | F | - | F | 25594000 | 25594000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | JEFFERSON ST | TAYLOR ST | 104829 | 104829 | 37.80821405 | -122.41580243 | TAYLOR ST \ JEFFERSON ST | JEFFERSON ST \ TAYLOR ST | 1710539427000 | MTA | TAYLOR ST | TAYLOR ST intersection | - | - | - | - | - | - | - | 120012 | 1603200840000 | -122.41580243 | 37.80821405 | - | - | - | D3 | - | STREET NAME | GUIDE | D3-2.0332 | 72X18 | SUP1 | LIGHT POLE | IS | 1601027160000 | JEFFERSON ST | - | - | - | - | - | - |
| 102725 | N/A | Point | - | - | - | - | S207722 | 23RD ST: INDIANA ST | - | F | F | - | F | 23617000 | 23617000 | - | - | SOUTH EAST CORNER | - | - | - | - | INDIANA ST | 23RD ST | 49361 | 49361 | 37.7552139 | -122.39092194 | 23RD ST \ INDIANA ST | INDIANA ST \ 23RD ST | 1710539427000 | MTA | 23RD ST | 23RD ST intersection | - | I<1100 BLK | - | - | - | - | - | 120013 | 1410767280000 | -122.39092194 | 37.7552139 | - | 1695308100000 | - | D10 | - | STREET NAME | GUIDE | D3-1.0017 | 36X08 | SUP1 | LIGHT POLE | IS | 1405597920000 | INDIANA ST | - | - | - | - | - | - |
| 102726 | N/A | Point | 1 | 1 | 300 - 399 | - | S274363 | 300-399 GOLDEN GATE AVE | 300-399 GOLDEN GATE AVE | F | F | - | F | 6263000 | 6263000 | - | - | NORTH SIDE | - | - | - | - | HYDE ST | HYDE ST | 108415 | 108415 | 37.78155088 | -122.4163254 | - | - | 1710539427000 | MTA | WHEEL STOP | HYDE ST to LARKIN ST (300 - 399) | - | 70' W OF HYDE IN CORRAL | - | - | - | - | - | 120014 | 1621508520000 | -122.4163254 | 37.78155088 | - | - | - | D6 | - | OTHER WARNING | WARNING | W(SF).0072 | 36X08 | SUP1 | SPIKE | IS | 1619771100000 | GOLDEN GATE AVE | 300 - 399 GOLDEN GATE AVE | 300 - 399 GOLDEN GATE AVE | 300 GOLDEN GATE AVE | - | LARKIN ST | LARKIN ST |
| 102727 | N/A | Point | 1 | 1 | 300 - 399 | - | S257284 | 300-399 HAYES ST | 300-399 HAYES ST | F | F | - | F | 6815000 | 6815000 | - | - | SOUTH SIDE | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 90242 | 90242 | 37.77698725 | -122.42215429 | - | - | 1710539427000 | MTA | BIKE RACK | FRANKLIN ST to GOUGH ST (300 - 399) | 67730 | 12' W OF EPL#301/2.5' IN FROM CURB | - | - | - | - | - | 120015 | 1566985860000 | -122.42215429 | 37.77698725 | - | - | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1566544560000 | HAYES ST | 300 - 399 HAYES ST | 300 - 399 HAYES ST | 300 HAYES ST | - | GOUGH ST | GOUGH ST |
| 102728 | N/A | Point | 1 | 1 | 1900 - 1999 | - | S208809 | 1900-1999 PAGE ST | 1900-1999 PAGE ST | F | F | - | F | 10188000 | 10188000 | - | - | NORTH SIDE | - | - | - | - | SHRADER ST | SHRADER ST | 125749 | 125749 | 37.77020634 | -122.45289092 | - | - | 1746739590000 | middleware_editor | NPRK 12NN-2PM TUE STCL | SHRADER ST to STANYAN ST (1900 - 1999) | - | INFO #1984 | - | - | - | - | - | 120016 | 1411676640000 | -122.45289092 | 37.77020634 | - | 1746739500000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0083 | 18X18 | SUP1 | 2IN IRON POST | IS | 1410171060000 | PAGE ST | 1900 - 1999 PAGE ST | 1900 - 1999 PAGE ST | 1900 PAGE ST | - | STANYAN ST | STANYAN ST |
| 102729 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S152303 | 1400-1499 WAWONA ST | 1400-1499 WAWONA ST | F | F | - | F | 13481000 | 13481000 | - | - | SOUTH SIDE | - | - | - | - | 25TH AVE | 25TH AVE | 41896 | 41896 | 37.73738485 | -122.48224864 | - | - | 1754068883000 | middleware_editor | NPRK 7AM-9AM 2ND & 4TH FRI OF MONTH STCL | 25TH AVE to WAWONA ST (1400 - 1499) | - | 1432 WAWONA | - | - | - | - | - | 120017 | 1228896000000 | -122.48224864 | 37.73738485 | - | 1578643200000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0231 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375730640000 | WAWONA ST | 1400 - 1499 WAWONA ST | 1400 - 1499 WAWONA ST | 1400 WAWONA ST | - | WAWONA ST | WAWONA ST |
| 102730 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S238514 | 1400-1499 WAWONA ST | 1400-1499 WAWONA ST | F | F | - | F | 13481000 | 13481000 | - | - | WEST SIDE, WESTBOUND TRAFFIC | - | - | - | - | 25TH AVE | 25TH AVE | 68989 | 68989 | 37.73738485 | -122.48224864 | - | - | 1710539427000 | MTA | END | 25TH AVE to WAWONA ST (1400 - 1499) | - | AT END OF STREET | - | - | - | - | - | 120018 | - | -122.48224864 | 37.73738485 | - | - | - | D4 | - | OTHER WARNING | WARNING | W31(CA).0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1503917460000 | WAWONA ST | 1400 - 1499 WAWONA ST | 1400 - 1499 WAWONA ST | 1400 WAWONA ST | - | WAWONA ST | WAWONA ST |
| 102731 | N/A | Point | - | - | - | - | S274815 | WAWONA ST: END | - | F | F | - | F | 23227000 | 50565000 | - | - | NORTH WEST CORNER | - | - | - | - | 24TH AVE | WAWONA ST | 123535 | 123535 | 37.73746869 | -122.48282689 | WAWONA ST \ 24TH AVE | WAWONA ST \ WAWONA ST | 1710539427000 | MTA | WAWONA ST | WAWONA ST intersection | - | - | - | - | - | - | - | 120019 | 1587340800000 | -122.48282689 | 37.73746869 | - | 1627948800000 | - | D7 | - | STREET NAME | GUIDE | D3-1.1841 | 36X08 | SUP2 | 3IN IRON POST | IS | 1621421640000 | WAWONA ST | - | - | - | - | - | - |
| 102732 | N/A | Point | 1 | 1 | 1 - 99 | - | S152327 | 1-99 ROSEMARY CT | 1-99 ROSEMARY CT | F | F | - | F | 11156000 | 11156000 | - | - | NORTH SIDE | - | - | - | - | 25TH AVE | 25TH AVE | 40832 | 40832 | 37.73779245 | -122.48150247 | - | - | 1748363384000 | middleware_editor | NPRK 8AM-10AM 2ND & 4TH FRI OF MONTH STCL | 25TH AVE to END: 1-99 BLOCK (1 - 99) | - | 2606 ROSEMARY | - | - | - | - | - | 120020 | 1228896000000 | -122.48150247 | 37.73779245 | - | 1748026800000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0254 | 18X18 | SUP2 | 2IN IRON POST | IS | 1375730640000 | ROSEMARY CT | 1 - 99 ROSEMARY CT | 1 - 99 ROSEMARY CT | 1 ROSEMARY CT | - | END: 1-99 BLOCK | END: 1-99 BLOCK |
| 102733 | N/A | Point | 1 | 1 | 200 - 249 | - | S213637 | 200-249 CONCORD ST | 200-249 CONCORD ST | F | F | - | F | 4321000 | 4321000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | BRUNSWICK ST | BRUNSWICK ST | 51253 | 51253 | 37.71062907 | -122.44202387 | - | - | 1741200419000 | middleware_editor | STOP AHEAD (SYM) | BRUNSWICK ST to PRETOR WAY (200 - 249) | - | WPL#227 | - | - | - | - | - | 120021 | 1426283580000 | -122.44202387 | 37.71062907 | - | 1426230000000 | - | D11 | - | OTHER WARNING | WARNING | W3-1.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | 1424339520000 | CONCORD ST | 200 - 249 CONCORD ST | 200 - 249 CONCORD ST | 200 CONCORD ST | - | PRETOR WAY | PRETOR WAY |
| 102734 | N/A | Point | 1 | 1 | 600 - 627 | - | S210555 | 600-627 LAGUNA ST | 600-627 LAGUNA ST | F | F | - | F | 25935000 | 7950000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | IVY ST | HAYES ST | 51836 | 51836 | 37.7768794395105 | -122.426422502 | LAGUNA ST \ IVY ST | - | 1754338789000 | middleware_editor | STOP AHEAD (SYM) | HAYES ST to IVY ST (600 - 627) | - | - | - | - | - | - | - | 120022 | 1416349380000 | -122.42631119 | 37.77669725 | - | 1754333100000 | - | D5 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1415099160000 | LAGUNA ST | - | 600 - 627 LAGUNA ST | 600 LAGUNA ST | - | - | IVY ST |
| 102735 | N/A | Point | 1 | 1 | 1900 - 1999 | - | S212919 | 1900-1999 LAWTON ST | 1900-1999 LAWTON ST | T | T | - | F | 8205000 | 8205000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 25TH AVE | 25TH AVE | 51708 | 51708 | 37.75766021 | -122.48369797 | - | - | 1744746515000 | middleware_editor | STOP AHEAD (SYM) | 25TH AVE to 26TH AVE (1900 - 1999) | - | 45`EAST OF 26TH AVE | - | - | - | - | - | 120023 | - | -122.48369797 | 37.75766021 | - | - | - | D4 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1422353520000 | LAWTON ST | 1900 - 1999 LAWTON ST | 1900 - 1999 LAWTON ST | 1900 LAWTON ST | - | 26TH AVE | 26TH AVE |
| 102736 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S211539 | 1200-1299 PHELPS ST | 1200-1299 PHELPS ST | F | F | - | F | 10404000 | 10404000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | MCKINNON AVE | MCKINNON AVE | 52593 | 52593 | 37.73765598 | -122.39324436 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | MCKINNON AVE to NEWCOMB AVE (1200 - 1299) | - | OPP 1201-1203 | - | - | - | - | - | 120024 | - | -122.39324436 | 37.73765598 | - | - | - | D10 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1418119980000 | PHELPS ST | 1200 - 1299 PHELPS ST | 1200 - 1299 PHELPS ST | 1200 PHELPS ST | - | NEWCOMB AVE | NEWCOMB AVE |
| 102737 | N/A | Point | 1 | 1 | 1 - 99 | - | S226359 | 50-99 GLENVIEW DR | 1-99 GLENVIEW DR | F | F | - | F | 6222000 | 6222000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | PORTOLA DR | PORTOLA DR | 68626 | 68626 | 37.74751214 | -122.4477932 | - | - | 1710539427000 | MTA | STOP AHEAD (SYM) | PORTOLA DR to DAWNVIEW WAY (1 - 99) | - | IFO#50 | - | - | - | - | - | 120025 | 1467207900000 | -122.4477932 | 37.74751214 | - | 1467158400000 | - | D8 | - | OTHER WARNING | WARNING | W3-1.0001 | 24X24 | SUP2 | UTILITY POLE | IS | 1465380900000 | GLENVIEW DR | 1 - 99 GLENVIEW DR | 1 - 99 GLENVIEW DR | 1 GLENVIEW DR | - | DAWNVIEW WAY | DAWNVIEW WAY |
| 102738 | N/A | Point | - | - | - | - | S201270 | GREENWICH ST: VIA BUFANO | - | F | F | - | F | 25452000 | 25452000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | VIA BUFANO | GREENWICH ST | 51001 | 51001 | 37.80205023 | -122.41160002 | GREENWICH ST \ VIA BUFANO | VIA BUFANO \ GREENWICH ST | 1710539427000 | MTA | STOP AHEAD (SYM) | GREENWICH ST intersection | - | - | - | - | - | - | - | 120026 | - | -122.41160002 | 37.80205023 | - | - | - | D3 | - | OTHER WARNING | WARNING | W3-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1387463700000 | VIA BUFANO | - | - | - | - | - | - |
| 102739 | N/A | Point | - | - | - | - | S220576 | FELL ST: 10TH ST \ MARKET ST \ | - | F | F | - | F | 30746000 | 30746000 | - | - | NORTH WEST CORNER | - | - | - | - | 10TH ST \ FELL ST \ POLK ST | 10TH ST \ FELL ST \ POLK ST | 59297 | 59297 | 37.77654089 | -122.41750146 | MARKET ST \ 10TH ST \ FELL ST \ POLK ST | MARKET ST \ 10TH ST \ FELL ST \ POLK ST | 1710539427000 | MTA | STOP HERE ON RED (45LA) | 10TH ST \ FELL ST \ POLK ST intersection | - | NWC OF FELL & MARKET | - | - | - | - | - | 120027 | - | -122.41750146 | 37.77654089 | - | - | - | D6 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP1 | 2IN IRON POST | IS | 1446813180000 | MARKET ST | - | - | - | - | - | - |
| 102740 | N/A | Point | 1 | 1 | 100 - 199 | - | S215770 | 100-199 OAK ST | 100-199 OAK ST | F | F | - | F | 9751000 | 9751000 | - | - | SOUTH SIDE | - | - | - | - | FRANKLIN ST | FRANKLIN ST | 55233 | 55233 | 37.77512844 | -122.42177934 | - | - | 1710539427000 | MTA | STOP HERE ON RED (45LA) | FRANKLIN ST to GOUGH ST (100 - 199) | - | 200' WEST OF FRANKLIN | - | - | - | - | - | 120028 | - | -122.42177934 | 37.77512844 | - | - | - | D5 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP1 | 2IN IRON POST | IS | 1430391900000 | OAK ST | 100 - 199 OAK ST | 100 - 199 OAK ST | 100 OAK ST | - | GOUGH ST | GOUGH ST |
| 102741 | N/A | Point | - | - | - | - | S215530 | WOODSIDE AVE: LAGUNA HONDA BLV | - | F | F | - | F | 22863000 | 22863000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | WOODSIDE AVE | WOODSIDE AVE | 57421 | 57421 | 37.74675543 | -122.45872852 | LAGUNA HONDA BLVD \ WOODSIDE AVE | LAGUNA HONDA BLVD \ WOODSIDE AVE | 1710539427000 | MTA | STOP HERE ON RED (45LA) | WOODSIDE AVE intersection | - | UNDER SIGNAL LIGHT | - | - | - | - | - | 120029 | 577324800000 | -122.45872852 | 37.74675543 | - | 1594166400000 | - | D7 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP2 | LIGHT POLE | IS | 1429706340000 | LAGUNA HONDA BLVD | - | - | - | - | - | - |
| 102742 | N/A | Point | 1 | 1 | 1 - 99 | - | S214261 | 1-99 EVELYN WAY | 1-99 EVELYN WAY | F | F | - | F | 5344000 | 5344000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | PORTOLA DR | PORTOLA DR | 52316 | 52316 | 37.74369629 | -122.45382491 | - | - | 1710539427000 | MTA | STOP HERE ON RED (45LA) | PORTOLA DR to JUANITA WAY (1 - 99) | - | 15`SOUTH ( SEE PAINT MARK) | - | - | - | - | - | 120030 | 1427793180000 | -122.45382491 | 37.74369629 | - | 1623196800000 | - | D7 | - | OTHER REGULATORY | REG | R10-6.0002 | 24X36 | SUP2 | 2IN IRON POST | IS | 1426499340000 | EVELYN WAY | 1 - 99 EVELYN WAY | 1 - 99 EVELYN WAY | 1 EVELYN WAY | - | JUANITA WAY | JUANITA WAY |
| 102743 | N/A | Point | - | - | - | - | S282377 | MARKET ST: BUCHANAN ST \ DUBOC | - | T | T | - | F | 30758000 | 30758000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | DUBOCE AVE \ MARKET ST | BUCHANAN ST \ DUBOCE AVE | 106960 | 106960 | 37.7696026 | -122.42630944 | BUCHANAN ST \ DUBOCE AVE \ MARKET ST | MARKET ST \ BUCHANAN ST \ DUBOCE AVE | 1729216070000 | middleware_editor | SPEED LIMIT 20 | BUCHANAN ST \ DUBOCE AVE intersection | - | - | - | - | - | - | - | 120031 | 1650499200000 | -122.42630944 | 37.7696026 | - | - | - | D8 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP2 | OVERHEAD MAST ARM | IS | 1650535320000 | MARKET ST | - | - | - | - | - | - |
| 102744 | N/A | Point | - | - | - | - | S205348 | BUCHANAN ST: DUBOCE AVE \ MARK | - | F | F | - | F | 30758000 | 30758000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | DUBOCE AVE \ MARKET ST | BUCHANAN ST \ DUBOCE AVE | 46051 | 46051 | 37.7696026 | -122.42630944 | BUCHANAN ST \ DUBOCE AVE \ MARKET ST | MARKET ST \ BUCHANAN ST \ DUBOCE AVE | 1729185745000 | middleware_editor | RAILROAD TRACK ADVANCE WARNING CROSS BUCK (SYM) | BUCHANAN ST \ DUBOCE AVE intersection | - | FACING NORTEAST OF ENTRY OF DUBOCE BIKE | - | - | - | - | - | 120032 | 1399911360000 | -122.42630944 | 37.7696026 | - | 1399852800000 | - | D8 | - | OTHER WARNING | WARNING | W47(CA).0001 | 24X24 | SUP2 | LIGHT POLE | IS | 1398934140000 | MARKET ST | - | - | - | - | - | - |
| 102745 | N/A | Point | - | - | - | - | S216067 | LINCOLN WAY: 29TH AVE | - | F | F | - | F | 8367101 | 27440000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 29TH AVE | LINCOLN WAY | 54266 | 54266 | 37.76497079 | -122.48796743 | - | 29TH AVE \ LINCOLN WAY | 1710539427000 | MTA | YIELD HERE TO PED (SYM) (LA) | LINCOLN WAY intersection | - | 15`WEST | - | - | - | - | - | 120033 | - | -122.48796743 | 37.76497079 | - | - | - | D4 | - | PEDESTRIAN | REG | R1-5.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1431512760000 | 29TH AVE | 2801 - 2899 LINCOLN WAY | - | - | - | 30TH AVE | - |
| 102746 | N/A | Point | - | - | - | - | S217235 | 29TH AVE: LINCOLN WAY | - | F | F | - | F | 1614000 | 27440000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 54982 | 54982 | 37.76497079 | -122.48796743 | - | 29TH AVE \ LINCOLN WAY | 1710539427000 | MTA | SPEED HUMPS | LINCOLN WAY intersection | - | SPL# 1201 | - | - | - | - | - | 120034 | 1435663740000 | -122.48796743 | 37.76497079 | - | 1435622400000 | - | D4 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1434711180000 | 29TH AVE | 1200 - 1299 29TH AVE | - | - | - | IRVING ST | - |
| 102747 | N/A | Point | - | - | - | - | 25022 | - | - | - | T | - | - | 25975000 | - | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | 1698790560000 | evillan | - | - | SANCHEZ ST | - | 166162 | 166162 | 37.7660907079261 | -122.43113301113 | 15TH ST \ SANCHEZ ST | - | 1713923180000 | middleware_editor | REMOVE (SF BIKE ROUTE) GREEN (SYM) # | - | - | - | - | - | - | - | - | 120035 | - | - | - | - | - | - | 08 | - | BIKE REG | REG | R(SF).0388 | 12X24 | SUP3 | LIGHT POLE | PI | - | 15TH ST | - | - | - | - | - | - |
| 102748 | N/A | Point | - | - | - | - | 25023 | - | - | - | T | - | - | 25975000 | - | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | 1698790596000 | evillan | - | - | SANCHEZ ST | - | 166163 | 166163 | 37.766080106258 | -122.431132340578 | 15TH ST \ SANCHEZ ST | - | 1713923177000 | middleware_editor | REMOVE (SF BIKE ROUTE) GREEN (SYM) # | - | - | - | - | - | - | - | - | 120036 | - | - | - | - | - | - | 08 | - | BIKE REG | REG | R(SF).0388 | 12X24 | SUP3 | LIGHT POLE | PI | - | 15TH ST | - | - | - | - | - | - |
| 102749 | N/A | Point | - | - | - | - | S217236 | 29TH AVE: LINCOLN WAY | - | F | F | - | F | 1614000 | 27440000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | LINCOLN WAY | LINCOLN WAY | 124077 | 124077 | 37.76497079 | -122.48796743 | - | 29TH AVE \ LINCOLN WAY | 1710539427000 | MTA | SPEED HUMPS | LINCOLN WAY intersection | - | NPL# 1288 | - | - | - | - | - | 120037 | 1435663860000 | -122.48796743 | 37.76497079 | - | 1435622400000 | - | D4 | - | OTHER WARNING | WARNING | W17-1A.0001 | 30X30 | SUP2 | 2IN IRON POST | IS | 1434711600000 | 29TH AVE | 1200 - 1299 29TH AVE | - | - | - | IRVING ST | - |
| 102750 | N/A | Point | - | - | - | - | S288354 | MARKET ST: CHURCH ST | - | F | F | - | T | 8764201 | 25881000 | - | - | CENTER ISLAND, W LINE, WESTBOUND | - | - | - | - | CHURCH ST | CHURCH ST | 95864 | 95864 | 37.76750446 | -122.42894857 | - | MARKET ST \ CHURCH ST | 1730150804000 | middleware_editor | TYPE Q DELINEATOR (W) | CHURCH ST intersection | - | 2 TYPE Q ' S | - | - | - | - | - | 120038 | 1729867440000 | -122.42894857 | 37.76750446 | - | - | - | D8 | - | DELINEATOR 5 | WARNING | TYPE-DL.0004 | 03X36 | SUP2 | STANDARD BASE | IS | 1680517080000 | MARKET ST | 2100 - 2194 MARKET ST | - | - | - | 15TH 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.