Hi,
I need some help in doing something that should be fairly simple - but i’m not familiar with postgresql.
i have:
- a GRASS file of some 40 points which are met. stations in India.
v.db. select gives the following info FYI(subset)
cat|INDEX|STATION|LONG|LAT
1|43296|Bangalore|77.666389|12.949722
2|43197|Belgaum|74.505556|15.847222
3|43205|Bellary|76.917222|15.137500
4|43125|Bidar|77.333333|18.083333
5|43259|Balehonnur|75.464658|13.35130
- i also have corresponding for each point, a text file which contains 10 years of meteor0logical data.
what i ultimately want to do:
- Link each file to each point;
- So that i can extract any slice of data for all stations; and make either individual vector maps; interpolate the same; calculate derived variables and create new columns; get monthly sums from daily; and related operations…
I’ve looked up online for individual v.* and d.* commands that seem to be related, but dont quite know how to go about it.
Can someone provide a simple algorithm to follow? I assume that i have to link the ‘cat’ identifier somehow to each file?
thanks!
vishal