English, GIS, Tutorials

5 commands you should know in ArcGIS

Nowadays, it is so easy to use maps and geography can be loved by everyone (almost everyone…).

The easy access to these tools draws attention of new professionals eager to learn and use them. However, when we start learning something, we can trip on some obstacles. So we decide to write some commands and tips you should know when starting using ArcGIS that can improve your maps and save some time.

Continue reading “5 commands you should know in ArcGIS”

English, Tutorials

Extracting Geographic Coordinates from Spreadsheet Cells [and Converting THEM]

Geographic coordinates are numbers used to locate elements, objects, places (etc) on the Earth’s surface. Our planet is vertical and horizontally divided in angles, which are called longitude and latitude, respectively.

Spreadsheets are a very good way to arrange a great range of information, including coordinates. But if they are used carelessly, it can bring headaches from other planets… Especially if you want to extract a piece of information from a cell, i.e. remove useless information.

Suppose you have a huge spreadsheet with many geographic coordinates (e.g. 28°40′39″S 49°22′11″W) and you need to separate the degrees, minutes and seconds from each other. This is necessary, if your GIS software only accepts decimal degrees. One way (the hardest way), is to edit each cell and copy and paste to another cell… boring and time consuming. Another way is to create a function (formula) that can do this for us!

Continue reading “Extracting Geographic Coordinates from Spreadsheet Cells [and Converting THEM]”