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 ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 99838 | 99838 | 85776 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1425 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2015 11:16:00 AM | 3 | 3x3 | 6008757.0 | 2109407.0 | 37.772524019699 | -122.413109930192 | (37.772524019699, -122.413109930192) | ||
| 90626 | 90626 | 69599 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 366 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/2014 12:00:00 AM | 3 | Permit Number 773624 | 6004805.18148758 | 2109878.85249056 | 37.7735969721496 | -122.42681328543001 | (37.7735969721496, -122.42681328543) | |
| 15103 | 15103 | 85784 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1257 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/09/2015 11:19:00 AM | 3 | 3x3 | 6009427.6278 | 2110025.2513 | 37.7742592182749 | -122.410833824093 | (37.7742592182749, -122.410833824093) | ||
| 82663 | 82663 | 85791 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1101X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6010323.0 | 2110925.0 | 37.776779882708205 | -122.407800012097 | (37.7767798827082, -122.407800012097) | ||
| 129479 | 129479 | 112783 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 506 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2015 12:00:00 AM | Permit Number 774416 | 5992870.4 | 2111974.5 | 37.7786690335249 | -122.468249618869 | (37.7786690335249, -122.468249618869) | |||
| 111578 | 111578 | 85758 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 984 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011059.0 | 2111650.0 | 37.7788117396287 | -122.40530502246901 | (37.7788117396287, -122.405305022469) | ||
| 13595 | 13595 | 85796 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 975 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2014 12:00:00 AM | 3 | 3x3 | 6011171.3417 | 2111690.3951 | 37.778928935443204 | -122.404919231111 | (37.7789289354432, -122.404919231111) | ||
| 84955 | 84955 | 85798 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 965 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011205.0 | 2111745.0 | 37.7790807491546 | -122.404806638376 | (37.7790807491546, -122.404806638376) | ||
| 101326 | 101326 | 85800 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 935 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | Permit Number 768011 | 6011398.0 | 2111930.0 | 37.7795995018672 | -122.404151992929 | (37.7795995018672, -122.404151992929) | |
| 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) | |
| 99536 | 99536 | 85808 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 901X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011628.490476 | 2112144.478567 | 37.780201286185104 | -122.40336971541402 | (37.7802012861851, -122.403369715414) | ||
| 107666 | 107666 | 85746 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 900 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6011609.0 | 2112176.0 | 37.78028674810621 | -122.403439360525 | (37.7802867481062, -122.403439360525) | ||
| 104550 | 104550 | 85745 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 880 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 6 | 3x3 | 6011737.0 | 2112298.0 | 37.7806288802706 | -122.403005130314 | (37.7806288802706, -122.403005130314) | ||
| 145445 | 145445 | 85742 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 816 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6012158.0 | 2112700.0 | 37.7817561793381 | -122.40157694342501 | (37.7817561793381, -122.401576943425) | ||
| 160833 | 160833 | 120786 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 253 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5989295.33642 | 2113646.62963 | 37.78305310452279 | -122.480739452185 | (37.7830531045228, -122.480739452185) | |||
| 3858 | 3858 | 35488 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | Permit Number 770253 | 6000772.5656 | 2114469.8149 | 37.7859737553806 | -122.441092113094 | (37.7859737553806, -122.441092113094) | ||
| 44188 | 44188 | 101645 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2609 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/08/2013 12:00:00 AM | 3x3 | 6001467.0 | 2114916.0 | 37.787238394783394 | -122.438721548179 | (37.7872383947834, -122.438721548179) | |||
| 104712 | 104712 | 117585 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 3100X FILLMORE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002493.0 | 2118872.0 | 37.7981588656011 | -122.435454914846 | (37.7981588656011, -122.435454914846) |
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");