trees
10 rows where qSpecies_id = 333
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9993 | 47292 | Permitted Site 7 | Ailanthus altissima :: Tree Of Heaven 333 | 2801x 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/16/2002 12:00:00 AM | Permit Number 45232 | 6009524 | 2104958 | 37.7603511166103 | -122.410142631678 | (37.7603511166103, -122.410142631678) | 2 | 4 | 7 | 28859 | 19 | ||
31159 | 221969 | DPW Maintained 1 | Ailanthus altissima :: Tree Of Heaven 333 | 3900 22nd St | 9 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6002406.82062 | 2102995.69652 | 37.7545616068583 | -122.434617293171 | (37.7545616068583, -122.434617293171) | 2 | 4 | 5 | 28862 | 22 | |||
36736 | 101527 | Significant Tree 6 | Ailanthus altissima :: Tree Of Heaven 333 | 151-153 Lower Ter | 1 | Front Yard : Yard | Tree | Private 2 | 18 | Permit Number 769490 | 6000139.7 | 2106146.6 | 37.7630842500585 | -122.4426838025 | (37.7630842500585, -122.4426838025) | 15 | 5 | 5 | 28862 | 3 | |||
67155 | 187969 | DPW Maintained 1 | Ailanthus altissima :: Tree Of Heaven 333 | 1630 Jerrold Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6015189.03434 | 2097156.64279 | 37.7392461326034 | -122.390004769231 | (37.7392461326034, -122.390004769231) | 10 | 3 | 8 | 58 | 1 | |||
71457 | 215470 | DPW Maintained 1 | Ailanthus altissima :: Tree Of Heaven 333 | 2 Sola Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 4ft | 5994985.87708 | 2100710.42792 | 37.7478627619652 | -122.460115152419 | (37.7478627619652, -122.460115152419) | 1 | 8 | 4 | 29491 | 40 | |||
105473 | 187968 | DPW Maintained 1 | Ailanthus altissima :: Tree Of Heaven 333 | 600 Illinois St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6015942.9159 | 2106228.07287 | 37.7641961608518 | -122.388031024433 | (37.7641961608518, -122.388031024433) | 14 | 3 | 8 | 28856 | 29 | |||
107229 | 255805 | Significant Tree 6 | Ailanthus altissima :: Tree Of Heaven 333 | 2 Sola Ave | 1 | Front Yard : Yard | Tree | Private 2 | 10x10 | 5994994 | 2100719 | 37.7478867659483 | -122.460087684856 | (37.7478867659483, -122.460087684856) | 1 | 8 | 4 | 29491 | 40 | ||||
130003 | 187970 | DPW Maintained 1 | Ailanthus altissima :: Tree Of Heaven 333 | 1630 Jerrold Ave | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6015180.35371 | 2097164.4459 | 37.7392670769075 | -122.390035328173 | (37.7392670769075, -122.390035328173) | 10 | 3 | 8 | 58 | 1 | |||
167607 | 221970 | DPW Maintained 1 | Ailanthus altissima :: Tree Of Heaven 333 | 3900 22nd St | 10 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 4ft | 6002405.12131 | 2102995.45063 | 37.7545608352344 | -122.434623152247 | (37.7545608352344, -122.434623152247) | 2 | 4 | 5 | 28862 | 22 | |||
185733 | 175228 | DPW Maintained 1 | Ailanthus altissima :: Tree Of Heaven 333 | 102 France Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 1ft | 6001368.13444 | 2090223.95068 | 37.7194343448899 | -122.437294890573 | (37.7194343448899, -122.437294890573) | 9 | 7 | 6 | 28861 | 5 |
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) );