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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 40726 | N/A | Point | - | - | - | - | S118792 | WALLER ST: STEINER ST | - | F | F | - | F | 25991000 | 25991000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | WALLER ST | WALLER ST | 14577 | 14577 | 37.77096443 | -122.43190432 | STEINER ST \ WALLER ST | STEINER ST \ WALLER ST | 1753213699000 | middleware_editor | STOP | WALLER ST intersection | - | NECORNER | - | - | - | - | - | 57813 | 1082703600000 | -122.43190432 | 37.77096443 | - | 938156400000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373573460000 | STEINER ST | - | - | - | - | - | - |
| 40727 | N/A | Point | - | - | - | - | S118793 | WALLER ST: STEINER ST | - | F | F | - | F | 25991000 | 25991000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | WALLER ST | WALLER ST | 14578 | 14578 | 37.77096443 | -122.43190432 | STEINER ST \ WALLER ST | STEINER ST \ WALLER ST | 1753213695000 | middleware_editor | STOP | WALLER ST intersection | - | SWCORNER | - | - | - | - | - | 57814 | 1082703600000 | -122.43190432 | 37.77096443 | - | 938156400000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373573460000 | STEINER ST | - | - | - | - | - | - |
| 40728 | N/A | Point | - | - | - | - | S119058 | RIVERA ST: 41ST AVE | - | F | F | - | F | 23470000 | 23470000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 41ST AVE | 41ST AVE | 14579 | 14579 | 37.745739 | -122.49952545 | RIVERA ST \ 41ST AVE | RIVERA ST \ 41ST AVE | 1710539427000 | MTA | ALL WAY | 41ST AVE intersection | - | - | - | - | - | - | - | 57815 | 1087257600000 | -122.49952545 | 37.745739 | - | 1477526400000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573520000 | RIVERA ST | - | - | - | - | - | - |
| 40729 | N/A | Point | - | - | - | - | S119059 | RIVERA ST: 41ST AVE | - | F | F | - | F | 23470000 | 23470000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 41ST AVE | 41ST AVE | 14580 | 14580 | 37.745739 | -122.49952545 | RIVERA ST \ 41ST AVE | RIVERA ST \ 41ST AVE | 1710539427000 | MTA | ALL WAY | 41ST AVE intersection | - | - | - | - | - | - | - | 57816 | 1087257600000 | -122.49952545 | 37.745739 | - | - | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 3IN IRON POST | IS | 1373573520000 | RIVERA ST | - | - | - | - | - | - |
| 40730 | N/A | Point | - | - | - | - | S119060 | 19TH ST: CAPP ST | - | F | F | - | F | 24131000 | 24131000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 14581 | 14581 | 37.76030106 | -122.41811812 | CAPP ST \ 19TH ST | CAPP ST \ 19TH ST | 1745515987000 | middleware_editor | ALL WAY | 19TH ST intersection | - | NECORNER | - | - | - | - | - | 57817 | 1087282800000 | -122.41811812 | 37.76030106 | - | 1591167600000 | - | D9 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573520000 | CAPP ST | - | - | - | - | - | - |
| 40731 | N/A | Point | 1 | 1 | 631 - 699 | - | S119055 | 631-699 MISSOURI ST | 631-699 MISSOURI ST | F | F | - | F | 9213000 | 9213000 | - | - | EAST SIDE | - | - | - | - | SIERRA ST | SIERRA ST | 14582 | 14582 | 37.75788598 | -122.39605075 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-6PM MON-FRI EXC "X" PERMITS | SIERRA ST to 22ND ST (631 - 699) | - | OPPOSITE NPL # 698 | - | - | - | - | - | 57818 | 1086912000000 | -122.39605075 | 37.75788598 | - | - | - | D10 | - | PARKING:RPP | REG | R32C(CA).0106 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373573520000 | MISSOURI ST | 631 - 699 MISSOURI ST | 631 - 699 MISSOURI ST | 631 MISSOURI ST | - | 22ND ST | 22ND ST |
| 40732 | N/A | Point | 1 | 1 | 100 - 199 | - | S120076 | 100-199 GREENWOOD AVE | 100-199 GREENWOOD AVE | F | F | - | F | 6528000 | 6528000 | - | - | SOUTH SIDE | - | - | - | - | COLON AVE | COLON AVE | 14683 | 14683 | 37.72878045 | -122.45601804 | - | - | 1720038565000 | middleware_editor | 2 HR PRK 8AM-4PM SCHL DAYS | COLON AVE to PLYMOUTH AVE (100 - 199) | - | IFO#101 | - | - | - | - | - | 57819 | 1104278400000 | -122.45601804 | 37.72878045 | - | - | - | D7 | - | PARKING | REG | R32(CA).0077 | 18X18 | SUP2 | 2IN IRON POST | IS | 1373573820000 | GREENWOOD AVE | 100 - 199 GREENWOOD AVE | 100 - 199 GREENWOOD AVE | 100 GREENWOOD AVE | - | PLYMOUTH AVE | PLYMOUTH AVE |
| 40733 | N/A | Point | 1 | 1 | 100 - 199 | - | S120077 | 100-199 MONTECITO AVE | 100-199 MONTECITO AVE | F | F | - | F | 9267000 | 9267000 | - | - | SOUTH SIDE | - | - | - | - | HAZELWOOD AVE | HAZELWOOD AVE | 14684 | 14684 | 37.73027404 | -122.45460556 | - | - | 1710539427000 | MTA | 2 HR PRK 8AM-4PM SCHL DAYS | HAZELWOOD AVE to VALDEZ AVE (100 - 199) | - | 65`WEST | - | - | - | - | - | 57820 | 1104278400000 | -122.45460556 | 37.73027404 | - | - | - | D7 | - | PARKING | REG | R32(CA).0077 | 18X18 | SUP2 | 2IN IRON POST | IS | 1373573820000 | MONTECITO AVE | 100 - 199 MONTECITO AVE | 100 - 199 MONTECITO AVE | 100 MONTECITO AVE | - | VALDEZ AVE | VALDEZ AVE |
| 40734 | N/A | Point | - | - | - | - | S120406 | POPE ST: CROSS ST | - | F | F | - | F | 21472000 | 21472000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CROSS ST | CROSS ST | 15606 | 15606 | 37.71393254 | -122.44115621 | POPE ST \ CROSS ST | POPE ST \ CROSS ST | 1710539427000 | MTA | STOP | CROSS ST intersection | - | - | - | - | - | - | - | 57821 | 1109203200000 | -122.44115621 | 37.71393254 | - | 1600905600000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373573940000 | POPE ST | - | - | - | - | - | - |
| 40735 | N/A | Point | - | - | - | - | S120407 | CROSS ST: POPE ST | - | F | F | - | F | 21472000 | 21472000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | CROSS ST | CROSS ST | 15607 | 15607 | 37.71393254 | -122.44115621 | POPE ST \ CROSS ST | POPE ST \ CROSS ST | 1710539427000 | MTA | ALL WAY | CROSS ST intersection | - | - | - | - | - | - | - | 57822 | 1109203200000 | -122.44115621 | 37.71393254 | - | - | - | D11 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373573940000 | POPE ST | - | - | - | - | - | - |
| 40736 | N/A | Point | 1 | 1 | 2400 - 2449 | - | S118222 | 0-2449 LEAVENWORTH ST | 2400-2449 LEAVENWORTH ST | F | F | - | F | 8270101 | 8270101 | - | - | WEST SIDE | - | - | - | - | CHESTNUT ST | CHESTNUT ST | 15609 | 15609 | 37.80339281 | -122.41820349 | - | - | 1710539427000 | MTA | NPRK ANY TIME | CHESTNUT ST to FRANCISCO ST (2400 - 2449) -- WEST -- | - | NPL # 2455 UPPER LEAVENWORTH | - | - | - | - | - | 57823 | 1074729600000 | -122.41820349 | 37.80339281 | - | - | - | D2 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | RETAINING WALL | IS | 1373573220000 | LEAVENWORTH ST | 2400 - 2449 LEAVENWORTH ST | 2400 - 2449 LEAVENWORTH ST | 2400 LEAVENWORTH ST | - | FRANCISCO ST | FRANCISCO ST |
| 40737 | N/A | Point | - | - | - | - | S118225 | COLUMBUS AVE: NORTH POINT ST | - | F | F | - | F | 25573000 | 25573000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | NORTH POINT ST | NORTH POINT ST | 15610 | 15610 | 37.80597737 | -122.41838066 | COLUMBUS AVE \ NORTH POINT ST | COLUMBUS AVE \ NORTH POINT ST | 1710539427000 | MTA | TRUCK ROUTE (LA) | NORTH POINT ST intersection | - | @ PM | - | - | - | - | - | 57824 | 1074816000000 | -122.41838066 | 37.80597737 | - | - | - | D2 | - | OTHER REGULATORY | REG | R14-1(CA).0007 | 24X18 | SUP1 | 2IN IRON POST | IS | 1373573220000 | COLUMBUS AVE | - | - | - | - | - | - |
| 40738 | N/A | Point | 1 | 1 | 220 - 399 | - | S118226 | 220-399 TUNNEL AVE | 220-399 TUNNEL AVE | F | F | - | F | 12714000 | 12714000 | - | - | WEST SIDE | - | - | - | - | LATHROP AVE | LATHROP AVE | 15611 | 15611 | 37.71032582 | -122.40124026 | - | - | 1710539427000 | MTA | NPRK 7AM-8AM TUE STCL | LATHROP AVE to VISITACION AVE (220 - 399) | - | OPP SE CORNER OF LATHROP | - | - | - | - | - | 57825 | 1074816000000 | -122.40124026 | 37.71032582 | - | 1540944000000 | - | D10 | - | STREET CLEANING | REG | R30B(CA).0220 | 18X18 | SUP1 | UTILITY POLE | IS | 1373573220000 | TUNNEL AVE | 220 - 399 TUNNEL AVE | 220 - 399 TUNNEL AVE | 220 TUNNEL AVE | - | VISITACION AVE | VISITACION AVE |
| 40739 | N/A | Point | 1 | 1 | 220 - 399 | - | S118227 | 220-399 TUNNEL AVE | 220-399 TUNNEL AVE | F | F | - | F | 12714000 | 12714000 | - | - | WEST SIDE | - | - | - | - | LATHROP AVE | LATHROP AVE | 15612 | 15612 | 37.71032582 | -122.40124026 | - | - | 1710539427000 | MTA | 1 HR PRK COMMERCIAL VEH | LATHROP AVE to VISITACION AVE (220 - 399) | - | OPP SE CORNER OF LATHROP | - | - | - | - | - | 57826 | 1074816000000 | -122.40124026 | 37.71032582 | - | - | - | D10 | - | PARKING | REG | R32(SF).0002 | 18X18 | SUP1 | UTILITY POLE | IS | 1373573220000 | TUNNEL AVE | 220 - 399 TUNNEL AVE | 220 - 399 TUNNEL AVE | 220 TUNNEL AVE | - | VISITACION AVE | VISITACION AVE |
| 40740 | N/A | Point | 1 | 1 | 400 - 435 | - | S118228 | 400-435 DUBOCE AVE | 400-435 DUBOCE AVE | F | F | - | F | 4985000 | 4985000 | - | - | CENTER ISLAND, WESTBOUND TRAFFIC | - | - | - | - | CHURCH ST | CHURCH ST | 15613 | 15613 | 37.76943203 | -122.42951682 | - | - | 1710539427000 | MTA | (45 LA-DN/45 RA-DN) (SYM) | CHURCH ST to FILLMORE ST (400 - 435) | - | E-LINE OF MUNI TRAFFIC ISLAND | - | - | - | - | - | 57827 | 1074816000000 | -122.42951682 | 37.76943203 | - | - | - | D8 | - | OTHER WARNING | WARNING | W12-1.0003 | 36X36 | SUP2 | 2IN IRON POST | IS | 1373573220000 | DUBOCE AVE | 400 - 435 DUBOCE AVE | 400 - 435 DUBOCE AVE | 400 DUBOCE AVE | - | FILLMORE ST | FILLMORE ST |
| 40741 | N/A | Point | - | - | - | - | S115957 | SANCHEZ ST: DAY ST | - | F | F | - | F | 21909000 | 21909000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DAY ST | DAY ST | 15614 | 15614 | 37.74276429 | -122.4288056 | SANCHEZ ST \ DAY ST | SANCHEZ ST \ DAY ST | 1754493698000 | middleware_editor | ALL WAY | DAY ST intersection | - | NWCORNER | - | - | - | - | - | 57828 | 1043827200000 | -122.4288056 | 37.74276429 | - | - | - | D8 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1373572500000 | SANCHEZ ST | - | - | - | - | - | - |
| 40742 | N/A | Point | 1 | 1 | 200 - 275 | - | S122740 | 200-275 MIDDLEFIELD DR | 200-275 MIDDLEFIELD DR | F | F | - | F | 9018000 | 9018000 | - | - | EAST SIDE | - | - | - | - | EUCALYPTUS DR | EUCALYPTUS DR | 15628 | 15628 | 37.73033249 | -122.48629479 | - | - | 1755807152000 | middleware_editor | BUS STOP TANS 8:30AM-4:30PM SCHL DAYS | EUCALYPTUS DR to GELLERT DR (200 - 275) | - | 14`SOUTH (PLUS RA) | - | - | - | - | - | 57829 | 1139990400000 | -122.48629479 | 37.73033249 | - | 1662966000000 | - | D7 | - | OTHER REGULATORY | REG | R37(SF).0048 | 18X30 | SUP2 | 2IN IRON POST | IS | 1373574660000 | MIDDLEFIELD DR | 200 - 275 MIDDLEFIELD DR | 200 - 275 MIDDLEFIELD DR | 200 MIDDLEFIELD DR | - | GELLERT DR | GELLERT DR |
| 40743 | N/A | Point | - | - | - | - | S121877 | THOMAS AVE: SILVER AVE | - | F | F | - | F | 20741000 | 20741000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | THOMAS AVE | THOMAS AVE | 15669 | 15669 | 37.73558082 | -122.40035734 | SILVER AVE \ THOMAS AVE | SILVER AVE \ THOMAS AVE | 1751469615000 | middleware_editor | SCHOOL (SYM) | THOMAS AVE intersection | - | PM | - | - | - | - | - | 57830 | 1129791600000 | -122.40035734 | 37.73558082 | - | 1703002500000 | - | D10 | - | SCHOOL | WARNING | S1-1.0001 | 24X24 | SUP1 | 2IN IRON POST | IS | 1373574420000 | SILVER AVE | - | - | - | - | - | - |
| 40744 | N/A | Point | 1 | 1 | 2500 - 2599 | - | S121880 | 2500-2599 INGALLS ST | 2500-2599 INGALLS ST | F | F | - | F | 7235000 | 7235000 | - | - | EAST SIDE | - | - | - | - | BANCROFT AVE | BANCROFT AVE | 15671 | 15671 | 37.72316653 | -122.38933611 | - | - | 1726154585000 | middleware_editor | TANS EXC 30 MIN 6 WHEEL TL 7AM-6PM MON-FRI | BANCROFT AVE to CARROLL AVE (2500 - 2599) | - | 15' SOUTH OF NORTH LINE @ PM | - | - | - | - | - | 57831 | 1129852800000 | -122.38933611 | 37.72316653 | - | - | - | D10 | - | OTHER REGULATORY | REG | R37(SF).0148 | 10X15 | SUP1 | 2IN IRON POST | IS | 1373574420000 | INGALLS ST | 2500 - 2599 INGALLS ST | 2500 - 2599 INGALLS ST | 2500 INGALLS ST | - | CARROLL AVE | CARROLL AVE |
| 40745 | N/A | Point | 1 | 1 | 1400 - 1499 | - | S121881 | 1400-1499 CARROLL AVE | 1400-1499 CARROLL AVE | F | F | - | F | 3736000 | 3736000 | - | - | NORTH SIDE | - | - | - | - | INGALLS ST | INGALLS ST | 15672 | 15672 | 37.72338278 | -122.39055573 | - | - | 1710539427000 | MTA | TANS EXC 30 MIN 6 WHEEL TL 7AM-6PM MON-SAT | INGALLS ST to JENNINGS ST (1400 - 1499) | - | 30'WEST OF EPL # 1480 @ PM | - | - | - | - | - | 57832 | 1129852800000 | -122.39055573 | 37.72338278 | - | - | - | D10 | - | OTHER REGULATORY | REG | R37(SF).0151 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373574420000 | CARROLL AVE | 1400 - 1499 CARROLL AVE | 1400 - 1499 CARROLL AVE | 1400 CARROLL AVE | - | JENNINGS ST | JENNINGS ST |
| 40746 | N/A | Point | - | 1 | 1 - 99 | - | S122400 | 1-99 HARDING RD | 1-99 HARDING RD | F | F | - | F | 6674000 | 6674000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | SKYLINE BLVD | SKYLINE BLVD | 15674 | 15674 | 37.7250493 | -122.49783833 | - | - | 1710539427000 | MTA | PEDESTRIAN (SYM) | SKYLINE BLVD to END: 1-99 BLOCK (1 - 99) | - | 150' EAST OF ENTRANCE TO GOLF COURS..... | - | - | - | - | - | 57833 | 1136937600000 | -122.49783833 | 37.7250493 | - | 1632700800000 | - | D7 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373574600000 | HARDING RD | 1 - 99 HARDING RD | 1 - 99 HARDING RD | 1 HARDING RD | - | END: 1-99 BLOCK | END: 1-99 BLOCK |
| 40747 | N/A | Point | - | - | - | - | S122401 | AVILA ST: ALHAMBRA ST | - | F | F | - | F | 26971000 | 26971000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | AVILA ST | ALHAMBRA ST | 15675 | 15675 | 37.80128132 | -122.4405086 | ALHAMBRA ST \ AVILA ST | AVILA ST \ ALHAMBRA ST | 1710539427000 | MTA | ALL WAY | ALHAMBRA ST intersection | - | - | - | - | - | - | - | 57834 | 1137024000000 | -122.4405086 | 37.80128132 | - | 1600905600000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373574600000 | AVILA ST | - | - | - | - | - | - |
| 40748 | N/A | Point | - | - | - | - | S122403 | ALHAMBRA ST: AVILA ST | - | F | F | - | F | 26971000 | 26971000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | AVILA ST | ALHAMBRA ST | 15677 | 15677 | 37.80128132 | -122.4405086 | ALHAMBRA ST \ AVILA ST | AVILA ST \ ALHAMBRA ST | 1710539427000 | MTA | ALL WAY | ALHAMBRA ST intersection | - | - | - | - | - | - | - | 57835 | 1137024000000 | -122.4405086 | 37.80128132 | - | - | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 3IN IRON POST | IS | 1373574600000 | AVILA ST | - | - | - | - | - | - |
| 40749 | N/A | Point | - | - | - | - | S122404 | ALHAMBRA ST: AVILA ST | - | F | F | - | F | 26971000 | 26971000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | AVILA ST | ALHAMBRA ST | 15678 | 15678 | 37.80128132 | -122.4405086 | ALHAMBRA ST \ AVILA ST | AVILA ST \ ALHAMBRA ST | 1710539427000 | MTA | ALL WAY | ALHAMBRA ST intersection | - | - | - | - | - | - | - | 57836 | 1137024000000 | -122.4405086 | 37.80128132 | - | - | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373574600000 | AVILA ST | - | - | - | - | - | - |
| 40750 | N/A | Point | 1 | 1 | 243 - 299 | - | S116329 | 243-299 HARRIET ST | 243-299 HARRIET ST | F | F | - | F | 6702000 | 6702000 | - | - | EAST SIDE | - | - | - | - | AHERN WAY | AHERN WAY | 16364 | 16364 | 37.77595787 | -122.40351789 | - | - | 1715722477000 | middleware_editor | NPRK 12MN-2AM THUR STCL | AHERN WAY to BRYANT ST (243 - 299) | - | 12' NORTH OF BRYANT | - | - | - | - | - | 57837 | 1047600000000 | -122.40351789 | 37.77595787 | - | 1715697180000 | - | D6 | - | STREET CLEANING | REG | R30B(CA).0036 | 18X18 | SUP1 | LIGHT POLE | IS | 1373572620000 | HARRIET ST | 243 - 299 HARRIET ST | 243 - 299 HARRIET ST | 243 HARRIET ST | - | BRYANT ST | BRYANT ST |
| 40751 | N/A | Point | - | - | - | - | S116333 | 23RD AVE: KIRKHAM ST | - | F | F | - | F | 27410000 | 27410000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 23RD AVE | 23RD AVE | 16365 | 16365 | 37.75964304 | -122.48114752 | KIRKHAM ST \ 23RD AVE | KIRKHAM ST \ 23RD AVE | 1710539427000 | MTA | ALL WAY | 23RD AVE intersection | - | - | - | - | - | - | - | 57838 | 1047859200000 | -122.48114752 | 37.75964304 | - | - | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572620000 | KIRKHAM ST | - | - | - | - | - | - |
| 40752 | N/A | Point | - | - | - | - | S116334 | 23RD AVE: KIRKHAM ST | - | F | F | - | F | 27410000 | 27410000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 23RD AVE | 23RD AVE | 16366 | 16366 | 37.75964304 | -122.48114752 | KIRKHAM ST \ 23RD AVE | KIRKHAM ST \ 23RD AVE | 1710539427000 | MTA | ALL WAY | 23RD AVE intersection | - | - | - | - | - | - | - | 57839 | 1047859200000 | -122.48114752 | 37.75964304 | - | - | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572620000 | KIRKHAM ST | - | - | - | - | - | - |
| 40753 | N/A | Point | - | - | - | - | S116335 | THE EMBARCADERO: WASHINGTON ST | - | F | F | - | F | 24572000 | 24572000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WASHINGTON ST | WASHINGTON ST | 16367 | 16367 | 37.7966829 | -122.39540527 | THE EMBARCADERO \ WASHINGTON ST | THE EMBARCADERO \ WASHINGTON ST | 1714669031000 | middleware_editor | LANE REDUCTION (SYM) LEFT/EXC 7AM-9AM 3PM-7PM MON-FRI | WASHINGTON ST intersection | - | @ PM PAINT MARK | - | - | - | - | - | 57840 | 1047859200000 | -122.39540527 | 37.7966829 | - | - | - | D3 | - | OTHER WARNING | WARNING | W4-2+W(SF).01 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373572620000 | THE EMBARCADERO | - | - | - | - | - | - |
| 40754 | N/A | Point | 1 | 1 | 300 - 399 | - | S116600 | 300-399 BEALE ST | 300-399 BEALE ST | F | F | - | F | 2866000 | 2866000 | - | - | WEST SIDE | - | - | - | - | FOLSOM ST | FOLSOM ST | 16368 | 16368 | 37.78807093 | -122.39195125 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM WED STCL | FOLSOM ST to HARRISON ST (300 - 399) | - | 500S / 500'SOUTH | - | - | - | - | - | 57841 | 1051056000000 | -122.39195125 | 37.78807093 | - | - | - | D6 | - | STREET CLEANING | REG | R30B(CA).0063 | 18X18 | SUP1 | LIGHT POLE | IS | 1373572740000 | BEALE ST | 300 - 399 BEALE ST | 300 - 399 BEALE ST | 300 BEALE ST | - | HARRISON ST | HARRISON ST |
| 40755 | N/A | Point | 1 | 1 | 400 - 499 | - | S116601 | 400-499 BEALE ST | 400-499 BEALE ST | F | F | - | F | 2867000 | 2867000 | - | - | WEST SIDE | - | - | - | - | HARRISON ST | HARRISON ST | 16369 | 16369 | 37.78683949 | -122.39040815 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM WED STCL | HARRISON ST to BRYANT ST \ DELANCEY ST (400 - 499) | - | 20'SOUTH OF ENT # 400 | - | - | - | - | - | 57842 | 1051056000000 | -122.39040815 | 37.78683949 | - | - | - | D6 | - | STREET CLEANING | REG | R30B(CA).0063 | 18X18 | SUP1 | LIGHT POLE | IS | 1373572740000 | BEALE ST | 400 - 499 BEALE ST | 400 - 499 BEALE ST | 400 BEALE ST | - | BRYANT ST \ DELANCEY ST | BRYANT ST \ DELANCEY ST |
| 40756 | N/A | Point | 1 | 1 | 400 - 499 | - | S116602 | 400-499 BEALE ST | 400-499 BEALE ST | F | F | - | F | 2867000 | 2867000 | - | - | WEST SIDE | - | - | - | - | HARRISON ST | HARRISON ST | 16370 | 16370 | 37.78683949 | -122.39040815 | - | - | 1710539427000 | MTA | NPRK 12MN-6AM WED STCL | HARRISON ST to BRYANT ST \ DELANCEY ST (400 - 499) | - | 25S / 25'SOUTH | - | - | - | - | - | 57843 | 1051056000000 | -122.39040815 | 37.78683949 | - | - | - | D6 | - | STREET CLEANING | REG | R30B(CA).0063 | 18X18 | SUP1 | 2IN IRON POST | IS | 1373572740000 | BEALE ST | 400 - 499 BEALE ST | 400 - 499 BEALE ST | 400 BEALE ST | - | BRYANT ST \ DELANCEY ST | BRYANT ST \ DELANCEY ST |
| 40757 | N/A | Point | - | - | - | - | S116793 | 28TH AVE: ULLOA ST | - | F | F | - | F | 23253000 | 23253000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ULLOA ST | ULLOA ST | 16371 | 16371 | 37.74075807 | -122.48520464 | 28TH AVE \ ULLOA ST | 28TH AVE \ ULLOA ST | 1738357396000 | middleware_editor | ALL WAY | ULLOA ST intersection | - | - | - | - | - | - | - | 57844 | 1052870400000 | -122.48520464 | 37.74075807 | - | 1738326480000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572800000 | 28TH AVE | - | - | - | - | - | - |
| 40758 | N/A | Point | - | - | - | - | S116794 | 28TH AVE: ULLOA ST | - | F | F | - | F | 23253000 | 23253000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ULLOA ST | ULLOA ST | 16372 | 16372 | 37.74075807 | -122.48520464 | 28TH AVE \ ULLOA ST | 28TH AVE \ ULLOA ST | 1738699977000 | middleware_editor | ALL WAY | ULLOA ST intersection | - | - | - | - | - | - | - | 57845 | 1052870400000 | -122.48520464 | 37.74075807 | - | 1738332720000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572800000 | 28TH AVE | - | - | - | - | - | - |
| 40759 | N/A | Point | - | - | - | - | S116795 | ULLOA ST: 28TH AVE | - | F | F | - | F | 23253000 | 23253000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ULLOA ST | ULLOA ST | 16373 | 16373 | 37.74075807 | -122.48520464 | 28TH AVE \ ULLOA ST | 28TH AVE \ ULLOA ST | 1738174897000 | middleware_editor | ALL WAY | ULLOA ST intersection | - | - | - | - | - | - | - | 57846 | 1052870400000 | -122.48520464 | 37.74075807 | - | 1574726400000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572800000 | 28TH AVE | - | - | - | - | - | - |
| 40760 | N/A | Point | - | - | - | - | S116796 | ULLOA ST: 28TH AVE | - | F | F | - | F | 23253000 | 23253000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ULLOA ST | ULLOA ST | 16374 | 16374 | 37.74075807 | -122.48520464 | 28TH AVE \ ULLOA ST | 28TH AVE \ ULLOA ST | 1738174882000 | middleware_editor | ALL WAY | ULLOA ST intersection | - | - | - | - | - | - | - | 57847 | 1052870400000 | -122.48520464 | 37.74075807 | - | 1574726400000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572800000 | 28TH AVE | - | - | - | - | - | - |
| 40761 | N/A | Point | 1 | 1 | 600 - 625 | - | S116800 | 600-625 WEBSTER ST | 600-625 WEBSTER ST | F | F | - | F | 13529000 | 13529000 | - | - | CENTER ISLAND, SOUTHBOUND TRAFFIC | - | - | - | - | HAYES ST | HAYES ST | 16377 | 16377 | 37.77627776 | -122.42960217 | - | - | 1710539427000 | MTA | LANE ENDS MERGE RIGHT | HAYES ST to IVY ST (600 - 625) | - | CI ON GROVE | - | - | - | - | - | 57848 | 1052870400000 | -122.42960217 | 37.77627776 | - | - | - | D5 | - | OTHER WARNING | WARNING | W9-2.0003 | 36X36 | SUP1 | 2IN IRON POST | IS | 1373572800000 | WEBSTER ST | 600 - 625 WEBSTER ST | 600 - 625 WEBSTER ST | 600 WEBSTER ST | - | IVY ST | IVY ST |
| 40762 | N/A | Point | 1 | 1 | 1 - 4 | - | S116801 | 1-4 MIRALOMA DR | 1-4 MIRALOMA DR | F | F | - | F | 9066000 | 9066000 | - | - | CENTER ISLAND, NORTHBOUND TRAFFIC | - | - | - | - | KENSINGTON WAY \ PORTOLA DR | KENSINGTON WAY \ PORTOLA DR | 16378 | 16378 | 37.7403186 | -122.45894472 | - | - | 1729702535000 | middleware_editor | KENSINGTON WAY USE RIGHT LANE | KENSINGTON WAY \ PORTOLA DR to MARNE AVE (1 - 4) | - | 15`SOUTH | - | - | - | - | - | 57849 | 1052956800000 | -122.45894472 | 37.7403186 | - | - | - | D7 | - | OTHER GUIDE | GUIDE | G-K(SF).0001 | 30X24 | SUP2 | 2IN IRON POST | IS | 1373572800000 | MIRALOMA DR | 1 - 4 MIRALOMA DR | 1 - 4 MIRALOMA DR | 1 MIRALOMA DR | - | MARNE AVE | MARNE AVE |
| 40763 | N/A | Point | - | - | - | - | S116803 | 43RD AVE: ORTEGA ST | - | F | F | - | F | 27765000 | 27765000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 43RD AVE | 43RD AVE | 16379 | 16379 | 37.75123977 | -122.50206032 | ORTEGA ST \ 43RD AVE | ORTEGA ST \ 43RD AVE | 1748898678000 | middleware_editor | STOP | 43RD AVE intersection | - | - | - | - | - | - | - | 57850 | 1052982000000 | -122.50206032 | 37.75123977 | - | 1493794800000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373572800000 | ORTEGA ST | - | - | - | - | - | - |
| 40764 | N/A | Point | - | - | - | - | S116804 | 43RD AVE: ORTEGA ST | - | F | F | - | F | 27765000 | 27765000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 43RD AVE | 43RD AVE | 16380 | 16380 | 37.75123977 | -122.50206032 | ORTEGA ST \ 43RD AVE | ORTEGA ST \ 43RD AVE | 1747261292000 | middleware_editor | ALL WAY | 43RD AVE intersection | - | - | - | - | - | - | - | 57851 | 1052982000000 | -122.50206032 | 37.75123977 | - | 1747252920000 | - | D4 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373572800000 | ORTEGA ST | - | - | - | - | - | - |
| 40765 | N/A | Point | - | - | - | - | S118884 | STANYAN ST: BEULAH ST | - | F | F | - | F | 26428000 | 26428000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BEULAH ST | STANYAN ST | 16381 | 16381 | 37.7673069 | -122.45316479 | STANYAN ST \ BEULAH ST | BEULAH ST \ STANYAN ST | 1710539427000 | MTA | (45 LA-DN) | STANYAN ST intersection | - | NECORNER | - | - | - | - | - | 57852 | 1084147200000 | -122.45316479 | 37.7673069 | - | - | - | D5 | - | OTHER WARNING | WARNING | W16-7P.0001 | 18X18 | SUP1 | LIGHT POLE | IS | 1373573460000 | BEULAH ST | - | - | - | - | - | - |
| 40766 | N/A | Point | 1 | 1 | 200 - 399 | - | S118885 | 200-399 WASHINGTON ST | 200-399 WASHINGTON ST | F | F | - | F | 13405000 | 13405000 | - | - | SOUTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | DAVIS ST | DAVIS ST | 16382 | 16382 | 37.79603054 | -122.3993188 | - | - | 1710539427000 | MTA | MONTHLY ENTRANCE ONLY OTHERS USE ENTRANCE ON CLAY ST. | DAVIS ST to BATTERY ST (200 - 399) | - | 200' WEST @ ENTRANCE TO GARAGE BELO..... | - | - | - | - | - | 57853 | 1084233600000 | -122.3993188 | 37.79603054 | - | - | - | D3 | - | OTHER GUIDE | GUIDE | G-M(SF).0017 | 30X30 | SUP1 | LIGHT POLE | IS | 1373573460000 | WASHINGTON ST | 200 - 399 WASHINGTON ST | 200 - 399 WASHINGTON ST | 200 WASHINGTON ST | - | BATTERY ST | BATTERY ST |
| 40767 | N/A | Point | 1 | 1 | 52 - 99 | - | S122349 | 52-99 LEAVENWORTH ST | 52-99 LEAVENWORTH ST | F | F | - | F | 8238000 | 8238000 | - | - | WEST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | MCALLISTER ST | MCALLISTER ST | 16893 | 16893 | 37.7813951 | -122.41377098 | - | - | 1710539427000 | MTA | WE KNOW THE BIRDS MIGHT BE HUNGRY BUT FEEDING THEM ETC | MCALLISTER ST to GOLDEN GATE AVE (52 - 99) | - | 200'SOUTH ON LP 21'WEST OF GOLD LP(..... | - | - | - | - | - | 57854 | 1136246400000 | -122.41377098 | 37.7813951 | - | - | - | D6 | - | OTHER REGULATORY | REG | R(SF).0320 | 14X10 | SUP1 | LIGHT POLE | IS | 1373574540000 | LEAVENWORTH ST | 52 - 99 LEAVENWORTH ST | 52 - 99 LEAVENWORTH ST | 52 LEAVENWORTH ST | - | GOLDEN GATE AVE | GOLDEN GATE AVE |
| 40768 | N/A | Point | 1 | 1 | 700 - 760 | - | S122356 | PNDG MORSE ST | 700-760 MORSE ST | T | T | - | F | 9397001 | 9397001 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | LOWELL ST | LOWELL ST | 16894 | 16894 | 37.71080676 | -122.44683268 | - | - | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | LOWELL ST to WHIPPLE ST (700 - 760) | 096056 | 12`NORTH OF NPL#789 | - | - | - | - | - | 57855 | 1100649600000 | -122.44683268 | 37.71080676 | - | - | - | D11 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | MUNI POLE | IS | 1373574540000 | MORSE ST | PNDG MORSE ST | 700 - 760 MORSE ST | - | - | WHIPPLE ST | WHIPPLE ST |
| 40769 | N/A | Point | - | - | - | - | S122357 | FULTON ST: 32ND AVE | - | F | F | - | F | 5938000 | 27817000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 31ST AVE | FULTON ST | 16895 | 16895 | 37.772315621509 | -122.491470188749 | - | 32ND AVE \ FULTON ST | 1735066574000 | middleware_editor | PEDESTRIAN (SYM) XING/(45 LA-DN) | FULTON ST intersection | - | 25' EAST | - | - | - | - | - | 57856 | 1136332800000 | -122.49168805 | 37.77222749 | - | - | - | D1 | - | PEDESTRIAN(LA DN) | WARNING | W11-2+SW44(CA).01 | 30X30 | SUP2 | MUNI POLE | IS | 1373574540000 | 32ND AVE | 5500 - 5733 FULTON ST | - | - | - | 32ND AVE | - |
| 40770 | N/A | Point | 1 | 1 | 6595 - 6699 | - | S122365 | 6595-6699 FULTON ST | 6595-6699 FULTON ST | F | F | - | F | 5949000 | 5949000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 42ND AVE | 42ND AVE | 16897 | 16897 | 37.7717139 | -122.50293615 | - | - | 1710539427000 | MTA | PEDESTRIAN (SYM) | 42ND AVE to 43RD AVE \ CHAIN OF LAKES DR (6595 - 6699) | 102337 | 60FT EAST OF 43RD AVE | - | - | - | - | - | 57857 | 1136419200000 | -122.50293615 | 37.7717139 | - | 1600214400000 | - | D1 | - | OTHER WARNING | WARNING | W11-2.0003 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373574540000 | FULTON ST | 6595 - 6699 FULTON ST | 6595 - 6699 FULTON ST | 6595 FULTON ST | - | 43RD AVE \ CHAIN OF LAKES DR | 43RD AVE \ CHAIN OF LAKES DR |
| 40771 | N/A | Point | 1 | 1 | 6595 - 6699 | - | S122368 | 6595-6699 FULTON ST | 6595-6699 FULTON ST | F | F | - | F | 5949000 | 5949000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 42ND AVE | 42ND AVE | 16898 | 16898 | 37.7717139 | -122.50293615 | - | - | 1710539427000 | MTA | PEDESTRIAN (SYM) XING/(45 LA-DN) | 42ND AVE to 43RD AVE \ CHAIN OF LAKES DR (6595 - 6699) | - | OPP NEC | - | - | - | - | - | 57858 | 1136419200000 | -122.50293615 | 37.7717139 | - | - | - | D1 | - | PEDESTRIAN(LA DN) | WARNING | W11-2+SW44(CA).01 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373574540000 | FULTON ST | 6595 - 6699 FULTON ST | 6595 - 6699 FULTON ST | 6595 FULTON ST | - | 43RD AVE \ CHAIN OF LAKES DR | 43RD AVE \ CHAIN OF LAKES DR |
| 40772 | N/A | Point | - | - | - | - | S122371 | 3RD ST: THOMAS AVE | - | F | F | - | F | 20502000 | 20502000 | - | - | CENTER ISLAND, N LINE, NORTHBOUND | - | - | - | - | 3RD ST | 03RD ST | 16899 | 16899 | 37.73085518 | -122.39207296 | THOMAS AVE \ 3RD ST | THOMAS AVE \ 03RD ST | 1710539427000 | MTA | NO LEFT TURN (SYM)/NO U TURN (SYM) | 03RD ST intersection | - | NORTH CENTER ISLAND | - | - | - | - | - | 57859 | 1136592000000 | -122.39207296 | 37.73085518 | - | 1681344000000 | - | D10 | - | NO LEFT TURN | REG | R3-18.0001 | 24X24 | SUP1 | SIGNAL POLE | IS | 1373574540000 | THOMAS AVE | - | - | - | - | - | - |
| 40773 | N/A | Point | - | - | - | - | S118597 | INGALLS ST: HARBOR RD | - | F | F | - | F | 20061000 | 20061000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | INGALLS ST | INGALLS ST | 16902 | 16902 | 37.73338073 | -122.37993173 | HARBOR RD \ INGALLS ST | HARBOR RD \ INGALLS ST | 1710539427000 | MTA | ALL WAY | INGALLS ST intersection | - | - | - | - | - | - | - | 57860 | 1080259200000 | -122.37993173 | 37.73338073 | - | - | - | D10 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | LIGHT POLE | IS | 1373573340000 | HARBOR RD | - | - | - | - | - | - |
| 40774 | N/A | Point | 1 | 1 | 900 - 999 | - | S124061 | 900-1099 4TH ST | 900-999 04TH ST | F | F | - | F | 270002 | 270002 | - | - | WEST SIDE | - | - | - | - | BERRY ST | BERRY ST | 16928 | 16928 | 37.77540709 | -122.39285066 | - | - | 1710539427000 | MTA | TANSAT | BERRY ST to MISSION CREEK (900 - 999) | - | 250' SOUTH | - | - | - | - | - | 57861 | 1150070400000 | -122.39285066 | 37.77540709 | - | - | - | D6 | - | TOW (TANSAT) | REG | R37(CA).0090 | 18X21 | SUP1 | UNKNOWN | IS | 1373575080000 | 04TH ST | 900 - 999 4TH ST | 900 - 999 04TH ST | 900 4TH ST | - | MISSION CREEK | MISSION CREEK |
| 40775 | N/A | Point | - | - | - | - | S123141 | UNION ST: SCOTT ST | - | F | F | - | F | 26873000 | 26873000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SCOTT ST | UNION ST | 16929 | 16929 | 37.7965358650683 | -122.440331652755 | UNION ST \ SCOTT ST | SCOTT ST \ UNION ST | 1736285748000 | middleware_editor | ALL WAY | UNION ST intersection | - | - | - | - | - | - | - | 57862 | 1143417600000 | -122.44042175 | 37.79646144 | - | 1735309380000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373574780000 | SCOTT ST | - | - | - | - | - | - |
| 40776 | N/A | Point | - | - | - | - | S121017 | MISSION ST: 10TH ST | - | F | F | - | F | 24414000 | 24414000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 10TH ST | 10TH ST | 16930 | 16930 | 37.77527206 | -122.41590818 | MISSION ST \ 10TH ST | MISSION ST \ 10TH ST | 1752868879000 | middleware_editor | NO LEFT TURN (SYM) EXC BUSES AND TAXIS | 10TH ST intersection | - | - | - | - | - | - | - | 57863 | 1115967600000 | -122.41590818 | 37.77527206 | - | 1460530800000 | 1752868800000 | D6 | - | NO LEFT TURN | REG | R3-2(SF).0060 | 36X45 | SUP1 | 2IN IRON POST | RETD | 1373574120000 | MISSION ST | - | - | - | - | - | - |
| 40777 | N/A | Point | - | - | - | - | S121020 | 3RD ST: THOMAS AVE | - | F | F | - | F | 20502000 | 20502000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 3RD ST | 03RD ST | 16933 | 16933 | 37.73085518 | -122.39207296 | THOMAS AVE \ 3RD ST | THOMAS AVE \ 03RD ST | 1710539427000 | MTA | THOMAS (RA)/THORNTON (LA) | 03RD ST intersection | - | - | - | - | - | - | - | 57864 | 1116028800000 | -122.39207296 | 37.73085518 | - | 1707383700000 | - | D10 | - | OTHER GUIDE | GUIDE | G-T(SF).0009 | 72X30 | SUP1 | OVERHEAD MAST ARM | IS | 1373574120000 | THOMAS AVE | - | - | - | - | - | - |
| 40778 | N/A | Point | - | - | - | - | S123687 | MISSISSIPPI ST: 7TH ST \ 16TH | - | F | F | - | F | 23785000 | 23785000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 07TH ST \ MISSISSIPPI ST | 07TH ST \ MISSISSIPPI ST | 16934 | 16934 | 37.76654458 | -122.39506055 | 16TH ST \ 07TH ST \ MISSISSIPPI ST | 16TH ST \ 07TH ST \ MISSISSIPPI ST | 1710967591000 | evillan | 2 TRACKS | 07TH ST \ MISSISSIPPI ST intersection | - | 10'WEST OF CROSSWALK | - | - | - | - | - | 57865 | 1147392000000 | -122.39506055 | 37.76654458 | - | - | - | D10 | - | OTHER WARNING | WARNING | W48(CA).0001 | 30X24 | SUP1 | LIGHT POLE | IS | 1373574960000 | 16TH ST | - | - | - | - | - | - |
| 40779 | N/A | Point | 1 | - | - | - | S123688 | 900-999 16TH ST | - | F | F | - | F | 701001 | 701000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 07TH ST \ MISSISSIPPI ST | - | 16935 | 16935 | 37.76648727 | -122.39597883 | - | - | 1721159599000 | middleware_editor | 2 TRACKS | - | - | 254'W. MISSISSIPPI ST | - | - | - | - | - | 57866 | 1147392000000 | -122.39597883 | 37.76648727 | - | 1711411200000 | - | D10 | - | OTHER WARNING | WARNING | W48(CA).0001 | 30X24 | SUP1 | 2IN IRON POST | IS | 1373574960000 | 16TH ST | 900 - 959 16TH ST | 16TH ST | - | - | DAGGETT ST | - |
| 40780 | N/A | Point | 1 | 1 | 3900 - 3999 | - | S124237 | 3900-3999 24TH ST | 3900-3999 24TH ST | F | F | - | F | 1361000 | 1361000 | - | - | NORTH SIDE | - | - | - | - | SANCHEZ ST | SANCHEZ ST | 17385 | 17385 | 37.75150401 | -122.4307677 | - | - | 1752526644000 | middleware_editor | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | SANCHEZ ST to NOE ST (3900 - 3999) | - | OPP#3969 | - | - | - | - | - | 57867 | 1150959600000 | -122.4307677 | 37.75150401 | - | - | - | D8 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373575140000 | 24TH ST | 3900 - 3999 24TH ST | 3900 - 3999 24TH ST | 3900 24TH ST | - | NOE ST | NOE ST |
| 40781 | N/A | Point | 1 | 1 | 4000 - 4099 | - | S124238 | 4000-4099 24TH ST | 4000-4099 24TH ST | F | F | - | F | 1362000 | 1362000 | - | - | NORTH SIDE | - | - | - | - | NOE ST | NOE ST | 17386 | 17386 | 37.75137045 | -122.4329831 | - | - | 1752266110000 | middleware_editor | NO DBL PRK ANY TIME DBL FINE ZONE $135 6AM-9AM/ETC | NOE ST to CASTRO ST (4000 - 4099) | - | IFO#4010 | - | - | - | - | - | 57868 | 1150959600000 | -122.4329831 | 37.75137045 | - | - | - | D8 | - | PARKING:NO DBL PRK | REG | R39-1(SF).0003 | 18X21 | SUP2 | 2IN IRON POST | IS | 1373575140000 | 24TH ST | 4000 - 4099 24TH ST | 4000 - 4099 24TH ST | 4000 24TH ST | - | CASTRO ST | CASTRO ST |
| 40782 | N/A | Point | 1 | 1 | 2000 - 2099 | - | S124244 | 2000-2099 BROADWAY | 2000-2099 BROADWAY | T | T | - | F | 3175000 | 3175000 | - | - | NORTH SIDE, WESTBOUND TRAFFIC | - | - | - | - | LAGUNA ST | LAGUNA ST | 17391 | 17391 | 37.7947896 | -122.43081157 | - | - | 1746135734000 | middleware_editor | SCHOOL (SYM)/SCHOOL | LAGUNA ST to BUCHANAN ST (2000 - 2099) | 106160 | WPL 2012 | - | - | - | - | - | 57869 | 1151046000000 | -122.43081157 | 37.7947896 | - | 1746133380000 | - | D2 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP1 | LIGHT POLE | IS | 1373575140000 | BROADWAY | 2000 - 2099 BROADWAY | 2000 - 2099 BROADWAY | 2000 BROADWAY | - | BUCHANAN ST | BUCHANAN ST |
| 40783 | N/A | Point | 1 | 1 | 1500 - 1599 | - | S120556 | 1500-1599 CABRILLO ST | 1500-1599 CABRILLO ST | F | F | - | F | 3483000 | 3483000 | - | - | NORTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 16TH AVE | 16TH AVE | 17409 | 17409 | 37.7748523 | -122.47521854 | - | - | 1712182711000 | middleware_editor | SCHOOL (SYM)/SCHOOL | 16TH AVE to 17TH AVE (1500 - 1599) | - | INFO 1502 | - | - | - | - | - | 57870 | 1110240000000 | -122.47521854 | 37.7748523 | - | 1712156700000 | - | D1 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1373574000000 | CABRILLO ST | 1500 - 1599 CABRILLO ST | 1500 - 1599 CABRILLO ST | 1500 CABRILLO ST | - | 17TH AVE | 17TH AVE |
| 40784 | N/A | Point | 1 | 1 | 1700 - 1799 | - | S120557 | 1700-1799 CABRILLO ST | 1700-1799 CABRILLO ST | F | F | - | F | 3485000 | 3485000 | - | - | SOUTH SIDE, EASTBOUND TRAFFIC | - | - | - | - | 18TH AVE | 18TH AVE | 17410 | 17410 | 37.77475441 | -122.47736485 | - | - | 1741715583000 | middleware_editor | SCHOOL/SPEED LIMIT 15/WHEN CHILDREN ARE PRESENT | 18TH AVE to 19TH AVE (1700 - 1799) | 133845 | EPL #1707 | - | - | - | - | - | 57871 | 1321516800000 | -122.47736485 | 37.77475441 | - | - | - | D1 | - | OTHER REGULATORY | REG | SR4-1(CA).0001 | 24X48 | SUP2 | 2IN IRON POST | IS | 1373574000000 | CABRILLO ST | 1700 - 1799 CABRILLO ST | 1700 - 1799 CABRILLO ST | 1700 CABRILLO ST | - | 19TH AVE | 19TH AVE |
| 40785 | N/A | Point | 1 | 1 | 700 - 799 | - | S120558 | 700-799 17TH AVE | 700-799 17TH AVE | F | F | - | F | 756000 | 756000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | CABRILLO ST | CABRILLO ST | 17411 | 17411 | 37.77389522 | -122.4756823 | - | - | 1710539427000 | MTA | SCHOOL (SYM)/SCHOOL | CABRILLO ST to FULTON ST (700 - 799) | - | NPL#714 | - | - | - | - | - | 57872 | 1110240000000 | -122.4756823 | 37.77389522 | - | 1570665600000 | - | D1 | - | SCHOOL | WARNING | SW24-1(CA).0001 | 30X42 | SUP2 | 2IN IRON POST | IS | 1373574000000 | 17TH AVE | 700 - 799 17TH AVE | 700 - 799 17TH AVE | 700 17TH AVE | - | FULTON ST | FULTON ST |
| 40786 | N/A | Point | - | - | - | - | S120562 | SARGENT ST: BRIGHT ST | - | F | F | - | F | 22598000 | 22598000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BRIGHT ST | BRIGHT ST | 17412 | 17412 | 37.71613507 | -122.46352104 | SARGENT ST \ BRIGHT ST | SARGENT ST \ BRIGHT ST | 1736968550000 | middleware_editor | STOP | BRIGHT ST intersection | - | - | - | - | - | - | - | 57873 | 1110326400000 | -122.46352104 | 37.71613507 | - | - | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373574000000 | SARGENT ST | - | - | - | - | - | - |
| 40787 | N/A | Point | - | - | - | - | S120563 | SARGENT ST: BRIGHT ST | - | F | F | - | F | 22598000 | 22598000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | BRIGHT ST | BRIGHT ST | 17413 | 17413 | 37.71613507 | -122.46352104 | SARGENT ST \ BRIGHT ST | SARGENT ST \ BRIGHT ST | 1736968536000 | middleware_editor | STOP | BRIGHT ST intersection | - | 3`WEST OF UP | - | - | - | - | - | 57874 | 1110326400000 | -122.46352104 | 37.71613507 | - | 1736849100000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373574000000 | SARGENT ST | - | - | - | - | - | - |
| 40788 | N/A | Point | 1 | 1 | 700 - 799 | - | S120564 | 700-799 SCOTT ST | 700-799 SCOTT ST | F | F | - | F | 11689000 | 11689000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | GROVE ST | GROVE ST | 17414 | 17414 | 37.77660296 | -122.43641269 | - | - | 1710539427000 | MTA | STOP | GROVE ST to FULTON ST (700 - 799) | - | OPPOSITE SOUTHWEST CORNER | - | - | - | - | - | 57875 | 1110326400000 | -122.43641269 | 37.77660296 | - | - | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373574000000 | SCOTT ST | 700 - 799 SCOTT ST | 700 - 799 SCOTT ST | 700 SCOTT ST | - | FULTON ST | FULTON ST |
| 40789 | N/A | Point | - | - | - | - | S120565 | SCOTT ST: GROVE ST | - | F | F | - | F | 26051000 | 26051000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GROVE ST | GROVE ST | 17415 | 17415 | 37.77613784 | -122.43631814 | SCOTT ST \ GROVE ST | SCOTT ST \ GROVE ST | 1743019737000 | middleware_editor | STOP | GROVE ST intersection | - | - | - | - | - | - | - | 57876 | 1110355200000 | -122.43631814 | 37.77613784 | - | 1743007500000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373574000000 | SCOTT ST | - | - | - | - | - | - |
| 40790 | N/A | Point | - | - | - | - | S120566 | GROVE ST: SCOTT ST | - | F | F | - | F | 26051000 | 26051000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GROVE ST | GROVE ST | 17416 | 17416 | 37.77613784 | -122.43631814 | SCOTT ST \ GROVE ST | SCOTT ST \ GROVE ST | 1729886399000 | middleware_editor | ALL WAY | GROVE ST intersection | - | - | - | - | - | - | - | 57877 | 1110326400000 | -122.43631814 | 37.77613784 | - | - | - | D5 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373574000000 | SCOTT ST | - | - | - | - | - | - |
| 40791 | N/A | Point | - | - | - | - | S116896 | HOWARD ST: 4TH ST | - | F | F | - | F | 24627000 | 24627000 | - | - | SOUTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | HOWARD ST | 04TH ST | 17417 | 17417 | 37.78325924 | -122.40270815 | 4TH ST \ HOWARD ST | HOWARD ST \ 04TH ST | 1710539427000 | MTA | LEFT LANE MUST TURN LEFT | 04TH ST intersection | - | SOTHEAST CORNER | - | - | - | - | - | 57878 | 1054080000000 | -122.40270815 | 37.78325924 | - | - | - | D6 | - | OTHER REGULATORY | REG | R3-7.0003 | 36X36 | SUP1 | LIGHT POLE | IS | 1373572800000 | HOWARD ST | - | - | - | - | - | - |
| 40792 | N/A | Point | - | 1 | 1400 - 1499 | - | S116897 | 1400-1499 7TH ST | 1400-1499 07TH ST | F | F | - | F | 384000 | 384000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | DAGGETT ST | DAGGETT ST | 17418 | 17418 | 37.76685527 | -122.39544349 | - | - | 1710539427000 | MTA | BIKE (SYM) LANE | DAGGETT ST to 16TH ST \ MISSISSIPPI ST (1400 - 1499) | - | 50S / ABOVE R2(25) | - | - | - | - | - | 57879 | 1054080000000 | -122.39544349 | 37.76685527 | - | - | - | D10 | - | BIKE REG | REG | R81(CA).0002 | 24X18 | SUP1 | 2IN IRON POST | IS | 1373572800000 | 07TH ST | 1400 - 1499 7TH ST | 1400 - 1499 07TH ST | 1400 7TH ST | - | 16TH ST \ MISSISSIPPI ST | 16TH ST \ MISSISSIPPI ST |
| 40793 | N/A | Point | - | - | - | - | S116898 | 7TH ST: TOWNSEND ST | - | F | F | - | F | 23854000 | 23854000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | TOWNSEND ST | 07TH ST | 17419 | 17419 | 37.77181713 | -122.40165668 | 7TH ST \ TOWNSEND ST | TOWNSEND ST \ 07TH ST | 1710539427000 | MTA | BIKE (SYM) LANE | 07TH ST intersection | - | - | - | - | - | - | - | 57880 | 1054080000000 | -122.40165668 | 37.77181713 | - | - | - | D10 | - | BIKE REG | REG | R81(CA).0002 | 24X18 | SUP1 | LIGHT POLE | IS | 1373572800000 | TOWNSEND ST | - | - | - | - | - | - |
| 40794 | N/A | Point | 1 | 1 | 400 - 499 | - | S123735 | 400-499 MCALLISTER ST | 400-499 MCALLISTER ST | F | F | - | F | 8894000 | 8894000 | - | - | NORTH SIDE | - | - | - | - | DR CARLTON B GOODLETT PL \ POLK ST | DR CARLTON B GOODLETT PL \ POLK ST | 18136 | 18136 | 37.78015826 | -122.41942174 | - | - | 1732570444000 | middleware_editor | TANS 3PM-7PM EXC SAT & SUN | DR CARLTON B GOODLETT PL \ POLK ST to VAN NESS AVE (400 - 499) | - | 220' WEST @ PM | - | - | - | - | - | 57881 | 1147737600000 | -122.41942174 | 37.78015826 | - | - | - | D6 | - | OTHER REGULATORY | REG | R37(CA).0022 | 18X21 | SUP1 | 2IN IRON POST | IS | 1373574960000 | MCALLISTER ST | 400 - 499 MCALLISTER ST | 400 - 499 MCALLISTER ST | 400 MCALLISTER ST | - | VAN NESS AVE | VAN NESS AVE |
| 40795 | N/A | Point | - | - | - | - | S123748 | GRANT AVE: GREENWICH ST | - | F | F | - | F | 25379000 | 25379000 | - | - | SOUTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GREENWICH ST | GREENWICH ST | 18139 | 18139 | 37.80250477 | -122.40795586 | GRANT AVE \ GREENWICH ST | GRANT AVE \ GREENWICH ST | 1712153601000 | middleware_editor | ALL WAY | GREENWICH ST intersection | - | - | - | - | - | - | - | 57882 | 1147824000000 | -122.40795586 | 37.80250477 | - | - | - | D3 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373574960000 | GRANT AVE | - | - | - | - | - | - |
| 40796 | N/A | Point | - | - | - | - | S123749 | ANZA ST: 11TH AVE | - | F | F | - | F | 27296000 | 27296000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 11TH AVE | ANZA ST | 18140 | 18140 | 37.77884909 | -122.4694947 | ANZA ST \ 11TH AVE | 11TH AVE \ ANZA ST | 1710539427000 | MTA | ALL WAY | ANZA ST intersection | - | - | - | - | - | - | - | 57883 | 1147824000000 | -122.4694947 | 37.77884909 | - | 1558396800000 | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | 2IN IRON POST | IS | 1373574960000 | 11TH AVE | - | - | - | - | - | - |
| 40797 | N/A | Point | - | - | - | - | S123750 | ANZA ST: 11TH AVE | - | F | F | - | F | 27296000 | 27296000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 11TH AVE | ANZA ST | 18141 | 18141 | 37.77884909 | -122.4694947 | ANZA ST \ 11TH AVE | 11TH AVE \ ANZA ST | 1710539427000 | MTA | ALL WAY | ANZA ST intersection | - | - | - | - | - | - | - | 57884 | 1147824000000 | -122.4694947 | 37.77884909 | - | - | - | D1 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP2 | LIGHT POLE | IS | 1373574960000 | 11TH AVE | - | - | - | - | - | - |
| 40798 | N/A | Point | - | - | - | - | S123751 | UNION ST: GRANT AVE | - | F | F | - | F | 25343000 | 25343000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | UNION ST | GRANT AVE | 18142 | 18142 | 37.80063802 | -122.40758444 | GRANT AVE \ UNION ST | UNION ST \ GRANT AVE | 1712192462000 | middleware_editor | ALL WAY | GRANT AVE intersection | - | - | - | - | - | - | - | 57885 | 1147824000000 | -122.40758444 | 37.80063802 | - | 1598832000000 | - | D3 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373574960000 | UNION ST | - | - | - | - | - | - |
| 40799 | N/A | Point | - | - | - | - | S125761 | JACKSON ST: WEBSTER ST | - | F | F | - | F | 26650000 | 26650000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | WEBSTER ST | JACKSON ST | 18144 | 18144 | 37.79267992 | -122.43291758 | JACKSON ST \ WEBSTER ST | WEBSTER ST \ JACKSON ST | 1743443684000 | middleware_editor | ALL WAY | JACKSON ST intersection | - | - | - | - | - | - | - | 57886 | 1159513200000 | -122.43291758 | 37.79267992 | - | 1591945200000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | MUNI POLE | IS | 1373575620000 | WEBSTER ST | - | - | - | - | - | - |
| 40800 | N/A | Point | - | - | - | - | S125762 | JACKSON ST: WEBSTER ST | - | F | F | - | F | 26650000 | 26650000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | WEBSTER ST | JACKSON ST | 18145 | 18145 | 37.79267992 | -122.43291758 | JACKSON ST \ WEBSTER ST | WEBSTER ST \ JACKSON ST | 1743443755000 | middleware_editor | ALL WAY | JACKSON ST intersection | - | - | - | - | - | - | - | 57887 | 1159513200000 | -122.43291758 | 37.79267992 | - | 1591945200000 | - | D2 | - | ALL WAY | REG | R1-3P.0001 | 18X06 | SUP1 | 2IN IRON POST | IS | 1373575620000 | WEBSTER 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