PL/SQL Determine if the coordinates of a point is within four points


 
Thread Tools Search this Thread
Top Forums Programming PL/SQL Determine if the coordinates of a point is within four points
# 1  
Old 05-29-2012
PL/SQL Determine if the coordinates of a point is within four points

Dear all,

Given that the coordinates of 4 points such as c1(x1,y1), c2(x2,y2), c3(x3,y3), c4(x4,y4).

Does any body know how to use plain sql / plsql to determine coordinates of a point e.g. (x,y) is within 4 points above efficiently. The 4 points supposedly form a rectangle rectangular.

In addition, if the 4 points do not form a rectangular, how to determine a point within the 4 other coordinates using plain sql or plsql
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

How to create a new mount point with 600GB and add 350 GBexisting mount point? IN AIX

How to create a new mount point with 600GB and add 350 GBexisting mount point Best if there step that i can follow or execute before i mount or add diskspace IN AIX Thanks (2 Replies)
Discussion started by: Thilagarajan
2 Replies

2. UNIX for Beginners Questions & Answers

Help with processing coordinates in a file.

I have a variation table (variation.txt) which is a very big file. The first column in the chromosome number and the second column is the position of the variation. I have a second file annotation.txt which has a list of 37,000 genes (1st column), their chromosome number(2nd column), their start... (1 Reply)
Discussion started by: Sanchari
1 Replies

3. Shell Programming and Scripting

Reducing the decimal points of numbers (3d coordinates) in a file; how to input data to e.g. Python

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

4. UNIX for Dummies Questions & Answers

overlapped genomic coordinates

Hi, I would like to know how can I get the ID of a feature if its genomic coordinates overlap the coordinates of another file. Example: Get the 4th column (ID) of this file1: chr1 10 100 gene1 chr2 3000 5000 gene2 chr3 200 1500 gene3 if it overlaps with a feature in this file2: chr2... (1 Reply)
Discussion started by: fadista
1 Replies

5. Shell Programming and Scripting

How to perform a hexdump using dd from start point to end point?

hi, I would like to ask or is it possible to dump a hex using dd from starting point to end point just like the "xxd -s 512 -l 512 <bin file>" I know the redirect hexdump -C but i can't figure it out the combination options of dd. Hope someone can share their knowledge.. Thanks in... (3 Replies)
Discussion started by: jao_madn
3 Replies

6. Shell Programming and Scripting

Determination n points between two coordinates

Hi guys. Can anyone tell me how to determine points between two coardinates. For example: Which type of command line gives me 50 points between (8, -5, 7) and (2, 6, 9) points Thanks (5 Replies)
Discussion started by: rpf
5 Replies

7. Shell Programming and Scripting

Search for particular tag and arrange as coordinates

Hi I have a file whose sample contents are shown here, 1.2.3.4->2.4.2.4 a(10) b(20) c(30) 1.2.3.4->2.9.2.4 a(10) c(20) 2.3.4.3->3.6.3.2 b(40) d(50) c(20) 2.3.4.3->3.9.0.2 a(40) e(50) c(20) 1.2.3.4->3.4.2.4 a(10) c(30) 6.2.3.4->2.4.2.5 c(10) . . . . Here I need to search... (5 Replies)
Discussion started by: AKD
5 Replies

8. UNIX and Linux Applications

Gnuplot question: how to plot 3D points as colored points in map view?

I have a simple gnuplot question. I have a set of points (list of x,y,z values; irregularly spaced, i.e. no grid) that I want to plot. I want the plot to look like this: - points in map view (no 3D view) - color of each point should depend on its z-value. - I want to define my own color scale -... (0 Replies)
Discussion started by: karman
0 Replies

9. Shell Programming and Scripting

Syntax to determine the storage in a particular mount point

Can someone please mention the syntax to determine the storage in a mount point (1 Reply)
Discussion started by: kthri
1 Replies

10. UNIX for Advanced & Expert Users

