trees

14 rows where DBH = 5 and qSpecies_id = 65 sorted by PlotSize

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

DBH ✖

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)
51850 83832 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1311 47th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/24/2008 12:00:00 AM 5 3x3 Permit Number 50170 5981489.3468 2106129.5123 37.7619565050576 -122.507186662869 (37.7619565050576, -122.507186662869) 1 8 3 56 35
88133 94732 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3965 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/28/2010 12:00:00 AM 5 3x3 Permit Number 53863 5995732.51221 2115478.09158 37.7884538465346 -122.458602225523 (37.7884538465346, -122.458602225523) 11 6 1 54 31
152974 94731 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3965 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/28/2010 12:00:00 AM 5 3x3 Permit Number 53863 5995713.23783 2115474.26613 37.788442235114 -122.458668634362 (37.788442235114, -122.458668634362) 11 6 1 54 31
162286 121320 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 550 07th Ave   Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   5993807 2111747 37.7780984292352 -122.464993055827 (37.7780984292352, -122.464993055827) 11 6 2 54 11
27616 185641 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 2100 Sunset Blvd 21 Sidewalk: Property side : Yard Tree Private 2     5 Width 0ft   5985060.0587 2100441.1859 37.7465475916098 -122.494417818871 (37.7465475916098, -122.494417818871) 1 8 3 29491 35
109884 183265 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1249 46th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 0ft   5981784.0294 2106586.8909 37.7632296873576 -122.506201404659 (37.7632296873576, -122.506201404659) 1 8 3 56 35
2752 221825 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 499X Tompkins Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6008302.15962 2096532.14097 37.7371470321954 -122.41377241466 (37.7371470321954, -122.41377241466) 2 7 7 28859 2
8756 221784 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 201 Buchanan St 5 : Tree Private 2     5 Width 3ft   6004701.97389 2109293.67351 37.7719843770185 -122.427128606994 (37.7719843770185, -122.427128606994) 7 9 11 28852 10
139805 117947 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3851 Cabrillo St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5983640.26853 2110338.90864 37.7736407564987 -122.500058768002 (37.7736407564987, -122.500058768002) 11 6 2 55 26
144708 117946 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 3851 Cabrillo St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5983654.61491 2110341.88423 37.773649768576 -122.500009362473 (37.773649768576, -122.500009362473) 11 6 2 55 26
160833 125544 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1410 Jefferson St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6002431.61204 2121624.28708 37.8057124359506 -122.435864366851 (37.8057124359506, -122.435864366851) 13 9 1 57 17
57235 125546 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 1070 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6007858.97154 2118915.83985 37.798582528908 -122.416890128576 (37.798582528908, -122.416890128576) 5 1 10 308 32
87878 120718 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 168 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   5989321.49284 2114237.33382 37.7846765322868 -122.480692220574 (37.7846765322868, -122.480692220574) 11 6 2 55 26
52355 175197 DPW Maintained 1 Agonis flexuosa :: Peppermint Willow 65 701 Peru Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6005286.47432 2092498.92071 37.7259028886841 -122.423912306729 (37.7259028886841, -122.423912306729) 9 7 7 309 5

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