GeoIQ Connect

GeoIQ Connect is an extensible component that enables you to connect Databases and Data Services directly into the GeoIQ platform. By using GeoIQ Connect you can use your existing infrastructure to store and manage data and leverage GeoIQ to perform data filtering, visualization and analysis and combine it with other data through GeoIQ. Tables, Views, and Queries can be created through our easy to use interface and provide all of the same capability that other datasets have within GeoIQ. Currently supported databases include: Oracle, MySQL, PostgreSQL, MondoDB, HBase. If you have another database or data web service that you would like supported, feel free to contact us.

To start using GeoIQ Connect you will first need to gather some information about your Database:

• Network IP Address or Hostname
• Database server Port number
• Database Name
• Username and Password

With this information, you can then go to the GeoIQ Administration console and click on the “Connect” tab. Then click “+ Add a New Data Store”. On this page you can enter the information from above, as well as several other options such as data caching and retention.

Database Schemas

GeoIQ Connect does not require a specific schema to registered Tables or Views. After creating a database you can register existing tables, or create a new query. When this registration is performed, GeoIQ will inspect the schema and store this in local metadata. Once the Table is registered the schema can’t change and would require “deleting” (unregistering) the Table from GeoIQ and reregistering it for the new schema to be detected.

Spatial Data

GeoIQ Connect can use the spatial extensions to supported databases. Oracle Spatial and PostGIS for example can store geometry for points, lines, polygons, and more complex geometries. When a Table or Query is created in GeoIQ Connect you will have the option to specify this geometry column in the dataset registration process. If your tables don’t include spatial data types, then you can specify the other georeferencing columns such as Latitude, Longitude, or Street and City, or geojoin to a polygon boundary.

In addition, GeoIQ Connect can read geographic data stored in the WKB and WKT standard formats.

Data Limits

GeoIQ Connect will pull data in sets from your database, sorted by an attribute such as time, column, or by auto index. GeoIQ determines this sorting either by a specific API request, or through the GeoIQ visualization interface when you theme a dataset by Time or by an thematic attribute. GeoIQ Connect has a configuration for the limit of data loaded, which by default is 10,000 features. This can be modified by GeoIQ depending on your use case but with implications to data loading and rendering speeds. Future versions of GeoIQ Connect will provide for multiple ways to stream and load in additional features.

API

GeoIQ Connect is integrated with the full GeoIQ programming interface (API) to enable developers to easily integrate your databases along with GeoIQ visualization and analysis into a variety of applications. Read more about the GeoIQ Features API as well as the full GeoIQ API .