trees

17 rows where qSpecies_id = 270

✎ 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)
3949 197735 DPW Maintained 1 Styphnolobium japonicum :: Chinese scholar tree 270 1800 04th St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6015134.28315 2107098.29667 37.7665407725773 -122.390888699377 (37.7665407725773, -122.390888699377) 14 3 9 310 29
14954 197738 DPW Maintained 1 Styphnolobium japonicum :: Chinese scholar tree 270 1950 04th St 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6015098.87065 2106329.98343 37.7644291868918 -122.390957482206 (37.7644291868918, -122.390957482206) 14 3 9 310 29
66996 197741 DPW Maintained 1 Styphnolobium japonicum :: Chinese scholar tree 270 1950 04th St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6015114.56396 2106401.37866 37.7646260934509 -122.390908193055 (37.7646260934509, -122.390908193055) 14 3 9 310 29
70115 197734 DPW Maintained 1 Styphnolobium japonicum :: Chinese scholar tree 270 1800 04th St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6015133.75646 2107117.49754 37.766593464749 -122.390891863179 (37.766593464749, -122.390891863179) 14 3 9 310 29
77018 197746 DPW Maintained 1 Styphnolobium japonicum :: Chinese scholar tree 270 1975 04th St 4 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6015183.75911 2106426.79652 37.7646997245393 -122.390670639842 (37.7646997245393, -122.390670639842) 14 3 9 310 29
93415 197745 DPW Maintained 1 Styphnolobium japonicum :: Chinese scholar tree 270 1975 04th St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6015176.56394 2106407.0773 37.7646451806587 -122.390694148136 (37.7646451806587, -122.390694148136) 14 3 9 310 29
104320 197740 DPW Maintained 1 Styphnolobium japonicum :: Chinese scholar tree 270 1950 04th St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6015109.43195 2106376.23025 37.7645567566262 -122.390924185703 (37.7645567566262, -122.390924185703) 14 3 9 310 29
114235 240844 DPW Maintained 1 Styphnolobium japonicum :: Chinese scholar tree 270 2512 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/22/1992 12:00:00 AM 11 Width 4ft Permit Number 30823 6011341.20529 2101862.92497 37.7519544137647 -122.403639957344 (37.7519544137647, -122.403639957344) 10 4 8 28859 19
121118 197742 DPW Maintained 1 Styphnolobium japonicum :: Chinese scholar tree 270 1950 04th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6015122.9218 2106424.48754 37.7646900091555 -122.390880900439 (37.7646900091555, -122.390880900439) 14 3 9 310 29
132343 197736 DPW Maintained 1 Styphnolobium japonicum :: Chinese scholar tree 270 1800 04th St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6015134.508 2107075.04349 37.7664769368987 -122.390886296359 (37.7664769368987, -122.390886296359) 14 3 9 310 29
134235 197743 DPW Maintained 1 Styphnolobium japonicum :: Chinese scholar tree 270 1975 04th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6015167.69493 2106306.41081 37.7643682802918 -122.390717788601 (37.7643682802918, -122.390717788601) 14 3 9 310 29
147136 197739 DPW Maintained 1 Styphnolobium japonicum :: Chinese scholar tree 270 1950 04th St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 5ft   6015103.59693 2106351.60043 37.7644888047255 -122.390942646108 (37.7644888047255, -122.390942646108) 14 3 9 310 29
153255 197748 DPW Maintained 1 Styphnolobium japonicum :: Chinese scholar tree 270 1975 04th St 6 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6015201.44705 2106465.6253 37.7648073212362 -122.390612174905 (37.7648073212362, -122.390612174905) 14 3 9 310 29
163836 197737 DPW Maintained 1 Styphnolobium japonicum :: Chinese scholar tree 270 1950 04th St 6 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 5ft   6015099.56152 2106307.90518 37.764368603152 -122.390953549474 (37.764368603152, -122.390953549474) 14 3 9 310 29
166677 66156 DPW Maintained 1 Styphnolobium japonicum :: Chinese scholar tree 270 1751 Newhall St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/04/1990 12:00:00 AM 13   Permit Number 29227 6013871.1718 2094957.56097 37.7331347302712 -122.394407446159 (37.7331347302712, -122.394407446159) 10 3 8 58 1
191390 197747 DPW Maintained 1 Styphnolobium japonicum :: Chinese scholar tree 270 1975 04th St 5 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6015191.97429 2106445.31898 37.7647510389611 -122.390643519901 (37.7647510389611, -122.390643519901) 14 3 9 310 29
191941 197744 DPW Maintained 1 Styphnolobium japonicum :: Chinese scholar tree 270 1975 04th St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 5ft   6015167.55758 2106323.79258 37.7644159992358 -122.390719478427 (37.7644159992358, -122.390719478427) 14 3 9 310 29

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