979 rows where qSpecies_id = 13 sorted by Neighborhoods (old)

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old) ▼
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                        
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
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
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
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
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
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
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
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
54957 193353 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 75 Latona St 2 : Tree Private 2     2 Width 2ft   6014356.71381 2094130.91489 37.7308919074363 -122.392670976684 (37.7308919074363, -122.392670976684) 10 3 8 58 1
83365 6755 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1215 Fairfax Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1   01/03/2017 06:41:00 AM 3 3x3   6017521.0990665 2096743.3718322 37.7382404347673 -122.381912713319 (37.7382404347673, -122.381912713319) 10 3 8 58 1
86141 88503 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 7 Wheat St   Sidewalk: Curb side : Cutout Tree Private 2   07/18/2008 12:00:00 AM   3x3 Permit Number 51441 6012178 2091435 37.7233682355202 -122.400013942822 (37.7233682355202, -122.400013942822) 10 3 8 58 1
87006 113267 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 83 Exeter St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/2015 12:00:00 AM 2   Permit Number 774551 6012507.04437 2090789.37208 37.7216138123142 -122.398831200496 (37.7216138123142, -122.398831200496) 10 3 8 58 1
107537 193351 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1752 Quesada Ave 2 : Tree Private 2     1 Width 4ft   6014452.02014 2095263.45344 37.7340069206852 -122.392420670182 (37.7340069206852, -122.392420670182) 10 3 8 58 1
117325 30768 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1639 Wallace Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/31/1995 12:00:00 AM 1   Permit Number 34648 6014552.699 2093014.6387 37.7278377210513 -122.391915390574 (37.7278377210513, -122.391915390574) 10 3 8 58 1
123198 61691 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 61 Lucy St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1992 12:00:00 AM 4   Permit Number 31258 6014147.06906 2093799.26826 37.7299696274983 -122.393372558494 (37.7299696274983, -122.393372558494) 10 3 8 58 1
137832 113270 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1570 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/2015 12:00:00 AM     Permit Number 773602 6015432.5 2094545.1 37.7320888656597 -122.388980682272 (37.7320888656597, -122.388980682272) 10 3 8 58 1
147550 113269 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1328 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/16/2015 12:00:00 AM     Permit Number 774425 6016744.9 2093624.7 37.7296342890732 -122.384379303046 (37.7296342890732, -122.384379303046) 10 3 8 58 1
151472 193354 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 75 Latona St 4 : Tree Private 2     3 Width 2ft   6014363.50892 2094164.90475 37.7309856140862 -122.392649861509 (37.7309856140862, -122.392649861509) 10 3 8 58 1
152301 193350 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1752 Quesada Ave 1 : Tree Private 2     1 Width 4ft   6014471.5284 2095248.21375 37.7339661589078 -122.392352158028 (37.7339661589078, -122.392352158028) 10 3 8 58 1
154786 248942 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1500x Galvez Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 Private 03/18/2017 12:56:00 PM 3 3x3   6016393 2097292 37.7396844950272 -122.385851388433 (37.7396844950272, -122.385851388433) 10 3 8 58 1
163849 8230 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1500X Galvez Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1   12/10/2015 08:33:00 AM 3 3x3   6016396.247314 2097296.3974116 37.7396967491289 -122.385840466933 (37.7396967491289, -122.385840466933) 10 3 8 58 1
183758 8223 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1500X Galvez Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/10/2015 08:24:00 AM 3 3x3   6016396.247314 2097296.3974116 37.7396967491289 -122.385840466933 (37.7396967491289, -122.385840466933) 10 3 8 58 1
190220 96333 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 11 Robblee Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2011 12:00:00 AM 3 3x3 Permit Number 767342 6012676.77436 2095976.0416 37.7358647977189 -122.398608271155 (37.7358647977189, -122.398608271155) 10 3 8 58 1
191282 248924 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 201x Cashmere St 5 Sidewalk: Curb side : Cutout Tree DPW 1 Private 04/29/2017 10:39:00 AM 3 3x3   6016272 2096170 37.7365970133228 -122.386191558691 (37.7365970133228, -122.386191558691) 10 3 8 58 1
192930 193352 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1707 McKinnon Ave 1 : Tree Private 2     4 Width 3ft   6014777.57623 2096343.32459 37.736990099615 -122.391370577692 (37.736990099615, -122.391370577692) 10 3 8 58 1
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
3837 255657 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1421 Fulton St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/22/2018 12:00:00 AM 3     6000959.70168 2111031.39919 37.7765434007218 -122.44019801367 (37.7765434007218, -122.44019801367) 15 5 11 29492 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
6177 70542 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 657 Broderick St 2 Sidewalk: Curb side : Cutout Tree DPW 1     7     6001053.4846 2110988.4642 37.7764308509595 -122.439870513201 (37.7764308509595, -122.439870513201) 15 5 11 29492 10
24707 230280 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 201 Webster St 3 : Tree Private 2     2 Width 3ft   6004189.92363 2109488.51079 37.7724903832539 -122.428913720795 (37.7724903832539, -122.428913720795) 7 9 11 29492 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
35478 141579 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 500 BAKER ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     0 Width 0ft   6000650.2876 2110740.0178 37.7757257205697 -122.441247451765 (37.7757257205697, -122.441247451765) 15 5 11 29492 10
48829 63744 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 690 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/2014 12:00:00 AM 3 3x3 Permit Number 773423 6003267.19349485 2109664.80045569 37.772922159977 -122.432118125319 (37.772922159977, -122.432118125319) 15 9 11 29492 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
119526 88650 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 400 Haight St   Sidewalk: Curb side : Cutout Tree Private 2   08/05/2008 12:00:00 AM   3x3 Permit Number 51631 6004213 2109445 37.7723722193741 -122.428830794856 (37.7723722193741, -122.428830794856) 7 9 11 29492 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
131845 253506 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1401 Fulton St 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6001009 2111012 37.7764929420148 -122.440026085657 (37.7764929420148, -122.440026085657) 15 5 11 29492 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
6056 147742 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 175 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2019 12:00:00 AM 3 Width 4ft   5993335.44452 2114350.58879 37.7852199756724 -122.466813637549 (37.7852199756724, -122.466813637549) 11 6 2 54 11
17123 254549 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 170 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/04/2020 12:00:00 AM 3 3x3   5992784 2114350 37.7851865177567 -122.46872140612 (37.7851865177567, -122.46872140612) 11 6 2 54 11
21538 123622 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 111 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5995179.48554 2114830.2995 37.7866433854107 -122.460468639914 (37.7866433854107, -122.460468639914) 11 6 1 54 11
29086 112523 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 195 02nd Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2015 12:00:00 AM 1 3x3 Permit Number 776238 5995199.36548 2114291.31706 37.7851646286632 -122.460360793578 (37.7851646286632, -122.460360793578) 11 6 2 54 11
37880 53932 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 140 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/27/1972 12:00:00 AM 1   Permit Number 9646 5993064.17697 2114524.47346 37.7856817557629 -122.467764782699 (37.7856817557629, -122.467764782699) 11 6 2 54 11
43419 108518 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 600-602 Cabrillo St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773792 5993757.57798 2110759.58067 37.7753843907715 -122.465092287532 (37.7753843907715, -122.465092287532) 11 6 2 54 11
43601 94709 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 739 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/28/2010 12:00:00 AM 1 3x3 Permit Number 53847 5992236.9095 2110392.30167 37.7742881380791 -122.470325834679 (37.7742881380791, -122.470325834679) 11 6 2 54 11
46494 48393 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1325 Anza St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/17/2018 12:00:00 AM 4   Permit Number 45775 5994526.88441 2112095.32134 37.7790963088496 -122.462528007047 (37.7790963088496, -122.462528007047) 11 6 2 54 11
49638 123123 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 780 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5992600.03768 2110148.99607 37.7736410746067 -122.469052008303 (37.7736410746067, -122.469052008303) 11 6 2 54 11
59490 12529 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 105 Lake St 1 Front Yard : Cutout Tree Private 2 FUF 07/12/2004 12:00:00 AM 6 3x3 Permit Number 773769 5995136.95364 2114887.49287 37.7867979761022 -122.460619935074 (37.7867979761022, -122.460619935074) 11 6 1 54 11
63821 94705 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 682 12th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/28/2010 12:00:00 AM   3x3 Permit Number 53845 5992291.3 2110837.3 37.7755131276945 -122.470170100471 (37.7755131276945, -122.470170100471) 11 6 2 54 11
65512 108459 Private 9 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 771 11th Ave   Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x3 Permit Number 773786 5992558.08669 2110211.94426 37.7738114893979 -122.469201704334 (37.7738114893979, -122.469201704334) 11 6 2 54 11
66307 47394 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 492 03rd Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 05/14/2002 12:00:00 AM 2   Permit Number 45308 5995008.66399 2112223.96074 37.7794772512056 -122.460870672851 (37.7794772512056, -122.460870672851) 11 6 2 54 11
68596 123366 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 780 04th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 4ft   5994765.69029 2110380.32738 37.7744011411578 -122.461577514019 (37.7744011411578, -122.461577514019) 11 6 2 54 11
70004 123549 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 65 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 5ft   5994237.46417 2115165.09446 37.7875084040974 -122.463752090061 (37.7875084040974, -122.463752090061) 11 6 1 54 11
73688 32337 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2626 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/03/1996 12:00:00 AM 3   Permit Number 36899 5995236.94633 2110306.39824 37.7742252654946 -122.459942005265 (37.7742252654946, -122.459942005265) 11 6 2 54 11
73885 123609 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 121 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/12/2018 12:00:00 AM 3 Width 5ft Permit Number 782700 5995062.26821 2114886.47744 37.786790890934 -122.460878253711 (37.786790890934, -122.460878253711) 11 6 1 54 11
81645 47396 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 492 03rd Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 05/14/2002 12:00:00 AM 3   Permit Number 45308 5995005.9977 2112260.59137 37.7795776757203 -122.46088255216 (37.7795776757203, -122.46088255216) 11 6 2 54 11
92756 52460 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 682@ CABRILLO 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2005 12:00:00 AM 1   Permit Number 48571 5992268.12798 2110826.06835 37.7754809489734 -122.470249439229 (37.7754809489734, -122.470249439229) 11 6 2 54 11
93223 41941 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 646 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 10   Permit Number 42299 5994427.44449 2111105.89465 37.7763738805691 -122.46280020914 (37.7763738805691, -122.46280020914) 11 6 2 54 11
95963 123057 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 514 Funston Ave 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   5991919.13974 2111920.98536 37.7784671102548 -122.47153646454 (37.7784671102548, -122.47153646454) 11 6 2 54 11
98197 123608 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 121 Lake St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/06/2018 12:00:00 AM 19 Width 5ft   5995078.16732 2114887.75716 37.7867953195114 -122.46082333969 (37.7867953195114, -122.46082333969) 11 6 1 54 11
98204 112522 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 195 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2015 12:00:00 AM 1 3x3 Permit Number 776238 5995198.14893 2114301.99699 37.7851938828924 -122.460365776533 (37.7851938828924, -122.460365776533) 11 6 2 54 11
104295 47397 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 492 03rd Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 05/14/2002 12:00:00 AM 2   Permit Number 45308 5995007.08219 2112241.09178 37.7795241974528 -122.460877386845 (37.7795241974528, -122.460877386845) 11 6 2 54 11
111497 87238 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 313 04th Ave   Sidewalk: Curb side : Cutout Tree Private 2   02/14/2008 12:00:00 AM   3x3 Permit Number 50268 5994594.9 2113356.1 37.7825619851863 -122.462384185128 (37.7825619851863, -122.462384185128) 11 6 2 54 11
113259 108495 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 133 12th Ave   Sidewalk: Curb side : Cutout Tree Private 2   12/23/2014 12:00:00 AM 3 3x3 Permit Number 773787 5992089.92921 2114572.19418 37.7857564810121 -122.47113884729 (37.7857564810121, -122.47113884729) 11 6 2 54 11
116678 31977 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 134 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/30/1995 12:00:00 AM 7   Permit Number 35376 5995230.64434 2114664.73917 37.7861917443429 -122.460279644251 (37.7861917443429, -122.460279644251) 11 6 1 54 11
121719 12532 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 120 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 6x7.4   5995061.51034 2114935.24706 37.7869247555074 -122.460884411661 (37.7869247555074, -122.460884411661) 11 6 1 54 11
147619 123367 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 780 04th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 4ft   5994765.80276 2110367.1849 37.7743650618625 -122.461576171928 (37.7743650618625, -122.461576171928) 11 6 2 54 11
148085 38814 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 286 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/03/2008 12:00:00 AM 4 3x3 Permit Number 51147 5995268.26088 2113665.38834 37.7834499595789 -122.460077076847 (37.7834499595789, -122.460077076847) 11 6 2 54 11
149921 123425 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 642 03rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 3ft   5995046.06242 2111151.48991 37.7765346834922 -122.460663556381 (37.7765346834922, -122.460663556381) 11 6 2 54 11
153748 34942 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 462 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/1997 12:00:00 AM 8   Permit Number 38539 5995310.64413 2112404.55918 37.7799904974934 -122.459839088006 (37.7799904974934, -122.459839088006) 11 6 2 54 11
163039 122918 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 336 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5992182.56375 2113171.96239 37.7819171874048 -122.470716333226 (37.7819171874048, -122.470716333226) 11 6 2 54 11
166546 68687 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 133 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/2014 12:00:00 AM 1 6x6 Permit Number 771044 5992088.87095 2114507.13587 37.7855777876584 -122.471137767056 (37.7855777876584, -122.471137767056) 11 6 2 54 11
171901 82180 Private 9 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 105 Lake St 1 Front Yard : Cutout Tree Private 2 FUF     3x3 Permit Number 773769 5995179.68463591 2114884.08050195 37.7867910649613 -122.460471849521 (37.7867910649613, -122.460471849521) 11 6 1 54 11
172708 107438 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 777 04th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2014 12:00:00 AM 3 3x3 Permit Number 773131 5994721.10495 2110354.7884 37.7743284514501 -122.461729889857 (37.7743284514501, -122.461729889857) 11 6 2 54 11
175719 123126 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 771 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5992555.29457 2110202.54859 37.7737855300786 -122.469210678659 (37.7737855300786, -122.469210678659) 11 6 2 54 11
192174 84410 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 745 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/04/2008 12:00:00 AM 2 3x3 Permit Number 51564 5992859.62349 2110370.66867 37.7742647232802 -122.468170197773 (37.7742647232802, -122.468170197773) 11 6 2 54 11
192796 94708 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 696 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/28/2010 12:00:00 AM 1 3x3 Permit Number 53846 5992270.38847 2110735.82166 37.7752332866791 -122.470235046427 (37.7752332866791, -122.470235046427) 11 6 2 54 11
8586 50836 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 202 Kirkham St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2004 12:00:00 AM     Permit Number 47354 5994277.69303186 2105335.48637483 37.7605212305047 -122.462899497742 (37.7605212305047, -122.462899497742) 1 5 11 56 12
11428 122390 Undocumented 4 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1958 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF     3x2   5991007 2102078 37.7513881006776 -122.473973545995 (37.7513881006776, -122.473973545995) 1 8 4 29491 12
22578 108523 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1655 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773674 5990561.39992 2104128.43771 37.7569922406164 -122.475664177859 (37.7569922406164, -122.475664177859) 1 8 4 56 12
27335 50837 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 202 Kirkham St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2004 12:00:00 AM     Permit Number 47354 5994277.69303186 2105335.48637483 37.7605212305047 -122.462899497742 (37.7605212305047, -122.462899497742) 1 5 11 56 12
32475 255482 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1559 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2018 12:00:00 AM 3 3x5   5993958 2104895 37.7592933500003 -122.463973185629 (37.7592933500003, -122.463973185629) 1 8 4 56 12
32930 83189 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1670 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53556 5992811.58181355 2104100.90541778 37.7570468381941 -122.467880263564 (37.7570468381941, -122.467880263564) 1 8 4 56 12
47632 208834 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1669 18th Ave 1 Sidewalk: Property side : Yard Tree Private 2     1 Width 3ft   5990551.61783 2104055.61326 37.7567917168824 -122.475692689987 (37.7567917168824, -122.475692689987) 1 8 4 56 12
57445 94819 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1551 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53898 5993027.2 2104915.2 37.7592951275131 -122.467193784759 (37.7592951275131, -122.467193784759) 1 8 4 56 12
99358 83188 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1664 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2010 12:00:00 AM   3x3 Permit Number 53557 5992810.26262937 2104140.01708709 37.7571541524742 -122.467887670443 (37.7571541524742, -122.467887670443) 1 8 4 56 12
101820 69097 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1652 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/2010 12:00:00 AM   3x3 Permit Number 53733 5992497.75001654 2104207.48539143 37.7573213517081 -122.468973359701 (37.7573213517081, -122.468973359701) 1 8 4 56 12
102332 208836 DPW Maintained 1 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1677 18th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   5990563.73281 2104000.71919 37.7566416946684 -122.475646784065 (37.7566416946684, -122.475646784065) 1 8 4 56 12

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