Firehalls in the City of Vancouver, and Parks & Garbage Centers of Mesquite Texas

This is a demo map of a GIS map I created using pre-existing latitude and longitude data in an Excel spreadsheet.  The spreadsheet was uploaded into Google Drive and saved as a CSV file which is shared to the general public (to provide access to my account).  Then the URL for the Google CSV file is copied and shared in my ArcGIS file and over layed on top of a street base map.

The hardest part of this process was getting Google to save the document as a CSV file format.  The rest was pretty straight forward.  Once the Google Doc is linked to the ArcGIS map, you can modify the data in the Google Doc and the changes will be reflected in the ArcGIS map.  It is a pretty slick system.

Here is a link to a sample map (don’t forget to share your file to everyone):


The example below is using existing kml files (Keyhole Markup Language, which are over glorified xml files) and side stepping kml file editing issues with AcrGIS by using Google Earth.  This was a little bit more of a stretch for me because actually finding and saving kml files was an issue (the directions I was following were a little less descriptive).  Once I had the files, the process was easy.  I’m not sure if I know exactly WHY or in what situations one would use kml files over other types of files; this reason wasn’t explained in the tutorial directions, but perhaps in the book the class is following (which I don’t have).  The map below is much larger in scale (viewed higher in the sky) intentionally as to provide perspective of where Mesquite, Texas is located.



About repplinger

John has served as a Reference Librarian at Willamette University since 2002. He is the liaison to the Science Departments, and is responsible for maintaining the collections related to the life & physical sciences. His research interests range over the entire spectrum of libraries and information sciences, but includes: - Google and its influence on information & society - The Internet's influence on information seeking & sharing behaviors - Trends of scholarly communication - Electronic learning environments - Traditional pedagogy - GIS use in academic libraries

Posted on February 18, 2013, in Maps and tagged , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: