trees
24 rows where SiteOrder = 2 and qLegalStatus_id = 9 sorted by PlantDate
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 190102 | 104109 | Private 9 | Maytenus boaria :: Mayten 58 | 342-346 MOULTRIE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x6 | 6007700 | 2097518 | 37.7398201496863 | -122.415924151926 | (37.7398201496863, -122.415924151926) | 2 | 7 | 7 | 28859 | 2 | |||
| 15121 | 261452 | Private 9 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2 Geneva Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/13/2020 12:00:00 AM | 3 | 3x4 | Permit Number 782541 | 5997165 | 2091482 | 37.7226488176407 | -122.451914211983 | (37.7226488176407, -122.451914211983) | 9 | 8 | 6 | 28861 | 24 |
| 12794 | 262012 | Private 9 | Magnolia grandiflora :: Southern Magnolia 19 | 1591 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2020 12:00:00 AM | 3 | 3x3 | 5998968.26858 | 2109018.36861 | 37.7709025542262 | -122.446942035054 | (37.7709025542262, -122.446942035054) | 15 | 5 | 11 | 29492 | 9 | ||
| 171374 | 85740 | Private 9 | Platanus x hispanica :: Sycamore: London Plane 27 | 601X Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/30/2007 12:00:00 AM | 3 | 5x5 | Permit Number 770115 | 6013161.811798 | 2114488.497614 | 37.7867229411628 | -122.398229721423 | (37.7867229411628, -122.398229721423) | 6 | 2 | 9 | 28855 | 6 | |
| 8142 | 262151 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 1295 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2020 12:00:00 AM | 3 | 3x3 | 5981486.26206 | 2106277.60943 | 37.7623629555319 | -122.50720831894 | (37.7623629555319, -122.50720831894) | 1 | 8 | 3 | 56 | 35 | ||
| 94173 | 22382 | Private 9 | Pyrus spp :: Pear Tree 281 | 2499X Mendell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/13/1997 12:00:00 AM | 3 | 3X3 | 6014045.0718623 | 2092725.5085003 | 37.7270156330804 | -122.393650054041 | (37.7270156330804, -122.393650054041) | 10 | 3 | 8 | 58 | 1 | ||
| 8898 | 149678 | Private 9 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 2100x Mariposa St | 2 | Front Yard : Cutout | Tree | DPW 1 | 05/19/2020 12:00:00 AM | 3 | Width 4ft | Permit Number 784452 | 6011170 | 2106024 | 37.76337023621 | -122.404524893747 | (37.76337023621, -122.404524893747) | 8 | 3 | 8 | 28856 | 29 | |
| 8242 | 264706 | Private 9 | Lagunaria patersonii :: Primrose Tree 6 | 4345 Clement St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 5982064.28374 | 2113052.50483 | 37.7809988756405 | -122.505711450059 | (37.7809988756405, -122.505711450059) | 11 | 6 | 2 | 55 | 26 | |||
| 13028 | 264748 | Private 9 | Pittosporum undulatum :: Victorian Box 36 | 2002 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2020 12:00:00 AM | 3 | 3x3 | 6001953.79528 | 2115381.82831 | 37.7885451212547 | -122.437070707369 | (37.7885451212547, -122.437070707369) | 13 | 6 | 1 | 29490 | 27 | ||
| 15916 | 150017 | Private 9 | Tree(s) :: 17 | 777 Tennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/17/2019 12:00:00 AM | 0 | 9x5 | Permit Number 776949 | 6015494.08881 | 2105409.25245 | 37.7619229804945 | -122.389526212978 | (37.7619229804945, -122.389526212978) | 10 | 3 | 8 | 28856 | 29 | |
| 166399 | 39628 | Private 9 | Platanus x hispanica :: Sycamore: London Plane 27 | 199X Carmel St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1998 12:00:00 AM | 5 | Permit Number 775173 | 5997915.23661319 | 2105333.02481713 | 37.7607233191374 | -122.450318782133 | (37.7607233191374, -122.450318782133) | 15 | 5 | 11 | 29492 | 12 |
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) );