MTA.signshop_assets
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6376 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S211299 | 2000-2099 LOWER GREAT HWY | 2000-2099 GREAT HWY | F | F | - | F | 8516000 | 8516000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | PACHECO ST | PACHECO ST | 52991 | 52991 | 37.74817974 | -122.50781822 | - | - | 1713297791000 | middleware_editor | STOP | PACHECO ST to QUINTARA ST (2000 - 2099) | - | OPP.NE CORNOR | - | - | - | - | - | 23448 | - | -122.50781822 | 37.74817974 | - | - | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1417525740000 | GREAT HWY | 2000 - 2099 GREAT HWY | 2000 - 2099 GREAT HWY | 2000 GREAT HWY | - | QUINTARA ST | QUINTARA ST |
| 6377 | N/A | Point | 1 | 1 | 2900 - 2999 | - | S211319 | 2900-2999 TARAVAL ST | 2900-2999 TARAVAL ST | F | F | - | F | 12416000 | 12416000 | - | - | SOUTH SIDE | - | - | - | - | 39TH AVE | 39TH AVE | 52992 | 52992 | 37.74207994 | -122.49765296 | - | - | 1710539427000 | MTA | NPRK 7AM-8AM MON THUR STCL | 39TH AVE to 40TH AVE (2900 - 2999) | - | IFO 2921 | - | - | - | - | - | 23449 | 1418821560000 | -122.49765296 | 37.74207994 | - | 1418774400000 | - | D4 | - | STREET CLEANING | REG | R30B(CA).0212 | 18X18 | SUP2 | MUNI POLE | IS | 1417529460000 | TARAVAL ST | 2900 - 2999 TARAVAL ST | 2900 - 2999 TARAVAL ST | 2900 TARAVAL ST | - | 40TH AVE | 40TH AVE |
| 6378 | N/A | Point | 1 | 1 | 100 - 149 | - | S210241 | 100-149 SANCHEZ ST | 100-149 SANCHEZ ST | F | F | - | F | 11508000 | 11508000 | - | - | WEST SIDE | - | - | - | - | 14TH ST | 14TH ST | 52993 | 52993 | 37.76719572 | -122.4311528 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM THUR STCL | 14TH ST to HENRY ST (100 - 149) | - | IFO #106 | - | - | - | - | - | 23450 | - | -122.4311528 | 37.76719572 | - | - | - | D8 | - | STREET CLEANING | REG | R30B(CA).0267 | 18X18 | SUP2 | 2IN IRON POST | IS | 1413969480000 | SANCHEZ ST | 100 - 149 SANCHEZ ST | 100 - 149 SANCHEZ ST | 100 SANCHEZ ST | - | HENRY ST | HENRY ST |
| 6379 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S211547 | 1000-1135 OFARRELL ST | 1000-1099 OFARRELL ST | F | F | - | F | 9736000 | 9736000 | - | - | SOUTH SIDE | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 52994 | 52994 | 37.78465003 | -122.42201553 | - | - | 1710539427000 | MTA | MUNI LANDOR FLAG - TYPE 6 | VAN NESS AVE to FRANKLIN ST \ STARR KING WAY (1000 - 1099) | - | 25FT. WEST OF VAN NESS AVE. | - | - | - | - | - | 23451 | - | -122.42201553 | 37.78465003 | - | - | - | D5 | - | OTHER REGULATORY | REG | R(SF).0334 | 15X39 | SUP1 | MUNI LANDOR POLE 3" X121" | IS | 1418122500000 | OFARRELL ST | 1000 - 1099 OFARRELL ST | 1000 - 1099 OFARRELL ST | 1000 OFARRELL ST | - | FRANKLIN ST \ STARR KING WAY | FRANKLIN ST \ STARR KING WAY |
| 6380 | N/A | Point | - | - | - | - | S211549 | OFARRELL ST: VAN NESS AVE | - | T | T | - | F | 25192000 | 25192000 | - | - | NORTH WEST CORNER | - | - | - | - | OFARRELL ST | VAN NESS AVE | 52995 | 52995 | 37.78475345 | -122.42119297 | VAN NESS AVE \ OFARRELL ST | OFARRELL ST \ VAN NESS AVE | 1710539427000 | MTA | TEMPORARY SIGNS | VAN NESS AVE intersection | - | CONTRUCTION SIGN | - | - | - | - | - | 23452 | - | -122.42119297 | 37.78475345 | - | - | - | D5 | - | OTHER MISC | MISC | TEMPORARY SIGNS | 36X08 | SUP1 | LIGHT POLE | IS | 1418122980000 | OFARRELL ST | - | - | - | - | - | - |
| 6381 | N/A | Point | 1 | 1 | 1000 - 1099 | - | S211553 | 1000-1135 OFARRELL ST | 1000-1099 OFARRELL ST | F | F | - | F | 9736000 | 9736000 | - | - | NORTH SIDE | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 52996 | 52996 | 37.78465003 | -122.42201553 | - | - | 1710539427000 | MTA | NPRK 6AM-8AM THUR STCL | VAN NESS AVE to FRANKLIN ST \ STARR KING WAY (1000 - 1099) | - | 90' WEST OF VAN NESS AVE. | - | - | - | - | - | 23453 | - | -122.42201553 | 37.78465003 | - | 1654128000000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0193 | 18X18 | SUP1 | 2IN IRON POST | IS | 1418124540000 | OFARRELL ST | 1000 - 1099 OFARRELL ST | 1000 - 1099 OFARRELL ST | 1000 OFARRELL ST | - | FRANKLIN ST \ STARR KING WAY | FRANKLIN ST \ STARR KING WAY |
| 6382 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S211559 | 1700-1799 CALIFORNIA ST | 1700-1799 CALIFORNIA ST | F | F | - | F | 3550000 | 3550000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | VAN NESS AVE | VAN NESS AVE | 52997 | 52997 | 37.79026507 | -122.42315196 | - | - | 1731606412000 | middleware_editor | KEEP RIGHT | VAN NESS AVE to FRANKLIN ST (1700 - 1799) | - | 15FT. EAST OF VAN NESS AVE | - | - | - | - | - | 23454 | 1419259200000 | -122.42315196 | 37.79026507 | - | 1419206400000 | - | D2 | - | OTHER REGULATORY | REG | R4-7A(SF).0001 | 24X30 | SUP1 | 2IN IRON POST | IS | 1418125440000 | CALIFORNIA ST | 1700 - 1799 CALIFORNIA ST | 1700 - 1799 CALIFORNIA ST | 1700 CALIFORNIA ST | - | FRANKLIN ST | FRANKLIN ST |
| 6383 | N/A | Point | 1 | 1 | 1 - 99 | - | S211797 | 1-99 BELCHER ST | 1-99 BELCHER ST | F | F | - | F | 2883000 | 2883000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | DUBOCE AVE | DUBOCE AVE | 52998 | 52998 | 37.7685272 | -122.43016441 | - | - | 1739370133000 | middleware_editor | BUMP | DUBOCE AVE to 14TH ST \ BOYNTON CT (1 - 99) | - | 25' NORTH OF 14TH ST. | - | - | - | - | - | 23455 | - | -122.43016441 | 37.7685272 | - | - | - | D8 | - | OTHER WARNING | WARNING | W8-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1418719380000 | BELCHER ST | 1 - 99 BELCHER ST | 1 - 99 BELCHER ST | 1 BELCHER ST | - | 14TH ST \ BOYNTON CT | 14TH ST \ BOYNTON CT |
| 6384 | N/A | Point | 1 | 1 | 1 - 99 | - | S211800 | 1-99 WALTER ST | 1-99 WALTER ST | F | F | - | F | 13386000 | 13386000 | - | - | WEST SIDE | - | - | - | - | DUBOCE AVE | DUBOCE AVE | 52999 | 52999 | 37.76838905 | -122.43238179 | - | - | 1710539427000 | MTA | NPRK 8AM-10AM FRI STCL | DUBOCE AVE to 14TH ST (1 - 99) | 120019442 | NPL #24 | - | - | - | - | - | 23456 | 107568000000 | -122.43238179 | 37.76838905 | - | 1538524800000 | - | D8 | - | STREET CLEANING | REG | R30B(CA).0259 | 18X18 | SUP2 | 2IN IRON POST | IS | 1418720100000 | WALTER ST | 1 - 99 WALTER ST | 1 - 99 WALTER ST | 1 WALTER ST | - | 14TH ST | 14TH ST |
| 6385 | N/A | Point | 1 | 1 | 300 - 399 | LEFT ARROW | S211826 | 300-399 4TH AVE | 300-399 04TH AVE | F | F | - | F | 241000 | 241000 | - | - | EAST SIDE | - | - | - | - | CLEMENT ST | CLEMENT ST | 53000 | 53000 | 37.78207467 | -122.46220902 | - | - | 1714438756000 | middleware_editor | 2 HR PRK 9AM-6PM MON-FRI EXC "N" PERMITS | CLEMENT ST to GEARY BLVD (300 - 399) | - | NPL 378 | - | - | - | - | - | 23457 | 1420541280000 | -122.46220902 | 37.78207467 | - | 1574294400000 | - | D1 | - | PARKING:RPP | REG | R32C(CA).0169 | 18X21 | SUP2 | 2IN IRON POST | IS | 1418725200000 | 04TH AVE | 300 - 399 04TH AVE | 300 - 399 04TH AVE | 300 4TH AVE | - | GEARY BLVD | GEARY BLVD |
| 6386 | N/A | Point | 1 | 1 | 501 - 599 | - | S214465 | PNDG VIDAL DR | 501-599 VIDAL DR | F | F | - | F | 13296000 | 13296000 | - | - | EAST SIDE | - | - | - | - | ARBALLO DR | ARBALLO DR | 53001 | 53001 | 37.71546454 | -122.48248083 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "E" PERMITS | ARBALLO DR to RIVAS AVE (501 - 599) | - | OPP#28 | - | - | - | - | - | 23458 | 1469179740000 | -122.48248083 | 37.71546454 | - | 1579219200000 | - | D7 | - | PARKING:RPP | REG | R32C(CA).0082 | 18X21 | SUP2 | 2IN IRON POST | IS | 1427192400000 | VIDAL DR | PNDG VIDAL DR | 501 - 599 VIDAL DR | - | - | RIVAS AVE | RIVAS AVE |
| 6387 | N/A | Point | 1 | 1 | 1457 - 1499 | - | S214466 | 1500-1525 MARKET ST | 1457-1499 MARKET ST | T | T | - | F | 8754102 | 8754102 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 11TH ST | 11TH ST | 53002 | 53002 | 37.77533538 | -122.41894497 | - | - | 1710539427000 | MTA | RAILROAD TRACK ADVANCE WARNING CROSS BUCK (SYM) | 11TH ST to SOUTH VAN NESS AVE \ VAN NESS AVE (1457 - 1499) -- SOUTH -- | - | 50FT. WEST OF 11TH ST. | - | - | - | - | - | 23459 | 1427846400000 | -122.41894497 | 37.77533538 | - | 1427846400000 | - | D6 | - | OTHER WARNING | WARNING | W47(CA).0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1427192880000 | MARKET ST | 1457 - 1499 MARKET ST | 1457 - 1499 MARKET ST | 1457 MARKET ST | - | SOUTH VAN NESS AVE \ VAN NESS AVE | SOUTH VAN NESS AVE \ VAN NESS AVE |
| 6388 | N/A | Point | 1 | 1 | 300 - 347 | - | S224097 | 300-347 VALLEJO ST | 300-347 VALLEJO ST | F | F | - | F | 13084000 | 13084000 | - | - | NORTH SIDE | - | - | - | - | SANSOME ST | SANSOME ST | 58956 | 58956 | 37.79932822 | -122.40283704 | - | - | 1710539427000 | MTA | PARK AT 90 DEGREES (SYM) | SANSOME ST to PRESCOTT CT (300 - 347) | - | 20FT. WEST OF SANSOME ST. | - | - | - | - | - | 23460 | - | -122.40283704 | 37.79932822 | - | - | - | D3 | - | PARKING:PARK AT 90 | REG | R(SF).0182 | 18X18 | SUP1 | 2 POST ALUMINUM | IS | 1458041160000 | VALLEJO ST | 300 - 347 VALLEJO ST | 300 - 347 VALLEJO ST | 300 VALLEJO ST | - | PRESCOTT CT | PRESCOTT CT |
| 6389 | N/A | Point | 1 | 1 | 600 - 699 | - | S224099 | 600-699 3RD ST | 600-699 03RD ST | F | F | - | F | 179000 | 179000 | - | - | EAST SIDE | - | - | - | - | BRANNAN ST | BRANNAN ST | 58957 | 58957 | 37.77947073 | -122.39352491 | - | - | 1728349423000 | middleware_editor | MUNI LANDOR FLAG - TYPE 6 | BRANNAN ST to TOWNSEND ST (600 - 699) | - | INFO #665 | - | - | - | - | - | 23461 | - | -122.39352491 | 37.77947073 | - | - | 1672185600000 | D6 | - | OTHER REGULATORY | REG | R(SF).0334 | 15X39 | SUP1 | MUNI LANDOR POLE 3" X121" | RETD | 1458042300000 | 03RD ST | 600 - 699 3RD ST | 600 - 699 03RD ST | 600 3RD ST | - | TOWNSEND ST | TOWNSEND ST |
| 6390 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S224102 | 1200-1299 4TH ST | 1200-1299 04TH ST | F | F | - | F | 19983000 | 19983000 | - | - | EAST SIDE | - | - | - | - | MISSION ROCK ST | MISSION ROCK ST | 58958 | 58958 | 37.7726043737043 | -122.391281206302 | - | - | 1746646239000 | middleware_editor | TA (SYM) NO STOPPING EXC PERMITTED CSV- ZIPCARS | MISSION ROCK ST to CHINA BASIN ST (1200 - 1299) | - | 35 FT SOUTH OF MISSION ROCK | - | - | - | - | - | 23462 | 1458161220000 | -122.39132889 | 37.77236409 | - | 1630306800000 | - | D6 | - | OTHER REGULATORY | REG | R37(SF).0291 | 05X12 | SUP1 | 2IN IRON POST | IS | 1458043800000 | 04TH ST | 1200 - 1299 04TH ST | 1200 - 1299 04TH ST | 1200 4TH ST | - | CHINA BASIN ST | CHINA BASIN ST |
| 6391 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S224103 | 1200-1299 4TH ST | 1200-1299 04TH ST | F | F | - | F | 19983000 | 19983000 | - | - | EAST SIDE | - | - | - | - | MISSION ROCK ST | MISSION ROCK ST | 58959 | 58959 | 37.77236409 | -122.39132889 | - | - | 1746646176000 | middleware_editor | ZIPCARS | MISSION ROCK ST to CHINA BASIN ST (1200 - 1299) | - | 35 FT SOUTH OF MISSION ROCK | - | - | - | - | - | 23463 | 1458161340000 | -122.39132889 | 37.77236409 | - | 1630306800000 | 1746640800000 | D6 | - | OTHER GUIDE | GUIDE | G-Z(SF).0005 | 05X12 | SUP1 | 2IN IRON POST | RETD | 1458043860000 | 04TH ST | 1200 - 1299 4TH ST | 1200 - 1299 04TH ST | 1200 4TH ST | - | CHINA BASIN ST | CHINA BASIN ST |
| 6392 | N/A | Point | 1 | 1 | 1800 - 1899 | - | S224109 | 1800-1899 18TH ST | 1800-1899 18TH ST | F | F | - | F | 859000 | 859000 | - | - | NORTH SIDE | - | - | - | - | CAROLINA ST | CAROLINA ST | 58960 | 58960 | 37.76231821 | -122.40085667 | - | - | 1710539427000 | MTA | NPRK 9AM-11AM WED STCL | CAROLINA ST to DE HARO ST (1800 - 1899) | - | 75' EAST OF DEHARO | - | - | - | - | - | 23464 | 1045094400000 | -122.40085667 | 37.76231821 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0312 | 18X18 | SUP1 | 2IN IRON POST | IS | 1458048180000 | 18TH ST | 1800 - 1899 18TH ST | 1800 - 1899 18TH ST | 1800 18TH ST | - | DE HARO ST | DE HARO ST |
| 6393 | N/A | Point | 1 | 1 | 400 - 449 | - | S224114 | 400-449 CHURCH ST | 400-449 CHURCH ST | F | F | - | F | 4012000 | 4012000 | - | - | EAST SIDE | - | - | - | - | 16TH ST | 16TH ST | 58963 | 58963 | 37.76404198 | -122.42862012 | - | - | 1725629415000 | middleware_editor | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | 16TH ST to CHULA LN (400 - 449) | - | 30' NPL #445 | - | - | - | - | - | 23465 | - | -122.42862012 | 37.76404198 | - | 1657584000000 | - | D8 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP2 | 2 POST ALUMINUM | IS | 1458056940000 | CHURCH ST | 400 - 449 CHURCH ST | 400 - 449 CHURCH ST | 400 CHURCH ST | - | CHULA LN | CHULA LN |
| 6394 | N/A | Point | - | - | - | - | S223194 | GREAT HWY: FULTON ST | - | T | T | - | F | 27981000 | 27981000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GREAT HWY | GREAT HWY | 59685 | 59685 | 37.7713425 | -122.51105376 | FULTON ST \ GREAT HWY | FULTON ST \ GREAT HWY | 1743613567000 | middleware_editor | FULTON ST | GREAT HWY intersection | - | - | - | - | - | - | - | 23466 | 1479761220000 | -122.51105376 | 37.7713425 | - | 1743444840000 | - | D1 | - | STREET NAME | GUIDE | D3-2.0164 | 72X18 | SUP2 | OVERHEAD MAST ARM | IS | 1454671080000 | FULTON ST | - | - | - | - | - | - |
| 6395 | N/A | Point | - | - | - | - | S224409 | JUDAH ST: 47TH AVE | - | F | F | - | F | 27950000 | 27950000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 47TH AVE | JUDAH ST | 59686 | 59686 | 37.76037707 | -122.50699921 | JUDAH ST \ 47TH AVE | 47TH AVE \ JUDAH ST | 1710539427000 | MTA | NO LEFT TURN (SYM) 7AM-9AM/4PM-6PM EXC SAT & SUN | JUDAH ST intersection | - | - | - | - | - | - | - | 23467 | 1507645320000 | -122.50699921 | 37.76037707 | - | 1507766400000 | - | D4 | - | NO LEFT TURN | REG | R33A(CA).0014 | 30X48 | SUP2 | 3IN IRON POST | IS | 1458908640000 | 47TH AVE | - | - | - | - | - | - |
| 6396 | N/A | Point | - | - | - | - | S224410 | JUDAH ST: 47TH AVE | - | T | T | - | F | 27950000 | 27950000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 47TH AVE | JUDAH ST | 59687 | 59687 | 37.76037707 | -122.50699921 | JUDAH ST \ 47TH AVE | 47TH AVE \ JUDAH ST | 1710539427000 | MTA | NO LEFT TURN (SYM) 7AM-9AM/4PM-6PM EXC SAT & SUN | JUDAH ST intersection | - | - | - | - | - | - | - | 23468 | 1507129560000 | -122.50699921 | 37.76037707 | - | 1630281600000 | - | D4 | - | NO LEFT TURN | REG | R33A(CA).0014 | 30X48 | SUP2 | LIGHT POLE | IS | 1458908880000 | 47TH AVE | - | - | - | - | - | - |
| 6397 | N/A | Point | - | - | - | - | S224411 | JUDAH ST: 47TH AVE | - | T | T | - | F | 27950000 | 27950000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 47TH AVE | JUDAH ST | 59688 | 59688 | 37.76037707 | -122.50699921 | JUDAH ST \ 47TH AVE | 47TH AVE \ JUDAH ST | 1710539427000 | MTA | NO LEFT TURN (SYM) 7AM-9AM/4PM-6PM EXC SAT & SUN | JUDAH ST intersection | - | - | - | - | - | - | - | 23469 | 1507129860000 | -122.50699921 | 37.76037707 | - | 1630281600000 | - | D4 | - | NO LEFT TURN | REG | R33A(CA).0014 | 30X48 | SUP2 | LIGHT POLE | IS | 1458908940000 | 47TH AVE | - | - | - | - | - | - |
| 6398 | N/A | Point | - | - | - | - | S229821 | ASHBURY ST: GROVE ST | - | F | F | - | F | 26380000 | 26380000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GROVE ST | ASHBURY ST | 61935 | 61935 | 37.77466737 | -122.4478778 | ASHBURY ST \ GROVE ST | GROVE ST \ ASHBURY ST | 1755538691000 | middleware_editor | ALL WAY | ASHBURY ST intersection | - | 0 / 0 | - | - | - | - | - | 23470 | 183366000000 | -122.4478778 | 37.77466737 | - | 1742841000000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1476433740000 | GROVE ST | - | - | - | - | - | - |
| 6399 | N/A | Point | - | - | - | - | S229822 | ASHBURY ST: GROVE ST | - | F | F | - | F | 26380000 | 26380000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GROVE ST | ASHBURY ST | 61936 | 61936 | 37.77466737 | -122.4478778 | ASHBURY ST \ GROVE ST | GROVE ST \ ASHBURY ST | 1755538693000 | middleware_editor | ALL WAY | ASHBURY ST intersection | - | 0 / 0 | - | - | - | - | - | 23471 | 183366000000 | -122.4478778 | 37.77466737 | - | 1742842800000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1476433860000 | GROVE ST | - | - | - | - | - | - |
| 6400 | N/A | Point | - | - | - | - | S229823 | GROVE ST: ASHBURY ST | - | F | F | - | F | 26380000 | 26380000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GROVE ST | ASHBURY ST | 61937 | 61937 | 37.77466737 | -122.4478778 | ASHBURY ST \ GROVE ST | GROVE ST \ ASHBURY ST | 1755538696000 | middleware_editor | ALL WAY | ASHBURY ST intersection | - | - | - | - | - | - | - | 23472 | 1476725700000 | -122.4478778 | 37.77466737 | - | 1742843700000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1476434100000 | GROVE ST | - | - | - | - | - | - |
| 6401 | N/A | Point | - | - | - | - | S229824 | GROVE ST: ASHBURY ST | - | F | F | - | F | 26380000 | 26380000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GROVE ST | ASHBURY ST | 61938 | 61938 | 37.77466737 | -122.4478778 | ASHBURY ST \ GROVE ST | GROVE ST \ ASHBURY ST | 1755538690000 | middleware_editor | ALL WAY | ASHBURY ST intersection | - | - | - | - | - | - | - | 23473 | 1476725820000 | -122.4478778 | 37.77466737 | - | 1742844600000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1476434160000 | GROVE ST | - | - | - | - | - | - |
| 6402 | N/A | Point | - | - | - | - | S229825 | GROVE ST: CLAYTON ST | - | F | F | - | F | 26454000 | 26454000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CLAYTON ST | CLAYTON ST | 61939 | 61939 | 37.77445987 | -122.44951736 | GROVE ST \ CLAYTON ST | GROVE ST \ CLAYTON ST | 1743113754000 | middleware_editor | ALL WAY | CLAYTON ST intersection | - | 0 / 00 | - | - | - | - | - | 23474 | 183193200000 | -122.44951736 | 37.77445987 | - | 1743110100000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1476434460000 | GROVE ST | - | - | - | - | - | - |
| 6403 | N/A | Point | 1 | 1 | 36 - 68 | - | S226273 | 36-68 2ND ST | 36-68 02ND ST | F | F | - | F | 130000 | 130000 | - | - | WEST SIDE | - | - | - | - | STEVENSON ST | STEVENSON ST | 61940 | 61940 | 37.78862883 | -122.40057808 | - | - | 1710539427000 | MTA | MUNI LANDOR FLAG - TYPE 2 | STEVENSON ST to JESSIE ST (36 - 68) | - | NPL #58 | - | - | - | - | - | 23475 | - | -122.40057808 | 37.78862883 | - | - | - | D6 | - | OTHER REGULATORY | REG | R(SF).0335 | 15X25 | SUP1 | MUNI LANDOR POLE 3" X121" | IS | 1465218360000 | 02ND ST | 36 - 68 2ND ST | 36 - 68 02ND ST | 36 2ND ST | - | JESSIE ST | JESSIE ST |
| 6404 | N/A | Point | 1 | 1 | 200 - 299 | - | S227128 | 200-299 LARKIN ST | 200-299 LARKIN ST | F | F | - | F | 8122000 | 8122000 | - | - | EAST SIDE | - | - | - | - | FULTON ST | FULTON ST | 61941 | 61941 | 37.78002739 | -122.41685785 | - | - | 1710539427000 | MTA | (H/C SYM) PARK ONLY/MIN FINE $250 | FULTON ST to MCALLISTER ST (200 - 299) | - | 30' NORTH OF FULTON ST | - | - | - | - | - | 23476 | - | -122.41685785 | 37.78002739 | - | 1678665600000 | - | D6 | - | OTHER REGULATORY | REG | R99C(CA).0001 | 12X24 | SUP1 | 2IN IRON POST | IS | 1467882240000 | LARKIN ST | 200 - 299 LARKIN ST | 200 - 299 LARKIN ST | 200 LARKIN ST | - | MCALLISTER ST | MCALLISTER ST |
| 6405 | N/A | Point | - | 1 | 715 - 899 | - | S228221 | 715-899 IOWA ST | 715-899 IOWA ST | F | F | - | F | 7270000 | 7270000 | - | - | WEST SIDE | - | - | - | - | 22ND ST | 22ND ST | 61942 | 61942 | 37.75643257 | -122.39201743 | - | - | 1710539427000 | MTA | BIKE RACK | 22ND ST to 23RD ST (715 - 899) | - | 150' SOUTH 10' FROM CURB | - | - | - | - | - | 23477 | - | -122.39201743 | 37.75643257 | - | - | - | D10 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1471596240000 | IOWA ST | 715 - 899 IOWA ST | 715 - 899 IOWA ST | 715 IOWA ST | - | 23RD ST | 23RD ST |
| 6406 | N/A | Point | - | 1 | 715 - 899 | - | S228222 | 715-899 IOWA ST | 715-899 IOWA ST | F | F | - | F | 7270000 | 7270000 | - | - | WEST SIDE | - | - | - | - | 22ND ST | 22ND ST | 61943 | 61943 | 37.75643257 | -122.39201743 | - | - | 1710539427000 | MTA | BIKE RACK | 22ND ST to 23RD ST (715 - 899) | - | 160' SOUTH 10' FROM CURB | - | - | - | - | - | 23478 | - | -122.39201743 | 37.75643257 | - | - | - | D10 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1471596360000 | IOWA ST | 715 - 899 IOWA ST | 715 - 899 IOWA ST | 715 IOWA ST | - | 23RD ST | 23RD ST |
| 6407 | N/A | Point | - | 1 | 715 - 899 | - | S228223 | 715-899 IOWA ST | 715-899 IOWA ST | F | F | - | F | 7270000 | 7270000 | - | - | WEST SIDE | - | - | - | - | 22ND ST | 22ND ST | 61944 | 61944 | 37.75643257 | -122.39201743 | - | - | 1710539427000 | MTA | BIKE RACK | 22ND ST to 23RD ST (715 - 899) | - | 160' SOUTH 5' FROM CURB | - | - | - | - | - | 23479 | - | -122.39201743 | 37.75643257 | - | - | - | D10 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1471596540000 | IOWA ST | 715 - 899 IOWA ST | 715 - 899 IOWA ST | 715 IOWA ST | - | 23RD ST | 23RD ST |
| 6408 | N/A | Point | 1 | 1 | 900 - 920 | - | S225012 | 900-920 POST ST | 900-920 POST ST | F | F | - | F | 10637000 | 10637000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | HYDE ST | HYDE ST | 62546 | 62546 | 37.78722292 | -122.41681427 | - | - | 1710539427000 | MTA | WARNING-SUSPICIOUS ACTIVITIES IMMEDIATELY RPTD TO POLICE ETC | HYDE ST to MEACHAM PL (900 - 920) | - | 100FT. EAST OF LARKIN ST. | - | - | - | - | - | 23480 | - | -122.41681427 | 37.78722292 | - | - | - | D6 | - | OTHER WARNING | WARNING | SW(SF).0007 | 18X24 | SUP1 | LIGHT POLE | IS | 1461168900000 | POST ST | 900 - 920 POST ST | 900 - 920 POST ST | 900 POST ST | - | MEACHAM PL | MEACHAM PL |
| 6409 | N/A | Point | 1 | 1 | 300 - 399 | RIGHT ARROW | S225017 | 300-399 CALIFORNIA ST | 300-399 CALIFORNIA ST | F | F | - | F | 3527000 | 3527000 | - | - | SOUTH SIDE | - | - | - | - | BATTERY ST | BATTERY ST | 62548 | 62548 | 37.7931347 | -122.40054254 | - | - | 1710539427000 | MTA | TANS 7AM-11AM EXC SAT & SUN | BATTERY ST to SANSOME ST (300 - 399) | - | 30' EAST OF SANSOME ST | - | - | - | - | - | 23481 | 1462362060000 | -122.40054254 | 37.7931347 | - | 1634083200000 | - | D3 | - | OTHER REGULATORY | REG | R37(CA).0224 | 14X21 | SUP1 | 2IN FLANGE POST | IS | 1461228240000 | CALIFORNIA ST | 300 - 399 CALIFORNIA ST | 300 - 399 CALIFORNIA ST | 300 CALIFORNIA ST | - | SANSOME ST | SANSOME ST |
| 6410 | N/A | Point | - | - | - | - | S227532 | CASTRO ST: 28TH ST | - | F | F | - | F | 22012000 | 22012000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 28TH ST | CASTRO ST | 62549 | 62549 | 37.74488092 | -122.43346593 | CASTRO ST \ 28TH ST | 28TH ST \ CASTRO ST | 1718285824000 | middleware_editor | STOP | CASTRO ST intersection | - | - | - | - | - | - | - | 23482 | 1470217800000 | -122.43346593 | 37.74488092 | - | 1718194800000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1469611380000 | 28TH ST | - | - | - | - | - | - |
| 6411 | N/A | Point | 1 | 1 | 4100 - 4150 | - | S227534 | 4100-4150 17TH ST | 4100-4150 17TH ST | F | F | - | F | 813000 | 813000 | - | - | SOUTH SIDE | - | - | - | - | DIAMOND ST | DIAMOND ST | 62550 | 62550 | 37.76232274 | -122.43788033 | - | - | 1715044375000 | middleware_editor | NPRK 9AM-11AM FRI STCL | DIAMOND ST to EUREKA ST (4100 - 4150) | - | 25`WEST | - | - | - | - | - | 23483 | - | -122.43788033 | 37.76232274 | - | 1650412800000 | - | D8 | - | STREET CLEANING | REG | R30B(CA).0298 | 18X18 | SUP2 | 2IN IRON POST | IS | 1469612400000 | 17TH ST | 4100 - 4150 17TH ST | 4100 - 4150 17TH ST | 4100 17TH ST | - | EUREKA ST | EUREKA ST |
| 6412 | N/A | Point | 1 | 1 | 2200 - 2299 | - | S228638 | 2200-2299 BEACH ST | 2200-2299 BEACH ST | F | F | - | F | 2858000 | 2858000 | - | - | SOUTH SIDE | - | - | - | - | BRODERICK ST | BRODERICK ST | 65838 | 65838 | 37.8033004711344 | -122.446418539874 | - | - | 1753985581000 | elclark | 2 HR PRK 8AM-6PM MON-FRI EXC "M" PERMITS | BRODERICK ST to BAKER ST (2200 - 2299) | - | WPL #2265 | - | - | - | - | - | 23484 | 1219993200000 | -122.44609025 | 37.80338834 | - | 1473404400000 | - | D2 | - | PARKING:RPP | REG | R32C(CA).0096 | 18X21 | SUP1 | 2IN IRON POST | IS | 1472814960000 | BEACH ST | 2200 - 2299 BEACH ST | 2200 - 2299 BEACH ST | 2200 BEACH ST | - | BAKER ST | BAKER ST |
| 6413 | N/A | Point | 1 | 1 | 200 - 299 | - | S228644 | 200-299 MISSISSIPPI ST | 200-299 MISSISSIPPI ST | F | F | - | F | 9201000 | 9201000 | - | - | EAST SIDE | - | - | - | - | MARIPOSA ST | MARIPOSA ST | 65840 | 65840 | 37.76333012 | -122.39465204 | - | - | 1754416920000 | middleware_editor | NPRK 9AM-11AM MON STCL | MARIPOSA ST to 18TH ST (200 - 299) | - | SPL # 249 | - | - | - | - | - | 23485 | 1002006000000 | -122.39465204 | 37.76333012 | - | 1582099200000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0300 | 18X18 | SUP1 | 2IN IRON POST | IS | 1472823180000 | MISSISSIPPI ST | 200 - 299 MISSISSIPPI ST | 200 - 299 MISSISSIPPI ST | 200 MISSISSIPPI ST | - | 18TH ST | 18TH ST |
| 6414 | N/A | Point | 1 | 1 | 100 - 199 | - | S229844 | 100-199 CRESCENT AVE | 100-199 CRESCENT AVE | F | F | - | F | 4486000 | 4486000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | AGNON AVE | AGNON AVE | 65841 | 65841 | 37.73510549 | -122.42117228 | - | - | 1749583123000 | middleware_editor | SPEED LIMIT 25 | AGNON AVE to MURRAY ST (100 - 199) | - | 20FT. EAST OF 114 CRECENT AVE. | - | - | - | - | - | 23486 | 1222758000000 | -122.42117228 | 37.73510549 | - | 1477983600000 | - | D9 | - | SPEED LIMIT | REG | R2-1.0006 | 36X45 | SUP2 | 2IN IRON POST | IS | 1476442200000 | CRESCENT AVE | 100 - 199 CRESCENT AVE | 100 - 199 CRESCENT AVE | 100 CRESCENT AVE | - | MURRAY ST | MURRAY ST |
| 6415 | N/A | Point | - | - | - | - | S231395 | CLIFFORD TER: UPPER TER | - | F | F | - | F | 26210000 | 26210000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | UPPER TER | UPPER TER | 65842 | 65842 | 37.76398693 | -122.44441171 | CLIFFORD TER \ UPPER TER | CLIFFORD TER \ UPPER TER | 1710539427000 | MTA | ALL WAY | UPPER TER intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 23487 | 1492871040000 | -122.44441171 | 37.76398693 | - | 1492819200000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1480504560000 | CLIFFORD TER | - | - | - | - | - | - |
| 6416 | N/A | Point | - | - | - | - | S231396 | UPPER TER: CLIFFORD TER | - | F | F | - | F | 26210000 | 26210000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | UPPER TER | UPPER TER | 65843 | 65843 | 37.76398693 | -122.44441171 | CLIFFORD TER \ UPPER TER | CLIFFORD TER \ UPPER TER | 1710539427000 | MTA | ALL WAY | UPPER TER intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 23488 | 1492866300000 | -122.44441171 | 37.76398693 | - | 1492819200000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1480504860000 | CLIFFORD TER | - | - | - | - | - | - |
| 6417 | N/A | Point | - | - | - | - | S231397 | UPPER TER: CLIFFORD TER | - | F | F | - | F | 26210000 | 26210000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | UPPER TER | UPPER TER | 65844 | 65844 | 37.76398693 | -122.44441171 | CLIFFORD TER \ UPPER TER | CLIFFORD TER \ UPPER TER | 1710539427000 | MTA | ALL WAY | UPPER TER intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 23489 | 1492866420000 | -122.44441171 | 37.76398693 | - | 1492819200000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1480505040000 | CLIFFORD TER | - | - | - | - | - | - |
| 6418 | N/A | Point | - | - | - | - | S231398 | DEMING ST: URANUS TER | - | F | F | - | F | 26196000 | 26196000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | DEMING ST | URANUS TER | 65845 | 65845 | 37.7604808 | -122.44530943 | URANUS TER \ DEMING ST | DEMING ST \ URANUS TER | 1723669022000 | middleware_editor | ALL WAY | URANUS TER intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 23490 | 752544000000 | -122.44530943 | 37.7604808 | - | 1493164800000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1480506540000 | DEMING ST | - | - | - | - | - | - |
| 6419 | N/A | Point | 1 | 1 | 1300 - 1399 | - | S231486 | 1300-1399 PAGE ST | 1300-1399 PAGE ST | F | F | - | F | 10182000 | 10182000 | - | - | SOUTH SIDE | - | - | - | - | LYON ST | LYON ST | 65846 | 65846 | 37.77146458 | -122.44301201 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "Q" PERMITS | LYON ST to CENTRAL AVE (1300 - 1399) | - | WPL #1301 | - | - | - | - | - | 23491 | 1482796800000 | -122.44301201 | 37.77146458 | - | 1482796800000 | - | D5 | - | PARKING:RPP | REG | R32C(CA).0215 | 18X21 | SUP1 | 2 POST ALUMINUM | IS | 1480933200000 | PAGE ST | 1300 - 1399 PAGE ST | 1300 - 1399 PAGE ST | 1300 PAGE ST | - | CENTRAL AVE | CENTRAL AVE |
| 6420 | N/A | Point | - | - | - | - | S231462 | FRANCISCO ST: MONTGOMERY ST | - | F | F | - | F | 24880000 | 24880000 | - | - | SOUTH WEST CORNER | - | - | - | - | MONTGOMERY ST | MONTGOMERY ST | 65847 | 65847 | 37.80569594 | -122.40535724 | FRANCISCO ST \ MONTGOMERY ST | FRANCISCO ST \ MONTGOMERY ST | 1710539427000 | MTA | FRANCISCO ST | MONTGOMERY ST intersection | - | 050 | - | - | - | - | - | 23492 | 1483694520000 | -122.40535724 | 37.80569594 | - | 1483660800000 | - | D3 | - | STREET NAME | GUIDE | D3-1.0687 | 36X08 | SUP1 | LIGHT POLE | IS | 1480691280000 | FRANCISCO ST | - | - | - | - | - | - |
| 6421 | N/A | Point | - | - | - | - | S231464 | MONTGOMERY ST: FRANCISCO ST | - | F | F | - | F | 24880000 | 24880000 | - | - | SOUTH WEST CORNER | - | - | - | - | MONTGOMERY ST | MONTGOMERY ST | 65848 | 65848 | 37.80569594 | -122.40535724 | FRANCISCO ST \ MONTGOMERY ST | FRANCISCO ST \ MONTGOMERY ST | 1710539427000 | MTA | MONTGOMERY ST | MONTGOMERY ST intersection | - | END | - | - | - | - | - | 23493 | 1483694400000 | -122.40535724 | 37.80569594 | - | 1483660800000 | - | D3 | - | STREET NAME | GUIDE | D3-1.1229 | 36X08 | SUP1 | LIGHT POLE | IS | 1480691400000 | FRANCISCO ST | - | - | - | - | - | - |
| 6422 | N/A | Point | - | - | - | - | S228604 | STILLMAN ST: 2ND ST | - | F | F | - | F | 24492000 | 24492000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | STILLMAN ST | 02ND ST | 65849 | 65849 | 37.78350351 | -122.39415052 | 2ND ST \ STILLMAN ST | STILLMAN ST \ 02ND ST | 1710539427000 | MTA | STOP | 02ND ST intersection | - | 10' WEST OF 2ND ST | - | - | - | - | - | 23494 | 1472824620000 | -122.39415052 | 37.78350351 | - | 1472774400000 | - | D6 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1472741340000 | STILLMAN ST | - | - | - | - | - | - |
| 6423 | N/A | Point | 1 | 1 | 400 - 422 | - | S231225 | 400-422 FILBERT ST | 400-422 FILBERT ST | F | F | - | F | 5495000 | 5495000 | - | - | EAST SIDE, EASTBOUND TRAFFIC | - | - | - | - | KEARNY ST | KEARNY ST | 65850 | 65850 | 37.8017505 | -122.40640678 | - | - | 1710539427000 | MTA | NO LITTERING (SYM)-IT SHALL BE UNLAWFUL¿ | KEARNY ST to GENOA PL (400 - 422) | - | CENTER LINE OF FILBERT/END OF FILBERT | - | - | - | - | - | 23495 | - | -122.40640678 | 37.8017505 | - | - | - | D3 | - | OTHER REGULATORY | REG | SR(SF).0035 | 18X24 | SUP1 | 2IN IRON POST | IS | 1479811500000 | FILBERT ST | 400 - 422 FILBERT ST | 400 - 422 FILBERT ST | 400 FILBERT ST | - | GENOA PL | GENOA PL |
| 6424 | N/A | Point | - | - | - | - | S231463 | 19TH AVE: CLEMENT ST | - | F | F | - | F | 27506000 | 27506000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CLEMENT ST | CLEMENT ST | 65852 | 65852 | 37.78230838 | -122.47844351 | 19TH AVE \ CLEMENT ST | 19TH AVE \ CLEMENT ST | 1715356235000 | middleware_editor | ALL WAY | CLEMENT ST intersection | - | 0 / 0 | - | - | - | - | - | 23496 | -74908800000 | -122.47844351 | 37.78230838 | - | 1484611200000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1480691280000 | 19TH AVE | - | - | - | - | - | - |
| 6425 | N/A | Point | - | - | - | - | S231465 | 19TH AVE: CLEMENT ST | - | F | F | - | F | 27506000 | 27506000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CLEMENT ST | CLEMENT ST | 65853 | 65853 | 37.78230838 | -122.47844351 | 19TH AVE \ CLEMENT ST | 19TH AVE \ CLEMENT ST | 1715356297000 | middleware_editor | ALL WAY | CLEMENT ST intersection | - | 0 / 0 | - | - | - | - | - | 23497 | -74908800000 | -122.47844351 | 37.78230838 | - | 1484611200000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1480691460000 | 19TH AVE | - | - | - | - | - | - |
| 6426 | N/A | Point | - | - | - | - | S231466 | CLEMENT ST: 19TH AVE | - | F | F | - | F | 27506000 | 27506000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CLEMENT ST | CLEMENT ST | 65854 | 65854 | 37.78230838 | -122.47844351 | 19TH AVE \ CLEMENT ST | 19TH AVE \ CLEMENT ST | 1715356294000 | middleware_editor | ALL WAY | CLEMENT ST intersection | - | 0 / 0 | - | - | - | - | - | 23498 | 209347200000 | -122.47844351 | 37.78230838 | - | 1484611200000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1480691640000 | 19TH AVE | - | - | - | - | - | - |
| 6427 | N/A | Point | - | - | - | - | S231467 | CLEMENT ST: 19TH AVE | - | F | F | - | F | 27506000 | 27506000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CLEMENT ST | CLEMENT ST | 65855 | 65855 | 37.78230838 | -122.47844351 | 19TH AVE \ CLEMENT ST | 19TH AVE \ CLEMENT ST | 1715356328000 | middleware_editor | ALL WAY | CLEMENT ST intersection | - | 0 / 0 | - | - | - | - | - | 23499 | 209347200000 | -122.47844351 | 37.78230838 | - | 1484611200000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1480691760000 | 19TH AVE | - | - | - | - | - | - |
| 6428 | N/A | Point | - | - | - | - | S231468 | 22ND AVE: CALIFORNIA ST | - | F | F | - | F | 27644000 | 27644000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 65856 | 65856 | 37.78402824 | -122.48179117 | 22ND AVE \ CALIFORNIA ST | 22ND AVE \ CALIFORNIA ST | 1714611720000 | middleware_editor | ALL WAY | CALIFORNIA ST intersection | - | 0 / 00 | - | - | - | - | - | 23500 | -385430400000 | -122.48179117 | 37.78402824 | - | 1484784000000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1480691940000 | 22ND AVE | - | - | - | - | - | - |
| 6429 | N/A | Point | - | - | - | - | S231469 | 22ND AVE: CALIFORNIA ST | - | F | F | - | F | 27644000 | 27644000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 65857 | 65857 | 37.78402824 | -122.48179117 | 22ND AVE \ CALIFORNIA ST | 22ND AVE \ CALIFORNIA ST | 1727901255000 | middleware_editor | ALL WAY | CALIFORNIA ST intersection | - | 0 / 00 | - | - | - | - | - | 23501 | -385430400000 | -122.48179117 | 37.78402824 | - | 1727866560000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1480692060000 | 22ND AVE | - | - | - | - | - | - |
| 6430 | N/A | Point | - | - | - | - | S239945 | BURNETT AVE: GARDENSIDE DR | - | F | F | - | F | 26118000 | 26118000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GARDENSIDE DR | BURNETT AVE | 75068 | 75068 | 37.75093681 | -122.44526286 | BURNETT AVE \ GARDENSIDE DR | GARDENSIDE DR \ BURNETT AVE | 1739999445000 | middleware_editor | ALL WAY | BURNETT AVE intersection | - | NORTHERN INTERSECTION | - | - | - | - | - | 23502 | 722649600000 | -122.44526286 | 37.75093681 | - | 1516579200000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1509119340000 | GARDENSIDE DR | - | - | - | - | - | - |
| 6431 | N/A | Point | - | - | - | - | S239947 | CHURCH ST: LIBERTY ST | - | F | F | - | F | 25678000 | 25678000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LIBERTY ST | CHURCH ST | 75070 | 75070 | 37.75729224 | -122.4279696 | CHURCH ST \ LIBERTY ST | LIBERTY ST \ CHURCH ST | 1721955687000 | middleware_editor | ALL WAY | CHURCH ST intersection | - | BELOW STOP SIGN | - | - | - | - | - | 23503 | 598579200000 | -122.4279696 | 37.75729224 | - | 1516406400000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1509120420000 | LIBERTY ST | - | - | - | - | - | - |
| 6432 | N/A | Point | - | - | - | - | S239948 | CHURCH ST: LIBERTY ST | - | F | F | - | F | 25678000 | 25678000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LIBERTY ST | CHURCH ST | 75071 | 75071 | 37.75729224 | -122.4279696 | CHURCH ST \ LIBERTY ST | LIBERTY ST \ CHURCH ST | 1721955714000 | middleware_editor | ALL WAY | CHURCH ST intersection | - | - | - | - | - | - | - | 23504 | 598579200000 | -122.4279696 | 37.75729224 | - | 1517270400000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1509120840000 | LIBERTY ST | - | - | - | - | - | - |
| 6433 | N/A | Point | - | - | - | - | S239949 | LIBERTY ST: CHURCH ST | - | F | F | - | F | 25678000 | 25678000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LIBERTY ST | CHURCH ST | 75072 | 75072 | 37.75729224 | -122.4279696 | CHURCH ST \ LIBERTY ST | LIBERTY ST \ CHURCH ST | 1721955718000 | middleware_editor | ALL WAY | CHURCH ST intersection | - | - | - | - | - | - | - | 23505 | 598579200000 | -122.4279696 | 37.75729224 | - | 1516406400000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1509121200000 | LIBERTY ST | - | - | - | - | - | - |
| 6434 | N/A | Point | - | - | - | - | S239950 | LIBERTY ST: CHURCH ST | - | F | F | - | F | 25678000 | 25678000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | LIBERTY ST | CHURCH ST | 75073 | 75073 | 37.75729224 | -122.4279696 | CHURCH ST \ LIBERTY ST | LIBERTY ST \ CHURCH ST | 1721955744000 | middleware_editor | ALL WAY | CHURCH ST intersection | - | - | - | - | - | - | - | 23506 | 598579200000 | -122.4279696 | 37.75729224 | - | 1516406400000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1509121500000 | LIBERTY ST | - | - | - | - | - | - |
| 6435 | N/A | Point | - | - | - | - | S240076 | ELIZABETH ST: SANCHEZ ST | - | F | F | - | F | 25654000 | 25654000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ELIZABETH ST | ELIZABETH ST | 75075 | 75075 | 37.752362 | -122.4297313 | SANCHEZ ST \ ELIZABETH ST | SANCHEZ ST \ ELIZABETH ST | 1711491138000 | middleware_editor | ALL WAY | ELIZABETH ST intersection | - | - | - | - | - | - | - | 23507 | 747964800000 | -122.4297313 | 37.752362 | - | 1510963200000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1509465960000 | SANCHEZ ST | - | - | - | - | - | - |
| 6436 | N/A | Point | - | - | - | - | S240077 | ELIZABETH ST: SANCHEZ ST | - | F | F | - | F | 25654000 | 25654000 | - | - | SOUTH WEST CORNER | - | - | - | - | ELIZABETH ST | ELIZABETH ST | 75076 | 75076 | 37.752362 | -122.4297313 | SANCHEZ ST \ ELIZABETH ST | SANCHEZ ST \ ELIZABETH ST | 1711491142000 | middleware_editor | ELIZABETH ST | ELIZABETH ST intersection | - | - | - | - | - | - | - | 23508 | 1526372280000 | -122.4297313 | 37.752362 | - | - | - | D8 | - | STREET NAME | GUIDE | D3-1.0593 | 36X08 | SUP2 | 3IN IRON POST | IS | 1509466260000 | SANCHEZ ST | - | - | - | - | - | - |
| 6437 | N/A | Point | - | - | - | - | S240078 | ELIZABETH ST: SANCHEZ ST | - | F | F | - | F | 25654000 | 25654000 | - | - | SOUTH WEST CORNER | - | - | - | - | ELIZABETH ST | ELIZABETH ST | 75077 | 75077 | 37.752362 | -122.4297313 | SANCHEZ ST \ ELIZABETH ST | SANCHEZ ST \ ELIZABETH ST | 1711491146000 | middleware_editor | SANCHEZ ST | ELIZABETH ST intersection | - | - | - | - | - | - | - | 23509 | - | -122.4297313 | 37.752362 | - | - | - | D8 | - | STREET NAME | GUIDE | D3-1.1573 | 36X08 | SUP2 | 3IN IRON POST | IS | 1509466560000 | SANCHEZ ST | - | - | - | - | - | - |
| 6438 | N/A | Point | - | - | - | - | S241098 | 3RD ST: LE CONTE AVE | - | F | F | - | T | 20467000 | 20467000 | - | - | CENTER ISLAND, S LINE, NORTHBOUND | - | - | - | - | LE CONTE AVE | 03RD ST | 75078 | 75078 | 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 | - | - | - | - | - | - | - | 23510 | 1512486480000 | -122.39747874 | 37.71883436 | - | 1512432000000 | - | D10 | - | NO LEFT TURN | REG | R3-18.0001 | 24X24 | SUP1 | SIGNAL POLE | IS | 1512142380000 | LE CONTE AVE | - | - | - | - | - | - |
| 6439 | N/A | Point | 1 | 1 | 424 - 499 | - | S241070 | 424-499 WEBSTER ST | 424-499 WEBSTER ST | F | F | - | F | 13527000 | 13527000 | - | - | WEST SIDE | - | - | - | - | HICKORY ST | HICKORY ST | 75079 | 75079 | 37.77488005 | -122.42931925 | - | - | 1753123731000 | middleware_editor | TANSAT (LA) | HICKORY ST to FELL ST (424 - 499) | - | IFO #435 | - | - | - | - | - | 23511 | - | -122.42931925 | 37.77488005 | - | - | - | D5 | - | TOW (TANSAT) | REG | R37(CA).0092 | 18X21 | SUP1 | 2IN IRON POST | IS | 1512123900000 | WEBSTER ST | 424 - 499 WEBSTER ST | 424 - 499 WEBSTER ST | 424 WEBSTER ST | - | FELL ST | FELL ST |
| 6440 | N/A | Point | 1 | 1 | 300 - 399 | - | S241072 | 300-399 MONTGOMERY ST | 300-399 MONTGOMERY ST | F | F | - | F | 9300000 | 9300000 | - | - | EAST SIDE | - | - | - | - | PINE ST | PINE ST | 75080 | 75080 | 37.79237508 | -122.40266905 | - | - | 1710539427000 | MTA | TANS 7AM-7PM MON-FRI/11AM-7PM SAT & SUN | PINE ST to CALIFORNIA ST (300 - 399) | - | 75FT. NORTH OF PINE ST. | - | - | - | - | - | 23512 | 1513244280000 | -122.40266905 | 37.79237508 | - | 1513209600000 | - | D3 | - | OTHER REGULATORY | REG | R37(CA).0058 | 18X21 | SUP1 | 2IN IRON POST | IS | 1512126060000 | MONTGOMERY ST | 300 - 399 MONTGOMERY ST | 300 - 399 MONTGOMERY ST | 300 MONTGOMERY ST | - | CALIFORNIA ST | CALIFORNIA ST |
| 6441 | N/A | Point | 1 | 1 | 700 - 749 | - | S241073 | 700-749 CALIFORNIA ST | 700-749 CALIFORNIA ST | F | F | - | F | 3534000 | 3534000 | - | - | SOUTH SIDE | - | - | - | - | GRANT AVE | GRANT AVE | 75081 | 75081 | 37.79240151 | -122.40632818 | - | - | 1710539427000 | MTA | NPRK 2AM-6AM TUE THUR STCL | GRANT AVE to SABIN PL (700 - 749) | - | 75' E STOCKTON ON CABLE CAR SIGNAL | - | - | - | - | - | 23513 | 1513250400000 | -122.40632818 | 37.79240151 | - | 1600300800000 | - | D3 | - | STREET CLEANING | REG | R30B(CA).0133 | 18X18 | SUP1 | MUNI POLE | IS | 1512127260000 | CALIFORNIA ST | 700 - 749 CALIFORNIA ST | 700 - 749 CALIFORNIA ST | 700 CALIFORNIA ST | - | SABIN PL | SABIN PL |
| 6442 | N/A | Point | - | - | - | - | S240441 | EUGENIA AVE: ANDERSON ST | - | F | F | - | F | 21210000 | 21210000 | - | - | NORTH EAST CORNER | - | - | - | - | EUGENIA AVE | ANDERSON ST | 75082 | 75082 | 37.74037698 | -122.41516878 | ANDERSON ST \ EUGENIA AVE | EUGENIA AVE \ ANDERSON ST | 1753476630000 | middleware_editor | EUGENIA AVE | ANDERSON ST intersection | - | - | - | - | - | - | - | 23514 | 154598400000 | -122.41516878 | 37.74037698 | - | 1525244400000 | - | D9 | - | STREET NAME | GUIDE | D3-1.0628 | 36X08 | SUP2 | 3IN IRON POST | IS | 1510640460000 | EUGENIA AVE | - | - | - | - | - | - |
| 6443 | N/A | Point | - | - | - | - | S240442 | EUGENIA AVE: ANDERSON ST | - | F | F | - | F | 21210000 | 21210000 | - | - | NORTH EAST CORNER | - | - | - | - | EUGENIA AVE | ANDERSON ST | 75083 | 75083 | 37.74037698 | -122.41516878 | ANDERSON ST \ EUGENIA AVE | EUGENIA AVE \ ANDERSON ST | 1753476634000 | middleware_editor | ANDERSON ST | ANDERSON ST intersection | - | - | - | - | - | - | - | 23515 | 154598400000 | -122.41516878 | 37.74037698 | - | 1525158000000 | - | D9 | - | STREET NAME | GUIDE | D3-1.0101 | 36X08 | SUP2 | 3IN IRON POST | IS | 1510640760000 | EUGENIA AVE | - | - | - | - | - | - |
| 6444 | N/A | Point | - | - | - | - | S240443 | EUGENIA AVE: ANDERSON ST | - | F | F | - | F | 21210000 | 21210000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | EUGENIA AVE | ANDERSON ST | 75084 | 75084 | 37.74037698 | -122.41516878 | ANDERSON ST \ EUGENIA AVE | EUGENIA AVE \ ANDERSON ST | 1753476683000 | middleware_editor | ALL WAY | ANDERSON ST intersection | - | BELOW STOP SIGN | - | - | - | - | - | 23516 | 154598400000 | -122.41516878 | 37.74037698 | - | 1517212800000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1510641240000 | EUGENIA AVE | - | - | - | - | - | - |
| 6445 | N/A | Point | - | - | - | - | S240444 | ANDERSON ST: EUGENIA AVE | - | F | F | - | F | 21210000 | 21210000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | EUGENIA AVE | ANDERSON ST | 75085 | 75085 | 37.74037698 | -122.41516878 | ANDERSON ST \ EUGENIA AVE | EUGENIA AVE \ ANDERSON ST | 1753476677000 | middleware_editor | ALL WAY | ANDERSON ST intersection | - | - | - | - | - | - | - | 23517 | 779439600000 | -122.41516878 | 37.74037698 | - | 1517212800000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1510641540000 | EUGENIA AVE | - | - | - | - | - | - |
| 6446 | N/A | Point | - | - | - | - | S242002 | FULTON ST: LAGUNA ST | - | T | T | - | F | 25958000 | 25958000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | LAGUNA ST | FULTON ST | 75086 | 75086 | 37.7782776382859 | -122.426546439523 | FULTON ST \ LAGUNA ST | LAGUNA ST \ FULTON ST | 1739290997000 | middleware_editor | LAGUNA ST | FULTON ST intersection | - | - | - | - | - | - | - | 23518 | - | -122.4266415 | 37.77832856 | - | - | - | D5 | - | STREET NAME | GUIDE | D3-2.0218 | 72X18 | SUP1 | LIGHT POLE | IS | 1514973420000 | LAGUNA ST | - | - | - | - | - | - |
| 6447 | N/A | Point | - | - | - | - | S242003 | FULTON ST: LAGUNA ST | - | T | T | - | F | 25958000 | 25958000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | LAGUNA ST | FULTON ST | 75087 | 75087 | 37.7782815811427 | -122.426524072476 | FULTON ST \ LAGUNA ST | LAGUNA ST \ FULTON ST | 1739291109000 | middleware_editor | LAGUNA ST | FULTON ST intersection | - | - | - | - | - | - | - | 23519 | - | -122.4266415 | 37.77832856 | - | - | - | D5 | - | STREET NAME | GUIDE | D3-2.0218 | 72X18 | SUP1 | LIGHT POLE | IS | 1514973480000 | LAGUNA ST | - | - | - | - | - | - |
| 6448 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S242766 | 1500-1599 4TH ST | 1500-1599 04TH ST | F | F | - | F | 19987000 | 19987000 | - | - | EAST SIDE | - | - | - | - | NELSON RISING LN | NELSON RISING LN | 76225 | 76225 | 37.76918979 | -122.3910254 | - | - | 1710539427000 | MTA | SPECIAL EVENT AREA CHECK YOUR METER (SFPARK) | NELSON RISING LN to GENE FRIEND WAY (1500 - 1599) | - | 145' NORTH OF GENE FRIENDLY WAY | - | - | - | - | - | 23520 | 1405987200000 | -122.3910254 | 37.76918979 | - | 1405987200000 | - | D6 | - | OTHER GUIDE | GUIDE | G-S(SF).0058 | 18X18 | SUP1 | LIGHT POLE | IS | 1517577120000 | 04TH ST | 1500 - 1599 4TH ST | 1500 - 1599 04TH ST | 1500 4TH ST | - | GENE FRIEND WAY | GENE FRIEND WAY |
| 6449 | N/A | Point | 1 | 1 | 543 - 599 | - | S242797 | 543-599 WALLER ST | 543-599 WALLER ST | F | F | - | F | 13364000 | 13364000 | - | - | SOUTH SIDE | - | - | - | - | POTOMAC ST | POTOMAC ST | 76226 | 76226 | 37.77080807 | -122.43313221 | - | - | 1710539427000 | MTA | BIKE RACK | POTOMAC ST to PIERCE ST (543 - 599) | 05622 | 6FT. WEST OF EPL# 557 WALLER ST. | - | - | - | - | - | 23521 | 1519819200000 | -122.43313221 | 37.77080807 | - | 1519776000000 | - | D5 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1517840940000 | WALLER ST | 543 - 599 WALLER ST | 543 - 599 WALLER ST | 543 WALLER ST | - | PIERCE ST | PIERCE ST |
| 6450 | N/A | Point | 1 | - | - | - | S242860 | 700-799 MORSE ST | - | F | F | - | F | 9397000 | 9397000 | - | - | WEST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | - | - | 76227 | 76227 | 37.7106662 | -122.44725935 | - | - | 1742910926000 | middleware_editor | SCHOOL (SYM)/SCHOOL | - | - | OPP DRIVEWAY TO CHRISTIAN SCHOOL | - | - | - | - | - | 23522 | 1100678400000 | -122.44725935 | 37.7106662 | - | 1520409600000 | - | D11 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1517989620000 | MORSE ST | 700-799 MORSE ST | MORSE 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 meters