Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize, XCoord, YCoord, Latitude, Longitude, Location
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2572 | 2572 | 24480 | Significant Tree 6 | Salix babylonica :: Weeping Willow 182 | 108X Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780363 | 6002195.08262 | 2096706.93645 | 37.737282128351005 | -122.434899824187 | (37.737282128351, -122.434899824187) | |
| 35949 | 35949 | 139617 | Undocumented 2 | Salix babylonica :: Weeping Willow 182 | 1835 EDDY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6001670.9088 | 2112514.652 | 37.780656503893 | -122.437844009531 | (37.780656503893, -122.437844009531) | |||
| 38409 | 38409 | 139607 | Undocumented 2 | Salix babylonica :: Weeping Willow 182 | 1111 SCOTT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6001857.8665 | 2112279.1586 | 37.78002052789039 | -122.437180368262 | (37.7800205278904, -122.437180368262) | |||
| 48170 | 48170 | 240950 | Undocumented 2 | Salix babylonica :: Weeping Willow 182 | 4806 25th St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 14 | 6000018.52876 | 2101091.51792 | 37.7491973234931 | -122.44273989253401 | (37.7491973234931, -122.442739892534) | ||||
| 52016 | 52016 | 179420 | Undocumented 2 | Salix babylonica :: Weeping Willow 182 | 1665 Cayuga Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5998335.89123 | 2088859.42966 | 37.715514840403706 | -122.447678015949 | (37.7155148404037, -122.447678015949) | |||
| 69849 | 69849 | 214147 | Undocumented 2 | Salix babylonica :: Weeping Willow 182 | 824 Faxon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 5994913.19129 | 2093521.6850400001 | 37.7281200673663 | -122.459845842331 | (37.7281200673663, -122.459845842331) | |||
| 78751 | 78751 | 117435 | Significant Tree 6 | Salix babylonica :: Weeping Willow 182 | 98X CLIPPER ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6004559.0 | 2101087.0 | 37.749442713924296 | -122.427038546128 | (37.7494427139243, -122.427038546128) | |||||
| 80563 | 80563 | 107239 | DPW Maintained 3 | Salix babylonica :: Weeping Willow 182 | 300x Liberty St | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 27 | 6004353.0 | 2103966.0 | 37.7573361226439 | -122.42795602638 | (37.7573361226439, -122.42795602638) | ||||
| 91654 | 91654 | 20980 | DPW Maintained 3 | Salix babylonica :: Weeping Willow 182 | 2002X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
| 96063 | 96063 | 107834 | Significant Tree 6 | Salix babylonica :: Weeping Willow 182 | 100X SUSSEX ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6002188.0 | 2096682.0 | 37.7372132564844 | -122.434922529204 | (37.7372132564844, -122.434922529204) | ||||
| 106133 | 106133 | 20981 | DPW Maintained 3 | Salix babylonica :: Weeping Willow 182 | 2002X Sunset Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
| 114032 | 114032 | 20979 | DPW Maintained 3 | Salix babylonica :: Weeping Willow 182 | 2002X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
| 114561 | 114561 | 114882 | DPW Maintained 3 | Salix babylonica :: Weeping Willow 182 | 801x Alemany Blvd | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 6004188.833980001 | 2094500.26728 | 37.731336111506295 | -122.42784931643499 | (37.7313361115063, -122.427849316435) | |||||
| 122438 | 122438 | 107835 | Significant Tree 6 | Salix babylonica :: Weeping Willow 182 | 100X SUSSEX ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6002188.0 | 2096682.0 | 37.7372132564844 | -122.434922529204 | (37.7372132564844, -122.434922529204) | ||||
| 140841 | 140841 | 122730 | DPW Maintained 3 | Salix babylonica :: Weeping Willow 182 | 700X Sanchez St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6003672.0 | 2104202.0 | 37.757945572264 | -122.430328029181 | (37.757945572264, -122.430328029181) | |||
| 149553 | 149553 | 197458 | Undocumented 2 | Salix babylonica :: Weeping Willow 182 | 1301 Minnesota St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6015384.239680001 | 2102278.60238 | 37.753320792420205 | -122.389687474898 | (37.7533207924202, -122.389687474898) | ||||
| 186848 | 186848 | 240949 | Undocumented 2 | Salix babylonica :: Weeping Willow 182 | 332 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003757.14491 | 2098676.58582 | 37.742778900740106 | -122.429639491667 | (37.7427789007401, -122.429639491667) |
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");