Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, qSiteInfo, qCaretaker, DBH, PlotSize, XCoord, YCoord, Latitude, Longitude, Location
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 95172 | 95172 | 100581 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Folsom St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | |||||
| 120847 | 120847 | 100625 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Folsom St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | |||||
| 168860 | 168860 | 97843 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 900 Minnesota St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6015209.9181699995 | 2104379.39414 | 37.7590794509666 | -122.39043709491399 | (37.7590794509666, -122.390437094914) | ||||
| 46975 | 46975 | 198638 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 419 Mission Bay Blvd North | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015910.558069999 | 2108750.53892 | 37.7711205116333 | -122.388319006239 | (37.7711205116333, -122.388319006239) | ||||
| 48814 | 48814 | 198592 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 980 16th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6013452.45897 | 2107129.35079 | 37.766532578853 | -122.396708048633 | (37.766532578853, -122.396708048633) | |||
| 56778 | 56778 | 198623 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 454 Mission Bay Blvd South | 12 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6015749.91564 | 2108621.24573 | 37.7707565982691 | -122.38886565105 | (37.7707565982691, -122.38886565105) | ||||
| 131321 | 131321 | 138394 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2445 PINE ST | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002278.9059 | 2115030.4127 | 37.7875986981409 | -122.435920721296 | (37.7875986981409, -122.435920721296) | |||
| 159657 | 159657 | 198444 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 500 Mariposa St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 6ft | 6015385.264330001 | 2106283.84094 | 37.7643183769187 | -122.38996369358802 | (37.7643183769187, -122.389963693588) | |||
| 172502 | 172502 | 242403 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 1201 Treat Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008707.95248 | 2101269.88955 | 37.75017862504279 | -122.412704235035 | (37.7501786250428, -122.412704235035) | |||
| 1201 | 1201 | 119839 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 301x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110475.0 | 6005532.0 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | |||||
| 1233 | 1233 | 119757 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109793.0 | 6005627.0 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | |||||
| 12573 | 12573 | 17588 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 801X Persia Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6003687.80932 | 2090380.0219599998 | 37.7199944786431 | -122.429287755146 | (37.7199944786431, -122.429287755146) | |||
| 40192 | 40192 | 246545 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1x Octavia St | 12 | Median : Yard 3 | Tree 1 | DPW 2 | 8 | Width 8ft | 6005664.26886 | 2109539.08097 | 37.7727125769595 | -122.423817404855 | (37.7727125769595, -122.423817404855) | |||
| 42949 | 42949 | 244310 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 300x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 0ft | 6005563.2696 | 2110605.957 | 37.77563625821271 | -122.424242664251 | (37.7756362582127, -122.424242664251) | |||
| 66611 | 66611 | 244468 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 101x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6005635.3174 | 2109670.3256 | 37.7730713086411 | -122.423926885709 | (37.7730713086411, -122.423926885709) | |||
| 110953 | 110953 | 119719 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 102x Octavia St Frontage East | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2109802.0 | 6005691.0 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | |||||
| 116938 | 116938 | 109163 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 6x Octavia St Frontage West | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x20 | 2109337.0 | 6005692.0 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||
| 122435 | 122435 | 119792 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 202x Octavia St Frontage East | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110143.0 | 6005643.0 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | |||||
| 122887 | 122887 | 16449 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1395 Newcomb Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/20/2008 12:00:00 AM | 12 | 3x3 | 6016285.996927 | 2094866.0167389999 | 37.733017311739104 | -122.386052291775 | (37.7330173117391, -122.386052291775) | ||
| 127815 | 127815 | 119816 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 302x Octavia St Frontage East | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 2110484.0 | 6005595.0 | 47.27021880585 | -138.279315979183 | (47.27021880585, -138.279315979183) | |||||
| 164108 | 164108 | 244401 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 200x Octavia St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6005612.7252 | 2110260.2263 | 37.7746897578806 | -122.424046993197 | (37.7746897578806, -122.424046993197) |
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");