443 rows where qSpecies_id = 32 sorted by Longitude

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                      
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
127261 194536 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 150 Berry St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6014975.61342 2110964.15152 37.7771467490639 -122.391707837847 (37.7771467490639, -122.391707837847) 6 2 9 28856 20
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
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
52158 194535 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 360 Ritch St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6014325.43113 2111634.88834 37.7789523278141 -122.394004006676 (37.7789523278141, -122.394004006676) 6 2 9 28856 34
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
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
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
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
191856 194538 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 4 08th St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6012547.84553 2107301.30971 37.7669543500844 -122.399849041507 (37.7669543500844, -122.399849041507) 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
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
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
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
121600 194541 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 4 08th St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6012465.16673 2107386.76068 37.7671843696864 -122.40014101809 (37.7671843696864, -122.40014101809) 14 3 8 28856 20
125518 194542 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 4 08th St 6 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6012450.21381 2107404.91238 37.7672333764343 -122.400194013336 (37.7672333764343, -122.400194013336) 14 3 8 28856 20
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
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
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
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
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
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
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
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
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
44013 87743 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 335 Wilde Ave   Sidewalk: Curb side : Cutout Tree Private 2   05/27/2008 12:00:00 AM   3x3 Permit Number 50406 6011180.9 2088940.4 37.7164629306199 -122.403285348147 (37.7164629306199, -122.403285348147) 9 7 8 309 39
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
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
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
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
192710 249942 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 331 Filbert St 4 Front Yard : Yard Tree Private 2     14 Width 0ft   6011270.23997 2120024.6306 37.801818286952 -122.405164122933 (37.801818286952, -122.405164122933) 3 1 10 308 23
177361 249944 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 331 Filbert St 6 Front Yard : Yard Tree Private 2     8 Width 0ft   6011269.54801 2120028.9121 37.8018300042211 -122.40516681911 (37.8018300042211, -122.40516681911) 3 1 10 308 23
103041 249943 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 331 Filbert St 5 Front Yard : Yard Tree Private 2     8 Width 0ft   6011269.12703 2120027.36915 37.8018257441226 -122.405168167193 (37.8018257441226, -122.405168167193) 3 1 10 308 23
34340 45171 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 47 Brewster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/23/2001 12:00:00 AM     Permit Number 44018 6010456.17942581 2099626.75633158 37.7457649076199 -122.406542957313 (37.7457649076199, -122.406542957313) 2 7 7 28859 2
163353 248106 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 47 Brewster St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6010434.28428 2099597.55931 37.7456835139995 -122.406616610788 (37.7456835139995, -122.406616610788) 2 7 7 28859 2
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
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
81814 194532 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2200 Alameda St 6 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6010402.10466 2107886.85819 37.7684422757183 -122.407312137446 (37.7684422757183, -122.407312137446) 8 4 8 28853 19
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
19586 194533 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2200 Alameda St 9 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6010348.85424 2107885.73513 37.7684362115906 -122.40749624758 (37.7684362115906, -122.40749624758) 8 4 8 28853 19
55733 39080 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2280X Alameda St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/18/1998 12:00:00 AM     Permit Number 40778 6010277.76687759 2108009.04739866 37.7687708195348 -122.40775082962 (37.7687708195348, -122.40775082962) 8 4 8 28853 19
167745 39073 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2280X Alameda St 6 Sidewalk: Curb side : Cutout Tree Private 2   11/18/1998 12:00:00 AM     Permit Number 40778 6010277.76687759 2108009.04739866 37.7687708195348 -122.40775082962 (37.7687708195348, -122.40775082962) 8 4 8 28853 19
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
129629 95626 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2737 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/2011 12:00:00 AM   3x3 Permit Number 767393 6010051.6 2104518.5 37.7591739071678 -122.408286901595 (37.7591739071678, -122.408286901595) 2 4 7 28859 19
89268 233371 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2737 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009946.29944 2104530.48554 37.7592009197153 -122.408651928554 (37.7592009197153, -122.408651928554) 2 4 7 28859 19
83677 178356 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 700 Olmstead St 1 Sidewalk: Curb side : Yard Tree Private 2     4 Width 3ft   6009662.10656 2090649.30438 37.7210702863525 -122.408655555513 (37.7210702863525, -122.408655555513) 9 3 7 309 28
136531 178357 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 700 Olmstead St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6009625.93878 2090631.7553 37.7210200744845 -122.408779340021 (37.7210200744845, -122.408779340021) 9 3 7 309 28
120089 51755 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2964 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/11/2015 12:00:00 AM     Permit Number 771839 6009683.01299313 2101640.06724055 37.7512497292061 -122.409358522845 (37.7512497292061, -122.409358522845) 2 4 7 28859 19
69826 233366 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2964 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6009652.81284 2101635.24983 37.7512348095611 -122.409462618807 (37.7512348095611, -122.409462618807) 2 4 7 28859 19
49515 233400 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2807 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009350.24678 2103328.60933 37.7558674377406 -122.410628499003 (37.7558674377406, -122.410628499003) 2 4 7 28859 19
158235 233373 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 3101 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6009080.82321 2100470.36587 37.748004231619 -122.411358344739 (37.748004231619, -122.411358344739) 2 7 7 28859 2
63965 233374 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 3101 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6009080.92209 2100478.86061 37.7480275618365 -122.411358602837 (37.7480275618365, -122.411358602837) 2 7 7 28859 2
34823 108597 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 3103 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2014 12:00:00 AM 3 3x3 Permit Number 774586 6009067.61972 2100561.38658 37.7482534137383 -122.411410431436 (37.7482534137383, -122.411410431436) 2 4 7 28859 2
50919 108598 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 3103 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/2014 12:00:00 AM 3 3x3 Permit Number 774586 6009067.61972 2100561.38658 37.7482534137383 -122.411410431436 (37.7482534137383, -122.411410431436) 2 4 7 28859 2
123792 233403 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 3071 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009068.28085 2100690.59156 37.7486082190041 -122.411417271913 (37.7486082190041, -122.411417271913) 2 4 7 28859 19
139810 233372 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 3265 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6009039.47947 2099686.62589 37.7458499362223 -122.411445948568 (37.7458499362223, -122.411445948568) 2 7 7 28859 2
124043 93976 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 3261 Harrison St   : Cutout Tree Private 2   05/06/2010 12:00:00 AM     Permit Number 53402 6009036 2099698 37.7458809718535 -122.411458783557 (37.7458809718535, -122.411458783557) 2 7 7 28859 2
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
101767 233405 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2989 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6009047.23113 2101093.61607 37.7497136539827 -122.411518531957 (37.7497136539827, -122.411518531957) 2 4 7 28859 19
174979 233404 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2997 Harrison St 2 Sidewalk: Curb side : Cutout Tree Cleary Bros. Landscape 22     5 Width 3ft   6009042 2101022 37.7495167187784 -122.41153156233 (37.7495167187784, -122.41153156233) 2 4 7 28859 19
177011 233406 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2967 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009040.76192 2101208.50526 37.7500287512299 -122.411549018972 (37.7500287512299, -122.411549018972) 2 4 7 28859 19
81331 233407 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2959 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009039.77718 2101237.37153 37.7501079563364 -122.411554463491 (37.7501079563364, -122.411554463491) 2 4 7 28859 19
137671 233408 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2949 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6009035.34127 2101297.66233 37.7502732526072 -122.411574062399 (37.7502732526072, -122.411574062399) 2 4 7 28859 19
140165 91805 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2959 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2007 12:00:00 AM 3 3x3   6009030.231108 2101235.143415 37.7501013029605 -122.411587317077 (37.7501013029605, -122.411587317077) 2 4 7 28859 19
168250 91804 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2959 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2007 12:00:00 AM 3 3x3   6009030.231108 2101235.143415 37.7501013029605 -122.411587317077 (37.7501013029605, -122.411587317077) 2 4 7 28859 19
143745 91737 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 3050 Harrison St   Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6009013.94236 2100807.207547 37.7489253726566 -122.411613412745 (37.7489253726566, -122.411613412745) 2 4 7 28859 19
10685 233450 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 3050 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009002.96054 2100768.18815 37.7488176180461 -122.411648631477 (37.7488176180461, -122.411648631477) 2 4 7 28859 19
59459 26520 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2859 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 1X1   6009005.00104 2101862.3389 37.7518220263649 -122.411718875733 (37.7518220263649, -122.411718875733) 2 4 7 28859 19
101913 26527 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2789 Harrison St 2 Sidewalk: Curb side : Cutout Tree DPW 1   07/04/2011 12:00:00 AM 3 3x3   6009007.86561 2102243.77418 37.7528695228702 -122.411735918856 (37.7528695228702, -122.411735918856) 2 4 7 28859 19
26635 26526 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2789 Harrison St 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/30/2011 12:00:00 AM 3 3x3   6009007 2102243 37.7528673485866 -122.411738857609 (37.7528673485866, -122.411738857609) 2 4 7 28859 19
40647 233409 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2789 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6009007 2102243 37.7528673485866 -122.411738857609 (37.7528673485866, -122.411738857609) 2 4 7 28859 19
190640 91738 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2900x Harrison St   Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6008972.238365 2101556.992621 37.7509817758285 -122.411810599761 (37.7509817758285, -122.411810599761) 2 4 7 28859 19

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