Data-flo
Data-floSource CodeCGPS
  • INTRODUCTION
    • What is Data-flo
    • Getting Started - Sign In
    • Privacy and Terms Of Service
    • Contact - Help & reporting errors
    • Change log
  • USING DATA-FLO
    • Data-flo site navigation
      • Transformations Page
      • Run Page
      • Canvas
    • Data
      • Bringing data in to Data-flo
      • Getting data out of Data-flo
      • Data Types
        • Boolean
        • Datatable
        • File
        • Graph
        • List
        • Map
        • Number
        • Text
    • Regular Expressions (RegEx)
    • Adaptors overview
      • Components of an adaptor
      • Binding types
        • Bind to Data-flo input
        • Bind to value
        • Bind to another transformation
    • Specific adaptors
      • add-column
      • append-to-list
      • calculate-time-difference
      • change-column-case
      • columns-concatenation
      • concatenate-text
      • create-microreact-project
      • csv-file-to-datatable
      • csv-to-datatable
      • datatable-columns
      • datatable-to-csv-file
      • datatable-to-graph
      • datatable-to-list
      • datatable-to-map
      • datatable-to-sqlite-file
      • date-to-text
      • dbf-file
      • dot-to-graph
      • download-file
      • dropbox-file
      • epicollect-project
      • extend-datatable
      • figshare-file
      • file-to-text
      • filter-blank-values
      • filter-columns
      • filter-list
      • filter-rows
      • filter-rows-numerically
      • force-directed-layout
      • format-date-column
      • forward-geocoding
      • ftp-file
      • gather-rows
      • google-drive-file
      • google-spreadsheet
      • graph-to-dot
      • join-datatables
      • list-to-datatable
      • lookup-map-value
      • merge-datatables
      • merge-lists
      • microreact-project
      • mysql-database
      • newick-leaf-labels
      • oracle-database
      • postgress-database
      • prepend-to-list
      • remove-columns
      • remove-duplicate-rows
      • rename-columns
      • replace-blank-values
      • replace-column-values
      • replace-text
      • replace-text-in-list
      • replace-value
      • reverse-geocoding
      • row-column-value
      • s3-file
      • select-columns
      • send-email-message
      • slice-datatable
      • slice-list
      • smb-file
      • sort-datatable
      • sort-list
      • split-column
      • split-datatable-rows
      • split-list
      • split-text
      • spread-rows
      • spreadsheet-file
      • sql-server-database
      • sqlite-database
      • sum-rows
      • text-template
      • text-to-file
      • unique-list-items
      • update-epicollect-entries
      • update-microreact-project
      • update-smb-file
      • upload-file-to-google-drive
      • upload-files-to-google-drive
      • url-builder
      • yaml-to-json
    • Building a data-flo
      • Debugging mode
      • Show detailed errors on Run Page
      • Permissions - Access Control
    • Tips & Tricks
  • TUTORIALS
    • Prep outbreak data for Microreact
    • Common use cases, solved
      • Fixing datatable headers
      • Select, remove, rename, reorder columns
      • Data in separate files
      • There's no single-column unique row ID (primary key)
      • Ensure non-dates stay non-dates
      • Connect directly to a database
      • Access files on a drive
Powered by GitBook
On this page
  • Arguments
  • Example
  • Possible use cases
  • Troubleshooting

Was this helpful?

  1. USING DATA-FLO
  2. Specific adaptors

forward-geocoding

Converts location names in a datatable column to +/- latitude & longitude

Previousformat-date-columnNextftp-file

Last updated 1 year ago

Was this helpful?

Much information about geocoding exists in this (make a copy to see the internal structure).

Arguments

Inputs:

data: The datatable containing the column to be converted.

PlaceColumn: The source column containing location names.

longitudeColumn: The target column for the longitude result. Defaults to 'longitude'.

latitudeColumn: The target column for the latitude result. Defaults to 'latitude'.

typeColumn: The name of the column to hold the place type. Defaults to type.

Output:

data: A datatable containing the new geocoding columns (latitude, longitude, type)

Example

Possible use cases

  • Preparing epidemiological data for mapping in Microreact.

  • Using before reverse-geocoding to obtain more standardized place names (e.g. when the original data contain US state names like NY, ny, New York, and you want them to be consistent)

Troubleshooting

Misinterpreting placeColumn

The map Api interprets places the best it can, but some values could represent multiple places:

  • Manchester is a city in England and also a city in New Hampshire, USA

  • 15220 is a postcode for Vitrac France and also for Pittsburgh, PA USA

  • Washington is the name of one US State, one US District, 21 US Cities, and 30 US Counties

In these situations, the map API may seem to select arbitrarily, so it can be beneficial to point the placeColumn argument at a column containing more information (e.g. instead of "15220" value, use "15220, France" or "15220, US"). This can be done using columns-concatenation and either combining multiple columns or adding a prefix/suffix to a single column. If your troubleshooting involves or other modification before the step, ensure that your step points at the correct/new placeColumn before testing.

columns-concatenation
forward-geocoding
forward-geocoding
example data-flo
Data-flo - Run: Geocoder - Data-flo
Logo