trees
12 rows where Fire Prevention Districts = 13 and qSpecies_id = 43 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
161625 | 126462 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1990 Beach St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000762.32542 | 2120990.48851 | 37.8038772290062 | -122.441595650935 | (37.8038772290062, -122.441595650935) | 13 | 9 | 1 | 57 | 17 | |||
172638 | 126461 | DPW Maintained 1 | Dodonaea viscosa :: Hop Bush 43 | 1990 Beach St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 6000743.63592 | 2120987.57838 | 37.8038681737437 | -122.441660117946 | (37.8038681737437, -122.441660117946) | 13 | 9 | 1 | 57 | 17 | |||
32857 | 47691 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2858 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/22/2002 12:00:00 AM | Permit Number 45490 | 6001036.99468682 | 2116264.16139907 | 37.7909156246348 | -122.440305990836 | (37.7909156246348, -122.440305990836) | 13 | 6 | 1 | 29490 | 27 | ||
39342 | 37525 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1150 Larkin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/22/1998 12:00:00 AM | 3x3 | Permit Number 52992 | 6007323.5106073 | 2115257.61387493 | 37.7885078148262 | -122.418483459105 | (37.7885078148262, -122.418483459105) | 13 | 9 | 10 | 28858 | 21 | ||
59370 | 68249 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 3531 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | Permit Number 32050 | 6001184.87724579 | 2120700.92595518 | 37.8031062325164 | -122.440112611548 | (37.8031062325164, -122.440112611548) | 13 | 9 | 1 | 57 | 17 | ||
98159 | 34672 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 3112 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/01/2005 12:00:00 AM | Permit Number 38340 | 6003381.0349361 | 2119134.6254032 | 37.7989303613953 | -122.432400821612 | (37.7989303613953, -122.432400821612) | 13 | 9 | 1 | 57 | 17 | ||
108248 | 96988 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2201 North Point St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.443579300178 | (37.8026268776405, -122.443579300178) | 13 | 9 | 1 | 57 | 17 | ||||
122439 | 96990 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2201 North Point St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.443579300178 | (37.8026268776405, -122.443579300178) | 13 | 9 | 1 | 57 | 17 | ||||
135345 | 96989 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2201 North Point St | Sidewalk: Property side : Yard | Tree | Private 2 | 08/16/2011 12:00:00 AM | Permit Number 768194 | 6000179.9 | 2120547.2 | 37.8026268776405 | -122.443579300178 | (37.8026268776405, -122.443579300178) | 13 | 9 | 1 | 57 | 17 | ||||
177318 | 37526 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 1150 Larkin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1998 12:00:00 AM | Permit Number 39975 | 6007323.5106073 | 2115257.61387493 | 37.7885078148262 | -122.418483459105 | (37.7885078148262, -122.418483459105) | 13 | 9 | 10 | 28858 | 21 | ||
180904 | 34527 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2856 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/1997 12:00:00 AM | Permit Number 38237 | 6001046.30881699 | 2116265.48327203 | 37.7909197844571 | -122.440273859259 | (37.7909197844571, -122.440273859259) | 13 | 6 | 1 | 29490 | 27 | |||
189659 | 34528 | Permitted Site 7 | Dodonaea viscosa :: Hop Bush 43 | 2856 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1997 12:00:00 AM | Permit Number 38237 | 6001046.30881699 | 2116265.48327203 | 37.7909197844571 | -122.440273859259 | (37.7909197844571, -122.440273859259) | 13 | 6 | 1 | 29490 | 27 |
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) );