trees

70 rows where Zip Codes = 28855 and qSpecies_id = 53

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

  • 28855 · 70 ✖
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)
3993 49288 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 19 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
26933 120656 Undocumented 4 Ficus nitida :: Laurel Fig 53 160 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
27040 120661 Undocumented 4 Ficus nitida :: Laurel Fig 53 299X Main St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
32399 102602 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
40083 49240 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 24 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
40156 49286 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 14 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
40462 48697 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 9 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
43665 94218 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 01st St 3 Sidewalk: Property side : Pot Tree Private 2   06/25/2010 12:00:00 AM   2x3 Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636) 6 2 9 28855 6
45439 49260 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
45931 49235 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 8 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
46738 113373 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 HOWARD ST 4 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2015 12:00:00 AM   3x3   6014757 2116474 37.7922633974731 -122.39284966575 (37.7922633974731, -122.39284966575) 12 2 9 28855 6
53416 48709 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 8 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
57627 114283 Undocumented 4 Ficus nitida :: Laurel Fig 53 200X STEUART ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
59324 94216 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1X Tehama St 1 Sidewalk: Property side : Pot Tree Private 2   06/25/2010 12:00:00 AM   2x3 Permit Number 53568 6013910.7 2114841.3 37.7877333404996 -122.395663455814 (37.7877333404996, -122.395663455814) 6 2 9 28855 6
60857 49274 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 20 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
61686 100705 Permitted Site 7 Ficus nitida :: Laurel Fig 53 220X 01st St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM   3x3 Permit Number 768932 6013902 2115015 37.7882097965006 -122.395705731652 (37.7882097965006, -122.395705731652) 6 2 9 28855 6
69985 49269 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
70254 48702 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 14 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
71167 114282 Undocumented 4 Ficus nitida :: Laurel Fig 53 200X STEUART ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
78580 114284 Undocumented 4 Ficus nitida :: Laurel Fig 53 200X STEUART ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
81758 49264 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
84141 102599 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
84798 48704 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 6 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
85954 15110 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 6 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014281.21891 2116519.09631 37.7923607834286 -122.394499049528 (37.7923607834286, -122.394499049528) 12 2 9 28855 6
91220 120660 Undocumented 4 Ficus nitida :: Laurel Fig 53 126 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
91238 49276 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 16 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
95381 49285 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 13 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
95808 48700 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 12 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
95982 49266 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 7 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
98499 102601 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
100078 102598 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
100582 48699 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 11 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
103493 49277 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 15 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
105004 100707 Permitted Site 7 Ficus nitida :: Laurel Fig 53 220X 01st St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM   3x3 Permit Number 768932 6013902 2115015 37.7882097965006 -122.395705731652 (37.7882097965006, -122.395705731652) 6 2 9 28855 6
111958 15109 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014295.34515 2116528.26215 37.7923867359811 -122.3944508141 (37.7923867359811, -122.3944508141) 12 2 9 28855 6
114688 49239 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 10 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
114816 120655 Undocumented 4 Ficus nitida :: Laurel Fig 53 160 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
115493 15108 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014309.51773 2116539.1619 37.7924174520023 -122.394402539761 (37.7924174520023, -122.394402539761) 12 2 9 28855 6
117139 49290 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 10 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
118155 49258 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 8 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
123162 114285 Undocumented 4 Ficus nitida :: Laurel Fig 53 200X STEUART ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
124192 15106 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014335.21568 2116559.29701 37.7924741668095 -122.394315033873 (37.7924741668095, -122.394315033873) 12 2 9 28855 6
125521 49234 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 29 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
128659 120663 Undocumented 4 Ficus nitida :: Laurel Fig 53 299X Main St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
128922 49236 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 21 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
129369 94220 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1X Tehama St 5 Sidewalk: Property side : Pot Tree Private 2         Permit Number 53568 6013910.7 2114841.3 37.7877333404996 -122.395663455814 (37.7877333404996, -122.395663455814) 6 2 9 28855 6
129463 49287 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
129993 49238 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 16 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
132195 100706 Permitted Site 7 Ficus nitida :: Laurel Fig 53 220X 01st St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM   3x3 Permit Number 768932 6013902 2115015 37.7882097965006 -122.395705731652 (37.7882097965006, -122.395705731652) 6 2 9 28855 6
132203 48698 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 7 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
136842 49263 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 17 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
144032 49294 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
145539 48701 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 13 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
147296 49297 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 9 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
150564 102603 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
151649 49289 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 11 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
155305 102600 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
156149 49237 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 18 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
163880 15107 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014322.84653 2116550.95179 37.7924505652168 -122.394357247259 (37.7924505652168, -122.394357247259) 12 2 9 28855 6
165688 120662 Undocumented 4 Ficus nitida :: Laurel Fig 53 299X Main St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
168885 48703 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 10 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
170466 114281 Undocumented 4 Ficus nitida :: Laurel Fig 53 200X STEUART ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015060 2116254 37.7916761533754 -122.391785881413 (37.7916761533754, -122.391785881413) 6 2 9 28855 6
170512 94219 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 01st St 4 Sidewalk: Property side : Pot Tree Private 2   06/25/2010 12:00:00 AM     Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636) 6 2 9 28855 6
172671 49251 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 18 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
174050 49256 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 6 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
175879 15105 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6014344.93761 2116565.97781 37.7924930511311 -122.394281863407 (37.7924930511311, -122.394281863407) 12 2 9 28855 6
177069 49259 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 12 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
182718 100710 Permitted Site 7 Ficus nitida :: Laurel Fig 53 220X 01st St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM   3x3 Permit Number 768932 6013902 2115015 37.7882097965006 -122.395705731652 (37.7882097965006, -122.395705731652) 6 2 9 28855 6
187881 94217 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 01st St 2 Sidewalk: Property side : Pot Tree Private 2   06/25/2010 12:00:00 AM   2x3 Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636) 6 2 9 28855 6
188290 100708 Permitted Site 7 Ficus nitida :: Laurel Fig 53 220X 01st St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM   3x3 Permit Number 768932 6013902 2115015 37.7882097965006 -122.395705731652 (37.7882097965006, -122.395705731652) 6 2 9 28855 6

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);