trees

979 rows where qSpecies_id = 13 sorted by Zip Codes

✎ 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)
5226 259803 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 199x Harkness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
12808 254368 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 590X Orizaba Ave 1 Back Yard : Yard Tree Private 2   02/06/2018 12:00:00 AM 3   Permit Number 778929                    
15038 259861 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 201x Wilde Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
15229 259804 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 199x Harkness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
15796 260912 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 99x Belvedere St   Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/21/2019 12:00:00 AM 3                        
19358 259860 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 201x Wilde Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/30/2019 12:00:00 AM 3                        
37 264963 Section 806 (d) 5 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 275 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2020 12:00:00 AM 3 3x3   6005706 2110306 37.7748207071365 -122.423727591769 (37.7748207071365, -122.423727591769) 7 9 11 28852 10
4723 259742 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 259 Page St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/11/2019 12:00:00 AM 3     6005340.35583 2109906.90312 37.7737042366543 -122.424964031136 (37.7737042366543, -122.424964031136) 7 9 11 28852 10
31341 230282 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 175 Haight St 1 : Tree Private 2     3 Width 3ft   6005285.87309 2109545.94561 37.7727100570619 -122.425126806975 (37.7727100570619, -122.425126806975) 7 9 11 28852 10
60800 230281 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 185 Haight St 1 : Tree Private 2     3 Width 3ft   6005261.48002 2109543.28647 37.772701377697 -122.425210996096 (37.772701377697, -122.425210996096) 7 9 11 28852 10
123403 94055 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 179 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/22/2010 12:00:00 AM 3 3x9   6005293.28741 2109516.64513 37.7726300238656 -122.42509907481 (37.7726300238656, -122.42509907481) 7 9 11 28852 10
138906 230279 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 529 Buchanan St 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   6004554.65684 2110370.74902 37.774933432055 -122.427714942505 (37.774933432055, -122.427714942505) 7 9 11 28852 10
142902 47067 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 604 Webster St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/28/2012 12:00:00 AM 1   Permit Number 768780 6004041.40702 2110873.30571 37.7762842830232 -122.429526231047 (37.7762842830232, -122.429526231047) 7 9 11 28852 10
149181 47068 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 604 Webster St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/28/2012 12:00:00 AM 1   Permit Number 768780 6004042.80919 2110860.8938 37.7762502823647 -122.429520495178 (37.7762502823647, -122.429520495178) 7 9 11 28852 10
180960 94054 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 185 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/22/2010 12:00:00 AM 3 3x9   6005268.81764 2109524.34557 37.7726497850887 -122.425184266439 (37.7726497850887, -122.425184266439) 7 9 11 28852 10
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
4490 224675 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 121 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6007745.9196 2107233.93005 37.7665004685576 -122.4164534151 (37.7665004685576, -122.4164534151) 8 4 7 28853 19
7285 261471 Undocumented 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1785 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005616 2107209 37.7663120077949 -122.423818660091 (37.7663120077949, -122.423818660091) 8 4 5 28853 19
12106 112557 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 35 DOLORES ST 5 Sidewalk: Curb side : Cutout Tree Private 2   08/28/2015 12:00:00 AM   3x3   6004913 2108042 37.7685595148495 -122.426309519551 (37.7685595148495, -122.426309519551) 8 4 5 28853 19
15864 112555 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 35 DOLORES ST 3 Sidewalk: Curb side : Cutout Tree Private 2   08/28/2015 12:00:00 AM   3x3   6004913 2108042 37.7685595148495 -122.426309519551 (37.7685595148495, -122.426309519551) 8 4 5 28853 19
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
26112 112553 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 35 DOLORES ST 1 Sidewalk: Curb side : Cutout Tree Private 2   08/28/2015 12:00:00 AM 2 3x3   6004913 2108042 37.7685595148495 -122.426309519551 (37.7685595148495, -122.426309519551) 8 4 5 28853 19
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
46594 112556 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 35 DOLORES ST 4 Sidewalk: Curb side : Cutout Tree Private 2   08/28/2015 12:00:00 AM   3x3   6004913 2108042 37.7685595148495 -122.426309519551 (37.7685595148495, -122.426309519551) 8 4 5 28853 19
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
57426 230290 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 59 Ramona Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6005216.74861 2107488.55744 37.7670570589707 -122.425219491113 (37.7670570589707, -122.425219491113) 8 4 5 28853 19
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
65379 24369 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 134 Duboce Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   07/19/2016 04:44:00 AM 3 3x3   6005829.4207618 2108507.0022787 37.7698880583785 -122.423172750169 (37.7698880583785, -122.423172750169) 8 4 5 28853 19
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
105979 112554 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 35 DOLORES ST 2 Sidewalk: Curb side : Cutout Tree Private 2   08/28/2015 12:00:00 AM   3x3   6004913 2108042 37.7685595148495 -122.426309519551 (37.7685595148495, -122.426309519551) 8 4 5 28853 19
116279 112558 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 35 DOLORES ST 6 Sidewalk: Curb side : Cutout Tree Private 2   08/28/2015 12:00:00 AM   3x3   6004913 2108042 37.7685595148495 -122.426309519551 (37.7685595148495, -122.426309519551) 8 4 5 28853 19
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
55068 116930 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 900x 24th St 9 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 5x5   6015446.80292 2102557.08015 37.7540889024884 -122.389490562948 (37.7540889024884, -122.389490562948) 10 3 8 28856 29
59269 193346 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1133 19th St 5 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   6014187.49963 2105244.21667 37.761397296172 -122.394033672633 (37.761397296172, -122.394033672633) 10 3 8 28856 29
63967 116932 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 900x 24th St 11 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 5x5   6015412.75293 2102554.60022 37.7540802051572 -122.389608143898 (37.7540802051572, -122.389608143898) 10 3 8 28856 29
66389 116929 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 900x 24th St 8 Sidewalk: Curb side : Cutout Tree Private 2   11/22/2016 12:00:00 AM 3 5x5   6015461.93425 2102556.84012 37.7540890823654 -122.389438217924 (37.7540890823654, -122.389438217924) 10 3 8 28856 29

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