trees

8 rows where SiteOrder = 15 and qSpecies_id = 35

✎ 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)
39949 8349 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1300 Geary Blvd 15 Median : Cutout Tree DPW 1     24 6   6005496.3592183 2114176.6024527 37.7854365962768 -122.424728193484 (37.7854365962768, -122.424728193484) 13 9 11 28858 13
62197 94233 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Ocean Sloat Blvd 15 Sidewalk: Property side : Yard Tree Private 2   06/28/2010 12:00:00 AM 12   Permit Number 53611 5986316.3 2095724.7 37.7336708170949 -122.489727133621 (37.7336708170949, -122.489727133621) 1 8 4 64 35
72849 91503 Permitted Site 7 Pinus canariensis :: Canary Island Pine 35 1501@Clearfield Sloat Blvd 15 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986536.9 2095861.8 37.7340601352242 -122.488974540344 (37.7340601352242, -122.488974540344) 1 8 4 64 35
75630 184347 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 1251 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     1 Width 0ft   5984658.9334 2106421.3632 37.7629440193232 -122.496246001897 (37.7629440193232, -122.496246001897) 1 8 3 56 35
87630 243112 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 5300x Diamond Heights Blvd 15 Median : Yard Tree DPW 1   05/01/2017 12:00:00 AM 3     6001806.81928 2098684.11193 37.7426889388393 -122.436383692077 (37.7426889388393, -122.436383692077) 2 7 5 63 7
121908 178144 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 20 Brotherhood Way 15 : Tree Private 2     4 Width 0ft   5991934.88004 2087954.77106 37.7126629535013 -122.469736757058 (37.7126629535013, -122.469736757058) 9 8 4 64 24
143757 185290 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 2601 Sunset Blvd 15 Sidewalk: Property side : Yard Tree Private 2     2 Width 0ft   5984983.8028 2097379.2257 37.738135813056 -122.494455822202 (37.738135813056, -122.494455822202) 1 8 3 29491 35
174956 178160 DPW Maintained 1 Pinus canariensis :: Canary Island Pine 35 10 Brotherhood Way 15 : Tree Private 2     6 Width 0ft   5993144.35627 2087854.16093 37.7124565357104 -122.465549154771 (37.7124565357104, -122.465549154771) 9 8 4 64 24

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