An extension that adds spatial operations to Oracle databases
1
vote
0answers
10 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 ...
2
votes
0answers
206 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 ...
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
72 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 ...
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:
...
2
votes
0answers
127 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 ...
4
votes
1answer
65 views
Does Oracle MapViewer support PostGIS?
I use Oracle MapViewer to generate my mapping data and currently I'm using an Oracle database as my spatial back-end. I would like to move my data over the PostGIS but I can't find any references if ...
3
votes
2answers
119 views
Get Spatial Table Information Oracle Spatial
How can I get the tablename, Srid and GeometryType of all spatial tables in Oracle(I use 11g)?
In postgis, I can do something like
select f_table_name,srid,type from public.geometry_columns order by ...
2
votes
1answer
182 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 ...
2
votes
1answer
32 views
Can I use a join in Mapviewer
I've got two tables, parcels and permits. I'd like to display permits on a map without having to copy the geometry data from parcels. Is there a way to create a join in Mapviewer? Do I have to ...
4
votes
1answer
167 views
How to get minx, miny, maxx and maxy of a geometry?
I'm new to Oracle Spatial.
In MySQL or PostGIS, it's easy to get minx miny maxx maxy of a geometry, any and/or all of them. But how to do that in Oracle Spatial?
Do I need to chain up several ...
3
votes
3answers
212 views
Shapefile import with Oracle + GeoServer produces points instead of vector shapes
I have implemented the example at http://www.gistutor.com/openlayers/22-advanced-openlayers-tutorials/47-openlayers-wfs-t-using-a-geoserver-hosted-postgis-layer.html and got it working properly.
Now ...
1
vote
2answers
480 views
Querying intersecting areas areas - Oracle Locator or Spatial?
My spatial database is Oracle. We are wondering if we can use basic Oracle Locator or need to get the more expensive, full, Oracle Spatial.
My application's requirements include having to be able to ...
3
votes
2answers
164 views
How can I extract data from Oracle Spatial and preserve the spatial data?
My table currently contains an SDO column that I want to export (along with the rest of the data) but all I have at my disposal is PL SQL Developer -- Is there anything I can do to get at that data ...
2
votes
2answers
341 views
Is ArcMap 10.0 Query Layer passing invalid SQL to Oracle 11gR2?
In two different environments I'm having trouble using ArcMap 10.0 Query Layers to view SDO_GEOMETRY (point) data in Oracle 11.2. This suggests I'm doing something wrong...
Points are in Oracle ...
0
votes
0answers
135 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 ...
7
votes
4answers
2k views
What is the difference between geocoding and georeferencing?
After some googling around both seem to be interchangable words, where we speak of tying the spatial info of a real place and storing in database.
But still I am not satisfied, there should be some ...
0
votes
0answers
636 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 ?
...
2
votes
1answer
342 views
Making calls the PostGIS functions with Java
We have Java stored procedure in Oracle that make calls to functions offered by Oracle Spatial to perform spatial analysis and return results. I am looking to the same in PostGIS, is this possible?
2
votes
1answer
334 views
Publishing oracle spatial table in geoserver
I published oracle view in geoserver. using this link. But when I see this in layer preview I get following xml response:
<?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE ...
3
votes
1answer
277 views
Joining spatial and not spatial table in oracle
I have spatial table with rows of data representing polygon(A). I have another table that contains values for polygon field(B). Now I would like to join these two table and create a spatial table. I ...
1
vote
1answer
257 views
Oracle MapViewer / Map Builder - Tile algorithm
Oracle MapBuilder generates three types of layers - theme, base and tiles.
I try to create algorithm for tiled layers. Have you any idea how to decode this?
I mean algorithm for width and height of ...
2
votes
1answer
294 views
How to move an Oracle spatial table to another db?
I have uploaded a polyline data (50 million rows) to oracle spatial 10g as sdo_geometry through arccatalog and arcsde in my TEST database.
Now, I need to move this table to QA database, this table ...
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 ...
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 ...
2
votes
2answers
1k views
How to convert geometry coordinates into Google lat/lons?
For storing geospatial data, the geometry field is used in SQL Server or Oracle Spatial. I want to know is there any way where we can convert this geometry field into a set of latitudes and ...
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
1answer
173 views
Open Source Challenge: Automated Mastermap update in Oracle Spatial
I've been set a challenge which is a bit out of my comfort zone. I'm an esri developer trying to break into the open source world.
I've been asked to automate the update of some oracle SDO datasets. ...
4
votes
1answer
192 views
Error in passing geometry column to SQL query
When I execute the following query with a static table name it's working fine:
SELECT pe.structure_category_name,SDO_NN_DISTANCE(2),pe.bt_object_subid,
pe.bt_owning_node_id INTO ...
18
votes
3answers
1k views
When should you NOT use a spatial index?
I am asking this because I was mainly working with Oracle but for the past year I've been doubling with PostGIS and SQLServer 2008. Most spatial functions in Oracle won't work without a spatial index ...
12
votes
3answers
888 views
Future of spatial databases
It may be a bit off-topic. I am eager to know the industry specific importance of Spatial Databases.
Is Spatial Database a very important part of any GIS system? Or will we use other technologies to ...
8
votes
7answers
3k views
Register SDE view and Layer
I'm building simple views against an ArcSDE Oracle RAC 10g. My SHAPE columns are of SDO_GEOMETRY datatype. ArcSDE 9.3.1.
I have several point tables, with the following outline:
ID (Guid)
Name ...
4
votes
1answer
440 views
Oracle Spatial - How to calculate the point of intersection of 2 line geometries
How to calculate the point of intersection of 2 line geometries.
3
votes
2answers
292 views
Oracle Linestrings and MultiLinestrings
We have a very complicated setup for a project we are doing, and it involves 40+ developers and two oracle databases, one with sde and one only with oracle spatial and it's quite big.
We'll here are ...
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 ...
4
votes
1answer
752 views
In Oracle Spatial, what is the fastest way to determine the percentage of intersection between two shapes?
I have to query polygons that intersect with one another. Our polygons occasionally contain intersections that aren't intended (meaning just a few vertices cross boundaries). I want to filter out ...
