Street_Tree_List

Data source: data.sfgov.org

21 rows where SiteOrder = 2, qLegalStatus = 6 and qSiteInfo = 13

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qSpecies, qAddress, DBH, XCoord, YCoord, Latitude, Longitude, Location

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1409 1409 251514 Significant Tree 6 Pinus radiata :: Monterey Pine 3 99x Mountview Ct 2 Back Yard : Yard 13 Tree 1 Private 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1608 1608 251603 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 44R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999509.0 2100035.0 37.746267320465705 -122.444425925791 (37.7462673204657, -122.444425925791)
1609 1609 251630 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 8R Amethyst Way 2 Back Yard : Yard 13 Tree 1 Private 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1611 1611 251605 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 108 48R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999482.0 2100041.0 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345)
1616 1616 251607 Significant Tree 6 Pinus radiata :: Monterey Pine 3 52R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1623 1623 251613 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 60R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
1637 1637 251619 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 72R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999318.0 2100030.0 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875)
1646 1646 251633 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 14R Amethyst Way 2 Back Yard : Yard 13 Tree 1 Private 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1651 1651 251609 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 56R Amber Dr 2 Back Yard : Yard 13 Tree 1 Private 1           5999423.0 2100048.0 37.7462981080439 -122.44472423658002 (37.7462981080439, -122.44472423658)
19360 19360 105328 Significant Tree 6 Tree(s) :: 17 2051 03rd St 2 Back Yard : Yard 13 Tree 1 Private 1         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631)
60806 60806 96274 Significant Tree 6 Olea europaea :: Olive Tree 41 55@ Alemany Trumbull St 2 Back Yard : Yard 13 Tree 1 Private 1     2     6004001.3006 2094332.0064299998 37.7308634942567 -122.428485665086 (37.7308634942567, -122.428485665086)
82211 82211 115446 Significant Tree 6 Tree(s) :: 17 546 FRANCONIA ST 2 Back Yard : Yard 13 Tree 1 Private 1   04/01/2016 12:00:00 AM 3 3x3 Permit Number 777844 6009931.0 2098208.0 37.7418399166086 -122.40825891223801 (37.7418399166086, -122.408258912238)
86911 86911 87150 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 116 4 Bellair Pl 2 Back Yard : Yard 13 Tree 1 Private 1         Permit Number 50135 6010093.0 2120950.0 37.8042932388788 -122.409303278994 (37.8042932388788, -122.409303278994)
87905 87905 100771 Significant Tree 6 Pittosporum crassifolium :: Karo Tree 108 450 Hayes St 2 Back Yard : Yard 13 Tree 1 Private 1         Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899)
90919 90919 112420 Significant Tree 6 Picea Spp :: Spruce Spp 357 268 Lily St 2 Back Yard : Yard 13 Tree 1 Private 1   07/29/2015 12:00:00 AM 3     6005334.87738 2110100.0463 37.7742342515583 -122.42499672664302 (37.7742342515583, -122.424996726643)
91632 91632 87216 Significant Tree 6 Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 502 500 Cortland Ave 2 Back Yard : Yard 13 Tree 1 Private 1   02/08/2008 12:00:00 AM   3x3 Permit Number 50224 6007640.7 2097187.4 37.7389090609704 -122.416105779709 (37.7389090609704, -122.416105779709)
111685 111685 107343 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 116 110 JULIAN AVE 2 Back Yard : Yard 13 Tree 1 Private 1     15     6006340.8 2107214.1 37.7663669011591 -122.421312071366 (37.7663669011591, -122.421312071366)
125077 125077 87149 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 116 4 Bellair Pl 2 Back Yard : Yard 13 Tree 1 Private 1           6010093.0 2120950.0 37.8042932388788 -122.409303278994 (37.8042932388788, -122.409303278994)
140306 140306 98695 Significant Tree 6 Aesculus californica :: California Buckeye 338 191@Clarendon Forest Knolls Dr 2 Back Yard : Yard 13 Tree 1 Private 1   05/01/2012 12:00:00 AM     Permit Number 768674 5996330.9 2103059.9 37.754391095173794 -122.455633951336 (37.7543910951738, -122.455633951336)
143929 143929 92898 Significant Tree 6 Eucalyptus globulus :: Blue Gum 103 208 States St 2 Back Yard : Yard 13 Tree 1 Private 1   08/13/2008 12:00:00 AM       6000833.0 2106506.0 37.7641105715625 -122.440311694354 (37.7641105715625, -122.440311694354)
144323 144323 115460 Significant Tree 6 Tree(s) :: 17 80 Crestline Dr 2 Back Yard : Yard 13 Tree 1 Private 1   02/02/2016 12:00:00 AM 3   Permit Number 776150 5999012.8 2102131.7 37.7519960240451 -122.446292521132 (37.7519960240451, -122.446292521132)

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" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 908.416ms · Data source: data.sfgov.org