An extension that adds spatial operations to Oracle databases

learn more… | top users | synonyms

3
votes
1answer
626 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
194 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
693 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 ...
3
votes
2answers
613 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
39 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
1k 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
575 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
2k 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 ...
5
votes
2answers
712 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
925 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 ...
10
votes
4answers
7k 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 ...
3
votes
1answer
511 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
888 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 ...
4
votes
1answer
685 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
435 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
799 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 ...
2
votes
1answer
143 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 ...
2
votes
1answer
684 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
3answers
3k 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
406 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
215 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
260 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 ...
20
votes
3answers
2k 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 ...
10
votes
3answers
2k 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 ...
9
votes
7answers
6k 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 ...
5
votes
1answer
661 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
501 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
464 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
1k 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 ...