WGS84 gps point in postgis

[Arnulf Christl]

Stéphane RIFF wrote:

> Hello,
>
> I want to store WGS84 gps points in a postgis table:
>       What is the format of WGS84 point in postgis ???
>             For now i have something like this:
>                   SRID=4326;POINT(DDMM.SSSS DDMM.SSSS)   ----> is that
> ok ???
>
> Next i want to show those gps points on raster map in other projection:
> epsg:27582 (lambert II etendu)
>
> Does somebody already do something like that...
>
> All advices are wellcome
>
> Thanks
>
Hi,
just as Vladimir pointed out the format should be something like:
SRID=4326;POINT(7.0725 50.73882)

You need a geometry field in the table, so after creating the TABLE
(named umn_user in this example) itself:

CREATE TABLE umn_user (
    gid integer,
    firstname character varying,
    lastname character varying,
    ...
);

you have to add the field that contains the geometry (DATBASE germany,
TABLE umn_user, FIELD the_geom, SRID, Type, dimension):

SELECT AddGeometryColumn('germany', 'umn_user', 'the_geom', 4326,
'POINT', 2);

then you can add values:

INSERT INTO umn_user VALUES (42, Stephane, Riff, ... ,
'SRID=4326;POINT(7.07250238209242 50.7387903487365)';

Now you can add WMS capabilities to the MAP file and query MapServer
with WMS syntax. Then you can switch projections on the fly by just
adding another EPSG code to the getMap string. The WMS client Mapbender
includes that functionality, check it out here:
http://www.mapbender.org/testbed.html
The testbed currently contains 3 WMS and as you can see not all of them
answer to all EPSGs.

Cheers, Arnulf.

--
----------------------------
CCGIS Christl & Stamm GbR
----------------------------
http://www.ccgis.de
http://www.mapbender.org
----------------------------
Service: +49 (0)228 90826 0
Direct:  +49 (0)228 90826 23
Fax:     +49 (0)228 90826 11
----------------------------
CCGIS Christl & Stamm GbR
Siemensstraße 8
53121 Bonn
GERMANY