Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29186 | 29186 | 209002 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 115 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 36 | Width 4ft | 5994119.61861 | 2096725.9639 | 37.736872559114104 | -122.462821593742 | (37.7368725591141, -122.462821593742) | |||
36907 | 36907 | 208993 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 31 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 5993535.26127 | 2097150.77507 | 37.7380053101076 | -122.46487280074899 | (37.7380053101076, -122.464872800749) | |||
40168 | 40168 | 208995 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 21 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 35 | Width 4ft | 5993486.0432 | 2097190.73028 | 37.7381121792369 | -122.465045871672 | (37.7381121792369, -122.465045871672) | |||
52160 | 52160 | 208998 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 10 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | Width 4ft | 5993381.76992 | 2097221.25805 | 37.7381899876824 | -122.465408610532 | (37.7381899876824, -122.465408610532) | |||
56324 | 56324 | 208990 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 51 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 4ft | 5993670.13129 | 2097058.8329 | 37.7377606351295 | -122.46439981849899 | (37.7377606351295, -122.464399818499) | |||
63161 | 63161 | 208994 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 21 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 4ft | 5993511.280230001 | 2097168.00802 | 37.7380512447772 | -122.46495696559799 | (37.7380512447772, -122.464956965598) | |||
65353 | 65353 | 207764 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1520 Monterey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 4ft | 5993438.38203 | 2095281.4007599999 | 37.7328668869905 | -122.46507202306299 | (37.7328668869905, -122.465072023063) | |||
73251 | 73251 | 208996 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 11 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | Width 4ft | 5993421.96829 | 2097241.5815 | 37.7382481090644 | -122.465271101502 | (37.7382481090644, -122.465271101502) | |||
74972 | 74972 | 208988 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 85 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 4ft | 5993834.637730001 | 2096941.34521 | 37.7374475244853 | -122.463822519421 | (37.7374475244853, -122.463822519421) | |||
75055 | 75055 | 208997 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 10 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | Width 4ft | 5993343.646380001 | 2097250.7379 | 37.738268733207605 | -122.465542562746 | (37.7382687332076, -122.465542562746) | |||
77037 | 77037 | 208999 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 10 Yerba Buena Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | Width 4ft | 5993404.322790001 | 2097201.32336 | 37.7381365526709 | -122.465329186907 | (37.7381365526709, -122.465329186907) | |||
127109 | 127109 | 208991 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 45 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 5993638.39674 | 2097082.374 | 37.73782344378579 | -122.46451124811199 | (37.7378234437858, -122.464511248112) | |||
133032 | 133032 | 209000 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 135 Yerba Buena Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | Width 4ft | 5994206.5655 | 2096669.1829099997 | 37.7367216600723 | -122.462516864768 | (37.7367216600723, -122.462516864768) | |||
133286 | 133286 | 209001 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 125 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 24 | Width 4ft | 5994148.93284 | 2096709.76404 | 37.7368297666801 | -122.462719067425 | (37.7368297666801, -122.462719067425) | |||
147084 | 147084 | 208989 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 55 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 4ft | 5993734.999890001 | 2097013.08627 | 37.7376387653037 | -122.46417221806699 | (37.7376387653037, -122.464172218067) | |||
149384 | 149384 | 207754 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1364 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 5993663.7534300005 | 2106217.17575 | 37.7629067380829 | -122.46508685559999 | (37.7629067380829, -122.4650868556) | |||
165255 | 165255 | 224249 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 500x 27th St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 48 | Width 4ft | 6002852.0087 | 2100065.56768 | 37.7465414276517 | -122.432868400457 | (37.7465414276517, -122.432868400457) | |||
183947 | 183947 | 208992 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 45 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 4ft | 5993607.99739 | 2097104.1803400002 | 37.7378815660919 | -122.46461793558001 | (37.7378815660919, -122.46461793558) |
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");