trees
145 rows where qSpecies_id = 181 sorted by TreeID
This data as json, CSV (advanced)
| rowid | TreeID ▼ | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 125779 | 112775 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 298X De Montfort Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2015 12:00:00 AM | Permit Number 774165 | 5994620.34335 | 2091897.94945 | 37.7236448360577 | -122.460740597397 | (37.7236448360577, -122.460740597397) | 9 | 8 | 4 | 28861 | 24 | ||
| 16285 | 114961 | Private 9 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 220 Evelyn Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 776128 | 5997838.7 | 2098850.9 | 37.7429206264442 | -122.450116261368 | (37.7429206264442, -122.450116261368) | 9 | 7 | 4 | 59 | 40 | |||
| 39655 | 114962 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 220 Evelyn Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 776128 | 5997838.7 | 2098850.9 | 37.7429206264442 | -122.450116261368 | (37.7429206264442, -122.450116261368) | 9 | 7 | 4 | 59 | 40 | |||
| 98716 | 115179 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2018 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775293 | 5981721.2 | 2101325.9 | 37.7487808007055 | -122.506028615883 | (37.7487808007055, -122.506028615883) | 1 | 8 | 3 | 29491 | 35 | |||
| 111363 | 115321 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 783 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2016 12:00:00 AM | 3 | Permit Number 776299 | 5992231.1 | 2110127 | 37.7735593554473 | -122.470326606247 | (37.7735593554473, -122.470326606247) | 11 | 6 | 2 | 54 | 11 | ||
| 114771 | 115339 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 534 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/26/2016 12:00:00 AM | 3 | Permit Number 776329 | 5994083.4 | 2111862.7 | 37.778432043803 | -122.464045297105 | (37.778432043803, -122.464045297105) | 11 | 6 | 2 | 54 | 11 | ||
| 189777 | 115404 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 355 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2016 12:00:00 AM | 3 | Permit Number 776433 | 6006990.5 | 2096060.3 | 37.7357777137995 | -122.418273984634 | (37.7357777137995, -122.418273984634) | 2 | 7 | 7 | 28859 | 2 | ||
| 52396 | 115779 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 864 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775643 | 6009345.7 | 2104137.1 | 37.7580871157921 | -122.410701317143 | (37.7580871157921, -122.410701317143) | 2 | 4 | 7 | 28859 | 19 | ||
| 124147 | 117394 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 283 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2016 12:00:00 AM | 3 | Permit Number 776575 | 5993365.5 | 2113610.2 | 37.7831888046166 | -122.466655818894 | (37.7831888046166, -122.466655818894) | 11 | 6 | 2 | 54 | 11 | ||
| 19140 | 117865 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 834 40th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2018 12:00:00 AM | 3 | Width 4ft | 5983577.11501 | 2110117.51493 | 37.7730291665941 | -122.500260851226 | (37.7730291665941, -122.500260851226) | 11 | 6 | 2 | 55 | 26 | ||
| 5220 | 117866 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 834 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x4 | 5983575.70369 | 2110102.10506 | 37.772986772695 | -122.500264593603 | (37.772986772695, -122.500264593603) | 11 | 6 | 2 | 55 | 26 | |||
| 129146 | 118752 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 538 44th Ave | 1 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | Width 4ft | 5982260.79513 | 2112091.34059 | 37.7783713653468 | -122.504960384037 | (37.7783713653468, -122.504960384037) | 11 | 6 | 2 | 55 | 26 | ||
| 128598 | 120206 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 880 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | Width 2ft | 5988238.0912 | 2110027.42802 | 37.7730542866325 | -122.484131545488 | (37.7730542866325, -122.484131545488) | 11 | 6 | 2 | 55 | 26 | ||
| 177534 | 131972 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1386 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/2018 12:00:00 AM | 3 | Width 3ft | Permit Number 782617 | 6006417.70095 | 2118709.68602 | 37.7979353075185 | -122.421862734678 | (37.7979353075185, -122.421862734678) | 13 | 9 | 10 | 28858 | 32 |
| 3040 | 143978 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 734 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | Width 4ft | 5985411.43916 | 2110864.37217 | 37.7751873187751 | -122.493970840399 | (37.7751873187751, -122.493970840399) | 11 | 6 | 2 | 55 | 26 | ||
| 18968 | 143984 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 810 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | Width 3ft | 5985428.80234 | 2110336.46001 | 37.7737388383198 | -122.493871865501 | (37.7737388383198, -122.493871865501) | 11 | 6 | 2 | 55 | 26 | ||
| 2671 | 144171 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 630 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | Width 4ft | 5983218.04467 | 2111492.83388 | 37.7767843114763 | -122.501604665448 | (37.7767843114763, -122.501604665448) | 11 | 6 | 2 | 55 | 26 | ||
| 12012 | 144250 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 636 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/16/2020 12:00:00 AM | 3 | Width 4ft | 5982286.59796 | 2111414.30559 | 37.7765139438058 | -122.504820943253 | (37.7765139438058, -122.504820943253) | 11 | 6 | 2 | 55 | 26 | ||
| 12661 | 144820 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 790 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 0 | Width 6ft | 5989783.49445 | 2110002.95663 | 37.7730769498637 | -122.478784070846 | (37.7730769498637, -122.478784070846) | 11 | 6 | 2 | 55 | 26 | ||
| 1817 | 146851 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 811 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x4 | 5983524.5081 | 2110251.67641 | 37.7733944474176 | -122.5004527436 | (37.7733944474176, -122.5004527436) | 11 | 6 | 2 | 55 | 26 | |||
| 11176 | 147474 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 795 20th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 0 | Width 4ft | 5989738.01651 | 2110022.28004 | 37.7731273658577 | -122.47894279668 | (37.7731273658577, -122.47894279668) | 11 | 6 | 2 | 55 | 26 | ||
| 2783 | 147475 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 795 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 0 | Width 4ft | 5989738.23862 | 2110044.5222 | 37.7731884496103 | -122.478943655543 | (37.7731884496103, -122.478943655543) | 11 | 6 | 2 | 55 | 26 | ||
| 4273 | 147476 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 771 20th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 0 | Width 4ft | 5989736.46836 | 2110101.65987 | 37.7733452311378 | -122.47895395906 | (37.7733452311378, -122.47895395906) | 11 | 6 | 2 | 55 | 26 | ||
| 18273 | 147576 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 627 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | 0 | Width 4ft | 5990011.63162 | 2111078.55702 | 37.7760434967366 | -122.478073576744 | (37.7760434967366, -122.478073576744) | 11 | 6 | 2 | 55 | 26 | ||
| 15422 | 158373 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 240 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6001519.98518 | 2096454.487 | 37.7365506072174 | -122.437215872525 | (37.7365506072174, -122.437215872525) | 2 | 7 | 5 | 63 | 7 | |||
| 193740 | 160520 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 782 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 12:02:00 PM | 3 | Width 0ft | 6001673.45326 | 2089428.52056 | 37.7172676235708 | -122.436182625252 | (37.7172676235708, -122.436182625252) | 9 | 7 | 6 | 28861 | 5 | |
| 27138 | 160521 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 786 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 11:59:00 AM | 3 | Width 0ft | 6001662.29271 | 2089410.30964 | 37.7172169863455 | -122.436219899452 | (37.7172169863455, -122.436219899452) | 9 | 7 | 6 | 28861 | 5 | |
| 71930 | 160603 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 771 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 12:20:00 PM | 3 | Width 0ft | 6002439.45935 | 2089043.61541 | 37.7162542504093 | -122.433507413734 | (37.7162542504093, -122.433507413734) | 9 | 7 | 6 | 28861 | 5 | |
| 7249 | 160605 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 753 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 01:48:00 PM | 3 | Width 0ft | 6002503.48745 | 2089141.95917 | 37.7165279132188 | -122.433293125102 | (37.7165279132188, -122.433293125102) | 9 | 7 | 6 | 28861 | 5 | |
| 186878 | 160606 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 745 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 0 | Width 0ft | 6002538.27018 | 2089198.00588 | 37.716683778298 | -122.433176901193 | (37.716683778298, -122.433176901193) | 9 | 7 | 6 | 28861 | 5 | ||
| 17692 | 161115 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 580 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 03:13:00 PM | 3 | Width 0ft | 6003070.44185 | 2090129.12968 | 37.7192706134287 | -122.431403880597 | (37.7192706134287, -122.431403880597) | 9 | 7 | 6 | 28861 | 5 | |
| 5069 | 161446 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 330 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6002674.4423 | 2091528.28518 | 37.7230899316367 | -122.432872602985 | (37.7230899316367, -122.432872602985) | 9 | 7 | 6 | 28861 | 5 | |||
| 17122 | 171142 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 23 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 4ft | 6004222.5848 | 2093413.47095 | 37.7283539207904 | -122.427655231101 | (37.7283539207904, -122.427655231101) | 9 | 7 | 6 | 28861 | 5 | ||
| 13304 | 171228 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 131 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 2ft | 6004022.36469 | 2093295.14469 | 37.7280176957394 | -122.428338971261 | (37.7280176957394, -122.428338971261) | 9 | 7 | 6 | 28861 | 5 | ||
| 13387 | 171252 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 198 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003761.7429 | 2092753.33549 | 37.7265152577639 | -122.429201331188 | (37.7265152577639, -122.429201331188) | 9 | 7 | 6 | 28861 | 5 | ||
| 194490 | 171446 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 130 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 2ft | 6004630.97691 | 2092622.98585 | 37.7262065159928 | -122.426187146329 | (37.7262065159928, -122.426187146329) | 9 | 7 | 6 | 28861 | 5 | ||
| 19514 | 171471 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 225 Congdon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6004711.85389 | 2093923.42078 | 37.7297817932982 | -122.426000090949 | (37.7297817932982, -122.426000090949) | 9 | 7 | 6 | 28861 | 5 | |||
| 11445 | 171733 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1010 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 0 | 3x5 | 6007780.11257 | 2093435.62386 | 37.72861533842 | -122.415358227021 | (37.72861533842, -122.415358227021) | 9 | 3 | 7 | 309 | 5 | |||
| 10773 | 172109 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 310 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x5 | 6009602.86357 | 2092915.14715 | 37.7272884975408 | -122.409020135273 | (37.7272884975408, -122.409020135273) | 10 | 3 | 7 | 309 | 28 | |||
| 2545 | 177492 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1362 Wayland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/2019 12:00:00 AM | 3 | Width 2ft | 6007661.42088 | 2091474.33514 | 37.7232233883366 | -122.415629744043 | (37.7232233883366, -122.415629744043) | 9 | 3 | 7 | 309 | 28 | ||
| 194476 | 179001 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 500 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | Permit Number 778923 | 6001827.05422 | 2090687.03762 | 37.7207319560017 | -122.435741691253 | (37.7207319560017, -122.435741691253) | 9 | 7 | 6 | 28861 | 5 | ||
| 194471 | 179002 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 500 Paris St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | Permit Number 778923 | 6001822.18343 | 2090679.74768 | 37.7207116627863 | -122.43575800674 | (37.7207116627863, -122.43575800674) | 9 | 7 | 6 | 28861 | 5 | ||
| 183982 | 180958 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 778 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 12:11:00 PM | 3 | Width 2ft | 6001688.47401 | 2089452.0208 | 37.7173330033918 | -122.43613238641 | (37.7173330033918, -122.43613238641) | 9 | 7 | 6 | 28861 | 5 | |
| 13513 | 183546 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2585 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2020 12:00:00 AM | 3 | Width 0ft | 5988604.9156 | 2097737.5116 | 37.7393308334388 | -122.481962210024 | (37.7393308334388, -122.481962210024) | 1 | 8 | 3 | 29491 | 35 | ||
| 6390 | 183851 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2235 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2020 12:00:00 AM | 3 | 5x5 | 5986665.607 | 2100041.6444 | 37.7455443899531 | -122.4888367163 | (37.7455443899531, -122.4888367163) | 1 | 8 | 3 | 29491 | 35 | ||
| 5336 | 191216 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2095 Bancroft Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2020 09:52:00 PM | 3 | 4x6 | 6011626.75031 | 2094136.85513 | 37.7307562213185 | -122.402109379558 | (37.7307562213185, -122.402109379558) | 10 | 3 | 8 | 58 | 1 | ||
| 34807 | 197978 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1100 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2018 12:00:00 AM | 7 | Width 4ft | 6013947.00765 | 2106209.45605 | 37.7640342630845 | -122.394933045925 | (37.7640342630845, -122.394933045925) | 14 | 3 | 8 | 28856 | 29 | ||
| 11252 | 221394 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 704 Waller St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 08:48:00 AM | 3 | Width 3ft | 6002285.30812 | 2108832.29494 | 37.7705805883473 | -122.435455014354 | (37.7705805883473, -122.435455014354) | 15 | 5 | 11 | 29492 | 9 | ||
| 6122 | 221395 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 704 Waller St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 08:44:00 AM | 3 | Width 3ft | 6002236.87075 | 2108821.32754 | 37.7705477235228 | -122.435621774727 | (37.7705477235228, -122.435621774727) | 15 | 5 | 11 | 29492 | 9 | ||
| 1288 | 233082 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1418 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/2020 12:00:00 AM | 3 | 3x3 | Permit Number 785211 | 6001974.22065 | 2099890.10044 | 37.746009810513 | -122.43589113876 | (37.746009810513, -122.43589113876) | 2 | 7 | 5 | 63 | 22 |
| 19245 | 233677 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 4068 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | Permit Number 785223 | 6003410.93999 | 2101286.47025 | 37.7499254263317 | -122.431022800956 | (37.7499254263317, -122.431022800956) | 2 | 4 | 5 | 28862 | 22 | ||
| 20897 | 23686 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 332 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/29/2016 12:00:00 AM | 3 | 3X3 | Permit Number 776287 | 6006868.2665484 | 2098036.0093442 | 37.7411956919963 | -122.418836670708 | (37.7411956919963, -122.418836670708) | 2 | 7 | 7 | 28859 | 2 | |
| 17274 | 240325 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 704 Waller St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 08:41:00 AM | 3 | Width 3ft | 6002296.51471 | 2108833.13942 | 37.7705835435377 | -122.435416311116 | (37.7705835435377, -122.435416311116) | 15 | 5 | 11 | 29492 | 9 | ||
| 10788 | 243432 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 706 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x4 | 6007366.7652 | 2095614.77671 | 37.7345755773039 | -122.416941529321 | (37.7345755773039, -122.416941529321) | 2 | 7 | 7 | 28859 | 2 | |||
| 5390 | 244700 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 722 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/07/2020 08:50:00 AM | 3 | Width 3ft | Permit Number 32809 | 6002026.57128 | 2108798.52358 | 37.7704731625436 | -122.43634756898 | (37.7704731625436, -122.43634756898) | 15 | 5 | 11 | 29492 | 9 | |
| 194428 | 253435 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 793 Vienna St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/18/2017 11:49:00 AM | 3 | 6002373 | 2088903 | 37.7158643806251 | -122.433727084844 | (37.7158643806251, -122.433727084844) | 9 | 7 | 6 | 28861 | 5 | |||
| 172127 | 254562 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2743 38th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/28/2018 12:00:00 AM | 3 | 3x3 | Permit Number 779392 | 5984613.41462 | 2096519.76609 | 37.7357542837064 | -122.495673043599 | (37.7357542837064, -122.495673043599) | 1 | 8 | 3 | 29491 | 35 | |
| 88439 | 254690 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1666 28th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781577 | 5987504.11579 | 2103945.47752 | 37.7563121659062 | -122.486223855163 | (37.7563121659062, -122.486223855163) | 1 | 8 | 3 | 56 | 35 | |
| 133805 | 254759 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1185 Vicente St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781601 | 5989303.86415 | 2097634.53427 | 37.7390887094016 | -122.479538051252 | (37.7390887094016, -122.479538051252) | 1 | 8 | 3 | 29491 | 35 | |
| 15858 | 255188 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 401 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 8618 | 255189 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 401 Goettingen St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
| 20087 | 255687 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1435 Oakdale Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/25/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782067 | 6015917.10189 | 2094795.04742 | 37.7328020209929 | -122.387322721383 | (37.7328020209929, -122.387322721383) | 10 | 3 | 8 | 58 | 1 | |
| 8975 | 256665 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1381 Filbert St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/2018 12:00:00 AM | 3 | 5x5 | Permit Number 782595 | 6006338.70929 | 2119347.35531 | 37.7996817310416 | -122.422181395696 | (37.7996817310416, -122.422181395696) | 13 | 9 | 1 | 28858 | 32 | |
| 52532 | 256670 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2115 Larkin St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782609 | 6006830.64787 | 2118452.41017 | 37.7972521720159 | -122.42041554717 | (37.7972521720159, -122.42041554717) | 13 | 9 | 10 | 28858 | 32 | |
| 63591 | 256687 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2325 Larkin St | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/21/2018 12:00:00 AM | 3 | 3x3 | Permit Number 782619 | 6006732.00195 | 2119165.45043 | 37.7992044415718 | -122.420807535438 | (37.7992044415718, -122.420807535438) | 5 | 9 | 1 | 28858 | 32 | |
| 12440 | 256745 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1562 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 3x5 | 5985620.2456 | 2104586.16151 | 37.7579613290823 | -122.492786024726 | (37.7579613290823, -122.492786024726) | 1 | 8 | 3 | 56 | 35 | ||
| 14907 | 258013 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2319 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 5983275.88991 | 2099350.91924 | 37.7434494414187 | -122.500506582091 | (37.7434494414187, -122.500506582091) | 1 | 8 | 3 | 29491 | 35 | |||
| 4847 | 258154 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 343 Woolsey St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 6010747.56272 | 2091896.11912 | 37.7245545163839 | -122.404991175416 | (37.7245545163839, -122.404991175416) | 10 | 3 | 7 | 309 | 28 | |||
| 14189 | 258155 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 624 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | 4x5 | 6010881.85424 | 2091832.73842 | 37.7243879921254 | -122.404522485328 | (37.7243879921254, -122.404522485328) | 10 | 3 | 7 | 309 | 28 | ||
| 15487 | 258375 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1010 Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3x3 | 6007854.59312 | 2093456.62302 | 37.7286771834491 | -122.415102228476 | (37.7286771834491, -122.415102228476) | 9 | 3 | 7 | 309 | 5 | |||
| 15845 | 258506 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1826 48th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/24/2019 12:00:00 AM | 3 | 3x3 | Permit Number 784310 | 5981340.96511 | 2102634.36273 | 37.7523510806953 | -122.507440512367 | (37.7523510806953, -122.507440512367) | 1 | 8 | 3 | 56 | 35 | |
| 17044 | 260427 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 89 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/17/2019 12:00:00 AM | 3 | 6010194.54099 | 2094209.98779 | 37.7308769843628 | -122.407065928845 | (37.7308769843628, -122.407065928845) | 10 | 3 | 7 | 309 | 28 | ||
| 19168 | 260518 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 3832 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 5983000.66744 | 2104942.49722 | 37.7587861961844 | -122.50187185062 | (37.7587861961844, -122.50187185062) | 1 | 8 | 3 | 56 | 35 | ||
| 15040 | 260527 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2610 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | 5981833.19804 | 2097322.67554 | 37.7377956491303 | -122.505344662268 | (37.7377956491303, -122.505344662268) | 1 | 8 | 3 | 29491 | 35 | ||
| 5063 | 260534 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1506 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | 5981886.54013 | 2104825.39883 | 37.7583991678414 | -122.50571626969 | (37.7583991678414, -122.50571626969) | 1 | 8 | 3 | 56 | 35 | ||
| 2865 | 261006 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 790 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/2019 12:00:00 AM | 3 | 3x3 | 5990765 | 2110001 | 37.7731285196197 | -122.475388811077 | (37.7731285196197, -122.475388811077) | 11 | 6 | 2 | 54 | 26 | |
| 10184 | 261009 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 838 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/2019 12:00:00 AM | 3 | 3x3 | 5987009 | 2110240 | 37.7735663130345 | -122.488398695138 | (37.7735663130345, -122.488398695138) | 11 | 6 | 2 | 55 | 26 | |
| 5004 | 261013 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 579 19th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/2019 12:00:00 AM | 3 | Width 3ft | 5989983 | 2111430 | 37.7770068001675 | -122.478198321712 | (37.7770068001675, -122.478198321712) | 11 | 6 | 2 | 55 | 26 | ||
| 5923 | 261025 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 795 20th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2019 12:00:00 AM | Width 4ft | 5989738.01651 | 2110022.28004 | 37.7731273658577 | -122.47894279668 | (37.7731273658577, -122.47894279668) | 11 | 6 | 2 | 55 | 26 | |||
| 13969 | 261065 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2511 Quint St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6011535 | 2094074 | 37.7305785127067 | -122.402422158669 | (37.7305785127067, -122.402422158669) | 10 | 3 | 8 | 58 | 1 | ||||
| 2870 | 261066 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2511 Quint St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6011535 | 2094074 | 37.7305785127067 | -122.402422158669 | (37.7305785127067, -122.402422158669) | 10 | 3 | 8 | 58 | 1 | ||||
| 9286 | 261118 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 115 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2019 12:00:00 AM | 3 | 5x5 | 6014054.18406 | 2094106.54967 | 37.7308081987292 | -122.393715174766 | (37.7308081987292, -122.393715174766) | 10 | 3 | 8 | 58 | 1 | ||
| 16510 | 261124 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1955 Carroll Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2019 12:00:00 AM | 3 | 4x6 | 6012189 | 2093402 | 37.7287698274178 | -122.400113992874 | (37.7287698274178, -122.400113992874) | 10 | 3 | 8 | 58 | 1 | ||
| 5846 | 261125 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1955 Carroll Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/2019 12:00:00 AM | 3 | 4x6 | 6012189 | 2093402 | 37.7287698274178 | -122.400113992874 | (37.7287698274178, -122.400113992874) | 10 | 3 | 8 | 58 | 1 | ||
| 1338 | 261130 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 198 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003761.7429 | 2092753.33549 | 37.7265152577639 | -122.429201331188 | (37.7265152577639, -122.429201331188) | 9 | 7 | 6 | 28861 | 5 | ||
| 5570 | 261215 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1770 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/12/2019 12:00:00 AM | 3 | 4x6 | 5984144 | 2103125 | 37.7538629512363 | -122.497783538537 | (37.7538629512363, -122.497783538537) | 1 | 8 | 3 | 56 | 35 | |
| 12991 | 261216 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2786 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 12:00:00 AM | 3 | 4x6 | 5984380 | 2096227 | 37.7349367548256 | -122.496458440233 | (37.7349367548256, -122.496458440233) | 1 | 8 | 3 | 29491 | 35 | |
| 9110 | 261218 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1506 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/2019 12:00:00 AM | 3 | 4x6 | 5983437 | 2104877 | 37.7586319808213 | -122.500357993039 | (37.7586319808213, -122.500357993039) | 1 | 8 | 3 | 56 | 35 | |
| 14230 | 261818 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1601 Quintara St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 02/28/2020 12:00:00 AM | 3 | 5x5 | 5988457 | 2100975 | 37.7482115203177 | -122.482710816875 | (37.7482115203177, -122.482710816875) | 1 | 8 | 3 | 29491 | 35 | ||
| 194410 | 265060 | Section 806 (d) 5 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 48 Miraloma Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12/28/2020 12:00:00 AM | 3 | 6x6 | Permit Number 782253 | 5994833.01253 | 2097558.21258 | 37.7391987718964 | -122.46041537824 | (37.7391987718964, -122.46041537824) | 9 | 7 | 4 | 59 | 40 | |
| 72908 | 32056 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 3516 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/15/2009 12:00:00 AM | 3x3 | Permit Number 52612 | 6003328.9813191 | 2106558.55926414 | 37.7643966822396 | -122.431682578762 | (37.7643966822396, -122.431682578762) | 15 | 4 | 5 | 28862 | 3 | |
| 194478 | 35851 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 500 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778923 | 6001833.39372 | 2090697.41132 | 37.7207607999542 | -122.435720519401 | (37.7207607999542, -122.435720519401) | 9 | 7 | 6 | 28861 | 5 | |
| 8206 | 38101 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1273 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781573 | 5987681.6278 | 2106613.2126 | 37.7636473828601 | -122.485805759721 | (37.7636473828601, -122.485805759721) | 1 | 8 | 3 | 56 | 35 | |
| 48916 | 45137 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1234 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53510 | 6000650.05093889 | 2109301.35578788 | 37.7717755038706 | -122.441145029184 | (37.7717755038706, -122.441145029184) | 15 | 5 | 11 | 29492 | 9 | ||
| 101331 | 49926 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 639@ 20th ST Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53572 | 6007922.28440673 | 2104209.24888267 | 37.7582053099171 | -122.415629221325 | (37.7582053099171, -122.415629221325) | 2 | 4 | 7 | 28859 | 19 | ||
| 25814 | 52407 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 70 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/2005 12:00:00 AM | 3x3 | Permit Number 48526 | 6007233.79686164 | 2099091.04833404 | 37.7441131685781 | -122.41764755492 | (37.7441131685781, -122.41764755492) | 2 | 7 | 7 | 28859 | 2 | |
| 91815 | 52452 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 687 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 02/06/2018 12:00:00 AM | 3 | 3x5 | Permit Number 48564 | 5992531.34359589 | 2110788.08825495 | 37.7753918800475 | -122.469336156693 | (37.7753918800475, -122.469336156693) | 11 | 6 | 2 | 54 | 11 |
| 120361 | 54427 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 190 Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/29/2018 12:00:00 AM | 0 | Permit Number 772447 | 6013973.0139 | 2106251.38304 | 37.7641508314323 | -122.39484603384 | (37.7641508314323, -122.39484603384) | 14 | 3 | 8 | 28856 | 29 | ||
| 102455 | 56347 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 875 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | Permit Number 12489 | 5988181.07847 | 2110036.24372 | 37.7730751725436 | -122.484329403924 | (37.7730751725436, -122.484329403924) | 11 | 6 | 2 | 55 | 26 | |
| 92598 | 60089 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1216 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2018 12:00:00 AM | 3 | Permit Number 782039 | 6007184.48933 | 2118821.16351 | 37.7982846096101 | -122.419217334828 | (37.7982846096101, -122.419217334828) | 5 | 1 | 10 | 28858 | 32 |
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) );