Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3782 | 3782 | 182315 | Permitted Site 1 | Hakea suaveolens :: Sweet Hakea Tree 14 | 2724 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2001 12:00:00 AM | 9 | Width 0ft | Permit Number 43905 | 5986428.3511 | 2105069.3949 | 37.759335376640294 | -122.490026834722 | (37.7593353766403, -122.490026834722) | |
24310 | 24310 | 184685 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 3339 Lawton St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5983851.9132 | 2104244.1115 | 37.756918592100206 | -122.498876300129 | (37.7569185921002, -122.498876300129) | |||
42448 | 42448 | 228408 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 511 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007849.96973 | 2096414.41057 | 37.7367983659444 | -122.41532751336901 | (37.7367983659444, -122.415327513369) | |||
49674 | 49674 | 47187 | Permitted Site 1 | Hakea suaveolens :: Sweet Hakea Tree 14 | 399 El Camino Del Mar | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 9 | Permit Number 45147 | 5987458.66147 | 2115287.92656 | 37.787452713754604 | -122.487214103607 | (37.7874527137546, -122.487214103607) | |
73004 | 73004 | 190635 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 1 01st St | 28 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014407.37845 | 2105898.42582 | 37.7632058300952 | -122.393318979581 | (37.7632058300952, -122.393318979581) | ||||
120065 | 120065 | 52568 | Permitted Site 1 | Hakea suaveolens :: Sweet Hakea Tree 14 | 1600 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 9 | Permit Number 48665 | 5983775.59805013 | 2104247.52774772 | 37.756923495634496 | -122.49914047475201 | (37.7569234956345, -122.499140474752) | |
171238 | 171238 | 78333 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 701x 34th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/22/2000 12:00:00 AM | 9 | 3x3 | 5985357.102659999 | 2111002.94955 | 37.7755646332868 | -122.494169015949 | (37.7755646332868, -122.494169015949) | |
182081 | 182081 | 43618 | Permitted Site 1 | Hakea suaveolens :: Sweet Hakea Tree 14 | 1918 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 9 | Permit Number 43270 | 5985398.78072313 | 2102143.2200772 | 37.7512407312978 | -122.493371949534 | (37.7512407312978, -122.493371949534) |
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");