On 7/25/2011 10:52 PM, Paragon Corporation wrote:
Steve,
Is your pgsql2shp not exporting .prj files? It should be if you are
exporting an sql query or table/view with a known srid and all records have
the same srid. It should be doing this from version PostGIS 1.3.6 on. I
wrote that logic because I had similar issues with users using ArcMap not
being able to overlay the exports with their other data layers.
Thanks,
Regina
http://www.postgis.us
Hmmm, I recently upgraded and just now checked and yes it is writing the
.prj file. Sorry for old information and glad to know you are on top of
these issues.
RCSID: $Id: pgsql2shp.c 5181 2010-02-01 17:35:55Z pramsey $ RELEASE: 1.5
USE_GEOS=1 USE_PROJ=1 USE_STATS=1
Thanks,
-Steve
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Stephen
Woodbridge
Sent: Monday, July 25, 2011 9:17 PM
To: [email protected]
Subject: Re: [postgis-users] Shapefiles exported from PostGIS and ESRI
ArcView 9 compatibility
On 7/21/2011 3:23 AM, Ben Madin wrote:
G'dat all,
We have a client (potential client) who wants some mapping done and
the maps returned in shapefile format. In the contract they insist on
specifying that the shapefiles are compatible with "ESRI's ArcView
version 9" (their words, not mine).
I don't have "ESRI's ArcView version 9", and don't intend on spending
that sort of money (more than the contract is worth). However, I'm
sure that if what we send back doesn't open in "ESRI's ArcView
version 9" it will become our problem.
Does anyone have any reason to suspect that a shapefile created using
valid OGC geometry in PostGIS and exported using pgsql2shp would not
or might not work on "ESRI's ArcView version 9"?
Are there any issues that someone who is across platforms can help me
with?
(I routinely use shapefiles created using valid OGC geometry in
PostGIS and exported using pgsql2shp in QGIS and MapServer and send
them to other people, so I have no reason to be concerned except that
the client insists on this line remaining the contract!)
Hi Ben,
I use ArcGIS Explorer and it will not open shapefiles that do not have
.prj file. What I do in this case if to just write a script that
generates that appropriate .prj that I need. The other option that might
be work better for you is to use ogr2ogr to export the postgis table
into a shapefile as I believe that will write the .prj file appropriately.
-Steve W
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
