[GRASS-user] GRASS and linking postgres tables to spatial layers

Hey Folks,

I have imported a shape file of polygons representing canadian provinces. I also have a list of projects that have a particular dollar value attributed to them.

I would like to create a map that can classify each province by totla dolar value of all projects. Each classification would have a dollar range associated with a color.

Alternative would be to do pie charts or other graphics to easily examplify the distribution of money amongst provinces.

I am thinking that I have to link the GRASS data with a postgres table.

I looked in the GRASS book (2nd ed) and thorugh the wiki and man pages. No hints.

Any ideas?

I will already know that if you just need to read the postgis layers use v.external (http://grass.osgeo.org/grass63/manuals/html63_user/v.external.html)

2008/2/4, Sampson, David <dsampson@nrcan.gc.ca>:

Hey Folks,

I have imported a shape file of polygons representing canadian provinces. I also have a list of projects that have a particular dollar value attributed to them.

I would like to create a map that can classify each province by totla dolar value of all projects. Each classification would have a dollar range associated with a color.

Alternative would be to do pie charts or other graphics to easily examplify the distribution of money amongst provinces.

I am thinking that I have to link the GRASS data with a postgres table.

I looked in the GRASS book (2nd ed) and thorugh the wiki and man pages. No hints.

Any ideas?


grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user

David Sampson wrote:

I have imported a shape file of polygons representing canadian
provinces. I also have a list of projects that have a particular
dollar
value attributed to them.

I would like to create a map that can classify each province by totla
dolar value of all projects. Each classification would have a dollar
range associated with a color.

Alternative would be to do pie charts or other graphics to easily
examplify the distribution of money amongst provinces.

I am thinking that I have to link the GRASS data with a postgres
table.

I looked in the GRASS book (2nd ed) and thorugh the wiki and man
pages.
No hints.

Any ideas?

maybe something like the "Income and Employment USA 2002" map using
v.extrude + NVIZ?
  http://grass.osgeo.org/grass60/screenshots/viz.php

or d.vect.chart:
  http://grass.osgeo.org/screenshots/vector.php

see also v.reclass + GRASSRGB column to hold color.

Hamish

      ____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ

2008/2/4, Sampson, David <dsampson@nrcan.gc.ca>:

I would like to create a map that can classify each province by totla dolar value of all projects. Each classification would have a dollar range associated with a color.

Alternative would be to do pie charts or other graphics to easily examplify the distribution of money amongst provinces.

I am thinking that I have to link the GRASS data with a postgres table.

David, linking to postgres can be useful, but you can accomplish what you are trying to do using the
default GRASS database.

Michele.

Do you have any more information?

Would I just build onto the existing table or create a separate table and again link them?

I will eventually want to information accessible through WMS and perhaps other applications hitting the DB. but this might be a good proof of concept for right now.

Cheers


From: Michele Rocca [mailto:michele.rocc@gmail.com]
Sent: Tuesday, February 05, 2008 03:48
To: Sampson, David
Cc: grass-user@lists.osgeo.org
Subject: Re: [GRASS-user] GRASS and linking postgres tables to spatial layers

2008/2/4, Sampson, David <dsampson@nrcan.gc.ca>:

I would like to create a map that can classify each province by totla dolar value of all projects. Each classification would have a dollar range associated with a color.

Alternative would be to do pie charts or other graphics to easily examplify the distribution of money amongst provinces.

I am thinking that I have to link the GRASS data with a postgres table.

David, linking to postgres can be useful, but you can accomplish what you are trying to do using the
default GRASS database.

Michele.