From Ingres Community Wiki
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.
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.
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.
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:
Articles and Videos
Good introductory video:
OGC SFS by Frank Warmerdam, Ingres Geospatial by Andrew Ross, Coordinate Systems by Frank Warmerdam June 2, 2008 (108 minutes)
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]
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
- 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
- GeoServer/GeoNetwork support for Ingres.
- Mapserver (native) support for Ingres
- ESRI ArcGIS support for Ingres (read and write support)
- 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)
- 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
Refer to the following links for further details on the design of the new spatial library:
Design and Implementation Details for the new types.
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
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.
- 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)