Tagged Questions

0
votes
0answers
61 views

java.sql.SQLException: ORA-13226: interface not supported without a spatial index

I have created a spatial index on the column name and yet, I get an java.sql.SQLException: ORA-13226: interface not supported without a spatial index ORA-06512: at "MDSYS.MD", line 1723 ...
0
votes
0answers
168 views

STRUCT object instantiated by GeoTools geometry converter breaks SQL prepared statement on Oracle 11G

Oracle 10.2.0.5.0 and 11.2.0.3.0 (the former works, the latter does not) Java runtime 1.6.0_32 GlassFish 3.1.2 (running on Windows 7 desktop) GeoTools 2.7.5 and 8.0 RC2 (makes no difference to the ...
1
vote
1answer
354 views

Oracle spatial - check polygon vertices counter clockwise

I need to import a huge number of polygons from a third party (as a csv file- array of x,y's). I have to check whether the polygon vertices are in clockwise or counter clockwise, finally i have to ...
3
votes
2answers
344 views

Is there a common interface for ST_Geometry SDO_Geomtry

I've worked a fair bit with Oracle Spatial and I've had some requests to transition to PostgreSQL Spatial. Is there a common interface for SDO_Geometry and ST_Geometry? I'm working in Java with ...