Last updated: November 30, 2019

Adding and calculating a new field in MapGeo Studio is a common use of SQL. This is a quick way to edit datasets within MapGeo Studio itself, instead of having to import changes from other platforms such as ArcGIS. 

To create a new field, you will need to navigate to the dataset you would like to edit:

  • In the bottom right corner of the dataset view there is a button with three columns and plus sign. Select this button.

  • A new field will be created with the default option to rename the field. Rename the field by typing. If you would like to rename it in the future, click the name of the field to open a drop down menu and select “Rename Column.”

  • Once the column is named, you can calculate the field using SQL. In the right hand panel, type in your SQL query and click Submit.

Tips and Tricks

  • If there is a new field you have created in your data in a different platform, such as ArcGIS, and you plan to upload the updated data through the MapGeo uploader, you will need to add a new field to the dataset in MapGeo Studio. 

  • See the common SQL queries help page for highly used queries for calculating fields.

Next: SQL in MapGeo Studio