Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34313 | 34313 | 192355 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1400 Quint St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 1ft | 6013376.06433 | 2096591.73652 | 37.7375943028269 | -122.39623367064199 | (37.7375943028269, -122.396233670642) | |||
38564 | 38564 | 192200 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 326 10th St | 0 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008879.18119 | 2109418.2333 | 37.7725617219648 | -122.41268808588998 | (37.7725617219648, -122.41268808589) | |||
52799 | 52799 | 192306 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3600 03rd St | 4 | : 4 | Tree 1 | Private 1 | 21 | Width 5ft | 6015896.02327 | 2098855.55467 | 37.74395018136929 | -122.38767879773701 | (37.7439501813693, -122.387678797737) | |||
60743 | 60743 | 192197 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 315 10th St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6008969.56374 | 2109417.5428 | 37.77256489838 | -122.412375393416 | (37.77256489838, -122.412375393416) | |||
70126 | 70126 | 192356 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1400 Quint St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6013361.05471 | 2096570.45075 | 37.7375350213353 | -122.396284074954 | (37.7375350213353, -122.396284074954) | |||
150364 | 150364 | 192199 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 326 10th St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008867.1222 | 2109432.51416 | 37.77260025703389 | -122.412730809104 | (37.7726002570339, -122.412730809104) | |||
152796 | 152796 | 225789 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 409 Dellbrook Ave | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5997048.20072 | 2102795.35511 | 37.753705857856204 | -122.453134258532 | (37.7537058578562, -122.453134258532) | |||
156396 | 156396 | 192354 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1400 Quint St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 1ft | 6013388.3658300005 | 2096606.99697 | 37.7376368893361 | -122.39619220741999 | (37.7376368893361, -122.39619220742) | |||
158326 | 158326 | 192198 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 313 10th St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008924.99319 | 2109468.55838 | 37.7727024739698 | -122.412533174959 | (37.7727024739698, -122.412533174959) | |||
159013 | 159013 | 192201 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 326 10th St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6008912.071409999 | 2109388.51463 | 37.772481967387705 | -122.412572213639 | (37.7724819673877, -122.412572213639) | |||
160266 | 160266 | 192202 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 360 10th St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6009124.54034 | 2109165.9585 | 37.7718828021889 | -122.411821530666 | (37.7718828021889, -122.411821530666) |
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");