Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25751 | 25751 | 221793 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 26 Norwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6009169.37019 | 2099491.8572 | 37.745322428990995 | -122.410983048655 | (37.745322428991, -122.410983048655) | |||
| 31428 | 31428 | 221908 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1175 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6003228.296569999 | 2101452.81084 | 37.750371807525504 | -122.431666264992 | (37.7503718075255, -122.431666264992) | |||
| 34380 | 34380 | 221910 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1175 Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6003225.80615 | 2101486.76003 | 37.750464882852604 | -122.43167730058599 | (37.7504648828526, -122.431677300586) | |||
| 36231 | 36231 | 203575 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 60 Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 6001009.56246 | 2095231.0134 | 37.7331622045591 | -122.438892966938 | (37.7331622045591, -122.438892966938) | |||
| 46344 | 46344 | 221789 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 3456 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 6005341.04131 | 2103147.38287 | 37.7551442389361 | -122.424480760089 | (37.7551442389361, -122.424480760089) | |||
| 47027 | 47027 | 221919 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 80 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 6004080.1128 | 2102611.51792 | 37.75360159226479 | -122.428803219313 | (37.7536015922648, -122.428803219313) | |||
| 47049 | 47049 | 175197 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 701 Peru Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6005286.47432 | 2092498.9207099997 | 37.725902888684104 | -122.423912306729 | (37.7259028886841, -122.423912306729) | |||
| 51371 | 51371 | 221911 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1175 Noe St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 5ft | 6003226.50292 | 2101503.3413 | 37.750510450614705 | -122.431676074804 | (37.7505104506147, -122.431676074804) | |||
| 52906 | 52906 | 221884 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 230 Esmeralda Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6007166.67292 | 2098807.97162 | 37.7433321258706 | -122.417859593245 | (37.7433321258706, -122.417859593245) | |||
| 66449 | 66449 | 124123 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 83 Stanyan Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 5996382.54086 | 2112452.81509 | 37.7801845808517 | -122.456134428556 | (37.7801845808517, -122.456134428556) | |||
| 71715 | 71715 | 221909 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 1175 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | Width 5ft | 6003227.24309 | 2101470.4878 | 37.750420284586205 | -122.43167116991002 | (37.7504202845862, -122.43167116991) | |||
| 75692 | 75692 | 221790 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 3456 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | Width 5ft | 6005327.10837 | 2103145.45598 | 37.75513816131679 | -122.424528807253 | (37.7551381613168, -122.424528807253) | |||
| 91929 | 91929 | 203584 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 391 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 5ft | 5997518.2723 | 2093790.63155 | 37.729008004011 | -122.450859415354 | (37.729008004011, -122.450859415354) | |||
| 153618 | 153618 | 125545 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 3211 Sacramento St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 5999423.84524 | 2115333.3179900004 | 37.78826779516471 | -122.445820424872 | (37.7882677951647, -122.445820424872) | |||
| 162375 | 162375 | 221918 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 78 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6004080.11539 | 2102633.3428599997 | 37.7536615185686 | -122.428804766139 | (37.7536615185686, -122.428804766139) |
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");