Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qCaretaker, PlantDate, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1489 | 1489 | 239150 | DPW Maintained 3 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | Width 4ft | 6005732.390269999 | 2109686.64828 | 37.773121606595105 | -122.42359225870001 | (37.7731216065951, -122.4235922587) | |||
| 9721 | 9721 | 173654 | DPW Maintained 3 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 118 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010152.0 | 2112318.0 | 37.7805951592946 | -122.408489839314 | (37.7805951592946, -122.408489839314) | ||||
| 20029 | 20029 | 10244 | DPW Maintained 3 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 99X Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2000 12:00:00 AM | 6 | 3X3 | 6005773.33687 | 2109613.89968 | 37.7729241676403 | -122.42344544616002 | (37.7729241676403, -122.42344544616) | ||
| 80041 | 80041 | 91027 | DPW Maintained 3 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 722 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6007490.257402 | 2105446.273959 | 37.761577600545394 | -122.417211018518 | (37.7615776005454, -122.417211018518) | ||
| 101764 | 101764 | 22308 | DPW Maintained 3 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 5033 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2000 12:00:00 AM | 3 | 3x3 | 6014806.8487599995 | 2094754.47288 | 37.7326290611665 | -122.39115834308599 | (37.7326290611665, -122.391158343086) | ||
| 110318 | 110318 | 91028 | DPW Maintained 3 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 722 South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6007490.257402 | 2105446.273959 | 37.761577600545394 | -122.417211018518 | (37.7615776005454, -122.417211018518) | ||
| 110849 | 110849 | 91029 | DPW Maintained 3 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 967 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 5 | 3x3 | 6007608.48742 | 2104034.949256 | 37.7577090789947 | -122.416702122814 | (37.7577090789947, -122.416702122814) | ||
| 111319 | 111319 | 22306 | DPW Maintained 3 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 5015 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6014803.86419 | 2094824.41992 | 37.7328209559263 | -122.39117354906 | (37.7328209559263, -122.39117354906) | |||
| 117701 | 117701 | 95060 | DPW Maintained 3 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 5033 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6014806.53085 | 2094754.47288 | 37.732629043524206 | -122.391159442188 | (37.7326290435242, -122.391159442188) | |||
| 121292 | 121292 | 22304 | DPW Maintained 3 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 5012X 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6014702.6472 | 2094891.22359 | 37.7329987676998 | -122.39152815342301 | (37.7329987676998, -122.391528153423) | |||
| 121921 | 121921 | 95064 | DPW Maintained 3 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 4849X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014989.6 | 2095442.3 | 37.734527834908 | -122.390574568357 | (37.734527834908, -122.390574568357) | |||
| 124874 | 124874 | 91022 | DPW Maintained 3 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 140 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6007266.813002 | 2109001.353693 | 37.7713264423251 | -122.418235884317 | (37.7713264423251, -122.418235884317) | ||
| 126287 | 126287 | 91026 | DPW Maintained 3 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 722 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6007490.257402 | 2105446.273959 | 37.761577600545394 | -122.417211018518 | (37.7615776005454, -122.417211018518) |
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");