| Terence 2007-04-29, 7:04 pm |
| I already wrote a reply and I see it didn't get posted.
You have 6059 records each containing real values of:
latitude,longitude,spin, run-off by year(1:102) and you probably will
be addding to these data records.
You wish to make 102 year tables of latitude by longitude, within
which you willl then want to interpolate data to cover missing,
dubious and uncollectable points.
You don't need to be elegant about this.
What I suggest is you write a program to read your file and pick up
latitude, longitude and run-off for year 1901 (the index 1 of your 102
year data points. These are written to a table of latitude by
longitude for the year 1901. Here you anticipate the possible
coordinates and convert them on reading, to an integer index number
for your table entries. This takes care of the sorting problem. Then
you write this table to file "YEAR1901.RAW".
You test this table and ensure you program is doing what you want.
Then go back to your program and change it to do the same thing 102
times, using the year number as an index and generating the file name
the same way. The result is 102 files of data by year.
You will have a list of measurement point coordinates, which will
match the integer indexes you used in the tables
Then you can interpolate within year as a separate set of runs run. I
doubt interpolating between years has any validity.
|