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.

RESOURCE authority is required.

If the -gl option has been set to DBA, DBA authority is required.

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

If loading fails, the created table remains.

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

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

st_geometry_load_shapefile system procedure

Syntax

Arguments

Remarks

Permissions

Side effects

See also

Example