trees
5,599 rows where qSpecies_id = 38 sorted by Supervisor Districts
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10998 | 100001 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 501X 01st St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | Address is 100 1st Street | ||||||||||||||
| 73 | 127010 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1931 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003752.87677 | 2118634.51429 | 37.7975782631807 | -122.431078412364 | (37.7975782631807, -122.431078412364) | 13 | 9 | 1 | 57 | 17 | |||
| 802 | 126843 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 400 Avila St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001073.31574 | 2121444.93358 | 37.8051427271077 | -122.440552066845 | (37.8051427271077, -122.440552066845) | 13 | 9 | 1 | 57 | 17 | |||
| 878 | 126969 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2701 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | Width 3ft | 5999145.58694 | 2118075.75757 | 37.795781916869 | -122.44698057642 | (37.795781916869, -122.44698057642) | 11 | 1 | 57 | 30 | ||||
| 1426 | 84231 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 178 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 5988065.20329 | 2114809.31405 | 37.7861739305031 | -122.48508048983 | (37.7861739305031, -122.48508048983) | 11 | 6 | 1 | 55 | 33 | |||
| 1771 | 126877 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 431 Walnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5998608.56646 | 2115039.1362 | 37.7874134653004 | -122.448619946057 | (37.7874134653004, -122.448619946057) | 13 | 6 | 1 | 54 | 31 | |||
| 1979 | 92945 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3516 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 5998014.58163 | 2115182.9594 | 37.7877743839331 | -122.450685374939 | (37.7877743839331, -122.450685374939) | 11 | 6 | 1 | 54 | 31 | ||||
| 2176 | 59307 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3180 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/04/1980 12:00:00 AM | 18 | Permit Number 18647 | 5999500.07139 | 2116046.04634 | 37.7902291122342 | -122.445607969042 | (37.7902291122342, -122.445607969042) | 13 | 6 | 1 | 29490 | 27 | |
| 2197 | 126966 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 32 Parker Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 5996866.78793 | 2114389.9756 | 37.7855312948716 | -122.454599192111 | (37.7855312948716, -122.454599192111) | 11 | 6 | 1 | 54 | 31 | |||
| 2345 | 59877 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2125 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/20/1981 12:00:00 AM | 11 | Permit Number 19342 | 6002756.67005 | 2118848.34018 | 37.7981088730742 | -122.434540847196 | (37.7981088730742, -122.434540847196) | 13 | 9 | 1 | 57 | 17 | |
| 2527 | 127017 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2859 Filbert St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999232.73482 | 2118356.53874 | 37.7965578456306 | -122.446699242399 | (37.7965578456306, -122.446699242399) | 13 | 9 | 1 | 57 | 17 | |||
| 2560 | 126872 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 346 Walnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5998571.39948 | 2115304.13388 | 37.7881389538087 | -122.448767630033 | (37.7881389538087, -122.448767630033) | 13 | 6 | 1 | 54 | 31 | |||
| 2595 | 71280 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2046 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6x7 | 6003095.65483 | 2119286.01418 | 37.7993298493627 | -122.433399154261 | (37.7993298493627, -122.433399154261) | 13 | 9 | 1 | 57 | 17 | ||
| 2755 | 127908 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 894 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 5ft | 6007564.93188 | 2120607.69354 | 37.8032113898512 | -122.41802760281 | (37.8032113898512, -122.41802760281) | 5 | 1 | 1 | 308 | 32 | |||
| 3389 | 126982 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2701 Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004396.01598 | 2118466.17604 | 37.7971524719675 | -122.428840971039 | (37.7971524719675, -122.428840971039) | 13 | 9 | 1 | 57 | 17 | |||
| 3503 | 127267 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2429 Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001933.00752 | 2117690.75949 | 37.7948836677101 | -122.437308024273 | (37.7948836677101, -122.437308024273) | 13 | 9 | 1 | 57 | 27 | |||
| 4062 | 127062 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3252 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6001378.86232 | 2119524.81659 | 37.7998879892946 | -122.439356969471 | (37.7998879892946, -122.439356969471) | 13 | 9 | 1 | 57 | 17 | |||
| 4145 | 86824 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 290 Alhambra St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6000862.93753 | 2120018.08903 | 37.801213010829 | -122.441177668529 | (37.801213010829, -122.441177668529) | 13 | 9 | 1 | 57 | 17 | |||
| 4765 | 110239 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2655 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6000951.09283 | 2117196.46677 | 37.793470600727 | -122.440670108247 | (37.793470600727, -122.440670108247) | 13 | 9 | 1 | 29490 | 27 | |||
| 5834 | 126875 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 401 Walnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998625 | 2115075 | 37.7875128775034 | -122.448565673536 | (37.7875128775034, -122.448565673536) | 13 | 6 | 1 | 54 | 31 | |||
| 6210 | 92707 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2600 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/2009 12:00:00 AM | 13 | 3x3 | Permit Number 52950 | 6000514.42126 | 2118236.58998 | 37.7963016287713 | -122.442255722737 | (37.7963016287713, -122.442255722737) | 13 | 9 | 1 | 57 | 17 | |
| 6941 | 7350 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2239 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002792.88059 | 2116041.24067 | 37.7904033576739 | -122.434214763813 | (37.7904033576739, -122.434214763813) | 13 | 9 | 1 | 29490 | 27 | |||
| 7161 | 127048 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3701 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6002027.78119 | 2121185.63165 | 37.8044850565104 | -122.437230452331 | (37.8044850565104, -122.437230452331) | 13 | 9 | 1 | 57 | 17 | |||
| 7640 | 127293 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2753 Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6002583.07588 | 2117538.07089 | 37.7945013578125 | -122.435047772547 | (37.7945013578125, -122.435047772547) | 13 | 9 | 1 | 29490 | 27 | |||
| 7735 | 72939 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1941 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5999440.2574 | 2115574.76841 | 37.7889316917948 | -122.445781013002 | (37.7889316917948, -122.445781013002) | 13 | 6 | 1 | 29490 | 31 | |||
| 7751 | 127203 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 46 Presidio Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5998966.77804 | 2116409.36285 | 37.7911962224881 | -122.447479279259 | (37.7911962224881, -122.447479279259) | 13 | 6 | 1 | 29490 | 31 | |||
| 7839 | 126779 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2055 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003068.79068 | 2119239.76733 | 37.7992013434186 | -122.43348880679 | (37.7992013434186, -122.43348880679) | 13 | 9 | 1 | 57 | 17 | |||
| 7954 | 127208 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2332 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999786.9812 | 2116918.58029 | 37.7926412369447 | -122.444678026877 | (37.7926412369447, -122.444678026877) | 13 | 6 | 1 | 29490 | 27 | |||
| 7963 | 56974 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 143 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/27/1974 12:00:00 AM | 6 | 3x3 | Permit Number 14227 | 5995185.81125 | 2114601.91547 | 37.7860166684359 | -122.46043020011 | (37.7860166684359, -122.46043020011) | 11 | 6 | 1 | 54 | 11 | |
| 8284 | 115669 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2600X Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777079 | 6001202.18162 | 2117312.37284 | 37.7938031439473 | -122.439809637804 | (37.7938031439473, -122.439809637804) | 13 | 9 | 1 | 57 | 27 | |
| 8337 | 126910 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 75 Spruce St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5997010.72159 | 2116048.10236 | 37.7900923226531 | -122.454221034373 | (37.7900923226531, -122.454221034373) | 11 | 6 | 1 | 54 | 31 | |||
| 8393 | 127867 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2044 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6007226.91182 | 2119423.24121 | 37.7999401526838 | -122.419113268885 | (37.7999401526838, -122.419113268885) | 5 | 1 | 1 | 28858 | 32 | |||
| 8460 | 12704 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1424 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 5991031.65731 | 2114791.36704 | 37.7862970008275 | -122.47481613459 | (37.7862970008275, -122.47481613459) | 11 | 6 | 1 | 54 | 33 | |||
| 8519 | 126819 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1861 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000341.48277 | 2121286.03183 | 37.8046647257642 | -122.443073236154 | (37.8046647257642, -122.443073236154) | 13 | 9 | 1 | 57 | 17 | |||
| 8779 | 75939 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2100 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6004008.54398 | 2117326.08278 | 37.7940001296632 | -122.430100346576 | (37.7940001296632, -122.430100346576) | 13 | 9 | 1 | 29490 | 27 | |||
| 9090 | 127065 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3252 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6001375.07484 | 2119548.95116 | 37.7999540409146 | -122.43937180647 | (37.7999540409146, -122.43937180647) | 13 | 9 | 1 | 57 | 17 | |||
| 9932 | 59703 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3151 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/24/2020 12:00:00 AM | 3 | Permit Number 19133 | 5999623.74954 | 2116015.3785 | 37.7901519665752 | -122.445177847597 | (37.7901519665752, -122.445177847597) | 13 | 6 | 1 | 29490 | 27 | |
| 10035 | 55896 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3305 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/1973 12:00:00 AM | 22 | Permit Number 11953 | 5999805.23357 | 2119943.78324 | 37.8009486821054 | -122.444832429667 | (37.8009486821054, -122.444832429667) | 13 | 9 | 1 | 57 | 17 | ||
| 10063 | 25510 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1845 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6005220.00534 | 2116049.4982 | 37.7905634882709 | -122.425817655354 | (37.7905634882709, -122.425817655354) | 13 | 9 | 1 | 28858 | 27 | |||
| 10515 | 7366 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2360 Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002774.54957 | 2116438.38146 | 37.7914927640347 | -122.434306592692 | (37.7914927640347, -122.434306592692) | 13 | 9 | 1 | 29490 | 27 | |||
| 10541 | 127381 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2199x Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005034 | 2117073 | 37.7933632530766 | -122.42653413355 | (37.7933632530766, -122.42653413355) | 13 | 9 | 1 | 28858 | 27 | |||
| 11125 | 127105 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1601 Beach St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002505.01994 | 2121244.09156 | 37.8046726892538 | -122.435583111981 | (37.8046726892538, -122.435583111981) | 13 | 9 | 1 | 57 | 17 | |||
| 11215 | 127251 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2655 Pierce St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6001594.68789 | 2117605.84286 | 37.7946312702617 | -122.438472568947 | (37.7946312702617, -122.438472568947) | 13 | 9 | 1 | 57 | 27 | |||
| 11275 | 75984 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2100 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6004038.06226 | 2117331.41602 | 37.7940164451412 | -122.429998590982 | (37.7940164451412, -122.429998590982) | 13 | 9 | 1 | 29490 | 27 | |||
| 11298 | 127916 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1175 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/31/1990 12:00:00 AM | 13 | Width 4ft | 6007863.00532 | 2121226.60678 | 37.8049275409425 | -122.417039987112 | (37.8049275409425, -122.417039987112) | 5 | 1 | 1 | 308 | 32 | ||
| 11377 | 66090 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1024 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/08/1990 12:00:00 AM | 16 | Permit Number 29134 | 6007982.68967 | 2119627.22736 | 37.8005427793916 | -122.416512442105 | (37.8005427793916, -122.416512442105) | 5 | 1 | 1 | 308 | 32 | |
| 11506 | 65817 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3117 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/03/1990 12:00:00 AM | 12 | Permit Number 28806 | 5999897.13421 | 2119287.78113 | 37.7991527197746 | -122.444467242891 | (37.7991527197746, -122.444467242891) | 13 | 9 | 1 | 57 | 17 | |
| 11784 | 127030 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3851 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6000069.69361 | 2121560.37704 | 37.8054025034915 | -122.444033510631 | (37.8054025034915, -122.444033510631) | 13 | 9 | 1 | 57 | 17 | |||
| 11793 | 126809 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2460 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5999542.14007 | 2119832.86925 | 37.800629124187 | -122.445734860683 | (37.800629124187, -122.445734860683) | 13 | 9 | 1 | 57 | 17 | |||
| 12022 | 251011 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3832 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/2015 12:00:00 AM | 12 | Width 3ft | Permit Number 32266 | 5995890.12624 | 2115872.70718 | 37.7895464116889 | -122.458085479669 | (37.7895464116889, -122.458085479669) | 11 | 6 | 1 | 54 | 31 | |
| 12434 | 64629 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1824 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1988 12:00:00 AM | 12 | 3x3 | Permit Number 25539 | 6004249.16577 | 2118756.87495 | 37.7979423438312 | -122.429369849745 | (37.7979423438312, -122.429369849745) | 13 | 9 | 1 | 57 | 17 | |
| 12443 | 126758 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2252 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6002155.35779 | 2118810.64175 | 37.7979712102548 | -122.436618860277 | (37.7979712102548, -122.436618860277) | 13 | 9 | 1 | 57 | 17 | |||
| 12501 | 126681 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2961 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5999971.48713 | 2118755.27158 | 37.7976948324145 | -122.44417167168 | (37.7976948324145, -122.44417167168) | 13 | 9 | 1 | 57 | 17 | |||
| 12718 | 127207 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2332 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999792.21615 | 2116884.67261 | 37.7925484341161 | -122.444657475575 | (37.7925484341161, -122.444657475575) | 13 | 6 | 1 | 29490 | 27 | |||
| 14519 | 126987 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3100 Baker St | 1 | Median : Cutout | Tree | Private 2 | 20 | Width 2ft | 5999366.53139 | 2119613.96333 | 37.8000180393548 | -122.446326780069 | (37.8000180393548, -122.446326780069) | 13 | 9 | 1 | 57 | 17 | |||
| 14778 | 18836 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2055 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004953.14987 | 2116100.26294 | 37.7906877916676 | -122.426744576702 | (37.7906877916676, -122.426744576702) | 13 | 9 | 1 | 28858 | 27 | |||
| 15009 | 12639 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 916 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 6x7 | 5992597.52584 | 2114847.07961 | 37.7865405872228 | -122.469402738454 | (37.7865405872228, -122.469402738454) | 11 | 6 | 1 | 54 | 11 | |||
| 15450 | 127420 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1890 Clay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6005703.51164 | 2116578.93116 | 37.7920444900078 | -122.424182418992 | (37.7920444900078, -122.424182418992) | 13 | 9 | 1 | 28858 | 27 | |||
| 15500 | 75967 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2100 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6004022.22932 | 2117328.34706 | 37.7940071218757 | -122.430053155526 | (37.7940071218757, -122.430053155526) | 13 | 9 | 1 | 29490 | 27 | |||
| 15710 | 41275 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2401X Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/2000 12:00:00 AM | 8 | 5x6 | Permit Number 41958 | 6001411.89604 | 2118660.00924 | 37.7975153358094 | -122.439180642975 | (37.7975153358094, -122.439180642975) | 13 | 9 | 1 | 57 | 17 |
| 15801 | 127380 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2199x Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005034 | 2117073 | 37.7933632530766 | -122.42653413355 | (37.7933632530766, -122.42653413355) | 13 | 9 | 1 | 28858 | 27 | |||
| 15863 | 106734 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2652 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2014 12:00:00 AM | 3 | Permit Number 770178 | 5999150.64318 | 2119434.00692 | 37.7995115951419 | -122.447060875059 | (37.7995115951419, -122.447060875059) | 13 | 9 | 1 | 57 | 17 | ||
| 16141 | 7373 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2440 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6002748.17801 | 2116678.12412 | 37.7921495389154 | -122.434414986179 | (37.7921495389154, -122.434414986179) | 13 | 9 | 1 | 29490 | 27 | |||
| 16523 | 49710 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2841GREENWICH Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/03/2003 12:00:00 AM | 10 | Permit Number 46523 | 5999496.96891 | 2118665.02672 | 37.7974199618166 | -122.445807134711 | (37.7974199618166, -122.445807134711) | 13 | 9 | 1 | 57 | 17 | ||
| 16562 | 126915 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 400 Maple St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 5996741.93757 | 2114831.31845 | 37.786735943056 | -122.455063038144 | (37.786735943056, -122.455063038144) | 11 | 6 | 1 | 54 | 31 | |||
| 16786 | 126674 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2759 Broderick St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 6ft | 6000067.13426 | 2118059.9483 | 37.7957911151245 | -122.443790726982 | (37.7957911151245, -122.443790726982) | 13 | 9 | 1 | 57 | 17 | |||
| 17180 | 127399 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3836 Buchanan St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6003521.77735 | 2118150.49447 | 37.7962361716258 | -122.431843499793 | (37.7962361716258, -122.431843499793) | 13 | 9 | 1 | 57 | 17 | |||
| 17889 | 58681 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2339 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/1979 12:00:00 AM | 13 | Permit Number 17909 | 6001837.83245 | 2118026.07393 | 37.7957989428223 | -122.437661368787 | (37.7957989428223, -122.437661368787) | 13 | 9 | 1 | 57 | 27 | ||
| 17935 | 9914 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1900 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 126 | 3X3 | 6005235.69262 | 2116267.9294 | 37.7911641319684 | -122.425778932349 | (37.7911641319684, -122.425778932349) | 13 | 9 | 1 | 28858 | 27 | |||
| 18520 | 127917 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2357 Jones St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 6007984.65596 | 2120608.29341 | 37.8032366509171 | -122.416575173411 | (37.8032366509171, -122.416575173411) | 5 | 1 | 1 | 308 | 32 | |||
| 18683 | 64976 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3024 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/03/1989 12:00:00 AM | 11 | Permit Number 26011 | 6004714.90539 | 2119991.34549 | 37.8013582396417 | -122.427846265115 | (37.8013582396417, -122.427846265115) | 13 | 9 | 1 | 57 | 17 | |
| 18713 | 127382 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2199x Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005034 | 2117073 | 37.7933632530766 | -122.42653413355 | (37.7933632530766, -122.42653413355) | 13 | 9 | 1 | 28858 | 27 | |||
| 18743 | 23497 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2525 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6005737.90239 | 2119081.40662 | 37.7989175974325 | -122.424241484673 | (37.7989175974325, -122.424241484673) | 13 | 9 | 1 | 57 | 17 | |||
| 18751 | 126825 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 238 Mallorca Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6001585 | 2120665 | 37.8030303602242 | -122.438725403657 | (37.8030303602242, -122.438725403657) | 13 | 9 | 1 | 57 | 17 | |||
| 19234 | 127064 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3252 Pierce St | 4 | : | Tree | Private 2 | 8 | Width 3ft | 6001385.25853 | 2119550.33485 | 37.7999584196931 | -122.439336666363 | (37.7999584196931, -122.439336666363) | 13 | 9 | 1 | 57 | 17 | |||
| 19775 | 126764 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 200 Moulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002290.84386 | 2119337.45482 | 37.7994253996333 | -122.436187760354 | (37.7994253996333, -122.436187760354) | 13 | 9 | 1 | 57 | 17 | |||
| 20334 | 126856 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2120 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6001679.64241 | 2119787.1835 | 37.8006254918441 | -122.43833496638 | (37.8006254918441, -122.43833496638) | 13 | 9 | 1 | 57 | 17 | |||
| 20398 | 106085 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2710 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 6003043.75991 | 2118055.45149 | 37.795948098984 | -122.433490741223 | (37.795948098984, -122.433490741223) | 13 | 9 | 1 | 57 | 17 | ||||
| 20399 | 127351 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2445 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6003653.07733 | 2116820.72881 | 37.7925924181638 | -122.431294206467 | (37.7925924181638, -122.431294206467) | 13 | 9 | 1 | 29490 | 27 | |||
| 20404 | 127052 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 627 Marina Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999904.12445 | 2121564.04699 | 37.8054031339002 | -122.444606746617 | (37.8054031339002, -122.444606746617) | 13 | 9 | 1 | 57 | 17 | |||
| 20686 | 126815 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2100 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6000624.03287 | 2120677.08197 | 37.803008818477 | -122.442051709713 | (37.803008818477, -122.442051709713) | 13 | 9 | 1 | 57 | 17 | |||
| 20745 | 126881 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 405 Locust St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5997631.97231 | 2115058.83857 | 37.7874116729687 | -122.452000165778 | (37.7874116729687, -122.452000165778) | 11 | 6 | 1 | 54 | 31 | |||
| 20926 | 40346 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3625 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Permit Number 41477 | 5996889.13616 | 2115964.594 | 37.7898560581496 | -122.454635672204 | (37.7898560581496, -122.454635672204) | 11 | 6 | 1 | 54 | 31 | |||
| 21020 | 127285 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2281 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6002179.60988 | 2118069.35136 | 37.7959371982844 | -122.436481856646 | (37.7959371982844, -122.436481856646) | 13 | 9 | 1 | 57 | 17 | |||
| 21060 | 127406 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2060 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6004304.72833 | 2117043.3227 | 37.7932405127998 | -122.42905534873 | (37.7932405127998, -122.42905534873) | 13 | 9 | 1 | 28858 | 27 | |||
| 21103 | 127308 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2626 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6002184.80376 | 2117253.87502 | 37.7936984070995 | -122.436405491626 | (37.7936984070995, -122.436405491626) | 13 | 9 | 1 | 29490 | 27 | |||
| 21184 | 127331 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2519 Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6003626.12696 | 2117027.40326 | 37.7931583660299 | -122.43140221595 | (37.7931583660299, -122.43140221595) | 13 | 9 | 1 | 29490 | 27 | |||
| 21429 | 126668 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2962 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004748.51273 | 2119738.62444 | 37.8006662338212 | -122.427711952264 | (37.8006662338212, -122.427711952264) | 13 | 9 | 1 | 57 | 17 | |||
| 21436 | 114633 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2253 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6000298.51737 | 2116393.24113 | 37.7912279703404 | -122.442870356286 | (37.7912279703404, -122.442870356286) | 13 | 6 | 1 | 29490 | 27 | |||
| 21441 | 127239 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 25 Normandie Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6000903.5108 | 2117368.04112 | 37.7939389892431 | -122.440847058851 | (37.7939389892431, -122.440847058851) | 13 | 9 | 1 | 57 | 27 | |||
| 21694 | 126645 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3001 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001436.68729 | 2118800.88237 | 37.7979035470752 | -122.439104960548 | (37.7979035470752, -122.439104960548) | 13 | 9 | 1 | 57 | 17 | |||
| 21742 | 55626 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2150 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/1973 12:00:00 AM | 17 | Permit Number 11605 | 6003872.40922 | 2116984.632 | 37.7930548819164 | -122.43054701104 | (37.7930548819164, -122.43054701104) | 13 | 9 | 1 | 29490 | 27 | ||
| 21754 | 9870 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1450X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3X3 | 6005458.91532 | 2114681.28421 | 37.7868202122258 | -122.424893656836 | (37.7868202122258, -122.424893656836) | 13 | 9 | 1 | 28858 | 41 | |||
| 21917 | 113488 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 30 Presidio Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | 5998957.82494 | 2116489.61065 | 37.7914160500734 | -122.447516035438 | (37.7914160500734, -122.447516035438) | 13 | 6 | 1 | 29490 | 31 | |||
| 21971 | 36892 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 10 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1998 12:00:00 AM | 9 | Permit Number 39545 | 5998941.54083 | 2116530.8219 | 37.7915282746499 | -122.447575345738 | (37.7915282746499, -122.447575345738) | 13 | 6 | 1 | 29490 | 31 | |
| 21985 | 123623 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 143 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995185.66965 | 2114595.15703 | 37.7859981034378 | -122.460430200119 | (37.7859981034378, -122.460430200119) | 11 | 6 | 1 | 54 | 11 | |||
| 22068 | 126754 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1755 Filbert St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004623.36719 | 2119105.43437 | 37.7989205768795 | -122.428099858641 | (37.7989205768795, -122.428099858641) | 13 | 9 | 1 | 57 | 17 | |||
| 22163 | 126713 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1824 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004227.39839 | 2118752.26863 | 37.7979284636791 | -122.429444842409 | (37.7979284636791, -122.429444842409) | 13 | 9 | 1 | 57 | 17 | |||
| 22188 | 127008 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1957 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6003633.3632 | 2118619.82022 | 37.7975311440965 | -122.43149091157 | (37.7975311440965, -122.43149091157) | 13 | 9 | 1 | 57 | 17 | |||
| 22226 | 51925 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 101 Walnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/2005 12:00:00 AM | 8 | Permit Number 48124 | 5998455.0177 | 2116126.83868 | 37.7903912276242 | -122.449229583883 | (37.7903912276242, -122.449229583883) | 13 | 6 | 1 | 54 | 31 |
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) );