Login Register Actian.com  

Actian Community Wiki

Learn About
Developing With
Ingres Talk


From Ingres Community Wiki

Jump to: navigation, search



May 2012 - We've now officially released Ingres 10S Geospatial! Available for download from esd.actian.com.

November 2011 - We've created an extension for ESRI's ArcGIS that provides read and write support for Ingres. This enables you to use ArcCatalog to add connections to Ingres and ArcMap to create maps using data from Ingres. You can view and edit features and more.

June 2011 - The project has been re-kindled. More updates soon.

January 2011 - A shift in focus put the geospatial project on hold.

November, 2010 - Ingres geospatial features are now merged into main and thus build into Ingres for all community builds starting in December.

October, 2010 - A draft of our user documentation was contributed by Adriel Deal-Hall.

September, 2010 - Binary installers for Linux and Windows are available. This is Ingres 10.1 with Geospatial support built in!

June, 2010 - A draft of the detailed design specification for phase 1 is available.

May, 2010 - Code providing coordinate system support - st_transform() and projections is now committed.

March, 2010 - We now support building Ingres with geospatial support on Windows.

February, 2010 - OGC SFS v1.1 shapes and functions are fully supported.

February, 2010 - We now support GDAL/OGR connectivity. This means anything that knows how to use OGR for vector data will work with Ingres. This includes Mapserver, QGis, OpenLayers, and much more. We are working on native drivers for many applications as well.

January, 2010 - We have initiated a research project with the University of Toronto to work towards speeding up geospatial database performance by a factor of ten.

Geospatial Logo

This project is focused on storing geometry and geography related data in Ingres databases. This includes supporting industry standard data types and functions. The project also includes support for desktop GIS and map rendering software.

Ingres Geospatial Project

Ingres has had spatial support since the mid-1990's through the spatial library, an Object Model Extension (OME) library. Unfortunately the code was the one piece of Ingres that wasn't open source. It had also fallen behind the state of the art rather badly.

This project was created in March 2008 to replace the "old" spatial library with a new one. Our goal is much more than this. Our mission is to provide the best database for location data.

To follow along and get involved, please join our Mailing list or visit the #ingres IRC channel.

All bugs and tasks will be tracked in our bug tracker.

Community support

The Open Source Geospatial Foundation (OSGeo) is a non-profit organization whose mission is to support and promote the collaborative development of open geospatial technologies and data. Ingres is a proud supporting sponsor and active member of OSGeo:

Supporting OSGeo logo

Articles and Videos

Good introductory video:

A brief introduction to Ingres geospatial features

Quick demo of the point datatype

Quick demo of the line datatype

Geospatial Primer: in Search of the Next "Killer App"

Rearranging the landscape of geospatial databases (from OSGeo's FOSS4G2009 conference)

Doing maps in Drupal

Building Ingres from source with geospatial support

OGC SFS by Frank Warmerdam, Ingres Geospatial by Andrew Ross, Coordinate Systems by Frank Warmerdam June 2, 2008 (108 minutes)

Primary Goals

1) Make it easy for the community to work with Ingres [SIGNIFICANT PROGRESS, refinement ongoing]

2) Reuse code from open source projects (such as GEOS for one example) and strengthen the OSGEO community [COMPLETED, ongoing contributions to GEOS & GDAL/OGR planned]

3) Develop a new geospatial technology within Ingres that IS open source (GPLv2 license) [COMPLETED]

4) Ensure Ingres supports the Open Geospatial Consortium (OGC) Simple Feature Specification for SQL [COMPLETED]

5) Ensure access layers such as OGR, Geotools support Ingres (thus enabling applications to use Ingres as a spatial repository) [COMPLETED]

Secondary goals

1) Work with the community to develop a geospatial platform/distribution

2) Add new features and capabilities such as geocoding and routing

3) Create import tools to allow easy migration from other RDBMSs

4) Advance the state of the art in terms of geospatial features and performance by an order of magnitude

Overview of Roadmap

Phase 1 - Complete in November 2010

Overall Project Plan Detailed Design Specification (DDS) for phase 1 is available.

  • OGC SFS SQL (v1.1) compliance See a list of supported shapes. (Certified 2012)
  • Rtree indexing.
  • GDAL/OGR support for Ingres
  • Coordinate system support (using Proj.4)
  • WKT / WKB support
  • Geospatial types available through OpenAPI (C), ODBC, JDBC, Perl, Ruby, Python

Phase 2 - Complete in November 2011

Phase 3

  • Ingres support in FME (complete)
  • Significantly improve performance for geospatial data (work in progress)
  • Autodesk FDO provider for Ingres
  • Linear Reference System (LRS) and ZM support (work in progress)

Phase 4

  • Increased portion of OGC SFS SQL (v1.2) compliance. (work in progress)
  • Routing - see the OpenRouter project.
  • Geocoding - see the OpenGeocoder project.
  • Various formatting functions like AsGML, AsKML, AsJSON, AsSVG
  • Raster support.
  • Geodetic support
  • Further native support - MapServer, QGIS

Design Details

Refer to the following links for further details on the design of the new spatial library:

List of supported types

Design and Implementation Details for the new types.

List of supported functions

List of Changes by Subsystem

List of issues

Spatial Reference System

Geometry Columns

Updating OGR

Related Documents

Linear Reference System

Testing Details

Conformance tests

Demo Scripts - using some real world data with spatial functions

Project How Tos

The following are tips and tricks that likely won't be that interesting to you unless you're working on coding or testing.

  • Building Ingres Geospatial : How to build Ingres with GEOS support.
  • GeoDemoLinuxSetup : Importing and exporting spatial data using the old spatial types
  • GeoExamples : Some random examples using the new geospatial-branch implementation
  • GeoCodePointers : Finding spatial code in source tree
  • Debug logs from GEOS are in your $ING_ROOT/dbms.log
  • GeoQuantumGISWindows: Get Quantum GIS (QGIS) up and running on Windows
  • GeoFME: Get started with Ingres FME Plugin on Windows
  • GeoDataSetup: Examples for getting sample datasets loaded and running in Ingres 10S

General Knowledge

This information is not specific to geospatial and should be available / expanded elsewhere on the community pages. For now, it's tracked here and will be moved at a later time.

Trace points


  • You may want to increase Ingres db transaction log size if you plan to do mass updates on geospatial tables

External Related Links





http://www.gdal.org/ogr/drv_ingres.html - Ingres support in GDAL/OGR

Minutes from Meetings

Text from April 3, 2008 IRC meeting (28.0 kB)

audio from September 11, 2009 dimdim meeting (45.6 MB)

Thank you,

Personal tools
© 2011 Actian Corporation. All Rights Reserved