trees

16 rows where PlotSize = "6x6" and qLegalStatus_id = 6

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

PlotSize ✖

  • 6x6 · 16 ✖
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)
12289 254085 Significant Tree 6 Pinus radiata :: Monterey Pine 15 411 Lansdale Ave 1 Front Yard : Cutout Tree Private 2       6x6   5995707 2096451 37.7362088759349 -122.457313463895 (37.7362088759349, -122.457313463895) 9 7 4 59 40
21449 255662 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1626 Shrader St 1 Sidewalk: Property side : Yard Tree Private 2       6x6 Permit Number 782137 5998119 2105007 37.759839795982 -122.44959056596 (37.759839795982, -122.44959056596) 15 5 11 29492 12
29379 254551 Significant Tree 6 Cordyline australis :: Dracena Palm 64 1433 Cayuga Ave 1 Front Yard : Cutout Tree Private 2       6x6   5999129 2089595 37.7175798453783 -122.444989533853 (37.7175798453783, -122.444989533853) 9 7 6 28861 25
37092 254109 Significant Tree 6 Tree(s) :: 17 38X Starview Way 1 Sidewalk: Property side : Yard Tree Private 2   02/06/2018 12:00:00 AM 3 6x6 Permit Number 781050 5997469 2101545 37.7502968010125 -122.451588863361 (37.7502968010125, -122.451588863361) 1 5 4 63 38
63888 254137 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1619 47th Ave 1 Side Yard : Yard Tree Private 2       6x6   5981543 2104041 37.756225206981 -122.506846181577 (37.756225206981, -122.506846181577) 1 8 3 56 35
75557 254361 Significant Tree 6 Platanus x hispanica :: Sycamore: London Plane 27 1749 09th Ave 1 Front Yard : Yard Tree Private 2       6x6   5993372 2103579 37.7556461665355 -122.465904219148 (37.7556461665355, -122.465904219148) 1 8 4 56 12
85388 255663 Significant Tree 6 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 230 1626 Shrader St 2 Sidewalk: Property side : Yard Tree Private 2       6x6 Permit Number 782137 5998119 2105007 37.759839795982 -122.44959056596 (37.759839795982, -122.44959056596) 15 5 11 29492 12
93101 251659 Significant Tree 6 Olea europaea :: Olive Tree 9 1050 North Point St 3 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
104704 256850 Significant Tree 6 Calocedrus decurrens :: Incense Cedar 206 100 Brentwood Ave 1 Front Yard : Yard Tree Private 2       6x6   5995843 2095739 37.7342617075966 -122.456791779994 (37.7342617075966, -122.456791779994) 9 7 4 59 40
143771 251658 Significant Tree 6 Olea europaea :: Olive Tree 9 1050 North Point St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
144517 112363 Significant Tree 6 Cedrus atlantica :: Atlas Cedar 233 540 10th Ave 3 Front Yard : Yard Tree Private 2     24 6x6   5992860.82014 2111778.58973 37.778130563709 -122.468268503132 (37.778130563709, -122.468268503132) 11 6 2 54 11
151937 251657 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1050 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
157788 251660 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1050 North Point St 4 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32
166922 103307 Significant Tree 6 Pyrus spp :: Pear Tree 281 1467 Willard St 1 Front Yard : Yard Tree Private 2   04/02/2013 12:00:00 AM 5 6x6 Permit Number 768689 5996817.5 2106175 37.7629722844649 -122.454176154627 (37.7629722844649, -122.454176154627) 15 5 11 29492 12
177345 251411 Significant Tree 6 Tree(s) :: 17 2751 Buchanan St 1 Front Yard : Cutout Tree Private 2   06/21/2017 12:00:00 AM 3 6x6 Permit Number 779887 6003497 2117826 37.7953437887296 -122.431906052505 (37.7953437887296, -122.431906052505) 13 9 1 29490 27
178107 251661 Significant Tree 6 Olea europaea :: Olive Tree 9 3200X Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6005628 2121390 37.8052501972152 -122.424786108187 (37.8052501972152, -122.424786108187) 5 1 1 28858 32

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