[GRASSLIST:1033] Re: Populating fields of one table based on SQL query from another ta ble

[Patton, Eric]

Hamish,

Sure, by all means. I'm definitely interested. Although I have zero
experience with Matlab, I could probably mirror the functionality through
bash. 


~ Eric.


-----Original Message-----
From: Hamish
To: David Finlayson
Cc: Patton, Eric; GRASSLIST at baylor.edu
Sent: 5/5/2006 8:12 AM
Subject: Re: [GRASSLIST:1002] Re: Populating fields of one table based on
SQL query from another ta ble



fyi I've got a few Matlab scripts for lining up and interpolating
positions from a GPS log & a recording instrument. Basic idea is the
recording instrument is taking a reading every 10 sec but the GPS only
every 30. I want a x,y column with my sensor data so figure out a
position for each record, then filter & calc a R:G:B column, then import
with v.in.ascii for snail-trail plotting & interpolation. It works
pretty well as the ship's movements are pretty steady vs a 2nd order
fit. Currently they are task specific but if I get the funds to do more
with that data I can revisit them & put together a more general script.
I can share the basic idea though if you are interested.



Hamish