Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3028 | 3028 | 191362 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 999 Key Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 6013336.3333 | 2089743.8780099999 | 37.718789267498295 | -122.39589132571999 | (37.7187892674983, -122.39589132572) | ||||
| 13242 | 13242 | 187620 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 33 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005528.0 | 2098708.0 | 37.742965269558795 | -122.423518602522 | (37.7429652695588, -122.423518602522) | ||||
| 13245 | 13245 | 187619 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 27 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005553.0 | 2098709.0 | 37.7429694263933 | -122.423432230366 | (37.7429694263933, -122.423432230366) | ||||
| 53638 | 53638 | 198720 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1800 Illinois St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 6016247.28658 | 2100667.2131 | 37.7489440726059 | -122.386590499372 | (37.7489440726059, -122.386590499372) | |||
| 70294 | 70294 | 198718 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1 Jack Balestreri Way | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6012424.057019999 | 2104786.65184 | 37.7600427570935 | -122.40010058818899 | (37.7600427570935, -122.400100588189) | ||||
| 75827 | 75827 | 198713 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1 Jack Balestreri Way | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6012404.84739 | 2104738.96788 | 37.759910756386 | -122.400163676537 | (37.759910756386, -122.400163676537) | ||||
| 81341 | 81341 | 97022 | Property Tree 7 | Umbellularia californica :: California Bay 195 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 136559 | 136559 | 198717 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1 Jack Balestreri Way | 38 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6012427.078840001 | 2104786.19155 | 37.760041661724294 | -122.40009010477199 | (37.7600416617243, -122.400090104772) | ||||
| 137764 | 137764 | 198711 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1 Jack Balestreri Way | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6012390.58934 | 2104733.77688 | 37.7598957080306 | -122.400212623923 | (37.7598957080306, -122.400212623923) | ||||
| 150647 | 150647 | 242816 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 2 Trainor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008308.46792 | 2108230.50138 | 37.7692684406077 | -122.41457818386002 | (37.7692684406077, -122.41457818386) | |||
| 154286 | 154286 | 242818 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1001 San Jose Ave | 76 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6005391.8173 | 2097529.9468 | 37.7397229144901 | -122.423905733564 | (37.7397229144901, -122.423905733564) | |||
| 164987 | 164987 | 242817 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1001 San Jose Ave | 75 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 8ft | 6005376.5812099995 | 2097527.53797 | 37.7397154402194 | -122.42395824228501 | (37.7397154402194, -122.423958242285) | |||
| 171959 | 171959 | 198715 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1 Jack Balestreri Way | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6012393.75722 | 2104758.14097 | 37.7599627830829 | -122.40020337888001 | (37.7599627830829, -122.40020337888) | ||||
| 177012 | 177012 | 198712 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1 Jack Balestreri Way | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6012409.2868 | 2104740.75677 | 37.7599159158162 | -122.400148448317 | (37.7599159158162, -122.400148448317) | ||||
| 183330 | 183330 | 198714 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1 Jack Balestreri Way | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6012392.10432 | 2104746.43 | 37.7599305351797 | -122.40020827299 | (37.7599305351797, -122.40020827299) | ||||
| 186305 | 186305 | 198719 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1 Jack Balestreri Way | 40 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012426.60188 | 2104780.3365 | 37.760025558456 | -122.40009134316001 | (37.760025558456, -122.40009134316) | ||||
| 188303 | 188303 | 137083 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 3699 Webster St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6002550.0727 | 2121200.5962799997 | 37.8045558214586 | -122.435424089363 | (37.8045558214586, -122.435424089363) | |||
| 188787 | 188787 | 198716 | Undocumented 2 | Umbellularia californica :: California Bay 195 | 1 Jack Balestreri Way | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6012435.45526 | 2104782.66199 | 37.760032437365105 | -122.40006088669901 | (37.7600324373651, -122.400060886699) |
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");