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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35762 | 35762 | 241219 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 4130 Cesar Chavez St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 6ft | 6003095.93223 | 2100399.3712299997 | 37.7474718059861 | -122.432048772745 | (37.7474718059861, -122.432048772745) | |||
| 35806 | 35806 | 136746 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2908 Broderick St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6000043.09421 | 2118605.60705 | 37.7972879782152 | -122.44391313370501 | (37.7972879782152, -122.443913133705) | |||
| 39377 | 39377 | 241220 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2800 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009102.18096 | 2106403.8524599997 | 37.7642974442959 | -122.41170367540899 | (37.7642974442959, -122.411703675409) | |||
| 47759 | 47759 | 241195 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 699 Hampshire St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010149.3192300005 | 2105113.8429400004 | 37.7608140561404 | -122.407990924146 | (37.7608140561404, -122.407990924146) | |||
| 53611 | 53611 | 109316 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1516 BROADWAY | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006331.3 | 2118082.2 | 37.796207516174796 | -122.42211710536101 | (37.7962075161748, -122.422117105361) | ||||
| 58250 | 58250 | 215427 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 15 Fairfield Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993797.5326 | 2092869.7349099999 | 37.726265747145604 | -122.463655385788 | (37.7262657471456, -122.463655385788) | |||
| 60023 | 60023 | 241192 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 3630 20th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6006049.00576 | 2104357.91631 | 37.7585080370469 | -122.42211840383499 | (37.7585080370469, -122.422118403835) | |||
| 64723 | 64723 | 215414 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 423 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 6ft | 5997954.5929 | 2094069.3346400002 | 37.7297982247933 | -122.449371101191 | (37.7297982247933, -122.449371101191) | |||
| 67671 | 67671 | 197984 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1177 De Haro St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6012264.79545 | 2102939.83963 | 37.754962935614294 | -122.40052167053999 | (37.7549629356143, -122.40052167054) | |||
| 73423 | 73423 | 72214 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1799 Revere Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/1990 12:00:00 AM | 12 | 6014033.56934 | 2095149.8862 | 37.7336718422767 | -122.39385944784901 | (37.7336718422767, -122.393859447849) | ||
| 131633 | 131633 | 241213 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2801 17th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009032.16938 | 2106352.76347 | 37.76415323799171 | -122.411942216073 | (37.7641532379917, -122.411942216073) | |||
| 156645 | 156645 | 179959 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 162 Tunnel Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011901.82986 | 2087473.4551099997 | 37.7124752317148 | -122.400690449024 | (37.7124752317148, -122.400690449024) | |||
| 159781 | 159781 | 197990 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 155 Grace St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008384.453919999 | 2110216.9376 | 37.774726996282 | -122.414455930021 | (37.774726996282, -122.414455930021) | |||
| 167445 | 167445 | 215432 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 20 Lakewood Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993607.07382 | 2092934.5708400002 | 37.7264327944236 | -122.464318491921 | (37.7264327944236, -122.464318491921) | |||
| 178635 | 178635 | 182656 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2618 Ortega St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5985872.0635 | 2102330.847 | 37.7517835760889 | -122.491749119446 | (37.7517835760889, -122.491749119446) | |||
| 185349 | 185349 | 179968 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 675 Silver Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | Width 2ft | 6005852.39602 | 2093589.2328700002 | 37.7289285803821 | -122.422033372066 | (37.7289285803821, -122.422033372066) | |||
| 188473 | 188473 | 215418 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 286 Orizaba Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | 5994025.68496 | 2088506.9373700002 | 37.7142996980529 | -122.462550356439 | (37.7142996980529, -122.462550356439) |
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");