Creating Georeference/Location Columns in the New Publishing Experience

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.

Lat/Long

Latitude and Longitude values from two columns in the dataset.

Address

Address information that is split up into street address, city, state and zipcode.

Combined Location

Combined values like latitude longitude or full street address.

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`))

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.