How to best get Geonames Data into DOMO
We want to do a lot of mapping. We do not have Latitude and Longitude for the addresses. However if we use Geonames data we should be able to getLatitude and Longitude based on Country, City and possibly state/province.
Right now getting all the data from geonames is painful. Its tab delimited data and many do not have the header row so lots on data manipulating then uploading it to domo.
Whats the easiest way to connect to all the data via the webserivce they provide? And then join it all together for easy use. Also it would be nice to set it up and share it for everyone who wants it so we dont all have to duplicate the work.
http://www.geonames.org/export/ws-overview.html
Comments
-
I noticed that for many of the options there are XML and JSON sources as well. We have connectors that can connect to XML and JSON pulls. This will take a little more in depth review, so we will reach out offline to review in more detail.
I work for Domo.
**Say "Thanks" by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as "Accepted Solution"4
Categories
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 307 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 790 Beast Mode
- 78 App Studio
- 43 Variables
- 746 Automate
- 187 Apps
- 475 APIs & Domo Developer
- 68 Workflows
- 16 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 139 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive