trees
11 rows where PlotSize = "Width 4ft", SiteOrder = 2 and qSpecies_id = 65 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
652 | 144195 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 630 42nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/2020 12:17:00 PM | 0 | Width 4ft | 5982905.71974 | 2111464.01201 | 37.7766868258595 | -122.502682939079 | (37.7766868258595, -122.502682939079) | 11 | 6 | 2 | 55 | 26 | ||
43499 | 203561 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 509 Lawton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5992707.23353 | 2104539.55392 | 37.7582452263566 | -122.468273046583 | (37.7582452263566, -122.468273046583) | 1 | 8 | 4 | 56 | 12 | |||
47655 | 189217 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1634 Jerrold Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6015116.50224 | 2097212.0883 | 37.7393943516633 | -122.390259427548 | (37.7393943516633, -122.390259427548) | 10 | 3 | 8 | 58 | 1 | |||
115143 | 221806 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1350 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6003875.18729 | 2100363.84416 | 37.7474184051535 | -122.429351626769 | (37.7474184051535, -122.429351626769) | 2 | 7 | 5 | 63 | 22 | |||
115309 | 203525 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2428 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992054.69549 | 2098894.88306 | 37.74270871135 | -122.470118765694 | (37.74270871135, -122.470118765694) | 1 | 8 | 4 | 29491 | 40 | |||
126749 | 175180 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 690 Athens St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 6002933.07108 | 2089399.59548 | 37.7172596870602 | -122.43182665728 | (37.7172596870602, -122.43182665728) | 9 | 7 | 6 | 28861 | 5 | |||
142588 | 203516 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 301 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5993037.18841 | 2102512.99868 | 37.7526998825032 | -122.466984597774 | (37.7526998825032, -122.466984597774) | 1 | 8 | 4 | 29491 | 12 | |||
145252 | 123201 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 1310 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5993108.25102 | 2112027.19449 | 37.7788274527304 | -122.467430639975 | (37.7788274527304, -122.467430639975) | 11 | 6 | 2 | 54 | 11 | |||
146877 | 203582 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 24 Gennessee St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5997457.41638 | 2093726.64675 | 37.7288288329774 | -122.451065185614 | (37.7288288329774, -122.451065185614) | 9 | 7 | 4 | 28861 | 40 | |||
179502 | 221830 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 2451 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6008241.38226 | 2104159.63616 | 37.7580870167112 | -122.414522128209 | (37.7580870167112, -122.414522128209) | 2 | 4 | 7 | 28859 | 19 | |||
186130 | 221808 | DPW Maintained 1 | Agonis flexuosa :: Peppermint Willow 65 | 3720 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6004922.45206 | 2102542.08461 | 37.753458583869 | -122.425885280803 | (37.753458583869, -122.425885280803) | 2 | 4 | 5 | 28862 | 22 |
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) );