# insert into spatial_ref_sys VALUES (900913, 'EPSG', 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');
gisdb=# select astext(transform(geomfromtext('POINT(116.78787 39.29983)',4326),900913));
astext
-----------------------------------------
POINT(13000766.219231 4764711.10113251)
(1 row)
zydb=# select astext(transform(geomfromtext('POINT(116.78787 39.29983)',4326),32650));
astext
------------------------------------------
POINT(481709.059137956 4350071.34479768)
(1 row)
gisdb=#
|----------------------------------------------------------------------------------------|
版权声明 版权所有 @zhyiwww
引用请注明来源 http://www.blogjava.net/zhyiwww
|----------------------------------------------------------------------------------------|
posted on 2009-07-09 17:57
zhyiwww 阅读(404)
评论(0) 编辑 收藏 所属分类:
gis 、
Postgis