A commercial relational database management system.

learn more… | top users | synonyms

1
vote
1answer
290 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 ...
1
vote
0answers
983 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
318 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
2k 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
489 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
269 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
540 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
488 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
132 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
80 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
750 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
3k 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
4k 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
332 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
133 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
201 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
39 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
356 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
231 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
54 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
203 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 ...
1
vote
0answers
120 views

Oracle spatial. Cannot load data

Have just installed QGIS 1.9 with Oracle spatial abilities. We maintain geodata in an Oracle 9.2. spatial database. I get connected to the database but I can not load the data. The table shows up ...
3
votes
0answers
157 views

Does QGIS Server support QGIS project with Oracle layers?

QGIS recently got native Oracle support. I was wondering if QGIS Server supports generating WMS and WFS from a QGIS project with Oracle Spatial layers. I just tested this but I did not succeed...
1
vote
0answers
228 views

Oracle Spatial support QGIS 1.9-0-Master (Ubuntu)

I just installed QGIS 1.9.0-Master (Build 480) on a Ubuntu virtual machine. I am running/compiled against GDAL/OGR 1.9.2. My question is why I cannot add Oracle Spatial Layers as I am able to do ...
3
votes
1answer
296 views

How can I validate a table name on SDE with Oracle backend?

Second title: "Is arcpy.ValidateTableName broken on Oracle?" I have an Oracle SDE database 9.3.1 (service connection). My arcGIS client tools are version 10.0 SP5). I have some names of feature ...
3
votes
4answers
1k views

converting oracle geometry to postgis with 3d data (wkt?)

I am converting Oracle spatial database to postgis. Most of of the spatial data is 2.5d. Meaning we have a Z-coordinate which indicates the depth/height of the element compared to soil level. Getting ...
1
vote
4answers
1k 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 : ...
4
votes
2answers
348 views

Huge x,y,z dataset into oracle, possible?

I have 200 .xyz files containing 1500000 points each. Is this possible to import this dataset to oracle? It makes a total of 300.000.000 points!!! Background is I want to improve a FME script that ...
2
votes
1answer
166 views

Strange ArcSDE error inserting null into state_locks?

I'm working with a heavily customized version of ArcMap 9.3.1. It's heavily customized, but it mostly uses class extensions and special validations. Environment: ArcSDE installed in: linux, ...
3
votes
1answer
876 views

Arcpy does not execute “CopyFeatures_Management” to write a featureclass to an ArcSDE database

I have some problems with my Python script. The script gets an JSON with different information about images. The information includes general information about images and also the gps position of ...
6
votes
2answers
1k views

GIS Database Migration Project (Oracle to ArcGIS)

I have been tasked with converting an Oracle Database into an ESRI file geodatabase. The data represents a gas network. The client's Oracle database has over 400 tables, 120 of which are spatial. ...
2
votes
1answer
403 views

How can I use Oracle views with Geoserver and WFS-T?

What goes on when Geoserver handles updates to my table using WFS-T? I have a table AREA ( ID NUMBER(10) NOT NULL PRIMARY KEY, SOME_OTHER_ID NUMBER(10) NOT NULL FOREIGN KEY REFERENCES FOO(ID), ...
1
vote
1answer
2k views

How to manage user privilege on layers to Arcgis 10 Desktop?

Problem: I am a Computer Analyst on a town hall. Here we have the sector A and B. Both work in ArcGIS 10 Desktop. The sector A has granted to access/edit everything. The sector A has all the ...
1
vote
1answer
268 views

Using Query Layers with ArcGIS Server 10.0 for Java on Linux

I have an ArcGIS Server 10.0 for Java running under Red Hat Linux. I would like to be able to publish a Map Document that I have created which has a working Query Layer connecting to Oracle 11g. In ...
2
votes
1answer
527 views

Geometry valid in PostGIS turns out to be not valid in Oracle

Geometry is in PostgreSQL database. It is valid. Geometry is exported as GML and then inserted into Oracle database. Then function SDO_UTIL.RECTIFY_GEOMETRY(geometry, tolerance) is called, which ...
4
votes
2answers
2k views

ST_Geometry vs SDE Binary: seeking recommendations, experiences

I've got some questions I've collected as we try to come to a decision about whether to use ST_Geometry or SDE native geometry for an Oracle/SDE datastore on a new project. The organization has quite ...
7
votes
1answer
249 views

What is the overall architecture of ArcSDE, and how does it fit into the enterprise?

I'm finding many gaps in my understanding of ArcSDE, particularly as it relates to Oracle. I just can't quite wrap my brain around the overall architecture of it, and how it fits into an enterprise. ...
5
votes
3answers
392 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 ...
3
votes
2answers
650 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 ...
5
votes
2answers
644 views

OGR to read from oracle, and then write a CSV

I need to read an Oracle (not spatial) table with OGR. I have no problem with ogrinfo. I use this command: ogrinfo -ro OCI:user/password -sql "select * from HR.EMPLOYEES" I have this kind of ...
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 ...
9
votes
4answers
2k views

How to identify “true arcs” in Arcmap?

This is really annoying: the only good way of creating circles in ArcMap is using true arc, (compound curves) but I need to convert those to vertex (densifying) because of a compatibility problem. I ...
5
votes
1answer
393 views

How to Make a Thematic Map with ORACLE using MapXtreme?

I want to make a thematic map with Oracle source longitude and latitude values. I have made thematic maps with tab file source. Part of the code looks like this: ...
3
votes
3answers
634 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
766 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 ...
3
votes
1answer
301 views

Using multiversion view trigger to maintain unique ID in ArcSDE for Oracle?

I'm trying to identify the best way to automatically maintain a unique id column in Oracle ArcSDE. I don't want to use a class extension, since I've multiple third party users of the data and it's ...