When looking for a easy way to update a clients google map, i ran into google’s Spreadsheet Mapper. It is a pretty crafty way of connecting a google spreadsheet with a google map. It is a spreadsheet entry for creating a kml file that can be displayed in google maps or google earth. The application that we used it for was updating a realitors website with properties that are currently for sale, or have sold. The Spreadsheet Mapper simple has you fill in the information that you want in the ballon and they are created and added to your google spreadsheet. The best part is that if you publish the map in a website you do not have to update any of the code on the website, it will dynamically refresh with any new information that you have entered into the associated spreadsheet. This makes the process easily accomplished by anyone, not just your webmaster or GIS professional. So if you are looking for a not to technical way to create your google maps that are continually being added to check out this Spreadsheet Mapper tutorial .
Tag: Google Earth
How to Convert Google Earth kml to a shapefile
Working with non gis data formats can often add benefits to a GIS project. One of them is that there can be existing data in a consumer format such as Google Earths KML. Using existing data can help you become familiar with the area of the project and also cut down on the amount of field time that it would take to recollect the data. I will show the best way that I have found to import Google Earth KML files into ESRIs shapefile format.
There are a couple of tools out that can help you import kml to shp but the best one that i have found is the Department of Natural Resources of Minnesota DNR Garmin extension. You can download the script at the DNR website. This program can also be used as a stand program if you do not have ESRI ARCgis. Open the kml file by going to the file menu and selecting Load From -> File. On file type drop down select the kml file extension and browse to the file you want to load. An Output Shape dialog box will appear and select between Point, Line, or Polygon depending on the format you want the data displayed as. When the file has successfully loaded you will not want to save it as a shp by going to File -> Save To -> File. In the Save as Type drop down menu you will have two choices of shapefile to save it as. You can save it as a projected or unprojected shapefile. Select the one you want, browse to where you want it saved and name the file. When the process is complete you will have the kml data in a shapefile that you can open in Arcview or many other GIS software packages. Before you bring it into ARCgis remember to define the projection as DNR Garmin does not do it.
Converting KML files to shapefile is only one of the many great features of DNR Garmin, and they are continually updating and improving it. If you work with Garmin GPS receivers in your GIS work flow this utility will help you easily incorporate the data into you regular working environment.[ad#Google Adsense under post links]