Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11285 | 11285 | 83683 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 215 Dublin St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/01/2009 12:00:00 AM | 3 | 3x3 | Permit Number 52308 | 6004110.69577 | 2089162.29942 | 37.716674810270206 | -122.42773926378 | (37.7166748102702, -122.42773926378) | |
| 53784 | 53784 | 113548 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1911 20th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/30/2015 12:00:00 AM | 1 | Permit Number 774960 | 6012300.00129 | 2104664.7502 | 37.759701124429796 | -122.400521077012 | (37.7597011244298, -122.400521077012) | ||
| 71915 | 71915 | 96679 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 375@32nd Ave 32nd Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/28/2011 12:00:00 AM | 5 | Permit Number 768040 | 5985878.99721 | 2113476.25396 | 37.7823861446856 | -122.49254586983999 | (37.7823861446856, -122.49254586984) | ||
| 77563 | 77563 | 94632 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3600 16th St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/19/2016 12:00:00 AM | 3x3 | Permit Number 775358 | 6002902.0 | 2106490.0 | 37.764184223284396 | -122.433154488347 | (37.7641842232844, -122.433154488347) | ||
| 92122 | 92122 | 115292 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2058 17th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 774300 | 5991031.5 | 2101384.0 | 37.7494839769409 | -122.47383819807501 | (37.7494839769409, -122.473838198075) | |||
| 93844 | 93844 | 100509 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1X Treat Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3 | 18x18 | 6009122.9 | 2107982.7 | 37.7686337575832 | -122.41174358203101 | (37.7686337575832, -122.411743582031) | |||
| 109588 | 109588 | 113335 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2X STANFORD ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/10/2015 12:00:00 AM | 3x9 | Permit Number 770912 | 6014727.0 | 2112481.0 | 37.781297869167396 | -122.392674013487 | (37.7812978691674, -122.392674013487) | ||
| 118077 | 118077 | 111289 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 306 AVILA ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6000943.0 | 2121065.0 | 37.804092109664005 | -122.440975765753 | (37.804092109664, -122.440975765753) | ||||
| 127737 | 127737 | 112972 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4099x ULLOA ST | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10/20/2015 12:00:00 AM | 1 | 3x3 | Permit Number 773327 | 5983385.0 | 2098079.0 | 37.7399635032694 | -122.500035309652 | (37.7399635032694, -122.500035309652) | |
| 141647 | 141647 | 122627 | Planning Code 138.1 required 4 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 34 Country Club Dr | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11/15/2016 12:00:00 AM | 3 | 3x4 | Permit Number 775279 | 5984731.0 | 2094410.0 | 37.729968312905505 | -122.49511098534401 | (37.7299683129055, -122.495110985344) | |
| 147467 | 147467 | 82811 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2362 44th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50731 | 5982709.1994 | 2099047.2891 | 37.742582474230396 | -122.502443555218 | (37.7425824742304, -122.502443555218) |
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");