coordinate system mismatch

Posted in 2005

James — 9 Sep 2005 06:36:46 -0700 — source: Usenet: comp.databases.informix

Hi everyone, I had this "coordinate system mismatch" problem when I tried to load shapefiles into informix database. I used "loadshp" utility. The following is the command that I use and the error message that I got: ------------------------------------------------------------ >loadshp -o init -l bt_ht_10,geometry -f bt_res_bt_ht_5.shp -D gportal -srid 32648 Coordinate system info from bt_res_bt_ht_5.prj ... PROJCS["WGS_1984_UTM_Zone_48N",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",105.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0]] Spatial reference text for SRID 32648 ... GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]] Coordinate system mismatch ... exiting. ----------------------------------------------------------------- As you can see, I have the matching SRID in my spatial_references table. The 'srtext' column is matching the part of the coordinate system info from the shapefile. Did anyone encounter this problem before? Or anyone can give me a hint how to solve it? Thanks in advance. regards, James