data (#23) - Data appears smaller (#317) - Message List

Hi Everyone

I am trying to overlay data (nrn_rrn_bc_shp_en.zip) onto Google Maps. I have downloaded data from Canadian website as recommended by a tutorial on this website. I have changed SRID to 54004 for Victoria table. But when I display Victoria table on Google Maps then it appears smaller than Google Maps (nearly half of the size of area on Google Map). When I try to use 900913 for Victoria table it does not appear at all.

I am using OpenLayers? and my map projection is in 900913.

The Victoria tables is published as a WMS, thus I am using 900913 project for it in the mapfile.

Here is my ESPG entry for Proj4 (for MapServer)

<900913> +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs

Here is the insert statement for 900913 for PostGIS (it is taken from this website as well)

INSERT INTO spatial_ref_sys (srid, auth_name, auth_srid, srtext, proj4text) VALUES (900913, 'EPSG', 900913, 'PROJCS["unnamed",GEOGCS["unnamed ellipse",DATUM["unknown",SPHEROID["unnamed",6378137,0]], PRIMEM["Greenwich",0],UNIT["degree",0.0174532925199433]], PROJECTIONMercator_2SP?,PARAMETER["standard_parallel_1",0],PARAMETER["central_meridian",0],PARAMETER["false_easting",0], PARAMETER["false_northing",0],UNIT["Meter",1],EXTENSION["PROJ4","+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs"]]',

'+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext +no_defs');

Could any one help me in understating what is wrong?