trees
7,322 rows where qSpecies_id = 1 sorted by TreeID
This data as json, CSV (advanced)
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );