Two problems have been identified with some shapefiles
1. When using the 'db2se import_shape' or the
db2gse.ST_import_shape_stored procedure, it fails with a message
that the coordinate system definition in the .prj file does not
match the spatial reference system specified for the import
process.
This may occur if the coordinate system definition in the .prj
file is correct but this is followed by additional information
not related to the geographic or projected coordinate system
definition.
This is an example
GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",S
PHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",
0.0],UNIT["Degree",0.0174532925199433]],VERTCS["Unknown
VCS from ArcInfo
Workstation",VDATUM["Unknown"],PARAMETER["Vertical_Shift",0.0],P
ARAMETER["Direction",1.0],UNIT["Meter",1.0]]
In particular, the VERTCS part is not recognized.
All text after the end of the GEOGCS definition should be
ignored.
2. Some shapefiles which have Z coordinates may be rejected with
a "coordinate out of bounds" error message.
This is due to the presence of M values in the shapefile which
have a value less than -1E38 which indicates a "no data" value
and will generally be outside the bounds of the M value in the
spatial reference system definition. |
****************************************************************
* USERS AFFECTED: *
* DB2 Spatial Extender users *
****************************************************************
* PROBLEM DESCRIPTION: *
* Two problems have been identified with some shapefiles *
* *
* 1. When using the 'db2se import_shape' or the *
* db2gse.ST_import_shape_stored procedure, it fails with a *
* message that the coordinate system definition in the .prj *
* file does not match the spatial reference system specified *
* for the import process. *
* This may occur if the coordinate system definition in the *
* .prj file is correct but this is followed by additional *
* information not related to the geographic or projected *
* coordinate system definition. *
* *
* This is an example *
* GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983"
* VCS from ArcInfo *
* Workstation",VDATUM["Unknown"],PARAMETER["Vertical_Shift",0.0]
* In particular, the VERTCS part is not recognized. *
* *
* All text after the end of the GEOGCS definition should be *
* ignored. *
* *
* 2. Some shapefiles which have Z coordinates may be rejected *
* with a "coordinate out of bounds" error message. *
* This is due to the presence of M values in the shapefile *
* which have a value less than -1E38 which indicates a "no *
* data" value and will generally be outside the bounds of the *
* M value in the spatial reference system definition. *
****************************************************************
* RECOMMENDATION: *
* Apply V9.8 fixpack 3 *
**************************************************************** |
