<HTML dir=ltr><HEAD><TITLE>[Proj] load arcSDE raw data from database and convert to lat/long</TITLE>
<META content="text/html; charset=unicode" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7601.17699"></HEAD>
<BODY>
<DIV dir=ltr id=idOWAReplyText38541>
<DIV dir=ltr><FONT color=#000000 size=2 face="Times New Roman">Vincenzo,</FONT></DIV>
<DIV dir=ltr><FONT size=2></FONT> </DIV>
<DIV dir=ltr><FONT size=2>Since you did not mention where you are, I had to look up the coordinates to give you a clue. Since your coordinates are near Rome, the local coordinate system is a Gauss-Boaga Transverse Mercator referenced to the Monte Mario Datum of 1940 on the International ellipsoid. For further details, see my column on the <STRONG>Italian Republic</STRONG> in the August 2005 issue of <EM>Photogrammetric Engineering & Remote Sensing</EM>. The pdf of that column may be downloaded from the society's website at <A href="http://www.ASPRS.org">www.ASPRS.org</A>. </FONT></DIV>
<DIV dir=ltr><FONT size=2></FONT><FONT color=#000000 size=2 face="Times New Roman"></FONT> </DIV></DIV>
<DIV dir=ltr id=idSignature34563>
<DIV><FONT color=#000000 size=2 face="Times New Roman"><SPAN style="FONT-SIZE: 10pt">
<DIV style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt; mso-ansi-language: DE" lang=DE>Clifford J. Mugnier, C.P., C.M.S.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></DIV>
<DIV style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt">Chief of Geodesy,<o:p></o:p></SPAN></DIV>
<DIV style="MARGIN: 0in 0in 0pt" class=MsoNormal><B><SPAN style="FONT-VARIANT: small-caps; FONT-SIZE: 10pt">Center for GeoInformatics<o:p></o:p></SPAN></B></DIV>
<DIV style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt">Department of Civil Engineering <o:p></o:p></SPAN></DIV>
<DIV style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt">Patrick F. Taylor Hall 3531</SPAN></DIV>
<DIV style="MARGIN: 0in 0in 0pt" class=MsoNormal><B><SPAN style="FONT-SIZE: 10pt">LOUISIANA STATE UNIVERSITY <o:p></o:p></SPAN></B></DIV>
<DIV style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt">Baton Rouge, LA<SPAN style="mso-spacerun: yes"> </SPAN>70803<o:p></o:p></SPAN></DIV>
<DIV style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt">Voice and Facsimile:<SPAN style="mso-spacerun: yes"> </SPAN>(225) 578-8536 [Academic] <o:p></o:p></SPAN></DIV>
<DIV style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt">Voice and Facsimile:<SPAN style="mso-spacerun: yes"> </SPAN>(225) 578-4578 [Research] <o:p></o:p></SPAN></DIV>
<DIV style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt">Cell: (225) 328-8975 [Academic & Research]<o:p></o:p></SPAN></DIV>
<DIV style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt">Honorary Life Member of the <o:p></o:p></SPAN></DIV>
<DIV style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt">Louisiana Society of Professional Surveyors <o:p></o:p></SPAN></DIV>
<DIV style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt">Fellow Emeritus of the ASPRS <o:p></o:p></SPAN></DIV>
<DIV style="MARGIN: 0in 0in 0pt" class=MsoNormal><SPAN style="FONT-SIZE: 10pt">Member of the Americas Petroleum Survey Group<o:p></o:p></SPAN></DIV><BR></SPAN></FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> proj-bounces@lists.maptools.org on behalf of Vincenzo Ampolo<BR><B>Sent:</B> Wed 09-Nov-11 09:36<BR><B>To:</B> proj@lists.maptools.org<BR><B>Subject:</B> [Proj] load arcSDE raw data from database and convert to lat/long<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>Hi all,<BR><BR>I'm new to proj.<BR><BR>I just have a set of X, Y coordinates. i dunno what they are or the<BR>format they use. I suppose they are a raw export of arcgis point data<BR>exported via csv from a database. I think that arcsde is used as a<BR>gateway. Coordinates are:<BR><BR>X = 1550428 Y = 2447336 and should be a point closer to lat = 41,8905198<BR>lng = 12,4942486<BR>X = 2159820 Y = 1457635 and should be a point closer to lat = 45,463681<BR>lng = 9,1881714<BR><BR>I need a way to convert them. i tried to decode them as UTM or<BR>cartesians point in meters but it doesn't work.<BR><BR>Does anyone have a suggestion in how to solve this problem?<BR><BR>Thanks.<BR><BR>--<BR>Vincenzo Ampolo<BR><A href="http://vincenzo-ampolo.net/">http://vincenzo-ampolo.net</A><BR><A href="http://goshawknest.wordpress.com/">http://goshawknest.wordpress.com</A><BR><BR>_______________________________________________<BR>Proj mailing list<BR>Proj@lists.maptools.org<BR><A href="http://lists.maptools.org/mailman/listinfo/proj">http://lists.maptools.org/mailman/listinfo/proj</A><BR></FONT></P></DIV></BODY></HTML>