File Information

MTA.signshop_assets

MTA.signshop_assets

ESRI_HARVEST Uploaded Aug 31, 2025 at 7:26 PM
Dataset Information
No Information Available

No additional information has been provided for this dataset.

MTA.signshop_assets
150140 records
Advanced Filters
Quick Tips:
• Use Ctrl+F to focus search
• Use Ctrl+Shift+F to toggle filters
• Combine multiple filters for precise results
Operators:
Between for ranges (e.g., 10,100)
Regex for pattern matching
Case sensitive for exact matches
Showing all 150140 records
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
17926 N/A Point - - - - S100372 37TH AVE: LINCOLN WAY - F F - F 27747000 27747000 - - SOUTH WEST CORNER, EASTBOUND TRAFFIC - - - - LINCOLN WAY 37TH AVE 422 422 37.7644969880342 -122.496627867217 37TH AVE \ LINCOLN WAY LINCOLN WAY \ 37TH AVE 1735075545000 middleware_editor ONE WAY (RA) 37TH AVE intersection - 0 / 0 - - - - - 35002 -404611200000 -122.49654699 37.76459606 - 1718323200000 - D4 - ONE WAY(RA) REG R6-1.0002 36X12 SUP2 UNKNOWN IS 1373566440000 LINCOLN WAY - - - - - -
17927 N/A Point - - - - S100373 36TH AVE: LINCOLN WAY - F F - F 27745000 27745000 - - SOUTH WEST CORNER, WESTBOUND TRAFFIC - - - - LINCOLN WAY 36TH AVE 423 423 37.7645542382491 -122.495574261988 36TH AVE \ LINCOLN WAY LINCOLN WAY \ 36TH AVE 1756493531000 middleware_editor ONE WAY (RA) 36TH AVE intersection - 0 / 0 - - - - 1 35003 -404582400000 -122.49547531 37.76463804 - 1756491840000 - D4 - ONE WAY(RA) REG R6-1.0003 48X16 SUP2 2IN IRON POST IS 1373566440000 LINCOLN WAY - - - - - -
17928 N/A Point - - - - S100374 GOUGH ST: FULTON ST - F F - F 25940000 25940000 - - NORTH EAST CORNER, EASTBOUND TRAFFIC - - - - FULTON ST FULTON ST 424 424 37.77874737 -122.42335403 GOUGH ST \ FULTON ST GOUGH ST \ FULTON ST 1710539427000 MTA ONE WAY (RA) FULTON ST intersection - - - - - - - 35004 -404611200000 -122.42335403 37.77874737 - 1386028800000 - D5 - ONE WAY(RA) REG R6-1.0003 48X16 SUP1 LIGHT POLE IS 1373566440000 GOUGH ST - - - - - -
17929 N/A Point - - - - S107874 21ST AVE: MORAGA ST - F F - F 27344000 27344000 - - SOUTH EAST CORNER, NORTHBOUND TRAFFIC - - - - 21ST AVE 21ST AVE 3249 3249 37.75601365 -122.47874437 MORAGA ST \ 21ST AVE MORAGA ST \ 21ST AVE 1710539427000 MTA STOP 21ST AVE intersection - 0 / 0 - - - - - 35005 260496000000 -122.47874437 37.75601365 - 1467072000000 - D4 - STOP REG R1-1.0002 30X30 SUP2 2IN IRON POST IS 1373569980000 MORAGA ST - - - - - -
17930 N/A Point - - - - S107875 43RD AVE: MORAGA ST - F F - F 27775000 27775000 - - NORTH WEST CORNER, SOUTHBOUND TRAFFIC - - - - 43RD AVE 43RD AVE 3250 3250 37.75495313 -122.50231815 MORAGA ST \ 43RD AVE MORAGA ST \ 43RD AVE 1710539427000 MTA STOP 43RD AVE intersection - 0 / 0 - - - - - 35006 260496000000 -122.50231815 37.75495313 - 1493769600000 - D4 - STOP REG R1-1.0002 30X30 SUP2 2IN IRON POST IS 1373569980000 MORAGA ST - - - - - -
17931 N/A Point - - - - S107876 43RD AVE: MORAGA ST - F F - F 27775000 27775000 - - SOUTH EAST CORNER, NORTHBOUND TRAFFIC - - - - 43RD AVE 43RD AVE 3251 3251 37.75495313 -122.50231815 MORAGA ST \ 43RD AVE MORAGA ST \ 43RD AVE 1710539427000 MTA STOP 43RD AVE intersection - 0 / 0 - - - - - 35007 260496000000 -122.50231815 37.75495313 - 1493769600000 - D4 - STOP REG R1-1.0002 30X30 SUP2 2IN IRON POST IS 1373569980000 MORAGA ST - - - - - -
17932 N/A Point - - - - S106710 MASON ST: LOMBARD ST - F F - F 25464000 25464000 - - SOUTH EAST CORNER, NORTHBOUND TRAFFIC - - - - LOMBARD ST LOMBARD ST 3253 3253 37.8028277 -122.41303434 MASON ST \ LOMBARD ST MASON ST \ LOMBARD ST 1710539427000 MTA STOP LOMBARD ST intersection - 0 / 0 - - - - - 35008 160012800000 -122.41303434 37.8028277 - - - D3 - STOP REG R1-1.0002 30X30 SUP1 UNKNOWN IS 1373569620000 MASON ST - - - - - -
17933 N/A Point - - - - S106716 PIERCE ST: OAK ST - F F - F 26002000 26002000 - - NORTH WEST CORNER, NORTHBOUND TRAFFIC - - - - OAK ST OAK ST 3256 3256 37.77354938 -122.43410901 PIERCE ST \ OAK ST PIERCE ST \ OAK ST 1746828150000 middleware_editor DO NOT ENTER OAK ST intersection - 0 / MADE PIERCE ONE WAY SB BET FELL..... - - - - - 35009 160214400000 -122.43410901 37.77354938 - - - D5 - OTHER REGULATORY REG R5-1.0001 30X30 SUP1 UNKNOWN IS 1373569620000 PIERCE ST - - - - - -
17934 N/A Point - - - - S106718 PIERCE ST: OAK ST - F F - F 26002000 26002000 - - NORTH EAST CORNER, EASTBOUND TRAFFIC - - - - OAK ST OAK ST 3258 3258 37.77354938 -122.43410901 PIERCE ST \ OAK ST PIERCE ST \ OAK ST 1747059010000 middleware_editor ONE WAY (RA) OAK ST intersection - 0 / MADE PIERCE ONE-WAY SB FELL-OAK - - - - - 35010 160214400000 -122.43410901 37.77354938 - 1746809100000 - D5 - ONE WAY(RA) REG R6-1.0003 48X16 SUP1 LIGHT POLE IS 1373569620000 PIERCE ST - - - - - -
17935 N/A Point - - - - S106720 PIXLEY ST: WEBSTER ST - F F - F 26745000 26745000 - - NORTH WEST CORNER, NORTHBOUND TRAFFIC - - - - PIXLEY ST WEBSTER ST 3260 3260 37.7986961 -122.43413019 WEBSTER ST \ PIXLEY ST PIXLEY ST \ WEBSTER ST 1754778450000 middleware_editor ONE WAY (LA) WEBSTER ST intersection - 0 / MADE PIXLEY ONE-WAY WB WEBSTER-..... - - - - - 35011 160300800000 -122.43413019 37.7986961 - 1754685660000 - D2 - ONE WAY(LA) REG R6-1.0001 48X16 SUP1 2IN IRON POST IS 1373569620000 PIXLEY ST - - - - - -
17936 N/A Point - - - - S101652 SCOTT ST: POST ST - F F - F 26622000 26622000 - - SOUTH EAST CORNER, NORTHBOUND TRAFFIC - - - - POST ST SCOTT ST 3261 3261 37.78453092 -122.43801967 SCOTT ST \ POST ST POST ST \ SCOTT ST 1710539427000 MTA STOP SCOTT ST intersection - 0 / 0 - - - - - 35012 -395452800000 -122.43801967 37.78453092 - - - D5 - STOP REG R1-1.0002 30X30 SUP1 2IN IRON POST IS 1373566860000 POST ST - - - - - -
17937 N/A Point - - - - S101653 PIERCE ST: SUTTER ST - F F - F 26626000 26626000 - - SOUTH EAST CORNER, NORTHBOUND TRAFFIC - - - - SUTTER ST SUTTER ST 3262 3262 37.78566778 -122.4365573 PIERCE ST \ SUTTER ST PIERCE ST \ SUTTER ST 1710539427000 MTA STOP SUTTER ST intersection - 0 / 0 - - - - - 35013 -395452800000 -122.4365573 37.78566778 - 784425600000 - D2 - STOP REG R1-1.0002 30X30 SUP1 UNKNOWN IS 1373566860000 PIERCE ST - - - - - -
17938 N/A Point - - - - S101654 SCOTT ST: SUTTER ST - F F - F 26625000 26625000 - - NORTH WEST CORNER, SOUTHBOUND TRAFFIC - - - - SUTTER ST SCOTT ST 3263 3263 37.78545934 -122.43820638 SCOTT ST \ SUTTER ST SUTTER ST \ SCOTT ST 1754778480000 middleware_editor STOP SCOTT ST intersection - 0 / 0 - - - - - 35014 -395427600000 -122.43820638 37.78545934 - 1754679720000 - D2 - STOP REG R1-1.0002 30X30 SUP1 2IN IRON POST IS 1373566860000 SUTTER ST - - - - - -
17939 N/A Point - - - - S101656 SAINT JOSEPHS AVE: OFARRELL ST - F F - F 26812000 26812000 - - SOUTH EAST CORNER, NORTHBOUND TRAFFIC - - - - SAINT JOSEPHS AVE SAINT JOSEPHS AVE 3265 3265 37.78223395 -122.44167164 OFARRELL ST \ SAINT JOSEPHS AVE OFARRELL ST \ SAINT JOSEPHS AVE 1710539427000 MTA STOP SAINT JOSEPHS AVE intersection - 0 / 00 - - - - - 35015 -395452800000 -122.44167164 37.78223395 - 1684972800000 - D2 - STOP REG R1-1.0002 30X30 SUP1 3IN IRON POST IS 1373566860000 OFARRELL ST - - - - - -
17940 N/A Point - - - - S101658 PRECITA AVE: ALABAMA ST - F F - F 21140000 21140000 - - SOUTH WEST CORNER, WESTBOUND TRAFFIC - - - - ALABAMA ST ALABAMA ST 3267 3267 37.7473542 -122.4104952 PRECITA AVE \ ALABAMA ST PRECITA AVE \ ALABAMA ST 1712625530000 middleware_editor DO NOT ENTER ALABAMA ST intersection - 0 / MADE EASTBOUND ONE WAY - - - - - 35016 -395452800000 -122.4104952 37.7473542 - - - D9 - OTHER REGULATORY REG R5-1.0001 30X30 SUP2 LIGHT POLE IS 1373566860000 PRECITA AVE - - - - - -
17941 N/A Point - - - - S101659 BUSH ST: SCOTT ST - F F - F 26627000 26627000 - - SOUTH WEST CORNER, SOUTHBOUND TRAFFIC - - - - SCOTT ST BUSH ST 3268 3268 37.78639168 -122.43839388 BUSH ST \ SCOTT ST SCOTT ST \ BUSH ST 1710539427000 MTA ONE WAY (LA) BUSH ST intersection - 0 / 0 - - - - - 35017 -395452800000 -122.43839388 37.78639168 - 1473120000000 - D2 - ONE WAY(LA) REG R6-1.0001 48X16 SUP1 LIGHT POLE IS 1373566860000 SCOTT ST - - - - - -
17942 N/A Point - - - - S101660 BUSH ST: DIVISADERO ST - F F - F 26810000 26810000 - - SOUTH WEST CORNER, SOUTHBOUND TRAFFIC - - - - BUSH ST DIVISADERO ST 3269 3269 37.78617958 -122.4400612 DIVISADERO ST \ BUSH ST BUSH ST \ DIVISADERO ST 1710539427000 MTA ONE WAY (LA) DIVISADERO ST intersection - 0 / 0 - - - - - 35018 -395452800000 -122.4400612 37.78617958 - 1684886400000 - D2 - ONE WAY(LA) REG R6-1.0001 48X16 SUP1 UNKNOWN IS 1373566860000 BUSH ST - - - - - -
17943 N/A Point - - - - S101661 PINE ST: SCOTT ST - F F - F 26642000 26642000 - - NORTH EAST CORNER, NORTHBOUND TRAFFIC - - - - SCOTT ST PINE ST 3270 3270 37.7873249 -122.43858157 PINE ST \ SCOTT ST SCOTT ST \ PINE ST 1727744430000 middleware_editor ONE WAY (LA) PINE ST intersection - 0 / 0 - - - - - 35019 -395452800000 -122.43858157 37.7873249 - 1684195200000 - D2 - ONE WAY(LA) REG R6-1.0001 48X16 SUP1 LIGHT POLE IS 1373566860000 SCOTT ST - - - - - -
17944 N/A Point - - - - S101943 ALABAMA ST: 20TH ST - F F - F 24028000 24028000 - - SOUTH EAST CORNER, NORTHBOUND TRAFFIC - - - - ALABAMA ST 20TH ST 3271 3271 37.75908406 -122.41157984 20TH ST \ ALABAMA ST ALABAMA ST \ 20TH ST 1716393952000 middleware_editor STOP 20TH ST intersection - 0 / 0 - - - - - 35020 -394502400000 -122.41157984 37.75908406 - 1537142400000 - D9 - STOP REG R1-1.0002 30X30 SUP2 2IN IRON POST IS 1373566920000 ALABAMA ST - - - - - -
17945 N/A Point - - - - S107129 46TH AVE: WAWONA ST - F F - F 23455000 23455000 - - SOUTH EAST CORNER, NORTHBOUND TRAFFIC - - - - 46TH AVE WAWONA ST 5157 5157 37.73618212 -122.50422775 WAWONA ST \ 46TH AVE 46TH AVE \ WAWONA ST 1742509711000 middleware_editor NO LEFT TURN (SYM) WAWONA ST intersection - - - - - - - 35021 191836800000 -122.50422775 37.73618212 - 1393920000000 - D4 - NO LEFT TURN REG R3-2.0001 24X24 SUP2 2IN IRON POST IS 1373569740000 46TH AVE - - - - - -
17946 N/A Point - - - - S107130 MISSION ST: FREMONT ST - T T - F 24560000 24560000 - - NORTH EAST CORNER, EASTBOUND TRAFFIC - - - - MISSION ST FREMONT ST 5158 5158 37.79046107 -122.39668969 FREMONT ST \ MISSION ST MISSION ST \ FREMONT ST 1744121741000 middleware_editor NO RIGHT TURN (SYM) FREMONT ST intersection - 0 / 0 - - - - - 35022 194083200000 -122.39668969 37.79046107 - 1540364400000 1739996100000 D6 - NO RIGHT TURN REG R3-1.0001 24X24 SUP1 LIGHT POLE RETD 1373569740000 MISSION ST - - - - - -
17947 N/A Point - - - - S107131 PUTNAM ST: CRESCENT AVE - F F - F 33662000 33662000 - - NORTH EAST CORNER, WESTBOUND TRAFFIC - - - - PUTNAM ST CRESCENT AVE 5159 5159 37.73507166 -122.41116581 CRESCENT AVE \ PUTNAM ST PUTNAM ST \ CRESCENT AVE 1738359542000 middleware_editor STOP CRESCENT AVE intersection - EXIT FROM FARMERS MARKET - - - - - 35023 195350400000 -122.41116581 37.73507166 - - - D9 - STOP REG R1-1.0002 30X30 SUP2 UNKNOWN IS 1373569740000 PUTNAM ST - - - - - -
17948 N/A Point - - - - S107132 38TH AVE: ANZA ST - F F - F 27888000 27888000 - - NORTH WEST CORNER, SOUTHBOUND TRAFFIC - - - - ANZA ST ANZA ST 5160 5160 37.77753091 -122.49852129 38TH AVE \ ANZA ST 38TH AVE \ ANZA ST 1731006336000 middleware_editor STOP ANZA ST intersection - 0 / 0 - - - - - 35024 195868800000 -122.49852129 37.77753091 - 1730809380000 - D1 - STOP REG R1-1.0002 30X30 SUP2 2IN IRON POST IS 1373569740000 38TH AVE - - - - - -
17949 N/A Point - - - - S107133 38TH AVE: ANZA ST - F F - F 27888000 27888000 - - SOUTH EAST CORNER, NORTHBOUND TRAFFIC - - - - ANZA ST ANZA ST 5161 5161 37.77753091 -122.49852129 38TH AVE \ ANZA ST 38TH AVE \ ANZA ST 1731003306000 middleware_editor STOP ANZA ST intersection - 0 / 0 - - - - - 35025 195868800000 -122.49852129 37.77753091 - 1730804040000 - D1 - STOP REG R1-1.0002 30X30 SUP2 2IN IRON POST IS 1373569740000 38TH AVE - - - - - -
17950 N/A Point - - - - S108522 SHIELDS ST: VICTORIA ST - F F - F 22697000 22697000 - - SOUTH WEST CORNER, EASTBOUND TRAFFIC - - - - SHIELDS ST SHIELDS ST 5162 5162 37.71791811 -122.46534206 VICTORIA ST \ SHIELDS ST VICTORIA ST \ SHIELDS ST 1736968521000 middleware_editor STOP SHIELDS ST intersection - 0 / 0 - - - - - 35026 310176000000 -122.46534206 37.71791811 - 1736856000000 - D11 - STOP REG R1-1.0002 30X30 SUP2 UNKNOWN IS 1373570220000 VICTORIA ST - - - - - -
17951 N/A Point - - - - S108527 LEVANT ST: STATES ST - F F - F 26167000 26167000 - - NORTH WEST CORNER, SOUTHBOUND TRAFFIC - - - - LEVANT ST STATES ST 5164 5164 37.76500272 -122.4423173 STATES ST \ LEVANT ST LEVANT ST \ STATES ST 1746564582000 middleware_editor STOP STATES ST intersection - NEXT TO STAIRCASE - - - - - 35027 310809600000 -122.4423173 37.76500272 - - - D8 - STOP REG R1-1.0002 30X30 SUP2 2IN IRON POST IS 1373570220000 LEVANT ST - - - - - -
17952 N/A Point - - - - S108529 FOLSOM ST: CRESCENT AVE - F F - F 21046000 21046000 - - SOUTH EAST CORNER, SOUTHBOUND TRAFFIC - - - - CRESCENT AVE FOLSOM ST 5165 5165 37.73473162 -122.41368902 FOLSOM ST \ CRESCENT AVE CRESCENT AVE \ FOLSOM ST 1734133616000 middleware_editor DO NOT ENTER FOLSOM ST intersection - 0 / MADE FOLSOM 1-WAY NB BET CRESCE..... - - - - - 35028 310780800000 -122.41368902 37.73473162 - - - D9 - OTHER REGULATORY REG R5-1.0001 30X30 SUP2 UNKNOWN IS 1373570220000 CRESCENT AVE - - - - - -
17953 N/A Point - - - - S106496 UPLAND DR: WESTGATE DR - F F - F 22760000 22760000 - - NORTH EAST CORNER, WESTBOUND TRAFFIC - - - - WESTGATE DR WESTGATE DR 5167 5167 37.7299726 -122.46463257 UPLAND DR \ WESTGATE DR UPLAND DR \ WESTGATE DR 1717549445000 middleware_editor STOP WESTGATE DR intersection - 0 / 0 - - - - - 35029 146361600000 -122.46463257 37.7299726 - 1666915200000 - D7 - STOP REG R1-1.0002 30X30 SUP2 2IN IRON POST IS 1373569560000 UPLAND DR - - - - - -
17954 N/A Point - - - - S108282 BUCHANAN ST: CLAY ST - F F - F 26563000 26563000 - - NORTH WEST CORNER, SOUTHBOUND TRAFFIC - - - - BUCHANAN ST CLAY ST 5179 5179 37.79112951 -122.43091425 CLAY ST \ BUCHANAN ST BUCHANAN ST \ CLAY ST 1736271817000 middleware_editor NO LEFT TURN (SYM) CLAY ST intersection - 0 / 0 - - - - - 35030 296784000000 -122.43091425 37.79112951 - - - D2 - NO LEFT TURN REG R3-2.0001 24X24 SUP1 UNKNOWN IS 1373570160000 BUCHANAN ST - - - - - -
17955 N/A Point - - - - S108284 TAPIA DR: FONT BLVD \ HOLLOWAY - F F - F 33484000 33484000 - - SOUTH EAST CORNER, SOUTHBOUND TRAFFIC - - - - HOLLOWAY AVE \ TAPIA DR FONT BLVD \ TAPIA DR 5180 5180 37.72070273 -122.48105803 FONT BLVD \ HOLLOWAY AVE \ TAPIA DR HOLLOWAY AVE \ FONT BLVD \ TAPIA DR 1710539427000 MTA ONE WAY (LA) FONT BLVD \ TAPIA DR intersection - 0 / REVERSED ONE-WAY ON TAPIANB&WB ..... - - - - - 35031 296956800000 -122.48105803 37.72070273 - - - D7 - ONE WAY(LA) REG R6-1.0001 48X16 SUP2 UNKNOWN IS 1373570160000 HOLLOWAY AVE - - - - - -
17956 N/A Point - - - - S108290 HERMANN ST: BUCHANAN ST - F F - F 25864000 25864000 - - NORTH EAST CORNER, WESTBOUND TRAFFIC - - - - HERMANN ST BUCHANAN ST 5183 5183 37.77066018 -122.42678077 BUCHANAN ST \ HERMANN ST HERMANN ST \ BUCHANAN ST 1733152590000 middleware_editor STOP BUCHANAN ST intersection - - - - - - - 35032 297475200000 -122.42678077 37.77066018 - 1732613400000 - D8 - STOP REG R1-1.0002 30X30 SUP2 2IN IRON POST IS 1373570160000 HERMANN ST - - - - - -
17957 N/A Point - - - - S108291 HERMANN ST: BUCHANAN ST - F F - F 25864000 25864000 - - SOUTH WEST CORNER, EASTBOUND TRAFFIC - - - - HERMANN ST BUCHANAN ST 5184 5184 37.77066018 -122.42678077 BUCHANAN ST \ HERMANN ST HERMANN ST \ BUCHANAN ST 1733154530000 middleware_editor STOP BUCHANAN ST intersection - - - - - - - 35033 297475200000 -122.42678077 37.77066018 - 1732626000000 - D8 - STOP REG R1-1.0002 30X30 SUP2 2IN IRON POST IS 1373570160000 HERMANN ST - - - - - -
17958 N/A Point - - - - S103740 26TH ST: CHURCH ST - F F - F 21917000 21917000 - - NORTH EAST CORNER, WESTBOUND TRAFFIC - - - - CHURCH ST CHURCH ST 5659 5659 37.74849583 -122.42712276 26TH ST \ CHURCH ST 26TH ST \ CHURCH ST 1733945932000 middleware_editor STOP CHURCH ST intersection - 00 / 00 - - - - - 35034 -111456000000 -122.42712276 37.74849583 - 1733839200000 - D8 - STOP REG R1-1.0002 30X30 SUP2 2IN IRON POST IS 1373568720000 26TH ST - - - - - -
17959 N/A Point - - - - S103741 26TH ST: CHURCH ST - F F - F 21917000 21917000 - - SOUTH WEST CORNER, EASTBOUND TRAFFIC - - - - CHURCH ST CHURCH ST 5660 5660 37.74849583 -122.42712276 26TH ST \ CHURCH ST 26TH ST \ CHURCH ST 1733945905000 middleware_editor STOP CHURCH ST intersection - 00 / 00 - - - - - 35035 -111456000000 -122.42712276 37.74849583 - 1733836500000 - D8 - STOP REG R1-1.0002 30X30 SUP2 2IN IRON POST IS 1373568720000 26TH ST - - - - - -
17960 N/A Point 1 1 200 - 223 - S103742 200-223 TOWNSEND ST 200-223 TOWNSEND ST F F - F 12659000 12659000 - - CENTER ISLAND, WESTBOUND TRAFFIC - - - - 3RD ST 03RD ST 5661 5661 37.77863961 -122.39301839 - - 1713879382000 middleware_editor NO LEFT TURN (SYM) 03RD ST to RITCH ST (200 - 223) - W LINE / 00 - - - - - 35036 -111369600000 -122.39301839 37.77863961 - - - D6 - NO LEFT TURN REG R3-2.0001 24X24 SUP1 UNKNOWN IS 1373568720000 TOWNSEND ST 200 - 223 TOWNSEND ST 200 - 223 TOWNSEND ST 200 TOWNSEND ST - RITCH ST RITCH ST
17961 N/A Point - - - - S103743 TOWNSEND ST: 3RD ST - F F - F 23807000 23807000 - SHOULD BE RETIRED NORTH EAST CORNER, EASTBOUND TRAFFIC - - - - TOWNSEND ST 03RD ST 5662 5662 37.77885172 -122.39274979 3RD ST \ TOWNSEND ST TOWNSEND ST \ 03RD ST 1710875501000 middleware_editor NO LEFT TURN (SYM) 03RD ST intersection - 0 / 00 - - - - - 35037 -111369600000 -122.39274979 37.77885172 - - - D6 - NO LEFT TURN REG R3-2.0001 24X24 SUP1 UNKNOWN RETD 1373568720000 TOWNSEND ST - - - - - -
17962 N/A Point - - - - S109370 JACKSON ST: DAVIS CT \ DAVIS S - F F - F 24577000 24577000 - - NORTH EAST CORNER, WESTBOUND TRAFFIC - - - - DAVIS CT \ DAVIS ST DAVIS CT \ DAVIS ST 5851 5851 37.79709205 -122.39833315 JACKSON ST \ DAVIS CT \ DAVIS ST JACKSON ST \ DAVIS CT \ DAVIS ST 1710539427000 MTA STOP DAVIS CT \ DAVIS ST intersection - 0 / 0 - - - - - 35038 467251200000 -122.39833315 37.79709205 - 1597104000000 - D3 - STOP REG R1-1.0002 30X30 SUP1 2IN IRON POST IS 1373570460000 JACKSON ST - - - - - -
17963 N/A Point - - - - S113231 DIVISADERO ST: TURK ST - F F - F 26077000 26077000 - - CENTER ISLAND, NORTHBOUND TRAFFIC - - - - TURK ST TURK ST 7355 7355 37.77965963 -122.43874018 DIVISADERO ST \ TURK ST DIVISADERO ST \ TURK ST 1710539427000 MTA NO RIGHT TURN (SYM) TURK ST intersection - - - - - - - 35039 985046400000 -122.43874018 37.77965963 - 1686700800000 - D5 - NO RIGHT TURN REG R3-1.0001 24X24 SUP1 LIGHT POLE IS 1373571660000 DIVISADERO ST - - - - - -
17964 N/A Point - - - - S113232 DIVISADERO ST: TURK ST - F F - F 26077000 26077000 - - CENTER ISLAND, SOUTHBOUND TRAFFIC - - - - TURK ST TURK ST 7356 7356 37.77965963 -122.43874018 DIVISADERO ST \ TURK ST DIVISADERO ST \ TURK ST 1710539427000 MTA NO LEFT TURN (SYM) TURK ST intersection - NA - - - - - 35040 985046400000 -122.43874018 37.77965963 - 1686700800000 - D5 - NO LEFT TURN REG R3-2.0003 36X36 SUP1 LIGHT POLE IS 1373571660000 DIVISADERO ST - - - - - -
17965 N/A Point - - - - S113233 SUTTER ST: HYDE ST - F F - F 25163000 25163000 - - NORTH WEST CORNER, WESTBOUND TRAFFIC - - - - SUTTER ST SUTTER ST 7357 7357 37.78817789 -122.41682715 HYDE ST \ SUTTER ST HYDE ST \ SUTTER ST 1710539427000 MTA SKATBRD & BICYCLE RIDING PROH ON SWALK SEC 96 & 100 TC SUTTER ST intersection - - - - - - - 35041 985046400000 -122.41682715 37.78817789 - - - D3 - OTHER REGULATORY REG R(SF).0312 18X24 SUP1 MUNI POLE IS 1373571660000 HYDE ST - - - - - -
17966 N/A Point - - - - S113240 MARKET ST: SOUTH VAN NESS AVE - F F - F 30748000 30748000 - - NORTH EAST CORNER, WESTBOUND TRAFFIC - - - - SOUTH VAN NESS AVE \ VAN NESS AVE SOUTH VAN NESS AVE \ VAN NESS AVE 7358 7358 37.77514707 -122.41925561 MARKET ST \ SOUTH VAN NESS AVE \ VAN NESS AVE MARKET ST \ SOUTH VAN NESS AVE \ VAN NESS AVE 1710539427000 MTA END SOUTH VAN NESS AVE \ VAN NESS AVE intersection - - - - - - - 35042 985132800000 -122.41925561 37.77514707 - - - D6 - OTHER REGULATORY REG R81B(CA).0001 08X05 SUP1 SIGNAL POLE IS 1373571660000 MARKET ST - - - - - -
17967 N/A Point - - - - S111096 19TH ST: YUKON ST - F F - F 26155000 26155000 - - NORTH EAST CORNER, WESTBOUND TRAFFIC - - - - YUKON ST 19TH ST 7360 7360 37.75893944 -122.44217528 19TH ST \ YUKON ST YUKON ST \ 19TH ST 1710823357000 middleware_editor STOP 19TH ST intersection - BACK TO BACK W/EXIST R11 - - - - - 35043 748137600000 -122.44217528 37.75893944 - 897868800000 - D8 - STOP REG R1-1.0002 30X30 SUP2 2IN IRON POST IS 1373571000000 YUKON ST - - - - - -
17968 N/A Point - - - - S111098 19TH ST: YUKON ST - F F - F 26155000 26155000 - - SOUTH WEST CORNER, EASTBOUND TRAFFIC - - - - YUKON ST 19TH ST 7362 7362 37.75893944 -122.44217528 19TH ST \ YUKON ST YUKON ST \ 19TH ST 1710823417000 middleware_editor STOP 19TH ST intersection - SEE PAINT - - - - - 35044 748137600000 -122.44217528 37.75893944 - - - D8 - STOP REG R1-1.0002 30X30 SUP2 2IN IRON POST IS 1373571000000 YUKON ST - - - - - -
17969 N/A Point - - - - S111099 YUKON ST: 19TH ST - F F - F 26155000 26155000 - - NORTH WEST CORNER, SOUTHBOUND TRAFFIC - - - - YUKON ST 19TH ST 7363 7363 37.75893944 -122.44217528 19TH ST \ YUKON ST YUKON ST \ 19TH ST 1710823476000 middleware_editor STOP 19TH ST intersection - BELOW EXIST R17 - - - - - 35045 748137600000 -122.44217528 37.75893944 - - - D8 - STOP REG R1-1.0002 30X30 SUP2 2IN IRON POST IS 1373571000000 YUKON ST - - - - - -
17970 N/A Point - - - - S109429 MASON ST: SHEPHARD PL \ TRUETT - F F - F 25102000 25102000 - - SOUTH WEST CORNER, WESTBOUND TRAFFIC - - - - MASON ST \ TRUETT ST MASON ST \ TRUETT ST 7364 7364 37.79405951 -122.41127157 SHEPHARD PL \ MASON ST \ TRUETT ST SHEPHARD PL \ MASON ST \ TRUETT ST 1710539427000 MTA ONE WAY (RA) MASON ST \ TRUETT ST intersection - 0 / 0 - - - - - 35046 488505600000 -122.41127157 37.79405951 - - - D3 - ONE WAY(RA) REG R6-1.0002 36X12 SUP1 2IN IRON POST IS 1373570520000 SHEPHARD PL - - - - - -
17971 N/A Point - - - - S109432 ALAMEDA ST: RHODE ISLAND ST - F F - F 23861000 23861000 - - SOUTH WEST CORNER, EASTBOUND TRAFFIC - - - - RHODE ISLAND ST ALAMEDA ST 7365 7365 37.76864813 -122.40292681 ALAMEDA ST \ RHODE ISLAND ST RHODE ISLAND ST \ ALAMEDA ST 1710539427000 MTA STOP ALAMEDA ST intersection - 0 / 0 - - - - - 35047 488678400000 -122.40292681 37.76864813 - 1132531200000 - D10 - STOP REG R1-1.0002 30X30 SUP1 2IN IRON POST IS 1373570520000 RHODE ISLAND ST - - - - - -
17972 N/A Point - - - - S109433 WEBSTER ST: HERMANN ST - F F - F 25887000 25887000 - - NORTH WEST CORNER, SOUTHBOUND TRAFFIC - - - - WEBSTER ST WEBSTER ST 7366 7366 37.77045176 -122.42842618 HERMANN ST \ WEBSTER ST HERMANN ST \ WEBSTER ST 1710539427000 MTA STOP WEBSTER ST intersection - 0 / DIRECTION OF STOP SIGN REVERSE - - - - - 35048 488678400000 -122.42842618 37.77045176 - 1578268800000 - D5 - STOP REG R1-1.0002 30X30 SUP1 2IN IRON POST IS 1373570520000 HERMANN ST - - - - - -
17973 N/A Point - - - - S109435 SANSOME ST: LOMBARD ST - F F - F 24870000 24870000 - - SOUTH WEST CORNER, NORTHBOUND TRAFFIC - - - - SANSOME ST SANSOME ST 7367 7367 37.80403013 -122.40334871 LOMBARD ST \ SANSOME ST LOMBARD ST \ SANSOME ST 1710539427000 MTA NO LEFT TURN (SYM) SANSOME ST intersection - 0 / MAKE LOMBARD ONE WAY EASTBOUND - - - - - 35049 488678400000 -122.40334871 37.80403013 - 1684108800000 - D3 - NO LEFT TURN REG R3-2.0002 30X30 SUP1 LIGHT POLE IS 1373570520000 LOMBARD ST - - - - - -
17974 N/A Point - - - - S109437 CHESTNUT ST: MONTGOMERY ST - F F - F 24875000 24875000 - - NORTH EAST CORNER, EASTBOUND TRAFFIC - - - - MONTGOMERY ST CHESTNUT ST 7368 7368 37.80476321 -122.40517354 CHESTNUT ST \ MONTGOMERY ST MONTGOMERY ST \ CHESTNUT ST 1710539427000 MTA DO NOT ENTER CHESTNUT ST intersection - 0 / MAKE ONE WAY WEST BOUND - - - - - 35050 488678400000 -122.40517354 37.80476321 - - - D3 - OTHER REGULATORY REG R5-1.0001 30X30 SUP1 2IN IRON POST IS 1373570520000 MONTGOMERY ST - - - - - -
17975 N/A Point 1 1 2550 - 2599 - S111877 2550-2599 23RD ST 2550-2599 23RD ST F F - F 33638000 1251000 - - NORTH SIDE, WESTBOUND TRAFFIC - - - - SFGH ACCESS SFGH ACCESS 7369 7369 37.75443311 -122.404967751 23RD ST \ SFGH ACCESS - 1744306950000 middleware_editor STOP SFGH ACCESS to UTAH ST (2550 - 2599) - AT ENTRANCE OF GENERAL HOSPITAL - - - - - 35051 873961200000 -122.40524308 37.75434998 - 1744303200000 - D10 - STOP REG R1-1.0002 30X30 SUP1 2IN IRON POST IS 1373571240000 23RD ST - 2550 - 2599 23RD ST 2550 23RD ST - - UTAH ST
17976 N/A Point 1 1 2500 - 2549 - S111878 2500-2599 23RD ST 2500-2549 23RD ST F F - F 33638000 1250000 - - SOUTH SIDE, EASTBOUND TRAFFIC - - - - SFGH ACCESS SAN BRUNO AVE 7370 7370 37.754310767882 -122.405085888206 23RD ST \ SFGH ACCESS - 1743775450000 elclark STOP SAN BRUNO AVE to SFGH ACCESS (2500 - 2549) - 55'E OF UTAH - - - - - 35052 873961200000 -122.40475818 37.75437926 - - - D10 - STOP REG R1-1.0002 30X30 SUP1 2IN IRON POST IS 1373571240000 23RD ST - 2500 - 2549 23RD ST 2500 23RD ST - - SFGH ACCESS
17977 N/A Point - - - - S111879 BRYANT ST: 2ND ST - T T - F 24490000 24490000 - - SOUTH WEST CORNER, SOUTHBOUND TRAFFIC - - - - BRYANT ST 02ND ST 7371 7371 37.78307785 -122.39361808 2ND ST \ BRYANT ST BRYANT ST \ 02ND ST 1710539427000 MTA ONE WAY (LA) 02ND ST intersection - - - - - - - 35053 874022400000 -122.39361808 37.78307785 - 1591228800000 - D6 - ONE WAY(LA) REG R6-1.0001 48X16 SUP1 SIGNAL POLE IS 1373571240000 BRYANT ST - - - - - -
17978 N/A Point - - - - S111880 MERCURY ST: THORNTON AVE - F F - F 20628000 20628000 - - NORTH EAST CORNER, NORTHBOUND TRAFFIC - - - - THORNTON AVE THORNTON AVE 7372 7372 37.73121738 -122.40128832 MERCURY ST \ THORNTON AVE MERCURY ST \ THORNTON AVE 1752597805000 middleware_editor DO NOT ENTER THORNTON AVE intersection - - - - - - - 35054 874306800000 -122.40128832 37.73121738 - 1738161000000 - D10 - OTHER REGULATORY REG R5-1.0001 30X30 SUP1 2IN IRON POST IS 1373571240000 MERCURY ST - - - - - -
17979 N/A Point - - - - S110327 20TH ST: COLLINGWOOD ST - F F - F 25775000 25775000 - - SOUTH WEST CORNER, EASTBOUND TRAFFIC - - - - COLLINGWOOD ST COLLINGWOOD ST 7373 7373 37.7576231 -122.43580799 20TH ST \ COLLINGWOOD ST 20TH ST \ COLLINGWOOD ST 1710539427000 MTA STOP COLLINGWOOD ST intersection - 0 / 0 - - - - - 35055 621648000000 -122.43580799 37.7576231 - 1241136000000 - D8 - STOP REG R1-1.0002 30X30 SUP2 2IN IRON POST IS 1373570760000 20TH ST - - - - - -
17980 N/A Point 1 1 500 - 599 - S120057 500-599 STAPLES AVE 500-599 STAPLES AVE F F - F 12108000 12108000 - - NORTH SIDE - - - - FRIDA KAHLO WAY FRIDA KAHLO WAY 14608 14608 37.72912395 -122.45321853 - - 1718310741000 middleware_editor NPRK 8AM-4PM EXC SAT SUN & HOLIDAY FRIDA KAHLO WAY to HAZELWOOD AVE (500 - 599) - IFO#536 - - - - - 35056 1104192000000 -122.45321853 37.72912395 - - - D7 - PARKING REG R30(CA).0033 12X18 SUP2 2IN IRON POST IS 1373573820000 STAPLES AVE 500 - 599 STAPLES AVE 500 - 599 STAPLES AVE 500 STAPLES AVE - HAZELWOOD AVE HAZELWOOD AVE
17981 N/A Point 1 1 1 - 14 - S120058 1-14 HAZELWOOD AVE 1-14 HAZELWOOD AVE F F - F 6836000 6836000 - - EAST SIDE - - - - JUDSON AVE JUDSON AVE 14609 14609 37.72865739 -122.45399326 - - 1720055414000 middleware_editor 2 HR PRK 8AM-4PM SCHL DAYS JUDSON AVE to GREENWOOD AVE (1 - 14) - IFO#10 - - - - - 35057 1104192000000 -122.45399326 37.72865739 - - - D7 - PARKING REG R32(CA).0077 18X18 SUP2 LIGHT POLE IS 1373573820000 HAZELWOOD AVE 1 - 14 HAZELWOOD AVE 1 - 14 HAZELWOOD AVE 1 HAZELWOOD AVE - GREENWOOD AVE GREENWOOD AVE
17982 N/A Point 1 1 1 - 49 - S120059 1-49 GREENWOOD AVE 1-49 GREENWOOD AVE F F - F 6526000 6526000 - - SOUTH SIDE - - - - HAZELWOOD AVE HAZELWOOD AVE 14610 14610 37.72879042 -122.45439044 - - 1710539427000 MTA 2 HR PRK 8AM-4PM SCHL DAYS HAZELWOOD AVE to VALDEZ AVE (1 - 49) - IFO#15 - - - - - 35058 1104192000000 -122.45439044 37.72879042 - - - D7 - PARKING REG R32(CA).0077 18X18 SUP2 2IN IRON POST IS 1373573820000 GREENWOOD AVE 1 - 49 GREENWOOD AVE 1 - 49 GREENWOOD AVE 1 GREENWOOD AVE - VALDEZ AVE VALDEZ AVE
17983 N/A Point 1 1 100 - 199 - S120060 100-199 HAZELWOOD AVE 100-199 HAZELWOOD AVE F F - F 6840000 6840000 - - EAST SIDE - - - - MONTECITO AVE MONTECITO AVE 14611 14611 37.73098463 -122.45457114 - - 1722474473000 middleware_editor 2 HR PRK 8AM-4PM SCHL DAYS MONTECITO AVE to MONTEREY BLVD (100 - 199) - OPP#125 - - - - - 35059 1104192000000 -122.45457114 37.73098463 - - - D7 - PARKING REG R32(CA).0077 18X18 SUP2 2IN IRON POST IS 1373573820000 HAZELWOOD AVE 100 - 199 HAZELWOOD AVE 100 - 199 HAZELWOOD AVE 100 HAZELWOOD AVE - MONTEREY BLVD MONTEREY BLVD
17984 N/A Point 1 1 32 - 69 - S120062 32-69 HAZELWOOD AVE 32-69 HAZELWOOD AVE F F - F 6838000 6838000 - - EAST SIDE - - - - STAPLES AVE STAPLES AVE 14612 14612 37.72950086 -122.45402509 - - 1710539427000 MTA 2 HR PRK 8AM-4PM SCHL DAYS STAPLES AVE to FLOOD AVE (32 - 69) - IFO#34 - - - - - 35060 1104192000000 -122.45402509 37.72950086 - - - D7 - PARKING REG R32(CA).0077 18X18 SUP2 2IN IRON POST IS 1373573820000 HAZELWOOD AVE 32 - 69 HAZELWOOD AVE 32 - 69 HAZELWOOD AVE 32 HAZELWOOD AVE - FLOOD AVE FLOOD AVE
17985 N/A Point 1 1 32 - 69 - S120063 32-69 HAZELWOOD AVE 32-69 HAZELWOOD AVE F F - F 6838000 6838000 - - EAST SIDE - - - - STAPLES AVE STAPLES AVE 14613 14613 37.72950086 -122.45402509 - - 1710539427000 MTA 2 HR PRK 8AM-4PM SCHL DAYS STAPLES AVE to FLOOD AVE (32 - 69) - IFO#60 - - - - - 35061 1104192000000 -122.45402509 37.72950086 - - - D7 - PARKING REG R32(CA).0077 18X18 SUP2 2IN IRON POST IS 1373573820000 HAZELWOOD AVE 32 - 69 HAZELWOOD AVE 32 - 69 HAZELWOOD AVE 32 HAZELWOOD AVE - FLOOD AVE FLOOD AVE
17986 N/A Point - - - - S120065 20TH ST: KANSAS ST - F F - F 23761000 23761000 - - SOUTH EAST CORNER, SOUTHBOUND TRAFFIC - - - - 20TH ST 20TH ST 14614 14614 37.7596171 -122.40304821 KANSAS ST \ 20TH ST KANSAS ST \ 20TH ST 1710539427000 MTA DEAD END 20TH ST intersection - - - - - - - 35062 1104192000000 -122.40304821 37.7596171 - - - D10 - OTHER WARNING WARNING W14-1.0002 30X30 SUP1 LIGHT POLE IS 1373573820000 KANSAS ST - - - - - -
17987 N/A Point - - - - S120066 20TH ST: KANSAS ST - F F - F 23761000 23761000 - - SOUTH WEST CORNER, SOUTHBOUND TRAFFIC - - - - 20TH ST 20TH ST 14615 14615 37.7596171 -122.40304821 KANSAS ST \ 20TH ST KANSAS ST \ 20TH ST 1710539427000 MTA DEAD END 20TH ST intersection - - - - - - - 35063 1104192000000 -122.40304821 37.7596171 - - - D10 - OTHER WARNING WARNING W14-1.0002 30X30 SUP1 3IN IRON POST IS 1373573820000 KANSAS ST - - - - - -
17988 N/A Point - - - - S120067 BALBOA ST: 32ND AVE - F F - F 27837000 27837000 - - NORTH EAST CORNER, WESTBOUND TRAFFIC - - - - BALBOA ST 32ND AVE 14616 14616 37.77596006 -122.49195945 32ND AVE \ BALBOA ST BALBOA ST \ 32ND AVE 1738611341000 middleware_editor ALL WAY 32ND AVE intersection - - - - - - - 35064 1104278400000 -122.49195945 37.77596006 - 1592265600000 - D1 - ALL WAY REG R1-3P.0001 18X06 SUP2 2IN IRON POST IS 1373573820000 BALBOA ST - - - - - -
17989 N/A Point - - - - S120068 BALBOA ST: 32ND AVE - F F - F 27837000 27837000 - - SOUTH WEST CORNER, EASTBOUND TRAFFIC - - - - BALBOA ST 32ND AVE 14617 14617 37.77596006 -122.49195945 32ND AVE \ BALBOA ST BALBOA ST \ 32ND AVE 1738882814000 middleware_editor ALL WAY 32ND AVE intersection - IFO #3101 BALBOA - - - - - 35065 1104278400000 -122.49195945 37.77596006 - 1738840080000 - D1 - ALL WAY REG R1-3P.0001 18X06 SUP2 MUNI POLE IS 1373573820000 BALBOA ST - - - - - -
17990 N/A Point - - - - S120070 32ND AVE: BALBOA ST - F F - F 27837000 27837000 - - NORTH WEST CORNER, NORTHBOUND TRAFFIC - - - - BALBOA ST 32ND AVE 14619 14619 37.77596006 -122.49195945 32ND AVE \ BALBOA ST BALBOA ST \ 32ND AVE 1738882818000 middleware_editor ALL WAY 32ND AVE intersection - - - - - - - 35066 1104278400000 -122.49195945 37.77596006 - 1738839840000 - D1 - ALL WAY REG R1-3P.0001 18X06 SUP2 2IN IRON POST IS 1373573820000 BALBOA ST - - - - - -
17991 N/A Point 1 1 1 - 199 - S119805 1-197 MUSEUM WAY 1-199 MUSEUM WAY F F - F 9463000 9463000 - - EAST SIDE, NORTHBOUND TRAFFIC - - - - FAIRBANKS ST \ ROOSEVELT WAY FAIRBANKS ST \ ROOSEVELT WAY 14620 14620 37.76458979 -122.44015692 - - 1710539427000 MTA STOP FAIRBANKS ST \ ROOSEVELT WAY to END: 1-197 BLOCK (1 - 199) - 19 FEET SOUTH OF DRIVEWAY CUT @ SE ..... - - - - - 35067 1101081600000 -122.44015692 37.76458979 - 1661904000000 - D8 - STOP REG R1-1.0002 30X30 SUP2 2IN IRON POST IS 1373573760000 MUSEUM WAY 1 - 199 MUSEUM WAY 1 - 199 MUSEUM WAY 1 MUSEUM WAY - END: 1-197 BLOCK END: 1-197 BLOCK
17992 N/A Point - - - - S120171 CONNECTICUT ST: MARIPOSA ST - F F - F 23682000 23682000 - - NORTH WEST CORNER, SOUTHBOUND TRAFFIC - - - - CONNECTICUT ST MARIPOSA ST 14622 14622 37.76379389 -122.39761271 MARIPOSA ST \ CONNECTICUT ST CONNECTICUT ST \ MARIPOSA ST 1710539427000 MTA ALL WAY MARIPOSA ST intersection - - - - - - - 35068 1106092800000 -122.39761271 37.76379389 - - - D10 - ALL WAY REG R1-3P.0001 18X06 SUP1 MUNI POLE IS 1373573880000 CONNECTICUT ST - - - - - -
17993 N/A Point - - - - S120172 CONNECTICUT ST: MARIPOSA ST - F F - F 23682000 23682000 - - SOUTH EAST CORNER, NORTHBOUND TRAFFIC - - - - CONNECTICUT ST MARIPOSA ST 14623 14623 37.76379389 -122.39761271 MARIPOSA ST \ CONNECTICUT ST CONNECTICUT ST \ MARIPOSA ST 1710539427000 MTA ALL WAY MARIPOSA ST intersection - - - - - - - 35069 1106092800000 -122.39761271 37.76379389 - 1608508800000 - D10 - ALL WAY REG R1-3P.0001 18X06 SUP1 2IN IRON POST IS 1373573880000 CONNECTICUT ST - - - - - -
17994 N/A Point - - - - S120173 TEXAS ST: MARIPOSA ST - F F - F 23676000 23676000 - - NORTH WEST CORNER, SOUTHBOUND TRAFFIC - - - - TEXAS ST TEXAS ST 14624 14624 37.76390699 -122.39568232 MARIPOSA ST \ TEXAS ST MARIPOSA ST \ TEXAS ST 1710539427000 MTA ALL WAY TEXAS ST intersection - - - - - - - 35070 1106092800000 -122.39568232 37.76390699 - - - D10 - ALL WAY REG R1-3P.0001 18X06 SUP1 2IN IRON POST IS 1373573880000 MARIPOSA ST - - - - - -
17995 N/A Point 1 1 100 - 199 - S119394 100-199 OFARRELL ST 100-199 OFARRELL ST F F - F 9722000 9722000 - - NORTH SIDE - - - - STOCKTON ST STOCKTON ST 14625 14625 37.78651248 -122.40721756 - - 1710539427000 MTA TANSAT STOCKTON ST to POWELL ST (100 - 199) - 180'WEST OPPOSITE # 121 @ PM - - - - - 35071 1094083200000 -122.40721756 37.78651248 - - - D3 - TOW (TANSAT) REG R37(CA).0090 18X21 SUP1 2IN FLANGE POST IS 1373573640000 OFARRELL ST 100 - 199 OFARRELL ST 100 - 199 OFARRELL ST 100 OFARRELL ST - POWELL ST POWELL ST
17996 N/A Point 1 1 100 - 199 - S119395 100-199 OFARRELL ST 100-199 OFARRELL ST F F - F 9722000 9722000 - - NORTH SIDE - - - - STOCKTON ST STOCKTON ST 14626 14626 37.78651248 -122.40721756 - - 1710539427000 MTA TANSAT STOCKTON ST to POWELL ST (100 - 199) - EPL # 184 - - - - - 35072 1094083200000 -122.40721756 37.78651248 - - - D3 - TOW (TANSAT) REG R37(CA).0090 18X21 SUP1 LIGHT POLE IS 1373573640000 OFARRELL ST 100 - 199 OFARRELL ST 100 - 199 OFARRELL ST 100 OFARRELL ST - POWELL ST POWELL ST
17997 N/A Point 1 1 2400 - 2499 - S119397 2400-2499 TAYLOR ST 2400-2499 TAYLOR ST F F - F 12462000 12462000 - - WEST SIDE - - - - FRANCISCO ST FRANCISCO ST 14627 14627 37.80485535 -122.41512794 - - 1710539427000 MTA TANSAT FRANCISCO ST to END: 2400-2499 BLOCK (2400 - 2499) - 100' NORTH - - - - - 35073 1094169600000 -122.41512794 37.80485535 - - - D3 - TOW (TANSAT) REG R37(CA).0090 18X21 SUP1 LIGHT POLE IS 1373573640000 TAYLOR ST 2400 - 2499 TAYLOR ST 2400 - 2499 TAYLOR ST 2400 TAYLOR ST - END: 2400-2499 BLOCK END: 2400-2499 BLOCK
17998 N/A Point 1 1 3101 - 3195 - S126629 PNDG SAN BRUNO AVE 3101-3195 SAN BRUNO AVE F F - F 11384000 11384000 - - EAST SIDE - - - - WARE ST WARE ST 21836 21836 37.72201886 -122.40127579 - - 1710539427000 MTA NPRK 7AM-8AM TUE THUR STCL WARE ST to HWY 101 S OFF RAMP (3101 - 3195) - 0 / INSTALL SIGN AND 2IN POST AT NO..... - - - - - 35074 1170201600000 -122.40127579 37.72201886 - - - D9 - STREET CLEANING REG R30B(CA).0222 18X18 SUP2 2IN IRON POST IS 1373575860000 SAN BRUNO AVE PNDG SAN BRUNO AVE 3101 - 3195 SAN BRUNO AVE - - HWY 101 S OFF RAMP HWY 101 S OFF RAMP
17999 N/A Point - - - - S126631 ROOSEVELT WAY: 15TH ST \ PARK - F F - F 26018000 26018000 - - SOUTH WEST CORNER, EASTBOUND TRAFFIC - - - - 15TH ST \ PARK HILL AVE 15TH ST \ PARK HILL AVE 21837 21837 37.76657553 -122.43950184 ROOSEVELT WAY \ 15TH ST \ PARK HILL AVE ROOSEVELT WAY \ 15TH ST \ PARK HILL AVE 1746462539000 middleware_editor PEDESTRIAN (SYM) 15TH ST \ PARK HILL AVE intersection - WEST CROSSWALK - - - - - 35075 1170230400000 -122.43950184 37.76657553 - 1633417200000 - D8 - OTHER WARNING WARNING W11-2.0003 30X30 SUP2 2IN IRON POST IS 1373575860000 ROOSEVELT WAY - - - - - -
18000 N/A Point 1 1 2500 - 2599 - S126634 2500-2599 SAN BRUNO AVE 2500-2599 SAN BRUNO AVE F F - F 11376000 11376000 - - EAST SIDE - - - - FELTON ST FELTON ST 21838 21838 37.7294361 -122.40434616 - - 1715735037000 middleware_editor NPRK 7AM-8AM TUE THUR STCL FELTON ST to BURROWS ST (2500 - 2599) - NPL #2559-2561 - - - - - 35076 1170288000000 -122.40434616 37.7294361 - 1422835200000 - D9 - STREET CLEANING REG R30B(CA).0222 18X18 SUP2 LIGHT POLE IS 1373575860000 SAN BRUNO AVE 2500 - 2599 SAN BRUNO AVE 2500 - 2599 SAN BRUNO AVE 2500 SAN BRUNO AVE - BURROWS ST BURROWS ST
Showing 17926 to 18000 of 150140 records
Loading...
Loading Map...
Preparing spatial data visualization
Data Analysis
Chart Options
Export Spatial Data
CSV Export

