trees
11,761 rows where qSpecies_id = 17 sorted by qCaretaker_id
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
76405 | 173919 | DPW Maintained 1 | Tree(s) :: 17 | 2160X 09th Ave | 7 | Median : Cutout | Tree | DPW 1 | 6x10 | 5993671 | 2100995 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | 1 | 8 | 4 | 29491 | 40 | ||||
77174 | 28936 | DPW Maintained 1 | Tree(s) :: 17 | 350 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009925.6038615 | 2109969.203142 | 37.7741332326441 | -122.409107271232 | (37.7741332326441, -122.409107271232) | 8 | 2 | 9 | 28853 | 34 | |
78433 | 104459 | DPW Maintained 1 | Tree(s) :: 17 | 1601X Kansas St | 3 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 4 | 3x6 | 6011789.30586 | 2100707.09327 | 37.748805772054 | -122.402009105448 | (37.748805772054, -122.402009105448) | 10 | 3 | 8 | 58 | 1 | |||
79270 | 28937 | DPW Maintained 1 | Tree(s) :: 17 | 350 08th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009925.6038615 | 2109969.203142 | 37.7741332326441 | -122.409107271232 | (37.7741332326441, -122.409107271232) | 8 | 2 | 9 | 28853 | 34 | |
81420 | 17844 | DPW Maintained 1 | Tree(s) :: 17 | 2064 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/03/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780190 | 6004071.9084 | 2115331.7333 | 37.7885277407175 | -122.429738786656 | (37.7885277407175, -122.429738786656) | 13 | 9 | 11 | 29490 | 27 | |
81495 | 106392 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 19 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
81638 | 96139 | DPW Maintained 1 | Tree(s) :: 17 | 1460X Innes Ave | 1 | Median : Yard | Tree | DPW 1 | 12 | 6016261.2 | 2096710.2 | 37.7380796956477 | -122.386266549459 | (37.7380796956477, -122.386266549459) | 10 | 3 | 8 | 58 | 1 | ||||
82169 | 22858 | DPW Maintained 1 | Tree(s) :: 17 | 144 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 5999468.3728742 | 2098975.529944 | 37.7433559522386 | -122.444490278488 | (37.7433559522386, -122.444490278488) | 2 | 7 | 5 | 63 | 7 | |||
82372 | 105324 | DPW Maintained 1 | Tree(s) :: 17 | 2051 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | Permit Number 771015 | 6015779.9 | 2106081.5 | 37.7637846705736 | -122.388584622631 | (37.7637846705736, -122.388584622631) | 14 | 3 | 8 | 28856 | 29 | |||
83345 | 96130 | DPW Maintained 1 | Tree(s) :: 17 | 1428X Innes Ave | 1 | Median : Yard | Tree | DPW 1 | 12 | 6016403.1 | 2096603.7 | 37.7377951214128 | -122.385768505015 | (37.7377951214128, -122.385768505015) | 10 | 3 | 8 | 58 | 1 | ||||
84387 | 100665 | Permitted Site 7 | Tree(s) :: 17 | 63 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/04/2012 12:00:00 AM | 3x3 | Permit Number 769258 | 6003201.8 | 2107946.7 | 37.7682009695292 | -122.432221606092 | (37.7682009695292, -122.432221606092) | 15 | 5 | 5 | 28862 | 3 | |
85535 | 90656 | DPW Maintained 1 | Tree(s) :: 17 | 3450 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 12/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776853 | 5984933.736244 | 2110433.593284 | 37.7739765609982 | -122.495591517296 | (37.7739765609982, -122.495591517296) | 11 | 6 | 2 | 55 | 26 |
86536 | 879 | DPW Maintained 1 | Tree(s) :: 17 | 600X Alemany Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | 2 | 7 | 7 | 28861 | 2 | |||
88159 | 106377 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 4 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
88742 | 877 | DPW Maintained 1 | Tree(s) :: 17 | 600X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | 2 | 7 | 7 | 28861 | 2 | |||
89216 | 8324 | DPW Maintained 1 | Tree(s) :: 17 | 1101 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/08/2013 12:00:00 AM | 6 | 3x5 | 6006325.83915 | 2114183.13875 | 37.7855013564448 | -122.421858899832 | (37.7855013564448, -122.421858899832) | 13 | 9 | 11 | 28858 | 41 | ||
89498 | 27440 | DPW Maintained 1 | Tree(s) :: 17 | 1690X Indiana St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6015146.8447845 | 2100681.5042352 | 37.7489223309609 | -122.390396861105 | (37.7489223309609, -122.390396861105) | 10 | 3 | 8 | 58 | 1 | |||
90789 | 10292 | DPW Maintained 1 | Tree(s) :: 17 | 488 Haight St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3x4 | 6003826.4075 | 2109393.9739 | 37.7722102257422 | -122.430164413383 | (37.7722102257422, -122.430164413383) | 7 | 9 | 11 | 29492 | 10 | |||
91642 | 103567 | DPW Maintained 1 | Tree(s) :: 17 | 49X Nevada St | 1 | Front Yard : Yard | Tree | DPW 1 | DPW property; tree is below Bernal Heights Blvd; near this address | 6009060 | 2098204 | 37.741780122475 | -122.411270274356 | (37.741780122475, -122.411270274356) | 10 | 7 | 7 | 28859 | 2 | ||||
91953 | 105325 | DPW Maintained 1 | Tree(s) :: 17 | 2051 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | Permit Number 771015 | 6015779.9 | 2106081.5 | 37.7637846705736 | -122.388584622631 | (37.7637846705736, -122.388584622631) | 14 | 3 | 8 | 28856 | 29 | |||
92535 | 107891 | Permitted Site 7 | Tree(s) :: 17 | 941 Washington St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | ||||
92648 | 28968 | DPW Maintained 1 | Tree(s) :: 17 | 2455 Hyde St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6006975.5076786 | 2120876.6023829 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | 5 | 1 | 1 | 28858 | 32 | ||||||
94961 | 106389 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 16 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
95878 | 91776 | DPW Maintained 1 | Tree(s) :: 17 | 1200x Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6010069.453126 | 2109834.328197 | 37.7737709548765 | -122.40860015267 | (37.7737709548765, -122.40860015267) | 8 | 2 | 9 | 28853 | 34 | |
95891 | 87443 | DPW Maintained 1 | Tree(s) :: 17 | 2801X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3x3 | 5997499.095645 | 2087961.159651 | 37.7130005371424 | -122.450505622879 | (37.7130005371424, -122.450505622879) | 9 | 7 | 6 | 28861 | 25 | |||
96353 | 29461 | DPW Maintained 1 | Tree(s) :: 17 | 1735X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2X3 | 6016645.7817587 | 2093112.7248692 | 37.7282230250629 | -122.384686318732 | (37.7282230250629, -122.384686318732) | 10 | 3 | 8 | 58 | 1 | |||
96373 | 107561 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 12 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
96546 | 870 | DPW Maintained 1 | Tree(s) :: 17 | 600X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | 2 | 7 | 7 | 28861 | 2 | |||
96773 | 92813 | Significant Tree 6 | Tree(s) :: 17 | 365 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | Permit Number 53020 | 6006011 | 2111744 | 37.7787863189721 | -122.42277474798 | (37.7787863189721, -122.42277474798) | 7 | 9 | 11 | 28852 | 10 | |||
97502 | 543 | DPW Maintained 1 | Tree(s) :: 17 | 2871 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3X3 | 6009625.4825 | 2102172.3236 | 37.7527079631855 | -122.409595033175 | (37.7527079631855, -122.409595033175) | 2 | 4 | 7 | 28859 | 19 | |||
98264 | 107548 | DPW Maintained 1 | Tree(s) :: 17 | 198X Jennings St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.7393885572332 | -122.377570991407 | (37.7393885572332, -122.377570991407) | 10 | 3 | 8 | 58 | 1 | |
98721 | 107560 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |
99033 | 12958 | DPW Maintained 1 | Tree(s) :: 17 | 829X Chenery St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6001844.2088716 | 2095812.5283612 | 37.7348063625139 | -122.436048971563 | (37.7348063625139, -122.436048971563) | 2 | 7 | 5 | 63 | 7 | |||
102600 | 107890 | Permitted Site 7 | Tree(s) :: 17 | 941 Washington St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | ||||
103232 | 254273 | DPW Maintained 1 | Tree(s) :: 17 | 355 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005049 | 2110166 | 37.7743991919417 | -122.425990324694 | (37.7743991919417, -122.425990324694) | 7 | 9 | 11 | 28852 | 10 | ||||
103383 | 3886 | DPW Maintained 1 | Tree(s) :: 17 | 18 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6002041.7840637 | 2108518.2345868 | 37.7697044226674 | -122.436274885743 | (37.7697044226674, -122.436274885743) | 15 | 5 | 5 | 29492 | 9 | |||
103804 | 106384 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 11 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
103978 | 26070 | DPW Maintained 1 | Tree(s) :: 17 | 251 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/23/2002 12:00:00 AM | 3 | 3X3 | 5993991.0956793 | 2088217.0958164 | 37.7135018699932 | -122.462648897038 | (37.7135018699932, -122.462648897038) | 9 | 8 | 6 | 64 | 24 | ||
105574 | 96129 | DPW Maintained 1 | Tree(s) :: 17 | 1424X Innes Ave | 1 | Median : Yard | Tree | DPW 1 | 12 | 6016423.9 | 2096594.4 | 37.7377707364606 | -122.385695940665 | (37.7377707364606, -122.385695940665) | 10 | 3 | 8 | 58 | 1 | ||||
106276 | 91388 | DPW Maintained 1 | Tree(s) :: 17 | 151 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52086 | 6006268.862 | 2110391.01499 | 37.7750858950422 | -122.421786571974 | (37.7750858950422, -122.421786571974) | 7 | 9 | 11 | 28852 | 10 | |
110211 | 252861 | DPW Maintained 1 | Tree(s) :: 17 | 988 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779759 | 6010589.4479 | 2112082.95565 | 37.7799742710855 | -122.40695991983 | (37.7799742710855, -122.40695991983) | 14 | 2 | 9 | 28853 | 34 | |
110286 | 95333 | DPW Maintained 1 | Tree(s) :: 17 | 399X Filbert St | 5 | Median : Yard | Tree | DPW 1 | 24 | 6010951.1 | 2119992.4 | 37.8017119430502 | -122.406266229116 | (37.8017119430502, -122.406266229116) | 3 | 1 | 10 | 308 | 23 | ||||
111499 | 27545 | DPW Maintained 1 | Tree(s) :: 17 | 1301X Illinois St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/24/2004 12:00:00 AM | 3 | 3X3 | 6016183.3939043 | 2103024.539071 | 37.7554132592376 | -122.386975829537 | (37.7554132592376, -122.386975829537) | 10 | 3 | 8 | 28856 | 29 | ||
114557 | 107035 | DPW Maintained 1 | Tree(s) :: 17 | 350 08th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/23/2014 12:00:00 AM | 3x3 | Permit Number 772214 | 6009826 | 2110084 | 37.7744428576765 | -122.409459923405 | (37.7744428576765, -122.409459923405) | 8 | 2 | 9 | 28853 | 34 | ||
114583 | 16460 | DPW Maintained 1 | Tree(s) :: 17 | 2X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3X3 | Permit Number 774049 | 6018746.8015012 | 2097101.6577332 | 37.7392918278803 | -122.377699652009 | (37.7392918278803, -122.377699652009) | 10 | 3 | 8 | 58 | 1 | |
115023 | 254274 | DPW Maintained 1 | Tree(s) :: 17 | 355 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005049 | 2110166 | 37.7743991919417 | -122.425990324694 | (37.7743991919417, -122.425990324694) | 7 | 9 | 11 | 28852 | 10 | ||||
117353 | 122682 | DPW Maintained 1 | Tree(s) :: 17 | 2160X 09th Ave | 2 | Median : Cutout | Tree | DPW 1 | 02/03/2017 12:00:00 AM | 3 | 6x10 | Permit Number 778226 | 5993671 | 2100995 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | 1 | 8 | 4 | 29491 | 40 | |
118097 | 106387 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 14 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
119862 | 107553 | Significant Tree 6 | Tree(s) :: 17 | 1 Newhall St | 3 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
126188 | 868 | DPW Maintained 1 | Tree(s) :: 17 | 600X Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | 2 | 7 | 7 | 28861 | 2 | |||
126501 | 880 | DPW Maintained 1 | Tree(s) :: 17 | 600X Alemany Blvd | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | 2 | 7 | 7 | 28861 | 2 | |||
128204 | 875 | DPW Maintained 1 | Tree(s) :: 17 | 600X Alemany Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | 2 | 7 | 7 | 28861 | 2 | |||
129917 | 872 | DPW Maintained 1 | Tree(s) :: 17 | 600X Alemany Blvd | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | 2 | 7 | 7 | 28861 | 2 | |||
130341 | 106381 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 8 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
134698 | 4150 | DPW Maintained 1 | Tree(s) :: 17 | 3709X Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005798.7041306 | 2100501.8256949 | 37.7479059827851 | -122.42271003071 | (37.7479059827851, -122.42271003071) | 2 | 4 | 5 | 28859 | 22 | |||
135414 | 107540 | DPW Maintained 1 | Tree(s) :: 17 | 198X JENNINGS ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018784 | 2097136 | 37.739388174499 | -122.377573417349 | (37.739388174499, -122.377573417349) | 10 | 3 | 8 | 58 | 1 | ||
135959 | 1318 | DPW Maintained 1 | Tree(s) :: 17 | 4050X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/11/1992 12:00:00 AM | 3 | TR | 5991740.4279021 | 2087082.0100679 | 37.7102553211792 | -122.470345319704 | (37.7102553211792, -122.470345319704) | 9 | 8 | 4 | 64 | 24 | ||
136738 | 867 | DPW Maintained 1 | Tree(s) :: 17 | 600X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | 2 | 7 | 7 | 28861 | 2 | |||
141703 | 96138 | DPW Maintained 1 | Tree(s) :: 17 | 1454X Innes Ave | 3 | Median : Yard | Tree | DPW 1 | 12 | 6016287.8 | 2096690.3 | 37.7380265265677 | -122.386173192236 | (37.7380265265677, -122.386173192236) | 10 | 3 | 8 | 58 | 1 | ||||
141858 | 105326 | DPW Maintained 1 | Tree(s) :: 17 | 2051 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | Permit Number 771015 | 6015779.9 | 2106081.5 | 37.7637846705736 | -122.388584622631 | (37.7637846705736, -122.388584622631) | 14 | 3 | 8 | 28856 | 29 | |||
143544 | 29903 | DPW Maintained 1 | Tree(s) :: 17 | 750 San Jose Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6005639.13550214 | 2098758.44315121 | 37.7431100472957 | -122.423137910761 | (37.7431100472957, -122.423137910761) | 2 | 7 | 5 | 28859 | 22 | ||||||
144927 | 90657 | DPW Maintained 1 | Tree(s) :: 17 | 3450 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 12/07/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776853 | 5984933.736244 | 2110433.593284 | 37.7739765609982 | -122.495591517296 | (37.7739765609982, -122.495591517296) | 11 | 6 | 2 | 55 | 26 |
149005 | 106383 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 10 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
149527 | 874 | DPW Maintained 1 | Tree(s) :: 17 | 600X Alemany Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | 2 | 7 | 7 | 28861 | 2 | |||
149659 | 91774 | DPW Maintained 1 | Tree(s) :: 17 | 1200x Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6010069.453126 | 2109834.328197 | 37.7737709548765 | -122.40860015267 | (37.7737709548765, -122.40860015267) | 8 | 2 | 9 | 28853 | 34 | |
150050 | 873 | DPW Maintained 1 | Tree(s) :: 17 | 600X Alemany Blvd | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | 2 | 7 | 7 | 28861 | 2 | |||
150177 | 25576 | DPW Maintained 1 | Tree(s) :: 17 | 250 Industrial St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3X3 | 6010651.890723 | 2096938.1663788 | 37.7383935669237 | -122.405676875145 | (37.7383935669237, -122.405676875145) | 10 | 3 | 8 | 58 | 1 | |||
150652 | 106397 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 24 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
152657 | 203218 | DPW Maintained 1 | Tree(s) :: 17 | 865x Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5997430 | 2091537 | 37.7228150096033 | -122.451002133856 | (37.7228150096033, -122.451002133856) | 9 | 7 | 4 | 28861 | 24 | ||||
156690 | 106375 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 2 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
156782 | 12711 | Significant Tree 6 | Tree(s) :: 17 | 1449 Lake St | 3 | Front Yard : Cutout | Tree | DPW 1 | 06/01/2000 12:00:00 AM | 3 | 5990998.3321714 | 2114735.5234974 | 37.7861417388427 | -122.474927352046 | (37.7861417388427, -122.474927352046) | 11 | 6 | 2 | 54 | 26 | |||
160604 | 91775 | DPW Maintained 1 | Tree(s) :: 17 | 1200x Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6010069.453126 | 2109834.328197 | 37.7737709548765 | -122.40860015267 | (37.7737709548765, -122.40860015267) | 8 | 2 | 9 | 28853 | 34 | |
164914 | 87444 | DPW Maintained 1 | Tree(s) :: 17 | 2801X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 5997499.095645 | 2087961.159651 | 37.7130005371424 | -122.450505622879 | (37.7130005371424, -122.450505622879) | 9 | 7 | 6 | 28861 | 25 | ||
165385 | 87425 | - 12 | Tree(s) :: 17 | 25X Jones St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6009102.081359 | 2112621.960117 | 37.781370907497 | -122.412143510234 | (37.781370907497, -122.412143510234) | 7 | 10 | 9 | 28852 | 36 | |||
165729 | 863 | DPW Maintained 1 | Tree(s) :: 17 | 600X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | 2 | 7 | 7 | 28861 | 2 | |||
168696 | 107563 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 5 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | ||
170327 | 96144 | DPW Maintained 1 | Tree(s) :: 17 | 1484X Innes Ave | 1 | Median : Yard | Tree | DPW 1 | 12 | 6016157.8 | 2096794.1 | 37.7383043442369 | -122.386629906827 | (37.7383043442369, -122.386629906827) | 10 | 3 | 8 | 58 | 1 | ||||
170918 | 106396 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 23 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
171630 | 107936 | DPW Maintained 1 | Tree(s) :: 17 | 3098X Market St | 2 | Median : Yard | Tree | DPW 1 | 5999920 | 2105144 | 37.7603188321069 | -122.44337164916 | (37.7603188321069, -122.44337164916) | 2 | 4 | 5 | 28862 | 3 | |||||
173719 | 96140 | DPW Maintained 1 | Tree(s) :: 17 | 1460X Innes Ave | 2 | Median : Yard | Tree | DPW 1 | 12 | 6016261.2 | 2096710.2 | 37.7380796956477 | -122.386266549459 | (37.7380796956477, -122.386266549459) | 10 | 3 | 8 | 58 | 1 | ||||
176016 | 107544 | DPW Maintained 1 | Tree(s) :: 17 | 198X Jennings St | 5 | Front Yard : Yard | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.7393885572332 | -122.377570991407 | (37.7393885572332, -122.377570991407) | 10 | 3 | 8 | 58 | 1 | ||
177001 | 106385 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 12 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
177873 | 96128 | DPW Maintained 1 | Tree(s) :: 17 | 1420X Innes Ave | 1 | Median : Yard | Tree | DPW 1 | 12 | 6016441.6 | 2096581.1 | 37.7377351967413 | -122.385633815961 | (37.7377351967413, -122.385633815961) | 10 | 3 | 8 | 58 | 1 | ||||
178308 | 9009 | DPW Maintained 1 | Tree(s) :: 17 | 5255 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/27/2016 12:00:00 AM | 3 | 4X4 | Permit Number 777115 | 5990680.0267 | 2112634.9623 | 37.7803557304658 | -122.4758751346 | (37.7803557304658, -122.4758751346) | 11 | 6 | 2 | 54 | 26 | |
179371 | 106388 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 15 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
179752 | 10547 | DPW Maintained 1 | Tree(s) :: 17 | 187 Harbor Rd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/11/1995 12:00:00 AM | 6 | 3X4 | 6018418.3027239 | 2094690.3062519 | 37.7326526259914 | -122.378668074213 | (37.7326526259914, -122.378668074213) | 10 | 3 | 8 | 58 | 1 | ||
180086 | 107557 | DPW Maintained 1 | Tree(s) :: 17 | 1 Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726 | 2097063 | 37.73918453522 | -122.377768892846 | (37.73918453522, -122.377768892846) | 10 | 3 | 8 | 58 | 1 | |
181526 | 182864 | DPW Maintained 1 | Tree(s) :: 17 | 1674 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/2016 10:49:00 AM | 1 | Width 0ft | 5987818.6474 | 2103915.1987 | 37.7562473553988 | -122.485133888104 | (37.7562473553988, -122.485133888104) | 1 | 8 | 3 | 56 | 35 | ||
182068 | 871 | DPW Maintained 1 | Tree(s) :: 17 | 600X Alemany Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | 2 | 7 | 7 | 28861 | 2 | |||
182704 | 106378 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 5 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
182865 | 254272 | DPW Maintained 1 | Tree(s) :: 17 | 355 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005049 | 2110166 | 37.7743991919417 | -122.425990324694 | (37.7743991919417, -122.425990324694) | 7 | 9 | 11 | 28852 | 10 | ||||
183678 | 869 | DPW Maintained 1 | Tree(s) :: 17 | 600X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | 2 | 7 | 7 | 28861 | 2 | |||
185191 | 106391 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 18 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
186077 | 104457 | DPW Maintained 1 | Tree(s) :: 17 | 1601X Kansas St | 5 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 4 | 3x6 | 6011789.30586 | 2100707.09327 | 37.748805772054 | -122.402009105448 | (37.748805772054, -122.402009105448) | 10 | 3 | 8 | 58 | 1 | |||
187232 | 106398 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 25 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
187735 | 106390 | DPW Maintained 1 | Tree(s) :: 17 | 182x Lower Ter | 17 | Median : Cutout | Tree | DPW 1 | 10x10 | 6000081.12192 | 2106216.81045 | 37.7632736910742 | -122.442891445737 | (37.7632736910742, -122.442891445737) | 15 | 5 | 5 | 28862 | 3 | ||||
188056 | 27546 | DPW Maintained 1 | Tree(s) :: 17 | 1301X Illinois St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/10/1999 12:00:00 AM | 3 | 3X3 | 6016183.3939043 | 2103024.539071 | 37.7554132592376 | -122.386975829537 | (37.7554132592376, -122.386975829537) | 10 | 3 | 8 | 28856 | 29 | ||
188774 | 107889 | Permitted Site 7 | Tree(s) :: 17 | 941 Washington St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 11/03/2014 12:00:00 AM | 3 | Permit Number 771772 | 6010165.08902 | 2117347.11602 | 37.7944046419585 | -122.40879946772 | (37.7944046419585, -122.40879946772) | 3 | 1 | 10 | 28857 | 4 | |
193167 | 96143 | DPW Maintained 1 | Tree(s) :: 17 | 1470X Innes Ave | 1 | Median : Yard | Tree | DPW 1 | 12 | 6016219.9 | 2096747.5 | 37.738179827823 | -122.386411945382 | (37.738179827823, -122.386411945382) | 10 | 3 | 8 | 58 | 1 | ||||
193379 | 107543 | DPW Maintained 1 | Tree(s) :: 17 | 198X Jennings St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | Permit Number 774049 | 6018784.70414 | 2097136.12526 | 37.7393885572332 | -122.377570991407 | (37.7393885572332, -122.377570991407) | 10 | 3 | 8 | 58 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );