Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28634 | 28634 | 141934 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1050 MCALLISTER ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6004016.7876 | 2111854.945 | 37.7789782281051 | -122.42968142536199 | (37.7789782281051, -122.429681425362) | |||
| 36086 | 36086 | 118225 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5984452.242269999 | 2111581.69085 | 37.7771006996432 | -122.49734183320601 | (37.7771006996432, -122.497341833206) | |||
| 41692 | 41692 | 107848 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 407 09th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6009766.34192 | 2109306.87193 | 37.7723057020722 | -122.40961143144101 | (37.7723057020722, -122.409611431441) | |||
| 46443 | 46443 | 200679 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6015689.2638 | 2095313.8362 | 37.7342138898064 | -122.388146614226 | (37.7342138898064, -122.388146614226) | |||
| 51448 | 51448 | 92261 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4545 Anza St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/23/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52708 | 5984639.1399 | 2111735.34775 | 37.7775335493935 | -122.49670664793301 | (37.7775335493935, -122.496706647933) | |
| 61327 | 61327 | 197568 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6011770.36838 | 2107496.4530700003 | 37.7674467954558 | -122.40255195122299 | (37.7674467954558, -122.402551951223) | |||
| 100190 | 100190 | 111034 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 150 15th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | ||||
| 117473 | 117473 | 30944 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
| 121244 | 121244 | 136424 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6013541.7115 | 2118113.66267 | 37.7966979482953 | -122.39716964367202 | (37.7966979482953, -122.397169643672) | |||
| 130459 | 130459 | 113597 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6013588.4505 | 2118285.15352 | 37.7971714233818 | -122.39701994521099 | (37.7971714233818, -122.397019945211) | |||
| 169554 | 169554 | 197514 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | 6009780.84318 | 2109499.43172 | 37.7728352390743 | -122.409574863193 | (37.7728352390743, -122.409574863193) | ||||
| 173654 | 173654 | 138406 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1850 PIERCE ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002021.2907 | 2114957.6084 | 37.7873841584288 | -122.43680680385799 | (37.7873841584288, -122.436806803858) | |||
| 174770 | 174770 | 136392 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3395 Sacramento St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5998815.16498 | 2115250.29133 | 37.788005052827394 | -122.447920368844 | (37.7880050528274, -122.447920368844) | |||
| 176319 | 176319 | 136396 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3651 Baker St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 5ft | 5999117.86509 | 2121345.1324299998 | 37.8047571571746 | -122.447311924407 | (37.8047571571746, -122.447311924407) |
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");