trees
16 rows where PlotSize = "" and qSpecies_id = 87 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 300 | 234411 | DPW Maintained 1 | Phoenix dactylifera :: Date Palm 87 | 10x Benton Ave | 4 | Median : Yard | Tree | DPW 1 | 32 | 6004755.33467 | 2095032.93123 | 37.7328307189427 | -122.425928720736 | (37.7328307189427, -122.425928720736) | 2 | 7 | 7 | 28861 | 2 | ||||
| 25053 | 194399 | DPW Maintained 1 | Phoenix dactylifera :: Date Palm 87 | 1121 Jamestown Ave | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6013370.43296 | 2090062.5178 | 37.7196660858089 | -122.395795770954 | (37.7196660858089, -122.395795770954) | 10 | 3 | 8 | 58 | 1 | ||||
| 27847 | 194401 | DPW Maintained 1 | Phoenix dactylifera :: Date Palm 87 | 1121 Jamestown Ave | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6013389.43326 | 2090047.39318 | 37.719625613601 | -122.395729034071 | (37.719625613601, -122.395729034071) | 10 | 3 | 8 | 58 | 1 | ||||
| 33998 | 178089 | DPW Maintained 1 | Phoenix dactylifera :: Date Palm 87 | 627 Paris St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 37 | 6001428.27595 | 2089993.7852 | 37.7188057808522 | -122.437070533975 | (37.7188057808522, -122.437070533975) | 9 | 7 | 6 | 28861 | 5 | ||||
| 53949 | 210931 | DPW Maintained 1 | Phoenix dactylifera :: Date Palm 87 | 2 Edna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | 5998770.31007 | 2092974.74869 | 37.7268393752316 | -122.446472369507 | (37.7268393752316, -122.446472369507) | 9 | 7 | 4 | 28861 | 40 | ||||
| 58534 | 107481 | DPW Maintained 1 | Phoenix dactylifera :: Date Palm 87 | 1300x Montgomery St | 1 | Median : Cutout | Tree | DPW 1 | 6011490.99877 | 2119741.79528 | 37.8010540290465 | -122.404380271142 | (37.8010540290465, -122.404380271142) | 3 | 1 | 10 | 308 | 23 | |||||
| 66704 | 107130 | Property Tree 8 | Phoenix dactylifera :: Date Palm 87 | 751 DOLORES ST | 1 | Front Yard : Cutout | Tree | Private 2 | 6005081.8 | 2103948.4 | 37.7573290011944 | -122.425434294507 | (37.7573290011944, -122.425434294507) | 2 | 4 | 5 | 28859 | 19 | |||||
| 80394 | 194400 | DPW Maintained 1 | Phoenix dactylifera :: Date Palm 87 | 1121 Jamestown Ave | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6013373.9192 | 2090059.88362 | 37.7196590468175 | -122.395783535707 | (37.7196590468175, -122.395783535707) | 10 | 3 | 8 | 58 | 1 | ||||
| 90927 | 194398 | DPW Maintained 1 | Phoenix dactylifera :: Date Palm 87 | 1121 Jamestown Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6013340.66521 | 2090086.19155 | 37.7197294331555 | -122.395900326164 | (37.7197294331555, -122.395900326164) | 10 | 3 | 8 | 58 | 1 | ||||
| 96400 | 234415 | DPW Maintained 1 | Phoenix dactylifera :: Date Palm 87 | 10x Benton Ave | 5 | Median : Yard | Tree | DPW 1 | 33 | 6004760.79404 | 2095007.84902 | 37.732762157335 | -122.425908061504 | (37.732762157335, -122.425908061504) | 2 | 7 | 7 | 28861 | 2 | ||||
| 124793 | 69360 | DPW Maintained 1 | Phoenix dactylifera :: Date Palm 87 | 1695 North Point St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1994 12:00:00 AM | 4 | Permit Number 33454 | 6002664.21541 | 2120911.8448 | 37.803769467759 | -122.435008424509 | (37.803769467759, -122.435008424509) | 13 | 9 | 1 | 57 | 17 | ||
| 151503 | 210930 | DPW Maintained 1 | Phoenix dactylifera :: Date Palm 87 | 2 Edna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 44 | 5998770.14435 | 2092952.36281 | 37.7267778993647 | -122.446471332592 | (37.7267778993647, -122.446471332592) | 9 | 7 | 4 | 28861 | 40 | ||||
| 160743 | 234409 | DPW Maintained 1 | Phoenix dactylifera :: Date Palm 87 | 1750x Dolores St | 2 | Median : Yard | Tree | DPW 1 | 18 | 6005335.11777 | 2098093.36784 | 37.7412667401708 | -122.424141835295 | (37.7412667401708, -122.424141835295) | 2 | 7 | 5 | 63 | 7 | ||||
| 176164 | 234408 | DPW Maintained 1 | Phoenix dactylifera :: Date Palm 87 | 1700x Dolores St | 6 | Median : Yard | Tree | DPW 1 | 18 | 6005328.71951 | 2098210.15562 | 37.7415870517023 | -122.424172262039 | (37.7415870517023, -122.424172262039) | 2 | 7 | 5 | 63 | 7 | ||||
| 185787 | 178097 | DPW Maintained 1 | Phoenix dactylifera :: Date Palm 87 | 201 Trumbull St | 71 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6004719.38437 | 2094363.75444 | 37.7309912771155 | -122.426005390643 | (37.7309912771155, -122.426005390643) | 9 | 7 | 6 | 28861 | 5 | ||||
| 192523 | 234407 | DPW Maintained 1 | Phoenix dactylifera :: Date Palm 87 | 100x Dolores St | 8 | Median : Yard | Tree | DPW 1 | 18 | 6004812.29017 | 2107562.9589 | 37.7672384899902 | -122.426623750084 | (37.7672384899902, -122.426623750084) | 8 | 4 | 5 | 28862 | 3 |
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) );