« Return to Thread: pgsql2shp

Re: RE: pgsql2shp

by pcreso :: Rate this Message:

--- anhtin <anhtin@...> wrote:

>
> thanks very much all support to me
>
> How can i customize the Query
> Ex: i have Box (295149 2315499, 465992 2163790)
> can I export this box ???
>

I'm not sure what you mean by export, but if you want to use this box in a
query, try something like:

pgsql2shp -f myshp -h myserver -u apguser -P apgpassword mygisdb
"select * from province WHERE id IN(1,2,3,4,67,34)
and geom && SetSRID('BOX3D(295149 2315499, 465992 2163790)'::box3d,-1)

See the docs at http://postgis.refractions.net/docs/ch04.html#id2640015

Cheers,

Brent Wood

>
>
> Obe, Regina DND\MIS wrote:
> >
> > pgsql2shp -f myshp -h myserver -u apguser -P apgpassword mygisdb
> > "select * from province WHERE id IN(1,2,3,4,67,34,23,22)"
> >
> > Note the myshp is the shapefile name without the suffix
> > So if you wanted to output province.shp and province.dbf you would just
> > type in province for myshp
> >
> > Hope that helps,
> > Regina
> >
> >
> > -----Original Message-----
> > From: postgis-users-bounces@...
> > [mailto:postgis-users-bounces@...] On Behalf Of
> > anhtin
> > Sent: Thursday, April 12, 2007 5:34 AM
> > To: postgis-users@...
> > Subject: [postgis-users] pgsql2shp
> >
> >
> > Hi all
> > I am developing application Web use Mapserver and Database Postgis
> > I want Export Data Corrdinate in Post Gis to shapfile. But Export with
> > condition
> > ex: select * from Province where id in '1,2,3,4,67,34,23,22'
> > How can i do that ???
> >
> >
> > --
> > View this message in context:
> > http://www.nabble.com/pgsql2shp-tf3564424.html#a9956047
> > Sent from the PostGIS - User mailing list archive at Nabble.com.
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users@...
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> > -----------------------------------------
> > The substance of this message, including any attachments, may be
> > confidential, legally privileged and/or exempt from disclosure
> > pursuant to Massachusetts law. It is intended
> > solely for the addressee. If you received this in error, please
> > contact the sender and delete the material from any computer.
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users@...
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/pgsql2shp-tf3564424.html#a9971889
> Sent from the PostGIS - User mailing list archive at Nabble.com.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@...
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>

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

« Return to Thread: pgsql2shp