trees

12 rows where DBH = 2 and qSpecies_id = 79

✎ View and edit SQL

This data as json, CSV (advanced)

DBH ✖

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)
21315 222803 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 2800x Cesar Chavez St 5 Median : Cutout Tree DPW 1     2 Width 6ft   6010452.68948 2100735.70398 37.748809640151 -122.406633159205 (37.748809640151, -122.406633159205) 2 4 7 28859 2
32922 188440 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 900 Marin St 4 : Tree Private 2     2 Width 4ft   6016353.67764 2100743.44065 37.7491592669079 -122.3862279089 (37.7491592669079, -122.3862279089) 10 3 8 58 1
36055 188441 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 1075 Jamestown Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2     6013593.18256 2089903.25055 37.7192411588259 -122.39501465042 (37.7192411588259, -122.39501465042) 10 3 8 58 1
42012 222846 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 3561 21st St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004563.86343 2103647.46019 37.7564734144392 -122.427204088022 (37.7564734144392, -122.427204088022) 2 4 5 28862 22
47260 222814 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 3500x Cesar Chavez St 4 Median : Yard Tree DPW 1     2 Width 10ft   6006266.09505 2100563.37105 37.748101331408 -122.421098180538 (37.748101331408, -122.421098180538) 2 4 7 28859 2
72682 222845 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 3100x Cesar Chavez St 15 Median : Yard Tree DPW 1     2 Width 10ft   6008656.93174 2100575.27687 37.7482685099843 -122.412831565537 (37.7482685099843, -122.412831565537) 2 4 7 28859 2
81105 222777 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 2950x Cesar Chavez St 7 Median : Yard Tree DPW 1     2     6009523.38261 2100580.00732 37.7483300946563 -122.409835724135 (37.7483300946563, -122.409835724135) 2 4 7 28859 2
113808 222776 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 2950x Cesar Chavez St 8 Median : Yard Tree DPW 1     2     6009504.41429 2100580.51468 37.7483304247098 -122.40990135219 (37.7483304247098, -122.40990135219) 2 4 7 28859 2
146215 222822 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 3500x Cesar Chavez St 15 Median : Yard Tree DPW 1     2 Width 10ft   6006028.77468 2100543.72066 37.7480339946844 -122.421917431454 (37.7480339946844, -122.421917431454) 2 4 7 28859 22
158916 222821 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 3500x Cesar Chavez St 14 Median : Yard Tree DPW 1     2 Width 10ft   6006053.42295 2100544.76657 37.7480382565647 -122.421832272848 (37.7480382565647, -122.421832272848) 2 4 7 28859 22
185667 222819 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 3500x Cesar Chavez St 12 Median : Yard Tree DPW 1     2 Width 10ft   6006102.45265 2100549.03678 37.7480527464562 -122.42166303303 (37.7480527464562, -122.42166303303) 2 4 7 28859 22
191083 222851 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 586 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6002830.3384 2099791.36235 37.7457872948532 -122.43292374744 (37.7457872948532, -122.43292374744) 2 7 5 63 22

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