Street_Tree_List

Data source: data.sfgov.org

12 rows where PlotSize = "Width 4ft" and qSpecies = 190

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH

PlotSize ✖

  • Width 4ft · 12 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
23748 23748 224117 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 2818 23rd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6009831.98095 2102814.76339 37.754483528604396 -122.40892624516701 (37.7544835286044, -122.408926245167)
25572 25572 191703 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1501 Quint St 2 Front Yard : Yard 7 Tree 1 Private 1     7 Width 4ft   6013259.66608 2096346.4213299998 37.7369142408999 -122.396618925818 (37.7369142408999, -122.396618925818)
32095 32095 224121 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 211 Ogden Ave 3 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 4ft   6008290.10508 2096093.22608 37.7359411906366 -122.413783055452 (37.7359411906366, -122.413783055452)
39445 39445 224131 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1340 Alabama St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 4ft   6009255.1331 2101276.97976 37.7502287892492 -122.41081254437799 (37.7502287892492, -122.410812544378)
62610 62610 224125 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1745 Folsom St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6008033.82801 2108179.5959900003 37.7691132329216 -122.415524547646 (37.7691132329216, -122.415524547646)
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)
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)
154781 154781 126564 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1519 Pacific Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6006833.89403 2117675.37487 37.7951188107324 -122.42034913432501 (37.7951188107324, -122.420349134325)
171139 171139 126563 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1519 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 4ft   6006819.81222 2117673.20836 37.795112068514705 -122.420397705787 (37.7951120685147, -122.420397705787)
177924 177924 126565 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1519 Pacific Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 4ft   6006864.87455 2117678.3281900003 37.795128665521 -122.420242146478 (37.795128665521, -122.420242146478)
179929 179929 207728 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 3802 19th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     3 Width 4ft   5990564.76109 2090542.95021 37.7196901687566 -122.47466105158199 (37.7196901687566, -122.474661051582)
187509 187509 191704 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1501 Quint St 3 Front Yard : Yard 7 Tree 1 Private 1     6 Width 4ft   6013263.69136 2096352.02038 37.736929838751294 -122.396605400918 (37.7369298387513, -122.396605400918)

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