Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24807 | 24807 | 199978 | Undocumented 2 | Betula spp :: Birch 95 | 1176 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6017205.7669 | 2092508.1354 | 37.726593894330705 | -122.382708354896 | (37.7265938943307, -122.382708354896) | |||
| 26440 | 26440 | 221264 | Undocumented 2 | Betula spp :: Birch 95 | 1 Church St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6004131.74855 | 2108500.27281 | 37.7697736293789 | -122.42904448133801 | (37.7697736293789, -122.429044481338) | |||
| 26457 | 26457 | 205617 | Undocumented 2 | Betula spp :: Birch 95 | 828 Foerster St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5998289.5702599995 | 2096474.9505900003 | 37.7364226309944 | -122.448386220344 | (37.7364226309944, -122.448386220344) | |||
| 31290 | 31290 | 221216 | Undocumented 2 | Betula spp :: Birch 95 | 350 Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004036.63734 | 2102173.24246 | 37.752395729983796 | -122.428922322819 | (37.7523957299838, -122.428922322819) | |||
| 46823 | 46823 | 114049 | Undocumented 2 | Betula spp :: Birch 95 | 1190 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 3x3 | 6017122.5886 | 2092569.8305 | 37.7267587013694 | -122.38300019404801 | (37.7267587013694, -122.383000194048) | ||
| 47416 | 47416 | 221223 | Undocumented 2 | Betula spp :: Birch 95 | 263 Upper Ter | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5999330.89237 | 2105950.16873 | 37.762498758842 | -122.445467058755 | (37.762498758842, -122.445467058755) | |||
| 59004 | 59004 | 221201 | Undocumented 2 | Betula spp :: Birch 95 | 84 Richland Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 2ft | 6005032.52935 | 2096155.14672 | 37.7359277331662 | -122.425050206297 | (37.7359277331662, -122.425050206297) | |||
| 60043 | 60043 | 221213 | Undocumented 2 | Betula spp :: Birch 95 | 381 Elizabeth St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003933.59101 | 2102143.29739 | 37.752307674663 | -122.429276538783 | (37.752307674663, -122.429276538783) | |||
| 66948 | 66948 | 91525 | Permitted Site 1 | Betula spp :: Birch 95 | 350 Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52129 | 6011425.5779 | 2106742.38308 | 37.7653570345305 | -122.403691477679 | (37.7653570345305, -122.403691477679) | |
| 131874 | 131874 | 221207 | Undocumented 2 | Betula spp :: Birch 95 | 144 Prospect Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006793.72845 | 2098662.88692 | 37.7429127603125 | -122.41913885277599 | (37.7429127603125, -122.419138852776) | |||
| 151116 | 151116 | 221209 | Undocumented 2 | Betula spp :: Birch 95 | 740 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008349.6086099995 | 2097665.71648 | 37.7402622469036 | -122.413688516938 | (37.7402622469036, -122.413688516938) | |||
| 155941 | 155941 | 122921 | Undocumented 2 | Betula spp :: Birch 95 | 166 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5992451.5223199995 | 2114364.2053900003 | 37.7852063091564 | -122.469872700188 | (37.7852063091564, -122.469872700188) |
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");