trees
15 rows where qLegalStatus_id = 7 and qSpecies_id = 202
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1907 | 36575 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2959 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2015 12:00:00 AM | 3 | Permit Number 773747 | 6009743.48880831 | 2101591.28473575 | 37.7511191714417 | -122.409145947985 | (37.7511191714417, -122.409145947985) | 2 | 4 | 7 | 28859 | 19 | |
| 7590 | 109072 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1570 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769406 | 5992498.7 | 2104770.7 | 37.7588678465638 | -122.469011061686 | (37.7588678465638, -122.469011061686) | 1 | 8 | 4 | 56 | 12 |
| 34074 | 36574 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2959 25th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/2015 12:00:00 AM | 3 | Permit Number 773747 | 6009743.48880831 | 2101591.28473575 | 37.7511191714417 | -122.409145947985 | (37.7511191714417, -122.409145947985) | 2 | 4 | 7 | 28859 | 19 | |
| 42639 | 255491 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 139 Melrose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/31/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781962 | 5999277.13576 | 2095481.56921 | 37.7337514533765 | -122.444900415841 | (37.7337514533765, -122.444900415841) | 9 | 7 | 4 | 59 | 40 |
| 53421 | 115385 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 375 Park St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2016 12:00:00 AM | 3 | Permit Number 776680 | 6007256.8 | 2096298.8 | 37.7364475687434 | -122.417370175703 | (37.7364475687434, -122.417370175703) | 2 | 7 | 7 | 28859 | 2 | ||
| 53602 | 117377 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 3783 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/08/2016 12:00:00 AM | 3 | Permit Number 775394 | 6003225.8 | 2102971.4 | 37.7545413531892 | -122.43178331278 | (37.7545413531892, -122.43178331278) | 2 | 4 | 5 | 28862 | 22 | ||
| 89333 | 101004 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2801X Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2012 12:00:00 AM | 3x3 | Permit Number 769246 | 6003500.6 | 2117942.3 | 37.7956633226967 | -122.431901904302 | (37.7956633226967, -122.431901904302) | 13 | 9 | 1 | 57 | 17 | ||
| 120297 | 36540 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 3780 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/18/1998 12:00:00 AM | Permit Number 768357 | 6008402.05844785 | 2097287.64414787 | 37.7392270883895 | -122.413480433949 | (37.7392270883895, -122.413480433949) | 2 | 7 | 7 | 28859 | 2 | ||
| 148068 | 115208 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1014 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 774282 | 6001957.4 | 2112096.8 | 37.7795254745958 | -122.436822979652 | (37.7795254745958, -122.436822979652) | 15 | 5 | 11 | 29490 | 41 | |||
| 156394 | 115207 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1014 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 774282 | 6001957.4 | 2112096.8 | 37.7795254745958 | -122.436822979652 | (37.7795254745958, -122.436822979652) | 15 | 5 | 11 | 29490 | 41 | |||
| 168365 | 114971 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 431 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/28/2015 12:00:00 AM | Permit Number 771835 | 5997422.4 | 2094904.1 | 37.7320598346121 | -122.45127112252 | (37.7320598346121, -122.45127112252) | 9 | 7 | 4 | 59 | 40 | |||
| 173627 | 101003 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2801X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/10/2012 12:00:00 AM | 3x3 | Permit Number 769246 | 6003500.6 | 2117942.3 | 37.7956633226967 | -122.431901904302 | (37.7956633226967, -122.431901904302) | 13 | 9 | 1 | 57 | 17 | ||
| 173788 | 69064 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1359 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | Permit Number 773642 | 5992377.26935607 | 2106205.46978928 | 37.7628003299421 | -122.469535465436 | (37.7628003299421, -122.469535465436) | 1 | 8 | 11 | 56 | 12 | |
| 173878 | 108526 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 1677 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773677 | 5990566.26137 | 2103985.48594 | 37.7566000147891 | -122.475636927177 | (37.7566000147891, -122.475636927177) | 1 | 8 | 4 | 56 | 12 |
| 186577 | 109033 | Permitted Site 7 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 202 | 2120 Moraga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772816 | 5987671.1 | 2103767.6 | 37.7558334934217 | -122.48563331933 | (37.7558334934217, -122.48563331933) | 1 | 8 | 3 | 56 | 35 |
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) );