zhyiwww
用平实的笔,记录编程路上的点点滴滴………
posts - 536,comments - 394,trackbacks - 0
# 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)  编辑  收藏 所属分类: gisPostgis

只有注册用户登录后才能发表评论。


网站导航: