Spatial :: Decimal Points - Geometry - Sql Developer Geographer?

Aug 13, 2013

I have loaded shape files with SQL developer Georaper and limited number of decimals to 8. There is option to limit number of decimals in georapter.But there are some X, Y with many decimals. This may create problem in spatial functions in which geometries are compared and filtered

how to control the decimal points of X,Y to be loaded in geometry column.  -0.4695623500000000172249770002963487058878                    51.47160360000000167701728059910237789154-0.4702653600000000211345252409955719485879                    51.47174944999999723904693382792174816132-0.4713475400000000092859409051015973091125                    51.47330664999999783049133839085698127747-0.4717886499999999760923685698799090459943  
                 
[code]...

View 2 Replies


ADVERTISEMENT

Spatial :: Store Duplicate Geometry

Nov 9, 2012

I want to store duplicate geometry intentionally, will it have any problems ?? Because same data comes from different sources and going to be big database system.

View 8 Replies View Related

PL/SQL :: Two Decimal Points

Aug 10, 2012

What would be the syntax if I want to use use '999G999G990D00' to show only two decimal points for outstanding_receipt_value in the following

((declared_quantity - delivered_qty) * po_unit_price) outstanding_receipt_value

View 3 Replies View Related

Spatial :: Splitting Line At Multiple Points

Apr 22, 2013

I see that I can use SDO_LRS.SPLIT_GEOM_SEGMENT to split a line at a single point (and get 2 resulting lines).

However, how I could split a line, at multiple points, into multiple segments? I need to do this for many rows, therefore a function or procedure would be good if any exists.

View 13 Replies View Related

Spatial :: Sdo_nn To Fetch Points From Point Cloud And Georaster

Mar 9, 2013

I have a requirement to fetch the nearest neighbor from a given point coordinates inside a point cloud/georaster data. how can i retrieve a collection of all neighboring points from a given point.

I guess i will have to use sdo_nn operator. how to use the operator to achieve the result.

View 21 Replies View Related

Spatial :: Convert Shape File To Oracle Spatial

Jul 31, 2012

I have a road network which is shape file format and i want to export it to oracle spatial format using any free tool, I am using arcgis 9.3.1 and Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bi,

View 2 Replies View Related

Spatial :: Error In Spatial Index

Jun 16, 2013

I created a spatial index on a table, but i get the error message:

ORA-13033: the data in sdo_elem_info_array of sdo_geometry is unavailable

How can i write a SQL command to delete those unavailable records?

View 2 Replies View Related

How To Get Binary Data From Geometry Column

Mar 21, 2011

How to get binary data from Geometry column?

I want to read GEOMETRY COLUMN data as binary, using GET_WKB() method. I'm able to read character data by using GET_WKT().
But our requirement is to read data in binary format and display it.

View 1 Replies View Related

Spatial :: ORACLE 11g Spatial And GRS 80

Apr 4, 2013

I am working on a project that will require both projected coordinates and geographic coordinates for different product files coming in. I have no issues defining, storing, extracting or matching the geographic coordinates. My columns for those coordinates with SRID 8307 are defined in the user_sdo_geom_metadata table as follows:

INSERT INTO
USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
VALUES
('INVENTORYGEOMETRY','INVGEO',MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('Longitude', -180, 180, .05),MDSYS.SDO_DIM_ELEMENT('Latitude', -90, 90, .05)),8307);

the index: create index "MYDB"."INVGEO_IDX" on "MYDB"."INVENTORYGEOMETRY"("INVGEO") indextype is MDSYS.SPATIAL_INDEX;

how I am going to have a column that has both Geographic and Projected coordinates. Am I allowed to define more SDO_DIM_ELEMENT(s) fro the SDO_DIM_ARRAY with different min/max values. As an example, would I be able to still use an SRID of 8307 for both WGS 84 and GRS80 data (ellipsoid), something like the following:

INSERT INTO
USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
VALUES
('INVENTORYGEOMETRY','INVGEO',MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('Longitude', -180, 180, .05),MDSYS.SDO_DIM_ELEMENT('Latitude', -90, 90, .05),
(MDSYS.SDO_DIM_ELEMENT('FIXEDGRID_.5Resolution', 0, 26916, .5)),8307);

Is that possible or do i have to create a new column in the database? Also, I don't know the relationship between the SDO_ELLIPSOIDS table and the SDO_GEOMETRY table.

