|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
How to get data only inside polygon created by points which is part of whole data from file?
Post 302411198 by reva on Thursday 8th of April 2010 12:55:01 AM
04-08-2010
How to get data only inside polygon created by points which is part of whole data from file?
hiii, Help me out..i have a huge set of data stored in a file.This file has has 2 columns which is latitude & longitude of a region. Now i have a program which asks for the number of points & based on this number it asks the user to enter that latitude & longitude values which are in the same region.here first point & last point should have same latitude & longitude so as to form a polygon. I mean to say this points form a polygon on the entire region of the data given in file.
Now i want a program using awk or unix which takes data from this file & points entered from user & then comparing this , it takes data from the file & stores data in another file such that for data which is only in the region of points or for data which is inside the polygon.
In short i want program which stores the data in another file only polygon region's data not the entire region of the file.
Please please Help me out.
For exampl:
Few lines of the file data are as follows
a.dat:
Here the 8 & 9th column is latitude & longitude of a region.
Using small program what i have it asks for
Enter no of points as : 7
Then for this 7 points the user will enter latitude & longitude using for loop. this 7 points i am entering is for ex:.
Actu this points forms a plygon in the given region of the file.. Now i want a program in such way that the points or the latitude & longitude only inside the polygon should be stored in another file say b.dat.
The answer for the above example or the output file using above file a.dat & the points
are
b.dat:
Now please me out.
Actu i have a region full of data i.e from latitude 0 to 40 & longitude 60 to 100.
Now i am asking for few points & based on how many ever points i am entering the lat & long for those points, this x,y points or lat long form a closed loop or polygon inside the given region 0 to 40 & 60 to 100..Now what i need is only the data which is inside that polygon or points which form a loop..Please help me out with a simple program..
Now i want a program using awk or unix which takes data from this file & points entered from user & then comparing this , it takes data from the file & stores data in another file such that for data which is only in the region of points or for data which is inside the polygon.
In short i want program which stores the data in another file only polygon region's data not the entire region of the file.
Please please Help me out.
For exampl:
Few lines of the file data are as follows
a.dat:
HTML Code:
BDA 1908 8 20 9 53 0.00 32.0000N 89.0000E 60.0 0 0.00 0 0.00 0.00 6.60 0 7.00 7.00 0 NULL BDA 1915 12 3 2 39 19.00 29.5000N 91.5000E 60.0 0 0.00 0 0.00 0.00 6.70 0 7.10 7.10 0 NULL SIG 1927 5 22 0 0 0.00 36.0000N 96.0000E 0.0 0 0.00 0 0.00 0.00 7.50 0 8.00 8.00 0 NULL BDA 1934 12 15 1 57 37.00 31.3000N 89.3000E 60.0 0 0.00 0 0.00 0.00 6.70 0 7.10 7.10 0 NULL SIG 1937 1 7 0 0 0.00 35.5000N 98.0000E 0.0 0 0.00 0 0.00 0.00 7.10 0 7.60 7.60 0 NULL LEE 1937 1 7 13 20 41.00 35.5000N 97.6000E 0.0 0 0.00 0 0.00 0.00 7.10 0 7.60 7.60 10 NULL SIG 1947 7 29 0 0 0.00 28.5000N 94.0000E 60.0 0 0.00 0 0.00 0.00 7.30 0 7.80 7.80 0 NULL BDA 1947 7 29 13 43 22.00 28.5000N 94.0000E 60.0 0 0.00 0 0.00 0.00 7.40 0 7.90 7.90 0 NULL G-R 1950 8 15 14 9 30.00 28.5000N 96.5000E 25.0 0 0.00 0 0.00 0.00 8.10 0 8.70 8.70 10 NULL ISS 1950 9 13 11 7 27.00 27.5000N 96.4000E 0.0 0 0.00 0 0.00 0.00 6.60 0 7.00 7.00 7 NULL G-R 1951 11 18 9 35 47.00 30.5000N 91.0000E 25.0 0 0.00 0 0.00 0.00 7.40 0 7.90 7.90 4 NULL LEE 1951 11 18 9 35 50.00 31.1000N 91.4000E 0.0 0 0.00 0 0.00 0.00 7.50 0 8.00 8.00 0 NULL G-R 1952 8 17 16 2 7.00 30.5000N 91.5000E 0.0 0 0.00 0 0.00 0.00 7.00 0 7.50 7.50 9 NULL BDA 1963 4 19 7 35 24.00 35.8000N 96.9000E 33.0 0 0.00 0 0.00 0.00 6.60 0 7.00 7.00 0 NULL PDE 2001 11 14 9 26 10.01 35.9500N 90.5400E 10.0 0 0.00 0 0.00 7.80 8.30 0 0.00 8.30 0 NULL
Using small program what i have it asks for
Enter no of points as : 7
Then for this 7 points the user will enter latitude & longitude using for loop. this 7 points i am entering is for ex:.
HTML Code:
29.45, 89.43 32.47, 90.98 27.25, 95.63 27.29, 98.27 36.74, 96.32 31.90, 87.67 29.45, 89.43
The answer for the above example or the output file using above file a.dat & the points
are
b.dat:
HTML Code:
BDA 1908 8 20 9 53 0.00 32.0000N 89.0000E 60.0 0 0.00 0 0.00 0.00 6.60 0 7.00 7.00 0 NULL SIG 1927 5 22 0 0 0.00 36.0000N 96.0000E 0.0 0 0.00 0 0.00 0.00 7.50 0 8.00 8.00 0 NULL BDA 1934 12 15 1 57 37.00 31.3000N 89.3000E 60.0 0 0.00 0 0.00 0.00 6.70 0 7.10 7.10 0 NULL G-R 1950 8 15 14 9 30.00 28.5000N 96.5000E 25.0 0 0.00 0 0.00 0.00 8.10 0 8.70 8.70 10 NULL ISS 1950 9 13 11 7 27.00 27.5000N 96.4000E 0.0 0 0.00 0 0.00 0.00 6.60 0 7.00 7.00 7 NULL
Actu i have a region full of data i.e from latitude 0 to 40 & longitude 60 to 100.
Now i am asking for few points & based on how many ever points i am entering the lat & long for those points, this x,y points or lat long form a closed loop or polygon inside the given region 0 to 40 & 60 to 100..Now what i need is only the data which is inside that polygon or points which form a loop..Please help me out with a simple program..
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
suppose u have a file which consist of many data points separated by asterisk
Question is to extract third part in each line .
0.0002*0.003*-0.93939*0.0202*0.322*0.3332*0.2222*0.22020
0.003*0.3333*0.33322*-0.2220*0.3030*0.2222*0.3331*-0.3030
0.0393*0.3039*-0.03038*0.033*0.4033*0.30384*0.4048... (5 Replies)
Discussion started by: cdfd123
5 Replies
2. Shell Programming and Scripting
Hi Everyone,
I will try to explain my question please forgive my english here.
I am looking for shell script or command that can compare data in the files.
I have 50 files in one directory test1 test2 test3 ....so on.
I want to compare data in each files with each other and output each... (4 Replies)
Discussion started by: email-lalit
4 Replies
3. Shell Programming and Scripting
I am using the fallowing script. this script seems to work fine except the file has data I do not wish to have. Is there away to omit that data. I will first provide the scrip and then a sample of the data the way it looks and then a sample of how I would like the data to look. Thanks for any... (3 Replies)
Discussion started by: krisarmstrong
3 Replies
4. Shell Programming and Scripting
Hello all,
I have a data file that needs some serious work...I have no idea how to implement the changes that are needed!
The file is a genotypic file with >64,000 columns representing genetic markers, a header line, and >1100 rows that looks like this:
ID 1 2 3 4 ... (7 Replies)
Discussion started by: doobedoo
7 Replies
5. Shell Programming and Scripting
I have a file that has been partially recoded so that data points that were formerly letter combinations are now -1, 0, or 1. I need to finish recoding the GG and CC data points. The file looks like this:
ID 1 2 3 4 5 6 7 8
83845676 0 0 0 0 CC -1 CC CC
838469. -1 -1 1 GG CC 0 CC 1
83847041... (10 Replies)
Discussion started by: doobedoo
10 Replies
6. Shell Programming and Scripting
Hi,
I have a file with one column data (sample below) and I am trying to write a shell script to calculate the difference between consecutive data valuse i.e
Var = Ni -N(i-1)
0.3141
-3.6595
0.9171
5.2001
3.5331
3.7022
-6.1087
-5.1039
-9.8144
1.6516
-2.725
3.982
7.769
8.88 (5 Replies)
Discussion started by: malandisa
5 Replies
7. UNIX for Dummies Questions & Answers
Hi, I need help on finding the value of my data that encompasses certain percentage of my total data points (n). Attached is an example of my data, n=30. What I want to do is for instance is find the minimum threshold that still encompasses 60% (n=18), 70% (n=21) and 80% (n=24).
manually to... (4 Replies)
Discussion started by: ida1215
4 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I have a large number of data files each containing simple integers from 1 to around 25000 in ascending order. However, they are not in a specific progression; some numbers are missing in each file.
For ex. datfile1 may have the numbers in order 1 2 4 6 7 8 12 ... 24996 24999
while datfile2... (8 Replies)
Discussion started by: latsyrc
8 Replies
9. Shell Programming and Scripting
I have a text file that shows the output of my solar inverters. I want to separate this into sections. overview , device 1 , device 2 , device 3. Each device has different number of lines. but they all have unique starting points. Overview starts with 6 #'s, Devices have 4#'s and their data starts... (6 Replies)
Discussion started by: Mikey
6 Replies
10. Shell Programming and Scripting
I have a file full of coordinates of the form:
37.68899917602539 58.07500076293945 57.79100036621094
The numbers don't always have the same number of decimal points. I need to reduce the decimal points of all the numbers (there are 128 rows of 3 numbers) to 2.
I have tried to do this... (2 Replies)
Discussion started by: crunchgargoyle
2 Replies