trees

7 rows where qSpecies_id = 295

✎ View and edit SQL

This data as json, CSV (advanced)

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)
5928 260423 Significant Tree 6 Juniperus californica :: California juniper 295 237 Glenview Dr 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5998907 2100812 37.7483664070673 -122.446563453195 (37.7483664070673, -122.446563453195) 2 5 5 63 38
11981 261158 Significant Tree 6 Juniperus californica :: California juniper 295 1100X Moraga St 2 Sidewalk: Property side : Yard Tree Private 2       10x10 Permit Number 784837 5990881 2103853 37.7562544846391 -122.474538790377 (37.7562544846391, -122.474538790377) 1 8 4 56 12
17146 261307 DPW Maintained 1 Juniperus californica :: California juniper 295 3324 Moraga St 1 Front Yard : Yard Tree Private 2       Width 0ft   5983935.3115 2103621.2359 37.7552132408568 -122.498541873458 (37.7552132408568, -122.498541873458) 1 8 3 56 35
19560 173904 DPW Maintained 1 Juniperus californica :: California juniper 295 60 Crestline Dr 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5999017 2101826 37.7511568864894 -122.446256008608 (37.7511568864894, -122.446256008608) 2 5 5 63 38
53271 253667 DPW Maintained 1 Juniperus californica :: California juniper 295 2 Cabrillo St 2 Sidewalk: Property side : Yard Tree Private 2       Width 3ft   5995617 2110854 37.775750686051 -122.458666990683 (37.775750686051, -122.458666990683) 11 6 2 54 11
142057 121418 DPW Maintained 1 Juniperus californica :: California juniper 295 521 Lakeview Ave 1 Sidewalk: Property side : Cutout Landscaping Private 2       3x3   5996348 2089857 37.7181401212561 -122.454621046384 (37.7181401212561, -122.454621046384) 9 8 6 28861 24
150329 219238 DPW Maintained 1 Juniperus californica :: California juniper 295 235 Granville Way 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   5994114.29549 2098802.76008 37.742574617028 -122.462990631211 (37.742574617028, -122.462990631211) 1 8 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)
);