A commercial relational database management system.

learn more… | top users | synonyms

0
votes
1answer
111 views

Importing recent NAVTEQ/HERE RDF Data into Postgres/Postgis

I am trying to import a recent version of navteq data into a postgres DBMS. I have downloaded the 2014Q2 version of the data from https://here.flexnetoperations.com as well as ...
3
votes
2answers
538 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
121 views

How do you determine which dbclient connection property to use for an Oracle SQLWorkspace connection?

I have an Oracle11g database that I connect to via a SQL Workspace; however the actual dbclient string value that works differs depending on machine (and I'm guessing oracle client configuration). On ...
0
votes
1answer
94 views

QGIS and Oracle Spatial database - rule based system in future version?

I (a geographer not to familiar with IT stuff) want to start a pilot with QGIS at a municipality I work for. We store our data in Oracle databases. When trying to open these databases (QGIS 2.2) using ...
3
votes
1answer
231 views

How to clip a Oracle query layer directly in a Python script?

I have a query layer directly running from ORACLE database in a MXD. I want to clip this layer with a layer being created in another MXD in a Python based tool. My question is to do this clip ...
1
vote
1answer
50 views

Bulk insert with Python and cx_Oracle into st_geometry enabled table

I'm trying to make a bulk insert of a CSV file with Python and cx_Oracle into an st_geometry enabled table of an Oracle database with ArcSDE. I could do it with the method execute() of cx_Oracle but ...
0
votes
2answers
245 views

How to plot lat/long stored as text in Oracle DB using report builder/SSRS r2

We use an Oracle 10g database. However we write reports using SSRS or report builder, using the Oracle connection type to the datbase. In oracle we have 2 text fields, one for lat and one for long. ...
1
vote
1answer
31 views

Associating 9.3 geodatabase domains to a SDE feature class' field in ArcCatalog 10.1 fails

I have succesfully created Domains into a 9.3 geodatabase based on Oracle (SDE) by using ArcCatalog (ArcGIS 10.1). Proof: If I open the table GDB_DOMAINS in Oracle the new domains are listed. ...
1
vote
1answer
28 views

Best way to store raster data with Java into Oracle spatial

I have a Java application that processes raster data. At the end of the process I plan to store the raster in oracle spatial. What is the best way to do this? I had a look at geotools but I did not ...
4
votes
2answers
408 views

Failed to connect to the specified server, ArcGIS 10.1 connection using Oracle 11 g

I am trying to connect an Oracle 11g database to ArcGIS 10, but it's not working and gives the following error: "Failed to connect to the specified server. Operation Failed." While I am sure about ...
5
votes
3answers
290 views

Updates to ArcSDE via Oracle trigger

Is it possible and/or feasible for an Oracle trigger to periodically update ArcSDE via a REST geoprocessing service? Does anyone have any experience with such a thing? The reason for this is that I ...
0
votes
1answer
168 views

Creating a layer in arcmap by dragging a table from an OracleDB

I am working on a project for a client, they gave us some data from their oracleDB, and when I connect to it in arc map I can just drag and drop the tables from the catalog window into arcmap and they ...
2
votes
2answers
201 views

Call ArcGIS Repair Geometry Function from Oracle 11.2

Could anyone please point me to the right direction on how to call an ArcGIS Function (i.e. Repair Geometry) from PL/SQL? All information I found so far concerns the other way round. This is needed ...
2
votes
0answers
11 views

Is it possible to add an ArcGIS attachment to a row in Oracle/SDE using oracle stored procedures?

So far I have been able to attach files to features within a featureclass using the python tools and ArcObjects. Within Oracle I have been able to add features with geometries using the ST_Geometry ...
0
votes
0answers
23 views

Delete user on ArcGIS server against Oracle backend

I have a problem, when we delete users, using the following command: drop user sdedata cascade; We get the this error: ORA-00604: error occurred at recursive sql level 1 ORA-21700: object ...
2
votes
1answer
66 views

Reordering Tables in ArcMap Layer List?

I'm trying to reorder the TABLES in my ArcMap layer list. I can't find a way to do it. I can reorder normal layers since they appear in the "List by Drawing Order" tab of the "Table of Contents". ...
1
vote
0answers
24 views

Migrate MS Access Data into Oracle DB

I was sent some old MS Access files that contained survey data and served as a "file geodatabase". I want to import these to my Oracle Database with it maintaining "geometric" sense and meaning. I ...
0
votes
0answers
28 views

Table To Table on Oracle table to File Geodatabase fails?

I recently upgraded to 10.2.2 and have found that some python scripts I used with table to table command no longer work. I am copying tables from an Oracle database to a file based geodatabase. ...
2
votes
2answers
312 views

How to get a list of features from Oracle via FME?

I have a table in Oracle containing only the names of other tables of varying feature types, which I'd like to process (i.e.export to csv). this task is to be scheduled via FME Server. the feature ...
4
votes
1answer
602 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
67 views

where is the sequence in Oracle associated with the Objectid field in ArcGIS, and how to manage it?

I am working in ArcGIS 10.1 with non-spatial Oracle tables. These tables have a field named 'objectid' because were created originally for inserting/updating records by using ArcGIS instead, not ...
1
vote
0answers
24 views

Geoserver Image Mosaic Plugin - Index Table - ORACLE

On my current project we are using a Geoserver ImageMosaic to display aerial photography for England. We are also working to enable the TIME attribute on the layer so that we can display historic ...
0
votes
0answers
45 views

Storing 3D Oracle sdo_geometry objects with a 2D SRID

I'm trying to understand the implications of storing 3-dimensional sdo_geometry values in Oracle when the geometry's SRID is a 2-dimensional system. The database I'm studying uses SRID 4326 (WGS84 ...
1
vote
4answers
885 views

finding the definition of missing srid in postgis

I am converting a spatial Oracle database to POSTGIS, and one of the problems I encounter is that we use SRID in Oracle that do not exist in POSTGIS. I am talking about the following SRID: 90112 : ...
0
votes
1answer
24 views

MapServer - Not Rendering All Features With Complex DATA statement

I have run into a little problem when using MapServer to render complex data statements. To keep this post short and simple, I think the output of shp2img is the best place to start. When I use ...
1
vote
1answer
92 views

How to create a shapefile or gml from a Oracle database using SDE.ST_Geometry?

I have a ORACLE database 10g(Oracle Database 10g Enterprise Edition Release 10.2.0.3.0) with a SDE.ST_Geometry field and i want to make a program in python so i can create several shapefiles based on ...
1
vote
1answer
23 views

Syntax to view permissions on Oracle table

I want to be able to see what permissions have been granted on a specific object in my Oracle geodatabase. What would my script look like? Thank you.
3
votes
2answers
272 views

How to connect QGIS to an Oracle DB (SDE)?

I want to access an Oracle Database (with SDE) from Qgis 2.4. I have tried many different options from within the window Create a new Oracle Connection but I always get an error message (ORA-12514: ...
3
votes
1answer
481 views

ORA-28595: Extproc agent : Invalid DLL Path

I'm trying to create a table with spatial column in oracle and insert data into it. I'm using ArcSDE and Oracle. The version of Oracle is 11.2.0, the version of ArcSDE is 10.0. My create statement ...
0
votes
0answers
78 views

Error selecting geometry from Oracle DB

I'm trying to select a geometry column as well-known text from a feature class in an Oracle 11g/ArcSDE 10.1 geodatabase. (This is in a Python script using pypyodbc as a driver). This is my SQL: ...
0
votes
1answer
46 views

Error configuring Oracle datastore in GeoServer

I want to configure an Oracle datastore in Geoserver so I copied gt2-oracle-spatial-2.3.1.jar and ojdbc14.jar into GeoServer webapp (in WEB-IF/lib folder); then I restarted and try to create new data ...
2
votes
1answer
56 views

Using REPLACE function in ArcGIS Server Query - Is it supported?

I'm working on a Flex application for a client that will be the replacement for a legacy application they have that was written in .net/adf. In their current code base, they are using an ADF query ...
1
vote
1answer
88 views

Can't select geometry from Oracle DB using SQL

I'm trying to select the geometry field from an ArcSDE feature class in an Oracle 11g database (inside of a Python script via PyODBC). This is my query: SELECT SHAPE FROM USR.FEAT_CLASS This is ...
1
vote
0answers
41 views

Using IRelationalOperator ArcObjects interface with feature classes stored in Oracle?

Could you give an example how you’d use the IRelationalOperator ArcObjects interface with features from different feature classes stored in oracle database? In my visual studio project I have an xml ...
2
votes
1answer
33 views

Incomplete Data - Missing line segments from Oracle data

I have setup GeoServer 2.5.2 on Windows. Everything was going smoothly until I actually had to display my geometry data from an Oracle Database Table. Some lines are rendered but some are not ...
1
vote
2answers
76 views

Query to find all lines connected to other

I have problem with one spatial (Oracle) query. Simplified overview of the problem is: I have two tables: CREATE TABLE thin_lines ( id NUMBER PRIMARY KEY, geom SDO_GEOMETRY), color ...
0
votes
1answer
77 views

geoserver fails to start with jdbcconfig community module

I have installed the geoserver JDBC config community module, but now geoserver fails to start. I have set the properties to connect to an oracle database like this: #Default GeoServer JDBC config ...
3
votes
2answers
129 views

Importing Feature Class to Oracle SDE Geodatabase Simplifies Features

I recently imported a feature class from a File Geodatabase to an Oracle SDE Geodatabase. The features of the two feature classes now look drastically different despite not having any edits made. ...
0
votes
1answer
46 views

GeoPortal - A database Reference has not been configured for connection Tag

I've followed the instructions on setting up to a tee. I am using Oracle as a database. My database structure has been setup. I receive the following error message when I try to search for anything: ...
1
vote
1answer
341 views

How to merge/union non contiguous polygons using Oracle Spatial functions

Is there any way of merging non contiguous polygons using the SDO_AGGR_UNION or a similar dissolve function? When i run the below query in oracle sql developer i managed to convert geometry type from ...
2
votes
1answer
65 views

How to clear spatial reference identifier?

I created a table in oracle with a sde.st_geometry column. I followed the instructions of ArcGIS help to register the table into geodatabase. My table creation statement is: create table ...
0
votes
0answers
30 views

Web Editing Versioned Enterprise GDB

I would like to implement a web editing environment where edits are posted to a version of a database (delta tables) not too default. The idea behind this is so that any edits made through a web app ...
1
vote
3answers
223 views

How Oracle is related with GIS (Professional wise)

I am GIS B.Tech Graduate. In the aiming of becoming GIS Developer .I temporairly changed my profession from GIS Analyst to Software Engineer. But what I got in this software company is oracle (not ...
0
votes
1answer
50 views

How to read Oracle data with PyQGIS? (“identifier is not long” error)

Do you have any idea how load Oracle spatial data to QGIS with using the PyQGIS? Is it possible? I try: uri = QgsDataSourceURI() uri.setConnection("*host*", "1521", "*database*", "*username*", ...
2
votes
1answer
68 views

Does ST_GEOMETRY support Linear Referencing

I am wondering if the ArcGIS ST_GEOMETRY provides Linear Referencing functions, such as creating a point based on a given measurement, like Oracle Spatial. I couldn't find any function like that in ...
1
vote
0answers
198 views

How to use the same client for Oracle 8 and Oracle 11g?

I have a legacy system into Oracle 8, and spatial database in Oracle 11g. When I installed the Instant Client for Oracle Spatial access to Oracle 8 did not work. My question is how can I do to be able ...
0
votes
0answers
28 views

Formula to know if LINE intersects with MBR

I have a table with four columns: SRC_X, SRC_Y, DST_X, DST_Y. (SRC_X,SRCY) have position of the start point of a LINE, (DST_X, DST_Y) have position of the end POINT of a LINE. I know there are ...
0
votes
1answer
71 views

Creating an OVF file for connecting Oracle and QGIS

I'm trying to create an OGR file that can be opened in QGIS that pulls in vector data from an Oracle Database. I've tried a few combinations of things but can't seem to get anything to work. I've few ...
0
votes
0answers
45 views

Qgis Server, show Oracle Georaster dynamically

I have an Oracle Spatial database and I use rasters (SDO_GEORASTER). I can render some rasters on a web page with Qgis Server : when I render the maps on the webpage, it come from a qgis project ...
2
votes
0answers
93 views

How to insert a large feature using C# and ST_GEOMETRY in Oracle

I am using the st_polyfromtext command to insert features into an Oracle database like this: INSERT INTO polygon_test VALUES ( sde.st_polyfromtext ('polygon ((10.01 20.03, 10.52 40.11, 30.29 41.56, ...