trees
22 rows where DBH = 3 and qSpecies_id = 79
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13574 | 222784 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 28 | Median : Cutout | Tree | DPW 1 | 3 | Width 6ft | 6010005.90686 | 2100575.10884 | 37.7483436744252 | -122.408166814455 | (37.7483436744252, -122.408166814455) | 2 | 4 | 7 | 28859 | 2 | |||
| 18608 | 222775 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2950x Cesar Chavez St | 9 | Median : Yard | Tree | DPW 1 | 3 | 6009484.12274 | 2100580.43593 | 37.7483290712363 | -122.40997151459 | (37.7483290712363, -122.40997151459) | 2 | 4 | 7 | 28859 | 2 | ||||
| 25647 | 222842 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3100x Cesar Chavez St | 9 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6008782.20284 | 2100575.62151 | 37.748276486974 | -122.412398404384 | (37.748276486974, -122.412398404384) | 2 | 4 | 7 | 28859 | 2 | |||
| 40844 | 188439 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 900 Marin St | 2 | : | Tree | Private 2 | 3 | Width 4ft | 6016416.33259 | 2100747.09096 | 37.7491727576269 | -122.386011499647 | (37.7491727576269, -122.386011499647) | 10 | 3 | 8 | 58 | 1 | |||
| 42136 | 222807 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3400x Cesar Chavez St | 6 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6006935.06482 | 2100562.99304 | 37.7481379823795 | -122.418784875139 | (37.7481379823795, -122.418784875139) | 2 | 4 | 7 | 28859 | 2 | |||
| 53546 | 222786 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 26 | Median : Cutout | Tree | DPW 1 | 3 | Width 6ft | 6010045.33048 | 2100578.24772 | 37.7483545004769 | -122.408030709253 | (37.7483545004769, -122.408030709253) | 2 | 4 | 7 | 28859 | 2 | |||
| 58636 | 222781 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2950x Cesar Chavez St | 1 | Median : Cutout | Tree | DPW 1 | 3 | Width 5ft | 6009693.66446 | 2100583.02791 | 37.748347930031 | -122.409247104384 | (37.748347930031, -122.409247104384) | 2 | 4 | 7 | 28859 | 2 | |||
| 76360 | 222843 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3100x Cesar Chavez St | 13 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6008698.15924 | 2100574.66503 | 37.7482691440259 | -122.412688958247 | (37.7482691440259, -122.412688958247) | 2 | 4 | 7 | 28859 | 2 | |||
| 76509 | 222802 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 6 | Median : Cutout | Tree | DPW 1 | 3 | Width 6ft | 6010429.09117 | 2100727.82073 | 37.7487866741639 | -122.406714207005 | (37.7487866741639, -122.406714207005) | 2 | 4 | 7 | 28859 | 2 | |||
| 89381 | 188436 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 1310 Indiana St | 3 | : Yard | Tree | Private 2 | 3 | 6014947.70455 | 2102543.51938 | 37.7540239822338 | -122.391215632613 | (37.7540239822338, -122.391215632613) | 10 | 3 | 8 | 28856 | 29 | ||||
| 100204 | 222805 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3400x Cesar Chavez St | 4 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6006981.21986 | 2100563.90929 | 37.7481430968362 | -122.418625337193 | (37.7481430968362, -122.418625337193) | 2 | 4 | 7 | 28859 | 2 | |||
| 103143 | 222806 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3400x Cesar Chavez St | 5 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6006951.5861 | 2100562.96476 | 37.7481388349423 | -122.418727742984 | (37.7481388349423, -122.418727742984) | 2 | 4 | 7 | 28859 | 2 | |||
| 111695 | 222808 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3400x Cesar Chavez St | 7 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6006921.03633 | 2100562.97022 | 37.7481371298399 | -122.418833383667 | (37.7481371298399, -122.418833383667) | 2 | 4 | 7 | 28859 | 2 | |||
| 130436 | 222844 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3100x Cesar Chavez St | 14 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6008676.6905 | 2100575.48577 | 37.7482701926188 | -122.412763254825 | (37.7482701926188, -122.412763254825) | 2 | 4 | 7 | 28859 | 2 | |||
| 133209 | 222825 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3200x Cesar Chavez St | 5 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6008183.00365 | 2100572.10257 | 37.7482331810351 | -122.414470176157 | (37.7482331810351, -122.414470176157) | 2 | 4 | 7 | 28859 | 2 | |||
| 140727 | 222787 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2800x Cesar Chavez St | 24 | Median : Cutout | Tree | DPW 1 | 3 | Width 6ft | 6010096.17882 | 2100593.44521 | 37.748399076272 | -122.407855947615 | (37.748399076272, -122.407855947615) | 2 | 4 | 7 | 28859 | 2 | |||
| 143571 | 222780 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 2950x Cesar Chavez St | 2 | Median : Yard | Tree | DPW 1 | 3 | 6009674.91221 | 2100582.21964 | 37.7483446600884 | -122.409311892454 | (37.7483446600884, -122.409311892454) | 2 | 4 | 7 | 28859 | 2 | ||||
| 154971 | 222820 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3500x Cesar Chavez St | 13 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6006079.97911 | 2100547.63598 | 37.7480476328877 | -122.421740646313 | (37.7480476328877, -122.421740646313) | 2 | 4 | 7 | 28859 | 22 | |||
| 157904 | 35884 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 65 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/24/1998 12:00:00 AM | 3 | Permit Number 39085 | 6011192.13952 | 2096439.01345 | 37.737053195154 | -122.403773834904 | (37.737053195154, -122.403773834904) | 10 | 3 | 8 | 58 | 1 | |
| 160080 | 222829 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3300x Cesar Chavez St | 6 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6007416.24383 | 2100569.30041 | 37.7481823819313 | -122.417121417131 | (37.7481823819313, -122.417121417131) | 2 | 4 | 7 | 28859 | 2 | |||
| 168469 | 222826 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3200x Cesar Chavez St | 6 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6008154.70095 | 2100571.67515 | 37.7482304174003 | -122.414568016118 | (37.7482304174003, -122.414568016118) | 2 | 4 | 7 | 28859 | 2 | |||
| 188294 | 222809 | DPW Maintained 1 | Ceiba speciosa :: Silk floss 79 | 3400x Cesar Chavez St | 8 | Median : Yard | Tree | DPW 1 | 3 | Width 10ft | 6006905.75522 | 2100562.66292 | 37.7481354256304 | -122.418886203547 | (37.7481354256304, -122.418886203547) | 2 | 4 | 7 | 28859 | 2 |
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) );