trees

16 rows where Supervisor Districts = 1 and qSpecies_id = 116 sorted by PlantDate

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor Districts ✖

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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);