trees
145 rows where qSpecies_id = 181 sorted by PlotSize
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qCareAssistant, Fire Prevention Districts, Neighborhoods (old)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | ||
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 | ||||||||||||||
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 | ||
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 | ||||||||||||||
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 | |||
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 | ||
35599 | 97045 | Property Tree 8 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
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 | |||
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 | ||
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 | ||
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 | |||
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
141020 | 62882 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 107 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/2015 12:00:00 AM | Permit Number 774278 | 6008878.23001524 | 2098033.75307574 | 37.7413024656019 | -122.41188674968 | (37.7413024656019, -122.41188674968) | 10 | 7 | 7 | 28859 | 2 | ||
148693 | 64873 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 710 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2014 12:00:00 AM | Permit Number 772699 | 6002299.12581357 | 2108836.45328021 | 37.77059279087 | -122.435407516384 | (37.77059279087, -122.435407516384) | 15 | 5 | 11 | 29492 | 9 | ||
165726 | 66984 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 584 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/04/1992 12:00:00 AM | 6 | Permit Number 30386 | 5995340.92423 | 2111581.33357 | 37.7777318801956 | -122.459674692692 | (37.7777318801956, -122.459674692692) | 11 | 6 | 2 | 54 | 11 | |
173197 | 63695 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1783 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/30/2014 12:00:00 AM | Permit Number 773244 | 5993095.47933652 | 2103351.7568476 | 37.7550062601161 | -122.466843987881 | (37.7550062601161, -122.466843987881) | 1 | 8 | 4 | 56 | 12 | ||
182313 | 65459 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 298X De Montfort Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/19/2015 12:00:00 AM | Permit Number 774165 | 5994499.27735341 | 2091923.17456246 | 37.7237071317421 | -122.46116092612 | (37.7237071317421, -122.46116092612) | 9 | 8 | 4 | 28861 | 24 | ||
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 | ||
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 | |||
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 | |
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 |
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 | |
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 | |||
6232 | 90570 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1830 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/13/2019 12:00:00 AM | 3 | 3x3 | 5989885.34607 | 2110621.45957 | 37.7747811022825 | -122.478476993955 | (37.7747811022825, -122.478476993955) | 11 | 6 | 2 | 55 | 26 | ||
7091 | 88264 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1911 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51250 | 5997436 | 2108804 | 37.7702262944805 | -122.452226693379 | (37.7702262944805, -122.452226693379) | 15 | 5 | 11 | 29492 | 9 | |
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 | |
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 | |
12802 | 90560 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1708X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/13/2019 12:00:00 AM | 3 | 3x3 | 5990305.21936 | 2110637.36838 | 37.7748491506665 | -122.477025744042 | (37.7748491506665, -122.477025744042) | 11 | 6 | 2 | 55 | 26 | ||
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 | |||
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 | |
16809 | 90561 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1708 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/13/2019 12:00:00 AM | 3 | 3x3 | 5990278 | 2110663 | 37.7749179489318 | -122.47712177393 | (37.7749179489318, -122.47712177393) | 11 | 6 | 2 | 55 | 26 | ||
18029 | 87976 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2160 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/2008 12:00:00 AM | 3x3 | Permit Number 51010 | 5999212.8 | 2111613.6 | 37.7780423637934 | -122.446282917617 | (37.7780423637934, -122.446282917617) | 15 | 5 | 11 | 54 | 16 | ||
19947 | 95872 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 585 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767589 | 6010187.2 | 2119540 | 37.8004270041515 | -122.408877749885 | (37.8004270041515, -122.408877749885) | 3 | 1 | 10 | 308 | 23 | |
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 | |
24316 | 95871 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 585 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/2011 12:00:00 AM | 3x3 | Permit Number 767589 | 6010187.2 | 2119540 | 37.8004270041515 | -122.408877749885 | (37.8004270041515, -122.408877749885) | 3 | 1 | 10 | 308 | 23 | |
25276 | 83901 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 30 Paulding St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50520 | 6000137.45040152 | 2093299.82569478 | 37.727809954285 | -122.441769533345 | (37.727809954285, -122.441769533345) | 9 | 7 | 6 | 28861 | 25 | ||
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 | |
28459 | 88318 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 607 France Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51309 | 6002519.4 | 2089575.2 | 37.7177183994753 | -122.433269062939 | (37.7177183994753, -122.433269062939) | 9 | 7 | 6 | 28861 | 5 | |||
29622 | 96478 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 777 Florida St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2011 12:00:00 AM | 3x3 | Permit Numbe 52657 | 6009359.6 | 2104624.3 | 37.7594256359904 | -122.410687650563 | (37.7594256359904, -122.410687650563) | 2 | 4 | 7 | 28859 | 19 | ||
30953 | 92220 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 777 Florida St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52657 | 6009359.6 | 2104624.3 | 37.7594256359904 | -122.410687650563 | (37.7594256359904, -122.410687650563) | 2 | 4 | 7 | 28859 | 19 | ||
31219 | 92221 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 777 Florida St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52657 | 6009359.6 | 2104624.3 | 37.7594256359904 | -122.410687650563 | (37.7594256359904, -122.410687650563) | 2 | 4 | 7 | 28859 | 19 | ||
33507 | 95540 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 4750 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767327 | 6000130.6 | 2101122.2 | 37.7492879573628 | -122.442354552038 | (37.7492879573628, -122.442354552038) | 2 | 4 | 5 | 28862 | 22 | |
41375 | 96477 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 777 Florida St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/24/2011 12:00:00 AM | 3x3 | Permit number 52657 | 6009359.6 | 2104624.3 | 37.7594256359904 | -122.410687650563 | (37.7594256359904, -122.410687650563) | 2 | 4 | 7 | 28859 | 19 | ||
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 | ||
49877 | 88184 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 489 Clementina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2011 12:00:00 AM | 1 | 3x3 | Permit Number 767583 | 6010914.9 | 2111745.1 | 37.7790648045054 | -122.405810224266 | (37.7790648045054, -122.405810224266) | 14 | 2 | 9 | 28853 | 34 | ||
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 | |
55226 | 88252 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 1025 Ashbury St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51238 | 5999131 | 2106547 | 37.7641260948648 | -122.446201344399 | (37.7641260948648, -122.446201344399) | 15 | 5 | 11 | 29492 | 9 | |||
59104 | 92219 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 777 Florida St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52657 | 6009359.6 | 2104624.3 | 37.7594256359904 | -122.410687650563 | (37.7594256359904, -122.410687650563) | 2 | 4 | 7 | 28859 | 19 | ||
61970 | 88249 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 4758 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51235 | 5998426 | 2105687 | 37.7617244639768 | -122.448577782387 | (37.7617244639768, -122.448577782387) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |
65175 | 87928 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2x TRAINOR ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50952 | 6008026 | 2108277 | 37.7693802414943 | -122.415558521529 | (37.7693802414943, -122.415558521529) | 8 | 4 | 7 | 28853 | 19 | ||
65448 | 84437 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 635 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2010 12:00:00 AM | 3x3 | Permit Number 53514 | 6007921.04355944 | 2104231.6010622 | 37.7582666141285 | -122.415635095313 | (37.7582666141285, -122.415635095313) | 2 | 4 | 7 | 28859 | 19 | ||
67156 | 88254 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 107 Belvedere St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51239 | 5998213 | 2108192 | 37.768590378969 | -122.449494963351 | (37.768590378969, -122.449494963351) | 15 | 5 | 11 | 29492 | 9 | |||
70681 | 63131 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 12 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/14/2009 12:00:00 AM | 3x3 | Permit Number 52579 | 6007273.52756305 | 2099560.25449012 | 37.745403739192 | -122.417543422292 | (37.745403739192, -122.417543422292) | 2 | 7 | 7 | 28859 | 2 | ||
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 | |
72954 | 95530 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 3325 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/2011 12:00:00 AM | 3x3 | Permit Number 767321 | 5982880 | 2100129 | 37.7455625889452 | -122.501933006964 | (37.7455625889452, -122.501933006964) | 1 | 8 | 3 | 29491 | 35 | |
73236 | 88248 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 4418 17th St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51234 | 6000065 | 2105781 | 37.7620761444221 | -122.442915908064 | (37.7620761444221, -122.442915908064) | 15 | 5 | 5 | 28862 | 3 | |||
76201 | 92222 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 777 Florida St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52657 | 6009359.6 | 2104624.3 | 37.7594256359904 | -122.410687650563 | (37.7594256359904, -122.410687650563) | 2 | 4 | 7 | 28859 | 19 | ||
77188 | 95705 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 531 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/09/2011 12:00:00 AM | 3x3 | Permit Number 767453 | 5992416 | 2103429 | 37.7551791102968 | -122.469199421964 | (37.7551791102968, -122.469199421964) | 1 | 8 | 4 | 56 | 12 | |
81556 | 95870 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 471 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/2012 12:00:00 AM | 0 | 3x3 | Permit Number 769435 | 6010616 | 2120218 | 37.8023126350272 | -122.407441748946 | (37.8023126350272, -122.407441748946) | 3 | 1 | 10 | 308 | 23 | |
81594 | 95568 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 353 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767360 | 6002854 | 2101511 | 37.7505103579798 | -122.432964764241 | (37.7505103579798, -122.432964764241) | 2 | 4 | 5 | 28862 | 22 | |
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 | |
89626 | 88352 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 700 VIENNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51333 | 6002601.8 | 2089436.1 | 37.7173411358396 | -122.432974311079 | (37.7173411358396, -122.432974311079) | 9 | 7 | 6 | 28861 | 5 | ||
93173 | 84265 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 766 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | Permit Number 51838 | 5988211.57973 | 2110760.94894 | 37.7750667870422 | -122.484277057304 | (37.7750667870422, -122.484277057304) | 11 | 6 | 2 | 55 | 26 |
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 | ||
118405 | 62528 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 4259 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 3x3 | Permit Number 53580 | 6000833.16850213 | 2102853.59020152 | 37.7540819566375 | -122.440049196257 | (37.7540819566375, -122.440049196257) | 2 | 4 | 5 | 28862 | 22 | ||
121189 | 88324 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 182 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51313 | 6003195 | 2092351 | 37.7253784345628 | -122.431131833246 | (37.7253784345628, -122.431131833246) | 9 | 7 | 6 | 28861 | 5 | |||
128073 | 88181 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 437 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51189 | 6011272.5 | 2112058.5 | 37.7799453198016 | -122.404595202044 | (37.7799453198016, -122.404595202044) | 14 | 2 | 9 | 28853 | 34 | ||
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 | |
135010 | 99820 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 100X Wool St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/04/2012 12:00:00 AM | 8 | 3x3 | Permit Number 768974 | 6007364.7 | 2097747 | 37.7404300763526 | -122.417099703218 | (37.7404300763526, -122.417099703218) | 2 | 7 | 7 | 28859 | 2 |
157786 | 95576 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 373 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/02/2011 12:00:00 AM | 3x3 | Permit Number 767365 | 6003497 | 2099203 | 37.7442095786195 | -122.430576552899 | (37.7442095786195, -122.430576552899) | 2 | 7 | 5 | 63 | 22 | |
159282 | 96479 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 777 Florida St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 52657 | 6009359.6 | 2104624.3 | 37.7594256359904 | -122.410687650563 | (37.7594256359904, -122.410687650563) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |
178822 | 88182 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 437 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51189 | 6011272.5 | 2112058.5 | 37.7799453198016 | -122.404595202044 | (37.7799453198016, -122.404595202044) | 14 | 2 | 9 | 28853 | 34 | ||
188482 | 90527 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 721 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/29/2018 12:00:00 AM | 3 | 3x3 | 5988144.63495 | 2111037.07695 | 37.7758210592037 | -122.484528889225 | (37.7758210592037, -122.484528889225) | 11 | 6 | 2 | 55 | 26 | ||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 |
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 | |||
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 | ||
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 | ||
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 | |
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 | ||
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 | |
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 | |
15099 | 95445 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 2201 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/2020 12:00:00 AM | 3 | 4x6 | Permit Number 767307 | 5985726.3556 | 2100198.6842 | 37.7459207192562 | -122.492096016775 | (37.7459207192562, -122.492096016775) | 1 | 8 | 3 | 29491 | 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) );