trees
22 rows where Supervisor Districts = 6 and qSpecies_id = 181
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1338 | 261130 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 198 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003761.7429 | 2092753.33549 | 37.7265152577639 | -122.429201331188 | (37.7265152577639, -122.429201331188) | 9 | 7 | 6 | 28861 | 5 | ||
| 5069 | 161446 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 330 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6002674.4423 | 2091528.28518 | 37.7230899316367 | -122.432872602985 | (37.7230899316367, -122.432872602985) | 9 | 7 | 6 | 28861 | 5 | |||
| 7249 | 160605 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 753 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 01:48:00 PM | 3 | Width 0ft | 6002503.48745 | 2089141.95917 | 37.7165279132188 | -122.433293125102 | (37.7165279132188, -122.433293125102) | 9 | 7 | 6 | 28861 | 5 | |
| 13304 | 171228 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 131 Peru Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 2ft | 6004022.36469 | 2093295.14469 | 37.7280176957394 | -122.428338971261 | (37.7280176957394, -122.428338971261) | 9 | 7 | 6 | 28861 | 5 | ||
| 13387 | 171252 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 198 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 3ft | 6003761.7429 | 2092753.33549 | 37.7265152577639 | -122.429201331188 | (37.7265152577639, -122.429201331188) | 9 | 7 | 6 | 28861 | 5 | ||
| 17122 | 171142 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 23 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/27/2019 12:00:00 AM | 3 | Width 4ft | 6004222.5848 | 2093413.47095 | 37.7283539207904 | -122.427655231101 | (37.7283539207904, -122.427655231101) | 9 | 7 | 6 | 28861 | 5 | ||
| 17692 | 161115 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 580 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/25/2017 03:13:00 PM | 3 | Width 0ft | 6003070.44185 | 2090129.12968 | 37.7192706134287 | -122.431403880597 | (37.7192706134287, -122.431403880597) | 9 | 7 | 6 | 28861 | 5 | |
| 19514 | 171471 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 225 Congdon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x5 | 6004711.85389 | 2093923.42078 | 37.7297817932982 | -122.426000090949 | (37.7297817932982, -122.426000090949) | 9 | 7 | 6 | 28861 | 5 | |||
| 25276 | 83901 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 30 Paulding St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50520 | 6000137.45040152 | 2093299.82569478 | 37.727809954285 | -122.441769533345 | (37.727809954285, -122.441769533345) | 9 | 7 | 6 | 28861 | 25 | ||
| 27138 | 160521 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 786 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 11:59:00 AM | 3 | Width 0ft | 6001662.29271 | 2089410.30964 | 37.7172169863455 | -122.436219899452 | (37.7172169863455, -122.436219899452) | 9 | 7 | 6 | 28861 | 5 | |
| 28459 | 88318 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 607 France Ave | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51309 | 6002519.4 | 2089575.2 | 37.7177183994753 | -122.433269062939 | (37.7177183994753, -122.433269062939) | 9 | 7 | 6 | 28861 | 5 | |||
| 71930 | 160603 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 771 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 12:20:00 PM | 3 | Width 0ft | 6002439.45935 | 2089043.61541 | 37.7162542504093 | -122.433507413734 | (37.7162542504093, -122.433507413734) | 9 | 7 | 6 | 28861 | 5 | |
| 89626 | 88352 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 700 VIENNA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51333 | 6002601.8 | 2089436.1 | 37.7173411358396 | -122.432974311079 | (37.7173411358396, -122.432974311079) | 9 | 7 | 6 | 28861 | 5 | ||
| 121189 | 88324 | Permitted Site 7 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 182 Lisbon St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51313 | 6003195 | 2092351 | 37.7253784345628 | -122.431131833246 | (37.7253784345628, -122.431131833246) | 9 | 7 | 6 | 28861 | 5 | |||
| 183982 | 180958 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 778 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 12:11:00 PM | 3 | Width 2ft | 6001688.47401 | 2089452.0208 | 37.7173330033918 | -122.43613238641 | (37.7173330033918, -122.43613238641) | 9 | 7 | 6 | 28861 | 5 | |
| 186878 | 160606 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 745 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 0 | Width 0ft | 6002538.27018 | 2089198.00588 | 37.716683778298 | -122.433176901193 | (37.716683778298, -122.433176901193) | 9 | 7 | 6 | 28861 | 5 | ||
| 193740 | 160520 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 782 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/18/2017 12:02:00 PM | 3 | Width 0ft | 6001673.45326 | 2089428.52056 | 37.7172676235708 | -122.436182625252 | (37.7172676235708, -122.436182625252) | 9 | 7 | 6 | 28861 | 5 | |
| 194428 | 253435 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 793 Vienna St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/18/2017 11:49:00 AM | 3 | 6002373 | 2088903 | 37.7158643806251 | -122.433727084844 | (37.7158643806251, -122.433727084844) | 9 | 7 | 6 | 28861 | 5 | |||
| 194471 | 179002 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 500 Paris St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | Permit Number 778923 | 6001822.18343 | 2090679.74768 | 37.7207116627863 | -122.43575800674 | (37.7207116627863, -122.43575800674) | 9 | 7 | 6 | 28861 | 5 | ||
| 194476 | 179001 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 500 Paris St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | Permit Number 778923 | 6001827.05422 | 2090687.03762 | 37.7207319560017 | -122.435741691253 | (37.7207319560017, -122.435741691253) | 9 | 7 | 6 | 28861 | 5 | ||
| 194478 | 35851 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 500 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778923 | 6001833.39372 | 2090697.41132 | 37.7207607999542 | -122.435720519401 | (37.7207607999542, -122.435720519401) | 9 | 7 | 6 | 28861 | 5 | |
| 194490 | 171446 | DPW Maintained 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 181 | 130 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/2017 12:00:00 AM | 3 | Width 2ft | 6004630.97691 | 2092622.98585 | 37.7262065159928 | -122.426187146329 | (37.7262065159928, -122.426187146329) | 9 | 7 | 6 | 28861 | 5 |
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) );