trees
8 rows where PlotSize = "Width 4ft", Supervisor Districts = 5 and qSpecies_id = 5
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4441 | 246422 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Duncan St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6003829.35465 | 2099854.81871 | 37.7460181445246 | -122.429473817668 | (37.7460181445246, -122.429473817668) | 2 | 7 | 5 | 63 | 22 | |||
| 31579 | 225050 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 500x 27th St | 24 | Median : Cutout | Tree | DPW 1 | 11 | Width 4ft | 6002949.31338 | 2100070.05084 | 37.7465592558077 | -122.432532251866 | (37.7465592558077, -122.432532251866) | 2 | 7 | 5 | 63 | 22 | |||
| 60894 | 246420 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Duncan St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6003851.19686 | 2099854.61267 | 37.7460188154337 | -122.429398275524 | (37.7460188154337, -122.429398275524) | 2 | 7 | 5 | 63 | 22 | |||
| 63609 | 222900 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3733 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005413.47026 | 2104278.82733 | 37.7582550109751 | -122.424310747749 | (37.7582550109751, -122.424310747749) | 2 | 4 | 5 | 28859 | 19 | |||
| 77058 | 222893 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 301 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | Width 4ft | 6004914.2278 | 2106488.73534 | 37.7642946914815 | -122.426194676362 | (37.7642946914815, -122.426194676362) | 8 | 4 | 5 | 28859 | 19 | |||
| 110454 | 246421 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Duncan St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6003840.65408 | 2099855.19689 | 37.7460198226686 | -122.429434772709 | (37.7460198226686, -122.429434772709) | 2 | 7 | 5 | 63 | 22 | |||
| 172941 | 225057 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 360 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6001062.01743 | 2096696.77883 | 37.7371898399477 | -122.438816616317 | (37.7371898399477, -122.438816616317) | 2 | 7 | 5 | 63 | 7 | |||
| 175659 | 225049 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 500x 27th St | 22 | Median : Cutout | Tree | DPW 1 | 6 | Width 4ft | 6002919.63953 | 2100068.30287 | 37.7465527734974 | -122.432634735922 | (37.7465527734974, -122.432634735922) | 2 | 7 | 5 | 63 | 22 |
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) );