trees

110 rows where qLegalStatus_id = 6 and qSiteInfo = "Back Yard : Yard" sorted by qLegalStatus_id

✎ View and edit SQL

This data as json, CSV (advanced)

qSiteInfo ✖

  • Back Yard : Yard · 10 ✖
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)
179476 115460 Significant Tree 6 Tree(s) :: 17 80 Crestline Dr 2 Back Yard : Yard Tree Private 2   02/02/2016 12:00:00 AM 3   Permit Number 776150 5999012.8 2102131.7 37.7519960240451 -122.446292521132 (37.7519960240451, -122.446292521132) 2 5 5 63 38
179498 106172 Significant Tree 6 Ulmus parvifolia :: Chinese Elm 31 150 CONRAD ST 1 Back Yard : Yard Tree Private 2     14     6001768.8 2096480 37.7366348009068 -122.436357440328 (37.7366348009068, -122.436357440328) 2 7 5 63 7
180754 96273 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 55@ Alemany Trumbull St 1 Back Yard : Yard Tree Private 2           6004020.1 2094407.4 37.7310715719205 -122.428426044208 (37.7310715719205, -122.428426044208) 9 7 6 28861 5
183899 253897 Significant Tree 6 Tree(s) :: 17 201X Oak Park Dr 1 Back Yard : Yard Tree Private 2   01/17/2018 12:00:00 AM 3 10x10 Permit Number 780818 5996124 2103402 37.7553185401494 -122.45637419556 (37.7553185401494, -122.45637419556) 1 5 4 63 12
184053 109576 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 155 21X STILLINGS AVE 1 Back Yard : Yard Tree Private 2     60     6000417 2095694 37.7343997262189 -122.44097481224 (37.7343997262189, -122.44097481224) 9 7 5 63 40
184595 187668 Significant Tree 6 Eriobotrya deflexa :: Bronze Loquat 8 100x OGDEN AVE 4 Back Yard : Yard Tree Private 2           6007659 2096105 37.7359380573488 -122.41596587682 (37.7359380573488, -122.41596587682) 2 7 7 28859 2
190157 117273 Significant Tree 6 Pinus radiata :: Monterey Pine 15 17 PEREGO TER 1 Back Yard : Yard Tree Private 2           5999542 2101494 37.7502752643571 -122.444416651791 (37.7502752643571, -122.444416651791) 2 5 5 63 38
190882 251610 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 41 56R Amber Dr 3 Back Yard : Yard Tree Private 2           5999423 2100048 37.7462981080439 -122.44472423658 (37.7462981080439, -122.44472423658) 2 7 5 63 22
193693 255496 Significant Tree 6 Pinus radiata :: Monterey Pine 15 2100 Turk Blvd 1 Back Yard : Yard Tree Private 2           5999950 2111978 37.7790849877594 -122.443758873408 (37.7790849877594, -122.443758873408) 15 5 1 29490 16
194175 116308 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 699X DETROIT ST 9 Back Yard : Yard Tree Private 2       3x20   5999400 2095202 37.7329908332996 -122.444455553893 (37.7329908332996, -122.444455553893) 9 7 4 59 40

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