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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
127616 | 85251 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1151 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2007 12:00:00 AM | 3 | 3x3 | Under 3yr maintenance agreement. Expires 6/15/2010. | 6001497.16836 | 2088486.70556 | 37.7146715920273 | -122.43672457862 | (37.7146715920273, -122.43672457862) | 9 | 7 | 6 | 28861 | 5 | |
164286 | 53970 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1362 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/1972 12:00:00 AM | 6 | Permit Number 9685 | 5988675.3296 | 2106056.0456 | 37.7621754078315 | -122.482328071622 | (37.7621754078315, -122.482328071622) | 1 | 8 | 3 | 56 | 35 | ||
4268 | 204887 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 381 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/1972 12:00:00 AM | 7 | Width 3ft | Permit Number 9510 | 5992671.12766 | 2094035.9384 | 37.729402884631 | -122.467634050386 | (37.729402884631, -122.467634050386) | 9 | 8 | 4 | 59 | 40 | |
131428 | 30425 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 367 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/1956 12:00:00 AM | 5 | Permit Number 79 | 6011159.52441 | 2119665.62673 | 37.800826359895 | -122.405521953284 | (37.800826359895, -122.405521953284) | 3 | 1 | 10 | 308 | 23 | ||
6289 | 204865 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 209 Wawona St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 787675 | 5992600.05898 | 2097817.49879 | 37.7397819999276 | -122.468154715592 | (37.7397819999276, -122.468154715592) | 1 | 8 | 4 | 59 | 40 | |
9463 | 205558 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 24 Merced Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/14/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785258 | 5995231.87418 | 2100136.53584 | 37.7463011440963 | -122.459222960193 | (37.7463011440963, -122.459222960193) | 1 | 8 | 4 | 59 | 40 | |
16763 | 205559 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 24 Merced Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 04/14/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785258 | 5995247.10792 | 2100152.69765 | 37.74634639618 | -122.459171454206 | (37.74634639618, -122.459171454206) | 1 | 8 | 4 | 59 | 40 | |
13118 | 204869 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2570 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785253 | 5992086.28225 | 2097946.7819 | 37.7401072928198 | -122.469940532643 | (37.7401072928198, -122.469940532643) | 1 | 8 | 4 | 59 | 40 | |
18283 | 204870 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2570 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785253 | 5992085.54647 | 2097970.62901 | 37.7401727283979 | -122.469944812517 | (37.7401727283979, -122.469944812517) | 1 | 8 | 4 | 59 | 40 | |
2278 | 204025 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 345 Grafton Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | FUF | 04/13/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785247 | 5995726.34615 | 2090539.61949 | 37.7199787576063 | -122.456819166779 | (37.7199787576063, -122.456819166779) | 9 | 8 | 6 | 28861 | 24 |
14885 | 204090 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 520 Garfield St | 1 | : | Tree | Private 2 | 04/13/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785246 | 5992622.63923 | 2090513.25983 | 37.7197276740608 | -122.467545605645 | (37.7197276740608, -122.467545605645) | 9 | 8 | 6 | 64 | 24 | |
11539 | 262395 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2755 40th Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/21/2020 12:00:00 AM | 3 | 3x3 | Permit Number 784406 | 5983997.14788 | 2096421.7593 | 37.7354490751144 | -122.497796450434 | (37.7354490751144, -122.497796450434) | 1 | 8 | 3 | 29491 | 35 | |
77115 | 258442 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2671 46th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783276 | 5982116.53191 | 2096931.04259 | 37.7367370009212 | -122.504336052062 | (37.7367370009212, -122.504336052062) | 1 | 8 | 3 | 29491 | 35 | |
158295 | 258423 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1574 46th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783273 | 5981901.80485 | 2104381.69613 | 37.7571817847752 | -122.505630587503 | (37.7571817847752, -122.505630587503) | 1 | 8 | 3 | 56 | 35 | |
165923 | 258344 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1367 45th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/06/2019 12:00:00 AM | 3 | 3x3 | Permit Number 783237 | 5982123.28365 | 2105802.38537 | 37.7610956253843 | -122.504969918121 | (37.7610956253843, -122.504969918121) | 1 | 8 | 3 | 56 | 35 | |
47339 | 257897 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1920 41st Ave | : Cutout | Tree | Private 2 | FUF | 01/15/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782788 | 5983533.51637 | 2102067.62361 | 37.7509238827647 | -122.499816549562 | (37.7509238827647, -122.499816549562) | 1 | 8 | 3 | 29491 | 35 | |
1558 | 256904 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1571 37th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/03/2019 12:00:00 AM | 3 | 3x3 | Permit Number 782743 | 5984651.59496 | 2104500.79365 | 37.7576702424259 | -122.496129679735 | (37.7576702424259, -122.496129679735) | 1 | 8 | 3 | 56 | 35 | |
86995 | 52550 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1527 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2018 12:00:00 AM | 3 | Permit Number 782739 | 5984635.73167971 | 2104787.38586659 | 37.7584562156449 | -122.496205685195 | (37.7584562156449, -122.496205685195) | 1 | 8 | 3 | 56 | 35 | |
5552 | 140161 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 251 ASHBURY ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | Permit Number 782679 | 5998791.141 | 2109784.5074 | 37.7729960548875 | -122.44760988047 | (37.7729960548875, -122.44760988047) | 15 | 5 | 11 | 29492 | 16 | ||
6526 | 140160 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 251 ASHBURY ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | Permit Number 782679 | 5998786.9251 | 2109803.6706 | 37.773048431195 | -122.447625843455 | (37.773048431195, -122.447625843455) | 15 | 5 | 11 | 29492 | 16 | ||
13456 | 140159 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 251 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | Permit Number 782679 | 5998783.859 | 2109828.5826 | 37.7731166579469 | -122.447638243085 | (37.7731166579469, -122.447638243085) | 15 | 5 | 11 | 29492 | 16 | ||
1857 | 219599 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 953 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | Permit Number 782497 | 6008614.00505 | 2103032.05792 | 37.7550118695111 | -122.41315370269 | (37.7550118695111, -122.41315370269) | 2 | 4 | 7 | 28859 | 19 | ||
3704 | 219600 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 953 Treat Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | Permit Number 782497 | 6008613.26133 | 2103064.87325 | 37.7551019312323 | -122.413158594994 | (37.7551019312323, -122.413158594994) | 2 | 4 | 7 | 28859 | 19 | ||
72404 | 90852 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2439 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782290 | 5987980.63943 | 2110496.20326 | 37.7743264199702 | -122.485056492221 | (37.7743264199702, -122.485056492221) | 11 | 6 | 2 | 55 | 26 | |
138633 | 247782 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 274 30th St | 1 | : | Tree | Private 2 | 6 | Width 3ft | Permit Number 782244 | 6004804.71628 | 2098445.98307 | 37.7422049794818 | -122.426000872448 | (37.7422049794818, -122.426000872448) | 2 | 7 | 5 | 63 | 22 | ||
191944 | 105385 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3934 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/2018 12:00:00 AM | 3 | 7x4 | Permit Number 782220 | 5995901.48242 | 2115548.91761 | 37.7886580254237 | -122.458022746601 | (37.7886580254237, -122.458022746601) | 11 | 6 | 1 | 54 | 31 | |
164830 | 205019 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 799 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2018 12:00:00 AM | 3 | Width 2ft | Permit Number 782157 | 5996841.53997 | 2094990.29904 | 37.7322632404509 | -122.453285492137 | (37.7322632404509, -122.453285492137) | 9 | 7 | 4 | 59 | 40 | |
114957 | 255490 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1345 Ocean Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781959 | 5995771.36887 | 2091978.31443 | 37.7239316573406 | -122.456767536047 | (37.7239316573406, -122.456767536047) | 9 | 8 | 4 | 28861 | 24 | |
95904 | 256882 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3075 25th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/21/2018 12:00:00 AM | 3 | 3x10 | Permit Number 781920 | 5988824.60597 | 2094879.63635 | 37.7314966214822 | -122.480993433312 | (37.7314966214822, -122.480993433312) | 1 | 8 | 4 | 64 | 35 | |
140218 | 256881 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3075 25th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/21/2018 12:00:00 AM | 3 | 3x10 | Permit Number 781920 | 5988824.60597 | 2094879.63635 | 37.7314966214822 | -122.480993433312 | (37.7314966214822, -122.480993433312) | 1 | 8 | 4 | 64 | 35 | |
192334 | 255396 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 48 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/17/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781889 | 6010638.4313 | 2100429.44362 | 37.7479791063891 | -122.405969289482 | (37.7479791063891, -122.405969289482) | 2 | 7 | 7 | 28859 | 2 |
131553 | 256083 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2187 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781873 | 5989736 | 2100494 | 37.7469651502436 | -122.478252958666 | (37.7469651502436, -122.478252958666) | 1 | 8 | 3 | 29491 | 35 | |
2678 | 157809 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 647 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781831 | 6002443.37703 | 2099727.28553 | 37.7455893990301 | -122.4342572226 | (37.7455893990301, -122.4342572226) | 2 | 7 | 5 | 63 | 22 | |
36772 | 219612 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3725 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | Permit Number 781657 | 6005463.61082 | 2104281.77344 | 37.7582659314531 | -122.424137549134 | (37.7582659314531, -122.424137549134) | 2 | 4 | 5 | 28859 | 19 | ||
17594 | 254853 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 799 Avalon Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781645 | |||||||||||
6964 | 162755 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 991x Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781607 | 5995095 | 2090528 | 37.7199105805333 | -122.459000657746 | (37.7199105805333, -122.459000657746) | 9 | 8 | 6 | 28861 | 24 | |
25884 | 162754 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 997x Capitol Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 781607 | 5995095 | 2090528 | 37.7199105805333 | -122.459000657746 | (37.7199105805333, -122.459000657746) | 9 | 8 | 6 | 28861 | 24 | |
60693 | 254809 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 571 32nd Ave | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/29/2018 12:00:00 AM | 3 | Permit Number 781555 | 5985946.54219 | 2112020.89571 | 37.778394097385 | -122.492205001438 | (37.778394097385, -122.492205001438) | 11 | 6 | 2 | 55 | 26 | |||
83162 | 254657 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2488 20th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/12/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781543 | 5990177.21335 | 2098449.1475 | 37.741376119024 | -122.476577935241 | (37.741376119024, -122.476577935241) | 1 | 8 | 3 | 29491 | 35 | |
62869 | 254648 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 139 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/08/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781531 | 6004195.65769 | 2092853.5748 | 37.7268150472913 | -122.427708443617 | (37.7268150472913, -122.427708443617) | 9 | 7 | 6 | 28861 | 5 |
65342 | 171450 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 170 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 781529 | 6004500.13705 | 2092415.89266 | 37.7256304876314 | -122.426624712387 | (37.7256304876314, -122.426624712387) | 9 | 7 | 6 | 28861 | 5 | |
152898 | 175330 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 96 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781320 | 6011072.40293 | 2088273.47466 | 37.7146256285428 | -122.403613472283 | (37.7146256285428, -122.403613472283) | 9 | 7 | 8 | 309 | 39 |
100060 | 217956 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2215 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781289 | 5990997.94076 | 2100310.89341 | 37.746535561373 | -122.47387596681 | (37.746535561373, -122.47387596681) | 1 | 8 | 4 | 29491 | 40 |
7853 | 254252 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 25 Madrone Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781269 | 5992974.7928 | 2098963.72085 | 37.7429508712544 | -122.466942363368 | (37.7429508712544, -122.466942363368) | 1 | 8 | 4 | 59 | 40 |
53917 | 216313 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 25 Madrone Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781269 | 5992975.08594 | 2098974.67773 | 37.742980972991 | -122.466942146163 | (37.742980972991, -122.466942146163) | 1 | 8 | 4 | 59 | 40 |
145131 | 254218 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2343 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781242 | 5991031.80958 | 2099459.54032 | 37.7441999276063 | -122.473696758523 | (37.7441999276063, -122.473696758523) | 1 | 8 | 4 | 29491 | 40 |
65069 | 254216 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2333 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781241 | 5991029.55411 | 2099524.84245 | 37.7443790997741 | -122.473709320163 | (37.7443790997741, -122.473709320163) | 1 | 8 | 4 | 29491 | 40 |
105097 | 81268 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2254 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781238 | 5992017.76094021 | 2100096.08796794 | 37.746004777226 | -122.470333931585 | (37.746004777226, -122.470333931585) | 1 | 8 | 4 | 29491 | 40 |
57819 | 258202 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2422 41st Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/16/2019 12:00:00 AM | 3 | 3x3 | Permit Number 781120 | 5983650.02463 | 2098655.15546 | 37.741561019666 | -122.499161539913 | (37.741561019666, -122.499161539913) | 1 | 8 | 3 | 29491 | 35 | |
35632 | 182616 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1856 28th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/16/2018 12:00:00 AM | 0 | Width 0ft | Permit Number 780914 | 5987553.0951 | 2102630.1854 | 37.7527035840583 | -122.485957928463 | (37.7527035840583, -122.485957928463) | 1 | 8 | 3 | 56 | 35 | |
119839 | 152118 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 44 Woodward St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780873 | 6006474.76942 | 2108215.62621 | 37.7691244070031 | -122.420919809024 | (37.7691244070031, -122.420919809024) | 8 | 4 | 7 | 28853 | 19 | |
46623 | 123325 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 798 05th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Permit Number 780721 | 5994467.5512 | 2110242.48836 | 37.7740055063811 | -122.462598824841 | (37.7740055063811, -122.462598824841) | 11 | 6 | 2 | 54 | 11 | |||
69635 | 123324 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 798 05th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Permit Number 780721 | 5994466.95086 | 2110266.43708 | 37.7740712286384 | -122.462602639066 | (37.7740712286384, -122.462602639066) | 11 | 6 | 2 | 54 | 11 | |||
150687 | 123527 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2850 Fulton St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | Permit Number 780721 | 5994500.1201 | 2110215.19956 | 37.7739324541636 | -122.462484184544 | (37.7739324541636, -122.462484184544) | 11 | 6 | 2 | 54 | 11 | ||
20702 | 37086 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1426 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/22/2017 12:00:00 AM | 3 | Permit Number 780691 | 5981873.63686209 | 2105374.96731705 | 37.7599073668224 | -122.505801636192 | (37.7599073668224, -122.505801636192) | 1 | 8 | 3 | 56 | 35 | |
106941 | 219785 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 683 Duncan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780690 | 6002082.57154 | 2099708.00243 | 37.7455159666962 | -122.435503451831 | (37.7455159666962, -122.435503451831) | 2 | 7 | 5 | 63 | 22 | |
84790 | 253242 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 299X Moncada Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2 | Permit Number 780627 | 5992091 | 2093757 | 37.7286034765424 | -122.469619290083 | (37.7286034765424, -122.469619290083) | 9 | 8 | 4 | 59 | 40 | |||
89695 | 253243 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 299X Moncada Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2 | Permit Number 780627 | 5992091 | 2093757 | 37.7286034765424 | -122.469619290083 | (37.7286034765424, -122.469619290083) | 9 | 8 | 4 | 59 | 40 | |||
103256 | 253240 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 101 Paloma Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2 | Permit Number 780627 | 5992091 | 2093757 | 37.7286034765424 | -122.469619290083 | (37.7286034765424, -122.469619290083) | 9 | 8 | 4 | 59 | 40 | |||
171484 | 253235 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 101 Paloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x2 | Permit Number 780627 | 5992091 | 2093757 | 37.7286034765424 | -122.469619290083 | (37.7286034765424, -122.469619290083) | 9 | 8 | 4 | 59 | 40 | |||
12391 | 221098 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2815 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 12:00:00 AM | 3 | 4x4 | Permit Number 780566 | 6009314.5684 | 2105431.86525 | 37.7616405016156 | -122.410900429722 | (37.7616405016156, -122.410900429722) | 2 | 4 | 7 | 28859 | 19 | |
105377 | 64013 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3934 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/11/2017 12:00:00 AM | 3 | 7x4 | Permit Number 780499 | 5995918.46244 | 2115550.14517 | 37.7886623715551 | -122.457964087488 | (37.7886623715551, -122.457964087488) | 11 | 6 | 1 | 54 | 31 | |
36929 | 256611 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 80 Terra Vista Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780481 | 6000092 | 2112863 | 37.7815230689536 | -122.443331223004 | (37.7815230689536, -122.443331223004) | 15 | 5 | 1 | 29490 | 16 | |
78803 | 256612 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2375 Ofarrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780481 | 6000092 | 2112863 | 37.7815230689536 | -122.443331223004 | (37.7815230689536, -122.443331223004) | 15 | 5 | 1 | 29490 | 16 | |
99613 | 256169 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 80 Terra Vista Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780481 | 6000092 | 2112863 | 37.7815230689536 | -122.443331223004 | (37.7815230689536, -122.443331223004) | 15 | 5 | 1 | 29490 | 16 | |
102847 | 256610 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 80 Terra Vista Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/07/2018 12:00:00 AM | 3 | 3x3 | Permit Number 780481 | 6000092 | 2112863 | 37.7815230689536 | -122.443331223004 | (37.7815230689536, -122.443331223004) | 15 | 5 | 1 | 29490 | 16 | |
145159 | 255476 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3099 California St | : | Tree | Private 2 | FUF | 05/25/2018 12:00:00 AM | 3 | Permit Number 780282 | 5999555.47805 | 2115010.95429 | 37.7873901837957 | -122.445341811443 | (37.7873901837957, -122.445341811443) | 15 | 6 | 1 | 29490 | 31 | ||
113810 | 88721 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 833 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780265 | 5987866.10195 | 2110280.46308 | 37.7737273853775 | -122.485436858685 | (37.7737273853775, -122.485436858685) | 11 | 6 | 2 | 55 | 26 | |
77615 | 213163 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 142 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780043 | 5995654.76041 | 2090862.89111 | 37.7208622740576 | -122.457089984111 | (37.7208622740576, -122.457089984111) | 9 | 8 | 6 | 28861 | 24 | |
11552 | 245177 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 119 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | Permit Number 780020 | 6000299.8756 | 2109409.2021 | 37.7720516702596 | -122.442364048942 | (37.7720516702596, -122.442364048942) | 15 | 5 | 11 | 29492 | 9 | ||
59070 | 25759 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1536 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/23/2017 12:00:00 AM | 3 | 3X3 | Permit Number 779613 | 6003087.54114 | 2087663.41758 | 37.7125012778973 | -122.431168873349 | (37.7125012778973, -122.431168873349) | 9 | 7 | 6 | 28861 | 5 | |
59056 | 160371 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 868 Edinburgh St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779314 | 6001686.38396 | 2088939.39451 | 37.7159253269669 | -122.436102948002 | (37.7159253269669, -122.436102948002) | 9 | 7 | 6 | 28861 | 5 | |
158600 | 160369 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 868 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779314 | 6001700.06015 | 2088961.7176 | 37.7159873981889 | -122.436057273237 | (37.7159873981889, -122.436057273237) | 9 | 7 | 6 | 28861 | 5 | |
179839 | 160370 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 868 Edinburgh St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779314 | 6001693.73373 | 2088950.71414 | 37.715956825716 | -122.436078353349 | (37.715956825716, -122.436078353349) | 9 | 7 | 6 | 28861 | 5 | |
146170 | 43158 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 251 Harvard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779279 | 6006275.83968 | 2092663.45342 | 37.7264104651465 | -122.420503806033 | (37.7264104651465, -122.420503806033) | 9 | 7 | 7 | 309 | 5 | |
59845 | 121650 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 90 Fernwood Dr | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2017 12:00:00 AM | 3 | 2x2 | Permit Number 779248 | 5994730 | 2095273 | 37.7329182144954 | -122.46060599284 | (37.7329182144954, -122.46060599284) | 9 | 8 | 4 | 59 | 40 | |
152758 | 41173 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3253 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2016 12:00:00 AM | 3 | Permit Number 779130 | 5999305.0198 | 2120031.74997 | 37.8011616559474 | -122.446569707626 | (37.8011616559474, -122.446569707626) | 13 | 9 | 1 | 57 | 17 | |
37533 | 253101 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3000x Irving St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427 | 2106455 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | 1 | 8 | 3 | 56 | 35 | |
169212 | 253102 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3000x Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427 | 2106455 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | 1 | 8 | 3 | 56 | 35 | |
176443 | 253103 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3000x Irving St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427 | 2106455 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | 1 | 8 | 3 | 56 | 35 | |
186709 | 253104 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3000x Irving St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778939 | 5986427 | 2106455 | 37.7631397866436 | -122.490133427734 | (37.7631397866436, -122.490133427734) | 1 | 8 | 3 | 56 | 35 | |
171699 | 121206 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 930 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778903 | 6007356.48577 | 2120579.52821 | 37.8031223210123 | -122.418746939923 | (37.8031223210123, -122.418746939923) | 5 | 1 | 1 | 28858 | 32 | |
26748 | 88385 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 139 19th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778767 | 5989887.12414 | 2114429.03218 | 37.7852357408604 | -122.478749371232 | (37.7852357408604, -122.478749371232) | 11 | 6 | 2 | 55 | 26 | ||
70837 | 37274 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3861 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2016 12:00:00 AM | 3 | Permit Number 778685 | 6002725.39128498 | 2102957.76189665 | 37.7544755272865 | -122.433512881799 | (37.7544755272865, -122.433512881799) | 2 | 4 | 5 | 28862 | 22 | |
62784 | 165665 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 14 Vasquez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778649 | 5995764.46908 | 2100162.80413 | 37.7464038754353 | -122.457383222478 | (37.7464038754353, -122.457383222478) | 1 | 5 | 4 | 59 | 40 |
59513 | 254754 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3044 Ulloa St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 778626 | 5986607.78234 | 2098260.29291 | 37.7406498995894 | -122.488905737407 | (37.7406498995894, -122.488905737407) | 1 | 8 | 3 | 29491 | 35 | |||
161610 | 117380 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 823 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2016 12:00:00 AM | 3 | Permit Number 778551 | 5981342 | 2110110.3 | 37.7728779129239 | -122.507991719286 | (37.7728779129239, -122.507991719286) | 11 | 6 | 2 | 55 | 26 | ||
125752 | 117352 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2066 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778538 | 5986073.6 | 2101175.7 | 37.7486236329866 | -122.490967193042 | (37.7486236329866, -122.490967193042) | 1 | 8 | 3 | 29491 | 35 | ||
131730 | 213571 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 10 Merced Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 08/30/2016 12:00:00 AM | 4 | Width 3ft | Permit Number 778534 | 5995317.16684 | 2100218.39007 | 37.746530798564 | -122.458933955845 | (37.746530798564, -122.458933955845) | 1 | 8 | 4 | 59 | 40 | |
125010 | 115224 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 741 35th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778505 | 5985056.12254 | 2110795.86603 | 37.7749784243735 | -122.495194889307 | (37.7749784243735, -122.495194889307) | 11 | 6 | 2 | 55 | 26 | |
105822 | 117315 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1359 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/06/2016 12:00:00 AM | 3 | Permit Number 778500 | 5989234.9 | 2106072.8 | 37.7622539446327 | -122.480393979375 | (37.7622539446327, -122.480393979375) | 1 | 8 | 3 | 56 | 35 | ||
179776 | 117477 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1999X Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 14 | Permit Number 778454 | 6004121.65182 | 2117991.32781 | 37.7958331278375 | -122.429756453008 | (37.7958331278375, -122.429756453008) | 13 | 9 | 1 | 28858 | 27 | ||
120060 | 221127 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1218 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2016 12:00:00 AM | 1 | Width 3ft | Permit Number 778419 | 6008662.3869 | 2101444.26707 | 37.750654869142 | -122.412874131348 | (37.750654869142, -122.412874131348) | 2 | 4 | 7 | 28859 | 19 | |
92086 | 86173 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1439 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778355 | 5988651.1741 | 2105513.6858 | 37.7606848299416 | -122.482371875236 | (37.7606848299416, -122.482371875236) | 1 | 8 | 3 | 56 | 35 | |
147255 | 44823 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2440 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/2016 12:00:00 AM | 3 | Permit Number 778318 | 6001806.8581 | 2114669.882 | 37.7865819462822 | -122.437528082282 | (37.7865819462822, -122.437528082282) | 13 | 6 | 11 | 29490 | 27 | |
56634 | 100228 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 701X 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778265 | 5983810.9 | 2111033.8 | 37.7755587404093 | -122.499519901729 | (37.7755587404093, -122.499519901729) | 11 | 6 | 2 | 55 | 26 | |
90563 | 254217 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2335 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2018 12:00:00 AM | 3 | 3x3 | Permit Number 778077 | 5991030.00521 | 2099511.78202 | 37.7443432653304 | -122.473706807809 | (37.7443432653304, -122.473706807809) | 1 | 8 | 4 | 29491 | 40 |
11885 | 157920 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4147 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/23/2019 12:00:00 AM | 3 | 3x3 | Permit Number 777832 | 6002961.17206 | 2100636.31842 | 37.7481147664022 | -122.432531686182 | (37.7481147664022, -122.432531686182) | 2 | 4 | 5 | 63 | 22 | |
62352 | 62936 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 316 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/01/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777778 | 6006849.46263115 | 2097253.97380445 | 37.7390473377689 | -122.418846238018 | (37.7390473377689, -122.418846238018) | 2 | 7 | 7 | 28859 | 2 |
47574 | 115278 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1820 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 777410 | 5989175.1 | 2105179.9 | 37.7597988071794 | -122.480535438141 | (37.7597988071794, -122.480535438141) | 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) );