trees
125 rows where Supervisor Districts = 8 and qSpecies_id = 53 sorted by PlantDate
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 154248 | 18380 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 756 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010387.2722525 | 2104782.2318449 | 37.7599168463595 | -122.407144570806 | (37.7599168463595, -122.407144570806) | 10 | 4 | 8 | 28859 | 19 | |||
| 158152 | 6829 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1450X Fairfax Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016306.5293484 | 2097712.5542014 | 37.740834465841 | -122.386179680893 | (37.740834465841, -122.386179680893) | 10 | 3 | 8 | 58 | 1 | |||
| 158929 | 101720 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
| 161591 | 21959 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2525 03RD ST | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x6 | 6015860.3 | 2103824.9 | 37.7575929852339 | -122.388149048897 | (37.7575929852339, -122.388149048897) | 10 | 3 | 8 | 28856 | 29 | |||
| 163580 | 116126 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
| 163969 | 18370 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 635 Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4x4 | 6010438.67568 | 2105328.38433 | 37.7614193346753 | -122.407005286068 | (37.7614193346753, -122.407005286068) | 10 | 4 | 8 | 28859 | 19 | |||
| 166186 | 112407 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 300x 15TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011264 | 2107649 | 37.7678373720049 | -122.404314158491 | (37.7678373720049, -122.404314158491) | 8 | 2 | 8 | 28853 | 20 | ||||
| 168880 | 112409 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 300x 15TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011264 | 2107649 | 37.7678373720049 | -122.404314158491 | (37.7678373720049, -122.404314158491) | 8 | 2 | 8 | 28853 | 20 | ||||
| 169319 | 101719 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
| 169622 | 6721 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
| 170902 | 18297 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 35X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6010274.737783 | 2108072.9305947 | 37.7689460585554 | -122.407765812226 | (37.7689460585554, -122.407765812226) | 8 | 4 | 8 | 28853 | 19 | |||
| 174144 | 116127 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2500X Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014198.52795 | 2092093.45262 | 37.7252886606488 | -122.393075349238 | (37.7252886606488, -122.393075349238) | 10 | 3 | 8 | 58 | 1 | |||||
| 176915 | 101718 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
| 178024 | 173876 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 250 Raymond Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009764 | 2087931 | 37.7136120890563 | -122.408111727364 | (37.7136120890563, -122.408111727364) | 9 | 7 | 8 | 309 | 39 | ||||
| 179093 | 21930 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2347 03rd St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x5 | 6015939.39473 | 2104425.48438 | 37.7592464441674 | -122.38791741203 | (37.7592464441674, -122.38791741203) | 10 | 3 | 8 | 28856 | 29 | |||
| 179159 | 101726 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 560 Wisconsin St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6012536 | 2104936 | 37.760459075101 | -122.399723915341 | (37.760459075101, -122.399723915341) | 10 | 3 | 8 | 28856 | 29 | |||||
| 182806 | 112161 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1324 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013680.97327942 | 2105726.70860795 | 37.7626939483281 | -122.39581935837 | (37.7626939483281, -122.39581935837) | 14 | 3 | 8 | 28856 | 29 | ||||
| 183113 | 18328 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 269 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6010332.3440196 | 2107072.4168362 | 37.7662021013824 | -122.407496007113 | (37.7662021013824, -122.407496007113) | 8 | 4 | 8 | 28853 | 19 | |||
| 188021 | 6788 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1390 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.7398763247169 | -122.384492742853 | (37.7398763247169, -122.384492742853) | 10 | 3 | 8 | 58 | 1 | |||
| 188136 | 120939 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 485 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012395 | 2105853 | 37.7629690927527 | -122.400275979648 | (37.7629690927527, -122.400275979648) | 14 | 3 | 8 | 28856 | 29 | ||||
| 188909 | 6818 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016560.8212721 | 2097522.8211505 | 37.7403275687029 | -122.385287208511 | (37.7403275687029, -122.385287208511) | 10 | 3 | 8 | 58 | 1 | |||
| 190734 | 6815 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1400X Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016560.8212721 | 2097522.8211505 | 37.7403275687029 | -122.385287208511 | (37.7403275687029, -122.385287208511) | 10 | 3 | 8 | 58 | 1 | |||
| 150567 | 25558 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 50X Industrial St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/23/2001 12:00:00 AM | 8 | 4X4 | 6012204.29417 | 2097469.52586 | 37.7399392564551 | -122.400346698766 | (37.7399392564551, -122.400346698766) | 10 | 3 | 8 | 58 | 1 | ||
| 135125 | 45390 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1501-1555 Mariposa St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2001 12:00:00 AM | Permit Number 44202 | 6012875.34483574 | 2106095.24513094 | 37.7636610173266 | -122.398631621456 | (37.7636610173266, -122.398631621456) | 14 | 3 | 8 | 28856 | 29 | |||
| 143054 | 57622 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1401 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/15/1976 12:00:00 AM | Permit Number 16516 | 6013468.70293325 | 2105662.80878203 | 37.762506682391 | -122.396549051509 | (37.762506682391, -122.396549051509) | 10 | 3 | 8 | 28856 | 29 |
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) );