<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<style>body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body bidimailui-detected-decoding-type="UTF-8" bgcolor="#FFFFFF"
text="#000000">
<p>On 01/03/2012 14:09, <a class="moz-txt-link-abbreviated" href="mailto:aruntheguy@gmail.com">aruntheguy@gmail.com</a> wrote:
<blockquote
cite="mid:CACbtZwR4gL_ppdjy_YVM7StBaDkTSGp1gA6OO=ojpUMR4HvdLw@mail.gmail.com"
type="cite">
<div>Hello,</div>
<div><br>
</div>
<div>I have worked with ArcGIS before as a part of my course.
In ArcGIS we used to carry out Projection of vector layer in
WGS 84 to Polyconic projection with a custom central meridian
using the Project Tool from the ArcToolbox. And that is saved
as a seperate feature in the mdb.</div>
<div><br>
</div>
<div>I have been trying to redo all my ArcGIS experiments in
QGIS to test the functionality. But I couldn't find out how to
do this re-projection. I am using Spatialite in place of the
mdb. So It would be better if the resultant is also within the
spatialite DB. But the CRS of the entire DB has been preset as
WGS 84 during creation. So, how can this be done? </div>
</blockquote>
</p>
<p><br>
</p>
<p>In QGIS you use the "Save As..." option (right click on the
layer in the TOC) then choose a different CRS. You can save the
new, reprojected, layer as a shapefile, or several other formats.</p>
<p>But if you're using spatialite, why not reproject right in the
database, using the ST_Transform() function?</p>
<p>I'd create a new table, duplicating the columns from the original
(except the Geometry- that you do with AddGeometryColumn(). Then:</p>
<p>SELECT AddGeometryColumn(</p>
<p> 'new_table', 'Geometry', <new epsg code>,<feature
type>,'XY');</p>
<p>INSERT INTO new_table (column1, column2,..., Geometry)</p>
<p> SELECT column1, column2,...,ST_Transform(Geometry, <new
epsg code>) </p>
<p> FROM old_table;</p>
<p><br>
</p>
<p>HTH,</p>
<p>Micha<br>
</p>
<p>
<blockquote
cite="mid:CACbtZwR4gL_ppdjy_YVM7StBaDkTSGp1gA6OO=ojpUMR4HvdLw@mail.gmail.com"
type="cite">-- <br>
Regards<br>
Arunmozhi<br>
Twitter: @tecoholic<br>
Website: <a moz-do-not-send="true" href="http://arunmozhi.in"
target="_blank">http://arunmozhi.in</a><br>
IRC Nick: teco<br>
<br>
<br>
This mail was received via Mail-SeCure System.<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
This mail was received via Mail-SeCure System.
</pre>
</blockquote>
<br>
<br>
</p>
</body>
</html>