A commercial relational database management system.

learn more… | top users | synonyms

0
votes
1answer
113 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
74 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
23 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
233 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
114 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
86 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 ...
1
vote
0answers
306 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
100 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
1answer
124 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
598 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
88 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
276 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
90 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 ...
0
votes
2answers
312 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 ...
2
votes
0answers
218 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
250 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
2answers
299 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
343 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
216 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
38 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 ...
2
votes
1answer
338 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
56 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
2answers
266 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
82 views

Connect between Oracle 64 bit 11g and Arcgis10.1

How can I Connect between Oracle 64 bit 11g and Arcgis10.1 ? Thanks
4
votes
1answer
148 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
2answers
391 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 ...
1
vote
1answer
242 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 ...
3
votes
1answer
1k views

Build a website to track GPS signals [closed]

I need to build a solution that allows me to track cellphones/tablets and display on a visual map. I think there are two parts, one is understanding the general architecture. The other is more ...
3
votes
1answer
2k views

ArcGIS for Server 10.1, Registering a database data store fails with Underlying DBMS error

When I registered a database data store to ArcGIS Server in ArcCatalog, the following error occurs: The connection property set was missing a required property or the property value was ...
0
votes
0answers
828 views

Arcgis desktop connection to oracle

I am trying to create a database connection from ArcGIS desktop 10.1 to SDE Geodatabase on Oracle server with direct connection using Oracle easy connect syntax So, from ArcCatalog I use "Add database ...
1
vote
3answers
298 views

Differences between SQL dialects in QGIS vs ArcView vs Oracle

I'm kinda new with SQL queries and there is something I don't get: A SQL query in QGIS is written differently than the same query in ArcView and will probably also be written differently if I want to ...
3
votes
1answer
1k views

How to correctly set up Oracle connection parameters?

Just testing out the new QGIS2 install here and trying to connect it to our huge SDE/Oracle spatial database. Im struggling with the connection parameters. Here is the connection properties to the ...
1
vote
1answer
388 views

Arcsde and Oracle on same machine but while creating a Enterprise Geodatabase giving TNS Error

I have Installed Arcgis Desktop 10.2 and Oracle 11G and Arcsde 10.2 and oracle Client When I am Creating a Enterprise Geodatabase it is giving me this error: ORA-12154: TNS:could not resolve the ...
2
votes
2answers
235 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 ...
0
votes
1answer
447 views

Test of ORACLE DB functions converting lat-long to utm and mgrs with real data known to be correct?

I have rewritten some Delphi function to ORACLE DB functions for converting from lat-long to utm and mgrs. Anyone care to validate the output with real data they know is correct? package ...
3
votes
2answers
425 views

Can QGIS use a non-spatial Oracle Database?

I'm building my first plugin in qgis, that needs to read some coordinates from an oracle database (not oracle spatial database) and create a shapefile with this points. I'm searching but only find to ...
1
vote
1answer
113 views

Error occured during Geodatabase compressing

When I am doing geodatabase administration in ArcSDE on an Oracle Database, the following error pops up when I run the compress tool ORA-00604: error occurred at recursive SQL level 1 ORA-01000: ...
3
votes
2answers
78 views

arcgis desktop selection layer

I have Desktop 10.1 that is accessing data from sde geodatabase. I select some features on the map, and try to do "Create layer from selected feature" but nothing happen, and no error message. the ...
2
votes
2answers
628 views

finding the correct transformation (from EPSG:31300 to EPSG:4326) or how to store two srid in one table

I have a very specific problem. I have data crossing two coordinate-systems, more specifically: the Netherlands and Belgium. Previously the data was stored in one table in Oracle, using the RD ...
3
votes
1answer
2k views

Oracle spatial SDO_RELATE: why better performance result from UNION ALL/INTERSECT combined individual specified mask

Initially I was trying to find out why it's so slow to do a spatial query with multiple SDO_REALTE in a single SELECT statement like this one: SELECT * FROM geom_table a WHERE ...
4
votes
1answer
3k views

ArcSDE 10.2: How to enable and create Geodatabase in Oracle without ArcGIS Desktop

Since there is no Post Installation Wizard anymore in ArcSDE 10.2 - how can i enable und create a geodatabase in oracle without ArcGIS Desktop? We have only an EDN description for ArcGIS Server/SDE, ...
0
votes
1answer
298 views

ArcGIS - Help Using Oracle Function in Definition Query - No ArcSDE

I have set up a Query Layer pointing at an Oracle table with a SDO.Geometry column, and that is working and behaving fine. However, when I am attempting to set up a definition query that calls a ...
0
votes
1answer
108 views

How to Avoid Object ID conflicts in Versioned geodatabase

We have just implemented a versioned Geodatabase and our schema has few feature classes and relationship classes. We do not Reconcile and Post to the parent ( Default) version, as we need some ...
0
votes
1answer
171 views

Spatial query without spatial database module?

I have the following scenario: Oracle database without the spatial module. Application in J2EE with the following architecture: -- Entity -- Persistence (DAO / JPA + JDBC) -- Business (BC) -- Vision ...
1
vote
1answer
38 views

Where is DatabaseSupport directory in the ArcGIS client?

May I know where is this folder stated in the guide? DatabaseSupport directory in the ArcGIS client installation location and move it to a location on the Oracle server. ...
0
votes
3answers
313 views

For a SDE FeatureClasses list all Roles that have been Granted any Privileges on it, and which Privileges each Role have on it

I have searched through the ArcObjects 10 SDK API and googled, but havnt been able to find what I am looking for, so thats the reason for me posting this question. Q: How can I for a SDE ...
1
vote
1answer
209 views

SDE FeatureClass Granting and Revoking Privilege with ArcObjects

Q: How can I with ArcObjects GRANT or REVOKE Privileges like SELECT, UPDATE on SDE FeatureClasses to/from Roles? The equivalent in normal Oracle would be something like this: GRANT SELECT ON ...
0
votes
0answers
53 views

Geometry type invalid occurs while trying to view data from oracle to arcmap connection

I have been trying to connect oracle databse in to arcmap 10.1. It got connected but while trying to add feature type ( route network file) to the map it says "Coodinate system identifier is invalid". ...
2
votes
0answers
36 views

My view in Oracle when displayed in ArcMap/ArcCatalog values are being dropped to 0

I created a view in an Oracle Database in order to match formatting of a new database/table I am going to be migrating the data to. The problem is when I look at my view in Oracle I see the correct ...
1
vote
0answers
174 views

MapInfo/PlanWeb and Oracle to ArcGIS/GeoCortex Essentials and Oracle [closed]

As an organisation we currently use MapInfo desktop GIS (120 users) and PlanWeb intranet GIS (about 1000 users), both products of Pitney Bowes. We have about 15 core desktop GIS users who edit spatial ...