Street_Tree_List

Data source: data.sfgov.org

15 rows where DBH = 4 and qSpecies = 190

✎ View and edit SQL

This data as json, CSV (advanced)

DBH ✖

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
133784 133784 224113 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1100 San Jose Ave 69 Front Yard : Yard 7 Tree 1 Private 1     4     6004690.02185 2096554.43933 37.7370047468799 -122.426262810788 (37.7370047468799, -122.426262810788)
135365 135365 224124 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1244 Treat Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 3ft   6008668.58024 2101297.73586 37.7502528748804 -122.412842355611 (37.7502528748804, -122.412842355611)
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)
151773 151773 224122 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 211 Ogden Ave 6 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   6008272.03754 2096094.4851799998 37.73594363319479 -122.41384561137899 (37.7359436331948, -122.413845611379)
162057 162057 247967 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 16 Joy St 3 Front Yard : Yard 7 Tree 1 Private 1     4     6010333.495709999 2098927.4961099997 37.743838026898295 -122.40691790615 (37.7438380268983, -122.40691790615)
172056 172056 207733 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 500 Joost Ave 3 Sidewalk: Property side : Yard 9 Tree 1 Private 1     4     5998757.70005 2094996.74516 37.732390582643205 -122.446661380942 (37.7323905826432, -122.446661380942)
172703 172703 176284 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 251 De Long St 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 10ft   5993742.60383 2086796.45358 37.7095868089467 -122.46340473574101 (37.7095868089467, -122.463404735741)
181257 181257 176287 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1565 Bacon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6006970.59339 2091697.7707099998 37.723798037137 -122.418033639041 (37.723798037137, -122.418033639041)
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.295ms · Data source: data.sfgov.org