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

[Eli Adam]

A useful trick like that along with the tigger code might be a helpful tip on the wiki: http://geomoose.org/wiki/index.php/Main_Page 

Eli

>>> On 7/13/2011 at 12:04 PM, in message
<C509828C7EF844868B9FAA89CB0CA6E1 at GISWKSTN2>, "Dara Olson" <dolson at glifwc.org>
wrote:
> 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