trees
13 rows where Supervisor Districts = 11 and qSpecies_id = 116 sorted by PermitNotes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14508 | 246217 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 725 Buena Vista Ave West | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999828.0384 | 2107849.3991 | 37.7677419398126 | -122.443884078726 | (37.7677419398126, -122.443884078726) | 15 | 5 | 11 | 29492 | 9 | |||
| 20297 | 246216 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 725 Buena Vista Ave West | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5999835.3063 | 2107870.2944 | 37.7677997276311 | -122.443860441452 | (37.7677997276311, -122.443860441452) | 15 | 5 | 11 | 29492 | 9 | |||
| 40644 | 247521 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1101 Waller St | 2 | Side Yard : Yard | Tree | Private 2 | 5 | 6000007.86979 | 2108477.01107 | 37.7694754609529 | -122.443307149811 | (37.7694754609529, -122.443307149811) | 15 | 5 | 11 | 29492 | 9 | ||||
| 60671 | 103568 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 223 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5997125.5 | 2106655.6 | 37.7643095465843 | -122.453145590268 | (37.7643095465843, -122.453145590268) | 15 | 5 | 11 | 29492 | 12 | |||
| 75935 | 241200 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 26 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5998502.5017 | 2107263.12139 | 37.7660564705643 | -122.448426703328 | (37.7660564705643, -122.448426703328) | 15 | 5 | 11 | 29492 | 9 | |||
| 99590 | 241201 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 26 Carl St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998490.81522 | 2107264.49374 | 37.7660595705173 | -122.448467223189 | (37.7660595705173, -122.448467223189) | 15 | 5 | 11 | 29492 | 9 | |||
| 103122 | 241199 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 24 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998508.2304 | 2107266.01278 | 37.7660647371231 | -122.448407097228 | (37.7660647371231, -122.448407097228) | 15 | 5 | 11 | 29492 | 9 | |||
| 123985 | 141332 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1324 HAYES ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 0ft | 6001489.2623 | 2110460.5875 | 37.7750062304087 | -122.438325211171 | (37.7750062304087, -122.438325211171) | 15 | 5 | 11 | 29492 | 10 | |||
| 111572 | 57900 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1324 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/1977 12:00:00 AM | 5 | Permit Number 16856 | 6001502.5818 | 2110462.7186 | 37.7750128394498 | -122.438279288937 | (37.7750128394498, -122.438279288937) | 15 | 5 | 11 | 29492 | 10 | ||
| 28105 | 63543 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 1715 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1994 12:00:00 AM | Permit Number 33376 | 6001376.18344652 | 2111778.57795299 | 37.7786186676026 | -122.438810841545 | (37.7786186676026, -122.438810841545) | 15 | 5 | 11 | 29490 | 41 | ||
| 189828 | 38219 | Permitted Site 7 | Trachycarpus fortunei :: Windmill Palm 116 | 118 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/2000 12:00:00 AM | Permit Number 40340 | 6000363.19569215 | 2109305.86913973 | 37.7717715527779 | -122.44213760158 | (37.7717715527779, -122.44213760158) | 15 | 5 | 11 | 29492 | 9 | ||
| 193666 | 50830 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 621 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/19/2004 12:00:00 AM | 9 | Permit Number 47349 | 6000535.8217 | 2111139.1847 | 37.7768152106013 | -122.441672069607 | (37.7768152106013, -122.441672069607) | 15 | 5 | 11 | 29492 | 16 | ||
| 111371 | 255520 | Undocumented 4 | Trachycarpus fortunei :: Windmill Palm 116 | 77 Belgrave Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 10x10 | Permit Number 781419 | 5998149.61527 | 2104897.27011 | 37.7595402565853 | -122.449476776674 | (37.7595402565853, -122.449476776674) | 15 | 5 | 11 | 28862 | 12 |
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) );