443 rows where qSpecies_id = 32 sorted by TreeID

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)
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
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
23903 107340 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 300X EUGENIA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2014 12:00:00 AM 3 3x3 Permit Number 773835 6006696 2098030 37.7411694904711 -122.419431881915 (37.7411694904711, -122.419431881915) 2 7 7 28859 2
54744 108430 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 3025 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2014 12:00:00 AM 3 3x3 Permit Number 772569 6008074.01196 2103843.74387 37.7572102444691 -122.415078608854 (37.7572102444691, -122.415078608854) 2 4 7 28859 19
177707 108436 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 200-212X Lexington St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2014 12:00:00 AM 3 3x3 Permit Number 772675 6006463.90093 2104927.47787 37.7600953129132 -122.420723941274 (37.7600953129132, -122.420723941274) 2 4 7 28859 19
107605 108437 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 200-212X Lexington St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2014 12:00:00 AM 3 3x3 Permit Number 772675 6006463.90093 2104927.47787 37.7600953129132 -122.420723941274 (37.7600953129132, -122.420723941274) 2 4 7 28859 19
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
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
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
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
182852 115200 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 716 Dolores St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/19/2016 12:00:00 AM     Permit Number 774286 6004934.3 2104152.6 37.7578813515637 -122.425958943462 (37.7578813515637, -122.425958943462) 2 4 5 28862 3
34960 115370 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 481 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2016 12:00:00 AM 3   Permit Number 773523 6007887 2096619.6 37.7373638523191 -122.415214003631 (37.7373638523191, -122.415214003631) 2 7 7 28859 2
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
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
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
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
132552 120537 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 300X EUGENIA AVE 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2016 12:00:00 AM 3 3x3 Permit Number 778832 6006696 2098030 37.7411694904711 -122.419431881915 (37.7411694904711, -122.419431881915) 2 7 7 28859 2
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
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
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
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
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
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
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
72362 139831 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 925 GOLDEN GATE AVE 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6005175.7373 2112309.654 37.7802923037704 -122.42570452289 (37.7802923037704, -122.42570452289) 7 9 11 28852 41
85920 139838 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 875 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6005379.6259 2112337.1416 37.7803792970953 -122.425001133553 (37.7803792970953, -122.425001133553) 7 9 11 28852 41
26805 139841 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 855 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6005489.2243 2112352.6717 37.7804281291994 -122.424623086227 (37.7804281291994, -122.424623086227) 7 9 11 28852 41
123609 139845 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 833 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6005645.4131 2112373.0828 37.7804929927223 -122.424084207294 (37.7804929927223, -122.424084207294) 7 9 11 28852 41
5052 139847 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 829 Golden Gate Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6005684.1962 2112380.729 37.7805161769301 -122.423950581978 (37.7805161769301, -122.423950581978) 7 9 11 28852 41
92938 139937 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 800 GOLDEN GATE AVE 15 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6005368.7488 2112395.1092 37.7805378474705 -122.425042888178 (37.7805378474705, -122.425042888178) 7 9 11 28852 41
67414 139945 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 900 GOLDEN GATE AVE 8 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6005081.184 2112356.1174 37.7804145374079 -122.426034935273 (37.7804145374079, -122.426034935273) 7 9 11 28852 41
49344 139946 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 900 GOLDEN GATE AVE 9 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6005060.605 2112352.3265 37.7804029654412 -122.426105857766 (37.7804029654412, -122.426105857766) 7 9 11 28852 41
180969 139955 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 900 GOLDEN GATE AVE 18 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6004851.0238 2112323.6242 37.7803123083991 -122.426828852854 (37.7803123083991, -122.426828852854) 7 9 11 28852 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
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
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
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
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
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
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
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
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
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
10960 166315 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008872.21502 2103120.32489 37.7552687230844 -122.412266973836 (37.7552687230844, -122.412266973836) 2 4 7 28859 19
16166 166316 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008870.16891 2103155.64589 37.7553655917605 -122.412276546247 (37.7553655917605, -122.412276546247) 2 4 7 28859 19
12003 166317 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008865.69274 2103234.56357 37.755582030708 -122.412297603862 (37.755582030708, -122.412297603862) 2 4 7 28859 19
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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