Vertica-OT-White
  • Vertica Documentation
    • Supported platforms
    • New features
    • Getting started
    • Architecture
    • Setup
    • Eon
    • Containerized Vertica
    • 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!

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
© 2024 Open Text Corporation All Rights Reserved
Privacy Policy
Cookie Preferences