• 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

Introducing Ingres Geospatial

iiattribute DBMS System Catalog