trees
10 rows where SiteOrder = 8, qCaretaker_id = 1 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16214 | 16506 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016450.0254075 | 2098336.1941649 | 37.7425547953869 | -122.385726976255 | (37.7425547953869, -122.385726976255) | 10 | 3 | 8 | 58 | 1 | |||
| 76900 | 6652 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 495X Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | 10 | 3 | 8 | 58 | 1 | |||
| 81257 | 2540 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016367.14673 | 2098986.82897 | 37.7443367189812 | -122.386058894813 | (37.7443367189812, -122.386058894813) | 10 | 3 | 8 | 58 | 1 | |||
| 84076 | 2520 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016533.26 | 2098864.45764 | 37.744009904432 | -122.385475978555 | (37.744009904432, -122.385475978555) | 10 | 3 | 8 | 58 | 1 | |||
| 98289 | 14914 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017206.58246 | 2098230.05631 | 37.7423051973143 | -122.383103612647 | (37.7423051973143, -122.383103612647) | 10 | 3 | 8 | 58 | 1 | |||
| 104002 | 2512 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1501 Burke Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067 | 37.743747386446 | -122.384952066789 | (37.743747386446, -122.384952066789) | 10 | 3 | 8 | 58 | 1 | |||
| 151412 | 2504 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Burke Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016654.18712 | 2098861.64491 | 37.7440088711085 | -122.385057640012 | (37.7440088711085, -122.385057640012) | 10 | 3 | 8 | 58 | 1 | |||
| 170549 | 16497 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 305X Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016834.58957 | 2098268.17724 | 37.7423893070591 | -122.384392517318 | (37.7423893070591, -122.384392517318) | 10 | 3 | 8 | 58 | 1 | |||
| 177736 | 14931 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016461.7664057 | 2098387.7906821 | 37.7426971185746 | -122.385689974252 | (37.7426971185746, -122.385689974252) | 10 | 3 | 8 | 58 | 1 | |||
| 185290 | 4919 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/11/2016 12:00:00 AM | 12 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 |
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) );