trees
15 rows where DBH = 18 and qCaretaker_id = 4 sorted by qCareAssistant
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7851 | 220311 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 4235 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 18 | Width 3ft | 6001938.02984 | 2104676.35813 | 37.7591496745354 | -122.436358769151 | (37.7591496745354, -122.436358769151) | 2 | 4 | 5 | 28862 | 3 | |||
| 38417 | 95498 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X 32nd Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 18 | 3x3 | 5985976.05543 | 2112422.37376 | 37.7794981665366 | -122.492132474117 | (37.7794981665366, -122.492132474117) | 11 | 6 | 2 | 55 | 26 | |||
| 110617 | 225504 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 450 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 18 | 6x6 | 6004179.96928 | 2106475.61191 | 37.7642171285539 | -122.428733333881 | (37.7642171285539, -122.428733333881) | 8 | 4 | 5 | 28862 | 3 | |||
| 118868 | 95499 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 500X 32nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 18 | 3x3 | 5985977.73249 | 2112402.27637 | 37.7794430828921 | -122.49212519236 | (37.7794430828921, -122.49212519236) | 11 | 6 | 2 | 55 | 26 | |||
| 18970 | 97073 | DPW Maintained 1 | Tree(s) :: 17 | 1551 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 4x4 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
| 24349 | 97071 | DPW Maintained 1 | Tree(s) :: 17 | 1551 Newcomb Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 4x4 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
| 33876 | 115549 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 925x Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 20x7 | 6015281.58054 | 2104112.34112 | 37.7583501556473 | -122.390170593412 | (37.7583501556473, -122.390170593412) | 10 | 3 | 8 | 28856 | 29 | ||
| 36749 | 122752 | DPW Maintained 1 | Ficus microcarpa :: Chinese Banyan 97 | 693 Vermont St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 6011278.80569 | 2105286.3398 | 37.7613508668666 | -122.404096651066 | (37.7613508668666, -122.404096651066) | 10 | 3 | 8 | 28856 | 29 | |||
| 38426 | 115550 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 925x Minnesota St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 20x7 | 6015279.22506 | 2104155.94994 | 37.7584697654838 | -122.390181786362 | (37.7584697654838, -122.390181786362) | 10 | 3 | 8 | 28856 | 29 | ||
| 51914 | 95459 | Undocumented 4 | Corymbia ficifolia :: Red Flowering Gum 28 | 657X 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 3x3 | 5986588.2 | 2111449.2 | 37.776861872872 | -122.489943238472 | (37.776861872872, -122.489943238472) | 11 | 6 | 2 | 55 | 26 | ||
| 130673 | 102193 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 3999X Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 3x3 | 6008408 | 2096514 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | 10 | 7 | 7 | 28859 | 2 | ||
| 133629 | 97072 | DPW Maintained 1 | Tree(s) :: 17 | 1551 Newcomb Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 4x4 | 6015475.3 | 2095481.7 | 37.7346629526589 | -122.388898077079 | (37.7346629526589, -122.388898077079) | 10 | 3 | 8 | 58 | 1 | ||
| 134813 | 122751 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 693 Vermont St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 6011280.99043 | 2105260.13165 | 37.7612790272197 | -122.404087250433 | (37.7612790272197, -122.404087250433) | 10 | 3 | 8 | 28856 | 29 | |||
| 149298 | 95153 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 250 23rd Ave | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 18 | 5988721.45224 | 2113658.22406 | 37.783051567455 | -122.482725682991 | (37.783051567455, -122.482725682991) | 11 | 6 | 2 | 55 | 26 | |||
| 189005 | 75040 | DPW Maintained 1 | Tree(s) :: 17 | 499X Hearst Ave | 2 | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/15/1999 12:00:00 AM | 18 | 6x20 | 5998132.77434913 | 2094246.31790382 | 37.7302943698097 | -122.448767853229 | (37.7302943698097, -122.448767853229) | 9 | 7 | 4 | 28861 | 40 |
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) );