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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
53954 | 53954 | 47883 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 1422 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/11/2006 12:00:00 AM | 5 | Permit Number 45630 | 5982178.8025 | 2105387.2339 | 37.7599590039895 | -122.504747143589 | (37.7599590039895, -122.504747143589) | |
55292 | 55292 | 234854 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 130 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007573.33331 | 2098019.6233599996 | 37.7411903742509 | -122.41639763464799 | (37.7411903742509, -122.416397634648) | |||
63869 | 63869 | 121932 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 344 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990915.4532 | 2113093.93697 | 37.7816295951245 | -122.475094208069 | (37.7816295951245, -122.475094208069) | |||
71138 | 71138 | 30700 | Permitted Site 1 | Podocarpus macrophyllus :: Yew Pine 168 | 240 Lily St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 5 | Permit Number 34612 | 6005310.6159 | 2110107.7982 | 37.7742541659126 | -122.425081203232 | (37.7742541659126, -122.425081203232) | |
73670 | 73670 | 135656 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 1920 Beach St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6001020.2424800005 | 2121027.2609 | 37.8039928872331 | -122.440705754666 | (37.8039928872331, -122.440705754666) | |||
136606 | 136606 | 212846 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 375 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993227.98035 | 2089685.02025 | 37.7174884593132 | -122.465393040574 | (37.7174884593132, -122.465393040574) | |||
142199 | 142199 | 212835 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 401 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997377.5580400005 | 2097039.2762900002 | 37.7379199482423 | -122.451580107737 | (37.7379199482423, -122.451580107737) | |||
148572 | 148572 | 135659 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 341 Spruce St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 1ft | 5997134.75197 | 2115094.07357 | 37.7874799260983 | -122.453722981751 | (37.7874799260983, -122.453722981751) | |||
157808 | 157808 | 234844 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 471 Oak St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 6004727.493290001 | 2110160.10241 | 37.7743648231001 | -122.427102057227 | (37.7743648231001, -122.427102057227) | |||
175065 | 175065 | 244282 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 563 Oak St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004300.7385 | 2110098.3052 | 37.7741710014741 | -122.42857387592699 | (37.7741710014741, -122.428573875927) | |||
182107 | 182107 | 234866 | Undocumented 2 | Podocarpus macrophyllus :: Yew Pine 168 | 3781 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001808.66537 | 2106354.74749 | 37.7637507715923 | -122.436926328595 | (37.7637507715923, -122.436926328595) |
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");