Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, PlantDate, DBH, PlotSize, PermitNotes, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32240 | 32240 | 242815 | Undocumented 2 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 377 | 2701 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009780.14565 | 2104995.56148 | 37.760468605848295 | -122.409259390033 | (37.7604686058483, -122.409259390033) | |||
| 46638 | 46638 | 120038 | Undocumented 2 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 377 | 854 28th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5987294.25132 | 2110228.98103 | 37.7735526974552 | -122.48741117152201 | (37.7735526974552, -122.487411171522) | |||
| 51560 | 51560 | 242811 | Undocumented 2 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 377 | 2745 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6009688.52485 | 2104990.07805 | 37.7604484160935 | -122.409575878526 | (37.7604484160935, -122.409575878526) | |||
| 69289 | 69289 | 242812 | Undocumented 2 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 377 | 2745 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009701.726559999 | 2104990.85902 | 37.7604513002023 | -122.409530274826 | (37.7604513002023, -122.409530274826) | |||
| 89886 | 89886 | 83546 | Permitted Site 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 377 | 1637 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52247 | 6008761.11402026 | 2118496.02129158 | 37.7974805140976 | -122.413738710342 | (37.7974805140976, -122.413738710342) | ||
| 96076 | 96076 | 91338 | Permitted Site 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 377 | 829 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/2009 12:00:00 AM | 3x3 | Permit Number 52060 | 6012100.0 | 2112601.0 | 37.7814811117781 | -122.401770636493 | (37.7814811117781, -122.401770636493) | ||
| 108850 | 108850 | 84543 | Permitted Site 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 377 | 2747 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52650 | 6009716.06976497 | 2104988.12537503 | 37.7604445979168 | -122.40948047514999 | (37.7604445979168, -122.40948047515) | ||
| 111148 | 111148 | 84160 | Permitted Site 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 377 | 2747 19th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52650 | 6009716.0 | 2104988.0 | 37.7604442497563 | -122.409480707587 | (37.7604442497563, -122.409480707587) | |
| 112116 | 112116 | 84542 | Permitted Site 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 377 | 2747 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52650 | 6009716.06976497 | 2104988.12537503 | 37.7604445979168 | -122.40948047514999 | (37.7604445979168, -122.40948047515) | ||
| 117419 | 117419 | 84172 | Permitted Site 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 377 | 2747 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52650 | 6009716.06976497 | 2104988.12537503 | 37.7604445979168 | -122.40948047514999 | (37.7604445979168, -122.40948047515) | ||
| 141193 | 141193 | 84455 | Permitted Site 1 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 377 | 2747 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52650 | 6009716.06976497 | 2104988.12537503 | 37.7604445979168 | -122.40948047514999 | (37.7604445979168, -122.40948047515) | ||
| 178099 | 178099 | 242814 | Undocumented 2 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 377 | 2745 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009744.75824 | 2104993.1324 | 37.760459953494895 | -122.40938160789 | (37.7604599534949, -122.40938160789) | |||
| 178201 | 178201 | 242813 | Undocumented 2 | Ulmus carpinifolia 'Frontier' :: Frontier Elm 'Frontier' 377 | 2745 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009725.73602 | 2104991.41978 | 37.76045418521829 | -122.409447276397 | (37.7604541852183, -122.409447276397) |
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");