trees
21 rows where qSpecies_id = 280
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4764 | 234494 | DPW Maintained 1 | Pinus muricata :: Bishop Pine 280 | 101 Prospect Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 23 | 6006984.21795 | 2098930.06522 | 37.7436570977129 | -122.418499132638 | (37.7436570977129, -122.418499132638) | 2 | 7 | 7 | 28859 | 2 | ||||
| 11168 | 132167 | DPW Maintained 1 | Pinus muricata :: Bishop Pine 280 | 2600 Divisadero St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6000732.76285 | 2117258.7957 | 37.7936293041036 | -122.441430019189 | (37.7936293041036, -122.441430019189) | 13 | 9 | 1 | 57 | 27 | |||
| 13654 | 132172 | DPW Maintained 1 | Pinus muricata :: Bishop Pine 280 | 2660 Divisadero St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 4ft | 6000708.21595 | 2117451.76226 | 37.7941577412367 | -122.441528807029 | (37.7941577412367, -122.441528807029) | 13 | 9 | 1 | 57 | 27 | |||
| 24466 | 8211 | DPW Maintained 1 | Pinus muricata :: Bishop Pine 280 | 2189X Funston Ave | 2 | Median : Cutout | Tree | DPW 1 | 3 | 8X25 | 5992289.98615 | 2100521.20656 | 37.7471877793895 | -122.469423560971 | (37.7471877793895, -122.469423560971) | 1 | 8 | 4 | 29491 | 40 | |||
| 27174 | 87027 | Permitted Site 7 | Pinus muricata :: Bishop Pine 280 | 23 Magellan Ave | 1 | Median : Cutout | Tree | Private 2 | 3x3 | Permit Number 49971 | 5994623.4 | 2101166.9 | 37.7490952636688 | -122.461401658799 | (37.7490952636688, -122.461401658799) | 1 | 8 | 4 | 29491 | 40 | |||
| 37200 | 211052 | DPW Maintained 1 | Pinus muricata :: Bishop Pine 280 | 22 Bella Vista Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 3ft | 5998708.36986 | 2096976.77006 | 37.7378244429432 | -122.446974360306 | (37.7378244429432, -122.446974360306) | 9 | 7 | 4 | 59 | 40 | |||
| 43631 | 234497 | DPW Maintained 1 | Pinus muricata :: Bishop Pine 280 | 319 Virginia Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 29 | Width 3ft | 6006916.18961 | 2098124.94387 | 37.741442584617 | -122.418677274835 | (37.741442584617, -122.418677274835) | 2 | 7 | 7 | 28859 | 2 | |||
| 46058 | 132170 | DPW Maintained 1 | Pinus muricata :: Bishop Pine 280 | 2600 Divisadero St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6000727.16458 | 2117291.40452 | 37.7937185204489 | -122.441451730627 | (37.7937185204489, -122.441451730627) | 13 | 9 | 1 | 57 | 27 | |||
| 51383 | 211053 | DPW Maintained 1 | Pinus muricata :: Bishop Pine 280 | 22 Bella Vista Way | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5998636.7251 | 2097022.14809 | 37.7379449467086 | -122.447225335003 | (37.7379449467086, -122.447225335003) | 9 | 7 | 4 | 59 | 40 | |||
| 55972 | 132169 | DPW Maintained 1 | Pinus muricata :: Bishop Pine 280 | 2600 Divisadero St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6000728.22452 | 2117282.00982 | 37.7936927854492 | -122.441447388701 | (37.7936927854492, -122.441447388701) | 13 | 9 | 1 | 57 | 27 | |||
| 76633 | 132168 | DPW Maintained 1 | Pinus muricata :: Bishop Pine 280 | 2600 Divisadero St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6000730.50016 | 2117270.71509 | 37.793661902722 | -122.441438703959 | (37.793661902722, -122.441438703959) | 13 | 9 | 1 | 57 | 27 | |||
| 90983 | 234496 | DPW Maintained 1 | Pinus muricata :: Bishop Pine 280 | 319 Virginia Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 6006920.2208 | 2098172.14234 | 37.7415724080422 | -122.418666682638 | (37.7415724080422, -122.418666682638) | 2 | 7 | 7 | 28859 | 2 | |||
| 95211 | 132166 | DPW Maintained 1 | Pinus muricata :: Bishop Pine 280 | 2600 Divisadero St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6000733.82305 | 2117249.40067 | 37.7936035682113 | -122.441425676352 | (37.7936035682113, -122.441425676352) | 13 | 9 | 1 | 57 | 27 | |||
| 108711 | 234500 | DPW Maintained 1 | Pinus muricata :: Bishop Pine 280 | 4090 20th St | 8 | : Yard | Tree | Private 2 | 9 | Width 3ft | 6003098.9698 | 2104154.51537 | 37.7577827158042 | -122.432306416827 | (37.7577827158042, -122.432306416827) | 2 | 4 | 5 | 28862 | 3 | |||
| 120580 | 234495 | DPW Maintained 1 | Pinus muricata :: Bishop Pine 280 | 101 Prospect Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | 6006979.85845 | 2098918.36092 | 37.7436247149028 | -122.418513376991 | (37.7436247149028, -122.418513376991) | 2 | 7 | 7 | 28859 | 2 | ||||
| 125364 | 234499 | DPW Maintained 1 | Pinus muricata :: Bishop Pine 280 | 240 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003593.7917 | 2101005.47854 | 37.7491642482304 | -122.430370445337 | (37.7491642482304, -122.430370445337) | 2 | 4 | 5 | 28862 | 22 | |||
| 140608 | 211054 | DPW Maintained 1 | Pinus muricata :: Bishop Pine 280 | 545 Teresita Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 5998992.8807 | 2097359.88674 | 37.7388926405891 | -122.44601821997 | (37.7388926405891, -122.44601821997) | 9 | 7 | 4 | 59 | 40 | |||
| 141965 | 211051 | DPW Maintained 1 | Pinus muricata :: Bishop Pine 280 | 135 Fernwood Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 55 | Width 2ft | 5994767.60349 | 2094950.02192 | 37.7320335589939 | -122.460452594226 | (37.7320335589939, -122.460452594226) | 9 | 8 | 4 | 59 | 40 | |||
| 166994 | 132171 | DPW Maintained 1 | Pinus muricata :: Bishop Pine 280 | 2600 Divisadero St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6000726.09791 | 2117300.48722 | 37.7937433983948 | -122.441456073444 | (37.7937433983948, -122.441456073444) | 13 | 9 | 1 | 57 | 27 | |||
| 171423 | 234498 | DPW Maintained 1 | Pinus muricata :: Bishop Pine 280 | 319 Virginia Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 27 | Width 3ft | 6006908.1598 | 2098121.75298 | 37.7414333710501 | -122.418704812971 | (37.7414333710501, -122.418704812971) | 2 | 7 | 7 | 28859 | 2 | |||
| 177540 | 211055 | DPW Maintained 1 | Pinus muricata :: Bishop Pine 280 | 300x Marietta Dr | 72 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 5999722.47175 | 2097250.79063 | 37.7386347240172 | -122.443487806529 | (37.7386347240172, -122.443487806529) | 9 | 7 | 4 | 59 | 40 |
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) );