trees
19 rows where Fire Prevention Districts = 15 and qSpecies_id = 160 sorted by qSpecies_id
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3603 | 247549 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 815 Buena Vista Ave West | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 32 | Width 2ft | 6000106.41756 | 2108406.30035 | 37.7692869261681 | -122.442961199511 | (37.7692869261681, -122.442961199511) | 15 | 5 | 11 | 29492 | 9 | |||
| 7222 | 25538 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2200X Market St | 4 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003277.964 | 2106841.2745 | 37.7651700578839 | -122.431879221699 | (37.7651700578839, -122.431879221699) | 15 | 4 | 5 | 28862 | 3 | ||
| 24974 | 25527 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2300X Market St | 2 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002730.2479 | 2106324.2376 | 37.7637193356407 | -122.433736680672 | (37.7637193356407, -122.433736680672) | 15 | 4 | 5 | 28862 | 3 | ||
| 31694 | 234402 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 667 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 3ft | 6002514.48058 | 2108813.73054 | 37.7705426279609 | -122.434660977745 | (37.7705426279609, -122.434660977745) | 15 | 5 | 5 | 29492 | 9 | |||
| 36707 | 25526 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2300X Market St | 1 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002746.7355 | 2106338.4868 | 37.7637593960329 | -122.433680673672 | (37.7637593960329, -122.433680673672) | 15 | 4 | 5 | 28862 | 3 | ||
| 49235 | 110583 | Significant Tree 6 | Phoenix canariensis :: Canary Island Date Palm 160 | 46 COOK ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 5997534 | 2113434 | 37.782944683725 | -122.452221842699 | (37.782944683725, -122.452221842699) | 15 | 6 | 1 | 54 | 31 | ||||
| 49888 | 25532 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2300X Market St | 7 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002592.5231 | 2106186.5128 | 37.7633333608706 | -122.43420318117 | (37.7633333608706, -122.43420318117) | 15 | 4 | 5 | 28862 | 3 | ||
| 50720 | 25534 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2300X Market St | 9 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002560.5766 | 2106158.8258 | 37.7632555258533 | -122.434311693987 | (37.7632555258533, -122.434311693987) | 15 | 4 | 5 | 28862 | 3 | ||
| 58770 | 25528 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2300X Market St | 3 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002714.6296 | 2106302.2301 | 37.7636580221412 | -122.433789126424 | (37.7636580221412, -122.433789126424) | 15 | 4 | 5 | 28862 | 3 | ||
| 79068 | 25540 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2200X Market St | 6 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003208.8276 | 2106774.142 | 37.7649818088085 | -122.432113553176 | (37.7649818088085, -122.432113553176) | 15 | 4 | 5 | 28862 | 3 | ||
| 110870 | 25531 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2300X Market St | 6 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002640.0878 | 2106231.2379 | 37.7634588646533 | -122.434041867896 | (37.7634588646533, -122.434041867896) | 15 | 4 | 5 | 28862 | 3 | ||
| 122735 | 25533 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2300X Market St | 8 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002574.775 | 2106170.8945 | 37.7632894694666 | -122.434263449332 | (37.7632894694666, -122.434263449332) | 15 | 4 | 5 | 28862 | 3 | ||
| 122835 | 25529 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2300X Market St | 4 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002679.8435 | 2106267.4439 | 37.7635605336875 | -122.433906953947 | (37.7635605336875, -122.433906953947) | 15 | 4 | 5 | 28862 | 3 | ||
| 168832 | 245079 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 154 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 38 | Width 0ft | 6000824.0394 | 2109520.8819 | 37.7723881764486 | -122.440558941181 | (37.7723881764486, -122.440558941181) | 15 | 5 | 11 | 29492 | 9 | |||
| 171928 | 25536 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2200X Market St | 2 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003342.0906 | 2106904.3991 | 37.7653470177984 | -122.431661930586 | (37.7653470177984, -122.431661930586) | 15 | 4 | 5 | 28862 | 3 | ||
| 179504 | 25535 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2200X Market St | 1 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003362.1302 | 2106920.4307 | 37.7653921725618 | -122.431593762963 | (37.7653921725618, -122.431593762963) | 15 | 4 | 5 | 28862 | 3 | ||
| 181062 | 25537 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2200X Market St | 3 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003301.0095 | 2106860.3121 | 37.7652236369165 | -122.431800872336 | (37.7652236369165, -122.431800872336) | 15 | 4 | 5 | 28862 | 3 | ||
| 181531 | 25530 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2300X Market St | 5 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 10 | 6002661.3855 | 2106250.4058 | 37.7635127037236 | -122.433969576289 | (37.7635127037236, -122.433969576289) | 15 | 4 | 5 | 28862 | 3 | ||
| 184625 | 25539 | DPW Maintained 1 | Phoenix canariensis :: Canary Island Date Palm 160 | 2200X Market St | 5 | Median : Cutout | Tree | DPW 1 | 04/01/1993 12:00:00 AM | 36 | 20 | 6003230.8711 | 2106796.1855 | 37.7650435846647 | -122.432038884515 | (37.7650435846647, -122.432038884515) | 15 | 4 | 5 | 28862 | 3 |
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) );