Hi Ndefo ,
In postgis, if you try something like: (assuming the_geom is your geometry
field)
SELECT ST_SRID(the_geom), ST_AsText(the_geom) FROM planet_osm_line LIMIT 10
What results for SRID (st_srid field) and coordinates (st_astext field) ?
Fred.
On Sat, Jun 12, 2010 at 5:03 AM, arnauld ndefo <[email protected]> wrote:
> hello every body,
> excuse me because i don't know always all to solve my problem.I have tried
> many possibilities without success.
>
> I use the database Postgis. I have a file .osm which represent the area of
> a geographic map to transfert data to my database Postgis. This have created
> 5 tables :
>
> "planet_osm_line"
> "planet_osm_point"
> "planet_osm_polygon"
> "planet_osm_roads"
> "spatial_ref_sys" and another one.
>
> Though geotools, i have succed to draw my map from the data which are
> stored into the database. But i have always this kind of coordinate:
> x=1131270.8550 y=4418856.9693; x=1131439.2747 y=4418792.6636 etc which
> represent the point on the map and on the JMapFRame frame i have EPSG: WGS
> 84 mentionned .However in the file .osm which resume all the nodes of the
> map, i have rather this kind of coordinate: long=10.1623439 lat=36.8545816;
> long=10.1702667 lat=36.8532032 etc.
>
> How can i do to have this king of coordinate lon=10.1623439 lat=36.8545816
> rather than this x=1131270.8550 y=4418856.9693????
>
> Without this, really my project cannot go head.This embarrasses me
>
> Thank you every body for your help
>
>
> Ndefo Kamgne Arnauld
> Cité Ettayour,Immeuble Bolbol 1,Appartement A2,Ariana
> 0021624249357
>
>
>
>
> ------------------------------------------------------------------------------
> ThinkGeek and WIRED's GeekDad team up for the Ultimate
> GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
> lucky parental unit. See the prize list and enter to win:
> http://p.sf.net/sfu/thinkgeek-promo
> _______________________________________________
> Geotools-gt2-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
>
>
------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the
lucky parental unit. See the prize list and enter to win:
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
Geotools-gt2-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