how I'm going to make this work for both the geographic and projected coordinates or if I'm going to be able to make it work.

View 4 Replies View Related

SQL & PL/SQL :: Query To Get Total Points From Various Factors

Oct 20, 2011

I am trying to calculate the total points of each customer

create table Customers(Customer_no number,revenue varchar2(30),Regularity varchar 2(30)
);
insert into Customers values(1,'25','2');
insert into Customers values(2,'50','3');

Table customers:

Customer_no, revenue, regularity
1,25,2
2,50,3

create table Points(ponts ID number,Factor varchar2(30),Weight number);

insert into Points values(1,revenue,2);
insert into Points values(1,Regularity,4);

Table points
Points ID,Factor,Weight
1,revenue,2
1,regularity,4

So for customer_no: 1

revenue is 25 * 2(weight for revenue ) =50
regularity is 2*4(weight for regularity) =8
Total =58

So for customer_no: 2

revenue is 50 * 2(weight for revenue ) =100
regularity is 3*4(weight for regularity) =12
Total =104

View 8 Replies View Related

PL/SQL :: Generate All Dates Between To Date Points

Sep 8, 2012

Is there a way I can generate a list of date using a simple SELECT statement to generate all dates between to date points? For example between SYSDATE AND SYSDATE-7?

One way I know is have a table and run PL/SQL script to put all dates in it and query that but was wondering if it can be achieve via SQL SELECT query at all without creating a table (querying DUAL).

View 5 Replies View Related

Server Administration :: Why 3 Mount Points For Datafiles

Feb 3, 2013

i encoutered lately on such statement:

Table D-7 shows a hierarchical file mapping of a sample OFA-compliant installation with two Oracle home directories and two databases. The database files are distributed across three mount points, /u02, /u03, and /u04. URL....

why three mount points (/u02, /u03, and /u04) for datafiles? don' understant this. isn't it better to store all datafiles in one mountpoint?

View 4 Replies View Related

Application Express :: How To Manage Positions Of Different Display Points Of Theme

Apr 6, 2013

I'm developing, or trying, on Apex 4.2...The issue is about themes and how to manage the positions of diferents Display Points of a theme.

Everybody know that any theme have a map where its position all differents parts of this map (Body1, Body2, Body3, position01, position02 and so). So when you choice any theme, it come with all this Display points defined. You can see this map rendering any region page and in the item Display Point you can see this map clicking on the light.

There is anyway to can manage this map and change position or behavior of those points?. For example , I'm interested that under the tabs, to have at the same height, 3 diferentes position, one at left, one at center and other at right.

View 2 Replies View Related

SQL & PL/SQL :: Integer As Decimal

Feb 18, 2010

I have a field in a table that is declared in the CREATE statement as an INT datatype. However, when I query that table using vb.net, the value comes back as a decimal.

How do you declare a field in Oracle as a true integer data type?

View 5 Replies View Related

SQL & PL/SQL :: Decimal Places In A Value

Dec 12, 2011

I have a table with column amount as decimal(11,2). I want to store the values as shown below

15.30

but it stores as

15.3

Is it possible to store the value in 15.30?

View 4 Replies View Related

Spatial :: Geometry  (0,0) Coordinates

Jun 3, 2013

When performing job search in i Recruitment found that all jobs are not retried when performing geocode search using Distance from Location functionality.

Narrowed down and found few addresses have Geometry coordinates (0,0) which are posing this problem.
Example :

Geometry :
MDSYS.SDO_GEOMETRY(2001,8307,MDSYS.SDO_POINT_TYPE(0,0,NULL),NULL,NULL)

Address line 1 :1560 Regent Ave
Town/City :Winnipeg
Region : MB
Postal code:R2C 3B4
COuntry : CA

This customer has 200 such Canada Addresses with (0,0) geometry details.

how to get the Geometry colun populated with proper coordinates so that the searches can be successfull.

View 2 Replies View Related

Spatial :: Strange Lengths From SDO?

Oct 7, 2013

The SDO_LENGTH command appears to be giving us the length of only the first line segment in a mult-segmented polylines. ... For example..  for this

