RE: [postgis-users] Updated shapefile to update postgres database

2008-06-15 Thread Paragon Corporation
EMAIL PROTECTED] On Behalf Of SenTnel Sent: Sunday, June 15, 2008 4:37 AM To: postgis-users@postgis.refractions.net Subject: RE: [postgis-users] Updated shapefile to update postgres database Thanks Regina for your help! I must tell you that the worst part of this is not knowing what most of what you

RE: [postgis-users] Updated shapefile to update postgres database

2008-06-15 Thread SenTnel
> Hope that helps, > Regina > > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > SenTnel > Sent: Sunday, June 15, 2008 1:34 AM > To: postgis-users@postgis.refractions.net > Subject: RE: [postgis-users] Updated shapefil

RE: [postgis-users] Updated shapefile to update postgres database

2008-06-15 Thread Paragon Corporation
gina > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > SenTnel > Sent: Saturday, June 07, 2008 4:36 PM > To: postgis-users@postgis.refractions.net > Subject: RE: [postgis-users] Updated shapefile to update postgres > d

RE: [postgis-users] Updated shapefile to update postgres database

2008-06-15 Thread Paragon Corporation
t; -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > SenTnel > Sent: Saturday, June 07, 2008 4:36 PM > To: postgis-users@postgis.refractions.net > Subject: RE: [postgis-users] Updated shapefile to update postgres > database > &

RE: [postgis-users] Updated shapefile to update postgres database

2008-06-14 Thread SenTnel
[EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > SenTnel > Sent: Saturday, June 07, 2008 4:36 PM > To: postgis-users@postgis.refractions.net > Subject: RE: [postgis-users] Updated shapefile to update postgres database > > > Hello Regina! Thanks for your hel

RE: [postgis-users] Updated shapefile to update postgres database

2008-06-07 Thread Paragon Corporation
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > SenTnel > Sent: Saturday, June 07, 2008 2:25 AM > To: postgis-users@postgis.refractions.net > Subject: Re: [postgis-users] Updated shapefile to update postgres > database >

RE: [postgis-users] Updated shapefile to update postgres database

2008-06-07 Thread SenTnel
D] > [mailto:[EMAIL PROTECTED] On Behalf Of > SenTnel > Sent: Saturday, June 07, 2008 2:25 AM > To: postgis-users@postgis.refractions.net > Subject: Re: [postgis-users] Updated shapefile to update postgres database > > > Hello! Im confused about this issue: > > I hav

RE: [postgis-users] Updated shapefile to update postgres database

2008-06-07 Thread Paragon Corporation
s-users@postgis.refractions.net Subject: Re: [postgis-users] Updated shapefile to update postgres database Hello! Im confused about this issue: I have a street (polyline) duplicated, one on top of the other, exact same features, same "the_geom", but one bears the street name (column:&qu

Re: [postgis-users] Updated shapefile to update postgres database

2008-06-06 Thread SenTnel
Hello! Im confused about this issue: I have a street (polyline) duplicated, one on top of the other, exact same features, same "the_geom", but one bears the street name (column:"street") "main street" and the other bears "N/A" as street name. Now my maps shows the street but the name that shows

Re: [postgis-users] Updated shapefile to update postgres database

2008-05-07 Thread SenTnel
Thanks Regina, Chris and all of you for your help. Im truly newby but with such help Im ready to start the procedures, Ill keep you posted of my progress or else if some issue comes along that may require some light from you, Thanks again and I hope my problem/solution may be of help to many other

RE: [postgis-users] Updated shapefile to update postgres database

2008-05-07 Thread Martin Chapman
Thanks for that info William. Best regards, Martin -Original Message- From: William Kyngesburye [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 06, 2008 5:56 PM To: PostGIS Users Discussion Cc: Martin Chapman; SenTnel Subject: Re: [postgis-users] Updated shapefile to update postgres

Re: [postgis-users] Updated shapefile to update postgres database

2008-05-07 Thread Chris Hermansen
Sent: Wednesday, May 07, 2008 1:50 AM To: postgis-users@postgis.refractions.net Subject: Re: [postgis-users] Updated shapefile to update postgres database Thanks! Thats exactly what I want to do, but just don't know how to. I don't pretend for you to give me a step by step indication but I

RE: [postgis-users] Updated shapefile to update postgres database

2008-05-07 Thread Obe, Regina
s.net Subject: Re: [postgis-users] Updated shapefile to update postgres database Thanks! Thats exactly what I want to do, but just don't know how to. I don't pretend for you to give me a step by step indication but Ill apreciate some instructions since Im really new to this and im eager to lear

Re: [postgis-users] Updated shapefile to update postgres database

2008-05-06 Thread SenTnel
Thanks! Thats exactly what I want to do, but just don't know how to. I don't pretend for you to give me a step by step indication but Ill apreciate some instructions since Im really new to this and im eager to learn more about it. Thanks again! Chris Hermansen wrote: > > Presumably what you mea

Re: [postgis-users] Updated shapefile to update postgres database

2008-05-06 Thread William Kyngesburye
I was interested in a similar thing once, but the ogr2ogr option names are misleading. "-update" means add to an existing data source (ie the database in Postgres). Otherwise ogr2ogr will try to create a new database, and fail if it exists. "-append" means add to an existing layer (or, t

Re: [postgis-users] Updated shapefile to update postgres database

2008-05-06 Thread Stephen Woodbridge
SenTnel wrote: Hello! I would like some help updating a postgres database. This is the problem: We created the database using shp2pgsql to convert a shapefile that contains a city's street details (centerline), after we created the database we also created an aditional column to classify the str

RE: [postgis-users] Updated shapefile to update postgres database

2008-05-06 Thread Martin Chapman
Ogr2Ogr at http://www.gdal.org/ogr/ogr2ogr.html has append and update options. As long as your new columns were added to the end of the table it will probably will work fine. Best regards, Martin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of SenTnel S

Re: [postgis-users] Updated shapefile to update postgres database

2008-05-06 Thread Chris Hermansen
Presumably what you mean by "update" is that you want to replace old versions of roads already in PostGIS with new versions of the same roads from shapefiles, and you want to keep the old street type in conjunction with the updated geometry? If that's the case, your problem is really determining w