trees
5,723 rows where qSpecies_id = 14 sorted by PermitNotes 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
89419 | 115274 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1830 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 777408 | 5984468.3 | 2102689.1 | 37.7526850963295 | -122.496629885272 | (37.7526850963295, -122.496629885272) | 1 | 8 | 3 | 56 | 35 | |||
157535 | 114321 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2118 47th Ave | 1 | Front Yard : Cutout | Landscaping | Private 2 | 01/14/2016 12:00:00 AM | 5x16 | Permit Number 777356 | 5981743.9 | 2100646.6 | 37.7469169691931 | -122.505899765145 | (37.7469169691931, -122.505899765145) | 1 | 8 | 3 | 29491 | 35 | ||
99611 | 114577 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3610 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | 30 | 3x3 | Permit Number 777195 | 5997470.26766 | 2115762.68023 | 37.7893349711866 | -122.452610443035 | (37.7893349711866, -122.452610443035) | 11 | 6 | 1 | 54 | 31 | |
161064 | 114972 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1431 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 777191 | 6000962.5 | 2110659.8 | 37.7755232425188 | -122.440161680014 | (37.7755232425188, -122.440161680014) | 15 | 5 | 11 | 29492 | 10 | |
178989 | 34546 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3625 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1997 12:00:00 AM | Permit Number 776883 | 6008512.67488418 | 2097989.46495614 | 37.7411603448387 | -122.413147584008 | (37.7411603448387, -122.413147584008) | 10 | 7 | 7 | 28859 | 2 | ||
157197 | 113938 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3000 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776872 | 5999473.11509 | 2119163.08751 | 37.7987861417299 | -122.445925515144 | (37.7987861417299, -122.445925515144) | 13 | 9 | 1 | 57 | 17 | |
39677 | 100514 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1X Treat Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2015 12:00:00 AM | 3 | 18x18 | Permit Number 776854 | 6009122.9 | 2107982.7 | 37.7686337575832 | -122.411743582031 | (37.7686337575832, -122.411743582031) | 8 | 4 | 7 | 28853 | 19 | |
88094 | 100518 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2X FLORIDA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776854 | 6009099 | 2107996 | 37.7686689355282 | -122.411827190456 | (37.7686689355282, -122.411827190456) | 8 | 4 | 7 | 28853 | 19 | |
101394 | 100519 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2X FLORIDA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776854 | 6009099 | 2107996 | 37.7686689355282 | -122.411827190456 | (37.7686689355282, -122.411827190456) | 8 | 4 | 7 | 28853 | 19 | |
99897 | 113549 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4500X 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2015 12:00:00 AM | 3x3 | Permit Number 776494 | 6001307.45082 | 2104071.52181 | 37.7574530911412 | -122.438496273023 | (37.7574530911412, -122.438496273023) | 2 | 4 | 5 | 28862 | 3 | ||
150097 | 113550 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4500X 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2015 12:00:00 AM | 3x3 | Permit Number 776494 | 6001307.45082 | 2104071.52181 | 37.7574530911412 | -122.438496273023 | (37.7574530911412, -122.438496273023) | 2 | 4 | 5 | 28862 | 3 | ||
137779 | 66904 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 225 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2016 12:00:00 AM | 3 | Permit Number 776293 | 6007580.09129508 | 2097612.98419124 | 37.7400742131662 | -122.416345472797 | (37.7400742131662, -122.416345472797) | 2 | 7 | 7 | 28859 | 2 | |
12115 | 115003 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 291 Whitney St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | Permit Number 776266 | 6004325.9 | 2096691 | 37.737359123084 | -122.42753146954 | (37.737359123084, -122.42753146954) | 2 | 7 | 5 | 63 | 7 | |||
162493 | 60670 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 291 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2015 12:00:00 AM | Permit Number 776266 | 6004331.68787007 | 2096689.31302497 | 37.737354818402 | -122.427511338031 | (37.737354818402, -122.427511338031) | 2 | 7 | 5 | 63 | 7 | ||
53419 | 32750 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 500 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/28/2015 12:00:00 AM | 1 | 3x3 | Permit Number 776233 | 5995920.63223 | 2088735.9867 | 37.7150375603089 | -122.456017264699 | (37.7150375603089, -122.456017264699) | 9 | 8 | 6 | 28861 | 24 | |
70850 | 111244 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 799X SANCHEZ ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2015 12:00:00 AM | 36 | 3x3 | Permit Number 776149 | 6003713 | 2103768 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | 2 | 4 | 5 | 28862 | 3 | |
38063 | 83288 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 164 Marietta Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | 3x3 | Permit Number 776115 | 5998661.46033678 | 2097891.48861403 | 37.7403333609851 | -122.447202361917 | (37.7403333609851, -122.447202361917) | 9 | 7 | 4 | 59 | 40 | ||
32448 | 114973 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 125 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 776087 | 5996468.6 | 2094435 | 37.7307171398869 | -122.454534722301 | (37.7307171398869, -122.454534722301) | 9 | 7 | 4 | 28861 | 40 | |||
58025 | 114963 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 284 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 776075 | 5994159.8 | 2088442 | 37.714129118114 | -122.462082099319 | (37.714129118114, -122.462082099319) | 9 | 8 | 6 | 28861 | 24 | |||
105599 | 256614 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1483 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776026 | 5987111.69916 | 2105187.42749 | 37.7596993421459 | -122.487672186767 | (37.7596993421459, -122.487672186767) | 1 | 8 | 3 | 56 | 35 | |
111189 | 115001 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 46 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2015 12:00:00 AM | Permit Number 775910 | 5993155.2 | 2098864.2 | 37.7426880232123 | -122.46631133897 | (37.7426880232123, -122.46631133897) | 1 | 8 | 4 | 59 | 40 | |||
26619 | 115723 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 147 Baltimore Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2016 12:00:00 AM | 3 | Permit Number 775898 | 6002684.2 | 2086288.6 | 37.7087034632659 | -122.432464808573 | (37.7087034632659, -122.432464808573) | 9 | 7 | 6 | 28861 | 5 | ||
190093 | 115269 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2218 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 775791 | 5986730.3 | 2100136.4 | 37.7458083387155 | -122.488619984215 | (37.7458083387155, -122.488619984215) | 1 | 8 | 3 | 29491 | 35 | |||
148218 | 115756 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1514 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775783 | 5998796.2 | 2089378.8 | 37.7169672098689 | -122.44612432488 | (37.7169672098689, -122.44612432488) | 9 | 7 | 6 | 28861 | 25 | ||
60940 | 115311 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 483 Faxon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2016 12:00:00 AM | Permit Number 775691 | 5994725.9 | 2091786.1 | 37.7233437971028 | -122.460367608597 | (37.7233437971028, -122.460367608597) | 9 | 8 | 4 | 28861 | 24 | |||
57330 | 115310 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1199 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2016 12:00:00 AM | Permit Number 775586 | 5995022.2 | 2091844.5 | 37.7235211897184 | -122.459347589211 | (37.7235211897184, -122.459347589211) | 9 | 8 | 4 | 28861 | 24 | |||
36713 | 115229 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 677 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 775542 | 5987138.4 | 2111350.8 | 37.776623806317 | -122.488032723116 | (37.776623806317, -122.488032723116) | 11 | 6 | 2 | 55 | 26 | |||
108557 | 114976 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 231 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 775532 | 5994424.6 | 2091464.1 | 37.7224423257418 | -122.461385806846 | (37.7224423257418, -122.461385806846) | 9 | 8 | 4 | 28861 | 24 | |||
176726 | 115240 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 507 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 775523 | 5981264.2 | 2112246.8 | 37.7787395279518 | -122.508419460029 | (37.7787395279518, -122.508419460029) | 11 | 6 | 2 | 55 | 26 | |||
7973 | 115236 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 742 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2016 12:00:00 AM | Permit Number 775515 | 5982957.8 | 2110723 | 37.7746552828593 | -122.502447924769 | (37.7746552828593, -122.502447924769) | 11 | 6 | 2 | 55 | 26 | |||
25816 | 94632 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3600 16th St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | 3x3 | Permit Number 775358 | 6002902 | 2106490 | 37.7641842232844 | -122.433154488347 | (37.7641842232844, -122.433154488347) | 15 | 4 | 5 | 28862 | 3 | ||
122015 | 59326 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 130 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2015 12:00:00 AM | Permit Number 775294 | 5998173.48699395 | 2105389.83328333 | 37.7608940771819 | -122.449429707195 | (37.7608940771819, -122.449429707195) | 15 | 5 | 11 | 29492 | 12 | ||
171095 | 122627 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 34 Country Club Dr | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/15/2016 12:00:00 AM | 3 | 3x4 | Permit Number 775279 | 5984731 | 2094410 | 37.7299683129055 | -122.495110985344 | (37.7299683129055, -122.495110985344) | 1 | 8 | 4 | 64 | 35 | |
118414 | 115163 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 41 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775222 | 6001328.5 | 2108884.4 | 37.7706692687709 | -122.438768350781 | (37.7706692687709, -122.438768350781) | 15 | 5 | 11 | 29492 | 9 | |||
3005 | 109931 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2822 Moraga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/12/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775171 | ||||||||||
12098 | 115181 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2166 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775165 | 5981753.9 | 2100346.3 | 37.7460930178281 | -122.505842927008 | (37.7460930178281, -122.505842927008) | 1 | 8 | 3 | 29491 | 35 | |||
142432 | 115178 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2582 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775071 | 5982161.7 | 2097535.9 | 37.7384004300806 | -122.50422468152 | (37.7384004300806, -122.50422468152) | 1 | 8 | 3 | 29491 | 35 | |||
98265 | 114812 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1315-- 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2015 12:00:00 AM | 8 | Permit Number 775040 | 5987054.5 | 2106285.6 | 37.7627112856961 | -122.487950697253 | (37.7627112856961, -122.487950697253) | 1 | 8 | 3 | 56 | 35 | ||
136928 | 114813 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1315-- 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Permit Number 775040 | 5987054.5 | 2106285.6 | 37.7627112856961 | -122.487950697253 | (37.7627112856961, -122.487950697253) | 1 | 8 | 3 | 56 | 35 | |||
118899 | 110310 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 899x Stanyan St | 4 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 04/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774992 | 5997166.64381 | 2107575.86009 | 37.7668387037649 | -122.45306972129 | (37.7668387037649, -122.45306972129) | 15 | 5 | 11 | 29492 | 8 | |
172695 | 110311 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 899x Stanyan St | 5 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 04/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774992 | 5997166.64381 | 2107575.86009 | 37.7668387037649 | -122.45306972129 | (37.7668387037649, -122.45306972129) | 15 | 5 | 11 | 29492 | 8 | |
60845 | 113548 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1911 20th St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/30/2015 12:00:00 AM | 1 | Permit Number 774960 | 6012300.00129 | 2104664.7502 | 37.7597011244298 | -122.400521077012 | (37.7597011244298, -122.400521077012) | 10 | 3 | 8 | 28856 | 29 | ||
109511 | 64633 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 194 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/24/2015 12:00:00 AM | 1 | Permit Number 774889 | 6013135.37911 | 2106215.95355 | 37.7640069398975 | -122.397740705065 | (37.7640069398975, -122.397740705065) | 14 | 3 | 8 | 28856 | 29 | ||
160250 | 108108 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 901x YORK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774841 | 6009981 | 2103887 | 37.7574359966054 | -122.408486525898 | (37.7574359966054, -122.408486525898) | 2 | 4 | 7 | 28859 | 19 | |
2679 | 261736 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 540 De Haro St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
7112 | 261737 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 540 De Haro St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
9940 | 261738 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 540 De Haro St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
17602 | 261735 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 540 De Haro St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 02/25/2020 12:00:00 AM | 3 | Permit Number 774839 | 6012051.5879 | 2105883.7172 | 37.7630342801454 | -122.401465890035 | (37.7630342801454, -122.401465890035) | 8 | 3 | 8 | 28856 | 29 | ||
112908 | 109330 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1329 CLAYTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2015 12:00:00 AM | 3 | 2.5x2.5 | Permit Number 774837 | 5999055 | 2105304 | 37.7607087868046 | -122.446374778866 | (37.7607087868046, -122.446374778866) | 15 | 5 | 5 | 28862 | 12 | |
32075 | 109188 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 482 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774830 | 5981628.45653 | 2112492.50566 | 37.7794356235543 | -122.507177609428 | (37.7794356235543, -122.507177609428) | 11 | 6 | 2 | 55 | 26 |
170475 | 109189 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 482 46th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774830 | 5981625.7586 | 2112517.84773 | 37.7795050464814 | -122.507188823101 | (37.7795050464814, -122.507188823101) | 11 | 6 | 2 | 55 | 26 |
24048 | 109149 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 56-98X Capistrano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2015 12:00:00 AM | 3 | Permit Number 774812 | 6001217.27385 | 2093926.25582 | 37.7295914563619 | -122.438081423517 | (37.7295914563619, -122.438081423517) | 9 | 7 | 6 | 28861 | 25 | ||
117819 | 109152 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 56-98X Capistrano Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2015 12:00:00 AM | 3 | Permit Number 774812 | 6001217.27385 | 2093926.25582 | 37.7295914563619 | -122.438081423517 | (37.7295914563619, -122.438081423517) | 9 | 7 | 6 | 28861 | 25 | ||
139014 | 109148 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 56-98X Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2015 12:00:00 AM | 3 | Permit Number 774812 | 6001217.27385 | 2093926.25582 | 37.7295914563619 | -122.438081423517 | (37.7295914563619, -122.438081423517) | 9 | 7 | 6 | 28861 | 25 | ||
144949 | 109150 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 56-98X Capistrano Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2015 12:00:00 AM | 3 | Permit Number 774812 | 6001217.27385 | 2093926.25582 | 37.7295914563619 | -122.438081423517 | (37.7295914563619, -122.438081423517) | 9 | 7 | 6 | 28861 | 25 | ||
122256 | 254396 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 167 Harvard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 774780 | 6006150.23201 | 2093073.81475 | 37.7275301484246 | -122.420967149802 | (37.7275301484246, -122.420967149802) | 9 | 7 | 7 | 309 | 5 | |
176317 | 256115 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 503 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 774745 | 6007867.72621 | 2096528.91607 | 37.7371137709195 | -122.41527422465 | (37.7371137709195, -122.41527422465) | 2 | 7 | 7 | 28859 | 2 | |
170397 | 36938 | Private 9 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 351 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774744 | 5992449.52236815 | 2113091.823439 | 37.781712581861 | -122.469786951776 | (37.781712581861, -122.469786951776) | 11 | 6 | 2 | 54 | 11 | |
5983 | 110477 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 131X Washington St | 1 | Back Yard : Yard | Tree | Private 2 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 6013427.21844 | 2117958.83498 | 37.7962664536588 | -122.397554954018 | (37.7962664536588, -122.397554954018) | 3 | 1 | 10 | 28860 | 6 | |
26906 | 110476 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3700 Washington St | 1 | Back Yard : Yard | Tree | Private 2 | 04/16/2015 12:00:00 AM | 3 | 10x10 | Permit Number 774729 | 5997015.1 | 2115715 | 37.7891779638687 | -122.454181816252 | (37.7891779638687, -122.454181816252) | 11 | 6 | 1 | 54 | 31 | |
92900 | 64961 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 120 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2015 12:00:00 AM | Permit Number 774717 | 6004261.49676722 | 2097472.14872907 | 37.7395003369823 | -122.427809784477 | (37.7395003369823, -122.427809784477) | 2 | 7 | 5 | 63 | 7 | |||
182156 | 81731 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2371 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2015 12:00:00 AM | 3x3 | Permit Number 774678 | 5982660.98623523 | 2098988.34584031 | 37.7424177991727 | -122.502605897625 | (37.7424177991727, -122.502605897625) | 1 | 8 | 3 | 29491 | 35 | ||
68241 | 108840 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 171 Vienna St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774672 | 6004535.74354 | 2092399.57178 | 37.7255876870469 | -122.426500461978 | (37.7255876870469, -122.426500461978) | 9 | 7 | 6 | 28861 | 5 | |
122992 | 108838 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 267 Prague St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774666 | 6004068.9172 | 2089601.41292 | 37.717878156846 | -122.427914943595 | (37.717878156846, -122.427914943595) | 9 | 7 | 6 | 28861 | 5 | |
172196 | 108835 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 582 Paris St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774664 | 6001569.98355 | 2090273.86395 | 37.7195828682199 | -122.436600744727 | (37.7195828682199, -122.436600744727) | 9 | 7 | 6 | 28861 | 5 | |
13863 | 108832 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 60 Ney St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774659 | 6003833.887 | 2093995.50335 | 37.7299300570357 | -122.429040457944 | (37.7299300570357, -122.429040457944) | 9 | 7 | 6 | 28861 | 5 | |
187763 | 108735 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1514 21st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774640 | 5989640.68368 | 2105037.22287 | 37.759434101142 | -122.478914795236 | (37.759434101142, -122.478914795236) | 1 | 8 | 3 | 56 | 35 | |
2116 | 108701 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 478 30th St | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774626 | 6003507.49152 | 2098366.33094 | 37.7419128730633 | -122.43048058961 | (37.7419128730633, -122.43048058961) | 2 | 7 | 5 | 63 | 22 | |
113835 | 108696 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3219 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774620 | 6003723.12183 | 2119813.07153 | 37.8008125903965 | -122.431265542364 | (37.8008125903965, -122.431265542364) | 13 | 9 | 1 | 57 | 17 |
18452 | 108642 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 167 Judson Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774606 | 5998978.54245 | 2093474.85877 | 37.7282244523119 | -122.44578846914 | (37.7282244523119, -122.44578846914) | 9 | 7 | 4 | 28861 | 40 | |
49227 | 108638 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 414 Hearst Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/30/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774605 | 5998661.98035 | 2094402.21639 | 37.7307526786149 | -122.446949537766 | (37.7307526786149, -122.446949537766) | 9 | 7 | 4 | 59 | 40 | |
68443 | 24736 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 7630 Geary Blvd To Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2015 12:00:00 AM | 1 | 3x3 | Permit Number 774506 | 5983286.15671 | 2112505.72861 | 37.7795694254676 | -122.501443995349 | (37.7795694254676, -122.501443995349) | 11 | 6 | 2 | 55 | 26 | |
40028 | 57959 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 336 Hanover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2017 12:00:00 AM | 3 | 3x3 | Permit Number 774423 | 5999490.29697456 | 2086502.70799744 | 37.7091097236101 | -122.443518692288 | (37.7091097236101, -122.443518692288) | 9 | 7 | 6 | 28861 | 5 | |
48396 | 109097 | Property Tree 8 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 601 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774331 | 6002630.6 | 2098839.9 | 37.7431634703749 | -122.43354642925 | (37.7431634703749, -122.43354642925) | 2 | 7 | 5 | 63 | 7 |
83530 | 115292 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2058 17th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/22/2016 12:00:00 AM | Permit Number 774300 | 5991031.5 | 2101384 | 37.7494839769409 | -122.473838198075 | (37.7494839769409, -122.473838198075) | 1 | 8 | 4 | 29491 | 12 | |||
155855 | 109692 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 943 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774281 | 6003685.4 | 2089620.3 | 37.7179083124774 | -122.429241939063 | (37.7179083124774, -122.429241939063) | 9 | 7 | 6 | 28861 | 5 |
175966 | 97340 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1455 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774279 | 5988651.4823 | 2098958.5529 | 37.7426862015352 | -122.481890624504 | (37.7426862015352, -122.481890624504) | 1 | 8 | 3 | 29491 | 35 | |
142863 | 109691 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 926 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/27/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774277 | 6003588.14539 | 2089614.80455 | 37.7178877169308 | -122.429577713667 | (37.7178877169308, -122.429577713667) | 9 | 7 | 6 | 28861 | 5 |
78328 | 74724 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1055 Pine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/17/2014 12:00:00 AM | 3 | Permit Number 774207 | 6008888.65221 | 2115945.87795 | 37.7904856069694 | -122.413116978879 | (37.7904856069694, -122.413116978879) | 5 | 1 | 10 | 28858 | 21 | ||
80371 | 74571 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1055 Pine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/2014 12:00:00 AM | 3 | Permit Number 774207 | 6008908.989 | 2115950.02828 | 37.7904981444129 | -122.413046908194 | (37.7904981444129, -122.413046908194) | 5 | 1 | 10 | 28858 | 21 | |
104900 | 112766 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 209 Minerva St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2015 12:00:00 AM | Permit Number 774179 | 5994932.2 | 2088977.2 | 37.715643091976 | -122.459451143491 | (37.715643091976, -122.459451143491) | 9 | 8 | 6 | 28861 | 24 | ||
113793 | 44460 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1543 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2015 12:00:00 AM | 1 | Permit Number 774159 | 6006374.3577 | 2092477.5987 | 37.7259056999789 | -122.420150048693 | (37.7259056999789, -122.420150048693) | 9 | 7 | 7 | 309 | 5 | |
187601 | 44461 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1543 Felton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/01/2015 12:00:00 AM | 1 | Permit Number 774159 | 6006415.39359 | 2092491.7152 | 37.7259467729087 | -122.42000919148 | (37.7259467729087, -122.42000919148) | 9 | 7 | 7 | 309 | 5 | |
71759 | 112768 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 248 Harold Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2015 12:00:00 AM | Permit Number 774129 | 5996862.7 | 2091541.5 | 37.7227948711442 | -122.4529634838 | (37.7227948711442, -122.4529634838) | 9 | 8 | 6 | 28861 | 24 | ||
49214 | 219632 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 878 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2015 12:00:00 AM | 1 | Width 3ft | Permit Number 774094 | 6010166.13097 | 2104121.45382 | 37.7580901202723 | -122.407862798639 | (37.7580901202723, -122.407862798639) | 2 | 4 | 7 | 28859 | 19 | |
50695 | 108975 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 878 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774094 | 6010152.1 | 2104117.3 | 37.7580779292919 | -122.407911031062 | (37.7580779292919, -122.407911031062) | 2 | 4 | 7 | 28859 | 19 |
126529 | 114703 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 225 Woolsey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2015 12:00:00 AM | 1 | Permit Number 774054 | 6011021.11321 | 2091977.24554 | 37.7247925605111 | -122.404051248766 | (37.7247925605111, -122.404051248766) | 10 | 3 | 7 | 309 | 28 | ||
11143 | 258742 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 367 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2019 12:00:00 AM | 3 | 3x3 | Permit Number 774042 | 6003945 | 2103884 | 37.7570878795298 | -122.429361203627 | (37.7570878795298, -122.429361203627) | 2 | 4 | 5 | 28862 | 3 | |
75920 | 107665 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1901 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2014 12:00:00 AM | 3 | Permit Number 774040 | 6004992.97404 | 2117395.95155 | 37.794247676908 | -122.42669909504 | (37.794247676908, -122.42669909504) | 13 | 9 | 1 | 28858 | 27 | ||
160637 | 40115 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1901 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2014 12:00:00 AM | 3 | Permit Number 774040 | 6005036.86664929 | 2117421.65480501 | 37.7943207329719 | -122.426549052687 | (37.7943207329719, -122.426549052687) | 13 | 9 | 1 | 28858 | 27 | ||
63235 | 115275 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2474 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 774024 | 5982446.7 | 2098277.8 | 37.7404542411895 | -122.503294223796 | (37.7404542411895, -122.503294223796) | 1 | 8 | 3 | 29491 | 35 | |||
138896 | 109073 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1366 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773979 | 5991180.2 | 2106120.4 | 37.7624974952767 | -122.473669459996 | (37.7624974952767, -122.473669459996) | 1 | 8 | 11 | 56 | 12 |
120242 | 11578 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3930 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | 4x10 | Permit Number 773955 | 5982364 | 2105595 | 37.760540363416 | -122.504122035983 | (37.760540363416, -122.504122035983) | 1 | 8 | 3 | 56 | 35 | |
107855 | 109042 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2611 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773886 | 5988906.4 | 2097539.8 | 37.7388054980833 | -122.480905351261 | (37.7388054980833, -122.480905351261) | 1 | 8 | 3 | 29491 | 35 |
26651 | 108767 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 500X Lathrop Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
39034 | 108763 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 500X Lathrop Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
61760 | 108770 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 500X Lathrop Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
107447 | 108777 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 500X Lathrop Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
113509 | 108774 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 500X Lathrop Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773822 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | 10 | 3 | 8 | 309 | 1 | |
33934 | 45243 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1000-1098X Woolsey St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773816 | 6008759.06383256 | 2091334.69120464 | 37.7229015956225 | -122.411825527366 | (37.7229015956225, -122.411825527366) | 9 | 3 | 7 | 309 | 28 |
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) );