Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantDate, DBH, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||
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) | |
8186 | 8186 | 35487 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770253 | 6000866.3431 | 2114483.9624 | 37.7860179417845 | -122.440768684557 | (37.7860179417845, -122.440768684557) | |
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) | |||
11227 | 11227 | 114871 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 539 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 3 | 3x3 | 6003469.271369999 | 2090174.15825 | 37.7194168476851 | -122.430028488037 | (37.7194168476851, -122.430028488037) | ||
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) | ||
22936 | 22936 | 104688 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770253 | 6000851.7 | 2114462.1 | 37.7859570793449 | -122.440817776746 | (37.7859570793449, -122.440817776746) | |
41362 | 41362 | 81620 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1516 Felton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/08/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52473 | 6006483.0681300005 | 2092558.4106599998 | 37.726133716789796 | -122.419779974986 | (37.7261337167898, -122.419779974986) | |
81230 | 81230 | 103729 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2331 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008229.6 | 2104850.4 | 37.759983034143296 | -122.414611757947 | (37.7599830341433, -122.414611757947) | ||
81448 | 81448 | 85872 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2380 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2007 12:00:00 AM | 3 | 3x3 | 6008166.0 | 2104564.0 | 37.759193072031294 | -122.41481145075399 | (37.7591930720313, -122.414811450754) | ||
81541 | 81541 | 85772 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1585 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6008240.0 | 2108862.0 | 37.770998540951794 | -122.41485971180599 | (37.7709985409518, -122.414859711806) | ||
84080 | 84080 | 116788 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 530 CRESCENT AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6007719.0 | 2095661.0 | 37.7347223035732 | -122.415727003996 | (37.7347223035732, -122.415727003996) | |||
86085 | 86085 | 103749 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1675 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008074.4 | 2108475.6 | 37.76992827096289 | -122.415405169405 | (37.7699282709629, -122.415405169405) | ||
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) | ||
94092 | 94092 | 88649 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 135 Fillmore St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778385 | 6003732.7 | 2108890.4 | 37.7708222270411 | -122.43045261886999 | (37.7708222270411, -122.43045261887) | ||
95999 | 95999 | 122427 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770253 | 6000851.7 | 2114462.1 | 37.7859570793449 | -122.440817776746 | (37.7859570793449, -122.440817776746) | |
97542 | 97542 | 122425 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770253 | 6000851.7 | 2114462.1 | 37.7859570793449 | -122.440817776746 | (37.7859570793449, -122.440817776746) | |
100388 | 100388 | 103748 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1675 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008074.4 | 2108475.6 | 37.76992827096289 | -122.415405169405 | (37.7699282709629, -122.415405169405) | ||
101883 | 101883 | 122422 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770253 | 6000851.7 | 2114462.1 | 37.7859570793449 | -122.440817776746 | (37.7859570793449, -122.440817776746) | |
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) | ||||
109170 | 109170 | 95393 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 3965 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767262 | 6004412.0 | 2100353.0 | 37.747419006534 | -122.427494591738 | (37.747419006534, -122.427494591738) | |
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) | ||
112363 | 112363 | 83897 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 177 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2008 12:00:00 AM | 3x3 | Permit Number 50522 | 6001329.15000051 | 2093174.60526977 | 37.727533957839896 | -122.437640847728 | (37.7275339578399, -122.437640847728) | ||
114824 | 114824 | 122426 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770253 | 6000851.7 | 2114462.1 | 37.7859570793449 | -122.440817776746 | (37.7859570793449, -122.440817776746) | |
114998 | 114998 | 81136 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 4657 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/06/2012 12:00:00 AM | 3x3 | Permit Number 768983 | 6000147.95764033 | 2105151.97717561 | 37.7603537323491 | -122.442583825347 | (37.7603537323491, -122.442583825347) | |
116171 | 116171 | 103730 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2315 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008264.6 | 2104925.3 | 37.7601906586786 | -122.41449600953501 | (37.7601906586786, -122.414496009535) | ||
116680 | 116680 | 108833 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 79 Ney St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774661 | 6003925.191380001 | 2094039.50832 | 37.7300560527634 | -122.42872794360301 | (37.7300560527634, -122.428727943603) | |
117274 | 117274 | 85873 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2394 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2007 12:00:00 AM | 3 | 3x3 | 6008197.0 | 2104472.0 | 37.7589422028837 | -122.414697726814 | (37.7589422028837, -122.414697726814) | ||
117501 | 117501 | 98852 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 64 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2012 12:00:00 AM | 3x3 | Permit Number 768793 | 6002914.9 | 2108659.2 | 37.770141048876 | -122.43326488117901 | (37.770141048876, -122.433264881179) | ||
118874 | 118874 | 103742 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2021 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008130.3 | 2106612.8 | 37.7648165983937 | -122.415079938624 | (37.7648165983937, -122.415079938624) | ||
119372 | 119372 | 87185 | DPW Maintained 3 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1245 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2008 12:00:00 AM | 3x3 | Permit Number 50187 | 5999399.3 | 2108538.0 | 37.7696081992395 | -122.445416546032 | (37.7696081992395, -122.445416546032) | ||
119670 | 119670 | 122424 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770253 | 6000851.7 | 2114462.1 | 37.7859570793449 | -122.440817776746 | (37.7859570793449, -122.440817776746) | |
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) | |||
124602 | 124602 | 95382 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 4317 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767252 | 6001161.0 | 2101705.0 | 37.75094686177329 | -122.43883317496099 | (37.7509468617733, -122.438833174961) | |
127384 | 127384 | 103750 | Permitted Site 1 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1665 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008126.9 | 2108535.0 | 37.770094320073596 | -122.41522777783301 | (37.7700943200736, -122.415227777833) | ||
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) | ||
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) | ||
138619 | 138619 | 110252 | Undocumented 2 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 1514 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774936 | 6002531.9 | 2101059.9 | 37.749253468980896 | -122.434046366801 | (37.7492534689809, -122.434046366801) | |
139186 | 139186 | 122423 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770253 | 6000851.7 | 2114462.1 | 37.7859570793449 | -122.440817776746 | (37.7859570793449, -122.440817776746) | |
142253 | 142253 | 122428 | Planning Code 138.1 required 4 | Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 69 | 2655 Bush St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/31/2016 12:00:00 AM | 3 | 3x3 | Permit Number 770253 | 6000851.7 | 2114462.1 | 37.7859570793449 | -122.440817776746 | (37.7859570793449, -122.440817776746) | |
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) | ||
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) |
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");