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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9067 | 9067 | 85664 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2774 FOLSOM ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/14/2007 12:00:00 AM | 3 | 5x5 | Permit Number 49691 | 6008274.0 | 2102260.0 | 37.7528728796483 | -122.414274918711 | (37.7528728796483, -122.414274918711) | |
| 9398 | 9398 | 116356 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2752 FOLSOM ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6008296.0 | 2102398.0 | 37.7532530322434 | -122.414208601119 | (37.7532530322434, -122.414208601119) | |||
| 128080 | 128080 | 96190 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2889 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2007 12:00:00 AM | 3 | 3x3 | 6008375.88429 | 2101615.45305 | 37.7511088214431 | -122.41387699241899 | (37.7511088214431, -122.413876992419) | ||
| 87880 | 87880 | 103725 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2899X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008379.2 | 2101559.4 | 37.7509550985774 | -122.41386156167499 | (37.7509550985774, -122.413861561675) | ||
| 110092 | 110092 | 85771 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1480 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008543.0 | 2109248.0 | 37.7720754271741 | -122.41383893105801 | (37.7720754271741, -122.413838931058) | ||
| 127683 | 127683 | 85770 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1480 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008543.0 | 2109248.0 | 37.7720754271741 | -122.41383893105801 | (37.7720754271741, -122.413838931058) | ||
| 145109 | 145109 | 98188 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1498X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6008543.0 | 2109248.0 | 37.7720754271741 | -122.41383893105801 | (37.7720754271741, -122.413838931058) | |||
| 143964 | 143964 | 96191 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2843 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2007 12:00:00 AM | 3 | 3x3 | 6008392.81566 | 2101883.12562 | 37.7518447409777 | -122.41383737404101 | (37.7518447409777, -122.413837374041) | ||
| 121518 | 121518 | 98189 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1498X Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6008828.0 | 2109520.0 | 37.7728382767515 | -122.412872323828 | (37.7728382767515, -122.412872323828) | |||
| 74986 | 74986 | 242783 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 3060 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009163.38905 | 2101022.2173 | 37.7495241236381 | -122.411111809067 | (37.7495241236381, -122.411111809067) | |||
| 14261 | 14261 | 85782 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1265 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/04/2014 03:09:00 PM | 8 | 3x3 | 6009372.4773 | 2109973.5478 | 37.7741141600547 | -122.411020947743 | (37.7741141600547, -122.411020947743) | ||
| 36292 | 36292 | 242782 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 3060 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009196.5579699995 | 2101026.42039 | 37.7495375244342 | -122.41099740631999 | (37.7495375244342, -122.41099740632) | |||
| 258 | 258 | 251259 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1050x Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009753.0 | 2116795.0 | 37.7928655753561 | -122.410186352148 | (37.7928655753561, -122.410186352148) | ||||
| 50861 | 50861 | 242785 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2730 22nd St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009778.64704 | 2103394.74604 | 37.7560730434384 | -122.409151611674 | (37.7560730434384, -122.409151611674) | |||
| 185851 | 185851 | 242784 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2730 22nd St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 7ft | 6009801.01572 | 2103396.12186 | 37.756078074246 | -122.409074350022 | (37.756078074246, -122.409074350022) | |||
| 361 | 361 | 85803 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 923 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778048 | 6011427.0378 | 2111936.1074 | 37.779617893816 | -122.40405196806002 | (37.779617893816, -122.40405196806) | |
| 394 | 394 | 85804 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 923 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/2017 12:00:00 AM | 3 | 3x3 | Permit Number 778048 | 6011441.4589 | 2111949.4191 | 37.7796552503769 | -122.404003016031 | (37.7796552503769, -122.404003016031) | |
| 39767 | 39767 | 137066 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 12 Filbert St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6012425.54206 | 2120223.78485 | 37.8024296352708 | -122.401180217987 | (37.8024296352708, -122.401180217987) | ||||
| 43013 | 43013 | 137065 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 11 Filbert St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6012521.25442 | 2120194.7201 | 37.8023551696124 | -122.40084696071399 | (37.8023551696124, -122.400846960714) |
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");