Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1009 | 1009 | 223537 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300 Noe St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 6003218.0959 | 2100594.3408 | 37.7480140720016 | -122.431640256605 | (37.7480140720016, -122.431640256605) | |||
| 28506 | 28506 | 223371 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3527 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6006033.70926 | 2105484.59441 | 37.7616007686849 | -122.42225135332899 | (37.7616007686849, -122.422251353329) | |||
| 28721 | 28721 | 223467 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 812 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5998670.80107 | 2107458.83461 | 37.7666034705969 | -122.447858683442 | (37.7666034705969, -122.447858683442) | |||
| 29336 | 29336 | 207629 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1256 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5993954.61606 | 2106931.98149 | 37.7648861755735 | -122.464132764815 | (37.7648861755735, -122.464132764815) | |||
| 34451 | 34451 | 224069 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 4411 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5999992.96572 | 2105734.65927 | 37.761944797124706 | -122.44316171774099 | (37.7619447971247, -122.443161717741) | |||
| 40030 | 40030 | 223645 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3422 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006716.76064 | 2104985.28573 | 37.760268288171794 | -122.41985352063101 | (37.7602682881718, -122.419853520631) | |||
| 44237 | 44237 | 207563 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1453 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5993327.97162 | 2105609.42801 | 37.7612186539421 | -122.466204030294 | (37.7612186539421, -122.466204030294) | |||
| 52641 | 52641 | 207623 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1209 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5995446.62936 | 2107316.27502 | 37.7660272254875 | -122.45900013246401 | (37.7660272254875, -122.459000132464) | |||
| 53106 | 53106 | 59756 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 410 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/1981 12:00:00 AM | 15 | Permit Number 19194 | 6003645.40594 | 2091044.7006599999 | 37.7218171391456 | -122.42948170562 | (37.7218171391456, -122.42948170562) | ||
| 54974 | 54974 | 207657 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1343 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 5994851.17406 | 2106389.13082 | 37.7634472809955 | -122.46099247254699 | (37.7634472809955, -122.460992472547) | |||
| 63479 | 63479 | 207666 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 316 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 6ft | 5993287.90775 | 2103943.6101599997 | 37.756642440205106 | -122.46622153019501 | (37.7566424402051, -122.466221530195) | |||
| 65203 | 65203 | 224090 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 236 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004557.93322 | 2109147.67974 | 37.771575367127205 | -122.427616451463 | (37.7715753671272, -122.427616451463) | |||
| 133926 | 133926 | 223454 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 582 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 5998651.90281 | 2105834.0074299998 | 37.7621410238197 | -122.447807062365 | (37.7621410238197, -122.447807062365) | |||
| 143974 | 143974 | 58476 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 772 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/1978 12:00:00 AM | 15 | 8x7 | Permit Number 17633 | 5998628.49862087 | 2107799.74145876 | 37.767537096550605 | -122.44802954749599 | (37.7675370965506, -122.448029547496) | |
| 150845 | 150845 | 207631 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1253 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5993899.350740001 | 2106950.14127 | 37.7649328521939 | -122.464325230527 | (37.7649328521939, -122.464325230527) | |||
| 169694 | 169694 | 223530 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 606 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6002608.27814 | 2098903.4509099997 | 37.743336699841706 | -122.433628153123 | (37.7433366998417, -122.433628153123) | |||
| 177966 | 177966 | 223438 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 270 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6004159.88516 | 2099284.24689 | 37.7444701945428 | -122.428290228918 | (37.7444701945428, -122.428290228918) | |||
| 179873 | 179873 | 223417 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 416 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009130.8253 | 2100056.49852 | 37.7468706478628 | -122.411156208595 | (37.7468706478628, -122.411156208595) | |||
| 183175 | 183175 | 54136 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 2443 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/1972 12:00:00 AM | 15 | Permit Number 9869 | 6001890.1565 | 2117687.62066 | 37.7948726132212 | -122.437456069748 | (37.7948726132212, -122.437456069748) | ||
| 184002 | 184002 | 223444 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 319 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6003651.97677 | 2099506.05827 | 37.7450504848013 | -122.430062291736 | (37.7450504848013, -122.430062291736) | |||
| 185551 | 185551 | 71394 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1549 Kirkwood Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/21/1988 12:00:00 AM | 15 | 6015490.02353 | 2096504.2256900002 | 37.7374714167655 | -122.388918537456 | (37.7374714167655, -122.388918537456) | ||
| 187744 | 187744 | 207546 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 1249 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5993899.6739 | 2106983.20983 | 37.7650236684223 | -122.46432651386002 | (37.7650236684223, -122.46432651386) | |||
| 188247 | 188247 | 223414 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 308 Montcalm St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009647.06904 | 2099615.2237400003 | 37.7456879422558 | -122.40933994229799 | (37.7456879422558, -122.409339942298) |
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");