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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8293 | 8293 | 24315 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006566.6125300005 | 2112551.64159 | 37.781035239531704 | -122.420910018978 | (37.7810352395317, -122.420910018978) | |||
| 8305 | 8305 | 24325 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 33 | 3X3 | 6006278.38926 | 2112509.01094 | 37.7809019357225 | -122.42190409898998 | (37.7809019357225, -122.42190409899) | |||
| 8309 | 8309 | 22576 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006347.61377 | 2112822.4191900003 | 37.7817663820541 | -122.421686883966 | (37.7817663820541, -122.421686883966) | |||
| 8318 | 8318 | 24321 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006368.77272 | 2112521.86674 | 37.7809423314653 | -122.42159233103999 | (37.7809423314653, -122.42159233104) | |||
| 8440 | 8440 | 19006 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3067 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000132.745080001 | 2115433.98205 | 37.7885846434091 | -122.443374990159 | (37.7885846434091, -122.443374990159) | |||
| 8642 | 8642 | 22574 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006283.90302 | 2112813.42944 | 37.7817381055674 | -122.421906654863 | (37.7817381055674, -122.421906654863) | |||
| 8650 | 8650 | 7811 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006219.73405 | 2112674.25147 | 37.7813523377843 | -122.422118759068 | (37.7813523377843, -122.422118759068) | |||
| 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 | ||||||||||
| 8791 | 8791 | 117119 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 447 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 5x9 | Permit Number 778563 | 5997182.09338 | 2114812.8648 | 37.78671051561479 | -122.45353887881001 | (37.7867105156148, -122.45353887881) | |
| 8925 | 8925 | 22575 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006314.95978 | 2112814.99848 | 37.7817441651975 | -122.42179932438499 | (37.7817441651975, -122.421799324385) | |||
| 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 | ||||||||||
| 9022 | 9022 | 105217 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5999896.62594 | 2116125.07257 | 37.7904687293982 | -122.44424160568998 | (37.7904687293982, -122.44424160569) | |||
| 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 | ||||||||||
| 9050 | 9050 | 1999 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 217 Bocana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 38 | 3X3 | 6007148.9837828 | 2097704.1672577998 | 37.7403003295941 | -122.417842531543 | (37.7403003295941, -122.417842531543) | |||
| 9075 | 9075 | 17962 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2507 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6001946.9790368 | 2114981.8697349 | 37.7874465501899 | -122.437065644028 | (37.7874465501899, -122.437065644028) | |||
| 9093 | 9093 | 12590 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 521 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2008 12:00:00 AM | 11 | 4x4 | 5993790.57771 | 2114837.48993 | 37.786583130222 | -122.465274409298 | (37.786583130222, -122.465274409298) | ||
| 9127 | 9127 | 12154 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016226.76201 | 2095667.61701 | 37.735215066832104 | -122.386312951947 | (37.7352150668321, -122.386312951947) | |||
| 9140 | 9140 | 12661 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1045 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 4X4 | 5992178.70595 | 2114775.57253 | 37.786320036254004 | -122.47084652786002 | (37.786320036254, -122.47084652786) | |||
| 9163 | 9163 | 17982 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2578 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6001610.4943389995 | 2114985.9919613 | 37.7874387369759 | -122.43823010545499 | (37.7874387369759, -122.438230105455) | |||
| 9177 | 9177 | 10667 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1021 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6002954.21433 | 2110590.33753 | 37.7754457061984 | -122.43326690297701 | (37.7754457061984, -122.433266902977) | |||
| 9233 | 9233 | 25445 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 40 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 6016123.98501 | 2095766.22901 | 37.735480146065505 | -122.386675167071 | (37.7354801460655, -122.386675167071) | |||
| 9275 | 9275 | 9356 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 241 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 100 | 3X3 | 6000999.4900667 | 2098404.1035626 | 37.74187419547079 | -122.43915513344 | (37.7418741954708, -122.43915513344) | |||
| 9286 | 9286 | 4816 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 50X Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 11x5 | 6005990.1672425 | 2097819.1039723 | 37.7405506369184 | -122.421857425384 | (37.7405506369184, -122.421857425384) | |||
| 9297 | 9297 | 5763 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 401 Duboce Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6004052.45174 | 2108353.78487 | 37.7693669201086 | -122.429308319494 | (37.7693669201086, -122.429308319494) | |||
| 9301 | 9301 | 28308 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 244X CORTLAND AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6006809.0 | 2097383.0 | 37.739399336612 | -122.418995288624 | (37.739399336612, -122.418995288624) | |||
| 9314 | 9314 | 12158 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016158.70701 | 2095735.6730099998 | 37.735398167686206 | -122.38655298897699 | (37.7353981676862, -122.386552988977) | |||
| 9353 | 9353 | 12157 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016176.76201 | 2095719.00601 | 37.73535340295211 | -122.386489403775 | (37.7353534029521, -122.386489403775) | |||
| 9420 | 9420 | 12628 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 840 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 5992820.04588 | 2114852.30881 | 37.786567801977796 | -122.46863326133999 | (37.7865678019778, -122.46863326134) | |||
| 9423 | 9423 | 17963 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2507 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6001946.9790368 | 2114981.8697349 | 37.7874465501899 | -122.437065644028 | (37.7874465501899, -122.437065644028) | |||
| 9450 | 9450 | 19167 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 95 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003517.6175946 | 2107764.5447227 | 37.767718716857 | -122.43111622226601 | (37.767718716857, -122.431116222266) | |||
| 9455 | 9455 | 17964 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2507 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6001946.9790368 | 2114981.8697349 | 37.7874465501899 | -122.437065644028 | (37.7874465501899, -122.437065644028) | |||
| 9472 | 9472 | 12156 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016192.73501 | 2095700.95101 | 37.7353047117642 | -122.386432920212 | (37.7353047117642, -122.386432920212) | |||
| 9558 | 9558 | 122158 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 515 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 6ft | 5991239.57046 | 2111867.63351 | 37.7782812827035 | -122.47388343446801 | (37.7782812827035, -122.473883434468) | |||
| 9570 | 9570 | 16824 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2139X O'Farrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6001076.0 | 2113135.0 | 37.7823259746064 | -122.439946572306 | (37.7823259746064, -122.439946572306) | |||
| 9609 | 9609 | 97058 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 506 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 5991284.01792 | 2111924.69862 | 37.7784405421859 | -122.473733839825 | (37.7784405421859, -122.473733839825) | |||
| 9706 | 9706 | 5132 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2787 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 55 | 5X5 | 6002542.444802401 | 2095842.6422614 | 37.734928691439706 | -122.433637082687 | (37.7349286914397, -122.433637082687) | |||
| 9760 | 9760 | 2247 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 21 Brompton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002207.695280001 | 2095600.7924099998 | 37.734245627727 | -122.434777138659 | (37.734245627727, -122.434777138659) | |||
| 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) | ||
| 9864 | 9864 | 173715 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 4143 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x9 | 6002772.0 | 2104111.0 | 37.7576446879549 | -122.43343410325701 | (37.7576446879549, -122.433434103257) | ||||
| 9958 | 9958 | 19162 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 85 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003517.76355 | 2107824.4837 | 37.7678833029889 | -122.431119996093 | (37.7678833029889, -122.431119996093) | |||
| 10109 | 10109 | 114554 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1200x 43RD AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5982778.0 | 2106905.0 | 37.764161588502795 | -122.50278719613199 | (37.7641615885028, -122.502787196132) | ||||
| 10143 | 10143 | 58653 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1041 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1979 12:00:00 AM | 3x3 | Permit Number 17875 | 5997239.92048014 | 2106921.18918515 | 37.7650453439116 | -122.45276901450501 | (37.7650453439116, -122.452769014505) | ||
| 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 | |||||||||
| 10466 | 10466 | 1196 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3080 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/1992 12:00:00 AM | 28 | 3X3 | 5996438.01379 | 2087205.1874 | 37.7108640234246 | -122.45411848649799 | (37.7108640234246, -122.454118486498) | ||
| 10580 | 10580 | 1280 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5992520.10718 | 2087379.1823 | 37.71111633361279 | -122.467672210425 | (37.7111163336128, -122.467672210425) | |||
| 10644 | 10644 | 1838 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2201X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6011226.77764 | 2087216.18178 | 37.71173113716571 | -122.403005565662 | (37.7117311371657, -122.403005565662) | |||
| 10647 | 10647 | 19755 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY15 | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | ||||||||
| 10725 | 10725 | 941 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1352 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 5x5 | 6002586.79672 | 2094029.0615 | 37.7299515286195 | -122.43335418993799 | (37.7299515286195, -122.433354189938) | |||
| 10914 | 10914 | 104429 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 390 Wilde Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | 6010684.070780001 | 2089238.8941400002 | 37.7172547740586 | -122.405023648815 | (37.7172547740586, -122.405023648815) | |||
| 11180 | 11180 | 103669 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 20 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/2016 12:00:00 AM | 3 | 3x3 | 6010632.36965 | 2089377.76421 | 37.717633192597205 | -122.40521212966298 | (37.7176331925972, -122.405212129663) | ||
| 11364 | 11364 | 1271 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992356.50735 | 2087300.8185599998 | 37.7108917180496 | -122.468231949349 | (37.7108917180496, -122.468231949349) | |||
| 11884 | 11884 | 1270 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5992245.7583099995 | 2087252.3125599998 | 37.7107521351809 | -122.46861119345101 | (37.7107521351809, -122.468611193451) | |||
| 12454 | 12454 | 1277 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992498.771269999 | 2087369.1133 | 37.7110874546035 | -122.46774522006099 | (37.7110874546035, -122.467745220061) | |||
| 12526 | 12526 | 104428 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 390 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 4x4 | 6010699.78768 | 2089233.16834 | 37.7172399307634 | -122.404968919684 | (37.7172399307634, -122.404968919684) | |||
| 12581 | 12581 | 1281 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992683.69403 | 2087456.96265 | 37.7113393439098 | -122.46711247059099 | (37.7113393439098, -122.467112470591) | |||
| 13079 | 13079 | 1273 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | Permit Number 771193 | 5992398.03069 | 2087322.1494900002 | 37.710952685801104 | -122.46808998688499 | (37.7109526858011, -122.468089986885) | ||
| 13163 | 13163 | 1267 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 3995X Alemany Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5992203.06147 | 2087231.00688 | 37.710691168335096 | -122.468757212784 | (37.7106911683351, -122.468757212784) | |||
| 13264 | 13264 | 187632 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 268 Sadowa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994314.0 | 2087800.0 | 37.7123752149716 | -122.461502613047 | (37.7123752149716, -122.461502613047) | ||||
| 13410 | 13410 | 14990 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Mendell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016422.4428900005 | 2097376.45794 | 37.7399180286864 | -122.385755471644 | (37.7399180286864, -122.385755471644) | |||
| 13443 | 13443 | 14968 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016667.040519999 | 2097697.80462 | 37.7408139135396 | -122.384932128834 | (37.7408139135396, -122.384932128834) | |||
| 13495 | 13495 | 14948 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016767.4558 | 2097838.85848 | 37.7412067724716 | -122.384594749942 | (37.7412067724716, -122.384594749942) | |||
| 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 | ||||||||||
| 13625 | 13625 | 14933 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016941.57525 | 2098184.84614 | 37.7421664120423 | -122.384016788063 | (37.7421664120423, -122.384016788063) | |||
| 13725 | 13725 | 14972 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016621.68773 | 2097636.5481 | 37.740643206920204 | -122.385084676324 | (37.7406432069202, -122.385084676324) | |||
| 13778 | 13778 | 26456 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 401X Keith St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/13/1997 12:00:00 AM | 6 | 3x3 | 6017743.988609999 | 2096808.9329900001 | 37.7384327587528 | -122.381146620635 | (37.7384327587528, -122.381146620635) | ||
| 13789 | 13789 | 14992 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Mendell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016399.93011 | 2097341.84893 | 37.739821753578504 | -122.385830900501 | (37.7398217535785, -122.385830900501) | |||
| 13826 | 13826 | 26458 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 401X Keith St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017771.22225 | 2096841.3441599999 | 37.738523256636896 | -122.381054711725 | (37.7385232566369, -122.381054711725) | |||
| 13834 | 13834 | 14938 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016907.69513 | 2098053.9241400003 | 37.741805053675 | -122.38412482092501 | (37.741805053675, -122.384124820925) | |||
| 13861 | 13861 | 12127 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6016490.26403 | 2095091.74303 | 37.733648414028295 | -122.385361804207 | (37.7336484140283, -122.385361804207) | |||
| 13902 | 13902 | 14887 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 151 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2006 12:00:00 AM | 3 | 3x3 | 6017068.53164 | 2098456.8281 | 37.7429202372855 | -122.38359673900699 | (37.7429202372855, -122.383596739007) | ||
| 13922 | 13922 | 14989 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6016436.5067300005 | 2097390.6567700002 | 37.7399577940171 | -122.38570783365101 | (37.7399577940171, -122.385707833651) | |||
| 14055 | 14055 | 102316 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2325 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x6 | 6010512.04072 | 2105967.73717 | 37.763178958366396 | -122.406796606491 | (37.7631789583664, -122.406796606491) | |||
| 14130 | 14130 | 12150 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/17/1996 12:00:00 AM | 2 | 3X3 | 6016234.16268 | 2095665.57813 | 37.735209878118 | -122.386287222793 | (37.735209878118, -122.386287222793) | ||
| 14260 | 14260 | 14934 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016937.56123 | 2098168.30957 | 37.742120784060795 | -122.38402951616301 | (37.7421207840608, -122.384029516163) | |||
| 14289 | 14289 | 102315 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2325 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x6 | 6010497.0299 | 2105967.33167 | 37.7631770050447 | -122.40684849557199 | (37.7631770050447, -122.406848495572) | |||
| 14350 | 14350 | 12152 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/17/1996 12:00:00 AM | 6 | 3X3 | 6016198.01461 | 2095698.1267099997 | 37.7352972490591 | -122.386414469663 | (37.7352972490591, -122.386414469663) | ||
| 14352 | 14352 | 14936 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016920.64099 | 2098083.60989 | 37.7418872804668 | -122.38408212471201 | (37.7418872804668, -122.384082124712) | |||
| 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 | ||||||||||
| 14459 | 14459 | 14937 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016913.42346 | 2098066.4048200003 | 37.741839639797504 | -122.384105882978 | (37.7418396397975, -122.384105882978) | |||
| 14499 | 14499 | 35359 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 917 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 28 | 6x6 | Permit Number 38821 | 6011905.65469 | 2104108.25722 | 37.758151117709104 | -122.40184581615 | (37.7581511177091, -122.40184581615) |
| 14530 | 14530 | 12145 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6016306.3498599995 | 2095580.8792299998 | 37.734981307347205 | -122.386031740688 | (37.7349813073472, -122.386031740688) | |||
| 14566 | 14566 | 14942 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016868.17311 | 2097974.63279 | 37.7415851505377 | -122.38425595555401 | (37.7415851505377, -122.384255955554) | |||
| 14766 | 14766 | 12139 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1996 12:00:00 AM | 6 | 3X3 | 6016385.33586 | 2095408.8215700001 | 37.7345132425897 | -122.385746667286 | (37.7345132425897, -122.385746667286) | ||
| 14800 | 14800 | 12153 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016182.90625 | 2095712.9210700002 | 37.7353370350581 | -122.386467736523 | (37.7353370350581, -122.386467736523) | |||
| 15037 | 15037 | 14946 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016823.8175 | 2097912.1941299997 | 37.741411254039 | -122.38440497592899 | (37.741411254039, -122.384404975929) | |||
| 15253 | 15253 | 14890 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 151 Mendell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017084.252730001 | 2098515.6728 | 37.743082681818294 | -122.383546475015 | (37.7430826818183, -122.383546475015) | |||
| 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) | ||
| 15452 | 15452 | 12142 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1996 12:00:00 AM | 3 | 3X3 | 6016364.0707 | 2095472.0382700001 | 37.734685646232 | -122.385824593536 | (37.734685646232, -122.385824593536) | ||
| 15460 | 15460 | 14875 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 50 Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017137.53448 | 2098765.92965 | 37.7437727810994 | -122.383379656173 | (37.7437727810994, -122.383379656173) | |||
| 15463 | 15463 | 14991 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Mendell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016409.43425 | 2097357.66427 | 37.739865705229505 | -122.38579914093201 | (37.7398657052295, -122.385799140932) | |||
| 15486 | 15486 | 14943 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 200X Mendell St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016856.6474 | 2097956.20405 | 37.7415339116704 | -122.38429452477101 | (37.7415339116704, -122.384294524771) | |||
| 15558 | 15558 | 14894 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 151 Mendell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 3 | 3x3 | 6017116.82626 | 2098595.36732 | 37.743303307108704 | -122.38343939001899 | (37.7433033071087, -122.383439390019) | ||
| 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 | ||||||||||
| 15647 | 15647 | 26457 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 401X Keith St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/13/1997 12:00:00 AM | 6 | 3x3 | 6017757.31102 | 2096823.45757 | 37.7384733757484 | -122.381101567303 | (37.7384733757484, -122.381101567303) | ||
| 15691 | 15691 | 11881 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Keith St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6017730.140319999 | 2096877.36865 | 37.7386199049771 | -122.381199258841 | (37.7386199049771, -122.381199258841) | |||
| 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) | ||||
| 15813 | 15813 | 14969 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 400X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3x3 | 6016654.44168 | 2097681.89431 | 37.7407695301847 | -122.38497458311501 | (37.7407695301847, -122.384974583115) | |||
| 15841 | 15841 | 12149 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016248.95724 | 2095649.3696400002 | 37.735166191751 | -122.38623494249399 | (37.735166191751, -122.386234942494) | |||
| 16015 | 16015 | 12144 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6016321.20053 | 2095553.30546 | 37.734906417192704 | -122.38597847472201 | (37.7349064171927, -122.385978474722) | |||
| 16035 | 16035 | 54185 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1526 Kirkwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/19/1972 12:00:00 AM | 30 | 4x4 | Permit Number 9920 | 6015598.37895 | 2096494.31778 | 37.7374502170542 | -122.388543207207 | (37.7374502170542, -122.388543207207) |
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");