trees

12 rows where PlotSize = "Width 3ft" and qSpecies_id = 101

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • Width 3ft · 12 ✖
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)
2824 133031 DPW Maintained 1 Ficus Spp. :: 101 899 Pine St 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6009745.43403 2116066.84146 37.7908658043502 -122.410161098851 (37.7908658043502, -122.410161098851) 5 1 10 28857 21
9091 218801 DPW Maintained 1 Ficus Spp. :: 101 40 Melrose Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5999835.96742 2095516.42127 37.7338790262872 -122.442970877111 (37.7338790262872, -122.442970877111) 9 7 4 63 40
26643 126615 DPW Maintained 1 Ficus Spp. :: 101 728 Washington St 2 Sidewalk: Curb side : Pot Tree Private 2     10 Width 3ft   6011119.33477 2117657.8785 37.7953113232058 -122.405519543093 (37.7953113232058, -122.405519543093) 3 1 10 28857 4
27341 224467 DPW Maintained 1 Ficus Spp. :: 101 98 29th St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6005848.74864 2099086.12969 37.7440216271089 -122.422436402315 (37.7440216271089, -122.422436402315) 2 7 5 28859 2
67756 225378 DPW Maintained 1 Ficus Spp. :: 101 430 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6007552.41754 2095692.96656 37.7348007108828 -122.416305201448 (37.7348007108828, -122.416305201448) 2 7 7 28859 2
99594 218964 DPW Maintained 1 Ficus Spp. :: 101 530 Rockdale Dr 2 Sidewalk: Property side : Yard Tree Private 2     4 Width 3ft   5997978.47661 2097724.68038 37.7398362974137 -122.449551820875 (37.7398362974137, -122.449551820875) 9 7 4 59 40
104149 224463 DPW Maintained 1 Ficus Spp. :: 101 998 York St 5 Sidewalk: Property side : Yard Tree Private 2     2 Width 3ft   6009934.61987 2103458.53933 37.7562569422093 -122.408616703004 (37.7562569422093, -122.408616703004) 2 4 7 28859 19
116092 126614 DPW Maintained 1 Ficus Spp. :: 101 728 Washington St 1 Sidewalk: Curb side : Pot Tree Private 2     1 Width 3ft   6011128.85528 2117659.08548 37.7953151696175 -122.40548668546 (37.7953151696175, -122.40548668546) 3 1 10 28857 4
135938 224479 Undocumented 4 Ficus Spp. :: 101 252 Alma St 3 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 3ft   5997431.87905 2106139.44688 37.7629098758031 -122.452048674332 (37.7629098758031, -122.452048674332) 15 5 11 29492 9
136133 199415 DPW Maintained 1 Ficus Spp. :: 101 431 Mississippi St 1 : Tree Private 2     14 Width 3ft   6014097.52278 2105089.09032 37.7609663518261 -122.394334005715 (37.7609663518261, -122.394334005715) 10 3 8 28856 29
191840 199414 DPW Maintained 1 Ficus Spp. :: 101 1247 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6012275.78259 2102564.1308 37.7539319339304 -122.400457284478 (37.7539319339304, -122.400457284478) 10 3 8 28856 29
191920 224459 DPW Maintained 1 Ficus Spp. :: 101 2044 Bryant St 6 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 3ft   6009528.13819 2105154.39369 37.7608906010467 -122.410142185216 (37.7608906010467, -122.410142185216) 2 4 7 28859 19

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