[postgis-users] issue with pgsql2shp

[John Cole]

Good catch!  Using %% to escape it fixed the query.

Thanks,

John

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
strk at refractions.net
Sent: Monday, June 05, 2006 12:22 PM
To: 'PostGIS Users Discussion'
Subject: Re: [postgis-users] issue with pgsql2shp

On Mon, Jun 05, 2006 at 12:19:14PM -0500, John Cole wrote:
> On 1) if I run the query in pgAdmin III Query it returns 596 rows, so
there
> is data there.  Any query that has a 'like' in the where clause seems to
> cause the error.
> 
> For example:
> 
> select the_geom from tgr_county2000 where county = 'Madison'
> 
> works fine
> 
> but
> 
> select the_geom from tgr_county2000 where county like 'Mad%'
> 
> does not.

mm... it can be your shell is "using" the '%' char as a special char.
If you built from sources I suggest you have pgsql2shp print
the query (maybe the code is already  by setting a DEBUG or VERBOSE
macro, should take a look).

--strk;

> 
> I have now tried segmentize on a line geometry and it does seem to work
(at
> least it increases the value returned by numpoints())
> 
> Thanks,
> 
> John
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> strk at refractions.net
> Sent: Monday, June 05, 2006 12:03 PM
> To: 'PostGIS Users Discussion'
> Subject: Re: [postgis-users] issue with pgsql2shp
> 
> On Mon, Jun 05, 2006 at 11:53:17AM -0500, John Cole wrote:
> > Strk,
> >   Thanks for the reply.  On issue 1) I am using the query and getting
the
> > error about the geometry types (unless you are talking about using a
> > sub-query).
> 
> Oh, sorry, I'm reading the error message better now (did you?).
> It says that your query returns an EMPTY table.
> Try your queries manually before feeding them to pgsql2shp.
> 
> >   With SnapToGrid in issue 2) will it eliminate any points that snap to
> the
> > same point?
> 
> It should. feel free to file a bug report if it doesn't.
> 
> >   On issue 3) the Segmentize returns [multi]polygons according to the
> > documentation, will it also work on lines and return those as well?
> 
> Did you try ? 
> 
> --strk;
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the sender. This
message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 

 /"\    ASCII Ribbon Campaign
 \ /    Respect for low technology.
  X     Keep e-mail messages readable by any computer system.
 / \    Keep it ASCII. 

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.