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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27899 | 27899 | 136747 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2859 Filbert St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 5999233.55999 | 2118349.36625 | 37.796538199022606 | -122.446695870812 | (37.7965381990226, -122.446695870812) | |||
| 28207 | 28207 | 179962 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 299 Lathrop Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6012155.6977 | 2086855.9290099998 | 37.710793783685006 | -122.39976966465599 | (37.710793783685, -122.399769664656) | |||
| 34328 | 34328 | 241212 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2801 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6009052.89196 | 2106353.81264 | 37.7641572813666 | -122.411870616529 | (37.7641572813666, -122.411870616529) | |||
| 60020 | 60020 | 241221 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2800 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009078.922 | 2106403.19833 | 37.764294343422996 | -122.411784075669 | (37.764294343423, -122.411784075669) | |||
| 81156 | 81156 | 109317 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1516 BROADWAY | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006331.3 | 2118082.2 | 37.796207516174796 | -122.42211710536101 | (37.7962075161748, -122.422117105361) | ||||
| 109031 | 109031 | 136743 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2900 Broderick St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6000050.877859999 | 2118557.23395 | 37.7971556025074 | -122.44388272313 | (37.7971556025074, -122.44388272313) | |||
| 110112 | 110112 | 115632 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 55x 15TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6012114.0 | 2107494.0 | 37.7674592382642 | -122.40136319642001 | (37.7674592382642, -122.40136319642) | ||||
| 164853 | 164853 | 215422 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 15 Fairfield Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993781.00975 | 2092831.61045 | 37.7261601145848 | -122.46370973814 | (37.7261601145848, -122.46370973814) | |||
| 166430 | 166430 | 179960 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 162 Tunnel Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6011897.9450900005 | 2087458.38855 | 37.7124336452757 | -122.400702818282 | (37.7124336452757, -122.400702818282) | |||
| 168300 | 168300 | 215431 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 20 Lakewood Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993618.37614 | 2092959.3845099998 | 37.726501578172396 | -122.464281221309 | (37.7265015781724, -122.464281221309) | |||
| 175537 | 175537 | 136749 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1360 Jones St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6008500.72583 | 2117239.96883 | 37.794017078290295 | -122.41455079677701 | (37.7940170782903, -122.414550796777) | |||
| 178204 | 178204 | 197987 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 2 Bridgeview Dr | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6014076.35565 | 2095353.09382 | 37.734232186468894 | -122.39372574026501 | (37.7342321864689, -122.393725740265) | ||||
| 178324 | 178324 | 215437 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 217 Staples Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5998668.44451 | 2093778.0926299999 | 37.729039350777 | -122.44688229669701 | (37.729039350777, -122.446882296697) | |||
| 185205 | 185205 | 179966 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 716 Peru Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 2ft | 6005255.40982 | 2092462.4838400001 | 37.725801087223 | -122.424017104714 | (37.725801087223, -122.424017104714) | |||
| 188342 | 188342 | 70057 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 1799 Revere Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/18/1990 12:00:00 AM | 12 | 6014037.2583099995 | 2095146.8497099997 | 37.7336637097057 | -122.393846481427 | (37.7336637097057, -122.393846481427) | ||
| 188528 | 188528 | 246216 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 725 Buena Vista Ave West | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5999835.3063 | 2107870.2944 | 37.7677997276311 | -122.443860441452 | (37.7677997276311, -122.443860441452) |
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");