Street_Tree_List

Data source: data.sfgov.org

18 rows where DBH = 9 and qSiteInfo = 23

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qSpecies, qAddress, SiteOrder

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
37555 37555 237003 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 199 Franconia St 14 : Yard 23 Tree 1 Private 1     9 Width 3ft   6010106.165469999 2099668.32603 37.7458594609566 -122.40775619120001 (37.7458594609566, -122.4077561912)
60000 60000 192362 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 1 25th St 20 : Yard 23 Tree 1 Private 1     9     6014965.98324 2102248.74822 37.7532156176115 -122.391131817592 (37.7532156176115, -122.391131817592)
73004 73004 190635 Undocumented 2 Hakea suaveolens :: Sweet Hakea Tree 14 1 01st St 28 : Yard 23 Tree 1 Private 1     9     6014407.37845 2105898.42582 37.7632058300952 -122.393318979581 (37.7632058300952, -122.393318979581)
74692 74692 196073 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1 25th St 5 : Yard 23 Tree 1 Private 1     9     6014983.580569999 2102134.9117099997 37.752904023218605 -122.391063005979 (37.7529040232186, -122.391063005979)
134718 134718 196565 Undocumented 2 Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 1 24th St 22 : Yard 23 Tree 1 Private 1     9     6017179.65065 2102592.91539 37.7542832244069 -122.38350039013599 (37.7542832244069, -122.383500390136)
137284 137284 189677 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 24th St 14 : Yard 23 Tree 1 Private 1     9     6017255.58244 2102660.6719 37.754473466102795 -122.38324251223801 (37.7544734661028, -122.383242512238)
139126 139126 199549 Undocumented 2 Yucca gloriosa :: Spanish Dagger 224 1 01st St 5 : Yard 23 Tree 1 Private 1     9     6014392.26095 2105920.87265 37.7632666242892 -122.39337283731399 (37.7632666242892, -122.393372837314)
150675 150675 190752 Undocumented 2 Juglans regia :: Walnut: English 348 1 24th St 5 : Yard 23 Tree 1 Private 1     9     6017117.58441 2102700.05767 37.7545739842169 -122.383722492107 (37.7545739842169, -122.383722492107)
150778 150778 188007 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1310 Indiana St 2 : Yard 23 Tree 1 Private 1     9     6015000.133780001 2102555.57956 37.7540600063901 -122.391035161147 (37.7540600063901, -122.391035161147)
152462 152462 233605 Undocumented 2 Olea europaea :: Olive Tree 41 199 Franconia St 12 : Yard 23 Tree 1 Private 1     9 Width 3ft   6010122.88511 2099649.32748 37.745808231063705 -122.407697037414 (37.7458082310637, -122.407697037414)
152563 152563 234500 Undocumented 2 Pinus muricata :: Bishop Pine 302 4090 20th St 8 : Yard 23 Tree 1 Private 1     9 Width 3ft   6003098.9698 2104154.51537 37.757782715804204 -122.43230641682699 (37.7577827158042, -122.432306416827)
153276 153276 199557 Undocumented 2 Yucca gloriosa :: Spanish Dagger 224 1 01st St 18 : Yard 23 Tree 1 Private 1     9     6014448.03527 2105905.59327 37.7632277690557 -122.393178861636 (37.7632277690557, -122.393178861636)
154821 154821 237005 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 199 Franconia St 16 : Yard 23 Tree 1 Private 1     9 Width 3ft   6010090.49979 2099699.0653 37.7459429872721 -122.40781252834101 (37.7459429872721, -122.407812528341)
156957 156957 233233 Undocumented 2 Olea europaea :: Olive Tree 41 199 Franconia St 6 : Yard 23 Tree 1 Private 1     9 Width 3ft   6010125.251569999 2099665.5030400003 37.745852778088 -122.407689994823 (37.745852778088, -122.407689994823)
163742 163742 189680 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1 24th St 21 : Yard 23 Tree 1 Private 1     9     6017213.38014 2102597.10976 37.754296605427704 -122.38338403586701 (37.7542966054277, -122.383384035867)
171136 171136 199548 Undocumented 2 Yucca gloriosa :: Spanish Dagger 224 1 01st St 4 : Yard 23 Tree 1 Private 1     9     6014382.11605 2105919.95745 37.7632635477036 -122.39340786139499 (37.7632635477036, -122.393407861395)
172054 172054 222663 Undocumented 2 Ceanothus Sps :: California lilac 270 4090 20th St 2 : Yard 23 Tree 1 Private 1     9 Width 3ft   6003162.223809999 2104187.96649 37.7578781509761 -122.43209004713002 (37.7578781509761, -122.43209004713)
179643 179643 222664 Undocumented 2 Ceanothus Sps :: California lilac 270 4090 20th St 3 : Yard 23 Tree 1 Private 1     9 Width 3ft   6003149.42788 2104190.19818 37.7578835531891 -122.432134460156 (37.7578835531891, -122.432134460156)

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 58.213ms · Data source: data.sfgov.org