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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6777 | 6777 | 26162 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 220 Richardson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999090.095480001 | 2119848.96049 | 37.800647486559704 | -122.447300272802 | (37.8006474865597, -122.447300272802) | |||
| 6785 | 6785 | 24317 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006479.1525 | 2112537.25416 | 37.7809908049215 | -122.421211565287 | (37.7809908049215, -122.421211565287) | |||
| 6948 | 6948 | 20002 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY46 | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2 | ||||||||
| 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 | ||||||||||
| 7016 | 7016 | 22573 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006249.787140001 | 2112806.77447 | 37.781717908586295 | -122.422024207046 | (37.7817179085863, -122.422024207046) | |||
| 7149 | 7149 | 23486 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6005800.3407 | 2119014.80575 | 37.7987382537111 | -122.424020688524 | (37.7987382537111, -122.424020688524) | |||
| 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 | ||||||||||
| 7212 | 7212 | 6169 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1075 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/2009 12:00:00 AM | 3 | 3x3 | 6005763.6544 | 2113429.69831 | 37.7834008746955 | -122.423750304634 | (37.7834008746955, -122.423750304634) | ||
| 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) | ||
| 7319 | 7319 | 98048 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2251 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6003429.10066 | 2116873.98532 | 37.7927259513035 | -122.432072977999 | (37.7927259513035, -122.432072977999) | |||
| 7445 | 7445 | 99167 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 25928 | 6003331.11107 | 2115984.74946 | 37.7902787808939 | -122.432348487091 | (37.7902787808939, -122.432348487091) | ||
| 7447 | 7447 | 23391 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1500X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 06/09/2005 12:00:00 AM | 6 | 9 | 6006253.0985199995 | 2115767.98121 | 37.789848839288 | -122.422223199151 | (37.789848839288, -122.422223199151) | ||
| 7696 | 7696 | 19998 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY46 | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | ||||||||
| 7734 | 7734 | 24324 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 600X Golden Gate Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006305.76929 | 2112511.39113 | 37.7809100152295 | -122.421809546989 | (37.7809100152295, -122.421809546989) | |||
| 7803 | 7803 | 98047 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2251 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6003407.78151 | 2116869.84399 | 37.7927133715759 | -122.43214644721901 | (37.7927133715759, -122.432146447219) | |||
| 7840 | 7840 | 19005 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3067 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000119.97054 | 2115432.29592 | 37.788579285248495 | -122.443419066834 | (37.7885792852485, -122.443419066834) | |||
| 7871 | 7871 | 9429 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 727 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005901.79421 | 2112405.20993 | 37.7805956778943 | -122.423199547232 | (37.7805956778943, -122.423199547232) | |||
| 7904 | 7904 | 23169 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 202X Van Ness Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006882.10264 | 2111252.84384 | 37.777486833097896 | -122.419726396954 | (37.7774868330979, -122.419726396954) | |||
| 7920 | 7920 | 98924 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 3527 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 5997977.38318 | 2115131.5705 | 37.7876311543002 | -122.45081036719999 | (37.7876311543002, -122.4508103672) | |||
| 7982 | 7982 | 99166 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | Permit Number 25928 | 6003335.0360900005 | 2115969.1620099996 | 37.7902362042855 | -122.43233379308701 | (37.7902362042855, -122.432333793087) | ||
| 8048 | 8048 | 23233 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Van Ness Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006624.19189 | 2113053.59601 | 37.782416729491 | -122.42074646829799 | (37.782416729491, -122.420746468298) | |||
| 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 | |||||||||
| 8251 | 8251 | 22580 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006453.23929 | 2112834.51188 | 37.7818055412449 | -122.42132232756 | (37.7818055412449, -122.42132232756) | |||
| 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) | |||
| 8553 | 8553 | 23232 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006628.60579 | 2113016.72655 | 37.7823157437221 | -122.42072857987301 | (37.7823157437221, -122.420728579873) | |||
| 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) | |||
| 8649 | 8649 | 23408 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1748X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006154.759930001 | 2116452.2699700003 | 37.7917221783851 | -122.42261208848801 | (37.7917221783851, -122.422612088488) | |||
| 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) | |||
| 9474 | 9474 | 173600 | Property Tree 7 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Clarendon Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5996184.0 | 2102497.0 | 37.7528370823128 | -122.45610127186899 | (37.7528370823128, -122.456101271869) | ||||
| 9497 | 9497 | 122159 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 547 15th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 4ft | 5991246.192840001 | 2111684.05416 | 37.7777776077222 | -122.473847129053 | (37.7777776077222, -122.473847129053) | |||
| 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) | |||
| 9682 | 9682 | 13402 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 Marietta Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 0 | 5x10 | 5999116.0 | 2097588.0 | 37.7395260150228 | -122.445608931545 | (37.7395260150228, -122.445608931545) | |||
| 9685 | 9685 | 111779 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 356 Marietta Dr | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 5999368.0 | 2097504.0 | 37.7393097549515 | -122.44473159198601 | (37.7393097549515, -122.444731591986) | ||||
| 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) | |||
| 10926 | 10926 | 15989 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 236 Moncada Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 35M | 5992398.75579 | 2093455.53191 | 37.7277935021904 | -122.468533444909 | (37.7277935021904, -122.468533444909) | |||
| 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) | ||||
| 13311 | 13311 | 29591 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991298.8544 | 2091955.25413 | 37.7236105159064 | -122.47222647259899 | (37.7236105159064, -122.472226472599) | ||
| 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) |
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");