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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12076 | 12076 | 17583 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6003749.1517199995 | 2090342.6567099998 | 37.7198953544779 | -122.429073052804 | (37.7198953544779, -122.429073052804) | |||
| 14760 | 14760 | 91037 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1051X Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010705.7086 | 2111246.6708 | 37.7776845332645 | -122.40649877417499 | (37.7776845332645, -122.406498774175) | ||
| 45247 | 45247 | 32993 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 666 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 3 | Permit Number 37299 | 6013060.48706 | 2113590.00605 | 37.7842502474912 | -122.398517212115 | (37.7842502474912, -122.398517212115) | |
| 46868 | 46868 | 141760 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 10 HOLLIS ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003934.4308 | 2113424.6033 | 37.783283455356795 | -122.430078335144 | (37.7832834553568, -122.430078335144) | |||
| 47086 | 47086 | 141782 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1441 Ellis St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003950.7038 | 2113181.9456 | 37.782618099550604 | -122.430004721615 | (37.7826180995506, -122.430004721615) | |||
| 57062 | 57062 | 198499 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1215 Michigan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6016506.220509999 | 2102490.10595 | 37.753963688078706 | -122.38582213748 | (37.7539636880787, -122.38582213748) | |||
| 64547 | 64547 | 198587 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013654.04555 | 2107139.63113 | 37.7665720240075 | -122.396011512024 | (37.7665720240075, -122.396011512024) | |||
| 72757 | 72757 | 198439 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 500 Mariposa St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6015495.11625 | 2106291.74793 | 37.7643461794683 | -122.38958429568399 | (37.7643461794683, -122.389584295684) | |||
| 95377 | 95377 | 17954 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2475 Pine St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002112.5991001 | 2115004.8317446 | 37.787519010566704 | -122.43649427747101 | (37.7875190105667, -122.436494277471) | |||
| 110060 | 110060 | 16424 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1390X Newcomb Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016384.44159 | 2094872.70878 | 37.7330411346315 | -122.38571240580299 | (37.7330411346315, -122.385712405803) | |||
| 116270 | 116270 | 31072 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1700X 15th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34816 | 6005529.95864507 | 2107274.01239209 | 37.7664856587307 | -122.424120885174 | (37.7664856587307, -122.424120885174) | ||
| 119541 | 119541 | 108234 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 131 RUSS ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6010302.0 | 2111707.0 | 37.7789258960759 | -122.407927816208 | (37.7789258960759, -122.407927816208) | ||||
| 121043 | 121043 | 97838 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
| 140297 | 140297 | 16444 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | |||
| 154001 | 154001 | 242558 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2355 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008208.121719999 | 2104777.36989 | 37.7597813034931 | -122.41468087292499 | (37.7597813034931, -122.414680872925) | |||
| 160806 | 160806 | 242483 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2675 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6008307.6947 | 2102932.59061 | 37.75472155396079 | -122.41420597784901 | (37.7547215539608, -122.414205977849) | |||
| 163849 | 163849 | 138411 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2445 PINE ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6002152.1984 | 2115012.2116 | 37.7875415238713 | -122.436357800436 | (37.7875415238713, -122.436357800436) | |||
| 168976 | 168976 | 180538 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 430 Wayland St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6010266.12531 | 2092269.81 | 37.7255536693496 | -122.40668177206899 | (37.7255536693496, -122.406681772069) | |||
| 178732 | 178732 | 198681 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 Russ St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010294.844330001 | 2111624.8311799997 | 37.778699879144796 | -122.40794677462401 | (37.7786998791448, -122.407946774624) | |||
| 179497 | 179497 | 242503 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2618 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6008245.42572 | 2102971.97718 | 37.754826202679205 | -122.414424108384 | (37.7548262026792, -122.414424108384) | |||
| 183730 | 183730 | 137017 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2700 Pacific Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6001093.24038 | 2116921.57925 | 37.79272392512 | -122.440158546893 | (37.79272392512, -122.440158546893) |
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");