Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, qCareAssistant, PlantDate, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 67 | 67 | 166623 | Permitted Site 1 | Potential Site :: Potential Site 29 | 520 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 18521 | 6001647.24706 | 2101482.78936 | 37.7503643764264 | -122.437135780708 | (37.7503643764264, -122.437135780708) | |
| 938 | 938 | 251414 | Undocumented 2 | Potential Site :: Potential Site 29 | 10x Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2005 12:00:00 AM | 3x3 | 6009207.0 | 2112641.0 | 37.7814290728676 | -122.411781887248 | (37.7814290728676, -122.411781887248) | |||
| 947 | 947 | 251413 | Undocumented 2 | Potential Site :: Potential Site 29 | 10x Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2005 12:00:00 AM | 3x3 | 6009207.0 | 2112641.0 | 37.7814290728676 | -122.411781887248 | (37.7814290728676, -122.411781887248) | |||
| 967 | 967 | 251416 | Undocumented 2 | Potential Site :: Potential Site 29 | 10x Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009207.0 | 2112641.0 | 37.7814290728676 | -122.411781887248 | (37.7814290728676, -122.411781887248) | ||||
| 971 | 971 | 251415 | Undocumented 2 | Potential Site :: Potential Site 29 | 10x Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2005 12:00:00 AM | 3x3 | 6009207.0 | 2112641.0 | 37.7814290728676 | -122.411781887248 | (37.7814290728676, -122.411781887248) | |||
| 1937 | 1937 | 251785 | DPW Maintained 3 | Potential Site :: Potential Site 29 | 245 Lobos St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5994580.0 | 2088672.0 | 37.714784827932604 | -122.460646394253 | (37.7147848279326, -122.460646394253) | ||||
| 3317 | 3317 | 253413 | Undocumented 2 | Potential Site :: Potential Site 29 | 2433 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | Private 3 | 3x3 | 5989193.66308 | 2098780.80152 | 37.7422296590049 | -122.48000293550501 | (37.7422296590049, -122.480002935505) | |||
| 5209 | 5209 | 169218 | Permitted Site 1 | Potential Site :: Potential Site 29 | 824 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | 3x3 | 6006905.3054599995 | 2113639.6299099997 | 37.7840416758297 | -122.419815533287 | (37.7840416758297, -122.419815533287) | ||
| 5217 | 5217 | 169168 | Permitted Site 1 | Potential Site :: Potential Site 29 | 701 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | 3x3 | 6007051.56678 | 2113380.55802 | 37.7833385660552 | -122.41929113679599 | (37.7833385660552, -122.419291136796) | ||
| 5218 | 5218 | 169214 | Permitted Site 1 | Potential Site :: Potential Site 29 | 724 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | Width 4ft | 6007369.544319999 | 2113705.88387 | 37.7842497348906 | -122.41821413029301 | (37.7842497348906, -122.418214130293) | ||
| 5227 | 5227 | 169217 | Permitted Site 1 | Potential Site :: Potential Site 29 | 800 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | 3x3 | 6006932.37231 | 2113646.73425 | 37.7840627073778 | -122.41972239586501 | (37.7840627073778, -122.419722395865) | ||
| 5234 | 5234 | 169170 | Permitted Site 1 | Potential Site :: Potential Site 29 | 750 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | 3x3 | 6006877.9642199995 | 2113290.02776 | 37.7830802133315 | -122.419885308057 | (37.7830802133315, -122.419885308057) | ||
| 5238 | 5238 | 169219 | Permitted Site 1 | Potential Site :: Potential Site 29 | 840 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 0 | 3x3 | 6006827.36035 | 2113629.7400599997 | 37.7840101293977 | -122.42008449353001 | (37.7840101293977, -122.42008449353) | ||
| 9742 | 9742 | 610 | DPW Maintained 3 | Potential Site :: Potential Site 29 | 3105 24TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2009 12:00:00 AM | 3 | 3x3 | 6008244.0 | 2102074.0 | 37.752360480426205 | -122.414365505061 | (37.7523604804262, -122.414365505061) | ||
| 9753 | 9753 | 173669 | Permitted Site 1 | Potential Site :: Potential Site 29 | 1200X Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009203.67582999 | 2102144.49744393 | 37.7526079137784 | -122.41105175633601 | (37.7526079137784, -122.411051756336) | ||||
| 13272 | 13272 | 187624 | Undocumented 2 | Potential Site :: Potential Site 29 | 325 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991928.0 | 2097693.0 | 37.7394013212876 | -122.470469324928 | (37.7394013212876, -122.470469324928) | ||||
| 13277 | 13277 | 187623 | Undocumented 2 | Potential Site :: Potential Site 29 | 325 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991928.0 | 2097693.0 | 37.7394013212876 | -122.470469324928 | (37.7394013212876, -122.470469324928) | ||||
| 13305 | 13305 | 187653 | Undocumented 2 | Potential Site :: Potential Site 29 | 307 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992004.0 | 2097696.0 | 37.7394139526506 | -122.47020677123899 | (37.7394139526506, -122.470206771239) |
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");