Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36079 | 36079 | 219231 | Undocumented 2 | Ilex spp :: Holly Species 163 | 449 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5997163.53491 | 2095515.5214200001 | 37.7337238258 | -122.45221017186199 | (37.7337238258, -122.452210171862) | ||||
| 36969 | 36969 | 117716 | Undocumented 2 | Ilex spp :: Holly Species 163 | 3945 Clement St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 8ft | 5983209.45945 | 2113085.35212 | 37.7811563972474 | -122.50175221539601 | (37.7811563972474, -122.501752215396) | |||
| 44415 | 44415 | 129095 | Undocumented 2 | Ilex spp :: Holly Species 163 | 2942 Divisadero St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6000568.08591 | 2118422.82625 | 37.796816042775504 | -122.442083407248 | (37.7968160427755, -122.442083407248) | |||
| 48602 | 48602 | 129094 | Undocumented 2 | Ilex spp :: Holly Species 163 | 2942 Divisadero St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6000566.12061 | 2118445.5081599997 | 37.7968782093121 | -122.442091836579 | (37.7968782093121, -122.442091836579) | |||
| 53938 | 53938 | 118083 | Undocumented 2 | Ilex spp :: Holly Species 163 | 7309 Geary Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 2ft | 5984328.8836199995 | 2112397.00903 | 37.7793320968225 | -122.49782878116999 | (37.7793320968225, -122.49782878117) | |||
| 55099 | 55099 | 129098 | Undocumented 2 | Ilex spp :: Holly Species 163 | 699 Marina Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 7ft | 5999673.759930001 | 2121514.33526 | 37.8052534912214 | -122.445400374028 | (37.8052534912214, -122.445400374028) | |||
| 131062 | 131062 | 219225 | Undocumented 2 | Ilex spp :: Holly Species 163 | 1820 16th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 5ft | 5991268.144090001 | 2102994.44508 | 37.7539195421662 | -122.473137315828 | (37.7539195421662, -122.473137315828) | |||
| 156444 | 156444 | 129097 | Undocumented 2 | Ilex spp :: Holly Species 163 | 699 Marina Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 7ft | 5999648.00124 | 2121510.04753 | 37.8052402478033 | -122.445489206378 | (37.8052402478033, -122.445489206378) | |||
| 163490 | 163490 | 219230 | Undocumented 2 | Ilex spp :: Holly Species 163 | 175 Stillings Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 5ft | 5999606.10326 | 2095741.44552 | 37.7344837817026 | -122.44378174542601 | (37.7344837817026, -122.443781745426) | |||
| 178573 | 178573 | 129096 | Undocumented 2 | Ilex spp :: Holly Species 163 | 313 Maple St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 5996631.61587 | 2115198.1283 | 37.7877367751689 | -122.45547124399599 | (37.7877367751689, -122.455471243996) | |||
| 185125 | 185125 | 185003 | Undocumented 2 | Ilex spp :: Holly Species 163 | 2701 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985018.8709 | 2096488.705 | 37.7356927337416 | -122.494268955014 | (37.7356927337416, -122.494268955014) | |||
| 187368 | 187368 | 219226 | Undocumented 2 | Ilex spp :: Holly Species 163 | 98 Lurline St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5991838.5673400005 | 2105160.13567 | 37.759898970787 | -122.47132246058399 | (37.759898970787, -122.471322460584) | |||
| 188574 | 188574 | 120103 | Undocumented 2 | Ilex spp :: Holly Species 163 | 2551 Cabrillo St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 3ft | 5987706.88835 | 2110474.6605700003 | 37.77425132027 | -122.486001854101 | (37.77425132027, -122.486001854101) |
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");