sa_describe_shapefile system procedure

sa_describe_shapefile( shp_filename 
, srid 
[, encoding ] 
)

shp_filename A VARCHAR(512) parameter that identifies the location of the ESRI shape file. The file name must have the extension .shp and must have an associated .dbf file with the same base name located in the same directory.
srid An INTEGER parameter that identifies the SRID for the geometries in the shape file. Specify NULL to indicate the column can store multiple SRIDs. Specifying NULL limits the operations that can be performed on the geometry values.
encoding A VARCHAR(50) parameter that identifies the encoding to use when reading the shape file. The default encoding is ISO-8859-1.

Column name	Data type	Description
column_number	INTEGER	The ordinal position of the column described by this row, starting at 1.
name	VARCHAR(128)	The name of the column.
domain_name_with_size	VARCHAR(160)	The data type name, including size and precision (as used in CREATE TABLE or CAST functions).

The sa_describe_shapefile system procedure is used to describe the name and type of columns in an ESRI shape file. This information can be used to create a table to load data from a shape file using the LOAD TABLE ... FORMAT SHAPEFILE. Alternately, this system procedure can be used to read a shape file by specifying the WITH clause for OPENSTRING ... FORMAT SHAPEFILE.

If the -gl database option has been set to all, all users can execute this system procedure. Otherwise, DBA or READFILE authority is required.

The following example creates a table that can be loaded with ESRI shape file data:

SELECT 'create table esri_load( record_number int primary key, ' ||
    (SELECT list( name || ' ' || domain_name_with_size, ', ' 
     ORDER BY column_number )
     FROM sa_describe_shapefile( 'c:\\esri\\shapefile.shp', 1000004326 )
     WHERE column_number > 1 ) || ' )';

sa_describe_shapefile system procedure

Syntax

Arguments

Result set

Remarks

Permissions

See also

Example