Street_Tree_List

Data source: data.sfgov.org

189,144 rows sorted by Location descending

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location ▲
124714 124714 119691 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 4x Octavia St 9 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
126370 126370 119730 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 104x Octavia St 10 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
129094 129094 119732 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 104x Octavia St 12 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
138816 138816 119735 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 104x Octavia St 15 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
139912 139912 119688 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 4x Octavia St 6 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
140489 140489 119773 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 204x Octavia St 8 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
141892 141892 119779 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 204x Octavia St 14 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
142187 142187 119776 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 204x Octavia St 11 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
142339 142339 119695 DPW Maintained 3 Populus nigra 'Italica' :: Lombardy Poplar 86 4x Octavia St 13 Median : Cutout 11 Tree 1 DPW 2           2109391.0 6005718.0 47.269987373868105 -138.2836696503 (47.2699873738681, -138.2836696503)
1192 1192 119753 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 8 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1196 1196 119750 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 5 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1202 1202 119754 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 9 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1204 1204 119749 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 4 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1213 1213 119747 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 2 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1223 1223 119752 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 7 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1227 1227 119736 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 1 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1233 1233 119757 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 12 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1234 1234 119748 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 3 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1235 1235 119756 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 101x Octavia St 11 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
99951 99951 119755 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 106x Octavia St Frontage West 10 Median : Cutout 11 Tree 1 DPW 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
81045 81045 109169 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 6x Octavia St Frontage West 6 Median : Cutout 11 Tree 1 DPW 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
83700 83700 109168 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 6x Octavia St Frontage West 7 Median : Cutout 11 Tree 1 DPW 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
97204 97204 109171 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 6x Octavia St Frontage West 4 Median : Cutout 11 Tree 1 DPW 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
99403 99403 109164 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 6x Octavia St Frontage West 11 Median : Cutout 11 Tree 1 DPW 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
116938 116938 109163 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 6x Octavia St Frontage West 12 Median : Cutout 11 Tree 1 DPW 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
121401 121401 109167 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 6x Octavia St Frontage West 8 Median : Cutout 11 Tree 1 DPW 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
126070 126070 109170 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 6x Octavia St Frontage West 5 Median : Cutout 11 Tree 1 DPW 2       3x20   2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
127400 127400 119700 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 6x Octavia St Frontage West 2 Median : Cutout 11 Tree 1 DPW 2           2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
138316 138316 119699 DPW Maintained 3 Phoenix canariensis :: Canary Island Date Palm 100 6x Octavia St Frontage West 1 Median : Cutout 11 Tree 1 DPW 2           2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
144933 144933 119701 DPW Maintained 3 Ulmus parvifolia :: Chinese Elm 46 6x Octavia St Frontage West 3 Median : Cutout 11 Tree 1 DPW 2           2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
93209 93209 65564 Permitted Site 1 Tree(s) :: 17 228 Yerba Buena Rd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/17/1990 12:00:00 AM     Permit Number 28463 6021524.08705829 2122941.38889516 37.8103949467147 -122.36988228287599 (37.8103949467147, -122.369882282876)
90246 90246 65563 Permitted Site 1 Tree(s) :: 17 255 Yerba Buena Rd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/16/1990 12:00:00 AM     Permit Number 28462 6021766.42970205 2122905.90070123 37.8103107984086 -122.36904110347099 (37.8103107984086, -122.369041103471)
143067 143067 65565 Permitted Site 1 Tree(s) :: 17 282 Yerba Buena Rd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/17/1990 12:00:00 AM     Permit Number 28464 6022001.13211196 2122805.77301993 37.8100487398864 -122.368221901586 (37.8100487398864, -122.368221901586)
87727 87727 65566 Permitted Site 1 Tree(s) :: 17 340 Yerba Buena Rd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/17/1990 12:00:00 AM     Permit Number 28465 6022030.55852908 2122617.11164597 37.8095323316173 -122.368107024455 (37.8095323316173, -122.368107024455)
100902 100902 27706 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1801 The Embarcadero 1 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     6     6008269.247115 2122709.555122 37.8090221854411 -122.415739206432 (37.8090221854411, -122.415739206432)
107973 107973 27707 Permitted Site 1 Platanus x hispanica :: Sycamore: London Plane 15 1801 The Embarcadero 2 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     6     6008269.247115 2122709.555122 37.8090221854411 -122.415739206432 (37.8090221854411, -122.415739206432)
50106 50106 28049 Permitted Site 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 1800 The Embarcadero 5 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
80340 80340 28045 Permitted Site 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 1800 The Embarcadero 1 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
87468 87468 28050 Permitted Site 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 1800 The Embarcadero 6 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
88591 88591 28047 Permitted Site 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 1800 The Embarcadero 3 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
89860 89860 28053 Permitted Site 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 1800 The Embarcadero 9 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
95965 95965 28046 Permitted Site 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 1800 The Embarcadero 2 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
112403 112403 28055 Permitted Site 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 1800 The Embarcadero 11 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
121432 121432 28052 Permitted Site 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 1800 The Embarcadero 8 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
124163 124163 28048 Permitted Site 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 1800 The Embarcadero 4 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
143432 143432 28051 Permitted Site 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 1800 The Embarcadero 7 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
144070 144070 28054 Permitted Site 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 1800 The Embarcadero 10 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
185575 185575 135176 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1415 The Embarcadero 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 5ft   6009043.293819999 2122602.08116 37.8087705715725 -122.41305277088999 (37.8087705715725, -122.41305277089)
62361 62361 135174 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1415 The Embarcadero 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 5ft   6009066.35805 2122600.86777 37.808768534616604 -122.412972864314 (37.8087685346166, -122.412972864314)
56560 56560 135172 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1415 The Embarcadero 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 5ft   6009083.4055699995 2122596.81093 37.808758352483295 -122.412913579207 (37.8087583524833, -122.412913579207)
31802 31802 135170 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1415 The Embarcadero 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 5ft   6009098.25007 2122594.28253 37.80875224337429 -122.412862026464 (37.8087522433743, -122.412862026464)
171854 171854 135168 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1415 The Embarcadero 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 5ft   6009115.60188 2122586.88161 37.8087328962651 -122.41280145171999 (37.8087328962651, -122.41280145172)
158721 158721 135169 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1415 The Embarcadero 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 5ft   6009098.34948 2122580.92994 37.808715586113294 -122.41286073775801 (37.8087155861133, -122.412860737758)
132860 132860 135175 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1415 The Embarcadero 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 5ft   6009042.10981 2122580.5962900002 37.808711513081 -122.41305534834801 (37.808711513081, -122.413055348348)
164188 164188 135173 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1415 The Embarcadero 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 5ft   6009065.91093 2122578.9974 37.8087084590055 -122.412972864333 (37.8087084590055, -122.412972864333)
186981 186981 135171 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1415 The Embarcadero 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 5ft   6009081.537769999 2122578.30683 37.808707440053894 -122.412918734125 (37.8087074400539, -122.412918734125)
136976 136976 135167 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 14 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8     6009297.39065 2122561.1634400003 37.8086724825285 -122.41217049819201 (37.8086724825285, -122.412170498192)
121276 121276 66415 Permitted Site 1 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/12/1991 12:00:00 AM     Permit Number 29546 6006760.29248409 2122608.12240598 37.808658736106 -122.42095420122601 (37.808658736106, -122.420954201226)
172987 172987 135165 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 12 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8     6009319.750469999 2122555.32253 37.808657699448105 -122.41209270231 (37.8086576994481, -122.41209270231)
76952 76952 135177 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1415 The Embarcadero 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 4ft   6009002.92609 2122558.40528 37.8086483824759 -122.41318938508199 (37.8086483824759, -122.413189385082)
46489 46489 135163 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     11     6009340.6942 2122549.79423 37.8086436952141 -122.412019829366 (37.8086436952141, -122.412019829366)
69245 69245 135161 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12     6009360.267630001 2122546.84411 37.808636693089106 -122.411951881091 (37.8086366930891, -122.411951881091)
60061 60061 135166 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 13 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 6ft   6009296.71843 2122542.1924 37.8086203551155 -122.412171482933 (37.8086203551155, -122.412171482933)
166962 166962 135178 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1415 The Embarcadero 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6008933.56816 2122548.59369 37.8086175483309 -122.41342872435 (37.8086175483309, -122.41342872435)
64496 64496 135164 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 11 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   6009318.816980001 2122537.49043 37.808608684618605 -122.412094671852 (37.8086086846186, -122.412094671852)
52747 52747 135162 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   6009337.24139 2122533.99681 37.8086001257557 -122.41203066168998 (37.8086001257557, -122.41203066169)
132949 132949 135179 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1415 The Embarcadero 15 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6008885.320280001 2122540.99865 37.808593985178206 -122.41359516278999 (37.8085939851782, -122.41359516279)
61001 61001 135157 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     6009451.25096 2122529.40055 37.808593901544796 -122.411635772999 (37.8085939015448, -122.411635772999)
171105 171105 135160 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6009356.48989 2122529.06979 37.8085876773375 -122.411963698174 (37.8085876773375, -122.411963698174)
52903 52903 135180 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1415 The Embarcadero 16 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 4ft   6008860.7937 2122537.90132 37.8085841034484 -122.413679824982 (37.8085841034484, -122.413679824982)
59638 59638 135156 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13     6009480.72759 2122523.69804 37.808579897317706 -122.411533357278 (37.8085798973177, -122.411533357278)
48102 48102 135159 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 6ft   6009379.72618 2122524.34495 37.8085760077391 -122.41188294806001 (37.8085760077391, -122.41188294806)
167870 167870 135181 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1415 The Embarcadero 17 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 4ft   6008836.81707 2122534.51599 37.8085734617661 -122.41376256350401 (37.8085734617661, -122.413762563504)
137623 137623 135158 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6009395.60812 2122521.7536 37.808569783535106 -122.41182780071199 (37.8085697835351, -122.411827800712)
67415 67415 135155 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     6     6009496.8532 2122519.11823 37.808568226806706 -122.41147722608801 (37.8085682268067, -122.411477226088)
72535 72535 131232 Undocumented 2 Melaleuca quinquenervia :: Cajeput 50 1403 The Embarcadero 27 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     34 Width 10ft   6009815.0933300005 2122512.40886 37.8085676494355 -122.410375388423 (37.8085676494355, -122.410375388423)
184904 184904 135153 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1411 The Embarcadero 10 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13     6009517.81435 2122514.4396599997 37.8085565563141 -122.41140435313 (37.8085565563141, -122.41140435313)
157993 157993 135137 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1405 The Embarcadero 9 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     6009675.17252 2122510.18452 37.8085536973592 -122.41085946829901 (37.8085536973592, -122.410859468299)
161852 161852 135151 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1411 The Embarcadero 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8     6009534.78747 2122509.55925 37.8085441079032 -122.411345267671 (37.8085441079032, -122.411345267671)
152551 152551 135133 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1405 The Embarcadero 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6009697.90214 2122506.13355 37.808543848874 -122.410780519498 (37.808543848874, -122.410780519498)
174362 174362 135149 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1411 The Embarcadero 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12     6009556.32302 2122505.1526099998 37.808533216194895 -122.411270426102 (37.8085332161949, -122.411270426102)
68718 68718 135129 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1405 The Embarcadero 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6009719.11313 2122501.21683 37.8085315380587 -122.4107067652 (37.8085315380587, -122.4107067652)
157851 157851 135147 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1411 The Embarcadero 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12     6009572.95679 2122501.76157 37.8085248381209 -122.411212620383 (37.8085248381209, -122.411212620383)
173340 173340 135136 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1405 The Embarcadero 8 Sidewalk: Property side : Yard 9 Tree 1 Private 1     7     6009674.61624 2122497.64189 37.808519227256106 -122.410860507034 (37.8085192272561, -122.410860507034)
33779 33779 135154 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1413 The Embarcadero 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6009495.3394 2122500.7310200003 37.80851765524471 -122.41148116512 (37.8085176552447, -122.41148116512)
34258 34258 135145 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1411 The Embarcadero 2 Sidewalk: Property side : Yard 9 Tree 1 Private 1     10     6009594.12763 2122497.09351 37.808513208082 -122.411139022559 (37.808513208082, -122.411139022559)
166646 166646 135127 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1403 The Embarcadero 29 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6009796.651769999 2122491.2642 37.8085085577008 -122.41043771682399 (37.8085085577008, -122.410437716824)
160660 160660 135152 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1411 The Embarcadero 9 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 6ft   6009514.303780001 2122495.80991 37.808505206806004 -122.411415185469 (37.808505206806, -122.411415185469)
173081 173081 135125 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1403 The Embarcadero 26 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6009814.02361 2122489.41499 37.8085044540716 -122.410377465851 (37.8085044540716, -122.410377465851)
68996 68996 135143 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1405 The Embarcadero 15 Sidewalk: Property side : Yard 9 Tree 1 Private 1     12     6009614.4871 2122492.8917400003 37.8085028128125 -122.41106826569799 (37.8085028128125, -122.411068265698)
177887 177887 135132 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1405 The Embarcadero 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 4ft   6009696.09091 2122490.92652 37.8085019926339 -122.41078571309299 (37.8085019926339, -122.410785713093)
58970 58970 135150 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1411 The Embarcadero 7 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     13 Width 6ft   6009533.57548 2122492.01614 37.8084958709589 -122.41134822196301 (37.8084958709589, -122.411348221963)
173108 173108 135141 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1405 The Embarcadero 13 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5     6009636.62254 2122489.1519 37.808493785432795 -122.410991395247 (37.8084937854328, -122.410991395247)
68355 68355 135148 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1411 The Embarcadero 5 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     12 Width 6ft   6009553.896240001 2122488.10727 37.808486277873605 -122.41127761976101 (37.8084862778736, -122.411277619761)
53095 53095 135139 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1405 The Embarcadero 11 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5     6009651.5635 2122485.8577099997 37.808485578225294 -122.410939454894 (37.8084855782253, -122.410939454894)
163339 163339 135128 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1403 The Embarcadero 30 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     11 Width 7ft   6009778.15443 2122482.07693 37.808482294798104 -122.410501083081 (37.8084822947981, -122.410501083081)
169413 169413 135146 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1411 The Embarcadero 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     10 Width 6ft   6009571.76938 2122485.2677 37.8084794835077 -122.411215563861 (37.8084794835077, -122.411215563861)
47889 47889 135126 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1403 The Embarcadero 28 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 7ft   6009794.33207 2122480.55113 37.808479012257706 -122.410444987853 (37.8084790122577, -122.410444987853)
86526 86526 107905 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2650 Mason St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6008717.0 2122501.0 37.8084747060674 -122.414174852603 (37.8084747060674, -122.414174852603)
93860 93860 107908 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 2650 Mason St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           6008717.0 2122501.0 37.8084747060674 -122.414174852603 (37.8084747060674, -122.414174852603)

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" 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");
Powered by Datasette · Query took 314.142ms · Data source: data.sfgov.org