trees
13 rows where PlotSize = "Width 6ft" and qSpecies_id = 86
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40385 | 215342 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Circular Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 5999549.56796 | 2093580.96212 | 37.7285483748934 | -122.443822037778 | (37.7285483748934, -122.443822037778) | 9 | 7 | 4 | 63 | 40 | |||
44075 | 215290 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 496 Pacheco St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 6ft | 5993542.94164 | 2101911.83549 | 37.7510784210541 | -122.465191965655 | (37.7510784210541, -122.465191965655) | 1 | 8 | 4 | 29491 | 12 | |||
46050 | 215344 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Circular Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5999563.31377 | 2093588.13313 | 37.7285688488645 | -122.443775032896 | (37.7285688488645, -122.443775032896) | 9 | 7 | 4 | 63 | 40 | |||
79418 | 179867 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 985 Avalon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 6ft | 6005404.97601 | 2092232.73416 | 37.7251786880381 | -122.423483738408 | (37.7251786880381, -122.423483738408) | 9 | 7 | 6 | 309 | 5 | |||
105016 | 136696 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1063 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 6ft | 6007280.02976 | 2120167.28303 | 37.8019860950362 | -122.418982261931 | (37.8019860950362, -122.418982261931) | 5 | 1 | 1 | 28858 | 32 | |||
105158 | 215289 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 496 Pacheco St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 6ft | 5993555.20621 | 2101912.20382 | 37.7510801396391 | -122.465149580605 | (37.7510801396391, -122.465149580605) | 1 | 8 | 4 | 29491 | 12 | |||
121616 | 136698 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1047 Lombard St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6007369.77523 | 2120178.57084 | 37.802022141674 | -122.418672500363 | (37.802022141674, -122.418672500363) | 5 | 1 | 1 | 28858 | 32 | |||
124331 | 215343 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 450 Circular Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5999604.29165 | 2093616.12751 | 37.7286480521422 | -122.443635380789 | (37.7286480521422, -122.443635380789) | 9 | 7 | 4 | 63 | 40 | |||
133349 | 136697 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 1047 Lombard St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6007352.71781 | 2120177.3681 | 37.80201787889 | -122.418731441927 | (37.80201787889, -122.418731441927) | 5 | 1 | 1 | 28858 | 32 | |||
133906 | 179882 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 323 Pioche St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 6005924.81091 | 2093297.57145 | 37.7281318260086 | -122.421762319978 | (37.7281318260086, -122.421762319978) | 9 | 7 | 7 | 309 | 5 | |||
161461 | 215320 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 613 Head St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 5993477.4709 | 2089866.91929 | 37.7180022959343 | -122.464543873715 | (37.7180022959343, -122.464543873715) | 9 | 8 | 6 | 64 | 24 | |||
175773 | 179848 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 801 Delano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 5998870.31235 | 2090001.49747 | 37.7186812265492 | -122.445912915673 | (37.7186812265492, -122.445912915673) | 9 | 7 | 6 | 28861 | 25 | |||
188918 | 179849 | DPW Maintained 1 | Taxus baccata :: Irish Yew 86 | 801 Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 5998875.31966 | 2090008.53873 | 37.7187008461546 | -122.445896113635 | (37.7187008461546, -122.445896113635) | 9 | 7 | 6 | 28861 | 25 |
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) );