Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, DBH, XCoord, YCoord, Latitude, Longitude, Location
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5722 | 5722 | 21711 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1900 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6x6 | 6003392.8992 | 2114541.4083 | 37.7863192355998 | -122.43203159373999 | (37.7863192355998, -122.43203159374) | |||
| 6429 | 6429 | 7178 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 837 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6x6 | 6003458.7438 | 2111235.1971 | 37.777244939721704 | -122.431567664925 | (37.7772449397217, -122.431567664925) | |||
| 42976 | 42976 | 113471 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 47060 | 47060 | 65627 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2116 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1990 12:00:00 AM | 12 | 6x6 | Permit Number 28535 | 6002451.5098 | 2114409.7678 | 37.7859043690694 | -122.435279135393 | (37.7859043690694, -122.435279135393) |
| 80997 | 80997 | 113469 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 87131 | 87131 | 113474 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 92566 | 92566 | 113466 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 96050 | 96050 | 113472 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 111779 | 111779 | 113467 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 112823 | 112823 | 113475 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 124165 | 124165 | 113473 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 126562 | 126562 | 113465 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 20 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | |||
| 144168 | 144168 | 113470 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 450 CHURCH ST | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 6x6 | 6004088.0 | 2106523.0 | 37.764342039298896 | -122.429054808288 | (37.7643420392989, -122.429054808288) | ||||
| 181868 | 181868 | 65538 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 2180 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/20/1990 12:00:00 AM | 16 | 6x6 | Permit Number 28435 | 6002182.4791 | 2114372.5672 | 37.7857869442252 | -122.43620724273501 | (37.7857869442252, -122.436207242735) |
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");