Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 36917 | 36917 | 191685 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1301 Minnesota St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6015385.022890001 | 2102351.0583099998 | 37.7535197845136 | -122.38968982661801 | (37.7535197845136, -122.389689826618) | ||||
| 48398 | 48398 | 224111 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 1100 San Jose Ave | 50 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6004733.53405 | 2096634.51546 | 37.7372270772601 | -122.42611806850799 | (37.7372270772601, -122.426118068508) | ||||
| 63802 | 63802 | 183573 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 2587 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988295.3826 | 2097727.4025 | 37.7392850696685 | -122.483031684036 | (37.7392850696685, -122.483031684036) | |||
| 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) | ||||
| 69216 | 69216 | 207727 | Undocumented 2 | Eriobotrya japonica :: Edible Loquat 190 | 378 Victoria St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5993265.77465 | 2089711.0849799998 | 37.717562206406 | -122.46526429632601 | (37.717562206406, -122.465264296326) | |||
| 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) |
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");