trees
14 rows where Neighborhoods (old) = 3 and qSpecies_id = 224 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12849 | 94786 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 1X CASELLI AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2010 12:00:00 AM | 3x3 | Permit Number 53882 | 6000842 | 2104917 | 37.7597480805722 | -122.440166611531 | (37.7597480805722, -122.440166611531) | 2 | 4 | 5 | 28862 | 3 | ||
78431 | 110449 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 28 BELCHER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 775444 | 6003746 | 2108157 | 37.7688092427031 | -122.430354279635 | (37.7688092427031, -122.430354279635) | 7 | 9 | 5 | 28862 | 3 | |||
97224 | 94785 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 1X CASELLI AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2010 12:00:00 AM | 3x3 | Permit Number 53882 | 6000842 | 2104917 | 37.7597480805722 | -122.440166611531 | (37.7597480805722, -122.440166611531) | 2 | 4 | 5 | 28862 | 3 | ||
110759 | 110448 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 28 BELCHER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 775444 | 6003746 | 2108157 | 37.7688092427031 | -122.430354279635 | (37.7688092427031, -122.430354279635) | 7 | 9 | 5 | 28862 | 3 | |||
155991 | 94784 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 1X CASELLI AVE | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/04/2010 12:00:00 AM | 3x3 | Permit Number 53882 | 6000842 | 2104917 | 37.7597480805722 | -122.440166611531 | (37.7597480805722, -122.440166611531) | 2 | 4 | 5 | 28862 | 3 | ||
163265 | 87372 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 67 Belcher St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2008 12:00:00 AM | 3x3 | Permit Number 50351 | 6003819 | 2107947 | 37.7682367684387 | -122.430086795172 | (37.7682367684387, -122.430086795172) | 7 | 9 | 5 | 28862 | 3 | ||
168295 | 87371 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 67 Belcher St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2008 12:00:00 AM | 3x3 | Permit Number 50351 | 6003819 | 2107947 | 37.7682367684387 | -122.430086795172 | (37.7682367684387, -122.430086795172) | 7 | 9 | 5 | 28862 | 3 | ||
153574 | 100151 | Undocumented 4 | Magnolia spp :: Magnolia 224 | 4047 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 5x5 | Permit Number 776452 | 6002690 | 2105300 | 37.7609047432887 | -122.433802674054 | (37.7609047432887, -122.433802674054) | 2 | 4 | 5 | 28862 | 3 | ||
91213 | 57434 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 4324 18TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1976 12:00:00 AM | 20 | 9x6 | Permit Number 16276 | 6001563 | 2105306 | 37.7608572014532 | -122.437700893331 | (37.7608572014532, -122.437700893331) | 15 | 4 | 5 | 28862 | 3 | |
132772 | 57433 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 4316 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1976 12:00:00 AM | 20 | 6x6 | Permit Number 16275 | 6001651.18541617 | 2105289.61210405 | 37.7608172180801 | -122.437394726023 | (37.7608172180801, -122.437394726023) | 15 | 4 | 5 | 28862 | 3 | |
163852 | 57435 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 4328 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/16/1976 12:00:00 AM | 24 | 6x6 | Permit Number 16277 | 6001615.3752968 | 2105287.59579624 | 37.7608096458957 | -122.437518432693 | (37.7608096458957, -122.437518432693) | 15 | 4 | 5 | 28862 | 3 | |
6434 | 230789 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 3933 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/11/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 767282 | 6004098.889 | 2104204.25697 | 37.757975940552 | -122.428851827645 | (37.757975940552, -122.428851827645) | 2 | 4 | 5 | 28862 | 3 | |
37133 | 5427 | DPW Maintained 1 | Magnolia spp :: Magnolia 224 | 460X Dolores St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004889.2026724 | 2105697.5669462 | 37.7621209168257 | -122.426224900449 | (37.7621209168257, -122.426224900449) | 8 | 4 | 5 | 28862 | 3 | |||
165128 | 51939 | Permitted Site 7 | Magnolia spp :: Magnolia 224 | 61 Pond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/2005 12:00:00 AM | 8 | 5x2 | Permit Number 48164 | 6003201.44301211 | 2106166.49517673 | 37.763312938971 | -122.432095698187 | (37.763312938971, -122.432095698187) | 15 | 4 | 5 | 28862 | 3 |
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) );