Hi
I’m trying to find the random point from a set of Longitude Latitude coordinates so I can create a co-ordinate string from the cluster

The Longitude values can be between -180 + 180 and Latitude between -90 and +90 degrees
each point needs to be with +or- 10 degrees of the last point

The code I’ve come up with works unless the first point is the one that is wrong causing every other point to be in error and $co-ord-String ony equels the firsst point.

The code is copied from a standalone so ignore obvious typosmy $co-ord-String;For my $pNum (sort keys %{$hash{$key}} { my @points = (sort{$a<=> $b} keys %{$hash{$key})); my ($long_H,$long_L,$Lat_H,$Lat_L); Foreach my $pt (@points) { my $long = $hash{$key}{$pNum}{Long}; my $lat = $hash{$key}{$pNum}{Lat}; if(($long_H eq "") and ($long_L eq "")) { #set higher & lower linits $long_H = $long + 10; $long_L = $long – 10; Repeat for $Lat } else { # check if $long is within 10 of last piont if($long >=$long_L && $long <= $long_H) { $long_H = $long + 10; $long_L = $long – 10; } else { # long is in error $long = ‘E’; } Repeat for $Lat } Unless (($long eq ‘E’) or ($lat = ‘E’) { $co-ord-String = $co-ord-String . $long . " " . $lat . ","; } } }$co-ord-String =~ s/,$//g

I have to put everything into code because it refuses to accept the i in paranthesis:

What you are checking is:Starting with the second point:p[i+1] >= p[i]-10 && p[i+1] <= && p[i]+10 That is, the next point must be in a range of +-10 of the point before.If this is true, p[i+1] is not an error.The problem is clear with the first point being the real error.A solution would be:Starting with the first point:Check forp[i+1]+10 > p[i] && p[i+1]-10 < p[i]In this case the check logic is something else. Imagin the second point in the middle of the range:i oi+1 |--------o--------|From the left to right every position is allowed.If the position is the most left one which is p[i]-10 = p[i+1]than p[i] not to be an error p[i] < p[i+1]+10 must be true.And if the position is the most right one which is p[i]+10 = p[i+1]than p[i] not to be an error p[i] > p[i+1]-10 must be true.All together:p[i] is not an error ifp[i+1]+10 > p[i] && p[i+1]-10 < p[i]is true.But thats still not all, because now the second last point can be an error, but the real error is the last one. A new problem.Solution:For all points except the first one and the last one, check both conditions:1 is the index of the first point, m is the index of the last point, k is the current point to check:for 1<k<mconditions:( p[k] <= p[k-1]+10 and p[k] >= p[k-1]-10 )or( p[k] < p[k+1]+10 and p[k] > p[k+1]-10 )must be true, for p[k] not to be an error.for k=1 (the first point):( p[k] < p[k+1]+10 and p[k] > p[k+1]-10 )must be true, for p[k] not to be an error.for k=m (the last point):( p[k] <= p[k-1]+10 and p[k] >= p[k-1]-10 )must be true, for p[k] not to be an error.Implementing it now should be straight forward.There is still a problem: say some point in the middle is an error in comparisonto the points before but not in comparison to the points after it. Which means youhave to lists where all points would be ok if the two lists would be separated.Checking like described will not find an error. But this condition is not definedin your explanation. Its an undefined condition of the list of points in yourscenario. Add another condition, called "break of lists" = b.p[k] is of type b, if ( p[k] <= p[k-1]+10 and p[k] >= p[k-1]-10 )XOR( p[k] < p[k+1]+10 and p[k] > p[k+1]-10 )is true.Regards,OliPS: long explanation but I developed it during writing :-)Short version: check in both directions for each points, for the first point check against next one only, for the last point check against the second last only. Scenarion "break of list" maybe unpossible in your case or use the XOR rule to find out.

so when testing the first point I'm testing it agents the last and second and the last point against first & second last

although i am testing the points in numerical order they may not be nearest to each other if plotted on a map but this is dealt with later while inserting into my database

BUT

say point 3 is in error 2 & 4 are ok then all 3 points are erroring because I'm testing

if (last point +- 10 of Point && Next point +- 10 of Point) on both the x and y axis (Long and Latitude) rather like a 10 degree circle around each point both it's neighbors are within it's circle.

So each point can be in error 0 or 1 time but not 2

so some how i need to test this

0

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

so when testing the first point I'm testing it agents the last and second and the last point against first & second last

No, I don't think so. You test the first point (in the sorted list) againts its successor, the last one against its predecessor. All others are tested against its predecessor and successor.

although i am testing the points in numerical order they may not be nearest to each other if plotted on a map but this is dealt with later while inserting into my database

Totally clear because you have longitude and latitude.

say point 3 is in error 2 & 4 are ok then all 3 points are erroring because I'm testing

Why is that? Or is this a new definition of yours now?
This would be my suggested test with k = 3:

for 1<k<mconditions:( p[k] <= p[k-1]+10 and p[k] >= p[k-1]-10 )or( p[k] < p[k+1]+10 and p[k] > p[k+1]-10 )must be true, for p[k] not to be an error.

For k=3 this results in false, because k-1=2 and k+1=4 are outside the +-10 range, 0 or 0 = 0.
For k=2 and 4 this test would result in true, because of the OR logic:
For k=2 it is false for k+1 (because 3 is an error) but true for k-1, together 1 or 0 = 1.
For k=4 it is false for k-1 (because 3 is an error) but true for k+1, together 0 or 1 = 1.

if (last point +- 10 of Point && Next point +- 10 of Point) on both the x and y axis (Long and Latitude) rather like a 10 degree circle around each point both it's neighbors are within it's circle.

No, thats not my suggestion, my logic would be:
if( point +- 10 of last point || point +- 10 of next point ) ... at least one neighbor is within its circle.
Mind the OR.

Oli thanx
May be i need to explain the situation a little more

If for instance you had a square you need a minimum of 4 points to make a square

Point co-ords X,Y
1 1,1
2 1,2
3 2,1
4 1,2
5 1,1

(You actually need 5 because the first and last points need to be the same to close the square)

In my data I’ve maybe 50 unique points at a seemingly random pattern and order within that same square they are numbered 1 to 50 but point 5 may not be adjacent geographically to points 4 or 6 hence my 10 degree error margin (The UK is about 6.5 degrees at it widest point) some of these points are not within this square. That’s why I need to test all points in both directions (as they are numbered) ie point 1 is with a 10d radius of both point 2 and 50 thus reducing the probability of point 1 being in error.

If I could I’d test every point against every other point but that’s not going to happen

You want to test if points are inside a given square?
Or is the square somehow spanned by the points in a beforehand unknown manner and you like to eliminate outliers?
Actually a square is mathematically defined by two points.

Maybe it would help for my comprehension, if you give an example of, say, 5 points and the exact question you have regarding these points.

Some more ideas:
Maybe you can calculate the centroid as an average of all points and check the distance of each point to the centroid.

Or you check for outliers statistically, e.g. by median absolute deviation larger than some value, (search for "median absolute deviation").

My database is PostGis it has a Convex_hull it creates a polygon from a cluster of points like in the diagram on the wiki page.

In my data set some of these points are in error creating spikes in the polygon that covers half the world unfortunately there isn't a postGis command that identifies these points so I’m attempting it in Perl first

I appreciate your help on this as it is making me focus on the problem so I can explain it.

If some points produce spikes than not the points are "in" error but the postGis (never heard) command Convex_hull has a bug and does not produce the convex hull as defined.

I try to draw an example with one "error" point:

points 1-4, no error point, the convex hull is trivial a polygon through all points + ++ +the same with an additional "error" point called e, the others 1,2,3,4 from left to right: + + ++ +The convex hull would be a triangle defined by the first 1, the last 4 and the new "error" point e.The two other points (2,3) are inside the convex hull.

FYI postGis is a bolt on to PostGresSQL giving it Geo (maps) analytical capabilities

using a insert command with Convex_hull will create what is known as a Geo blob of all its given points usually a polygon or if all points are straight a line.

unfortunately you can't tell it to ignore the spikes.

i think I've come up with a solution

loop through each point

if the point is within the last point +-10d on both Long & Lat axis add 1 to $count

repeat for it's next point

if the $count >=1 it must be good

the only issue is if two wrong points are together (points 3 & 4) they both have a count of 1 so pass the test

I need to investigate my data to see if this actually occurs or not.

I have been pestered over the years to produce and distribute regular data extracts, and often the request have explicitly requested the data be emailed as an Excel attachement; specifically Excel, as it appears: CSV files confuse (no Red or Green h…

There are many situations when we need to display the data in sorted order. For example: Student details by name or by rank or by total marks etc. If you are working on data driven based projects then you will use sorting techniques very frequently.…

Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions.
Consider email address RFCs:
Look at HTML5 form input element (with type=email) regex pattern:
T…