Fibre connection Point to Point SUN

Anyone know of a guide or instructions for Solaris I got to configure a SBUS HBA to talk to a tape robot. I have done this on a switch but not point to point. just going HBA >>>>> TAPE Fibre simple two nodes Kie (6 Replies)
Discussion started by: kie
6 Replies
Login or Register to Ask a Question
QwtPointPolar(3)						 Qwt User's Guide						  QwtPointPolar(3)

NAME
QwtPointPolar - A point in polar coordinates. SYNOPSIS
#include <qwt_point_polar.h> Public Member Functions QwtPointPolar () QwtPointPolar (double azimuth, double radius) QwtPointPolar (const QwtPointPolar &) QwtPointPolar (const QPointF &) void setPoint (const QPointF &) QPointF toPoint () const bool isValid () const bool isNull () const double radius () const double azimuth () const double & rRadius () double & rAzimuth () void setRadius (double) void setAzimuth (double) bool operator== (const QwtPointPolar &) const bool operator!= (const QwtPointPolar &) const QwtPointPolar normalized () const Detailed Description A point in polar coordinates. In polar coordinates a point is determined by an angle and a distance. See http://en.wikipedia.org/wiki/Polar_coordinate_system Constructor &; Destructor Documentation QwtPointPolar::QwtPointPolar () [inline] Constructs a null point, with a radius and azimuth set to 0.0. See also: QPointF::isNull QwtPointPolar::QwtPointPolar (doubleazimuth, doubleradius) [inline] Constructs a point with coordinates specified by radius and azimuth. Parameters: azimuth Azimuth radius Radius QwtPointPolar::QwtPointPolar (const QwtPointPolar &other) [inline] Constructs a point using the values of the point specified. Parameters: other Other point QwtPointPolar::QwtPointPolar (const QPointF &p) Convert and assign values from a point in Cartesian coordinates Parameters: p Point in Cartesian coordinates See also: setPoint(), toPoint() Member Function Documentation double QwtPointPolar::azimuth () const [inline] Returns the azimuth. bool QwtPointPolar::isNull () const [inline] Returns true if radius() >= 0.0. bool QwtPointPolar::isValid () const [inline] Returns true if radius() >= 0.0. QwtPointPolar QwtPointPolar::normalized () const Normalize radius and azimuth When the radius is < 0.0 it is set to 0.0. The azimuth is a value >= 0.0 and < 2 * M_PI. bool QwtPointPolar::operator!= (const QwtPointPolar &other) const Returns true if point1 is not equal to point2; otherwise returns false. Two points are equal to each other if radius and azimuth-coordinates are the same. Points are not equal, when the azimuth differs, but other.azimuth() == azimuth() % (2 * PI). See also: normalized() bool QwtPointPolar::operator== (const QwtPointPolar &other) const Returns true if point1 is equal to point2; otherwise returns false. Two points are equal to each other if radius and azimuth-coordinates are the same. Points are not equal, when the azimuth differs, but other.azimuth() == azimuth() % (2 * PI). See also: normalized() double QwtPointPolar::radius () const [inline] Returns the radius. double & QwtPointPolar::rAzimuth () [inline] Returns the azimuth. double & QwtPointPolar::rRadius () [inline] Returns the radius. void QwtPointPolar::setAzimuth (doubleazimuth) [inline] Sets the atimuth to atimuth. void QwtPointPolar::setPoint (const QPointF &p) Convert and assign values from a point in Cartesian coordinates Parameters: p Point in Cartesian coordinates void QwtPointPolar::setRadius (doubleradius) [inline] Sets the radius to radius. QPointF QwtPointPolar::toPoint () const Convert and return values in Cartesian coordinates Note: Invalid or null points will be returned as QPointF(0.0, 0.0) See also: isValid(), isNull() Author Generated automatically by Doxygen for Qwt User's Guide from the source code. Version 6.0.0 Fri Apr 15 2011 QwtPointPolar(3)