Upsolver
Search…
Welcome to Upsolver
Getting Started
Start using Upsolver for free
Get started as a Upsolver user
Upsolver concepts
Upsolver Amazon AWS deployment guide
Tutorials and FAQ
Glossary
Language guide
SQL syntax reference
Functions
Aggregation Functions
Calculated functions
Aerospike functions
Array functions
Conditional functions
Date functions
External API functions
Filter functions
Numeric functions
Spacial functions
String functions
Structural functions
Type conversion functions
Data formats
Data types and features
Database output options
Permissions list
Index
Troubleshooting
Connecting data sources
Amazon AWS data sources
Microsoft Azure data sources
Kafka data source
Google Cloud Storage data source
File upload data source
CDC data sources (Debezium)
JDBC data source
HDFS data source
Data source UI
Data source properties
Data outputs and data transformation
Data outputs
Data transformation
Guide for developers
Upsolver REST API
CI/CD on Upsolver
Administration
Connections
Clusters
Python UDF
Reference data
Workspaces
Monitoring
Security
Release notes
Change log
Support
Upsolver support portal
Powered By GitBook
Spacial functions
This page goes over the spacial functions in Upsolver.

WKT_SPATIAL_CONTAINS

Checks if the first WKT formatted spatial object contains the second.

Inputs

  • first
  • second
first
second
result
"POLYGON((-10 30, -40 40, -10 -20, 40 20, 0 0, -10 30))"
"POINT(10 0)"
true
"POLYGON((-10 30, -40 40, -10 -20, 40 20, 0 0, -10 30))"
"POINT(15 0)"
false

WKT_SPATIAL_INTERSECT

Checks if the WKT formatted spatial objects intersect.

Inputs

  • first
  • second
first
second
result
"POLYGON((-10 30, -40 40, -10 -20, 40 20, 0 0, -10 30))"
"POINT(10 0)"
true
"POLYGON((-10 30, -40 40, -10 -20, 40 20, 0 0, -10 30))"
"POINT(16 0)"
false
Previous
Numeric functions
Next
String functions
Last modified 1yr ago
Copy link
Contents
WKT_SPATIAL_CONTAINS
WKT_SPATIAL_INTERSECT