For a quick guide on creating a georeference column, please see our How To video!
Location columns can be configured from a dataset draft if this is for an existing dataset click 'Edit' from the action bar to get started.
From the data preview page, open the Add Georeference tab from the sidebar on the left.
The geocoding toll will accept 3 different formats for creating a location column.
Latitude and Longitude values from two columns in the dataset.
Address information that is split up into street address, city, state and zipcode.
Combined values like latitude-longitude or full street address.
Remapping your location column
If for any reason the mapping of your location column is not stored in the revision (this can occure if there is a change in your source schema or if you are editing your dataset for the first time with the new publishing tool), you will have the option to remap your columns.
When this happens you will first see a Column Mismatch warning like below:
From here you can select Other Fix Options > Configure My Location Column. This will open the Georeference modal as described above. Where you can now once again set up your location column based on lat/long, address, or a combined location column!
Adding a location column using Transforms
Location columns can also be created using the data transformer tool. To do so, use the Add Column button from the sidebar to get started. From the new column, open the column drop down menu and select Data Transforms.
From the transforms editor, you can specify which column values will be used to create the new location column. For this example, Latitude and Longitude data was used:
Reference text: to_point('POINT ('||`longitude`||' '||`latitude`||')')
The to_point() function converts text values to create a georeferenced point. In this dataset the longitude and latitude values are split into 2 columns, so in this transform the values are combined using the || transform to combine multiple strings.
The make_point() function can be used to create georeferenced points as well if the column values are already stored in a number data type. The example below converts text format lat/long to numbers.
Reference text: make_point(to_number(`latitude`),to_number(`longitude`))