Agenda

  • General Tech.
  • Recap (Openstreetmap)
  • CSV!

 

Organizing Your Data

Organizing your data is very important both when you collect it and when you display it. Sometimes both times are dependent upon each other. For example, some digital mapping tools may need you to organize your information in an excel sheet with labels or need your to convert your geo data.

This week, we will be taking a step back to look at ways of importing large amounts of data


Geocoding

Geocoding is the act of converting addresses to latitude and longitudinal coordinates. Certain mapping tools require you to geocode geographic data before automatically mapping the locations for you. Because you might not want to gather the latitude and longitude coordinates for hundreds of addresses, you need to find a converter to speed up the process.  Sometimes you will have to include this information to your Excel sheet when uploading data for your map (depends on your mapping tool). Here are some resources:

Excel 


CSV

A comma-separated values (CSV) file stores tabular data (numbers and text) in plain text. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the comma as a field separator is the source of the name for this file format.

 Importing CSV to Google My Maps

Homework: 
  • Create an Excel Spreadsheet with 4 Different parts of information EX. Location, Date, Name etc…
    • Address is important here
    • Feel free to refer to video for ideas, but stick to a theme
      •  Some ideas are schools, tutoring centers, nonprofits, homeless shelters etcs
    • Save as CSV file type
  • Input 10 different entries
    •  Have atleast 2 different kinds of entries EX Schools and Tutoring Centers
  • Visit https://maps.google.com/
  • Locate and click “My Maps” ( To directly visit it, click here.)
  • Click on “Create” —> then “Import”
  • Import a CSV file, XLSX file, classic My Map, TSV, KML file, or sheet from Google Drive with geographically-specific data including addresses, place names, or lat/longs.
  • Style the 2 Different kinds of entries, grouping them together through tab colors or shape
  • 2 Screenshots – 1 of Map with the points plotted and another of your excel csv file

Tonight is the Working for Dignity Presentation.

Steve McKay is hosting an event today at 7pm at the Museum of Art and History regarding the minimum wage. As it as an event that will have community organizations that tackle social justice issues regarding low-wage, I encourage you all to come check it out! Feel free to email me any questions.  I encourage everyone to go and support an issue that is likely affecting you or a loved one.