Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, PlantType, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 197 | 197 | 251245 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 701 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/1992 12:00:00 AM | 6002463.96916 | 2095671.24377 | 37.73445361741221 | -122.433896153002 | (37.7344536174122, -122.433896153002) | ||||
| 794 | 794 | 212187 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Bosworth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6002096.28779 | 2095466.30888 | 37.733870041163 | -122.435152693763 | (37.733870041163, -122.435152693763) | ||||
| 796 | 796 | 212189 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Bosworth St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6002068.0773599995 | 2095471.6867 | 37.7338832054473 | -122.435250610137 | (37.7338832054473, -122.435250610137) | ||||
| 797 | 797 | 212191 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Bosworth St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6002043.865019999 | 2095478.6742 | 37.7339010165159 | -122.435334819059 | (37.7339010165159, -122.435334819059) | ||||
| 801 | 801 | 212193 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 720 Bosworth St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 14 | 6002021.19403 | 2095482.3719 | 37.7339098820273 | -122.43541346386002 | (37.7339098820273, -122.43541346386) | ||||
| 810 | 810 | 212202 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 800 Bosworth St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6001677.26505 | 2095571.4535400001 | 37.734134940976 | -122.43660890297501 | (37.734134940976, -122.436608902975) | ||||
| 1277 | 1277 | 212203 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 16 | 6001598.82808 | 2095593.8833700002 | 37.7341920703926 | -122.436881688932 | (37.7341920703926, -122.436881688932) | ||||
| 1307 | 1307 | 212207 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 11 | 6001467.5944 | 2095628.72955 | 37.7342802902926 | -122.43733789885 | (37.7342802902926, -122.43733789885) | ||||
| 2773 | 2773 | 114412 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1345 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6008898.23064 | 2117525.75314 | 37.794824095717395 | -122.413195602999 | (37.7948240957174, -122.413195602999) | ||||
| 2898 | 2898 | 114413 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1345 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 6008903.22514 | 2117506.21986 | 37.7947707425189 | -122.413176939363 | (37.7947707425189, -122.413176939363) | ||||
| 3357 | 3357 | 32073 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3254 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Permit Number 35447 | 5999189.55674 | 2115674.61094 | 37.7891915158244 | -122.44665558658701 | (37.7891915158244, -122.446655586587) | |||
| 3494 | 3494 | 106527 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5999890.2062099995 | 2116153.78918 | 37.7905472114236 | -122.444265881958 | (37.7905472114236, -122.444265881958) | ||||
| 3898 | 3898 | 212122 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Miramar Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5995365.2918 | 2092257.6675200001 | 37.724675368963105 | -122.45819147914699 | (37.7246753689631, -122.458191479147) | ||||
| 4330 | 4330 | 70503 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 193 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/25/1994 12:00:00 AM | 7 | 6004252.47977 | 2092436.6780400001 | 37.725673555265395 | -122.42748232385901 | (37.7256735552654, -122.427482323859) | ||
| 4657 | 4657 | 24332 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1999 12:00:00 AM | 9 | 6006393.27479 | 2112527.98365 | 37.7809605085733 | -122.421508000714 | (37.7809605085733, -122.421508000714) | |||
| 5515 | 5515 | 48743 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 6135 | 6135 | 48746 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 6180 | 6180 | 113748 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 840X Broadway | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6009543.77791 | 2118449.1609099996 | 37.7973957673671 | -122.411027164876 | (37.7973957673671, -122.411027164876) | ||||
| 6477 | 6477 | 113747 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 840X Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2016 12:00:00 AM | 3 | 6009570.41641 | 2118454.8311400004 | 37.7974128301892 | -122.410935389082 | (37.7974128301892, -122.410935389082) | |||
| 6959 | 6959 | 48747 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 7180 | 7180 | 48749 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 7248 | 7248 | 65393 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1345 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/1989 12:00:00 AM | 22 | Permit Number 28235 | 6008898.78625 | 2117545.17326 | 37.7948774497893 | -122.41319505442 | (37.7948774497893, -122.41319505442) | ||
| 8055 | 8055 | 113745 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 840X Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6009609.4912 | 2118458.30583 | 37.797424561837 | -122.410800425125 | (37.797424561837, -122.410800425125) | ||||
| 8095 | 8095 | 50823 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | Permit Number 47344 | |||||||||
| 8773 | 8773 | 48750 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 8939 | 8939 | 48748 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 9025 | 9025 | 48744 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 9805 | 9805 | 57857 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 491 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/1984 12:00:00 AM | 15 | Permit Number 779316 | 5992173.1495199995 | 2112167.2990599996 | 37.7791581122705 | -122.47067570242599 | (37.7791581122705, -122.470675702426) | ||
| 10338 | 10338 | 30354 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1956 12:00:00 AM | Permit Number 43 | |||||||||
| 13566 | 13566 | 48742 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 14417 | 14417 | 48751 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 15356 | 15356 | 54446 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 661 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1972 12:00:00 AM | 30 | Permit Number 10224 | 6014152.690909999 | 2104085.93791 | 37.7582149794585 | -122.394072973006 | (37.7582149794585, -122.394072973006) | ||
| 15637 | 15637 | 48745 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 46023 | ||||||||||
| 15745 | 15745 | 106168 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1052 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6012164.747830001 | 2103476.70855 | 37.7564314799541 | -122.400905383382 | (37.7564314799541, -122.400905383382) | ||||
| 16097 | 16097 | 104813 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 1601X Portola Dr | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 16857 | 16857 | 50824 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2004 12:00:00 AM | Permit Number 47344 | |||||||||
| 18367 | 18367 | 99991 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Clay Montgomery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 44594 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | ||||
| 19062 | 19062 | 50066 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 406 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46794 | 6003569.14495563 | 2105912.6827965 | 37.7626368713078 | -122.430805824209 | (37.7626368713078, -122.430805824209) | ||
| 19247 | 19247 | 106705 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 199X BRIGHTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 5996224.0 | 2090880.0 | 37.7209419254054 | -122.455123542447 | (37.7209419254054, -122.455123542447) | ||||
| 23380 | 23380 | 53997 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 437 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | 27 | Permit Number 9715 | 6012213.68621 | 2086616.7781099998 | 37.7101403551771 | -122.399552462203 | (37.7101403551771, -122.399552462203) | ||
| 23869 | 23869 | 212124 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Miramar Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5995365.62659 | 2092320.18392 | 37.72484704325171 | -122.45819484441999 | (37.7248470432517, -122.45819484442) | ||||
| 23909 | 23909 | 249678 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2400 Baker St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5999727.06015 | 2117202.6736 | 37.7934178626924 | -122.444905786498 | (37.7934178626924, -122.444905786498) | ||||
| 24541 | 24541 | 57383 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1038 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/1976 12:00:00 AM | 20 | Permit Number 16222 | 6008178.637569999 | 2116060.00557 | 37.790759089023 | -122.415581676167 | (37.790759089023, -122.415581676167) | ||
| 25183 | 25183 | 249466 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900x Van Ness Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6006522.49711 | 2113836.87509 | 37.7845616899264 | -122.421153924138 | (37.7845616899264, -122.421153924138) | ||||
| 26114 | 26114 | 61073 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2638 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1983 12:00:00 AM | 20 | Permit Number 20909 | 5999566.78827199 | 2113662.02579548 | 37.783687022959995 | -122.44520566105601 | (37.78368702296, -122.445205661056) | |
| 26476 | 26476 | 212215 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1120 Bosworth St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6001146.22542 | 2095720.4454400002 | 37.73451384602821 | -122.438455541186 | (37.7345138460282, -122.438455541186) | ||||
| 26962 | 26962 | 54655 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 280 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1972 12:00:00 AM | 18 | Permit Number 10479 | 6012382.775359999 | 2087271.8623 | 37.7119485104815 | -122.39901400211201 | (37.7119485104815, -122.399014002112) | ||
| 28874 | 28874 | 218292 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Woodacre Dr | 16 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 39 | 5991223.38049 | 2095418.74528 | 37.73311602796429 | -122.472739784911 | (37.7331160279643, -122.472739784911) | ||||
| 29344 | 29344 | 212243 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 160 Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5998464.243 | 2093227.24787 | 37.7275151923546 | -122.447548599 | (37.7275151923546, -122.447548599) | ||||
| 29736 | 29736 | 100016 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Montgomery St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 6011790.6974 | 2117658.0677 | 37.7953493591435 | -122.403196519624 | (37.7953493591435, -122.403196519624) | ||||
| 30306 | 30306 | 248645 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 701 Church St | 43 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6004348.66213 | 2104681.30747 | 37.7592999422487 | -122.428022000737 | (37.7592999422487, -122.428022000737) | ||||
| 32763 | 32763 | 68295 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 25 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/27/1993 12:00:00 AM | 17 | Permit Number 32104 | 5991131.604780001 | 2114879.69838 | 37.7865453253482 | -122.47447679418 | (37.7865453253482, -122.47447679418) | |
| 33089 | 33089 | 59113 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 672 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 23 | Permit Number 18417 | 5993196.849359999 | 2110897.8448900003 | 37.7757316778167 | -122.46704201709801 | (37.7757316778167, -122.467042017098) | ||
| 33121 | 33121 | 212178 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 610 Bosworth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6002338.16376 | 2095402.39755 | 37.7337082872919 | -122.434311888799 | (37.7337082872919, -122.434311888799) | ||||
| 34298 | 34298 | 102410 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 55X Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6000310.8 | 2109142.0 | 37.7713186232103 | -122.442307075209 | (37.7713186232103, -122.442307075209) | |||||
| 34333 | 34333 | 217817 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1x Junipero Serra Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 5991627.99201 | 2095776.79312 | 37.7341225510202 | -122.47136702736 | (37.7341225510202, -122.47136702736) | ||||
| 35672 | 35672 | 59088 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3426 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 23 | Permit Number 18389 | 5992714.67832 | 2110042.8934299997 | 37.7733563684721 | -122.468647730515 | (37.7733563684721, -122.468647730515) | ||
| 36645 | 36645 | 248794 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 5175 Diamond Heights Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 6000769.8942 | 2099922.22188 | 37.7460295209503 | -122.440057831812 | (37.7460295209503, -122.440057831812) | ||||
| 36736 | 36736 | 205507 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1518 05th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | 5994641.653519999 | 2105137.30281 | 37.7599980266194 | -122.46162636506 | (37.7599980266194, -122.46162636506) | ||||
| 37422 | 37422 | 56296 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 153 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1973 12:00:00 AM | 19 | Permit Number 12428 | 5993949.48549 | 2114460.3201 | 37.7855566873358 | -122.464697232751 | (37.7855566873358, -122.464697232751) | ||
| 37614 | 37614 | 212222 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1120 Bosworth St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6000900.61271 | 2095850.79313 | 37.734857776454504 | -122.43931404390699 | (37.7348577764545, -122.439314043907) | ||||
| 38217 | 38217 | 176045 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5990157.58815 | 2089581.85402 | 37.7170276349961 | -122.475998332672 | (37.7170276349961, -122.475998332672) | ||||
| 38559 | 38559 | 248795 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 5175 Diamond Heights Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 6000777.48804 | 2099988.6184 | 37.746212262280395 | -122.440036333505 | (37.7462122622804, -122.440036333505) | ||||
| 38653 | 38653 | 176017 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6009623.1629099995 | 2089154.9429900001 | 37.7169648982982 | -122.408684805076 | (37.7169648982982, -122.408684805076) | ||||
| 38847 | 38847 | 51264 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 791 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 11 | Permit Number 47641 | 5991632.45779 | 2110058.1497 | 37.773335681454896 | -122.472392358685 | (37.7733356814549, -122.472392358685) | |
| 39338 | 39338 | 248648 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2x Lyell St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 18 | 6002994.42779 | 2095088.08837 | 37.7328824938235 | -122.432020555603 | (37.7328824938235, -122.432020555603) | ||||
| 39371 | 39371 | 37143 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2155 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Permit Number 39724 | 6003778.522480001 | 2115919.83113 | 37.7901258907459 | -122.430795841768 | (37.7901258907459, -122.430795841768) | |||
| 39680 | 39680 | 212217 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1120 Bosworth St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6001121.36826 | 2095728.58105 | 37.734534770568 | -122.438542063178 | (37.734534770568, -122.438542063178) | ||||
| 40493 | 40493 | 53401 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 730 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1969 12:00:00 AM | 19 | Permit Number 6300 | 5990392.09793 | 2110392.4951299997 | 37.774181835613206 | -122.476707321825 | (37.7741818356132, -122.476707321825) | ||
| 40567 | 40567 | 176049 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5989054.79394 | 2089564.29309 | 37.716915411303 | -122.479808833919 | (37.716915411303, -122.479808833919) | ||||
| 40789 | 40789 | 176052 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 5989234.209980001 | 2089407.1197400002 | 37.716494274064495 | -122.47917719598 | (37.7164942740645, -122.47917719598) | ||||
| 42314 | 42314 | 212140 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 602x Miramar Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5995385.5779099995 | 2093583.7848200002 | 37.728317733874704 | -122.458217288803 | (37.7283177338747, -122.458217288803) | ||||
| 43116 | 43116 | 212147 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995390.97132 | 2094022.6530799998 | 37.729523070026104 | -122.458230394627 | (37.7295230700261, -122.458230394627) | ||||
| 43129 | 43129 | 54833 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 601 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1972 12:00:00 AM | 18 | Permit Number 10687 | 5982543.3158 | 2111642.14145 | 37.777154613505395 | -122.50394977664 | (37.7771546135054, -122.50394977664) | ||
| 43585 | 43585 | 212135 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Miramar Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5995377.611959999 | 2093148.71744 | 37.7271226859638 | -122.45821335156201 | (37.7271226859638, -122.458213351562) | ||||
| 43758 | 43758 | 212210 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 920 Bosworth St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | 6001335.34031 | 2095664.21523 | 37.734370206320705 | -122.437797683519 | (37.7343702063207, -122.437797683519) | ||||
| 44066 | 44066 | 57393 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1236 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/1976 12:00:00 AM | 17 | Permit Number 16232 | 6008083.47781 | 2116740.22221 | 37.792621447386104 | -122.415959115337 | (37.7926214473861, -122.415959115337) | ||
| 44314 | 44314 | 126179 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 Marina Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6003111.16889 | 2121419.1431 | 37.8051877435806 | -122.43349799333201 | (37.8051877435806, -122.433497993332) | ||||
| 44431 | 44431 | 100017 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Montgomery St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 6011791.69231 | 2117640.10072 | 37.7953000816886 | -122.40319181257799 | (37.7953000816886, -122.403191812578) | ||||
| 44746 | 44746 | 212150 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700x Miramar Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5995395.95716 | 2094183.25498 | 37.72996433048829 | -122.45822477747 | (37.7299643304883, -122.45822477747) | ||||
| 44875 | 44875 | 32939 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1419 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 26 | Permit Number 37259 | 6013402.96511 | 2105197.8174 | 37.76122625950521 | -122.39674381646999 | (37.7612262595052, -122.39674381647) | |
| 46418 | 46418 | 53581 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 149 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/08/1970 12:00:00 AM | 20 | Permit Number 6509 | 5993949.30457 | 2114483.86823 | 37.7856213336586 | -122.46469956926599 | (37.7856213336586, -122.464699569266) | ||
| 46604 | 46604 | 2135 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 24 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 24 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 47032 | 47032 | 212197 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 820 Bosworth St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6001769.124890001 | 2095547.7255799999 | 37.7340750092381 | -122.436289617596 | (37.7340750092381, -122.436289617596) | ||||
| 47368 | 47368 | 248653 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1001 San Jose Ave | 48 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 6005296.42687 | 2097177.8941099998 | 37.738750871460205 | -122.424210521903 | (37.7387508714602, -122.424210521903) | ||||
| 47950 | 47950 | 176025 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 26 Ervine St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6009634.04356 | 2089276.3567700002 | 37.7172988849001 | -122.408655756084 | (37.7172988849001, -122.408655756084) | ||||
| 48061 | 48061 | 53996 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 409 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1972 12:00:00 AM | 33 | Permit Number 9714 | 6012251.58643 | 2086735.6167099997 | 37.7104687749864 | -122.399429808164 | (37.7104687749864, -122.399429808164) | ||
| 48270 | 48270 | 212154 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Miramar Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5995400.46902 | 2094347.10151 | 37.7304144726506 | -122.458221033597 | (37.7304144726506, -122.458221033597) | ||||
| 48651 | 48651 | 212130 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Miramar Ave | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 5995375.50202 | 2092861.84028 | 37.726334869051705 | -122.458199891406 | (37.7263348690517, -122.458199891406) | ||||
| 49017 | 49017 | 100015 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Montgomery St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 6011789.640790001 | 2117672.98825 | 37.795390268386 | -122.403201225768 | (37.795390268386, -122.403201225768) | ||||
| 49060 | 49060 | 212149 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700x Miramar Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995397.3757 | 2094149.6680599998 | 37.7298721904459 | -122.45821744347602 | (37.7298721904459, -122.458217443476) | ||||
| 49451 | 49451 | 54596 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 614 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1972 12:00:00 AM | 19 | Permit Number 10419 | 6014083.5952699995 | 2104262.66421 | 37.758696391053206 | -122.394324311034 | (37.7586963910532, -122.394324311034) | ||
| 49454 | 49454 | 34585 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2201 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | 19 | Permit Number 38286 | 5999325.9998 | 2116419.19935 | 37.7912437525454 | -122.446237095163 | (37.7912437525454, -122.446237095163) | ||
| 49572 | 49572 | 189393 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 24th St | 15 | : Yard 23 | Tree 1 | Private 1 | 10 | 6017282.75412 | 2102644.41979 | 37.7544303427117 | -122.38314741343201 | (37.7544303427117, -122.383147413432) | ||||
| 49696 | 49696 | 248657 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000 San Jose Ave | 111 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6005025.16759 | 2096929.69692 | 37.7380540578596 | -122.425130754104 | (37.7380540578596, -122.425130754104) | ||||
| 50835 | 50835 | 212136 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Miramar Ave | 9 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 5995379.948 | 2093237.13475 | 37.7273655928402 | -122.458211672546 | (37.7273655928402, -122.458211672546) | ||||
| 51115 | 51115 | 99989 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Clay Montgomery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Permit Number 44594 | 6011816.528390001 | 2117490.26365 | 37.794890051993896 | -122.40309533059099 | (37.7948900519939, -122.403095330591) | |||
| 51327 | 51327 | 97306 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 47 Kittredge Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997949.8 | 2111441.7 | 37.777498158560796 | -122.450639669067 | (37.7774981585608, -122.450639669067) | |||||
| 52129 | 52129 | 54126 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 415 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1972 12:00:00 AM | 16 | Permit Number 9859 | 6012243.80314 | 2086705.1932599999 | 37.7103848043898 | -122.39945457456301 | (37.7103848043898, -122.399454574563) | ||
| 52253 | 52253 | 247575 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 350x Alemany Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6008404.3383 | 2095155.19461 | 37.7333719741436 | -122.413321789588 | (37.7333719741436, -122.413321789588) |
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");