<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19088">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Garamond>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.</FONT></DIV>
<DIV><FONT face=Garamond>Dara</FONT> </DIV>
<DIV><FONT face=Garamond></FONT> </DIV>
<DIV><FONT face=Garamond>----</FONT><BR>Message: 4<BR>Date: Tue, 12 Jul 2011
17:07:38 -0600<BR>From: Brent Fraser <<A
href="mailto:bfraser@geoanalytic.com">bfraser@geoanalytic.com</A>><BR>Subject:
Re: [Geomoose-users] How to add a new line to postgis db in<BR>degrees?<BR>To:
pinchitirabassi <<A
href="mailto:pinchitirabassi@gmail.com">pinchitirabassi@gmail.com</A>><BR>Cc:
<A
href="mailto:geomoose-users@lists.sourceforge.net">geomoose-users@lists.sourceforge.net</A><BR>Message-ID:
<<A
href="mailto:4E1CD3BA.9020205@geoanalytic.com">4E1CD3BA.9020205@geoanalytic.com</A>><BR>Content-Type:
text/plain; charset=ISO-8859-1; format=flowed<BR><BR>Pinchi,<BR><BR>
The problem is that GeoMoose is set up to deal with coordinates in <BR>the
Display Coordinate System (900913 in your case). That's what the
<BR>JavaScript passes to the editor.php, and that's what the PHP inserts
<BR>into the PostGIS database. I'd recommend storing the data in PostGIS
in <BR>900913, otherwise you'll have to edit the editor.php to use
<BR>"ST_Transform" prior to inserting into the database.<BR><BR>Best
Regards,<BR>Brent Fraser<BR><BR><BR>On 7/12/2011 4:16 PM, pinchitirabassi
wrote:<BR>> Hi, I've set up geomoose and I followed the instructions on the
website. I<BR>> created a tool to add lines, and they are added to the
database, but I have<BR>> a database with information in the EPSG:4326 SRID,
and the insertion is made<BR>> in meters. I need to configure it so as to
insert linestrings in degrees.<BR>><BR>> So far, I have changed some lines
in the mapbook:<BR>><BR>> EPSG:4326<BR>> dd<BR>><BR>> But this
didn't do anything.<BR>><BR>> I set a wms map-source and it works
perfectly:<BR>><BR>> <map-source name="street_editor" type="wms"
tiled="true"<BR>>
projection='EPSG:900913'><BR>>
<url>http://localhost/cgi-bin/mapserv</url><BR>><BR>><BR>>
<layer name="streets"/><BR>>
</map-source><BR>><BR>> I don't know if it has something to do with
the problem.<BR>><BR>> Hope you can help.<BR>><BR>>
Pinchi</DIV></BODY></HTML>