trees

17 rows where PlotSize = "3x3" and qSpecies_id = 59

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • 3x3 · 17 ✖
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)
1376 263620 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 3 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
4419 260950 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 460x Davis Ct 2 Side Yard : Yard Tree Private 2       3x3   6013239 2118152 37.7967863568579 -122.398219792292 (37.7967863568579, -122.398219792292) 3 1 10 28860 6
10225 263619 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 2 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
10567 263621 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 4 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
11694 263618 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 900 Beach St 1 Side Yard : Yard Tree DPW 1 Rec/Park     3x3   6005896 2121751 37.8062565433008 -122.423884345484 (37.8062565433008, -122.423884345484) 3 1 1 28858 32
13002 260949 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 460x Davis Ct 1 Side Yard : Yard Tree Private 2       3x3   6013239 2118152 37.7967863568579 -122.398219792292 (37.7967863568579, -122.398219792292) 3 1 10 28860 6
14196 6096 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 106X Saint Joseph's Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6000733.8426241 2112435.5369559 37.7803859446112 -122.44108008458 (37.7803859446112, -122.44108008458) 15 5 1 29490 41
52665 254470 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 1601 Evans Ave 11 Sidewalk: Property side : Yard Tree Private 2       3x3   6015397 2098706 37.7435118805521 -122.389393878977 (37.7435118805521, -122.389393878977) 10 3 8 58 1
73440 116094 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
80147 116095 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
118842 116091 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     30 3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
145439 116093 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
151245 255455 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 31x Garlington Ct 1 Side Yard : Yard Tree Private 2       3x3   6016454 2094669 37.7324856396877 -122.385457730704 (37.7324856396877, -122.385457730704) 10 3 8 58 1
154885 116096 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
169477 255308 Undocumented 4 Populus nigra 'Italica' :: Lombardy Poplar 59 50 Mendell St 1 Front Yard : Yard Tree Private 2   06/05/2018 12:00:00 AM 3 3x3   6017061 2098665 37.7434914187463 -122.383637271506 (37.7434914187463, -122.383637271506) 10 3 8 58 1
170444 116097 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1
177168 116092 Significant Tree 6 Populus nigra 'Italica' :: Lombardy Poplar 59 300x EXECUTIVE PARK BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014482 2086919 37.7110963749119 -122.391733773238 (37.7110963749119, -122.391733773238) 10 3 8 309 1

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