trees
256 rows where qSpecies_id = 151 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
51718 | 43139 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1 Gambier St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2000 12:00:00 AM | 4 | Permit Number 42953 | 6005713.11166 | 2093478.24293 | 37.7286159697368 | -122.422507005398 | (37.7286159697368, -122.422507005398) | 9 | 7 | 7 | 309 | 5 | ||
96848 | 43137 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1 Gambier St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/11/2000 12:00:00 AM | 7 | Permit Number 42953 | 6005718.46144 | 2093462.75751 | 37.728573751977 | -122.422487410986 | (37.728573751977, -122.422487410986) | 9 | 7 | 7 | 309 | 5 | |
165181 | 43138 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1 Gambier St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2000 12:00:00 AM | 4 | Permit Number 42953 | 6005709.81909 | 2093489.20943 | 37.7286458955884 | -122.422519166951 | (37.7286458955884, -122.422519166951) | 9 | 7 | 7 | 309 | 5 | ||
106884 | 177525 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 100 Yale St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006897.82744 | 2093555.37403 | 37.7288945185586 | -122.418416832071 | (37.7288945185586, -122.418416832071) | 9 | 3 | 7 | 309 | 5 | |||
163588 | 63364 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 103 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/1992 12:00:00 AM | Permit Number 30639 | 6006732.73114879 | 2096957.82345997 | 37.7382276012884 | -122.419228840922 | (37.7382276012884, -122.419228840922) | 2 | 7 | 7 | 28859 | 2 | ||
79837 | 65256 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1059 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28055 | 6009469.52961682 | 2103013.30669194 | 37.7550083744364 | -122.410193718367 | (37.7550083744364, -122.410193718367) | 2 | 4 | 7 | 28859 | 19 | ||
159201 | 231947 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1101 San Jose Ave | 64 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 8ft | 6005025.65555 | 2096592.3987 | 37.7371279405099 | -122.425105073942 | (37.7371279405099, -122.425105073942) | 2 | 7 | 5 | 28859 | 2 | |||
168760 | 62861 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 112 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1993 12:00:00 AM | Permit Number 31839 | 6008289.1101765 | 2098063.77851113 | 37.7413518401577 | -122.413925848755 | (37.7413518401577, -122.413925848755) | 2 | 7 | 7 | 28859 | 2 | ||
144291 | 66433 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 118 Highland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/1991 12:00:00 AM | Permit Number 29576 | 6005529.27345058 | 2096644.50573799 | 37.7372994514328 | -122.423367539465 | (37.7372994514328, -122.423367539465) | 2 | 7 | 7 | 28859 | 2 | ||
9879 | 63777 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 118 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24458 | 6004354.0616299 | 2101637.06942721 | 37.7509414857928 | -122.427786417218 | (37.7509414857928, -122.427786417218) | 2 | 4 | 5 | 28862 | 22 | ||
111329 | 67925 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 118 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31638 | 6003735.12063535 | 2095135.9515003 | 37.7330558796375 | -122.42946320321 | (37.7330558796375, -122.42946320321) | 9 | 7 | 5 | 28861 | 25 | ||
18660 | 264656 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1199 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/08/2020 04:53:00 PM | 3x3 | |||||||||||||
129396 | 64627 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 120 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/15/1988 12:00:00 AM | Permit Number 25536 | 6005377.18111658 | 2103001.16489201 | 37.7547447992353 | -122.424345378751 | (37.7547447992353, -122.424345378751) | 2 | 4 | 5 | 28859 | 19 | ||
152389 | 231973 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 120 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | Width 3ft | 6004325.56331 | 2101629.44898 | 37.7509189496627 | -122.427884424232 | (37.7509189496627, -122.427884424232) | 2 | 4 | 5 | 28862 | 22 | |||
29959 | 45335 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1239 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2001 12:00:00 AM | Permit Number 44167 | 6013665.22038022 | 2106606.66789645 | 37.7651092465016 | -122.39593550872 | (37.7651092465016, -122.39593550872) | 14 | 3 | 8 | 28856 | 29 | ||
146059 | 67909 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 124 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32837 | 5999245.55939042 | 2093517.24429142 | 37.7283560753919 | -122.444868429871 | (37.7283560753919, -122.444868429871) | 9 | 7 | 4 | 28861 | 40 | ||
22799 | 101714 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1240 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6006918 | 2119116 | 37.7990791449181 | -122.420160405591 | (37.7990791449181, -122.420160405591) | 5 | 1 | 1 | 28858 | 32 | |||||
9740 | 75309 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 125 Excelsior Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6002784.56496 | 2092514.51527 | 37.7258041440316 | -122.432562342276 | (37.7258041440316, -122.432562342276) | 9 | 7 | 6 | 28861 | 5 | ||
115516 | 69060 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1254 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/10/1994 12:00:00 AM | Permit Number 33068 | 5992404.85704232 | 2106915.96776858 | 37.7647527637413 | -122.4694917724 | (37.7647527637413, -122.4694917724) | 11 | 8 | 11 | 56 | 12 | ||
106252 | 68686 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 128 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | Permit Number 32596 | 5992134.97207697 | 2114599.88023196 | 37.7858351044588 | -122.470985030783 | (37.7858351044588, -122.470985030783) | 11 | 6 | 2 | 54 | 11 | ||
89977 | 56611 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 131 Chaves Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/01/1992 12:00:00 AM | Permit Number 30977 | 5996730.28293802 | 2098448.69823617 | 37.7417527884603 | -122.453919799435 | (37.7417527884603, -122.453919799435) | 9 | 7 | 4 | 59 | 40 | ||
103700 | 66325 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 131 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | Permit Number 29444 | 6000554.87735499 | 2095194.20587313 | 37.7330352599042 | -122.440462292733 | (37.7330352599042, -122.440462292733) | 9 | 7 | 5 | 63 | 40 | ||
98615 | 46679 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1310 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/2002 12:00:00 AM | Permit Number 44809 | 5990528.41168502 | 2106454.94562806 | 37.76337829801 | -122.475948167358 | (37.76337829801, -122.475948167358) | 1 | 8 | 3 | 56 | 12 | ||
67134 | 69042 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1315 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | Permit Number 33049 | 5983966.84504954 | 2106204.15933041 | 37.7623070738116 | -122.498623613567 | (37.7623070738116, -122.498623613567) | 1 | 8 | 3 | 56 | 35 | ||
34670 | 66326 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 135 Mangels Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1990 12:00:00 AM | Permit Number 29445 | 6000528.81306712 | 2095194.53475792 | 37.7330346787859 | -122.440552427184 | (37.7330346787859, -122.440552427184) | 9 | 7 | 5 | 63 | 40 | ||
87351 | 67921 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 136 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31632 | 6004231.25027354 | 2095231.88967626 | 37.7333473817874 | -122.427754784883 | (37.7333473817874, -122.427754784883) | 9 | 7 | 5 | 28861 | 25 | ||
188557 | 231955 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 136 Marsily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004248.08815 | 2095120.37618 | 37.7330421432752 | -122.42768862922 | (37.7330421432752, -122.42768862922) | 9 | 7 | 5 | 28861 | 25 | |||
137787 | 104161 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 138 ALPINE TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2013 12:00:00 AM | 12 | 3x3 | Permit Number 770750 | 6001664 | 2107990 | 37.7682325491861 | -122.437543793089 | (37.7682325491861, -122.437543793089) | 15 | 5 | 5 | 29492 | 3 | |
74527 | 231974 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 138 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6004099.54085 | 2102284.63466 | 37.7527051471301 | -122.428712732201 | (37.7527051471301, -122.428712732201) | 2 | 4 | 5 | 28862 | 22 | |||
131792 | 67823 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 138 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31479 | 6004089.22123214 | 2102351.15512092 | 37.7528872126598 | -122.428753160983 | (37.7528872126598, -122.428753160983) | 2 | 4 | 5 | 28862 | 22 | ||
153381 | 45327 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1385 Holloway Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2001 12:00:00 AM | Permit Number 44161 | 5991450.97971793 | 2091205.24216012 | 37.7215599710698 | -122.471645977425 | (37.7215599710698, -122.471645977425) | 9 | 8 | 6 | 64 | 24 | |||
168262 | 45325 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1385 Holloway Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2001 12:00:00 AM | Permit Number 44161 | 5991450.97971793 | 2091205.24216012 | 37.7215599710698 | -122.471645977425 | (37.7215599710698, -122.471645977425) | 9 | 8 | 6 | 64 | 24 | |||
173866 | 45326 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1385 Holloway Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2001 12:00:00 AM | Permit Number 44161 | 5991450.97971793 | 2091205.24216012 | 37.7215599710698 | -122.471645977425 | (37.7215599710698, -122.471645977425) | 9 | 8 | 6 | 64 | 24 | |||
18761 | 56456 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 141 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1992 12:00:00 AM | Permit Number 30464 | 5999359.80887308 | 2107414.28954328 | 37.7665205189943 | -122.445472331181 | (37.7665205189943, -122.445472331181) | 15 | 5 | 5 | 29492 | 9 | ||
48209 | 209293 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1416 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993991.03354 | 2105859.32276 | 37.7619430335757 | -122.463928938879 | (37.7619430335757, -122.463928938879) | 1 | 5 | 11 | 56 | 12 | |||
45942 | 67106 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1422 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1992 12:00:00 AM | Permit Number 30521 | 5994302.05947846 | 2105826.4023092 | 37.7618705618217 | -122.462850841683 | (37.7618705618217, -122.462850841683) | 1 | 5 | 11 | 56 | 12 | ||
53276 | 37921 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1433 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2002 12:00:00 AM | Permit Number 44597 | 6013051.43972244 | 2106572.53658415 | 37.7649813631667 | -122.398056045773 | (37.7649813631667, -122.398056045773) | 14 | 3 | 8 | 28856 | 29 | ||
19917 | 209292 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1466 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993385.70012 | 2105501.91756 | 37.7609267888564 | -122.465996561219 | (37.7609267888564, -122.465996561219) | 1 | 8 | 11 | 56 | 12 | |||
192102 | 37860 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 147 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/07/1998 12:00:00 AM | 13 | 6x8 | Permit Number 40147 | 6003940.89934 | 2092950.10622 | 37.7270656869264 | -122.428596014613 | (37.7270656869264, -122.428596014613) | 9 | 7 | 6 | 28861 | 5 |
1406 | 75132 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 148X Paris St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 6 | 3x3 | 6002992.10347 | 2092540.72564 | 37.7258878789975 | -122.431846767938 | (37.7258878789975, -122.431846767938) | 9 | 7 | 6 | 28861 | 5 | ||
84836 | 66660 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1500 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/05/1992 12:00:00 AM | 3x3 | Permit Number 31265 | 6016229.06481316 | 2097072.60827917 | 37.7390730165912 | -122.386402918839 | (37.7390730165912, -122.386402918839) | 10 | 3 | 8 | 58 | 1 | |
84565 | 177524 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 151 London St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002754.06698 | 2092583.57784 | 37.725992044773 | -122.432672702599 | (37.725992044773, -122.432672702599) | 9 | 7 | 6 | 28861 | 5 | |||
114407 | 68863 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 152 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32826 | 5999067.96340072 | 2093519.65088656 | 37.7283525462917 | -122.445482558018 | (37.7283525462917, -122.445482558018) | 9 | 7 | 4 | 28861 | 40 | ||
62954 | 103530 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 155 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x9 | 5993328.74433 | 2114475.40992 | 37.7855623136611 | -122.466845895101 | (37.7855623136611, -122.466845895101) | 11 | 6 | 2 | 54 | 11 | |||
168878 | 60177 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 16 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/1982 12:00:00 AM | Permit Number 19709 | 6005786.70456433 | 2105990.31461515 | 37.7629754214805 | -122.423141591085 | (37.7629754214805, -122.423141591085) | 8 | 4 | 5 | 28859 | 19 | ||
1945 | 44489 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 16 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2001 12:00:00 AM | 8 | Permit Number 43794 | 6005364.27294 | 2093438.07689 | 37.7284859970226 | -122.423710107629 | (37.7284859970226, -122.423710107629) | 9 | 7 | 6 | 28861 | 5 | |
137851 | 66928 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 160 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1991 12:00:00 AM | Permit Number 30250 | 6007554.42782644 | 2097919.72536023 | 37.7409150133245 | -122.416455928807 | (37.7409150133245, -122.416455928807) | 2 | 7 | 7 | 28859 | 2 | ||
22053 | 49821 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 7 | Permit Number 46611 | 6012834.79813 | 2105677.969 | 37.7625130103804 | -122.398742575008 | (37.7625130103804, -122.398742575008) | 14 | 3 | 8 | 28856 | 29 | ||
27044 | 49828 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 7 | Permit Number 46611 | 6012702.02381 | 2105670.26876 | 37.7624844685969 | -122.399201255332 | (37.7624844685969, -122.399201255332) | 14 | 3 | 8 | 28856 | 29 | ||
61575 | 49822 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 7 | Permit Number 46611 | 6012816.10881 | 2105676.13284 | 37.7625069273679 | -122.398807086097 | (37.7625069273679, -122.398807086097) | 14 | 3 | 8 | 28856 | 29 | ||
135882 | 49824 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 5 | Permit Number 46611 | 6012781.37184 | 2105676.15617 | 37.7625050558738 | -122.398927231008 | (37.7625050558738, -122.398927231008) | 14 | 3 | 8 | 28856 | 29 | ||
157444 | 49819 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 6 | Permit Number 46611 | 6012718.30127 | 2105671.30189 | 37.7624882124737 | -122.39914502972 | (37.7624882124737, -122.39914502972) | 14 | 3 | 8 | 28856 | 29 | ||
164137 | 49823 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 6 | Permit Number 46611 | 6012798.82942 | 2105676.31317 | 37.7625064597174 | -122.398866862242 | (37.7625064597174, -122.398866862242) | 14 | 3 | 8 | 28856 | 29 | ||
179331 | 49825 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X 18th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2003 12:00:00 AM | 5 | Permit Number 46611 | 6012763.71929 | 2105674.81061 | 37.7625003776121 | -122.398988190679 | (37.7625003776121, -122.398988190679) | 14 | 3 | 8 | 28856 | 29 | ||
110307 | 42646 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X GREEN ST | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/26/2000 12:00:00 AM | 10 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
166834 | 42645 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1600X GREEN ST | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 06/26/2000 12:00:00 AM | 6 | 3x3 | 6005364 | 2118556 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | 13 | 9 | 1 | 57 | 17 | |
32169 | 231956 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 162 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6004841.81484 | 2095922.14472 | 37.7352771869788 | -122.425693003951 | (37.7352771869788, -122.425693003951) | 2 | 7 | 5 | 28861 | 2 | |||
131393 | 64147 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1620 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/05/1987 12:00:00 AM | Permit Number 24926 | 6003320.75004876 | 2098798.13825464 | 37.7430879358174 | -122.431157094729 | (37.7430879358174, -122.431157094729) | 2 | 7 | 5 | 63 | 22 | ||
171045 | 68055 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1635 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/23/1993 12:00:00 AM | Permit Number 31792 | 5993371.17911644 | 2104355.17278609 | 37.7577772885613 | -122.4659634545 | (37.7577772885613, -122.4659634545) | 1 | 8 | 4 | 56 | 12 | ||
97377 | 77990 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 163X London St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 04/01/2000 12:00:00 AM | 8 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
163496 | 77992 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 163X London St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 04/01/2000 12:00:00 AM | 16 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
174822 | 75386 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 163X London St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/1992 12:00:00 AM | 10 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
149721 | 34268 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 166 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/14/1997 12:00:00 AM | 3 | Permit Number 38071 | 5987436.71132 | 2114846.84684 | 37.7862403554066 | -122.487257635976 | (37.7862403554066, -122.487257635976) | 11 | 6 | 1 | 55 | 33 | |
159388 | 66895 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 168 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1991 12:00:00 AM | Permit Number 30213 | 6007551.53091374 | 2097886.23194596 | 37.7408228849183 | -122.4164635734 | (37.7408228849183, -122.4164635734) | 2 | 7 | 7 | 28859 | 2 | ||
178401 | 64628 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 170 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/1988 12:00:00 AM | Permit Number 25537 | 6005392.70908858 | 2102720.91068508 | 37.7539761631805 | -122.424271747549 | (37.7539761631805, -122.424271747549) | 2 | 4 | 5 | 28859 | 19 | ||
20236 | 131192 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1700 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6005755.68073 | 2116051.93764 | 37.7906004431923 | -122.423964421545 | (37.7906004431923, -122.423964421545) | 13 | 9 | 1 | 28858 | 27 | |||
49220 | 7946 | Landmark tree 11 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1701 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6005703.15328 | 2116043.32965 | 37.7905738421571 | -122.424145551273 | (37.7905738421571, -122.424145551273) | 13 | 9 | 1 | 28858 | 27 | |||
178945 | 231951 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 171 Lexington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006481.13342 | 2105135.05865 | 37.7606662525548 | -122.42067907849 | (37.7606662525548, -122.42067907849) | 2 | 4 | 7 | 28859 | 19 | |||
30115 | 46922 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 174 Granville Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44977 | 5994451.42522147 | 2098637.59383586 | 37.7421405253127 | -122.461812970424 | (37.7421405253127, -122.461812970424) | 1 | 8 | 4 | 59 | 40 | |||
135210 | 46920 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 174 Granville Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2002 12:00:00 AM | Permit Number 44977 | 5994451.42522147 | 2098637.59383586 | 37.7421405253127 | -122.461812970424 | (37.7421405253127, -122.461812970424) | 1 | 8 | 4 | 59 | 40 | |||
186568 | 46921 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 174 Granville Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/01/2002 12:00:00 AM | Permit Number 44977 | 5994451.42522147 | 2098637.59383586 | 37.7421405253127 | -122.461812970424 | (37.7421405253127, -122.461812970424) | 1 | 8 | 4 | 59 | 40 | ||
22314 | 231968 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 177 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6004880.9264 | 2095958.67753 | 37.735379707894 | -122.425560380023 | (37.735379707894, -122.425560380023) | 2 | 7 | 5 | 28861 | 2 | |||
188615 | 68833 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 178 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32784 | 5999570.75659197 | 2094098.77581282 | 37.7299713792854 | -122.443785974037 | (37.7299713792854, -122.443785974037) | 9 | 7 | 4 | 63 | 40 | ||
166925 | 62359 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 183 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1992 12:00:00 AM | Permit Number 31493 | 6004713.1576588 | 2099557.75082014 | 37.7452524642677 | -122.426396594795 | (37.7452524642677, -122.426396594795) | 2 | 7 | 5 | 63 | 22 | ||
82588 | 66076 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1830 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1990 12:00:00 AM | Permit Number 29120 | 6008716.78878742 | 2119192.91553026 | 37.7993915237126 | -122.413941412032 | (37.7993915237126, -122.413941412032) | 3 | 1 | 10 | 308 | 32 | ||
106979 | 231966 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 189 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007085.27173 | 2097974.9068 | 37.7410401344022 | -122.418082011786 | (37.7410401344022, -122.418082011786) | 2 | 7 | 7 | 28859 | 2 | |||
141071 | 60176 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 19 Dearborn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/28/1982 12:00:00 AM | Permit Number 19708 | 6005839.66943051 | 2105974.33981931 | 37.7629345472543 | -122.422957268124 | (37.7629345472543, -122.422957268124) | 8 | 4 | 5 | 28859 | 19 | ||
47147 | 68648 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1935 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/21/1993 12:00:00 AM | Permit Number 32553 | 5990620.64023794 | 2102219.83857431 | 37.7517551651121 | -122.475319963854 | (37.7517551651121, -122.475319963854) | 1 | 8 | 4 | 29491 | 12 | ||
135642 | 51700 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1935 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2005 12:00:00 AM | Permit Number 47976 | 5989632.50224537 | 2110558.09504806 | 37.7745924384823 | -122.479346986422 | (37.7745924384823, -122.479346986422) | 11 | 6 | 2 | 55 | 26 | ||
168613 | 25930 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1940 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2008 12:00:00 AM | 12 | 3x3 | 6013172.33562 | 2096908.97422 | 37.7384540331375 | -122.396960298598 | (37.7384540331375, -122.396960298598) | 10 | 3 | 8 | 58 | 1 | ||
106210 | 231953 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 195 Lexington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006489.5205 | 2105029.86683 | 37.7603778930513 | -122.420642603769 | (37.7603778930513, -122.420642603769) | 2 | 4 | 7 | 28859 | 19 | |||
177128 | 231952 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 195 Lexington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006488.33791 | 2105047.80636 | 37.7604270841668 | -122.420647967328 | (37.7604270841668, -122.420647967328) | 2 | 4 | 7 | 28859 | 19 | |||
6623 | 42595 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1950 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 5 | Permit Number 42667 | 6005494.51102 | 2116553.24353 | 37.7919621552701 | -122.424903735525 | (37.7919621552701, -122.424903735525) | 13 | 9 | 1 | 28858 | 27 | |
28039 | 42596 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1950 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 11 | 3x3 | Permit Number 42667 | 6005477.78345 | 2116550.81967 | 37.7919545551073 | -122.424961440544 | (37.7919545551073, -122.424961440544) | 13 | 9 | 1 | 28858 | 27 | |
71484 | 66923 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 196 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1991 12:00:00 AM | Permit Number 30244 | 6007541.39171999 | 2097769.00500385 | 37.740500435503 | -122.416490329324 | (37.740500435503, -122.416490329324) | 2 | 7 | 7 | 28859 | 2 | ||
154741 | 42598 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1961 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 14 | Permit Number 42668 | 6005388.01706 | 2116488.54152 | 37.7917784840479 | -122.425267599417 | (37.7917784840479, -122.425267599417) | 13 | 9 | 1 | 28858 | 27 | |
43632 | 48013 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 1991 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2002 12:00:00 AM | Permit Number 45735 | 5991253.49588687 | 2101875.72214117 | 37.7508469733877 | -122.473106392758 | (37.7508469733877, -122.473106392758) | 1 | 8 | 4 | 29491 | 12 | ||
151858 | 231977 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 20 Ford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003286.06563 | 2105669.78053 | 37.7619538776004 | -122.431767549352 | (37.7619538776004, -122.431767549352) | 15 | 4 | 5 | 28862 | 3 | |||
85647 | 193531 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 200 Jennings St | 4 | : | Tree | Private 2 | 3 | Width 3ft | 6018621.46299 | 2096962.90365 | 37.7389039297614 | -122.378123392174 | (37.7389039297614, -122.378123392174) | 10 | 3 | 8 | 58 | 1 | |||
174781 | 193532 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 200 Jennings St | 7 | : | Tree | Private 2 | 2 | Width 3ft | 6018580.21539 | 2096908.74747 | 37.7387529542923 | -122.378262250201 | (37.7387529542923, -122.378262250201) | 10 | 3 | 8 | 58 | 1 | |||
67640 | 66893 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 201 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1991 12:00:00 AM | Permit Number 30211 | 6007590.04442076 | 2097728.05974103 | 37.7403907448612 | -122.416319207408 | (37.7403907448612, -122.416319207408) | 2 | 7 | 7 | 28859 | 2 | ||
83403 | 9925 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2010 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2008 12:00:00 AM | 12 | 3x3 | 6005193.66561 | 2116589.42028 | 37.7920444900059 | -122.425947239584 | (37.7920444900059, -122.425947239584) | 13 | 9 | 1 | 28858 | 27 | ||
32738 | 66930 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 206 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1991 12:00:00 AM | Permit Number 30252 | 6007535.74955777 | 2097703.77171349 | 37.7403210020284 | -122.41650521811 | (37.7403210020284, -122.41650521811) | 2 | 7 | 7 | 28859 | 2 | ||
45505 | 231972 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 206 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003745.92075 | 2101014.04618 | 37.7491963890986 | -122.429844992161 | (37.7491963890986, -122.429844992161) | 2 | 4 | 5 | 28862 | 22 | |||
14893 | 69004 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2079 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | 0 | 3x3 | Permit Number 33005 | 5982592.52058918 | 2100976.42518266 | 37.7478724914068 | -122.502989774605 | (37.7478724914068, -122.502989774605) | 1 | 8 | 3 | 29491 | 35 |
85201 | 68664 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 211 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | Permit Number 32571 | 5993343.03467885 | 2114079.66644038 | 37.7844765349697 | -122.46676767712 | (37.7844765349697, -122.46676767712) | 11 | 6 | 2 | 54 | 11 | ||
26041 | 87359 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2127 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53579 | 6012075.86217 | 2102321.0716 | 37.7532533954437 | -122.401131582655 | (37.7532533954437, -122.401131582655) | 10 | 3 | 8 | 28856 | 29 | |
135798 | 231954 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 215 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 3ft | 6006180.99637 | 2101867.22963 | 37.751676631191 | -122.421485034734 | (37.751676631191, -122.421485034734) | 2 | 4 | 5 | 28859 | 19 | |||
177080 | 66906 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 219 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/06/1991 12:00:00 AM | 20 | 2x5 | Permit Number 30224 | 6007582.57957611 | 2097641.75307421 | 37.7401533460797 | -122.416338906472 | (37.7401533460797, -122.416338906472) | 2 | 7 | 7 | 28859 | 2 |
185697 | 69014 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 2190 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1994 12:00:00 AM | 0 | Permit Number 33018 | 5982359.98589934 | 2100209.73898476 | 37.7457537141944 | -122.503737083774 | (37.7457537141944, -122.503737083774) | 1 | 8 | 3 | 29491 | 35 |
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) );