StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Go and download the <a href="http://www.gdal.org/" rel="noreferrer">GDAL utilities</a> , the ogrinfo (which would spit the projection information) and ogr2ogr utilities are invaluable.</p> <p>James gave already a link to <a href="http://www.spatialreference.org" rel="noreferrer">spatialreference.org</a>. That helps to find spatial reference information... I assume you did load the <code>spatial_ref_sys.sql</code> when you <a href="http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01" rel="noreferrer">prepared your postgis instance</a>.</p> <p>And to be honest, I don't think the problem is in the PostGIS side of things. </p> <p>I usually keep my data in different SRIDs in my PostGIS dbs. However, I always need <strong>to project to the output SRS</strong>. You are showing OpenStreetMap pre-rendered tiles, and I bet they have been drawn using SRID 900913 (<a href="http://openlayers.org/pipermail/tilecache/2008-December/001561.html" rel="noreferrer">the Google Map's modified mercator projection</a> that now everyone uses to <strong><em>render</em></strong>).</p> <p>My recommendation to you is:</p> <p>1- Set the right projection in the OpenLayers code which matches whatever tiles you are reading from.</p> <p>2.- Keep the data in the database in whatever SRID you want (as long as it is correct of course).</p> <p>3.- Make sure the server you are using to generate the images from your data (ArcGIS Server, Mapserver, GeoServer or whatever it is) is reprojecting to that same SRS. </p> <p>Everything will match.</p> <p>Cheers</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload