Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9761 | 9761 | 122592 | Planning Code 138.1 required 4 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 72 Townsend St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779103 | 6015480.0 | 2112413.0 | 37.781152948088 | -122.390064228941 | (37.781152948088, -122.390064228941) | |
| 11816 | 11816 | 56918 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 757 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/14/1974 12:00:00 AM | 8 | 3x3 | Permit Number 14160 | 6002721.67474 | 2088983.8970400002 | 37.716106284944 | -122.432527678806 | (37.716106284944, -122.432527678806) | |
| 11975 | 11975 | 105023 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 761 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6002706.48951 | 2088960.92893 | 37.7160423584316 | -122.432578526497 | (37.7160423584316, -122.432578526497) | |||
| 79435 | 79435 | 113168 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 3902 CLAY ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996089.0 | 2115262.0 | 37.7878809990319 | -122.45735320225701 | (37.7878809990319, -122.457353202257) | ||||
| 89794 | 89794 | 103329 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1194X Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001718.9 | 2110136.9 | 37.7741305241547 | -122.437507661432 | (37.7741305241547, -122.437507661432) | ||||
| 92915 | 92915 | 84676 | Permitted Site 1 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 25 Josiah Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49727 | 5996908.75152474 | 2089951.72351373 | 37.718432356708796 | -122.45268961212099 | (37.7184323567088, -122.452689612121) | ||
| 94639 | 94639 | 110388 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 601X JOOST AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998083.0 | 2094940.0 | 37.732196210044705 | -122.44898987974899 | (37.7321962100447, -122.448989879749) | ||||
| 110197 | 110197 | 110391 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 601X JOOST AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998083.0 | 2094940.0 | 37.732196210044705 | -122.44898987974899 | (37.7321962100447, -122.448989879749) | ||||
| 115104 | 115104 | 113167 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 3902 CLAY ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5996089.0 | 2115262.0 | 37.7878809990319 | -122.45735320225701 | (37.7878809990319, -122.457353202257) | ||||
| 120421 | 120421 | 110392 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 601X JOOST AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998083.0 | 2094940.0 | 37.732196210044705 | -122.44898987974899 | (37.7321962100447, -122.448989879749) | ||||
| 124276 | 124276 | 110389 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 601X JOOST AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998083.0 | 2094940.0 | 37.732196210044705 | -122.44898987974899 | (37.7321962100447, -122.448989879749) | ||||
| 124788 | 124788 | 104692 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 2201 SUTTER ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6001996.0 | 2114241.0 | 37.7854150975946 | -122.436842984948 | (37.7854150975946, -122.436842984948) | ||||
| 143071 | 143071 | 110390 | Undocumented 2 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 601X JOOST AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998083.0 | 2094940.0 | 37.732196210044705 | -122.44898987974899 | (37.7321962100447, -122.448989879749) |
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");