polyline.... MDSYS.SDO_GEOMETRY(3002,82212,null,MDSYS.SDO_ELEM_INFO_ARRAY(1,4,2,1,2,1,7,2,2),MDSYS.SDO_ORDINATE_ARRAY(489308.53608219,5465823.43147879,0,489254.621813806,5465739.29869485,0,489223.453489433,5465690.81111309,0,489217.608149169,5465676.83952032,0,489213.696031073,5465662.20843221,0,489213.337168734,5465657.12388026,0,489213.259485918,5465652.02727197,0)) RunningUPDATE TEMP_1 SET LEN = SDO_GEOM.SDO_LENGTH (GEOMETRY,0.005,'unit=meter'); 

We get 99.925 meters,and not the 198.075 that we were expecting. 

View 5 Replies View Related

How To Convert Hex To Decimal For Each 2 Digits

Dec 6, 2008

Actually I got a data in hex values and i want to convert it to datetime format. But before i convert the hex value into datetime format, i must convert the hex values into decimal val first for each 2 digits of hex values. This is an example of the input data:-

This is input data in hex value:-
STARTTIME : 080b1317021a

This is decimal value after convert from hex to decimal:-
STARTTIME : 081119230226

My problem is how could i convert hex to decimal in oracle? Below are my coding:-

case
when substr(LOAD_NGNSM.STARTTIME, 1, 2) not between '00' and '99'
or substr(LOAD_NGNSM.STARTTIME, 3, 2) not between '01' and '12'
or substr(LOAD_NGNSM.STARTTIME, 5, 2) not between '01' and '31'
or substr(LOAD_NGNSM.STARTTIME, 7, 2) not between '00' and '59'
or substr(LOAD_NGNSM.STARTTIME, 9, 2) not between '00' and '59'
[code]....

View 5 Replies View Related

SQL & PL/SQL :: 2nd Decimal Place Not Appearing?

Jul 19, 2012

I am using Oracle Forms 6i. In my program unit i write into a .CSV and .TXT File. Here if the amount is 100.00 then it prints as 100 only. That is if the 2nd decimal digit is 0 it doesnt print it.

For example
10.00 -->10
10.01--> 10.01
10.10-->10.1
10.12-->10.12

I used to_char(nvl(&amount,0),'9999999.99') so if query select to_char(nvl(10.10,0),'9999999.99') from dual, then i get the output as 10.10.

Do you think this is a problem with Oracle forms or SQL or the formatting of .TXT & .CSV.

View 12 Replies View Related

SQL & PL/SQL :: Format Column Value In Decimal

Jul 26, 2013

I have an amount field and I want the o/p in the format of $9,999,999.99

like for 1500 it should display $1,500.00
for 25000 it should display $25,000.00
for 25000000 it should display $25,000,000.00

Test case

add comma from last 3rd position ,and append a $ in the start with two decimal places

View 15 Replies View Related

SQL & PL/SQL :: Comparing Two Decimal Values

Nov 5, 2011

Recently i have started working on PLSQL coding. I have a requirement. Either error or un-processed record count is 90% of to be processed records then the script has to fail. Currently I am having a situation where error count is 1 and total to be processed is also 1.

in the below
V_ERR is error count
V_UPS is un processed count
V_PROCESSED_COUNT is total to be processed.

I am expecting PASS result but it is giving FAIL.

DECLARE
V_ERR NUMBER:=0;
V_UPS NUMBER:=0;
V_PROCESSED_COUNT NUMBER:=0;
NIN NUMBER;
BEGIN
V_PROCESSED_COUNT:=1;
[Code] .......

View 1 Replies View Related

SQL & PL/SQL :: IDs Decimal Values Are Truncating

Jul 10, 2012

If I perform a Query as below

SELECT SUM(total_amt) FROM Amont_dtls WHERE id=10;

It's giving me the value as

2.08166817117217E-19

The values in total_amount column for ID=10 is 0.01 and -0.01..Actually it should return 0.If I use the query like

SELECT SUM(0.01-0.01) FROm Amont_dtls WHERE id=10;

Then I am getting 0.Why it's a variation.And also the data type of the column is NUMBER.If I use

SELECT TRUNC(SUM(total_amt)) FROm Amont_dtls WHERE id=10;

Then I am getting 0.But some other ID's decimal values are truncating.

Ex: If i Use TRUNC
Instead of 28781947.48 it's showing 28781947

Instead of 590874.5 it's showing 590874

View 6 Replies View Related

SQL & PL/SQL :: How To Get Integer Portion From Decimal

