Geospatial User Guide
Introducing Ingres Geospatial
In This Guide
Audience
Terminology
Ingres Geospatial Functionality
Geospatial Restrictions
Migration Considerations
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
Loading Geospatial Data
Ingres Support in Safe Software FME
Geospatial Data Types
How Data Types Are Stored
Spatial Reference Systems
Spatial Reference System Identifier (SRID)
SRID Restrictions
Linear Reference System
Spatial Data Types
Two-dimensional Data Types
Geometry Data Type
Point Data Type
Linestring Data Type
Polygon Data Type
GeometryCollection Data Type
MultiPoint Data Type
MultiLinestring Data Type
MultiPolygon Data Type
PolyhedralSurface Data Type
MultiCurve Data Type
MultiSurface Data Type
CircularString Data Type
CompoundCurve Data Type
CurvePolygon Data Type
TIN Data Type
Triangle Data Type
Three-dimensional Data Types
GeometryZ and GeometryM Data Types
PointZ and PointM Data Types
LinestringZ and LinestringM Data Types
PolygonZ and PolygonM Data Types
MultiPointZ and MultiPointM Data Types
MultiLinestringZ and MultiLinestringM Data Types
MultiPolygonZ and MultiPolygonM Data Types
GeometryCollectionZ and GeometryCollectionM Data Types
PolyhedralSurfaceZ and PolyhedralSurfaceM Data Types
MultiCurveZ and MultiCurveM Data Types
MultiSurfaceZ and MultiSurfaceM Data Types
CircularStringZ and CircularStringM Data Types
CompoundCurveZ and CompoundCurveM Data Types
CurvePolygonZ and CurvePolygonM Data Types
TINZ and TINM Data Types
TriangleZ and TriangleM Data Types
Four-dimensional Data Types
GeometryZM Data Type
PointZM Data Type
LinestringZM Data Type
PolygonZM Data Type
MultiPointZM Data Type
MultiLinestringZM Data Type
MultiPolygonZM Data Type
GeometryCollectionZM Data Type
PolyhedralSurfaceZM Data Type
MultiCurveZM Data Type
MultiSurfaceZM Data Type
CircularStringZM Data Type
CompoundCurveZM Data Type
CurvePolygonZM Data Type
TINZM Data Type
TriangleZM Data Type
Geospatial Functions
Using Geospatial Functions
Function Alias
Function Argument Data Types
Spatial SQL Function Details
Functions That Do Not Support 3D
Area
AsBinary
AsText
AsTextRaw
AsTextRound
Boundary
Buffer
Centroid
Contains
ConvexHull
Crosses
Difference
Dimension
Disjoint
Distance
Envelope
Endpoint
Equals
Extent
ExteriorRing
GeomCollFromText
GeomCollFromWKB
GeometryFromText
GeometryFromWKB
GeometryMFromText GeometryZFromText
GeometryMFromWKB GeometryZFromWKB
GeometryN
GeometryType
GeometryMFromText GeometryZFromText
GeometryMFromWKB GeometryZFromWKB
GeometryZMFromText
GeometryZMFromWKB
Inside
InteriorRingN
Intersection
Intersects
IsClosed
IsEmpty
IsRing
IsSimple
IsValid
IsValidReason
LineFromText
LineFromWKB
M
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
Z
LRS-related Functions
Add_Measure
Interpolate_Point
Line_Interpolate_Point
Line_Locate_Point
Line_Substring
Locate_Along
Locate_Between
Locate_Between_Elevations
Maximizing Performance
Using Inline BLOBs
RTREE Indexing
A. Geospatial System Catalogs
spatial_ref_sys Catalog
geometry_columns Catalog
iiattribute DBMS System Catalog
Geospatial User Guide
iiattribute DBMS System Catalog