{"id":672,"date":"2020-09-02T15:34:00","date_gmt":"2020-09-02T15:34:00","guid":{"rendered":"https:\/\/commons.princeton.edu\/remote-ethnography\/?page_id=672"},"modified":"2020-12-16T21:24:50","modified_gmt":"2020-12-16T21:24:50","slug":"collecting-mapping-data","status":"publish","type":"page","link":"https:\/\/commons.princeton.edu\/remote-ethnography\/collecting-mapping-data\/","title":{"rendered":"Collecting + Coloring Mapping Data"},"content":{"rendered":"<div id=\"panels-ipe-paneid-66126\" class=\"panels-ipe-portlet-wrapper panels-ipe-portlet-marker\">\n<div class=\"panels-ipe-portlet-content\">\n<div class=\"panel-pane pane-fieldable-panels-pane pane-vuuid-eac5c1af-5e87-43f3-8ba2-e09a625fc894 pane-bundle-text\">\n<div class=\"fieldable-panels-pane\">These instructions will help you collect and clean geo-location data sets during or possibly after\u00a0your research. With this data that includes geographic latitude and longitude coordinates, you will be able to create layered maps that display relationships among selected locations, and in connection with the wide variety of other numerical and qualitative data that you might create or obtain for the same areas. We also suggest reading our <a href=\"https:\/\/commons.princeton.edu\/remote-ethnography\/collecting-data\/\">set of tips on collecting and cleaning data sets for visualization<\/a>. This part of also describes how to choose from the 3 basic types of color schemes based on the kind of data that you have, and regardless of your mapping software.<\/div>\n<div><\/div>\n<h4>Generating Geocoded Data Sets\u00a0for Excel or Google Sheets<\/h4>\n<\/div>\n<\/div>\n<\/div>\n<div id=\"panels-ipe-paneid-66131\" class=\"panels-ipe-portlet-wrapper panels-ipe-portlet-marker\">\n<div class=\"panels-ipe-portlet-content\">\n<div class=\"panel-pane pane-entity-view pane-node\">\n<div class=\"panelizer-view-mode node node-full node-basic-page node-2371 page-default\">\n<div class=\"panel-display boxton clearfix radix-boxton\">\n<div class=\"container-fluid\">\n<div class=\"row\">\n<div class=\"col-md-12 radix-layouts-content panel-panel\">\n<div class=\"panel-panel-inner\">\n<div class=\"panel-pane pane-entity-view pane-node\">\n<article class=\"node-2371 node node-basic-page view-mode-full node-by-viewer clearfix\">\n<div class=\"field field-name-body field-type-text-with-summary field-label-hidden\">\n<div class=\"field-items\">\n<div class=\"field-item even\">\n<ol>\n<li><strong>Open<\/strong> Google maps with a web browser at <a href=\"http:\/\/maps.google.com\/\" data-extlink=\"\">maps.google.com<\/a>.<\/li>\n<li><strong>Use<\/strong> the Search field to find your selected location of interest.<\/li>\n<li><strong>Zoom<\/strong> <strong>in<\/strong>, <strong>move<\/strong> the map, and then <strong>click<\/strong> on the specific location you identify as your most accurate data point.<\/li>\n<li><strong>Generate<\/strong> latitude and longitude information, using one of these methods:<br \/>\na. <strong>Click<\/strong> on a select location, to open a small box with location details, or<br \/>\nb. <strong>Control\/right-click<\/strong> on a spot to open a menu, select \u201cWhat\u2019s here?\u201d, or<br \/>\nc. <strong>Click<\/strong> on a red location marker, select \u201cWhat\u2019s here?\u201d if needed.<\/li>\n<li><strong>Click<\/strong> on the latitude and longitude data that appears in decimal degrees in the location information box at the bottom. These latitude and longitude details will appear in the Google Search field.<\/li>\n<li><strong>Highlight and Copy<\/strong> both the latitude and longitude data together from the Search field.<\/li>\n<\/ol>\n<h4>Generating Geocoded Data Sets and Maps from Street Addresses<\/h4>\n<p>If you have a set of street addresses, finding geo-location data with these methods could be time consuming, if not\u00a0tedious. <a href=\"http:\/\/www.gpsvisualizer.com\/\" data-extlink=\"\">GPS Visualizer<\/a>\u00a0and <a href=\"https:\/\/www.geocod.io\/\">Gecodio <\/a>(free for 2,500 look ups per day)\u00a0are free tools that\u00a0can generate\u00a0tabular data\u00a0as well as maps from GIS coordinates, addresses, travel routes, and a number of\u00a0digital\u00a0sources. In addition, the<strong>\u00a0Social Explorer<\/strong>\u00a0platform features a<a href=\"https:\/\/www.socialexplorer.com\/blog\/post\/announcing-social-explorer-s-geocoder-v3-9252?utm_source=email&amp;utm_medium=newsletter&amp;utm_campaign=may_2018\" data-extlink=\"\"> new\u00a0geo-coder<\/a> within the platform that transforms addresses into geographic coordinates.<\/p>\n<\/div>\n<\/div>\n<h4><strong>Generating data while on location with your iPhone<\/strong><\/h4>\n<ul>\n<li>You can use your iPhone to collect geographic locations during your field research at your fieldsites where there is a GPS signal. <strong>Open<\/strong> the Compass app and your current geo-coordinates will appear on the bottom (your elevation appears beneath). <strong>Tap and hold<\/strong> on the latitude and longitude line, and <strong>select copy<\/strong>.<\/li>\n<li>From there you can <strong>paste<\/strong> the location data into a notebook, from which you can later copy and paste each location as an entry into an Excel or Sheets document. As you copy the data, you can <strong>remove<\/strong> the N,S,W,E initials from each entry.<\/li>\n<li>There are a number of Apps in the App Store for iPhone that collect GPS and geo-location data.<\/li>\n<\/ul>\n<div class=\"field-items\">\n<div class=\"field-item even\">\n<h4><strong>Storing your data in Excel<\/strong><\/h4>\n<ol>\n<li><strong>Create<\/strong> a new workbook in Excel. <strong>Name<\/strong> the workbook and save it on your local drive. <strong>Title<\/strong> the first three columns, \u201cName,\u201d \u201cLatitude\u201d and \u201cLongitude.\u201d<\/li>\n<li><strong>Paste<\/strong> the copied latitude and longitude data into the latitude column.<\/li>\n<li><strong>Separate<\/strong> the latitude and longitude values into their respective columns by <strong>cutting<\/strong> and <strong>pasting<\/strong> the longitude (the second decimal number) to the longitude column. Be sure to <strong>remove<\/strong> the leftover comma in the latitude column.<\/li>\n<li>You are ready to <strong>import<\/strong> the geographic data into software, such as ArcGIS, to create layered maps for data analysis and visualization. Be sure to save the workbook (sheet) on your own computer, or download it when you are ready to import to data analysis\/visualization software.<\/li>\n<\/ol>\n<h4>Storing your data in Sheets<\/h4>\n<ol>\n<li><strong>Create<\/strong> or <strong>Open<\/strong> a new on-line workbook in Google Sheets. Name the workbook and\u00a0 Title the first three columns as \u201cName,\u201d \u201cLatitude\u201d and \u201cLongitude.\u201d<\/li>\n<li><strong>Paste<\/strong> the copied latitude and longitude data into the Latitude column.<\/li>\n<li><strong>Separate<\/strong> the latitude and longitude values into their respective columns by <strong>clicking<\/strong> on the small pop-up paste menu that appears, and selecting \u201cSplit text to columns\u2026.\u201d Leave the Separator as \u201cComma,\u201d by clicking outside the menu.\u00a0[Note:\u00a0 This step is done manually in Excel; see above.]<\/li>\n<li>You are ready to <strong>import<\/strong> the geographic data into software, such as Carto, Datawrapper, or ArcGIS, to create maps for data analysis and visualization. To do this, first <strong>download<\/strong> the sheet from the google on-line platform. <strong>Export<\/strong> it as a new Excel, CSV or TSV file on your local drive.<\/li>\n<\/ol>\n<h4>Exporting your data<\/h4>\n<p><strong>Export<\/strong> and <strong>archive<\/strong> your Sheets and Excel worksheets in either the .TSV (tab separated values) or .CSV (comma separated values) format. Both Sheets and Excel are proprietary software that contain invisible formatting data. Further, Google Sheets can can only download your data in Excel, PDF, OpenDocument, .html (e.g. for web pages), .CSV and .TSV files. So in order to ensure that the data from your worksheets can be imported, visualized using the widest variety of other software tools, it is important to preserve your data in one of these plain formats. Even if some visualization software tools are currently able to read Excel files (e.g. Tableau), saving your work in plain .TSV or .CSV formats will ensure that you will be able to access your data from a wider variety of existing visualization tools and future generations of software. (See more tips on collecting structured data <a href=\"https:\/\/anthropology.princeton.edu\/research-programs\/vize-lab\/resources\/tip-sheets\/creating-structured-data-sets-visualization\">here<\/a>.)<\/p>\n<h4>Choosing your map&#8217;s color scheme based on the data<\/h4>\n<p>A <strong>sequential<\/strong> color scheme (or palette) plots a continuum of shades of a single color to represent values that use the same units of measure, from lesser to greater. Examples are population densities, dollars, or average ages. Note they can be aggregate numbers or specific values. A <strong>diverse<\/strong> color scheme use a palette to highlight how your data can represent diverse categories without a common underlying measure or continuum, such as social identities, or pizza toppings; data points only belong to one category. Any combinations would require their own discrete categories defined as such.<\/p>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-543 aligncenter\" src=\"https:\/\/commons.princeton.edu\/remote-ethnography\/wp-content\/uploads\/sites\/174\/2020\/08\/Screen-Shot-2020-08-23-at-12.41.12-PM-1024x571.png\" alt=\"\" width=\"1099\" height=\"612\" srcset=\"https:\/\/commons.princeton.edu\/remote-ethnography\/wp-content\/uploads\/sites\/174\/2020\/08\/Screen-Shot-2020-08-23-at-12.41.12-PM-1024x571.png 1024w, https:\/\/commons.princeton.edu\/remote-ethnography\/wp-content\/uploads\/sites\/174\/2020\/08\/Screen-Shot-2020-08-23-at-12.41.12-PM-300x167.png 300w, https:\/\/commons.princeton.edu\/remote-ethnography\/wp-content\/uploads\/sites\/174\/2020\/08\/Screen-Shot-2020-08-23-at-12.41.12-PM-768x428.png 768w, https:\/\/commons.princeton.edu\/remote-ethnography\/wp-content\/uploads\/sites\/174\/2020\/08\/Screen-Shot-2020-08-23-at-12.41.12-PM-1536x856.png 1536w, https:\/\/commons.princeton.edu\/remote-ethnography\/wp-content\/uploads\/sites\/174\/2020\/08\/Screen-Shot-2020-08-23-at-12.41.12-PM-2048x1141.png 2048w\" sizes=\"auto, (max-width: 1099px) 100vw, 1099px\" \/><\/p>\n<div class=\"field-item even\">\n<p>Look at the example above from our Carto tutorial on <strong>UFO sightings<\/strong>, where both color schemes appear. Each scheme represents a different data set. The <strong>diverse<\/strong> colors represent the data on different types of UFOs that were reported. Each UFO only has one discrete color. Among the shaded counties, however, data on the number of people with Bachelor&#8217;s degrees is plotted. Here, the <strong>sequential<\/strong>\u00a0lighter-to-darker shades of a common color &#8211; blue &#8211; represent a linear measurable continuum of people with a BA ranging from 11.7% to 54.1%.<\/p>\n<p>A third color scheme is a <strong>divergent<\/strong> palette. In this case, the data is represented as starting from a single point and moves away from that point in two opposite, positive and negative directions. For instance, colors are sequentially shaded in one color toward the positive side and sequentially shaded in a contrasting color toward the opposite negative side. Note that these are sometimes used instead of a sequential palette. Yet this can be misleading if there is no meaning central point in the data. For example, a divergent scheme applied to the Bachelor&#8217;s degree data in this has no necessary central point in the context of stories about UFOs. That depiction would add an unnecessary degree of visual complexity, and possibly confuse readings. If you did want to map how each county is related to the California average in another context, however, you would make the 24% the center of a divergent palette of two contrasting colors. But here, that data seems to get in the way of a narrative about UFO sightings.<\/p>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<\/div>\n<\/article>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>These instructions will help you collect and clean geo-location data sets during or possibly after\u00a0your research. With this data that includes geographic latitude and longitude coordinates, you will be able to create layered maps that display relationships among selected locations, and in connection with the wide variety of other numerical and qualitative data that you [&hellip;]<\/p>\n","protected":false},"author":142,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-672","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/commons.princeton.edu\/remote-ethnography\/wp-json\/wp\/v2\/pages\/672","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/commons.princeton.edu\/remote-ethnography\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/commons.princeton.edu\/remote-ethnography\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/commons.princeton.edu\/remote-ethnography\/wp-json\/wp\/v2\/users\/142"}],"replies":[{"embeddable":true,"href":"https:\/\/commons.princeton.edu\/remote-ethnography\/wp-json\/wp\/v2\/comments?post=672"}],"version-history":[{"count":12,"href":"https:\/\/commons.princeton.edu\/remote-ethnography\/wp-json\/wp\/v2\/pages\/672\/revisions"}],"predecessor-version":[{"id":768,"href":"https:\/\/commons.princeton.edu\/remote-ethnography\/wp-json\/wp\/v2\/pages\/672\/revisions\/768"}],"wp:attachment":[{"href":"https:\/\/commons.princeton.edu\/remote-ethnography\/wp-json\/wp\/v2\/media?parent=672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}