Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlantDate, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78847 | 78847 | 91259 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 952x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005689.43944 | 2103423.018644 | 37.755920739203 | -122.423295489065 | (37.755920739203, -122.423295489065) | ||
| 80089 | 80089 | 91264 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 978X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005697.5214949995 | 2103276.567378 | 37.7555190742141 | -122.423257128608 | (37.7555190742141, -122.423257128608) | ||
| 87711 | 87711 | 91236 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 804 Guerrero St | 1 | Median : 22 | Tree 1 | DPW 2 | 11/20/2009 12:00:00 AM | 3 | 3x100 | 6005614.0 | 2104300.0 | 37.758324467407704 | -122.423618732861 | (37.7583244674077, -122.423618732861) | ||
| 101466 | 101466 | 91258 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 948x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005688.196047001 | 2103445.549621 | 37.755982533848794 | -122.423301390711 | (37.7559825338488, -122.423301390711) | ||
| 108090 | 108090 | 91255 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 940x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005685.709261 | 2103490.611554 | 37.75610612308 | -122.423313194032 | (37.75610612308, -122.423313194032) | ||
| 111105 | 111105 | 91265 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 986x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005700.008282 | 2103231.505425 | 37.7553954849101 | -122.423245325469 | (37.7553954849101, -122.423245325469) | ||
| 111602 | 111602 | 91252 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 908x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005675.762116 | 2103670.859284 | 37.7566004799608 | -122.42336040770901 | (37.7566004799608, -122.423360407709) | ||
| 111728 | 111728 | 91263 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 970x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005695.03471 | 2103321.62929 | 37.7556426634019 | -122.42326893177601 | (37.7556426634019, -122.423268931776) | ||
| 128795 | 128795 | 91254 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 928x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005681.9790819995 | 2103558.204453 | 37.7562915069181 | -122.423330899086 | (37.7562915069181, -122.423330899086) | ||
| 141128 | 141128 | 91251 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 906X Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005675.14042 | 2103682.124768 | 37.756631377266295 | -122.42336335858299 | (37.7566313772663, -122.423363358583) | ||
| 118503 | 118503 | 91256 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 940X Guerrero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 3x100 | 6005685.709261 | 2103490.611554 | 37.75610612308 | -122.423313194032 | (37.75610612308, -122.423313194032) |
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");