st_geometry_load_shapefile system procedure

st_geometry_load_shapefile(
shp_filename 
, srid 
, table_name 
[, table_owner
[, shp_encoding ] ] 
)

shp_filename Use this VARCHAR(512) parameter to specify the location of the ESRI shapefile. The file name must have the extension .shp and must have associated .shx and .dbf files with the same base name located in the same directory. The path is relative to the database server, not the client application.
srid Use this INTEGER parameter to specify the SRID to associate with the data from the shapefile. For the geometries to be meaningful, the SRID you specify should be appropriate for the geometries, even if it isn't identical to the SRID used in the shapefile.
table_name Use this VARCHAR(128) column to specify the name of the table to create to hold the shapefile data.
table_owner Use this optional VARCHAR(128) column to specify the owner for the new table that is created. The default owner is the current user.
shp_encoding Use this optional VARCHAR(50) parameter to specify the encoding to use when reading the shapefile. The default encoding is ISO-8859-1.

The st_geometry_load_shapefile system procedure first creates the table "table_owner"."table_name" using the column information (names and types) found in the ESRI shapefile. st_geometry_load_shapefile then loads the data from the shapefile into the new table.

This procedures makes use of the sa_describe_shapefile system procedure, and the LOAD TABLE...FORMAT SHAPEFILE statement.

If the -gl option is set to NONE, loading the data fails.

If the -gl option is set to DBA:

If you are table_owner, you must have one of CREATE TABLE, CREATE ANY TABLE, or CREATE ANY OBJECT system privilege, and you must have one of ALTER ANY TABLE, ALTER ANY OBJECT, or LOAD ANY TABLE system privilege.
If you are not table_owner, you must have one of CREATE ANY TABLE or CREATE ANY OBJECT system privilege, and you must have one of ALTER ANY TABLE, ALTER ANY OBJECT, or LOAD ANY TABLE system privilege.

If the -gl option is set to ALL:

If you are table_owner, you must have one of CREATE TABLE, CREATE ANY TABLE, or CREATE ANY OBJECT system privilege.
If you are not table_owner, you must have one of CREATE ANY TABLE or CREATE ANY OBJECT system privilege, and you must have one of ALTER ANY TABLE, ALTER ANY OBJECT, or LOAD ANY TABLE system privilege.

If loading fails, the created table remains.

The following statement creates the table esri_load and loads it with the data from a fictitious shapefile c:\esri\shapefile.shp, associating the data with SRID 1000004326:

CALL st_geometry_load_shapefile( 'c:\\esri\\tgr36069trt00.shp', 1000004326, 'esri_load' );

st_geometry_load_shapefile system procedure

Syntax

Arguments

Remarks

Privileges

Side effects

See also

Example