trees
10 rows where qSpecies_id = 290 sorted by qAddress
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8362 | 96178 | Permitted Site 7 | Citrus aurantifolia 'Bearss' :: Seedless Lime 290 | Unaccepted Street : Cutout | Tree | Private 2 | 04/04/2011 12:00:00 AM | 3x3 | Permit Number 767810 | ||||||||||||||
61095 | 202161 | DPW Maintained 1 | Citrus aurantifolia 'Bearss' :: Seedless Lime 290 | 10 Kalmanovitz St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 2ft | 6013174.1458 | 2093326.82429 | 37.7286182899883 | -122.396702988148 | (37.7286182899883, -122.396702988148) | 10 | 3 | 8 | 58 | 1 | |||
77177 | 225220 | DPW Maintained 1 | Citrus aurantifolia 'Bearss' :: Seedless Lime 290 | 20 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006133.39433 | 2102315.3901 | 37.7529044926489 | -122.421681477217 | (37.7529044926489, -122.421681477217) | 2 | 4 | 5 | 28859 | 19 | |||
112649 | 126036 | DPW Maintained 1 | Citrus aurantifolia 'Bearss' :: Seedless Lime 290 | 2100 Jefferson St | 3 | Front Yard : Yard | Tree | Private 2 | 3 | 5999082.9482 | 2121164.53578 | 37.8042592925024 | -122.447419750445 | (37.8042592925024, -122.447419750445) | 13 | 9 | 1 | 57 | 17 | ||||
5400 | 126034 | DPW Maintained 1 | Citrus aurantifolia 'Bearss' :: Seedless Lime 290 | 2390 Bay St | 2 | Side Yard : Yard | Tree | Private 2 | 8 | Width 4ft | 5999370.04259 | 2120163.81894 | 37.8015279956692 | -122.446354207574 | (37.8015279956692, -122.446354207574) | 13 | 9 | 1 | 57 | 17 | |||
41813 | 126035 | DPW Maintained 1 | Citrus aurantifolia 'Bearss' :: Seedless Lime 290 | 30 Prado St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6000818.5713 | 2121295.61763 | 37.8047182363242 | -122.441422917254 | (37.8047182363242, -122.441422917254) | 13 | 9 | 1 | 57 | 17 | |||
24896 | 94213 | DPW Maintained 1 | Citrus aurantifolia 'Bearss' :: Seedless Lime 290 | 465 Missouri St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53589 | 6013544.89395 | 2104951.55787 | 37.7605579831829 | -122.396235681525 | (37.7605579831829, -122.396235681525) | 10 | 3 | 8 | 28856 | 29 | |
174185 | 117925 | DPW Maintained 1 | Citrus aurantifolia 'Bearss' :: Seedless Lime 290 | 611 41st Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 5983159.2558 | 2111596.27774 | 37.7770648850992 | -122.501815685849 | (37.7770648850992, -122.501815685849) | 11 | 6 | 2 | 55 | 26 | |||
134920 | 121632 | DPW Maintained 1 | Citrus aurantifolia 'Bearss' :: Seedless Lime 290 | 951 Avalon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6005186.05535 | 2092124.80477 | 37.7248699786428 | -122.424232852987 | (37.7248699786428, -122.424232852987) | 9 | 7 | 6 | 28861 | 5 | |||
147583 | 175852 | DPW Maintained 1 | Citrus aurantifolia 'Bearss' :: Seedless Lime 290 | 981 Delano Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 9ft | 5998486.05845 | 2089261.92623 | 37.7166285851125 | -122.447187923197 | (37.7166285851125, -122.447187923197) | 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) );