trees
10 rows where PlotSize = "Width 3ft", SiteOrder = 3 and qSpecies_id = 65 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23352 | 203570 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 551 Pacheco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993253.16761 | 2101842.90601 | 37.7508724439217 | -122.466189017022 | (37.7508724439217, -122.466189017022) | 1 | 8 | 4 | 29491 | 40 | |||
| 40387 | 203586 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 77 Staples Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 3ft | 5999493.48314 | 2093757.18666 | 37.7290290472426 | -122.444028582376 | (37.7290290472426, -122.444028582376) | 9 | 7 | 4 | 63 | 40 | |||
| 79681 | 221871 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 619 Eugenia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007314.53376 | 2097779.75076 | 37.7405171804218 | -122.417275479073 | (37.7405171804218, -122.417275479073) | 2 | 7 | 7 | 28859 | 2 | |||
| 85330 | 221801 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 378 Valley St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6003412.45231 | 2099242.88691 | 37.7443143087709 | -122.430871746349 | (37.7443143087709, -122.430871746349) | 2 | 7 | 5 | 63 | 22 | |||
| 93237 | 203567 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 209 Colon Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 3ft | 5996068.02094 | 2094221.27645 | 37.7301073235953 | -122.455904133578 | (37.7301073235953, -122.455904133578) | 9 | 7 | 4 | 28861 | 40 | |||
| 114883 | 221926 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 651 Noe St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003063.55536 | 2104400.84265 | 37.7584570634637 | -122.432446488035 | (37.7584570634637, -122.432446488035) | 2 | 4 | 5 | 28862 | 3 | |||
| 139805 | 117947 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3851 Cabrillo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5983640.26853 | 2110338.90864 | 37.7736407564987 | -122.500058768002 | (37.7736407564987, -122.500058768002) | 11 | 6 | 2 | 55 | 26 | |||
| 149081 | 221900 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 7 Marsily St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004249.68912 | 2095508.61359 | 37.7341082463924 | -122.427710746252 | (37.7341082463924, -122.427710746252) | 2 | 7 | 5 | 28861 | 25 | |||
| 188028 | 221867 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2825 Diamond St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002454.8642 | 2095527.53959 | 37.7340585219649 | -122.43391736341 | (37.7340585219649, -122.43391736341) | 2 | 7 | 5 | 63 | 7 | |||
| 189738 | 203583 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Gennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5997456.92965 | 2093746.95791 | 37.72888457474 | -122.451068332359 | (37.72888457474, -122.451068332359) | 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) );