trees
16 rows where Supervisor Districts = 1 and qSpecies_id = 116 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
183428 | 136750 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1124 Filbert St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 5ft | 6007528.1043 | 2119564.51843 | 37.8003450211571 | -122.418081047713 | (37.8003450211571, -122.418081047713) | 5 | 1 | 1 | 28858 | 32 | |||
112010 | 136751 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1142 Filbert St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 3ft | 6007453.51921 | 2119553.70533 | 37.8003111329029 | -122.41833837522 | (37.8003111329029, -122.41833837522) | 5 | 1 | 1 | 28858 | 32 | |||
85163 | 136748 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 165 Marina Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 7ft | 6002698.42353 | 2121575.97678 | 37.8055949413272 | -122.434937570523 | (37.8055949413272, -122.434937570523) | 13 | 9 | 1 | 57 | 17 | |||
168165 | 87391 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3322 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773384 | 6002335.87278 | 2119635.99284 | 37.800247665053 | -122.436053318908 | (37.800247665053, -122.436053318908) | 13 | 9 | 1 | 57 | 17 | |
26740 | 87392 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 3322 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773384 | 6002333.63287 | 2119648.29419 | 37.8002813140837 | -122.436061950612 | (37.8002813140837, -122.436061950612) | 13 | 9 | 1 | 57 | 17 | |
71242 | 136740 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1920 Beach St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6000976.88542 | 2121020.42839 | 37.8039716578185 | -122.44085530385 | (37.8039716578185, -122.44085530385) | 13 | 9 | 1 | 57 | 17 | |||
123376 | 113776 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 1710 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6000070.198 | 2114878.1306 | 37.7870548531015 | -122.443551447546 | (37.7870548531015, -122.443551447546) | 13 | 6 | 1 | 29490 | 27 | |||
21140 | 136741 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2900 Broderick St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6000055.17715 | 2118534.11341 | 37.7970923648718 | -122.443866184587 | (37.7970923648718, -122.443866184587) | 13 | 9 | 1 | 57 | 17 | |||
8935 | 136742 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2900 Broderick St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6000053.33945 | 2118542.13589 | 37.7971142876507 | -122.443873120143 | (37.7971142876507, -122.443873120143) | 13 | 9 | 1 | 57 | 17 | |||
124321 | 136743 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2900 Broderick St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 6000050.87786 | 2118557.23395 | 37.7971556025074 | -122.44388272313 | (37.7971556025074, -122.44388272313) | 13 | 9 | 1 | 57 | 17 | |||
145163 | 136744 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2906 Broderick St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6000047.06944 | 2118581.72583 | 37.7972226334754 | -122.443897661751 | (37.7972226334754, -122.443897661751) | 13 | 9 | 1 | 57 | 17 | |||
156301 | 136745 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2908 Broderick St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6000044.84961 | 2118592.59728 | 37.7972523569702 | -122.443906124388 | (37.7972523569702, -122.443906124388) | 13 | 9 | 1 | 57 | 17 | |||
47804 | 136746 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2908 Broderick St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 4ft | 6000043.09421 | 2118605.60705 | 37.7972879782152 | -122.443913133705 | (37.7972879782152, -122.443913133705) | 13 | 9 | 1 | 57 | 17 | |||
158744 | 136747 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2859 Filbert St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 4ft | 5999233.55999 | 2118349.36625 | 37.7965381990226 | -122.446695870812 | (37.7965381990226, -122.446695870812) | 13 | 9 | 1 | 57 | 17 | |||
102004 | 124330 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 130 Palm Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5995934.00049 | 2113471.95009 | 37.7829570979054 | -122.457759890544 | (37.7829570979054, -122.457759890544) | 11 | 6 | 1 | 54 | 31 | |||
47194 | 250756 | DPW Maintained 1 | Trachycarpus fortunei :: Windmill Palm 116 | 2900 Lake St | 1 | : | Tree | Private 2 | 6 | Width 0ft | 5986048.1037 | 2114785.2005 | 37.7859900201618 | -122.492057248563 | (37.7859900201618, -122.492057248563) | 11 | 6 | 1 | 55 | 33 |
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) );