Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, qSiteInfo, DBH, PlotSize, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3132 | 3132 | 253339 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 2019X 24th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | PUC 13 | 3x3 | 5988853.0 | 2101569.0 | 37.7498655183494 | -122.481384971136 | (37.7498655183494, -122.481384971136) | ||||
85296 | 85296 | 12456 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
145293 | 145293 | 12457 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
79934 | 79934 | 12458 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
108403 | 108403 | 12459 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
127369 | 127369 | 12460 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
101961 | 101961 | 12461 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
140349 | 140349 | 12462 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
93559 | 93559 | 12463 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
138346 | 138346 | 12464 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
111079 | 111079 | 12465 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
77359 | 77359 | 12466 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
100881 | 100881 | 12467 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
96684 | 96684 | 12468 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
81281 | 81281 | 12469 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
144723 | 144723 | 12470 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
104160 | 104160 | 12471 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
98709 | 98709 | 12472 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
115085 | 115085 | 12473 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
116784 | 116784 | 12474 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
91597 | 91597 | 12475 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
145316 | 145316 | 12476 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
118813 | 118813 | 12477 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
111984 | 111984 | 12478 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
113404 | 113404 | 12479 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
78443 | 78443 | 12480 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
116167 | 116167 | 12481 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
96901 | 96901 | 12482 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
78476 | 78476 | 12483 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
84240 | 84240 | 12484 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
117794 | 117794 | 12485 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 36 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
121516 | 121516 | 12486 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 31 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
107010 | 107010 | 12487 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 32 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
138304 | 138304 | 12489 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
113400 | 113400 | 12491 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 6 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
124901 | 124901 | 12497 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 42 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
126959 | 126959 | 12498 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 307 Lake Merced Blvd | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) |
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");