Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25968 | 25968 | 249846 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 289 Greenwich St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | Width 0ft | 6011427.16735 | 2120382.55668 | 37.8028098362532 | -122.40464628970601 | (37.8028098362532, -122.404646289706) | |||
| 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) | |||
| 34441 | 34441 | 191696 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1700 22nd St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6012930.9536 | 2103804.38992 | 37.7573739307682 | -122.398278546439 | (37.7573739307682, -122.398278546439) | ||||
| 37458 | 37458 | 246770 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 99 Waltham St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6009309.01668 | 2098932.20278 | 37.7437935707282 | -122.410460661231 | (37.7437935707282, -122.410460661231) | ||||
| 67005 | 67005 | 191705 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1700 Armstrong Ave | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6013900.77828 | 2092879.68746 | 37.727430958252604 | -122.394159667654 | (37.7274309582526, -122.394159667654) | ||||
| 73834 | 73834 | 207713 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 171 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 5999625.5730099995 | 2094046.65577 | 37.7298313962868 | -122.443592725033 | (37.7298313962868, -122.443592725033) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 177778 | 177778 | 176281 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 600 Blanken Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 6013188.37125 | 2086854.32403 | 37.710846891333105 | -122.39620037057101 | (37.7108468913331, -122.396200370571) | |||
| 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) | |||
| 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) |
JSON shape: default, array, newline-delimited
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");