1,985 rows where qSpecies_id = 83 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)
47740 85646 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1321 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016609.4363 2093572.233 37.7294827335965 -122.38484396609 (37.7294827335965, -122.38484396609) 10 3 8 58 1
96544 197151 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 99 Whitney Young Cir 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6016637.91847 2095129.63156 37.7337606161438 -122.384853953468 (37.7337606161438, -122.384853953468) 10 3 8 58 1
5684 83143 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 101X Whitney Young Cir 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6016637.51216 2095504.68596 37.7347904181313 -122.384881478104 (37.7347904181313, -122.384881478104) 10 3 8 58 1
110946 24179 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 101X Whitney Young Cir 12 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/1990 12:00:00 AM 12 5x3   6016625.58798 2095312.02915 37.7342607615082 -122.384909286932 (37.7342607615082, -122.384909286932) 10 3 8 58 1
55456 24180 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 101X Whitney Young Cir 13 Sidewalk: Curb side : Cutout Tree DPW 1     30 3x3   6016621.33395 2095295.74377 37.7342158098126 -122.384922860422 (37.7342158098126, -122.384922860422) 10 3 8 58 1
64663 24178 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 101X Whitney Young Cir 11 Sidewalk: Curb side : Cutout Tree DPW 1   02/15/2001 12:00:00 AM 4 4x3   6016619.18629 2095310.93644 37.7342574070589 -122.384931343733 (37.7342574070589, -122.384931343733) 10 3 8 58 1
73012 1709 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 7X Bass Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   01/01/2006 12:00:00 AM 5 3x3   6016610.5210337 2095134.7434862 37.7337731370994 -122.384949031469 (37.7337731370994, -122.384949031469) 10 3 8 58 1
118427 85621 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1356 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016575.2959 2093679.014 37.7297740447744 -122.384969430386 (37.7297740447744, -122.384969430386) 10 3 8 58 1
176763 197157 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 106 Whitney Young Cir 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6016598.78719 2095669.6865 37.7352413346217 -122.385026857123 (37.7352413346217, -122.385026857123) 10 3 8 58 1
40192 85647 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1351 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016557.1838 2093613.7118 37.7295937360014 -122.385027498588 (37.7295937360014, -122.385027498588) 10 3 8 58 1
48144 85622 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1360 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016552.9396 2093696.0654 37.7298196279301 -122.385047906896 (37.7298196279301, -122.385047906896) 10 3 8 58 1
971 16508 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 325 Newhall St 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016639.93914 2098306.03692 37.7424824967653 -122.385068203435 (37.7424824967653, -122.385068203435) 10 3 8 58 1
63506 197158 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 106 Whitney Young Cir 6 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6016583.16711 2095682.22839 37.7352749081106 -122.385081735533 (37.7352749081106, -122.385081735533) 10 3 8 58 1
97184 85648 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1357 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016534.0204 2093632.0271 37.7296427448929 -122.385108853227 (37.7296427448929, -122.385108853227) 10 3 8 58 1
151238 197160 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 11 Mabrey Ct 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6016488.26571 2095902.24457 37.7358737783612 -122.385425174944 (37.7358737783612, -122.385425174944) 10 3 8 58 1
37453 16492 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 305X Newhall St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1992 12:00:00 AM 3 3X3   6016524.6681965 2098330.497802 37.7425432844059 -122.385468484111 (37.7425432844059, -122.385468484111) 10 3 8 58 1
42041 13319 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 14 Mabrey Ct 1 Sidewalk: Curb side : Cutout Tree Private 2   09/09/1992 12:00:00 AM 7 3X3   6016463.59576 2095940.92929 37.7359786339072 -122.385513164614 (37.7359786339072, -122.385513164614) 10 3 8 58 1
59260 197159 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 122 Whitney Young Cir 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6016446.71962 2095806.95269 37.7356098273254 -122.385562178561 (37.7356098273254, -122.385562178561) 10 3 8 58 1
90740 112843 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 1415 EVANS AVE 1 Front Yard : Yard Tree Private 2           6016481 2097724 37.7408755487739 -122.385577218432 (37.7408755487739, -122.385577218432) 10 3 8 58 1
17729 197162 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 123 Whitney Young Cir 6 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6016438.8167 2095743.2053 37.735434352517 -122.385585060917 (37.735434352517, -122.385585060917) 10 3 8 58 1
100166 24177 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 95X Whitney Young Cir 10 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 4 3X3   6016412.1769872 2096105.6107164 37.736427970914 -122.38570241579 (37.736427970914, -122.38570241579) 10 3 8 58 1
111504 24186 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 55X Whitney Young Cir 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 4x3   6016412.1769872 2096105.6107164 37.736427970914 -122.38570241579 (37.736427970914, -122.38570241579) 10 3 8 58 1
115424 24171 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 95X Whitney Young Cir 4 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3x3   6016412.1769872 2096105.6107164 37.736427970914 -122.38570241579 (37.736427970914, -122.38570241579) 10 3 8 58 1
117222 24194 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 55X Whitney Young Cir 10 Sidewalk: Curb side : Cutout Tree DPW 1   01/01/2008 12:00:00 AM 3 3x3   6016412.1769872 2096105.6107164 37.736427970914 -122.38570241579 (37.736427970914, -122.38570241579) 10 3 8 58 1
95338 24072 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 161X Whitney Young Cir 2 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3X3   6016395.7853594 2095946.5828375 37.735990405317 -122.385748008424 (37.735990405317, -122.385748008424) 10 3 8 58 1
1561 24107 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 105X Whitney Young Cir 14 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.081358 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885) 10 3 8 58 1
61107 24109 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 105X Whitney Young Cir 16 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.081358 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885) 10 3 8 58 1
100588 24094 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 105X Whitney Young Cir 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.081358 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885) 10 3 8 58 1
123317 24106 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 105X Whitney Young Cir 13 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.081358 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885) 10 3 8 58 1
184542 24098 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 105X Whitney Young Cir 5 Sidewalk: Curb side : Cutout Tree DPW 1   03/11/2006 12:00:00 AM 3 3x3   6016397.2233978 2096041.081358 37.7362499588234 -122.385749620885 (37.7362499588234, -122.385749620885) 10 3 8 58 1
134247 85649 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1399 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016350.3286 2093764.5437 37.7299964462298 -122.385753133703 (37.7299964462298, -122.385753133703) 10 3 8 58 1
27684 24086 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 141X Whitney Young Cir 8 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3X3   6016393.5495733 2095983.6738742 37.7360921261264 -122.385758322913 (37.7360921261264, -122.385758322913) 10 3 8 58 1
40510 197161 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 130 Whitney Young Cir 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6016392.6723 2096037.13258 37.7362388644345 -122.385765080913 (37.7362388644345, -122.385765080913) 10 3 8 58 1
92503 8232 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1500X Galvez Ave 11 Sidewalk: Curb side : Cutout Tree DPW 1   11/13/1992 12:00:00 AM 6 3x3   6016396.247314 2097296.3974116 37.7396967491289 -122.385840466933 (37.7396967491289, -122.385840466933) 10 3 8 58 1
48659 16518 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 330 Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3X3   6016409.9700879 2098376.06541 37.7426620571468 -122.385868255606 (37.7426620571468, -122.385868255606) 10 3 8 58 1
74210 24149 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 100X Whitney Young Cir 9 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3x3   6016357.373923 2096088.8828188 37.736379006836 -122.385890729183 (37.736379006836, -122.385890729183) 10 3 8 58 1
77507 24151 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 100X Whitney Young Cir 11 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3x3   6016357.373923 2096088.8828188 37.736379006836 -122.385890729183 (37.736379006836, -122.385890729183) 10 3 8 58 1
173196 24167 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 110X Whitney Young Cir 18 Sidewalk: Curb side : Cutout Tree Private 2   01/01/2011 12:00:00 AM 2 3x3   6016346.0952597 2096044.1423309 37.736255534298 -122.385926606914 (37.736255534298, -122.385926606914) 10 3 8 58 1
24442 24127 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 140X Whitney Young Cir 6 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3X3   6016343.6401634 2095980.6654178 37.7360811036021 -122.385930671948 (37.7360811036021, -122.385930671948) 10 3 8 58 1
140511 24090 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 125X Whitney Young Cir 2 Sidewalk: Curb side : Cutout Tree Private 2   05/07/1997 12:00:00 AM 6 3x3   6016342.36416 2095991.2568 37.736110114791 -122.3859358217 (37.736110114791, -122.3859358217) 10 3 8 58 1
151215 85623 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1404 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016275.7207 2093898.407 37.7303598794973 -122.386020392504 (37.7303598794973, -122.386020392504) 10 3 8 58 1
80757 16526 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 375 Newhall St 6 Sidewalk: Curb side : Cutout Tree Private 2   12/03/1992 12:00:00 AM 3 3X3   6016351.58796 2098272.95822 37.7423757148758 -122.386062939968 (37.7423757148758, -122.386062939968) 10 3 8 58 1
114475 85624 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1422 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016199.7661 2093954.969 37.7305109836044 -122.38628692243 (37.7305109836044, -122.38628692243) 10 3 8 58 1
90386 85650 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1419 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016182.7975 2093891.6734 37.7303362472247 -122.386341174586 (37.7303362472247, -122.386341174586) 10 3 8 58 1
29386 8257 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1525 GALVEZ AVE 4 Sidewalk: Curb side : Cutout Tree DPW 1   11/13/1992 12:00:00 AM 6 3x3   6016246 2097351 37.7398383611722 -122.386363768789 (37.7398383611722, -122.386363768789) 10 3 8 58 1
44842 85625 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1430 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016164.799973 2093969.832807 37.7305498611727 -122.386408842499 (37.7305498611727, -122.386408842499) 10 3 8 58 1
68298 256028 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1376 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3   6016144 2093317 37.7287561605437 -122.386435251043 (37.7287561605437, -122.386435251043) 10 3 8 58 1
9223 60407 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1430 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/27/1982 12:00:00 AM 6   Permit Number 19988 6016156.6712 2093985.1354 37.7305914290757 -122.386438011678 (37.7305914290757, -122.386438011678) 10 3 8 58 1
14166 197170 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1510X Galvez Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6016200.17093 2097456.77974 37.740126273917 -122.386529601766 (37.740126273917, -122.386529601766) 10 3 8 58 1
33561 52155 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1431 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/31/2005 12:00:00 AM 8   Permit Number 48347 6016125.1581 2093936.3843 37.7304558237734 -122.386543560163 (37.7304558237734, -122.386543560163) 10 3 8 58 1
18976 44337 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1386 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/06/2001 12:00:00 AM 10   Permit Number 43722 6016111.02072 2094370.93672 37.7316482354559 -122.386622725671 (37.7316482354559, -122.386622725671) 10 3 8 58 1
128338 60409 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1448 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/09/2009 12:00:00 AM 5 3x3 Permit Number 52503 6016089.8742 2094040.62 37.7307400809012 -122.386672808634 (37.7307400809012, -122.386672808634) 10 3 8 58 1
168996 85626 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1454 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6016038.1604 2094077.7893 37.7308392772335 -122.38685418415 (37.7308392772335, -122.38685418415) 10 3 8 58 1
76146 16542 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 400X Newhall St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6016097.47551 2098025.0219 37.741680865376 -122.386924304309 (37.741680865376, -122.386924304309) 10 3 8 58 1
89508 98309 Significant Tree 6 Pyrus kawakamii :: Evergreen Pear 83 401X Newhall St 1 Front Yard : Tree Private 2     6 3x3   6016081.14502 2097910.94016 37.7413667159929 -122.386972815546 (37.7413667159929, -122.386972815546) 10 3 8 58 1
192376 16544 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 400X Newhall St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016074.64629 2097992.47705 37.7415902397879 -122.387000971524 (37.7415902397879, -122.387000971524) 10 3 8 58 1
63378 6645 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 495X Newhall St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/16/1992 12:00:00 AM 6 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472) 10 3 8 58 1
83069 85627 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1466 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015977.8277 2094121.4228 37.7309557454266 -122.387065808076 (37.7309557454266, -122.387065808076) 10 3 8 58 1
12336 85628 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1470 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015957.8963 2094137.5833 37.7309990152261 -122.387135841638 (37.7309990152261, -122.387135841638) 10 3 8 58 1
131856 85651 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1467 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015942.8131 2094070.7863 37.7308147687334 -122.387183329829 (37.7308147687334, -122.387183329829) 10 3 8 58 1
21156 16551 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 500X Newhall St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/12/1998 12:00:00 AM 3 3x3   6016006.287148 2097894.9109735 37.7413185578473 -122.387230532448 (37.7413185578473, -122.387230532448) 10 3 8 58 1
63941 16550 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 500X Newhall St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/12/1998 12:00:00 AM 3 3x3   6016006.287148 2097894.9109735 37.7413185578473 -122.387230532448 (37.7413185578473, -122.387230532448) 10 3 8 58 1
70918 16558 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 500X Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1   12/27/1997 12:00:00 AM 3 3x3   6016006.287148 2097894.9109735 37.7413185578473 -122.387230532448 (37.7413185578473, -122.387230532448) 10 3 8 58 1
99225 16557 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 500X Newhall St 8 Sidewalk: Curb side : Cutout Tree Private 2   12/23/1997 12:00:00 AM 3 3x3   6016006.287148 2097894.9109735 37.7413185578473 -122.387230532448 (37.7413185578473, -122.387230532448) 10 3 8 58 1
75271 16549 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 400X Newhall St 10 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6015994.10911 2097882.11034 37.7412827355083 -122.38727174751 (37.7412827355083, -122.38727174751) 10 3 8 58 1
328 197129 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 400 Newhall St 11 : Tree Private 2     5 Width 3ft   6015974.4503 2097856.83037 37.7412122331485 -122.387337958305 (37.7412122331485, -122.387337958305) 10 3 8 58 1
60469 6847 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 595X Newhall St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/11/2002 12:00:00 AM 3 3x3   6015962.97666 2097752.78836 37.7409259196071 -122.387370374337 (37.7409259196071, -122.387370374337) 10 3 8 58 1
19617 78383 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1490 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6015869.5519 2094203.8416 37.7311760546893 -122.387445886397 (37.7311760546893, -122.387445886397) 10 3 8 58 1
142465 6845 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 595X Newhall St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/16/1992 12:00:00 AM 6 3x3   6015936.9719 2097716.00593 37.7408234823092 -122.387457724609 (37.7408234823092, -122.387457724609) 10 3 8 58 1
140235 85629 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1490 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015857.024431 2094199.26405 37.7311627918046 -122.387488877238 (37.7311627918046, -122.387488877238) 10 3 8 58 1
176900 88478 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1514 McKinnon Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51430 6015856.3 2095628.5 37.7350871465747 -122.387591057509 (37.7350871465747, -122.387591057509) 10 3 8 58 1
175370 197130 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 400 Newhall St 16 : Tree Private 2     5 Width 3ft   6015893.18708 2097747.64492 37.7409079313583 -122.387611324313 (37.7409079313583, -122.387611324313) 10 3 8 58 1
29832 197131 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 400 Newhall St 17 : Tree Private 2     5 Width 3ft   6015885.54456 2097735.33833 37.740873716654 -122.38763689115 (37.740873716654, -122.38763689115) 10 3 8 58 1
66623 85652 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1519 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015655.7374 2094284.1377 37.7313846871586 -122.388190689138 (37.7313846871586, -122.388190689138) 10 3 8 58 1
150888 85630 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1518 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015608.4708 2094395.709 37.7316884205401 -122.388361884277 (37.7316884205401, -122.388361884277) 10 3 8 58 1
28575 54817 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1414 Underwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2007 12:00:00 AM 5 3x3 Permit Number 49953 6015568.3491 2093032.3958 37.7279428116622 -122.388405474303 (37.7279428116622, -122.388405474303) 10 3 8 58 1
49059 85653 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1541 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015555.708 2094360.5338 37.7315889126514 -122.388541843069 (37.7315889126514, -122.388541843069) 10 3 8 58 1
83082 16560 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 702X Newhall St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/03/1992 12:00:00 AM 12 3X3   6015615.61867 2097370.07413 37.7398558207833 -122.388544712683 (37.7398558207833, -122.388544712683) 10 3 8 58 1
97427 16561 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 702X Newhall St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/11/2006 12:00:00 AM 3 3X3   6015590.52894 2097333.28077 37.7397534032962 -122.388628895503 (37.7397534032962, -122.388628895503) 10 3 8 58 1
9955 71391 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1531 Kirkwood Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6015562.7322 2096452.7948 37.7373342278764 -122.388663558077 (37.7373342278764, -122.388663558077) 10 3 8 58 1
9184 88476 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1531 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51429 6015551.7 2096433.9 37.7372817351758 -122.388700383218 (37.7372817351758, -122.388700383218) 10 3 8 58 1
162397 73566 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1531 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/24/2008 12:00:00 AM 4 3x3 Permit Number 51073 6015551.1974 2096459.91912 37.7373531505315 -122.388703936761 (37.7373531505315, -122.388703936761) 10 3 8 58 1
192309 85631 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1556 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015497.489334 2094466.503619 37.7318766579731 -122.388750513143 (37.7318766579731, -122.388750513143) 10 3 8 58 1
9959 71411 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1556 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6015495.2506 2094478.7004 37.7319100238031 -122.388759104128 (37.7319100238031, -122.388759104128) 10 3 8 58 1
20465 193326 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1398 Tennessee St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6015584.37458 2102621.55349 37.754273559383 -122.389019303814 (37.754273559383, -122.389019303814) 10 3 8 28856 29
1933 193325 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1398 Tennessee St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6015584.15702 2102639.39931 37.7543225481714 -122.389021302106 (37.7543225481714, -122.389021302106) 10 3 8 28856 29
129779 253557 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1398 Tennessee St 5 Sidewalk: Curb side : Cutout Tree Private 2       Width 5ft   6015583.67362 2102658.40109 37.7543746962452 -122.389024300455 (37.7543746962452, -122.389024300455) 10 3 8 28856 29
193114 193324 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1398 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6015583.67362 2102658.40109 37.7543746962452 -122.389024300455 (37.7543746962452, -122.389024300455) 10 3 8 28856 29
58251 85632 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1582 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015365.5421 2094575.4322 37.7321684400373 -122.38921428964 (37.7321684400373, -122.38921428964) 10 3 8 58 1
42067 197079 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 690 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6015561.72583 2105828.91514 37.7630790337836 -122.389321587544 (37.7630790337836, -122.389321587544) 14 3 8 28856 29
67501 197080 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 690 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6015550.01358 2105828.21981 37.7630764752211 -122.389362048039 (37.7630764752211, -122.389362048039) 14 3 8 28856 29
166801 85633 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1590 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2007 12:00:00 AM 3 3x3   6015320.4739 2094608.4089 37.7322564888471 -122.389372403809 (37.7322564888471, -122.389372403809) 10 3 8 58 1
56120 200038 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1598 Lane St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6015316.6267 2094740.3159 37.7326184655785 -122.389394912765 (37.7326184655785, -122.389394912765) 10 3 8 58 1
98452 197081 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 690 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6015537.3565 2105827.07749 37.7630726369229 -122.389405745189 (37.7630726369229, -122.389405745189) 14 3 8 28856 29
30035 53150 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1499@ LANE Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/02/2006 12:00:00 AM     Permit Number 49076 6015286.17606683 2093519.24782482 37.7292639697355 -122.389414946979 (37.7292639697355, -122.389414946979) 10 3 8 58 1
40942 53148 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1499@ LANE Thomas Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   11/02/2006 12:00:00 AM     Permit Number 49076 6015286.17606683 2093519.24782482 37.7292639697355 -122.389414946979 (37.7292639697355, -122.389414946979) 10 3 8 58 1
42781 200039 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1598 Lane St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015308.9321 2094726.026 37.7325788017835 -122.38942051753 (37.7325788017835, -122.38942051753) 10 3 8 58 1
164051 197082 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 690 18th St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6015524.49345 2105827.33722 37.7630726369153 -122.389450252639 (37.7630726369153, -122.389450252639) 14 3 8 28856 29
126674 200040 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1598 Lane St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6015299.5887 2094715.0337 37.7325481011108 -122.389452052823 (37.7325481011108, -122.389452052823) 10 3 8 58 1
40672 199666 DPW Maintained 1 Pyrus kawakamii :: Evergreen Pear 83 1901 Keith St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6015268.2608 2093490.7724 37.7291847886233 -122.389474894337 (37.7291847886233, -122.389474894337) 10 3 8 58 1

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