Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, qCaretaker
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187 | 187 | 251248 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 829 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001839.0 | 2095802.0 | 37.7347771581377 | -122.436066227259 | (37.7347771581377, -122.436066227259) | ||||
| 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) | ||||
| 813 | 813 | 251390 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Bosworth St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Width 3ft | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
| 821 | 821 | 251392 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Bosworth St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | Width 3ft | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
| 1453 | 1453 | 251535 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2799 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6002520.0 | 2095715.0 | 37.734576941489294 | -122.433705562416 | (37.7345769414893, -122.433705562416) | ||||
| 1471 | 1471 | 251536 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2799 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6002520.0 | 2095715.0 | 37.734576941489294 | -122.433705562416 | (37.7345769414893, -122.433705562416) | ||||
| 1614 | 1614 | 251637 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1640 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6002593.76659 | 2112688.5347700003 | 37.7811863760687 | -122.43466384314199 | (37.7811863760687, -122.434663843142) | ||||
| 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) | ||||
| 88606 | 88606 | 113723 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 282X MARIETTA DR | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 5x30 | 5999031.0 | 2097664.0 | 37.739729839693496 | -122.445908288102 | (37.7397298396935, -122.445908288102) | ||||
| 90173 | 90173 | 95961 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 5990756.89162 | 2112756.21837 | 37.780693122390204 | -122.47561808245399 | (37.7806931223902, -122.475618082454) | ||||
| 90700 | 90700 | 109270 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 875x CHENERY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 6001242.0 | 2095902.0 | 37.7350178001347 | -122.438137418666 | (37.7350178001347, -122.438137418666) | ||||
| 95291 | 95291 | 101437 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 31X College Ave | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6004315.3 | 2095877.6 | 37.7351251110849 | -122.427510187339 | (37.7351251110849, -122.427510187339) | |||||
| 95546 | 95546 | 104524 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 43X BONVIEW ST | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6007716.0 | 2099172.0 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | |||||
| 100050 | 100050 | 112184 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 301x CORBETT AVE | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 5999677.0 | 2105220.0 | 37.760513648972996 | -122.444217531177 | (37.760513648973, -122.444217531177) | ||||
| 103229 | 103229 | 101442 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 31X College Ave | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6004315.3 | 2095877.6 | 37.7351251110849 | -122.427510187339 | (37.7351251110849, -122.427510187339) | |||||
| 104582 | 104582 | 95964 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200 Geary Blvd | 6 | Median : 22 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 5990756.89162 | 2112756.21837 | 37.780693122390204 | -122.47561808245399 | (37.7806931223902, -122.475618082454) | ||||
| 110459 | 110459 | 111240 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 745X SANCHEZ ST | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 6003713.0 | 2103768.0 | 37.7567562336472 | -122.430155272915 | (37.7567562336472, -122.430155272915) | |||||
| 112767 | 112767 | 111778 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300 Marietta Dr | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 5999367.9101935 | 2097504.6578797 | 37.7393115562077 | -122.444731949771 | (37.7393115562077, -122.444731949771) | ||||
| 120666 | 120666 | 112186 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 301x CORBETT AVE | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 5999677.0 | 2105220.0 | 37.760513648972996 | -122.444217531177 | (37.760513648973, -122.444217531177) | ||||
| 122172 | 122172 | 101448 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 31X College Ave | 4 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6004315.3 | 2095877.6 | 37.7351251110849 | -122.427510187339 | (37.7351251110849, -122.427510187339) | |||||
| 123130 | 123130 | 109269 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 875x CHENERY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 6001242.0 | 2095902.0 | 37.7350178001347 | -122.438137418666 | (37.7350178001347, -122.438137418666) | ||||
| 129407 | 129407 | 26515 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2886 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 6008938.686290001 | 2101687.00134 | 37.751336868362706 | -122.411935812817 | (37.7513368683627, -122.411935812817) | ||||
| 144362 | 144362 | 111667 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2201 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3X3 | 6004212.17015 | 2115977.4871900002 | 37.7903087592304 | -122.429299568375 | (37.7903087592304, -122.429299568375) | ||||
| 146135 | 146135 | 112185 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 301x CORBETT AVE | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 5999677.0 | 2105220.0 | 37.760513648972996 | -122.444217531177 | (37.760513648973, -122.444217531177) | ||||
| 189144 | 189144 | 121399 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 349X Cargo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | ||||||||||
| 800 | 800 | 216493 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Bosworth St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 0 | Width 3ft | 6001711.3067 | 2095523.18805 | 37.734004349526 | -122.43648775710301 | (37.734004349526, -122.436487757103) | |||
| 804 | 804 | 216488 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/29/1998 12:00:00 AM | 0 | Width 3ft | 6001838.4009 | 2095488.4107 | 37.7339160801534 | -122.43604586623002 | (37.7339160801534, -122.43604586623) | ||
| 843 | 843 | 216491 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Bosworth St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 01/29/1998 12:00:00 AM | 0 | Width 3ft | 6001764.68694 | 2095507.97765 | 37.733965618424 | -122.43630211726601 | (37.733965618424, -122.436302117266) | ||
| 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) | |||
| 125275 | 125275 | 2132 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1100X Bosworth St | 21 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 0 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||||
| 44686 | 44686 | 251075 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5100x Geary Blvd | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 10ft | 5990994.9145 | 2112700.954 | 37.7805551774565 | -122.47479062026899 | (37.7805551774565, -122.474790620269) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 22414 | 22414 | 9013 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5317 Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 2 | 8M | 5990485.6581 | 2112681.4706 | 37.7804721580667 | -122.47655093756501 | (37.7804721580667, -122.476550937565) | ||
| 32868 | 32868 | 251069 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200x Geary Blvd | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 10ft | 5990794.5513 | 2112690.3427 | 37.7805144291466 | -122.47548298954099 | (37.7805144291466, -122.475482989541) | |||
| 43116 | 43116 | 212147 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700x Miramar Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995390.97132 | 2094022.6530799998 | 37.729523070026104 | -122.458230394627 | (37.7295230700261, -122.458230394627) | ||||
| 49060 | 49060 | 212149 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700x Miramar Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995397.3757 | 2094149.6680599998 | 37.7298721904459 | -122.45821744347602 | (37.7298721904459, -122.458217443476) | ||||
| 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) | |||
| 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) | |||
| 89161 | 89161 | 9257 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 6600X Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 2 | 8M | 5986360.871619999 | 2112530.52863 | 37.7798176164012 | -122.490809209885 | (37.7798176164012, -122.490809209885) | ||
| 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) | |||
| 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) | |||
| 105037 | 105037 | 95960 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5100 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 2 | 5991179.182440001 | 2112771.35122 | 37.780759144985 | -122.47415829445299 | (37.780759144985, -122.474158294453) | |||
| 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) | |||
| 134170 | 134170 | 212144 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 650x Miramar Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995391.35311 | 2093756.23728 | 37.7287915785573 | -122.458209800162 | (37.7287915785573, -122.458209800162) | ||||
| 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) | |||
| 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) | |||
| 169173 | 169173 | 212153 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Miramar Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995398.99771 | 2094330.69415 | 37.730369337469504 | -122.458224933031 | (37.7303693374695, -122.458224933031) | ||||
| 179786 | 179786 | 212148 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700x Miramar Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 5995395.17866 | 2094120.1752900002 | 37.7297910841891 | -122.45822290508801 | (37.7297910841891, -122.458222905088) | ||||
| 2857 | 2857 | 41128 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2049 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 08/10/2017 12:00:00 AM | 3 | 6x6 | Permit Number 41868 | 5998020.62854813 | 2110270.29167038 | 37.7742858282579 | -122.450310189268 | (37.7742858282579, -122.450310189268) |
| 2873 | 2873 | 41127 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2049 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 08/10/2017 12:00:00 AM | 3 | 6x6 | Permit Number 41868 | 5998020.62854813 | 2110270.29167038 | 37.7742858282579 | -122.450310189268 | (37.7742858282579, -122.450310189268) |
| 2880 | 2880 | 41129 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 2049 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 08/10/2017 12:00:00 AM | 3 | 6x6 | Permit Number 41868 | 5998020.62854813 | 2110270.29167038 | 37.7742858282579 | -122.450310189268 | (37.7742858282579, -122.450310189268) |
| 3898 | 3898 | 212122 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 300x Miramar Ave | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5995365.2918 | 2092257.6675200001 | 37.724675368963105 | -122.45819147914699 | (37.7246753689631, -122.458191479147) | ||||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 16230 | 16230 | 11782 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991290.0959 | 2091855.3897900002 | 37.7233358062868 | -122.472249472731 | (37.7233358062868, -122.472249472731) | ||
| 17111 | 17111 | 29966 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991400.88182 | 2093544.5626 | 37.7279802659702 | -122.471989567778 | (37.7279802659702, -122.471989567778) | ||
| 17196 | 17196 | 11780 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991289.71415 | 2091805.7046599998 | 37.7231993611319 | -122.47224717228599 | (37.7231993611319, -122.472247172286) | ||
| 17538 | 17538 | 30052 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3X3 | 5991303.9336 | 2092006.82804 | 37.723752419029005 | -122.4722126725 | (37.723752419029, -122.4722126725) | |||
| 17711 | 17711 | 29585 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500X Junipero Serra Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991398.016530001 | 2093471.7437599998 | 37.7277801578055 | -122.47199416782101 | (37.7277801578055, -122.471994167821) | ||
| 17761 | 17761 | 11776 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991282.42505 | 2091712.4343599998 | 37.7229428421321 | -122.47226557329701 | (37.7229428421321, -122.472265573297) | ||
| 17868 | 17868 | 11672 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 710X Junipero Serra Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991310.6193982 | 2092985.7524279999 | 37.7264406890913 | -122.472260886614 | (37.7264406890913, -122.472260886614) | ||
| 17935 | 17935 | 29599 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Junipero Serra Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991176.65606 | 2091094.6598 | 37.7212404641514 | -122.472586172621 | (37.7212404641514, -122.472586172621) | ||
| 17949 | 17949 | 11779 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991286.49524 | 2091779.26927 | 37.723126589806704 | -122.47225637323 | (37.7231265898067, -122.47225637323) | ||
| 18437 | 18437 | 11778 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991284.6486 | 2091754.7927400002 | 37.723059276443294 | -122.472260973265 | (37.7230592764433, -122.472260973265) | ||
| 18870 | 18870 | 16690 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 950X Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/07/2014 11:22:00 AM | 3 | 8 | 5991053.49575 | 2103158.03284 | 37.7543562808184 | -122.473891546652 | (37.7543562808184, -122.473891546652) | ||
| 18901 | 18901 | 29590 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991297.67299 | 2091930.7639 | 37.723543203431504 | -122.47222877213301 | (37.7235432034315, -122.472228772133) | ||
| 19148 | 19148 | 2110 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1041 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/06/2005 12:00:00 AM | 3 | 3X3 | 6001168.361930001 | 2095632.80978 | 37.734274477972896 | -122.43837273163601 | (37.7342744779729, -122.438372731636) | ||
| 19341 | 19341 | 11783 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991294.00766 | 2091883.13578 | 37.7234122162896 | -122.472237972213 | (37.7234122162896, -122.472237972213) | ||
| 19985 | 19985 | 29967 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500X Junipero Serra Blvd | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991402.13289 | 2093572.36272 | 37.7280566705545 | -122.471987268219 | (37.7280566705545, -122.471987268219) | ||
| 20180 | 20180 | 11683 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 700X Junipero Serra Blvd | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991304.64081 | 2092852.6411099997 | 37.7260748525524 | -122.47227185508301 | (37.7260748525524, -122.472271855083) | ||
| 20236 | 20236 | 29626 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X Junipero Serra Blvd | 35 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991174.60245 | 2090776.1353200001 | 37.720365755664794 | -122.47257006037901 | (37.7203657556648, -122.472570060379) | ||
| 20444 | 20444 | 29975 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500X Junipero Serra Blvd | 20 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991414.71879 | 2093790.73319 | 37.72865698961311 | -122.471959668 | (37.7286569896131, -122.471959668) | ||
| 20515 | 20515 | 29969 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500X Junipero Serra Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/01/2007 12:00:00 AM | 3 | 3x3 | 5991404.41199 | 2093617.36709 | 37.728180373200495 | -122.471982668172 | (37.7281803732005, -122.471982668172) | ||
| 20806 | 20806 | 2048 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 701X Bosworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/27/2000 12:00:00 AM | 3 | 3X3 | 6001958.681419999 | 2095417.21372 | 37.7337274221844 | -122.435624928664 | (37.7337274221844, -122.435624928664) | ||
| 20900 | 20900 | 11781 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991290.20273 | 2091828.8846200001 | 37.7232630358375 | -122.472247172271 | (37.7232630358375, -122.472247172271) | ||
| 21009 | 21009 | 11768 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 6X6 | 5991277.20617 | 2091654.2371 | 37.7227827448208 | -122.472279373401 | (37.7227827448208, -122.472279373401) | ||
| 21040 | 21040 | 16351 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1500X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 4-HOA | 5993490.85605 | 2095190.6948799998 | 37.7326208567505 | -122.464884023402 | (37.7326208567505, -122.464884023402) | |||
| 21262 | 21262 | 11775 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 3X3 | 5991281.15985 | 2091683.9699900001 | 37.722864612795 | -122.47226787285801 | (37.722864612795, -122.472267872858) | ||
| 21923 | 21923 | 2107 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1019 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3X3 | 6001281.91782 | 2095601.18761 | 37.7341941091789 | -122.437977868977 | (37.7341941091789, -122.437977868977) | ||
| 22120 | 22120 | 11777 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800X Junipero Serra Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991284.187940001 | 2091732.93739 | 37.7229992404026 | -122.472260973267 | (37.7229992404026, -122.472260973267) | ||
| 22280 | 22280 | 16692 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 950X Noriega St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/25/2016 08:08:00 AM | 3 | 8 | 5990985.786309999 | 2103156.72144 | 37.7543487579916 | -122.474125605135 | (37.7543487579916, -122.474125605135) | ||
| 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) | |||
| 55512 | 55512 | 206300 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Junipero Serra Blvd | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991425.03969 | 2093964.76062 | 37.7291354226469 | -122.471936666969 | (37.7291354226469, -122.471936666969) | |||
| 56441 | 56441 | 205091 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991304.49196 | 2092033.3191900002 | 37.7238251894741 | -122.472212672491 | (37.7238251894741, -122.472212672491) | |||
| 58519 | 58519 | 212305 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991194.3003 | 2090309.58448 | 37.7190858620976 | -122.47246797653901 | (37.7190858620976, -122.472467976539) | |||
| 61634 | 61634 | 212145 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 650x Miramar Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5995391.25206 | 2093803.15728 | 37.7289204037391 | -122.458213544026 | (37.7289204037391, -122.458213544026) | ||||
| 67631 | 67631 | 251025 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5000x Geary Blvd | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 10ft | 5991443.5764 | 2112711.3468 | 37.7806097019127 | -122.47323925917101 | (37.7806097019127, -122.473239259171) | |||
| 69825 | 69825 | 205093 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 800x Junipero Serra Blvd | 23 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5991307.52024 | 2092082.28561 | 37.7239598143777 | -122.472205771982 | (37.7239598143777, -122.472205771982) | |||
| 72326 | 72326 | 212134 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 500x Miramar Ave | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 5995376.36506 | 2093112.3941099998 | 37.727022879194 | -122.458215034219 | (37.727022879194, -122.458215034219) | ||||
| 74409 | 74409 | 251072 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5200x Geary Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 10ft | 5990697.77 | 2112688.192 | 37.7805029132293 | -122.475817641236 | (37.7805029132293, -122.475817641236) | |||
| 76481 | 76481 | 251028 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 5000x Geary Blvd | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 10ft | 5991390.9488 | 2112709.5778 | 37.780601797334704 | -122.47342119229799 | (37.7806017973347, -122.473421192298) | |||
| 78324 | 78324 | 30038 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991408.898027 | 2088383.098472 | 37.7138086207581 | -122.47158589282199 | (37.7138086207581, -122.471585892822) | ||
| 79082 | 79082 | 11840 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X Junipero Serra Blvd | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6X6 | 5991384.4577741 | 2088377.8376777 | 37.7137927618926 | -122.47166998341001 | (37.7137927618926, -122.47166998341) | |||
| 79615 | 79615 | 11764 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 810X Junipero Serra Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991252.992504 | 2092079.9575241 | 37.7239502662313 | -122.472394094235 | (37.7239502662313, -122.472394094235) | ||
| 79741 | 79741 | 16693 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 900X NORIEGA ST | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/07/2014 11:22:00 AM | 3 | 8 | 5991142.4 | 2103205.1 | 37.7544906639436 | -122.473587529216 | (37.7544906639436, -122.473587529216) | ||
| 86659 | 86659 | 99336 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 450 30th Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5986577.60051 | 2112919.49158 | 37.7808982560395 | -122.490088077428 | (37.7808982560395, -122.490088077428) |
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");