Download data as a comma-separated values file with coordinates and properties.

Download CSV
GeoJSON Export

Download data in GeoJSON format, compatible with most GIS applications.

Download GeoJSON
KML Export

Download data in KML format for use with Google Earth and other mapping applications.

Download KML
Shapefile Export

Download data as a shapefile (ZIP format) for use with ArcGIS and other GIS software.

Download Shapefile
Export Information
  • CSV: Contains coordinates and all properties in a tabular format
  • GeoJSON: Standard format for web mapping and GIS applications
  • KML: Compatible with Google Earth, Google Maps, and other mapping platforms
  • Shapefile: Industry standard format for GIS software (requires GDAL/ogr2ogr)
Export Details
Total Features: 150140
File Name: MTA.signshop_assets
Original Type: ESRI_HARVEST
Properties: 63 fields

Note: Shapefile export requires GDAL/ogr2ogr to be installed on the server. If unavailable, a GeoJSON file will be provided instead. Check your server's error logs for more details.
API Endpoints
Dataset Details

Get detailed information about this dataset including metadata and available properties.

Test Endpoint
Query Data

Query spatial data with filtering, pagination, and spatial operations.

Test Endpoint
Query Parameters
Pagination
  • page - Page number (default: 1)
  • limit - Results per page (max: 1000, default: 100)
