trees
27 rows where Zip Codes = 56 and qSpecies_id = 66 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
133233 | 184755 | DPW Maintained 1 | Shrub :: Shrub 66 | 1301 Sunset Blvd | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984688.1718 | 2106071.0721 | 37.7619839309054 | -122.496119032944 | (37.7619839309054, -122.496119032944) | 1 | 8 | 3 | 56 | 35 | |||
144873 | 181567 | DPW Maintained 1 | Shrub :: Shrub 66 | 1300 Sunset Blvd | 62 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984855.7554 | 2106265.0899 | 37.7625264639896 | -122.495553745896 | (37.7625264639896, -122.495553745896) | 1 | 8 | 3 | 56 | 35 | |||
183891 | 186250 | DPW Maintained 1 | Shrub :: Shrub 66 | 1701 Sunset Blvd | 61 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984767.3503 | 2103112.4152 | 37.753864919503 | -122.495626952484 | (37.753864919503, -122.495626952484) | 1 | 8 | 3 | 56 | 35 | |||
193173 | 186364 | DPW Maintained 1 | Shrub :: Shrub 66 | 1801 Sunset Blvd | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984815.8043 | 2102571.1093 | 37.7523814800587 | -122.495419470402 | (37.7523814800587, -122.495419470402) | 1 | 8 | 3 | 56 | 35 | |||
69162 | 181582 | DPW Maintained 1 | Shrub :: Shrub 66 | 1200 Sunset Blvd | 72 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984863.0361 | 2106906.9776 | 37.7642893338004 | -122.495575911156 | (37.7642893338004, -122.495575911156) | 1 | 8 | 3 | 56 | 35 | |||
120610 | 181577 | DPW Maintained 1 | Shrub :: Shrub 66 | 1200 Sunset Blvd | 59 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984846.2035 | 2106866.5794 | 37.7641774260073 | -122.495631149537 | (37.7641774260073, -122.495631149537) | 1 | 8 | 3 | 56 | 35 | |||
140028 | 184206 | DPW Maintained 1 | Shrub :: Shrub 66 | 1484 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5983432.9268 | 2105012.9881 | 37.7590051267749 | -122.500382134012 | (37.7590051267749, -122.500382134012) | 1 | 8 | 3 | 56 | 35 | |||
163645 | 184622 | DPW Maintained 1 | Shrub :: Shrub 66 | 1778 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5983811.7777 | 2103069.4322 | 37.7536908962098 | -122.498928317229 | (37.7536908962098, -122.498928317229) | 1 | 8 | 3 | 56 | 35 | |||
102820 | 186362 | DPW Maintained 1 | Shrub :: Shrub 66 | 1801 Sunset Blvd | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 0ft | 5984819.5753 | 2102574.8802 | 37.7523920547151 | -122.495406707945 | (37.7523920547151, -122.495406707945) | 1 | 8 | 3 | 56 | 35 | |||
36371 | 186363 | DPW Maintained 1 | Shrub :: Shrub 66 | 1801 Sunset Blvd | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5984829.0026 | 2102575.9576 | 37.7523955649491 | -122.495374186734 | (37.7523955649491, -122.495374186734) | 1 | 8 | 3 | 56 | 35 |
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) );