trees

12 rows where PlotSize = "Width 4ft" and qSpecies_id = 59

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: PlotSize

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)
37565 125723 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     38 Width 4ft   6003539.04242 2117994.60754 37.7958091249389 -122.431772623315 (37.7958091249389, -122.431772623315) 13 9 1 57 17
41514 195974 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 20 Back Yard : Yard Tree Private 2     12 Width 4ft   6015315.44713 2100317.81293 37.7479330619596 -122.389788429193 (37.7479330619596, -122.389788429193)   3 8 58 1
47415 125722 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     43 Width 4ft   6003540.89789 2117978.17849 37.7957641201722 -122.431765029446 (37.7957641201722, -122.431765029446) 13 9 1 57 17
49152 125724 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     35 Width 4ft   6003536.06003 2118009.60299 37.7958501295278 -122.431784014136 (37.7958501295278, -122.431784014136) 13 9 1 57 17
53808 195978 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 24 Back Yard : Yard Tree Private 2     9 Width 4ft   6015236.23042 2100312.22008 37.7479133119586 -122.390061968785 (37.7479133119586, -122.390061968785)   3 8 58 1
81240 195975 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 21 Back Yard : Yard Tree Private 2     9 Width 4ft   6015294.9834 2100316.47199 37.747928245201 -122.389859098828 (37.747928245201, -122.389859098828)   3 8 58 1
98771 195973 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 19 Back Yard : Yard Tree Private 2     10 Width 4ft   6015335.01264 2100318.29491 37.7479354703429 -122.389720805596 (37.7479354703429, -122.389720805596)   3 8 58 1
127355 195972 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 18 Back Yard : Yard Tree Private 2     10 Width 4ft   6015355.8319 2100319.80426 37.7479407691514 -122.389648918288 (37.7479407691514, -122.389648918288)   3 8 58 1
144333 195971 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 17 Back Yard : Yard Tree Private 2     10 Width 4ft   6015377.86647 2100320.41197 37.7479436595871 -122.389572765484 (37.7479436595871, -122.389572765484)   3 8 58 1
145025 195977 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 23 Back Yard : Yard Tree Private 2     5 Width 4ft   6015256.87723 2100313.90806 37.7479190918917 -122.389990690329 (37.7479190918917, -122.389990690329)   3 8 58 1
166467 125725 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     36 Width 4ft   6003533.81623 2118024.94741 37.7958921341649 -122.431792874238 (37.7958921341649, -122.431792874238) 13 9 1 57 17
185019 195976 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 22 Back Yard : Yard Tree Private 2     5 Width 4ft   6015275.57642 2100315.10939 37.7479234275315 -122.389926112714 (37.7479234275315, -122.389926112714)   3 8 58 1

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