trees
12 rows where Neighborhoods (old) = 11 and qSpecies_id = 151 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
78472 | 123457 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 607 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995303.78835 | 2111399.35412 | 37.7772300773628 | -122.459789972595 | (37.7772300773628, -122.459789972595) | 11 | 6 | 2 | 54 | 11 | |||
143358 | 47401 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 442 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/14/2002 12:00:00 AM | Permit Number 45312 | 5994381.12828597 | 2112514.18639084 | 37.780238005012 | -122.463062632294 | (37.780238005012, -122.463062632294) | 11 | 6 | 2 | 54 | 11 | ||
125727 | 105520 | Undocumented 4 | Melaleuca ericifolia :: Heath Melaleuca 151 | 3851X Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994314 | 2113544 | 37.7830617285902 | -122.463369610154 | (37.7830617285902, -122.463369610154) | 11 | 6 | 2 | 54 | 11 | ||||
116366 | 59096 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 735 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49983 | 5993787.7809 | 2110375.019 | 37.7743302287246 | -122.464959874093 | (37.7743302287246, -122.464959874093) | 11 | 6 | 2 | 54 | 11 | |
188020 | 87046 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 735@ 8th Ave 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/30/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53657 | 5993787.03862 | 2110396.38433 | 37.7743888494182 | -122.464963993756 | (37.7743888494182, -122.464963993756) | 11 | 6 | 2 | 54 | 11 | |
141258 | 87040 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 735 07th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49983 | 5993786.75747 | 2110417.02828 | 37.7744455159827 | -122.4649664659 | (37.7744455159827, -122.4649664659) | 11 | 6 | 2 | 54 | 11 | |
32603 | 87041 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 735 07th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49983 | 5993785.44399 | 2110433.89839 | 37.7744917610659 | -122.464972234911 | (37.7744917610659, -122.464972234911) | 11 | 6 | 2 | 54 | 11 | |
40483 | 87042 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 735 07th Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49983 | 5993785.1728 | 2110455.01638 | 37.7745497297907 | -122.464974707047 | (37.7745497297907, -122.464974707047) | 11 | 6 | 2 | 54 | 11 | |
157761 | 87043 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 735 07th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/10/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49983 | 5993784.66357 | 2110476.13962 | 37.7746076992047 | -122.464978002989 | (37.7746076992047, -122.464978002989) | 11 | 6 | 2 | 54 | 11 | |
85201 | 68664 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 211 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | Permit Number 32571 | 5993343.03467885 | 2114079.66644038 | 37.7844765349697 | -122.46676767712 | (37.7844765349697, -122.46676767712) | 11 | 6 | 2 | 54 | 11 | ||
62954 | 103530 | DPW Maintained 1 | Melaleuca ericifolia :: Heath Melaleuca 151 | 155 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x9 | 5993328.74433 | 2114475.40992 | 37.7855623136611 | -122.466845895101 | (37.7855623136611, -122.466845895101) | 11 | 6 | 2 | 54 | 11 | |||
106252 | 68686 | Permitted Site 7 | Melaleuca ericifolia :: Heath Melaleuca 151 | 128 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/02/1993 12:00:00 AM | Permit Number 32596 | 5992134.97207697 | 2114599.88023196 | 37.7858351044588 | -122.470985030783 | (37.7858351044588, -122.470985030783) | 11 | 6 | 2 | 54 | 11 |
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) );