Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize ▼ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 43355 | 43355 | 41527 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1038 Innes Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2000 12:00:00 AM | 19 | Permit Number 42067 | 6018424.261969999 | 2095097.67116 | 37.7337714988594 | -122.378675747684 | (37.7337714988594, -122.378675747684) | ||
| 47057 | 47057 | 84747 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 170 King St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 19 | Permit No. 49304 | 6015084.20168 | 2111522.58673 | 37.7786861141091 | -122.391371241385 | (37.7786861141091, -122.391371241385) | ||
| 160511 | 160511 | 33315 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 1229 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | 19 | Permit Number 37460 | 6005351.66292 | 2120593.2650099997 | 37.8030469569032 | -122.42568566546001 | (37.8030469569032, -122.42568566546) | |
| 165317 | 165317 | 217452 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 248 Thrift St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 5994521.8342699995 | 2089659.5838400002 | 37.7174931519523 | -122.46091897182801 | (37.7174931519523, -122.460918971828) | ||||
| 181886 | 181886 | 49328 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 650 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2003 12:00:00 AM | 19 | Permit Number 46321 | 6013181.12431 | 2110489.32106 | 37.775743196927294 | -122.397882269155 | (37.7757431969273, -122.397882269155) | ||
| 39861 | 39861 | 65881 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 122 Palm Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2010 12:00:00 AM | 19 | 3x3 | Permit Number 53867 | 5995930.99366 | 2113550.02665 | 37.783171302573 | -122.457775944343 | (37.783171302573, -122.457775944343) |
| 145780 | 145780 | 28459 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2160X Ocean Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 19 | 3x3 | 5992788.04983 | 2093457.91659 | 37.727822529658 | -122.467187832651 | (37.727822529658, -122.467187832651) | ||
| 70541 | 70541 | 102432 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 982 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | 4x4 | 6010557.78599 | 2112071.21552 | 37.779940263668706 | -122.40706862532801 | (37.7799402636687, -122.407068625328) | |||
| 13185 | 13185 | 98922 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2507 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 6x6 | 5989831.2863 | 2098268.2421 | 37.7408593296697 | -122.47776079641599 | (37.7408593296697, -122.477760796416) | |||
| 43953 | 43953 | 249965 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 265 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 0ft | 6011638.85917 | 2120086.18138 | 37.802007891017205 | -122.40389285566799 | (37.8020078910172, -122.403892855668) | |||
| 26802 | 26802 | 243938 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 315 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6003592.012490001 | 2106424.54324 | 37.764043612453996 | -122.43076326292 | (37.764043612454, -122.43076326292) | |||
| 48613 | 48613 | 244810 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1346 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6010313.90218 | 2101409.39253 | 37.750651674745995 | -122.407160569311 | (37.750651674746, -122.407160569311) | |||
| 155650 | 155650 | 181265 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 271 Leland Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 3ft | 6009530.324580001 | 2087672.9738099999 | 37.7128905152502 | -122.40890120353201 | (37.7128905152502, -122.408901203532) | |||
| 178669 | 178669 | 243943 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 671 Church St | 56 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 3ft | 6004315.82343 | 2105235.1157 | 37.7608187101375 | -122.428175041065 | (37.7608187101375, -122.428175041065) | |||
| 39967 | 39967 | 199470 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1050 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6015462.75637 | 2109791.03207 | 37.7739526530238 | -122.38994067543001 | (37.7739526530238, -122.38994067543) | |||
| 64963 | 64963 | 199457 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6015609.11002 | 2108848.45381 | 37.7713726563476 | -122.389368573515 | (37.7713726563476, -122.389368573515) | |||
| 148816 | 148816 | 199461 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1279 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6015597.30963 | 2109009.9155099997 | 37.7718153404253 | -122.389420669423 | (37.7718153404253, -122.389420669423) | |||
| 167534 | 167534 | 199452 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1401 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6015631.41317 | 2108425.60277 | 37.7702128366907 | -122.38926189323799 | (37.7702128366907, -122.389261893238) |
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");