443 rows where qSpecies_id = 32 sorted by XCoord

View and edit SQL

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)
13031 261121 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 80 Vesta St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2019 12:00:00 AM 3 5x5                      
18435 261120 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2901 Jennings St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2019 12:00:00 AM 3 5x5                      
126321 118491 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 8245 Geary Blvd 10 Sidewalk: Curb side : Yard Tree Private 2     2     5981413.14873 2112317.48344 37.7789423808296 -122.507909444403 (37.7789423808296, -122.507909444403) 11 6 2 55 26
69127 120436 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 235 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5988981.18981 2113759.01569 37.7833434210971 -122.481834493116 (37.7833434210971, -122.481834493116) 11 6 2 55 26
132142 100385 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1800 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/09/2012 12:00:00 AM   3x3 Permit Number 769433 5990171 2106556 37.7636350362567 -122.477191710239 (37.7636350362567, -122.477191710239) 1 8 3 56 35
4051 260659 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2 Varela Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x6   5990178.30137 2091110.96603 37.7212273981358 -122.476038353928 (37.7212273981358, -122.476038353928) 1 8 4 64 14
8550 260661 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2 Varela Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x6   5990178.30137 2091110.96603 37.7212273981358 -122.476038353928 (37.7212273981358, -122.476038353928) 1 8 4 64 14
9356 260660 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2 Varela Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x6   5990178.30137 2091110.96603 37.7212273981358 -122.476038353928 (37.7212273981358, -122.476038353928) 1 8 4 64 14
17511 260658 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2 Varela Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x6   5990178.30137 2091110.96603 37.7212273981358 -122.476038353928 (37.7212273981358, -122.476038353928) 1 8 4 64 14
18441 260662 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2 Varela Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x6   5990178.30137 2091110.96603 37.7212273981358 -122.476038353928 (37.7212273981358, -122.476038353928) 1 8 4 64 14
126685 211312 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2331 12th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5992605.95071 2099584.48851 37.7446340456409 -122.468262856351 (37.7446340456409, -122.468262856351) 1 8 4 29491 40
13269 211313 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2331 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5992606.24128 2099598.30232 37.7446719916245 -122.468262856359 (37.7446719916245, -122.468262856359) 1 8 4 29491 40
58134 38018 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 26 Forest Side Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1998 12:00:00 AM     Permit Number 40229 5992654.87509513 2098962.67617423 37.7429295327147 -122.46804846503 (37.7429295327147, -122.46804846503) 1 8 4 29491 40
141605 38019 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 26 Forest Side Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1998 12:00:00 AM     Permit Number 40229 5992654.87509513 2098962.67617423 37.7429295327147 -122.46804846503 (37.7429295327147, -122.46804846503) 1 8 4 29491 40
12761 261857 Private 9 Pistacia chinensis :: Chinese Pistache 32 176 Ramsell St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/2020 12:00:00 AM 3     5992988.80812 2088380.73889 37.7138934199028 -122.466125014283 (37.7138934199028, -122.466125014283) 9 8 6 64 24
184152 63700 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 1530 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53921 5993398.86039614 2105062.95124939 37.7597222610505 -122.465919149256 (37.7597222610505, -122.465919149256) 1 8 4 56 12
149706 89031 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 1536 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53922 5993414.1 2105027.2 37.7596249765547 -122.465863845757 (37.7596249765547, -122.465863845757) 1 8 4 56 12
51549 123985 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 15 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5993608.31847 2115347.64983 37.7879733773019 -122.465942059673 (37.7879733773019, -122.465942059673) 11 6 1 54 11
25550 211315 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1950 08th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   5993849.45223 2102159.58974 37.7517763614982 -122.464150012924 (37.7517763614982, -122.464150012924) 1 8 4 29491 12
2706 211314 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1950 08th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   5993864.84081 2102208.58731 37.7519117832189 -122.464100354143 (37.7519117832189, -122.464100354143) 1 8 4 29491 12
16610 211317 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 45 Linares Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   5993928.12229 2102221.55917 37.7519510476114 -122.463882461023 (37.7519510476114, -122.463882461023) 1 8 4 29491 12
98544 211316 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 45 Linares Ave 3 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   5993952.85587 2102199.15235 37.7518909495221 -122.463795303226 (37.7518909495221, -122.463795303226) 1 8 4 29491 40
6458 211310 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1645 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5993991.2178 2104316.50873 37.7577068768914 -122.46381631408 (37.7577068768914, -122.46381631408) 1 5 4 56 12
30327 34199 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 200 Granville Way 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/13/1997 12:00:00 AM     Permit Number 38018 5994287.68885518 2098749.96127524 37.7424396309737 -122.462387263533 (37.7424396309737, -122.462387263533) 1 8 4 59 40
191498 211311 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 652 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5995443.13465 2089926.39084 37.7182787106718 -122.457753775529 (37.7182787106718, -122.457753775529) 9 8 6 28861 24
144217 104308 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 652 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2013 12:00:00 AM   3x3 Permit Number 770798 5995451.6 2089938.7 37.7183129950309 -122.457725404768 (37.7183129950309, -122.457725404768) 9 8 6 28861 24
19607 163461 Section 806 (d) 5 Pistacia chinensis :: Chinese Pistache 32 115 Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2020 12:00:00 AM 3 3x3 Permit Number 774886 5995870.30801 2087623.97935 37.7119813591246 -122.456110856234 (37.7119813591246, -122.456110856234) 9 8 6 28861 24
17374 163460 Section 806 (d) 5 Pistacia chinensis :: Chinese Pistache 32 115 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2020 12:00:00 AM 3 3x3 Permit Number 774886 5995870.33981 2087649.24929 37.7120507463226 -122.45611257216 (37.7120507463226, -122.45611257216) 9 8 6 28861 24
10091 163462 Section 806 (d) 5 Pistacia chinensis :: Chinese Pistache 32 115 Plymouth Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2020 12:00:00 AM 3 3x3 Permit Number 774886 5995871.2375 2087597.30845 37.7119081803938 -122.45610571662 (37.7119081803938, -122.45610571662) 9 8 6 28861 24
9475 163463 Section 806 (d) 5 Pistacia chinensis :: Chinese Pistache 32 109 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/24/2020 12:00:00 AM 3 3x3 Permit Number 774886 5995872.36784 2087580.2575 37.7118614273349 -122.456100577893 (37.7118614273349, -122.456100577893) 9 8 6 28861 24
106410 57835 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 254 Edgewood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/30/1977 12:00:00 AM 30 3x10 Permit Number 16776 5996589.21937103 2105630.13222731 37.7614631235225 -122.4549263227 (37.7614631235225, -122.4549263227) 15 5 11 29492 12
2889 211318 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 355 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5997726.4515 2093787.92348 37.7290124835257 -122.450139532341 (37.7290124835257, -122.450139532341) 9 7 4 28861 40
165119 178355 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2 Moneta Ct 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 1ft   5997930.01019 2088108.42362 37.7134295446025 -122.449026847907 (37.7134295446025, -122.449026847907) 9 7 6 28861 25
73390 14514 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 507 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   5999077.3967 2111056.5759 37.7765051848822 -122.446711235239 (37.7765051848822, -122.446711235239) 15 5 2 29492 16
23719 132215 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2860 Filbert St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5999237.1134 2118402.93591 37.7966854900001 -122.446687431602 (37.7966854900001, -122.446687431602) 13 9 1 57 17
131234 132216 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2860 Filbert St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5999249.48209 2118404.06668 37.7966893013211 -122.446644714701 (37.7966893013211, -122.446644714701) 13 9 1 57 17
14931 132217 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2860 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5999261.04653 2118404.81755 37.7966920235835 -122.446604753326 (37.7966920235835, -122.446604753326) 13 9 1 57 17
163748 132218 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2860 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5999271.44145 2118406.78235 37.796698012158 -122.446568926118 (37.796698012158, -122.446568926118) 13 9 1 57 17
19222 22826 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 84 Turquoise Way 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2015 02:48:00 PM 3 3x3   5999343.3761 2099052.93009 37.743561341476 -122.444928046502 (37.743561341476, -122.444928046502) 2 7 5 63 7
61436 54918 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2836 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/16/1972 12:00:00 AM 9   Permit Number 10785 5999351.3134 2118417.61273 37.7967323114142 -122.446293331595 (37.7967323114142, -122.446293331595) 13 9 1 57 17
39346 50453 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2645 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/21/2003 12:00:00 AM 5   Permit Number 47099 5999591.19502 2117968.49826 37.7955128594886 -122.445430979754 (37.7955128594886, -122.445430979754) 13 9 1 57 17
14763 97267 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2050X Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2012 12:00:00 AM 2 3x3 Permit Number 769192 5999912.27224 2116008.29642 37.7901489853223 -122.444179075813 (37.7901489853223, -122.444179075813) 13 6 1 29490 27
96009 132214 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2678 Union St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6000146.66842 2118183.0353 37.7961336156155 -122.443524371168 (37.7961336156155, -122.443524371168) 13 9 1 57 17
69752 132213 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2678 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6000167.6867 2118186.05064 37.7961430935947 -122.443451860639 (37.7961430935947, -122.443451860639) 13 9 1 57 17
82766 62895 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2678 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/25/1986 12:00:00 AM 7   Permit Number 23269 6000188.22889 2118188.91865 37.7961521398507 -122.443380986865 (37.7961521398507, -122.443380986865) 13 9 1 57 17
1087 233496 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 60 Yukon St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6000227.44313 2104506.90628 37.7585870568739 -122.442262614226 (37.7585870568739, -122.442262614226) 2 4 5 28862 3
98646 233497 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 60 Yukon St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6000229.80091 2104520.72602 37.7586251368655 -122.442255452052 (37.7586251368655, -122.442255452052) 2 4 5 28862 3
4937 132212 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2654 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6000265.26964 2118199.18789 37.7961847294893 -122.443115149071 (37.7961847294893, -122.443115149071) 13 9 1 57 17
82188 32003 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2648 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/13/1995 12:00:00 AM 7   Permit Number 35399 6000296.93169 2118203.44965 37.7961982364164 -122.4430058985 (37.7961982364164, -122.4430058985) 13 9 1 57 17
2751 32002 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2652 Union St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/13/1995 12:00:00 AM   5x5 Permit Number 35399 6000302.11365106 2118206.59769697 37.7962071755692 -122.442988194102 (37.7962071755692, -122.442988194102) 13 9 1 57 17
113333 32004 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2648 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/13/1995 12:00:00 AM 4   Permit Number 35399 6000314.48806 2118206.69354 37.7962081442408 -122.44294538314 (37.7962081442408, -122.44294538314) 13 9 1 57 17
84326 233436 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 73 Fountain St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6000375.83482 2101284.56019 37.7497477337837 -122.441518177039 (37.7497477337837, -122.441518177039) 2 4 5 28862 22
182963 109449 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 73 Fountain St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/18/2015 12:00:00 AM 3 3x3 Permit Number 773467 6000399 2101283.9 37.7497472407948 -122.441438023758 (37.7497472407948, -122.441438023758) 2 4 5 28862 22
178420 55550 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 101 Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/12/2008 12:00:00 AM   3x3 Permit Number 50802 6000558.4706929 2104874.62393167 37.759615580312 -122.441144156399 (37.759615580312, -122.441144156399) 2 4 5 28862 3
42619 233498 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 101 Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6000562.67168 2104881.27171 37.7596340727711 -122.441130104275 (37.7596340727711, -122.441130104275) 2 4 5 28862 3
160348 117434 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 71 Santa Ynez Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/14/2016 12:00:00 AM 3   Permit Number 775886 6000675.58728 2092024.5104 37.7243388786085 -122.439817790169 (37.7243388786085, -122.439817790169) 9 7 6 28861 25
6345 175597 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 650 London St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 3 Width 2ft   6001092.21629 2090034.68248 37.7188989677059 -122.438235084102 (37.7188989677059, -122.438235084102) 9 7 6 28861 5
42988 233501 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 6 Park Hill Ave 5 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   6001141.15752 2107828.11381 37.7677583098187 -122.439340644067 (37.7677583098187, -122.439340644067) 15 5 5 29492 3
138417 233502 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 6 Park Hill Ave 7 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   6001148.61748 2107774.29044 37.7676109487195 -122.439310982617 (37.7676109487195, -122.439310982617) 15 5 5 29492 3
96920 63999 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 595 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 778275 6001356.36107438 2100834.50333121 37.7485677985315 -122.438095249236 (37.7485677985315, -122.438095249236) 2 4 5 28862 22
148038 233491 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 580 Jersey St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6001369.26473 2101468.92323 37.7503104980297 -122.438096067791 (37.7503104980297, -122.438096067791) 2 4 5 28862 22
194332 237618 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 395 Eureka St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/11/2020 12:00:00 AM 3 3x3 Permit Number 787900 6001516.02196 2103550.89224 37.756035430207 -122.437737665468 (37.756035430207, -122.437737665468) 2 4 5 28862 3
137193 233435 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 650 28th St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6001680.56547 2099436.84867 37.7447486021689 -122.436874115749 (37.7447486021689, -122.436874115749) 2 7 5 63 22
613 161126 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 485 London St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 0 Width 0ft   6001694.7774 2090903.55181 37.721318940793 -122.436214417168 (37.721318940793, -122.436214417168) 9 7 6 28861 5
15217 161127 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 485 London St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 3 Width 0ft   6001702.30852 2090917.36085 37.7213572852021 -122.436189371961 (37.7213572852021, -122.436189371961) 9 7 6 28861 5
3506 161128 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 485 London St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 0 Width 0ft   6001711.00806 2090931.14538 37.7213956286903 -122.436160286079 (37.7213956286903, -122.436160286079) 9 7 6 28861 5
10399 161129 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 485 London St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 3 Width 0ft   6001722.11588 2090948.37155 37.7214435589648 -122.436123121581 (37.7214435589648, -122.436123121581) 9 7 6 28861 5
129097 233493 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 4103 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6001723.63115 2103489.69631 37.7558792035671 -122.437015303929 (37.7558792035671, -122.437015303929) 2 4 5 28862 22
10542 233492 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 416 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6001776.45872 2103391.52743 37.7556126580189 -122.436825582043 (37.7556126580189, -122.436825582043) 2 4 5 28862 22
132630 51917 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 4103 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/2006 12:00:00 AM     Permit Number 48118 6001789.43433007 2103492.65068775 37.7558910555827 -122.436787946951 (37.7558910555827, -122.436787946951) 2 4 5 28862 22
117702 233490 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 918 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6001888.71802 2101354.60643 37.7500261396126 -122.436291586193 (37.7500261396126, -122.436291586193) 2 4 5 28862 22
81784 93874 Significant Tree 6 Pistacia chinensis :: Chinese Pistache 32 2614 Sacramento St   Front Yard : Tree Private 2   04/14/2010 12:00:00 AM     Permit Number 53370 6002291 2115777 37.7896493226209 -122.435932319436 (37.7896493226209, -122.435932319436) 13 6 1 29490 27
66612 233437 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 4221 26th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6002351.48314 2100601.8225 37.7479854555773 -122.434637500016 (37.7479854555773, -122.434637500016) 2 4 5 63 22
168397 233499 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 4033 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6002782.35328 2104714.28422 37.7593017489969 -122.43344140802 (37.7593017489969, -122.43344140802) 2 4 5 28862 3
106723 60332 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 4033 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2013 12:00:00 AM   3x3 Permit Number 770595 6002797.86052916 2104715.61000638 37.7593062690744 -122.433387871218 (37.7593062690744, -122.433387871218) 2 4 5 28862 3
123083 233500 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 4090 20th St 10 : Yard Tree Private 2     3 Width 3ft   6003098.24212 2104183.0577 37.7578610449587 -122.432310971886 (37.7578610449587, -122.432310971886) 2 4 5 28862 3
16103 247814 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 532 30th St 1 : Tree Private 2     5 Width 3ft   6003126.49354 2098351.09832 37.7418494576778 -122.431796869036 (37.7418494576778, -122.431796869036) 2 7 5 63 22
28716 233494 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 885 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6003128.49899 2103230.63077 37.7552476232057 -122.432138316435 (37.7552476232057, -122.432138316435) 2 4 5 28862 22
86394 81256 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 885 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2008 12:00:00 AM   3x3 Permit Number 50448 6003133.58124947 2103094.76960314 37.7548748688717 -122.432111038861 (37.7548748688717, -122.432111038861) 2 4 5 28862 22
43234 233495 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 450 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6003394.34799 2103331.88494 37.7555407122568 -122.431226159276 (37.7555407122568, -122.431226159276) 2 4 5 28862 22
134754 233376 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 476 27th St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6003431.53598 2100120.0067 37.7467237571152 -122.430868343305 (37.7467237571152, -122.430868343305) 2 7 5 63 22
120408 178359 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 235 Madrid St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6003629.76511 2092456.58351 37.7256929707372 -122.429636417784 (37.7256929707372, -122.429636417784) 9 7 6 28861 5
146239 40842 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 736 Brazil Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/02/1999 12:00:00 AM 4   Permit Number 41768 6003877.32471 2090996.85853 37.7216989034509 -122.428676613636 (37.7216989034509, -122.428676613636) 9 7 6 28861 5
46316 9558 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 1195X Golden Gate Ave 11 Sidewalk: Curb side : Cutout Tree Office of Mayor 9   12/15/2005 12:00:00 AM 3 3X3   6003912.3472435 2112132.7194564 37.7797350134544 -122.430062547125 (37.7797350134544, -122.430062547125) 7 9 11 29490 41
36402 16950 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 630 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003955.1515 2110112.5344 37.7741905079368 -122.429770337641 (37.7741905079368, -122.429770337641) 7 9 11 29492 10
67618 233375 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1489 Sanchez St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6003970.51891 2099621.7541 37.7453861945158 -122.428969076773 (37.7453861945158, -122.428969076773) 2 7 5 63 22
170214 57728 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 354 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2009 12:00:00 AM   3x3 Permit Number 52544 6004003.00672697 2109073.0127901 37.7713389455863 -122.429530647558 (37.7713389455863, -122.429530647558) 7 9 11 29492 10
130406 233503 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 354 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6004006.37155 2109072.69928 37.7713382752792 -122.429518986121 (37.7713382752792, -122.429518986121) 7 9 11 29492 10
73865 233504 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 303 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6004169.36699 2109042.82598 37.7712654778421 -122.428953047263 (37.7712654778421, -122.428953047263) 7 9 11 29492 10
182151 233505 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 303 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6004187.87714 2109045.00996 37.7712725222301 -122.428889175598 (37.7712725222301, -122.428889175598) 7 9 11 29492 10
53615 233359 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 93 Webster St 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 4ft   6004257.74689 2109007.55308 37.7711736292001 -122.428644822623 (37.7711736292001, -122.428644822623) 7 9 11 29492 10
13489 160999 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 265 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 0 Width 0ft   6004550.61216 2090876.91947 37.7214076589281 -122.426340700176 (37.7214076589281, -122.426340700176) 9 7 6 28861 5
159942 141827 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1040 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6004564.2329 2112276.6178 37.7801670209735 -122.427817645466 (37.7801670209735, -122.427817645466) 7 9 11 29490 41
37896 9519 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 1042 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/06/2002 12:00:00 AM 3 3X3   6004584.56967 2112292.20585 37.780210972327 -122.427748402246 (37.780210972327, -122.427748402246) 7 9 11 29490 41
110100 12389 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 1450 Laguna St 3 Sidewalk: Curb side : Cutout Tree Private 2     18 4x4   6004617.47643 2113882.98777 37.7845807261574 -122.427747939391 (37.7845807261574, -122.427747939391) 13 9 11 28858 41
87307 141826 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1020 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6004640.8141 2112287.0177 37.7801999083923 -122.427553457164 (37.7801999083923, -122.427553457164) 7 9 11 29490 41
27892 9514 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 1024 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/15/2005 12:00:00 AM 3 3X3   6004658.34921 2112287.36137 37.7802018438259 -122.427492819652 (37.7802018438259, -122.427492819652) 7 9 11 29490 41
55259 178358 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 54 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6004690.16722 2093211.84688 37.7278267435864 -122.426024429306 (37.7278267435864, -122.426024429306) 9 7 6 28861 5
11621 171168 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 61 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004706.69577 2093156.0367 37.7276744353238 -122.425963318556 (37.7276744353238, -122.425963318556) 9 7 6 28861 5
1405 96265 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2776 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/19/2011 12:00:00 AM     Permit Number 767311 6004841.3 2119075.5 37.798850712467 -122.427343605274 (37.798850712467, -122.427343605274) 13 9 1 57 17

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);