trees

17 rows where Supervisor Districts = 11 and qLegalStatus_id = 8 sorted by DBH

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor Districts ✖

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)
364 255980 Property Tree 8 Tree(s) :: 17 541 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6000551 2110847 37.7760138103106 -122.441598590487 (37.7760138103106, -122.441598590487) 15 5 11 29492 16
5987 262213 Property Tree 8 Olea europaea :: Olive Tree 9 66 Clarendon Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5997837 2104660 37.7588708842054 -122.450540844653 (37.7588708842054, -122.450540844653) 15 5 11 28862 12
9668 264919 Property Tree 8 Olea Majestic Beauty :: 183 1833 Page St 1 Sidewalk: Property side : Yard Tree Public Library 12       3x3   5997789 2108763 37.7701339345343 -122.451002717521 (37.7701339345343, -122.451002717521) 15 5 11 29492 9
31670 104539 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 2 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
49750 104540 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 4 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
52825 104544 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 8 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
71797 256101 Property Tree 8 Populus spp :: Poplar Spp 262 1255 Oak St 1 Back Yard : Cutout Tree Private 2       3x3   6001013 2109627 37.7726903083913 -122.439912920243 (37.7726903083913, -122.439912920243) 15 5 11 29492 9
80203 253469 Property Tree 8 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 701 Stanyan St 5 Side Yard : Yard Tree Private 2           5997178 2108423 37.7691653834469 -122.453091601514 (37.7691653834469, -122.453091601514) 15 5 11 29492 9
86207 104538 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 1 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
99497 104543 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 7 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
101786 104542 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 6 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
101829 257926 Property Tree 8 Pinus radiata :: Monterey Pine 15 8 Hill Point Ave 1 Back Yard : Yard Tree Private 2       3x3   5996384 2106804 37.7646744896132 -122.455720942569 (37.7646744896132, -122.455720942569) 15 5 11 29492 12
155860 96938 Property Tree 8 Tree(s) :: 17 1306 Cole St   Back Yard : Yard Tree Private 2         Backyard tree on private property 5998246 2105961 37.7624665052811 -122.449220068104 (37.7624665052811, -122.449220068104) 15 5 11 29492 9
177432 102706 Property Tree 8 Cupressus macrocarpa :: Monterey Cypress 41 1342 Funston Ave 1 Back Yard : Yard Tree Private 2           5992135.4 2106294.8 37.7630316255695 -122.470378504645 (37.7630316255695, -122.470378504645) 1 8 11 56 12
181064 104568 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 9 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
182344 104541 Property Tree 8 Juniperus chinensis :: Juniper 113 1101 Van Ness Ave 5 Front Yard : Yard Tree Private 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
105239 110843 Property Tree 8 Pseudotsuga menziesii :: Douglas Fir 285 2037 TURK BLVD   Front Yard : Yard Tree Private 2     15     6000252 2111948 37.7790198360362 -122.442711981138 (37.7790198360362, -122.442711981138) 15 5 11 29490 16

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