home / trees

Street_Tree_List

Data source: data.sfgov.org

9 rows where qSpecies = 24

View and edit SQL

Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlantDate, DBH, PlotSize, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes, Neighborhoods

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
82 100073 Permitted Site 2 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 24 930@ Lorraine Ct Anza St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/02/2012 12:00:00 AM   3x3 Permit Number 769060 5996162.0 2112255.0 37.7796287713947 -122.45688306406099 (37.7796287713947, -122.456883064061) 11 6 2 54 16
6418 107434 Undocumented 3 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 24 3169 WASHINGTON ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5999560.6 2115983.6 37.7900611064648 -122.44539405336 (37.7900611064648, -122.44539405336) 13 6 1 29490 27
6641 107697 Permitted Site 2 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 24 2401 MORAGA ST 3 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3     5986802.4 2103641.7 37.7554371523715 -122.488628271884 (37.7554371523715, -122.488628271884) 1 8 3 56 35
6642 107698 Permitted Site 2 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 24 2401 MORAGA ST 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2     3     5986802.4 2103641.7 37.7554371523715 -122.488628271884 (37.7554371523715, -122.488628271884) 1 8 3 56 35
14095 115885 Planning Code 138.1 required 8 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 24 134 Lunado Way 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2   03/01/2016 12:00:00 AM 3 10x10 Permit Number 772714 5991633.6 2092401.5 37.7248551637156 -122.471101821397 (37.7248551637156, -122.471101821397) 9 8 4 59 40
14096 115886 Planning Code 138.1 required 8 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 24 134 Lunado Way 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/01/2016 12:00:00 AM 3 2x4 Permit Number 772714 5991633.6 2092401.5 37.7248551637156 -122.471101821397 (37.7248551637156, -122.471101821397) 9 8 4 59 40
14097 115887 Planning Code 138.1 required 8 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 24 134 Lunado Way 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/01/2016 12:00:00 AM 3 2x4 Permit Number 772714 5991633.6 2092401.5 37.7248551637156 -122.471101821397 (37.7248551637156, -122.471101821397) 9 8 4 59 40
115521 243896 Planning Code 138.1 required 8 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 24 4225 23rd St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/13/2018 12:00:00 AM 3 3x3   6001659.329919999 2102313.2065 37.752645190240294 -122.43715344698201 (37.7526451902403, -122.437153446982) 2 4 5 28862 22
169982 66716 Permitted Site 2 Prunus cerasifera 'Thundercloud' :: Purple-Leaf Plum 'Thundercloud' 24 3506 24th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   08/06/1991 12:00:00 AM 12 3x3 Permit Number 29957 6006118.0 2102026.0 37.752109025945295 -122.42171416073799 (37.7521090259453, -122.421714160738) 2 4 5 28859 19

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 18.987ms · Data source: data.sfgov.org