home / trees

Street_Tree_List

Data source: data.sfgov.org

191,550 rows sorted by qAddress

View and edit SQL

Suggested facets: qLegalStatus, PlantType, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus qSpecies qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
4194 104721 Undocumented 3 Tree(s) :: 13   3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     16 5x5   6002949.0 2107631.0 37.7673197977372 -122.43307345634199 (37.7673197977372, -122.433073456342) 15 5 5 28862 3
15580 117428 Permitted Site 2 Leptospermum laevigatum :: Australian Tea Tree 73   2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/14/2016 12:00:00 AM 3   Permit Number 776915                    
21230 12380 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9   1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   09/17/2013 12:00:00 AM 3 3x3   6004345.46385 2113763.0093400003 37.7842359045501 -122.42868045552099 (37.7842359045501, -122.428680455521) 13 9 11 29490 41
42599 14676 DPW Maintained 1 Acer rubrum 'Red Sunset' :: Red Swamp Maple 271   1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   05/12/2011 12:00:00 AM 3 4x4   6005306.03378 2112177.46067 37.7799366952092 -122.425244357372 (37.7799366952092, -122.425244357372) 7 9 11 28852 41
130812 30278 Permitted Site 2 Tree(s) :: 13   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 128                    
130894 30354 Permitted Site 2 Corymbia ficifolia :: Red Flowering Gum 5   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/17/1956 12:00:00 AM     Permit Number 43                    
131029 30480 Permitted Site 2 Tree(s) :: 13   3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/05/1956 12:00:00 AM     Permit Number 147                    
131030 30481 Permitted Site 2 Tree(s) :: 13   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/05/1956 12:00:00 AM     Permit Number 147                    
131031 30482 Permitted Site 2 Tree(s) :: 13   2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/05/1956 12:00:00 AM     Permit Number 147                    
131032 30483 Permitted Site 2 Tree(s) :: 13   4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/05/1956 12:00:00 AM     Permit Number 147                    
131033 30484 Permitted Site 2 Tree(s) :: 13   5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/05/1956 12:00:00 AM     Permit Number 147                    
132489 31845 Permitted Site 2 Prunus serrulata :: Ornamental Cherry 132   3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
132490 31846 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
132491 31847 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43   2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
132492 31848 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43   3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
132493 31849 Permitted Site 2 Prunus serrulata :: Ornamental Cherry 132   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
132495 31850 Permitted Site 2 Prunus serrulata :: Ornamental Cherry 132   2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/19/1995 12:00:00 AM     Permit Number 35298                    
133829 33082 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11   7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
133830 33083 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43   2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
133831 33084 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
133832 33085 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11   10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
133833 33086 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
133834 33087 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11   6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
133835 33088 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11   5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
133836 33089 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11   4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
133838 33090 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11   3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
133839 33091 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11   2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
133840 33092 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11   8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
133841 33093 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11   9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/05/1996 12:00:00 AM     Permit Number 37336                    
134753 33927 Permitted Site 2 Tree(s) :: 13   2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
134754 33928 Permitted Site 2 Tree(s) :: 13   3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
134755 33929 Permitted Site 2 Tree(s) :: 13   4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
134757 33930 Permitted Site 2 Tree(s) :: 13   5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
134758 33931 Permitted Site 2 Tree(s) :: 13   6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
134759 33932 Permitted Site 2 Tree(s) :: 13   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
134836 34002 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 37940                    
134837 34003 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11   2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 37940                    
134838 34004 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11   3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 37940                    
134896 34058 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37960                    
134943 34100 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37975                    
134944 34101 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37975                    
134945 34102 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37975                    
134946 34103 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37975                    
134958 34114 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37978                    
134959 34115 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37978                    
134960 34116 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37979                    
134961 34117 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37979                    
134962 34118 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37979                    
134963 34119 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37980                    
134965 34120 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37980                    
134966 34121 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37980                    
134967 34122 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37981                    
134968 34123 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37981                    
134969 34124 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37982                    
134978 34132 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37986                    
134979 34133 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37986                    
134980 34134 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37986                    
134981 34135 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37986                    
134982 34136 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37986                    
134983 34137 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37987                    
134984 34138 Permitted Site 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 20   2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/05/1997 12:00:00 AM     Permit Number 37987                    
135092 34235 Permitted Site 2 Magnolia grandiflora :: Southern Magnolia 39   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/30/1997 12:00:00 AM     Permit Number 38048 6016895.91787464 2103845.69851644 37.757707418448895 -122.38456887610201 (37.7577074184489, -122.384568876102) 10 3 8 28856 29
135104 34246 Permitted Site 2 Metrosideros excelsa :: New Zealand Xmas Tree 3   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 38056                    
135106 34248 Permitted Site 2 Tree(s) :: 13   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/08/1997 12:00:00 AM     Permit Number 38058                    
135171 34307 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   29 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135172 34308 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   17 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135173 34309 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   18 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135175 34310 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   20 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135176 34311 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   32 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135177 34312 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   22 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135178 34313 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   23 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135179 34314 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   24 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135180 34315 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   25 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135181 34316 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   26 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135182 34317 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   28 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135183 34318 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   16 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135184 34319 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   30 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135186 34320 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   31 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135187 34321 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   19 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135188 34322 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   27 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135189 34323 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135190 34324 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   15 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135191 34325 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135192 34326 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135193 34327 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135194 34328 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135195 34329 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135197 34330 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135198 34331 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135199 34332 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135200 34333 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   11 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135201 34334 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   12 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135202 34335 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   21 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135203 34336 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   13 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135204 34337 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   14 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135205 34338 Permitted Site 2 Jacaranda mimosifolia :: Jacaranda 29   4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/14/1997 12:00:00 AM     Permit Number 38095 6011565.66175485 2101164.33215433 37.7500487659499 -122.40281462336901 (37.7500487659499, -122.402814623369) 10 3 8 28856 29
135766 34855 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11   3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 38478 6007910.36416897 2111288.85125958 37.777643571368706 -122.41617183970699 (37.7776435713687, -122.416171839707) 7 2 9 28852 36
135767 34856 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11   6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 38478 6007910.36416897 2111288.85125958 37.777643571368706 -122.41617183970699 (37.7776435713687, -122.416171839707) 7 2 9 28852 36
135768 34857 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11   7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 38478 6007910.36416897 2111288.85125958 37.777643571368706 -122.41617183970699 (37.7776435713687, -122.416171839707) 7 2 9 28852 36
135769 34858 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11   4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 38478 6007910.36416897 2111288.85125958 37.777643571368706 -122.41617183970699 (37.7776435713687, -122.416171839707) 7 2 9 28852 36

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 614.165ms · Data source: data.sfgov.org