Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1694 | 1694 | 251475 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 151 32nd Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779951 | 5985659.0 | 2114437.0 | 37.78501121016021 | -122.493377758762 | (37.7850112101602, -122.493377758762) | |
| 26376 | 26376 | 233965 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 16 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5998630.023569999 | 2106931.63106 | 37.765153571896896 | -122.44796176374099 | (37.7651535718969, -122.447961763741) | |||
| 40834 | 40834 | 247628 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 286 Bradford St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6009493.85882 | 2096962.27736 | 37.738394944962394 | -122.409682503062 | (37.7383949449624, -122.409682503062) | ||||
| 45134 | 45134 | 132383 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1713 Taylor St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 6008731.67478 | 2118716.1773200002 | 37.7980833548266 | -122.41385615953301 | (37.7980833548266, -122.413856159533) | |||
| 54276 | 54276 | 194583 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1698 Galvez Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 6015441.64874 | 2098018.63828 | 37.7416270022859 | -122.38919150780899 | (37.7416270022859, -122.389191507809) | |||
| 57817 | 57817 | 132397 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2836 Larkin St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6006502.73263 | 2120950.76111 | 37.804093525861795 | -122.42172776352899 | (37.8040935258618, -122.421727763529) | ||||
| 62614 | 62614 | 178399 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 339 Athens St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 2ft | 6004188.88481 | 2091298.12563 | 37.7225437445683 | -122.42762108566002 | (37.7225437445683, -122.42762108566) | |||
| 64368 | 64368 | 249601 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2200 Golden Gate Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 5998898.09787 | 2111497.4092 | 37.777705355751294 | -122.447363215433 | (37.7777053557513, -122.447363215433) | |||
| 69854 | 69854 | 132400 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2745 Larkin St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6006513.749919999 | 2120658.41667 | 37.8032914438996 | -122.421668860656 | (37.8032914438996, -122.421668860656) | ||||
| 70254 | 70254 | 122245 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 47 Lake St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5990779.800559999 | 2114787.3723 | 37.7862714344884 | -122.47568719317199 | (37.7862714344884, -122.475687193172) | |||
| 71019 | 71019 | 132386 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1468 Greenwich St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 2ft | 6005813.32494 | 2119673.13314 | 37.8005465862138 | -122.42402259955799 | (37.8005465862138, -122.424022599558) | |||
| 75547 | 75547 | 132405 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2671 Leavenworth St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6007317.65081 | 2121868.01026 | 37.8066579786473 | -122.418972771382 | (37.8066579786473, -122.418972771382) | ||||
| 89513 | 89513 | 132372 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 20 Reed St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6008211.08199 | 2117028.50784 | 37.793420182046 | -122.41553801857401 | (37.793420182046, -122.415538018574) | ||||
| 97714 | 97714 | 102073 | Significant Tree 6 | Pittosporum eugenioides :: Tarata 110 | 273 Magellan Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994674.1 | 2100293.4 | 37.7466997707371 | -122.461163031194 | (37.7466997707371, -122.461163031194) | |||||
| 115488 | 115488 | 233973 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 242 Upper Ter | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5999494.677630001 | 2106185.26835 | 37.7631536325665 | -122.44491748844901 | (37.7631536325665, -122.444917488449) | |||
| 147932 | 147932 | 233969 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 59 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998431.96444 | 2106860.6202700003 | 37.7649472710115 | -122.448641684483 | (37.7649472710115, -122.448641684483) | |||
| 155855 | 155855 | 132392 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2833 Larkin St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 16 | 6006479.362930001 | 2120932.81603 | 37.8040429353981 | -122.421807360741 | (37.8040429353981, -122.421807360741) | ||||
| 184440 | 184440 | 247639 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 360 Bradford St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 8ft | 6009456.29127 | 2096556.43991 | 37.7372784977969 | -122.409783755028 | (37.7372784977969, -122.409783755028) |
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");