trees
13 rows where PlotSize = "Width 10ft" and qSpecies_id = 98 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
133957 | 215770 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 6000577.40993 | 2095873.4525 | 37.7349015959229 | -122.440433090118 | (37.7349015959229, -122.440433090118) | 9 | 7 | 4 | 63 | 40 | |||
108492 | 215769 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6000576.07621 | 2095873.86239 | 37.7349026454429 | -122.440437730631 | (37.7349026454429, -122.440437730631) | 9 | 7 | 4 | 63 | 40 | |||
77716 | 215768 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 6000574.55456 | 2095874.46679 | 37.7349042183411 | -122.440443034827 | (37.7349042183411, -122.440443034827) | 9 | 7 | 4 | 63 | 40 | |||
4859 | 215767 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 6000573.18125 | 2095872.96734 | 37.7349000230045 | -122.440447675323 | (37.7349000230045, -122.440447675323) | 9 | 7 | 4 | 63 | 40 | |||
127590 | 215766 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6000570.32165 | 2095873.79044 | 37.7349021202175 | -122.440457620949 | (37.7349021202175, -122.440457620949) | 9 | 7 | 4 | 63 | 40 | |||
181428 | 215765 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 10ft | 6000567.86167 | 2095875.36939 | 37.7349063155722 | -122.440466239146 | (37.7349063155722, -122.440466239146) | 9 | 7 | 4 | 63 | 40 | |||
101031 | 215764 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6000563.68419 | 2095877.36552 | 37.7349115586084 | -122.440480825239 | (37.7349115586084, -122.440480825239) | 9 | 7 | 4 | 63 | 40 | |||
22845 | 215763 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6000560.6488 | 2095878.95607 | 37.7349157530474 | -122.440491433659 | (37.7349157530474, -122.440491433659) | 9 | 7 | 4 | 63 | 40 | |||
29909 | 215762 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6000558.90016 | 2095877.84663 | 37.7349126072133 | -122.44049739976 | (37.7349126072133, -122.44049739976) | 9 | 7 | 4 | 63 | 40 | |||
187844 | 215761 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 6000556.80733 | 2095878.65384 | 37.7349147044535 | -122.440504693264 | (37.7349147044535, -122.440504693264) | 9 | 7 | 4 | 63 | 40 | |||
379 | 215760 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 811 Congo St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6000555.25402 | 2095877.7313 | 37.734912082925 | -122.440509997443 | (37.734912082925, -122.440509997443) | 9 | 7 | 4 | 63 | 40 | |||
167056 | 215745 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | Width 10ft | 6000472.43959 | 2095925.27887 | 37.7350379214503 | -122.440799724826 | (37.7350379214503, -122.440799724826) | 9 | 7 | 4 | 63 | 40 | |||
9841 | 215746 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1199 Bosworth St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 10ft | 6000474.8444 | 2095921.02809 | 37.7350263867572 | -122.440791105741 | (37.7350263867572, -122.440791105741) | 9 | 7 | 4 | 63 | 40 |
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) );