Property Filtering
  • properties - JSON object for property filtering
  • geometry_type - Filter by geometry type (Point, LineString, Polygon, etc.)
Spatial Filtering
  • bbox - Bounding box (minX,minY,maxX,maxY)
  • lat - Center latitude for radius search
  • lon - Center longitude for radius search
  • radius - Search radius in meters
Response Format
  • Returns GeoJSON FeatureCollection
  • Includes pagination metadata
  • Contains query information
Example Queries
Basic Queries
Advanced Queries
API Information
Base URL: https://tor.datacatalog.ca//api.php
Dataset ID: 537
Total Features: 150140
Response Format: GeoJSON

Note: All API endpoints return JSON responses. The query endpoint returns GeoJSON FeatureCollection format for spatial data.
Rate Limiting: Consider implementing rate limiting for production use to prevent abuse.
Spatial Data Metadata
Basic Information
Not specified
Not specified
Not specified
Not specified
Not specified
Not specified
Not specified
Technical Information
Not specified
Not specified
Not specified
Not specified
Not specified
Not specified
Citation Information
Not specified
Not specified
Not specified
Not specified
Temporal Information
Not specified
Not specified
Not specified
Metadata Contact
Not specified
Not specified
Not specified
Not specified
Data Quality
Not specified
Not specified
Not specified
Constraints
Not specified
Not specified
Not specified
Distribution
Not specified
Not specified
Not specified
Not specified
Not specified
Additional Information
Not specified
Not specified