Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSpecies, qAddress, SiteOrder, qSiteInfo, PlantDate, PlotSize, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
44570 | 44570 | 27941 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
76348 | 76348 | 27944 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | |||
77877 | 77877 | 28025 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014170.25601 | 2117873.24701 | 37.796072794607895 | -122.39497787369301 | (37.7960727946079, -122.394977873693) | ||
78230 | 78230 | 27930 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961005 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | ||
78636 | 78636 | 28030 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 10 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014322.16601 | 2117689.8700099997 | 37.795577730351205 | -122.39443938464899 | (37.7955777303512, -122.394439384649) | ||
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) | |||
81297 | 81297 | 28024 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014145.300009999 | 2117911.2250099997 | 37.7961756855245 | -122.39506688844999 | (37.7961756855245, -122.39506688845) | ||
81328 | 81328 | 25745 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 10 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256002 | 37.802071026160604 | -122.400455716884 | (37.8020710261606, -122.400455716884) | ||
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) | |||
82580 | 82580 | 28021 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014080.19501 | 2118017.56101 | 37.796464038519396 | -122.39529961933201 | (37.7964640385194, -122.395299619332) | ||
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) | |||
83420 | 83420 | 27948 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
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) | |||
86291 | 86291 | 25738 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256002 | 37.802071026160604 | -122.400455716884 | (37.8020710261606, -122.400455716884) | ||
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) | |||
89908 | 89908 | 27997 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 300 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
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) | |||
91110 | 91110 | 27949 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
92133 | 92133 | 27942 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
92364 | 92364 | 27782 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 24 | 6013580.156802201 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | |||
92652 | 92652 | 27780 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 24 | 6013580.156802201 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | |||
92971 | 92971 | 28023 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4x4 | 6014119.25801 | 2117944.86201 | 37.7962665966149 | -122.395159357042 | (37.7962665966149, -122.395159357042) | ||
93395 | 93395 | 27838 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 11 | 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) | |||
94674 | 94674 | 27870 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015155.50001 | 2116672.0830099997 | 37.79282941355329 | -122.391484690649 | (37.7928294135533, -122.391484690649) | ||
94898 | 94898 | 28032 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 12 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014349.29301 | 2117643.21201 | 37.7954511263865 | -122.394342251353 | (37.7954511263865, -122.394342251353) | ||
94947 | 94947 | 27865 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 6 | 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) | |||
95434 | 95434 | 27933 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961005 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | ||
98209 | 98209 | 25737 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256002 | 37.802071026160604 | -122.400455716884 | (37.8020710261606, -122.400455716884) | ||
98325 | 98325 | 27947 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
101160 | 101160 | 25742 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256002 | 37.802071026160604 | -122.400455716884 | (37.8020710261606, -122.400455716884) | ||
102648 | 102648 | 28027 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014263.57201 | 2117754.9750099997 | 37.795753235969 | -122.394646693031 | (37.795753235969, -122.394646693031) | ||
103821 | 103821 | 27836 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 9 | 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) | |||
104366 | 104366 | 28002 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 300 The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
104388 | 104388 | 28031 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 11 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014334.10201 | 2117669.25401 | 37.7955217871698 | -122.394396639485 | (37.7955217871698, -122.394396639485) | ||
104498 | 104498 | 25741 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256002 | 37.802071026160604 | -122.400455716884 | (37.8020710261606, -122.400455716884) | ||
106008 | 106008 | 28003 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 300 The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
106831 | 106831 | 27951 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
107193 | 107193 | 27833 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 6 | 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) | |||
107611 | 107611 | 28000 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 300 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
109422 | 109422 | 27866 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6014921.77607 | 2116935.19701 | 37.793538888238395 | -122.39231180375 | (37.7935388882384, -122.39231180375) | ||
110146 | 110146 | 27862 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 3 | 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) | |||
111881 | 111881 | 27998 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 300 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
112720 | 112720 | 27781 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 24 | 6013580.156802201 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | |||
113256 | 113256 | 25744 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 9 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256002 | 37.802071026160604 | -122.400455716884 | (37.8020710261606, -122.400455716884) | ||
113720 | 113720 | 25743 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256002 | 37.802071026160604 | -122.400455716884 | (37.8020710261606, -122.400455716884) | ||
114665 | 114665 | 27950 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
114962 | 114962 | 27698 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 11 | Median : Cutout 11 | Tree 1 | Port 9 | 24 | 10 | 6012632.1664062 | 2120088.9827256002 | 37.802071026160604 | -122.400455716884 | (37.8020710261606, -122.400455716884) | |||
115229 | 115229 | 27932 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961005 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | ||
115397 | 115397 | 28022 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014106.23701 | 2117977.41401 | 37.796355252616294 | -122.39520669408002 | (37.7963552526163, -122.39520669408) | ||
115406 | 115406 | 27868 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015038.31301 | 2116806.19801 | 37.793191157262704 | -122.39189954881 | (37.7931911572627, -122.39189954881) | ||
116513 | 116513 | 27946 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
117908 | 117908 | 28001 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 300 The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
118790 | 118790 | 27869 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6015100.81301 | 2116738.49001 | 37.7930087163181 | -122.39167855690701 | (37.7930087163181, -122.391678556907) | ||
118856 | 118856 | 25739 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256002 | 37.802071026160604 | -122.400455716884 | (37.8020710261606, -122.400455716884) | ||
119199 | 119199 | 27935 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 7 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961005 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | ||
119973 | 119973 | 27999 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 300 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6013890.7555668 | 2118454.3638402 | 37.7976528582722 | -122.395985750709 | (37.7976528582722, -122.395985750709) | ||
120022 | 120022 | 27940 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
120299 | 120299 | 27835 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 8 | 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) | |||
123608 | 123608 | 28026 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014253.80701 | 2117776.67601 | 37.795812278914 | -122.39468200241699 | (37.795812278914, -122.394682002417) | ||
123638 | 123638 | 27929 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961005 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | ||
124835 | 124835 | 27837 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 10 | 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) | |||
125282 | 125282 | 27867 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 800 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 01/31/2001 12:00:00 AM | 24 | 4X4 | 6014979.71901 | 2116870.00001 | 37.7933630896865 | -122.392106753362 | (37.7933630896865, -122.392106753362) | ||
125860 | 125860 | 27766 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 24 | 6013580.156802201 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | |||
127099 | 127099 | 27943 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 699 The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 6012787.5534626 | 2119857.700218 | 37.801444644335106 | -122.399901749617 | (37.8014446443351, -122.399901749617) | |||
128206 | 128206 | 27931 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 3 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961005 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | ||
128307 | 128307 | 25736 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256002 | 37.802071026160604 | -122.400455716884 | (37.8020710261606, -122.400455716884) | ||
128446 | 128446 | 27860 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 900X The Embarcadero | 1 | 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) | |||
140893 | 140893 | 27783 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 24 | 6013580.156802201 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | |||
142211 | 142211 | 28029 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 9 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014304.80501 | 2117713.7420099997 | 37.7956423121436 | -122.394501129585 | (37.7956423121436, -122.394501129585) | ||
142246 | 142246 | 25740 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 801X The Embarcadero | 5 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 24 | 10 | 6012632.1664062 | 2120088.9827256002 | 37.802071026160604 | -122.400455716884 | (37.8020710261606, -122.400455716884) | ||
143792 | 143792 | 27934 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 799 The Embarcadero | 6 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 10 | 6012635.1983488 | 2120084.4698961005 | 37.8020588041016 | -122.400444907677 | (37.8020588041016, -122.400444907677) | ||
144240 | 144240 | 27945 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 999 The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 02/01/2001 12:00:00 AM | 24 | 4X4 | 6012331.2461069 | 2120536.8810451 | 37.8032840604314 | -122.401528548359 | (37.8032840604314, -122.401528548359) | ||
144544 | 144544 | 27779 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 399X The Embarcadero | 2 | Median : Cutout 11 | Tree 1 | Port 9 | 12/01/2000 12:00:00 AM | 24 | 6013580.156802201 | 2118681.7167588 | 37.7982598302065 | -122.397076463892 | (37.7982598302065, -122.397076463892) | |||
144979 | 144979 | 28028 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 The Embarcadero | 8 | Median : Cutout 11 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 24 | 4X4 | 6014289.61401 | 2117737.61301 | 37.7957070117951 | -122.394555365911 | (37.7957070117951, -122.394555365911) |
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");