MySQL CSV and MS Excel (XLS) Import

Free tools to import CSV- and Excel-files: http://www.vbmyadmin.de "CSV Import" & "XLS Import" use MySQL-ODBC-Driver to connect with MySQL databases. ...

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 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 ...

Ubuntu Problem compiling QtiPlot 0.9.8 with xls import

I am having problems compiling the latest release of QtiPlot with .xls import.Starting from v0.9.8 the library ExcelFormat (http://www.codeproject.com/KB/office/ExcelFormat.aspx) is used instead of libxls.Since I solved (more or less cleanly) I want to give a quick outline how to compile QtiPlot 0.9 ...

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. ...

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 ...

Recommend an XLS to MySQL importer?

yes, i'm a lame PHP coder...and i need something fast. i use Navicat right now for a mysql GUI and i love it, EXCEPT, i'm having one problem with the XLS import function.let me explain:i can run an XLS import, choose the nice "Update/Append" option, which allows me to set a primary key and ...

Recommend an XLS to MySQL importer?

yes, i'm a lame and lazy PHP coder, otherwise, i'd code something myself...but i need something fast. i use Navicat right now for a mysql GUI and i love it, EXCEPT, i'm having one problem with the XLS import function. basically, you cannot set it so that blank XLS cells DO NOT overwrite any existing ...

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 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 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 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 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 ...

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 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 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 ...

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 ORA-0095.

I just installed oracle Sql Developer on my personal workstation and created a table called Ryde_Markets with a column type SDO geometry.create table ryde_markets(mkt_id number primary key,extra_name varchar(32),shape MDSYS.SDO_GEOMETRY);And it generated an error ORA-0095.Name already been used by a ...

Oracle arc convex and hollow

HiI have a sdo.geometry SDO_GEOMETRY(3003, 82337, NULL, SDO_ELEM_INFO_ARRAY(1,1005,2, 1,2,1, 46,2,2, 55,2,1, 61,2,2, 70,2,1), SDO_ORDINATE_ARRAY(702681,971735179; 4239045,97412308;0 ;702625,5; 4239032,21;0 ;702618,92; 4239058,79;0 ;702637,33; 4239063,21;0 ;702638,24; 4239059,42;0 ;702640,05; 4239059 ...

Oracle Creating routes with nodes and links tables

I used a script in one of the threads to create node and link tables based on some spatial data. I used it and now have to two tables Link_topo (containing columns Link_id, start_node_id and end_node_id) and Node_topo (containing columns node_id and node(type sdo.geometry)). Now I created a network ...

Oracle Value in the

I added an SDO geometry column to a table.I then update the column with a statement similar to the following:UPDATE customer_merge_tempSET geometry = MDSYS.SDO_GEOMETRY(2001, 8265,MDSYS.SDO_POINT_TYPE(longitude,latitude,NULL), NULL, NULL) When I look at the value in the column I see the below. Is th ...

Oracle How to Reduce Clusetering Factor on Table?

I am seeing a very high clustering factor on an SDO geometry table in our 10g RAC DB on our Linux boxes. This slow performance is repeateable on othe r Linux as well as Solaris DBs for the same table. Inserts go in at a rate of 44 milliseconds per insert and we only have about 27000 rows in the tabl ...

Oracle 3D point

how do i insert a 3d point(srid:4347) into a sdo.geometry column? ...

Java How-to subclass default TableCells correctly?

seems like I have a problem understanding the inner workings of cell rendering in a TableView: not entirely sure how to do customization, f.i. for formatting numbers. At the end a complete runnable example of what I'm doing but that feels like overkill: actually, I only want to replace the text of t ...

Java Problem with ChoiceBox

I have 2 questions, I put this on the code import javafx.application.Application; import javafx.beans.value.ChangeListener; import javafx.beans.value.ObservableValue; import javafx.collections.FXCollections; import javafx.collections.ObservableList; import javafx.geometry.Insets; import javafx.geome ...

Java How to obtain mouse events during a DND operation

all, I'am trying to introduce visual cues for when a drag and drop operation is occurring over a javafx node however the dnd appears to consume all mouse events. Is it possible to overcome this? I have created a simple example of the problem where mouse events clearly stop when a dnd occurs.import j ...

Java FXML how to set up TabPane side

I'm trying to figure how to change the TabPane side within fxml, so far haven't been successful, searched, skimmed the pdf @ http://fxexperience.com/wp-content/uploads/2011/08/Introducing-FXML.pdf but was unable to find an answer.Tried the following:<?xml version="1.0" encoding="UT ...

Java FXML - Acess Enums and/or Constants

In FXML, is it possible to set a propertie with the value of a Enum or Constant?Example:<?xml version="1.0" encoding="UTF-8"?>   <?import javafx.scene.layout.*?> <?import javafx.scene.control.*?> <?import javafx.scene.*?> <?import javafx.geometry.S ...

Java Understanding Mouse Event Bubbling

I had an issue recently trying to capture mouse events on a TextArea control - listening to the TextArea for any Mouse Event (i.e. clicking in the TextArea) would not fire events.What Gives? Do I need to "walk" the Scene graph down into the bowels of the TextArea children and add a listener somewher ...

JavaFX 2.0 WebEngine

I have an ADF application that I want to wrap with the WebEngine. This works fine, but, from the login screen, the taskflow forwards to the home page. This is not working. Does anyone know why? The code is below and thank you.package javafxbrowsermenuidea;import javafx.application.Application;import ...

Java How to control TabPane Tab 'text' rotation?

Hello, I am getting confused with TabPane tabs and I don't know whether the following is a bug or a feature ...If you put the Tabs of a TabPane on Side.LEFT or RIGHT the text in a tab is always rotated, so if you don't want it rotated you need to put the text in a label with tab.setGraphic(), and yo ...

Oracle Export and Import using datapump with Spatial (sdo_geometry)

HiI've made an export dump using expdp from one database and i'm trying to import this dump file into another database using impdp. All tables that consist of a data type sdo_geometry fail with the following error:ORA-31693: Table data object "NAD_DAT"."NAD_FARM" failed to load/unload and is being s ...

Oracle Inserting 3D geometry into an SDO_GEOMETRY object

We would like to send 3D geometry information from our client (written in VB/C++) and create 3D SDO_GEOMETRY objects on the server side (running Oracle 10g). We are sending mapping info like points, lines, and polygons, so really the 2D aspect of our data is the most important. The Z value is there ...

Oracle How can i get a SDO_GEOMETRY for XML using sdoapi.zip?

I'm a new comer for oracle spatial, I need to convert SD_GEOMETRY to text or string in my application, I find sdo java api have methods to perform the transformation.i create a java source and a procedure which compile well.then i call the procedure to transform sdo_geometry with errors as follows:E ...

Oracle New to Spatial - need help!!! -Union in SQL not working with SDO_GEOMETRY types

When the following SQL is entered it works up until we try to merge the 17th line segment. Is there some parameter that needs to be tuned to increase the buffer size perhaps? I am really clueless. I just installed Oracle 8.1.7 and this worked in Oracle 8.1.6. Please see below:SQL>SQL> DROP TAB ...

Oracle DataBase-link + SDO_geometry causes ORA-00600 internal error code

At KMS I recently ran into touble, when attempting to fetch a somewhat large geometry accross a DataBase-link. The geometry is a linestring consisting of 1476 points (x,y,z,o). I wish to select it from a production server onto our DataWarehouse server. ORA-00600 internal error code, arguments: [rwor ...

Oracle Hibernate mapping between JGeometry & SDO_Geometry

Has anyone figured out how to create a hibernate mapping file for mapping between oracle.spatial.geometry.JGeometry and SDO_Geometry type? Haven't been able to figure out how to do it with UserTypesfor instance I'd like to create a simple class like the following: import oracle.spatial.geometry.JGeo ...

Oracle How can i get a SDO_GEOMETRY for XML using sdoapi.zip?

CREATE OR REPLACE and compile java source named SDOGEOMETRYasimport java.io.*;import oracle.sdoapi.adapter.*;import oracle.sdoapi.geom.*;import oracle.sdoapi.OraSpatialManager;public class SDOGEOMETRY {public static void exportToXML(Geometry geo){try{ GeometryAdapter xmlAdapter =OraSpatialManager.ge ...

Oracle VIEWS with SDO_GEOMETRY (ORA-22950)

I am attempting to create a VIEW that unions together two SDO_GEOMETRY columns from two tables. For example, if TABLE A and TABLE B both had SDO_GEOMETRY columns (and assume that the geometries are similar in each--i.e. all point data), the VIEW would be:CREATE VIEW A_AND_B ASSELECT GEOMETRY FROM A ...

Oracle sdo_geometry.to_string?

Is there a PLSQL function (documented or not) that converts an SDO_GEOMETRY object to a string for purposes of displaying via dbms_output.put_line and easy debugging? I think there must be one because SQL*Plus is able to format the results nicely when I select a geometry column from a table. What I' ...

Oracle SDO_GEOMETRY and SDO_GTYPE

Is it possible to have a table with a column of datatype SDO_GEOMETRY that contains multiple types of SDO_GTYPE? I would like to model a data object as any geometry type - point, linestring, polygon, etc. ...

Oracle How pass MDSYS.SDO_GEOMETRY object to Stored Procedure in VB

Please help meI need pass large poygons from Autocad to Oracle Spatial.I have a Stored Procedure to insert the polygon but I don't know how to pass MDSYS.SDO_GEOMETRY parameters through VB.The SP Code is:PROCEDURE INSERTA_ESTADO(CODIGO IN VARCHAR2,NOMBRE IN VARCHAR2, COORDENADAS IN MDSYS.SDO_GEOMETR ...

Oracle How can i return a SDO_GEOMETRY value in a Java-Stored-Function?

For a example, Ive got a java-function witch returns a oracle.sdoapi.geom.Geometry like:public static Geometry GetQPoint(String sF_TABLE_NAME, long lFID){...}And now, Ill try to deploy this function as a PL-SQL stored-function like:GET_Q_POINT(F_TABLE_NAME IN VARCHAR2, FID IN NUMBER) RETURN MDSYS. ...

Oracle IMP-00060 - "MDSYS"."SDO_GEOMETRY" does not exist

I try to import 8.1.6 Spatial tables (without index) into a 8.1.7 database. During the import for every table I get the following message: IMP-00060 Warning: Skipping table "owner"."table" because object type "MDSYS"."SDO_GEOMETRY" does not exist.Sure the object type exist! Any suggestions? ...

Oracle XDK and SDO_GEOMETRY datatype

I am working on project that suppose to retrieve data form one database, transform them and insert them into remote database. Databases are Oracle 8.1.7 with Spatial. For that reason I was thinking about using XML as suitable transport format. So I successfuly generated XML file from source geometry ...

Oracle SDO_GEOMETRY : Polyline is abble to store a data list per point ?

Context : while tracking with a GPS I receive other data such as ground roughness, ground temperature etc.My need : 1- Store in a Oracle the track and his general attribute (Caption, author, etc) as polyline.2- Store for each point of the polyline, ground roughness, ground temperature etc. The only ...

Oracle Convert varchar to sdo_geometry

I have a table of linestrings - all coordinates have precision, which I want to remove.I am trying to do it in PL/SQL as below, but since the new geometry with the rounded coordinates is a varchar, I keep getting the error: PL/SQL: ORA-00932: inconsistent datatypes: expected UDT got CHARHas anyone g ...

Linking to (oracle) SDO_GEOMETRY data type

Could someone give me some assistance/guideance with a table linking issue i have encountered.I have an Access frontend which is linked to an Oracle backend via ODBC.After making changes to the frontend i re-linked the application back to the live server using the Linked Table Manager.While testing ...