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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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: >>> >> > >>> >> > [EMAIL PROTECTED]:~$ 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 >>> >> > [email protected] >>> >> > 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 >>> >> [email protected] >>> >> http://postgis.refractions.net/mailman/listinfo/postgis-users >>> >> >>> > _______________________________________________ >>> > postgis-users mailing list >>> > [email protected] >>> > 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 >>> [email protected] >>> 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 >> [email protected] >> 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. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
