Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18858 | 18858 | 17137 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 2045 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5997217.7067 | 2109114.9444 | 37.7710675601361 | -122.453004213188 | (37.7710675601361, -122.453004213188) | |||
| 19296 | 19296 | 17136 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 2041 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5997241.2054 | 2109118.3624 | 37.7710782917307 | -122.45292317759301 | (37.7710782917307, -122.452923177593) | |||
| 19523 | 19523 | 16915 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 484 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004711.24143 | 2110219.61063 | 37.7745272991249 | -122.42716251506 | (37.7745272991249, -122.42716251506) | |||
| 21894 | 21894 | 17095 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1661 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5999030.0966 | 2109360.6125 | 37.7718458009941 | -122.446752800648 | (37.7718458009941, -122.446752800648) | |||
| 22581 | 22581 | 16398 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 299X Myrtle St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006124.74935 | 2114015.2727900003 | 37.7850290954547 | -122.422542679726 | (37.7850290954547, -122.422542679726) | ||
| 22586 | 22586 | 16396 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 299X Myrtle St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006093.31996 | 2114011.54372 | 37.7850170832184 | -122.422651150523 | (37.7850170832184, -122.422651150523) | ||
| 22735 | 22735 | 16395 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 299X Myrtle St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006070.4864 | 2114008.23449 | 37.7850067086413 | -122.42272991225201 | (37.7850067086413, -122.422729912252) | ||
| 22771 | 22771 | 16397 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 299X Myrtle St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1990 12:00:00 AM | 6 | 3X3 | 6006110.1202 | 2114012.78935 | 37.785021451230705 | -122.422593115487 | (37.7850214512307, -122.422593115487) | ||
| 24600 | 24600 | 234864 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 161 Beaver St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6001880.22394 | 2106835.6082900004 | 37.7650751645184 | -122.43671325313998 | (37.7650751645184, -122.43671325314) | |||
| 24985 | 24985 | 30698 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 240 Lily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 6 | Permit Number 34612 | 6005345.2585 | 2110114.4836 | 37.7742744792738 | -122.42496184383499 | (37.7742744792738, -122.424961843835) | |
| 25462 | 25462 | 250940 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 237 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5987097.72783 | 2114420.3103099996 | 37.7850494354169 | -122.488399056469 | (37.7850494354169, -122.488399056469) | |||
| 27987 | 27987 | 139151 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1881 POST ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6003144.9445 | 2114104.5849 | 37.7851057685851 | -122.43285823467801 | (37.7851057685851, -122.432858234678) | |||
| 49392 | 49392 | 49889 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1430@ OCTAVIA Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2003 12:00:00 AM | 6 | Permit Number 46660 | 6004450.34869 | 2120515.08924 | 37.8027813349583 | -122.42879910759599 | (37.8027813349583, -122.428799107596) | |
| 72379 | 72379 | 250724 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 2701 Lake St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5987063.6250599995 | 2114433.2112 | 37.7850828677123 | -122.488517988217 | (37.7850828677123, -122.488517988217) | |||
| 91939 | 91939 | 122722 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1385 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007219.0 | 2107431.0 | 37.76701193031621 | -122.41828991357599 | (37.7670119303162, -122.418289913576) | |||
| 93139 | 93139 | 18222 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 1643X Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 6 | 3X3 | 6004309.242075901 | 2114268.2781924 | 37.7856211964399 | -122.428841803498 | (37.7856211964399, -122.428841803498) | ||
| 132650 | 132650 | 212840 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 310 Orizaba Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5994040.889169999 | 2088808.5139 | 37.7151286310473 | -122.462519667047 | (37.7151286310473, -122.462519667047) | |||
| 135263 | 135263 | 135660 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 525 Spruce St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5997107.47515 | 2114429.48514 | 37.785653579297204 | -122.45376934359699 | (37.7856535792972, -122.453769343597) | |||
| 150305 | 150305 | 234860 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 160 Carnelian Way | 2 | : Yard 23 | Tree 1 | Private 1 | 6 | 6000574.359 | 2100517.55086 | 37.7476530184698 | -122.44077666170799 | (37.7476530184698, -122.440776661708) | ||||
| 159891 | 159891 | 234861 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 60 Zircon Pl | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6002321.72608 | 2098705.6175700002 | 37.7427772324719 | -122.434604832164 | (37.7427772324719, -122.434604832164) | |||
| 166626 | 166626 | 250938 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 239 28th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5987099.7017 | 2114350.08641 | 37.7848567358866 | -122.48838706491101 | (37.7848567358866, -122.488387064911) | |||
| 181063 | 181063 | 246079 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 663 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998980.117000001 | 2108420.232 | 37.769260899787 | -122.446858004242 | (37.769260899787, -122.446858004242) | |||
| 185748 | 185748 | 212847 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1269 02nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5995455.86214 | 2106863.98273 | 37.7647858787024 | -122.45893544780701 | (37.7647858787024, -122.458935447807) | |||
| 188863 | 188863 | 234852 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 590 York St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6009778.46002 | 2105547.1996400002 | 37.7619831846864 | -122.40930414927799 | (37.7619831846864, -122.409304149278) |
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");