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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45451 | N/A | Point | 1 | 1 | 1036 - 1071 | - | S102627 | 1036-1071 HARRISON ST | 1036-1071 HARRISON ST | F | F | - | F | 6726000 | 6726000 | - | - | SOUTH SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | COLUMBIA SQUARE ST | COLUMBIA SQUARE ST | 3117 | 3117 | 37.77639108 | -122.40518611 | - | - | 1713834578000 | middleware_editor | ONE WAY (RA) | COLUMBIA SQUARE ST to SHERMAN ST (1036 - 1071) | - | OPP CENTER LINE OF COLUMBIA SQUARE ST | - | - | - | - | - | 62546 | -387072000000 | -122.40518611 | 37.77639108 | - | 1462320000000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | 2IN IRON POST | IS | 1373568360000 | HARRISON ST | 1036 - 1071 HARRISON ST | 1036 - 1071 HARRISON ST | 1036 HARRISON ST | - | SHERMAN ST | SHERMAN ST |
| 45452 | N/A | Point | 1 | 1 | 1060 - 1099 | - | S102628 | 1060-1099 HARRISON ST | 1060-1099 HARRISON ST | F | F | - | F | 6727000 | 6727000 | - | - | SOUTH SIDE, SOUTHBOUND TRAFFIC | - | - | - | - | SHERMAN ST | SHERMAN ST | 3118 | 3118 | 37.77583807 | -122.40588601 | - | - | 1710539427000 | MTA | ONE WAY (RA) | SHERMAN ST to 07TH ST (1060 - 1099) | - | OPP. CENTER LINE OF SHERMAN ST. | - | - | - | - | - | 62547 | -387072000000 | -122.40588601 | 37.77583807 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | 2IN IRON POST | IS | 1373568360000 | HARRISON ST | 1060 - 1099 HARRISON ST | 1060 - 1099 HARRISON ST | 1060 HARRISON ST | - | 07TH ST | 07TH ST |
| 45453 | N/A | Point | - | - | - | - | S102629 | 1ST ST: FOLSOM ST | - | T | T | - | F | 24522000 | 24522000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FOLSOM ST | 01ST ST | 3119 | 3119 | 37.78729822 | -122.39448127 | 1ST ST \ FOLSOM ST | FOLSOM ST \ 01ST ST | 1710539427000 | MTA | ONE WAY (RA) | 01ST ST intersection | - | - | - | - | - | - | - | 62548 | -387072000000 | -122.39448127 | 37.78729822 | - | 1606953600000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373568360000 | FOLSOM ST | - | - | - | - | - | - |
| 45454 | N/A | Point | - | - | - | - | S102630 | BEALE ST: FOLSOM ST | - | F | F | - | F | 24496000 | 24496000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FOLSOM ST | BEALE ST | 3120 | 3120 | 37.78868666 | -122.39272283 | BEALE ST \ FOLSOM ST | FOLSOM ST \ BEALE ST | 1710539427000 | MTA | ONE WAY (RA) | BEALE ST intersection | - | 0 / 0 | - | - | - | - | - | 62549 | -387072000000 | -122.39272283 | 37.78868666 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373568360000 | FOLSOM ST | - | - | - | - | - | - |
| 45455 | N/A | Point | - | - | - | - | S107264 | SANTIAGO ST: 41ST AVE | - | F | F | - | F | 23468000 | 23468000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 41ST AVE | 41ST AVE | 3121 | 3121 | 37.74387941 | -122.49939324 | SANTIAGO ST \ 41ST AVE | SANTIAGO ST \ 41ST AVE | 1710539427000 | MTA | STOP | 41ST AVE intersection | - | 0 / 0 | - | - | - | - | - | 62550 | 209952000000 | -122.49939324 | 37.74387941 | - | 1508198400000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569800000 | SANTIAGO ST | - | - | - | - | - | - |
| 45456 | N/A | Point | - | - | - | - | S107265 | 48TH AVE: KIRKHAM ST | - | F | F | - | F | 27941000 | 27941000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 48TH AVE | 48TH AVE | 3122 | 3122 | 37.7583640671805 | -122.507868334646 | KIRKHAM ST \ 48TH AVE | KIRKHAM ST \ 48TH AVE | 1742917788000 | middleware_editor | STOP | 48TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 62551 | 209977200000 | -122.50793631 | 37.75846589 | - | 1495609200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373569800000 | KIRKHAM ST | - | - | - | - | - | - |
| 45457 | N/A | Point | - | - | - | - | S107312 | MISSOURI ST: SIERRA ST | - | F | F | - | F | 23662000 | 23662000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MISSOURI ST | MISSOURI ST | 3123 | 3123 | 37.75829497 | -122.39608874 | SIERRA ST \ MISSOURI ST | SIERRA ST \ MISSOURI ST | 1710539427000 | MTA | STOP | MISSOURI ST intersection | - | 0 / 0 | - | - | - | - | - | 62552 | 216000000000 | -122.39608874 | 37.75829497 | - | 1561680000000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569800000 | SIERRA ST | - | - | - | - | - | - |
| 45458 | N/A | Point | - | - | - | - | S107313 | 27TH AVE: KIRKHAM ST | - | F | F | - | F | 27426000 | 27426000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 27TH AVE | 27TH AVE | 3124 | 3124 | 37.75945392 | -122.48543735 | KIRKHAM ST \ 27TH AVE | KIRKHAM ST \ 27TH AVE | 1710539427000 | MTA | STOP | 27TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 62553 | 216259200000 | -122.48543735 | 37.75945392 | - | 1465344000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569800000 | KIRKHAM ST | - | - | - | - | - | - |
| 45459 | N/A | Point | - | - | - | - | S107316 | 42ND AVE: MORAGA ST | - | F | F | - | F | 27771000 | 27771000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | MORAGA ST | 42ND AVE | 3126 | 3126 | 37.75500279 | -122.50124924 | 42ND AVE \ MORAGA ST | MORAGA ST \ 42ND AVE | 1713810445000 | middleware_editor | STOP | 42ND AVE intersection | - | 0 / 0 | - | - | - | - | - | 62554 | 216259200000 | -122.50124924 | 37.75500279 | - | 1490227200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373569800000 | MORAGA ST | - | - | - | - | - | - |
| 45460 | N/A | Point | - | - | - | - | S107317 | SECURITY PACIFIC PL: OFARRELL | - | F | F | - | F | 24656000 | 24656000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | OFARRELL ST | OFARRELL ST | 3127 | 3127 | 37.78674762 | -122.40534608 | \SECURITY PACIFIC PL: OFARRELL | SECURITY PACIFIC PL \ OFARRELL ST | 1710539427000 | MTA | STOP | OFARRELL ST intersection | - | 0 / 0 | - | - | - | - | - | 62555 | 216259200000 | -122.40534608 | 37.78674762 | - | - | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569800000 | SECURITY PACIFIC PL | - | - | - | - | - | - |
| 45461 | N/A | Point | - | - | - | - | S107318 | GREEN ST: JONES ST | - | F | F | - | F | 25271000 | 25271000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | GREEN ST | GREEN ST | 3128 | 3128 | 37.79868013 | -122.41557232 | JONES ST \ GREEN ST | JONES ST \ GREEN ST | 1737154707000 | middleware_editor | STOP | GREEN ST intersection | - | 0 / 0 | - | - | - | - | - | 62556 | 216259200000 | -122.41557232 | 37.79868013 | - | 1737077400000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569800000 | JONES ST | - | - | - | - | - | - |
| 45462 | N/A | Point | - | - | - | - | S107319 | GREEN ST: JONES ST | - | F | F | - | F | 25271000 | 25271000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | GREEN ST | GREEN ST | 3129 | 3129 | 37.79868013 | -122.41557232 | JONES ST \ GREEN ST | JONES ST \ GREEN ST | 1737154374000 | middleware_editor | STOP | GREEN ST intersection | - | 0 / 0 | - | - | - | - | - | 62557 | 216259200000 | -122.41557232 | 37.79868013 | - | 1737114300000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569800000 | JONES ST | - | - | - | - | - | - |
| 45463 | N/A | Point | - | - | - | - | S107320 | JONES ST: GREEN ST | - | F | F | - | F | 25271000 | 25271000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | GREEN ST | GREEN ST | 3130 | 3130 | 37.79868013 | -122.41557232 | JONES ST \ GREEN ST | JONES ST \ GREEN ST | 1737154556000 | middleware_editor | STOP | GREEN ST intersection | - | 0 / 0 | - | - | - | - | - | 62558 | 216259200000 | -122.41557232 | 37.79868013 | - | 1737075600000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569800000 | JONES ST | - | - | - | - | - | - |
| 45464 | N/A | Point | - | - | - | - | S107321 | JONES ST: GREEN ST | - | F | F | - | F | 25271000 | 25271000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | GREEN ST | GREEN ST | 3131 | 3131 | 37.79868013 | -122.41557232 | JONES ST \ GREEN ST | JONES ST \ GREEN ST | 1737154223000 | middleware_editor | STOP | GREEN ST intersection | - | 0 / 0 | - | - | - | - | - | 62559 | 216259200000 | -122.41557232 | 37.79868013 | - | 1737112500000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569800000 | JONES ST | - | - | - | - | - | - |
| 45465 | N/A | Point | - | - | - | - | S101835 | ELLIS ST: SCOTT ST | - | F | F | - | F | 26616000 | 26616000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | SCOTT ST | ELLIS ST | 3135 | 3135 | 37.78172708 | -122.43744643 | ELLIS ST \ SCOTT ST | SCOTT ST \ ELLIS ST | 1710539427000 | MTA | STOP | ELLIS ST intersection | - | - | - | - | - | - | - | 62560 | -394934400000 | -122.43744643 | 37.78172708 | - | 878083200000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566920000 | SCOTT ST | - | - | - | - | - | - |
| 45466 | N/A | Point | - | - | - | - | S101836 | ELLIS ST: SCOTT ST | - | F | F | - | F | 26616000 | 26616000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SCOTT ST | ELLIS ST | 3136 | 3136 | 37.78172708 | -122.43744643 | ELLIS ST \ SCOTT ST | SCOTT ST \ ELLIS ST | 1710539427000 | MTA | STOP | ELLIS ST intersection | - | 0 / 00 | - | - | - | - | - | 62561 | -394934400000 | -122.43744643 | 37.78172708 | - | 886723200000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373566920000 | SCOTT ST | - | - | - | - | - | - |
| 45467 | N/A | Point | - | - | - | - | S101839 | ELLIS ST: DIVISADERO ST | - | F | F | - | F | 26800000 | 26800000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | ELLIS ST | DIVISADERO ST | 3138 | 3138 | 37.78152035 | -122.43911394 | DIVISADERO ST \ ELLIS ST | ELLIS ST \ DIVISADERO ST | 1756140514000 | middleware_editor | STOP | DIVISADERO ST intersection | - | 0 / 00 | - | - | - | - | - | 62562 | -394909200000 | -122.43911394 | 37.78152035 | - | 892105200000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373566920000 | ELLIS ST | - | - | - | - | - | - |
| 45468 | N/A | Point | - | - | - | - | S101840 | ELLIS ST: DIVISADERO ST | - | F | F | - | F | 26800000 | 26800000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | ELLIS ST | DIVISADERO ST | 3139 | 3139 | 37.78152035 | -122.43911394 | DIVISADERO ST \ ELLIS ST | ELLIS ST \ DIVISADERO ST | 1756140517000 | middleware_editor | STOP | DIVISADERO ST intersection | - | 0 / 00 | - | - | - | - | - | 62563 | -394909200000 | -122.43911394 | 37.78152035 | - | - | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373566920000 | ELLIS ST | - | - | - | - | - | - |
| 45469 | N/A | Point | - | - | - | - | S101842 | TURK ST: DIVISADERO ST | - | F | F | - | F | 26077000 | 26077000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TURK ST | TURK ST | 3140 | 3140 | 37.77965963 | -122.43874018 | DIVISADERO ST \ TURK ST | DIVISADERO ST \ TURK ST | 1710539427000 | MTA | DO NOT ENTER | TURK ST intersection | - | 0 / 00 | - | - | - | - | - | 62564 | -394934400000 | -122.43874018 | 37.77965963 | - | 1686700800000 | - | D5 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373566920000 | DIVISADERO ST | - | - | - | - | - | - |
| 45470 | N/A | Point | - | - | - | - | S101843 | TURK ST: DIVISADERO ST | - | T | T | - | F | 26077000 | 26077000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | TURK ST | TURK ST | 3141 | 3141 | 37.77965963 | -122.43874018 | DIVISADERO ST \ TURK ST | DIVISADERO ST \ TURK ST | 1710539427000 | MTA | DO NOT ENTER | TURK ST intersection | - | 0 / 00 | - | - | - | - | - | 62565 | -394934400000 | -122.43874018 | 37.77965963 | - | 1686700800000 | - | D5 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | LIGHT POLE | IS | 1373566920000 | DIVISADERO ST | - | - | - | - | - | - |
| 45471 | N/A | Point | - | - | - | - | S107820 | VISITACION AVE: CORA ST | - | F | F | - | F | 20348000 | 20348000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | VISITACION AVE | VISITACION AVE | 3791 | 3791 | 37.7116815007066 | -122.408950142557 | CORA ST \ VISITACION AVE | CORA ST \ VISITACION AVE | 1732126180000 | middleware_editor | STOP | VISITACION AVE intersection | - | 0 / 0 | - | - | - | - | - | 62566 | 257558400000 | -122.40882736 | 37.71170156 | - | 1572480000000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569980000 | CORA ST | - | - | - | - | - | - |
| 45472 | N/A | Point | - | - | - | - | S107821 | WILDE AVE: DELTA ST | - | F | F | - | F | 20838000 | 20838000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | WILDE AVE | DELTA ST | 3792 | 3792 | 37.71781995 | -122.40727155 | DELTA ST \ WILDE AVE | WILDE AVE \ DELTA ST | 1710539427000 | MTA | STOP | DELTA ST intersection | - | 0 / 0 | - | - | - | - | - | 62567 | 257558400000 | -122.40727155 | 37.71781995 | - | 1576195200000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373569980000 | WILDE AVE | - | - | - | - | - | - |
| 45473 | N/A | Point | - | - | - | - | S107823 | VISITACION AVE: DESMOND ST | - | F | F | - | F | 20316000 | 20316000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | VISITACION AVE | DESMOND ST | 3793 | 3793 | 37.71068283 | -122.40520904 | DESMOND ST \ VISITACION AVE | VISITACION AVE \ DESMOND ST | 1735938959000 | middleware_editor | STOP | DESMOND ST intersection | - | 0 / RES #1011-77 | - | - | - | - | - | 62568 | 257558400000 | -122.40520904 | 37.71068283 | - | 1735897500000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569980000 | VISITACION AVE | - | - | - | - | - | - |
| 45474 | N/A | Point | - | - | - | - | S107825 | VISITACION AVE: RUTLAND ST | - | F | F | - | F | 20349000 | 20349000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | VISITACION AVE | VISITACION AVE | 3795 | 3795 | 37.71144776 | -122.40792715 | RUTLAND ST \ VISITACION AVE | RUTLAND ST \ VISITACION AVE | 1710539427000 | MTA | STOP | VISITACION AVE intersection | - | 0 / 0 | - | - | - | - | - | 62569 | 257558400000 | -122.40792715 | 37.71144776 | - | 1572220800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569980000 | RUTLAND ST | - | - | - | - | - | - |
| 45475 | N/A | Point | - | - | - | - | S107826 | VISITACION AVE: RUTLAND ST | - | F | F | - | F | 20349000 | 20349000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | VISITACION AVE | VISITACION AVE | 3796 | 3796 | 37.71144776 | -122.40792715 | RUTLAND ST \ VISITACION AVE | RUTLAND ST \ VISITACION AVE | 1710539427000 | MTA | STOP | VISITACION AVE intersection | - | 0 / 0 | - | - | - | - | - | 62570 | 257558400000 | -122.40792715 | 37.71144776 | - | 1572220800000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373569980000 | RUTLAND ST | - | - | - | - | - | - |
| 45476 | N/A | Point | - | - | - | - | S108075 | 23RD AVE: ORTEGA ST | - | F | F | - | F | 27379000 | 27379000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ORTEGA ST | 23RD AVE | 3797 | 3797 | 37.75218736 | -122.48062888 | 23RD AVE \ ORTEGA ST | ORTEGA ST \ 23RD AVE | 1710539427000 | MTA | STOP | 23RD AVE intersection | - | 0 / 0 | - | - | - | - | - | 62571 | 278726400000 | -122.48062888 | 37.75218736 | - | 1464912000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570040000 | ORTEGA ST | - | - | - | - | - | - |
| 45477 | N/A | Point | - | - | - | - | S108076 | 23RD AVE: ORTEGA ST | - | F | F | - | F | 27379000 | 27379000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ORTEGA ST | 23RD AVE | 3798 | 3798 | 37.75218736 | -122.48062888 | 23RD AVE \ ORTEGA ST | ORTEGA ST \ 23RD AVE | 1710539427000 | MTA | STOP | 23RD AVE intersection | - | 0 / 0 | - | - | - | - | - | 62572 | 278726400000 | -122.48062888 | 37.75218736 | - | 1464912000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570040000 | ORTEGA ST | - | - | - | - | - | - |
| 45478 | N/A | Point | 1 | 1 | 1 - 25 | - | S108077 | 2-25 CERVANTES BLVD | 1-25 CERVANTES BLVD | F | F | - | F | 3873000 | 3873000 | - | - | UNKNOWN | - | - | - | - | BAY ST \ FILLMORE ST | BAY ST \ FILLMORE ST | 3799 | 3799 | 37.80287615 | -122.43704677 | - | - | 1710539427000 | MTA | STOP | BAY ST \ FILLMORE ST to ALHAMBRA ST (1 - 25) | - | E LINE / 0 | - | - | - | - | - | 62573 | 278726400000 | -122.43704677 | 37.80287615 | - | - | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570040000 | CERVANTES BLVD | 1 - 25 CERVANTES BLVD | 1 - 25 CERVANTES BLVD | 1 CERVANTES BLVD | - | ALHAMBRA ST | ALHAMBRA ST |
| 45479 | N/A | Point | - | - | - | - | S108078 | FERN ST: POLK ST | - | F | F | - | F | 25209000 | 25209000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | FERN ST | FERN ST | 3800 | 3800 | 37.7882227 | -122.42021044 | POLK ST \ FERN ST | POLK ST \ FERN ST | 1710539427000 | MTA | STOP | FERN ST intersection | - | 0 / REPAIR | - | - | - | - | - | 62574 | 279417600000 | -122.42021044 | 37.7882227 | - | 1172448000000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | UNKNOWN | IS | 1373570040000 | POLK ST | - | - | - | - | - | - |
| 45480 | N/A | Point | - | - | - | - | S108082 | CALIFORNIA ST: 28TH AVE | - | F | F | - | F | 28017000 | 28017000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 3802 | 3802 | 37.78373715 | -122.48821745 | 28TH AVE \ CALIFORNIA ST | 28TH AVE \ CALIFORNIA ST | 1720056347000 | middleware_editor | STOP | CALIFORNIA ST intersection | - | 0 / 00 | - | - | - | - | - | 62575 | 280368000000 | -122.48821745 | 37.78373715 | - | 1477267200000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373570040000 | 28TH AVE | - | - | - | - | - | - |
| 45481 | N/A | Point | - | - | - | - | S108083 | CALIFORNIA ST: 28TH AVE | - | F | F | - | F | 28017000 | 28017000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | CALIFORNIA ST | CALIFORNIA ST | 3803 | 3803 | 37.78373715 | -122.48821745 | 28TH AVE \ CALIFORNIA ST | 28TH AVE \ CALIFORNIA ST | 1720056381000 | middleware_editor | STOP | CALIFORNIA ST intersection | - | 0 / 00 | - | - | - | - | - | 62576 | 280368000000 | -122.48821745 | 37.78373715 | - | 1479859200000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570040000 | 28TH AVE | - | - | - | - | - | - |
| 45482 | N/A | Point | - | - | - | - | S108086 | PACIFIC AVE: LARKIN ST | - | F | F | - | F | 25305000 | 25305000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PACIFIC AVE | LARKIN ST | 3806 | 3806 | 37.79523766 | -122.41993564 | LARKIN ST \ PACIFIC AVE | PACIFIC AVE \ LARKIN ST | 1711141548000 | middleware_editor | STOP | LARKIN ST intersection | - | 0 / 0 | - | - | - | - | - | 62577 | 281318400000 | -122.41993564 | 37.79523766 | - | 1528934400000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570040000 | PACIFIC AVE | - | - | - | - | - | - |
| 45483 | N/A | Point | - | - | - | - | S108087 | PACIFIC AVE: LARKIN ST | - | F | F | - | F | 25305000 | 25305000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | PACIFIC AVE | LARKIN ST | 3807 | 3807 | 37.79523766 | -122.41993564 | LARKIN ST \ PACIFIC AVE | PACIFIC AVE \ LARKIN ST | 1711141582000 | middleware_editor | STOP | LARKIN ST intersection | - | 0 / 0 | - | - | - | - | - | 62578 | 281318400000 | -122.41993564 | 37.79523766 | - | 1555027200000 | - | D3 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570040000 | PACIFIC AVE | - | - | - | - | - | - |
| 45484 | N/A | Point | 1 | 1 | 415 - 499 | - | S108088 | 415-499 LAGUNA ST | 415-499 LAGUNA ST | F | F | - | F | 7947000 | 7947000 | - | - | EAST SIDE, EASTBOUND TRAFFIC | - | - | - | - | HICKORY ST | HICKORY ST | 3808 | 3808 | 37.77528699 | -122.42602491 | - | - | 1721265342000 | middleware_editor | ONE WAY (RA) | HICKORY ST to FELL ST (415 - 499) | - | N LINE / 0 | - | - | - | - | - | 62579 | 281577600000 | -122.42602491 | 37.77528699 | - | - | - | D5 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373570100000 | LAGUNA ST | 415 - 499 LAGUNA ST | 415 - 499 LAGUNA ST | 415 LAGUNA ST | - | FELL ST | FELL ST |
| 45485 | N/A | Point | - | - | - | - | S108089 | 21ST AVE: LAKE ST | - | F | F | - | F | 27645000 | 27645000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | LAKE ST | 21ST AVE | 3809 | 3809 | 37.78593396 | -122.4808601 | 21ST AVE \ LAKE ST | LAKE ST \ 21ST AVE | 1710539427000 | MTA | STOP | 21ST AVE intersection | - | 0 / 0 | - | - | - | - | - | 62580 | 281664000000 | -122.4808601 | 37.78593396 | - | 1663632000000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570100000 | LAKE ST | - | - | - | - | - | - |
| 45486 | N/A | Point | - | - | - | - | S108090 | 21ST AVE: LAKE ST | - | F | F | - | F | 27645000 | 27645000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | LAKE ST | 21ST AVE | 3810 | 3810 | 37.78593396 | -122.4808601 | 21ST AVE \ LAKE ST | LAKE ST \ 21ST AVE | 1710539427000 | MTA | STOP | 21ST AVE intersection | - | - | - | - | - | - | - | 62581 | 281664000000 | -122.4808601 | 37.78593396 | - | 1663632000000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570100000 | LAKE ST | - | - | - | - | - | - |
| 45487 | N/A | Point | - | - | - | - | S108091 | ANZA ST: 32ND AVE | - | F | F | - | F | 27838000 | 27838000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 32ND AVE | ANZA ST | 3811 | 3811 | 37.77782269 | -122.49209489 | ANZA ST \ 32ND AVE | 32ND AVE \ ANZA ST | 1749769525000 | middleware_editor | STOP | ANZA ST intersection | - | 0 / 0 | - | - | - | - | - | 62582 | 281692800000 | -122.49209489 | 37.77782269 | - | 1739469840000 | - | D1 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | LIGHT POLE | IS | 1373570100000 | 32ND AVE | - | - | - | - | - | - |
| 45488 | N/A | Point | - | - | - | - | S102662 | JESSIE ST: 2ND ST | - | F | F | - | F | 24605000 | 24605000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | JESSIE ST | 02ND ST | 3812 | 3812 | 37.78844216 | -122.40034385 | 2ND ST \ JESSIE ST | JESSIE ST \ 02ND ST | 1752695156000 | middleware_editor | ONE WAY (RA) | 02ND ST intersection | - | 0 / 00 | - | - | - | - | - | 62583 | -386438400000 | -122.40034385 | 37.78844216 | - | - | 1752695100000 | D6 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | LIGHT POLE | RETD | 1373568360000 | JESSIE ST | - | - | - | - | - | - |
| 45489 | N/A | Point | - | - | - | - | S102664 | STEVENSON ST: 2ND ST | - | F | F | - | F | 24618000 | 24618000 | - | - | NORTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 2ND ST | STEVENSON ST | 3813 | 3813 | 37.7888155 | -122.4008123 | STEVENSON ST \ 2ND ST | 02ND ST \ STEVENSON ST | 1754514195000 | middleware_editor | ONE WAY (RA) | STEVENSON ST intersection | - | 0 / 00 | - | - | - | - | - | 62584 | -386438400000 | -122.4008123 | 37.7888155 | - | 1754390400000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | 2IN IRON POST | IS | 1373568360000 | 02ND ST | - | - | - | - | - | - |
| 45490 | N/A | Point | - | - | - | - | S108646 | DIAMOND ST: MARKET ST | - | F | F | - | F | 25827000 | 25827000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MARKET ST | DIAMOND ST | 5363 | 5363 | 37.76189547 | -122.43729872 | DIAMOND ST \ MARKET ST | MARKET ST \ DIAMOND ST | 1710539427000 | MTA | ONE WAY (RA) | DIAMOND ST intersection | - | 0 / MAKE ONE WAY NORTHBOUND | - | - | - | - | - | 62585 | 326505600000 | -122.43729872 | 37.76189547 | - | - | - | D8 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP2 | LIGHT POLE | IS | 1373570280000 | MARKET ST | - | - | - | - | - | - |
| 45491 | N/A | Point | - | - | - | - | S108649 | 36TH AVE: ULLOA ST | - | F | F | - | F | 23376000 | 23376000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | ULLOA ST | ULLOA ST | 5364 | 5364 | 37.74038004 | -122.49377548 | 36TH AVE \ ULLOA ST | 36TH AVE \ ULLOA ST | 1710539427000 | MTA | STOP | ULLOA ST intersection | - | 0 / 0 | - | - | - | - | - | 62586 | 327196800000 | -122.49377548 | 37.74038004 | - | 1484784000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570280000 | 36TH AVE | - | - | - | - | - | - |
| 45492 | N/A | Point | - | - | - | - | S108650 | 35TH AVE: WAWONA ST | - | F | F | - | F | 23363000 | 23363000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WAWONA ST | 35TH AVE | 5365 | 5365 | 37.73706904 | -122.49247091 | 35TH AVE \ WAWONA ST | WAWONA ST \ 35TH AVE | 1715728418000 | middleware_editor | STOP | 35TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 62587 | 327196800000 | -122.49247091 | 37.73706904 | - | 1484179200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570280000 | WAWONA ST | - | - | - | - | - | - |
| 45493 | N/A | Point | - | - | - | - | S108651 | 35TH AVE: WAWONA ST | - | F | F | - | F | 23363000 | 23363000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | WAWONA ST | 35TH AVE | 5366 | 5366 | 37.73706904 | -122.49247091 | 35TH AVE \ WAWONA ST | WAWONA ST \ 35TH AVE | 1715218244000 | middleware_editor | STOP | 35TH AVE intersection | - | 0 / 0 | - | - | - | - | - | 62588 | 327196800000 | -122.49247091 | 37.73706904 | - | 1484179200000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570280000 | WAWONA ST | - | - | - | - | - | - |
| 45494 | N/A | Point | - | - | - | - | S111150 | 17TH ST: DE HARO ST | - | F | F | - | F | 23753000 | 23753000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | DE HARO ST | DE HARO ST | 5367 | 5367 | 37.76483924 | -122.401599 | 17TH ST \ DE HARO ST | 17TH ST \ DE HARO ST | 1710539427000 | MTA | STOP | DE HARO ST intersection | - | - | - | - | - | - | - | 62589 | 753321600000 | -122.401599 | 37.76483924 | - | 1566345600000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373571000000 | 17TH ST | - | - | - | - | - | - |
| 45495 | N/A | Point | - | - | - | - | S109956 | HERMANN ST: CHURCH ST | - | F | F | - | F | 25888000 | 25888000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | HERMANN ST | CHURCH ST | 5368 | 5368 | 37.77035062 | -122.42922462 | CHURCH ST \ HERMANN ST | HERMANN ST \ CHURCH ST | 1717725189000 | middleware_editor | STOP | CHURCH ST intersection | - | 0 / 00 | - | - | - | - | - | 62590 | 574992000000 | -122.42922462 | 37.77035062 | - | 938995200000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | MUNI POLE | IS | 1373570640000 | HERMANN ST | - | - | - | - | - | - |
| 45496 | N/A | Point | 1 | 1 | 40 - 99 | RIGHT ARROW | S109958 | 40-99 BERWICK PL | 40-99 BERWICK PL | F | F | - | F | 2962000 | 2962000 | - | - | EAST SIDE, EASTBOUND TRAFFIC | - | - | - | - | HERON ST | HERON ST | 5370 | 5370 | 37.77456912 | -122.40803871 | - | - | 1710539427000 | MTA | NPRK ANY TIME | HERON ST to HARRISON ST (40 - 99) | - | C LINE OF HERON | - | - | - | - | - | 62591 | 575510400000 | -122.40803871 | 37.77456912 | - | 1540857600000 | - | D6 | - | PARKING:NPRK ANY TIME | REG | R26(CA).0001 | 12X18 | SUP1 | 2IN IRON POST | IS | 1373570640000 | BERWICK PL | 40 - 99 BERWICK PL | 40 - 99 BERWICK PL | 40 BERWICK PL | - | HARRISON ST | HARRISON ST |
| 45497 | N/A | Point | - | - | - | - | S103416 | BAKER ST: LOMBARD ST | - | F | F | - | F | 27001000 | 27001000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | BAKER ST | BAKER ST | 5402 | 5402 | 37.79862602 | -122.44597389 | LOMBARD ST \ BAKER ST | LOMBARD ST \ BAKER ST | 1710539427000 | MTA | STOP | BAKER ST intersection | - | 0 / 0 | - | - | - | - | - | 62592 | -206496000000 | -122.44597389 | 37.79862602 | - | 1150416000000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373568600000 | LOMBARD ST | - | - | - | - | - | - |
| 45498 | N/A | Point | - | - | - | - | S103417 | BAKER ST: LOMBARD ST | - | F | F | - | F | 27001000 | 27001000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | BAKER ST | BAKER ST | 5403 | 5403 | 37.79862602 | -122.44597389 | LOMBARD ST \ BAKER ST | LOMBARD ST \ BAKER ST | 1710539427000 | MTA | STOP | BAKER ST intersection | - | 0 / 0 | - | - | - | - | - | 62593 | -206496000000 | -122.44597389 | 37.79862602 | - | 1651449600000 | - | D2 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | LIGHT POLE | IS | 1373568600000 | LOMBARD ST | - | - | - | - | - | - |
| 45499 | N/A | Point | - | - | - | - | S103418 | NOE ST: 19TH ST | - | F | F | - | F | 25787000 | 25787000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 5404 | 5404 | 37.75942329 | -122.43263777 | NOE ST \ 19TH ST | NOE ST \ 19TH ST | 1712885327000 | middleware_editor | STOP | 19TH ST intersection | - | 0 / 0 | - | - | - | - | - | 62594 | -206496000000 | -122.43263777 | 37.75942329 | - | 656812800000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | UNKNOWN | IS | 1373568600000 | NOE ST | - | - | - | - | - | - |
| 45500 | N/A | Point | - | - | - | - | S103419 | NOE ST: 19TH ST | - | F | F | - | F | 25787000 | 25787000 | - | - | SOUTH EAST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 19TH ST | 19TH ST | 5405 | 5405 | 37.75942329 | -122.43263777 | NOE ST \ 19TH ST | NOE ST \ 19TH ST | 1712885372000 | middleware_editor | STOP | 19TH ST intersection | - | - | - | - | - | - | - | 62595 | -206496000000 | -122.43263777 | 37.75942329 | - | 1579564800000 | - | D8 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568600000 | NOE ST | - | - | - | - | - | - |
| 45501 | N/A | Point | - | - | - | - | S103420 | PRAGUE ST: CORDOVA ST | - | F | F | - | F | 21393000 | 21393000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PRAGUE ST | CORDOVA ST | 5406 | 5406 | 37.71023873 | -122.43497949 | CORDOVA ST \ PRAGUE ST | PRAGUE ST \ CORDOVA ST | 1710539427000 | MTA | STOP | CORDOVA ST intersection | - | 0 / 0 | - | - | - | - | - | 62596 | -206496000000 | -122.43497949 | 37.71023873 | - | - | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373568600000 | PRAGUE ST | - | - | - | - | - | - |
| 45502 | N/A | Point | - | - | - | - | S108242 | LAGUNA ST: ELLIS ST | - | F | F | - | F | 26512000 | 26512000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | ELLIS ST | ELLIS ST | 5407 | 5407 | 37.78298605 | -122.42758433 | LAGUNA ST \ ELLIS ST | LAGUNA ST \ ELLIS ST | 1710960277000 | jsanfel | STOP | ELLIS ST intersection | - | 0 / 0 | - | - | - | - | - | 62597 | 292118400000 | -122.42758433 | 37.78298605 | - | 1433721600000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570100000 | LAGUNA ST | - | - | - | - | - | - |
| 45503 | N/A | Point | - | - | - | - | S108244 | EDDY ST: PIERCE ST | - | F | F | - | F | 26068000 | 26068000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | PIERCE ST | PIERCE ST | 5408 | 5408 | 37.78100935 | -122.43561627 | EDDY ST \ PIERCE ST | EDDY ST \ PIERCE ST | 1710539427000 | MTA | STOP | PIERCE ST intersection | - | 0 / 0 | - | - | - | - | - | 62598 | 292118400000 | -122.43561627 | 37.78100935 | - | 1592179200000 | - | D5 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570100000 | EDDY ST | - | - | - | - | - | - |
| 45504 | N/A | Point | 1 | 1 | 800 - 899 | - | S106815 | 800-899 4TH ST | 800-899 04TH ST | F | F | - | F | 269000 | 269000 | - | - | EAST SIDE, NORTHBOUND TRAFFIC | - | - | - | - | KING ST | KING ST | 5409 | 5409 | 37.77606015 | -122.3936951 | - | - | 1710539427000 | MTA | DO NOT ENTER | KING ST to BERRY ST (800 - 899) | - | 20N / 0 | - | - | - | - | - | 62599 | 172713600000 | -122.3936951 | 37.77606015 | - | - | - | D6 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373569680000 | 04TH ST | 800 - 899 4TH ST | 800 - 899 04TH ST | 800 4TH ST | - | BERRY ST | BERRY ST |
| 45505 | N/A | Point | - | - | - | - | S106816 | 4TH ST: KING ST | - | F | F | - | F | 23798000 | 23798000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 4TH ST | 04TH ST | 5410 | 5410 | 37.77633298 | -122.39403507 | KING ST \ 4TH ST | KING ST \ 04TH ST | 1737674930000 | middleware_editor | DO NOT ENTER | 04TH ST intersection | - | 00 / 0 | - | - | - | - | - | 62600 | 172713600000 | -122.39403507 | 37.77633298 | - | - | - | D6 | - | OTHER REGULATORY | REG | R5-1.0001 | 30X30 | SUP1 | UNKNOWN | IS | 1373569680000 | KING ST | - | - | - | - | - | - |
| 45506 | N/A | Point | - | - | - | - | S106817 | 4TH ST: KING ST | - | F | F | - | F | 23798000 | 23798000 | - | - | NORTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | 4TH ST | 04TH ST | 5411 | 5411 | 37.77633298 | -122.39403507 | KING ST \ 4TH ST | KING ST \ 04TH ST | 1737676003000 | middleware_editor | ONE WAY (LA) | 04TH ST intersection | - | 0 / MADE 4TH ST ONE-WAY SB TOWNSEND-KING | - | - | - | - | - | 62601 | 172713600000 | -122.39403507 | 37.77633298 | - | - | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373569680000 | KING ST | - | - | - | - | - | - |
| 45507 | N/A | Point | - | - | - | - | S107682 | PRAGUE ST: CORDOVA ST | - | F | F | - | F | 21393000 | 21393000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | PRAGUE ST | CORDOVA ST | 5448 | 5448 | 37.71023873 | -122.43497949 | CORDOVA ST \ PRAGUE ST | PRAGUE ST \ CORDOVA ST | 1710539427000 | MTA | ONE WAY (LA) | CORDOVA ST intersection | - | 0 / MADE PRAGUE ONE-WAY EB DRAKE-CORDOVA | - | - | - | - | - | 62602 | 244771200000 | -122.43497949 | 37.71023873 | - | - | - | D11 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | UNKNOWN | IS | 1373569920000 | PRAGUE ST | - | - | - | - | - | - |
| 45508 | N/A | Point | - | - | - | - | S110111 | 43RD AVE: WAWONA ST | - | F | F | - | F | 23446000 | 23446000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | WAWONA ST | 43RD AVE | 5450 | 5450 | 37.7364279159818 | -122.501094415779 | 43RD AVE \ WAWONA ST | WAWONA ST \ 43RD AVE | 1745250280000 | middleware_editor | STOP | 43RD AVE intersection | - | - | - | - | - | - | - | 62603 | 596880000000 | -122.50101 | 37.73632351 | - | 1490598000000 | - | D4 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570700000 | WAWONA ST | - | - | - | - | - | - |
| 45509 | N/A | Point | - | - | - | - | S108366 | NEWHALL ST: MENDELL ST | - | F | F | - | F | 20232000 | 20232000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | MENDELL ST | MENDELL ST | 5986 | 5986 | 37.74237875 | -122.38385038 | NEWHALL ST \ MENDELL ST | MENDELL ST intersection | 1710539427000 | MTA | STOP | MENDELL ST intersection | - | 0 / 00 | - | - | - | - | - | 62604 | 301017600000 | -122.38385038 | 37.74237875 | - | - | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570160000 | NEWHALL ST | - | - | - | - | - | - |
| 45510 | N/A | Point | - | - | - | - | S108368 | NEWHALL ST: EVANS AVE | - | F | F | - | F | 20236000 | 20236000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | EVANS AVE | EVANS AVE | 5987 | 5987 | 37.74195024 | -122.38655454 | NEWHALL ST \ EVANS AVE | NEWHALL ST \ EVANS AVE | 1710539427000 | MTA | STOP | EVANS AVE intersection | - | 0 / 0 | - | - | - | - | - | 62605 | - | -122.38655454 | 37.74195024 | - | 1677542400000 | - | D10 | - | STOP | REG | R1-1.0002 | 30X30 | SUP1 | 2IN IRON POST | IS | 1373570160000 | NEWHALL ST | - | - | - | - | - | - |
| 45511 | N/A | Point | - | - | - | - | S108369 | CURTIS ST: BRUNSWICK ST | - | F | F | - | F | 21423000 | 21423000 | - | - | NORTH EAST CORNER, WESTBOUND TRAFFIC | - | - | - | - | BRUNSWICK ST | CURTIS ST | 5988 | 5988 | 37.71174978 | -122.4390817 | CURTIS ST \ BRUNSWICK ST | BRUNSWICK ST \ CURTIS ST | 1733874456000 | middleware_editor | STOP | CURTIS ST intersection | - | - | - | - | - | - | - | 62606 | 301104000000 | -122.4390817 | 37.71174978 | - | 1588291200000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570160000 | BRUNSWICK ST | - | - | - | - | - | - |
| 45512 | N/A | Point | - | - | - | - | S108371 | SADOWA ST: LAWRENCE AVE \ SAN | - | F | F | - | F | 21597000 | 21597000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | SADOWA ST \ SAN JOSE AVE | SADOWA ST \ SAN JOSE AVE | 5989 | 5989 | 37.71233072 | -122.45466524 | LAWRENCE AVE \ SADOWA ST \ SAN JOSE AVE | LAWRENCE AVE \ SADOWA ST \ SAN JOSE AVE | 1710539427000 | MTA | STOP | SADOWA ST \ SAN JOSE AVE intersection | - | - | - | - | - | - | - | 62607 | 301104000000 | -122.45466524 | 37.71233072 | - | 1530144000000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570160000 | LAWRENCE AVE | - | - | - | - | - | - |
| 45513 | N/A | Point | - | - | - | - | S108372 | THRIFT ST: PLYMOUTH AVE | - | F | F | - | F | 22204000 | 22204000 | - | - | SOUTH WEST CORNER, EASTBOUND TRAFFIC | - | - | - | - | THRIFT ST | THRIFT ST | 5990 | 5990 | 37.71747731 | -122.45609424 | PLYMOUTH AVE \ THRIFT ST | PLYMOUTH AVE \ THRIFT ST | 1720647698000 | middleware_editor | STOP | THRIFT ST intersection | - | 0 / 0 | - | - | - | - | - | 62608 | 301104000000 | -122.45609424 | 37.71747731 | - | 1720611300000 | - | D11 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570160000 | PLYMOUTH AVE | - | - | - | - | - | - |
| 45514 | N/A | Point | - | - | - | - | S108373 | THOR AVE: SURREY ST | - | F | F | - | F | 21945000 | 21945000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | THOR AVE | THOR AVE | 5991 | 5991 | 37.73568219 | -122.43498486 | SURREY ST \ THOR AVE | SURREY ST \ THOR AVE | 1710539427000 | MTA | ONE WAY (LA) | THOR AVE intersection | - | 0 / MADE THOR ONE-WAY SB BET SURREY..... | - | - | - | - | - | 62609 | 301449600000 | -122.43498486 | 37.73568219 | - | - | - | D8 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | UNKNOWN | IS | 1373570160000 | SURREY ST | - | - | - | - | - | - |
| 45515 | N/A | Point | - | - | - | - | S108374 | THOR AVE: SURREY ST | - | F | F | - | F | 21945000 | 21945000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | THOR AVE | THOR AVE | 5992 | 5992 | 37.73568219 | -122.43498486 | SURREY ST \ THOR AVE | SURREY ST \ THOR AVE | 1710539427000 | MTA | ONE WAY (RA) | THOR AVE intersection | - | 0 / MADE THOR ONE-WAY SB BET SURREY..... | - | - | - | - | - | 62610 | 301449600000 | -122.43498486 | 37.73568219 | - | - | - | D8 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP2 | 3IN IRON POST | IS | 1373570160000 | SURREY ST | - | - | - | - | - | - |
| 45516 | N/A | Point | - | - | - | - | S108377 | DEL SUR AVE: JUANITA WAY | - | F | F | - | F | 22431000 | 22431000 | - | - | NORTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | DEL SUR AVE | DEL SUR AVE | 5995 | 5995 | 37.74177699 | -122.45493157 | JUANITA WAY \ DEL SUR AVE | JUANITA WAY \ DEL SUR AVE | 1710539427000 | MTA | STOP | DEL SUR AVE intersection | - | 0 / 0 | - | - | - | - | - | 62611 | 301795200000 | -122.45493157 | 37.74177699 | - | - | - | D7 | - | STOP | REG | R1-1.0002 | 30X30 | SUP2 | 2IN IRON POST | IS | 1373570160000 | JUANITA WAY | - | - | - | - | - | - |
| 45517 | N/A | Point | - | - | - | - | S108380 | RANDOLPH ST: CHESTER AVE | - | F | F | - | F | 22546000 | 22546000 | - | - | SOUTH WEST CORNER, WESTBOUND TRAFFIC | - | - | - | - | CHESTER AVE | CHESTER AVE | 5996 | 5996 | 37.71427724 | -122.47046372 | RANDOLPH ST \ CHESTER AVE | RANDOLPH ST \ CHESTER AVE | 1710539427000 | MTA | DO NOT ENTER | CHESTER AVE intersection | - | 0 / MADE RANDOLPH 1-WAY SB 19TH & C..... | - | - | - | - | - | 62612 | 301881600000 | -122.47046372 | 37.71427724 | - | - | - | D11 | - | OTHER REGULATORY | REG | R5-1.0002 | 24X24 | SUP2 | 2IN IRON POST | IS | 1373570160000 | RANDOLPH ST | - | - | - | - | - | - |
| 45518 | N/A | Point | - | - | - | - | S108381 | RANDOLPH ST: CHESTER AVE | - | F | F | - | F | 22546000 | 22546000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | CHESTER AVE | CHESTER AVE | 5997 | 5997 | 37.71427724 | -122.47046372 | RANDOLPH ST \ CHESTER AVE | RANDOLPH ST \ CHESTER AVE | 1710539427000 | MTA | ONE WAY (LA) | CHESTER AVE intersection | - | 0 / MADE RANDOLPH ONE-WAY SB CHESTE..... | - | - | - | - | - | 62613 | 301881600000 | -122.47046372 | 37.71427724 | - | - | - | D11 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP2 | UNKNOWN | IS | 1373570160000 | RANDOLPH ST | - | - | - | - | - | - |
| 45519 | N/A | Point | 1 | 1 | 50 - 99 | - | S102546 | 50-99 9TH ST | 50-99 09TH ST | F | F | - | F | 447000 | 447000 | - | - | EAST SIDE, EASTBOUND TRAFFIC | - | - | - | - | JESSIE ST | JESSIE ST | 6000 | 6000 | 37.77647411 | -122.41501579 | - | - | 1725039512000 | middleware_editor | ONE WAY (LA) | JESSIE ST to MISSION ST (50 - 99) | - | INFO #59 | - | - | - | - | - | 62614 | -387763200000 | -122.41501579 | 37.77647411 | - | 1725010200000 | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | 2IN IRON POST | IS | 1373568360000 | 09TH ST | 50 - 99 9TH ST | 50 - 99 09TH ST | 50 9TH ST | - | MISSION ST | MISSION ST |
| 45520 | N/A | Point | - | - | - | - | S102547 | NATOMA ST: RUSS ST | - | F | F | - | F | 24288000 | 24288000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | RUSS ST | NATOMA ST | 6001 | 6001 | 37.7792937 | -122.40880899 | NATOMA ST \ RUSS ST | RUSS ST \ NATOMA ST | 1710539427000 | MTA | ONE WAY (LA) | NATOMA ST intersection | - | 0 / 0 | - | - | - | - | - | 62615 | -387763200000 | -122.40880899 | 37.7792937 | - | - | - | D6 | - | ONE WAY(LA) | REG | R6-1.0001 | 48X16 | SUP1 | UNKNOWN | IS | 1373568360000 | RUSS ST | - | - | - | - | - | - |
| 45521 | N/A | Point | - | - | - | - | S102548 | NATOMA ST: 7TH ST | - | F | F | - | F | 24289000 | 24289000 | - | - | NORTH WEST CORNER, NORTHBOUND TRAFFIC | - | - | - | - | 7TH ST | 07TH ST | 6002 | 6002 | 37.77841628 | -122.40993824 | NATOMA ST \ 7TH ST | NATOMA ST \ 07TH ST | 1733940537000 | middleware_editor | ONE WAY (RA) | 07TH ST intersection | - | 0 / 0 | - | - | - | - | - | 62616 | -387763200000 | -122.40993824 | 37.77841628 | - | 1496102400000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0002 | 36X12 | SUP1 | LIGHT POLE | IS | 1373568360000 | NATOMA ST | - | - | - | - | - | - |
| 45522 | N/A | Point | - | - | - | - | S102549 | MARY ST: NATOMA ST | - | F | F | - | F | 24283000 | 24283000 | - | - | SOUTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | NATOMA ST | NATOMA ST | 6003 | 6003 | 37.78130585 | -122.40624778 | MARY ST \ NATOMA ST | MARY ST \ NATOMA ST | 1738964811000 | middleware_editor | ONE WAY (LA) | NATOMA ST intersection | - | 0 / 0 | - | - | - | - | - | 62617 | -387763200000 | -122.40624778 | 37.78130585 | - | 1388016000000 | - | D6 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP1 | 2IN IRON POST | IS | 1373568360000 | MARY ST | - | - | - | - | - | - |
| 45523 | N/A | Point | - | - | - | - | S102550 | NATOMA ST: 8TH ST | - | F | F | - | F | 24302000 | 24302000 | - | - | SOUTH WEST CORNER, SOUTHBOUND TRAFFIC | - | - | - | - | NATOMA ST | 08TH ST | 6004 | 6004 | 37.77666099 | -122.41215795 | 8TH ST \ NATOMA ST | NATOMA ST \ 08TH ST | 1733940451000 | middleware_editor | ONE WAY (LA) | 08TH ST intersection | - | - | - | - | - | - | - | 62618 | -387763200000 | -122.41215795 | 37.77666099 | - | 1469577600000 | - | D6 | - | ONE WAY(LA) | REG | R6-1.0004 | 36X12 | SUP1 | SIGNAL POLE | IS | 1373568360000 | NATOMA ST | - | - | - | - | - | - |
| 45524 | N/A | Point | - | - | - | - | S102551 | 10TH ST: NATOMA ST | - | F | F | - | F | 24412000 | 24412000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | 10TH ST | 10TH ST | 6005 | 6005 | 37.77447569 | -122.41490974 | NATOMA ST \ 10TH ST | NATOMA ST \ 10TH ST | 1726276029000 | middleware_editor | ONE WAY (RA) | 10TH ST intersection | - | E LINE / 0 | - | - | - | - | - | 62619 | -387763200000 | -122.41490974 | 37.77447569 | - | - | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | UNKNOWN | IS | 1373568360000 | NATOMA ST | - | - | - | - | - | - |
| 45525 | N/A | Point | - | - | - | - | S102552 | 8TH ST: NATOMA ST | - | F | F | - | F | 24302000 | 24302000 | - | - | NORTH EAST CORNER, EASTBOUND TRAFFIC | - | - | - | - | NATOMA ST | 08TH ST | 6006 | 6006 | 37.77666099 | -122.41215795 | 8TH ST \ NATOMA ST | NATOMA ST \ 08TH ST | 1710539427000 | MTA | ONE WAY (RA) | 08TH ST intersection | - | - | - | - | - | - | - | 62620 | -387763200000 | -122.41215795 | 37.77666099 | - | 1469577600000 | - | D6 | - | ONE WAY(RA) | REG | R6-1.0003 | 48X16 | SUP1 | LIGHT POLE | IS | 1373568360000 | NATOMA 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