Data source: data.sfgov.org
This data as json, CSV (advanced)
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | ||||
| 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) | ||
| 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) | |||||
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||||
| 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) | ||
| 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) | ||
| 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) | ||||
| 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) | ||
| 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) | ||
| 52835 | 52835 | 75161 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1500X Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/25/1989 12:00:00 AM | 15 | 6005585.43876 | 2119632.07302 | 37.80042097699361 | -122.42480825631 | (37.8004209769936, -122.42480825631) | ||
| 53623 | 53623 | 66064 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 612 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/06/1990 12:00:00 AM | 14 | Permit Number 29104 | 6013245.790080001 | 2104237.6601 | 37.7585811285267 | -122.397220091143 | (37.7585811285267, -122.397220091143) | |
| 55017 | 55017 | 54653 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 274 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/1972 12:00:00 AM | 16 | Permit Number 10477 | 6012392.2248 | 2087295.07392 | 37.7120127715543 | -122.39898297010299 | (37.7120127715543, -122.398982970103) | ||
| 55703 | 55703 | 99995 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Clay Montgomery St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Permit Number 44594 | 6011799.6511699995 | 2117580.00293 | 37.795135512041995 | -122.403160044009 | (37.795135512042, -122.403160044009) | |||
| 59209 | 59209 | 33675 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 469 Ivy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/03/2001 12:00:00 AM | 13 | Permit Number 37757 | 6005116.23557125 | 2111084.96150687 | 37.7769262359606 | -122.425823168919 | (37.7769262359606, -122.425823168919) | |
| 60605 | 60605 | 51265 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 791 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/2004 12:00:00 AM | 14 | Permit Number 47641 | 5991632.71365 | 2110039.2533299997 | 37.7732838119525 | -122.472390095818 | (37.7732838119525, -122.472390095818) | |
| 63415 | 63415 | 33467 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 72 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/1996 12:00:00 AM | Permit Number 37623 | 6006783.56593714 | 2099291.50343979 | 37.744638227793395 | -122.419218573599 | (37.7446382277934, -122.419218573599) | ||
| 65606 | 65606 | 58791 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 505 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/1992 12:00:00 AM | 15 | Permit Number 30381 | 6012232.54216 | 2117604.48195 | 37.7952268912538 | -122.40166388690099 | (37.7952268912538, -122.401663886901) | ||
| 65725 | 65725 | 99970 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2270 Folsom St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007986.9 | 2105322.2 | 37.761264849910205 | -122.415484545241 | (37.7612648499102, -122.415484545241) | |||||
| 66741 | 66741 | 50805 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1498 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2004 12:00:00 AM | Permit Number 47329 | 6000596.76427703 | 2111027.41746177 | 37.7765117981927 | -122.441453229456 | (37.7765117981927, -122.441453229456) | |||
| 67931 | 67931 | 32978 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 570 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 29 | Permit Number 37291 | 6014355.15854 | 2104463.2818299998 | 37.759262335300996 | -122.39339915324601 | (37.759262335301, -122.393399153246) | |
| 68692 | 68692 | 59156 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 724 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1980 12:00:00 AM | 21 | Permit Number 18465 | 5993208.37426 | 2110527.44532 | 37.7747153253036 | -122.466975215661 | (37.7747153253036, -122.466975215661) | ||
| 69234 | 69234 | 57994 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1582 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1983 12:00:00 AM | 16 | Permit Number 20710 | 6008213.2287 | 2108904.5033 | 37.7711137407294 | -122.41495532360099 | (37.7711137407294, -122.414955323601) | ||
| 69502 | 69502 | 106886 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 580 Commercial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2014 12:00:00 AM | 3 | Permit Number 772874 | 6011893.85928 | 2117261.69096 | 37.7942667642387 | -122.402811670039 | (37.7942667642387, -122.402811670039) | ||
| 71048 | 71048 | 54432 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 330 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1972 12:00:00 AM | 12 | Permit Number 10209 | 6014015.38229 | 2105524.69697 | 37.76215786632 | -122.39464860115801 | (37.76215786632, -122.394648601158) | ||
| 71291 | 71291 | 31404 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 4249 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1995 12:00:00 AM | 14 | Permit Number 34995 | 6002129.55776 | 2104097.73636 | 37.75757179961771 | -122.43565497859 | (37.7575717996177, -122.43565497859) | ||
| 72119 | 72119 | 54132 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 461 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1972 12:00:00 AM | 24 | Permit Number 9865 | 6012176.495490001 | 2086499.28373 | 37.7098156657361 | -122.3996727573 | (37.7098156657361, -122.3996727573) | ||
| 72582 | 72582 | 34885 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1539 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 38493 | 6002855.27225509 | 2121286.11305956 | 37.804807956300394 | -122.43437403696699 | (37.8048079563004, -122.434374036967) | ||||
| 76127 | 76127 | 50574 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2295 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194.0 | 2105070.0 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | ||
| 76246 | 76246 | 67886 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 554 Commercial St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/1993 12:00:00 AM | 16 | Permit Number 31581 | 6012025.247219999 | 2117281.36529 | 37.794328120508105 | -122.402358434194 | (37.7943281205081, -122.402358434194) | ||
| 76986 | 76986 | 59078 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 626 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1980 12:00:00 AM | 34 | Permit Number 18378 | 5993651.88803 | 2110754.40375 | 37.775364081352 | -122.46545751469 | (37.775364081352, -122.46545751469) | ||
| 77327 | 77327 | 33952 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Arbor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/09/1997 12:00:00 AM | Permit Number 37910 | 6002287.323724099 | 2097040.91143479 | 37.7382043832783 | -122.43460477820899 | (37.7382043832783, -122.434604778209) | |||
| 77439 | 77439 | 33533 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 185 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37643 | 6007275.34853053 | 2097937.54990535 | 37.7409482571652 | -122.41742214701401 | (37.7409482571652, -122.417422147014) | |||
| 77484 | 77484 | 97635 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1254 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008163.0 | 2117572.0 | 37.794909774633105 | -122.415742887246 | (37.7949097746331, -122.415742887246) | |||||
| 77699 | 77699 | 50634 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2900 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/2004 12:00:00 AM | Permit Number 47740 | 6014120.76360854 | 2090918.26429059 | 37.722057508368394 | -122.39326197707399 | (37.7220575083684, -122.393261977074) | ||
| 77841 | 77841 | 24330 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 601X Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 6006691.6523257 | 2112520.4868544 | 37.7809567435024 | -122.420475231256 | (37.7809567435024, -122.420475231256) | ||||
| 77978 | 77978 | 50685 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 915 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47258 | 5999168.89515798 | 2107036.01925898 | 37.765470983210896 | -122.44610545370399 | (37.7654709832109, -122.446105453704) | ||||
| 78017 | 78017 | 99966 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2270 Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007986.9 | 2105322.2 | 37.761264849910205 | -122.415484545241 | (37.7612648499102, -122.415484545241) | |||||
| 78022 | 78022 | 50314 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1055 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2003 12:00:00 AM | Permit Number 47021 | 6005825.34130744 | 2113438.50468071 | 37.783428536862395 | -122.42353751818999 | (37.7834285368624, -122.42353751819) | |||
| 78069 | 78069 | 51559 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 29 West Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47854 | 5988768.43262818 | 2115023.56671426 | 37.7868031451511 | -122.48266323691001 | (37.7868031451511, -122.48266323691) | ||||
| 78254 | 78254 | 100023 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Montgomery St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | |||||
| 78551 | 78551 | 38221 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 140 Chester Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/1998 12:00:00 AM | Permit Number 40348 | 5991708.17687703 | 2088279.9583595002 | 37.7135427330302 | -122.470543976889 | (37.7135427330302, -122.470543976889) | |||
| 78924 | 78924 | 41636 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 727 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2000 12:00:00 AM | Permit Number 42114 | 6002231.96646512 | 2108774.97906552 | 37.7704201835081 | -122.43563542227899 | (37.7704201835081, -122.435635422279) | |||
| 79856 | 79856 | 51669 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 852@ DIAMOND Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2005 12:00:00 AM | Permit Number 47947 | 6001771.23876172 | 2095874.53487777 | 37.734972472287104 | -122.43630569021099 | (37.7349724722871, -122.436305690211) | |||
| 79986 | 79986 | 49370 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 470 REVISED West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2003 12:00:00 AM | Permit Number 46343 | 5991620.22800025 | 2096213.28684732 | 37.735320603541204 | -122.471425664133 | (37.7353206035412, -122.471425664133) | |||
| 80226 | 80226 | 99208 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 Hahn St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 768718 | 6007772.4 | 2088271.5 | 37.7144353163031 | -122.415019520784 | (37.7144353163031, -122.415019520784) | ||||
| 80267 | 80267 | 107218 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 WINSTON DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 42 | 5990934.3 | 2093194.2 | 37.7269912477326 | -122.47357699184799 | (37.7269912477326, -122.473576991848) | ||||
| 80381 | 80381 | 100004 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600@Washington St Montgomery St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | |||||
| 80480 | 80480 | 100029 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Montgomery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011817.0 | 2117412.0 | 37.7946751850939 | -122.403088191063 | (37.7946751850939, -122.403088191063) | |||||
| 80750 | 80750 | 99968 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2270 Folsom St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6007986.9 | 2105322.2 | 37.761264849910205 | -122.415484545241 | (37.7612648499102, -122.415484545241) | |||||
| 80769 | 80769 | 107162 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 798X 07TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5993812.0 | 2110401.0 | 37.7744029620428 | -122.464877983618 | (37.7744029620428, -122.464877983618) | |||||
| 80970 | 80970 | 33511 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 30 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/1996 12:00:00 AM | Permit Number 37606 | 6006939.76943127 | 2099579.03687854 | 37.7454365257217 | -122.41869883835899 | (37.7454365257217, -122.418698838359) | |||
| 80978 | 80978 | 94439 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 598 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5998670.0 | 2105688.0 | 37.7617411583254 | -122.447733959945 | (37.7617411583254, -122.447733959945) | |||||
| 80983 | 80983 | 50445 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1458 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47092 | 5999576.80908785 | 2109151.13897488 | 37.7713018555978 | -122.44484663077499 | (37.7713018555978, -122.444846630775) | ||||
| 81000 | 81000 | 57042 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 201@ Page Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/1974 12:00:00 AM | Permit Number 14305. Tree 1 on Page St | 5999842.06289616 | 2109172.2578569 | 37.7713749769665 | -122.44393062683201 | (37.7713749769665, -122.443930626832) |
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");