trees
5,599 rows where qSpecies_id = 38 sorted by qCareAssistant
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6513 | 224799 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 159 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004849.19122 | 2099568.27784 | 37.7452890578355 | -122.425926962559 | (37.7452890578355, -122.425926962559) | 2 | 7 | 5 | 63 | 22 | |||
| 6582 | 122916 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 206 12th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992152.69759 | 2114024.49172 | 37.7842562714811 | -122.470881776845 | (37.7842562714811, -122.470881776845) | 11 | 6 | 2 | 54 | 11 | |||
| 6661 | 128698 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 300 Washington St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6012762.04961 | 2117890.12021 | 37.7960407192648 | -122.399851762841 | (37.7960407192648, -122.399851762841) | 3 | 1 | 10 | 28860 | 6 | |||
| 6741 | 120401 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 173 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5988655.68624 | 2114206.04007 | 37.7845518888292 | -122.482993367442 | (37.7845518888292, -122.482993367442) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 7059 | 192064 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 400 15th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6011310.89762 | 2107471.79469 | 37.7673534269378 | -122.404139471354 | (37.7673534269378, -122.404139471354) | 8 | 2 | 8 | 28853 | 20 | |||
| 7084 | 119456 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 766 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5985728.91492 | 2110666.6398 | 37.7746629724789 | -122.492858068519 | (37.7746629724789, -122.492858068519) | 11 | 6 | 2 | 55 | 26 | |||
| 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 | |||
| 7290 | 103105 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 300 Post St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6010638.43235 | 2115205.50204 | 37.7885507857476 | -122.407010612771 | (37.7885507857476, -122.407010612771) | 5 | 1 | 10 | 28852 | 6 | |||
| 7342 | 26844 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 100 Van Ness Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | Permit Number 775213 | 6006969.72882 | 2110998.7322 | 37.7767940394414 | -122.419405236481 | (37.7767940394414, -122.419405236481) | 7 | 9 | 9 | 28852 | 36 | ||
| 7454 | 218862 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 40 Hugo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5995574.38751 | 2107076.62885 | 37.7653765624148 | -122.458540896361 | (37.7653765624148, -122.458540896361) | 15 | 5 | 11 | 56 | 12 | |||
| 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 | |||
| 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 | |||
| 7804 | 225515 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1930 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 5x7 | 6004641.55449 | 2107219.04447 | 37.7662845296296 | -122.427189800463 | (37.7662845296296, -122.427189800463) | 8 | 4 | 5 | 28862 | 3 | |||
| 7810 | 192162 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1500 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 29 | Width 5ft | Permit Number 779453 | 6007414.0762 | 2109937.75552 | 37.7739058675964 | -122.417792878858 | (37.7739058675964, -122.417792878858) | 8 | 2 | 9 | 28853 | 19 | ||
| 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 | |||
| 7841 | 224759 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 231 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6010166.15347 | 2099991.74226 | 37.7467508491909 | -122.407571558604 | (37.7467508491909, -122.407571558604) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |
| 8017 | 249355 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 625 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008323.0201 | 2114666.64303 | 37.7869413697974 | -122.414983455249 | (37.7869413697974, -122.414983455249) | 13 | 1 | 9 | 28858 | 36 | |||
| 8051 | 127739 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1301 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008381.5529 | 2116915.61445 | 37.7931197850904 | -122.41494018075 | (37.7931197850904, -122.41494018075) | 5 | 1 | 10 | 28858 | 21 | |||
| 8181 | 192121 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 807 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 27 | Width 4ft | 6010922.27002 | 2113199.63335 | 37.783059024392 | -122.405887217429 | (37.783059024392, -122.405887217429) | 12 | 2 | 9 | 28853 | 34 | |||
| 8227 | 120322 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 650 23rd Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5988821.62524 | 2110892.0885 | 37.7754623614562 | -122.482176410805 | (37.7754623614562, -122.482176410805) | 11 | 6 | 2 | 55 | 26 | |||
| 8253 | 11057 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1630 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007426.31744 | 2117960.00612 | 37.7959337026338 | -122.418319444503 | (37.7959337026338, -122.418319444503) | 5 | 1 | 10 | 28858 | 32 | |||
| 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 | |
| 8311 | 224981 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 20 Prosper St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003320.11434 | 2106449.16062 | 37.7640957973979 | -122.431705435862 | (37.7640957973979, -122.431705435862) | 15 | 4 | 5 | 28862 | 3 | |||
| 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 | |||
| 8438 | 189632 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 11th St | 9 | : | Tree | Private 2 | 7 | Width 3ft | 6007298.00895 | 2110457.3775 | 37.7753260931545 | -122.4182312237 | (37.7753260931545, -122.4182312237) | 8 | 2 | 9 | 28853 | 34 | |||
| 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 | |||
| 8608 | 218881 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1374 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 5993982.19031 | 2106154.46944 | 37.7627529198293 | -122.463980949379 | (37.7627529198293, -122.463980949379) | 1 | 5 | 11 | 56 | 12 | |||
| 8631 | 128082 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6009683.35171 | 2121893.27188 | 37.8068602685411 | -122.41078756392 | (37.8068602685411, -122.41078756392) | 3 | 1 | 10 | 308 | 23 | |||
| 8684 | 189714 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 550 Wisconsin St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 4ft | 6012647.13321 | 2104908.73509 | 37.7603904062104 | -122.39933764023 | (37.7603904062104, -122.39933764023) | 10 | 3 | 8 | 28856 | 29 | |||
| 8793 | 128179 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 211 Beach St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009178.96771 | 2122171.51863 | 37.8075959706319 | -122.412552773896 | (37.8075959706319, -122.412552773896) | 3 | 1 | 10 | 308 | 23 | |||
| 8837 | 251690 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 98 11th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 779453 | 6007396 | 2110315 | 37.7749406737789 | -122.417882154347 | (37.7749406737789, -122.417882154347) | 8 | 2 | 9 | 28853 | 19 | |||
| 8948 | 128780 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 116 Maiden Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6011134.63349 | 2115083.13634 | 37.7882425530045 | -122.405285203167 | (37.7882425530045, -122.405285203167) | 5 | 1 | 10 | 28857 | 6 | |||
| 8971 | 224736 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3751 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 6x9 | 6005316.30441 | 2104275.01271 | 37.7582390497985 | -122.424646518647 | (37.7582390497985, -122.424646518647) | 2 | 4 | 5 | 28859 | 19 | |||
| 8976 | 128727 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 150 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6011307.13002 | 2118182.76086 | 37.7967630223487 | -122.404906710889 | (37.7967630223487, -122.404906710889) | 3 | 1 | 10 | 308 | 4 | |||
| 8984 | 127637 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 30 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6008197.67751 | 2111734.21851 | 37.7788825944034 | -122.415209456658 | (37.7788825944034, -122.415209456658) | 7 | 10 | 9 | 28852 | 36 | |||
| 9065 | 128399 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 316 Sutter St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 18 | Width 2ft | 6010737.08277 | 2115568.6338 | 37.7895533787223 | -122.406694896775 | (37.7895533787223, -122.406694896775) | 5 | 1 | 10 | 28857 | 6 | |||
| 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 | |||
| 9234 | 224994 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3787 17th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003747.34192 | 2105939.8631 | 37.76272159645 | -122.430191444288 | (37.76272159645, -122.430191444288) | 8 | 4 | 5 | 28862 | 3 | |||
| 9310 | 5671 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1421 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6005267.30914 | 2100058.51794 | 37.7466587657846 | -122.424516044105 | (37.7466587657846, -122.424516044105) | 2 | 7 | 5 | 28859 | 22 | |||
| 9327 | 190177 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 20 Spear St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6014053.70792 | 2116907.88857 | 37.7934156656489 | -122.395313496947 | (37.7934156656489, -122.395313496947) | 12 | 2 | 9 | 28855 | 6 | |||
| 9353 | 218922 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1225 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5995446.34406 | 2107212.89211 | 37.7657433464104 | -122.45899363306 | (37.7657433464104, -122.45899363306) | 15 | 5 | 11 | 56 | 12 | |||
| 9480 | 128144 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 580 North Point St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007778.14218 | 2121686.09097 | 37.8061843938561 | -122.417366248573 | (37.8061843938561, -122.417366248573) | 5 | 1 | 10 | 308 | 23 | |||
| 9530 | 225492 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 25 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6001938.93672 | 2107786.0573 | 37.7676882004846 | -122.436578216329 | (37.7676882004846, -122.436578216329) | 15 | 5 | 5 | 29492 | 3 | |||
| 9566 | 224977 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 51 Prosper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 2x2 | 6003350.18904 | 2106235.72692 | 37.7635114646938 | -122.431586177673 | (37.7635114646938, -122.431586177673) | 15 | 4 | 5 | 28862 | 3 | |||
| 9582 | 127979 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 160 Bay St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6009886.24296 | 2121622.25615 | 37.8061275009418 | -122.410066269842 | (37.8061275009418, -122.410066269842) | 3 | 1 | 10 | 308 | 23 | |||
| 9733 | 5598 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1114 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6005085.74952 | 2101846.15416 | 37.7515569476132 | -122.425271044719 | (37.7515569476132, -122.425271044719) | 2 | 4 | 5 | 28862 | 22 | |||
| 9781 | 113450 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 21X Leroy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6008324.74095 | 2116562.67984 | 37.7921475208351 | -122.415111760598 | (37.7921475208351, -122.415111760598) | 5 | 1 | 10 | 28858 | 21 | |||
| 9788 | 128384 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 109 Trenton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6010084.71998 | 2117858.53397 | 37.7958043693257 | -122.40911365939 | (37.7958043693257, -122.40911365939) | 3 | 1 | 10 | 308 | 4 | |||
| 9901 | 225315 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 107 Germania St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003691.1062 | 2108820.63843 | 37.7706283225572 | -122.430591513988 | (37.7706283225572, -122.430591513988) | 15 | 9 | 11 | 29492 | 10 | |||
| 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 | |||
| 10171 | 128630 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 400 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012042.35717 | 2118440.81507 | 37.7975126468404 | -122.402380794936 | (37.7975126468404, -122.402380794936) | 3 | 1 | 10 | 308 | 23 | |||
| 10177 | 225604 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 260 Laussat St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6003453.71894 | 2109156.79704 | 37.7715378807118 | -122.431436640207 | (37.7715378807118, -122.431436640207) | 15 | 9 | 11 | 29492 | 10 | |||
| 10190 | 128389 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 295 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6012038.5922 | 2116040.80306 | 37.79092257676 | -122.402224996381 | (37.79092257676, -122.402224996381) | 4 | 1 | 10 | 28854 | 6 | |||
| 10227 | 189669 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2475 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 5ft | 6015848.0451 | 2104085.46802 | 37.7583077705949 | -122.388209616279 | (37.7583077705949, -122.388209616279) | 10 | 3 | 8 | 28856 | 29 | |||
| 10355 | 128113 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2300 Stockton St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6009769.6912 | 2122058.41551 | 37.8073185522658 | -122.410500436454 | (37.8073185522658, -122.410500436454) | 3 | 1 | 10 | 308 | 23 | |||
| 10366 | 224768 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 310 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6004950.30827 | 2110058.97913 | 37.7740997605225 | -122.4263240969 | (37.7740997605225, -122.4263240969) | 7 | 9 | 11 | 28852 | 10 | |||
| 10437 | 190310 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 235 01st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6013968.89139 | 2115020.62738 | 37.7882289687394 | -122.395474691421 | (37.7882289687394, -122.395474691421) | 6 | 2 | 9 | 28855 | 6 | |||
| 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 | |||
| 10570 | 224802 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1450 Sanchez St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 2ft | 6003910.21401 | 2099792.41233 | 37.7458513688561 | -122.42918976771 | (37.7458513688561, -122.42918976771) | 2 | 7 | 5 | 63 | 22 | |||
| 10654 | 128380 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 15 Waverly Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6010746 | 2116993 | 37.7934648453026 | -122.406764467868 | (37.7934648453026, -122.406764467868) | 3 | 1 | 10 | 28857 | 4 | |||
| 10669 | 113451 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 21X Leroy Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008325.83409 | 2116548.49106 | 37.7921086233576 | -122.415106973525 | (37.7921086233576, -122.415106973525) | 5 | 1 | 10 | 28858 | 21 | |||
| 10727 | 190148 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1711 Oakdale Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6014397.54059 | 2095926.93864 | 37.7358256897857 | -122.392655422032 | (37.7358256897857, -122.392655422032) | 10 | 3 | 8 | 58 | 1 | |||
| 10802 | 190210 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 55 Main St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6013925.01532 | 2116617.87783 | 37.7926122059272 | -122.395738456263 | (37.7926122059272, -122.395738456263) | 12 | 2 | 9 | 28855 | 6 | |||
| 10869 | 114473 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 145 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 6007374.36978 | 2108955.06944 | 37.7712054103423 | -122.417860558238 | (37.7712054103423, -122.417860558238) | 8 | 2 | 9 | 28853 | 19 | ||||
| 10886 | 192122 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 807 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Dept of Real Estate 7 | 23 | Width 4ft | 6010961.41826 | 2113239.46389 | 37.7831705790105 | -122.405754586311 | (37.7831705790105, -122.405754586311) | 12 | 2 | 9 | 28853 | 34 | |||
| 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 | ||||||||||||||
| 11011 | 249339 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 839 Post St | 1 | : | Tree | Private 2 | 13 | Width 3ft | 6008120.77004 | 2114802.70738 | 37.7873036023197 | -122.415692834155 | (37.7873036023197, -122.415692834155) | 13 | 1 | 9 | 28858 | 36 | |||
| 11110 | 192149 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 63 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 5ft | 6007788.06434 | 2110652.2421 | 37.7758887171372 | -122.416549810724 | (37.7758887171372, -122.416549810724) | 8 | 2 | 9 | 28853 | 34 | |||
| 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 | |||
| 11132 | 19204 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 630 Sansome St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6012243.07343 | 2117875.47251 | 37.7959715542054 | -122.401646502996 | (37.7959715542054, -122.401646502996) | 3 | 1 | 10 | 28860 | 4 | |||
| 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 | |||
| 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 | ||
| 11305 | 189630 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 11th St | 7 | : | Tree | Private 2 | 14 | Width 3ft | 6007441.71426 | 2110305.43642 | 37.7749169870715 | -122.417723340559 | (37.7749169870715, -122.417723340559) | 8 | 2 | 9 | 28853 | 34 | |||
| 11574 | 224725 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 601 Treat Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008501.01971 | 2104985.35015 | 37.7603688215875 | -122.413682590383 | (37.7603688215875, -122.413682590383) | 2 | 4 | 7 | 28859 | 19 | |||
| 11597 | 189629 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 11th St | 6 | : | Tree | Private 2 | 16 | Width 3ft | 6007461.61467 | 2110284.7901 | 37.774861417042 | -122.417653036967 | (37.774861417042, -122.417653036967) | 8 | 2 | 9 | 28853 | 34 | |||
| 11615 | 189628 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 11th St | 5 | : | Tree | Private 2 | 11 | Width 3ft | 6007505.86156 | 2110238.1728 | 37.7747359067747 | -122.417496672745 | (37.7747359067747, -122.417496672745) | 8 | 2 | 9 | 28853 | 34 | |||
| 11696 | 189660 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2573 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | Width 4ft | 6015900.45488 | 2103484.96239 | 37.7566618134199 | -122.387986454936 | (37.7566618134199, -122.387986454936) | 10 | 3 | 8 | 28856 | 29 | |||
| 11735 | 260909 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 241 Laussat St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 6003564.7514 | 2109147.66361 | 37.7715190947724 | -122.431051921008 | (37.7715190947724, -122.431051921008) | 15 | 9 | 11 | 29492 | 10 | ||||
| 11772 | 225309 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 104 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/05/1987 12:00:00 AM | 16 | Width 3ft | Permit Number 24228 | 6003856.7224 | 2108736.74248 | 37.7704073456534 | -122.430012659982 | (37.7704073456534, -122.430012659982) | 7 | 9 | 11 | 29492 | 10 | |
| 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 | |||
| 11786 | 4500 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1740 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004605.06487 | 2098773.28135 | 37.743092380112 | -122.426714507892 | (37.743092380112, -122.426714507892) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 11937 | 224824 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 3560 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 5ft | 6004632.97491 | 2103109.67148 | 37.7550006810587 | -122.42692677575 | (37.7550006810587, -122.42692677575) | 2 | 4 | 5 | 28862 | 22 | |||
| 11943 | 246684 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 65 Randall St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 4ft | 6004997.42528 | 2097597.83608 | 37.7398870497478 | -122.425274204056 | (37.7398870497478, -122.425274204056) | 2 | 7 | 5 | 63 | 7 | |||
| 11954 | 224730 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 21 Oakwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/1983 12:00:00 AM | 15 | Width 5ft | Permit Number 20367 | 6005252.62208 | 2105310.75713 | 37.7610793633446 | -122.42494044944 | (37.7610793633446, -122.42494044944) | 2 | 4 | 5 | 28859 | 19 | |
| 11969 | 225360 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 127 Otis St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6006951.60276 | 2109409.2477 | 37.7724286744738 | -122.41935515412 | (37.7724286744738, -122.41935515412) | 8 | 2 | 9 | 28853 | 19 | |||
| 11991 | 54423 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 735 Montgomery St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/20/1972 12:00:00 AM | 15 | Permit Number 10197 | 6011692.51449 | 2118000.35932 | 37.796283725966 | -122.403560344851 | (37.796283725966, -122.403560344851) | 3 | 1 | 10 | 28860 | 4 | ||
| 11995 | 127689 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1020 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009869.61301 | 2116828.44156 | 37.7929639334768 | -122.409785225409 | (37.7929639334768, -122.409785225409) | 3 | 1 | 10 | 28857 | 21 | |||
| 12010 | 128071 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 245 North Point St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009416.46616 | 2121854.31268 | 37.8067383285777 | -122.411708423825 | (37.8067383285777, -122.411708423825) | 3 | 1 | 10 | 308 | 23 | |||
| 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 | |
| 12034 | 189635 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 45 11th St | 12 | : | Tree | Private 2 | 13 | Width 3ft | 6007252.77598 | 2110507.15575 | 37.7754602261381 | -122.418391225675 | (37.7754602261381, -122.418391225675) | 8 | 2 | 9 | 28853 | 34 | |||
| 12134 | 192099 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 999 Brannan St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6010725.77317 | 2108634.41691 | 37.7705130105866 | -122.406245268117 | (37.7705130105866, -122.406245268117) | 14 | 2 | 9 | 28853 | 34 | |||
| 12239 | 189672 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 2427 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6015841.43821 | 2104253.31303 | 37.7587682711682 | -122.388244179947 | (37.7587682711682, -122.388244179947) | 10 | 3 | 8 | 28856 | 29 |
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) );