Street_Tree_List

Data source: data.sfgov.org

26 rows where PlotSize = "Width 3ft" and qSpecies = 190

✎ View and edit SQL

This data as json, CSV (advanced)

PlotSize ✖

  • Width 3ft · 13 ✖
Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
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)
151623 151623 207729 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 10 Mendosa Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993528.0302800005 2101159.3791400003 37.749011508281995 -122.46518888187799 (37.749011508282, -122.465188881878)
154658 154658 207718 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 315 Faxon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5994723.84306 2090686.3460799998 37.7203240181088 -122.46029507616998 (37.7203240181088, -122.46029507617)
154979 154979 224128 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 18 Portola Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft   5999679.40978 2101490.53022 37.750273576386704 -122.443941232111 (37.7502735763867, -122.443941232111)
157517 157517 224132 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 310 Liberty St 26 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     9 Width 3ft   6004003.018680001 2103934.91108 37.7572309538551 -122.42916418288401 (37.7572309538551, -122.429164182884)
158863 158863 176275 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 23 Byron Ct 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5999165.787269999 2086612.0753799998 37.7093915094837 -122.444648098339 (37.7093915094837, -122.444648098339)
158994 158994 207710 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 641 Moraga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5992286.81518 2103851.81856 37.7563325940936 -122.46967695664 (37.7563325940936, -122.46967695664)
161021 161021 207707 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1254 18th Ave 1 Sidewalk: Property side : Yard 9 Tree 1 Private 1     8 Width 3ft   5990519.642630001 2106849.6628099997 37.7644615768749 -122.476007325895 (37.7644615768749, -122.476007325895)
161284 161284 207731 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 32 Malta Dr 19 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5999573.254930001 2096045.34694 37.735316349769704 -122.443917140176 (37.7353163497697, -122.443917140176)
168183 168183 118733 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 706 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 3ft   5982303.905590001 2110925.66237 37.7751732905824 -122.504724857451 (37.7751732905824, -122.504724857451)
168654 168654 207720 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 750 Grafton Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5994515.7556300005 2090598.91337 37.7200719768186 -122.46100802721901 (37.7200719768186, -122.461008027219)
172227 172227 120404 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 527 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   5988748.3356 2111702.11927 37.777682216959704 -122.482489301184 (37.7776822169597, -122.482489301184)
172510 172510 224129 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 26 Portola Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   5999702.07185 2101445.78437 37.7501520078164 -122.44385965101499 (37.7501520078164, -122.443859651015)

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