trees
194,517 rows sorted by Location descending
This data as json, CSV (advanced)
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );