Navigation

Learn About

Developing With

Ingres Talk

Information

Toolbox

Search

Views

IngresGeospatial

From Ingres Community Wiki

Jump to: navigation, search

1 Special Announcements
2 Ingres Geospatial Project

[edit]

Special Announcements

We now support storing and retrieving OGC 1.1 shapes (point, linestring, polygon, etc.) as well as 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 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.

[edit]

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 is the one piece of Ingres that isn't open source.

This project was created in March 2008 to replace the "old" spatial library with a new one.

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

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

[edit]

Community support

Ingres is a proud supporting sponsor of OSGeo:

[edit]

Articles and Videos

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

[edit]

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 library that IS open source (GPLv2 license) [IN PROGRESS]

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

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

[edit]

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

[edit]

Overview of Roadmap

[edit]

Phase 1

OGC SFS SQL (v1.1) compliance See a list of supported shapes.
Rtree indexing.
OGR support for Ingres
Coordinate system support (using Proj.4)
WKT / WKB support

[edit]

Phase 2

GeoServer/GeoNetwork support for Ingres.
Storage engine enhancements to deal with spatial data in a more performant way.
Increased portion of OGC SFS SQL (v1.2) compliance.
FDO driver.
Research project: Affects of applying VectorWise techniques to geospatial data.

[edit]

Phase 3

More performance enhancements
Routing - see the OpenRouter project.
Geocoding - see the OpenGeocoder project.

[edit]

Phase 4 and beyond

Raster support.
Geodetic support
OGC SFS 1.2 support and/or the current standard at the time

[edit]

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

Testing Details

Conformance tests

[edit]

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.

BuildingIngresGeospatial : 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

[edit]

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

BuildingTips

[edit]