The problem is that the e00 file isn't in the Postgres database. Basically, I imported the e00 file into dbf "normally" using the gui, then tried to attach the Postgres table as attributes of the data from the e00 file I imported. But because the key field from the e00 file (cat) doesn't exist in the Postgres table, I can't associate the data based on the field they do share in common (zipcode).
I suppose I could have imported the e00 into Postgres, instead of dbf, in which case the strategy you describe would work. James M. Turner Senior Software Engineer - Kronos Labs Kronos, Inc. 2 Omni Way, Chelmsford, MA 01824 (w) 978-947-4108, (c) 603-552-2020, (f) 978-256-2477 [EMAIL PROTECTED] > -----Original Message----- > From: Jarek Jasiewicz [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 09, 2007 11:55 AM > To: Turner, James > Cc: Daniel Victoria; [email protected] > Subject: Re: [GRASS-user] Associating attributes from Postgres file with a > key other than cat > > Turner, James wrote: > > That would work if there was an equivalent to the CAT field in the table > > I wanted to join to. There isn't, it needs to join on the zip code, > > which is the key field for the data in Postgres. There doesn't seem to > > be any way to associate data from an SQL table to a piece of vector data > > unless the SQL table has the same cat field available. In other words, > > if the original imported e00 file has: > > > > cat > > zipcode > > altitude > > population > > > > and the database table has: > > > > zipcode > > median_income > > life_expectancy > > > > > > I have a problem with understanding what you really want, because I see > no relation between imported e00 and database (there are from one source > or not, I don't know if database of e00 is in pgSQL or in other pale > etc) but, if you have in one database two tables: let say: e00 and ZTCS > with structure similar to above mayby this will help: > > CREATE TABLE joined AS > SELECT e.cat AS cat, e.zipcode AS zipcode, e.population AS population > z.medianincome AS medianincome, z.life_xepectancy AS life_expentancy > FROM ZTCS z JOIN e00 e ON z.zipcode=e.zipcode; > > next join jour importet e00 file to new table with v.db.conect > _______________________________________________ grassuser mailing list [email protected] http://grass.itc.it/mailman/listinfo/grassuser
