7,322 rows where qSpecies_id = 1 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)
81417 10002 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 145 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   09/19/2014 12:50:00 PM 3 3X2   6005473.70519 2108134.2356 37.7688444498294 -122.424376646466 (37.7688444498294, -122.424376646466) 8 4 5 28853 19
128526 10003 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 145 Guerrero St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3X2   6005473.24802 2108147.80938 37.7688816943622 -122.424379193367 (37.7688816943622, -122.424379193367) 8 4 5 28853 19
162681 10010 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 174 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/16/2002 12:00:00 AM 6 3x3   6005413.24282 2107997.40019 37.7684653181587 -122.424576046874 (37.7684653181587, -122.424576046874) 8 4 5 28853 19
156977 100129 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 155 05th St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6011082.10119 2112775.22352 37.7819026320456 -122.405304366814 (37.7819026320456, -122.405304366814) 12 2 9 28853 34
181095 100130 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 155 05th St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6011065.09249 2112790.58254 37.7819438533601 -122.405364291326 (37.7819438533601, -122.405364291326) 12 2 9 28853 34
143498 100131 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 155 05th St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6011051.59118 2112804.91213 37.7819824441767 -122.405412009362 (37.7819824441767, -122.405412009362) 12 2 9 28853 34
70912 100132 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 155 05th St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6011001.43438 2112862.15185 37.7821368065155 -122.405589562524 (37.7821368065155, -122.405589562524) 12 2 9 28853 34
109349 100133 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 155 05th St 5 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6010986.38868 2112879.38733 37.7821832897709 -122.405642828459 (37.7821832897709, -122.405642828459) 12 2 9 28853 34
181514 100134 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 155 05th St 6 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6010970.10593 2112898.88439 37.782235913593 -122.405700533469 (37.782235913593, -122.405700533469) 12 2 9 28853 34
143275 100136 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 155 05th St 7 Sidewalk: Curb side : Cutout Tree Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6010957.25903 2112913.83939 37.7822762580963 -122.405746031954 (37.7822762580963, -122.405746031954) 12 2 9 28853 34
38359 100161 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1699 Vallejo St 3 Sidewalk: Curb side : Cutout Tree Private 2     2   Permit Number 28164 6005519.03005 2118189.86695 37.7964572951359 -122.424935391656 (37.7964572951359, -122.424935391656) 13 9 1 28858 27
115639 100162 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1699 Vallejo St 4 Sidewalk: Curb side : Cutout Tree Private 2     3   Permit Number 28164 6005532.34096 2118193.08724 37.7964668890905 -122.424889562218 (37.7964668890905, -122.424889562218) 13 9 1 28858 27
166798 10017 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 240 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/24/2012 12:00:00 AM 1 3x3   6005435.61743 2107572.1515 37.7672989505107 -122.424468403392 (37.7672989505107, -122.424468403392) 8 4 5 28853 19
106283 100202 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 2389 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2012 12:00:00 AM     Permit Number 768863 6003320.6 2116507.6 37.79171379901 -122.432422214141 (37.79171379901, -122.432422214141) 13 9 1 29490 27
8493 10021 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 274 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/01/2018 12:00:00 AM 3 3x4   6005443.44254 2107417.66285 37.7668752034469 -122.424430347706 (37.7668752034469, -122.424430347706) 8 4 5 28853 19
150376 100333 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1X Gorham St 1 Sidewalk: Curb side : Cutout Tree Private 2       2x7   6002317.2 2094130.8 37.7302155808393 -122.43429348768 (37.7302155808393, -122.43429348768) 9 7 5 28861 25
19766 100334 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1X Gorham St 2 Sidewalk: Curb side : Cutout Tree Private 2       2x9   6002317.2 2094130.8 37.7302155808393 -122.43429348768 (37.7302155808393, -122.43429348768) 9 7 5 28861 25
51584 100335 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1X Gorham St 3 Sidewalk: Curb side : Cutout Tree Private 2       2x9   6002317.2 2094130.8 37.7302155808393 -122.43429348768 (37.7302155808393, -122.43429348768) 9 7 5 28861 25
123523 100336 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1X Gorham St 4 Sidewalk: Curb side : Cutout Tree Private 2       2x9   6002317.2 2094130.8 37.7302155808393 -122.43429348768 (37.7302155808393, -122.43429348768) 9 7 5 28861 25
137389 100337 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1X Gorham St 5 Sidewalk: Curb side : Cutout Tree Private 2       2x3 Permit Number 769202 6002317.2 2094130.8 37.7302155808393 -122.43429348768 (37.7302155808393, -122.43429348768) 9 7 5 28861 25
55586 100388 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2155 Turk Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   08/14/2012 12:00:00 AM 1 3x3 Permit Number 769083 5999725.3 2111817.6 37.7786317516959 -122.444524668182 (37.7786317516959, -122.444524668182) 15 5 11 29490 16
6355 100391 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 226 Paris St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x7   6002817 2092256 37.7250961583897 -122.432431760897 (37.7250961583897, -122.432431760897) 9 7 6 28861 5
130223 10046 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 380 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6005478.63749 2106816.50174 37.7652265455926 -122.424265853604 (37.7652265455926, -122.424265853604) 8 4 5 28853 19
119544 10047 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 380 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/13/2009 12:00:00 AM 8 3X3   6005478.32549 2106801.33005 37.765184870121 -122.424265853606 (37.765184870121, -122.424265853606) 8 4 5 28853 19
123095 10048 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 388 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/12/2014 12:00:00 AM 3 3X3   6005479.4973627 2106724.9559124 37.7649752310589 -122.424256368065 (37.7649752310589, -122.424256368065) 8 4 5 28853 19
147500 10051 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 398 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/11/2009 12:00:00 AM 16 3X3   6005480.85974 2106714.7911 37.7649473978257 -122.424250932944 (37.7649473978257, -122.424250932944) 8 4 5 28853 19
26263 10052 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 394 Guerrero St 3 Sidewalk: Curb side : Cutout Tree DPW 1   09/02/2005 12:00:00 AM 16 3X3   6005485.0846607 2106684.1712003 37.7648635614138 -122.424234142103 (37.7648635614138, -122.424234142103) 8 4 5 28853 19
186675 100522 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 2601 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6008910 2103320 37.7558191060193 -122.412150412844 (37.7558191060193, -122.412150412844) 2 4 7 28859 19
24342 10056 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 439 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/30/2006 12:00:00 AM 3 2X3   6005568.60446 2106406.01672 37.7641045307279 -122.423925487175 (37.7641045307279, -122.423925487175) 8 4 5 28859 19
103153 100575 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 3020 Washington St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/04/2012 12:00:00 AM   3x3 Permit Number 769157 6000252 2116146 37.7905464587755 -122.443013541289 (37.7905464587755, -122.443013541289) 13 6 1 29490 27
33482 10062 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 497 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/08/1997 12:00:00 AM 3 3X3   6005580.9933972 2106078.9124418 37.7632070792286 -122.423859376385 (37.7632070792286, -122.423859376385) 8 4 5 28859 19
68763 10063 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 504 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/30/2006 12:00:00 AM 6 3X3   6005521.76358 2106001.34506 37.7629907536385 -122.424058716358 (37.7629907536385, -122.424058716358) 8 4 5 28859 19
174695 10065 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 519 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/30/2006 12:00:00 AM 3 2X3   6005594.51242 2105932.67599 37.7628063116858 -122.423802219811 (37.7628063116858, -122.423802219811) 8 4 5 28859 19
82532 10066 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 524 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2010 12:00:00 AM 3 3X3   6005528.41421 2105906.00101 37.7627293369086 -122.42402893349 (37.7627293369086, -122.42402893349) 8 4 5 28859 19
36953 10067 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 545 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/19/1992 12:00:00 AM 6 3x3   6005600.27416 2105821.78074 37.7625021447809 -122.423774406467 (37.7625021447809, -122.423774406467) 8 4 5 28859 19
98229 1007 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1827 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/06/2006 12:00:00 AM 10 3X3   6001335.27273 2091591.54514 37.7231875827374 -122.437506364337 (37.7231875827374, -122.437506364337) 9 7 6 28861 25
42694 10070 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 550 Guerrero St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 3X4   6005536.09586 2105703.84797 37.7621747061057 -122.423987989174 (37.7621747061057, -122.423987989174) 8 4 5 28859 19
76438 10080 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 629 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/18/1998 12:00:00 AM 3 2x2   6005634.7584694 2105309.7909765 37.76109828818 -122.423618734472 (37.76109828818, -122.423618734472) 2 4 5 28859 19
173898 10086 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 653 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/21/1996 12:00:00 AM 6 3X3   6005638.59393 2105174.60724 37.7607273219395 -122.423595857781 (37.7607273219395, -122.423595857781) 2 4 5 28859 19
83562 10092 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 708 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/27/2009 12:00:00 AM 6 3X3   6005588.90911 2104804.48181 37.7597082398685 -122.423741377976 (37.7597082398685, -122.423741377976) 2 4 5 28859 19
175058 10093 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 721 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/18/1997 12:00:00 AM 3 2X2   6005660.10445 2104755.09426 37.7595766519684 -122.423491637128 (37.7595766519684, -122.423491637128) 2 4 5 28859 19
49466 10094 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 718 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 2X3   6005593.36455 2104752.70261 37.759566317848 -122.423722287162 (37.759566317848, -122.423722287162) 2 4 5 28859 19
129274 10108 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 799X Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2014 06:48:00 AM 3 3x3   6005680.61411 2104397.9808 37.7585972596694 -122.423395317067 (37.7585972596694, -122.423395317067) 2 4 5 28859 19
46852 10109 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 807 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2014 12:00:00 AM 2 3x6   6005690.64119 2104252.82969 37.7581992745969 -122.423350320365 (37.7581992745969, -122.423350320365) 2 4 5 28859 19
39898 10120 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 851 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/30/2006 12:00:00 AM 3 3X3   6005704.55717 2103950.70668 37.7573705007718 -122.423280716426 (37.7573705007718, -122.423280716426) 2 4 5 28859 19
60487 101205 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 800X Illinois St 1 Sidewalk: Property side : Yard Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769306 6015895.4 2105131.7 37.7611831239758 -122.388118852688 (37.7611831239758, -122.388118852688) 10 3 8 28856 29
148512 101206 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 800X Illinois St 2 Sidewalk: Property side : Yard Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769306 6015895.4 2105131.7 37.7611831239758 -122.388118852688 (37.7611831239758, -122.388118852688) 10 3 8 28856 29
1125 101207 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 800X Illinois St 3 Sidewalk: Property side : Yard Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769306 6015895.4 2105131.7 37.7611831239758 -122.388118852688 (37.7611831239758, -122.388118852688) 10 3 8 28856 29
11388 101208 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 800X Illinois St 4 Sidewalk: Property side : Yard Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769306 6015895.4 2105131.7 37.7611831239758 -122.388118852688 (37.7611831239758, -122.388118852688) 10 3 8 28856 29
56445 101209 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 800X Illinois St 5 Sidewalk: Property side : Yard Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769306 6015895.4 2105131.7 37.7611831239758 -122.388118852688 (37.7611831239758, -122.388118852688) 10 3 8 28856 29
65639 101210 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 800X Illinois St 6 Sidewalk: Property side : Yard Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769306 6015895.4 2105131.7 37.7611831239758 -122.388118852688 (37.7611831239758, -122.388118852688) 10 3 8 28856 29
17820 101211 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 800X Illinois St 7 Sidewalk: Property side : Yard Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769306 6015895.4 2105131.7 37.7611831239758 -122.388118852688 (37.7611831239758, -122.388118852688) 10 3 8 28856 29
151335 101212 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 800X Illinois St 8 Sidewalk: Property side : Yard Tree Private 2   10/03/2012 12:00:00 AM     Permit Number 769306 6015895.4 2105131.7 37.7611831239758 -122.388118852688 (37.7611831239758, -122.388118852688) 10 3 8 28856 29
144105 10122 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 862 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/08/1997 12:00:00 AM 24 3X4   6005637.76588 2103917.84087 37.7572764892318 -122.423509370882 (37.7572764892318, -122.423509370882) 2 4 5 28859 19
42286 101263 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2000 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 20727 5989478.8752 2106534.6445 37.7635362196488 -122.479583963683 (37.7635362196488, -122.479583963683) 1 8 3 56 35
181267 101264 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2000 Irving St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3 Permit Number 20727 5989453.6006 2106533.1127 37.7635305455459 -122.479671267422 (37.7635305455459, -122.479671267422) 1 8 3 56 35
5881 101267 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2230 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/25/2019 06:01:00 PM 3 3x3   5988779 2106526 37.7634718046826 -122.482003947791 (37.7634718046826, -122.482003947791) 1 8 3 56 35
14973 101277 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2333 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/25/2019 05:53:00 PM 3 3x3   5988461 2106418 37.7631567663104 -122.483095878101 (37.7631567663104, -122.483095878101) 1 8 3 56 35
7361 101278 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 2323 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   5988461 2106418 37.7631567663104 -122.483095878101 (37.7631567663104, -122.483095878101) 1 8 3 56 35
97304 101311 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 4244X 19th St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     5 3x3   6001912 2104709 37.7592378221466 -122.436451128899 (37.7592378221466, -122.436451128899) 2 4 5 28862 3
128851 10144 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 920 Guerrero St 2 Sidewalk: Curb side : Cutout Tree DPW 1   05/06/2011 12:00:00 AM 3 2x3   6005658.62572 2103547.83007 37.7562617032323 -122.423410925679 (37.7562617032323, -122.423410925679) 2 4 5 28859 19
24121 10145 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 925 Guerrero St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2003 12:00:00 AM 3 2X2   6005726.06335 2103597.33659 37.756401442588 -122.423181221762 (37.756401442588, -122.423181221762) 2 4 5 28859 19
69069 101525 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 630 28th St 1 Sidewalk: Property side : Yard Tree Private 2     8   15 ft wide public RoW 6001829 2099440 37.7447656902201 -122.436361083968 (37.7447656902201, -122.436361083968) 2 7 5 63 22
82873 101639 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 689X Amazon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002123.8 2088649.6 37.7151544566445 -122.434570326444 (37.7151544566445, -122.434570326444) 9 7 6 28861 5
118128 101640 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 689X Amazon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002123.8 2088649.6 37.7151544566445 -122.434570326444 (37.7151544566445, -122.434570326444) 9 7 6 28861 5
86799 101641 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 689X Amazon Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002123.8 2088649.6 37.7151544566445 -122.434570326444 (37.7151544566445, -122.434570326444) 9 7 6 28861 5
142602 101642 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 689X Amazon Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002123.8 2088649.6 37.7151544566445 -122.434570326444 (37.7151544566445, -122.434570326444) 9 7 6 28861 5
3957 101709 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 95X Milton St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003767.7 2095277.7 37.7334469335284 -122.429360672359 (37.7334469335284, -122.429360672359) 2 7 5 28861 25
175232 10173 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1037 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/30/2006 12:00:00 AM 3 3X3   6005774.28865 2102689.40926 37.7539112063372 -122.422949914307 (37.7539112063372, -122.422949914307) 2 4 5 28859 19
100893 10175 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1070 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/18/2010 12:00:00 AM 4 3x3 Permit Number 53293 6005702.26753 2102743.9562 37.7540569153999 -122.423202857623 (37.7540569153999, -122.423202857623) 2 4 5 28859 19
30435 10176 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1070 Guerrero St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/18/2010 12:00:00 AM 0 3x3 Permit Number 53294 6005702.26311 2102736.9430799 37.7540376587481 -122.423202374429 (37.7540376587481, -122.423202374429) 2 4 5 28859 19
4039 101850 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1001X Rhode Island St 4 Sidewalk: Property side : Cutout Tree Private 2   12/31/2015 12:00:00 AM 2 3x3 Permit Number 774983 6011937.4679 2103668.00433 37.7569440557359 -122.401704847401 (37.7569440557359, -122.401704847401) 10 3 8 28856 29
14072 10189 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1153 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/11/2017 12:00:00 AM 3 6x3   6005799.04863 2102230.07657 37.7526513820654 -122.42283164627 (37.7526513820654, -122.42283164627) 2 4 5 28859 19
146692 1019 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1868 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/13/1997 12:00:00 AM 12 3X3   6001068.28081 2091265.41408 37.7222769175205 -122.43840594717 (37.7222769175205, -122.43840594717) 9 7 6 28861 25
92652 10195 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1180 Guerrero St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/02/2015 04:22:00 PM 3 3x6   6005739.80386 2102077.08929 37.7522279713474 -122.423025652538 (37.7522279713474, -122.423025652538) 2 4 5 28859 19
20806 102022 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
177368 102023 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
38321 102024 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
76443 102025 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
185959 102026 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 6 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
129482 102027 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 7 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
19907 102028 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 8 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
130000 102029 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 9 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
48405 102030 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 10 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
167233 102031 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
113529 102032 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 12 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
35858 102033 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 13 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
135552 102034 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 165X Chattanooga St 14 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6004753 2102714 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656) 2 4 5 28862 22
21152 102108 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 160 25th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   03/13/2013 12:00:00 AM 1 3x3 Permit Number 770061 5988061.62738 2114927.67902 37.7864987186466 -122.485101549027 (37.7864987186466, -122.485101549027) 11 6 1 55 33
39569 10213 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1327 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/15/1990 12:00:00 AM 12 3X2   6005854.70152 2101246.55323 37.7499539932788 -122.422569305951 (37.7499539932788, -122.422569305951) 2 4 5 28859 19
144976 102133 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 400 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/24/2015 12:00:00 AM 1 3x3 Permit Number 769373 6015280.6913 2114587.07549 37.7871114100137 -122.390905733419 (37.7871114100137, -122.390905733419) 6 2 9 28855 6
34844 102134 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 400 Beale St 3 Sidewalk: Curb side : Cutout Tree Housing Authority 15 Private 11/24/2015 12:00:00 AM 1 3x3 Permit Number 769373 6015285.47231 2114577.79035 37.7870861804203 -122.390888542866 (37.7870861804203, -122.390888542866) 6 2 9 28855 6
99295 10226 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1401 Guerrero St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6005881.42321 2100761.4578 37.7486235398515 -122.422442436769 (37.7486235398515, -122.422442436769) 2 4 5 28859 19
148326 102285 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 106 Hoffman Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4x4   6000567.8 2102477.2 37.7530333697051 -122.440939902641 (37.7530333697051, -122.440939902641) 2 4 5 28862 22
159742 102303 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 767 Corbett Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2013 12:00:00 AM 4 3x3 Permit Number 770010 6000230.9 2103020.8 37.7545067693378 -122.442143982636 (37.7545067693378, -122.442143982636) 2 5 5 63 38
52361 102306 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1320 Stevenson St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006027 2108860 37.7708684537788 -122.422514413679 (37.7708684537788, -122.422514413679) 8 2 9 28853 19
63059 102307 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1320 Stevenson St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006027 2108860 37.7708684537788 -122.422514413679 (37.7708684537788, -122.422514413679) 8 2 9 28853 19
147395 102308 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1320 Stevenson St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006027 2108860 37.7708684537788 -122.422514413679 (37.7708684537788, -122.422514413679) 8 2 9 28853 19
170222 102309 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1320 Stevenson St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006027 2108860 37.7708684537788 -122.422514413679 (37.7708684537788, -122.422514413679) 8 2 9 28853 19
118816 102311 Undocumented 4 Tristaniopsis laurina :: Swamp Myrtle 1 1330 Stevenson St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006027 2108860 37.7708684537788 -122.422514413679 (37.7708684537788, -122.422514413679) 8 2 9 28853 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)
);