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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2521 | 2521 | 141908 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004604.7205 | 2111934.4347 | 37.779229760906205 | -122.42765319377199 | (37.7792297609062, -122.427653193772) | |||
| 25682 | 25682 | 183905 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2101 22nd Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5989441.4873 | 2100495.8044 | 37.746953003916296 | -122.479271477973 | (37.7469530039163, -122.479271477973) | |||
| 38279 | 38279 | 200678 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1535 Newcomb Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015671.6762 | 2095312.1874 | 37.734208388060104 | -122.388207305661 | (37.7342083880601, -122.388207305661) | |||
| 42864 | 42864 | 197567 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 15th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6011782.82118 | 2107497.01248 | 37.767449026680495 | -122.402508917767 | (37.7674490266805, -122.402508917767) | |||
| 43291 | 43291 | 197532 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 651 Missouri St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6013605.01625 | 2103874.9640900004 | 37.757605236406995 | -122.39595229975299 | (37.757605236407, -122.395952299753) | ||||
| 49441 | 49441 | 239733 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2002 Castro St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002632.00291 | 2099712.5863900003 | 37.745559743 | -122.433603933486 | (37.745559743, -122.433603933486) | |||
| 52120 | 52120 | 118224 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699 37th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5984451.82255 | 2111562.02768 | 37.7770466856492 | -122.49734183318701 | (37.7770466856492, -122.497341833187) | |||
| 53313 | 53313 | 197550 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101 Rhode Island St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6011736.4606800005 | 2107238.9435 | 37.766737839213796 | -122.402651123063 | (37.7667378392138, -122.402651123063) | |||
| 105110 | 105110 | 109303 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 251 RHODE ISLAND ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011759.4 | 2107238.5 | 37.766737902166795 | -122.402571748171 | (37.7667379021668, -122.402571748171) | ||||
| 108452 | 108452 | 111033 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 150 15th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | ||||
| 112313 | 112313 | 34507 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 18 Lansing St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) | |||
| 114702 | 114702 | 30958 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 8 | 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) | ||
| 132434 | 132434 | 197513 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | 6009803.31754 | 2109510.05508 | 37.7728656676608 | -122.409497871353 | (37.7728656676608, -122.409497871353) | ||||
| 138027 | 138027 | 138405 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1850 PIERCE ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6002023.3908 | 2114940.8074 | 37.787338146540705 | -122.436798334797 | (37.7873381465407, -122.436798334797) | |||
| 139901 | 139901 | 9540 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004321.7721315995 | 2112240.3684222 | 37.7800537702914 | -122.428653843346 | (37.7800537702914, -122.428653843346) | ||
| 173822 | 173822 | 136423 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 177 Drumm St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013540.78751 | 2118131.64516 | 37.796747272512604 | -122.397174102497 | (37.7967472725126, -122.397174102497) | |||
| 178033 | 178033 | 113596 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 370 Drumm St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6013590.96742 | 2118268.55465 | 37.797125986926204 | -122.397010071555 | (37.7971259869262, -122.397010071555) | |||
| 179700 | 179700 | 141933 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1050 MCALLISTER ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6004066.711 | 2111861.7308 | 37.77899968697729 | -122.429509204364 | (37.7789996869773, -122.429509204364) |
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");