trees
23 rows where qSpecies_id = 245
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2796 | 237951 | DPW Maintained 1 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 200 Eugenia Ave | 5 | Front Yard : Yard | Tree | Private 2 | 1 | 6006574.71878 | 2098103.54318 | 37.7413645918137 | -122.419856447043 | (37.7413645918137, -122.419856447043) | 2 | 7 | 7 | 28859 | 2 | ||||
| 30768 | 196341 | DPW Maintained 1 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 602 Arthur Ave | 10 | Front Yard : Yard | Tree | Private 2 | 5 | 6015838.55119 | 2099899.27486 | 37.7468128376585 | -122.387950340845 | (37.7468128376585, -122.387950340845) | 3 | 8 | 58 | 1 | |||||
| 31784 | 83694 | DPW Maintained 1 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 2455 29th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5987336.2715 | 2098572.6525 | 37.7415500456995 | -122.486409860339 | (37.7415500456995, -122.486409860339) | 1 | 8 | 3 | 29491 | 35 | |||
| 32431 | 196337 | DPW Maintained 1 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 602 Arthur Ave | 1 | Front Yard : Yard | Tree | Private 2 | 4 | 6015979.32592 | 2099953.23926 | 37.7469688106565 | -122.387467314982 | (37.7469688106565, -122.387467314982) | 3 | 8 | 58 | 1 | |||||
| 41321 | 97014 | Property Tree 8 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
| 44692 | 97015 | Property Tree 8 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
| 48780 | 237955 | DPW Maintained 1 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 43 Harry St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6003146.63501 | 2097611.34949 | 37.7398194198374 | -122.431674423652 | (37.7398194198374, -122.431674423652) | 2 | 7 | 5 | 63 | 7 | |||
| 51829 | 237953 | DPW Maintained 1 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 5569 Diamond Heights Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6001685.30274 | 2097174.90356 | 37.7385380999471 | -122.436695853025 | (37.7385380999471, -122.436695853025) | 2 | 7 | 5 | 63 | 7 | |||
| 57875 | 196345 | DPW Maintained 1 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 602 Arthur Ave | 34 | Front Yard : Yard | Tree | Private 2 | 4 | 6015663.13173 | 2099868.27306 | 37.7467179933348 | -122.388554766215 | (37.7467179933348, -122.388554766215) | 3 | 8 | 58 | 1 | |||||
| 60960 | 196339 | DPW Maintained 1 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 602 Arthur Ave | 3 | Front Yard : Yard | Tree | Private 2 | 4 | Width 8ft | 6015967.11689 | 2099936.11218 | 37.7469211070262 | -122.387508338452 | (37.7469211070262, -122.387508338452) | 3 | 8 | 58 | 1 | ||||
| 84036 | 178858 | DPW Maintained 1 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 321 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6010771.67715 | 2090938.64111 | 37.7219268276555 | -122.404840435337 | (37.7219268276555, -122.404840435337) | 10 | 3 | 7 | 309 | 28 | |||
| 85247 | 196340 | DPW Maintained 1 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 602 Arthur Ave | 4 | Front Yard : Yard | Tree | Private 2 | 4 | Width 8ft | 6015958.58897 | 2099937.15281 | 37.7469234920398 | -122.387537900079 | (37.7469234920398, -122.387537900079) | 3 | 8 | 58 | 1 | ||||
| 92080 | 97016 | Property Tree 8 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
| 93210 | 196343 | DPW Maintained 1 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 602 Arthur Ave | 31 | Front Yard : Yard | Tree | Private 2 | 18 | 6015689.42372 | 2099879.91957 | 37.7467514292439 | -122.388464663129 | (37.7467514292439, -122.388464663129) | 3 | 8 | 58 | 1 | |||||
| 100982 | 196338 | DPW Maintained 1 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 602 Arthur Ave | 2 | Front Yard : Yard | Tree | Private 2 | 2 | 6015971.97004 | 2099951.82403 | 37.7469645173129 | -122.387492652478 | (37.7469645173129, -122.387492652478) | 3 | 8 | 58 | 1 | |||||
| 111184 | 196342 | DPW Maintained 1 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 602 Arthur Ave | 13 | Front Yard : Yard | Tree | Private 2 | 5 | 6015828.19689 | 2099862.61894 | 37.7467116144672 | -122.387983587865 | (37.7467116144672, -122.387983587865) | 3 | 8 | 58 | 1 | |||||
| 120333 | 237954 | DPW Maintained 1 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 5569 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 6001676.45332 | 2097164.39417 | 37.7385087406884 | -122.43672569793 | (37.7385087406884, -122.43672569793) | 2 | 7 | 5 | 63 | 7 | |||
| 136548 | 196336 | DPW Maintained 1 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 1750 22nd St | 6 | Side Yard : Yard | Tree | Private 2 | 9 | 6012821.16046 | 2103795.98592 | 37.757344738798 | -122.398657667323 | (37.757344738798, -122.398657667323) | 10 | 3 | 8 | 28856 | 29 | ||||
| 139939 | 114756 | Permitted Site 7 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 301X Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/04/2015 12:00:00 AM | Permit Number 777132 | 6010782.88986 | 2090965.65242 | 37.722001621884 | -122.40480357636 | (37.722001621884, -122.40480357636) | 10 | 3 | 7 | 309 | 28 | |||
| 147066 | 121377 | Significant Tree 6 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 2701 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001200 | 2116539 | 37.7916795394978 | -122.439761713662 | (37.7916795394978, -122.439761713662) | 13 | 6 | 1 | 29490 | 27 | ||||
| 154701 | 237952 | DPW Maintained 1 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 1243 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5997445.05985 | 2105447.6147 | 37.7610110346617 | -122.451953171713 | (37.7610110346617, -122.451953171713) | 15 | 5 | 11 | 29492 | 12 | |||
| 155536 | 196344 | DPW Maintained 1 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 602 Arthur Ave | 33 | Front Yard : Yard | Tree | Private 2 | 5 | 6015666.28786 | 2099877.42762 | 37.7467433047611 | -122.388544491438 | (37.7467433047611, -122.388544491438) | 3 | 8 | 58 | 1 | |||||
| 163340 | 214359 | DPW Maintained 1 | Prunus ilicifoia :: Holly-leaved Cherry 245 | 618 Detroit St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5999464.23273 | 2095044.92453 | 37.7325632057162 | -122.444222201904 | (37.7325632057162, -122.444222201904) | 9 | 7 | 4 | 63 | 40 |
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) );