trees
14 rows where SiteOrder = 7 and qSpecies_id = 116
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3329 | 260429 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 580 Capp St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 778605 | 6007240 | 2103949 | 37.7574523501876 | -122.417970414127 | (37.7574523501876, -122.417970414127) | 2 | 4 | 7 | 28859 | 19 | |||
| 10106 | 49071 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1970 Ocean Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/07/2003 12:00:00 AM | Permit Number 46231 | 5993706.31601319 | 2092791.54243423 | 37.7260457932168 | -122.46396504093 | (37.7260457932168, -122.46396504093) | 9 | 8 | 4 | 59 | 40 | ||
| 34216 | 34084 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 240 Shotwell St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | 6 | 3x3 | Permit Number 37968 | 6007780.97837226 | 2105869.55428135 | 37.7627561815899 | -122.41623551069 | (37.7627561815899, -122.41623551069) | 8 | 4 | 7 | 28859 | 19 |
| 35262 | 253489 | Planning Code 138.1 required 2 | Trachycarpus fortunei :: Windmill Palm 116 | 1x Gordon St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 772214 | 6009763 | 2109812 | 37.7736924789578 | -122.409658650953 | (37.7736924789578, -122.409658650953) | 8 | 2 | 9 | 28853 | 34 | |
| 37911 | 117703 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 4001 Clement St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 7ft | 5983084.79003 | 2113081.26685 | 37.7811378565893 | -122.502183200126 | (37.7811378565893, -122.502183200126) | 11 | 6 | 2 | 55 | 26 | |||
| 40469 | 198000 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 828x Jamestown Ave | 7 | Median : Cutout | Tree | DPW 1 | 8 | Width 5ft | 6014844.30096 | 2089001.46751 | 37.7168345316683 | -122.390626989449 | (37.7168345316683, -122.390626989449) | 10 | 3 | 8 | 58 | 1 | |||
| 85554 | 215428 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 20 Lakewood Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993651.19736 | 2093024.90181 | 37.7266833644367 | -122.464172514845 | (37.7266833644367, -122.464172514845) | 9 | 8 | 4 | 59 | 40 | |||
| 104413 | 241223 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2800 17th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009004.56515 | 2106399.07167 | 37.7642788409211 | -122.412040964327 | (37.7642788409211, -122.412040964327) | 8 | 4 | 7 | 28859 | 19 | |||
| 104558 | 181643 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2520 Irving St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5987777.5915 | 2106472.9578 | 37.7632678730962 | -122.485463562399 | (37.7632678730962, -122.485463562399) | 1 | 8 | 3 | 56 | 35 | |||
| 127178 | 115617 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1400 16th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6012270.55026102 | 2107054.03832976 | 37.7662599354936 | -122.400790794031 | (37.7662599354936, -122.400790794031) | 14 | 3 | 8 | 28856 | 20 | ||||
| 129119 | 108282 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 1 HENRY ADAMS ST | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 10 | 3x3 | 6011517.4 | 2108140.5 | 37.7692010762684 | -122.403472255644 | (37.7692010762684, -122.403472255644) | 8 | 2 | 8 | 28853 | 20 | |||
| 135898 | 34049 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 375 Alabama St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37958 | 6008950.19472335 | 2106493.86234805 | 37.7645360636147 | -122.41223571698 | (37.7645360636147, -122.41223571698) | 8 | 4 | 7 | 28859 | 19 | ||
| 159508 | 42739 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 2155 Bay Shore Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | Permit Number 42735 | 6011836.19977805 | 2087516.89388515 | 37.7125908452343 | -122.400920338197 | (37.7125908452343, -122.400920338197) | 10 | 3 | 8 | 309 | 1 | ||
| 163922 | 241209 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2801 17th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6009128.3617 | 2106356.68814 | 37.7641694105262 | -122.411609790669 | (37.7641694105262, -122.411609790669) | 8 | 4 | 7 | 28859 | 19 |
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) );