Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1423 | 1423 | 54061 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 330 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/27/1972 12:00:00 AM | 12 | Permit Number 779745 | 5988745.7457 | 2113084.32895 | 37.7814772265446 | -122.482599571173 | (37.7814772265446, -122.482599571173) | ||
| 6978 | 6978 | 6035 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1826 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001552.687000001 | 2112546.4084 | 37.780736975678295 | -122.438255270265 | (37.7807369756783, -122.438255270265) | |||
| 9190 | 9190 | 2472 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2031X Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1993 12:00:00 AM | 12 | 4X4 | 6003774.0905 | 2114890.3514 | 37.7872989488923 | -122.43073768033301 | (37.7872989488923, -122.430737680333) | ||
| 18727 | 18727 | 3939 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 999X 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002271.23678 | 2107631.4399099997 | 37.7672825369934 | -122.43541777162201 | (37.7672825369934, -122.435417771622) | |||
| 30347 | 30347 | 35172 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 400 40th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/1998 12:00:00 AM | 12 | Permit Number 38706 | 5983466.53844 | 2113086.7632299997 | 37.7811753688678 | -122.50086296861099 | (37.7811753688678, -122.500862968611) | ||
| 36508 | 36508 | 31629 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2667 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/1995 12:00:00 AM | 12 | Permit Number 35146 | 5981804.4287 | 2096935.1986 | 37.736730050914296 | -122.505415418144 | (37.7367300509143, -122.505415418144) | |
| 44329 | 44329 | 97086 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 4550 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5981457.56361 | 2110998.49669 | 37.7753234489943 | -122.50765789816201 | (37.7753234489943, -122.507657898162) | |||
| 48536 | 48536 | 54077 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 1416 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/10/1972 12:00:00 AM | 12 | Permit Number 9800 | 5982488.8605 | 2105444.4291 | 37.7601342805878 | -122.503679056793 | (37.7601342805878, -122.503679056793) | ||
| 88678 | 88678 | 5013 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 5313 Diamond Heights Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2 | 6001578.667721 | 2098979.6063858 | 37.7434873306528 | -122.437193725781 | (37.7434873306528, -122.437193725781) | |||
| 109592 | 109592 | 2713 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2168 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | Permit Number 769716 | 6003121.54577 | 2114856.3596900003 | 37.7871686246892 | -122.43299291599199 | (37.7871686246892, -122.432992915992) | ||
| 167704 | 167704 | 55221 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 2301 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/1972 12:00:00 AM | 12 | Permit Number 11139 | 5986369.9081 | 2099546.7997 | 37.744168417752206 | -122.489822796734 | (37.7441684177522, -122.489822796734) |
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");