trees
5,723 rows where qSpecies_id = 14 sorted by PermitNotes descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41681 | 78868 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 701-799X Felton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773816 | 6008882 | 2093290 | 37.7282773557004 | -122.411538639849 | (37.7282773557004, -122.411538639849) | 9 | 3 | 7 | 309 | 28 |
150352 | 78865 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 701-799X Felton St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773816 | 6008882 | 2093290 | 37.7282773557004 | -122.411538639849 | (37.7282773557004, -122.411538639849) | 9 | 3 | 7 | 309 | 28 |
163700 | 45244 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1000-1098X Woolsey St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/2015 12:00:00 AM | 3 | Permit Number 773816 | 6008759.06383256 | 2091334.69120464 | 37.7229015956225 | -122.411825527366 | (37.7229015956225, -122.411825527366) | 9 | 3 | 7 | 309 | 28 | |
21442 | 82199 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 387-389 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773788 | 5992147.23232 | 2112897.41844 | 37.7811613217497 | -122.470818557907 | (37.7811613217497, -122.470818557907) | 11 | 6 | 2 | 54 | 11 | |
131067 | 108471 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 783 09th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773780 | 5993180.23272 | 2110155.10889 | 37.7736913649846 | -122.467045486436 | (37.7736913649846, -122.467045486436) | 11 | 6 | 2 | 54 | 11 | |||
187413 | 108474 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 619 06th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3x3 | Permit Number 773774 | 5994069.31075 | 2111288.088 | 37.7768535012339 | -122.464052313375 | (37.7768535012339, -122.464052313375) | 11 | 6 | 2 | 54 | 11 | |||
136948 | 108568 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 225 Harvard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773759 | 6006239.22183 | 2092782.68354 | 37.7267357814247 | -122.420638852723 | (37.7267357814247, -122.420638852723) | 9 | 7 | 7 | 309 | 5 |
109608 | 109273 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2471 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773741 | 5982670.2 | 2098312.5 | 37.7405626536351 | -122.502524028762 | (37.7405626536351, -122.502524028762) | 1 | 8 | 3 | 29491 | 35 |
118872 | 109274 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2471 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773741 | 5982670.2 | 2098312.5 | 37.7405626536351 | -122.502524028762 | (37.7405626536351, -122.502524028762) | 1 | 8 | 3 | 29491 | 35 |
74722 | 108401 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1180 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773737 | 6010006.40418 | 2102333.75389 | 37.7531725525046 | -122.408289117045 | (37.7531725525046, -122.408289117045) | 2 | 4 | 7 | 28859 | 19 |
97488 | 108547 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 400 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773709 | 6002168.78334 | 2093999.82608 | 37.7298475310412 | -122.434797220518 | (37.7298475310412, -122.434797220518) | 9 | 7 | 6 | 28861 | 25 |
89982 | 108543 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 291 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773705 | 6001182.06594 | 2092854.3647 | 37.7266462863625 | -122.43812638687 | (37.7266462863625, -122.43812638687) | 9 | 7 | 6 | 28861 | 25 |
175600 | 114769 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 17 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2015 12:00:00 AM | Permit Number 773692 | 6006175 | 2103983.2 | 37.7574862588428 | -122.421656044278 | (37.7574862588428, -122.421656044278) | 2 | 4 | 5 | 28859 | 19 | |||
163902 | 108515 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1411 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773663 | 5990815.14747 | 2105785.21755 | 37.7615560250548 | -122.474907562892 | (37.7615560250548, -122.474907562892) | 1 | 8 | 4 | 56 | 12 |
89174 | 108512 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1621 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773655 | 5991123.73124 | 2104364.35192 | 37.7576725829923 | -122.473736652625 | (37.7576725829923, -122.473736652625) | 1 | 8 | 4 | 56 | 12 |
123970 | 107442 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2915 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/2014 12:00:00 AM | 3 | Permit Number 773608 | 5999618.41032 | 2117367.65959 | 37.7938646692746 | -122.445293589454 | (37.7938646692746, -122.445293589454) | 13 | 9 | 1 | 57 | 27 | ||
59333 | 73959 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 75 Rice St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/1995 12:00:00 AM | 4 | 2x4 | Permit Number 773591 | 5995358.56494273 | 2086411.36688337 | 37.7086224204841 | -122.457791883945 | (37.7086224204841, -122.457791883945) | 9 | 7 | 6 | 28861 | 25 | |
128558 | 109252 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2443 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773556 | 5981723 | 2098451 | 37.7408872317264 | -122.505809288749 | (37.7408872317264, -122.505809288749) | 1 | 8 | 3 | 29491 | 35 |
59256 | 109137 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 782 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773540 | 5985421.66882 | 2110563.91491 | 37.7743629473402 | -122.493913306929 | (37.7743629473402, -122.493913306929) | 11 | 6 | 2 | 55 | 26 |
106706 | 109135 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 730 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773524 | 5981688.65422 | 2110759.10113 | 37.7746797503105 | -122.506840755547 | (37.7746797503105, -122.506840755547) | 11 | 6 | 2 | 55 | 26 |
3252 | 35926 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2660 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773492 | 6001423.81293 | 2116968.31873 | 37.7928710739952 | -122.439018105808 | (37.7928710739952, -122.439018105808) | 13 | 6 | 1 | 29490 | 27 | |
76401 | 35925 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2660 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/1998 12:00:00 AM | 17 | 3x3 | Permit Number 773492 | 6001407.31616 | 2116967.42218 | 37.7928676736556 | -122.439075121022 | (37.7928676736556, -122.439075121022) | 13 | 6 | 1 | 29490 | 27 | |
40004 | 109266 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2215 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773453 | 5984472.3 | 2100083.9 | 37.7455321666577 | -122.496423834874 | (37.7455321666577, -122.496423834874) | 1 | 8 | 3 | 29491 | 35 |
26543 | 108019 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 552 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2014 12:00:00 AM | 3 | 6x4 | Permit Number 773435 | 6005203 | 2110989 | 37.7766676518469 | -122.425516192927 | (37.7766676518469, -122.425516192927) | 7 | 9 | 11 | 28852 | 10 | |
57525 | 54809 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 150 Carmel St | 2 | Front Yard : Cutout | Tree | Private 2 | 03/12/2007 12:00:00 AM | 5 | 3x3 | Permit Number 773425 | 5998092.51354995 | 2105385.25255364 | 37.7608768673293 | -122.449709427273 | (37.7608768673293, -122.449709427273) | 15 | 5 | 11 | 29492 | 12 | |
36667 | 112972 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4099x ULLOA ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/20/2015 12:00:00 AM | 1 | 3x3 | Permit Number 773327 | 5983385 | 2098079 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | 1 | 8 | 3 | 29491 | 35 | |
45850 | 112974 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4099x ULLOA ST | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 773327 | 5983385 | 2098079 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | 1 | 8 | 3 | 29491 | 35 | ||
64240 | 112973 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4099x ULLOA ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 773327 | 5983385 | 2098079 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | 1 | 8 | 3 | 29491 | 35 | ||
124554 | 112975 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4099x ULLOA ST | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/20/2015 12:00:00 AM | 3x3 | Permit Number 773327 | 5983385 | 2098079 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | 1 | 8 | 3 | 29491 | 35 | ||
171259 | 107400 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3176 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2014 12:00:00 AM | 3 | Permit Number 773290 | 5999574.99056 | 2115728.91043 | 37.7893626172302 | -122.44532594346 | (37.7893626172302, -122.44532594346) | 13 | 6 | 1 | 29490 | 27 | ||
63590 | 114893 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1800 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2015 12:00:00 AM | 3 | Permit Number 773264 | 6000032.97053 | 2115147.92831 | 37.7877935241855 | -122.44369963555 | (37.7877935241855, -122.44369963555) | 13 | 6 | 1 | 29490 | 27 | ||
118384 | 114894 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1800 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2015 12:00:00 AM | 3 | Permit Number 773264 | 6000027.36318 | 2115184.64045 | 37.7878940063374 | -122.443721674325 | (37.7878940063374, -122.443721674325) | 13 | 6 | 1 | 29490 | 27 | ||
183021 | 109038 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1646 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773238 | 5985355 | 2103995.9 | 37.7563251201532 | -122.493659849192 | (37.7563251201532, -122.493659849192) | 1 | 8 | 3 | 56 | 35 |
65328 | 108980 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 70 Tucker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773181 | 6010690.3 | 2088693.9 | 37.7157586794381 | -122.404963766417 | (37.7157586794381, -122.404963766417) | 9 | 7 | 8 | 309 | 39 |
54362 | 108942 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 115B Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773148 | 6006936.4 | 2098796.9 | 37.7432887637665 | -122.418655034453 | (37.7432887637665, -122.418655034453) | 2 | 7 | 7 | 28859 | 2 |
94492 | 106556 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 767 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/2014 12:00:00 AM | 1 | 3x4 | Permit Number 773118 | 5988800.09905 | 2110110.4626 | 37.7733149816569 | -122.482193597345 | (37.7733149816569, -122.482193597345) | 11 | 6 | 2 | 55 | 26 | |
79300 | 106543 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 930 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2014 12:00:00 AM | 3x3 | Permit Number 773058 | 6007374.7 | 2120599.1 | 37.8031770856949 | -122.418685297733 | (37.8031770856949, -122.418685297733) | 5 | 1 | 1 | 28858 | 32 | ||
169243 | 115261 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 65 Williar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 773049 | 5997131.1 | 2090637.5 | 37.7203280768598 | -122.451970498816 | (37.7203280768598, -122.451970498816) | 9 | 8 | 6 | 28861 | 24 | |||
111352 | 108707 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1849 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773000 | 6003000.77487 | 2119918.27171 | 37.8010604804194 | -122.433772685874 | (37.8010604804194, -122.433772685874) | 13 | 9 | 1 | 57 | 17 |
114330 | 105935 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 450 Walnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2014 12:00:00 AM | 3x3 | Permit Number 772994 | 5998625.9783 | 2115075.11894 | 37.7875132600186 | -122.448562297399 | (37.7875132600186, -122.448562297399) | 13 | 6 | 1 | 54 | 31 | ||
126066 | 106759 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 363 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2014 12:00:00 AM | Permit Number 772944 | 5997685.2 | 2093762.7 | 37.7289408651206 | -122.450280323777 | (37.7289408651206, -122.450280323777) | 9 | 7 | 4 | 28861 | 40 | |||
131750 | 39246 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3524 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | 1 | Permit Number 772836 | 5997390.1418 | 2116079.35829 | 37.7901998932662 | -122.452910535096 | (37.7901998932662, -122.452910535096) | 11 | 6 | 1 | 54 | 31 | ||
17726 | 65839 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2328 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/2018 12:00:00 AM | 3 | 6x6 | Permit Number 772721 | 5999589.88517 | 2120533.82376 | 37.802556482867 | -122.445620078411 | (37.802556482867, -122.445620078411) | 13 | 9 | 1 | 57 | 17 | |
169250 | 104038 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 881 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772671 | 6008014.2 | 2102803.8 | 37.7543514341275 | -122.415211849225 | (37.7543514341275, -122.415211849225) | 2 | 4 | 7 | 28859 | 19 |
41668 | 106534 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 101 Carmel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2014 12:00:00 AM | Permit Number 772629 | 5998253.9 | 2105325.5 | 37.7607220337145 | -122.449146960487 | (37.7607220337145, -122.449146960487) | 15 | 5 | 11 | 29492 | 12 | |||
120456 | 106533 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 101 Carmel St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2014 12:00:00 AM | Permit Number 772629 | 5998253.9 | 2105325.5 | 37.7607220337145 | -122.449146960487 | (37.7607220337145, -122.449146960487) | 15 | 5 | 11 | 29492 | 12 | |||
173543 | 108564 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 208 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772581 | 6010035.65523 | 2093553.92933 | 37.7290666937725 | -122.407568987434 | (37.7290666937725, -122.407568987434) | 10 | 3 | 7 | 309 | 28 |
50355 | 34538 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3699X FOLSOM ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/1997 12:00:00 AM | Permit Number 772565 | 6008467 | 2097692 | 37.7403410071357 | -122.413284481355 | (37.7403410071357, -122.413284481355) | 10 | 7 | 7 | 28859 | 2 | ||
18825 | 66442 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 263 Richland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/01/2016 12:00:00 AM | 3 | Permit Number 772183 | 6006122.56808708 | 2096124.40877 | 37.7359048482193 | -122.421279320467 | (37.7359048482193, -122.421279320467) | 2 | 7 | 7 | 28859 | 2 | |
40662 | 109292 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3973 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772172 | 6003166.7 | 2105292.5 | 37.7609111890374 | -122.432153444067 | (37.7609111890374, -122.432153444067) | 2 | 4 | 5 | 28862 | 3 |
118082 | 30360 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 641 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2014 12:00:00 AM | 32 | 7x4 | Permit Number 772082 | 6013028.65179 | 2104089.94418 | 37.7581634420042 | -122.397960696334 | (37.7581634420042, -122.397960696334) | 10 | 3 | 8 | 28856 | 29 | |
169375 | 61392 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1665 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/26/2014 12:00:00 AM | 3 | Permit Number 771984 | 6004986.21736 | 2119156.81319 | 37.7990821724697 | -122.426847937578 | (37.7990821724697, -122.426847937578) | 13 | 9 | 1 | 57 | 17 | ||
188473 | 115251 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 38 Farallones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/21/2016 12:00:00 AM | Permit Number 771942 | 5996609.8 | 2088413 | 37.7141902463081 | -122.453611912242 | (37.7141902463081, -122.453611912242) | 9 | 8 | 6 | 28861 | 24 | |||
48602 | 105710 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 739 10th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2014 12:00:00 AM | 10 | 3x5 | Permit Number 771751 | 5992856.87559 | 2110408.5428 | 37.7743685567556 | -122.468182458896 | (37.7743685567556, -122.468182458896) | 11 | 6 | 2 | 54 | 11 | |
100934 | 99254 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 250X Locust St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2014 12:00:00 AM | 1 | Permit Number 771748 | 5997615.93287 | 2115496.61123 | 37.7886127616243 | -122.452087256128 | (37.7886127616243, -122.452087256128) | 11 | 6 | 1 | 54 | 31 | ||
135778 | 105884 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 250 Locust St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/06/2014 12:00:00 AM | 1 | Permit Number 771748 | 5997606.65182 | 2115545.6186 | 37.7887467911848 | -122.452122904373 | (37.7887467911848, -122.452122904373) | 11 | 6 | 1 | 54 | 31 | ||
61165 | 105972 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 40X Capistrano Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2014 12:00:00 AM | 3x3 | Permit Number 771217 | 6001217.27385 | 2093926.25582 | 37.7295914563619 | -122.438081423517 | (37.7295914563619, -122.438081423517) | 9 | 7 | 6 | 28861 | 25 | ||
152901 | 105971 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 40X Capistrano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/12/2014 12:00:00 AM | 3x3 | Permit Number 771217 | 6001217.27385 | 2093926.25582 | 37.7295914563619 | -122.438081423517 | (37.7295914563619, -122.438081423517) | 9 | 7 | 6 | 28861 | 25 | ||
128600 | 108416 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2835-2899X 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 771183 | 6004957 | 2100749 | 37.7485371416083 | -122.425638197277 | (37.7485371416083, -122.425638197277) | 2 | 4 | 5 | 63 | 22 |
65333 | 104823 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 641 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2013 12:00:00 AM | 2 | 3x3 | Permit Number 771081 | 5987509.53271 | 2111566.66512 | 37.7772381546113 | -122.48676473846 | (37.7772381546113, -122.48676473846) | 11 | 6 | 2 | 55 | 26 | |
52679 | 105069 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 49X Esmeralda Ave | 2 | Unaccepted Street : Yard | Tree | Private 2 | Permit Number 771039 | 6006861 | 2099026 | 37.7439135755866 | -122.418931994103 | (37.7439135755866, -122.418931994103) | 2 | 7 | 7 | 28859 | 2 | ||||
141297 | 105070 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 49X Esmeralda Ave | 3 | Unaccepted Street : Yard | Tree | Private 2 | Permit Number 771039 | 6006861 | 2099026 | 37.7439135755866 | -122.418931994103 | (37.7439135755866, -122.418931994103) | 2 | 7 | 7 | 28859 | 2 | ||||
36887 | 104925 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 620 27th Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | Permit Number 770954 | 5987551.03957 | 2111701.53361 | 37.7776108851926 | -122.486631060172 | (37.7776108851926, -122.486631060172) | 11 | 6 | 2 | 55 | 26 | |||
92158 | 74021 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1069 Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/09/2013 12:00:00 AM | 1 | Permit Number 770933 | 6008798.64457 | 2115935.54203 | 37.7904521737838 | -122.413427669467 | (37.7904521737838, -122.413427669467) | 5 | 1 | 10 | 28858 | 21 | ||
36960 | 113338 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2X STANFORD ST | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 3x9 | Permit Number 770912 | 6014727 | 2112481 | 37.7812978691674 | -122.392674013487 | (37.7812978691674, -122.392674013487) | 6 | 2 | 9 | 28856 | 6 | ||
125850 | 113335 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2X STANFORD ST | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 3x9 | Permit Number 770912 | 6014727 | 2112481 | 37.7812978691674 | -122.392674013487 | (37.7812978691674, -122.392674013487) | 6 | 2 | 9 | 28856 | 6 | ||
160249 | 113337 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2X STANFORD ST | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11/10/2015 12:00:00 AM | 3x9 | Permit Number 770912 | 6014727 | 2112481 | 37.7812978691674 | -122.392674013487 | (37.7812978691674, -122.392674013487) | 6 | 2 | 9 | 28856 | 6 | ||
167439 | 115530 | Planning Code 138.1 required 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 101 Polk St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/2016 12:00:00 AM | 3 | 4x4 | Permit Number 770842 | 6007332.44961 | 2111311.79762 | 37.7776740647351 | -122.418172674243 | (37.7776740647351, -122.418172674243) | 7 | 9 | 9 | 28852 | 36 | |
30958 | 104965 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3660 21ST ST | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 3x4 | Permit Number 770773 | 6003991.2 | 2103675.5 | 37.7565180033839 | -122.429186559891 | (37.7565180033839, -122.429186559891) | 2 | 4 | 5 | 28862 | 3 | ||
162628 | 25379 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1306 Geneva Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/16/2014 12:00:00 AM | 25 | 3x3 | Permit Number 770716 | 6002169.48596 | 2087962.88023 | 37.7132714689796 | -122.434363348013 | (37.7132714689796, -122.434363348013) | 9 | 7 | 6 | 28861 | 5 | |
138700 | 222084 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 300 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2016 12:00:00 AM | 2 | Width 3ft | Permit Number 770631 | 6007340.76603 | 2107872.40219 | 37.7682307704588 | -122.417900035784 | (37.7682307704588, -122.417900035784) | 8 | 4 | 7 | 28853 | 19 | |
9868 | 103994 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1084 Le Conte Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/17/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770460 | 6012711.25726 | 2089918.59543 | 37.7192342115648 | -122.398064228974 | (37.7192342115648, -122.398064228974) | 10 | 3 | 8 | 58 | 1 | |
33811 | 102328 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3201X 18th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770215 | 6008125.3 | 2105602.6 | 37.7620425418858 | -122.415025724241 | (37.7620425418858, -122.415025724241) | 2 | 4 | 7 | 28859 | 19 | |
87209 | 102349 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 401X Shotwell St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770215 | 6007842 | 2105589.3 | 37.7619900992271 | -122.416004610168 | (37.7619900992271, -122.416004610168) | 2 | 4 | 7 | 28859 | 19 | |
90268 | 102346 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 401X Shotwell St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770215 | 6007842 | 2105589.3 | 37.7619900992271 | -122.416004610168 | (37.7619900992271, -122.416004610168) | 2 | 4 | 7 | 28859 | 19 | |
114787 | 102331 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3201X 18th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770215 | 6008125.3 | 2105602.6 | 37.7620425418858 | -122.415025724241 | (37.7620425418858, -122.415025724241) | 2 | 4 | 7 | 28859 | 19 | |
145183 | 102351 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 401X Shotwell St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770215 | 6007842 | 2105589.3 | 37.7619900992271 | -122.416004610168 | (37.7619900992271, -122.416004610168) | 2 | 4 | 7 | 28859 | 19 | |
150325 | 102339 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 401X Shotwell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770215 | 6007842 | 2105589.3 | 37.7619900992271 | -122.416004610168 | (37.7619900992271, -122.416004610168) | 2 | 4 | 7 | 28859 | 19 | |
163235 | 102320 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3200X 19th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770215 | 6008156.4 | 2105059 | 37.760551689018 | -122.414879686077 | (37.760551689018, -122.414879686077) | 2 | 4 | 7 | 28859 | 19 | |
165592 | 102350 | Undocumented 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 401X Shotwell St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/2013 12:00:00 AM | 3 | 3x3 | Permit Number 770215 | 6007842 | 2105589.3 | 37.7619900992271 | -122.416004610168 | (37.7619900992271, -122.416004610168) | 2 | 4 | 7 | 28859 | 19 | |
64055 | 103896 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 17 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/2013 12:00:00 AM | 2 | 3x3 | Permit Number 770198 | 5990493.20289 | 2114947.47881 | 37.7866944227617 | -122.476690437965 | (37.7866944227617, -122.476690437965) | 11 | 6 | 1 | 55 | 33 | |
76759 | 103378 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 811 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/2013 12:00:00 AM | 4x9 | Permit Number 770000 | 5997606.4 | 2107692.1 | 37.7671830617373 | -122.451557069613 | (37.7671830617373, -122.451557069613) | 15 | 5 | 11 | 29492 | 9 | ||
25522 | 102715 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 100X 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2013 12:00:00 AM | Permit Number 769969 | 5988344 | 2115328 | 37.7876143301299 | -122.484153990404 | (37.7876143301299, -122.484153990404) | 11 | 1 | 55 | 33 | ||||
28059 | 102712 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 445 El Camino Del Mar | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2013 12:00:00 AM | Permit Number 769969 | 5987262.7 | 2115294.6 | 37.7874596082333 | -122.487892571932 | (37.7874596082333, -122.487892571932) | 11 | 6 | 1 | 55 | 33 | |||
30394 | 102711 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 445 El Camino Del Mar | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2013 12:00:00 AM | Permit Number 769969 | 5987262.7 | 2115294.6 | 37.7874596082333 | -122.487892571932 | (37.7874596082333, -122.487892571932) | 11 | 6 | 1 | 55 | 33 | |||
43262 | 102710 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 445 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2013 12:00:00 AM | Permit Number 769969 | 5987262.7 | 2115294.6 | 37.7874596082333 | -122.487892571932 | (37.7874596082333, -122.487892571932) | 11 | 6 | 1 | 55 | 33 | |||
139393 | 102714 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 100X 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2013 12:00:00 AM | Permit Number 769969 | 5988344 | 2115328 | 37.7876143301299 | -122.484153990404 | (37.7876143301299, -122.484153990404) | 11 | 1 | 55 | 33 | ||||
157682 | 102713 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 445 El Camino Del Mar | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/19/2013 12:00:00 AM | Permit Number 769969 | 5987262.7 | 2115294.6 | 37.7874596082333 | -122.487892571932 | (37.7874596082333, -122.487892571932) | 11 | 6 | 1 | 55 | 33 | |||
191916 | 102910 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1664 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2013 12:00:00 AM | 3x6 | Permit Number 769943 | 6002777.8 | 2121059.4 | 37.8041810642098 | -122.434625916396 | (37.8041810642098, -122.434625916396) | 13 | 9 | 1 | 57 | 17 | ||
9790 | 4263 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4140 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/2013 12:00:00 AM | 3 | 3X3 | Permit Number 769862 | 6002917.9994804 | 2100386.7174123 | 37.7474269722522 | -122.432663148332 | (37.7474269722522, -122.432663148332) | 2 | 4 | 5 | 63 | 22 | |
57583 | 102176 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 488 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769768 | 5999452.4 | 2104200.8 | 37.7577023616885 | -122.444921049841 | (37.7577023616885, -122.444921049841) | 2 | 5 | 5 | 28862 | 3 |
44732 | 84666 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4040 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6002909.03785492 | 2101853.22745181 | 37.75145315539 | -122.432798884354 | (37.75145315539, -122.432798884354) | 2 | 4 | 5 | 28862 | 22 |
57496 | 102119 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4040 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6002911 | 2101847 | 37.7514361675639 | -122.4327916542 | (37.7514361675639, -122.4327916542) | 2 | 4 | 5 | 28862 | 22 |
91523 | 84581 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 741 Douglass St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | Permit Number 769743 | 6001278.96097325 | 2101957.17252492 | 37.7516459775241 | -122.438443320582 | (37.7516459775241, -122.438443320582) | 2 | 4 | 5 | 28862 | 22 | ||
95834 | 84662 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4010 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003093.38123031 | 2101863.40239846 | 37.7514915468728 | -122.432162129841 | (37.7514915468728, -122.432162129841) | 2 | 4 | 5 | 28862 | 22 |
142814 | 84580 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 741 Douglass St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | Permit Number 769743 | 6001278.96097325 | 2101957.17252492 | 37.7516459775241 | -122.438443320582 | (37.7516459775241, -122.438443320582) | 2 | 4 | 5 | 28862 | 22 | ||
161731 | 102118 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 4010 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 4x4 | Permit Number 769743 | 6003103.5 | 2101879.6 | 37.7515365953655 | -122.432128294524 | (37.7515365953655, -122.432128294524) | 2 | 4 | 5 | 28862 | 22 |
165569 | 59582 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3911 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003738.17259187 | 2101846.91300121 | 37.7514828076554 | -122.429931187142 | (37.7514828076554, -122.429931187142) | 2 | 4 | 5 | 28862 | 22 |
174795 | 84567 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 3961 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003430.22054121 | 2101829.9153452 | 37.751418691406 | -122.430994909235 | (37.751418691406, -122.430994909235) | 2 | 4 | 5 | 28862 | 22 |
158151 | 102086 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 43 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/19/2012 12:00:00 AM | 3x3 | Permit Number 769732 | 6007144.2 | 2099182.9 | 37.744360330521 | -122.417963871752 | (37.744360330521, -122.417963871752) | 2 | 7 | 7 | 28859 | 2 |
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) );