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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 49276 | N/A | Point | 1 | 1 | 500 - 699 | - | S261145 | 500-699 PENNSYLVANIA AVE | 500-699 PENNSYLVANIA AVE | F | F | - | F | 10335000 | 10335000 | - | - | WEST SIDE | - | - | - | - | 20TH ST | 20TH ST | 98117 | 98117 | 37.75892636 | -122.39324368 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM MON STCL | 20TH ST to 22ND ST (500 - 699) | - | SPL 670 | - | - | - | - | - | 66377 | 1000512000000 | -122.39324368 | 37.75892636 | - | 1593993600000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0261 | 18X18 | SUP1 | LIGHT POLE | IS | 1580981460000 | PENNSYLVANIA AVE | 500 - 699 PENNSYLVANIA AVE | 500 - 699 PENNSYLVANIA AVE | 500 PENNSYLVANIA AVE | - | 22ND ST | 22ND ST |
| 49277 | N/A | Point | 1 | 1 | 500 - 699 | - | S261146 | 500-699 PENNSYLVANIA AVE | 500-699 PENNSYLVANIA AVE | F | F | - | F | 10335000 | 10335000 | - | - | WEST SIDE | - | - | - | - | 20TH ST | 20TH ST | 98118 | 98118 | 37.75892636 | -122.39324368 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES (SYM) | 20TH ST to 22ND ST (500 - 699) | - | SPL 670 | - | - | - | - | - | 66378 | 1000684800000 | -122.39324368 | 37.75892636 | - | - | - | D10 | - | PARKING:PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP1 | LIGHT POLE | IS | 1580981640000 | PENNSYLVANIA AVE | 500 - 699 PENNSYLVANIA AVE | 500 - 699 PENNSYLVANIA AVE | 500 PENNSYLVANIA AVE | - | 22ND ST | 22ND ST |
| 49278 | N/A | Point | 1 | 1 | 700 - 799 | - | S261183 | 700-799 TENNESSEE ST | 700-799 TENNESSEE ST | F | F | - | F | 12483000 | 12483000 | - | - | WEST SIDE | - | - | - | - | 18TH ST | 18TH ST | 98119 | 98119 | 37.76234838 | -122.38967027 | - | - | 1753472900000 | middleware_editor | NPRK 2AM-6AM WED STCL | 18TH ST to 19TH ST (700 - 799) | - | SPL 702 | - | - | - | - | - | 66379 | 1337238000000 | -122.38967027 | 37.76234838 | - | 1592982000000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0135 | 18X18 | SUP1 | 2IN IRON POST | IS | 1580995320000 | TENNESSEE ST | 700 - 799 TENNESSEE ST | 700 - 799 TENNESSEE ST | 700 TENNESSEE ST | - | 19TH ST | 19TH ST |
| 49279 | N/A | Point | - | - | - | - | S261894 | OAKDALE AVE: KEITH ST | - | T | T | - | F | 20156000 | 20156000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | OAKDALE AVE | KEITH ST | 98120 | 98120 | 37.73246639 | -122.3866187 | KEITH ST \ OAKDALE AVE | OAKDALE AVE \ KEITH ST | 1715873633000 | middleware_editor | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | KEITH ST intersection | 132571 | - | - | - | - | - | - | 66380 | 1317081600000 | -122.3866187 | 37.73246639 | - | - | - | D10 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP1 | LIGHT POLE | IS | 1582646220000 | OAKDALE AVE | - | - | - | - | - | - |
| 49280 | N/A | Point | 1 | 1 | 400 - 421 | - | S261977 | 400-421 FOLSOM ST | 400-421 FOLSOM ST | F | F | - | F | 5655000 | 5655000 | - | - | SOUTH SIDE | - | - | - | - | FREMONT ST | FREMONT ST | 98121 | 98121 | 37.78785231 | -122.39377954 | - | - | 1715264182000 | middleware_editor | TANSAT | FREMONT ST to GROTE PL (400 - 421) | - | 32' E OF 1ST ST | - | - | - | - | - | 66381 | 1583157480000 | -122.39377954 | 37.78785231 | - | - | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | LIGHT POLE | IS | 1582802460000 | FOLSOM ST | 400 - 421 FOLSOM ST | 400 - 421 FOLSOM ST | 400 FOLSOM ST | - | GROTE PL | GROTE PL |
| 49281 | N/A | Point | 1 | 1 | 1900 - 1999 | - | S287069 | 1900-1999 36TH AVE | 1900-1999 36TH AVE | F | F | - | F | 1809000 | 1809000 | - | - | EAST SIDE | - | - | - | - | ORTEGA ST | ORTEGA ST | 98510 | 98510 | 37.75063702 | -122.49449399 | - | - | 1717723862000 | middleware_editor | NPRK 9AM-11AM 1ST & 3RD MON OF MONTH STCL | ORTEGA ST to PACHECO ST (1900 - 1999) | - | #1966 36 TH AVE @ PAINT MARK. | - | - | - | - | - | 66382 | 1679961600000 | -122.49449399 | 37.75063702 | - | - | - | D4 | - | STREET CLEANING | REG | R30(CA).0036 | 18X18 | SUP2 | 2IN IRON POST | IS | 1673969460000 | 36TH AVE | 1900 - 1999 36TH AVE | 1900 - 1999 36TH AVE | 1900 36TH AVE | - | PACHECO ST | PACHECO ST |
| 49282 | N/A | Point | 1 | 1 | 1 - 99 | - | S287016 | 1-99 COLTON ST | 1-99 COLTON ST | F | F | - | F | 4283000 | 4283000 | - | - | SOUTH SIDE | - | - | - | - | COLUSA PL | COLUSA PL | 98513 | 98513 | 37.77307648 | -122.42014074 | - | - | 1710539427000 | MTA | TANP ANY TIME | COLUSA PL to BRADY ST (1 - 99) | - | 5' EAST OF BRADY ST | - | - | - | - | - | 66383 | 1674000000000 | -122.42014074 | 37.77307648 | - | - | - | D6 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP1 | LIGHT POLE | IS | 1673518260000 | COLTON ST | 1 - 99 COLTON ST | 1 - 99 COLTON ST | 1 COLTON ST | - | BRADY ST | BRADY ST |
| 49283 | N/A | Point | 1 | 1 | 1 - 99 | - | S287017 | 1-99 COLTON ST | 1-99 COLTON ST | F | F | - | F | 4283000 | 4283000 | - | - | SOUTH SIDE | - | - | - | - | COLUSA PL | COLUSA PL | 98514 | 98514 | 37.77307648 | -122.42014074 | - | - | 1710539427000 | MTA | TANP ANY TIME | COLUSA PL to BRADY ST (1 - 99) | - | 120' EAST OF BRADY ST | - | - | - | - | - | 66384 | 1674086400000 | -122.42014074 | 37.77307648 | - | - | - | D6 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP1 | 2IN IRON POST | IS | 1673518320000 | COLTON ST | 1 - 99 COLTON ST | 1 - 99 COLTON ST | 1 COLTON ST | - | BRADY ST | BRADY ST |
| 49284 | N/A | Point | 1 | 1 | 1 - 99 | - | S287018 | 1-99 COLTON ST | 1-99 COLTON ST | F | F | - | F | 4283000 | 4283000 | - | - | NORTH SIDE | - | - | - | - | COLUSA PL | COLUSA PL | 98515 | 98515 | 37.77307648 | -122.42014074 | - | - | 1710539427000 | MTA | TANP ANY TIME | COLUSA PL to BRADY ST (1 - 99) | - | 20' EAST OF BRADY ST | - | - | - | - | - | 66385 | 1674000000000 | -122.42014074 | 37.77307648 | - | - | - | D6 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP1 | LIGHT POLE | IS | 1673518380000 | COLTON ST | 1 - 99 COLTON ST | 1 - 99 COLTON ST | 1 COLTON ST | - | BRADY ST | BRADY ST |
| 49285 | N/A | Point | 1 | 1 | 1 - 99 | - | S287019 | 1-99 COLTON ST | 1-99 COLTON ST | F | F | - | F | 4283000 | 4283000 | - | - | NORTH SIDE | - | - | - | - | COLUSA PL | COLUSA PL | 98516 | 98516 | 37.77307648 | -122.42014074 | - | - | 1710539427000 | MTA | TANP ANY TIME | COLUSA PL to BRADY ST (1 - 99) | - | 115' EAST OF BRADY ST | - | - | - | - | - | 66386 | 1674000000000 | -122.42014074 | 37.77307648 | - | - | - | D6 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP1 | LIGHT POLE | IS | 1673518440000 | COLTON ST | 1 - 99 COLTON ST | 1 - 99 COLTON ST | 1 COLTON ST | - | BRADY ST | BRADY ST |
| 49286 | N/A | Point | 1 | 1 | 1 - 99 | - | S287021 | 1-99 COLUSA PL | 1-99 COLUSA PL | F | F | - | F | 4309000 | 4309000 | - | - | EAST SIDE | - | - | - | - | COLTON ST | COLTON ST | 98517 | 98517 | 37.77317198 | -122.41974413 | - | - | 1710539427000 | MTA | TANP ANY TIME | COLTON ST to CHASE CT (1 - 99) | - | 10' SOUTH OF COLTON ST/ NEXT TO BUILDING | - | - | - | - | - | 66387 | 1674086400000 | -122.41974413 | 37.77317198 | - | - | - | D6 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP1 | 2IN IRON POST | IS | 1673520360000 | COLUSA PL | 1 - 99 COLUSA PL | 1 - 99 COLUSA PL | 1 COLUSA PL | - | CHASE CT | CHASE CT |
| 49287 | N/A | Point | 1 | 1 | 1 - 99 | - | S287022 | 1-99 COLUSA PL | 1-99 COLUSA PL | F | F | - | F | 4309000 | 4309000 | - | - | EAST SIDE | - | - | - | - | COLTON ST | COLTON ST | 98518 | 98518 | 37.77317198 | -122.41974413 | - | - | 1710539427000 | MTA | TANP ANY TIME | COLTON ST to CHASE CT (1 - 99) | - | 10' NORTH OF CHASE CT. | - | - | - | - | - | 66388 | 1674000000000 | -122.41974413 | 37.77317198 | - | - | - | D6 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP1 | LIGHT POLE | IS | 1673520360000 | COLUSA PL | 1 - 99 COLUSA PL | 1 - 99 COLUSA PL | 1 COLUSA PL | - | CHASE CT | CHASE CT |
| 49288 | N/A | Point | 1 | 1 | 1 - 99 | - | S287023 | 1-99 COLUSA PL | 1-99 COLUSA PL | F | F | - | F | 4309000 | 4309000 | - | - | WEST SIDE | - | - | - | - | COLTON ST | COLTON ST | 98519 | 98519 | 37.77317198 | -122.41974413 | - | - | 1710539427000 | MTA | TANP ANY TIME | COLTON ST to CHASE CT (1 - 99) | - | 40' SOUTH OF COLTON ST | - | - | - | - | - | 66389 | 1674086400000 | -122.41974413 | 37.77317198 | - | - | - | D6 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP1 | 2IN IRON POST | IS | 1673520420000 | COLUSA PL | 1 - 99 COLUSA PL | 1 - 99 COLUSA PL | 1 COLUSA PL | - | CHASE CT | CHASE CT |
| 49289 | N/A | Point | - | - | - | - | S287025 | BAY ST: KEARNY ST | - | T | T | - | F | 25384000 | 25384000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BAY ST | BAY ST | 98520 | 98520 | 37.80642781 | -122.40714628 | KEARNY ST \ BAY ST | KEARNY ST \ BAY ST | 1753209570000 | middleware_editor | SPEED LIMIT 25 | BAY ST intersection | - | ABOVE SIGNALS | - | - | - | - | - | 66390 | 1673942400000 | -122.40714628 | 37.80642781 | - | - | - | D3 | - | SPEED LIMIT | REG | R2-1.0017 | 30X42 | SUP1 | LIGHT POLE | IS | 1673521800000 | KEARNY ST | - | - | - | - | - | - |
| 49290 | N/A | Point | - | - | - | - | S287027 | BAY ST: STOCKTON ST | - | T | T | - | F | 25410000 | 25410000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | STOCKTON ST | BAY ST | 98521 | 98521 | 37.80602772 | -122.41031084 | BAY ST \ STOCKTON ST | STOCKTON ST \ BAY ST | 1753207451000 | middleware_editor | SPEED LIMIT 25 | BAY ST intersection | - | ABOVE SIGNALS | - | - | - | - | - | 66391 | 1673942400000 | -122.41031084 | 37.80602772 | - | - | - | D3 | - | SPEED LIMIT | REG | R2-1.0017 | 30X42 | SUP1 | SIGNAL POLE | IS | 1673522340000 | STOCKTON ST | - | - | - | - | - | - |
| 49291 | N/A | Point | - | - | - | - | S273392 | 25TH ST: CONNECTICUT ST | - | F | F | - | F | 23634000 | 23634000 | - | - | SOUTH EAST CORNER | - | - | - | - | CONNECTICUT ST | 25TH ST | 98522 | 98522 | 37.75231076 | -122.3965135 | 25TH ST \ CONNECTICUT ST | CONNECTICUT ST \ 25TH ST | 1710539427000 | MTA | CONNECTICUT ST | 25TH ST intersection | - | 1800<---[] | - | - | - | - | - | 66392 | 1619395200000 | -122.3965135 | 37.75231076 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.0431 | 36X08 | SUP1 | LIGHT POLE | IS | 1616405820000 | CONNECTICUT ST | - | - | - | - | - | - |
| 49292 | N/A | Point | - | - | - | - | S273394 | 25TH ST: CONNECTICUT ST | - | F | F | - | F | 23634000 | 23634000 | - | - | SOUTH EAST CORNER | - | - | - | - | CONNECTICUT ST | 25TH ST | 98523 | 98523 | 37.75231076 | -122.3965135 | 25TH ST \ CONNECTICUT ST | CONNECTICUT ST \ 25TH ST | 1710539427000 | MTA | 25TH ST | 25TH ST intersection | - | 1100<---[] | - | - | - | - | - | 66393 | 1619395200000 | -122.3965135 | 37.75231076 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.0019 | 36X08 | SUP1 | LIGHT POLE | IS | 1616405880000 | CONNECTICUT ST | - | - | - | - | - | - |
| 49293 | N/A | Point | - | - | - | - | S273395 | 8TH ST: IRWIN ST \ WISCONSIN S | - | F | F | - | F | 23844000 | 23844000 | - | - | NORTH WEST CORNER | - | - | - | - | 8TH ST \ IRWIN ST | 08TH ST \ WISCONSIN ST | 98524 | 98524 | 37.76669544 | -122.39967764 | WISCONSIN ST \ 8TH ST \ IRWIN ST | IRWIN ST \ 08TH ST \ WISCONSIN ST | 1753725666000 | middleware_editor | WISCONSIN ST | 08TH ST \ WISCONSIN ST intersection | - | 000 | - | - | - | - | - | 66394 | 1619479500000 | -122.39967764 | 37.76669544 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.1884 | 36X08 | SUP1 | 3IN IRON POST | IS | 1616406360000 | IRWIN ST | - | - | - | - | - | - |
| 49294 | N/A | Point | - | - | - | - | S273396 | 8TH ST: IRWIN ST \ WISCONSIN S | - | F | F | - | F | 23844000 | 23844000 | - | - | NORTH WEST CORNER | - | - | - | - | 8TH ST \ IRWIN ST | 08TH ST \ WISCONSIN ST | 98525 | 98525 | 37.76669544 | -122.39967764 | WISCONSIN ST \ 8TH ST \ IRWIN ST | IRWIN ST \ 08TH ST \ WISCONSIN ST | 1753725670000 | middleware_editor | 8TH ST | 08TH ST \ WISCONSIN ST intersection | - | 1200 | - | - | - | - | - | 66395 | 1619468700000 | -122.39967764 | 37.76669544 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.0047 | 36X08 | SUP1 | 3IN IRON POST | IS | 1616406420000 | IRWIN ST | - | - | - | - | - | - |
| 49295 | N/A | Point | - | - | - | - | S273397 | IRWIN ST: 8TH ST \ WISCONSIN S | - | F | F | - | F | 23844000 | 23844000 | - | - | NORTH EAST CORNER | - | - | - | - | 8TH ST \ IRWIN ST | 08TH ST \ WISCONSIN ST | 98526 | 98526 | 37.76669544 | -122.39967764 | WISCONSIN ST \ 8TH ST \ IRWIN ST | IRWIN ST \ 08TH ST \ WISCONSIN ST | 1753725567000 | middleware_editor | 8TH ST | 08TH ST \ WISCONSIN ST intersection | - | X-STREET IS 8TH ST/WISCONSIN ST---1200 | - | - | - | - | - | 66396 | 1619463300000 | -122.39967764 | 37.76669544 | - | - | - | D10 | - | STREET NAME | GUIDE | D3-1.0047 | 36X08 | SUP1 | 3IN IRON POST | IS | 1616406840000 | IRWIN ST | - | - | - | - | - | - |
| 49296 | N/A | Point | 1 | 1 | 1300 - 1399 | RIGHT ARROW | S273403 | 1300-1399 VAN DYKE AVE | 1300-1399 VAN DYKE AVE | F | F | - | F | 13139000 | 13139000 | - | - | SOUTH SIDE | - | - | - | - | INGALLS ST | INGALLS ST | 98527 | 98527 | 37.72651491 | -122.38773646 | - | - | 1725398912000 | middleware_editor | TANS EXC 30 MIN COMMERCIAL VEH 9AM-6PM MON-FRI | INGALLS ST to JENNINGS ST (1300 - 1399) | - | 54' EAST OF WPL# 1375 VAN DYKE | - | - | - | - | - | 66397 | 1619183820000 | -122.38773646 | 37.72651491 | - | - | - | D10 | - | OTHER REGULATORY | REG | R37(SF).0191 | 18X21 | SUP1 | 2IN IRON POST | IS | 1616410260000 | VAN DYKE AVE | 1300 - 1399 VAN DYKE AVE | 1300 - 1399 VAN DYKE AVE | 1300 VAN DYKE AVE | - | JENNINGS ST | JENNINGS ST |
| 49297 | N/A | Point | 1 | 1 | 400 - 599 | - | S273421 | 400-599 ILLINOIS ST | 400-599 ILLINOIS ST | F | F | - | F | 7165000 | 7165000 | - | - | WEST SIDE | - | - | - | - | 16TH ST | 16TH ST | 98528 | 98528 | 37.76566865 | -122.38804047 | - | - | 1710539427000 | MTA | TA (SYM) NO STOPPING 12MID- 6AM DAILY | 16TH ST to MARIPOSA ST \ TERRY A FRANCOIS BLVD (400 - 599) | - | 55' SOUTH OF 16TH ST. | - | - | - | - | - | 66398 | 1618839540000 | -122.38804047 | 37.76566865 | - | - | - | D6 | - | OTHER REGULATORY | REG | R37(CA).0109 | 18X21 | SUP1 | 2IN IRON POST | IS | 1616423160000 | ILLINOIS ST | 400 - 599 ILLINOIS ST | 400 - 599 ILLINOIS ST | 400 ILLINOIS ST | - | MARIPOSA ST \ TERRY A FRANCOIS BLVD | MARIPOSA ST \ TERRY A FRANCOIS BLVD |
| 49298 | N/A | Point | - | - | - | - | S285227 | 3RD ST: LE CONTE AVE | - | F | F | - | T | 20467000 | 20467000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | LE CONTE AVE | 03RD ST | 100454 | 100454 | 37.71883436 | -122.39747874 | 3RD ST \ LE CONTE AVE | LE CONTE AVE \ 03RD ST | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | 03RD ST intersection | - | - | - | - | - | - | - | 66399 | 1512432000000 | -122.39747874 | 37.71883436 | - | 1512432000000 | - | D10 | - | NO LEFT TURN | REG | R3-18.0001 | 24X24 | SUP1 | SIGNAL POLE | IS | 1663942980000 | LE CONTE AVE | - | - | - | - | - | - |
| 49299 | N/A | Point | - | - | - | - | S285228 | 3RD ST: LE CONTE AVE | - | F | F | - | T | 20467000 | 20467000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | LE CONTE AVE | 03RD ST | 100455 | 100455 | 37.71883436 | -122.39747874 | 3RD ST \ LE CONTE AVE | LE CONTE AVE \ 03RD ST | 1710539427000 | MTA | DO NOT ENTER EXC MUNI | 03RD ST intersection | - | NORTH LINE | - | - | - | - | - | 66400 | 1144108800000 | -122.39747874 | 37.71883436 | - | 1663977600000 | - | D10 | - | OTHER REGULATORY | REG | R5-1(SF).0007 | 18X24 | SUP1 | SIGNAL POLE | IS | 1663943280000 | LE CONTE AVE | - | - | - | - | - | - |
| 49300 | N/A | Point | - | - | - | - | S285229 | 3RD ST: LE CONTE AVE | - | F | F | - | T | 20467000 | 20467000 | - | - | CENTER ISLAND, S LINE, SOUTHBOUND | - | - | - | - | LE CONTE AVE | 03RD ST | 100456 | 100456 | 37.71883436 | -122.39747874 | 3RD ST \ LE CONTE AVE | LE CONTE AVE \ 03RD ST | 1710539427000 | MTA | DO NOT ENTER EXC MUNI | 03RD ST intersection | - | NORTH LINE | - | - | - | - | - | 66401 | 1144108800000 | -122.39747874 | 37.71883436 | - | 1663977600000 | - | D10 | - | OTHER REGULATORY | REG | R5-1(SF).0007 | 18X24 | SUP1 | SIGNAL POLE | IS | 1663943400000 | LE CONTE AVE | - | - | - | - | - | - |
| 49301 | N/A | Point | - | - | - | - | S285327 | PALO ALTO AVE: CLARENDON AVE | - | F | F | - | F | 26250000 | 26250000 | - | - | SOUTH EAST CORNER | - | - | - | - | CLARENDON AVE | CLARENDON AVE | 100457 | 100457 | 37.75746785 | -122.45376946 | PALO ALTO AVE \ CLARENDON AVE | CLARENDON AVE intersection | 1712365361000 | middleware_editor | PALO ALTO AVE | CLARENDON AVE intersection | - | END | - | - | - | - | - | 66402 | - | -122.45376946 | 37.75746785 | - | - | - | D7 | - | STREET NAME | GUIDE | D3-1.1340 | 36X08 | SUP2 | 3IN IRON POST | IS | 1664793600000 | PALO ALTO AVE | - | - | - | - | - | - |
| 49302 | N/A | Point | 1 | 1 | 471 - 499 | - | S266480 | 471-499 44TH AVE | 471-499 44TH AVE | F | F | - | F | 1970000 | 1971000 | - | - | WEST SIDE | - | - | - | - | CLEMENT ST | POINT LOBOS AVE | 100458 | 100458 | 37.7801703177015 | -122.505235159437 | - | - | 1736960662000 | middleware_editor | NPRK 1PM-3PM 2ND & 4TH WED OF MONTH STCL | POINT LOBOS AVE to GEARY BLVD (471 - 499) | - | NPL #453-455 | - | - | - | - | - | 66403 | 1221091200000 | -122.50511232 | 37.77947987 | - | - | - | D1 | - | STREET CLEANING | REG | R30B(CA).0102 | 18X18 | SUP2 | 2IN IRON POST | IS | 1595424660000 | 44TH AVE | 400 - 470 44TH AVE | 471 - 499 44TH AVE | 471 44TH AVE | - | POINT LOBOS AVE | GEARY BLVD |
| 49303 | N/A | Point | - | - | - | - | S266561 | LARKIN ST: UNION ST | - | F | F | - | F | 25549000 | 25549000 | - | - | NORTH WEST CORNER | - | - | - | - | UNION ST | UNION ST | 100459 | 100459 | 37.79897106 | -122.4206888 | LARKIN ST \ UNION ST | LARKIN ST \ UNION ST | 1710539427000 | MTA | LARKIN ST | UNION ST intersection | - | 2300 II --> N | - | - | - | - | - | 66404 | 1600260900000 | -122.4206888 | 37.79897106 | - | - | - | D2 | - | STREET NAME | GUIDE | D3-1.1013 | 36X08 | SUP1 | LIGHT POLE | IS | 1595844600000 | LARKIN ST | - | - | - | - | - | - |
| 49304 | N/A | Point | - | - | - | - | S266562 | UNION ST: LARKIN ST | - | F | F | - | F | 25549000 | 25549000 | - | - | NORTH WEST CORNER | - | - | - | - | UNION ST | UNION ST | 100460 | 100460 | 37.79897106 | -122.4206888 | LARKIN ST \ UNION ST | LARKIN ST \ UNION ST | 1710539427000 | MTA | UNION ST | UNION ST intersection | - | 1300 II <-- W | - | - | - | - | - | 66405 | 1600262400000 | -122.4206888 | 37.79897106 | - | - | - | D2 | - | STREET NAME | GUIDE | D3-1.1765 | 36X08 | SUP1 | LIGHT POLE | IS | 1595844900000 | LARKIN ST | - | - | - | - | - | - |
| 49305 | N/A | Point | - | - | - | - | S285981 | BATTERY ST: PINE ST | - | T | T | - | F | 24671000 | 24671000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BATTERY ST | BATTERY ST | 100462 | 100462 | 37.79225795 | -122.39976335 | PINE ST \ BATTERY ST | PINE ST \ BATTERY ST | 1741981220000 | middleware_editor | DO NOT ENTER BIKE (SYM) OK | BATTERY ST intersection | - | - | - | - | - | - | - | 66406 | 1672128000000 | -122.39976335 | 37.79225795 | - | - | - | D3 | - | OTHER REGULATORY | REG | R5-1(SF).0019 | 24X30 | SUP1 | LIGHT POLE | IS | 1668597060000 | PINE ST | - | - | - | - | - | - |
| 49306 | N/A | Point | - | - | - | - | S285983 | BATTERY ST: CALIFORNIA ST | - | T | T | - | F | 24675000 | 24675000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | BATTERY ST | 100463 | 100463 | 37.7932091 | -122.39995874 | BATTERY ST \ CALIFORNIA ST | CALIFORNIA ST \ BATTERY ST | 1741979231000 | middleware_editor | DO NOT ENTER BIKE (SYM) OK | BATTERY ST intersection | - | - | - | - | - | - | - | 66407 | 1671523200000 | -122.39995874 | 37.7932091 | - | - | - | D3 | - | OTHER REGULATORY | REG | R5-1(SF).0019 | 24X30 | SUP1 | LIGHT POLE | IS | 1668597300000 | CALIFORNIA ST | - | - | - | - | - | - |
| 49307 | N/A | Point | - | - | - | - | S285986 | BATTERY ST: SACRAMENTO ST | - | T | T | - | F | 24692000 | 24692000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BATTERY ST | BATTERY ST | 100464 | 100464 | 37.79413424 | -122.40014878 | SACRAMENTO ST \ BATTERY ST | SACRAMENTO ST \ BATTERY ST | 1710771879000 | mmadsen | DO NOT ENTER BIKE (SYM) OK | BATTERY ST intersection | - | - | - | - | - | - | - | 66408 | 1671494400000 | -122.40014878 | 37.79413424 | - | - | - | D3 | - | OTHER REGULATORY | REG | R5-1(SF).0019 | 24X30 | SUP1 | LIGHT POLE | IS | 1668599460000 | SACRAMENTO ST | - | - | - | - | - | - |
| 49308 | N/A | Point | - | - | - | - | S285987 | BATTERY ST: CLAY ST | - | T | T | - | F | 24694000 | 24694000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BATTERY ST | BATTERY ST | 100465 | 100465 | 37.79501315 | -122.40032933 | CLAY ST \ BATTERY ST | CLAY ST \ BATTERY ST | 1741976815000 | middleware_editor | DO NOT ENTER BIKE (SYM) OK | BATTERY ST intersection | - | - | - | - | - | - | - | 66409 | 1671523200000 | -122.40032933 | 37.79501315 | - | - | - | D3 | - | OTHER REGULATORY | REG | R5-1(SF).0019 | 24X30 | SUP1 | LIGHT POLE | IS | 1668599700000 | CLAY ST | - | - | - | - | - | - |
| 49309 | N/A | Point | - | - | - | - | S285988 | BATTERY ST: WASHINGTON ST | - | T | T | - | F | 24695000 | 24695000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BATTERY ST | BATTERY ST | 100466 | 100466 | 37.795875 | -122.40048554 | WASHINGTON ST \ BATTERY ST | WASHINGTON ST \ BATTERY ST | 1741975809000 | middleware_editor | DO NOT ENTER BIKE (SYM) OK | BATTERY ST intersection | - | - | - | - | - | - | - | 66410 | 1671436800000 | -122.40048554 | 37.795875 | - | - | - | D3 | - | OTHER REGULATORY | REG | R5-1(SF).0019 | 24X30 | SUP1 | LIGHT POLE | IS | 1668599760000 | WASHINGTON ST | - | - | - | - | - | - |
| 49310 | N/A | Point | - | - | - | - | S285989 | BATTERY ST: JACKSON ST | - | T | T | - | F | 24696000 | 24696000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BATTERY ST | JACKSON ST | 100467 | 100467 | 37.79677684 | -122.40068134 | JACKSON ST \ BATTERY ST | BATTERY ST \ JACKSON ST | 1741975600000 | middleware_editor | DO NOT ENTER BIKE (SYM) OK | JACKSON ST intersection | - | - | - | - | - | - | - | 66411 | 1671436800000 | -122.40068134 | 37.79677684 | - | - | - | D3 | - | OTHER REGULATORY | REG | R5-1(SF).0019 | 24X30 | SUP1 | LIGHT POLE | IS | 1668599820000 | BATTERY ST | - | - | - | - | - | - |
| 49311 | N/A | Point | - | - | - | - | S285992 | BATTERY ST: PACIFIC AVE | - | T | T | - | F | 24707000 | 24707000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BATTERY ST | BATTERY ST | 100468 | 100468 | 37.79765414 | -122.40086318 | PACIFIC AVE \ BATTERY ST | PACIFIC AVE \ BATTERY ST | 1741974840000 | middleware_editor | DO NOT ENTER BIKE (SYM) OK | BATTERY ST intersection | - | - | - | - | - | - | - | 66412 | 1671436800000 | -122.40086318 | 37.79765414 | - | - | - | D3 | - | OTHER REGULATORY | REG | R5-1(SF).0019 | 24X30 | SUP1 | LIGHT POLE | IS | 1668601260000 | PACIFIC AVE | - | - | - | - | - | - |
| 49312 | N/A | Point | - | - | - | - | S285993 | BATTERY ST: BROADWAY | - | T | T | - | F | 30765000 | 30765000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BROADWAY | BROADWAY | 100469 | 100469 | 37.79858005 | -122.40105129 | BATTERY ST \ BROADWAY | BATTERY ST \ BROADWAY | 1741974379000 | middleware_editor | DO NOT ENTER BIKE (SYM) OK | BROADWAY intersection | - | - | - | - | - | - | - | 66413 | 1671436800000 | -122.40105129 | 37.79858005 | - | - | - | D3 | - | OTHER REGULATORY | REG | R5-1(SF).0019 | 24X30 | SUP1 | LIGHT POLE | IS | 1668601260000 | BATTERY ST | - | - | - | - | - | - |
| 49313 | N/A | Point | - | - | - | - | S267406 | 2ND ST: FOLSOM ST | - | F | F | - | F | 24519000 | 24519000 | - | - | SOUTH WEST CORNER | - | - | - | - | 2ND ST | FOLSOM ST | 101651 | 101651 | 37.78554213 | -122.39670518 | FOLSOM ST \ 2ND ST | 02ND ST \ FOLSOM ST | 1715209884000 | middleware_editor | FOLSOM ST | FOLSOM ST intersection | - | - | - | - | - | - | - | 66414 | 1606817100000 | -122.39670518 | 37.78554213 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.0676 | 36X08 | SUP1 | SIGNAL POLE | IS | 1598279460000 | 02ND ST | - | - | - | - | - | - |
| 49314 | N/A | Point | - | - | - | - | S267407 | FOLSOM ST: 2ND ST | - | F | F | - | F | 24519000 | 24519000 | - | - | SOUTH EAST CORNER | - | - | - | - | 2ND ST | FOLSOM ST | 101652 | 101652 | 37.78554213 | -122.39670518 | FOLSOM ST \ 2ND ST | 02ND ST \ FOLSOM ST | 1715209887000 | middleware_editor | 2ND ST | FOLSOM ST intersection | - | []--->300 | - | - | - | - | - | 66415 | 1606821900000 | -122.39670518 | 37.78554213 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.0024 | 36X08 | SUP1 | SIGNAL POLE | IS | 1598279460000 | 02ND ST | - | - | - | - | - | - |
| 49315 | N/A | Point | - | - | - | - | S267409 | FOLSOM ST: 2ND ST | - | T | T | - | F | 24519000 | 24519000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 2ND ST | FOLSOM ST | 101653 | 101653 | 37.78554213 | -122.39670518 | FOLSOM ST \ 2ND ST | 02ND ST \ FOLSOM ST | 1715209879000 | middleware_editor | 2ND ST | FOLSOM ST intersection | - | - | - | - | - | - | - | 66416 | 1610102580000 | -122.39670518 | 37.78554213 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-2.0039 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1598280180000 | 02ND ST | - | - | - | - | - | - |
| 49316 | N/A | Point | - | - | - | - | S286391 | UNION ST: LAGUNA ST | - | F | F | - | F | 26583000 | 26583000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | UNION ST | UNION ST | 101714 | 101714 | 37.79771621 | -122.43055896 | LAGUNA ST \ UNION ST | LAGUNA ST \ UNION ST | 1718759950000 | middleware_editor | SPEED LIMIT 20 | UNION ST intersection | - | - | - | - | - | - | - | 66417 | 1673913600000 | -122.43055896 | 37.79771621 | - | - | - | D2 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | 2IN IRON POST | IS | 1670407560000 | LAGUNA ST | - | - | - | - | - | - |
| 49317 | N/A | Point | 1 | 1 | 1900 - 1952 | - | S286392 | 1900-1952 UNION ST | 1900-1952 UNION ST | T | T | - | F | 12868000 | 12868000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | LAGUNA ST | LAGUNA ST | 101715 | 101715 | 37.79766034 | -122.43099824 | - | - | 1715112044000 | middleware_editor | SPEED LIMIT 20 | LAGUNA ST to CHARLTON CT (1900 - 1952) | - | IFO 1900 | - | - | - | - | - | 66418 | 1673568000000 | -122.43099824 | 37.79766034 | - | 1715086800000 | - | D2 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1670407680000 | UNION ST | 1900 - 1952 UNION ST | 1900 - 1952 UNION ST | 1900 UNION ST | - | CHARLTON CT | CHARLTON CT |
| 49318 | N/A | Point | - | - | - | - | S286394 | UNION ST: GOUGH ST | - | T | T | - | F | 26709000 | 26709000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | UNION ST | UNION ST | 101716 | 101716 | 37.79813458 | -122.42726898 | GOUGH ST \ UNION ST | GOUGH ST \ UNION ST | 1710539427000 | MTA | SPEED LIMIT 20 | UNION ST intersection | - | - | - | - | - | - | - | 66419 | 1673568000000 | -122.42726898 | 37.79813458 | - | - | - | D2 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1670408040000 | GOUGH ST | - | - | - | - | - | - |
| 49319 | N/A | Point | - | - | - | - | S286395 | UNION ST: GOUGH ST | - | T | T | - | F | 26709000 | 26709000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | UNION ST | UNION ST | 101717 | 101717 | 37.79813458 | -122.42726898 | GOUGH ST \ UNION ST | GOUGH ST \ UNION ST | 1710539427000 | MTA | SPEED LIMIT 20 | UNION ST intersection | - | - | - | - | - | - | - | 66420 | 1687305600000 | -122.42726898 | 37.79813458 | - | - | - | D2 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1670408100000 | GOUGH ST | - | - | - | - | - | - |
| 49320 | N/A | Point | - | - | - | - | S286396 | UNION ST: VAN NESS AVE | - | T | T | - | F | 26686000 | 26686000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | UNION ST | VAN NESS AVE | 101718 | 101718 | 37.79855245 | -122.42398215 | VAN NESS AVE \ UNION ST | UNION ST \ VAN NESS AVE | 1710539427000 | MTA | SPEED LIMIT 20 | VAN NESS AVE intersection | - | - | - | - | - | - | - | 66421 | 1673568000000 | -122.42398215 | 37.79855245 | - | - | - | D2 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | MUNI POLE | IS | 1670408280000 | UNION ST | - | - | - | - | - | - |
| 49321 | N/A | Point | - | - | - | - | S286398 | CHESTNUT ST: FILLMORE ST | - | T | T | - | F | 26763000 | 26763000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FILLMORE ST | CHESTNUT ST | 101719 | 101719 | 37.80081415 | -122.43627391 | CHESTNUT ST \ FILLMORE ST | FILLMORE ST \ CHESTNUT ST | 1735588718000 | middleware_editor | SPEED LIMIT 25 | CHESTNUT ST intersection | - | 5 FT WEST | - | - | - | - | - | 66422 | 1673481600000 | -122.43627391 | 37.80081415 | - | - | - | D2 | - | SPEED LIMIT | REG | R2-1.0005 | 24X30 | SUP1 | LIGHT POLE | IS | 1670409900000 | FILLMORE ST | - | - | - | - | - | - |
| 49322 | N/A | Point | - | - | - | - | S286400 | CHESTNUT ST: FILLMORE ST | - | T | T | - | F | 26763000 | 26763000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FILLMORE ST | CHESTNUT ST | 101720 | 101720 | 37.80081415 | -122.43627391 | CHESTNUT ST \ FILLMORE ST | FILLMORE ST \ CHESTNUT ST | 1735588711000 | middleware_editor | SPEED LIMIT 20 | CHESTNUT ST intersection | - | - | - | - | - | - | - | 66423 | 1673395200000 | -122.43627391 | 37.80081415 | - | - | - | D2 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1670410020000 | FILLMORE ST | - | - | - | - | - | - |
| 49323 | N/A | Point | 1 | 1 | 2100 - 2199 | - | S286402 | 2084-2199 CHESTNUT ST | 2100-2199 CHESTNUT ST | T | T | - | F | 3979000 | 3979000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | STEINER ST | STEINER ST | 101721 | 101721 | 37.80050609 | -122.43869681 | - | - | 1710539427000 | MTA | SPEED LIMIT 20 | STEINER ST to PIERCE ST (2100 - 2199) | - | IFO 2125 UNDER STOP AHEAD | - | - | - | - | - | 66424 | 1673481600000 | -122.43869681 | 37.80050609 | - | - | - | D2 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1670410860000 | CHESTNUT ST | 2100 - 2199 CHESTNUT ST | 2100 - 2199 CHESTNUT ST | 2100 CHESTNUT ST | - | PIERCE ST | PIERCE ST |
| 49324 | N/A | Point | 1 | 1 | 2250 - 2299 | - | S286403 | 2250-2299 CHESTNUT ST | 2250-2299 CHESTNUT ST | T | T | - | F | 3981000 | 3981000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | AVILA ST | AVILA ST | 101722 | 101722 | 37.8002456 | -122.44074349 | - | - | 1710539427000 | MTA | SPEED LIMIT 20 | AVILA ST to SCOTT ST (2250 - 2299) | - | IFO 2257 ABOVE SIGNS | - | - | - | - | - | 66425 | 1673481600000 | -122.44074349 | 37.8002456 | - | - | - | D2 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1670411280000 | CHESTNUT ST | 2250 - 2299 CHESTNUT ST | 2250 - 2299 CHESTNUT ST | 2250 CHESTNUT ST | - | SCOTT ST | SCOTT ST |
| 49325 | N/A | Point | 1 | 1 | 2250 - 2299 | - | S286404 | 2250-2299 CHESTNUT ST | 2250-2299 CHESTNUT ST | T | T | - | F | 3981000 | 3981000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | AVILA ST | AVILA ST | 101723 | 101723 | 37.8002456 | -122.44074349 | - | - | 1710539427000 | MTA | SPEED LIMIT 20 | AVILA ST to SCOTT ST (2250 - 2299) | - | IFO 2250 ABOVE TREE | - | - | - | - | - | 66426 | 1673395200000 | -122.44074349 | 37.8002456 | - | - | - | D2 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | LIGHT POLE | IS | 1670411400000 | CHESTNUT ST | 2250 - 2299 CHESTNUT ST | 2250 - 2299 CHESTNUT ST | 2250 CHESTNUT ST | - | SCOTT ST | SCOTT ST |
| 49326 | N/A | Point | 1 | 1 | 2300 - 2399 | - | S286405 | 2300-2399 CHESTNUT ST | 2300-2399 CHESTNUT ST | T | T | - | F | 3982000 | 3982000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SCOTT ST | SCOTT ST | 101724 | 101724 | 37.80008408 | -122.44201173 | - | - | 1710539427000 | MTA | SPEED LIMIT 20 | SCOTT ST to DIVISADERO ST (2300 - 2399) | - | EPL 2385 | - | - | - | - | - | 66427 | 1673481600000 | -122.44201173 | 37.80008408 | - | - | - | D2 | - | SPEED LIMIT | REG | R2-1.0004 | 24X30 | SUP1 | MUNI POLE | IS | 1670411640000 | CHESTNUT ST | 2300 - 2399 CHESTNUT ST | 2300 - 2399 CHESTNUT ST | 2300 CHESTNUT ST | - | DIVISADERO ST | DIVISADERO ST |
| 49327 | N/A | Point | 1 | 1 | 800 - 899 | - | S286423 | 800-899 BATTERY ST | 800-899 BATTERY ST | F | F | - | F | 2763000 | 2763000 | - | - | EAST SIDE | - | - | - | - | BROADWAY | BROADWAY | 101726 | 101726 | 37.79905575 | -122.40114577 | - | - | 1721158380000 | middleware_editor | BROADWAY | BROADWAY to VALLEJO ST (800 - 899) | - | 15' NORTH OF BROADWAY | - | - | - | - | - | 66428 | - | -122.40114577 | 37.79905575 | - | - | - | D3 | - | STREET NAME | GUIDE | D3-1.0258 | 36X08 | SUP1 | MUNI POLE | IS | 1670504880000 | BATTERY ST | 800 - 899 BATTERY ST | 800 - 899 BATTERY ST | 800 BATTERY ST | - | VALLEJO ST | VALLEJO ST |
| 49328 | N/A | Point | - | - | - | - | S286425 | BROADWAY: BATTERY ST | - | F | F | - | F | 30765000 | 30765000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BROADWAY | BROADWAY | 101727 | 101727 | 37.79858005 | -122.40105129 | BATTERY ST \ BROADWAY | BATTERY ST \ BROADWAY | 1741974374000 | middleware_editor | BATTERY ST | BROADWAY intersection | - | - | - | - | - | - | - | 66429 | - | -122.40105129 | 37.79858005 | - | 1670572800000 | - | D3 | - | STREET NAME | GUIDE | D3-1.0175 | 36X08 | SUP1 | SIGNAL POLE | IS | 1670505420000 | BATTERY ST | - | - | - | - | - | - |
| 49329 | N/A | Point | - | - | - | - | S289903 | AVENUE B: 12TH TI ST | - | F | F | - | F | 34099000 | 34099000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | AVENUE B | AVENUE B | 101728 | 101728 | 37.82544448 | -122.37619128 | 12TH TI ST \ AVENUE B | 12TH TI ST \ AVENUE B | 1710539427000 | MTA | 12TH ST | AVENUE B intersection | - | NEXT TO CITY VIEW STORAGE SIGN | - | - | - | - | - | 66430 | - | -122.37619128 | 37.82544448 | - | 1685664000000 | - | D6 | - | STREET NAME | GUIDE | D3-1.0002 | 36X08 | SUP1 | 3IN IRON POST | IS | 1685530680000 | 12TH TI ST | - | - | - | - | - | - |
| 49330 | N/A | Point | - | 1 | 400 - 499 | - | S285953 | 400-499 MIDDLE WEST DR (GGP) | 400-499 MIDDLE WEST DR | F | F | - | F | 9007000 | 9007000 | - | - | NORTH SIDE | - | - | - | - | METSON RD | METSON RD | 101729 | 101729 | 37.76607319 | -122.49575648 | - | - | 1710539427000 | MTA | TANP ANY TIME | METSON RD to MARTIN LUTHER KING JR DR (400 - 499) | - | PARKING AREA 50 FT WEST OF METSON | - | - | - | - | - | 66431 | 1668470400000 | -122.49575648 | 37.76607319 | - | - | - | D1 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0037 | 14X21 | SUP2 | 2IN IRON POST | IS | 1668509100000 | MIDDLE WEST DR | 400 - 499 MIDDLE WEST DR | 400 - 499 MIDDLE WEST DR | 400 MIDDLE WEST DR | - | MARTIN LUTHER KING JR DR | MARTIN LUTHER KING JR DR |
| 49331 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S288877 | 1500-1599 SANSOME ST | 1500-1599 SANSOME ST | F | F | - | F | 11561000 | 11561000 | - | - | WEST SIDE | - | - | - | - | LOMBARD ST | LOMBARD ST | 103074 | 103074 | 37.80460991 | -122.40344487 | - | - | 1710539427000 | MTA | BIKE RACK | LOMBARD ST to CHESTNUT ST \ THE EMBARCADERO (1500 - 1599) | - | 34'6" N OF LOMBARD/3' IN FROM CURB | - | - | - | - | - | 66432 | - | -122.40344487 | 37.80460991 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1682444100000 | SANSOME ST | 1500 - 1599 SANSOME ST | 1500 - 1599 SANSOME ST | 1500 SANSOME ST | - | CHESTNUT ST \ THE EMBARCADERO | CHESTNUT ST \ THE EMBARCADERO |
| 49332 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S288876 | 1500-1599 SANSOME ST | 1500-1599 SANSOME ST | F | F | - | F | 11561000 | 11561000 | - | - | WEST SIDE | - | - | - | - | LOMBARD ST | LOMBARD ST | 103075 | 103075 | 37.80460991 | -122.40344487 | - | - | 1710539427000 | MTA | BIKE RACK | LOMBARD ST to CHESTNUT ST \ THE EMBARCADERO (1500 - 1599) | - | 37'6" S OF CHESTNUT/3' IN FROM CURB | - | - | - | - | - | 66433 | - | -122.40344487 | 37.80460991 | - | - | - | D3 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1682443980000 | SANSOME ST | 1500 - 1599 SANSOME ST | 1500 - 1599 SANSOME ST | 1500 SANSOME ST | - | CHESTNUT ST \ THE EMBARCADERO | CHESTNUT ST \ THE EMBARCADERO |
| 49333 | N/A | Point | - | - | - | - | S288200 | MISSION ST: 14TH ST | - | T | T | - | F | 24372000 | 24372000 | - | - | SOUTH WEST CORNER | - | - | - | - | 14TH ST | 14TH ST | 103076 | 103076 | 37.76827365 | -122.41998151 | MISSION ST \ 14TH ST | MISSION ST \ 14TH ST | 1717723859000 | middleware_editor | 14TH ST | 14TH ST intersection | - | []300---> | - | - | - | - | - | 66434 | - | -122.41998151 | 37.76827365 | - | - | - | D9 | - | STREET NAME | GUIDE | D3-1.0004 | 36X08 | SUP2 | SIGNAL POLE | IS | 1679314800000 | MISSION ST | - | - | - | - | - | - |
| 49334 | N/A | Point | - | - | - | - | S288201 | MISSION ST: 14TH ST | - | T | T | - | F | 24372000 | 24372000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 14TH ST | 14TH ST | 103077 | 103077 | 37.76827365 | -122.41998151 | MISSION ST \ 14TH ST | MISSION ST \ 14TH ST | 1717723892000 | middleware_editor | ONE WAY (LA) | 14TH ST intersection | - | - | - | - | - | - | - | 66435 | - | -122.41998151 | 37.76827365 | - | 1679356800000 | - | D9 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | SIGNAL POLE | IS | 1679314800000 | MISSION ST | - | - | - | - | - | - |
| 49335 | N/A | Point | - | - | - | - | S289238 | LEAVENWORTH ST: GOLDEN GATE AV | - | F | F | - | F | 24334000 | 24334000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GOLDEN GATE AVE | GOLDEN GATE AVE | 103079 | 103079 | 37.78186334 | -122.4138656 | LEAVENWORTH ST \ GOLDEN GATE AVE | LEAVENWORTH ST \ GOLDEN GATE AVE | 1748360884000 | middleware_editor | 6AM-6PM EXCEPT LOADING AND EMERGENCY VEHICLES BIKE (SYM) OK | GOLDEN GATE AVE intersection | - | - | - | - | - | - | - | 66436 | 1554706800000 | -122.4138656 | 37.78186334 | - | 1587625200000 | - | D6 | - | OTHER REGULATORY | REG | R(SF).0491 | 30X30 | SUP1 | 2IN IRON POST | IS | 1683197100000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 49336 | N/A | Point | - | - | - | - | S289240 | GOLDEN GATE AVE: LEAVENWORTH S | - | T | T | - | F | 24334000 | 24334000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GOLDEN GATE AVE | GOLDEN GATE AVE | 103080 | 103080 | 37.78186334 | -122.4138656 | LEAVENWORTH ST \ GOLDEN GATE AVE | LEAVENWORTH ST \ GOLDEN GATE AVE | 1738695358000 | middleware_editor | 6AM-6PM EXCEPT LOADING AND EMERGENCY VEHICLES BIKE (SYM) OK | GOLDEN GATE AVE intersection | - | - | - | - | - | - | - | 66437 | 1115856000000 | -122.4138656 | 37.78186334 | - | 1587600000000 | - | D6 | - | OTHER REGULATORY | REG | R(SF).0491 | 30X30 | SUP1 | MUNI POLE | IS | 1683197280000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 49337 | N/A | Point | - | - | - | - | S289242 | GOLDEN GATE AVE: LEAVENWORTH S | - | F | F | - | F | 24334000 | 24334000 | - | - | CENTER ISLAND | - | - | - | - | GOLDEN GATE AVE | GOLDEN GATE AVE | 103081 | 103081 | 37.78186334 | -122.4138656 | LEAVENWORTH ST \ GOLDEN GATE AVE | LEAVENWORTH ST \ GOLDEN GATE AVE | 1748535120000 | middleware_editor | 6AM-6PM EXCEPT LOADING AND EMERGENCY VEHICLES BIKE (SYM) OK | GOLDEN GATE AVE intersection | - | MIDDLE OF STREET AT INTERSECTION | - | - | - | - | - | 66438 | 1115881200000 | -122.4138656 | 37.78186334 | - | 1587625200000 | 1748533500000 | D6 | - | OTHER REGULATORY | REG | R(SF).0491 | 30X30 | SUP1 | UNISTRUT | RETD | 1683197460000 | LEAVENWORTH ST | - | - | - | - | - | - |
| 49338 | N/A | Point | - | - | - | - | S289247 | LOMBARD ST: LAGUNA ST | - | T | T | - | F | 26722000 | 26722000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | LOMBARD ST | LAGUNA ST | 103084 | 103084 | 37.80046922 | -122.43111529 | LAGUNA ST \ LOMBARD ST | LOMBARD ST \ LAGUNA ST | 1710539427000 | MTA | EXC MUNI | LAGUNA ST intersection | - | BELOW NO LEFT TURN | - | - | - | - | - | 66439 | 1683244800000 | -122.43111529 | 37.80046922 | - | - | - | D2 | - | OTHER REGULATORY | REG | R(SF).0072 | 30X12 | SUP1 | LIGHT POLE | IS | 1683209640000 | LOMBARD ST | - | - | - | - | - | - |
| 49339 | N/A | Point | - | - | - | - | S289248 | LOMBARD ST: LAGUNA ST | - | T | T | - | F | 26722000 | 26722000 | - | - | CENTER ISLAND, E LINE, EASTBOUND | - | - | - | - | LOMBARD ST | LAGUNA ST | 103085 | 103085 | 37.80046922 | -122.43111529 | LAGUNA ST \ LOMBARD ST | LOMBARD ST \ LAGUNA ST | 1710539427000 | MTA | EXC MUNI | LAGUNA ST intersection | - | BELOW NO LEFT TURN | - | - | - | - | - | 66440 | 1683244800000 | -122.43111529 | 37.80046922 | - | - | - | D2 | - | OTHER REGULATORY | REG | R(SF).0072 | 30X12 | SUP1 | LIGHT POLE | IS | 1683210000000 | LOMBARD ST | - | - | - | - | - | - |
| 49340 | N/A | Point | - | - | - | - | S111045 | 3RD ST: ARTHUR AVE \ CARGO WAY | - | F | F | - | F | 20247000 | 20247000 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | - | - | - | - | 3RD ST \ CARGO WAY | ARTHUR AVE \ CARGO WAY | 103086 | 103086 | 37.74615713 | -122.38717422 | ARTHUR AVE \ 3RD ST \ CARGO WAY | 03RD ST \ ARTHUR AVE \ CARGO WAY | 1710539427000 | MTA | NO LEFT TURN (SYM) | ARTHUR AVE \ CARGO WAY intersection | - | N-LINE | - | - | - | - | - | 66441 | 740966400000 | -122.38717422 | 37.74615713 | - | - | - | D10 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1373571000000 | 03RD ST | - | - | - | - | - | - |
| 49341 | N/A | Point | - | - | - | - | S289264 | JORDAN AVE: EUCLID AVE | - | F | F | - | F | 27222000 | 27222000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | EUCLID AVE | EUCLID AVE | 103087 | 103087 | 37.78392891 | -122.45681322 | JORDAN AVE \ EUCLID AVE | JORDAN AVE \ EUCLID AVE | 1710539427000 | MTA | NO TRUCKS (SYM) OVER 3 TONS | EUCLID AVE intersection | - | . | - | - | - | - | - | 66442 | - | -122.45681322 | 37.78392891 | - | 1683244800000 | - | D2 | - | OTHER REGULATORY | REG | R5-2.0006 | 30X36 | SUP1 | LIGHT POLE | IS | 1683280560000 | JORDAN AVE | - | - | - | - | - | - |
| 49342 | N/A | Point | - | - | - | - | S288553 | DIVISADERO ST: PAGE ST | - | F | F | - | F | 26029000 | 26029000 | - | - | NORTH WEST CORNER | - | - | - | - | DIVISADERO ST | DIVISADERO ST | 103097 | 103097 | 37.77220371 | -122.43723493 | PAGE ST \ DIVISADERO ST | PAGE ST \ DIVISADERO ST | 1746654189000 | middleware_editor | FG 300 UR DELINEATOR (W) | DIVISADERO ST intersection | - | IN PSZ, NORTH OF S-LINE X-WALK | - | - | - | - | - | 66443 | 1683615600000 | -122.43723493 | 37.77220371 | - | 1746649800000 | - | D5 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1681724880000 | PAGE ST | - | - | - | - | - | - |
| 49343 | N/A | Point | - | - | - | - | S288559 | MASONIC AVE: PAGE ST | - | F | F | - | F | 26344000 | 26344000 | - | - | NORTH WEST CORNER | - | - | - | - | MASONIC AVE | MASONIC AVE | 103098 | 103098 | 37.77114193 | -122.44553528 | PAGE ST \ MASONIC AVE | PAGE ST \ MASONIC AVE | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | MASONIC AVE intersection | - | IN PSZ, SOUTH OF N-LINE X-WALK | - | - | - | - | - | 66444 | 1683676800000 | -122.44553528 | 37.77114193 | - | - | - | D5 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1681733880000 | PAGE ST | - | - | - | - | - | - |
| 49344 | N/A | Point | 1 | 1 | 471 - 499 | - | S287842 | 471-499 URBANO DR | 471-499 URBANO DR | F | F | - | F | 13029000 | 13029000 | - | - | NORTH SIDE | - | - | - | - | ALVISO ST | ALVISO ST | 103102 | 103102 | 37.72356637 | -122.46821067 | - | - | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | ALVISO ST to BORICA ST (471 - 499) | - | WPL 475 UNDER STREET NAMES | - | - | - | - | - | 66445 | - | -122.46821067 | 37.72356637 | - | 1681689600000 | - | D7 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP2 | LIGHT POLE | IS | 1678095000000 | URBANO DR | 471 - 499 URBANO DR | 471 - 499 URBANO DR | 471 URBANO DR | - | BORICA ST | BORICA ST |
| 49345 | N/A | Point | 1 | 1 | 3100 - 3199 | - | S258605 | 3100-3199 INGALLS ST | 3100-3199 INGALLS ST | F | F | - | F | 7241000 | 7241000 | - | - | WEST SIDE | - | - | - | - | HOLLISTER AVE | HOLLISTER AVE | 104530 | 104530 | 37.7194268 | -122.39269989 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM MON/4AM-6AM FRI STCL | HOLLISTER AVE to INGERSON AVE (3100 - 3199) | - | 3' SOUTH OF HOLLISTER AVE. | - | - | - | - | - | 66446 | 1546992000000 | -122.39269989 | 37.7194268 | - | 1578873600000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0330 | 18X18 | SUP1 | 2IN IRON POST | IS | 1571841060000 | INGALLS ST | 3100 - 3199 INGALLS ST | 3100 - 3199 INGALLS ST | 3100 INGALLS ST | - | INGERSON AVE | INGERSON AVE |
| 49346 | N/A | Point | 1 | 1 | 3100 - 3199 | - | S258606 | 3100-3199 INGALLS ST | 3100-3199 INGALLS ST | F | F | - | F | 7241000 | 7241000 | - | - | WEST SIDE | - | - | - | - | HOLLISTER AVE | HOLLISTER AVE | 104531 | 104531 | 37.7194268 | -122.39269989 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM MON/4AM-6AM FRI STCL | HOLLISTER AVE to INGERSON AVE (3100 - 3199) | - | 60' NORTH OF INGERSON AVE. | - | - | - | - | - | 66447 | 1546992000000 | -122.39269989 | 37.7194268 | - | 1578873600000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0330 | 18X18 | SUP1 | 2IN IRON POST | IS | 1571841120000 | INGALLS ST | 3100 - 3199 INGALLS ST | 3100 - 3199 INGALLS ST | 3100 INGALLS ST | - | INGERSON AVE | INGERSON AVE |
| 49347 | N/A | Point | 1 | 1 | 3100 - 3199 | - | S258607 | 3100-3199 INGALLS ST | 3100-3199 INGALLS ST | F | F | - | F | 7241000 | 7241000 | - | - | EAST SIDE | - | - | - | - | HOLLISTER AVE | HOLLISTER AVE | 104532 | 104532 | 37.7194268 | -122.39269989 | - | - | 1710539427000 | MTA | NPRK 4AM-6AM MON/9AM-11AM WED STCL | HOLLISTER AVE to INGERSON AVE (3100 - 3199) | - | 75' NORTH OF INGERSON AVE. | - | - | - | - | - | 66448 | 1578647760000 | -122.39269989 | 37.7194268 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0331 | 18X18 | SUP1 | 2IN IRON POST | IS | 1571841180000 | INGALLS ST | 3100 - 3199 INGALLS ST | 3100 - 3199 INGALLS ST | 3100 INGALLS ST | - | INGERSON AVE | INGERSON AVE |
| 49348 | N/A | Point | 1 | 1 | 3200 - 3299 | - | S258610 | 3200-3299 INGALLS ST | 3200-3299 INGALLS ST | F | F | - | F | 7242000 | 7242000 | - | - | WEST SIDE | - | - | - | - | INGERSON AVE | INGERSON AVE | 104533 | 104533 | 37.7188005 | -122.39326317 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM MON/4AM-6AM FRI STCL | INGERSON AVE to JAMESTOWN AVE (3200 - 3299) | - | NPL #3224 | - | - | - | - | - | 66449 | 1546992000000 | -122.39326317 | 37.7188005 | - | 1581033600000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0330 | 18X18 | SUP1 | 2IN IRON POST | IS | 1571842500000 | INGALLS ST | 3200 - 3299 INGALLS ST | 3200 - 3299 INGALLS ST | 3200 INGALLS ST | - | JAMESTOWN AVE | JAMESTOWN AVE |
| 49349 | N/A | Point | - | - | - | - | S137314 | DUBLIN ST: PERSIA AVE | - | F | F | - | F | 21608000 | 21608000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PERSIA AVE | DUBLIN ST | 104534 | 104534 | 37.71856073 | -122.42639027 | DUBLIN ST \ PERSIA AVE | PERSIA AVE \ DUBLIN ST | 1720634608000 | middleware_editor | ALL WAY | DUBLIN ST intersection | - | - | - | - | - | - | - | 66450 | 1348099200000 | -122.42639027 | 37.71856073 | - | 1571875200000 | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373579220000 | PERSIA AVE | - | - | - | - | - | - |
| 49350 | N/A | Point | - | - | - | - | S265349 | LEAVENWORTH ST: OFARRELL ST | - | T | T | - | F | 25153000 | 25153000 | - | - | SOUTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LEAVENWORTH ST | OFARRELL ST | 104972 | 104972 | 37.78558248 | -122.41461721 | OFARRELL ST \ LEAVENWORTH ST | LEAVENWORTH ST \ OFARRELL ST | 1717635993000 | middleware_editor | OFARRELL ST | OFARRELL ST intersection | - | - | - | - | - | - | - | 66451 | - | -122.41461721 | 37.78558248 | - | - | - | D6 | - | STREET NAME | GUIDE | D3-1.1303 | 36X08 | SUP1 | LIGHT POLE | IS | 1592904960000 | LEAVENWORTH 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.