Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSpecies, qAddress, SiteOrder, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3799 | 3799 | 178336 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 401 Ocean Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 29 | Width 8ft | 5998664.9682 | 2091522.93582 | 37.722847017548204 | -122.44673211618999 | (37.7228470175482, -122.44673211619) | |||
3801 | 3801 | 177109 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 6 | Width 5ft | 5998958.08532 | 2091518.52367 | 37.72285164275971 | -122.445718558684 | (37.7228516427597, -122.445718558684) | |||
3803 | 3803 | 178335 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 401 Ocean Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 33 | Width 8ft | 5998656.04486 | 2091523.1214700001 | 37.72284701755029 | -122.44676297552601 | (37.7228470175503, -122.446762975526) | |||
3805 | 3805 | 177105 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 4 | Width 5ft | 5998924.5969 | 2091518.7811599998 | 37.7228504376811 | -122.445834339179 | (37.7228504376811, -122.445834339179) | |||
3806 | 3806 | 177110 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 6 | Width 5ft | 5998978.57855 | 2091518.5364400002 | 37.722852847868 | -122.445647719081 | (37.722852847868, -122.445647719081) | |||
3808 | 3808 | 177108 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 5 | Width 5ft | 5998950.80755 | 2091518.23612 | 37.7228504376851 | -122.44574369563999 | (37.7228504376851, -122.44574369564) | |||
3811 | 3811 | 177743 | Significant Tree 6 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 401 Ocean Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 37 | 5998700.41574 | 2091522.98281 | 37.722849171448395 | -122.446609585371 | (37.7228491714484, -122.446609585371) | ||||
3818 | 3818 | 178337 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 401 Ocean Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 29 | 5998676.28102 | 2091524.0079700002 | 37.7228506076618 | -122.44669308741301 | (37.7228506076618, -122.446693087413) | ||||
3826 | 3826 | 177104 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 4 | Width 5ft | 5998921.0818300005 | 2091519.29315 | 37.722851642780796 | -122.44584652679501 | (37.7228516427808, -122.445846526795) | |||
3827 | 3827 | 177106 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 401 Ocean Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | 7 | Width 5ft | 5998933.177730001 | 2091518.16383 | 37.7228492325857 | -122.44580463279199 | (37.7228492325857, -122.445804632792) | |||
80719 | 80719 | 116576 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 2500x OCEAN AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | DPW 4 | 30 | 10X10 | 5991377.0 | 2094742.0 | 37.7312667472315 | -122.472159374256 | (37.7312667472315, -122.472159374256) |
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");