trees

15 rows where DBH = 5 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)
249 222839 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 3100x Cesar Chavez St 5 Median : Yard Tree DPW 1     5 Width 10ft   6008877.38377 2100577.11513 37.7482859289696 -122.412069375694 (37.7482859289696, -122.412069375694) 2 4 7 28859 2
25473 222818 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 3500x Cesar Chavez St 11 Median : Yard Tree DPW 1     5 Width 10ft   6006120.27144 2100551.46467 37.7480604176603 -122.421601588647 (37.7480604176603, -122.421601588647) 2 4 7 28859 22
34913 222797 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 2800x Cesar Chavez St 11 Median : Cutout Tree DPW 1     5 Width 6ft   6010346.58719 2100693.63731 37.7486881975031 -122.406997097757 (37.7486881975031, -122.406997097757) 2 4 7 28859 2
55795 222788 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 2800x Cesar Chavez St 20 Median : Cutout Tree DPW 1     5 Width 6ft   6010168.99866 2100623.96537 37.7484869544098 -122.407606288598 (37.7484869544098, -122.407606288598) 2 4 7 28859 2
74633 222795 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 2800x Cesar Chavez St 13 Median : Cutout Tree DPW 1     5 Width 6ft   6010312.60007 2100681.0451 37.7486517201183 -122.407113738008 (37.7486517201183, -122.407113738008) 2 4 7 28859 2
97646 222785 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 2800x Cesar Chavez St 27 Median : Cutout Tree DPW 1     5 Width 6ft   6010026.6545 2100576.07742 37.7483474956387 -122.408095137598 (37.7483474956387, -122.408095137598) 2 4 7 28859 2
117676 222794 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 2800x Cesar Chavez St 14 Median : Cutout Tree DPW 1     5 Width 6ft   6010286.07268 2100668.6664 37.7486162463561 -122.407204597414 (37.7486162463561, -122.407204597414) 2 4 7 28859 2
131467 222789 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 2800x Cesar Chavez St 19 Median : Cutout Tree DPW 1     5 Width 6ft   6010186.13966 2100630.80552 37.7485066954419 -122.407547497242 (37.7485066954419, -122.407547497242) 2 4 7 28859 2
132500 222791 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 2800x Cesar Chavez St 17 Median : Cutout Tree DPW 1     5 Width 6ft   6010227.86602 2100646.66118 37.7485525671486 -122.40740432517 (37.7485525671486, -122.40740432517) 2 4 7 28859 2
138021 222817 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 3500x Cesar Chavez St 10 Median : Yard Tree DPW 1     5 Width 10ft   6006145.22502 2100552.1939 37.7480638269962 -122.421515351753 (37.7480638269962, -122.421515351753) 2 4 7 28859 22
144033 222801 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 2800x Cesar Chavez St 7 Median : Cutout Tree DPW 1     5 Width 6ft   6010415.2689 2100722.39062 37.748770990899 -122.406761621955 (37.748770990899, -122.406761621955) 2 4 7 28859 19
150421 222830 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 3300x Cesar Chavez St 7 Median : Yard Tree DPW 1     5 Width 10ft   6007397.54212 2100569.68358 37.7481823819289 -122.417186114357 (37.7481823819289, -122.417186114357) 2 4 7 28859 2
152977 222841 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 3100x Cesar Chavez St 8 Median : Yard Tree DPW 1     5 Width 10ft   6008807.15459 2100576.25792 37.7482796346101 -122.412312166586 (37.7482796346101, -122.412312166586) 2 4 7 28859 2
155232 222793 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 2800x Cesar Chavez St 15 Median : Cutout Tree DPW 1     5 Width 6ft   6010266.15939 2100660.65315 37.748593129264 -122.407272892851 (37.748593129264, -122.407272892851) 2 4 7 28859 2
179129 222827 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 3300x Cesar Chavez St 4 Median : Yard Tree DPW 1     5 Width 10ft   6007469.11342 2100569.02723 37.7481846059292 -122.416938575954 (37.7481846059292, -122.416938575954) 2 4 7 28859 2

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