Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1192 | 1192 | 119753 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
1209 | 1209 | 119800 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
1395 | 1395 | 251525 | Planning Code 138.1 required 4 | Ulmus parvifolia :: Chinese Elm 46 | 173 Sanchez St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x15 | 6003549.6097 | 2107381.8851 | 37.7666698392386 | -122.430978251884 | (37.7666698392386, -122.430978251884) | ||||
12305 | 12305 | 17584 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 18 | 3x3 | 6003740.32149 | 2090358.06458 | 37.7199371612464 | -122.42910467385201 | (37.7199371612464, -122.429104673852) | |||
26146 | 26146 | 136958 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2900 Divisadero St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6000568.04629 | 2118355.71273 | 37.7966317645105 | -122.44207872445801 | (37.7966317645105, -122.442078724458) | |||
31383 | 31383 | 244306 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6005576.9618 | 2110512.9441 | 37.7753816404734 | -122.42418868303001 | (37.7753816404734, -122.42418868303) | |||
33227 | 33227 | 244397 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005625.7095 | 2110167.0444 | 37.7744346360097 | -122.423995450078 | (37.7744346360097, -122.423995450078) | |||
36542 | 36542 | 242484 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2675 Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6008307.71975 | 2102954.44615 | 37.7547815657263 | -122.41420743741699 | (37.7547815657263, -122.414207437417) | |||
39318 | 39318 | 141761 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 10 HOLLIS ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6003925.4266 | 2113468.4989 | 37.7834034717338 | -122.430112618538 | (37.7834034717338, -122.430112618538) | |||
42055 | 42055 | 198588 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013599.812609999 | 2107136.62549 | 37.766560753709 | -122.396198884879 | (37.766560753709, -122.396198884879) | |||
43669 | 43669 | 246542 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 9 | Width 8ft | 6005675.49099 | 2109463.50167 | 37.772505687922 | -122.42377321126001 | (37.772505687922, -122.42377321126) | |||
46612 | 46612 | 198480 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 800 Minnesota St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 6015199.5579 | 2104656.07032 | 37.759838569617706 | -122.39049225842501 | (37.7598385696177, -122.390492258425) | |||
51495 | 51495 | 244361 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005527.8586 | 2110404.3503 | 37.7750806956038 | -122.424350817202 | (37.7750806956038, -122.424350817202) | |||
52590 | 52590 | 198500 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1215 Michigan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6016504.90448 | 2102523.10402 | 37.754054221042 | -122.385828988529 | (37.754054221042, -122.385828988529) | |||
53601 | 53601 | 17955 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2475 Pine St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002112.5991001 | 2115004.8317446 | 37.787519010566704 | -122.43649427747101 | (37.7875190105667, -122.436494277471) | |||
54065 | 54065 | 198460 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 700 Mariposa St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 6014862.84066 | 2106274.78772 | 37.7642645317963 | -122.391769991798 | (37.7642645317963, -122.391769991798) | |||
56371 | 56371 | 141783 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1439 Ellis St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003973.4218 | 2113184.0589 | 37.7826251887217 | -122.42992627788999 | (37.7826251887217, -122.42992627789) | |||
57498 | 57498 | 138412 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2445 PINE ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002175.9998 | 2115015.7118 | 37.7875524868912 | -122.436275703068 | (37.7875524868912, -122.436275703068) | |||
59755 | 59755 | 198619 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6015825.0595 | 2108624.79715 | 37.770770514383 | -122.388605972695 | (37.770770514383, -122.388605972695) | ||||
61149 | 61149 | 96876 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2100X San Jose Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999221.1 | 2091561.9 | 37.7229857575378 | -122.444812491923 | (37.7229857575378, -122.444812491923) | |||||
66243 | 66243 | 198440 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 500 Mariposa St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6015476.913319999 | 2106290.58138 | 37.7643419670439 | -122.38964717358401 | (37.7643419670439, -122.389647173584) | |||
68449 | 68449 | 244328 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005669.917 | 2109835.444 | 37.7735266371926 | -122.423818944241 | (37.7735266371926, -122.423818944241) | |||
77605 | 77605 | 108235 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 131 RUSS ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6010302.0 | 2111707.0 | 37.7789258960759 | -122.407927816208 | (37.7789258960759, -122.407927816208) | ||||
83765 | 83765 | 97839 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.39039007649099 | (37.757949869225, -122.390390076491) | |||||
84045 | 84045 | 17925 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2397X Pine St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002488.019783099 | 2115056.9941341 | 37.787683560918495 | -122.435199131446 | (37.7876835609185, -122.435199131446) | |||
84934 | 84934 | 119788 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
93091 | 93091 | 119824 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
107627 | 107627 | 16425 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1390X Newcomb Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016278.2308330005 | 2094877.1898669999 | 37.733047561100896 | -122.386079920066 | (37.7330475611009, -122.386079920066) | |||
109710 | 109710 | 7588 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 3000X Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 6008378.51714 | 2100951.63552 | 37.7492862752884 | -122.41382093686701 | (37.7492862752884, -122.413820936867) | |||
113138 | 113138 | 119682 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x Octavia St Frontage East | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
121401 | 121401 | 109167 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||
131563 | 131563 | 198656 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1670 Owen St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 8ft | 6014014.86759 | 2107324.11249 | 37.7670986373305 | -122.394776403817 | (37.7670986373305, -122.394776403817) | |||
134544 | 134544 | 198608 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 456 Mission Bay Blvd South | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6016209.64695 | 2108646.95211 | 37.77085265305929 | -122.387277210877 | (37.7708526530593, -122.387277210877) | ||||
136228 | 136228 | 246554 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 8 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | Width 8ft | 6005723.73891 | 2109547.7321 | 37.772739687913706 | -122.423612306376 | (37.7727396879137, -122.423612306376) | |||
146043 | 146043 | 16445 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | ||
147997 | 147997 | 198649 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 421 Mission Bay Blvd North | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6016285.57372 | 2108771.35591 | 37.7711984432851 | -122.387023254046 | (37.7711984432851, -122.387023254046) | ||||
149024 | 149024 | 198634 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015830.835940001 | 2108747.07967 | 37.7711065955099 | -122.38859452883999 | (37.7711065955099, -122.38859452884) | ||||
149777 | 149777 | 244283 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005579.1186 | 2110077.6816 | 37.7741866368779 | -122.424150260413 | (37.7741866368779, -122.424150260413) | |||
155187 | 155187 | 244456 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005624.3552 | 2109760.7639 | 37.773319011501705 | -122.42397123777799 | (37.7733190115017, -122.423971237778) | |||
167338 | 167338 | 198570 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 400 01st St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 6ft | 6014790.57868 | 2114116.0189 | 37.7857907897446 | -122.392568465686 | (37.7857907897446, -122.392568465686) | |||
174425 | 174425 | 201913 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013833.24742 | 2093196.5259999998 | 37.728297178952204 | -122.394415299033 | (37.7282971789522, -122.394415299033) | |||
180569 | 180569 | 198489 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6015206.91645 | 2104475.31213 | 37.759342654666206 | -122.390454178415 | (37.7593426546662, -122.390454178415) | |||
184934 | 184934 | 198580 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 425 01st St | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6014742.64135 | 2114209.62608 | 37.7860451513037 | -122.392740867522 | (37.7860451513037, -122.392740867522) | |||
189066 | 189066 | 198682 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 149 Russ St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010265.525359999 | 2111657.0003299997 | 37.778786566576294 | -122.408050470058 | (37.7787865665763, -122.408050470058) |
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");