Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1536 | 1536 | 251472 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Hiliritas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780012 | 6001589.0 | 2096875.0 | 37.7377091611847 | -122.437007355935 | (37.7377091611847, -122.437007355935) | |
| 6724 | 6724 | 102771 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1438 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6006063.66154 | 2119354.00796 | 37.7996844799161 | -122.42313363592501 | (37.7996844799161, -122.423133635925) | |||
| 16814 | 16814 | 105175 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1601X Newcomb Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 10 | 3x3 | 6015153.3918 | 2095715.6028 | 37.735287354242395 | -122.390027366589 | (37.7352873542424, -122.390027366589) | |||
| 22329 | 22329 | 248977 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 748 Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999650.0 | 2111146.0 | 37.7767834132689 | -122.444736872581 | (37.7767834132689, -122.444736872581) | ||||
| 29829 | 29829 | 115807 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 742 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5999623.0981 | 2111117.8642 | 37.7767046243395 | -122.444827911038 | (37.7767046243395, -122.444827911038) | |||
| 48563 | 48563 | 117040 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2220x SUTTER ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001781.0 | 2114465.0 | 37.786017922595605 | -122.437602866759 | (37.7860179225956, -122.437602866759) | ||||
| 77653 | 77653 | 109672 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 798x GRAFTON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994496.0 | 2090624.0 | 37.72013972186421 | -122.461078132621 | (37.7201397218642, -122.461078132621) | ||||
| 82180 | 82180 | 120111 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 277 Clinton Park | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6004952.0 | 2108176.0 | 37.7689296510264 | -122.426184162815 | (37.7689296510264, -122.426184162815) | |||
| 86884 | 86884 | 117033 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2220x SUTTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001781.0 | 2114465.0 | 37.786017922595605 | -122.437602866759 | (37.7860179225956, -122.437602866759) | ||||
| 90165 | 90165 | 111781 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 399x EUGENIA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6006811.0 | 2098022.0 | 37.7411540008274 | -122.419033684979 | (37.7411540008274, -122.419033684979) | |||
| 92933 | 92933 | 120549 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4098 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x3 | 6002569.0 | 2102434.0 | 37.7530285274797 | -122.434016285558 | (37.7530285274797, -122.434016285558) | |||
| 93774 | 93774 | 98707 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 105X Ord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6000883.6 | 2105740.8 | 37.7620124016568 | -122.440081810476 | (37.7620124016568, -122.440081810476) | ||||
| 94988 | 94988 | 117034 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2220x SUTTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001781.0 | 2114465.0 | 37.786017922595605 | -122.437602866759 | (37.7860179225956, -122.437602866759) | ||||
| 96893 | 96893 | 105172 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1601X NEWCOMB AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 12 | 3x3 | Permit Number 770204 | 6015135.0 | 2095759.0 | 37.735405494081505 | -122.390093985074 | (37.7354054940815, -122.390093985074) | ||
| 97305 | 97305 | 109671 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 798x GRAFTON AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5994496.0 | 2090624.0 | 37.72013972186421 | -122.461078132621 | (37.7201397218642, -122.461078132621) | ||||
| 103765 | 103765 | 75790 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2080 FOLSOM ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 03/15/1997 12:00:00 AM | 3x3 | 6008075.0 | 2106289.0 | 37.763924410887206 | -122.41524828442499 | (37.7639244108872, -122.415248284425) | |||
| 108628 | 108628 | 120548 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4098 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6002569.0 | 2102434.0 | 37.7530285274797 | -122.434016285558 | (37.7530285274797, -122.434016285558) | |||
| 109113 | 109113 | 99760 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4247 25th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Most likely planted/permitted with tree no. 1 on same day/permit. | 6002269.0 | 2101186.0 | 37.7495847859814 | -122.434964495609 | (37.7495847859814, -122.434964495609) | |||
| 112074 | 112074 | 109502 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2604 POST ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999699.0 | 2113674.0 | 37.7837274467295 | -122.444749121189 | (37.7837274467295, -122.444749121189) | ||||
| 118711 | 118711 | 116614 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 299X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x3 | 6007772.0 | 2106483.0 | 37.7644400562771 | -122.41631001514901 | (37.7644400562771, -122.416310015149) | |||
| 128352 | 128352 | 117042 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2220x SUTTER ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001781.0 | 2114465.0 | 37.786017922595605 | -122.437602866759 | (37.7860179225956, -122.437602866759) | ||||
| 129296 | 129296 | 117035 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2220x SUTTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001781.0 | 2114465.0 | 37.786017922595605 | -122.437602866759 | (37.7860179225956, -122.437602866759) | ||||
| 143492 | 143492 | 117038 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2220x SUTTER ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001781.0 | 2114465.0 | 37.786017922595605 | -122.437602866759 | (37.7860179225956, -122.437602866759) |
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");