oracle spatial sdo geometry from wkt

Hi, I am trying to create a sdo geometry object using wkt. My wkt is over 4000 in length. How can I overcome this?My final goal is to move a geometry column in postgis in oracle. So what I had done was select 'update MAPPEDFEATURE_GEOLSTRUCTURE set shape=SDO_GEOMETRY(\'' ||st_asText(shape) || '\') w ...

Oracle Ora-13033 Invalid data in the sdo_elem_info_array in sdo geometry object

I am getting this error when I am creating spatial index on geometry. I suspect I have some problem with some rows of my geometry data. I have identified and fixed these problems so far. but I still getting error on spatial index creation.-emptry Gtype in some rows-wrong Gtype in some rowsComplete E ...

Oracle Spatial Java: Shapefile to SDO

The sample Shapefile to SDO class only imports the geometry into the database from the *.shp file and not the associated attributes stored in the *.dbf file. However, the unsupported shptosdo.exe imports all of the data. Is there a Java class somewhere that will perform the complete import? If not, ...

Oracle Java: Convert BLOB returned from sdo_geor.getRasterSubset(.....) into image

I'm sure this is really easy - but I can't find a way to do it and would appreciate a few pointers.I'm working in Java and trying to pull a raster out of the db and manipulate it (draw on it, etc.) before displaying in my app.I make my db connection. I then do this.. (fairly sure callable statement ...

Java PreparedStatements and Spatial Geometry Functions: Incompatible?

I have encountered the following situation: 1) Have devised a table that includes a GEOMETRY type (part of the spatial extensions provided by MySQL, http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html) 2) Geometry is provided in WKB, therefore I must use GeomFromWKB(...) in my insertion s ...

urgent help with java...convert int to String :S

