Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▲ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 107056 | 107056 | 104507 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99x DICHIERA CT | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 5998517.0 | 2087907.0 | 37.7129100350962 | -122.44698352706499 | (37.7129100350962, -122.446983527065) | |||
| 26905 | 26905 | 192098 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 999 Brannan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6010707.34193 | 2108618.01402 | 37.77046694101539 | -122.406307866326 | (37.7704669410154, -122.406307866326) | |||
| 28189 | 28189 | 192092 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 999 Brannan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6010624.92961 | 2108539.52949 | 37.7702468301474 | -122.40658740080099 | (37.7702468301474, -122.406587400801) | |||
| 46411 | 46411 | 192099 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 999 Brannan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6010725.77317 | 2108634.4169099997 | 37.7705130105866 | -122.406245268117 | (37.7705130105866, -122.406245268117) | |||
| 60518 | 60518 | 192096 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 999 Brannan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6010680.62429 | 2108593.08012 | 37.770396983667105 | -122.406398526079 | (37.7703969836671, -122.406398526079) | |||
| 62606 | 62606 | 61826 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 999 Brannan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1985 12:00:00 AM | 18 | Permit Number 21970 | 6010609.298690001 | 2108522.75878 | 37.7701999071164 | -122.406640286315 | (37.7701999071164, -122.406640286315) | ||
| 123824 | 123824 | 192095 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 999 Brannan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6010670.44749 | 2108583.65546 | 37.770370536406396 | -122.406433063631 | (37.7703705364064, -122.406433063631) | |||
| 159490 | 159490 | 192094 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 999 Brannan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6010646.58742 | 2108561.14866 | 37.77030740308621 | -122.406514009826 | (37.7703074030862, -122.406514009826) | |||
| 163976 | 163976 | 192093 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 999 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6010633.55953 | 2108549.60731 | 37.77027498434 | -122.406558260073 | (37.77027498434, -122.406558260073) | |||
| 167800 | 167800 | 192097 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 999 Brannan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6010693.32762 | 2108604.00678 | 37.7704276963991 | -122.406355355031 | (37.7704276963991, -122.406355355031) | |||
| 22493 | 22493 | 6152 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 998X Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6006127.91467 | 2113531.0311 | 37.78369966545571 | -122.42249730802901 | (37.7836996654557, -122.422497308029) | |||
| 22553 | 22553 | 6151 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 998X Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 2x2 | 6006159.131130001 | 2113535.212 | 37.783712906156204 | -122.422389607903 | (37.7837129061562, -122.422389607903) | |||
| 22674 | 22674 | 6149 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 998X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3x3 | 6006219.052080001 | 2113544.77353 | 37.7837425397409 | -122.422182983282 | (37.7837425397409, -122.422182983282) | |||
| 22754 | 22754 | 6150 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 998X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6006191.740119999 | 2113539.8235400002 | 37.7837274077384 | -122.42227712071 | (37.7837274077384, -122.42227712071) | |||
| 58812 | 58812 | 56928 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 990 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1974 12:00:00 AM | 22 | Permit Number 14172 | 6008190.72994 | 2120000.83835 | 37.8015803191331 | -122.415819006365 | (37.8015803191331, -122.415819006365) | ||
| 25602 | 25602 | 224374 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Rosemont Pl | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005143.26148 | 2107927.6943599996 | 37.768258671917 | -122.425504927819 | (37.768258671917, -122.425504927819) | |||
| 39464 | 39464 | 224371 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Rosemont Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005147.11158 | 2107876.09186 | 37.7681172013667 | -122.425487937825 | (37.7681172013667, -122.425487937825) | |||
| 50753 | 50753 | 224370 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Rosemont Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6005146.14836 | 2107861.1110799997 | 37.7680760133145 | -122.425490203232 | (37.7680760133145, -122.425490203232) | |||
| 58770 | 58770 | 224373 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Rosemont Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6005143.22647 | 2107910.0857 | 37.7682103207829 | -122.42550379558998 | (37.7682103207829, -122.42550379559) | |||
| 105565 | 105565 | 224372 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Rosemont Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005145.15548 | 2107892.43694 | 37.7681619705137 | -122.42549586715799 | (37.7681619705137, -122.425495867158) | |||
| 32212 | 32212 | 225573 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Carmelita St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002575.91941 | 2108784.24181 | 37.77046514688811 | -122.434446351835 | (37.7704651468881, -122.434446351835) | |||
| 63821 | 63821 | 225574 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Carmelita St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002579.4442 | 2108765.68107 | 37.7704143837497 | -122.434432832327 | (37.7704143837497, -122.434432832327) | |||
| 73645 | 73645 | 225575 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Carmelita St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002578.23632 | 2108754.51591 | 37.7703836584071 | -122.43443621197399 | (37.7703836584071, -122.434436211974) | |||
| 76288 | 76288 | 225572 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Carmelita St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002575.26449 | 2108799.82425 | 37.7705078952528 | -122.43444973149599 | (37.7705078952528, -122.434449731496) | |||
| 32386 | 32386 | 226561 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6005616.66249 | 2106341.84369 | 37.7639310398062 | -122.423754705029 | (37.7639310398062, -122.423754705029) | |||
| 135065 | 135065 | 226562 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Camp St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6005658.113609999 | 2106344.1833099998 | 37.763939803696 | -122.423611504189 | (37.763939803696, -122.423611504189) | |||
| 28641 | 28641 | 128657 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Broadway | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013049.87065 | 2118876.68015 | 37.7987656191896 | -122.398925115818 | (37.7987656191896, -122.398925115818) | |||
| 36739 | 36739 | 128654 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Broadway | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012944.99431 | 2118859.4388200003 | 37.7987124341865 | -122.399286813242 | (37.7987124341865, -122.399286813242) | |||
| 45411 | 45411 | 128649 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012846.97019 | 2118845.6927400003 | 37.7986692271531 | -122.39962504467199 | (37.7986692271531, -122.399625044672) | |||
| 47588 | 47588 | 128650 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012865.1211 | 2118849.0555 | 37.7986794722409 | -122.399562472556 | (37.7986794722409, -122.399562472556) | |||
| 136474 | 136474 | 128656 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Broadway | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013029.0227 | 2118872.45132 | 37.79875284613029 | -122.39899695996401 | (37.7987528461303, -122.398996959964) | |||
| 151729 | 151729 | 128651 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012885.20005 | 2118851.08112 | 37.798686153294895 | -122.399493134819 | (37.7986861532949, -122.399493134819) | |||
| 156156 | 156156 | 128648 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012833.22881 | 2118842.88932 | 37.7986607636496 | -122.39967239759 | (37.7986607636496, -122.39967239759) | |||
| 166785 | 166785 | 128655 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Broadway | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012979.83036 | 2118865.43828 | 37.7987308486974 | -122.399166689903 | (37.7987308486974, -122.399166689903) | |||
| 167598 | 167598 | 128658 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Broadway | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6013064.64697 | 2118875.86345 | 37.7987642000757 | -122.39887392728701 | (37.7987642000757, -122.398873927287) | |||
| 172786 | 172786 | 128653 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012921.146980001 | 2118856.35377 | 37.7987026342841 | -122.39936911649599 | (37.7987026342841, -122.399369116496) | |||
| 182211 | 182211 | 128652 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 99 Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012900.38712 | 2118852.8818099997 | 37.7986919440479 | -122.399440708848 | (37.7986919440479, -122.399440708848) | |||
| 90174 | 90174 | 106862 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 98X EUREKA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x7 | 6001388.44186 | 2105433.75017 | 37.7611980453607 | -122.438313763896 | (37.7611980453607, -122.438313763896) | |||
| 112726 | 112726 | 106861 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 98X EUREKA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4x7 | 6001388.44186 | 2105433.75017 | 37.7611980453607 | -122.438313763896 | (37.7611980453607, -122.438313763896) | |||
| 21138 | 21138 | 5560 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 986 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6005042.03687 | 2102621.3171900003 | 37.753682895456706 | -122.42547736900801 | (37.7536828954567, -122.425477369008) | |||
| 67769 | 67769 | 226551 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 98 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005031.08674 | 2105751.07552 | 37.7622758573624 | -122.42573798622401 | (37.7622758573624, -122.425737986224) | |||
| 67965 | 67965 | 226552 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 98 Dorland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6005004.40896 | 2105747.52782 | 37.7622646086585 | -122.42583000215599 | (37.7622646086585, -122.425830002156) | |||
| 1777 | 1777 | 251693 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 98 11th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779453 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | |||
| 1783 | 1783 | 251690 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 98 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779453 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | |||
| 1786 | 1786 | 251694 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 98 11th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 779453 | 6007396.0 | 2110315.0 | 37.77494067377889 | -122.417882154347 | (37.7749406737789, -122.417882154347) | |||
| 158007 | 158007 | 224785 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 975 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6004417.349830001 | 2103222.94294 | 37.7552995032934 | -122.42768053893101 | (37.7552995032934, -122.427680538931) | |||
| 22294 | 22294 | 121482 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 974 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6007920.55709 | 2115165.25969 | 37.788287825760996 | -122.416411220695 | (37.788287825761, -122.416411220695) | |||
| 56409 | 56409 | 121481 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 974 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6007930.82264 | 2115167.7263700003 | 37.7882951759371 | -122.41637587827101 | (37.7882951759371, -122.416375878271) | |||
| 31665 | 31665 | 127876 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 970 Chestnut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007171.45546 | 2120556.92909 | 37.8030498500356 | -122.41938563935499 | (37.8030498500356, -122.419385639355) | |||
| 72292 | 72292 | 127877 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 970 Chestnut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007161.73888 | 2120554.81667 | 37.8030435026051 | -122.419419113923 | (37.8030435026051, -122.419419113923) | |||
| 169548 | 169548 | 127875 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 970 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007195.86934 | 2120558.7403700002 | 37.803056198356295 | -122.41930128295 | (37.8030561983563, -122.41930128295) | |||
| 184086 | 184086 | 65792 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 970 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1990 12:00:00 AM | 13 | Permit Number 28760 | 6007205.77155 | 2120560.4638099996 | 37.8030614881672 | -122.41926713837799 | (37.8030614881672, -122.419267138378) | ||
| 30515 | 30515 | 128660 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 97 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6013191.30228 | 2118896.9121 | 37.798829051074705 | -122.398437133776 | (37.7988290510747, -122.398437133776) | |||
| 32755 | 32755 | 128661 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 97 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6013211.0694699995 | 2118898.74188 | 37.7988351763703 | -122.398368860847 | (37.7988351763703, -122.398368860847) | |||
| 41139 | 41139 | 128664 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 97 Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6013268.51889 | 2118906.92776 | 37.798860852911794 | -122.39817064036801 | (37.7988608529118, -122.398170640368) | |||
| 133156 | 133156 | 128659 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 97 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6013172.49753 | 2118894.02192 | 37.7988200677512 | -122.39850200186599 | (37.7988200677512, -122.398502001866) | |||
| 177738 | 177738 | 128662 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 97 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013238.37363 | 2118902.24016 | 37.798846302760204 | -122.39827462448099 | (37.7988463027602, -122.398274624481) | |||
| 184271 | 184271 | 128663 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 97 Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013256.27802 | 2118905.3058700003 | 37.798855717771396 | -122.398212884223 | (37.7988557177714, -122.398212884223) | |||
| 165996 | 165996 | 59253 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 969 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/1980 12:00:00 AM | 14 | Permit Number 18585 | 6007723.85224 | 2120237.02379 | 37.80220256726079 | -122.417451367582 | (37.8022025672608, -122.417451367582) | ||
| 154838 | 154838 | 224974 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 967 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6003806.67571 | 2102652.62823 | 37.7536989915247 | -122.42975175674201 | (37.7536989915247, -122.429751756742) | |||
| 21716 | 21716 | 5553 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 966 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 34 | 6x9 | 6005037.527369999 | 2102725.93475 | 37.7539698961026 | -122.425500408737 | (37.7539698961026, -122.425500408737) | |||
| 74823 | 74823 | 127500 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 965 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008026.888119999 | 2115133.10058 | 37.7882055036167 | -122.416041053474 | (37.7882055036167, -122.416041053474) | |||
| 149491 | 149491 | 127499 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 965 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6007987.09775 | 2115132.84469 | 37.788202563755604 | -122.416178703697 | (37.7882025637556, -122.416178703697) | |||
| 19390 | 19390 | 10149 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 960 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x9 | 6005669.8751300005 | 2103378.5529 | 37.7557975424466 | -122.423359988073 | (37.7557975424466, -122.423359988073) | |||
| 39689 | 39689 | 65969 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 960 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/1990 12:00:00 AM | 11 | Permit Number 28993 | 6007235.97107 | 2120561.3854400003 | 37.803065719471604 | -122.419162697418 | (37.8030657194716, -122.419162697418) | ||
| 61960 | 61960 | 127874 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 960 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007220.48464 | 2120560.93239 | 37.803063603375705 | -122.419216256534 | (37.8030636033757, -122.419216256534) | |||
| 22759 | 22759 | 6141 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 956 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 2x2 | 6006237.10649 | 2113548.0769 | 37.783752628311 | -122.422120756488 | (37.783752628311, -122.422120756488) | |||
| 84957 | 84957 | 59971 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 953 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/05/1982 12:00:00 AM | Permit Number 770164 | 6008622.11827174 | 2103000.09497074 | 37.7549245619495 | -122.41312338476601 | (37.7549245619495, -122.413123384766) | |||
| 108594 | 108594 | 104695 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 953 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770164 | 6008633.4 | 2103067.0 | 37.7551089013639 | -122.41308909976601 | (37.7551089013639, -122.413089099766) | |||
| 127157 | 127157 | 104696 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 953 Treat Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 770164 | 6008633.4 | 2103067.0 | 37.7551089013639 | -122.41308909976601 | (37.7551089013639, -122.413089099766) | |||
| 45544 | 45544 | 37548 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 952 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/2003 12:00:00 AM | 13 | Permit Number 39988 | 6008033.82968 | 2115183.28467 | 37.7883436871616 | -122.416020592081 | (37.7883436871616, -122.416020592081) | |
| 65419 | 65419 | 127483 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 952 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6007980.9662 | 2115174.7302099997 | 37.788317226402604 | -122.41620288555401 | (37.7883172264026, -122.416202885554) | |||
| 39752 | 39752 | 224891 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 950 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5997254.06668 | 2107165.46874 | 37.765716883847794 | -122.452737718683 | (37.7657168838478, -122.452737718683) | |||
| 37960 | 37960 | 246672 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 950 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 8ft | 6005247.4068 | 2097710.7023400003 | 37.7402110745895 | -122.42441789747299 | (37.7402110745895, -122.424417897473) | |||
| 48262 | 48262 | 246674 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 950 San Jose Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 8ft | 6005286.18809 | 2097704.16876 | 37.740195324763704 | -122.424283342697 | (37.7401953247637, -122.424283342697) | |||
| 76606 | 76606 | 246675 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 950 San Jose Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 8ft | 6005283.663509999 | 2097689.92499 | 37.7401560720365 | -122.424291058881 | (37.7401560720365, -122.424291058881) | |||
| 132636 | 132636 | 246673 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 950 San Jose Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 8ft | 6005263.852999999 | 2097708.23975 | 37.740205241579396 | -122.424360857976 | (37.7402052415794, -122.424360857976) | |||
| 35255 | 35255 | 190322 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 95 Hawthorne St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6013169.87744 | 2113860.96664 | 37.785000336047794 | -122.398157773768 | (37.7850003360478, -122.398157773768) | |||
| 129748 | 129748 | 190320 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 95 Hawthorne St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6013246.48768 | 2113782.19612 | 37.7847883172678 | -122.397887197434 | (37.7847883172678, -122.397887197434) | |||
| 150839 | 150839 | 190323 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 95 Hawthorne St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6013148.54782 | 2113882.8604200003 | 37.7850592632271 | -122.398233104571 | (37.7850592632271, -122.398233104571) | |||
| 152390 | 152390 | 190321 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 95 Hawthorne St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6013226.39617 | 2113799.41871 | 37.7848344875705 | -122.397957916523 | (37.7848344875705, -122.397957916523) | |||
| 52488 | 52488 | 192103 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 949 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 6010459.9272300005 | 2112762.97095 | 37.7818341846445 | -122.407455947136 | (37.7818341846445, -122.407455947136) | |||
| 61891 | 61891 | 192104 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 949 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 6010477.15217 | 2112780.1699 | 37.7818823730085 | -122.407397569457 | (37.7818823730085, -122.407397569457) | |||
| 20435 | 20435 | 10148 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 948 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 2x3 | 6005665.54475 | 2103435.0734200003 | 37.755952490237206 | -122.423378981771 | (37.7559524902372, -122.423378981771) | |||
| 58783 | 58783 | 30489 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 947 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1956 12:00:00 AM | 16 | Permit Number 149 | 6008994.77228 | 2115613.22786 | 37.78957818743321 | -122.41272628188999 | (37.7895781874332, -122.41272628189) | ||
| 74132 | 74132 | 30490 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 947 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1956 12:00:00 AM | 16 | 3x3 | Permit Number 149 | 6009006.10856 | 2115616.6025799997 | 37.7895880898559 | -122.41268729808 | (37.7895880898559, -122.41268729808) | |
| 135729 | 135729 | 30487 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 947 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1956 12:00:00 AM | 13 | Permit Number 149 | 6008968.98883 | 2115611.75141 | 37.789572686288295 | -122.412815385815 | (37.7895726862883, -122.412815385815) | ||
| 164515 | 164515 | 30488 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 947 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/05/1956 12:00:00 AM | 14 | Permit Number 149 | 6008985.48844 | 2115611.8146900004 | 37.7895737861364 | -122.41275830317 | (37.7895737861364, -122.41275830317) | ||
| 43955 | 43955 | 127801 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 945 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008428.81581 | 2119299.49673 | 37.7996679917499 | -122.414945450765 | (37.7996679917499, -122.414945450765) | |||
| 165613 | 165613 | 127803 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 945 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008464.69057 | 2119301.0779 | 37.79967434904471 | -122.414821422569 | (37.7996743490447, -122.414821422569) | |||
| 186990 | 186990 | 127802 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 945 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008446.28486 | 2119301.06839 | 37.7996732887356 | -122.414885112579 | (37.7996732887356, -122.414885112579) | |||
| 164896 | 164896 | 67369 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 944 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/27/1992 12:00:00 AM | 12 | Permit Number 30862 | 5992616.32068 | 2111401.03119 | 37.7770797658799 | -122.469086822528 | (37.7770797658799, -122.469086822528) | |
| 170694 | 170694 | 124353 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 944 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5992588.76079 | 2111400.8196099997 | 37.777077592480204 | -122.469182144559 | (37.7770775924802, -122.469182144559) | |||
| 15468 | 15468 | 15170 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 941 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6010493.2294 | 2112796.27211 | 37.781927485717794 | -122.407343084927 | (37.7819274857178, -122.407343084927) | |||
| 152187 | 152187 | 225432 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 94 Eureka St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6001376.9754 | 2105319.78515 | 37.7608844730594 | -122.438345256445 | (37.7608844730594, -122.438345256445) | |||
| 54706 | 54706 | 127905 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 937 Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 6ft | 6007996.96181 | 2120271.7748 | 37.8023133475557 | -122.41650873688299 | (37.8023133475557, -122.416508736883) | |||
| 128429 | 128429 | 127904 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 937 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 6ft | 6007970.92827 | 2120270.81905 | 37.802309259211796 | -122.416598758152 | (37.8023092592118, -122.416598758152) | |||
| 26543 | 26543 | 127899 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 935 Chestnut St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6007367.6196099995 | 2120526.83407 | 37.802978263103206 | -122.418704671783 | (37.8029782631032, -122.418704671783) | |||
| 158520 | 158520 | 127900 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 935 Chestnut St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6007384.64005 | 2120530.50291 | 37.80298929507771 | -122.418646032411 | (37.8029892950777, -122.418646032411) | |||
| 58608 | 58608 | 128642 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 932 Montgomery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6011648.98573 | 2118637.28581 | 37.7980301410295 | -122.403755803491 | (37.7980301410295, -122.403755803491) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");