A commercial relational database management system.

learn more… | top users | synonyms

0
votes
0answers
17 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 ...
2
votes
0answers
17 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 ...
2
votes
1answer
39 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 ...
1
vote
3answers
175 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 ...
-1
votes
0answers
13 views

How to update maps in oracle map viewer?

There was a table(Population) in oracle, with sdo_geometry column(Geometry). It was shown once in Oracle Map viewer. I made some changes to the table , now the problem is that the last map shown in ...
2
votes
1answer
24 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 ...
0
votes
1answer
23 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*", ...
0
votes
0answers
24 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
0answers
22 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
24 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, ...
1
vote
1answer
27 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 ...
0
votes
1answer
29 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 ...
0
votes
1answer
17 views

web map service - does it update by default when data is amended in Oracle source tables?

I have a WMS which source data is held in Oracle. Every year an amendment to the view in Oracle is run to update records. Does the web map service need to be re-published once these amendments are ...
0
votes
1answer
42 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 ...
0
votes
1answer
28 views

how to see a base map created by map builder in database?

I am new in oracle, I tried to create a style, then different themes and then a base map. I saved all my work, but I can't see the base map in the database. Did I miss something? The interesting ...
0
votes
0answers
14 views

applyEdits method and File on arcgis feature service

I would like to know if it's possible to upload a file through the applyEdits method on a feature service? I have an Oracle database with a parameter "DOCUMENT" of type BLOB. I would like to upload ...
1
vote
1answer
39 views

Error ORA-00920: invalid relational operator

I am running this SQL in Oracle Spatial in postgis worked. In the Oracle error [Err] ORA-00920: invalid relational operator I need to select all geometries that touch on my streets layer, ie the ...
0
votes
0answers
36 views

QGIS 2.2 - Oracle Spatial Layer - Offline editing - Not synchronizing

I am sarting with QGIS 2.2.0 (windows, 64b). For my project I imported some layers Oracle Spatial layers (Layer>add Oracle Spatial Layer). Then I convert the project offline as I can't always be ...
0
votes
1answer
43 views

QGis and Geomedia via Oracle

When I use both QGis and Geomedia to digitize in the same layer I get some issues in my Oracle table. It looks like Geomedia save my point, lines and polygons as ARRAY, while QGis save it like POINT ...
0
votes
2answers
67 views

Add Oracle spatial view Layer

Is it possible to add an Oracle Spatial View on QGIS MAP? My view is registered on MDSYS metadata but, when I connect with Oracle DB, it is dissabled on the list. QGIS Desktop 2.2.0 Oracle Database ...
1
vote
0answers
52 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
1answer
41 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 ...
1
vote
1answer
137 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 ...
0
votes
1answer
43 views

registering or unregistering as versioned a future dataset with python

As you know, you can store feature classes in arcsde in two ways. Firts, in the root path: sde_conn_file.sde/FeatureClass Second, in a dataset: sde_conn_file.sde/DataSet/FeatureClass How can I ...
4
votes
2answers
182 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 ...
0
votes
1answer
61 views

Cannot display Oracle raster images using QGis

I am dealing with QGIS 2.2 and the plug-in Oracle spatial georaster. Apparently the connection to the database can be made, as the raster images are listed once you press 'Connect', but when try to ...
1
vote
2answers
136 views

QGIS Installation - Oracle Link

Trying to connect an oracle 10g database to QGIS. I'm getting the error below: ORA - 12154: TNS:Could not resolve the connect identifier specified Anybody ever seen this error, or could provide some ...
0
votes
1answer
65 views

How to get a kml from stored in a blob file of oracle with arcpy

How to get a kml from stored in a blob file of oracle with arcpy? i try get data or kml files contains in a database oracle in a field of a table, using cursos options of arcpy. import arcpy, os ...
1
vote
0answers
59 views

arcgis 10.2 spatial stored procedure in oracle throws pls-00707 compilation error

Package def: create or replace PACKAGE POSEIDON_PACK AS procedure tester; END POSEIDON_PACK; Body: create or replace PACKAGE BODY POSEIDON_PACK AS procedure tester as d number; begin ...
0
votes
0answers
57 views

QGIS browser connect to Oracle DB, while QGIS GUI doesn't … why?

I installed QGIS 2.0.1 on my Windows 7 platform. Using QGIS browser I successfully connect to an Oracle DB specifying into the connection dialog box the following information HOST = the machine IP ...
0
votes
2answers
131 views

MapInfo MI_STYLE Column Definition

