trees

8 rows where PlotSize = "3x6" and qLegalStatus_id = 6

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

PlotSize ✖

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)
39767 254934 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 755 Ocean Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x6   5998003.33154 2091542.89024 37.7228639895457 -122.449020681299 (37.7228639895457, -122.449020681299) 9 7 4 28861 24
51708 173779 Significant Tree 6 Ficus macrophylla :: Morton Bay Fig 322 99X Cleveland St 2 Side Yard : Yard Tree Private 2       3x6   6010549 2110746 37.7763010397716 -122.407005587048 (37.7763010397716, -122.407005587048) 14 2 9 28853 34
73226 114272 Significant Tree 6 Tree(s) :: 17 2241 Sacramento St 1 Front Yard : Cutout Tree Private 2   03/22/2016 12:00:00 AM 3 3x6 Permit Number 776884 6004082.4 2115905.7 37.7901043022718 -122.429743441495 (37.7901043022718, -122.429743441495) 13 9 1 29490 27
77590 173780 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 57 99X Cleveland St 3 Side Yard : Yard Tree Private 2       3x6   6010549 2110746 37.7763010397716 -122.407005587048 (37.7763010397716, -122.407005587048) 14 2 9 28853 34
160978 112451 Significant Tree 6 Cedrus deodara :: Deodar Cedar 109 1526 MASONIC AVE 1 Front Yard : Cutout Tree Private 2       3x6   5999767 2107205 37.7659690994291 -122.444048894864 (37.7659690994291, -122.444048894864) 15 5 5 29492 9
168489 254935 Significant Tree 6 Cedrus atlantica Glauca :: Blue Atlas Cedar 208 755 Ocean Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x6 Permit Number 779678 5998003.33154 2091542.89024 37.7228639895457 -122.449020681299 (37.7228639895457, -122.449020681299) 9 7 4 28861 24
178381 254173 Significant Tree 6 Geijera parviflora :: Australian Willow 25 1850 19th Ave 1 Front Yard : Yard Tree Private 2       3x6   5990394 2102783 37.7532883185876 -122.476144836826 (37.7532883185876, -122.476144836826) 1 8 4 56 12
178383 254277 Significant Tree 6 Juniperus chinensis :: Juniper 113 105 Gladeview Way 1 Front Yard : Cutout Tree Private 2       3x6 Permit Number 781296 5997754 2101950 37.7514251480437 -122.450632514859 (37.7514251480437, -122.450632514859) 1 5 4 63 38

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