An extension that adds spatial operations to Oracle databases
2
votes
1answer
187 views
Convert non-spatial Oracle table to spatial Oracle table in a different database
I'm trying to use ogr2ogr to convert data from a non-spatial table (has X & Y values) in an Oracle database (1) to a spatial format in a different Oracle database (2). This will be scheduled to ...
0
votes
1answer
25 views
Migrating Lines to ArcGIS polyline
I'm trying to import geometry lines from Oracle Spatial database to ArcGIS enterprise geodatabase.
and some data will cause the error.
Its says not enough points for feature class, but when I look ...
2
votes
0answers
239 views
Which one is better ?SQL server 2012 or Oracle 11g
I want to learn a database server, SQL server 2012 or Oracle 11g . I surf in the internet to compare SQL server and Oracle for spatial data and found good websites such as gisboston.it was very ...
2
votes
0answers
131 views
Need Oracle spatial tutorials
I am working on Oracle spatial 11g and I am referring to Oracle docs as a learning resource.
Does anyone know any more Oracle Spatial tutorials ?
We want to integrate Oracle Spatial data with ...
2
votes
0answers
261 views
No primary key or unique index found?
I have a store created from oracle database in geoserver. Now after I create layer out of the store. And when I try to access the layer or try to preview the layer, I get the warning message in ...
1
vote
0answers
12 views
Best way to get the overlapping segment of two lines
Could anyone help me figure out the best way to get the overlapping line segment of 2 line sdo_geometry objects?
my query looks like this:
select SDO_GEOM.SDO_INTERSECTION(SHAPE, :SHAPE, 0.5) as ...
1
vote
0answers
27 views
ArcMap Oracle Query Layer Not Displaying
I am having an issue with an Oracle query layer using SDO_Geometry not displaying. I have created a polygon layer/table within oracle, registered the table with the SDO_GEOM_METADATA and created a ...
1
vote
0answers
55 views
Allocate places according to distance
I've asked this over on Stack Overflow but thought that someone may have a GI point of view that may help:
As an over-simplified example I have a list of events that have a maximum attendance:
...
1
vote
0answers
88 views
arcsde huge size file upload into Oracle spatial
I have 35million records (tomtom multinet) of file gdb file in my desktop machine. I need to upload this file into Oracle spatial as SDO_geometry file.
I already tested the connection with small ...
0
votes
0answers
74 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
78 views
Comparing SDO_GEOMETRY to ST_GEOMETRY in reference to measuring distance within features
Does anyone know how the SDO_WITHIN_DISTANCE works with featureclasses that are unprojected i.e. just Geographic WGS 84 systems. As I don't see how the km/miles units can work unless it does an on ...
0
votes
0answers
137 views
spatial query vb.net geomedia
I am trying to develop spatial query for selecting features within a polygon/ rectangle. Iam using vb.net for coding, geomedia for GIS and oracle spatial database.
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 ...
0
votes
0answers
637 views
Oracle Spatial connection : gdalplugins 1.8 and Quantum GIS
I am wondering what's going on behind the scenes in the gdalplugins for Oracle Spatial:
gdal_GEOR.dll and ogr_OCI.dll.
I assume MDSYS.ALL_SDO_GEOM_METADATA and MDSYS.ALL_SDO_INDEX_INFO are read ?
...
