{"id":128,"date":"2021-07-15T07:50:21","date_gmt":"2021-07-15T12:50:21","guid":{"rendered":"https:\/\/sites.owu.edu\/geog-112\/?page_id=128"},"modified":"2022-07-13T09:10:38","modified_gmt":"2022-07-13T14:10:38","slug":"lab-5-data-processing-2","status":"publish","type":"page","link":"https:\/\/sites.owu.edu\/geog-112\/schedule-content\/lab-5-data-processing-2\/","title":{"rendered":"Lab 5: Data Processing 2"},"content":{"rendered":"<blockquote style=\"border: 0px solid #666;padding: 10px;background-color: #f2f2f2\"><p>Update 7\/13\/2022<\/p><\/blockquote>\n<p><strong>100 points<br \/>\n<\/strong>Assign: Wednesday, Sept. 28<br \/>\nDue: Monday, Oct. 10<\/p>\n<blockquote style=\"border: 0px solid #666;padding: 10px;background-color: #f2f2f2\"><p><strong>Getting Data into ArcGIS Pro and Processing for Animation<\/strong><\/p><\/blockquote>\n<p>The data (historical population, by county, for your state) downloaded from the WWW must be processed in order to use it in ArcGIS Peo. There are two basic data processing tasks involved in this project. In <b>Lab 3,<\/b> you used <b>Excel<\/b> to clean up and combine your data into an Excel file.<\/p>\n<p>In <b>Lab 5<\/b> you will import your\u00a0<b>.xlsx<\/b>\u00a0file into <b>ArcGIS Pro. <\/b>Additional processing is required to prepare the data for animation. For now, we are working with the total population data. In the past we have calculated percent population change (which is more interesting to map) but ArcGIS Pro is making this difficult to do with data intended for animation. I&#8217;ll update this lab when I figure out an easy way to generate the population change data.<\/p>\n<blockquote style=\"border: 0px solid #666;padding: 10px;background-color: #f2f2f2\"><p><strong>The Details<\/strong><\/p><\/blockquote>\n<p>The process below consists of getting a map of your state by counties, adjusting it&#8217;s map projection, then processing your total population data in ArcGIS Pro so that it can be animated. That data will be joined to the state map, and a few more adjustments made for animation.<\/p>\n<p><em>With the new ArcGIS Pro, this is a brand new lab with instructions that are bound to have some errors and typos. Let me know and I&#8217;ll fix them.<\/em><\/p>\n<blockquote style=\"border: 0px solid #666;padding: 10px;background-color: #f2f2f2\">\n<ol>\n<li><b>A map of your state counties in ArcGIS Pro\u00a0<\/b><\/li>\n<\/ol>\n<\/blockquote>\n<p><em>I&#8217;m using Wisconsin as an example. Substitute your state name.<\/em><\/p>\n<p><strong>Open ArcGIS Pro<\/strong> (shortcut on desktop)<\/p>\n<p><span style=\"font-size: 1rem\">Under <\/span><strong style=\"font-size: 1rem\">New &gt;<\/strong><span style=\"font-size: 1rem\">\u00a0<\/span><strong style=\"font-size: 1rem\">Blank Templates &gt;<\/strong><span style=\"font-size: 1rem\">\u00a0<\/span><strong style=\"font-size: 1rem\">Map<\/strong><\/p>\n<p><strong style=\"font-size: 1rem\">Name<\/strong><span style=\"font-size: 1rem\">: <\/span><strong style=\"font-size: 1rem\">Wisconsin<\/strong><\/p>\n<p><strong style=\"font-size: 1rem\">Location<\/strong><span style=\"font-size: 1rem\">: Documents\\ArcGIS\\Projects (yes, create a <\/span><strong style=\"font-size: 1rem\">new folder<\/strong><span style=\"font-size: 1rem\"> for this project)<\/span><\/p>\n<p><strong style=\"font-size: 1rem\">Contents<\/strong><span style=\"font-size: 1rem\">: change &#8220;Map&#8221; to Wisconsin<\/span><\/p>\n<p><span style=\"font-size: 1rem\">Right click on <\/span><strong style=\"font-size: 1rem\">Wisconsin &gt;<\/strong><span style=\"font-size: 1rem\">\u00a0<\/span><strong style=\"font-size: 1rem\">Add Data<\/strong><\/p>\n<p><strong style=\"font-size: 1rem\">Navigate to:<\/strong><span style=\"font-size: 1rem\"> C: GIS Lab Data &gt; ESRI &gt; ESRIDATA_2000 &gt; usa &gt; counties.shp<\/span><\/p>\n<p><em style=\"font-size: 1rem\"><strong>Fun Facts: shape (.shp) files vs geodatabase (.gdb)<\/strong><\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-733 aligncenter\" style=\"font-size: 1rem\" src=\"https:\/\/sites.owu.edu\/geog-112\/wp-content\/uploads\/sites\/186\/2022\/07\/shapefilevsgeodatabase.png\" alt=\"\" width=\"341\" height=\"342\" srcset=\"https:\/\/sites.owu.edu\/geog-112\/wp-content\/uploads\/sites\/186\/2022\/07\/shapefilevsgeodatabase.png 1154w, https:\/\/sites.owu.edu\/geog-112\/wp-content\/uploads\/sites\/186\/2022\/07\/shapefilevsgeodatabase-300x300.png 300w, https:\/\/sites.owu.edu\/geog-112\/wp-content\/uploads\/sites\/186\/2022\/07\/shapefilevsgeodatabase-1020x1024.png 1020w, https:\/\/sites.owu.edu\/geog-112\/wp-content\/uploads\/sites\/186\/2022\/07\/shapefilevsgeodatabase-150x150.png 150w, https:\/\/sites.owu.edu\/geog-112\/wp-content\/uploads\/sites\/186\/2022\/07\/shapefilevsgeodatabase-768x771.png 768w, https:\/\/sites.owu.edu\/geog-112\/wp-content\/uploads\/sites\/186\/2022\/07\/shapefilevsgeodatabase-240x240.png 240w\" sizes=\"auto, (max-width: 341px) 100vw, 341px\" \/><\/p>\n<p>Click on <strong>Map<\/strong> <strong>tab<\/strong> at top (to right of Project)<\/p>\n<p>Click on<strong> Select by Attributes<\/strong><\/p>\n<p>In pop-up, next to <strong>Where<\/strong> select <strong>STATE_NAME<\/strong><\/p>\n<p style=\"padding-left: 40px\">is equal to<br \/>\n<span style=\"font-size: 1rem\">select <\/span><strong style=\"font-size: 1rem\">WISCONSIN<\/strong><span style=\"font-size: 1rem\"> &gt; OK<\/span><\/p>\n<p style=\"padding-left: 40px\"><em>We have selected WI out of the entire US!<\/em><\/p>\n<p><span style=\"font-size: 1rem\">Right click on <\/span><strong style=\"font-size: 1rem\">counties<\/strong><span style=\"font-size: 1rem\"> layer in <\/span><strong style=\"font-size: 1rem\">Contents<\/strong><span style=\"font-size: 1rem\"> (on left)<\/span><\/p>\n<p><strong>Selection<\/strong> &gt; <strong>Make Layer from Selected Features<\/strong><\/p>\n<p><strong>Change name<\/strong> of new layer &#8211; &#8220;counties selection&#8221; &#8211; to <strong>Wisconsin Counties<\/strong><\/p>\n<p>Right click on original &#8220;counties&#8221; layer in Contents &gt; <strong>remove<\/strong><\/p>\n<p>Also <strong>remove<\/strong> Topographic<\/p>\n<p>In <strong>Map tab,<\/strong> click on <strong>small globe<\/strong> to upper right of Explore: <strong>full extent<\/strong><\/p>\n<p><em>We are actually still using the counties.shp data, thus the extent is the entire US, but can&#8217;t see the rest. We need to\u00a0extract and save our state counties as a separate file.<\/em><\/p>\n<p>Right click on <strong>Wisconsin Counties<\/strong><\/p>\n<p><strong>Data<\/strong> &gt; <strong>Export Features<\/strong><\/p>\n<ul>\n<li><strong style=\"font-size: 1rem\">Output Name:<\/strong><span style=\"font-size: 1rem\"><strong> Wisconsin_Counties<\/strong> \u00a0<\/span><span style=\"font-size: 1rem\">(underscore is important)<\/span><strong><br \/>\n<\/strong><\/li>\n<\/ul>\n<p><strong style=\"font-size: 1rem\">Remove Wisconsin Counties layer <\/strong>(the layer <strong>without<\/strong> underscore)<\/p>\n<p><strong>Click<\/strong> Full extent icon:\u00a0state should fill screen<\/p>\n<p><strong>Save<\/strong> project<\/p>\n<p><span style=\"color: #ff0000\">Use the <strong>Windows Snipping tool<\/strong> to make a screen shot of progress to this point, and include it in your lab log along with comments on any issues that arose in this step.<\/span><\/p>\n<blockquote style=\"border: 0px solid #666;padding: 10px;background-color: #f2f2f2\"><p><b>2. Select and add an appropriate map projection\u00a0<\/b><\/p><\/blockquote>\n<p><em><span style=\"font-size: 1rem\">Important information on map projections and coordinate systems: KW Ch. 5 (Geographic Framework)<\/span><\/em><\/p>\n<p><em style=\"font-size: 1rem\">Both are set as part of a Map (Wisconsin) and apply to all layers in the map (Wisconsin_Counties)<\/em><\/p>\n<p><span style=\"font-size: 1rem\">Right click on <\/span><strong style=\"font-size: 1rem\">Wisconsin<\/strong><span style=\"font-size: 1rem\"> and select <\/span><strong style=\"font-size: 1rem\">Properties &gt;\u00a0Coordinate Systems<\/strong><\/p>\n<p><span style=\"font-size: 1rem\">Scroll down and click on <strong>tiny triangle<\/strong> next to <\/span><strong style=\"font-size: 1rem\">Projected Coordinate Systems<\/strong><\/p>\n<p><span style=\"font-size: 1rem\">Click on triangle next to <\/span><strong style=\"font-size: 1rem\">Continental<\/strong><\/p>\n<p><span style=\"font-size: 1rem\">Click on triangle next to <\/span><strong style=\"font-size: 1rem\">North America<\/strong><\/p>\n<p><span style=\"font-size: 1rem\">Scroll down and click on <\/span><strong style=\"font-size: 1rem\">US Contiguous Albers Eaual Area Conic &gt;<\/strong><span style=\"font-size: 1rem\">\u00a0<\/span><strong style=\"font-size: 1rem\">OK<\/strong><\/p>\n<p><em>Is your cow tipped? Here&#8217;s how to fix it:<\/em><br \/>\n<span style=\"font-size: 1rem\"><br \/>\nRight click on <\/span><strong style=\"font-size: 1rem\">Wisconsin<\/strong><span style=\"font-size: 1rem\"> and select <\/span><strong style=\"font-size: 1rem\">Properties<\/strong><span style=\"font-size: 1rem\"> &gt;\u00a0<\/span><strong style=\"font-size: 1rem\">Coordinate Systems<\/strong><\/p>\n<p>Right click\u00a0<strong>Contiguous Albers Equal Area Conic<\/strong> &gt; <strong>Copy<\/strong> &gt; <strong>Modify<\/strong><\/p>\n<p>Change <strong>Central Meridian<\/strong> to your state&#8217;s central meridian. WI is -90. <strong>Save<\/strong> &gt; <strong>OK<\/strong><\/p>\n<p><em><span style=\"font-size: 1rem\">Use Google Earth to find the central meridian of your state.<\/span><\/em><\/p>\n<p><strong>Save<\/strong><\/p>\n<p>Right click <strong>Wisconsin_Counties<\/strong> &gt; <strong>Attribute Table<\/strong><\/p>\n<p>Notice the connection between the attribute table (data) and map<\/p>\n<p><strong>Close<\/strong> Wisconsin_Counties table and <strong>Save<\/strong><\/p>\n<p><span style=\"color: #ff0000\">Use the <strong>Windows Snipping tool<\/strong> to make a screen shot of progress to this point, and include it in your lab log along with a comment on why the Albers Equal Area conic is a good choice for map projection in this project.<\/span><\/p>\n<blockquote style=\"border: 0px solid #666;padding: 10px;background-color: #f2f2f2\"><p><b>3. Import your Excel file from Lab 3 <\/b><\/p><\/blockquote>\n<p><em>If new layers or files are not appearing where they should, right click and choose refresh<\/em><\/p>\n<p><strong style=\"font-size: 1rem\">View tab<\/strong><span style=\"font-size: 1rem\"> &gt; <\/span><strong style=\"font-size: 1rem\">Reset Panes<\/strong><span style=\"font-size: 1rem\"> &gt; \u00a0<\/span><strong style=\"font-size: 1rem\">Reset Panes for Geoprocessing<\/strong><\/p>\n<p><strong>Add data<\/strong><br \/>\n<strong><br \/>\nNavigate<\/strong> to your .xlsx file (Lab 3). Mine is wisconsin-1900-2020_transpose.xlsx in my Data folder in my Geog 112 folder.<\/p>\n<p><strong>Open<\/strong> (add) and you should see &#8216;1900-2020$&#8217; &#8211; the sheet name from your .xlsx fileRight-click &#8216;1900-2020$&#8217; then <strong>OK<\/strong><br \/>\n<strong><strong><br \/>\nSave<\/strong><\/strong><\/p>\n<blockquote style=\"border: 0px solid #666;padding: 10px;background-color: #f2f2f2\"><p><b>4. Transposing data<\/b><\/p><\/blockquote>\n<p><em>We transposed our data in Excel, but have to do it again. Data gymnastics. Temporal data in ArcGIS works best, according to ESRI, when unique spatiotemporal values are stored as separate rows in a single column.<\/em><\/p>\n<p><span style=\"font-size: 1rem\">In the Geoprocessing pane, type <\/span><strong style=\"font-size: 1rem\">Transpose Fields<\/strong><span style=\"font-size: 1rem\"> in the <\/span><strong style=\"font-size: 1rem\">search box.<\/strong><span style=\"font-size: 1rem\"> Click on it<\/span><\/p>\n<ul>\n<li><strong>Input Table:<\/strong> &#8216;1900-2020$&#8217;<\/li>\n<li>Under <strong>Fields to Transpose <\/strong>(next to Field) click <strong>Add Many<\/strong> (small circle button)<\/li>\n<li><strong>Select all<\/strong> (small button, bottom left) then <strong>uncheck<\/strong> <strong>Year<\/strong> then scroll down and <strong>Add<\/strong><br \/>\n<strong><br \/>\nVital<\/strong>: scroll down and see if any of the FIELD names have changed under VALUE<\/li>\n<\/ul>\n<p><em>For Wisconsin, blanks (Fond du Lac) have been replaced with underscores (Fond_du_Lac)<\/em><\/p>\n<p><em>Also, St. Croix is now St__Croix. Yikes!<\/em><\/p>\n<p><strong>VitalVital:<\/strong> carefully change the names in the VALUE column to match those in the FIELDS column<\/p>\n<p><strong>They MUST BE EXACTLY THE SAME.<\/strong><\/p>\n<p><em>Before you proceed ask me if there are any odd differences you can&#8217;t fix.<\/em><\/p>\n<ul>\n<li><strong style=\"font-size: 1rem\">Output Table:<\/strong><span style=\"font-size: 1rem\"> replace entire path with <\/span><strong style=\"font-size: 1rem\">pop_total_transposed<\/strong><\/li>\n<li><strong style=\"font-size: 1rem\">Transposed Field:<\/strong> <strong style=\"font-size: 1rem\">County<\/strong><\/li>\n<li><strong>Value Field:<\/strong> <strong>Pop<\/strong><\/li>\n<\/ul>\n<p><em>The transposed field is a new field in the output table that will store the names of the counties. The value field is a new field that will store the population values. You can use any name for these fields.<\/em><\/p>\n<ul>\n<li><strong>Attribute Fields<\/strong> (not add many) click and select <strong>Year<\/strong><\/li>\n<\/ul>\n<p><strong>Run.<\/strong>\u00a0Transposed data added to Contents<\/p>\n<p><strong>Close<\/strong> &#8216;1900-2020$&#8217; table<\/p>\n<p>Open\u00a0<strong style=\"font-size: 1rem\">pop_total_transposed<\/strong><span style=\"font-size: 1rem\"> table<\/span><\/p>\n<p><strong>Save<\/strong><\/p>\n<p><strong>Catalog Pane:<\/strong> the new table is under Databases<\/p>\n<p><span style=\"color: #ff0000\">Use the <strong>Windows Snipping tool<\/strong> to make a screen shot of the transposed table, and include it in your lab log along with comments on any issues that arose in this step.<\/span><\/p>\n<blockquote style=\"border: 0px solid #666;padding: 10px;background-color: #f2f2f2\"><p><b>5. Changing numbers stored as text to numerical values<\/b><\/p><\/blockquote>\n<p><em>In pop_total_transposed table: hover over Pop: It&#8217;s text! We can&#8217;t map text, we need numbers. Thus we need to create a <strong>new<\/strong> column (Field) that is <strong>numerical<\/strong> so we can map out the data.<\/em><\/p>\n<p>Click on <strong>Add Fields<\/strong> button (upper left corner, Next t0 Field: in the pop_total_transposed table)<\/p>\n<p>In the <strong>Fields View,<\/strong> your new field is indicated with a <strong>green marker<br \/>\n<\/strong><\/p>\n<ul>\n<li>Change <strong>name<\/strong>: &#8220;Field&#8221; to <strong>PopTotal<br \/>\n<\/strong><\/li>\n<li><strong>Alias<\/strong>: <strong>PopTotal<br \/>\n<\/strong><\/li>\n<li><strong>Data typle:<\/strong> click and change to <strong>Float<\/strong> (this type allows decimals)<\/li>\n<\/ul>\n<p>The <strong>Fields tab<\/strong> (top of page) should be selected:\u00a0<strong>Save<\/strong> (on the right)<\/p>\n<p><strong>Close<\/strong> the <strong>Fields view.<\/strong> You should see pop_total_transposed with a new Population column (Field) with &lt;NULL&gt;<\/p>\n<p>Right click on <strong>PopTotal<\/strong>\u00a0and <strong>Calculate Field<br \/>\n<\/strong><\/p>\n<p><em><em>This is where we could have calculated population change, if the table was arranged differently<\/em><\/em><\/p>\n<ul>\n<li><strong>Input Table:<\/strong> pop_total_transposed<\/li>\n<li><strong>Field Name:<\/strong> PopTotal<\/li>\n<li><strong>Expression Type:<\/strong> Python 3<\/li>\n<\/ul>\n<p>Under <strong>Fields<\/strong>\u00a0double click on (old text field) <strong>Pop<br \/>\n<\/strong><\/p>\n<ul>\n<li>Population =<\/li>\n<li>!Pop!<\/li>\n<\/ul>\n<p><strong>OK<br \/>\n<\/strong><\/p>\n<p><em>Check that new column (Population) is the same as old POP (except its numerical now)<\/em><\/p>\n<p>Right click on (old text field) <strong>Pop<\/strong> and <strong>Delete<br \/>\n<\/strong><\/p>\n<p><strong>Save<\/strong><\/p>\n<blockquote style=\"border: 0px solid #666;padding: 10px;background-color: #f2f2f2\"><p><b>6. Convert time values to date format<\/b><\/p><\/blockquote>\n<p><em>Convert our years (numeric format) to actual date format for animation.<\/em><\/p>\n<p>Geoprocessing pane:\u00a0hit <strong>back<\/strong> (arrow) and search for <strong>Convert Time Field<\/strong> &gt; open<\/p>\n<ul>\n<li><strong>Input Table:<\/strong> pop_total_transposed (pop_change_transposed)<\/li>\n<li><strong>Input Time Field:<\/strong> year<\/li>\n<li><strong>Input Time Format:<\/strong> click calendar and under Date Format select <strong>yyyy<\/strong><\/li>\n<\/ul>\n<p>Ignore local<\/p>\n<ul>\n<li><strong>Output time field:<\/strong> <strong>Year_Converted<\/strong><\/li>\n<li><strong>Output Time Type: Date<\/strong><\/li>\n<\/ul>\n<p><strong>Run<\/strong><\/p>\n<p><em>Check that Year_Converted column in table is all there. If so&#8230;<\/em><\/p>\n<p><strong>Save<\/strong><\/p>\n<p><strong>Delete<\/strong> old Year column &gt;\u00a0<strong>Save<\/strong><\/p>\n<p><span style=\"color: #ff0000\">Use the <strong>Windows Snipping tool<\/strong> to make a screen shot of the outcome of steps 5 and 6, and include it in your lab log along with comments on any issues that arose in this step.<\/span><\/p>\n<blockquote style=\"border: 0px solid #666;padding: 10px;background-color: #f2f2f2\"><p><b>7. Join the modified table to the layer with your state map<\/b><\/p><\/blockquote>\n<p><em>Joining is a common GIS function where we combine (connect) two data tables together using a common column of data in both tables.<\/em><\/p>\n<p>Right click on <strong>Wisconsin_Counties<\/strong> &gt; <strong>Attribute Table<\/strong>&lt;<\/p>\n<p><em>We need to join the <strong>attribute table<\/strong> from <strong>Wisconsin_Counties<\/strong> with the <strong>pop_total_transposed<\/strong> table (with our population data in it) so we can map the data (and eventually animate it).<\/em><\/p>\n<p>Right click on <strong>Wisconsin_Counties<\/strong> &gt; <strong>Joins and Relates<\/strong> &gt; <strong>Add Join<\/strong><\/p>\n<ul>\n<li><strong>Input Table:<\/strong> <strong>Wisconsin_Counties<\/strong><\/li>\n<li><strong>Input Join Field:<\/strong> <strong>NAME<\/strong><\/li>\n<li><strong>Join Table:<\/strong> <strong>pop_total_transposed<\/strong><\/li>\n<li><strong>Join Table Field: County<\/strong><\/li>\n<li>Click <strong>Index Joined Fields<\/strong> then <strong>Validate Join<\/strong><\/li>\n<\/ul>\n<p><em>If you get an error message let your instructor know<\/em><\/p>\n<p><strong>Run<\/strong><\/p>\n<p><strong>Save<\/strong><\/p>\n<p><em>To make things easier to work with, hide unneeded columns \/ Fields<\/em><\/p>\n<p>Right click on <strong>Wisconsin_Counties<\/strong> layer and select <strong>Attribute Table<\/strong><\/p>\n<p>Right click on <strong>any field<\/strong> <strong>header<\/strong> and select <strong>Fields<\/strong><\/p>\n<p><strong>Uncheck Visible<\/strong><\/p>\n<p><em>Scroll down and <strong>recheck<\/strong> at end, <strong>County<\/strong>, <strong>PopTotal<\/strong>, and <strong>Year_Converted<\/strong> (all under alias)<\/em><\/p>\n<p><em>This leaves us with the county name, total population, and year: you can always go back and make invisible fields visible again.<\/em><\/p>\n<p><span style=\"color: #ff0000\">Use the <strong>Windows Snipping tool<\/strong> to make a screen shot of your joined data table with the three visible columns, and include it in your lab log along with comments on any issues that arose in this step.<\/span><\/p>\n<blockquote style=\"border: 0px solid #666;padding: 10px;background-color: #f2f2f2\"><p><b>8. Map Symbolization<\/b><\/p><\/blockquote>\n<p><em>We&#8217;ll do much more with map symbolization in Lab 7 but for now we&#8217;ll run through a few modifications that will allow you to symbolize your map.<\/em><\/p>\n<p>Right click on <strong>Wisconsin_Counties<\/strong> and select <strong>Symbology<\/strong><\/p>\n<ul>\n<li><strong>Primary symbology:<\/strong> <strong>Graduated Colors<\/strong> (also known as choropleth)<\/li>\n<li><strong>Field:<\/strong> <strong>PopTotal<\/strong><\/li>\n<li><strong>Normalization: &lt;none&gt;<\/strong><\/li>\n<li><strong>Method: Natural Breaks (Jenks)<\/strong><\/li>\n<li><strong>Classes: 5<\/strong><\/li>\n<\/ul>\n<p>Under <strong>More<\/strong>: <strong>Reverse Symbol Order<\/strong><\/p>\n<p>Click once on <strong>Upper Value<\/strong> and select <strong>Reverse Values<\/strong><\/p>\n<p>Under <strong>More<\/strong>: <strong>Format All Symbols<\/strong><\/p>\n<p>Click on <strong>Properties<\/strong><\/p>\n<p>Change <strong>Outline Color<\/strong> to <strong>White<\/strong> and <strong>width<\/strong> to <strong>1pt<\/strong> and <strong>Apply<\/strong><\/p>\n<p>Under <strong>More<\/strong>: <strong>Show Values out of Range<\/strong><\/p>\n<p><em>These are the no data counties! They were blanks in Excel and &lt;null&gt; in ArcGIS Pro<\/em><\/p>\n<p>Under <strong>Label<\/strong> change name to <strong>No data<\/strong><\/p>\n<p>Double click on <strong>dark grey <a href=\"https:\/\/www.youtube.com\/watch?v=AGl3_7jdUb0\" target=\"_blank\" rel=\"noopener\">color box<\/a><\/strong> for No Data<\/p>\n<ul>\n<li><strong>Color<\/strong>: 20% gray<\/li>\n<li><strong>Outline color<\/strong>: white<\/li>\n<li><strong>Outline width<\/strong>: 1pt<\/li>\n<\/ul>\n<p>In <strong>Symbology<\/strong> pane, click on last icon, <strong>Advanced Symbology Options<\/strong><\/p>\n<p><strong>Decimal Places:<\/strong> change to <strong>0<\/strong> and Enter<\/p>\n<p><strong>Save<\/strong><\/p>\n<p><em>Feel free to putter with more options here.<\/em><\/p>\n<p><span style=\"color: #ff0000\">Use the <strong>Windows Snipping tool<\/strong> to make a screen shot of your map, and include it in your lab log along with comments on any issues that arose in this step.<\/span><\/p>\n<blockquote style=\"border: 0px solid #666;padding: 10px;background-color: #f2f2f2\"><p><b>9. Enable time and animate the map<\/b><\/p><\/blockquote>\n<p><em>Animation in ArcGIS Pro requires you to enable time on the map<\/em><\/p>\n<p>Right click <strong>Wisconsin_Counties<\/strong> &gt; <strong>Properties<\/strong> &gt; <strong>Time<\/strong><\/p>\n<ul>\n<li><strong>Layer Time:<\/strong> <strong>Each feature has a single time field<\/strong><\/li>\n<li><strong>Time Field: Year_Converted<\/strong><\/li>\n<\/ul>\n<p>Leave the rest the same &gt; \u00a0<strong>OK<\/strong><\/p>\n<p><em>A <strong>time slider<\/strong> should appear<\/em><\/p>\n<p>On the <strong>left<\/strong> side of the time slider, click <strong>Time disabled<\/strong> (clock symbol) to change it to <strong>Time enabled<\/strong><\/p>\n<p>Under the <strong>Time tab<\/strong> at top, click on <strong>Time Snapping<\/strong> and set it to <strong>Decades<\/strong><\/p>\n<p><em>I&#8217;ve noticed that the Decades setting has a tendency to reset to years. You may have to readjust later.<\/em><\/p>\n<p>Make sure <strong>Span<\/strong> (on left) is<strong> 0<\/strong> (decades)<\/p>\n<p><em>You can hit the <strong>Play All Steps<\/strong> (play) button (to right of Time Snapping) and adjust speed.<\/em><\/p>\n<p><strong>Save<\/strong><\/p>\n<p><span style=\"color: #ff0000\">Use the <strong>Windows Snipping tool<\/strong> to make a screen shot of your state map with the time bar, and include it in your lab log along with comments on any issues that arose in this step.<\/span><\/p>\n<p><em>We will return in Lab 8 to set up our animations and export them to video.<\/em><\/p>\n<hr align=\"CENTER\" size=\"5\" width=\"400\" \/>\n<p>In this exercise, you have learned how to <b>join<\/b> data you found on the <b>WWW<\/b> and processed in <b>Excel<\/b> (.xlsx)\u00a0to an existing ArcGIS Pro map. You modified the\u00a0<b>map projection<\/b>\u00a0and further processed the data in ArcGIS Pro so it could be mapped and animated.<\/p>\n<p><strong>Next:<\/strong> you will make important decisions about how to <b>classify<\/b> and <b>symbolize<\/b> your population data as a choropleth (value by county), dot, and graduated symbol map in <b>Lab 6.<\/b> But first, the beloved mid-term project evaluation!<\/p>\n<blockquote style=\"border: 0px solid #666;padding: 10px;background-color: #f2f2f2\"><p>Completing the Lab<\/p><\/blockquote>\n<p>By end of class on the due date:<\/p>\n<p>Prepare to show your instructor your county map, symbolized and with the time bar (which requires the data tables to be properly processed).<\/p>\n<p>Email me the link to your blog entry for Lab 5. The blog entry should include<\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>comments and screen shots as requested above for steps 1, 2, 4, 5, 7, 8 and 9<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Update 7\/13\/2022 100 points Assign: Wednesday, Sept. 28 Due: Monday, Oct. 10 Getting Data into ArcGIS Pro and Processing for Animation The data (historical population, by county, for your state) downloaded from the WWW must be processed in order to <span class=\"readmore\"><a href=\"https:\/\/sites.owu.edu\/geog-112\/schedule-content\/lab-5-data-processing-2\/\">Continue Reading<\/a><\/span><\/p>\n","protected":false},"author":138,"featured_media":0,"parent":52,"menu_order":7,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-128","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/sites.owu.edu\/geog-112\/wp-json\/wp\/v2\/pages\/128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sites.owu.edu\/geog-112\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/sites.owu.edu\/geog-112\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/sites.owu.edu\/geog-112\/wp-json\/wp\/v2\/users\/138"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.owu.edu\/geog-112\/wp-json\/wp\/v2\/comments?post=128"}],"version-history":[{"count":97,"href":"https:\/\/sites.owu.edu\/geog-112\/wp-json\/wp\/v2\/pages\/128\/revisions"}],"predecessor-version":[{"id":804,"href":"https:\/\/sites.owu.edu\/geog-112\/wp-json\/wp\/v2\/pages\/128\/revisions\/804"}],"up":[{"embeddable":true,"href":"https:\/\/sites.owu.edu\/geog-112\/wp-json\/wp\/v2\/pages\/52"}],"wp:attachment":[{"href":"https:\/\/sites.owu.edu\/geog-112\/wp-json\/wp\/v2\/media?parent=128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}