Street_Tree_List

Data source: data.sfgov.org

15 rows where SiteOrder = 4 and qSpecies = 190

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize

SiteOrder ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
24799 24799 120350 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2122 Lake St 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     3 Width 6ft   5988813.63616 2114710.28976 37.7859456052821 -122.482483881641 (37.7859456052821, -122.482483881641)
25243 25243 126568 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2745 Larkin St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4     6006520.94056 2120654.06544 37.8032799020007 -122.421643667929 (37.8032799020007, -122.421643667929)
27406 27406 111563 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1498x Kansas St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 3x3   6011720.06091 2101415.9054400004 37.750748151322604 -122.40229838558001 (37.7507481513226, -122.40229838558)
35128 35128 249903 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 300 Greenwich St 4 Front Yard : Yard 7 Tree 1 Private 1     17 Width 0ft   6011307.54061 2120412.72536 37.8028859854681 -122.40506238711399 (37.8028859854681, -122.405062387114)
50631 50631 191693 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2212 25th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   6012143.16846 2101895.7398 37.752089281506706 -122.400868941954 (37.7520892815067, -122.400868941954)
57318 57318 218344 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 385 Castenada Ave 4 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     7 Width 0ft   5993369.339269999 2100022.3312 37.745880311731 -122.46565503467501 (37.745880311731, -122.465655034675)
64747 64747 191695 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 950x Kansas St 4 Median : Yard 3 Tree 1 DPW 2     4     6011603.94241 2103847.92507 37.7574194607598 -122.40287096412901 (37.7574194607598, -122.402870964129)
71206 71206 126566 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1519 Pacific Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6006877.845840001 2117681.84008 37.79513903917879 -122.420197513099 (37.7951390391788, -122.420197513099)
72590 72590 249863 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 233 Greenwich St 4 Front Yard : Yard 7 Tree 1 Private 1     6 Width 0ft   6011630.0308300005 2120434.01589 37.8029624665125 -122.40394789778799 (37.8029624665125, -122.403947897788)
143567 143567 111509 DPW Maintained 3 Eriobotrya japonica :: Edible Loquat 190 800x BOSWORTH ST 4 Front Yard : Yard 7 Tree 1 DPW 2     4     6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
153779 153779 207734 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 301 Joost Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 10ft   6000042.84201 2094939.4846400002 37.7323066857905 -122.442214249597 (37.7323066857905, -122.442214249597)
161098 161098 207716 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 115 Judson Ave 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 8ft   5999335.92351 2093459.52729 37.72820275463761 -122.44455189156601 (37.7282027546376, -122.444551891566)
165907 165907 126567 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2843 Larkin St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 5ft   6006455.5801099995 2121070.56705 37.8044198232789 -122.42189945398998 (37.8044198232789, -122.42189945399)
177554 177554 191692 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 764 De Haro St 4 Sidewalk: Property side : Yard 9 Tree 1 Private 1     9     6012093.5937 2104845.22166 37.7601851458373 -122.401247624904 (37.7601851458373, -122.401247624904)
184746 184746 191699 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 50 Quint St 4 Front Yard : Yard 7 Tree 1 Private 1     4 Width 6ft   6015737.97927 2099766.7157099997 37.7464432855229 -122.388288861864 (37.7464432855229, -122.388288861864)

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