I have been looking for some documentation or post which tells me what the column definition for a MapInfo MI_STYLE column should be in Oracle. My guess is that it's VARCHAR2(128) or something like ...
3
votes
0answers
137 views

Geodatabase Connection to Oracle Active Data Guard Standby

Thank you in advance for any help you can provide. ENVIRONMENT Database Server: Oracle 11.2.0.2.0 Single-Instance Database on Windows Server 2003 R2 Enterprise 64-bit Oracle Active Data Guard for ...
2
votes
1answer
148 views

Transferring data between spatial databases

I would like transfer spatial data from PostGIS to Oracle Spatial. I want to use Python's modules psycopg2 and cx_oracle. Transfer Oracle > PostGIS is OK, but in opposite version I have problem with a ...
0
votes
1answer
162 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. ...
0
votes
2answers
144 views

Exporting data from Oracle to Esri File Geodatabase grid size error

My specs: ArcInfo 10.1, Oracle 11g I have a line dataset which is sat in Oracle 11g. I can read/query/symbolise this in ArcDesktop without any problems. I now want to export a selection into a file ...
0
votes
1answer
100 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
0answers
32 views

Multiple Cursors

Below is the sql statement which I have explained below. Declare Cursor c1 is select store_number ,0 as total_area,0 as BG_ID ,0 as store_geom from table1 where CLIENT_ID= 1 and ORG_ID ...
0
votes
0answers
29 views

SQL cursor issue

I am trying to create a new table using a cursor and a select statements. Declare Cursor c1 is select store_number from table1 where CLIENT_ID= 1 and ORG_ID = 1 ; Type C1_TAB_TYPE ...
2
votes
1answer
190 views

Installing ArcGIS 10.1 on Win7 64 bit

Just reformatted my PC with Win7 64bit to try and take advantage of 64-bit python processing. However I'm not sure what to do here: Our office runs ArcGIS 10.1, TOAD and SDE for Oracle. Toad ...
1
vote
0answers
45 views

Is there a way to prevent losing metadata when generating a spatial view in ArcSDE 10.1?

When generating a spatial view in ArcSDE using a script, any previous metadata is dropped when the old view is dropped. Thus, any edits to metadata on the view, are lost. Is there a way to keep the ...
0
votes
0answers
21 views

Multiple cursors in sql for SDO_DIFFERNCE

This is a follow up to a previous question I had regarding sdo_difference. Now in this case I am trying to use cursors so that I can do it for all records at once.In the below code I select a list ...
0
votes
2answers
145 views

st_multi equivalent in Oracle spatial / how to convert polygon to multipolygon?

is there an equivalent to the PostGIS ST_MULTI available in Oracle Spatial? or - How can I convert POLYGON to MULTIPOLYGON in Oracle spatial? Regards, D
0
votes
1answer
52 views

Connect between Oracle 64 bit 11g and Arcgis10.1

How can I Connect between Oracle 64 bit 11g and Arcgis10.1 ? Thanks
0
votes
0answers
34 views

NextBuffer operation takes a long time when there are no rows in a table

We're trying to get data from a table which contains no rows. The query runs fast, but the SDE gets stuck on NextBuffer command. Some code that we're using: IQueryName2 queryName2 = (IQueryName2)new ...
4
votes
1answer
102 views

Should slow refresh rate be expected while viewing 1000 points out of 100 million using ArcSDE/Oracle?

Is it normal to experience very slow refresh rate in ArcMap with 1000 points shown out of 100 million using ArcSDE/Oracle? I’am testing a setup with ArcSDE/Oracle database to contain geographical ...
2
votes
1answer
206 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 ...
0
votes
0answers
50 views

How to get Geodatabase into Oracle database/ Tables

Simple question possibly. But how can I import a Geodatabase into a oracle database. I like to put data into tables but just wondering what is the best way or tools to use? Will it be through FME ...
0
votes
0answers
20 views

Oracle spatial routing engine on Jboss

Is it possible to run Oracle Spatial Routing Engine 11g on JBoss AS7?
1
vote
1answer
124 views

How to export and import ST_GEOMETRY from Oracle environment to another Oracle environment?

I have a geographic layer stored in an Oracle Geodatabase with ST_GEOMETRY type. I'd like to export that layer and its data into a SQL INSERT format in order to import it into another Oracle ...
2
votes
3answers
194 views

Fastest way to join points table to polygons tables in ORACLE

I have two tables in 11g oracle db, one with points geometry, one with polygons. Currently I need to enrich the points table daily with the name of the polygon (country) that the point is inside, but ...