[postgis-users] pgsql2shp syntax - sentence construction
SenTnel
elvin.pimentel at gmail.com
Tue Jun 3 08:51:08 PDT 2008
Thanks guys! nicely done! Worked fine!!
:jumping::clap:
SenTnel wrote:
>
> Thanks again Kishor!
>
> The situation is that I work at a Truck Company and we keep a gps vehicle
> location service using geoserver and openlayers, our shapefiles were
> converted to postgis to be able to display the maps with the vehicle's
> positions.
>
> =)
>
>
>
> P Kishor-3 wrote:
>>
>> On 6/2/08, SenTnel <elvin.pimentel at gmail.com> wrote:
>>>
>>> Thanks Kishor!
>>>
>>>
>>> >If you are not changing the geometry, you can do all your attribute
>>> >updates as simple SQL updates
>>>
>>>
>>> Some changes are just name corrections, but I need also update the maps
>>> with
>>> new streets and roads, and that is the most important updates that
>>> needs to
>>> be done, since our maps are couple of years old and there are many new
>>> streets to add and that's why Im asking if the best way is to dump
>>> postgres
>>> to shape, update and then convert it again. What do you think is the
>>> best
>>> way to achive this updating process?
>>
>> If you have update a lot of geometry manually, and if you have ArcMap,
>> then yes, this is probably the easiest route. That is what I would do.
>>
>> Why do you even have your 2 years old data in PostGIS? Mind you, I am
>> *for* PostGIS. But, I am wondering -- unless there is a good reason to
>> take on the complexity of Postgres/PostGIS, why not just keep your
>> data in Shapefile format?
>>
>>
>>>
>>> Thanks again!
>>>
>>>
>>>
>>>
>>> P Kishor-3 wrote:
>>> >
>>> > On 6/2/08, SenTnel <elvin.pimentel at gmail.com> wrote:
>>> >>
>>> >> Thanks Stephen!
>>> >>
>>> >> I must admit that Im not good at this, but Im determined to mantain
>>> my
>>> >> city's database correcting names and roads classifications, etc.,
>>> that's
>>> >> why
>>> >> I need to take the postgres data and convert it to shapefile, then
>>> >> correct
>>> >> things with arcmap, then drop the old postgres data and then
>>> re-convert
>>> >> the
>>> >> updated shapefile to postgres, is this the way you would do it?
>>> >
>>> > If you are not changing the geometry, you can do all your attribute
>>> > updates as simple SQL updates (see below).
>>> >
>>> >>
>>> >> I have one more question about this updating, and this is a
>>> "select"
>>> >> question, (I'll remind you that Im an ignorant in this matters)
>>> would
>>> >> you
>>> >> please construct an sql sentence to achive this:
>>> >>
>>> >> In mydatabase, myschema, mytable there's a "street" column, where
>>> the
>>> >> street
>>> >> names are, let's say I want to correct a misspeled name, for
>>> example,
>>> >> "Geoge
>>> >> Washington", and want to correct it to "George Washington", how do
>>> you
>>> >> write
>>> >> the select?
>>> >>
>>> >
>>> > UPDATE mytable
>>> > SET street = 'George Washington'
>>> > WHERE street = 'Geoge Washington'
>>> >
>>> > Note the single quotes to delimit the text strings.
>>> >
>>> > You might do well do spend some time looking a few basic SQL
>>> tutorials
>>> > before launching ahead. You will get more mileage from the tutorials
>>> > than from asking these simple questions on list.
>>> >
>>> > http://www.google.com/search?q=sql+tutorial
>>> >
>>> >
>>> >> Thanks again!
>>> >>
>>> >>
>>> >>
>>> >>
>>> >>
>>> >> Stephen Woodbridge wrote:
>>> >> >
>>> >> > SenTnel wrote:
>>> >> >> Hi! Im working with postgres and geoserver but im just not good
>>> at
>>> >> sql
>>> >> >> statements, none the less in construction sentences in postgres,
>>> and
>>> >> I
>>> >> >> would
>>> >> >> like to create a shapefile from a table in postgres and don't
>>> want to
>>> >> >> make a
>>> >> >> costly mistake, so if you help me achieve this using pgsql2shp:
>>> >> >>
>>> >> >> database name: mydatabase
>>> >> >> schema: myschema
>>> >> >> table: mytable
>>> >> >>
>>> >> >> shapefile to be created: updatedshp
>>> >> >>
>>> >> >> database user: postgres
>>> >> >> password: any
>>> >> >>
>>> >> >> can you help me with the syntax to achieve the shapefile
>>> containing
>>> >> all
>>> >> >> of
>>> >> >> the data (and geom) in such table?
>>> >> >>
>>> >> >> Thanks !
>>> >> >
>>> >> > SenTel,
>>> >> >
>>> >> > pgsql2shp is not a SQL statement it is a command line tool:
>>> >> >
>>> >> > woodbri at carto:~$ pgsql2shp
>>> >> > RCSID: $Id: pgsql2shp.c,v 1.82 2006/01/16 10:42:57 strk Exp $
>>> >> > USAGE: pgsql2shp [<options>] <database> [<schema>.]<table>
>>> >> > pgsql2shp [<options>] <database> <query>
>>> >> >
>>> >> > OPTIONS:
>>> >> > -f <filename> Use this option to specify the name of the file
>>> >> > to create.
>>> >> > -h <host> Allows you to specify connection to a database on a
>>> >> > machine other than the default.
>>> >> > -p <port> Allows you to specify a database port other than
>>> the
>>> >> > default.
>>> >> > -P <password> Connect to the database with the specified
>>> password.
>>> >> > -u <user> Connect to the database as the specified user.
>>> >> > -g <geometry_column> Specify the geometry column to be
>>> exported.
>>> >> > -b Use a binary cursor.
>>> >> > -r Raw mode. Do not assume table has been created by
>>> >> > the loader. This would not unescape attribute names
>>> >> > and will not skip the 'gid' attribute.
>>> >> > -k Keep postgresql identifiers case.
>>> >> >
>>> >> >
>>> >> > So you might use it like:
>>> >> >
>>> >> >> pgsql2shp -f updatedshp.shp -h localhost -u postgres mydatabase
>>> >> >> myschema.mytable
>>> >> >
>>> >> > Have fun,
>>> >> > -Steve W
>>> >> >
>>> >> > _______________________________________________
>>> >> > postgis-users mailing list
>>> >> > postgis-users at postgis.refractions.net
>>> >> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>>> >> >
>>> >> >
>>> >>
>>> >>
>>> >> --
>>> >> View this message in context:
>>> >>
>>> http://www.nabble.com/pgsql2shp-syntax---sentence-construction-tp17613265p17613906.html
>>> >> Sent from the PostGIS - User mailing list archive at Nabble.com.
>>> >>
>>> >>
>>> >> _______________________________________________
>>> >> postgis-users mailing list
>>> >> postgis-users at postgis.refractions.net
>>> >> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>> >>
>>> > _______________________________________________
>>> > postgis-users mailing list
>>> > postgis-users at postgis.refractions.net
>>> > http://postgis.refractions.net/mailman/listinfo/postgis-users
>>> >
>>> >
>>>
>>> --
>>>
>>> View this message in context:
>>> http://www.nabble.com/pgsql2shp-syntax---sentence-construction-tp17613265p17614606.html
>>>
>>> Sent from the PostGIS - User mailing list archive at Nabble.com.
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>
>>
>> --
>> Puneet Kishor http://punkish.eidesis.org/
>> Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/
>> Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
>
>
--
View this message in context: http://www.nabble.com/pgsql2shp-syntax---sentence-construction-tp17613265p17626857.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
More information about the postgis-users
mailing list