Friday, June 24, 2016

Geocoding with


Geocoding is the process of converting addresses into geographic coordinates. This is typically an expensive proposition, particularly for larger datasets that also requires cumbersome custom API implementation with third party API's. Geocoding is usually required for displaying address type coordinates on a map. 


After evaluating a number of geocoding services, we are pleased to announce an integration with for its simplicity, accuracy and cost effectiveness. By partnering with, latitude and longitude lookup support is now included within Cloud9 Charts. The service is free for up to 2500 lookups a day, all the way to $750/mo for high volume, unlimited usage (see pricing details). 


Following is a 5 minute, hands-on walkthrough to determine Lat/Longs from some addresses, to then display it on a map:

1. Copy and paste the following into

State City Address
Florida Orlando 1912 S Orange Avenue
Ohio Piketon 4077 Union Hill Road
Georgia Appling 3162 Johnson Drive
Michigan Kalamazoo 5581 Cracker Barrel Blvd
Virginia Chesapeake 1401 N. George Washington Hwy
New Mexico Roswell 2300 block of Davis Ave
Georgia Moultrie Rossman Dairy Road
Pennsylvania Pittsburgh (Wilkinsburg) 1304 Franklin Avenue
Kansas Kansas City 3000 block of South 36th Street

2. Click on Show me. On the dashboard, click on the Filter icon --> click on Cloud9QL. Cloud9QL is a powerful data transformation syntax that includes support for geocoding, IP to geo conversion, predictions, cohorts and other analytics functions.   

3. Add the following into the Cloud9QL:

select concat(address,',',city,',',state) as address;
select geocode(address,626bb3d8cd2c3db255d2223c67f670525d7a5d5)

The first statement concats the the address, city and state in comma separated form; the results of this are passed into the second statement which calls into the 

The geocode function takes two parameters: the address field and the API key. (The API key above is for small scale tests. We recommend obtaining your own API key from

The results will look something like this, with lat & long plus a few other fields. 

4. Let's convert this into a Map: From Settings, choose the Geo Marker Pins as the visualization type. 


More Geo features coming soon. Stay tuned.

Geocoding Tester API Docs
IP to Geo Conversions
Visualization Options

Monday, June 13, 2016

Drag & Drop Analytics for Multi-Structured Data + Other New Features

Cloud9 Charts Product Updates
Ad hoc Drag & Drop Analytics, JS Embed API, New Integrations, Visualizations, Training Webinars, and all the latest & greatest.
Introducing Drag & Drop Analytics for Multi-Structured Data

Analytics across your data has just gotten a lot easier with our new drag & drop analytics, the first of it's kind for multi-structured data. Learn more

Our new JavaScript API makes embeddable analytics a breeze. Also, you can now pass in encrypted parameters/filters from your application, in addition to other secure options.

Additions include Gauges, Word Clouds, Timelines (for IoT data), master-detail grid, Treemaps, Box Plots, Word Clouds and custom HTML widgets.

With 25 visualizations to choose from, choosing the right visualization as easy as 1-2-3 with a new preview mode.

Data across SQL, NoSQL, Web based API's and/or files? Our multi-datasource join processing capabilities allows you to seamlessly stitch them all together in a few simple clicks.

New Integrations: BigQuery, REST API, JSON/CSV/XML files.
MarkLogic integration has been updated with an XQuery generator, as well as JavaScript support.

Couchbase integration now includes N1QL query generation.

Query Status to check on query execution status, agent monitoring, query parameters support, enhanced filter and drilldown options.
We'll be holding several training webinars in June to run through our latest product features to enable you to get the most out of our platform. To book a time, drop us a line.