1. In Google Sheets, create a spreadsheet that includes these columns: Longitude, Latitude, Data* and Color. You can also map Addresses**. If additional columns are present, a “more…” button will appear above the map when the user clicks on your custom point. • Map data will be read from first tab in your Google Sheet; the first row must contain column headers• If you don’t have a Google Sheet, create one by importing from Excel or a .csv file• Longitude and Latitude must be in decimal degrees such as -87.633, 41.854 for Chicago (note: the U.S. and western hemisphere have negative longitudes)• The header of the Data column will be used as the map legend heading• Links included in the sheet beginning with https:// will be clickable when the user clicks the map on that custom point• The Color column is optional. If used, the Color column can contain any browser-supported color name or any 6-digit hex color code• If present, the Address column must contain U.S. addresses in this format: address, city, state, ZIP Code**• If you don’t already have Longitude/Latitudes and want to build your Google Sheet interactively: As you click the map or use Search places, the Long Lat is shown above the map and you can copy/paste it into your Google Sheet
2. In Google Sheets, Share your spreadsheet with Anyone with the link permissions and click the Copy link button In Google Sheets:1. Click the Share button in the upper right corner2. Click the Get link section in the box that appears3. Change the sharing setting to Anyone with the link (keep the drop-down to the right set as Viewer)4. Click the Copy link button5. Click DoneSee screenshot of these 5 steps
Bạn đang xem: Martin County, Florida – ZIP Codes Map
3. Paste the link you just copied into the box below:
Xem thêm : BLOG
* What is the Data column? The Data column is the first column in your spreadsheet other than Lat, Long and Color, such as Name in the image at right. The Data column will appear in the map legend.
** Addresses will be converted to Latitude and Longitude so they can be mapped. Read details about mapping addresses.
Nguồn: https://blogtinhoc.edu.vn
Danh mục: Info