Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSpecies, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, XCoord, Longitude, Location
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82393 | 82393 | 108910 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 129 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773054 | 6007361.2 | 2097016.9 | 37.7384251864379 | -122.417060086005 | (37.7384251864379, -122.417060086005) |
| 83041 | 83041 | 109366 | Permitted Site 1 | :: 54 | 1205 Filbert St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 3.125x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 91154 | 91154 | 109365 | Permitted Site 1 | :: 54 | 1205 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x16 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 101115 | 101115 | 109364 | Permitted Site 1 | :: 54 | 1205 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x6 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 101235 | 101235 | 109535 | Permitted Site 1 | :: 54 | 1234 Filbert St | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 112218 | 112218 | 109536 | Permitted Site 1 | :: 54 | 1234 Filbert St | 4 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.4 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 114314 | 114314 | 108701 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 478 30th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774626 | 6003507.49152 | 2098366.3309400002 | 37.7419128730633 | -122.43048058961 | (37.7419128730633, -122.43048058961) | |
| 116207 | 116207 | 109368 | Permitted Site 1 | :: 54 | 1205 Filbert St | 5 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 3x22 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 123584 | 123584 | 109253 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1355 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/05/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773041 | 5981790.7 | 2105864.5 | 37.7612466017789 | -122.50612476738199 | (37.7612466017789, -122.506124767382) |
| 124298 | 124298 | 109367 | Permitted Site 1 | :: 54 | 1205 Filbert St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 4.5x6.5 | 6007075.4 | 2119431.2 | 37.7999534721279 | -122.419638123127 | (37.7999534721279, -122.419638123127) | |
| 125946 | 125946 | 109370 | Permitted Site 1 | :: 54 | 2061 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 13x6 | 6007159.6 | 2119443.7 | 37.799992536546505 | -122.41934764587201 | (37.7999925365465, -122.419347645872) | |
| 126302 | 126302 | 109534 | Permitted Site 1 | :: 54 | 1234 Filbert St | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | FUF 1 | 02/23/2015 12:00:00 AM | 3 | 1.5x2.6 | 6007007.9 | 2119506.8 | 37.800157248198296 | -122.419877066677 | (37.8001572481983, -122.419877066677) | |
| 127072 | 127072 | 99201 | Permitted Site 1 | Tree(s) :: 17 | 4016 26th St | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | DPW 2 | FUF 1 | 04/12/2012 12:00:00 AM | 6x10.5 | Permit Number 768835 | 6003752.7 | 2100736.7 | 37.7484352450997 | -122.429801769855 | (37.7484352450997, -122.429801769855) | ||
| 128347 | 128347 | 104667 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 172 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 01/19/2016 12:00:00 AM | 6x12 | Permit Number 777366 | 6003998.6 | 2101043.1 | 37.749290469922705 | -122.42897329466999 | (37.7492904699227, -122.42897329467) | |
| 128427 | 128427 | 109369 | Permitted Site 1 | :: 54 | 2061 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/11/2015 12:00:00 AM | 3 | 5x6 | 6007159.6 | 2119443.7 | 37.799992536546505 | -122.41934764587201 | (37.7999925365465, -122.419347645872) | |
| 145744 | 145744 | 109499 | Permitted Site 1 | Agonis flexuosa :: Peppermint Willow 7 | 99 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | FUF 1 | 02/19/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774984 | 6002392.9 | 2096233.9 | 37.7359945088656 | -122.43418207236999 | (37.7359945088656, -122.43418207237) |
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");