trees

11 rows where qSpecies_id = 108

✎ 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)
469 245799 DPW Maintained 1 Corymbia calophylla :: 108 50 Church St 1 : Tree Private 2     21 Width 6ft   6004070.93701 2108481.83175 37.7697195522468 -122.429253511635 (37.7697195522468, -122.429253511635) 7 9 5 29492 10
20189 245800 DPW Maintained 1 Corymbia calophylla :: 108 1000 San Jose Ave 49 Front Yard : Yard Tree Private 2     19     6005122.79979 2097103.77874 37.7385375621556 -122.424805571837 (37.7385375621556, -122.424805571837) 2 7 5 28859 7
52314 247766 DPW Maintained 1 Corymbia calophylla :: 108 25 Alpine Ter 1 : Tree Private 2     21 Width 3ft   6001636.39273 2108565.80914 37.7698120088385 -122.437680527033 (37.7698120088385, -122.437680527033) 15 5 5 29492 9
65706 245805 DPW Maintained 1 Corymbia calophylla :: 108 1000 San Jose Ave 59 Front Yard : Yard Tree Private 2     18     6005091.99753 2097057.85602 37.7384097289195 -122.424908805024 (37.7384097289195, -122.424908805024) 2 7 5 28859 7
91951 123258 DPW Maintained 1 Corymbia calophylla :: 108 735 07th Ave 10 Sidewalk: Property side : Yard Tree Private 2     26 Width 4ft   5993772.80142 2110648.6089 37.7750805697855 -122.465031565013 (37.7750805697855, -122.465031565013) 11 6 2 54 11
111455 245802 DPW Maintained 1 Corymbia calophylla :: 108 1000 San Jose Ave 56 Front Yard : Yard Tree Private 2     18     6005105.11346 2097077.58418 37.738464638836 -122.424864859638 (37.738464638836, -122.424864859638) 2 7 5 28859 7
114308 245806 DPW Maintained 1 Corymbia calophylla :: 108 1000 San Jose Ave 61 Front Yard : Yard Tree Private 2     2     6005088.09229 2097053.37977 37.7383972175602 -122.424921989074 (37.7383972175602, -122.424921989074) 2 7 5 63 7
116950 245804 DPW Maintained 1 Corymbia calophylla :: 108 1000 San Jose Ave 58 Front Yard : Yard Tree Private 2     18     6005100.77229 2097064.25722 37.7384278008054 -122.424878921434 (37.7384278008054, -122.424878921434) 2 7 5 28859 7
155128 12855 DPW Maintained 1 Corymbia calophylla :: 108 2438 Lake St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x5   5987825.80689 2114674.13525 37.7857888205012 -122.485898802072 (37.7857888205012, -122.485898802072) 11 6 1 55 33
179150 245803 DPW Maintained 1 Corymbia calophylla :: 108 1000 San Jose Ave 57 Front Yard : Yard Tree Private 2     22     6005108.98123 2097067.8854 37.7384382266371 -122.424850796934 (37.7384382266371, -122.424850796934) 2 7 5 28859 7
183921 245801 DPW Maintained 1 Corymbia calophylla :: 108 1000 San Jose Ave 50 Front Yard : Yard Tree Private 2     15     6005117.51617 2097095.53018 37.7385146150421 -122.424823253408 (37.7385146150421, -122.424823253408) 2 7 5 28859 7

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