trees
25 rows where qSiteInfo = ":" and qSpecies_id = 50 sorted by qAddress
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 55010 | 247662 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 108 Divisadero St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6001959.68947 | 2108344.83823 | 37.7692236543626 | -122.436546435187 | (37.7692236543626, -122.436546435187) | 15 | 5 | 5 | 29492 | 9 | |||
| 134330 | 190745 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1617 Kirkwood Ave | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6015075.48119 | 2096817.46152 | 37.7383085120296 | -122.390373696315 | (37.7383085120296, -122.390373696315) | 10 | 3 | 8 | 58 | 1 | |||
| 176891 | 190742 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1617 Kirkwood Ave | 1 | : | Tree | Private 2 | 4 | Width 4ft | 6015073.9615 | 2096817.26033 | 37.7383078753038 | -122.390378936647 | (37.7383078753038, -122.390378936647) | 10 | 3 | 8 | 58 | 1 | |||
| 84269 | 228528 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1718 Bryant St | 1 | : | Tree | Private 2 | 8 | Width 4ft | 6009443.5955 | 2106700.35684 | 37.7651307237316 | -122.410543753197 | (37.7651307237316, -122.410543753197) | 8 | 4 | 7 | 28859 | 19 | |||
| 106771 | 228529 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1718 Bryant St | 2 | : | Tree | Private 2 | 10 | Width 4ft | 6009444.29412 | 2106686.02886 | 37.7650914215521 | -122.41054032498 | (37.7650914215521, -122.41054032498) | 8 | 4 | 7 | 28859 | 19 | |||
| 5058 | 228531 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1744 Bryant St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6009451.25319 | 2106552.40785 | 37.7647249190387 | -122.410506818932 | (37.7647249190387, -122.410506818932) | 8 | 4 | 7 | 28859 | 19 | |||
| 169649 | 190741 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1786 Quesada Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6014282.60323 | 2095390.34812 | 37.7343459381091 | -122.393015276746 | (37.7343459381091, -122.393015276746) | 10 | 3 | 8 | 58 | 1 | |||
| 29512 | 190708 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2033 22nd St | 4 | : | Tree | Private 2 | 5 | Width 3ft | 6011986.6004 | 2103715.0173 | 37.7570758846471 | -122.401538231824 | (37.7570758846471, -122.401538231824) | 10 | 3 | 8 | 28856 | 29 | |||
| 187304 | 228524 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 29 Pearl St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6005636.60822 | 2108865.67188 | 37.7708619961085 | -122.42386519304 | (37.7708619961085, -122.42386519304) | 8 | 2 | 5 | 28853 | 19 | |||
| 89588 | 190720 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 315 Mississippi St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6014070.97859 | 2105596.22306 | 37.7623573521408 | -122.394461321843 | (37.7623573521408, -122.394461321843) | 10 | 3 | 8 | 28856 | 29 | |||
| 108357 | 190715 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 350 Texas St | 1 | : | Tree | Private 2 | 12 | Width 4ft | 6013737.51284 | 2105460.97147 | 37.7619674375704 | -122.395605187539 | (37.7619674375704, -122.395605187539) | 10 | 3 | 8 | 28856 | 29 | |||
| 159008 | 190714 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 375 Texas St | 2 | : | Tree | Private 2 | 4 | Width 5ft | 6013800.48111 | 2105372.99908 | 37.7617293870175 | -122.395381240171 | (37.7617293870175, -122.395381240171) | 10 | 3 | 8 | 28856 | 29 | |||
| 12291 | 190743 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 39 Latona St | 1 | : | Tree | Private 2 | 2 | Width 6ft | 6014419.07803 | 2094437.81167 | 37.7317380471513 | -122.392476830144 | (37.7317380471513, -122.392476830144) | 10 | 3 | 8 | 58 | 1 | |||
| 27550 | 228526 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 405 Florida St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6009242.70378 | 2106296.28434 | 37.7640099687976 | -122.411210045617 | (37.7640099687976, -122.411210045617) | 8 | 4 | 7 | 28859 | 19 | |||
| 64720 | 228525 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 405 Florida St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6009242.66431 | 2106282.23281 | 37.7639713843042 | -122.411209189472 | (37.7639713843042, -122.411209189472) | 8 | 4 | 7 | 28859 | 19 | |||
| 119587 | 228527 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 405 Florida St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6009241.97976 | 2106321.44557 | 37.7640790151609 | -122.4112143273 | (37.7640790151609, -122.4112143273) | 8 | 4 | 7 | 28859 | 19 | |||
| 74250 | 190718 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 446 Missouri St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6013483.0407 | 2105010.44498 | 37.7607162323997 | -122.396453732953 | (37.7607162323997, -122.396453732953) | 10 | 3 | 8 | 28856 | 29 | |||
| 179328 | 190713 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 529 Texas St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6013844.95879 | 2104593.96331 | 37.7595927983841 | -122.395172837551 | (37.7595927983841, -122.395172837551) | 10 | 3 | 8 | 28856 | 29 | |||
| 45918 | 190719 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 642 Mississippi St | 1 | : | Tree | Private 2 | 13 | Width 4ft | 6014091.45327 | 2104130.33792 | 37.7583334885189 | -122.39428786959 | (37.7583334885189, -122.39428786959) | 10 | 3 | 8 | 28856 | 29 | |||
| 50870 | 129100 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 701 Buchanan St | 3 | : | Tree | Private 2 | 8 | Width 6ft | 6004473.20652 | 2110925.86056 | 37.7764530246232 | -122.428036263087 | (37.7764530246232, -122.428036263087) | 7 | 9 | 11 | 28852 | 10 | |||
| 74222 | 129101 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 701 Buchanan St | 4 | : | Tree | Private 2 | 6 | Width 6ft | 6004471.22614 | 2110943.39026 | 37.7765010448349 | -122.428044363274 | (37.7765010448349, -122.428044363274) | 7 | 9 | 11 | 28852 | 10 | |||
| 158091 | 129102 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 701 Buchanan St | 5 | : | Tree | Private 2 | 5 | Width 6ft | 6004465.70248 | 2110959.4385 | 37.7765447968535 | -122.428064615105 | (37.7765447968535, -122.428064615105) | 7 | 9 | 11 | 28852 | 10 | |||
| 4292 | 190709 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 715 Wisconsin St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6012742.49696 | 2104176.10053 | 37.7583840672751 | -122.398956396912 | (37.7583840672751, -122.398956396912) | 10 | 3 | 8 | 28856 | 29 | |||
| 168986 | 190710 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 715 Wisconsin St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6012743.45877 | 2104190.05175 | 37.7584224278606 | -122.398954049707 | (37.7584224278606, -122.398954049707) | 10 | 3 | 8 | 28856 | 29 | |||
| 146004 | 201527 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 740 Earl St | 4 | : | Tree | Private 2 | 6 | Width 5ft | 6020341.20189 | 2093704.82943 | 37.7300525126033 | -122.371951898056 | (37.7300525126033, -122.371951898056) | 10 | 3 | 8 | 58 | 1 |
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) );