Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1199 | 1199 | 119799 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110122.0 | 6005581.0 | 47.2699969117914 | -138.280716869623 | (47.2699969117914, -138.280716869623) | |||||
1223 | 1223 | 119752 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
1230 | 1230 | 119834 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
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) | ||
38215 | 38215 | 244396 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 4 | Width 0ft | 6005626.4733 | 2110143.3671 | 37.7743696669954 | -122.42399112385799 | (37.7743696669954, -122.423991123858) | |||
41607 | 41607 | 198633 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | 6015806.0947900005 | 2108744.2847599997 | 37.771097550144404 | -122.388679914958 | (37.7710975501444, -122.388679914958) | ||||
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) | |||
57322 | 57322 | 198607 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 456 Mission Bay Blvd South | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6016227.74089 | 2108648.22285 | 37.7708571442621 | -122.387214711603 | (37.7708571442621, -122.387214711603) | ||||
57780 | 57780 | 246553 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 20x Octavia St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6005726.464930001 | 2109532.06592 | 37.7726968262309 | -122.42360176272699 | (37.7726968262309, -122.423601762727) | |||
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) | |||
69313 | 69313 | 198648 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 421 Mission Bay Blvd North | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6016263.67679 | 2108770.7838 | 37.77119565988 | -122.387098957165 | (37.77119565988, -122.387098957165) | ||||
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) | |||
72795 | 72795 | 198459 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 700 Mariposa St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 6014889.29769 | 2106275.30651 | 37.7642674249283 | -122.391678519967 | (37.7642674249283, -122.391678519967) | |||
75717 | 75717 | 246541 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | Width 8ft | 6005680.0153 | 2109440.15852 | 37.772441848655795 | -122.423755901126 | (37.7724418486558, -122.423755901126) | |||
76593 | 76593 | 244327 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 100x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005673.3426 | 2109802.5573 | 37.773436531636 | -122.42380475570499 | (37.773436531636, -122.423804755705) | |||
76836 | 76836 | 198488 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 6ft | 6015206.153 | 2104497.9394400003 | 37.75940474205 | -122.39045839985799 | (37.75940474205, -122.390458399858) | |||
83700 | 83700 | 109168 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||
84832 | 84832 | 119681 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2x Octavia St Frontage East | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109501.0 | 6005733.0 | 47.2700833275765 | -138.283252028036 | (47.2700833275765, -138.283252028036) | |||||
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) | |||||
138143 | 138143 | 244478 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 201x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005577.5911 | 2110096.7762 | 37.7742389797832 | -122.424156902562 | (37.7742389797832, -122.424156902562) | |||
139301 | 139301 | 119823 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
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) | |||
145037 | 145037 | 119787 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
145232 | 145232 | 119714 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
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) | |||
156847 | 156847 | 201912 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1751 Yosemite Ave | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013819.77778 | 2093207.08272 | 37.7283254167788 | -122.394462603388 | (37.7283254167788, -122.394462603388) | |||
157331 | 157331 | 198579 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 425 01st St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6014752.73718 | 2114197.7568900003 | 37.78601312194579 | -122.392705107773 | (37.7860131219458, -122.392705107773) | |||
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) | |||
161664 | 161664 | 244455 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005622.2998 | 2109777.2072 | 37.7733640447919 | -122.423979517231 | (37.7733640447919, -122.423979517231) | |||
163277 | 163277 | 198569 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 400 01st St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6014782.21142 | 2114125.62722 | 37.7858167073117 | -122.392598086644 | (37.7858167073117, -122.392598086644) | |||
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) | |||
166254 | 166254 | 198479 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 800 Minnesota St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6015200.24285 | 2104674.6699099997 | 37.759889678091 | -122.390491189139 | (37.759889678091, -122.390491189139) | |||
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) | |||
169025 | 169025 | 244305 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005579.7947 | 2110490.7532 | 37.775320869598204 | -122.424177304818 | (37.7753208695982, -122.424177304818) | |||
174240 | 174240 | 244360 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005525.0257 | 2110428.4298 | 37.7751466521023 | -122.424362329876 | (37.7751466521023, -122.424362329876) | |||
175303 | 175303 | 198618 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015853.85549 | 2108626.75005 | 37.770777472424996 | -122.38850650226802 | (37.770777472425, -122.388506502268) | ||||
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) | |||
188835 | 188835 | 200601 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1300x Newcomb Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6016439.2859 | 2094833.5580000002 | 37.7329366690371 | -122.385520065311 | (37.7329366690371, -122.385520065311) |
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");