trees
25 rows where Fire Prevention Districts = 11 and qSpecies_id = 54 sorted by Fire Prevention Districts
This data as json, CSV (advanced)
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
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) );