Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1123 | 1123 | 28040 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011973.34792 | 2120976.9306 | 37.8044723526732 | -122.40279804081499 | (37.8044723526732, -122.402798040815) | ||
| 1899 | 1899 | 25838 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013225.308119999 | 2119220.74162 | 37.7997201038678 | -122.39834219506099 | (37.7997201038678, -122.398342195061) | ||
| 2090 | 2090 | 25842 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013279.137069999 | 2119139.97441 | 37.799501334781795 | -122.398150256355 | (37.7995013347818, -122.398150256355) | ||
| 2826 | 2826 | 28035 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011869.41049 | 2121075.03017 | 37.804735906188796 | -122.403164632367 | (37.8047359061888, -122.403164632367) | ||
| 3114 | 3114 | 25811 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012315.257619999 | 2120560.3270799997 | 37.8033475454092 | -122.401585526252 | (37.8033475454092, -122.401585526252) | ||
| 3657 | 3657 | 25806 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012234.78854 | 2120695.21971 | 37.8037134372885 | -122.401873481994 | (37.8037134372885, -122.401873481994) | ||
| 3684 | 3684 | 27830 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6013136.88249 | 2119351.75589 | 37.800074911578 | -122.398657381345 | (37.800074911578, -122.398657381345) | |||
| 3878 | 3878 | 28034 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011851.06099 | 2121093.24306 | 37.8047848895665 | -122.403229415001 | (37.8047848895665, -122.403229415001) | ||
| 4198 | 4198 | 25837 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013209.63865 | 2119244.79078 | 37.7997852642353 | -122.39839810591299 | (37.7997852642353, -122.398398105913) | ||
| 4234 | 4234 | 28039 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011949.43377 | 2121001.73319 | 37.8045391192453 | -122.402882543817 | (37.8045391192453, -122.402882543817) | ||
| 4885 | 4885 | 25808 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012265.91209 | 2120646.37252 | 37.803581051681704 | -122.401762341075 | (37.8035810516817, -122.401762341075) | ||
| 4943 | 4943 | 25845 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013327.75405 | 2119068.43707 | 37.799307618121 | -122.397977001961 | (37.799307618121, -122.397977001961) | ||
| 5391 | 5391 | 27795 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 24 | 6013107.19159 | 2119396.29372 | 37.8001955475498 | -122.398763251324 | (37.8001955475498, -122.398763251324) | |||
| 5630 | 5630 | 28043 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6012024.04433 | 2120930.34171 | 37.8043472614676 | -122.402619322118 | (37.8043472614676, -122.402619322118) | ||
| 5672 | 5672 | 25807 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012251.480269999 | 2120666.53325 | 37.8036356027669 | -122.40181370136801 | (37.8036356027669, -122.401813701368) | ||
| 5709 | 5709 | 25839 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013239.738969999 | 2119198.12663 | 37.799658812366204 | -122.398290671092 | (37.7996588123662, -122.398290671092) | ||
| 5784 | 5784 | 25812 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012332.091990001 | 2120538.6639799997 | 37.803289003136 | -122.401525746517 | (37.803289003136, -122.401525746517) | ||
| 5815 | 5815 | 25809 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012278.63673 | 2120626.00413 | 37.8035258351232 | -122.40171687406 | (37.8035258351232, -122.40171687406) | ||
| 6222 | 6222 | 27831 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6013146.80764 | 2119335.33451 | 37.8000303753641 | -122.39862188328699 | (37.8000303753641, -122.398621883287) | |||
| 6770 | 6770 | 25843 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013291.71436 | 2119122.7738 | 37.7994548065492 | -122.39810552676902 | (37.7994548065492, -122.398105526769) | ||
| 6942 | 6942 | 28041 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011990.996730001 | 2120961.47906 | 37.804430911926495 | -122.40273587786501 | (37.8044309119265, -122.402735877865) | ||
| 7124 | 7124 | 27832 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6013158.11098 | 2119319.87365 | 37.799988553278105 | -122.39858168361799 | (37.7999885532781, -122.398581683618) | |||
| 7283 | 7283 | 25805 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012220.3272400005 | 2120713.92747 | 37.803763997176794 | -122.401924842279 | (37.8037639971768, -122.401924842279) | ||
| 7341 | 7341 | 28044 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6012052.65409 | 2120901.81041 | 37.8042705187194 | -122.402518307585 | (37.8042705187194, -122.402518307585) | ||
| 7619 | 7619 | 25841 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013268.0055599995 | 2119155.84179 | 37.799544282796205 | -122.398189889456 | (37.7995442827962, -122.398189889456) | ||
| 7632 | 7632 | 25840 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013252.78025 | 2119179.61334 | 37.7996087057277 | -122.39824424358999 | (37.7996087057277, -122.39824424359) | ||
| 7651 | 7651 | 28038 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011930.42206 | 2121019.16916 | 37.80458593256979 | -122.402949563068 | (37.8045859325698, -122.402949563068) | ||
| 7856 | 7856 | 28033 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011830.13261 | 2121113.3124599997 | 37.80483882640021 | -122.403303252939 | (37.8048388264002, -122.403303252939) | ||
| 8279 | 8279 | 28037 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011908.75369 | 2121039.95348 | 37.8046417912539 | -122.403026011743 | (37.8046417912539, -122.403026011743) | ||
| 8292 | 8292 | 25844 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013309.3136 | 2119095.04373 | 37.7993796466195 | -122.398042680326 | (37.7993796466195, -122.398042680326) | ||
| 8337 | 8337 | 25810 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012292.79565 | 2120604.39505 | 37.803467291949204 | -122.401666356441 | (37.8034672919492, -122.401666356441) | ||
| 8683 | 8683 | 28036 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6011891.7394900005 | 2121054.53142 | 37.8046808685929 | -122.40308591740101 | (37.8046808685929, -122.403085917401) | ||
| 8734 | 8734 | 25813 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6012345.50187 | 2120516.10099 | 37.8032277988787 | -122.401477754221 | (37.8032277988787, -122.401477754221) | ||
| 8754 | 8754 | 28042 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1500 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 12 | 3X3 | 6012004.18493 | 2120947.51548 | 37.804393307678 | -122.4026892561 | (37.804393307678, -122.4026892561) | ||
| 8997 | 8997 | 27829 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6013118.439809999 | 2119374.83982 | 37.800137266990596 | -122.39872282141 | (37.8001372669906, -122.39872282141) | |||
| 18001 | 18001 | 27903 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015937.152000001 | 2112771.705 | 37.78216321542121 | -122.388507741674 | (37.7821632154212, -122.388507741674) | |||
| 20295 | 20295 | 25849 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012736.380854 | 2120162.4372415002 | 37.8022785256437 | -122.40010024450399 | (37.8022785256437, -122.400100244504) | ||
| 47992 | 47992 | 27910 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015913.96301 | 2112493.47301 | 37.7813979677469 | -122.38856853840599 | (37.7813979677469, -122.388568538406) | ||
| 53184 | 53184 | 27902 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015941.319 | 2112799.309 | 37.782239240724 | -122.38849525296699 | (37.782239240724, -122.388495252967) | |||
| 54631 | 54631 | 25675 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 66037 | 66037 | 121471 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 102X King St | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 9 | 3x3 | 6015546.21298 | 2111901.81315 | 37.779753015830394 | -122.38979944679701 | (37.7797530158304, -122.389799446797) | |||
| 75152 | 75152 | 27904 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015934.027000001 | 2112727.434 | 37.7820414840201 | -122.388515461744 | (37.7820414840201, -122.388515461744) | |||
| 75154 | 75154 | 27919 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015840.17801 | 2112278.62901 | 37.7808039650097 | -122.38880879774099 | (37.7808039650097, -122.388808797741) | ||
| 77564 | 77564 | 27895 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015957.985 | 2112989.413 | 37.7827621471367 | -122.388450868666 | (37.7827621471367, -122.388450868666) | |||
| 77648 | 77648 | 25821 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | ||
| 78967 | 78967 | 25865 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012565.65701 | 2120204.63501 | 37.8023848701418 | -122.400694001959 | (37.8023848701418, -122.400694001959) | ||
| 79277 | 79277 | 15089 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 30 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 4X4 | 6014680.683616 | 2116874.398416 | 37.7933585592202 | -122.393141753221 | (37.7933585592202, -122.393141753221) | |||
| 80016 | 80016 | 27916 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015873.81501 | 2112343.7330099996 | 37.780984590279104 | -122.388696976059 | (37.7809845902791, -122.388696976059) | ||
| 80438 | 80438 | 27893 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015963.194 | 2113042.017 | 37.7829068745448 | -122.388436520394 | (37.7829068745448, -122.388436520394) | |||
| 80608 | 80608 | 25651 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 80718 | 80718 | 27834 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 80770 | 80770 | 27817 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 80801 | 80801 | 27819 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 80951 | 80951 | 25637 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 550X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 6 | 4X4 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 81058 | 81058 | 25655 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 81408 | 81408 | 27915 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015885.75101 | 2112369.77501 | 37.7810567572813 | -122.38865750159401 | (37.7810567572813, -122.388657501594) | ||
| 81888 | 81888 | 27821 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 82200 | 82200 | 25676 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 82424 | 82424 | 27839 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 82957 | 82957 | 27840 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 83033 | 83033 | 27803 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 650 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4X4 | 6012967.8705311 | 2119824.4474868 | 37.8013633914033 | -122.399275432078 | (37.8013633914033, -122.399275432078) | ||
| 83311 | 83311 | 27705 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1501X The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 6010670.1386196995 | 2122042.3573555 | 37.807324899499 | -122.407383090822 | (37.807324899499, -122.407383090822) | ||||
| 83768 | 83768 | 27906 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015925.694 | 2112692.017 | 37.7819437751015 | -122.38854181744 | (37.7819437751015, -122.38854181744) | |||
| 83992 | 83992 | 25626 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015143.78201 | 2116618.69801 | 37.7926821803134 | -122.391521501856 | (37.7926821803134, -122.391521501856) | ||
| 84010 | 84010 | 27922 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015798.94501 | 2112218.95001 | 37.7806378144268 | -122.388947276171 | (37.7806378144268, -122.388947276171) | ||
| 84036 | 84036 | 27864 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 84193 | 84193 | 25858 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012435.4480099995 | 2120409.0630099997 | 37.802938916816295 | -122.40115896506201 | (37.8029389168163, -122.401158965062) | ||
| 84408 | 84408 | 25895 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213273997 | 37.7992817461076 | -122.39756784649201 | (37.7992817461076, -122.397567846492) | ||
| 85025 | 85025 | 25615 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014865.13601 | 2116922.0830099997 | 37.793499734993894 | -122.39250686670401 | (37.7934997349939, -122.392506866704) | ||
| 85287 | 85287 | 25623 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6015040.91701 | 2116748.90601 | 37.793033991285796 | -122.391886530718 | (37.7930339912858, -122.391886530718) | ||
| 85455 | 85455 | 25653 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 85492 | 85492 | 27923 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015780.499009999 | 2112201.5890099998 | 37.780589122550204 | -122.38900987778901 | (37.7805891225502, -122.389009877789) | ||
| 85814 | 85814 | 27885 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015984.5479999995 | 2113289.413 | 37.7835873515787 | -122.388379916552 | (37.7835873515787, -122.388379916552) | |||
| 86119 | 86119 | 25861 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012509.66701 | 2120295.78101 | 37.802632012073204 | -122.400894163602 | (37.8026320120732, -122.400894163602) | ||
| 86353 | 86353 | 25848 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012397.68801 | 2120467.65601 | 37.803097692384604 | -122.401293754953 | (37.8030976923846, -122.401293754953) | ||
| 86606 | 86606 | 27928 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100 The Embarcadero | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 12 | 3X3 | 6015611.22801 | 2112036.65901 | 37.7801268774736 | -122.389583949745 | (37.7801268774736, -122.389583949745) | ||
| 86704 | 86704 | 27813 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 86722 | 86722 | 25901 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 500X The Embarcadero | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6013445.7547399 | 2119056.6213273997 | 37.7992817461076 | -122.39756784649201 | (37.7992817461076, -122.397567846492) | ||
| 86828 | 86828 | 25818 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | ||
| 86833 | 86833 | 27886 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015979.339 | 2113269.621 | 37.7835327185594 | -122.388396555982 | (37.7835327185594, -122.388396555982) | |||
| 87036 | 87036 | 27900 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015944.964 | 2112842.538 | 37.7823581398375 | -122.388485661103 | (37.7823581398375, -122.388485661103) | |||
| 87440 | 87440 | 25866 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012586.49001 | 2120179.89601 | 37.8023181047385 | -122.400620170198 | (37.8023181047385, -122.400620170198) | ||
| 87777 | 87777 | 25847 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012388.5730099995 | 2120483.28101 | 37.803140086302705 | -122.401326396519 | (37.8031400863027, -122.401326396519) | ||
| 88104 | 88104 | 25650 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 88547 | 88547 | 27883 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 280 The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 12 | 6015986.631 | 2113340.455 | 37.7837276168383 | -122.388376273801 | (37.7837276168383, -122.388376273801) | |||
| 89385 | 89385 | 27863 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 90157 | 90157 | 25660 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 90241 | 90241 | 27861 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 12/20/2000 12:00:00 AM | 24 | 6012583.0764321 | 2120386.2715161997 | 37.8028845715493 | -122.400646489089 | (37.8028845715493, -122.400646489089) | |||
| 90272 | 90272 | 25652 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) | ||
| 90715 | 90715 | 27823 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 350X The Embarcadero | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 07/15/1994 12:00:00 AM | 12 | 4x4 | 6013785.794644901 | 2118604.8635638 | 37.7980602547356 | -122.39635950070699 | (37.7980602547356, -122.396359500707) | ||
| 90808 | 90808 | 25618 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014901.59401 | 2116884.32301 | 37.7933980793798 | -122.392378075877 | (37.7933980793798, -122.392378075877) | ||
| 90852 | 90852 | 25860 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012500.55201 | 2120312.7080099997 | 37.8026779810822 | -122.400926896266 | (37.8026779810822, -122.400926896266) | ||
| 91091 | 91091 | 25822 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | ||
| 91466 | 91466 | 25854 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800X The Embarcadero | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012736.380854 | 2120162.4372415002 | 37.8022785256437 | -122.40010024450399 | (37.8022785256437, -122.400100244504) | ||
| 92547 | 92547 | 25817 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1300X The Embarcadero | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/15/1995 12:00:00 AM | 6 | 4X4 | 6011529.7175275 | 2121574.5346243 | 37.8060884463757 | -122.404375360949 | (37.8060884463757, -122.404375360949) | ||
| 92649 | 92649 | 25621 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 800 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6014992.74001 | 2116800.99001 | 37.7931743271891 | -122.39205687118401 | (37.7931743271891, -122.392056871184) | ||
| 92956 | 92956 | 25834 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 10/30/1995 12:00:00 AM | 6 | 4X4 | 6012224.999683401 | 2120852.6389045 | 37.8041451257683 | -122.401918429695 | (37.8041451257683, -122.401918429695) | ||
| 93059 | 93059 | 121444 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 3x3 | 6013767.0 | 2118587.0 | 37.7980101597556 | -122.39642328332701 | (37.7980101597556, -122.396423283327) | ||||
| 93341 | 93341 | 25642 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 550X The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 6 | 4X4 | 6013263.823467299 | 2119389.8203611 | 37.8001864990432 | -122.398220785892 | (37.8001864990432, -122.398220785892) | ||
| 93368 | 93368 | 25662 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 450X The Embarcadero | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12/18/2000 12:00:00 AM | 12 | 4X4 | 6013579.1997782 | 2118911.837786 | 37.7988916345337 | -122.397095919657 | (37.7988916345337, -122.397095919657) |
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");