trees
5,599 rows where qSpecies_id = 38 sorted by qAddress 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 122000 | 104507 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99x DICHIERA CT | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 5998517 | 2087907 | 37.7129100350962 | -122.446983527065 | (37.7129100350962, -122.446983527065) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 62761 | 192098 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 999 Brannan St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6010707.34193 | 2108618.01402 | 37.7704669410154 | -122.406307866326 | (37.7704669410154, -122.406307866326) | 14 | 2 | 9 | 28853 | 34 | |||
| 101374 | 61826 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 999 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/05/1985 12:00:00 AM | 18 | Permit Number 21970 | 6010609.29869 | 2108522.75878 | 37.7701999071164 | -122.406640286315 | (37.7701999071164, -122.406640286315) | 14 | 2 | 9 | 28853 | 34 | ||
| 103695 | 192094 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 999 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6010646.58742 | 2108561.14866 | 37.7703074030862 | -122.406514009826 | (37.7703074030862, -122.406514009826) | 14 | 2 | 9 | 28853 | 34 | |||
| 144671 | 192096 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 999 Brannan St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6010680.62429 | 2108593.08012 | 37.7703969836671 | -122.406398526079 | (37.7703969836671, -122.406398526079) | 14 | 2 | 9 | 28853 | 34 | |||
| 154763 | 192092 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 999 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6010624.92961 | 2108539.52949 | 37.7702468301474 | -122.406587400801 | (37.7702468301474, -122.406587400801) | 14 | 2 | 9 | 28853 | 34 | |||
| 167574 | 192095 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 999 Brannan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6010670.44749 | 2108583.65546 | 37.7703705364064 | -122.406433063631 | (37.7703705364064, -122.406433063631) | 14 | 2 | 9 | 28853 | 34 | |||
| 170393 | 192097 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 999 Brannan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6010693.32762 | 2108604.00678 | 37.7704276963991 | -122.406355355031 | (37.7704276963991, -122.406355355031) | 14 | 2 | 9 | 28853 | 34 | |||
| 180417 | 192093 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 999 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6010633.55953 | 2108549.60731 | 37.77027498434 | -122.406558260073 | (37.77027498434, -122.406558260073) | 14 | 2 | 9 | 28853 | 34 | |||
| 66291 | 6152 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 998X Ellis St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6006127.91467 | 2113531.0311 | 37.7836996654557 | -122.422497308029 | (37.7836996654557, -122.422497308029) | 7 | 9 | 11 | 28858 | 41 | |||
| 89827 | 6151 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 998X Ellis St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 2x2 | 6006159.13113 | 2113535.212 | 37.7837129061562 | -122.422389607903 | (37.7837129061562, -122.422389607903) | 7 | 9 | 11 | 28858 | 41 | |||
| 133658 | 6149 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 998X Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3x3 | 6006219.05208 | 2113544.77353 | 37.7837425397409 | -122.422182983282 | (37.7837425397409, -122.422182983282) | 7 | 9 | 11 | 28858 | 41 | |||
| 177796 | 6150 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 998X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6006191.74012 | 2113539.82354 | 37.7837274077384 | -122.42227712071 | (37.7837274077384, -122.42227712071) | 7 | 9 | 11 | 28858 | 41 | |||
| 2178 | 56928 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 990 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 22 | Permit Number 14172 | 6008190.72994 | 2120000.83835 | 37.8015803191331 | -122.415819006365 | (37.8015803191331, -122.415819006365) | 5 | 1 | 10 | 308 | 32 | ||
| 85471 | 224374 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Rosemont Pl | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005143.26148 | 2107927.69436 | 37.768258671917 | -122.425504927819 | (37.768258671917, -122.425504927819) | 8 | 4 | 5 | 28853 | 19 | |||
| 93420 | 224373 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Rosemont Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005143.22647 | 2107910.0857 | 37.7682103207829 | -122.42550379559 | (37.7682103207829, -122.42550379559) | 8 | 4 | 5 | 28853 | 19 | |||
| 131165 | 224372 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Rosemont Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005145.15548 | 2107892.43694 | 37.7681619705137 | -122.425495867158 | (37.7681619705137, -122.425495867158) | 8 | 4 | 5 | 28853 | 19 | |||
| 140594 | 224371 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Rosemont Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005147.11158 | 2107876.09186 | 37.7681172013667 | -122.425487937825 | (37.7681172013667, -122.425487937825) | 8 | 4 | 5 | 28853 | 19 | |||
| 164049 | 224370 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Rosemont Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005146.14836 | 2107861.11108 | 37.7680760133145 | -122.425490203232 | (37.7680760133145, -122.425490203232) | 8 | 4 | 5 | 28853 | 19 | |||
| 489 | 225574 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Carmelita St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002579.4442 | 2108765.68107 | 37.7704143837497 | -122.434432832327 | (37.7704143837497, -122.434432832327) | 15 | 5 | 5 | 29492 | 9 | |||
| 124130 | 225572 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Carmelita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002575.26449 | 2108799.82425 | 37.7705078952528 | -122.434449731496 | (37.7705078952528, -122.434449731496) | 15 | 5 | 5 | 29492 | 9 | |||
| 184094 | 225573 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Carmelita St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002575.91941 | 2108784.24181 | 37.7704651468881 | -122.434446351835 | (37.7704651468881, -122.434446351835) | 15 | 5 | 5 | 29492 | 9 | |||
| 82032 | 226561 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Camp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6005616.66249 | 2106341.84369 | 37.7639310398062 | -122.423754705029 | (37.7639310398062, -122.423754705029) | 8 | 4 | 5 | 28859 | 19 | |||
| 139433 | 226562 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Camp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6005658.11361 | 2106344.18331 | 37.763939803696 | -122.423611504189 | (37.763939803696, -122.423611504189) | 8 | 4 | 5 | 28859 | 19 | |||
| 26042 | 128656 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Broadway | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6013029.0227 | 2118872.45132 | 37.7987528461303 | -122.398996959964 | (37.7987528461303, -122.398996959964) | 3 | 1 | 10 | 28860 | 6 | |||
| 45617 | 128649 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012846.97019 | 2118845.69274 | 37.7986692271531 | -122.399625044672 | (37.7986692271531, -122.399625044672) | 3 | 1 | 10 | 28860 | 6 | |||
| 78117 | 128655 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Broadway | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6012979.83036 | 2118865.43828 | 37.7987308486974 | -122.399166689903 | (37.7987308486974, -122.399166689903) | 3 | 1 | 10 | 28860 | 6 | |||
| 95204 | 128650 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012865.1211 | 2118849.0555 | 37.7986794722409 | -122.399562472556 | (37.7986794722409, -122.399562472556) | 3 | 1 | 10 | 28860 | 6 | |||
| 119942 | 128651 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6012885.20005 | 2118851.08112 | 37.7986861532949 | -122.399493134819 | (37.7986861532949, -122.399493134819) | 3 | 1 | 10 | 28860 | 6 | |||
| 129167 | 128654 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012944.99431 | 2118859.43882 | 37.7987124341865 | -122.399286813242 | (37.7987124341865, -122.399286813242) | 3 | 1 | 10 | 28860 | 6 | |||
| 137646 | 128652 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012900.38712 | 2118852.88181 | 37.7986919440479 | -122.399440708848 | (37.7986919440479, -122.399440708848) | 3 | 1 | 10 | 28860 | 6 | |||
| 145741 | 128653 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012921.14698 | 2118856.35377 | 37.7987026342841 | -122.399369116496 | (37.7987026342841, -122.399369116496) | 3 | 1 | 10 | 28860 | 6 | |||
| 147496 | 128648 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6012833.22881 | 2118842.88932 | 37.7986607636496 | -122.39967239759 | (37.7986607636496, -122.39967239759) | 3 | 1 | 10 | 28860 | 6 | |||
| 165597 | 128657 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Broadway | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6013049.87065 | 2118876.68015 | 37.7987656191896 | -122.398925115818 | (37.7987656191896, -122.398925115818) | 3 | 1 | 10 | 28860 | 6 | |||
| 190942 | 128658 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 99 Broadway | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6013064.64697 | 2118875.86345 | 37.7987642000757 | -122.398873927287 | (37.7987642000757, -122.398873927287) | 3 | 1 | 10 | 28860 | 6 | |||
| 74176 | 106862 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 98X EUREKA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x7 | 6001388.44186 | 2105433.75017 | 37.7611980453607 | -122.438313763896 | (37.7611980453607, -122.438313763896) | 15 | 4 | 5 | 28862 | 3 | |||
| 134981 | 106861 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 98X EUREKA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4x7 | 6001388.44186 | 2105433.75017 | 37.7611980453607 | -122.438313763896 | (37.7611980453607, -122.438313763896) | 15 | 4 | 5 | 28862 | 3 | |||
| 134026 | 5560 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 986 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6005042.03687 | 2102621.31719 | 37.7536828954567 | -122.425477369008 | (37.7536828954567, -122.425477369008) | 2 | 4 | 5 | 28862 | 22 | |||
| 37903 | 226552 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 98 Dorland St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005004.40896 | 2105747.52782 | 37.7622646086585 | -122.425830002156 | (37.7622646086585, -122.425830002156) | 8 | 4 | 5 | 28859 | 19 | |||
| 169791 | 226551 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 98 Dorland St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6005031.08674 | 2105751.07552 | 37.7622758573624 | -122.425737986224 | (37.7622758573624, -122.425737986224) | 8 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 22084 | 251694 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 98 11th St | 5 | 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 | |||
| 113497 | 251693 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 98 11th St | 4 | 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 | |||
| 150232 | 224785 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 975 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6004417.34983 | 2103222.94294 | 37.7552995032934 | -122.427680538931 | (37.7552995032934, -122.427680538931) | 2 | 4 | 5 | 28862 | 22 | |||
| 14467 | 121481 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 974 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6007930.82264 | 2115167.72637 | 37.7882951759371 | -122.416375878271 | (37.7882951759371, -122.416375878271) | 13 | 1 | 10 | 28858 | 21 | |||
| 79058 | 121482 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 974 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6007920.55709 | 2115165.25969 | 37.788287825761 | -122.416411220695 | (37.788287825761, -122.416411220695) | 13 | 1 | 10 | 28858 | 21 | |||
| 88731 | 65792 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 970 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1990 12:00:00 AM | 13 | Permit Number 28760 | 6007205.77155 | 2120560.46381 | 37.8030614881672 | -122.419267138378 | (37.8030614881672, -122.419267138378) | 5 | 1 | 1 | 28858 | 32 | ||
| 114015 | 127875 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 970 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007195.86934 | 2120558.74037 | 37.8030561983563 | -122.41930128295 | (37.8030561983563, -122.41930128295) | 5 | 1 | 1 | 28858 | 32 | |||
| 124936 | 127876 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 970 Chestnut St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007171.45546 | 2120556.92909 | 37.8030498500356 | -122.419385639355 | (37.8030498500356, -122.419385639355) | 5 | 1 | 1 | 28858 | 32 | |||
| 184636 | 127877 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 970 Chestnut St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007161.73888 | 2120554.81667 | 37.8030435026051 | -122.419419113923 | (37.8030435026051, -122.419419113923) | 5 | 1 | 1 | 28858 | 32 | |||
| 33566 | 128659 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 97 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6013172.49753 | 2118894.02192 | 37.7988200677512 | -122.398502001866 | (37.7988200677512, -122.398502001866) | 3 | 1 | 10 | 28860 | 6 | |||
| 54440 | 128660 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 97 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6013191.30228 | 2118896.9121 | 37.7988290510747 | -122.398437133776 | (37.7988290510747, -122.398437133776) | 3 | 1 | 10 | 28860 | 6 | |||
| 77001 | 128661 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 97 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6013211.06947 | 2118898.74188 | 37.7988351763703 | -122.398368860847 | (37.7988351763703, -122.398368860847) | 3 | 1 | 10 | 28860 | 6 | |||
| 114261 | 128662 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 97 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6013238.37363 | 2118902.24016 | 37.7988463027602 | -122.398274624481 | (37.7988463027602, -122.398274624481) | 3 | 1 | 10 | 28860 | 6 | |||
| 138125 | 128664 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 97 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6013268.51889 | 2118906.92776 | 37.7988608529118 | -122.398170640368 | (37.7988608529118, -122.398170640368) | 3 | 1 | 10 | 28860 | 6 | |||
| 181039 | 128663 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 97 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6013256.27802 | 2118905.30587 | 37.7988557177714 | -122.398212884223 | (37.7988557177714, -122.398212884223) | 3 | 1 | 10 | 28860 | 6 | |||
| 57492 | 59253 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 969 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/1980 12:00:00 AM | 14 | Permit Number 18585 | 6007723.85224 | 2120237.02379 | 37.8022025672608 | -122.417451367582 | (37.8022025672608, -122.417451367582) | 5 | 1 | 10 | 308 | 32 | ||
| 25296 | 224974 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 967 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6003806.67571 | 2102652.62823 | 37.7536989915247 | -122.429751756742 | (37.7536989915247, -122.429751756742) | 2 | 4 | 5 | 28862 | 22 | |||
| 178495 | 5553 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 966 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 34 | 6x9 | 6005037.52737 | 2102725.93475 | 37.7539698961026 | -122.425500408737 | (37.7539698961026, -122.425500408737) | 2 | 4 | 5 | 28862 | 22 | |||
| 100781 | 127500 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 965 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6008026.88812 | 2115133.10058 | 37.7882055036167 | -122.416041053474 | (37.7882055036167, -122.416041053474) | 13 | 1 | 10 | 28858 | 21 | |||
| 157272 | 127499 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 965 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6007987.09775 | 2115132.84469 | 37.7882025637556 | -122.416178703697 | (37.7882025637556, -122.416178703697) | 13 | 1 | 10 | 28858 | 21 | |||
| 101167 | 10149 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 960 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x9 | 6005669.87513 | 2103378.5529 | 37.7557975424466 | -122.423359988073 | (37.7557975424466, -122.423359988073) | 2 | 4 | 5 | 28859 | 19 | |||
| 106308 | 127874 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 960 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007220.48464 | 2120560.93239 | 37.8030636033757 | -122.419216256534 | (37.8030636033757, -122.419216256534) | 5 | 1 | 1 | 28858 | 32 | |||
| 191488 | 65969 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 960 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1990 12:00:00 AM | 11 | Permit Number 28993 | 6007235.97107 | 2120561.38544 | 37.8030657194716 | -122.419162697418 | (37.8030657194716, -122.419162697418) | 5 | 1 | 1 | 28858 | 32 | ||
| 171988 | 6141 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 956 Ellis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 2x2 | 6006237.10649 | 2113548.0769 | 37.783752628311 | -122.422120756488 | (37.783752628311, -122.422120756488) | 7 | 9 | 11 | 28858 | 41 | |||
| 34276 | 104696 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 953 Treat Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770164 | 6008633.4 | 2103067 | 37.7551089013639 | -122.413089099766 | (37.7551089013639, -122.413089099766) | 2 | 4 | 7 | 28859 | 19 | |||
| 60374 | 59971 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 953 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/1982 12:00:00 AM | Permit Number 770164 | 6008622.11827174 | 2103000.09497074 | 37.7549245619495 | -122.413123384766 | (37.7549245619495, -122.413123384766) | 2 | 4 | 7 | 28859 | 19 | |||
| 118744 | 104695 | Permitted Site 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 953 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 770164 | 6008633.4 | 2103067 | 37.7551089013639 | -122.413089099766 | (37.7551089013639, -122.413089099766) | 2 | 4 | 7 | 28859 | 19 | |||
| 2696 | 37548 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 952 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | 13 | Permit Number 39988 | 6008033.82968 | 2115183.28467 | 37.7883436871616 | -122.416020592081 | (37.7883436871616, -122.416020592081) | 13 | 1 | 10 | 28858 | 21 | |
| 26173 | 127483 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 952 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6007980.9662 | 2115174.73021 | 37.7883172264026 | -122.416202885554 | (37.7883172264026, -122.416202885554) | 13 | 1 | 10 | 28858 | 21 | |||
| 96972 | 224891 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 950 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5997254.06668 | 2107165.46874 | 37.7657168838478 | -122.452737718683 | (37.7657168838478, -122.452737718683) | 15 | 5 | 11 | 29492 | 9 | |||
| 31623 | 246675 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 950 San Jose Ave | 5 | Front Yard : Yard | Tree | Private 2 | 19 | Width 8ft | 6005283.66351 | 2097689.92499 | 37.7401560720365 | -122.424291058881 | (37.7401560720365, -122.424291058881) | 2 | 7 | 5 | 28859 | 7 | |||
| 37620 | 246674 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 950 San Jose Ave | 4 | Front Yard : Yard | Tree | Private 2 | 16 | Width 8ft | 6005286.18809 | 2097704.16876 | 37.7401953247637 | -122.424283342697 | (37.7401953247637, -122.424283342697) | 2 | 7 | 5 | 28859 | 7 | |||
| 125271 | 246673 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 950 San Jose Ave | 3 | Front Yard : Yard | Tree | Private 2 | 15 | Width 8ft | 6005263.853 | 2097708.23975 | 37.7402052415794 | -122.424360857976 | (37.7402052415794, -122.424360857976) | 2 | 7 | 5 | 63 | 7 | |||
| 188378 | 246672 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 950 San Jose Ave | 2 | Front Yard : Yard | Tree | Private 2 | 5 | Width 8ft | 6005247.4068 | 2097710.70234 | 37.7402110745895 | -122.424417897473 | (37.7402110745895, -122.424417897473) | 2 | 7 | 5 | 63 | 7 | |||
| 25727 | 190321 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 95 Hawthorne St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6013226.39617 | 2113799.41871 | 37.7848344875705 | -122.397957916523 | (37.7848344875705, -122.397957916523) | 6 | 2 | 9 | 28855 | 6 | |||
| 34500 | 190323 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 95 Hawthorne St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6013148.54782 | 2113882.86042 | 37.7850592632271 | -122.398233104571 | (37.7850592632271, -122.398233104571) | 6 | 2 | 9 | 28855 | 6 | |||
| 99350 | 190322 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 95 Hawthorne St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6013169.87744 | 2113860.96664 | 37.7850003360478 | -122.398157773768 | (37.7850003360478, -122.398157773768) | 6 | 2 | 9 | 28855 | 6 | |||
| 106976 | 190320 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 95 Hawthorne St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6013246.48768 | 2113782.19612 | 37.7847883172678 | -122.397887197434 | (37.7847883172678, -122.397887197434) | 6 | 2 | 9 | 28855 | 6 | |||
| 81390 | 192103 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 949 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6010459.92723 | 2112762.97095 | 37.7818341846445 | -122.407455947136 | (37.7818341846445, -122.407455947136) | 14 | 2 | 9 | 28853 | 34 | |||
| 164732 | 192104 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 949 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6010477.15217 | 2112780.1699 | 37.7818823730085 | -122.407397569457 | (37.7818823730085, -122.407397569457) | 14 | 2 | 9 | 28853 | 34 | |||
| 128786 | 10148 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 948 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2x3 | 6005665.54475 | 2103435.07342 | 37.7559524902372 | -122.423378981771 | (37.7559524902372, -122.423378981771) | 2 | 4 | 5 | 28859 | 19 | |||
| 15656 | 30489 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 947 Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1956 12:00:00 AM | 16 | Permit Number 149 | 6008994.77228 | 2115613.22786 | 37.7895781874332 | -122.41272628189 | (37.7895781874332, -122.41272628189) | 5 | 1 | 10 | 28858 | 21 | ||
| 39178 | 30488 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 947 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1956 12:00:00 AM | 14 | Permit Number 149 | 6008985.48844 | 2115611.81469 | 37.7895737861364 | -122.41275830317 | (37.7895737861364, -122.41275830317) | 5 | 1 | 10 | 28858 | 21 | ||
| 140185 | 30490 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 947 Bush St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1956 12:00:00 AM | 16 | 3x3 | Permit Number 149 | 6009006.10856 | 2115616.60258 | 37.7895880898559 | -122.41268729808 | (37.7895880898559, -122.41268729808) | 5 | 1 | 10 | 28858 | 21 | |
| 180319 | 30487 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 947 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1956 12:00:00 AM | 13 | Permit Number 149 | 6008968.98883 | 2115611.75141 | 37.7895726862883 | -122.412815385815 | (37.7895726862883, -122.412815385815) | 5 | 1 | 10 | 28858 | 21 | ||
| 85589 | 127803 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 945 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008464.69057 | 2119301.0779 | 37.7996743490447 | -122.414821422569 | (37.7996743490447, -122.414821422569) | 5 | 1 | 10 | 308 | 32 | |||
| 99262 | 127802 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 945 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008446.28486 | 2119301.06839 | 37.7996732887356 | -122.414885112579 | (37.7996732887356, -122.414885112579) | 5 | 1 | 10 | 308 | 32 | |||
| 144193 | 127801 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 945 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008428.81581 | 2119299.49673 | 37.7996679917499 | -122.414945450765 | (37.7996679917499, -122.414945450765) | 5 | 1 | 10 | 308 | 32 | |||
| 168869 | 67369 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 944 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | 12 | Permit Number 30862 | 5992616.32068 | 2111401.03119 | 37.7770797658799 | -122.469086822528 | (37.7770797658799, -122.469086822528) | 11 | 6 | 2 | 54 | 11 | |
| 193838 | 124353 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 944 Balboa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5992588.76079 | 2111400.81961 | 37.7770775924802 | -122.469182144559 | (37.7770775924802, -122.469182144559) | 11 | 6 | 2 | 54 | 11 | |||
| 69187 | 15170 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 941 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/13/2019 12:00:00 AM | 3 | 3x3 | 6010493.2294 | 2112796.27211 | 37.7819274857178 | -122.407343084927 | (37.7819274857178, -122.407343084927) | 14 | 2 | 9 | 28853 | 34 | ||
| 132621 | 258095 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 941 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/13/2019 12:00:00 AM | 3 | 3x3 | 6010493.2294 | 2112796.27211 | 37.7819274857178 | -122.407343084927 | (37.7819274857178, -122.407343084927) | 14 | 2 | 9 | 28853 | 34 | ||
| 152148 | 258094 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 941 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/13/2019 12:00:00 AM | 3 | 3x3 | 6010493.2294 | 2112796.27211 | 37.7819274857178 | -122.407343084927 | (37.7819274857178, -122.407343084927) | 14 | 2 | 9 | 28853 | 34 | ||
| 158154 | 258096 | Significant Tree 6 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 941 Mission St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/13/2019 12:00:00 AM | 3 | 3x3 | 6010493.2294 | 2112796.27211 | 37.7819274857178 | -122.407343084927 | (37.7819274857178, -122.407343084927) | 14 | 2 | 9 | 28853 | 34 | ||
| 171852 | 225432 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 94 Eureka St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6001376.9754 | 2105319.78515 | 37.7608844730594 | -122.438345256445 | (37.7608844730594, -122.438345256445) | 15 | 4 | 5 | 28862 | 3 | |||
| 99575 | 127904 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 937 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | Width 6ft | 6007970.92827 | 2120270.81905 | 37.8023092592118 | -122.416598758152 | (37.8023092592118, -122.416598758152) | 5 | 1 | 10 | 308 | 32 | |||
| 102614 | 127905 | Undocumented 4 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 937 Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 16 | Width 6ft | 6007996.96181 | 2120271.7748 | 37.8023133475557 | -122.416508736883 | (37.8023133475557, -122.416508736883) | 5 | 1 | 10 | 308 | 32 | |||
| 44458 | 127900 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 935 Chestnut St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6007384.64005 | 2120530.50291 | 37.8029892950777 | -122.418646032411 | (37.8029892950777, -122.418646032411) | 5 | 1 | 1 | 28858 | 32 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );