Geospatial User Guide
1. Introducing Ingres Geospatial
In This Guide
Audience
Terminology
Ingres Geospatial Functionality
Geospatial Restrictions
Migration Considerations
2. Getting Started with Spatial Features
In This Chapter
Basic Data Types
Representing Geometries as Text
Creating a Table
Inserting Basic Data into a Table
Using Basic Functions
Distance Calculations
Buffering and Finding Overlaps
3. Loading Geospatial Data
Ingres Support in GDAL/OGR Tools
Load Data with GDAL/OGR Tools
• OGC WKT
4. Geospatial Data Types
How Data Types Are Stored
Spatial Reference Systems
Spatial Reference System Identifier (SRID)
SRID Restrictions
Spatial Data Types
Point Data Type
Linestring Data Type
Polygon Data Type
GeometryCollection Data Type
MultiPoint Data Type
MultiLinestring Data Type
MultiPolygon Data Type
5. Geospatial Functions
Function Alias
Function Argument Data Types
Using Geospatial Functions
Area
AsBinary
AsText
AsTextRaw
AsTextRound
Boundary
Buffer
Centroid
Contains
ConvexHull
Crosses
Difference
Dimension
Disjoint
Distance
Envelope
Endpoint
Equals
Extent
ExteriorRing
GeomCollFromText
GeomCollFromWKB
GeometryFromText
GeometryFromWKB
GeometryN
GeometryType
Inside
InteriorRingN
Intersection
Intersects
IsClosed
IsEmpty
IsRing
IsSimple
IsValid
IsValidReason
LineFromText
LineFromWKB
MLineFromText
MLineFromWKB
MPointFromText
MPointFromWKB
MPolyFromText
MPolyFromWKB
NumGeometries
NumInteriorRing
NumPoints
Overlaps
Perimeter
PointFromText
PointFromWKB
PointN
PointOnSurface
PolyFromText
PolyFromWKB
Relate
Simplify
SRID
ST_Length
StartPoint
SymDifference
Touches
Transform
Union
Within
X
Y
A. Geospatial System Catalogs
spatial_ref_sys Catalog
geometry_columns Catalog
iiattribute DBMS System Catalog
Ingres 10S
iiattribute DBMS System Catalog