trees
14 rows where Fire Prevention Districts = 11 and qSpecies_id = 98 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12264 | 1493 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 312 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 5995573.92539 | 2114332.46977 | 37.7852991621023 | -122.459067922044 | (37.7852991621023, -122.459067922044) | 11 | 6 | 1 | 54 | 31 | |||
12928 | 123523 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 2820 Fulton St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 8ft | 5994606.69117 | 2110222.29586 | 37.7739580752179 | -122.462116054917 | (37.7739580752179, -122.462116054917) | 11 | 6 | 2 | 54 | 11 | |||
35844 | 123524 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 2828 Fulton St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 8ft | 5994582.70338 | 2110216.80029 | 37.7739416046925 | -122.462198633452 | (37.7739416046925, -122.462198633452) | 11 | 6 | 2 | 54 | 11 | |||
41015 | 123806 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 2201 Anza St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 33 | Width 4ft | 5991819.84372 | 2111992.27633 | 37.7786571107845 | -122.471885160871 | (37.7786571107845, -122.471885160871) | 11 | 6 | 2 | 54 | 11 | |||
56331 | 118304 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 399X Willard St North | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 5996218 | 2110432 | 37.7746265086244 | -122.45655746947 | (37.7746265086244, -122.45655746947) | 11 | 6 | 2 | 54 | 16 | ||||
58745 | 123328 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 767 04th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 4ft | 5994719.57081 | 2110383.41996 | 37.7744069778156 | -122.461737273105 | (37.7744069778156, -122.461737273105) | 11 | 6 | 2 | 54 | 11 | |||
64659 | 123360 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 752 04th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 4ft | 5994762.63942 | 2110475.46435 | 37.7746621864627 | -122.461594966486 | (37.7746621864627, -122.461594966486) | 11 | 6 | 2 | 54 | 11 | |||
129320 | 123330 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 753 04th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 5994716.4753 | 2110476.43216 | 37.7746621864718 | -122.461754726458 | (37.7746621864718, -122.461754726458) | 11 | 6 | 2 | 54 | 11 | |||
158123 | 122001 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 2250 Anza St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | Width 4ft | 5991649.8791 | 2112044.77165 | 37.7787914125342 | -122.472476956605 | (37.7787914125342, -122.472476956605) | 11 | 6 | 2 | 54 | 26 | |||
160556 | 123805 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 2201 Anza St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 4ft | 5991846.73407 | 2111993.54539 | 37.7786621511806 | -122.471792230155 | (37.7786621511806, -122.471792230155) | 11 | 6 | 2 | 54 | 11 | |||
161092 | 123804 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 2200 Anza St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | Width 4ft | 5991808.50618 | 2112055.95574 | 37.7788313010119 | -122.471929023833 | (37.7788313010119, -122.471929023833) | 11 | 6 | 2 | 54 | 11 | |||
167505 | 123522 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 2814 Fulton St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 8ft | 5994634.45147 | 2110226.82378 | 37.7739721059704 | -122.462020356507 | (37.7739721059704, -122.462020356507) | 11 | 6 | 2 | 54 | 11 | |||
168928 | 122002 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 2250 Anza St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | Width 4ft | 5991621.73453 | 2112044.32724 | 37.7787885632642 | -122.472574286372 | (37.7787885632642, -122.472574286372) | 11 | 6 | 2 | 54 | 26 | |||
172378 | 123368 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 798 04th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 4ft | 5994767.22383 | 2110333.14495 | 37.7742716789712 | -122.46156878779 | (37.7742716789712, -122.46156878779) | 11 | 6 | 2 | 54 | 11 |
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) );