443 rows where qSpecies_id = 32 sorted by Fire Prevention Districts

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                      
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
3388 261119 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2067 Bancroft Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2019 12:00:00 AM 3 5x5   6011786.16554 2094038.32843 37.730494584078 -122.401551330673 (37.730494584078, -122.401551330673) 10 3 8 58 1
4192 264915 Private 9 Pistacia chinensis :: Chinese Pistache 32 1461 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/09/2020 12:00:00 AM 3 3x3 Permit Number 784397 6015819.34366 2093828.22518 37.7301419060949 -122.387593270969 (37.7301419060949, -122.387593270969) 10 3 8 58 1
10926 39982 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 6 Flora St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/25/2019 12:00:00 AM 3 3x3 Permit Number 41240 6013913.21051 2094747.21056 37.7325594879289 -122.394247383904 (37.7325594879289, -122.394247383904) 10 3 8 58 1
12121 11883 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 400X Keith St 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6017703.73127 2096843.30561 37.7385249167977 -122.381288201801 (37.7385249167977, -122.381288201801) 10 3 8 58 1
15836 199688 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2000 Jennings St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6015592.0163 2092881.2495 37.7275291054366 -122.388313110838 (37.7275291054366, -122.388313110838) 10 3 8 58 1
17666 52759 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 22 Gaven St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2014 12:00:00 AM 3   Permit Number 774111 6010286.03762 2095339.86575 37.7339845095792 -122.406829209621 (37.7339845095792, -122.406829209621) 10 3 7 309 28
26149 29650 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1500X La Salle Ave 9 Median : Cutout Tree DPW 1   04/07/2006 12:00:00 AM 3 12x31   6015718.9286 2096019.8862 37.7361542039988 -122.388093308135 (37.7361542039988, -122.388093308135) 10 3 8 58 1
26684 194530 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 616 Carolina St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 6ft   6012360.41946 2105070.75065 37.7608192812075 -122.400340636111 (37.7608192812075, -122.400340636111) 10 3 8 28856 29
30724 200624 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1382 Newcomb Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6016324.8756 2094912.2277 37.7331463494491 -122.385921096754 (37.7331463494491, -122.385921096754) 10 3 8 58 1
33438 35878 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 50 Elmira St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/1998 12:00:00 AM 7   Permit Number 39083 6011145.10995 2096599.24748 37.7374905363641 -122.403947710713 (37.7374905363641, -122.403947710713) 10 3 8 58 1
36781 29649 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1500X La Salle Ave 8 Median : Cutout Tree DPW 1   04/07/2006 12:00:00 AM 3 12x31   6015738.3943 2096009.2115 37.7361259719003 -122.388025261983 (37.7361259719003, -122.388025261983) 10 3 8 58 1
40590 199686 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2000 Jennings St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6015608.757 2092907.6605 37.7276025523971 -122.388257080086 (37.7276025523971, -122.388257080086) 10 3 8 58 1
43559 194534 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 25 Lucy St 1 : Tree Private 2     1 Width 4ft   6014175.87087 2093939.45878 37.7303561623911 -122.39328279268 (37.7303561623911, -122.39328279268) 10 3 8 58 1
47331 29648 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1500X La Salle Ave 7 Median : Cutout Tree DPW 1   04/07/2006 12:00:00 AM 3 12x31   6015756.6041 2095993.5134 37.7360838769453 -122.38796120765 (37.7360838769453, -122.38796120765) 10 3 8 58 1
59287 233440 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 228 Nevada St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008985.91579 2097299.41691 37.7392921796829 -122.411462541085 (37.7392921796829, -122.411462541085) 10 7 7 28859 2
74150 199995 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1094 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6017857.178 2092387.3649 37.7262982485858 -122.380448036499 (37.7262982485858, -122.380448036499) 10 3 8 58 1
83366 45466 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2211 26th St 4 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2001 12:00:00 AM     Permit Number 44247 6011994.00463493 2101339.69847182 37.7505541915496 -122.401345703709 (37.7505541915496, -122.401345703709) 10 3 8 28856 1
91109 253371 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 100 Southern Heights Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2017 12:00:00 AM 3     6012159.87787 2104118.04133 37.7581921670504 -122.400967284676 (37.7581921670504, -122.400967284676) 10 3 8 28856 29
97002 35881 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 50 Elmira St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/1998 12:00:00 AM 7   Permit Number 39083 6011145.59946 2096623.30558 37.7375566221413 -122.403947710744 (37.7375566221413, -122.403947710744) 10 3 8 58 1
97777 35879 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 50 Elmira St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/1998 12:00:00 AM 8   Permit Number 39083 6011139.9615 2096662.77409 37.7376646792858 -122.403969980625 (37.7376646792858, -122.403969980625) 10 3 8 58 1
98560 178360 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 114 Sweeny St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/06/2018 12:00:00 AM 3 3x3 Permit Number 781343 6009991.86293 2095011.33058 37.7330659573247 -122.40782310796 (37.7330659573247, -122.40782310796) 10 3 7 309 28
104740 29645 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1500X La Salle Ave 4 Median : Cutout Tree DPW 1   04/07/2006 12:00:00 AM 3 12x31   6015832.5829 2095938.2561 37.7359363605469 -122.387694661666 (37.7359363605469, -122.387694661666) 10 3 8 58 1
114649 194547 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 590 Keith St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6017544.15385 2096613.95658 37.7378863594562 -122.381824001685 (37.7378863594562, -122.381824001685) 10 3 8 58 1
118450 199989 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1054 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6018046.698 2092242.698 37.7259114771391 -122.379782821602 (37.7259114771391, -122.379782821602) 10 3 8 58 1
118535 194531 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2221 26th St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6011908.13677 2101346.92633 37.75056924647 -122.401643151235 (37.75056924647, -122.401643151235) 10 3 8 28856 1
119135 45703 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 1796 La Salle Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/16/2002 12:00:00 AM     Permit Number 44377 6014535.62783282 2096937.66705225 37.7386086105091 -122.392248663491 (37.7386086105091, -122.392248663491) 10 3 8 58 1
120951 35880 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 50 Elmira St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/1998 12:00:00 AM 7   Permit Number 39083 6011141.46747 2096642.94504 37.7376103170696 -122.403963378733 (37.7376103170696, -122.403963378733) 10 3 8 58 1
123473 233367 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1113 Hampshire St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6010291.70011 2102620.11112 37.753974797412 -122.407322687398 (37.753974797412, -122.407322687398) 10 4 7 28859 19
125810 194528 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1 25th St 21 : Yard Tree Private 2     3     6014977.55524 2102273.87418 37.7532852503289 -122.391093555018 (37.7532852503289, -122.391093555018) 10 3 8 28856 29
130450 194526 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1 25th St 15 : Yard Tree Private 2     5     6014989.61274 2102184.78595 37.7530413020381 -122.391045631074 (37.7530413020381, -122.391045631074) 10 3 8 28856 29
131306 3871 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1540X La Salle Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/15/2013 12:00:00 AM   3X3   6015830.0749765 2095995.2525495 37.7360927223499 -122.3877073081 (37.7360927223499, -122.3877073081) 10 3 8 58 1
132838 26467 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 300X Keith St 4 Sidewalk: Curb side : Cutout Tree DPW 1   08/19/2016 12:00:00 AM 3 3X3   6017600.4401851 2096710.4383408 37.7381543871139 -122.381636098386 (37.7381543871139, -122.381636098386) 10 3 8 58 1
136895 29646 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1500X La Salle Ave 5 Median : Cutout Tree DPW 1   04/07/2006 12:00:00 AM 3 12x31   6015803.0705 2095958.3496 37.7359898984178 -122.387798100273 (37.7359898984178, -122.387798100273) 10 3 8 58 1
144108 194527 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1 25th St 16 : Yard Tree Private 2     3     6014969.95823 2102191.83984 37.7530595798584 -122.391114093749 (37.7530595798584, -122.391114093749) 10 3 8 28856 29
148734 253372 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 100 Southern Heights Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2017 12:00:00 AM 3     6012159.87787 2104118.04133 37.7581921670504 -122.400967284676 (37.7581921670504, -122.400967284676) 10 3 8 28856 29
153206 53194 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1465@ KEITH Underwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/28/2006 12:00:00 AM 2 3x3 Permit Number 49131 6015294.6422 2093162.1043 37.7282837944132 -122.389360748448 (37.7282837944132, -122.389360748448) 10 3 8 58 1
153544 29647 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1500X La Salle Ave 6 Median : Cutout Tree DPW 1   04/07/2006 12:00:00 AM 3 12x31   6015782.349 2095974.6757 37.7360335786804 -122.387870882274 (37.7360335786804, -122.387870882274) 10 3 8 58 1
157112 256075 Undocumented 4 Pistacia chinensis :: Chinese Pistache 32 1919 Jennings St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015778 2093027 37.7279396111572 -122.387680322808 (37.7279396111572, -122.387680322808) 10 3 8 58 1
157819 150468 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 100 Southern Heights Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2017 12:00:00 AM 3 Width 2ft Permit Number 776550 6012105.23351 2104143.6419 37.7582594122512 -122.401158068605 (37.7582594122512, -122.401158068605) 10 3 8 28856 29
159163 3872 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1540X La Salle Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1   05/15/2013 12:00:00 AM   3X3   6015830.0749765 2095995.2525495 37.7360927223499 -122.3877073081 (37.7360927223499, -122.3877073081) 10 3 8 58 1
160388 37944 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 547 Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/2006 12:00:00 AM 4   Permit Number 48880 6013009.69934 2104469.29926 37.7592040124698 -122.398052855272 (37.7592040124698, -122.398052855272) 10 3 8 28856 29
164883 253370 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 896 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2017 12:00:00 AM 3     6012140.05864 2104123.74749 37.7582067293333 -122.401036229519 (37.7582067293333, -122.401036229519) 10 3 8 28856 29
170251 52758 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 22 Gaven St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/04/2016 12:00:00 AM 1   Permit Number 774111 6010296.38896 2095344.759 37.733998524598 -122.406793766427 (37.733998524598, -122.406793766427) 10 3 7 309 28
171151 199687 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2000 Jennings St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6015600.4454 2092895.2979 37.7275681466115 -122.388284951178 (37.7275681466115, -122.388284951178) 10 3 8 58 1
181825 194529 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1 25th St 23 : Yard Tree Private 2     2     6014967.18541 2102296.35434 37.753346400626 -122.391130987502 (37.753346400626, -122.391130987502) 10 3 8 28856 29
188244 199695 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1350 Underwood Ave 2 Sidewalk: Curb side : Pot Tree Private 2     2 Width 0ft   6015882.1777 2092801.0091 37.7273248550401 -122.387304416847 (37.7273248550401, -122.387304416847) 10 3 8 58 1
189302 256060 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1560 Underwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF         6014829 2093598 37.7294548494407 -122.391000959828 (37.7294548494407, -122.391000959828) 10 3 8 58 1
190411 150469 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 100 Southern Heights Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2017 12:00:00 AM 3 Width 2ft Permit Number 776550 6012042.59416 2104165.28662 37.7583153491828 -122.401376225239 (37.7583153491828, -122.401376225239) 10 3 8 28856 29
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
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
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
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
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
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
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
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
18592 111041 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2700X Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6004870.73043 2118877.40927 37.7983084704282 -122.427227648441 (37.7983084704282, -122.427227648441) 13 9 1 57 17
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
37811 111042 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2700X Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6004867.45543 2118890.27835 37.7983436204214 -122.42723989811 (37.7983436204214, -122.42723989811) 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
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
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
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
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
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
91576 96266 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2776 Gough St 3 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
95260 96264 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2776 Gough St 1 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
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
101848 132211 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2700 Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004866.10803 2118906.26122 37.7983874290946 -122.427245699623 (37.7983874290946, -122.427245699623) 13 9 1 57 17
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
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
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
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
7122 194543 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 184 Hooper St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6012559.7859 2107618.88108 37.7678269955571 -122.399830043335 (37.7678269955571, -122.399830043335) 14 3 8 28856 20
21926 194544 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 184 Hooper St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6012545.36949 2107606.50724 37.7677922160651 -122.399879039311 (37.7677922160651, -122.399879039311) 14 3 8 28856 20
68145 194540 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 4 08th St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6012505.10498 2107346.22269 37.7670752882293 -122.400000029601 (37.7670752882293, -122.400000029601) 14 3 8 28856 20
73030 194539 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 4 08th St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6012519.55617 2107331.82323 37.767036556231 -122.399949033536 (37.767036556231, -122.399949033536) 14 3 8 28856 20
75963 194537 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 4 08th St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6012568.21907 2107279.59323 37.7668958572755 -122.399777047179 (37.7668958572755, -122.399777047179) 14 3 8 28856 20
89574 194545 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 184 Hooper St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6012495.5993 2107561.45835 37.7676657471131 -122.400048025518 (37.7676657471131, -122.400048025518) 14 3 8 28856 20
119104 194546 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 184 Hooper St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6012481.42509 2107546.77644 37.7676246435913 -122.40009602143 (37.7676246435913, -122.40009602143) 14 3 8 28856 20

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