Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3279 | 3279 | 253383 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 899 Waller St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6001282.0 | 2108613.0 | 37.76992142642111 | -122.438909742148 | (37.7699214264211, -122.438909742148) | |||||
| 5918 | 5918 | 23710 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 700X Webster St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 20 | 6003962.5277 | 2111419.0963 | 37.77777842285779 | -122.429838035535 | (37.7777784228578, -122.429838035535) | |||
| 7466 | 7466 | 23749 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900X Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6003935.7161 | 2111981.6282 | 37.779321477825704 | -122.429970923277 | (37.7793214778257, -122.429970923277) | |||
| 7737 | 7737 | 8094 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 762 Fulton St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 100 | 3X3 | 6004211.6397 | 2111535.7715 | 37.7781128879326 | -122.428984591665 | (37.7781128879326, -122.428984591665) | |||
| 21343 | 21343 | 14358 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6002934.58534 | 2106677.65284 | 37.764701320838796 | -122.43305519326599 | (37.7647013208388, -122.433055193266) | |||
| 27348 | 27348 | 225835 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6010878.34698 | 2102482.51525 | 37.7536298057935 | -122.40528422380899 | (37.7536298057935, -122.405284223809) | |||
| 39523 | 39523 | 103291 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 50 Francisco St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6011052.07349 | 2121439.56361 | 37.8056911462811 | -122.406018820613 | (37.8056911462811, -122.406018820613) | |||
| 46467 | 46467 | 225824 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6011091.77167 | 2102559.41951 | 37.753852897909105 | -122.404551563217 | (37.7538528979091, -122.404551563217) | |||
| 52261 | 52261 | 247740 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 900 Waller St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6001271.06334 | 2108691.18463 | 37.770135479706 | -122.43895317566299 | (37.770135479706, -122.438953175663) | ||||
| 92924 | 92924 | 14535 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701X Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | City College 12 | 100 | 3X3 | 5999165.2663 | 2110445.36773 | 37.7748319828874 | -122.446363290435 | (37.7748319828874, -122.446363290435) | |||
| 101917 | 101917 | 107391 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002910.362819999 | 2106651.2793799997 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | |||||
| 102315 | 102315 | 21703 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1710X Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003481.65409 | 2114822.70407 | 37.7870966340846 | -122.431744616249 | (37.7870966340846, -122.431744616249) | |||
| 111363 | 111363 | 17997 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2650X Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001258.2893795 | 2114937.1034436002 | 37.7872844637831 | -122.43944515397101 | (37.7872844637831, -122.439445153971) | |||
| 129233 | 129233 | 225865 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 190 Coleridge St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 6006497.19455 | 2098745.86937 | 37.7431239076329 | -122.420170074782 | (37.7431239076329, -122.420170074782) | |||
| 129349 | 129349 | 169 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 185X Noe St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 6X6 | 6002905.5013881 | 2107191.4781257 | 37.7661105103373 | -122.433192503539 | (37.7661105103373, -122.433192503539) | |||
| 130986 | 130986 | 141794 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1280 WEBSTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6003796.2839 | 2113010.6813 | 37.7821391040008 | -122.43052672386001 | (37.7821391040008, -122.43052672386) | |||
| 133476 | 133476 | 143474 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 676 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6010614.9102 | 2116239.469 | 37.791388495056204 | -122.407164909629 | (37.7913884950562, -122.407164909629) | |||
| 147706 | 147706 | 140251 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 709 Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 5999178.3085 | 2110310.1412 | 37.7744614302846 | -122.446308445103 | (37.7744614302846, -122.446308445103) | |||
| 149846 | 149846 | 139229 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1401 WEBSTER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6003620.1786 | 2113551.815 | 37.78361494385479 | -122.43117460516198 | (37.7836149438548, -122.431174605162) | |||
| 157847 | 157847 | 138433 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1601 Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003506.0814 | 2114378.5595 | 37.785878509884796 | -122.431628381871 | (37.7858785098848, -122.431628381871) | |||
| 167366 | 167366 | 246264 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2298 Noe St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6002930.8432 | 2106681.6365 | 37.76471204673471 | -122.433068420975 | (37.7647120467347, -122.433068420975) | |||
| 187742 | 187742 | 138098 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1720 Webster St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003547.1807 | 2114720.4636 | 37.786819621724206 | -122.43151060705799 | (37.7868196217242, -122.431510607058) |
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");