24 rows where qSpecies_id = 252 sorted by PlotSize

View and edit SQL

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)
7556 48879 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 508 (Revised) Missouri St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2002 12:00:00 AM 18   Permit Number 46086 6013517.21879 2104630.95561 37.7596761394707 -122.396308926831 (37.7596761394707, -122.396308926831) 10 3 8 28856 29
109092 221196 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 150 Coso Ave 7 Sidewalk: Curb side : Yard Tree Private 2     5     6007431.47639 2099616.35507 37.7455666650753 -122.417001233518 (37.7455666650753, -122.417001233518) 2 7 7 28859 2
119040 188798 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 1301 Minnesota St 34 Front Yard : Yard Tree Private 2     5     6015381.44838 2102498.58417 37.7539246610983 -122.389712491354 (37.7539246610983, -122.389712491354) 10 3 8 28856 29
129631 35002 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 370 De Haro St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/18/1999 12:00:00 AM 3   Permit Number 41321 6011984.13813 2106670.27599 37.7651902309691 -122.401754467513 (37.7651902309691, -122.401754467513) 8 3 8 28853 20
4821 243633 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 4757 25th St 1 Front Yard : Pot Landscaping Private 2     0 Width 10ft   6000099.67022 2101057.51685 37.749108590101 -122.442456864219 (37.749108590101, -122.442456864219) 2 4 5 28862 22
27794 188806 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 657 Rhode Island St 2 Sidewalk: Curb side : Pot Tree Private 2     3 Width 2ft   6011845.39378 2105334.97386 37.7615160462566 -122.402140468218 (37.7615160462566, -122.402140468218) 10 3 8 28856 29
70984 188803 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 370 De Haro St 7 Sidewalk: Curb side : Pot Tree Private 2     3 Width 2ft   6011986.97083 2106581.47042 37.7649465488559 -122.401738427204 (37.7649465488559, -122.401738427204) 8 3 8 28853 20
74763 188801 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 370 De Haro St 5 Sidewalk: Curb side : Pot Tree Private 2     3 Width 2ft   6011992.23861 2106628.45782 37.7650758596913 -122.401723510132 (37.7650758596913, -122.401723510132) 8 3 8 28853 20
91957 188805 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 657 Rhode Island St 1 Sidewalk: Curb side : Pot Tree Private 2     6 Width 2ft   6011846.53747 2105316.89164 37.7614664603431 -122.402135241342 (37.7614664603431, -122.402135241342) 10 3 8 28856 29
109321 188799 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 370 De Haro St 2 Sidewalk: Curb side : Pot Tree Private 2     3 Width 2ft   6011991.8145 2106659.37833 37.7651607368141 -122.401727150587 (37.7651607368141, -122.401727150587) 8 3 8 28853 20
127973 188802 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 370 De Haro St 6 Sidewalk: Curb side : Pot Tree Private 2     3 Width 2ft   6011993.79056 2106593.57945 37.7649801781082 -122.401715690531 (37.7649801781082, -122.401715690531) 8 3 8 28853 20
155558 188800 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 370 De Haro St 4 Sidewalk: Curb side : Pot Tree Private 2     3 Width 2ft   6011992.46212 2106639.45564 37.7651060697129 -122.401723510151 (37.7651060697129, -122.401723510151) 8 3 8 28853 20
136936 188804 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 156 Texas St 3 Sidewalk: Property side : Yard Tree Private 2     3 Width 3ft   6013681.45614 2106329.05253 37.7643478791612 -122.39585989804 (37.7643478791612, -122.39585989804) 14 3 8 28856 29
178078 221197 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 3315 20th St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6008125.18371 2104431.73276 37.7588276030241 -122.414943251948 (37.7588276030241, -122.414943251948) 2 4 7 28859 19
180423 188807 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 1751 22nd St 5 Sidewalk: Property side : Yard Tree Private 2     18 Width 3ft   6012841.80925 2103757.31487 37.7572397069546 -122.398583541591 (37.7572397069546, -122.398583541591) 10 3 8 28856 29
36406 188808 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 2200 Alameda St 7 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6010390.30388 2107888.20316 37.7684453082249 -122.407353050314 (37.7684453082249, -122.407353050314) 8 4 8 28853 19
3118 188810 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 1499 Rankin St 8 Side Yard : Yard Tree Private 2     24 Width 5ft   6012693.20045 2096700.71926 37.7378555261977 -122.398602316748 (37.7378555261977, -122.398602316748) 10 3 8 58 1
89612 188809 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 1842 Illinois St 1 : Tree Private 2     25 Width 6ft   6016259.82532 2100544.95868 37.7486090814646 -122.386538616586 (37.7486090814646, -122.386538616586) 10 3 8 58 1
114143 117848 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 640x 39th Ave 3 Median : Cutout Tree DPW 1     1 Width 6ft   5983816.13429 2111394.76914 37.7765501643732 -122.499528478131 (37.7765501643732, -122.499528478131) 11 6 2 55 26
127536 221191 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 84 Elgin Park 1 : Tree Private 2     2 Width 6ft   6005819.26634 2108627.07323 37.7702171714132 -122.423216410424 (37.7702171714132, -122.423216410424) 8 2 5 28853 19
76972 221195 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 200 Saint Marys Ave 2 Side Yard : Yard Tree Private 2     18 Width 7ft   6003941.6017 2095959.63254 37.7353292100649 -122.428808043276 (37.7353292100649, -122.428808043276) 2 7 5 63 7
32454 221194 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 1298 Vermont St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 8ft   6011381.87343 2102429.54936 37.7535125117077 -122.403539182002 (37.7535125117077, -122.403539182002) 10 4 8 28859 19
33024 221192 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 38 Dolores St 1 Sidewalk: Curb side : Pot Tree Private 2     12 Width 8ft   6004728.48786 2108042.49071 37.7685504308788 -122.426947766841 (37.7685504308788, -122.426947766841) 8 4 5 28862 3
36102 221193 DPW Maintained 1 Bambusa spp :: Bamboo Species 252 38 Dolores St 4 Sidewalk: Curb side : Pot Tree Private 2     12 Width 8ft   6004729.52945 2108000.8777 37.7684362304735 -122.426941199969 (37.7684362304735, -122.426941199969) 8 4 5 28862 3

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