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

[Mark Volz]

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
>