194,517 rows sorted by Location descending

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location ▲ Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
158897 119775 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 10 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
159585 119687 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 5 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
160546 119721 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 1 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
173837 119695 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 13 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
178614 119779 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 14 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
179144 119773 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 8 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
180133 119735 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 15 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
187388 119776 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 11 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
189536 119688 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 6 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
11525 119754 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 9 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
13324 119752 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 7 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
14547 119749 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 4 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
33483 119753 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 8 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
55145 119750 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 5 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
110263 119755 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 106x Octavia St Frontage West 10 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
149108 119747 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 2 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
166196 119736 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 1 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
190598 119757 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 12 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
191150 119756 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 11 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
191279 119748 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 3 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
6452 109163 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 6x Octavia St Frontage West 12 Median : Cutout Tree DPW 1       3x20   2109337 6005692 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
19858 109170 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 6x Octavia St Frontage West 5 Median : Cutout Tree DPW 1       3x20   2109337 6005692 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
32680 119700 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 6x Octavia St Frontage West 2 Median : Cutout Tree DPW 1           2109337 6005692 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
46034 109168 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 6x Octavia St Frontage West 7 Median : Cutout Tree DPW 1       3x20   2109337 6005692 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
55922 109169 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 6x Octavia St Frontage West 6 Median : Cutout Tree DPW 1       3x20   2109337 6005692 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
93874 109171 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 6x Octavia St Frontage West 4 Median : Cutout Tree DPW 1       3x20   2109337 6005692 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
107729 109164 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 6x Octavia St Frontage West 11 Median : Cutout Tree DPW 1       3x20   2109337 6005692 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
161548 109167 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 6x Octavia St Frontage West 8 Median : Cutout Tree DPW 1       3x20   2109337 6005692 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
165589 119699 DPW Maintained 1 Phoenix canariensis :: Canary Island Date Palm 160 6x Octavia St Frontage West 1 Median : Cutout Tree DPW 1           2109337 6005692 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
189843 119701 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 6x Octavia St Frontage West 3 Median : Cutout Tree DPW 1           2109337 6005692 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
72238 65564 DPW Maintained 1 Tree(s) :: 17 228 Yerba Buena Rd 1 Sidewalk: Curb side : Cutout Tree Private 2   01/17/1990 12:00:00 AM     Permit Number 28463 6021524.08705829 2122941.38889516 37.8103949467147 -122.369882282876 (37.8103949467147, -122.369882282876)   2 9 62 37
174692 65563 DPW Maintained 1 Tree(s) :: 17 255 Yerba Buena Rd 1 Sidewalk: Curb side : Cutout Tree Private 2   01/16/1990 12:00:00 AM     Permit Number 28462 6021766.42970205 2122905.90070123 37.8103107984086 -122.369041103471 (37.8103107984086, -122.369041103471)   2 9 62 37
33524 65565 DPW Maintained 1 Tree(s) :: 17 282 Yerba Buena Rd 1 Sidewalk: Curb side : Cutout Tree Private 2   01/17/1990 12:00:00 AM     Permit Number 28464 6022001.13211196 2122805.77301993 37.8100487398864 -122.368221901586 (37.8100487398864, -122.368221901586)   2 9 62 37
57815 65566 Permitted Site 7 Tree(s) :: 17 340 Yerba Buena Rd 1 Sidewalk: Curb side : Cutout Tree Private 2   01/17/1990 12:00:00 AM     Permit Number 28465 6022030.55852908 2122617.11164597 37.8095323316173 -122.368107024455 (37.8095323316173, -122.368107024455)   2 9 62 37
98286 27706 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1801 The Embarcadero 1 Sidewalk: Curb side : Cutout Tree Port 6     6     6008269.247115 2122709.555122 37.8090221854411 -122.415739206432 (37.8090221854411, -122.415739206432)   1 10 308 23
125862 27707 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1801 The Embarcadero 2 Sidewalk: Curb side : Cutout Tree Port 6     6     6008269.247115 2122709.555122 37.8090221854411 -122.415739206432 (37.8090221854411, -122.415739206432)   1 10 308 23
1742 28048 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 4 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
9221 28049 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 5 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
52938 28045 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 1 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
63150 28050 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 6 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
69024 28053 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 9 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
69445 28047 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 3 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
79601 28046 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 2 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
135463 28055 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 11 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
152629 28052 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 8 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
172485 28054 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 10 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
183471 28051 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 7 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
13244 135176 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1415 The Embarcadero 9 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 5ft   6009043.29382 2122602.08116 37.8087705715725 -122.41305277089 (37.8087705715725, -122.41305277089) 3 1 10 308 23
137935 135174 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1415 The Embarcadero 7 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 5ft   6009066.35805 2122600.86777 37.8087685346166 -122.412972864314 (37.8087685346166, -122.412972864314) 3 1 10 308 23
149013 135172 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1415 The Embarcadero 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6009083.40557 2122596.81093 37.8087583524833 -122.412913579207 (37.8087583524833, -122.412913579207) 3 1 10 308 23
21235 135170 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1415 The Embarcadero 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6009098.25007 2122594.28253 37.8087522433743 -122.412862026464 (37.8087522433743, -122.412862026464) 3 1 10 308 23
151262 135168 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1415 The Embarcadero 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 5ft   6009115.60188 2122586.88161 37.8087328962651 -122.41280145172 (37.8087328962651, -122.41280145172) 3 1 10 308 23
171062 135169 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1415 The Embarcadero 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6009098.34948 2122580.92994 37.8087155861133 -122.412860737758 (37.8087155861133, -122.412860737758) 3 1 10 308 23
44262 135175 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1415 The Embarcadero 8 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6009042.10981 2122580.59629 37.808711513081 -122.413055348348 (37.808711513081, -122.413055348348) 3 1 10 308 23
143801 135173 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1415 The Embarcadero 6 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6009065.91093 2122578.9974 37.8087084590055 -122.412972864333 (37.8087084590055, -122.412972864333) 3 1 10 308 23
139111 135171 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1415 The Embarcadero 4 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6009081.53777 2122578.30683 37.8087074400539 -122.412918734125 (37.8087074400539, -122.412918734125) 3 1 10 308 23
133844 135167 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1413 The Embarcadero 14 Sidewalk: Property side : Yard Tree Private 2     8     6009297.39065 2122561.16344 37.8086724825285 -122.412170498192 (37.8086724825285, -122.412170498192) 3 1 10 308 23
169670 66415 Permitted Site 7 Tree(s) :: 17   1 Sidewalk: Curb side : Cutout Tree Private 2   02/12/1991 12:00:00 AM     Permit Number 29546 6006760.29248409 2122608.12240598 37.808658736106 -122.420954201226 (37.808658736106, -122.420954201226)   1 1 28858 32
79035 135165 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1413 The Embarcadero 12 Sidewalk: Property side : Yard Tree Private 2     8     6009319.75047 2122555.32253 37.8086576994481 -122.41209270231 (37.8086576994481, -122.41209270231) 3 1 10 308 23
147803 135177 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1415 The Embarcadero 10 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6009002.92609 2122558.40528 37.8086483824759 -122.413189385082 (37.8086483824759, -122.413189385082) 3 1 10 308 23
121184 135163 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1413 The Embarcadero 10 Sidewalk: Property side : Yard Tree Private 2     11     6009340.6942 2122549.79423 37.8086436952141 -122.412019829366 (37.8086436952141, -122.412019829366) 3 1 10 308 23
14516 135161 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1413 The Embarcadero 8 Sidewalk: Property side : Yard Tree Private 2     12     6009360.26763 2122546.84411 37.8086366930891 -122.411951881091 (37.8086366930891, -122.411951881091) 3 1 10 308 23
108338 135166 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1413 The Embarcadero 13 Sidewalk: Curb side : Yard Tree Private 2     13 Width 6ft   6009296.71843 2122542.1924 37.8086203551155 -122.412171482933 (37.8086203551155, -122.412171482933) 3 1 10 308 23
152195 135178 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1415 The Embarcadero 13 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6008933.56816 2122548.59369 37.8086175483309 -122.41342872435 (37.8086175483309, -122.41342872435) 3 1 10 308 23
9798 135164 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1413 The Embarcadero 11 Sidewalk: Curb side : Yard Tree Private 2     10 Width 6ft   6009318.81698 2122537.49043 37.8086086846186 -122.412094671852 (37.8086086846186, -122.412094671852) 3 1 10 308 23
166177 135162 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1413 The Embarcadero 9 Sidewalk: Curb side : Yard Tree Private 2     11 Width 6ft   6009337.24139 2122533.99681 37.8086001257557 -122.41203066169 (37.8086001257557, -122.41203066169) 3 1 10 308 23
168501 135179 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1415 The Embarcadero 15 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6008885.32028 2122540.99865 37.8085939851782 -122.41359516279 (37.8085939851782, -122.41359516279) 3 1 10 308 23
81836 135157 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1413 The Embarcadero 4 Sidewalk: Property side : Yard Tree Private 2     6     6009451.25096 2122529.40055 37.8085939015448 -122.411635772999 (37.8085939015448, -122.411635772999) 3 1 10 308 23
91865 135160 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1413 The Embarcadero 7 Sidewalk: Curb side : Yard Tree Private 2     12 Width 6ft   6009356.48989 2122529.06979 37.8085876773375 -122.411963698174 (37.8085876773375, -122.411963698174) 3 1 10 308 23
28678 135180 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1415 The Embarcadero 16 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6008860.7937 2122537.90132 37.8085841034484 -122.413679824982 (37.8085841034484, -122.413679824982) 3 1 10 308 23
73089 135156 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1413 The Embarcadero 3 Sidewalk: Property side : Yard Tree Private 2     13     6009480.72759 2122523.69804 37.8085798973177 -122.411533357278 (37.8085798973177, -122.411533357278) 3 1 10 308 23
115662 135159 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1413 The Embarcadero 6 Sidewalk: Curb side : Yard Tree Private 2     11 Width 6ft   6009379.72618 2122524.34495 37.8085760077391 -122.41188294806 (37.8085760077391, -122.41188294806) 3 1 10 308 23
3092 261228 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1415 The Embarcadero 18 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   6008836.81707 2122534.51599 37.8085734617661 -122.413762563504 (37.8085734617661, -122.413762563504) 3 1 10 308 23
15436 261230 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1415 The Embarcadero 20 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   6008836.81707 2122534.51599 37.8085734617661 -122.413762563504 (37.8085734617661, -122.413762563504) 3 1 10 308 23
18299 261229 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1415 The Embarcadero 19 Sidewalk: Curb side : Cutout Tree Private 2       Width 4ft   6008836.81707 2122534.51599 37.8085734617661 -122.413762563504 (37.8085734617661, -122.413762563504) 3 1 10 308 23
130350 135181 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1415 The Embarcadero 17 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6008836.81707 2122534.51599 37.8085734617661 -122.413762563504 (37.8085734617661, -122.413762563504) 3 1 10 308 23
31143 135158 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1413 The Embarcadero 5 Sidewalk: Curb side : Yard Tree Private 2     12 Width 6ft   6009395.60812 2122521.7536 37.8085697835351 -122.411827800712 (37.8085697835351, -122.411827800712) 3 1 10 308 23
38514 135155 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1413 The Embarcadero 2 Sidewalk: Property side : Yard Tree Private 2     6     6009496.8532 2122519.11823 37.8085682268067 -122.411477226088 (37.8085682268067, -122.411477226088) 3 1 10 308 23
62841 131232 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1403 The Embarcadero 27 Sidewalk: Curb side : Pot Tree Private 2     34 Width 10ft   6009815.09333 2122512.40886 37.8085676494355 -122.410375388423 (37.8085676494355, -122.410375388423) 3 1 10 308 23
64174 135153 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1411 The Embarcadero 10 Sidewalk: Property side : Yard Tree Private 2     13     6009517.81435 2122514.43966 37.8085565563141 -122.41140435313 (37.8085565563141, -122.41140435313) 3 1 10 308 23
102118 135137 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1405 The Embarcadero 9 Sidewalk: Property side : Yard Tree Private 2     7     6009675.17252 2122510.18452 37.8085536973592 -122.410859468299 (37.8085536973592, -122.410859468299) 3 1 10 308 23
148565 135151 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1411 The Embarcadero 8 Sidewalk: Property side : Yard Tree Private 2     8     6009534.78747 2122509.55925 37.8085441079032 -122.411345267671 (37.8085441079032, -122.411345267671) 3 1 10 308 23
79974 135133 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1405 The Embarcadero 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6009697.90214 2122506.13355 37.808543848874 -122.410780519498 (37.808543848874, -122.410780519498) 3 1 10 308 23
81193 135149 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1411 The Embarcadero 6 Sidewalk: Property side : Yard Tree Private 2     12     6009556.32302 2122505.15261 37.8085332161949 -122.411270426102 (37.8085332161949, -122.411270426102) 3 1 10 308 23
59597 135129 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1405 The Embarcadero 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6009719.11313 2122501.21683 37.8085315380587 -122.4107067652 (37.8085315380587, -122.4107067652) 3 1 10 308 23
174271 135147 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1411 The Embarcadero 4 Sidewalk: Property side : Yard Tree Private 2     12     6009572.95679 2122501.76157 37.8085248381209 -122.411212620383 (37.8085248381209, -122.411212620383) 3 1 10 308 23
148183 135136 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1405 The Embarcadero 8 Sidewalk: Property side : Yard Tree Private 2     7     6009674.61624 2122497.64189 37.8085192272561 -122.410860507034 (37.8085192272561, -122.410860507034) 3 1 10 308 23
132033 135154 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1413 The Embarcadero 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 6ft   6009495.3394 2122500.73102 37.8085176552447 -122.41148116512 (37.8085176552447, -122.41148116512) 3 1 10 308 23
182652 135145 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1411 The Embarcadero 2 Sidewalk: Property side : Yard Tree Private 2     10     6009594.12763 2122497.09351 37.808513208082 -122.411139022559 (37.808513208082, -122.411139022559) 3 1 10 308 23
89379 135127 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 29 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6009796.65177 2122491.2642 37.8085085577008 -122.410437716824 (37.8085085577008, -122.410437716824) 3 1 10 308 23
112722 135152 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1411 The Embarcadero 9 Sidewalk: Curb side : Yard Tree Private 2     8 Width 6ft   6009514.30378 2122495.80991 37.808505206806 -122.411415185469 (37.808505206806, -122.411415185469) 3 1 10 308 23
176066 135125 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 26 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6009814.02361 2122489.41499 37.8085044540716 -122.410377465851 (37.8085044540716, -122.410377465851) 3 1 10 308 23
98769 135143 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1405 The Embarcadero 15 Sidewalk: Property side : Yard Tree Private 2     12     6009614.4871 2122492.89174 37.8085028128125 -122.411068265698 (37.8085028128125, -122.411068265698) 3 1 10 308 23
153021 135132 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1405 The Embarcadero 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6009696.09091 2122490.92652 37.8085019926339 -122.410785713093 (37.8085019926339, -122.410785713093) 3 1 10 308 23
107400 135150 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1411 The Embarcadero 7 Sidewalk: Curb side : Yard Tree Private 2     13 Width 6ft   6009533.57548 2122492.01614 37.8084958709589 -122.411348221963 (37.8084958709589, -122.411348221963) 3 1 10 308 23
115460 135141 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1405 The Embarcadero 13 Sidewalk: Property side : Yard Tree Private 2     5     6009636.62254 2122489.1519 37.8084937854328 -122.410991395247 (37.8084937854328, -122.410991395247) 3 1 10 308 23
70982 135148 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1411 The Embarcadero 5 Sidewalk: Curb side : Yard Tree Private 2     12 Width 6ft   6009553.89624 2122488.10727 37.8084862778736 -122.411277619761 (37.8084862778736, -122.411277619761) 3 1 10 308 23
163913 135139 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1405 The Embarcadero 11 Sidewalk: Property side : Yard Tree Private 2     5     6009651.5635 2122485.85771 37.8084855782253 -122.410939454894 (37.8084855782253, -122.410939454894) 3 1 10 308 23
56858 135128 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1403 The Embarcadero 30 Sidewalk: Curb side : Yard Tree Private 2     11 Width 7ft   6009778.15443 2122482.07693 37.8084822947981 -122.410501083081 (37.8084822947981, -122.410501083081) 3 1 10 308 23
103186 135146 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1411 The Embarcadero 3 Sidewalk: Curb side : Yard Tree Private 2     10 Width 6ft   6009571.76938 2122485.2677 37.8084794835077 -122.411215563861 (37.8084794835077, -122.411215563861) 3 1 10 308 23

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);