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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 118123 | 118123 | 107815 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 311 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5986808.71714 | 2113837.73031 | 37.7834329707826 | -122.489356078034 | (37.7834329707826, -122.489356078034) | |||
| 46760 | 46760 | 120018 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 333 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5986813.0635400005 | 2113669.74125 | 37.782971974652604 | -122.48932868568701 | (37.7829719746526, -122.489328685687) | |||
| 64736 | 64736 | 120017 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 343 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 5986815.03872 | 2113631.20342 | 37.7828662761015 | -122.48931901802 | (37.7828662761015, -122.48931901802) | |||
| 137115 | 137115 | 250622 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 122 28th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 4ft | 5987113.07989 | 2115137.65362 | 37.7870199498697 | -122.48839868145001 | (37.7870199498697, -122.48839868145) | |||
| 68348 | 68348 | 250621 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 122 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 4ft | 5987113.38286 | 2115127.17746 | 37.7869912030255 | -122.48839686305 | (37.7869912030255, -122.48839686305) | |||
| 184572 | 184572 | 119961 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 5987197.92043 | 2112907.45085 | 37.780901400579296 | -122.48794122965299 | (37.7809014005793, -122.487941229653) | |||
| 124558 | 124558 | 87671 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 El Camino Del Mar | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50395 | 5987244.0 | 2115292.0 | 37.787451378555396 | -122.48795707816299 | (37.7874513785554, -122.487957078163) | ||
| 96580 | 96580 | 43346 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2000 12:00:00 AM | Permit Number 43101 | 5987278.98724374 | 2109843.31804433 | 37.772492884784896 | -122.487435636536 | (37.7724928847849, -122.487435636536) | |||
| 106000 | 106000 | 43348 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200 Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2000 12:00:00 AM | Permit Number 43101 | 5987278.98724374 | 2109843.31804433 | 37.772492884784896 | -122.487435636536 | (37.7724928847849, -122.487435636536) | |||
| 142204 | 142204 | 43347 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200 Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/2000 12:00:00 AM | Permit Number 43101 | 5987278.98724374 | 2109843.31804433 | 37.772492884784896 | -122.487435636536 | (37.7724928847849, -122.487435636536) | |||
| 172011 | 172011 | 250333 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 135 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 5987387.37303 | 2115049.79038 | 37.786794702950395 | -122.487443244435 | (37.7867947029504, -122.487443244435) | |||
| 48672 | 48672 | 250325 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 165 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 5987394.93306 | 2114848.62147 | 37.7862427917124 | -122.487402306398 | (37.7862427917124, -122.487402306398) | |||
| 173634 | 173634 | 68443 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1274 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1993 12:00:00 AM | 26 | 7.5x7.5 | Permit Number 32300 | 5987418.73686806 | 2106612.65804585 | 37.7636305377833 | -122.486714964872 | (37.7636305377833, -122.486714964872) | |
| 124518 | 124518 | 65689 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 3601 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/1990 12:00:00 AM | 15 | 4x3 | Permit Number 28615 | 5987420.04323 | 2111837.39532 | 37.7779762857803 | -122.487094195586 | (37.7779762857803, -122.487094195586) | |
| 169338 | 169338 | 120058 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 132 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 37 | Width 4ft | 5987428.81431 | 2115064.18199 | 37.7868366349011 | -122.48730092667401 | (37.7868366349011, -122.487300926674) | |||
| 50964 | 50964 | 120056 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 142 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 5987429.57525 | 2114999.01583 | 37.786657751693504 | -122.487293505702 | (37.7866577516935, -122.487293505702) | |||
| 172929 | 172929 | 120057 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 142 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 4ft | 5987429.900230001 | 2115014.31734 | 37.786699784202106 | -122.48729350569799 | (37.7866997842021, -122.487293505698) | |||
| 182229 | 182229 | 106951 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 156 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2014 12:00:00 AM | 22 | 3x3 | Permit Number 773389 | 5987431.57269 | 2114958.38797 | 37.7865463157209 | -122.487283609867 | (37.7865463157209, -122.487283609867) | |
| 180044 | 180044 | 120055 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 146 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 5987431.73679 | 2114982.94917 | 37.786613763301794 | -122.48728484684099 | (37.7866137633018, -122.487284846841) | |||
| 54007 | 54007 | 120053 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 158 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 5987432.117819999 | 2114926.05688 | 37.786457575606896 | -122.487279348253 | (37.7864575756069, -122.487279348253) | |||
| 52932 | 52932 | 120054 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 158 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5987432.2307 | 2114943.781 | 37.786506247541 | -122.48728026005301 | (37.786506247541, -122.487280260053) | |||
| 173894 | 173894 | 119976 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 790 27th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 6ft | 5987592.781909999 | 2110583.46178 | 37.774543407501895 | -122.48640455355302 | (37.7745434075019, -122.486404553553) | |||
| 104120 | 104120 | 121412 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2548 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 5987616.0 | 2110573.0 | 37.774516035705204 | -122.486323470467 | (37.7745160357052, -122.486323470467) | |||
| 47380 | 47380 | 119985 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2512 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 5ft | 5987666.80033 | 2110540.3031900004 | 37.7744292202448 | -122.48614534379699 | (37.7744292202448, -122.486145343797) | |||
| 62014 | 62014 | 120074 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 135 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 4ft | 5987695.47672 | 2115079.1685 | 37.786893330275795 | -122.486379449256 | (37.7868933302758, -122.486379449256) | |||
| 29848 | 29848 | 120075 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 135 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 5987696.4529800005 | 2115057.7870099996 | 37.7868346797306 | -122.486374501304 | (37.7868346797306, -122.486374501304) | |||
| 40131 | 40131 | 102733 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 227 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 6x12 | 5987865.555930001 | 2115301.49013 | 37.78751367389071 | -122.48580734547899 | (37.7875136738907, -122.485807345479) | |||
| 181706 | 181706 | 120384 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 221 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5987878.79334 | 2115302.0322 | 37.7875159336053 | -122.48576158708201 | (37.7875159336053, -122.485761587082) | |||
| 130111 | 130111 | 120382 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 209 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5987947.25387 | 2115304.7445400003 | 37.787527369834706 | -122.48552492951599 | (37.7875273698347, -122.485524929516) | |||
| 99939 | 99939 | 19428 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1200X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/13/2007 12:00:00 AM | 3 | 20 | 5987947.5018995 | 2095985.7700737999 | 37.7344827526385 | -122.484106799366 | (37.7344827526385, -122.484106799366) | ||
| 129919 | 129919 | 120222 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 250 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 3ft | 5988081.00935 | 2114311.02027 | 37.7848066783881 | -122.48498923446199 | (37.7848066783881, -122.484989234462) | |||
| 34270 | 34270 | 120223 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 250 25th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5988081.34041 | 2114326.62635 | 37.7848495475274 | -122.48498923447201 | (37.7848495475274, -122.484989234472) | |||
| 180393 | 180393 | 120221 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 250 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5988083.13088 | 2114289.3007900002 | 37.7847471664462 | -122.48498030073401 | (37.7847471664462, -122.484980300734) | |||
| 30465 | 30465 | 182811 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1808 26th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 5988164.7245 | 2103004.1689 | 37.753766066392394 | -122.483870250853 | (37.7537660663924, -122.483870250853) | |||
| 62441 | 62441 | 182809 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1812 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5988165.2943 | 2102980.2378 | 37.7537003911945 | -122.48386652576401 | (37.7537003911945, -122.483866525764) | |||
| 43353 | 43353 | 182810 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1810 26th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5988165.8641 | 2102992.2034 | 37.7537332786865 | -122.483865432602 | (37.7537332786865, -122.483865432602) | |||
| 175176 | 175176 | 182808 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1814 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5988165.8641 | 2102960.2953 | 37.7536456676195 | -122.48386309312201 | (37.7536456676195, -122.483863093122) | |||
| 144019 | 144019 | 30320 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 867 25th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/13/1955 12:00:00 AM | Permit Number 14 | 5988182.28713273 | 2110079.61323567 | 37.773194323540004 | -122.484328404455 | (37.77319432354, -122.484328404455) | |||
| 60953 | 60953 | 251054 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 6000x Geary Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5988209.3153 | 2112595.4218 | 37.7801036030677 | -122.48441946896601 | (37.7801036030677, -122.484419468966) | |||
| 37593 | 37593 | 182806 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1851 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5988216.5752 | 2103026.3907 | 37.7538300998005 | -122.48369257066601 | (37.7538300998005, -122.483692570666) | |||
| 156895 | 156895 | 182805 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1835 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5988270.1353 | 2103027.5303 | 37.75383634637561 | -122.48350743328301 | (37.7538363463756, -122.483507433283) | |||
| 95902 | 95902 | 96835 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 60 | 6001 Geary Blvd | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 5988352.4 | 2112527.1 | 37.779924341439 | -122.483919468894 | (37.779924341439, -122.483919468894) | |||||
| 145187 | 145187 | 96949 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 798X 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5988521.18817 | 2110597.78203 | 37.7746367985505 | -122.483194104095 | (37.7746367985505, -122.483194104095) | |||
| 166322 | 166322 | 251051 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5900x Geary Blvd | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5988530.6021 | 2112606.8245 | 37.780153615018705 | -122.48330884168699 | (37.7801536150187, -122.483308841687) | |||
| 92602 | 92602 | 95971 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5900 Geary Blvd | 5 | Median : 22 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 2 | 5988665.62185 | 2112680.2165599996 | 37.7803629858967 | -122.482847132605 | (37.7803629858967, -122.482847132605) | |||
| 142695 | 142695 | 120405 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 557 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 4ft | 5988754.075119999 | 2111518.7834900003 | 37.7771791619936 | -122.48245600961599 | (37.7771791619936, -122.482456009616) | |||
| 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) | ||||
| 106768 | 106768 | 51557 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 29 West Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2005 12:00:00 AM | Permit Number 47854 | 5988768.43262818 | 2115023.56671426 | 37.7868031451511 | -122.48266323691001 | (37.7868031451511, -122.48266323691) | |||
| 138295 | 138295 | 51558 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 29 West Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2005 12:00:00 AM | Permit Number 47854 | 5988768.43262818 | 2115023.56671426 | 37.7868031451511 | -122.48266323691001 | (37.7868031451511, -122.48266323691) | |||
| 140018 | 140018 | 12815 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2139 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5988780.51636 | 2114651.15635 | 37.7857813149586 | -122.48259413097601 | (37.7857813149586, -122.482594130976) | |||
| 102737 | 102737 | 12813 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2122 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2008 12:00:00 AM | 3 | 5 | 5988829.5620099995 | 2114710.83275 | 37.785948022625206 | -122.482428823022 | (37.7859480226252, -122.482428823022) | ||
| 184066 | 184066 | 176047 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 5988958.7133 | 2089588.42281 | 37.7169760831658 | -122.480142699133 | (37.7169760831658, -122.480142699133) | ||||
| 114224 | 114224 | 19423 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 880X Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/13/2007 12:00:00 AM | 3 | 20 | 5988998.102828201 | 2096024.0271709 | 37.7346489082814 | -122.48047736602301 | (37.7346489082814, -122.480477366023) | ||
| 69208 | 69208 | 176048 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5989010.93647 | 2089619.81285 | 37.7170653066825 | -122.479964486788 | (37.7170653066825, -122.479964486788) | ||||
| 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) | ||||
| 163843 | 163843 | 176041 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | 5989102.080019999 | 2090436.91452 | 37.71931415859461 | -122.479709205217 | (37.7193141585946, -122.479709205217) | ||||
| 153599 | 153599 | 176040 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 5989182.3515099995 | 2090508.47222 | 37.719515300969206 | -122.479436972335 | (37.7195153009692, -122.479436972335) | ||||
| 173612 | 173612 | 176050 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989206.756130001 | 2089405.10082 | 37.7164871361381 | -122.47927194136999 | (37.7164871361381, -122.47927194137) | ||||
| 160065 | 160065 | 176051 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 5989218.52603 | 2089406.1518400002 | 37.7164907055632 | -122.479231336085 | (37.7164907055632, -122.479231336085) | ||||
| 179359 | 179359 | 176053 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 5989219.15665 | 2089312.55172 | 37.7162337395604 | -122.479222313162 | (37.7162337395604, -122.479222313162) | ||||
| 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) | ||||
| 185959 | 185959 | 176042 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 5989234.3289 | 2090278.8910299998 | 37.7188879474116 | -122.47924052173599 | (37.7188879474116, -122.479240521736) | ||||
| 55378 | 55378 | 176054 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | 5989245.31981 | 2089315.2477799999 | 37.7162426617475 | -122.47913207879101 | (37.7162426617475, -122.479132078791) | ||||
| 65336 | 65336 | 176043 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 5989267.954919999 | 2090414.23117 | 37.7192615104927 | -122.47913418591499 | (37.7192615104927, -122.479134185915) | ||||
| 76695 | 76695 | 97331 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 139 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 9x6 | 5989269.62959 | 2114411.1007 | 37.785150632675794 | -122.480884374701 | (37.7851506326758, -122.480884374701) | |||
| 187875 | 187875 | 176055 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 5989270.85841 | 2089380.9981799999 | 37.716424679123705 | -122.479048612712 | (37.7164246791237, -122.479048612712) | ||||
| 154485 | 154485 | 176056 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 5989277.7182599995 | 2089365.90518 | 37.7163836358725 | -122.47902379861401 | (37.7163836358725, -122.479023798614) | ||||
| 62427 | 62427 | 176057 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 5989281.98257 | 2089351.5172299999 | 37.7163443777799 | -122.479008007435 | (37.7163443777799, -122.479008007435) | ||||
| 59105 | 59105 | 115334 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 58 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | 21x4 | 5989295.28706 | 2114885.33628 | 37.786454241014 | -122.480830341017 | (37.786454241014, -122.480830341017) | |||
| 65379 | 65379 | 120717 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 154 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 5989318.46035 | 2114318.61366 | 37.7848995275722 | -122.480708664243 | (37.7848995275722, -122.480708664243) | |||
| 73728 | 73728 | 120716 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 154 21st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 5989318.464930001 | 2114336.78774 | 37.7849494287395 | -122.480709979349 | (37.7849494287395, -122.480709979349) | |||
| 150851 | 150851 | 251082 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5600x Geary Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 5989477.5192 | 2112643.2957 | 37.7803088175248 | -122.480035730601 | (37.7803088175248, -122.480035730601) | |||
| 149750 | 149750 | 251044 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5600x Geary Blvd | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 5989568.3861 | 2112643.8334 | 37.7803155729867 | -122.47972142279801 | (37.7803155729867, -122.479721422798) | |||
| 85995 | 85995 | 95969 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5600 Geary Blvd | 4 | Median : 22 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 2 | 5989606.68558 | 2112715.06065 | 37.7805133679778 | -122.479594141591 | (37.7805133679778, -122.479594141591) | |||
| 122416 | 122416 | 95968 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5600 Geary Blvd | 2 | Median : 22 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 2 | 5989606.68558 | 2112715.06065 | 37.7805133679778 | -122.479594141591 | (37.7805133679778, -122.479594141591) | |||
| 129636 | 129636 | 120745 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 310 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5989667.04936 | 2113254.10273 | 37.7819969332671 | -122.47942476507 | (37.7819969332671, -122.47942476507) | |||
| 178661 | 178661 | 43780 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 318 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 15 | Permit Number 43410 | 5989670.6824 | 2113208.17204 | 37.7818710314531 | -122.479408835232 | (37.7818710314531, -122.479408835232) | |
| 22482 | 22482 | 9050 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5500 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989756.3032 | 2112653.5115 | 37.7803530611008 | -122.47907204579799 | (37.7803530611008, -122.479072045798) | |||
| 57813 | 57813 | 120740 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 682 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 5989760.03773 | 2110677.5841599996 | 37.7749279292467 | -122.478914562404 | (37.7749279292467, -122.478914562404) | |||
| 73344 | 73344 | 176058 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Crespi Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 5989854.78687 | 2090110.33741 | 37.7184611570226 | -122.47708355628599 | (37.7184611570226, -122.477083556286) | ||||
| 109243 | 109243 | 95967 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5500 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 5 | 5989915.47138 | 2112737.13311 | 37.780591904899104 | -122.478527531838 | (37.7805919048991, -122.478527531838) | |||
| 64805 | 64805 | 113697 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 418 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3x3 | 5990008.80232 | 2112457.58426 | 37.779829759564706 | -122.47818421412599 | (37.7798297595647, -122.478184214126) | |||
| 166239 | 166239 | 176046 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 0 Font Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | 5990073.98867 | 2089647.08481 | 37.7172018948419 | -122.47629205486 | (37.7172018948419, -122.47629205486) | ||||
| 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) | ||||
| 51690 | 51690 | 251039 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5400x Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 6ft | 5990159.2899 | 2112663.7273 | 37.780404505362 | -122.47767868930201 | (37.780404505362, -122.477678689302) | |||
| 98676 | 98676 | 95965 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5400 Geary Blvd | 1 | Median : 22 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 2 | 5990210.87302 | 2112736.64328 | 37.7806077057511 | -122.47750557201701 | (37.7806077057511, -122.477505572017) | |||
| 132930 | 132930 | 110400 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 419X 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 28 | 3x3 | 5990269.5497 | 2112500.03817 | 37.77996145844129 | -122.477285287094 | (37.7799614584413, -122.477285287094) | ||
| 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) | ||
| 85205 | 85205 | 104946 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 532 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 86917 | 86917 | 104944 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 532 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 88948 | 88948 | 104951 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 95555 | 95555 | 104945 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 532 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 109251 | 109251 | 104950 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 112803 | 112803 | 104952 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 600 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 146250 | 146250 | 104914 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 614 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 159358 | 159358 | 205500 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1138 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 4ft | 5990418.09905 | 2103165.28215 | 37.754339361873605 | -122.476089416911 | (37.7543393618736, -122.476089416911) | |||
| 71511 | 71511 | 104957 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 759 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 90415 | 90415 | 104958 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 759 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 94825 | 94825 | 104959 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 759 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) | |||||
| 98987 | 98987 | 104915 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 701 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990435.0 | 2090585.0 | 37.7197981072685 | -122.47511265272199 | (37.7197981072685, -122.475112652722) |
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");