trees
145 rows where qSpecies_id = 181 sorted by XCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||
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 | ||||||||||||||
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 | |
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 | |||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | ||
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 | |||
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 | |
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 | |||
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 | ||
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 | |
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 | |
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 | ||
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 | ||
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 |
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 | ||
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 | |
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 | |
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 | |
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 | ||
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 | |
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 |
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | |||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
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 | |
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 |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
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 | |
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |
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 | ||
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 | ||
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 | ||
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 | |||
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 | |
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 | |
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 | |
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 | ||
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 | ||
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 | |
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 |
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
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 | |
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 | |||
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 | ||
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 | ||
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 | |||
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 | |
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 | |
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 | |||
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 | |
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 | ||
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | |||
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 |
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) );