trees
18 rows where qSpecies_id = 308
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7020 | 225978 | DPW Maintained 1 | Salix babylonica :: Weeping Willow 308 | 737 Sanchez St | 1 | Median : Yard | Tree | Private 2 | 22 | Width 3ft | 6003705.65415 | 2103955.34346 | 37.7572702182564 | -122.430194042444 | (37.7572702182564, -122.430194042444) | 2 | 4 | 5 | 28862 | 3 | |||
| 43399 | 117435 | Significant Tree 6 | Salix babylonica :: Weeping Willow 308 | 98X CLIPPER ST | 1 | Back Yard : Yard | Tree | Private 2 | 6004559 | 2101087 | 37.7494427139243 | -122.427038546128 | (37.7494427139243, -122.427038546128) | 2 | 4 | 5 | 28862 | 22 | |||||
| 48809 | 179420 | DPW Maintained 1 | Salix babylonica :: Weeping Willow 308 | 1665 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5998335.89123 | 2088859.42966 | 37.7155148404037 | -122.447678015949 | (37.7155148404037, -122.447678015949) | 9 | 7 | 6 | 28861 | 25 | |||
| 49740 | 107239 | DPW Maintained 1 | Salix babylonica :: Weeping Willow 308 | 300x Liberty St | 27 | Median : Cutout | Tree | DPW 1 | 27 | 6004353 | 2103966 | 37.7573361226439 | -122.42795602638 | (37.7573361226439, -122.42795602638) | 2 | 4 | 5 | 28862 | 3 | ||||
| 52867 | 240950 | DPW Maintained 1 | Salix babylonica :: Weeping Willow 308 | 4806 25th St | 1 | Side Yard : Yard | Tree | Private 2 | 14 | 6000018.52876 | 2101091.51792 | 37.7491973234931 | -122.442739892534 | (37.7491973234931, -122.442739892534) | 2 | 4 | 5 | 28862 | 22 | ||||
| 89812 | 107834 | Significant Tree 6 | Salix babylonica :: Weeping Willow 308 | 100X SUSSEX ST | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 6002188 | 2096682 | 37.7372132564844 | -122.434922529204 | (37.7372132564844, -122.434922529204) | 2 | 7 | 5 | 63 | 7 | ||||
| 93927 | 214147 | DPW Maintained 1 | Salix babylonica :: Weeping Willow 308 | 824 Faxon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 5994913.19129 | 2093521.68504 | 37.7281200673663 | -122.459845842331 | (37.7281200673663, -122.459845842331) | 9 | 7 | 4 | 28861 | 40 | |||
| 94821 | 20980 | DPW Maintained 1 | Salix babylonica :: Weeping Willow 308 | 2002X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | 5984887.6165706 | 2101567.3225095 | 37.7496295616808 | -122.495097123245 | (37.7496295616808, -122.495097123245) | 1 | 8 | 3 | 29491 | 35 | |||
| 97576 | 139617 | DPW Maintained 1 | Salix babylonica :: Weeping Willow 308 | 1835 EDDY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001670.9088 | 2112514.652 | 37.780656503893 | -122.437844009531 | (37.780656503893, -122.437844009531) | 15 | 5 | 11 | 29490 | 41 | |||
| 103329 | 197458 | DPW Maintained 1 | Salix babylonica :: Weeping Willow 308 | 1301 Minnesota St | 9 | Front Yard : Yard | Tree | Private 2 | 18 | 6015384.23968 | 2102278.60238 | 37.7533207924202 | -122.389687474898 | (37.7533207924202, -122.389687474898) | 10 | 3 | 8 | 28856 | 29 | ||||
| 123975 | 20981 | DPW Maintained 1 | Salix babylonica :: Weeping Willow 308 | 2002X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | 5984887.6165706 | 2101567.3225095 | 37.7496295616808 | -122.495097123245 | (37.7496295616808, -122.495097123245) | 1 | 8 | 3 | 29491 | 35 | |||
| 134585 | 24480 | Significant Tree 6 | Salix babylonica :: Weeping Willow 308 | 108X Sussex St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780363 | 6002195.08262 | 2096706.93645 | 37.737282128351 | -122.434899824187 | (37.737282128351, -122.434899824187) | 2 | 7 | 5 | 63 | 7 | |
| 136570 | 114882 | DPW Maintained 1 | Salix babylonica :: Weeping Willow 308 | 801x Alemany Blvd | 1 | Side Yard : Yard | Tree | DPW 1 | 6004188.83398 | 2094500.26728 | 37.7313361115063 | -122.427849316435 | (37.7313361115063, -122.427849316435) | 9 | 7 | 6 | 28861 | 5 | |||||
| 142562 | 20979 | DPW Maintained 1 | Salix babylonica :: Weeping Willow 308 | 2002X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40 | 5984887.6165706 | 2101567.3225095 | 37.7496295616808 | -122.495097123245 | (37.7496295616808, -122.495097123245) | 1 | 8 | 3 | 29491 | 35 | |||
| 158569 | 139607 | DPW Maintained 1 | Salix babylonica :: Weeping Willow 308 | 1111 SCOTT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6001857.8665 | 2112279.1586 | 37.7800205278904 | -122.437180368262 | (37.7800205278904, -122.437180368262) | 15 | 5 | 11 | 29490 | 41 | |||
| 170160 | 107835 | Significant Tree 6 | Salix babylonica :: Weeping Willow 308 | 100X SUSSEX ST | 1 | Front Yard : Yard | Tree | Private 2 | 13 | 6002188 | 2096682 | 37.7372132564844 | -122.434922529204 | (37.7372132564844, -122.434922529204) | 2 | 7 | 5 | 63 | 7 | ||||
| 180436 | 240949 | DPW Maintained 1 | Salix babylonica :: Weeping Willow 308 | 332 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003757.14491 | 2098676.58582 | 37.7427789007401 | -122.429639491667 | (37.7427789007401, -122.429639491667) | 2 | 7 | 5 | 63 | 22 | |||
| 183463 | 122730 | DPW Maintained 1 | Salix babylonica :: Weeping Willow 308 | 700X Sanchez St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6003672 | 2104202 | 37.757945572264 | -122.430328029181 | (37.757945572264, -122.430328029181) | 2 | 4 | 5 | 28862 | 3 |
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) );