[Geomoose-users] How to add a new line to postgis db in degrees?

[Dara Olson]

Just FYI - We ended up with the same issue, so we created a trigger in postgres to update another geometry field in 4326 automatically when you add a line in 900913.  It works pretty smooth and we still have our data stored in 4326 for staff download.
Dara 

----
Message: 4
Date: Tue, 12 Jul 2011 17:07:38 -0600
From: Brent Fraser <bfraser at geoanalytic.com>
Subject: Re: [Geomoose-users] How to add a new line to postgis db in
degrees?
To: pinchitirabassi <pinchitirabassi at gmail.com>
Cc: geomoose-users at lists.sourceforge.net
Message-ID: <4E1CD3BA.9020205 at geoanalytic.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Pinchi,

   The problem is that GeoMoose is set up to deal with coordinates in 
the Display Coordinate System (900913 in your case).  That's what the 
JavaScript passes to the editor.php, and that's what the PHP inserts 
into the PostGIS database.  I'd recommend storing the data in PostGIS in 
900913, otherwise you'll have to edit the editor.php to use 
"ST_Transform" prior to inserting into the database.

Best Regards,
Brent Fraser


On 7/12/2011 4:16 PM, pinchitirabassi wrote:
> Hi, I've set up geomoose and I followed the instructions on the website. I
> created a tool to add lines, and they are added to the database, but I have
> a database with information in the EPSG:4326 SRID, and the insertion is made
> in meters. I need to configure it so as to insert linestrings in degrees.
>
> So far, I have changed some lines in the mapbook:
>
> EPSG:4326
> dd
>
> But this didn't do anything.
>
> I set a wms map-source and it works perfectly:
>
> <map-source name="street_editor" type="wms" tiled="true"
> projection='EPSG:900913'>
>          <url>http://localhost/cgi-bin/mapserv</url>
>
>
>          <layer name="streets"/>
>    </map-source>
>
> I don't know if it has something to do with the problem.
>
> Hope you can help.
>
> Pinchi
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/geomoose-users/attachments/20110713/e4483589/attachment.html