private void eaddbtnActionPerformed(java.awt.event.ActionEvent evt) { if(eaddbtn.getText().equals("Add")){eaddbtn.setText("Save");eupbtn.setVisible(false);// edeletebtn.setVisible(false);ecanbtn.setText("Cancel");}else{Enrollment e = new Enrollment(eid_txt.getText(),eco ...

Java Convert UTF8 to MS949 MS874

I'm relatively new to java.Now I'm writing JAVA(1.6) program to send SMS to local customer.I should manipulate as 2 languages, MS949(Korean) and MS874(Thai).There's one tomcat server with thread base scheduler program.I've added this option to set up UTF in tomcat server.JAVA_TOOL_OPTIONS -Dfile.enc ...

Java objects to represent geometry (ST_Polygon)

I'm querying for ST_Polygon objects through java. I was wondering if there is a jdbc driver that supports db2 spatial components (preferably a transformation to a java polygon object).Currently I'm using "SELECT ST_Text (polygonGeom) ..." and parsing the string into a java polygon. ...

how to bind a field in java bean to sdo

I have a java bean called personal information that has two field name and address.I collect those two field from a form.Now after the user hit submit of that that form , i want to pass two fields in the personal information bean to a new form called store information.In that new form store informat ...

who can hlp me java convert to c++

import javax.swing.*;import java.awt.*;import java.awt.event.*;public class Plane extends JAppletimplements ActionListener {JTextField input;JLabel prompt1, prompt2;JButton yesButton, noButton;int section, seats[], smoking;int nonsmoking, people;public void init(){input = new JTextField( 4 );input.a ...

Ubuntu Java: convert a unicode value into a char

Say I have an integer value and want to convert it into a char, what's the best way of doing this? I have looked through the javadocs for the Character class but couldn't come up with anything.Could someone point me in the right direction? ...

Java Convert ArrayList to Vector - performance

I have a method which needs to return a Vector object. Now, I realize that I dont really need it to be a Vector here and an ArrayList would do the job too since i dont need a synchronized collection. However, due to framework limitations, the return type must be a vector. I was wondering if I could ...

Java Convert String to Printwriter (socket)

I'm writing a chat client applet, but I am having trouble with sending messages to the server.public void keyPressed(KeyEvent e) { int key=e.getKeyCode(); if (key==KeyEvent.VK_ENTER) { if (message.toString()==null) { } else { String messageText=message.toString(); sendMessage(messageText); } } } ...

Java Convert a 2-byte and 4-byte interger pair into a Double

This is to write a Java version of a function in a DLL that we use on WIndows (32-bit, Intel), which takes a (C#) Int16 (2-byte) and Int32 (4-byte) and returns a Double.Example of inputs and corrct results are:EntCOnvertInt ( Int16, Int32 ) = ResultEntCOnvertInt ( 129, 0 ) = 1EntCOnvertInt ( 138, 36 ...

Java convert

is there's a way that mysql query change the output of data fetch in database with the use of jasper report. ...

Oracle Rookie - Check if sdo geometry is within a bounding box

I'm sure this has been done countless times, but I'm new to Oracle Spatial (using Locator, actually) and I have an immediate need to be able to check if a given SDO_GEOMETRY is within a bounding box.If anyone could please help me, I'd be eternally grateful. ...

Ubuntu [Java] - Convert byte to GB -> MB -> kb -> byte

I got a program that print out traffic from time to time, problem is that it only print the largest unit, 2,6 GB become 2 GB. Is it possible to get around it so it print 2 GB 632 MB 20 kB 2 byteprivate static String reportTraffic(long trafficPrint){if((trafficPrint/1000000000)>0){return (trafficP ...

Ubuntu Java: Convert a string to 2D char array

I have a string array of 25 chars I want to put into a 2D array, five chars on each line to form a matrix of 5x5. I know to put a string into a 1D array you just run:char[] cArray = string.toCharArray();But could anyone tell me how to put the string into the mentioned 2D array? I'm thinking splittin ...

Java Convert file size from number to string

I wrote a static method that accepts file size in bytes, then return the textual representation in KB, MB, GB...Here is the code:public static String convertFileSize(double size) { String strSize = ""; long kb = 1024; // Kilobyte long mb = 1024 * kb; // Megabyte long gb = 1024 * mb; // Gig ...

Oracle Getting the SRID from SDO_Geometry

I apologise in advance for asking this question but I am a complete novice of Oracle and wondered if anyone could help.I have loaded Ordnance Survey Mastermap into OracleXE using a data loader and would now like to see what the loader has stored the SRID number as within the object SDO_GEOMETRY. In ...

Oracle sdo_geometry and sdo_totpo_geometry

I developed spatial prototype 2 years ago with oracle 9i. in the class I was taught SDO-GEOMETRY column to store the geometirs. now, i am using spatial after 2 years and i find SDO_TOPO_GEOMETRY is also being used in our application. I am not clear how the two geometries are related. please recommen ...

Oracle Unable to user SDO API in Enterprise Java Beans (EJB)

I made a java program to access geometry in Oracle Spatial 9i with the help of SDO API sample programs.Now, I want to insert,delete,modify Oracle Spatial Datathrough Enterprise Java Beans(EJB) in Container Managed Persistance(CMP Beans)How can I do this. ...

Oracle GIS applications using Java/SDO/MapViewer

First of all, sorry if my english is not soo good.I had installed MapViewer in my computer. It4s working perfectly. After view the JSP demo page and the Java demo program, I4m trying to create my own program, using the MapViewer.Well, before start my job, I wonder if there is anyone who has already ...

Oracle How to convert SDO to Shapefile?

I am trying to convert my SDO layers in the Oracle into Shapefile.Please give any solution for me.Thanks in advance. ...

Oracle java.lang.OutOfMemoryError while loading network

We created a (small) SDO Geometry Network and can clearly see it with the Oracle Network Data Model Editor. The network contains 82000 nodes and 106000 links.If however we perform Network nw = nwm.readNetwork(conn,"OUR_NETWORK");in the Network Analysis Java API we get the java.lang.OutOfMemoryError. ...

Oracle Problem binding SDO Polygon as struct to prepared statement

I am using the Oracle JVM to load polygons. Inside the database (9i) I have installed the sdoapi. The loading works fine, only on some circumstances java fails to bind the STRUCT representing the sdo geometry to my prepared statement. The error message is always "Ungültige Argumente in Aufruf" some ...

Oracle Get WKT Error

I have tried to convert the Oracle geometry into Well Known text through Get_WKT() and get_Wkb() method of SDO_GEometry but recieved following errors on thisORA-13199: ENGINEERING is not supported by geometry WKB/WKT generation.ORA-06512: at "MDSYS.MD", line 1723ORA-06512: at "MDSYS.MDERR", line 17O ...

Oracle Geometry Drawings in Spatial Data

How to store a Text graphical element in the column of type MDSYS.SDO_GEOMETRY ? Please kindly let me know is there is any way of store Text graphical element in SDO Geometry. ...

Oracle Performance Status OJVM used for SDO Network data Model 10R2.0.2

Can anyone give some details on the performance status of the OJVM when using the Java api for SDO Network analysis in 10gR2.0.2?Is there been some improvements compared with 10gR1?http://forums.oracle.com/forums/thread.jspa?forumID=76&tstart=45&threadID=282613&trange=15txfor the feedbac ...

Aspose.Newsletter: Convert Excel file to PDF using Aspose.Cells

Aspose publishes June 2009 Newsletter for .NET & Java programmers (http://www.aspose.com/community/blogs/customer.newsletters/archive/2009/06/01/aspose-customer-newsletter-june-2009.aspx) by highlighting the newly supported features by Aspose.Pdf.Kit, Aspose.Editor, Aspose.Words and Aspose.BarCo ...

Convert Excel XLS file to PDF

This technical tip shows how to convert an Excel XLS file to PDF (http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/convert-xls-file-containing-images-or-charts-to-pdf.html) even if it contains any images or charts within it. You will be using Aspose.Cells and ...

Oracle Spatial Geometry Function

i need to know how can i convert the oracle geometry location values Lat and Lon DD:MI:SS to Decimal Values DD.MISSDetails:oracle 10.2.0.4 64 Bit Enterprise editionFront End :- Crystal ReportsData Type:- GeometryStored in form of DD:MI:SS (Degree:Minute:Seconds)Retrieval Function in built Oracle Sto ...

Oracle 11g, SRID & 3D-geometry

HiI migrated a spatial table from an Oracle 10 to an Oracle 11 databaseThe table contains Multilines with M-values.I validate the Geometries with "SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT" In Oracle 10: No Errors.In Oracle 11g: ORA-54668: 2D SRID cannot be used with a 3D geometry    ...

Oracle Geometry Storage Questions

Is it right that a sdo.geometry equals a blob?How get a geometry line stored (its and array of points?)?Is it true that if I store points (which together describe a line) in an line that that waste less memory? ...

Oracle ORA-13199 in Get_Wkt() procedure

I have tried to convert the Oracle geometry into Well Known text through Get_WKT() and get_Wkb() method of SDO_GEometry but recieved following errors on thisORA-13199: ENGINEERING is not supported by geometry WKB/WKT generation.ORA-06512: at "MDSYS.MD", line 1723ORA-06512: at "MDSYS.MDERR", line 17O ...

Oracle Get_Wkt() error

I have tried to convert the Oracle geometry into Well Known text through Get_WKT() and get_Wkb() method of SDO_GEometry but recieved following errors on thisORA-13199: ENGINEERING is not supported by geometry WKB/WKT generation.ORA-06512: at "MDSYS.MD", line 1723ORA-06512: at "MDSYS.MDERR", line 17O ...

Oracle Problems with sqlldr

This is the question. I got some sql and ctl sample from oracle site. They should be able to create some tables and fill them with datas, but they don't work!So i used shp2sdo to convert shape file to sdo geometry for oracle 8i spatial but the result is the same: the table is correctly created, but ...

Oracle Network Memory Object (PL/SQL)

I've created a SDO Geometry Network witch contains 846975 links and 622566 nodes.Using the Network Memory Object (PL/SQL) by issuing the sdo_net_mem.network_manager.read_network('ag_streets_network', 'FALSE');command I get an : ORA-04030: out of process memory when trying to allocate 131124 bytes (j ...

crontab of script doesn't work but manual does

I'm trying to run a Perl script via crontab that produces the following crontab error:"Exception in thread "main" java.lang.NoClassDefFoundError: Convert"This Perl script has the following:"system ("/usr/bin/java Convert midwest_callout.csv \"Midwest Callout\" ...

Ubuntu Shell script to resize jpg and subfolders

I use the following to resize images in a folder for file in `ls -l`doname=`echo $file | cut -f1 -d.`convert -strip -quiet -geometry 1024x768 -quality 80 $file /path/to/pictures/{name}_email.jpgdoneWhich works great. Every time I put a memory stick or camera card in my PC Shotwell imports them and s ...

ImageMagick: Too large files

I use the following ImageMagick command to resize a 1600x1200 jpeg image to a 200x150 jpeg:convert -size 200x150 -geometry 200x150 large.jpg thumb.jpgThe thumb file is about 22 kB.If I use an image editor like Paint Shop Pro, I'm able to reduse the same file (large.jpg) to a 200x150 jpeg which is no ...

Oracle Error When Deleting From A Trigger

When I use a trigger to delete from my Oracle Spatial table, the triggering delete statement will fail if the Oracle Spatial table has a spatial index.Details:Tables CHEV_WELLBORE and CHEV_WELLBORE_SDO need to stay in sync. CHEV_WELLBORE_SDO has an sdo geometry column plus foreign keys to join back ...

Xpath XML question

I have a question related to my XML file, Data object using Xpath.Here is my XML file<?xml version="1.0" encoding="UTF-8"?><tns:PhoneBook xmlns:tns="http://www.ibm.org/PhoneBook" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.ibm.org/PhoneBook PhoneBook ...

Oracle Loading M-Shapes

I habe two questions concerning the Linear Referencing System:1. Is it possible to load M-Shapes (Shapefiles with measured coordinates) with SHP2SDO inclunding the M-Values?2. Is it possible to write measured data from SDE to SDO Geometry?If not, how can I possibly do this? ...

Oracle Weird output from getOrdinatesArray() : [D@872380

I’m trying to decipher how to use the 10g SDOAPI to extract spatial coordinates, and I found the code example (listed below) on the forum (thanks user 139877, whoever you are). The code complies, connects and runs fine, but my output, rather than the 1 1 2 2 3 3 that I expected, looks like this:Geo ...

getting exec() to run in Windows

Am i correct that this will only work when php is installed as cgi?What?! That would suck.The following returns no errors but also doesnt do anything. Try it.If i run it from command line or...in ASP it works fine.Please... Any thoughts?Thank you.<?phpecho("begin");$cmd="c:\ImageMa ...

Oracle locator - chapter 12 in pro orcale spatial

I am trying to launch the sample application of chapter 12 pro orcale spatial book (by Ravi kothuri) . But I am getting the following error.Errors compiling:C:\OC4J\j2ee\home\application-deployments\MapViewer\web\persistence\_pages\_spatial_2d_book\_sample_2d_app\_SAMPLEAPPLICATION.javapackage oracl ...

Oracle loading data from shape files

i am trying to load data from shape files following is my batch file rem call ..\..\setup\SETHOME.batset oracle_sid=pwdbset path=E:\oracle\product\10.2.0\db_1\BIN\;%path%set oracle_home=E:\oracle\product\10.2.0\db_1set clpath=.;E:\oracle\product\10.2.0\db_1\jdbc\lib\ojdbc14.jar;E:\oracle\product\10. ...

Oracle TO_NUMBER and ORA-01722 invalid number pls delete

I cannot see where to delete a post I made. I found out my problem. It was in my NLS settings. Decimals were set to be commas instead of periods.please disregard this post, and delete if you are a moderator I recently tried to bring in lat/long coordinates from a VARCHAR2 field (and even as a flat f ...

Oracle codepage conversion from multi-lingual table using JDBC

I have an Oracle database that has been around since before any unicode was available. It is currently 9.2.0.7.0 and the charset is WE8ISO8859P1. I am trying to port all of the data in the 'Translation' table to a UTF-8 database. The problem is that each of the translated strings is stored in its ow ...