Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 37277 | 37277 | 177144 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 224 Naylor St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6002612.15992 | 2086733.11082 | 37.709919907953704 | -122.43274552071001 | (37.7099199079537, -122.43274552071) | |||
| 59724 | 59724 | 227210 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 35 Powhattan Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6007580.30046 | 2098202.33291 | 37.7416924459422 | -122.416386483043 | (37.7416924459422, -122.416386483043) | |||
| 152082 | 152082 | 227211 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 225 Montcalm St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 23 | Width 3ft | 6009836.16533 | 2099585.28248 | 37.7456163229324 | -122.408683960589 | (37.7456163229324, -122.408683960589) | |||
| 158841 | 158841 | 177143 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 224 Naylor St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6002598.76646 | 2086748.83961 | 37.7099623361716 | -122.432792933869 | (37.7099623361716, -122.432792933869) | |||
| 165909 | 165909 | 227209 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 35 Powhattan Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6007561.8732 | 2098204.30964 | 37.741696837339504 | -122.416450338512 | (37.7416968373395, -122.416450338512) | |||
| 166303 | 166303 | 227396 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 5 28th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6005864.943030001 | 2099629.40283 | 37.7455142453913 | -122.422418999536 | (37.7455142453913, -122.422418999536) | |||
| 184110 | 184110 | 227208 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 35 Powhattan Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 22 | Width 3ft | 6007523.932469999 | 2098207.4852299998 | 37.741703423083294 | -122.416581750143 | (37.7417034230833, -122.416581750143) |
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");