trees
8 rows where PlotSize = "3x3" and qSpecies_id = 119 sorted by Latitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 135986 | 88782 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 166 Havelock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/02/2008 12:00:00 AM | 9 | 3x3 | Permit Number 51699 | 5999327.15741 | 2092949.02389 | 37.7268005308142 | -122.444545520761 | (37.7268005308142, -122.444545520761) | 9 | 7 | 6 | 28861 | 25 | |
| 180433 | 109627 | Undocumented 4 | Eriobotrya japonica :: Edible Loquat 119 | 500 CIRCULAR AVE | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 5999334 | 2093430 | 37.728121569817 | -122.444556419888 | (37.728121569817, -122.444556419888) | 9 | 7 | 4 | 28861 | 40 | ||||
| 8190 | 261370 | Planning Code 138.1 required 2 | Eriobotrya japonica :: Edible Loquat 119 | 102 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007140 | 2095356 | 37.7338522748733 | -122.417707198486 | (37.7338522748733, -122.417707198486) | 2 | 7 | 7 | 28859 | 2 | ||||
| 122868 | 17442 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1944 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6013068.40824 | 2096637.61256 | 37.73770314508 | -122.397300607455 | (37.73770314508, -122.397300607455) | 10 | 3 | 8 | 58 | 1 | |||
| 131673 | 111563 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1498x Kansas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3x3 | 6011720.06091 | 2101415.90544 | 37.7507481513226 | -122.40229838558 | (37.7507481513226, -122.40229838558) | 10 | 3 | 8 | 28856 | 29 | |||
| 98191 | 173854 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 240 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013446 | 2105960 | 37.763321440581 | -122.396648407729 | (37.763321440581, -122.396648407729) | 14 | 3 | 8 | 28856 | 29 | ||||
| 79000 | 99679 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 165 Grattan St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.450520485859 | (37.7638673579207, -122.450520485859) | 15 | 5 | 11 | 29492 | 9 | ||
| 22081 | 111169 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 1469 Pacific Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6007081.20428 | 2117722.03099 | 37.7952608496747 | -122.419496712817 | (37.7952608496747, -122.419496712817) | 5 | 1 | 10 | 28858 | 32 |
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) );