trees
5,723 rows where qSpecies_id = 14 sorted by TreeID 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
100865 | 96279 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 55@ Alemany Trumbull St | 7 | Back Yard : Yard | Tree | Private 2 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | 9 | 7 | 6 | 28861 | 5 | |||||
14296 | 96112 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 7909 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767767 | 5982473.14559 | 2112346.12315 | 37.7790834143652 | -122.504244675585 | (37.7790834143652, -122.504244675585) | 11 | 6 | 2 | 55 | 26 |
122905 | 96096 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1300 De Haro St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2011 12:00:00 AM | 3 | Permit Number 767202 | 6012228.91998 | 2102261.57238 | 37.7530985609606 | -122.400598094926 | (37.7530985609606, -122.400598094926) | 10 | 3 | 8 | 28856 | 29 | ||
172975 | 96095 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1300 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2011 12:00:00 AM | 3 | Permit Number 767202 | 6012224.44057 | 2102303.78485 | 37.7532142173861 | -122.400616550812 | (37.7532142173861, -122.400616550812) | 10 | 3 | 8 | 28856 | 29 | ||
110245 | 96078 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 442 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767702 | 5983166.63453 | 2112823.229 | 37.7804341684029 | -122.501880965545 | (37.7804341684029, -122.501880965545) | 11 | 6 | 2 | 55 | 26 |
59504 | 96077 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 442 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767702 | 5983166.97254 | 2112802.17844 | 37.7803763895854 | -122.501878238244 | (37.7803763895854, -122.501878238244) | 11 | 6 | 2 | 55 | 26 |
155006 | 96072 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 575 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767698 | 5985634.97945 | 2111987.83926 | 37.7782851153957 | -122.493280362056 | (37.7782851153957, -122.493280362056) | 11 | 6 | 2 | 55 | 26 |
125403 | 96051 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2301 Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767680 | 6009677 | 2103946 | 37.7575809678575 | -122.409542047526 | (37.7575809678575, -122.409542047526) | 2 | 4 | 7 | 28859 | 19 | |
105487 | 96050 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2301 Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/2011 12:00:00 AM | 3x3 | Permit Number 767680 | 6009677 | 2103946 | 37.7575809678575 | -122.409542047526 | (37.7575809678575, -122.409542047526) | 2 | 4 | 7 | 28859 | 19 | |
160054 | 95993 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 801 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767645 | 5987860.90334 | 2110470.58087 | 37.7742490928274 | -122.485468795602 | (37.7742490928274, -122.485468795602) | 11 | 6 | 2 | 55 | 26 |
165713 | 95939 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 770 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767634 | 5986967.35072 | 2110688.71973 | 37.7747959409125 | -122.488575751059 | (37.7747959409125, -122.488575751059) | 11 | 6 | 2 | 55 | 26 |
167472 | 95930 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 525 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767627 | 5987483.09565 | 2112350.67987 | 37.7793892963815 | -122.486913781541 | (37.7793892963815, -122.486913781541) | 11 | 6 | 2 | 55 | 26 |
9508 | 95929 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4054 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767626 | 5987436.1 | 2113196.8 | 37.7817097621118 | -122.487138517946 | (37.7817097621118, -122.487138517946) | 11 | 6 | 2 | 55 | 26 | |
155610 | 95923 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 408 22nd Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767620 | 5989072.23845 | 2112543.25955 | 37.7800105904918 | -122.481430439914 | (37.7800105904918, -122.481430439914) | 11 | 6 | 2 | 55 | 26 |
77178 | 95922 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 408 22nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767620 | 5989074.50485 | 2112480.10448 | 37.7798373161167 | -122.481417973094 | (37.7798373161167, -122.481417973094) | 11 | 6 | 2 | 55 | 26 |
2349 | 95912 | Section 806 (d) 5 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 858 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2011 12:00:00 AM | 4 | Permit Number 767389 | 5985440.58134 | 2110021.2041 | 37.7728739243823 | -122.493807884231 | (37.7728739243823, -122.493807884231) | 11 | 6 | 2 | 55 | 26 | ||
155054 | 95902 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1849 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767604 | 5989055.5587 | 2102725.7124 | 37.7530533181544 | -122.480769194582 | (37.7530533181544, -122.480769194582) | 1 | 8 | 3 | 56 | 35 |
92832 | 95894 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1500X Moraga St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 3x3 | Permit Number 767600 | 5989591.8 | 2103841.4 | 37.7561478529141 | -122.478996388599 | (37.7561478529141, -122.478996388599) | 1 | 8 | 3 | 56 | 35 | |
141021 | 95893 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1500X Moraga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 3x3 | Permit Number 767600 | 5989591.8 | 2103841.4 | 37.7561478529141 | -122.478996388599 | (37.7561478529141, -122.478996388599) | 1 | 8 | 3 | 56 | 35 | |
44390 | 95892 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1500X Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767600 | 5989616.6165 | 2103814.8649 | 37.7560764357046 | -122.478908624957 | (37.7560764357046, -122.478908624957) | 1 | 8 | 3 | 56 | 35 |
141106 | 95890 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1658 21st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767598 | 5989673.5494 | 2104075.8071 | 37.7567962192075 | -122.478730817301 | (37.7567962192075, -122.478730817301) | 1 | 8 | 3 | 56 | 35 |
66464 | 95889 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1658 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767598 | 5989675.4471 | 2104058.7272 | 37.7567494325496 | -122.478723005335 | (37.7567494325496, -122.478723005335) | 1 | 8 | 3 | 56 | 35 |
149565 | 95888 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1652 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767597 | 5989673.5494 | 2104088.1425 | 37.7568300889218 | -122.478731719422 | (37.7568300889218, -122.478731719422) | 1 | 8 | 3 | 56 | 35 |
153683 | 95886 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1851 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767595 | 5989982.9497 | 2102763.5943 | 37.7532111912555 | -122.477564899515 | (37.7532111912555, -122.477564899515) | 1 | 8 | 3 | 56 | 35 |
90513 | 95784 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2804 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767528 | 6009367 | 2103952 | 37.7575800672383 | -122.410614581161 | (37.7575800672383, -122.410614581161) | 2 | 4 | 7 | 28859 | 19 | |
16620 | 95774 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 674 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767509 | 6002740.18183 | 2089602.96297 | 37.7178071529464 | -122.432507901839 | (37.7178071529464, -122.432507901839) | 9 | 7 | 6 | 28861 | 5 |
93795 | 95760 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 207 Moscow St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767497 | 6004854.06205 | 2091888.44389 | 37.7242022320271 | -122.425363703668 | (37.7242022320271, -122.425363703668) | 9 | 7 | 6 | 28861 | 5 |
39835 | 95748 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 636 London St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767493 | 6001131.03467 | 2090095.70221 | 37.7190687219118 | -122.438105273239 | (37.7190687219118, -122.438105273239) | 9 | 7 | 6 | 28861 | 5 |
110953 | 95744 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 587 Lisbon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767489 | 6001821.48619 | 2090084.10233 | 37.7190761143586 | -122.43571782322 | (37.7190761143586, -122.43571782322) | 9 | 7 | 6 | 28861 | 5 |
47705 | 95743 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 587 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767489 | 6001815.52493 | 2090073.02841 | 37.7190453692361 | -122.435737637094 | (37.7190453692361, -122.435737637094) | 9 | 7 | 6 | 28861 | 5 |
172614 | 95731 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 239 Edinburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 3x3 | Permit Number 767477 | 6003896.7 | 2092252.3 | 37.7251471647108 | -122.42869908873 | (37.7251471647108, -122.42869908873) | 9 | 7 | 6 | 28861 | 5 | |
66961 | 95728 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 235 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767474 | 6004052.27697 | 2089070.25466 | 37.716418770593 | -122.427934633383 | (37.716418770593, -122.427934633383) | 9 | 7 | 6 | 28861 | 5 |
165986 | 95727 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 221 Dublin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767473 | 6004098.52125 | 2089144.62886 | 37.7166256020635 | -122.427780086703 | (37.7166256020635, -122.427780086703) | 9 | 7 | 6 | 28861 | 5 |
100660 | 95726 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 221 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767473 | 6004091.25163 | 2089133.01741 | 37.7165933083102 | -122.427804387274 | (37.7165933083102, -122.427804387274) | 9 | 7 | 6 | 28861 | 5 |
86945 | 95707 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1500 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767353 | 6001984 | 2099717 | 37.745535073009 | -122.435844939956 | (37.745535073009, -122.435844939956) | 2 | 7 | 5 | 63 | 22 |
118568 | 95706 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1500 Diamond St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767353 | 6001984 | 2099717 | 37.745535073009 | -122.435844939956 | (37.745535073009, -122.435844939956) | 2 | 7 | 5 | 63 | 22 |
41549 | 95596 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1625 Carroll Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6013942.4077 | 2092076.0569 | 37.7252266645194 | -122.393959521634 | (37.7252266645194, -122.393959521634) | 10 | 3 | 8 | 58 | 1 | |||
146480 | 95575 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 420 29th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767364 | 5986881.0139 | 2113113.76746 | 37.781449395794 | -122.489052722321 | (37.781449395794, -122.489052722321) | 11 | 6 | 2 | 55 | 26 | |
151072 | 95573 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 420 29th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767364 | 5986881.29994 | 2113082.68575 | 37.7813640709815 | -122.489049447076 | (37.7813640709815, -122.489049447076) | 11 | 6 | 2 | 55 | 26 | |
100258 | 95572 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 420 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2011 12:00:00 AM | 5 | 3x3 | Permit Number 767364 | 5986882.25424 | 2113067.0873 | 37.7813212977864 | -122.489044998627 | (37.7813212977864, -122.489044998627) | 11 | 6 | 2 | 55 | 26 | |
123467 | 95567 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 336 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767359 | 6002955 | 2101550 | 37.7506231710654 | -122.43261828431 | (37.7506231710654, -122.43261828431) | 2 | 4 | 5 | 28862 | 22 | |
56400 | 95559 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1500 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767353 | 6001984 | 2099717 | 37.745535073009 | -122.435844939956 | (37.745535073009, -122.435844939956) | 2 | 7 | 5 | 63 | 22 |
70256 | 95547 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 397399 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767348 | 6003988 | 2098355 | 37.7419089690329 | -122.428818339264 | (37.7419089690329, -122.428818339264) | 2 | 7 | 5 | 63 | 7 | |
97271 | 95536 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4215 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767325 | 6002474 | 2101197 | 37.7496266270423 | -122.434256385957 | (37.7496266270423, -122.434256385957) | 2 | 4 | 5 | 28862 | 22 | |
131068 | 95535 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4039 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2009 12:00:00 AM | 3x3 | Permit Number 767324 | 6003601 | 2101260 | 37.7498635129183 | -122.430363675989 | (37.7498635129183, -122.430363675989) | 2 | 4 | 5 | 28862 | 22 | |
119515 | 95533 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2569 San Jose Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 07/30/2010 12:00:00 AM | Permit Number 58711 | 5997895.9 | 2089454.8 | 37.7171244336089 | -122.449241684477 | (37.7171244336089, -122.449241684477) | 9 | 8 | 6 | 28861 | 24 | |||
88034 | 95532 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2569 San Jose Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 07/30/2010 12:00:00 AM | Permit Number 58711 | 5997895.9 | 2089454.8 | 37.7171244336089 | -122.449241684477 | (37.7171244336089, -122.449241684477) | 9 | 8 | 6 | 28861 | 24 | |||
168656 | 95531 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2569 San Jose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 07/30/2010 12:00:00 AM | 25x100x60 | Permit Number 58711 | 5997895.9 | 2089454.8 | 37.7171244336089 | -122.449241684477 | (37.7171244336089, -122.449241684477) | 9 | 8 | 6 | 28861 | 24 | ||
59177 | 95444 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1883 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767306 | 5985633.5 | 2102420.8 | 37.7520166165899 | -122.492580716677 | (37.7520166165899, -122.492580716677) | 1 | 8 | 3 | 56 | 35 | |
178252 | 95441 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2347 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767303 | 5986381.7528 | 2099264.2175 | 37.7433932143089 | -122.489761063274 | (37.7433932143089, -122.489761063274) | 1 | 8 | 3 | 29491 | 35 |
80934 | 95437 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1570 29th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767299 | 5987198 | 2104590.4 | 37.7580651010612 | -122.487329865241 | (37.7580651010612, -122.487329865241) | 1 | 8 | 3 | 56 | 35 | ||
88995 | 95434 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2151 25th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767298 | 5988486.9 | 2100677.9 | 37.747397502063 | -122.482585657316 | (37.747397502063, -122.482585657316) | 1 | 8 | 3 | 29491 | 35 | ||
105341 | 95433 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2147 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 2 | 3x3 | Permit Number 767297 | 5988504.6016 | 2100705.6353 | 37.7474746856512 | -122.482526479121 | (37.7474746856512, -122.482526479121) | 1 | 8 | 3 | 29491 | 35 |
139748 | 95356 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 769 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/15/2011 12:00:00 AM | 3x3 | Permit Number 767199 | 6008576.8 | 2104089.5 | 37.7579132767205 | -122.413357145974 | (37.7579132767205, -122.413357145974) | 2 | 4 | 7 | 28859 | 19 | ||
167686 | 95119 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 80 Danton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 6 | 3x3 | Permit Number 54046 | 6002860.87365 | 2094458.65897 | 37.7311466511867 | -122.432437345509 | (37.7311466511867, -122.432437345509) | 9 | 7 | 5 | 28861 | 25 |
183124 | 95115 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 111 Congdon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/2010 12:00:00 AM | 3 | 3x3 | Permit Number 54042 | 6004702.49074 | 2094193.2145 | 37.7305220576454 | -122.426051658966 | (37.7305220576454, -122.426051658966) | 9 | 7 | 6 | 28861 | 5 |
78575 | 95094 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 620 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 5993639.68625 | 2111436.58359 | 37.7772364604812 | -122.465549292862 | (37.7772364604812, -122.465549292862) | 11 | 6 | 2 | 54 | 11 | |||
130177 | 94971 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 40 Hemway Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2010 12:00:00 AM | 2 | 2x2 | Permit Number 54003 | 5998636.7696 | 2110976.7332 | 37.7762607772277 | -122.448229733394 | (37.7762607772277, -122.448229733394) | 15 | 6 | 2 | 29492 | 16 | |
161104 | 94886 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1571 Shafter Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53952 | 6015046.2 | 2094014.9 | 37.730611623012 | -122.3902791877 | (37.730611623012, -122.3902791877) | 10 | 3 | 8 | 58 | 1 | ||
76646 | 94865 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 30 Gladstone Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2010 12:00:00 AM | 2 | 3x2 | Permit Number 53936 | 6006380.98913 | 2094288.72029 | 37.7308790183509 | -122.42025560931 | (37.7308790183509, -122.42025560931) | 9 | 7 | 7 | 28861 | 5 | |
67993 | 94846 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1541 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53920 | 5992430.7 | 2104964.5 | 37.759396041377 | -122.469260340883 | (37.759396041377, -122.469260340883) | 1 | 8 | 4 | 56 | 12 | |
168076 | 94845 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1541 12th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53919 | 5992430.7 | 2104964.5 | 37.759396041377 | -122.469260340883 | (37.759396041377, -122.469260340883) | 1 | 8 | 4 | 56 | 12 | |
62881 | 94844 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1541 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53919 | 5992430.7 | 2104964.5 | 37.759396041377 | -122.469260340883 | (37.759396041377, -122.469260340883) | 1 | 8 | 4 | 56 | 12 | |
87969 | 94843 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1541 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53919 | 5992430.7 | 2104964.5 | 37.759396041377 | -122.469260340883 | (37.759396041377, -122.469260340883) | 1 | 8 | 4 | 56 | 12 | |
153209 | 94842 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1541 12th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53918 | 5992430.7 | 2104964.5 | 37.759396041377 | -122.469260340883 | (37.759396041377, -122.469260340883) | 1 | 8 | 4 | 56 | 12 | |
52519 | 94841 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1541 12th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53918 | 5992430.7 | 2104964.5 | 37.759396041377 | -122.469260340883 | (37.759396041377, -122.469260340883) | 1 | 8 | 4 | 56 | 12 | |
60320 | 94840 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1541 12th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53918 | 5992430.7 | 2104964.5 | 37.759396041377 | -122.469260340883 | (37.759396041377, -122.469260340883) | 1 | 8 | 4 | 56 | 12 | |
100671 | 94839 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1541 12th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53918 | 5992430.7 | 2104964.5 | 37.759396041377 | -122.469260340883 | (37.759396041377, -122.469260340883) | 1 | 8 | 4 | 56 | 12 | |
133244 | 94838 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1541 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53918 | 5992430.7 | 2104964.5 | 37.759396041377 | -122.469260340883 | (37.759396041377, -122.469260340883) | 1 | 8 | 4 | 56 | 12 | |
89516 | 94837 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1541 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53918 | 5992430.7 | 2104964.5 | 37.759396041377 | -122.469260340883 | (37.759396041377, -122.469260340883) | 1 | 8 | 4 | 56 | 12 | |
82821 | 94822 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1363 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/10/2010 12:00:00 AM | 3x3 | Permit Number 53902 | 5991082.8 | 2106131.5 | 37.7625223315187 | -122.474007137473 | (37.7625223315187, -122.474007137473) | 1 | 8 | 11 | 56 | 12 | |
102764 | 94818 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 606 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/2009 12:00:00 AM | 9 | 3x3 | Permit Number 52675 | 5983521.26249 | 2111637.40595 | 37.7771990690519 | -122.500566453574 | (37.7771990690519, -122.500566453574) | 11 | 6 | 2 | 55 | 26 |
64509 | 94816 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3837 Clay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53897 | 5996465.22864 | 2115252.18651 | 37.787875655692 | -122.456050818388 | (37.787875655692, -122.456050818388) | 11 | 6 | 1 | 54 | 31 | |
51407 | 94815 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3837 Clay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53897 | 5996452.2793 | 2115249.70493 | 37.7878680986671 | -122.456095440968 | (37.7878680986671, -122.456095440968) | 11 | 6 | 1 | 54 | 31 | |
85292 | 94814 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3837 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53897 | 5996437.51684 | 2115248.63725 | 37.7878643197416 | -122.456146438825 | (37.7878643197416, -122.456146438825) | 11 | 6 | 1 | 54 | 31 | |
121760 | 94719 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 493 08th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53855 | 5993385.1 | 2112169.4 | 37.7792338897239 | -122.466483256709 | (37.7792338897239, -122.466483256709) | 11 | 6 | 2 | 54 | 11 | |
141501 | 94718 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 493 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53855 | 5993385.1 | 2112169.4 | 37.7792338897239 | -122.466483256709 | (37.7792338897239, -122.466483256709) | 11 | 6 | 2 | 54 | 11 | |
50271 | 94717 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 497 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53855 | 5993415.93147 | 2112151.43646 | 37.7791863457452 | -122.466375292882 | (37.7791863457452, -122.466375292882) | 11 | 6 | 2 | 54 | 11 |
163063 | 94716 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 483 08th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53853 | 5993385.1 | 2112169.4 | 37.7792338897239 | -122.466483256709 | (37.7792338897239, -122.466483256709) | 11 | 6 | 2 | 54 | 11 | |
94494 | 94715 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 483 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/28/2010 12:00:00 AM | 3x3 | Permit Number 53853 | 5993385.1 | 2112169.4 | 37.7792338897239 | -122.466483256709 | (37.7792338897239, -122.466483256709) | 11 | 6 | 2 | 54 | 11 | |
68668 | 94682 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 289 Surrey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53818 | 6001670 | 2096192 | 37.7358384052787 | -122.436678424827 | (37.7358384052787, -122.436678424827) | 2 | 7 | 5 | 63 | 7 | |
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 | ||
169073 | 94462 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2926 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2010 12:00:00 AM | 4 | Permit Number 53680 | 5986416.2949 | 2113264.95718 | 37.7818373846731 | -122.490671530515 | (37.7818373846731, -122.490671530515) | 11 | 6 | 2 | 55 | 26 | ||
91438 | 94367 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 5100@ Fulton Fulton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2010 12:00:00 AM | 3 | Permit Number 53639 | 5987467.90397 | 2109853.1131 | 37.7725307948417 | -122.486782882641 | (37.7725307948417, -122.486782882641) | 11 | 6 | 2 | 55 | 26 | ||
53762 | 94366 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 5100@ Fulton Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2010 12:00:00 AM | 3 | Permit Number 53639 | 5987494.93106 | 2109853.90343 | 37.7725345404978 | -122.486689452451 | (37.7725345404978, -122.486689452451) | 11 | 6 | 2 | 55 | 26 | ||
173322 | 94365 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 5100@ Fulton Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2010 12:00:00 AM | 3 | Permit Number 53639 | 5987526.26616 | 2109854.79756 | 37.7725388222162 | -122.486581128222 | (37.7725388222162, -122.486581128222) | 11 | 6 | 2 | 55 | 26 | ||
91534 | 94364 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 5100@ Fulton Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2010 12:00:00 AM | 3 | Permit Number 53639 | 5987540.37696 | 2109855.66742 | 37.7725420331687 | -122.486532382038 | (37.7725420331687, -122.486532382038) | 11 | 6 | 2 | 55 | 26 | ||
129656 | 94325 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 501@ 28th Ave El Camino Del Mar | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/15/2010 12:00:00 AM | Permit Number 53625 | 5987118 | 2115378 | 37.7876801589176 | -122.488399329426 | (37.7876801589176, -122.488399329426) | 11 | 6 | 1 | 55 | 33 | |||
40007 | 94324 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 501@ 28th Ave El Camino Del Mar | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/15/2010 12:00:00 AM | Permit Number 53625 | 5987118 | 2115378 | 37.7876801589176 | -122.488399329426 | (37.7876801589176, -122.488399329426) | 11 | 6 | 1 | 55 | 33 | |||
129471 | 94323 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 501@ 28th Ave El Camino Del Mar | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/15/2010 12:00:00 AM | Permit Number 53625 | 5987118 | 2115378 | 37.7876801589176 | -122.488399329426 | (37.7876801589176, -122.488399329426) | 11 | 6 | 1 | 55 | 33 | |||
112248 | 94322 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 501 El Camino Del Mar | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/15/2010 12:00:00 AM | Permit Number 53625 | 5987118 | 2115378 | 37.7876801589176 | -122.488399329426 | (37.7876801589176, -122.488399329426) | 11 | 6 | 1 | 55 | 33 | |||
36769 | 94321 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 501 El Camino Del Mar | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 07/15/2010 12:00:00 AM | Permit Number 53625 | 5987118 | 2115378 | 37.7876801589176 | -122.488399329426 | (37.7876801589176, -122.488399329426) | 11 | 6 | 1 | 55 | 33 | |||
65132 | 94166 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 411 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53527 | 5992789 | 2103185 | 37.7545306959184 | -122.467891743432 | (37.7545306959184, -122.467891743432) | 1 | 8 | 4 | 56 | 12 | ||
2817 | 94164 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 729 Lawton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53529 | 5991968 | 2104568 | 37.7582806084367 | -122.470831686794 | (37.7582806084367, -122.470831686794) | 1 | 8 | 4 | 56 | 12 | ||
39102 | 94163 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1943 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53532 | 5993428.1 | 2102257.9 | 37.7520220022864 | -122.465614235533 | (37.7520220022864, -122.465614235533) | 1 | 8 | 4 | 29491 | 12 | ||
154878 | 94154 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2110 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53542 | 5991044 | 2101017.5 | 37.7484783873345 | -122.473768239875 | (37.7484783873345, -122.473768239875) | 1 | 8 | 4 | 29491 | 40 | ||
103247 | 94149 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1463 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53549 | 5992375 | 2105491.5 | 37.7608398260273 | -122.469491339338 | (37.7608398260273, -122.469491339338) | 1 | 8 | 4 | 56 | 12 | ||
168481 | 94143 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1915 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53559 | 5993113.3 | 2102419.8 | 37.7524483757214 | -122.466714618444 | (37.7524483757214, -122.466714618444) | 1 | 8 | 4 | 29491 | 12 | ||
89735 | 94141 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1669 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2010 12:00:00 AM | 3x3 | Permit Number 53561 | 5993053.9 | 2104137.1 | 37.757160208827 | -122.467044873586 | (37.757160208827, -122.467044873586) | 1 | 8 | 4 | 56 | 12 | ||
94277 | 94029 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 933 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/14/2010 12:00:00 AM | 3x3 | Permit Number 53443 | 6008667.9 | 2103109.2 | 37.7552267097076 | -122.412972771919 | (37.7552267097076, -122.412972771919) | 2 | 4 | 7 | 28859 | 19 |
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) );