Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo, PlantDate, DBH, PlotSize, PermitNotes, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2114 | 2114 | 107983 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 2405x Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6001231.007069999 | 2116743.47753 | 37.7922427464694 | -122.43966909537599 | (37.7922427464694, -122.439669095376) | |||
| 29261 | 29261 | 105753 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 3636 Buchanan St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/21/2014 12:00:00 AM | 13 | Permit Number 771077 | 6003146.89414 | 2120799.57812 | 37.803488607670296 | -122.433330062032 | (37.8034886076703, -122.433330062032) | ||
| 39637 | 39637 | 101740 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1590 Broadway | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/21/2012 12:00:00 AM | 10 | Permit Number 769428 | 6006182.95151 | 2117984.64817 | 37.7959312951427 | -122.42262348648998 | (37.7959312951427, -122.42262348649) | ||
| 58626 | 58626 | 101743 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1590 Broadway | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/21/2012 12:00:00 AM | 12 | Permit Number 769428 | 6006129.33795 | 2117976.30804 | 37.795905370388205 | -122.422808406898 | (37.7959053703882, -122.422808406898) | ||
| 69736 | 69736 | 99191 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1155@Sansome Battery St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | Plaza | Permit Number 768022 | 6012232.15659 | 2120086.23158 | 37.8020411569217 | -122.401839756495 | (37.8020411569217, -122.401839756495) | ||
| 84041 | 84041 | 114392 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 104x TAPIA DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10 | 5988688.0 | 2090939.0 | 37.72066869526729 | -122.481177253578 | (37.7206686952673, -122.481177253578) | ||||
| 93355 | 93355 | 111359 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1637 OAK ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x15 | 5999143.0 | 2109364.0 | 37.771861551181395 | -122.44636250519699 | (37.7718615511814, -122.446362505197) | ||||
| 93602 | 93602 | 111358 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1637 OAK ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x15 | 5999143.0 | 2109364.0 | 37.771861551181395 | -122.44636250519699 | (37.7718615511814, -122.446362505197) | ||||
| 95855 | 95855 | 112250 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 243 WINSTON DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990059.0 | 2093141.0 | 37.726794444209396 | -122.47659897114599 | (37.7267944442094, -122.476598971146) | ||||
| 99634 | 99634 | 99847 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 850@14th Ave Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5991942.0 | 2105939.0 | 37.7620435090796 | -122.47102148161501 | (37.7620435090796, -122.471021481615) | |||||
| 117806 | 117806 | 110559 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 320x FULTON ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x36 | 6006080.0 | 2112015.0 | 37.7795343118474 | -122.422555311635 | (37.7795343118474, -122.422555311635) | ||||
| 119616 | 119616 | 110560 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 320x FULTON ST | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x36 | 6006080.0 | 2112015.0 | 37.7795343118474 | -122.422555311635 | (37.7795343118474, -122.422555311635) | ||||
| 125203 | 125203 | 114389 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 345x ARBALLO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5988176.0 | 2090635.0 | 37.7198042094326 | -122.48292478788 | (37.7198042094326, -122.48292478788) | ||||
| 144015 | 144015 | 108197 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 930 FLORIDA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009368.6 | 2103733.3 | 37.7569796561067 | -122.410593604092 | (37.7569796561067, -122.410593604092) | |||||
| 150859 | 150859 | 106257 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X 18th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Permit Number 770844 | 6011994.4738300005 | 2105627.58235 | 37.762327804017296 | -122.401645425613 | (37.7623278040173, -122.401645425613) | |||
| 151501 | 151501 | 98241 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 3760 Washington St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/10/2012 12:00:00 AM | 9 | Permit Number 768462 | 5996814.4677800005 | 2115674.0493799997 | 37.7890540175629 | -122.45487301496999 | (37.7890540175629, -122.45487301497) | ||
| 155517 | 155517 | 101742 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1590 Broadway | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12/21/2012 12:00:00 AM | 8 | Permit Number 769428 | 6006220.9946099995 | 2117990.3045099997 | 37.7959489722299 | -122.422492252021 | (37.7959489722299, -122.422492252021) | ||
| 179146 | 179146 | 106256 | Significant Tree 6 | Platanus x hispanica :: Sycamore: London Plane 15 | 1900X 18th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Permit Number 770844 | 6012014.62334 | 2105627.65597 | 37.7623291305193 | -122.401575740746 | (37.7623291305193, -122.401575740746) |
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");