Spatial Data Support
Spatial data support is only supported by the row store query engine within
Sybase IQ
.
Interactive SQL: Import Wizard now supports shapefiles – the Import Wizard now includes an option for importing ESRI shapefiles. See
SQL Anywhere Server – SQL Usage > Remote data and bulk operations > Importing and exporting data > Importing data > Import data with the Import Wizard (Interactive SQL)
.
Interactive SQL: New FORMAT SHAPEFILE and SRID clauses for the INPUT statement – the INPUT statement now supports loading ESRI shapefiles using the FORMAT SHAPEFILE clause. The SRID clause has also been added to the INPUT statement for specifying the SRID to use when loading the shapefile. See
SQL Anywhere Server – SQL Reference > SQL statements > SQL statements > INPUT statement > Syntax 3 - Loading shapefiles
.
New st_geometry_load_shapefile system procedure – the st_geometry_load_shapefile system procedure allows you to load an ESRI shapefile by providing the name of the file, the SRID to use for loading the data, and the name of the table to create and load the data into. The columns for the table are taken from the column names specified in the shapefile. See
SQL Anywhere Server – SQL Reference > System procedures > Alphabetical list of system procedures > st_geometry_load_shapefile system procedure
.
Note:
You must upgrade your database to access this new stored procedure.
New database option to specify ST_CircularString interpolation tolerance – the st_geometry_interpolation option has been added to control the interpolation of ST_CircularString geometries. See
SQL Anywhere Server – Database Administration > Configuring your database > Database options > Alphabetical list of options > st_geometry_interpolation option
.
Enhancements to ST_WithinDistanceFilter – the spatial predicate ST_WithinDistanceFilter is now supported for geometries in round-Earth spatial reference systems. See
SQL Anywhere Server – Spatial Data Support > Accessing and manipulating spatial data > ST_Geometry type > ST_WithinDistanceFilter method
.
Note:
These references point to SQL Anywhere documentation.
Parent topic:
New Features
Created August 28, 2013. Send feedback on this help topic to Technical Publications:
pubs@sap.com