Feb 21, 2012

Using Oracle SQL Developer 2.1.1.64 to run the queries & Oracle 11g.

I have two numbers in two colomns of an oracle table(colomn a & colomn b). I am trying to divide colomn a/colomn b and putting the results in colomn c & also in colomn d (all in the same table) using update commands

Eg: UPDATE MTOTABLE_PWELD pw SET pw.WELDO=(pw.pipe_length/12000);

But here is the real issue. In colomn d I only need the integer portion of the division value.

For example , when I divide colomn a/colomn b , let us assume that we are getting a value of 2.56. Then I want the value of 2 to go to colomn d.

I tried round((colomn a/colomn b),0). But it rounds off 2.56 to 3. I dont want that. I need the exact integer portion of the value to be seperated.

View 2 Replies View Related

SQL & PL/SQL :: No Rounded Decimal Numbers

Aug 5, 2011

how can show this query in this picture

select round(15.555,2) from dual appear final result 15.55 only

and this query don't be this result 15.56

because i have filed and always Decimal numbers be (15.555,2)

i want only result appear after two numbers and no rounded the numbers

View 2 Replies View Related

PL/SQL :: Number Not Showing Zero After Decimal

Feb 21, 2013

i have a column

NUMBER(13,4)

when i insert 234.000

in show only 234

where as when i insert 234.12

i shows 234.12

is there any setting by which i can show 234.0000

View 13 Replies View Related

SQL & PL/SQL :: Decimal Values Validation

Jun 5, 2012

CREATE TABLE TEST ( CREDIT_BALANCE VARCHAR2(11 BYTE), AWARDS_BALANCE VARCHAR2(11 BYTE) )

Insert into TEST(CREDIT_BALANCE, AWARDS_BALANCE)
Values ('1678.09', '1678.9');
Insert into TEST(CREDIT_BALANCE, AWARDS_BALANCE)

[Code]....

From valid records from test table those two columns,need to be insert into test1 table. We should validate the decimal values while selecting from test table.

using regexp.

View 26 Replies View Related

Spatial :: Table Containing All Values And Description Of Each?

Sep 23, 2013

for functions like SDO_GEOM.RELATE, do the return values like "COVEREDBY", are those values/definitions defined in the database somewhere?  For instance a table containing all the values and a description of each? 

View 4 Replies View Related

Spatial :: Parameters For 2D Affine Transformation

Jul 13, 2012

I have the following parameters for 2D affine transformation:

Two translation:
tx=2754.3661 and ty = -237.0731
and rotation in radians: -.001016214498072193185827329

Is this specification correct:

SDO_UTIL.TO_WKTGEOMETRY(SDO_UTIL.AffineTransforms (
geometry =>myGeometry,
translation => 'TRUE', tx => 2754.3661, ty => -237.0731, tz => 0.0,
scaling => 'FALSE', psc1 => NULL, sx => 0.0, sy => 0.0, sz => 0.0,
rotation => 'TRUE',
p1 => MDSYS.SDO_GEOMETRY(2001, NULL, MDSYS.SDO_POINT_TYPE(0, 0, NULL), NULL, NULL), line1 => NULL,
angle => -.001016214498072193185827329,
dir => -1,
shearing => 'FALSE', shxy => 0.0, shyx => 0.0, shxz => 0.0, shzx => 0.0, shyz => 0.0, shzy => 0.0,
reflection => 'FALSE', pref => NULL, lineR => NULL, dirR => -1, planeR => 'FALSE', n => NULL, bigD => NULL
))

BTW, in PostGIS it works correctly: ST_Affine (myGeometry, cos(rotation), sin(rotation), -sin(rotation), cos(rotation), tx, ty));

View 6 Replies View Related

Spatial :: Select Repeating Values

Sep 7, 2012

some sample data in my point geometry table.

every POLYID has two rows with NAME value, i need to select the two rows if NAME is same for a given POLYID.

example: POLYID 4351 has same name N, then i need to select two rows with PILYID 4351.

POLYID POINTID           NAME
-----------------------------------------------------------------
4348 5763           N
4348 5764           F
4351 5741           N
4351 5756           N
4367 5721           M7

[Code]....

View 6 Replies View Related

Spatial :: Extract Point Heights From TIN?

Jun 18, 2013

Like to know a easy method to extract height for a coordinate in the TIN.

View 0 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved