Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3467 | 3467 | 123897 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 107 11th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992391.187940001 | 2114716.46428 | 37.7861700272505 | -122.47010709580299 | (37.7861700272505, -122.470107095803) | |||
| 26572 | 26572 | 132381 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1713 Taylor St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6008727.871259999 | 2118754.69526 | 37.7981889019448 | -122.413872046978 | (37.7981889019448, -122.413872046978) | |||
| 33012 | 33012 | 211434 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 910 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 1ft | 5992028.493840001 | 2105269.75757 | 37.760210948307794 | -122.47067358802299 | (37.7602109483078, -122.470673588023) | |||
| 33032 | 33032 | 247630 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 286 Bradford St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6009492.89578 | 2096949.07994 | 37.738358653736206 | -122.409684901541 | (37.7383586537362, -122.409684901541) | ||||
| 36060 | 36060 | 132385 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1468 Greenwich St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6005829.912880001 | 2119675.1182 | 37.8005529731893 | -122.423965339721 | (37.8005529731893, -122.423965339721) | |||
| 48906 | 48906 | 211441 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 200x Terrace Dr | 27 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5993812.00301 | 2096546.48985 | 37.7363620454614 | -122.463872125093 | (37.7363620454614, -122.463872125093) | ||||
| 61763 | 61763 | 132373 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 20 Reed St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6008208.92851 | 2117034.44521 | 37.793436363556204 | -122.415545890356 | (37.7934363635562, -122.415545890356) | ||||
| 66218 | 66218 | 233975 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 3786 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001886.12679 | 2106432.54375 | 37.76396878345871 | -122.43666398285299 | (37.7639687834587, -122.436663982853) | |||
| 133226 | 133226 | 122244 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 47 Lake St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5990784.64686 | 2114787.2699700003 | 37.7862714344765 | -122.475670418927 | (37.7862714344765, -122.475670418927) | |||
| 136421 | 136421 | 211445 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1313 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000197.7982 | 2096452.6133 | 37.736470213222 | -122.441787089628 | (37.736470213222, -122.441787089628) | |||
| 147937 | 147937 | 30820 | DPW Maintained 3 | Pittosporum eugenioides :: Tarata 110 | 151 Lippard Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/06/1995 12:00:00 AM | 7 | Permit Number 34679 | 6001842.2487 | 2095205.8891900002 | 37.7331405596841 | -122.43601235390601 | (37.7331405596841, -122.436012353906) | ||
| 162959 | 162959 | 132382 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1713 Taylor St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6008728.03476 | 2118737.75818 | 37.798142406100396 | -122.413870282493 | (37.7981424061004, -122.413870282493) | |||
| 170663 | 170663 | 178394 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 25 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001248.99944 | 2093921.6644099997 | 37.7295806536223 | -122.437971416359 | (37.7295806536223, -122.437971416359) | |||
| 172452 | 172452 | 132380 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1680 Taylor St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6008764.121730001 | 2118820.69014 | 37.7983721433051 | -122.4137512797 | (37.7983721433051, -122.4137512797) | |||
| 182363 | 182363 | 178396 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 55 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003704.97004 | 2093083.05909 | 37.7274173910959 | -122.42942109582899 | (37.7274173910959, -122.429421095829) | |||
| 185912 | 185912 | 178400 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 802 Excelsior Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6004451.61665 | 2091406.41613 | 37.7228559442383 | -122.426720588195 | (37.7228559442383, -122.426720588195) |
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");