trees

25 rows where Fire Prevention Districts = 11 and qSpecies_id = 54

✎ View and edit SQL

This data as json, CSV (advanced)

Fire Prevention Districts ✖

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)
39177 141081 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 190 Commonwealth Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5996587.7084 2113030.7088 37.7817830987642 -122.455466443539 (37.7817830987642, -122.455466443539) 11 6 1 54 31
43809 141086 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 3370 GEARY BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5996653.0238 2112962.686 37.7816000737762 -122.45523556685 (37.7816000737762, -122.45523556685) 11 6 1 54 31
56244 28068 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 3445 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   5996452.8473 2112841.7002 37.78125639187 -122.455919329089 (37.78125639187, -122.455919329089) 11 6 2 54 16
60248 53539 Permitted Site 7 Ficus retusa nitida :: Banyan Fig 54 322 02nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/11/1969 12:00:00 AM     Permit Number 776401 5995280.52661988 2113383.63166464 37.7826770367733 -122.460014224406 (37.7826770367733, -122.460014224406) 11 6 2 54 11
72300 251046 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 5625 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5989523.2215 2112593.8297 37.7801756529596 -122.479874006145 (37.7801756529596, -122.479874006145) 11 6 2 55 26
92829 9075 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 5612 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   5989561.9341 2112697.6008 37.7804628284507 -122.479747678424 (37.7804628284507, -122.479747678424) 11 6 2 55 26
104054 53486 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 3360 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/1969 12:00:00 AM 14   Permit Number 6395 5996703.1102 2112969.116 37.7816206023811 -122.455062757544 (37.7816206023811, -122.455062757544) 11 6 1 54 31
111163 141074 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 189 COMMONWEALTH AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5996533.2225 2113090.6095 37.7819444436309 -122.455659269227 (37.7819444436309, -122.455659269227) 11 6 1 54 31
115016 141083 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 3360 GEARY BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5996691.6039 2112967.4239 37.7816152962122 -122.45510244133 (37.7816152962122, -122.45510244133) 11 6 1 54 31
127716 141087 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 3380 GEARY BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5996639.8253 2112960.6555 37.781593741302 -122.45528108032 (37.781593741302, -122.45528108032) 11 6 1 54 31
127980 141088 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 3380 GEARY BLVD 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   5996627.3037 2112959.9786 37.7815911642759 -122.455324349899 (37.7815911642759, -122.455324349899) 11 6 1 54 31
134454 141080 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 192 Commonwealth Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5996588.0468 2113019.8793 37.7817533832417 -122.455464489898 (37.7817533832417, -122.455464489898) 11 6 1 54 31
143879 64376 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 69 Beaumont Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1988 12:00:00 AM 11   Permit Number 25215 5996673.1599 2112554.0417 37.7804791997483 -122.455136367138 (37.7804791997483, -122.455136367138) 11 6 2 54 16
147438 141078 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 196 Commonwealth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5996588.0468 2112978.9303 37.7816409481265 -122.455461529406 (37.7816409481265, -122.455461529406) 11 6 1 54 31
149785 141084 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 3360 GEARY BLVD 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5996679.0822 2112965.7318 37.7816099317752 -122.45514563789 (37.7816099317752, -122.45514563789) 11 6 1 54 31
150274 251080 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 5616 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5989535.588 2112697.0631 37.7804598215152 -122.47983878159 (37.7804598215152, -122.47983878159) 11 6 2 55 26
150946 142150 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 20 Stanyan Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5996389.5624 2112799.0591 37.7811356783284 -122.456135178495 (37.7811356783284, -122.456135178495) 11 6 2 54 16
151344 9008 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 5255 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   5990650.4547 2112633.3493 37.7803495870008 -122.475977319009 (37.7803495870008, -122.475977319009) 11 6 2 54 26
152159 141085 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 3370 GEARY BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   5996665.207 2112963.3629 37.7816026313548 -122.455193467958 (37.7816026313548, -122.455193467958) 11 6 1 54 31
157652 28067 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 3445 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   5996427.4656 2112840.3465 37.7812512181791 -122.456007038851 (37.7812512181791, -122.456007038851) 11 6 2 54 16
167541 251079 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 5616 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5989547.9545 2112698.1385 37.7804634926969 -122.479796079248 (37.7804634926969, -122.479796079248) 11 6 2 55 26
170716 141079 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 194 Commonwealth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   5996588.7236 2113000.2508 37.7816995274116 -122.455460729419 (37.7816995274116, -122.455460729419) 11 6 1 54 31
172618 141075 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 189 COMMONWEALTH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5996533.8993 2113075.3805 37.7819026676704 -122.455655826701 (37.7819026676704, -122.455655826701) 11 6 1 54 31
179334 141082 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 188 Commonwealth Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   5996586.3547 2113042.2151 37.7818146143415 -122.455471958556 (37.7818146143415, -122.455471958556) 11 6 1 54 31
181049 9074 DPW Maintained 1 Ficus retusa nitida :: Banyan Fig 54 5612 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   5989576.4513 2112697.6008 37.780463671789 -122.479697457165 (37.780463671789, -122.479697457165) 11 6 2 55 26

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