Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 200 | 200 | 134567 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 07/06/2011 12:00:00 AM | 4 | Width 4ft | 6007561.6986 | 2111595.58464 | 37.778466176805296 | -122.417399738421 | (37.7784661768053, -122.417399738421) | ||
| 203 | 203 | 134565 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 15 | Width 4ft | 6007431.26589 | 2111583.6583 | 37.7784260904314 | -122.41785010990299 | (37.7784260904314, -122.417850109903) | |||
| 205 | 205 | 134566 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 14 | Width 4ft | 6007493.55732 | 2111589.9734900002 | 37.7784469358085 | -122.417635067622 | (37.7784469358085, -122.417635067622) | |||
| 209 | 209 | 134568 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 12/17/2009 12:00:00 AM | 5 | Width 4ft | 6007669.37768 | 2111613.23365 | 37.778520694605795 | -122.41702848568501 | (37.7785206946058, -122.417028485685) | ||
| 214 | 214 | 251244 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 05/29/2013 12:00:00 AM | 6007340.02606 | 2111591.01475 | 37.778441154342296 | -122.41816626519301 | (37.7784411543423, -122.418166265193) | ||||
| 422 | 422 | 23174 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 240 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 5 | 3x3 | 6006908.21847 | 2111432.04348 | 37.777980343250796 | -122.419648771078 | (37.7779803432508, -122.419648771078) | |||
| 79333 | 79333 | 14628 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 460 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 20 | 3X3 | 6006936.4820313 | 2112240.9458517 | 37.7802029857658 | -122.419608403425 | (37.7802029857658, -122.419608403425) | |||
| 83247 | 83247 | 9951 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 95X Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 18 | 3X3 | 6007383.306516 | 2111592.002729 | 37.778446303098505 | -122.418016611499 | (37.7784463030985, -122.418016611499) | |||
| 94107 | 94107 | 9952 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 95X Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 07/06/2011 12:00:00 AM | 3 | 3x3 | 6007383.306516 | 2111592.002729 | 37.778446303098505 | -122.418016611499 | (37.7784463030985, -122.418016611499) | ||
| 101592 | 101592 | 14098 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1480X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 12 | 4x4 | 6007076.6773563 | 2110527.4337913003 | 37.7755059900951 | -122.419001832587 | (37.7755059900951, -122.419001832587) | |||
| 102104 | 102104 | 14627 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 410X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 35 | 3X3 | 6007165.245080001 | 2112272.29684 | 37.780301951255105 | -122.41881922945299 | (37.7803019512551, -122.418819229453) | |||
| 108539 | 108539 | 26896 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 460 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 20 | 3X3 | 6006936.4820313 | 2112240.9458517 | 37.7802029857658 | -122.419608403425 | (37.7802029857658, -122.419608403425) | |||
| 113247 | 113247 | 14103 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1525 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 12 | 4X4 | 6006946.0284757 | 2110289.3486746997 | 37.774844907593 | -122.419436884969 | (37.774844907593, -122.419436884969) | |||
| 113688 | 113688 | 9953 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 95X Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 12/17/2009 12:00:00 AM | 12 | 3X3 | 6007383.306516 | 2111592.002729 | 37.778446303098505 | -122.418016611499 | (37.7784463030985, -122.418016611499) | ||
| 121181 | 121181 | 9950 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 95X Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 18 | 3X3 | 6007383.306516 | 2111592.002729 | 37.778446303098505 | -122.418016611499 | (37.7784463030985, -122.418016611499) | |||
| 122208 | 122208 | 14099 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1484 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 12 | 4X4 | 6007056.5524178 | 2110508.208095 | 37.7754520676647 | -122.419070085744 | (37.7754520676647, -122.419070085744) | |||
| 122483 | 122483 | 14102 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1525 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 12 | 4X4 | 6006946.0284757 | 2110289.3486746997 | 37.774844907593 | -122.419436884969 | (37.774844907593, -122.419436884969) |
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");