_FT_LogoSheet.1Sheet.2Sheet.3Analytics Database
  • 25.2.x
    25.2.x 25.1.x 24.4.x 24.3.x 24.2.x 24.1.x 23.4.x 23.3.x 12.0.x 11.1.x 11.0.x 10.1.x 10.0.x 9.3.x 9.2.x 9.1.x 9.0.x 8.1.x
  • English
    中文
English
中文
  • Documentation
    • Supported platforms
    • New features
    • OpenText Core Analytics Database
    • Getting started
    • Architecture
    • Setup
    • Eon
    • Container deployment
    • Data exploration
    • Data load
    • Data analysis
      • Queries
      • Query optimization
      • Views
      • Flattened tables
      • SQL analytics
      • Machine learning for predictive analytics
      • Geospatial analytics
        • Best practices for geospatial analytics
        • Spatial objects
        • Working with spatial objects in tables
          • Defining table columns for spatial data
          • Exporting spatial data from a table
          • Identifying null spatial objects
          • Loading spatial data from shapefiles
          • Loading spatial data into tables using COPY
          • Retrieving spatial data from a table as well-known text (WKT)
          • Working with GeoHash data
          • Spatial joins with ST_Intersects & STV_Intersect
            • Best practices for spatial joins
            • Ensuring polygon validity before creating or refreshing an index
            • STV_Intersect: scalar function vs. transform function
            • Performing spatial joins with STV_Intersect functions
              • Spatial indexes & STV_Intersect
            • When to use ST_Intersects vs. STV_Intersect
              • Performing spatial joins with ST_Intersects
        • Working with spatial objects from clients
        • OGC spatial definitions
        • Spatial data type support limitations
      • Time series analytics
      • Data aggregation
    • Flex tables
    • Data export and replication
    • Management Console
    • Administrator's guide
    • Security & authentication
    • Connecting to Vertica
    • Extending Vertica
    • Hadoop integration
    • Kafka integration
    • Spark integration
    • Voltage SecureData integration
    • SQL reference
    • API reference
    • Vertica error messages
    • Glossary
    • Copyright notice

Thanks for your feedback!

Send feedback








Submitting...

Print entire section
  1. Data analysis
  2. Geospatial analytics
  3. Working with spatial objects in tables

Working with spatial objects in tables

  • Defining table columns for spatial data
  • Exporting spatial data from a table
  • Identifying null spatial objects
  • Loading spatial data from shapefiles
  • Loading spatial data into tables using COPY
  • Retrieving spatial data from a table as well-known text (WKT)

In this section

  • Defining table columns for spatial data
  • Exporting spatial data from a table
  • Identifying null spatial objects
  • Loading spatial data from shapefiles
  • Loading spatial data into tables using COPY
  • Retrieving spatial data from a table as well-known text (WKT)
  • Working with GeoHash data
  • Spatial joins with ST_Intersects and STV_Intersect
© 2025 Open Text Corporation All Rights Reserved
Privacy Policy
Cookie Preferences