trees

979 rows where qSpecies_id = 13 sorted by Supervisor Districts descending

✎ View and edit SQL

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)
2106 193374 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 778 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6008975.96564 2110229.86919 37.7747957152898 -122.412410677425 (37.7747957152898, -122.412410677425) 8 2 9 28853 34
3743 193316 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 136 Hawthorne St 2 : Tree Private 2     9 Width 2ft   6013300.83104 2113672.81478 37.7844910077044 -122.397691511273 (37.7844910077044, -122.397691511273) 6 2 9 28856 6
5290 89193 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
5638 89169 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
9218 106080 Significant Tree 6 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 188 The Embarcadero 1 Front Yard : Yard Tree Private 2   03/20/2014 12:00:00 AM     Permit Number 771259 6015087.8131 2116516.98611 37.7923997963133 -122.391708043282 (37.7923997963133, -122.391708043282) 12 2 9 28855 6
19852 33783 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013842.92338 2116188.62598 37.7914290137913 -122.395992405042 (37.7914290137913, -122.395992405042) 12 2 9 28855 6
21421 193318 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 136 Hawthorne St 4 : Tree Private 2     10 Width 2ft   6013332.96782 2113640.49809 37.7844040630434 -122.397578060899 (37.7844040630434, -122.397578060899) 6 2 9 28856 6
23205 81367 Undocumented 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1001 Polk St 1 Sidewalk: Curb side : Pot Tree Private 2   11/08/2003 12:00:00 AM   3x3   6006914.85774282 2114314.60875621 37.7858955407321 -122.419830397182 (37.7858955407321, -122.419830397182) 13 9 9 28858 36
24096 105848 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 790 Tehama St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6008900 2110136 37.7745337092857 -122.412666821872 (37.7745337092857, -122.412666821872) 8 2 9 28853 34
27143 193373 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 10 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6013783.27133 2116255.65231 37.7916097334637 -122.396203501097 (37.7916097334637, -122.396203501097) 12 2 9 28855 6
37097 193317 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 136 Hawthorne St 3 : Tree Private 2     9 Width 2ft   6013319.34244 2113654.62795 37.7844421016727 -122.397626191699 (37.7844421016727, -122.397626191699) 6 2 9 28856 6
38386 89162 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2008 12:00:00 AM   3x3 Permit Number 51807 6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
45307 85039 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 740 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2007 12:00:00 AM 1 3x3 Permit Number 49387 6008855.33926 2110725.28618 37.7761492435388 -122.412862984239 (37.7761492435388, -122.412862984239) 8 2 9 28853 34
55630 95830 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 5 Lucerne St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/29/2011 12:00:00 AM   3x3 Permit Number 767564 6011975 2109856 37.7739369979495 -122.402010048031 (37.7739369979495, -122.402010048031) 14 2 9 28853 34
58046 107963 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 33 03rd St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770900 6011844.7795 2114609.58385 37.7869819669901 -122.402794885102 (37.7869819669901, -122.402794885102) 12 2 9 28853 6
60421 112587 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 790 Tehama St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008900 2110136 37.7745337092857 -122.412666821872 (37.7745337092857, -122.412666821872) 8 2 9 28853 34
65644 109906 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1415 Howard St 3 Sidewalk: Curb side : Cutout Tree DPW 1     1 3x3   6008272.88194 2109795.90835 37.7735646809973 -122.414812077722 (37.7735646809973, -122.414812077722) 8 2 9 28853 34
66699 193377 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 250 10th St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2018 12:00:00 AM 3 Width 3ft   6008648.26214 2109663.47426 37.7732221328357 -122.413504208979 (37.7732221328357, -122.413504208979) 8 2 9 28853 34
67172 193355 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 60 Main St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6013990.6766 2116456.52969 37.7921728340575 -122.395499955167 (37.7921728340575, -122.395499955167) 12 2 9 28855 6
81471 33774 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013834.28126 2116198.48682 37.7914556085404 -122.396022998165 (37.7914556085404, -122.396022998165) 12 2 9 28855 6
90120 193368 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 262 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6013947.27528 2116186.44855 37.7914288402078 -122.395631194149 (37.7914288402078, -122.395631194149) 12 2 9 28855 6
90501 193371 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 264 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6013926.24547 2116163.52102 37.791364716756 -122.395702350277 (37.791364716756, -122.395702350277) 12 2 9 28855 6
91046 89190 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
95844 193362 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 246 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6014011.61838 2116245.86436 37.7915955610366 -122.395412730824 (37.7915955610366, -122.395412730824) 12 2 9 28855 6
97909 33782 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013852.02109 2116179.41654 37.7914042329729 -122.395960281264 (37.7914042329729, -122.395960281264) 12 2 9 28855 6
100555 89164 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2008 12:00:00 AM   3x3 Permit Number 51807 6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
103563 193357 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 62 Main St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6014010.13309 2116432.89008 37.7921090073852 -122.395430978058 (37.7921090073852, -122.395430978058) 12 2 9 28855 6
104923 33800 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013865.37275 2116161.97621 37.7913570887062 -122.395912861799 (37.7913570887062, -122.395912861799) 12 2 9 28855 6
109890 89170 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
110549 193372 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 9 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6013792.54079 2116244.01793 37.7915783039417 -122.39617061289 (37.7915783039417, -122.39617061289) 12 2 9 28855 6
115148 193365 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 260 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   6013979.60171 2116214.89575 37.7915087476865 -122.395521338359 (37.7915087476865, -122.395521338359) 12 2 9 28855 6
119007 109908 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1401 Howard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   07/18/2015 02:04:00 PM 3 3x3 Permit Number 778313 6008340.42119 2109862.66125 37.7737517633724 -122.414583173274 (37.7737517633724, -122.414583173274) 8 2 9 28853 34
124343 89194 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
131765 89188 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
131934 193363 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 246 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6014000.9996 2116238.17517 37.7915738577077 -122.395448933038 (37.7915738577077, -122.395448933038) 12 2 9 28855 6
132863 193366 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 260 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6013970.03568 2116205.74836 37.7914830990039 -122.395553795767 (37.7914830990039, -122.395553795767) 12 2 9 28855 6
134517 33792 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013856.54517 2116173.60161 37.7913885182281 -122.395944220262 (37.7913885182281, -122.395944220262) 12 2 9 28855 6
134523 193361 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 246 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6014025.95999 2116259.22664 37.7916330483898 -122.395364045136 (37.7916330483898, -122.395364045136) 12 2 9 28855 6
138815 193376 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 778 Tehama St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6008940.99117 2110196.43665 37.7747019546579 -122.41252929799 (37.7747019546579, -122.41252929799) 8 2 9 28853 34
139876 89172 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
143967 89185 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
145435 193364 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 260 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6013990.63933 2116225.45086 37.7915383434816 -122.395483887876 (37.7915383434816, -122.395483887876) 12 2 9 28855 6
146551 193370 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 262 Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6013935.48002 2116174.11264 37.7913943125596 -122.39567114113 (37.7913943125596, -122.39567114113) 12 2 9 28855 6
147236 193369 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 262 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6013943.1918 2116180.78279 37.7914130562087 -122.395644925876 (37.7914130562087, -122.395644925876) 12 2 9 28855 6
147690 193356 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 60 Main St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6014000.33626 2116445.25726 37.7921424198756 -122.395465742269 (37.7921424198756, -122.395465742269) 12 2 9 28855 6
152829 89184 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
154921 193359 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 208 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6014052.91282 2116289.57894 37.7917178877279 -122.395272915033 (37.7917178877279, -122.395272915033) 12 2 9 28855 6
155829 89192 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 9 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2008 12:00:00 AM   3x3 Permit Number 51807 6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
165807 193375 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 778 Tehama St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6008954.62424 2110209.13379 37.7747375831097 -122.412483035979 (37.7747375831097, -122.412483035979) 8 2 9 28853 34
166081 89187 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
166371 31608 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 5 Lucerne St 5 Sidewalk: Curb side : Cutout Tree Private 2   06/06/1995 12:00:00 AM 4   Permit Number 35133 6012020.8525 2109827.45516 37.7738611793697 -122.401849428724 (37.7738611793697, -122.401849428724) 14 2 9 28853 34
169387 89171 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
169485 33779 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 8 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013803.37475 2116233.23226 37.7915492918181 -122.396132371028 (37.7915492918181, -122.396132371028) 12 2 9 28855 6
170760 193358 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 62 Main St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6014021.3474 2116423.46881 37.7920837625026 -122.395391515812 (37.7920837625026, -122.395391515812) 12 2 9 28855 6
173449 193315 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 136 Hawthorne St 1 : Tree Private 2     9 Width 2ft   6013291.13873 2113684.88595 37.7845236126199 -122.39772589056 (37.7845236126199, -122.39772589056) 6 2 9 28856 6
175026 33785 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 7 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013812.6799 2116223.3583 37.7915226979635 -122.396099482817 (37.7915226979635, -122.396099482817) 12 2 9 28855 6
176468 89189 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
179834 99959 Undocumented 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 19 Rausch St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2014 12:00:00 AM 28 3x3 Permit Number 772856 6009640 2110980 37.776892640268 -122.410166607108 (37.776892640268, -122.410166607108) 8 2 9 28853 34
182336 33780 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 77 Beale St 6 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 774395 6013824.14126 2116210.79912 37.7914888510795 -122.39605894586 (37.7914888510795, -122.39605894586) 12 2 9 28855 6
183737 193360 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 208 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6014042.14131 2116274.34783 37.7916754675957 -122.395309117238 (37.7916754675957, -122.395309117238) 12 2 9 28855 6
184577 89191 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
187279 193367 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 262 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6013957.97413 2116198.08841 37.7914613956649 -122.395594991931 (37.7914613956649, -122.395594991931) 12 2 9 28855 6
193757 105847 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 790 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6008900 2110136 37.7745337092857 -122.412666821872 (37.7745337092857, -122.412666821872) 8 2 9 28853 34
895 56729 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1547 McKinnon Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/26/2012 12:00:00 AM 5   Permit Number 769649 6015653.0224 2095684.4557 37.7352295280363 -122.388297771341 (37.7352295280363, -122.388297771341) 10 3 8 58 1
2501 78191 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 680 Tennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6015407.71241 2105894.14692 37.7632496064147 -122.389858829046 (37.7632496064147, -122.389858829046) 14 3 8 28856 29
8067 106254 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1912X 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3 Permit Number 770844 6012043 2105629 37.7623344042956 -122.401477690357 (37.7623344042956, -122.401477690357) 8 3 8 28856 29
9101 149740 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 600 San Bruno Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     0 5x5   6010932.22924 2105459.16725 37.7618060416252 -122.405307491047 (37.7618060416252, -122.405307491047) 10 3 8 28856 29
9598 99292 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1300 Minnesota St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/01/2012 12:00:00 AM   3x3 Permit Number 768897 6015320.4 2102511.6 37.753957014382 -122.389924521932 (37.753957014382, -122.389924521932) 10 3 8 28856 29
10033 80634 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 577 Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6013018.0309 2104352.7115 37.7588843520526 -122.398015861652 (37.7588843520526, -122.398015861652) 10 3 8 28856 29
11103 149739 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 600 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 5x5   6010931.02944 2105481.85704 37.7618682756098 -122.405313238612 (37.7618682756098, -122.405313238612) 10 3 8 28856 29
12319 149738 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 600 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 5x5   6010928.54307 2105503.65431 37.7619279870025 -122.405323373095 (37.7619279870025, -122.405323373095) 10 3 8 28856 29
12863 154063 Private 9 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1781 La Salle Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/13/2020 12:00:00 AM 3 4x3 Permit Number 782693 6014599.10763 2096821.84485 37.7382941111836 -122.392021081628 (37.7382941111836, -122.392021081628) 10 3 8 58 1
15129 102443 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 514 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2013 12:00:00 AM 1   Permit Number 770339 6013518.76597 2104573.81866 37.7595193399709 -122.396299571184 (37.7595193399709, -122.396299571184) 10 3 8 28856 29
16524 84225 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1361 Brussels St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM   3x3 Permit Number 50686 6011917.47723073 2088615.29524593 37.7156113688947 -122.400716532679 (37.7156113688947, -122.400716532679) 10 7 8 309 39
16696 195151 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1912 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   6012043 2105629 37.7623344042956 -122.401477690357 (37.7623344042956, -122.401477690357) 8 3 8 28856 29
18550 116935 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1275 Minnesota St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 5x5   6015368.35588 2102637.50716 37.7543053881926 -122.389767471397 (37.7543053881926, -122.389767471397) 10 3 8 28856 29
20416 17382 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1627 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2015 12:00:00 AM 1 3X3 Permit Number 776412 6014690.32946 2095358.97831 37.7342824432881 -122.39160343105 (37.7342824432881, -122.39160343105) 10 3 8 58 1
22156 150165 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1091 19th St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2018 12:00:00 AM 3 Width 3ft   6014460.64342 2105255.76526 37.7614441832169 -122.39308978288 (37.7614441832169, -122.39308978288) 10 3 8 28856 29
24379 84492 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1726 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/22/2008 12:00:00 AM 6 3x3 Permit Number 50144 6014424.88297 2094914.9156 37.733048399857 -122.392490121246 (37.733048399857, -122.392490121246) 10 3 8 58 1
25069 193337 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1270 Minnesota St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6015308.47907 2102559.27559 37.7540872603324 -122.389969077812 (37.7540872603324, -122.389969077812) 10 3 8 28856 29
26858 193333 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1258 Minnesota St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6015305.27356 2102653.19148 37.7543449556813 -122.389986723422 (37.7543449556813, -122.389986723422) 10 3 8 28856 29
26944 105800 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 207 Raymond Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/27/2014 12:00:00 AM 3   Permit Number 769635 6010004.04754 2087785.06673 37.71322482385 -122.407271751589 (37.71322482385, -122.407271751589) 9 7 8 309 39
30093 98453 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 518 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2012 12:00:00 AM 2 3x3 Permit Number 768642 6014340.87186 2104676.45619 37.7598468721503 -122.393463482668 (37.7598468721503, -122.393463482668) 10 3 8 28856 29
30764 97025 Property Tree 8 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 195B Kiska Rd   Sidewalk: Property side : Cutout Tree Housing Authority 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
32359 193327 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1398 Tennessee St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   6015585.42977 2102602.25227 37.7542206208044 -122.389014307158 (37.7542206208044, -122.389014307158) 10 3 8 28856 29
32889 193331 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1258 Minnesota St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6015302.57075 2102682.83592 37.754426203129 -122.38999814121 (37.754426203129, -122.38999814121) 10 3 8 28856 29
33479 116924 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 900x 24th St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 5x5   6015542.44799 2102559.60008 37.7541011242826 -122.389159972153 (37.7541011242826, -122.389159972153) 10 3 8 28856 29
34828 116927 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 900x 24th St 6 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 5x5   6015494.24319 2102557.91546 37.7540938262957 -122.389326559889 (37.7540938262957, -122.389326559889) 10 3 8 28856 29
39534 8225 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1500X Galvez Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1   12/10/2015 08:37:00 AM 3 3x3   6016396.247314 2097296.3974116 37.7396967491289 -122.385840466933 (37.7396967491289, -122.385840466933) 10 3 8 58 1
40064 84782 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 228 Mississippi St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2007 12:00:00 AM 5   Permit No. 49243 6013990.15625 2105982.37522 37.7634131481085 -122.394767902514 (37.7634131481085, -122.394767902514) 14 3 8 28856 29
41578 193336 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1270 Minnesota St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6015307.25652 2102573.04925 37.7541250120819 -122.389974267815 (37.7541250120819, -122.389974267815) 10 3 8 28856 29
43703 106256 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1928 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3 Permit Number 770844 6011999 2105627 37.7623264575812 -122.401629730256 (37.7623264575812, -122.401629730256) 8 3 8 28856 29
45035 88479 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1751 Newcomb Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM 3 3x3 Permit Number 51431 6014386 2096253.8 37.7367225430205 -122.392718181551 (37.7367225430205, -122.392718181551) 10 3 8 58 1
45858 88076 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 674 Thornton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/24/2008 12:00:00 AM 5 3x3 Permit Number 51071 6011923.03733 2094336.64392 37.7313213328046 -122.401099095547 (37.7313213328046, -122.401099095547) 10 3 8 58 1
47704 108089 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2501X 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2014 12:00:00 AM 3   Permit Number 773081 6010157.47788 2105483.07585 37.7618283430246 -122.407988746007 (37.7618283430246, -122.407988746007) 10 4 8 28859 19
48719 116933 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1275 Minnesota St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 5x5   6015369.14789 2102590.92817 37.7541775360745 -122.389761479208 (37.7541775360745, -122.389761479208) 10 3 8 28856 29
48899 84780 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 224 Mississippi St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/18/2007 12:00:00 AM 4   Permit No. 49287 6013987.25375 2106041.39506 37.7635750422708 -122.394782074949 (37.7635750422708, -122.394782074949) 14 3 8 28856 29
49171 94884 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2010 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM 5 3x3 Permit Number 53951 6013072.55459 2096282.04692 37.736727066797 -122.397261344859 (37.736727066797, -122.397261344859) 10 3 8 58 1
50336 94885 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2010 Quesada Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53951 6013050.0613 2096298.08413 37.736769849332 -122.397340238786 (37.736769849332, -122.397340238786) 10 3 8 58 1
52659 6741 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1300X Fairfax Ave 11 Sidewalk: Curb side : Cutout Tree DPW 1   04/10/2017 01:50:00 PM 3 3x3   6016924.03316 2097256.88159 37.7396174392826 -122.384012840031 (37.7396174392826, -122.384012840031) 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)
);