trees
979 rows where qSpecies_id = 13 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
133012 | 101128 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 295X 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769229 | 5990852.62725 | 2113482.24479 | 37.7826921394002 | -122.475339912567 | (37.7826921394002, -122.475339912567) | 11 | 6 | 2 | 54 | 26 | |
89563 | 102081 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 525 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52509 | 5991566.61031 | 2111852.8346 | 37.7782595860122 | -122.472751014651 | (37.7782595860122, -122.472751014651) | 11 | 6 | 2 | 54 | 26 |
15129 | 102443 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 514 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/07/2013 12:00:00 AM | 1 | Permit Number 770339 | 6013518.76597 | 2104573.81866 | 37.7595193399709 | -122.396299571184 | (37.7595193399709, -122.396299571184) | 10 | 3 | 8 | 28856 | 29 | ||
94823 | 102805 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 600 Kansas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780021 | 6011492.26434 | 2105507.65774 | 37.7619704808857 | -122.403373953167 | (37.7619704808857, -122.403373953167) | 10 | 3 | 8 | 28856 | 29 | |
70101 | 103767 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1323 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006757 | 2115467 | 37.7890508291132 | -122.420458370284 | (37.7890508291132, -122.420458370284) | 13 | 9 | 10 | 28858 | 21 | ||
128948 | 103768 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1323 Polk St | 2 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006757 | 2115467 | 37.7890508291132 | -122.420458370284 | (37.7890508291132, -122.420458370284) | 13 | 9 | 10 | 28858 | 21 | ||
33672 | 103773 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1288 Polk St | 3 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 6006856.2 | 2115250.5 | 37.7884619632914 | -122.420099779635 | (37.7884619632914, -122.420099779635) | 13 | 9 | 10 | 28858 | 21 | |||
131007 | 103774 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1288 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006856.2 | 2115250.5 | 37.7884619632914 | -122.420099779635 | (37.7884619632914, -122.420099779635) | 13 | 9 | 10 | 28858 | 21 | ||
62327 | 103775 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1288 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006856.2 | 2115250.5 | 37.7884619632914 | -122.420099779635 | (37.7884619632914, -122.420099779635) | 13 | 9 | 10 | 28858 | 21 | ||
19938 | 103781 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1237 Polk St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006764.1 | 2115217.5 | 37.7883661638156 | -122.420416088533 | (37.7883661638156, -122.420416088533) | 13 | 9 | 10 | 28858 | 21 | ||
42861 | 103782 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1237 Polk St | 2 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006764.1 | 2115217.5 | 37.7883661638156 | -122.420416088533 | (37.7883661638156, -122.420416088533) | 13 | 9 | 10 | 28858 | 21 | ||
34100 | 103787 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1217 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006790.1 | 2115111 | 37.7880752061995 | -122.420318570601 | (37.7880752061995, -122.420318570601) | 13 | 9 | 10 | 28858 | 21 | ||
38286 | 103800 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1157 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.7875183256613 | -122.420067824472 | (37.7875183256613, -122.420067824472) | 13 | 9 | 10 | 28858 | 21 | ||
34827 | 103801 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1157 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.7875183256613 | -122.420067824472 | (37.7875183256613, -122.420067824472) | 13 | 9 | 10 | 28858 | 21 | ||
177229 | 103802 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1157 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006858.38304 | 2114906.78358 | 37.7875183256613 | -122.420067824472 | (37.7875183256613, -122.420067824472) | 13 | 9 | 10 | 28858 | 21 | ||
189600 | 103809 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1145 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.420200726176 | (37.7874934070669, -122.420200726176) | 13 | 9 | 10 | 28858 | 21 | ||
105559 | 103810 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1145 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.420200726176 | (37.7874934070669, -122.420200726176) | 13 | 9 | 10 | 28858 | 21 | ||
176203 | 103811 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1145 Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006819.8 | 2114898.5 | 37.7874934070669 | -122.420200726176 | (37.7874934070669, -122.420200726176) | 13 | 9 | 10 | 28858 | 21 | ||
64797 | 103852 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1507 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006614.6 | 2116113.6 | 37.7908182067111 | -122.420996984718 | (37.7908182067111, -122.420996984718) | 13 | 9 | 10 | 28858 | 21 | ||
33582 | 103859 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1475 Polk St | 3 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006677 | 2115920.4 | 37.7902912446707 | -122.420767361582 | (37.7902912446707, -122.420767361582) | 13 | 9 | 10 | 28858 | 21 | ||
91960 | 103860 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1475 Polk St | 4 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006677 | 2115920.4 | 37.7902912446707 | -122.420767361582 | (37.7902912446707, -122.420767361582) | 13 | 9 | 10 | 28858 | 21 | ||
155187 | 103861 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1436 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006766.2 | 2115894.4 | 37.7902248822442 | -122.420456889097 | (37.7902248822442, -122.420456889097) | 13 | 9 | 10 | 28858 | 21 | ||
128715 | 103863 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1435 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006674.8 | 2115856.4 | 37.790115392534 | -122.42077042798 | (37.790115392534, -122.42077042798) | 13 | 9 | 10 | 28858 | 21 | ||
151626 | 103864 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1435 Polk St | 2 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006674.8 | 2115856.4 | 37.790115392534 | -122.42077042798 | (37.790115392534, -122.42077042798) | 13 | 9 | 10 | 28858 | 21 | ||
89050 | 103865 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1424 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006775 | 2115831.4 | 37.7900523957484 | -122.420421968076 | (37.7900523957484, -122.420421968076) | 13 | 9 | 10 | 28858 | 21 | ||
102492 | 103866 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1411 Polk St | 1 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006684.9 | 2115784.5 | 37.7899185422019 | -122.420730376301 | (37.7899185422019, -122.420730376301) | 13 | 9 | 10 | 28858 | 21 | ||
165177 | 103867 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1411 Polk St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006684.9 | 2115784.5 | 37.7899185422019 | -122.420730376301 | (37.7899185422019, -122.420730376301) | 13 | 9 | 10 | 28858 | 21 | ||
149876 | 103868 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1411 Polk St | 3 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006684.9 | 2115784.5 | 37.7899185422019 | -122.420730376301 | (37.7899185422019, -122.420730376301) | 13 | 9 | 10 | 28858 | 21 | ||
62298 | 103869 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1411 Polk St | 4 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006684.9 | 2115784.5 | 37.7899185422019 | -122.420730376301 | (37.7899185422019, -122.420730376301) | 13 | 9 | 10 | 28858 | 21 | ||
74128 | 104035 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 31 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770364 | 6003192.1 | 2108122 | 37.7686817505567 | -122.43226767848 | (37.7686817505567, -122.43226767848) | 15 | 5 | 5 | 28862 | 3 | |
94413 | 104138 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 3067 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2013 12:00:00 AM | 3x3 | Permit Number 770728 | 6001906.1 | 2118706.9 | 37.7976721947069 | -122.437473929103 | (37.7976721947069, -122.437473929103) | 13 | 9 | 1 | 57 | 17 | ||
154327 | 104139 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2301X Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2013 12:00:00 AM | 3x3 | Permit Number 770728 | 6001711.91514 | 2118723.596 | 37.7977069957146 | -122.438147056882 | (37.7977069957146, -122.438147056882) | 13 | 9 | 1 | 57 | 17 | ||
148842 | 104140 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2301X Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/2013 12:00:00 AM | 3x3 | Permit Number 770728 | 6001711.91514 | 2118723.596 | 37.7977069957146 | -122.438147056882 | (37.7977069957146, -122.438147056882) | 13 | 9 | 1 | 57 | 17 | ||
58308 | 104296 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 4267 24TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770781 | 6001461 | 2101700 | 37.7509501962946 | -122.437795389969 | (37.7509501962946, -122.437795389969) | 2 | 4 | 5 | 28862 | 22 | ||||
66627 | 104506 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 631 France Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 6002582.75614 | 2089515.1433 | 37.7175570910528 | -122.43304578096 | (37.7175570910528, -122.43304578096) | 9 | 7 | 6 | 28861 | 5 | ||
81820 | 104632 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 323 Madrid St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2014 12:00:00 AM | 3 | Permit Number 773809 | 6003337.3 | 2091944.5 | 37.7242703388921 | -122.430610922244 | (37.7242703388921, -122.430610922244) | 9 | 7 | 6 | 28861 | 5 | |||
179581 | 105038 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 46 Atalaya Ter | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/05/2015 12:00:00 AM | 3 | 3X4 | Permit Number 771123 | 5998888.1 | 2110865.6 | 37.7759699989755 | -122.447352315284 | (37.7759699989755, -122.447352315284) | 15 | 6 | 2 | 29492 | 16 | ||
155734 | 105250 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 500 36th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 1 | Permit Number 771049 | 5984731.6893 | 2112357.91416 | 37.7792483592825 | -122.496432443475 | (37.7792483592825, -122.496432443475) | 11 | 6 | 2 | 55 | 26 | ||
40035 | 105251 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 500 36th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/08/2014 12:00:00 AM | 1 | Permit Number 771049 | 5984733.08187 | 2112389.43293 | 37.7793349822998 | -122.496429952441 | (37.7793349822998, -122.496429952441) | 11 | 6 | 2 | 55 | 26 | ||
46899 | 105692 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2523 HARRISON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | 6008930.3 | 2103627.5 | 37.7566645705002 | -122.412101939497 | (37.7566645705002, -122.412101939497) | 2 | 4 | 7 | 28859 | 19 | ||
63268 | 105693 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2523 HARRISON ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6008930.3 | 2103627.5 | 37.7566645705002 | -122.412101939497 | (37.7566645705002, -122.412101939497) | 2 | 4 | 7 | 28859 | 19 | ||||
184483 | 105717 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 409 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5987766.35137 | 2113121.02315 | 37.7815209517603 | -122.485990454458 | (37.7815209517603, -122.485990454458) | 11 | 6 | 2 | 55 | 26 | |||
47189 | 105758 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2523 HARRISON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | 6008930.3 | 2103627.5 | 37.7566645705002 | -122.412101939497 | (37.7566645705002, -122.412101939497) | 2 | 4 | 7 | 28859 | 19 | ||
26944 | 105800 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 207 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2014 12:00:00 AM | 3 | Permit Number 769635 | 6010004.04754 | 2087785.06673 | 37.71322482385 | -122.407271751589 | (37.71322482385, -122.407271751589) | 9 | 7 | 8 | 309 | 39 | ||
53650 | 105829 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 DOUGLASS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773272 | 6001076.7 | 2104819.3 | 37.7594931793762 | -122.439347898858 | (37.7594931793762, -122.439347898858) | 2 | 4 | 5 | 28862 | 3 | |
193757 | 105847 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 790 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008900 | 2110136 | 37.7745337092857 | -122.412666821872 | (37.7745337092857, -122.412666821872) | 8 | 2 | 9 | 28853 | 34 | |||
24096 | 105848 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 790 Tehama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6008900 | 2110136 | 37.7745337092857 | -122.412666821872 | (37.7745337092857, -122.412666821872) | 8 | 2 | 9 | 28853 | 34 | |||
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 | |||
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 | ||
43703 | 106256 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1928 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | Permit Number 770844 | 6011999 | 2105627 | 37.7623264575812 | -122.401629730256 | (37.7623264575812, -122.401629730256) | 8 | 3 | 8 | 28856 | 29 | ||
98983 | 106257 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1938 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | Permit Number 770844 | 6011971 | 2105625 | 37.7623194035501 | -122.40172643178 | (37.7623194035501, -122.40172643178) | 8 | 3 | 8 | 28856 | 29 | ||
97176 | 106368 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 426 Country Club Dr | Sidewalk: Property side : Yard | Tree | Private 2 | 04/23/2014 12:00:00 AM | Permit Number 770073 | 5984817.1 | 2094918.3 | 37.731369010287 | -122.494850794258 | (37.731369010287, -122.494850794258) | 1 | 8 | 4 | 64 | 35 | ||||
79934 | 106843 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1869 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2014 12:00:00 AM | Permit Number 773317 | 6004088.44172 | 2118602.99638 | 37.7975107321666 | -122.429915018594 | (37.7975107321666, -122.429915018594) | 13 | 9 | 1 | 57 | 17 | |||
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 | |
64728 | 107495 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 4089 26TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2014 12:00:00 AM | 3 | 5x5 | Permit Number 774317 | 6003351.8 | 2100635.3 | 37.7481341140921 | -122.431180836539 | (37.7481341140921, -122.431180836539) | 2 | 4 | 5 | 63 | 22 | |
127507 | 107673 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 834 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/09/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772907 | 5983266.37919 | 2110104.76952 | 37.7729759278402 | -122.501334764681 | (37.7729759278402, -122.501334764681) | 11 | 6 | 2 | 55 | 26 | |
192239 | 107674 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 133 ELSIE ST | 1 | Front Yard : Yard | Tree | Private 2 | 10/10/2014 12:00:00 AM | 3 | 6007164.4 | 2098513.7 | 37.742523993822 | -122.417846597438 | (37.742523993822, -122.417846597438) | 2 | 7 | 7 | 28859 | 2 | |||
130311 | 107776 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 4115 26TH ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003143.1 | 2100622.5 | 37.7480871393693 | -122.431901599648 | (37.7480871393693, -122.431901599648) | 2 | 4 | 5 | 63 | 22 | |||||
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 | ||
101232 | 107902 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 133 Elsie St | Front Yard : Yard | Tree | Private 2 | 11/04/2014 12:00:00 AM | 3 | Permit Number 773996 | 6007164.40736 | 2098513.65139 | 37.742523860764 | -122.417846568545 | (37.742523860764, -122.417846568545) | 2 | 7 | 7 | 28859 | 2 | |||
58046 | 107963 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 33 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/10/2014 12:00:00 AM | 3 | 3x3 | Permit Number 770900 | 6011844.7795 | 2114609.58385 | 37.7869819669901 | -122.402794885102 | (37.7869819669901, -122.402794885102) | 12 | 2 | 9 | 28853 | 6 | |
47704 | 108089 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2501X 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2014 12:00:00 AM | 3 | Permit Number 773081 | 6010157.47788 | 2105483.07585 | 37.7618283430246 | -122.407988746007 | (37.7618283430246, -122.407988746007) | 10 | 4 | 8 | 28859 | 19 | ||
142933 | 108091 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2501X 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2014 12:00:00 AM | 3 | Permit Number 773081 | 6010179.28671 | 2105483.38874 | 37.7618304231561 | -122.407913339641 | (37.7618304231561, -122.407913339641) | 10 | 4 | 8 | 28859 | 19 | ||
68492 | 108093 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2501X 18th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/2014 12:00:00 AM | 3 | Permit Number 773081 | 6010203.41719 | 2105485.67353 | 37.7618380476045 | -122.40783004262 | (37.7618380476045, -122.40783004262) | 10 | 4 | 8 | 28859 | 19 | ||
79651 | 108193 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250 Douglass St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773272 | 6001076.66199 | 2104819.30807 | 37.7594931993714 | -122.439348030893 | (37.7594931993714, -122.439348030893) | 2 | 4 | 5 | 28862 | 3 | |
145251 | 108356 | Planning Code 138.1 required 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250X Pixley St | 1 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/02/2018 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002158.91155 | 2118972.60439 | 37.7984161192732 | -122.436618162405 | (37.7984161192732, -122.436618162405) | 13 | 9 | 1 | 57 | 17 | |
108505 | 108357 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250X Pixley St | 2 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/02/2018 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002140.21513 | 2118970.44706 | 37.7984091333207 | -122.436682703142 | (37.7984091333207, -122.436682703142) | 13 | 9 | 1 | 57 | 17 | |
177003 | 108358 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 250X Pixley St | 3 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 11/02/2018 12:00:00 AM | 3 | 2x4 | Permit Number 773698 | 6002123.02459 | 2118966.98612 | 37.7983986535418 | -122.436741939704 | (37.7983986535418, -122.436741939704) | 13 | 9 | 1 | 57 | 17 | |
128293 | 108377 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 226 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 3x3 | Permit Number 773810 | 6004631.19295 | 2091083.05863 | 37.7219782266077 | -122.426076821998 | (37.7219782266077, -122.426076821998) | 9 | 7 | 6 | 28861 | 5 | |
104312 | 108448 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 90-98X Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | 6004670.84101 | 2090640.56593 | 37.7207654791334 | -122.425908286356 | (37.7207654791334, -122.425908286356) | 9 | 7 | 6 | 28861 | 5 | |
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 | |||
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 | ||
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 |
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 |
160765 | 108524 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1669 18th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773675 | 5990564.49357 | 2104037.4684 | 37.7567426423615 | -122.475646836483 | (37.7567426423615, -122.475646836483) | 1 | 8 | 4 | 56 | 12 |
121503 | 108525 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1673 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773676 | 5990565.37747 | 2104011.47717 | 37.7566713285758 | -122.475641881825 | (37.7566713285758, -122.475641881825) | 1 | 8 | 4 | 56 | 12 |
151899 | 108558 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 222 Theresa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773717 | 6001903.01628 | 2093995.18892 | 37.7298197060157 | -122.435715674761 | (37.7298197060157, -122.435715674761) | 9 | 7 | 6 | 28861 | 25 |
130803 | 108592 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 669 Parker Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774577 | 5997227.20075 | 2110944.62571 | 37.7760919347852 | -122.453103475186 | (37.7760919347852, -122.453103475186) | 15 | 6 | 2 | 54 | 16 |
22140 | 108608 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 46 Mirabel Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774593 | 6007564.86266 | 2099909.67409 | 37.7463795558054 | -122.416560777242 | (37.7463795558054, -122.416560777242) | 2 | 7 | 7 | 28859 | 2 | |
156492 | 108610 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 745 Moultrie St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774595 | 6007633.33742 | 2095945.52231 | 37.7354987236975 | -122.416043312411 | (37.7354987236975, -122.416043312411) | 2 | 7 | 7 | 28859 | 2 | |
187282 | 108632 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 99 ORD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774601 | 6000898 | 2105859 | 37.7623377695764 | -122.440040482469 | (37.7623377695764, -122.440040482469) | 15 | 5 | 5 | 28862 | 3 |
117947 | 108633 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 2610 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774602 | 5987336.48113 | 2114673.56953 | 37.7857587403195 | -122.487591667787 | (37.7857587403195, -122.487591667787) | 11 | 6 | 1 | 55 | 33 |
68669 | 108662 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 842 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772817 | 5982646.66004 | 2110014.02816 | 37.7726903649612 | -122.503471692361 | (37.7726903649612, -122.503471692361) | 11 | 6 | 2 | 55 | 26 |
71691 | 108663 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 842 43rd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772817 | 5982645.59315 | 2110033.99041 | 37.7727451127869 | -122.503476861251 | (37.7727451127869, -122.503476861251) | 11 | 6 | 2 | 55 | 26 |
20705 | 108706 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1683 Chattanooga St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774629 | 6004719.93732 | 2102694.114 | 37.7538645742471 | -122.42659644528 | (37.7538645742471, -122.42659644528) | 2 | 4 | 5 | 28862 | 22 | |
183971 | 108814 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 470 Munich St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774651 | 6003792.96606 | 2089744.94608 | 37.7182566522639 | -122.42887901198 | (37.7182566522639, -122.42887901198) | 9 | 7 | 6 | 28861 | 5 | |
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 | |
143819 | 108839 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1112 Russia Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770758 | 6003955.6442 | 2089384.80901 | 37.7172770009516 | -122.428291049376 | (37.7172770009516, -122.428291049376) | 9 | 7 | 6 | 28861 | 5 | |
189937 | 108842 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 420 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010509.54502 | 2091864.19266 | 37.7244535448266 | -122.405811727659 | (37.7244535448266, -122.405811727659) | 10 | 3 | 7 | 309 | 28 | |
107527 | 108843 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 420 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010519.10921 | 2091869.71455 | 37.7244692416558 | -122.405779054162 | (37.7244692416558, -122.405779054162) | 10 | 3 | 7 | 309 | 28 | |
98737 | 108845 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 420 Woolsey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010479.05335 | 2091857.99264 | 37.7244348155857 | -122.405916697196 | (37.7244348155857, -122.405916697196) | 10 | 3 | 7 | 309 | 28 | |
68920 | 108921 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 33 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772690 | 6007205.6 | 2099297 | 37.7446770790021 | -122.417759648925 | (37.7446770790021, -122.417759648925) | 2 | 7 | 7 | 28859 | 2 |
182294 | 108925 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 209 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 770705 | 6009037.7 | 2097340 | 37.7394065164512 | -122.411286359806 | (37.7394065164512, -122.411286359806) | 10 | 7 | 7 | 28859 | 2 | ||
41563 | 108933 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 518 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773146 | 6008530.3 | 2096373.5 | 37.7367242478568 | -122.41297241357 | (37.7367242478568, -122.41297241357) | 10 | 7 | 7 | 28859 | 2 |
107998 | 108994 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1819 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773341 | 5993399.9 | 2103085.8 | 37.7542935760975 | -122.465771900659 | (37.7542935760975, -122.465771900659) | 1 | 8 | 4 | 56 | 12 |
125740 | 109037 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1306 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772801 | 5987138.4 | 2106347.4 | 37.7628858653346 | -122.487665061189 | (37.7628858653346, -122.487665061189) | 1 | 8 | 3 | 56 | 35 |
135375 | 109088 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 218 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 3x3 | 5987170.3 | 2114494.3 | 37.7852568239907 | -122.488153421892 | (37.7852568239907, -122.488153421892) | 11 | 6 | 1 | 55 | 33 | ||
109181 | 109089 | Permitted Site 7 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 218 28th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 3x3 | 5987170.3 | 2114494.3 | 37.7852568239907 | -122.488153421892 | (37.7852568239907, -122.488153421892) | 11 | 6 | 1 | 55 | 33 | ||
51580 | 109211 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 819 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773413 | 6011187.72328 | 2090968.52831 | 37.722032138266 | -122.403404362845 | (37.722032138266, -122.403404362845) | 10 | 3 | 7 | 309 | 28 | |
187522 | 109253 | DPW Maintained 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 1355 46th Ave | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773041 | 5981790.7 | 2105864.5 | 37.7612466017789 | -122.506124767382 | (37.7612466017789, -122.506124767382) | 1 | 8 | 3 | 56 | 35 |
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) );