trees
56 rows where qSpecies_id = 154
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 936 | 215389 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 83 Melrose Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5999561.07911 | 2095471.21433 | 37.7337392221924 | -122.443917999028 | (37.7337392221924, -122.443917999028) | 9 | 7 | 4 | 63 | 40 | ||||
| 3846 | 78221 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 1181 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6009695.80374 | 2090736.07669 | 37.721310432317 | -122.408545191616 | (37.721310432317, -122.408545191616) | 10 | 3 | 7 | 309 | 28 | |||
| 6057 | 73458 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 1111 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 6008560.29322 | 2116488.33177 | 37.7919566136559 | -122.414291480873 | (37.7919566136559, -122.414291480873) | 5 | 1 | 10 | 28858 | 21 | |||
| 10634 | 215385 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 522 Bright St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 3ft | 5993803.26709 | 2090640.69025 | 37.7201456609819 | -122.463473869337 | (37.7201456609819, -122.463473869337) | 9 | 8 | 6 | 64 | 24 | |||
| 13839 | 78773 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 820 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5997287.64063 | 2087195.26407 | 37.7108854587791 | -122.451181278193 | (37.7108854587791, -122.451181278193) | 9 | 7 | 6 | 28861 | 25 | |||
| 18791 | 261936 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 1 Verna St | 1 | Unaccepted Street : Yard | Tree | Private 2 | Width 3ft | 5998303 | 2096292 | 37.7359210601709 | -122.448326617787 | (37.7359210601709, -122.448326617787) | 9 | 7 | 4 | 59 | 40 | ||||
| 25079 | 179941 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 200 Concord St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 5999888.95629 | 2087101.17339 | 37.7107757037144 | -122.442183801236 | (37.7107757037144, -122.442183801236) | 9 | 7 | 6 | 28861 | 5 | |||
| 32032 | 96652 | Permitted Site 7 | Tibochina urvilleana :: Princess Flower 154 | 731 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2012 12:00:00 AM | 3x3 | Permit Number 769486 | 5993295 | 2113455 | 37.7827585989517 | -122.466888432189 | (37.7827585989517, -122.466888432189) | 11 | 6 | 2 | 54 | 11 | ||
| 46361 | 241148 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 766 27th St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6001560.46361 | 2100021.36204 | 37.7463467109483 | -122.437331250153 | (37.7463467109483, -122.437331250153) | 2 | 7 | 5 | 63 | 22 | |||
| 47255 | 215386 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 425 Ulloa St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995486.64342 | 2098345.49842 | 37.7413980438947 | -122.458212397395 | (37.7413980438947, -122.458212397395) | 1 | 8 | 4 | 59 | 40 | |||
| 47757 | 215378 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 100 Vista Verde Ct | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 10ft | 5999253.01585 | 2096016.04831 | 37.7352176302864 | -122.445022215402 | (37.7352176302864, -122.445022215402) | 9 | 7 | 4 | 63 | 40 | |||
| 49148 | 215390 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 833 Teresita Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5999141.71949 | 2095614.88342 | 37.7341097734514 | -122.445378170666 | (37.7341097734514, -122.445378170666) | 9 | 7 | 4 | 59 | 40 | |||
| 49945 | 215391 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 906 Teresita Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5998840.72166 | 2095590.64849 | 37.7340260429642 | -122.446417067495 | (37.7340260429642, -122.446417067495) | 9 | 7 | 4 | 59 | 40 | |||
| 52502 | 94556 | Permitted Site 7 | Tibochina urvilleana :: Princess Flower 154 | 370X Mississippi St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53731 | 6014056 | 2105274 | 37.761471765277 | -122.394490563972 | (37.761471765277, -122.394490563972) | 10 | 3 | 8 | 28856 | 29 | |
| 55161 | 179940 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 200 Concord St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5999884.04631 | 2087117.21058 | 37.7108194584206 | -122.442201921678 | (37.7108194584206, -122.442201921678) | 9 | 7 | 6 | 28861 | 5 | |||
| 57199 | 29571 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 195 Virginia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6006671.74062 | 2098479.46548 | 37.7424022556491 | -122.419547643218 | (37.7424022556491, -122.419547643218) | 2 | 7 | 7 | 28859 | 2 | |||
| 58612 | 241149 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 786 27th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6001406.64604 | 2100012.02434 | 37.7463123262701 | -122.437862463483 | (37.7463123262701, -122.437862463483) | 2 | 7 | 5 | 63 | 22 | |||
| 62983 | 101381 | Permitted Site 7 | Tibochina urvilleana :: Princess Flower 154 | 875 43rd Ave | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10/18/2012 12:00:00 AM | Permit Number 769418 | 5982591.7 | 2109836.4 | 37.7721994183493 | -122.503648645129 | (37.7721994183493, -122.503648645129) | 11 | 6 | 2 | 55 | 26 | |||
| 63330 | 53949 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 110 Gaven St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2012 12:00:00 AM | 3 | Permit Number 769120 | 6009957.91529 | 2095221.76807 | 37.7336418732748 | -122.407955309198 | (37.7336418732748, -122.407955309198) | 10 | 3 | 7 | 309 | 28 | ||
| 64514 | 215381 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 750 Lakeview Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 5994524.37821 | 2089948.25925 | 37.718285932216 | -122.460931089315 | (37.718285932216, -122.460931089315) | 9 | 8 | 6 | 28861 | 24 | |||
| 68822 | 215395 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 582 Mangels Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5997512.21245 | 2095297.31547 | 37.7331446524868 | -122.45098896718 | (37.7331446524868, -122.45098896718) | 9 | 7 | 4 | 59 | 40 | |||
| 75699 | 215387 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 139 Mangels Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6000497.24486 | 2095192.00099 | 37.7330259239913 | -122.440661384821 | (37.7330259239913, -122.440661384821) | 9 | 7 | 5 | 63 | 40 | |||
| 87368 | 179952 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 607 Brussels St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6010912.05171 | 2091894.61022 | 37.7245595668681 | -122.404422449363 | (37.7245595668681, -122.404422449363) | 10 | 3 | 7 | 309 | 28 | |||
| 87600 | 94557 | Permitted Site 7 | Tibochina urvilleana :: Princess Flower 154 | 370X Mississippi St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53731 | 6014056 | 2105274 | 37.761471765277 | -122.394490563972 | (37.761471765277, -122.394490563972) | 10 | 3 | 8 | 28856 | 29 | |
| 103173 | 241152 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 3 Ohlone Way | 1 | Back Yard : Yard | Tree | Private 2 | 4 | Width 3ft | 6002150.14382 | 2096511.40008 | 37.736742679035 | -122.435041217385 | (37.736742679035, -122.435041217385) | 2 | 7 | 5 | 63 | 7 | |||
| 106903 | 94554 | Permitted Site 7 | Tibochina urvilleana :: Princess Flower 154 | 1200 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53731 | 6014056 | 2105274 | 37.761471765277 | -122.394490563972 | (37.761471765277, -122.394490563972) | 10 | 3 | 8 | 28856 | 29 | |
| 108952 | 179945 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 229 Delano Ave | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6000116.24367 | 2092335.56134 | 37.7251610981841 | -122.44177366992 | (37.7251610981841, -122.44177366992) | 9 | 7 | 6 | 28861 | 25 | |||
| 112462 | 179949 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 669 University St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6008688.54071 | 2090962.7431 | 37.7218763478091 | -122.412043039082 | (37.7218763478091, -122.412043039082) | 9 | 3 | 7 | 309 | 28 | |||
| 112475 | 179950 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 100 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6010078.69858 | 2095042.71983 | 37.733157006493 | -122.407525105013 | (37.733157006493, -122.407525105013) | 10 | 3 | 7 | 309 | 28 | |||
| 121244 | 179951 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 607 Brussels St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 2ft | 6010914.44854 | 2091887.55595 | 37.7245403312462 | -122.404413667483 | (37.7245403312462, -122.404413667483) | 10 | 3 | 7 | 309 | 28 | |||
| 121794 | 179942 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 200 Concord St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 5999892.98718 | 2087090.82168 | 37.7107475099609 | -122.442169127 | (37.7107475099609, -122.442169127) | 9 | 7 | 6 | 28861 | 5 | |||
| 130937 | 179948 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 437 Peru Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 6004719.22426 | 2092865.50598 | 37.7268774102596 | -122.425899335399 | (37.7268774102596, -122.425899335399) | 9 | 7 | 6 | 28861 | 5 | |||
| 131063 | 241150 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 1320 Diamond St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6001948.39861 | 2100174.85862 | 37.7467902223906 | -122.436000800312 | (37.7467902223906, -122.436000800312) | 2 | 7 | 5 | 63 | 22 | |||
| 135335 | 179943 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 200 Concord St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 5999899.21161 | 2087069.25046 | 37.710688634952 | -122.442146066583 | (37.710688634952, -122.442146066583) | 9 | 7 | 6 | 28861 | 5 | |||
| 138135 | 136722 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 420 Vallejo St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 10ft | 6011459.3679 | 2119062.99337 | 37.7991884363485 | -122.404441920581 | (37.7991884363485, -122.404441920581) | 3 | 1 | 10 | 308 | 23 | |||
| 141579 | 215393 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 442 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 5999150.62225 | 2095003.22641 | 37.7324308156273 | -122.445303428036 | (37.7324308156273, -122.445303428036) | 9 | 7 | 4 | 59 | 40 | |||
| 146217 | 179939 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 102 France Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 1ft | 6001352.27901 | 2090234.00625 | 37.7194610538624 | -122.437350416488 | (37.7194610538624, -122.437350416488) | 9 | 7 | 6 | 28861 | 5 | |||
| 147275 | 94555 | Permitted Site 7 | Tibochina urvilleana :: Princess Flower 154 | 370X Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53731 | 6014056 | 2105274 | 37.761471765277 | -122.394490563972 | (37.761471765277, -122.394490563972) | 10 | 3 | 8 | 28856 | 29 | |
| 151923 | 179938 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 1 Moneta Ct | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 5997974.23427 | 2088065.64877 | 37.7133146238397 | -122.448870915378 | (37.7133146238397, -122.448870915378) | 9 | 7 | 6 | 28861 | 25 | |||
| 155920 | 215392 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 371 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 2ft | 5999641.26044 | 2094937.86119 | 37.7322793329212 | -122.443602488063 | (37.7322793329212, -122.443602488063) | 9 | 7 | 4 | 63 | 40 | |||
| 157967 | 241151 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 75 Whitney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004313.08095 | 2097743.41481 | 37.7402480897892 | -122.427650750683 | (37.7402480897892, -122.427650750683) | 2 | 7 | 5 | 63 | 7 | |||
| 163871 | 215388 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 723 Detroit St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 5999419.30978 | 2095287.76027 | 37.7332274126104 | -122.444394956256 | (37.7332274126104, -122.444394956256) | 9 | 7 | 4 | 59 | 40 | |||
| 164397 | 94558 | Permitted Site 7 | Tibochina urvilleana :: Princess Flower 154 | 370X Mississippi St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/15/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53731 | 6014056 | 2105274 | 37.761471765277 | -122.394490563972 | (37.761471765277, -122.394490563972) | 10 | 3 | 8 | 28856 | 29 | |
| 164539 | 215380 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 1209 Capitol Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 3ft | 5995031.01707 | 2091921.98911 | 37.7237344631626 | -122.459322719284 | (37.7237344631626, -122.459322719284) | 9 | 8 | 4 | 28861 | 24 | |||
| 165945 | 215383 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 270 Arch St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 5992739.05978 | 2088994.50565 | 37.7155642635536 | -122.467032825702 | (37.7155642635536, -122.467032825702) | 9 | 8 | 6 | 64 | 24 | |||
| 167144 | 215384 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 724 Head St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5993537.5589 | 2090646.74234 | 37.72014696588 | -122.46439276513 | (37.72014696588, -122.46439276513) | 9 | 8 | 6 | 64 | 24 | |||
| 167336 | 179947 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 371 Mount Vernon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5998328.35697 | 2089789.74311 | 37.7180688367937 | -122.447770992363 | (37.7180688367937, -122.447770992363) | 9 | 7 | 6 | 28861 | 25 | ||||
| 168275 | 215396 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 338 Judson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 5997834.21693 | 2093590.20837 | 37.7284757708279 | -122.449752738393 | (37.7284757708279, -122.449752738393) | 9 | 7 | 4 | 28861 | 40 | |||
| 170582 | 179944 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 386 Teddy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009114.43117 | 2088706.36258 | 37.7157046827904 | -122.410411595123 | (37.7157046827904, -122.410411595123) | 9 | 7 | 8 | 309 | 39 | |||
| 173472 | 215382 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 272 Sadowa St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 5994227.37153 | 2087794.20543 | 37.7123543178716 | -122.461801605154 | (37.7123543178716, -122.461801605154) | 9 | 8 | 6 | 28861 | 24 | |||
| 177186 | 179946 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 243 Ottawa Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 5998318.77069 | 2089304.69123 | 37.7167364480014 | -122.447769227879 | (37.7167364480014, -122.447769227879) | 9 | 7 | 6 | 28861 | 25 | |||
| 183028 | 4273 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 4203 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002547.21339 | 2100318.00727 | 37.74721727537 | -122.433940389656 | (37.74721727537, -122.433940389656) | 2 | 4 | 5 | 63 | 22 | |||
| 183449 | 215394 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 470 Joost Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5998974.60602 | 2094996.65879 | 37.7324027333872 | -122.445911483039 | (37.7324027333872, -122.445911483039) | 9 | 7 | 4 | 59 | 40 | ||||
| 185487 | 115766 | Permitted Site 7 | Tibochina urvilleana :: Princess Flower 154 | 161 De Soto St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/24/2016 12:00:00 AM | 3 | Permit Number 768395 | 5993291.8 | 2092241 | 37.7245102406902 | -122.465358011485 | (37.7245102406902, -122.465358011485) | 9 | 8 | 4 | 59 | 40 | ||
| 188169 | 173629 | Significant Tree 6 | Tibochina urvilleana :: Princess Flower 154 | 10X Junipero Serra Blvd Off Ramp | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 01/20/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779383 | 5991168 | 2088425 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | 1 | 8 | 4 | 64 | 14 | |
| 191526 | 215379 | DPW Maintained 1 | Tibochina urvilleana :: Princess Flower 154 | 414 Detroit St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5999451.28248 | 2094469.70482 | 37.7309830483172 | -122.444225653487 | (37.7309830483172, -122.444225653487) | 9 | 7 | 4 | 63 | 40 |
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) );