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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15376 | N/A | Point | 1 | 1 | 16 - 99 | - | S228935 | 16-99 ARGUELLO BLVD | 16-99 ARGUELLO BLVD | F | F | - | F | 2414000 | 2414000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | JACKSON ST | JACKSON ST | 66711 | 66711 | 37.78885309 | -122.45942008 | - | - | 1715130170000 | middleware_editor | RIGHT LANE MUST TURN RIGHT | JACKSON ST to PRESIDIO TER \ WASHINGTON ST (16 - 99) | - | 105' NORTH OF PRESIDIO TER | - | - | - | - | - | 32451 | 1474029240000 | -122.45942008 | 37.78885309 | - | 1473984000000 | - | D2 | - | OTHER REGULATORY | REG | R3-7.0005 | 30X30 | SUP1 | 2IN IRON POST | IS | 1473933780000 | ARGUELLO BLVD | 16 - 99 ARGUELLO BLVD | 16 - 99 ARGUELLO BLVD | 16 ARGUELLO BLVD | - | PRESIDIO TER \ WASHINGTON ST | PRESIDIO TER \ WASHINGTON ST |
| 15377 | N/A | Point | 1 | 1 | 16 - 99 | - | S228937 | 16-99 ARGUELLO BLVD | 16-99 ARGUELLO BLVD | F | F | - | F | 2414000 | 2414000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | JACKSON ST | JACKSON ST | 66712 | 66712 | 37.78885309 | -122.45942008 | - | - | 1715130180000 | middleware_editor | EXCEPT BIKE (SYM) | JACKSON ST to PRESIDIO TER \ WASHINGTON ST (16 - 99) | - | 105' NORTH OF PRESIDIO TER | - | - | - | - | - | 32452 | 1474029360000 | -122.45942008 | 37.78885309 | - | 1473984000000 | - | D2 | - | OTHER REGULATORY | REG | R(SF).0362 | 24X18 | SUP1 | 2IN IRON POST | IS | 1473934140000 | ARGUELLO BLVD | 16 - 99 ARGUELLO BLVD | 16 - 99 ARGUELLO BLVD | 16 ARGUELLO BLVD | - | PRESIDIO TER \ WASHINGTON ST | PRESIDIO TER \ WASHINGTON ST |
| 15378 | N/A | Point | 1 | 1 | 16 - 99 | - | S228938 | 16-99 ARGUELLO BLVD | 16-99 ARGUELLO BLVD | F | F | - | F | 2414000 | 2414000 | - | - | EAST SIDE | - | - | - | - | JACKSON ST | JACKSON ST | 66713 | 66713 | 37.78885309 | -122.45942008 | - | - | 1715115530000 | middleware_editor | RIGHT LANE MUST TURN RIGHT | JACKSON ST to PRESIDIO TER \ WASHINGTON ST (16 - 99) | - | SPL #40 | - | - | - | - | - | 32453 | 1474029480000 | -122.45942008 | 37.78885309 | - | 1473984000000 | - | D2 | - | OTHER REGULATORY | REG | R3-7.0005 | 30X30 | SUP1 | 2IN IRON POST | IS | 1473934260000 | ARGUELLO BLVD | 16 - 99 ARGUELLO BLVD | 16 - 99 ARGUELLO BLVD | 16 ARGUELLO BLVD | - | PRESIDIO TER \ WASHINGTON ST | PRESIDIO TER \ WASHINGTON ST |
| 15379 | N/A | Point | - | - | - | - | S234705 | FRANKLIN ST: TURK ST | - | T | T | - | F | 25185000 | 25185000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TURK ST | TURK ST | 66714 | 66714 | 37.7817518 | -122.42228665 | FRANKLIN ST \ TURK ST | FRANKLIN ST \ TURK ST | 1710539427000 | MTA | FRANKLIN ST | TURK ST intersection | - | <<<<800 | - | - | - | - | - | 32454 | 1502982420000 | -122.42228665 | 37.7817518 | - | 1502928000000 | - | D5 | - | STREET NAME | GUIDE | D3-2.0159 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1490784840000 | FRANKLIN ST | - | - | - | - | - | - |
| 15380 | N/A | Point | - | - | - | - | S234710 | EDDY ST: FRANKLIN ST | - | T | T | - | F | 25191000 | 25191000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FRANKLIN ST | EDDY ST | 66715 | 66715 | 37.78268537 | -122.42246374 | EDDY ST \ FRANKLIN ST | FRANKLIN ST \ EDDY ST | 1710539427000 | MTA | FRANKLIN ST | EDDY ST intersection | - | - | - | - | - | - | - | 32455 | 1134172800000 | -122.42246374 | 37.78268537 | - | 1503014400000 | - | D5 | - | STREET NAME | GUIDE | D3-2.0159 | 72X18 | SUP1 | LIGHT POLE | IS | 1490785560000 | FRANKLIN ST | - | - | - | - | - | - |
| 15381 | N/A | Point | - | - | - | - | S234711 | EDDY ST: FRANKLIN ST | - | T | T | - | F | 25191000 | 25191000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FRANKLIN ST | EDDY ST | 66716 | 66716 | 37.78268537 | -122.42246374 | EDDY ST \ FRANKLIN ST | FRANKLIN ST \ EDDY ST | 1710539427000 | MTA | FRANKLIN ST | EDDY ST intersection | - | - | - | - | - | - | - | 32456 | 1134172800000 | -122.42246374 | 37.78268537 | - | 1503532800000 | - | D5 | - | STREET NAME | GUIDE | D3-2.0159 | 72X18 | SUP1 | LIGHT POLE | IS | 1490785680000 | FRANKLIN ST | - | - | - | - | - | - |
| 15382 | N/A | Point | - | - | - | - | S234713 | EDDY ST: FRANKLIN ST | - | T | T | - | F | 25191000 | 25191000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | FRANKLIN ST | EDDY ST | 66717 | 66717 | 37.78268537 | -122.42246374 | EDDY ST \ FRANKLIN ST | FRANKLIN ST \ EDDY ST | 1710539427000 | MTA | NO LEFT TURN (SYM) | EDDY ST intersection | - | - | - | - | - | - | - | 32457 | 1134172800000 | -122.42246374 | 37.78268537 | - | 1503014400000 | - | D5 | - | NO LEFT TURN | REG | R3-2.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1490785860000 | FRANKLIN ST | - | - | - | - | - | - |
| 15383 | N/A | Point | - | - | - | - | S234714 | EDDY ST: FRANKLIN ST | - | F | F | - | F | 25191000 | 25191000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FRANKLIN ST | EDDY ST | 66718 | 66718 | 37.78268537 | -122.42246374 | EDDY ST \ FRANKLIN ST | FRANKLIN ST \ EDDY ST | 1710539427000 | MTA | NO RIGHT TURN (SYM) | EDDY ST intersection | - | - | - | - | - | - | - | 32458 | 1134172800000 | -122.42246374 | 37.78268537 | - | 1491523200000 | - | D5 | - | NO RIGHT TURN | REG | R3-1.0002 | 30X30 | SUP1 | SIGNAL POLE | IS | 1490786040000 | FRANKLIN ST | - | - | - | - | - | - |
| 15384 | N/A | Point | - | - | - | - | S234715 | FRANKLIN ST: EDDY ST | - | T | T | - | F | 25191000 | 25191000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | FRANKLIN ST | EDDY ST | 66719 | 66719 | 37.78268537 | -122.42246374 | EDDY ST \ FRANKLIN ST | FRANKLIN ST \ EDDY ST | 1710539427000 | MTA | EDDY ST | EDDY ST intersection | - | - | - | - | - | - | - | 32459 | 1320278400000 | -122.42246374 | 37.78268537 | - | 1503014400000 | - | D5 | - | STREET NAME | GUIDE | D3-2.0137 | 72X18 | SUP1 | OVERHEAD MAST ARM | IS | 1490786220000 | FRANKLIN ST | - | - | - | - | - | - |
| 15385 | N/A | Point | 1 | 1 | 200 - 299 | - | S231952 | 200-299 DAY ST | 200-299 DAY ST | F | F | - | F | 4620000 | 4620000 | - | - | SOUTH SIDE | - | - | - | - | CHURCH ST | CHURCH ST | 66721 | 66721 | 37.74283081 | -122.42769988 | - | - | 1734376166000 | middleware_editor | NPRK 8AM-10AM 2ND & 4TH FRI OF MONTH STCL | CHURCH ST to SANCHEZ ST (200 - 299) | - | OPP#228 | - | - | - | - | - | 32460 | 1222300800000 | -122.42769988 | 37.74283081 | - | 1485216000000 | - | D8 | - | STREET CLEANING | REG | R30B(CA).0254 | 18X18 | SUP2 | 2IN IRON POST | IS | 1482394740000 | DAY ST | 200 - 299 DAY ST | 200 - 299 DAY ST | 200 DAY ST | - | SANCHEZ ST | SANCHEZ ST |
| 15386 | N/A | Point | 1 | 1 | 100 - 199 | - | S231954 | 100-199 COLLINGWOOD ST | 100-199 COLLINGWOOD ST | F | F | - | F | 4270000 | 4270000 | - | - | WEST SIDE | - | - | - | - | 18TH ST | 18TH ST | 66723 | 66723 | 37.76002333 | -122.4360354 | - | - | 1719623146000 | middleware_editor | 2 HR PRK 8AM-9PM MON-FRI EXC "S" PERMITS | 18TH ST to 19TH ST (100 - 199) | - | 50 FT SOUTH OF 18TH ST | - | - | - | - | - | 32461 | 1585828500000 | -122.4360354 | 37.76002333 | - | - | - | D8 | - | PARKING:RPP | REG | R32C(CA).0126 | 18X21 | SUP2 | LIGHT POLE | IS | 1482397020000 | COLLINGWOOD ST | 100 - 199 COLLINGWOOD ST | 100 - 199 COLLINGWOOD ST | 100 COLLINGWOOD ST | - | 19TH ST | 19TH ST |
| 15387 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S232131 | 1700-1799 16TH ST | 1700-1799 16TH ST | F | F | - | F | 711000 | 711000 | - | - | SOUTH SIDE | - | - | - | - | KANSAS ST | KANSAS ST | 66724 | 66724 | 37.76598763 | -122.4041332 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM TUE THUR STCL | KANSAS ST to VERMONT ST (1700 - 1799) | - | 119' WEST OF KANSAS ST | - | - | - | - | - | 32462 | - | -122.4041332 | 37.76598763 | - | - | - | D10 | - | STREET CLEANING | REG | R30B(CA).0058 | 18X18 | SUP1 | MUNI POLE | IS | 1483001160000 | 16TH ST | 1700 - 1799 16TH ST | 1700 - 1799 16TH ST | 1700 16TH ST | - | VERMONT ST | VERMONT ST |
| 15388 | N/A | Point | 1 | 1 | 2700 - 2799 | - | S235336 | 2700-2799 HYDE ST | 2700-2799 HYDE ST | F | F | - | F | 7151000 | 7151000 | - | - | EAST SIDE | - | - | - | - | NORTH POINT ST | NORTH POINT ST | 67322 | 67322 | 37.806189 | -122.42046451 | - | - | 1710539427000 | MTA | BIKE RACK | NORTH POINT ST to BEACH ST (2700 - 2799) | 20165440 | 2FT6" SOUTH OF SPL#2718 3FT FROM CRUB | - | - | - | - | - | 32463 | 1288051200000 | -122.42046451 | 37.806189 | - | 1493337600000 | - | D2 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BARRICADE | IS | 1492513920000 | HYDE ST | 2700 - 2799 HYDE ST | 2700 - 2799 HYDE ST | 2700 HYDE ST | - | BEACH ST | BEACH ST |
| 15389 | N/A | Point | - | - | - | - | S230301 | BANKS ST: TOMPKINS AVE | - | F | F | - | F | 21052000 | 21052000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TOMPKINS AVE | BANKS ST | 67323 | 67323 | 37.73703469 | -122.41285757 | BANKS ST \ TOMPKINS AVE | TOMPKINS AVE \ BANKS ST | 1746472949000 | middleware_editor | ALL WAY | BANKS ST intersection | - | BELOW EXISTING STOP SIGN | - | - | - | - | - | 32464 | 125308800000 | -122.41285757 | 37.73703469 | - | 1490166000000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1477570680000 | TOMPKINS AVE | - | - | - | - | - | - |
| 15390 | N/A | Point | - | - | - | - | S228383 | LINDA ST: 19TH ST | - | F | F | - | F | 25672000 | 25672000 | - | - | EAST SIDE | - | - | - | - | 19TH ST | 19TH ST | 67325 | 67325 | 37.76001342 | -122.42287938 | LINDA ST \ 19TH ST | LINDA ST \ 19TH ST | 1725930030000 | middleware_editor | TANP ANY TIME | 19TH ST intersection | - | OPP.# 40 LINDA ST | - | - | - | - | - | 32465 | - | -122.42287938 | 37.76001342 | - | - | - | D8 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP2 | 2IN IRON POST | IS | 1472113200000 | LINDA ST | - | - | - | - | - | - |
| 15391 | N/A | Point | 1 | 1 | 1 - 99 | - | S228384 | 1-99 LINDA ST | 1-99 LINDA ST | F | F | - | F | 8388000 | 8388000 | - | - | EAST SIDE | - | - | - | - | 18TH ST | 18TH ST | 67326 | 67326 | 37.76081825 | -122.42293163 | - | - | 1710539427000 | MTA | NPRK ANY TIME | 18TH ST to 19TH ST (1 - 99) | - | 100FT. NORTH OF 19TH ST. | - | - | - | - | - | 32466 | - | -122.42293163 | 37.76081825 | - | - | - | D8 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP2 | 2IN IRON POST | IS | 1472113680000 | LINDA ST | 1 - 99 LINDA ST | 1 - 99 LINDA ST | 1 LINDA ST | - | 19TH ST | 19TH ST |
| 15392 | N/A | Point | - | 1 | 200 - 216 | - | S231532 | 200-216 DIVISION ST | 200-216 DIVISION ST | T | T | - | F | 33032000 | 4844000 | - | - | SOUTH SIDE | - | - | - | - | UTAH ST | 09TH ST | 67327 | 67327 | 37.7693547 | -122.40653685 | DIVISION ST \ UTAH ST | - | 1710539427000 | MTA | NPRK ANY TIME VEH OVER 22' LONG OR 7' HIGH 12AM-6AM EVERYDAY | 09TH ST to UTAH ST (200 - 216) | - | 135' WEST OF SAN BRUNO | - | - | - | - | - | 32467 | 1481673600000 | -122.40653685 | 37.7693547 | - | 1481673600000 | - | D10 | - | PARKING:NPRK ANY TIME | REG | R30(SF).0572 | 18X18 | SUP1 | LIGHT POLE | IS | 1481023680000 | DIVISION ST | - | 200 - 216 DIVISION ST | 200 DIVISION ST | - | - | UTAH ST |
| 15393 | N/A | Point | - | 1 | 200 - 216 | - | S231536 | 200-216 DIVISION ST | 200-216 DIVISION ST | T | T | - | F | 33032000 | 4844000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | UTAH ST | 09TH ST | 67328 | 67328 | 37.7693547 | -122.40653685 | DIVISION ST \ UTAH ST | - | 1711748105000 | middleware_editor | BICYCLES (SYM) PEDESTRIAN (SYM) | 09TH ST to UTAH ST (200 - 216) | - | 135' WEST OF SAN BRUNO | - | - | - | - | - | 32468 | - | -122.40653685 | 37.7693547 | - | - | 1704979800000 | D10 | - | OTHER WARNING | WARNING | W11-1(SF).0008 | 30X30 | SUP1 | LIGHT POLE | RETD | 1481024640000 | DIVISION ST | - | 200 - 216 DIVISION ST | 200 DIVISION ST | - | - | UTAH ST |
| 15394 | N/A | Point | - | - | - | - | S231540 | CLEMENT ST: 27TH AVE | - | F | F | - | F | 27559000 | 27559000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 27TH AVE | CLEMENT ST | 67329 | 67329 | 37.7820023563454 | -122.486899830396 | CLEMENT ST \ 27TH AVE | 27TH AVE \ CLEMENT ST | 1753822679000 | middleware_editor | ALL WAY | CLEMENT ST intersection | - | 0 / 00 | - | - | - | - | - | 32469 | -255715200000 | -122.48701979 | 37.78192358 | - | 1485158400000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 3IN IRON POST | IS | 1481025240000 | 27TH AVE | - | - | - | - | - | - |
| 15395 | N/A | Point | - | 1 | 200 - 216 | LEFT ARROW | S231541 | 200-216 DIVISION ST | 200-216 DIVISION ST | F | F | - | F | 4844000 | 4844000 | - | - | SOUTH SIDE | - | - | - | - | 09TH ST | 09TH ST | 67330 | 67330 | 37.7693547 | -122.40653685 | - | - | 1710539427000 | MTA | TANSAT | 09TH ST to UTAH ST (200 - 216) | - | 75' WEST OF SAN BRUNO | - | - | - | - | - | 32470 | 1481500800000 | -122.40653685 | 37.7693547 | - | 1481500800000 | - | D10 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1481026080000 | DIVISION ST | 200 - 216 DIVISION ST | 200 - 216 DIVISION ST | 200 DIVISION ST | - | UTAH ST | UTAH ST |
| 15396 | N/A | Point | - | 1 | 126 - 195 | RIGHT ARROW | S231547 | 126-195 DIVISION ST | 126-195 DIVISION ST | F | F | - | F | 4842000 | 4842000 | - | - | SOUTH SIDE | - | - | - | - | VERMONT ST | VERMONT ST | 67335 | 67335 | 37.76968676 | -122.40546471 | - | - | 1754336188000 | middleware_editor | TANSAT | VERMONT ST to SAN BRUNO AVE (126 - 195) | - | 190FT WEST OF VERMONT | - | - | - | - | - | 32471 | 1481665260000 | -122.40546471 | 37.76968676 | - | 1481616000000 | - | D10 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | 2IN IRON POST | IS | 1481027280000 | DIVISION ST | 126 - 195 DIVISION ST | 126 - 195 DIVISION ST | 126 DIVISION ST | - | SAN BRUNO AVE | SAN BRUNO AVE |
| 15397 | N/A | Point | - | - | - | - | S231548 | SAN BRUNO AVE: DIVISION ST | - | F | F | - | F | 23880000 | 23880000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | SAN BRUNO AVE | DIVISION ST | 67336 | 67336 | 37.76965901 | -122.4059392 | DIVISION ST \ SAN BRUNO AVE | SAN BRUNO AVE \ DIVISION ST | 1711748111000 | middleware_editor | CROSS TRAFFIC DOES NOT STOP | DIVISION ST intersection | - | - | - | - | - | - | - | 32472 | - | -122.4059392 | 37.76965901 | - | - | 1704962700000 | D10 | - | OTHER WARNING | WARNING | W4-4P.0001 | 24X12 | SUP1 | 2IN IRON POST | RETD | 1481027940000 | SAN BRUNO AVE | - | - | - | - | - | - |
| 15398 | N/A | Point | 1 | 1 | 350 - 399 | - | S231549 | 350-399 LAGUNA ST | 350-399 LAGUNA ST | F | F | - | F | 7945000 | 7945000 | - | - | EAST SIDE | - | - | - | - | LILY ST | LILY ST | 67337 | 67337 | 37.77436555 | -122.42584141 | - | - | 1710539427000 | MTA | NPRK 12NN-2PM WED STCL | LILY ST to OAK ST (350 - 399) | - | 96' NORTH OF LILY ST. | - | - | - | - | - | 32473 | 1481118180000 | -122.42584141 | 37.77436555 | - | 1481068800000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0086 | 18X18 | SUP1 | 2IN IRON POST | IS | 1481028120000 | LAGUNA ST | 350 - 399 LAGUNA ST | 350 - 399 LAGUNA ST | 350 LAGUNA ST | - | OAK ST | OAK ST |
| 15399 | N/A | Point | - | - | - | - | S231550 | SAN BRUNO AVE: DIVISION ST | - | F | F | - | F | 23880000 | 23880000 | - | - | CENTER ISLAND, S LINE, SOUTHBOUND | - | - | - | - | DIVISION ST | DIVISION ST | 67338 | 67338 | 37.76965901 | -122.4059392 | SAN BRUNO AVE \ DIVISION ST | SAN BRUNO AVE \ DIVISION ST | 1710539427000 | MTA | KEEP RIGHT (SYM) | DIVISION ST intersection | - | - | - | - | - | - | - | 32474 | 381456000000 | -122.4059392 | 37.76965901 | - | 1481068800000 | - | D10 | - | OTHER REGULATORY | REG | R4-7A.0002 | 24X30 | SUP1 | SIGNAL POLE | IS | 1481028120000 | SAN BRUNO AVE | - | - | - | - | - | - |
| 15400 | N/A | Point | - | - | - | - | S231552 | SAN BRUNO AVE: DIVISION ST | - | F | F | - | F | 4844000 | 23880000 | - | - | CENTER ISLAND, W LINE, EASTBOUND | - | - | - | - | 09TH ST | DIVISION ST | 67339 | 67339 | 37.76965901 | -122.4059392 | - | SAN BRUNO AVE \ DIVISION ST | 1711748138000 | middleware_editor | (RA) TURNING VEHICLES YIELD (SYM) TO PED & BIKE (SYM) | DIVISION ST intersection | - | - | - | - | - | - | - | 32475 | - | -122.4059392 | 37.76965901 | - | - | 1704974400000 | D10 | - | PEDESTRIAN | REG | R10-15.0003 | 30X30 | SUP1 | 2IN IRON POST | RETD | 1481028420000 | SAN BRUNO AVE | 200 - 216 DIVISION ST | - | - | - | UTAH ST | - |
| 15401 | N/A | Point | 1 | 1 | 100 - 199 | RIGHT ARROW | S232584 | PNDG ALEMANY BLVD | 100-199 BOYLSTON ST | F | F | - | F | 3056000 | 3056000 | - | - | NORTH SIDE | - | - | - | - | SWEENY ST | SWEENY ST | 68398 | 68398 | 37.73176135 | -122.41084976 | - | - | 1710539427000 | MTA | TANSAT | SWEENY ST to HALE ST (100 - 199) | - | 70 FT WEST OF PUTNAM | - | - | - | - | - | 32476 | 1484307720000 | -122.41084976 | 37.73176135 | - | 1484265600000 | - | D9 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP2 | 2IN IRON POST | IS | 1484218500000 | BOYLSTON ST | PNDG ALEMANY BLVD | 100 - 199 BOYLSTON ST | - | - | HALE ST | HALE ST |
| 15402 | N/A | Point | 1 | 1 | 100 - 199 | - | S232585 | PNDG ALEMANY BLVD | 100-199 BOYLSTON ST | F | F | - | F | 3056000 | 3056000 | - | - | NORTH SIDE | - | - | - | - | SWEENY ST | SWEENY ST | 68399 | 68399 | 37.73176135 | -122.41084976 | - | - | 1710539427000 | MTA | NPRK 7AM-8AM THUR STCL | SWEENY ST to HALE ST (100 - 199) | - | 15`EAST OF #316 | - | - | - | - | - | 32477 | 1484307840000 | -122.41084976 | 37.73176135 | - | 1484265600000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0218 | 18X18 | SUP2 | LIGHT POLE | IS | 1484218620000 | BOYLSTON ST | PNDG ALEMANY BLVD | 100 - 199 BOYLSTON ST | - | - | HALE ST | HALE ST |
| 15403 | N/A | Point | 1 | 1 | 100 - 199 | - | S232586 | PNDG ALEMANY BLVD | 100-199 BOYLSTON ST | F | F | - | F | 3056000 | 3056000 | - | - | NORTH SIDE | - | - | - | - | SWEENY ST | SWEENY ST | 68400 | 68400 | 37.73176135 | -122.41084976 | - | - | 1710539427000 | MTA | NPRK 7AM-8AM THUR STCL | SWEENY ST to HALE ST (100 - 199) | - | IFO#334 | - | - | - | - | - | 32478 | 1484307900000 | -122.41084976 | 37.73176135 | - | 1484265600000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0218 | 18X18 | SUP2 | LIGHT POLE | IS | 1484218800000 | BOYLSTON ST | PNDG ALEMANY BLVD | 100 - 199 BOYLSTON ST | - | - | HALE ST | HALE ST |
| 15404 | N/A | Point | 1 | 1 | 100 - 199 | - | S232587 | PNDG ALEMANY BLVD | 100-199 BOYLSTON ST | F | F | - | F | 3056000 | 3056000 | - | - | NORTH SIDE | - | - | - | - | SWEENY ST | SWEENY ST | 68401 | 68401 | 37.73176135 | -122.41084976 | - | - | 1710539427000 | MTA | NPRK 7AM-8AM THUR STCL | SWEENY ST to HALE ST (100 - 199) | - | IFO#374 | - | - | - | - | - | 32479 | 1484307960000 | -122.41084976 | 37.73176135 | - | 1484265600000 | - | D9 | - | STREET CLEANING | REG | R30B(CA).0218 | 18X18 | SUP2 | LIGHT POLE | IS | 1484218860000 | BOYLSTON ST | PNDG ALEMANY BLVD | 100 - 199 BOYLSTON ST | - | - | HALE ST | HALE ST |
| 15405 | N/A | Point | 1 | 1 | 1551 - 1650 | RIGHT ARROW | S232323 | 1551-1650 VALENCIA ST | 1551-1650 VALENCIA ST | F | F | - | F | 13076000 | 13076000 | - | - | EAST SIDE | - | - | - | - | CESAR CHAVEZ ST | CESAR CHAVEZ ST | 68402 | 68402 | 37.74735066 | -122.42020459 | - | - | 1741274918000 | middleware_editor | (45 LA-DN) | CESAR CHAVEZ ST to TIFFANY AVE (1551 - 1650) | - | 233FT. NORTH OF DUNCAN ST(AT PAINT MARK) | - | - | - | - | - | 32480 | 1483985520000 | -122.42020459 | 37.74735066 | - | 1483948800000 | - | D9 | - | OTHER WARNING | WARNING | W16-7P.0002 | 24X24 | SUP2 | 2IN IRON POST | IS | 1483611300000 | VALENCIA ST | 1551 - 1650 VALENCIA ST | 1551 - 1650 VALENCIA ST | 1551 VALENCIA ST | - | TIFFANY AVE | TIFFANY AVE |
| 15406 | N/A | Point | 1 | 1 | 1551 - 1650 | LEFT ARROW | S232324 | 1551-1650 VALENCIA ST | 1551-1650 VALENCIA ST | F | F | - | F | 13076000 | 13076000 | - | - | EAST SIDE | - | - | - | - | CESAR CHAVEZ ST | CESAR CHAVEZ ST | 68403 | 68403 | 37.74735066 | -122.42020459 | - | - | 1741388303000 | middleware_editor | TANP ANY TIME | CESAR CHAVEZ ST to TIFFANY AVE (1551 - 1650) | - | (LA) SIGN 79FT. SOUTH OF CEZAR CHAVEZ ST | - | - | - | - | - | 32481 | 1483735680000 | -122.42020459 | 37.74735066 | - | 1483689600000 | - | D9 | - | TOW (TANP ANY TIME) | REG | R26K(CA).0038 | 18X21 | SUP2 | 2IN IRON POST | IS | 1483611660000 | VALENCIA ST | 1551 - 1650 VALENCIA ST | 1551 - 1650 VALENCIA ST | 1551 VALENCIA ST | - | TIFFANY AVE | TIFFANY AVE |
| 15407 | N/A | Point | - | - | - | - | S232331 | CASTRO ST: 29TH ST \ DAY ST | - | F | F | - | F | 22004000 | 22004000 | - | - | NORTH WEST CORNER | - | - | - | - | 29TH ST \ CASTRO ST | CASTRO ST \ DAY ST | 68404 | 68404 | 37.743296 | -122.43331953 | DAY ST \ 29TH ST \ CASTRO ST | 29TH ST \ CASTRO ST \ DAY ST | 1752254730000 | middleware_editor | ALL WAY | CASTRO ST \ DAY ST intersection | - | OF CASTRO & 29TH ST. | - | - | - | - | - | 32482 | 1488843240000 | -122.43331953 | 37.743296 | - | 1488787200000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1483615980000 | 29TH ST | - | - | - | - | - | - |
| 15408 | N/A | Point | - | - | - | - | S232332 | CASTRO ST: 29TH ST \ DAY ST | - | F | F | - | F | 22004000 | 22004000 | - | - | SOUTH EAST CORNER | - | - | - | - | 29TH ST \ CASTRO ST | CASTRO ST \ DAY ST | 68405 | 68405 | 37.743296 | -122.43331953 | DAY ST \ 29TH ST \ CASTRO ST | 29TH ST \ CASTRO ST \ DAY ST | 1752254007000 | middleware_editor | ALL WAY | CASTRO ST \ DAY ST intersection | - | OF CASTRO & 29TH ST. | - | - | - | - | - | 32483 | 1488843300000 | -122.43331953 | 37.743296 | - | 1488787200000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1483616220000 | 29TH ST | - | - | - | - | - | - |
| 15409 | N/A | Point | - | - | - | - | S232333 | 29TH ST: CASTRO ST \ DAY ST | - | F | F | - | F | 22004000 | 22004000 | - | - | SOUTH WEST CORNER | - | - | - | - | 29TH ST \ CASTRO ST | CASTRO ST \ DAY ST | 68406 | 68406 | 37.743296 | -122.43331953 | DAY ST \ 29TH ST \ CASTRO ST | 29TH ST \ CASTRO ST \ DAY ST | 1752508966000 | middleware_editor | ALL WAY | CASTRO ST \ DAY ST intersection | - | OF 29TH ST & CASTRO ST-F/E/B/T | - | - | - | - | - | 32484 | 1488838440000 | -122.43331953 | 37.743296 | - | 1488787200000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 3IN IRON POST | IS | 1483616580000 | 29TH ST | - | - | - | - | - | - |
| 15410 | N/A | Point | - | - | - | - | S232335 | DAY ST: 29TH ST \ CASTRO ST | - | F | F | - | F | 22004000 | 22004000 | - | - | SOUTH EAST CORNER | - | - | - | - | 29TH ST \ CASTRO ST | CASTRO ST \ DAY ST | 68407 | 68407 | 37.743296 | -122.43331953 | DAY ST \ 29TH ST \ CASTRO ST | 29TH ST \ CASTRO ST \ DAY ST | 1718114091000 | middleware_editor | ALL WAY | CASTRO ST \ DAY ST intersection | - | OF DAY ST. & 29TH ST-F/N/B/T | - | - | - | - | - | 32485 | 1488809460000 | -122.43331953 | 37.743296 | - | 1488758400000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1483616820000 | 29TH ST | - | - | - | - | - | - |
| 15411 | N/A | Point | - | - | - | - | S232337 | COLLINGWOOD ST: 19TH ST | - | F | F | - | F | 25812000 | 25812000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | COLLINGWOOD ST | COLLINGWOOD ST | 68409 | 68409 | 37.75922266 | -122.4359567 | 19TH ST \ COLLINGWOOD ST | 19TH ST \ COLLINGWOOD ST | 1715648363000 | middleware_editor | ALL WAY | COLLINGWOOD ST intersection | - | BELOW STOP SIGN | - | - | - | - | - | 32486 | 67910400000 | -122.4359567 | 37.75922266 | - | 1488499200000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | MUNI POLE | IS | 1483619940000 | 19TH ST | - | - | - | - | - | - |
| 15412 | N/A | Point | - | - | - | - | S232338 | COLLINGWOOD ST: 19TH ST | - | F | F | - | F | 25812000 | 25812000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | COLLINGWOOD ST | COLLINGWOOD ST | 68410 | 68410 | 37.75922266 | -122.4359567 | 19TH ST \ COLLINGWOOD ST | 19TH ST \ COLLINGWOOD ST | 1715648361000 | middleware_editor | ALL WAY | COLLINGWOOD ST intersection | - | BELOW STOP SIGN | - | - | - | - | - | 32487 | 67910400000 | -122.4359567 | 37.75922266 | - | 1488499200000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1483620000000 | 19TH ST | - | - | - | - | - | - |
| 15413 | N/A | Point | - | - | - | - | S232339 | 19TH ST: COLLINGWOOD ST | - | F | F | - | F | 25812000 | 25812000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | COLLINGWOOD ST | COLLINGWOOD ST | 68411 | 68411 | 37.75922266 | -122.4359567 | 19TH ST \ COLLINGWOOD ST | 19TH ST \ COLLINGWOOD ST | 1715648391000 | middleware_editor | ALL WAY | COLLINGWOOD ST intersection | - | BELOW STOP SIGN | - | - | - | - | - | 32488 | 67910400000 | -122.4359567 | 37.75922266 | - | 1488499200000 | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1483620060000 | 19TH ST | - | - | - | - | - | - |
| 15414 | N/A | Point | 1 | 1 | 500 - 599 | - | S234922 | 500-599 NEVADA ST | 500-599 NEVADA ST | F | F | - | F | 9539000 | 9539000 | - | - | WEST SIDE | - | - | - | - | OGDEN AVE | OGDEN AVE | 68412 | 68412 | 37.73521205 | -122.4117749 | - | - | 1710539427000 | MTA | WHEEL STOP | OGDEN AVE to CRESCENT AVE (500 - 599) | - | 39 FT SOUTH OF NW CORNOR | - | - | - | - | - | 32489 | 1491489360000 | -122.4117749 | 37.73521205 | - | 1491436800000 | - | D9 | - | OTHER WARNING | WARNING | W(SF).0072 | 36X08 | SUP2 | EPOXY | IS | 1491402360000 | NEVADA ST | 500 - 599 NEVADA ST | 500 - 599 NEVADA ST | 500 NEVADA ST | - | CRESCENT AVE | CRESCENT AVE |
| 15415 | N/A | Point | 1 | 1 | 648 - 699 | - | S234923 | 648-699 PERALTA AVE | 648-699 PERALTA AVE | F | F | - | F | 10350000 | 10350000 | - | - | WEST SIDE | - | - | - | - | MAYFLOWER ST | MAYFLOWER ST | 68413 | 68413 | 37.74180847 | -122.40881538 | - | - | 1710539427000 | MTA | WHEEL STOP | MAYFLOWER ST to POWHATTAN AVE (648 - 699) | - | 4FT. SOUTH OF N-LINE MAYFLOWER | - | - | - | - | - | 32490 | 1491307200000 | -122.40881538 | 37.74180847 | - | 1491264000000 | - | D9 | - | OTHER WARNING | WARNING | W(SF).0072 | 36X08 | SUP2 | EPOXY | IS | 1491405060000 | PERALTA AVE | 648 - 699 PERALTA AVE | 648 - 699 PERALTA AVE | 648 PERALTA AVE | - | POWHATTAN AVE | POWHATTAN AVE |
| 15416 | N/A | Point | 1 | 1 | 400 - 599 | - | S232640 | 400-599 PARNASSUS AVE | 400-599 PARNASSUS AVE | F | F | - | F | 10293000 | 10293000 | - | - | SOUTH SIDE | - | - | - | - | HILLWAY AVE | HILLWAY AVE | 68438 | 68438 | 37.76336907 | -122.45822957 | - | - | 1710539427000 | MTA | NPRK 6AM-7AM TUE STCL | HILLWAY AVE to 03RD AVE (400 - 599) | - | 22' WEST OF 521 ENTRANCE (OP.WPL 530) | - | - | - | - | - | 32491 | 1501076940000 | -122.45822957 | 37.76336907 | - | 1501718400000 | - | D5 | - | STREET CLEANING | REG | R30B(CA).0177 | 18X18 | SUP1 | LIGHT POLE | IS | 1484647200000 | PARNASSUS AVE | 400 - 599 PARNASSUS AVE | 400 - 599 PARNASSUS AVE | 400 PARNASSUS AVE | - | 03RD AVE | 03RD AVE |
| 15417 | N/A | Point | 1 | 1 | 634 - 675 | - | S237065 | 634-675 CAMPBELL AVE | 634-675 CAMPBELL AVE | F | F | - | F | 3646000 | 3646000 | - | - | NORTH SIDE | - | - | - | - | ERVINE ST | ERVINE ST | 71423 | 71423 | 37.71616784 | -122.40953072 | - | - | 1715608908000 | middleware_editor | NPRK 12NN-3PM MON STCL | ERVINE ST to ALBERTA ST (634 - 675) | - | WPL634 | - | - | - | - | - | 32492 | 1498660800000 | -122.40953072 | 37.71616784 | - | 1498608000000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0088 | 18X18 | SUP1 | 2IN IRON POST | IS | 1498475520000 | CAMPBELL AVE | 634 - 675 CAMPBELL AVE | 634 - 675 CAMPBELL AVE | 634 CAMPBELL AVE | - | ALBERTA ST | ALBERTA ST |
| 15418 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S237066 | 1500-1599 STOCKTON ST | 1500-1599 STOCKTON ST | F | F | - | F | 12213000 | 12213000 | - | - | NORTH SIDE | - | - | - | - | COLUMBUS AVE \ GREEN ST | COLUMBUS AVE \ GREEN ST | 71424 | 71424 | 37.79996744 | -122.4091021 | - | - | 1710539427000 | MTA | FG 300 UR DELINEATOR (W) | COLUMBUS AVE \ GREEN ST to UNION ST (1500 - 1599) | - | X ST IS COLUMBUS | - | - | - | - | - | 32493 | 1444867200000 | -122.4091021 | 37.79996744 | - | 1444867200000 | - | D3 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1498476300000 | STOCKTON ST | 1500 - 1599 STOCKTON ST | 1500 - 1599 STOCKTON ST | 1500 STOCKTON ST | - | UNION ST | UNION ST |
| 15419 | N/A | Point | - | - | - | - | S233861 | GROVE ST: OCTAVIA ST | - | F | F | - | F | 25928000 | 25928000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 71472 | 71472 | 37.77760186 | -122.42480888 | GROVE ST \ OCTAVIA ST | GROVE ST \ OCTAVIA ST | 1743458663000 | middleware_editor | ALL WAY | OCTAVIA ST intersection | - | 0 / 0 | - | - | - | - | - | 32494 | 448617600000 | -122.42480888 | 37.77760186 | - | 1743458640000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | LIGHT POLE | IS | 1487846760000 | GROVE ST | - | - | - | - | - | - |
| 15420 | N/A | Point | - | - | - | - | S233863 | OCTAVIA ST: GROVE ST | - | F | F | - | F | 25928000 | 25928000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 71473 | 71473 | 37.77760186 | -122.42480888 | GROVE ST \ OCTAVIA ST | GROVE ST \ OCTAVIA ST | 1710539427000 | MTA | ALL WAY | OCTAVIA ST intersection | - | 0 / 00 | - | - | - | - | - | 32495 | -393033600000 | -122.42480888 | 37.77760186 | - | 1495497600000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1487847000000 | GROVE ST | - | - | - | - | - | - |
| 15421 | N/A | Point | - | - | - | - | S233865 | OCTAVIA ST: GROVE ST | - | F | F | - | F | 25928000 | 25928000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | OCTAVIA ST | OCTAVIA ST | 71474 | 71474 | 37.77760186 | -122.42480888 | GROVE ST \ OCTAVIA ST | GROVE ST \ OCTAVIA ST | 1710539427000 | MTA | ALL WAY | OCTAVIA ST intersection | - | 0 / 0 | - | - | - | - | - | 32496 | 399254400000 | -122.42480888 | 37.77760186 | - | 1591228800000 | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1487847240000 | GROVE ST | - | - | - | - | - | - |
| 15422 | N/A | Point | - | - | - | - | S233882 | TOCOLOMA AVE: LATHROP AVE | - | F | F | - | F | 20273000 | 20273000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TOCOLOMA AVE | TOCOLOMA AVE | 71475 | 71475 | 37.71045518 | -122.39856235 | LATHROP AVE \ TOCOLOMA AVE | LATHROP AVE \ TOCOLOMA AVE | 1710539427000 | MTA | ALL WAY | TOCOLOMA AVE intersection | - | - | - | - | - | - | - | 32497 | 957916800000 | -122.39856235 | 37.71045518 | - | 1495584000000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1487857680000 | LATHROP AVE | - | - | - | - | - | - |
| 15423 | N/A | Point | - | - | - | - | S233883 | LATHROP AVE: TOCOLOMA AVE | - | F | F | - | F | 20273000 | 20273000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | TOCOLOMA AVE | TOCOLOMA AVE | 71476 | 71476 | 37.71045518 | -122.39856235 | LATHROP AVE \ TOCOLOMA AVE | LATHROP AVE \ TOCOLOMA AVE | 1710539427000 | MTA | ALL WAY | TOCOLOMA AVE intersection | - | - | - | - | - | - | - | 32498 | 932342400000 | -122.39856235 | 37.71045518 | - | 1495584000000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | LIGHT POLE | IS | 1487857800000 | LATHROP AVE | - | - | - | - | - | - |
| 15424 | N/A | Point | 1 | 1 | 1200 - 1299 | - | S233489 | 1200-1299 TWIN PEAKS BLVD | 1200-1299 TWIN PEAKS BLVD | F | F | - | F | 12774000 | 12774000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | PANORAMA DR | PANORAMA DR | 71477 | 71477 | 37.74627349 | -122.45026038 | - | - | 1710539427000 | MTA | CURVE CHEVRON (SYM) (LA) | PANORAMA DR to PORTOLA DR (1200 - 1299) | - | @ 1 MILE FROM PANORAMA DR.(730 TWIN PKS) | - | - | - | - | - | 32499 | 1487755920000 | -122.45026038 | 37.74627349 | - | 1487721600000 | - | D7 | - | OTHER WARNING | WARNING | W1-8.0003 | 18X24 | SUP2 | 2IN IRON POST | IS | 1486638780000 | TWIN PEAKS BLVD | 1200 - 1299 TWIN PEAKS BLVD | 1200 - 1299 TWIN PEAKS BLVD | 1200 TWIN PEAKS BLVD | - | PORTOLA DR | PORTOLA DR |
| 15425 | N/A | Point | 1 | 1 | 1600 - 1698 | - | S233496 | 1600-1698 7TH AVE | 1600-1698 07TH AVE | T | T | - | F | 363000 | 363000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | LAWTON ST \ WARREN DR | LAWTON ST \ WARREN DR | 71478 | 71478 | 37.75765115 | -122.4637196 | - | - | 1710539427000 | MTA | SPEED LIMIT 25 | LAWTON ST \ WARREN DR to MORAGA ST (1600 - 1698) | - | OPP.# 1689 | - | - | - | - | - | 32500 | 1357257600000 | -122.4637196 | 37.75765115 | - | - | - | D7 | - | SPEED LIMIT | REG | R2-1.0006 | 36X45 | SUP2 | LIGHT POLE | IS | 1486641060000 | 07TH AVE | 1600 - 1698 7TH AVE | 1600 - 1698 07TH AVE | 1600 7TH AVE | - | MORAGA ST | MORAGA ST |
| 15426 | N/A | Point | 1 | 1 | 4300 - 4399 | - | S235157 | 4300-4399 ANZA ST | 4300-4399 ANZA ST | F | F | - | F | 2350000 | 2350000 | - | - | SOUTH SIDE | - | - | - | - | 34TH AVE | 34TH AVE | 71479 | 71479 | 37.77770105 | -122.49477498 | - | - | 1719968835000 | middleware_editor | NPRK 12NN-2PM 2ND & 4TH MON OF MONTH STCL | 34TH AVE to 35TH AVE (4300 - 4399) | - | IFO 4355 | - | - | - | - | - | 32501 | 1221609600000 | -122.49477498 | 37.77770105 | - | 1503532800000 | - | D1 | - | STREET CLEANING | REG | R30B(CA).0072 | 18X18 | SUP2 | 2IN IRON POST | IS | 1492004640000 | ANZA ST | 4300 - 4399 ANZA ST | 4300 - 4399 ANZA ST | 4300 ANZA ST | - | 35TH AVE | 35TH AVE |
| 15427 | N/A | Point | 1 | 1 | 300 - 399 | RIGHT ARROW | S235650 | 48-399 SHOTWELL ST | 300-399 SHOTWELL ST | F | F | - | F | 11835000 | 11835000 | - | - | WEST SIDE | - | - | - | - | 17TH ST | 17TH ST | 71480 | 71480 | 37.76283457 | -122.41615263 | - | - | 1710539427000 | MTA | PROVISIONAL-ASSIGN NEW SIGN CODE WHEN CREATED IN SHOPS | 17TH ST to 18TH ST (300 - 399) | - | 9' N OF 18TH ST. | - | - | - | - | - | 32502 | 997228800000 | -122.41615263 | 37.76283457 | - | - | - | D9 | - | PROVISIONAL | MISC | PROVISIONAL CODE | N/A | SUP2 | 2IN IRON POST | IS | 1493204760000 | SHOTWELL ST | 300 - 399 SHOTWELL ST | 300 - 399 SHOTWELL ST | 300 SHOTWELL ST | - | 18TH ST | 18TH ST |
| 15428 | N/A | Point | - | - | - | - | S232381 | SANSOME ST: SACRAMENTO ST | - | F | F | - | F | 24701000 | 24701000 | - | - | WEST SIDE | - | - | - | - | SACRAMENTO ST | SACRAMENTO ST | 71481 | 71481 | 37.79398706 | -122.4013145 | SANSOME ST \ SACRAMENTO ST | SANSOME ST \ SACRAMENTO ST | 1727215568000 | middleware_editor | TANS 3PM-6PM EXC SAT & SUN | SACRAMENTO ST intersection | - | 5' SOUTH OF COMMERCIAL | - | - | - | - | - | 32503 | 1208995200000 | -122.4013145 | 37.79398706 | - | - | - | D3 | - | OTHER REGULATORY | REG | R37(CA).0020 | 18X21 | SUP1 | MUNI POLE | IS | 1483700460000 | SANSOME ST | - | - | - | - | - | - |
| 15429 | N/A | Point | - | - | - | - | S232382 | SANSOME ST: SACRAMENTO ST | - | F | F | - | F | 24701000 | 24701000 | - | - | WEST SIDE | - | - | - | - | SACRAMENTO ST | SACRAMENTO ST | 71482 | 71482 | 37.79398706 | -122.4013145 | SANSOME ST \ SACRAMENTO ST | SANSOME ST \ SACRAMENTO ST | 1727215508000 | middleware_editor | TANS 3P-8P EXCEPT SAT & SUN | SACRAMENTO ST intersection | - | 5' SOUTH OF COMMERCIAL | - | - | - | - | - | 32504 | 1208995200000 | -122.4013145 | 37.79398706 | - | 1488585600000 | - | D3 | - | OTHER REGULATORY | REG | R37(CA).0102 | 18X21 | SUP1 | MUNI POLE | IS | 1483700580000 | SANSOME ST | - | - | - | - | - | - |
| 15430 | N/A | Point | - | - | - | - | S232383 | SANSOME ST: CLAY ST | - | T | T | - | F | 24703000 | 24703000 | - | - | SOUTH EAST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SANSOME ST | CLAY ST | 71483 | 71483 | 37.7948395 | -122.40148758 | CLAY ST \ SANSOME ST | SANSOME ST \ CLAY ST | 1727215115000 | middleware_editor | EXC BUSES AND COMMERCIAL VEH | CLAY ST intersection | - | - | - | - | - | - | - | 32505 | 879897600000 | -122.40148758 | 37.7948395 | - | - | 1727189880000 | D3 | - | OTHER REGULATORY | REG | R(SF).0061 | 30X24 | SUP1 | MUNI POLE | RETD | 1483701120000 | SANSOME ST | - | - | - | - | - | - |
| 15431 | N/A | Point | - | - | - | - | S232384 | SANSOME ST: CLAY ST | - | T | T | - | F | 24703000 | 24703000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | SANSOME ST | CLAY ST | 71484 | 71484 | 37.7948395 | -122.40148758 | CLAY ST \ SANSOME ST | SANSOME ST \ CLAY ST | 1727226737000 | middleware_editor | DO NOT ENTER 7AM-8PM EVERYDAY | CLAY ST intersection | - | - | - | - | - | - | - | 32506 | 879897600000 | -122.40148758 | 37.7948395 | - | 1488844800000 | - | D3 | - | OTHER REGULATORY | REG | R5-1(SF).0013 | 30X42 | SUP1 | MUNI POLE | IS | 1483701240000 | SANSOME ST | - | - | - | - | - | - |
| 15432 | N/A | Point | 1 | 1 | 300 - 399 | - | S239212 | 300-399 PRESIDIO AVE | 300-399 PRESIDIO AVE | F | F | - | F | 10764000 | 10764000 | - | - | WEST SIDE | - | - | - | - | CLAY ST | CLAY ST | 71486 | 71486 | 37.78862893 | -122.44706109 | - | - | 1744652600000 | middleware_editor | TA (SYM) PLO 5:30PM-10:30PM EVERYDAY (5 MIN) | CLAY ST to SACRAMENTO ST (300 - 399) | - | IFO 347 | - | - | - | - | - | 32507 | - | -122.44706109 | 37.78862893 | - | - | - | D2 | - | OTHER REGULATORY | REG | R38(SF)1.0111 | 14X21 | SUP1 | 2IN IRON POST | IS | 1506601680000 | PRESIDIO AVE | 300 - 399 PRESIDIO AVE | 300 - 399 PRESIDIO AVE | 300 PRESIDIO AVE | - | SACRAMENTO ST | SACRAMENTO ST |
| 15433 | N/A | Point | 1 | 1 | 900 - 999 | - | S239865 | 900-999 NORTH POINT ST | 900-999 NORTH POINT ST | F | F | - | F | 9696000 | 9696000 | - | - | CENTER ISLAND, EASTBOUND TRAFFIC | - | - | - | - | LARKIN ST | LARKIN ST | 71487 | 71487 | 37.80539182 | -122.42283095 | - | - | 1746566545000 | middleware_editor | FG 300 UR DELINEATOR (W) | LARKIN ST to POLK ST (900 - 999) | - | 20' EAST OF POLK..1' FROM INSIDE CURB | - | - | - | - | - | 32508 | 1509124620000 | -122.42283095 | 37.80539182 | - | 1746566280000 | - | D2 | - | DELINEATOR 5 | WARNING | TYPE-DL.0011 | 03X36 | SUP1 | STANDARD BASE | IS | 1509007020000 | NORTH POINT ST | 900 - 999 NORTH POINT ST | 900 - 999 NORTH POINT ST | 900 NORTH POINT ST | - | POLK ST | POLK ST |
| 15434 | N/A | Point | - | - | - | - | S245686 | GREENWOOD AVE: COLON AVE | - | F | F | - | F | 22249000 | 22249000 | - | - | SOUTH WEST CORNER | - | - | - | - | COLON AVE | GREENWOOD AVE | 74287 | 74287 | 37.72884025 | -122.45560307 | GREENWOOD AVE \ COLON AVE | COLON AVE \ GREENWOOD AVE | 1720055353000 | middleware_editor | GREENWOOD AVE | GREENWOOD AVE intersection | - | <-- 100 W | - | - | - | - | - | 32509 | 1529660580000 | -122.45560307 | 37.72884025 | - | - | - | D7 | - | STREET NAME | GUIDE | D3-1.0774 | 36X08 | SUP2 | 3IN IRON POST | IS | 1526914080000 | COLON AVE | - | - | - | - | - | - |
| 15435 | N/A | Point | - | - | - | - | S245687 | GREENWOOD AVE: COLON AVE | - | F | F | - | F | 22249000 | 22249000 | - | - | SOUTH WEST CORNER | - | - | - | - | COLON AVE | GREENWOOD AVE | 74288 | 74288 | 37.72884025 | -122.45560307 | GREENWOOD AVE \ COLON AVE | COLON AVE \ GREENWOOD AVE | 1720038454000 | middleware_editor | COLON AVE | GREENWOOD AVE intersection | - | <-- 100 N | - | - | - | - | - | 32510 | 1529660580000 | -122.45560307 | 37.72884025 | - | - | - | D7 | - | STREET NAME | GUIDE | D3-1.0417 | 36X08 | SUP2 | 3IN IRON POST | IS | 1526914440000 | COLON AVE | - | - | - | - | - | - |
| 15436 | N/A | Point | 1 | 1 | 200 - 270 | - | S246062 | 200-270 BRANNAN ST | 200-270 BRANNAN ST | F | F | - | F | 3072000 | 3072000 | - | - | SOUTH SIDE | - | - | - | - | DELANCEY ST | DELANCEY ST | 74290 | 74290 | 37.78303157 | -122.39057735 | - | - | 1710539427000 | MTA | BIKE RACK | DELANCEY ST to COLIN P KELLY JR ST (200 - 270) | 07464 | 34' WEST OF DELANCY/3' IN FROM CURB | - | - | - | - | - | 32511 | 1528466580000 | -122.39057735 | 37.78303157 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1528196160000 | BRANNAN ST | 200 - 270 BRANNAN ST | 200 - 270 BRANNAN ST | 200 BRANNAN ST | - | COLIN P KELLY JR ST | COLIN P KELLY JR ST |
| 15437 | N/A | Point | 1 | 1 | 200 - 270 | - | S246063 | 200-270 BRANNAN ST | 200-270 BRANNAN ST | F | F | - | F | 3072000 | 3072000 | - | - | SOUTH SIDE | - | - | - | - | DELANCEY ST | DELANCEY ST | 74291 | 74291 | 37.78303157 | -122.39057735 | - | - | 1710539427000 | MTA | BIKE RACK | DELANCEY ST to COLIN P KELLY JR ST (200 - 270) | 07464 | 61' WEST OF DELANCY/3' IN FROM CURB | - | - | - | - | - | 32512 | 1528466700000 | -122.39057735 | 37.78303157 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0020 | 36X36 | SUP1 | BIKE RACK | IS | 1528196280000 | BRANNAN ST | 200 - 270 BRANNAN ST | 200 - 270 BRANNAN ST | 200 BRANNAN ST | - | COLIN P KELLY JR ST | COLIN P KELLY JR ST |
| 15438 | N/A | Point | 1 | 1 | 133 - 199 | - | S246064 | 133-199 3RD ST | 133-199 03RD ST | F | F | - | F | 167000 | 167000 | - | - | EAST SIDE | - | - | - | - | MINNA ST | MINNA ST | 74292 | 74292 | 37.78542975 | -122.40097916 | - | - | 1710539427000 | MTA | BIKE RACK (YERBA BUENA) | MINNA ST to HOWARD ST (133 - 199) | 09250 | 3' SOUTH OF CROSSWALK/4' IN FROM CURB | - | - | - | - | - | 32513 | 1528718880000 | -122.40097916 | 37.78542975 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0345 | 36X36 | SUP1 | BIKE RACK | IS | 1528198140000 | 03RD ST | 133 - 199 3RD ST | 133 - 199 03RD ST | 133 3RD ST | - | HOWARD ST | HOWARD ST |
| 15439 | N/A | Point | 1 | 1 | 133 - 199 | - | S246066 | 133-199 3RD ST | 133-199 03RD ST | F | F | - | F | 167000 | 167000 | - | - | EAST SIDE | - | - | - | - | MINNA ST | MINNA ST | 74293 | 74293 | 37.78542975 | -122.40097916 | - | - | 1710539427000 | MTA | BIKE RACK (YERBA BUENA) | MINNA ST to HOWARD ST (133 - 199) | 09250 | 6' SOUTH OF CROSSWALK/4' IN FROM CURB | - | - | - | - | - | 32514 | 1528718940000 | -122.40097916 | 37.78542975 | - | - | - | D6 | - | BIKE RACK | REG | R(SF).0345 | 36X36 | SUP1 | BIKE RACK | IS | 1528198260000 | 03RD ST | 133 - 199 3RD ST | 133 - 199 03RD ST | 133 3RD ST | - | HOWARD ST | HOWARD ST |
| 15440 | N/A | Point | 1 | 1 | 133 - 199 | - | S246068 | 133-199 3RD ST | 133-199 03RD ST | F | F | - | F | 167000 | 167000 | - | - | EAST SIDE | - | - | - | - | MINNA ST | MINNA ST | 74294 | 74294 | 37.78542975 | -122.40097916 | - | - | 1710539427000 | MTA | BIKE RACK (YERBA BUENA) | MINNA ST to HOWARD ST (133 - 199) | 09250 | 9' SOUTH OF CROSSWALK/4' IN FROM CURB | - | - | - | - | - | 32515 | 1528719060000 | -122.40097916 | 37.78542975 | - | 1670284800000 | 1652400000000 | D6 | - | BIKE RACK | REG | R(SF).0345 | 36X36 | SUP1 | BIKE RACK | RETD | 1528198320000 | 03RD ST | 133 - 199 3RD ST | 133 - 199 03RD ST | 133 3RD ST | - | HOWARD ST | HOWARD ST |
| 15441 | N/A | Point | - | - | - | RIGHT ARROW | S239437 | BRYANT ST: OAK GROVE ST | - | F | F | - | F | 23900000 | 23900000 | - | - | NORTH EAST CORNER | - | - | - | - | BRYANT ST | BRYANT ST | 74299 | 74299 | 37.77692041 | -122.40140938 | OAK GROVE ST \ BRYANT ST | OAK GROVE ST \ BRYANT ST | 1710539427000 | MTA | TANS 3PM-7PM EXC SAT & SUN | BRYANT ST intersection | - | - | - | - | - | - | - | 32516 | 1473638400000 | -122.40140938 | 37.77692041 | - | 1473638400000 | - | D6 | - | OTHER REGULATORY | REG | R37(CA).0022 | 18X21 | SUP1 | LIGHT POLE | IS | 1507804440000 | OAK GROVE ST | - | - | - | - | - | - |
| 15442 | N/A | Point | - | - | - | - | S239438 | BRYANT ST: OAK GROVE ST | - | F | F | - | F | 23900000 | 23900000 | - | - | NORTH EAST CORNER | - | - | - | - | BRYANT ST | BRYANT ST | 74300 | 74300 | 37.77692041 | -122.40140938 | OAK GROVE ST \ BRYANT ST | OAK GROVE ST \ BRYANT ST | 1710539427000 | MTA | OAK GROVE ST | BRYANT ST intersection | - | END <=[] LP | - | - | - | - | - | 32517 | - | -122.40140938 | 37.77692041 | - | 1707402000000 | - | D6 | - | STREET NAME | GUIDE | D3-1.1295 | 36X08 | SUP1 | LIGHT POLE | IS | 1507804500000 | OAK GROVE ST | - | - | - | - | - | - |
| 15443 | N/A | Point | - | - | - | - | S240087 | JENNINGS ST: PALOU AVE | - | F | F | - | F | 20140000 | 20140000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | JENNINGS ST | JENNINGS ST | 74301 | 74301 | 37.73079082 | -122.385287 | PALOU AVE \ JENNINGS ST | PALOU AVE \ JENNINGS ST | 1710539427000 | MTA | ALL WAY | JENNINGS ST intersection | - | - | - | - | - | - | - | 32518 | 1511222400000 | -122.385287 | 37.73079082 | - | 1511222400000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 3IN IRON POST | IS | 1509524700000 | PALOU AVE | - | - | - | - | - | - |
| 15444 | N/A | Point | - | - | - | - | S240088 | JENNINGS ST: PALOU AVE | - | F | F | - | F | 20140000 | 20140000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | JENNINGS ST | JENNINGS ST | 74302 | 74302 | 37.73079082 | -122.385287 | PALOU AVE \ JENNINGS ST | PALOU AVE \ JENNINGS ST | 1710539427000 | MTA | ALL WAY | JENNINGS ST intersection | - | - | - | - | - | - | - | 32519 | 1511222400000 | -122.385287 | 37.73079082 | - | 1709203500000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1509525240000 | PALOU AVE | - | - | - | - | - | - |
| 15445 | N/A | Point | - | - | - | - | S240093 | WISCONSIN ST: 23RD ST | - | F | F | - | F | 23699000 | 23699000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 23RD ST | 23RD ST | 74303 | 74303 | 37.75474531 | -122.39869331 | WISCONSIN ST \ 23RD ST | WISCONSIN ST \ 23RD ST | 1710539427000 | MTA | ALL WAY | 23RD ST intersection | - | - | - | - | - | - | - | 32520 | -399427200000 | -122.39869331 | 37.75474531 | - | 1511222400000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | LIGHT POLE | IS | 1509527880000 | WISCONSIN ST | - | - | - | - | - | - |
| 15446 | N/A | Point | - | - | - | - | S240140 | GARRISON AVE: SUNNYDALE AVE | - | F | F | - | F | 20377000 | 20377000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GARRISON AVE | SUNNYDALE AVE | 74312 | 74312 | 37.71103617 | -122.41288744 | SUNNYDALE AVE \ GARRISON AVE | GARRISON AVE \ SUNNYDALE AVE | 1743607840000 | middleware_editor | ALL WAY | SUNNYDALE AVE intersection | - | 0 / 0 | - | - | - | - | - | 32521 | 306486000000 | -122.41288744 | 37.71103617 | - | 1510992000000 | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1509544980000 | GARRISON AVE | - | - | - | - | - | - |
| 15447 | N/A | Point | - | - | - | - | S240176 | LIBERTY ST: NOE ST | - | F | F | - | F | 25784000 | 25784000 | - | - | SOUTH WEST CORNER | - | - | - | - | NOE ST | NOE ST | 74313 | 74313 | 37.75702042 | -122.43240731 | LIBERTY ST \ NOE ST | LIBERTY ST \ NOE ST | 1712884845000 | middleware_editor | LIBERTY ST | NOE ST intersection | - | - | - | - | - | - | - | 32522 | 1516959000000 | -122.43240731 | 37.75702042 | - | 1516924800000 | - | D8 | - | STREET NAME | GUIDE | D3-1.1039 | 36X08 | SUP2 | LIGHT POLE | IS | 1509637440000 | LIBERTY ST | - | - | - | - | - | - |
| 15448 | N/A | Point | - | - | - | - | S240177 | NOE ST: LIBERTY ST | - | F | F | - | F | 25784000 | 25784000 | - | - | SOUTH WEST CORNER | - | - | - | - | NOE ST | NOE ST | 74314 | 74314 | 37.75702042 | -122.43240731 | LIBERTY ST \ NOE ST | LIBERTY ST \ NOE ST | 1712884842000 | middleware_editor | NOE ST | NOE ST intersection | - | - | - | - | - | - | - | 32523 | 1516959000000 | -122.43240731 | 37.75702042 | - | 1516924800000 | - | D8 | - | STREET NAME | GUIDE | D3-1.1282 | 36X08 | SUP2 | LIGHT POLE | IS | 1509637800000 | LIBERTY ST | - | - | - | - | - | - |
| 15449 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S246435 | 1500-1599 31ST AVE | 1500-1599 31ST AVE | F | F | - | F | 1686000 | 1686000 | - | - | WEST SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | KIRKHAM ST | KIRKHAM ST | 74316 | 74316 | 37.75833265 | -122.48965674 | - | - | 1710539427000 | MTA | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | KIRKHAM ST to LAWTON ST (1500 - 1599) | - | AT SPL 1563 31ST AVE | - | - | - | - | - | 32524 | - | -122.48965674 | 37.75833265 | - | - | - | D4 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP2 | LIGHT POLE | IS | 1529063880000 | 31ST AVE | 1500 - 1599 31ST AVE | 1500 - 1599 31ST AVE | 1500 31ST AVE | - | LAWTON ST | LAWTON ST |
| 15450 | N/A | Point | 1 | 1 | 1600 - 1699 | - | S246438 | 1600-1699 31ST AVE | 1600-1699 31ST AVE | F | F | - | F | 1687000 | 1687000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | LAWTON ST | LAWTON ST | 74317 | 74317 | 37.7570630071553 | -122.489505808542 | - | - | 1740580017000 | middleware_editor | SCHOOL (SYM) | LAWTON ST to MORAGA ST (1600 - 1699) | - | 85FT SOUTH OF LAWTON ST | - | - | - | - | - | 32525 | 1529500200000 | -122.48952504 | 37.75647056 | - | 1740479040000 | - | D4 | - | SCHOOL | WARNING | S1-1.0001 | 24X24 | SUP2 | 2IN IRON POST | IS | 1529075880000 | 31ST AVE | 1600 - 1699 31ST AVE | 1600 - 1699 31ST AVE | 1600 31ST AVE | - | MORAGA ST | MORAGA 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