trees

10 rows where qSpecies_id = 290

✎ View and edit SQL

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)
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
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                    
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
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
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
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
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

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);