trees
979 rows where qSpecies_id = 13 sorted by qSpecies_id descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17 | 164866 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 719 Faxon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/16/2020 12:00:00 AM | 3 | 4x6 | Permit Number 782492 | 5994853.78052 | 2092811.30491 | 37.7261661184654 | -122.459999785581 | (37.7261661184654, -122.459999785581) | 9 | 7 | 4 | 28861 | 40 | |
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 | ||
558 | 230313 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 968 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6010194.52879 | 2103588.60829 | 37.7566286356186 | -122.407727015404 | (37.7566286356186, -122.407727015404) | 2 | 4 | 7 | 28859 | 19 | |||
741 | 262415 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 122 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/09/2019 12:00:00 AM | 3 | Width 3ft | 6003235 | 2094463 | 37.731179778599 | -122.431144235496 | (37.731179778599, -122.431144235496) | 9 | 7 | 5 | 28861 | 25 | ||
743 | 236478 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 222 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/14/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785288 | 6007898.7538 | 2097586.28669 | 37.7400188220044 | -122.415241775611 | (37.7400188220044, -122.415241775611) | 2 | 7 | 7 | 28859 | 2 | |
821 | 261708 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 1 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 | |
863 | 230293 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3500 19th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | Permit Number 769041 | 6006188.70146 | 2104951.15176 | 37.7601448013679 | -122.421677407793 | (37.7601448013679, -122.421677407793) | 2 | 4 | 5 | 28859 | 19 | ||
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 | ||
1002 | 260458 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 835 Darien Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/19/2019 12:00:00 AM | 3 | 6x10 | Permit Number 784514 | 5994066 | 2094094 | 37.7296427463027 | -122.462816092129 | (37.7296427463027, -122.462816092129) | 9 | 8 | 4 | 59 | 40 | |
1059 | 262280 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
1439 | 72311 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3769 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5996250.37824 | 2115874.50597 | 37.7895720432509 | -122.456839183887 | (37.7895720432509, -122.456839183887) | 11 | 6 | 1 | 54 | 31 | |||
1513 | 146932 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 619 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:30:00 PM | 0 | Width 3ft | 5982546.66357 | 2111553.12275 | 37.7769103910512 | -122.503931600958 | (37.7769103910512, -122.503931600958) | 11 | 6 | 2 | 55 | 26 | ||
1556 | 158441 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 49 Van Buren St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785489 | 6002069.34164 | 2096386.56921 | 37.7363953338756 | -122.435311658815 | (37.7363953338756, -122.435311658815) | 2 | 7 | 5 | 63 | 7 | |
1560 | 258220 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 477 Eucalyptus Dr | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774069 | 5989683 | 2094686 | 37.7310148065902 | -122.478011682019 | (37.7310148065902, -122.478011682019) | 1 | 8 | 4 | 64 | 14 | |
1859 | 243453 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 73 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 04/01/2016 12:00:00 AM | 0 | 4x6 | Permit Number 777687 | 6007416.81803 | 2098970.61704 | 37.7437927883108 | -122.417006175297 | (37.7437927883108, -122.417006175297) | 2 | 7 | 7 | 28859 | 2 |
1903 | 220552 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 13 Ohlone Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | Permit Number 785489 | 6002169.64489 | 2096371.31931 | 37.7363591568587 | -122.434963778568 | (37.7363591568587, -122.434963778568) | 2 | 7 | 5 | 63 | 7 | ||
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 | |||
2285 | 95676 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 232 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767428 | 6010063.65694 | 2093465.10714 | 37.7288243741431 | -122.407465923318 | (37.7288243741431, -122.407465923318) | 10 | 3 | 7 | 309 | 28 |
2308 | 144457 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 566 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/2019 12:00:00 AM | 3 | 4x6 | 5987536.08738 | 2112106.24218 | 37.7787212290426 | -122.486712509289 | (37.7787212290426, -122.486712509289) | 11 | 6 | 2 | 55 | 26 | |
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 | |||
2571 | 219957 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3933 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6003591.26694 | 2101840.52548 | 37.7514569483989 | -122.430438748853 | (37.7514569483989, -122.430438748853) | 2 | 4 | 5 | 28862 | 22 | |||
2708 | 50426 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 Howth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/12/2014 12:00:00 AM | 3 | Permit Number 773627 | 5997303.25557645 | 2090612.9654569 | 37.7202705700793 | -122.45137364778 | (37.7202705700793, -122.45137364778) | 9 | 8 | 6 | 28861 | 24 | |
2825 | 92602 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2201 Baker St | 11 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/25/2009 12:00:00 AM | 3x3 | Permit Number 52915 | 5999814 | 2116396 | 37.7912079107295 | -122.444546965455 | (37.7912079107295, -122.444546965455) | 13 | 6 | 1 | 29490 | 27 | ||
3141 | 117754 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 406 39th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 5983780.49053 | 2113060.07342 | 37.7811205143771 | -122.499774894109 | (37.7811205143771, -122.499774894109) | 11 | 6 | 2 | 55 | 26 | |||
3226 | 107892 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 162 Brewster St | Front Yard : Cutout | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773952 | 6010231.01704 | 2099016.49618 | 37.7440766668365 | -122.407278527778 | (37.7440766668365, -122.407278527778) | 2 | 7 | 7 | 28859 | 2 | ||
3356 | 74692 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 200 Green St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011876.44918 | 2119465.43765 | 37.8003167500634 | -122.403026990216 | (37.8003167500634, -122.403026990216) | 3 | 1 | 10 | 308 | 23 | |||
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 | |||
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 | |||
3880 | 262281 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
3991 | 131008 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 150x Drumm St | 3 | Median : Yard | Tree | DPW 1 | 4 | Width 7ft | 6013685.84477 | 2117434.71438 | 37.7948417395127 | -122.396623287539 | (37.7948417395127, -122.396623287539) | 4 | 1 | 10 | 28860 | 6 | |||
4347 | 174997 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 61 Curtis St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Width 4ft | 6000632.91251 | 2088182.32659 | 37.7137866806885 | -122.43968998482 | (37.7137866806885, -122.43968998482) | 9 | 7 | 6 | 28861 | 5 | ||
4377 | 88323 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 125 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51312 | 6003417 | 2092629 | 37.7261543381556 | -122.430384225952 | (37.7261543381556, -122.430384225952) | 9 | 7 | 6 | 28861 | 5 | |||
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 | |||
4564 | 264686 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2455 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2020 12:00:00 AM | 3 | 3x3 | Permit Number 782284 | 5990129.23032 | 2098669.31502 | 37.7419778589065 | -122.476759924113 | (37.7419778589065, -122.476759924113) | 1 | 8 | 3 | 29491 | 35 | |
4664 | 171655 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 101 Princeton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6007664.95872 | 2093252.16101 | 37.7281051161408 | -122.415743336498 | (37.7281051161408, -122.415743336498) | 9 | 3 | 7 | 309 | 5 | |||
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 | ||
4724 | 262586 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2 Byron Ct | 1 | Front Yard : Yard | Tree | Private 2 | 08/19/2020 12:00:00 AM | 3 | 8x8 | Permit Number 781313 | 5999459.72778 | 2086749.57445 | 37.7097858201455 | -122.443642066205 | (37.7097858201455, -122.443642066205) | 9 | 7 | 6 | 28861 | 5 | |
4773 | 165865 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 275 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | 3x4 | 6006836.83511 | 2097542.23848 | 37.7398381374333 | -122.418910337746 | (37.7398381374333, -122.418910337746) | 2 | 7 | 7 | 28859 | 2 | |||
4879 | 260889 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 527 45th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5981905.91133 | 2112171.65096 | 37.7785709887537 | -122.506193994794 | (37.7785709887537, -122.506193994794) | 11 | 6 | 2 | 55 | 26 | |||
4904 | 144219 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 876 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 5982678 | 2109818 | 37.7721539708604 | -122.503348768347 | (37.7721539708604, -122.503348768347) | 11 | 6 | 2 | 55 | 26 | ||
4996 | 255545 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 201X San Carlos St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006716 | 2104916 | 37.7600780028247 | -122.419851234809 | (37.7600780028247, -122.419851234809) | 2 | 4 | 7 | 28859 | 19 | ||||
5106 | 147909 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 69 Almaden Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 5995874.31253 | 2112332.21787 | 37.7798242673223 | -122.45788388223 | (37.7798242673223, -122.45788388223) | 11 | 6 | 2 | 54 | 16 | |||
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 | ||||||||||||
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 | |||||
5292 | 241594 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 687 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007646.0169 | 2096174.81068 | 37.7361290122323 | -122.416015706955 | (37.7361290122323, -122.416015706955) | 2 | 7 | 7 | 28859 | 2 | |||
5427 | 146424 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2131 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6000557.07663 | 2120624.21431 | 37.8028598421591 | -122.442279615007 | (37.8028598421591, -122.442279615007) | 13 | 9 | 1 | 57 | 17 | |||
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 | ||||
5720 | 80737 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 186 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6000043.55254 | 2087718.30936 | 37.7124790304587 | -122.44169374357 | (37.7124790304587, -122.44169374357) | 9 | 7 | 6 | 28861 | 5 | |||
5771 | 18021 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2725 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000769.3896 | 2114817.5231 | 37.7869282913907 | -122.441128056615 | (37.7869282913907, -122.441128056615) | 13 | 6 | 1 | 29490 | 27 | |||
5797 | 230342 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 65 Chenery St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004911.05921 | 2097907.10852 | 37.7407313620627 | -122.425594827655 | (37.7407313620627, -122.425594827655) | 2 | 7 | 5 | 63 | 7 | |||
6004 | 230296 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3500 19th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | Permit Number 769041 | 6006123.35153 | 2104947.42015 | 37.7601308699707 | -122.421903157405 | (37.7601308699707, -122.421903157405) | 2 | 4 | 5 | 28859 | 19 | ||
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 | ||
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 | ||||
6589 | 44716 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1879 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/08/2020 12:00:00 AM | 3 | Permit Number 43838 | 5989679.8369 | 2102593.1522 | 37.7527256083507 | -122.478600649693 | (37.7527256083507, -122.478600649693) | 1 | 8 | 3 | 56 | 35 | |
6755 | 264922 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 Urbano Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11/10/2020 12:00:00 AM | 3 | 4x6 | Permit Number 781481 | 5992625.08037 | 2092677.96132 | 37.7256715559054 | -122.467694516591 | (37.7256715559054, -122.467694516591) | 9 | 8 | 4 | 59 | 40 | |
6875 | 260888 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 528 45th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5981946.38688 | 2112159.7169 | 37.7785406040131 | -122.50605309173 | (37.7785406040131, -122.50605309173) | 11 | 6 | 2 | 55 | 26 | |||
7003 | 177395 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 715 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6001937.65614 | 2089768.77997 | 37.7182169074587 | -122.435293726344 | (37.7182169074587, -122.435293726344) | 9 | 7 | 6 | 28861 | 5 | |||
7146 | 112795 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1235 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/20/2015 12:00:00 AM | 3x3 | 5983624.1 | 2106731.7 | 37.7637354441658 | -122.499848016409 | (37.7637354441658, -122.499848016409) | 1 | 8 | 3 | 56 | 35 | |||
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 | ||||
7356 | 71615 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 536 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5983503.66193 | 2112151.1699 | 37.7786086821922 | -122.500665338334 | (37.7786086821922, -122.500665338334) | 11 | 6 | 2 | 55 | 26 | |||
7414 | 70266 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 414 23rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5988762.33088 | 2112478.21963 | 37.7798139854521 | -122.482497769619 | (37.7798139854521, -122.482497769619) | 11 | 6 | 2 | 55 | 26 | |||
7661 | 83659 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 559 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6001685.54257 | 2090383.45339 | 37.7198903425557 | -122.436209138162 | (37.7198903425557, -122.436209138162) | 9 | 7 | 6 | 28861 | 5 | |||
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 | ||
8309 | 55891 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1981 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/1979 12:00:00 AM | 4 | Permit Number 17936 | 6003525.54431 | 2118603.6465 | 37.7974806237872 | -122.431862837898 | (37.7974806237872, -122.431862837898) | 13 | 9 | 1 | 57 | 17 | ||
8374 | 208843 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 40 Agua Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5997291.06099 | 2098595.63938 | 37.7421883896873 | -122.451991423486 | (37.7421883896873, -122.451991423486) | 9 | 7 | 4 | 59 | 40 | |||
8414 | 260883 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 122 22nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5988999.56708 | 2114522.30916 | 37.7854402782048 | -122.481826844764 | (37.7854402782048, -122.481826844764) | 11 | 6 | 2 | 55 | 26 | ||
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 | |||
8981 | 233048 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3059 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | Width 3ft | 6009171.33105 | 2101566.67381 | 37.751019525329 | -122.411122798801 | (37.751019525329, -122.411122798801) | 2 | 4 | 7 | 28859 | 19 | ||
9085 | 119446 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 885 32nd Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 5985992 | 2109886 | 37.7725349378609 | -122.491890533583 | (37.7725349378609, -122.491890533583) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
9116 | 229637 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 209 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6009018.53484 | 2097336.36234 | 37.7393954533353 | -122.411352367829 | (37.7393954533353, -122.411352367829) | 10 | 7 | 7 | 28859 | 2 | |||
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 | |||
9277 | 85291 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 7350 Geary Blvd | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | 2 | 4x72 | Permit Number 49578 | 5984127.30348 | 2112512.4695 | 37.779637298343 | -122.498534651264 | (37.779637298343, -122.498534651264) | 11 | 6 | 2 | 55 | 26 | ||
9454 | 260881 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 751 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985678.2622 | 2110774.56948 | 37.7749563544765 | -122.493041236092 | (37.7749563544765, -122.493041236092) | 11 | 6 | 2 | 55 | 26 | |||
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 | ||
9768 | 225019 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 4326 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779083 | 6001573.01872 | 2104694.86149 | 37.7591797334691 | -122.437622474895 | (37.7591797334691, -122.437622474895) | 2 | 4 | 5 | 28862 | 3 | |
9933 | 264897 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 405 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/2020 12:00:00 AM | 3 | 3x3 | Permit Number 772749 | 6002446.89331 | 2091087.07144 | 37.7218655485653 | -122.433627676211 | (37.7218655485653, -122.433627676211) | 9 | 7 | 6 | 28861 | 5 | |
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 | |||
10118 | 108815 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 474 Munich St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774652 | 6003779.44726 | 2089723.38143 | 37.7181966752665 | -122.428924204145 | (37.7181966752665, -122.428924204145) | 9 | 7 | 6 | 28861 | 5 | |
10144 | 97101 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1096@Jones Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008668 | 2115966 | 37.7905284677514 | -122.413881848265 | (37.7905284677514, -122.413881848265) | 5 | 1 | 10 | 28857 | 21 | ||||
10157 | 124335 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 176 Palm Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 2 | Width 2ft | 5995959.20478 | 2113110.98096 | 37.7819674207447 | -122.457646568088 | (37.7819674207447, -122.457646568088) | 11 | 6 | 1 | 54 | 31 | |||
10191 | 117755 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 406 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2020 12:00:00 AM | 3 | Width 4ft | 5983780.25118 | 2113048.87393 | 37.7810897498012 | -122.499774894099 | (37.7810897498012, -122.499774894099) | 11 | 6 | 2 | 55 | 26 | ||
10378 | 163649 | Private 9 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 226 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 07/01/2020 12:00:00 AM | 3 | 3x4 | Permit Number 784460 | 5994737.04022 | 2087470.63166 | 37.71149518743 | -122.460016622663 | (37.71149518743, -122.460016622663) | 9 | 8 | 6 | 28861 | 24 |
10512 | 230294 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3500 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | Permit Number 769041 | 6006176.61067 | 2104951.77673 | 37.760145835588 | -122.421719268545 | (37.760145835588, -122.421719268545) | 2 | 4 | 5 | 28859 | 19 | ||
10565 | 65035 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1205 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51820 | 6003879.11104946 | 2101261.18670708 | 37.7498825208731 | -122.429402039878 | (37.7498825208731, -122.429402039878) | 2 | 4 | 5 | 28862 | 22 | ||
10679 | 259873 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2666 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 5996410.48132 | 2110785.34876 | 37.7756077608376 | -122.455917191866 | (37.7756077608376, -122.455917191866) | 11 | 6 | 2 | 54 | 16 | ||
10935 | 230295 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3500 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | Permit Number 769041 | 6006165.12102 | 2104950.71502 | 37.7601422724637 | -122.421758930432 | (37.7601422724637, -122.421758930432) | 2 | 4 | 5 | 28859 | 19 | ||
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 | |||
11108 | 86883 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 550 Jersey St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 49808 | 6001589 | 2101474 | 37.750336931821 | -122.43733657342 | (37.750336931821, -122.43733657342) | 2 | 4 | 5 | 28862 | 22 | ||||
11300 | 159230 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 144 Naglee Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 5998399.17588 | 2087828.03812 | 37.712686491475 | -122.44738508425 | (37.712686491475, -122.44738508425) | 9 | 7 | 6 | 28861 | 25 | |||
11319 | 255592 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 199X San Carlos St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784421 | 6006714 | 2105007 | 37.7603277549802 | -122.419864609266 | (37.7603277549802, -122.419864609266) | 2 | 4 | 7 | 28859 | 19 | |
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 | |||
11453 | 130994 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 800 Lombard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008432.69085 | 2120383.1883 | 37.8026437557674 | -122.415008787324 | (37.8026437557674, -122.415008787324) | 5 | 1 | 10 | 308 | 32 | |||
11517 | 72252 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 531 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6002585.93283 | 2090796.9641 | 37.7210768666757 | -122.433126335006 | (37.7210768666757, -122.433126335006) | 9 | 7 | 6 | 28861 | 5 | |||
11800 | 262282 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 10 Niantic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784434 | 5992391 | 2086794 | 37.7095021076955 | -122.468075893068 | (37.7095021076955, -122.468075893068) | 9 | 8 | 4 | 64 | 24 | |
11942 | 34949 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1246 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | Permit Number 38547 | 6007519.49351 | 2115461.74269 | 37.7890793334842 | -122.417819862092 | (37.7890793334842, -122.417819862092) | 13 | 1 | 10 | 28858 | 21 | ||
12009 | 162257 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 778 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6011373.11147 | 2091245.9028 | 37.7228041046152 | -122.402783015826 | (37.7228041046152, -122.402783015826) | 10 | 3 | 7 | 309 | 28 | |||
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 | |||
12150 | 31352 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2359 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/11/2020 11:52:00 AM | 3 | Permit Number 34962 | 5992611.19724 | 2099415.50216 | 37.7441703551938 | -122.468232424195 | (37.7441703551938, -122.468232424195) | 1 | 8 | 4 | 29491 | 40 | |
12273 | 261709 | Significant Tree 6 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 20 Entrada Ct | 2 | Front Yard : Yard | Tree | Private 2 | 02/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 783258 | 5992481.8221 | 2092418.55282 | 37.724951011222 | -122.468170882637 | (37.724951011222, -122.468170882637) | 9 | 8 | 4 | 59 | 40 |
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) );