[postgis-users] PostGIS-users Digest, Vol 160, Issue 8

[Mark Volz]

David and Others,

Apparently ArcGIS has trouble reading PostGIS data with Z values.  I was able to fix this issue by deleting the Z values from my shapefile.


Sincerely,
Mark Volz, GISP


 
> Message: 2
> Date: Mon, 8 Jun 2015 21:15:04 -0500
> From: David Fawcett <david.fawcett at gmail.com>
> To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> Subject: Re: [postgis-users] error adding data into ArcGIS
> Message-ID: <53B85106-31D3-4A62-96FF-240BF4FA19E3 at gmail.com>
> Content-Type: text/plain; charset="utf-8"
> 
> Mark,
> 
> I ran into this recently, but can't remember what caused it. I will look back and
> see if I can remember. Maybe wrong SRS, null geometries?
> 
> David
> 
> 
> 
> > On Jun 8, 2015, at 4:29 PM, Mark Volz <MarkVolz at co.lyon.mn.us> wrote:
> >
> > Hello,
> >
> > All the sudden I am getting an error loading data into ArcGIS:  ?One or more
> layers failed to draw:  lyongis.public.parcels:  The specified coordinate exceeds
> the valid coordinate range?
> >
> > The script (below) that I used in the past always had worked fine.  So
> > I am not sure where to begin.  QGIS works fine.  I am using ArcGIS
> > 10.3 with Postgres 9.2
> >
> > Sincerely,
> > Mark Volz, GISP
> > Lyon County GIS Coordinator
> >
> > Script to load data into PostGIS.
> >
> > set PATH=C:\Program Files\PostgreSQL\9.2\bin;%PATH% cd /d
> > "D:\PostGISIncoming\LyonGIS"
> > rem load data to postgis
> > for %%f in (*.shp) do shp2pgsql -d -I -s 103749 -W LATIN1 %%f %%~nf |
> > psql -w -U postgres -d lyongis
> >
> > for %%a in (*.*) do move "%%a" "D:\PostGISIncoming\LyonGIS\Done"
> >
> > cd /d "D:\PostGISIncoming"
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at lists.osgeo.org
> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.osgeo.org/pipermail/postgis-
> users/attachments/20150608/93a59276/attachment-0001.html>