[postgis-users] QGIS - PostGIS - ArcGIS Interaction

[Paragon Corporation]

James,

You can use shp2pgsql command line packaged with PostGIS.  It automatically
renames columns for you by adding digits to the end of duplicated 10char
names

So something like

pgsql2shp -f myshapefile -h myserver -u apguser -P apgpassword mygisdb
"SELECT * FROM incidents WHERE urgency = 'Immediate' AND
date_time_of_arrival - date_time_unit_assigned > '00:12:00' "

http://www.bostongis.com/pgsql2shp_shp2pgsql_quickguide_20.bqg

Leo
http://www.postgis.us 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of James
David Smith
Sent: Wednesday, June 15, 2011 1:58 PM
To: PostGIS Users Discussion
Subject: [postgis-users] QGIS - PostGIS - ArcGIS Interaction

Dear all,

I appreciate that this is more of a QGIS query, but I think that the route
of the problem might be in PostGIS, so... I have opened QGIS and ran the
query on my PostGIS table as below:

SELECT * FROM incidents
WHERE urgency = 'Immediate'
AND date_time_of_arrival - date_time_unit_assigned > '00:12:00'

This gives me 33 points in QGIS. Great. I would now however like to save
this as a ShapeFile for use in ArcGIS with which I am more familiar, but
when I try to SAVE AS from QGIS I am given the following error....

Export to vector file failed.
Error: trimming attribute name 'date_time_of_arrival' to ten significant
characters produces duplicate column name.

I am guessing that the problem here is that ESRI shapefiles can only deal
with column names that are ten characters long...? And that as I also have a
column called 'date_time_of_departure', when QGIS trims this column it ends
up with two columns called the same thing?  Is there a way around this? I
realise I could rename the column in QGIS, but I actually have around 45
columns in the table and this problem will occur with about 15 pairs of them
I think. I guess there is no simple answer... but thought I'd ask.

Cheers

James
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users