Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9711 | 9711 | 1086 | DPW Maintained 3 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 257 | 2162 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 5999946.202959999 | 2089791.38405 | 37.7181656785377 | -122.442178933209 | (37.7181656785377, -122.442178933209) | |||
| 81502 | 81502 | 107995 | Undocumented 2 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 257 | 907 Minnesota St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/12/2014 12:00:00 AM | 3 | 6x11 | Permit Number 774103 | 6015290.10173 | 2104424.8547900002 | 37.7592087238569 | -122.39016295569598 | (37.7592087238569, -122.390162955696) | ||
| 84900 | 84900 | 102201 | Permitted Site 1 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 257 | 442 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2013 12:00:00 AM | 3 | 3x3 | Permit Number 769775 | 6002908.2 | 2105655.8 | 37.7618940636715 | -122.433073438645 | (37.7618940636715, -122.433073438645) |
| 88181 | 88181 | 78196 | Permitted Site 1 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 257 | 130 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2009 12:00:00 AM | 3x3 | Permit Number 52582 | 6007025.13106895 | 2098703.78217433 | 37.743038078306 | -122.41834162381001 | (37.743038078306, -122.41834162381) | ||
| 91936 | 91936 | 94881 | Permitted Site 1 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 257 | 1590x MCKINNON AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53948 | 6015457.0 | 2095933.0 | 37.7359011166528 | -122.38899284571501 | (37.7359011166528, -122.388992845715) | |
| 99621 | 99621 | 82742 | Permitted Site 1 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 257 | 207 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52434 | 6008814.37056405 | 2110286.91631719 | 37.774943283624296 | -122.412973704517 | (37.7749432836243, -122.412973704517) | |
| 109043 | 109043 | 95840 | Permitted Site 1 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 257 | 2 Sheridan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767567 | 6009435.1 | 2109579.3 | 37.7730351591854 | -122.410776475157 | (37.7730351591854, -122.410776475157) | |
| 111187 | 111187 | 95838 | Permitted Site 1 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 257 | 2 Sheridan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767567 | 6009435.1 | 2109579.3 | 37.7730351591854 | -122.410776475157 | (37.7730351591854, -122.410776475157) | |
| 113813 | 113813 | 82986 | Permitted Site 1 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 257 | 130 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2009 12:00:00 AM | 3x3 | Permit Number 52582 | 6007025.13106895 | 2098703.78217433 | 37.743038078306 | -122.41834162381001 | (37.743038078306, -122.41834162381) | ||
| 116809 | 116809 | 28788 | Permitted Site 1 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 257 | 2948 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/02/2005 12:00:00 AM | 3 | 3X3 | 6008327.76166 | 2101276.4844400003 | 37.7501753870711 | -122.41401942877899 | (37.7501753870711, -122.414019428779) | ||
| 118598 | 118598 | 44029 | Permitted Site 1 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 257 | 96 Lafayette St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2000 12:00:00 AM | Permit Number 43568 | 6007789.10415303 | 2109389.65553955 | 37.7724220125921 | -122.416456760011 | (37.7724220125921, -122.416456760011) | |||
| 125922 | 125922 | 94880 | Permitted Site 1 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 257 | 1590x MCKINNON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/23/2010 12:00:00 AM | 3x3 | Permit Number 53948 | 6015457.0 | 2095933.0 | 37.7359011166528 | -122.38899284571501 | (37.7359011166528, -122.388992845715) | |
| 126443 | 126443 | 7478 | DPW Maintained 3 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 257 | 2650X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/23/2007 12:00:00 AM | 3 | 3x3 | 6008254.1361302 | 2102990.9843832003 | 37.7548788814664 | -122.414395330099 | (37.7548788814664, -122.414395330099) | ||
| 126768 | 126768 | 95839 | Permitted Site 1 | Ulmus parvifolia 'Sempervirens' :: Weeping Chinese Elm 257 | 2 Sheridan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/29/2011 12:00:00 AM | 3x3 | Permit Number 767567 | 6009435.1 | 2109579.3 | 37.7730351591854 | -122.410776475157 | (37.7730351591854, -122.410776475157) |
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");