trees
27,746 rows where qCaretaker_id = 1 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) | ||||||||||
36363 | 21824 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2741 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6008240.40798 | 2122263.00335 | 37.8077944465112 | -122.415807371838 | (37.8077944465112, -122.415807371838) | 5 | 1 | 10 | 308 | 23 | |||
8516 | 21797 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2600X Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/22/2016 12:00:00 AM | 12 | 3X3 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
73509 | 21808 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2600X Taylor St | 13 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 03/01/2016 12:00:00 AM | 3 | 4x4 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
87782 | 21807 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2600X Taylor St | 12 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 03/01/2016 12:00:00 AM | 3 | 3X3 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
154973 | 21805 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2600X Taylor St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2016 12:00:00 AM | 3 | 3X3 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
181027 | 21804 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2600X Taylor St | 9 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 01/22/2016 12:00:00 AM | 12 | 3X3 | 6008553.39113 | 2121935.04647 | 37.8069115498008 | -122.414700989571 | (37.8069115498008, -122.414700989571) | 3 | 1 | 10 | 308 | 23 | ||
1343 | 23590 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3251X Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005329.9297952 | 2121916.8669395 | 37.8066799978444 | -122.425855144407 | (37.8066799978444, -122.425855144407) | 13 | 1 | 1 | 28858 | 17 | |||
47583 | 23589 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3251X Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005329.9297952 | 2121916.8669395 | 37.8066799978444 | -122.425855144407 | (37.8066799978444, -122.425855144407) | 13 | 1 | 1 | 28858 | 17 | |||
67130 | 23587 | DPW Maintained 1 | Schinus terebinthifolius :: Brazilian Pepper 93 | 3251X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005329.9297952 | 2121916.8669395 | 37.8066799978444 | -122.425855144407 | (37.8066799978444, -122.425855144407) | 13 | 1 | 1 | 28858 | 17 | |||
147188 | 23591 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 3251X Van Ness Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005329.9297952 | 2121916.8669395 | 37.8066799978444 | -122.425855144407 | (37.8066799978444, -122.425855144407) | 13 | 1 | 1 | 28858 | 17 | |||
87422 | 136910 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2210 Stockton St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6009806.2153 | 2121790.84358 | 37.8065859141719 | -122.410355131177 | (37.8065859141719, -122.410355131177) | 3 | 1 | 10 | 308 | 23 | |||
128926 | 20260 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2210 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 4x3 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | 3 | 1 | 10 | 308 | 23 | |||
76919 | 131571 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2753 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | Width 3ft | 6006844.83313 | 2121827.18863 | 37.8065192573265 | -122.420606150667 | (37.8065192573265, -122.420606150667) | 5 | 1 | 1 | 28858 | 32 | |||
91316 | 132112 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 13 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6011208.19344 | 2121737.88602 | 37.8065189965151 | -122.405499565575 | (37.8065189965151, -122.405499565575) | 3 | 1 | 10 | 308 | 23 | |||
98334 | 20270 | DPW Maintained 1 | Acacia longifolia :: Golden Wattle 150 | 2290 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 4x3 | 6009846.48172 | 2121764.71414 | 37.8065164263834 | -122.410213935106 | (37.8065164263834, -122.410213935106) | 3 | 1 | 10 | 308 | 23 | |||
95994 | 11181 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2750X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6006890.68476 | 2121823.94924 | 37.8065129467732 | -122.420447242256 | (37.8065129467732, -122.420447242256) | 5 | 1 | 1 | 28858 | 32 | |||
152277 | 131962 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2753 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/1997 12:00:00 AM | 5 | Width 3ft | 6006843.61903 | 2121816.35124 | 37.806489432204 | -122.420609582486 | (37.806489432204, -122.420609582486) | 5 | 1 | 1 | 28858 | 32 | ||
140473 | 11180 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2750X Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006892.18437 | 2121805.14198 | 37.806461391357 | -122.420440716763 | (37.806461391357, -122.420440716763) | 5 | 1 | 1 | 28858 | 32 | |||
20141 | 132092 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 12 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6011191.46105 | 2121714.36376 | 37.806453474602 | -122.405555813649 | (37.806453474602, -122.405555813649) | 3 | 1 | 10 | 308 | 23 | |||
29595 | 20276 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2291 Stockton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6009755.78997 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | 3 | 1 | 10 | 308 | 23 | |||
154774 | 131963 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2753 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 3ft | 6006844.59432 | 2121791.39678 | 37.8064209686093 | -122.420604434741 | (37.8064209686093, -122.420604434741) | 5 | 1 | 1 | 28858 | 32 | |||
85699 | 11179 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2750X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3x3 | 6006893.59102 | 2121789.4662 | 37.8064184289444 | -122.4204347354 | (37.8064184289444, -122.4204347354) | 5 | 1 | 1 | 28858 | 32 | |||
130505 | 132111 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 11 | Median : Yard | Tree | DPW 1 | 22 | Width 10ft | 6011290.22315 | 2121683.26622 | 37.8063736103221 | -122.40521183647 | (37.8063736103221, -122.40521183647) | 3 | 1 | 10 | 308 | 23 | |||
42328 | 29773 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1323 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2006 12:00:00 AM | 8 | 3x3 | 6007274.40422 | 2121764.03489 | 37.8063700535072 | -122.41911505491 | (37.8063700535072, -122.41911505491) | 5 | 1 | 1 | 28858 | 32 | ||
39137 | 11183 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2765 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/1997 12:00:00 AM | 12 | 3X3 | 6006851.5978528 | 2121751.8788051 | 37.8063128570627 | -122.420577390706 | (37.8063128570627, -122.420577390706) | 5 | 1 | 1 | 28858 | 32 | ||
98064 | 11184 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2765 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6006851.5978528 | 2121751.8788051 | 37.8063128570627 | -122.420577390706 | (37.8063128570627, -122.420577390706) | 5 | 1 | 1 | 28858 | 32 | |||
176773 | 11182 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2765 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006851.5978528 | 2121751.8788051 | 37.8063128570627 | -122.420577390706 | (37.8063128570627, -122.420577390706) | 5 | 1 | 1 | 28858 | 32 | |||
48409 | 132091 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 10 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6011272.98764 | 2121658.8993 | 37.8063057411882 | -122.405269766312 | (37.8063057411882, -122.405269766312) | 3 | 1 | 10 | 308 | 23 | |||
1842 | 11178 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2741 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6006856.2652 | 2121744.00393 | 37.8062914977061 | -122.420560679149 | (37.8062914977061, -122.420560679149) | 5 | 1 | 1 | 28858 | 32 | |||
1376 | 263620 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 3 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
3583 | 111721 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 950X Beach St | 2 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||||
10225 | 263619 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 2 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
10567 | 263621 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 4 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
11694 | 263618 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 1 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
64526 | 111722 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 950X Beach St | 3 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||||
94245 | 111724 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 950X Beach St | 5 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||||
109267 | 111723 | DPW Maintained 1 | Populus spp :: Poplar Spp 262 | 950X Beach St | 4 | Sidewalk: Curb side : Yard | Tree | DPW 1 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||||
168330 | 132110 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 9 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6011374.63029 | 2121626.67271 | 37.8062229369941 | -122.404915741893 | (37.8062229369941, -122.404915741893) | 3 | 1 | 10 | 308 | 23 | |||
4334 | 136909 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2210 Stockton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | Width 3ft | 6009830.0684 | 2121639.18274 | 37.8061708284786 | -122.410261867902 | (37.8061708284786, -122.410261867902) | 3 | 1 | 10 | 308 | 23 | |||
75327 | 132090 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 8 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6011358.77785 | 2121601.92287 | 37.8061540939119 | -122.40496885854 | (37.8061540939119, -122.40496885854) | 3 | 1 | 10 | 308 | 23 | |||
52151 | 132109 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 7 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6011459.50109 | 2121569.1071 | 37.8060696196846 | -122.404617975463 | (37.8060696196846, -122.404617975463) | 3 | 1 | 10 | 308 | 23 | |||
36850 | 21792 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2598 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008439.13676 | 2121624.27905 | 37.8060518410095 | -122.415074380155 | (37.8060518410095, -122.415074380155) | 3 | 1 | 10 | 308 | 23 | |||
100104 | 21793 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2598 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008439.13676 | 2121624.27905 | 37.8060518410095 | -122.415074380155 | (37.8060518410095, -122.415074380155) | 3 | 1 | 10 | 308 | 23 | |||
142913 | 21795 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2598 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008439.13676 | 2121624.27905 | 37.8060518410095 | -122.415074380155 | (37.8060518410095, -122.415074380155) | 3 | 1 | 10 | 308 | 23 | |||
145684 | 21794 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2598 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 4X4 | 6008439.13676 | 2121624.27905 | 37.8060518410095 | -122.415074380155 | (37.8060518410095, -122.415074380155) | 3 | 1 | 10 | 308 | 23 | |||
103593 | 130948 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2501 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/2015 12:00:00 AM | 2 | Width 3ft | 6008329.55597 | 2121605.69745 | 37.8059946620911 | -122.415452287105 | (37.8059946620911, -122.415452287105) | 5 | 1 | 10 | 308 | 23 | ||
145461 | 132089 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 6 | Median : Yard | Tree | DPW 1 | 23 | Width 10ft | 6011437.6783 | 2121540.455 | 37.8059897284039 | -122.404691478852 | (37.8059897284039, -122.404691478852) | 3 | 1 | 10 | 308 | 23 | |||
183018 | 11170 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2706 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6006921.64786 | 2121607.86712 | 37.805921385333 | -122.42032474199 | (37.805921385333, -122.42032474199) | 5 | 1 | 1 | 28858 | 32 | |||
32861 | 11174 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2721 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6006871.9159428 | 2121607.3582758 | 37.8059171856884 | -122.420496811264 | (37.8059171856884, -122.420496811264) | 5 | 1 | 1 | 28858 | 32 | |||
103532 | 88132 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 6007534.97421 | 2121589.88295 | 37.8059065468398 | -122.418200949141 | (37.8059065468398, -122.418200949141) | 5 | 1 | 10 | 308 | 23 | ||||
187099 | 132108 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 5 | Median : Yard | Tree | DPW 1 | 21 | Width 10ft | 6011532.66827 | 2121506.48507 | 37.8059017639302 | -122.404360356561 | (37.8059017639302, -122.404360356561) | 3 | 1 | 10 | 28860 | 23 | |||
58554 | 87738 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3200X Van Ness Ave | 10 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005444.64461 | 2121623.98788 | 37.8058823097966 | -122.425437295217 | (37.8058823097966, -122.425437295217) | 5 | 1 | 1 | 28858 | 32 | ||
181937 | 87739 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 3200X Van Ness Ave | 11 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005433.61853 | 2121623.41722 | 37.8058801199389 | -122.425475412067 | (37.8058801199389, -122.425475412067) | 13 | 1 | 1 | 28858 | 17 | ||
46872 | 27432 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 4X4 | 6007580.92749 | 2121572.89753 | 37.8058624956614 | -122.418040715371 | (37.8058624956614, -122.418040715371) | 5 | 1 | 10 | 308 | 23 | |||
89322 | 11169 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2700 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6006924.13035 | 2121583.86925 | 37.8058556331999 | -122.420314446577 | (37.8058556331999, -122.420314446577) | 5 | 1 | 1 | 28858 | 32 | |||
34503 | 21789 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2585 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/20/2015 12:00:00 AM | 3 | 4X4 | 6008161.90241 | 2121549.79462 | 37.8058317424248 | -122.41602851934 | (37.8058317424248, -122.41602851934) | 5 | 1 | 10 | 308 | 23 | ||
71054 | 21785 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2585 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008161.90241 | 2121549.79462 | 37.8058317424248 | -122.41602851934 | (37.8058317424248, -122.41602851934) | 5 | 1 | 10 | 308 | 23 | |||
191196 | 21788 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2585 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2006 12:00:00 AM | 3 | 4X4 | 6008161.90241 | 2121549.79462 | 37.8058317424248 | -122.41602851934 | (37.8058317424248, -122.41602851934) | 5 | 1 | 10 | 308 | 23 | ||
87732 | 132088 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 4 | Median : Yard | Tree | DPW 1 | 22 | Width 10ft | 6011509.10408 | 2121480.92062 | 37.8058302534199 | -122.404440103948 | (37.8058302534199, -122.404440103948) | 3 | 1 | 10 | 28860 | 23 | |||
189542 | 27431 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 4X4 | 6007595.97622 | 2121559.89845 | 37.8058276504572 | -122.41798771471 | (37.8058276504572, -122.41798771471) | 5 | 1 | 10 | 308 | 23 | |||
166197 | 27430 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 1288 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 4X4 | 6007606.86637 | 2121548.41017 | 37.8057967194592 | -122.417949212693 | (37.8057967194592, -122.417949212693) | 5 | 1 | 10 | 308 | 23 | |||
37710 | 4753 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 4X4 | 6007719.65165 | 2121534.55679 | 37.8057650284682 | -122.417557918763 | (37.8057650284682, -122.417557918763) | 5 | 1 | 10 | 308 | 23 | |||
39012 | 4754 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 4X4 | 6007719.65165 | 2121534.55679 | 37.8057650284682 | -122.417557918763 | (37.8057650284682, -122.417557918763) | 5 | 1 | 10 | 308 | 23 | |||
89782 | 4755 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 4X4 | 6007719.65165 | 2121534.55679 | 37.8057650284682 | -122.417557918763 | (37.8057650284682, -122.417557918763) | 5 | 1 | 10 | 308 | 23 | |||
191952 | 29729 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1250 Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/19/2006 12:00:00 AM | 8 | 4x4 | 6007719.65165 | 2121534.55679 | 37.8057650284682 | -122.417557918763 | (37.8057650284682, -122.417557918763) | 5 | 1 | 10 | 308 | 23 | ||
175303 | 132107 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 3 | Median : Yard | Tree | DPW 1 | 22 | Width 10ft | 6011604.73213 | 2121437.14607 | 37.8057154028122 | -122.404106084029 | (37.8057154028122, -122.404106084029) | 3 | 1 | 10 | 28860 | 23 | |||
135227 | 21781 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550X Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/12/2011 12:00:00 AM | 3 | 4x4 | 6008458.56586 | 2121488.77145 | 37.8056808631332 | -122.41499754514 | (37.8056808631332, -122.41499754514) | 3 | 1 | 10 | 308 | 23 | ||
176301 | 21784 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550X Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2016 12:00:00 AM | 12 | 4X4 | 6008458.56586 | 2121488.77145 | 37.8056808631332 | -122.41499754514 | (37.8056808631332, -122.41499754514) | 3 | 1 | 10 | 308 | 23 | ||
83186 | 132087 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 1500x The Embarcadero | 2 | Median : Yard | Tree | DPW 1 | 20 | Width 10ft | 6011581.4658 | 2121414.59731 | 37.8056521894584 | -122.404185013045 | (37.8056521894584, -122.404185013045) | 3 | 1 | 10 | 28860 | 23 | |||
114579 | 87735 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3200X Van Ness Ave | 7 | Median : Cutout | Tree | DPW 1 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005457.064 | 2121526.81323 | 37.8056161950061 | -122.425387396305 | (37.8056161950061, -122.425387396305) | 5 | 1 | 1 | 28858 | 32 |
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) );