[postgis-users] Error loading Postgis into ArcGIS as a Query Layer - issue with encoding

[Mark Volz]

Hello,

I found out that the reason why ArcMap cannot connect to my parcel layer has nothing to do with my coordinate system.  It seems the problem is that unlike QGIS, ArcGIS cannot read a postgis database that is encoded in LATIN1.  When I loaded my data using the PostGIS Shapefile Import/Export tool I received a warning that I should change my encoding from UTF-8 to LATIN1.  I used QGIS to create a shapefile without any attributes, and that shapefile loaded into PostGIS and then into ArcGIS without issue.

So I need to figure out one of the following:
1)  Find out what is wrong with my shapefile with attributes that is stopping me from loading the shapefile into PostGIS using UTF-8 encoding
2) Make ArcGIS read LATIN1 encoded postgis data.


Thanks for any help

Mark Volz
GIS Specialist

> Message: 1
> Date: Fri, 12 Oct 2012 19:22:29 +0000
> From: Mark Volz <MarkVolz at co.lyon.mn.us>
> Subject: Re: [postgis-users] Error loading Postgis into ArcGIS as a
> 	Query	Layer
> To: "postgis-users at postgis.refractions.net"
> 	<postgis-users at postgis.refractions.net>
> Message-ID:
> 	<36CA828A36E29F45B7CF0A1766E5DFA31543D2 at swmail01.r8nssis.lo
> cal>
> Content-Type: text/plain; charset="us-ascii"
> 
> Paul and Dave,
> 
> It looks like I will have to figure out how to add a my county coordinate
> projection into postgis.  I have the mapserver proj4js.  I noticed that the
> spatial reference table in postgis also has a line for the projection in proj4cs.
> 1) do I actually need proj4cs, or will it be sufficient to only include proj4js?   2)
> If I do need both projections, is there an easy way to convert proj4js to
> proj4cs?
> 
> Thank You for your help.
> 
> Mark Volz
> GIS Specialist
> 
> 
> > Message: 18
> > Date: Fri, 12 Oct 2012 13:10:11 -0500
> > From: David Fawcett <david.fawcett at gmail.com>
> > Subject: Re: [postgis-users] Error loading Postgis into ArcGIS as a
> > 	Query Layer - The specified coordinate exceeds the valid coordinate
> > 	range
> > To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
> > Message-ID:
> > 	<CAF7K3b_eEmxT+NwbGSTCH4M=4ry36JRxy1E0ZkeR7EdUBSSGvA@
> > mail.gmail.com>
> > Content-Type: text/plain; charset=ISO-8859-1
> >
> > OK, razor still sharp, David is just dull (at least while problem
> > solving and eating lunch at the same time).
> >
> > This is obiously a vector layer question, not a WMS one...
> >
> > On Fri, Oct 12, 2012 at 1:08 PM, David Fawcett
> > <david.fawcett at gmail.com>
> > wrote:
> > > Occam may need a new blade on this one.
> > >
> > > At least at version 10 and below of ArcMap, you can display a
> > > statewide WMS like this one with no problems.  The full extent of
> > > this service covers at least 3 UTM Zones.
> > >
> > > http://geoint.lmic.state.mn.us/cgi-
> > bin/mncomp?request=GetCapabilities&version=1.3.0&Service=WMS&
> > >
> > > David.
> > >
> > > On Fri, Oct 12, 2012 at 11:49 AM, Paul Ramsey <pramsey at opengeo.org>
> > wrote:
> > >> On Fri, Oct 12, 2012 at 9:03 AM, Mark Volz <MarkVolz at co.lyon.mn.us>
> > wrote:
> > >>> One potential issue is that technically our county falls under UTM
> > >>> 14 and
> > 15.  However, since the majority of the state falls inside of UTM 15,
> > many WMS services are published only for UTM 15.  Therefore I don't
> > know if ArcGIS is sending an error "The specified coordinate exceeds
> > the valid coordinate range" due to the fact  that the western edge of
> > the county is in UTM 14, and not UTM 15, or if there is another issue that I
> need to fix.
> > >>
> > >> Occams razor states that you have the answer. The error message is
> > >> very consistent with the situation you are describing. Use a
> > >> projection that is valid for your data extent and things should be
> > >> fine.
> > >>
> > >> P.
> > >> _______________________________________________
> > >> postgis-users mailing list
> > >> postgis-users at postgis.refractions.net
> > >> http://postgis.refractions.net/mailman/listinfo/postgis-users
> >