This same i want to implement using SQL, because here i given the values x, y and a b c d randomly ... but these values i want to supply from table (above posted)...
For this i need your help to write these queries in optimized way.
ideaboy
Last Activity: Apr 6 '11, 06:11 AM
Joined: Feb 15 '11
Location:
-
Dear All,
I write a JAVA Program for this Interpolation formula ...
Here iam providing that program ... Please give me reply whether am i correct or not ??
import java.lang.Math. *;
public class Interpolation {
public Interpolation() {
}
public static void main (String[] args) {
double x=10.70, x1=10.20, x2=11.20, x3=10.20, x4=11.20, y=80.70, y1=80.20, y2=80.20,...Leave a comment:
-
@Stewart
This is not assignment, this is my project (i am working in Central govt dept).
@Rabbit
Thanks for your answer, i am finding the distances and i can make a box but second point (in my problem) needs interpolation formula to calculate, here i need help.Leave a comment:
-
SST- Sea Surface Temperature (treat this as a value which need to get as a result).
My problem is :
First, I need to get one box, my given point should be in that box (to get the box we need to find the coordinates of 4 points from table which is near by our given point).
Second, with that 4 points data we need to find our point value using interpolation formula
I hope you understand, if you need...Leave a comment:
-
see the table below:
LATITUDE LONGITUDE SST
13.09806 80.30028 28.2
13.09806 80.30028 28.2
13.09806 80.30028 28.3
13.09806 80.30028 28.3
13.09806 80.30028 28.3
13.09806 80.30028 28.3
13.09806 80.30028 28.3
13.09806 80.30028 28.3
13.09806 80.30028 28.3
13.09806 80.30028 28.3
13.09806 80.30028 28.3
13.09806 80.30028 28.3
13.09806 80.30028 28.3
13.09806...Leave a comment:
-
SQL Interpolation query
I want to write a query to get the interpolated result.
I have a table (which contains the gridded data - means lat, long, sst values for some points), the table contains around 100 million records.
I need to get a sst for my lat,long values (for these lat, long there is no exact match of records, so i need to take the result on interpolation based).
Please help me how to write the query to get the result...
No activity results to display
Leave a comment: