The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

Analyze DB2 spatial data with a free geobrowser

Use the IBM Data Management geobrowser for DB2, Informix and Netezza to visualize relational table data

David Adler (dadler@us.ibm.com), Senior Software Engineer, IBM

David Adler has been responsible for the development of spatial database technology in IBM for over 20 years, the past 10 years in DB2 Spatial Extender Development.

Summary: A geobrowser for IBM® DB2®, Informix® and Netezza® is now available as a free download. You can easily list tables containing spatial data and select tables to display as a map using a combination of points, lines, and polygons. The color, symbols, line style, and shading are user-selectable. Map navigation tools allow you to zoom in and out, pan, and select and display the alphanumeric values associated with each graphic object. The geobrowser can render the results of spatial analysis using DB2, Informix or Netezza. For example, the results of a spatial query that identifies customers within a flood zone can be visualized. The geobrowser is based on components from IBM's ILOG® JViews Maps. Use these components to construct custom spatial visualization applications. This tutorial shows how to use the free geobrowser to visualize data from DB2 tables.

Date: 01 Nov 2012 (Published 24 Mar 2011)
Level: Intermediate
PDF: A4 and Letter (841 KB | 18 pages)Get Adobe® Reader®

Activity: 26869 views
Comments:

Resources

Learn

Learn more about IBM spatial offerings.
Check out the DB2 Spatial Extender documentation in the DB2 Information Center.
See a demo of the IBM ILOG JViews Maps.
Learn more about Information Management at the developerWorks Information Management zone. Find technical documentation, how-to articles, education, downloads, product information, and more.
Stay current with developerWorks technical events and webcasts.
Follow developerWorks on Twitter.

Get products and technologies

Download DB2 Express-C. This is a fully functional no-charge version of DB2 which includes Spatial Extender.
Download DB2 Spatial Extender that corresponds to an existing DB2 server installation. Sample spatial data in shapefile format for use with Spatial Extender is also available via this link.
Download the Geobrowser for DB2, Informix and Netezza. This is free for you to use with any version of DB2, Informix or Netezza with the spatial feature installed.
Download IBM Data Studio, which provides developers and DBAs with basic capabilities for database management and development at no charge for DB2, Informix and Netezza.
Download a trial copy of JViews Enterprise. (This includes JViews Maps functionality.)
Build your next development project with IBM trial software, available for download directly from developerWorks.