Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3510 | 3510 | 247941 | Planning Code 138.1 required 4 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 29 Joy St | 4 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 5 | Permit Number 775404 | 6010287.82636 | 2098909.7574 | 37.743786764646 | -122.40707457072901 | (37.743786764646, -122.407074570729) | |||
| 4884 | 4884 | 253710 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Monument Way | 4 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 10x10 | 5999088.0 | 2105836.0 | 37.7621714109075 | -122.446298918118 | (37.7621714109075, -122.446298918118) | ||||
| 5099 | 5099 | 253794 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1698X 08th Ave | 4 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 3x3 | 5993765.0 | 2103990.0 | 37.7567973297208 | -122.464574954098 | (37.7567973297208, -122.464574954098) | ||||
| 8657 | 8657 | 97354 | Permitted Site 1 | Tree(s) :: 17 | 4 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | |||||||||||
| 76347 | 76347 | 111157 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 201x EUGENIA AVE | 4 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6006591.0 | 2098138.0 | 37.7414601197382 | -122.419802596536 | (37.7414601197382, -122.419802596536) | ||||
| 86301 | 86301 | 105759 | Permitted Site 1 | Tree(s) :: 17 | 1910X CASTRO ST | 4 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 04/10/2014 12:00:00 AM | 15 | Permit Number 771977 | 6002617.0 | 2100030.0 | 37.746430435118796 | -122.43367849259899 | (37.7464304351188, -122.433678492599) | ||
| 95360 | 95360 | 116668 | DPW Maintained 3 | Cedrus deodara :: Deodar Cedar 129 | 100x Esmeralda Ave | 4 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 111257 | 111257 | 98379 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 199X Cragmont Ave | 4 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 5992899.0 | 2101153.0 | 37.7489576989052 | -122.467363590244 | (37.7489576989052, -122.467363590244) | |||||
| 115115 | 115115 | 105652 | Undocumented 2 | Yucca elephantipes :: Giant Yucca 211 | 150 BRONTE ST | 4 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 25 | 6009287.5 | 2096640.3 | 37.737499298818996 | -122.410373266073 | (37.737499298819, -122.410373266073) | ||||
| 128665 | 128665 | 117627 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 890x VERMONT ST | 4 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 6011292.0 | 2104239.0 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | |||||
| 139585 | 139585 | 115666 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 601x PERU AVE | 4 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6005068.0 | 2092670.0 | 37.726360298316294 | -122.42467972288401 | (37.7263602983163, -122.424679722884) | ||||
| 145521 | 145521 | 116649 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 199x Esmeralda Ave | 4 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) |
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");