trees
979 rows where qSpecies_id = 13 sorted by Neighborhoods (old)
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 | ||||||||||||
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 |
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) );