Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSpecies, qAddress, SiteOrder, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1980 | 1980 | 11144 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2553X Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006934.8566 | 2121129.59308 | 37.8046089111446 | -122.42024506476801 | (37.8046089111446, -122.420245064768) | |||
2990 | 2990 | 11143 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2553X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.12852 | 2121148.49105 | 37.804660646434996 | -122.42025584765301 | (37.804660646435, -122.420255847653) | |||
19129 | 19129 | 12492 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 307 Lake Merced Blvd | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
84379 | 84379 | 1734 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 50X Bay St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3x9 | 6010708.099243 | 2121736.3211997 | 37.8064867247361 | -122.407230131732 | (37.8064867247361, -122.407230131732) | |||
86583 | 86583 | 11688 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3x3 | 5991356.324435 | 2092039.0089713002 | 37.7238438117461 | -122.472033912425 | (37.7238438117461, -122.472033912425) | |||
92672 | 92672 | 85425 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 799X Junipero Serra Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3x3 | 5991351.334229 | 2092039.32129 | 37.7238443805247 | -122.472051185335 | (37.7238443805247, -122.472051185335) | |||
99823 | 99823 | 11150 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
103862 | 103862 | 11145 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
113524 | 113524 | 11152 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
116167 | 116167 | 12481 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
117794 | 117794 | 12485 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
118796 | 118796 | 11718 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 899X Junipero Serra Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3 | 5991288.7107407 | 2091242.502063 | 37.7216528879997 | -122.47220960661998 | (37.7216528879997, -122.47220960662) | |||
120483 | 120483 | 11149 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) | |||
138383 | 138383 | 11151 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2595X Hyde St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.804741201891495 | -122.420255726238 | (37.8047412018915, -122.420255726238) |
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");