A commercial relational database management system.

learn more… | top users | synonyms

6
votes
2answers
813 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. ...
1
vote
0answers
278 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
245 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
402 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 ...
3
votes
2answers
1k 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
195 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
292 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
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 ...
5
votes
2answers
566 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 ...
8
votes
4answers
1k 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
341 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
515 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
622 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
239 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 ...
2
votes
0answers
596 views

oracle 10 connection on arcgis 10, windows 7

I have problem odbc connection on arcgis 10, oracle 10 and windows 7. odbc connection on windows, running well. but when arcgis conection via arcatalog, appear error "Test connection error because of ...
3
votes
1answer
232 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 ...
3
votes
0answers
180 views

ArcSDE Database Refactoring Tools?

We are using liquibase as evolutionary DB change management tool in our applications, it works great when we use it in "common" database schemas. But we also work with GIS applications using esri ...
4
votes
1answer
998 views

ArcGIS Query Layer performance documentation or feedback

I first tried asking this question in the ArcGIS forums but as is common I got a total of 0 responses. I'm willing to accept this may be due to a lack of knowledge on the subject, but I'm optimistic. ...
0
votes
1answer
497 views

Character encoding for Oracle DB and Geoserver

I have a setup that uses Oracle database->GeoServer->OpenLayers->my JavaScript. I use the UTF-8 character set in GeoServer and the JavaScript layers. The Oracle instance is configured to use WIN1252 ...
1
vote
0answers
69 views

sdequery.exe: When using functions as column names (-C parameter), how do you escape the comma for functions with parameters?

Using sdequery, I'm specifically trying to return sys_context('USERENV', 'SESSIONID'). user and sysdate work fine. Functions with single parameters work fine. But as soon as I use a function with ...
0
votes
0answers
333 views

Publishing Oracle View in Geoserver Error

I am getting following error while publishing layer in geoserver: org.apache.wicket.WicketRuntimeException: Failed to add pluggable layer configuration panels at ...
4
votes
2answers
340 views

Calculating the space a feature class will use in ArcSDE?

Is it possible to get a good estimate on how much space a feature class will take once loaded into ArcSDE from how big they are in a FGDB? I have some feature classes in a FGDB, where some are a few ...
2
votes
3answers
4k views

Python script: Access data from databases [closed]

I need to access data that is inside an oracle database using a python script. Its a Unix server running oracle 10g. I dont have much access to the database server. It works fine on model builder ...
4
votes
0answers
559 views

Could not obtain native oracle connection [closed]

Anyone knows the the cause and how to resolve the "Could not obtain native oracle connection" error? I'm using GeoTools 2.7.4, a oracle 11g DB, ojdbc14.jar, and a simple java code on a Tomcat 6 like ...
4
votes
1answer
603 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
414 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 ...
6
votes
2answers
674 views

Oracle / SDE: ST_GEOMETRY or SDE Compressed Binary

I read data from a SDE database (Oracle) directly. How do I know, which format is used to store the geometry data? Do I have to check the DataType for the geometry column or is this information ...
3
votes
3answers
1k views

Tracking change with ArcSDE/Oracle

I'm looking for the simplest way to track changes ([delete, update, create] feature(s)) made to the DEFAULT version of a given feature class in ArcSDE(10) and Oracle(11g). Qualifier: I am not a dba ...
1
vote
1answer
2k views

Adding EPSG:3857 / 900913 to Oracle's mdsys.cs_srs

I am working with an Oracle Standard database at version 11.2.0.1.0. I also have access to XE version 11.2.0.2.0. The later version has both SRIDs 900913 (Google Mercator) and 3857 (official Web ...
0
votes
1answer
865 views

OpenLayers/GeoServer/Oracle combo input/output scenario

Im completely new to GIS. I must finish already started project that uses Oracle as DB for geoobjects, Geoserver, OpenLayers. Task is to draw something on a map (OpenLayers must handle that drawing i ...
5
votes
3answers
537 views

How not to Copy Features when too many would be output?

This question has already been posed to the ArcGIS Geoprocessing forum but I have had no responses there. I have a 3.5 million polygon layer (cadastre) stored in Oracle via ArcSDE. I use a polygon ...
4
votes
2answers
697 views

How to allow more polyline vertices for a ST_GEOMETRY in Oracle/SDE?

I'm receiving an error writing geometry (in ArcObjects) that has a large number of vertices (around 900). So big, but not ridiculously big. I would expect this to be no problem and I don't recall ...
8
votes
2answers
360 views

How to determine storage type (ST_Geom/Oracle) from arcpy/python

We're migrating some feature classes from SDELOB (or some older binary format) to ST_Geometry. As we write our arcpy script to use the ESRI Migrate Storage Tool we'd like to test whether or not ...
5
votes
1answer
187 views

ArcObjects edit/update ODBC Oracle table

Can an ODBC Oracle table attached by OLE within ArcMap be edited/updated by using ArcObjects? If so, what are the procedural steps for doing this? Are there code examples out there showing how to do ...
3
votes
2answers
161 views

LRS schema error in Oracle SDO_NET when validating network

I have a problem with the Oracle Spatial Network package. I'm creating NODE, LINK and PATH based on LRS. When I try the call: SELECT SDO_NET.VALIDATE_NETWORK('network_tracking') FROM DUAL then I ...
4
votes
2answers
415 views

ArcObjects ISQLSyntax with Oracle DB esriSQL_DelimitedIdentifierPrefix issue

New to stack exchange, heading over from the esri forums, it is great! I am trying to produce a query that I can use across all workspaces, naturally using ISQLSyntax. The problem I'm having is that ...
0
votes
1answer
555 views

How can I change mouse cursor while it hovers over the map in Oracle Mapviewer

I'm using Oracle Mapviewer. I want to switch mouse pointer from default to crosshair when user enters "Interactive mode". I'm developing in GWT and tried do do something like this: public static void ...
4
votes
1answer
286 views

Geometry storage type in geodatabase Oracle 9i with SDE 9.3.1

How do I identify what geometry storage type is being used with a specific geodatabase? Thanks.
4
votes
3answers
900 views

ArcMap query layer with Oracle Locator displaying no results

I have an Oracle 11g database setup with Oracle Locator. I have created a table with the this query: CREATE TABLE geotest (id NUMBER(38) NOT NULL, shape SDO_GEOMETRY); Then I inserted one point ...
0
votes
1answer
270 views

Any known problems after Tomcat-upgrade using oracle locator?

After trying to upgrade from Tomcat 5.5.28 to 5.5.29 or above I ran into a strange problem. We use a linux based gis system using an Oracle EE DB (without spatial license). Problem After the upgrade ...
3
votes
1answer
1k views

ArcSde Oracle Maximum number of grids per feature (8000)

I have a problem with the import of data (lines) to ArcSde Oracle. 2011-07-14 12:10:04| 22.9| 0.0|ERROR |Error while executing stream insert operation for table 'CHEMN'.:SDE_ERROR_CODE(-51) ...
0
votes
1answer
595 views

FME ArcSDE… the scale is very small

I have a problem with ArcSde and FME. I try to import some line features to ArcSDE Oracle. When I start the script in FME, I have some errors: impossible to insert linestring in ArcSde because the ...
3
votes
1answer
2k views

How do I create a functional spatial index of an ST_Geometry Feature Class in Oracle/SDE?

Copied an SDE feature class (with blob(sdebinary(?) geom) into the same SDE GDB (Oracle 11g/SDE 9.3.1) but with the ST_geometry configuration keyword. I can see that the feature class was created, ...
7
votes
3answers
327 views

Changing a coded Domain to no codes

If we have coded domains in the geodatabase model, what are any disadvantages to changing the codes to the Description. For example: Existing Coded Domain: Code, Description 1, Single Family ...
1
vote
2answers
2k views

How do I use Oracle Locator's mdsys.sdo_geometry with ArcSDE?

I'm using the Oracle Locator MDSYS.SDO_Geometry type to store my spatial information and then accessing it through ArcSDE. I'm confused about how the precision component of the metadata is used and ...
15
votes
3answers
2k views

ArcObjects: Memory leak in IFeatureClass.Search (only on SDE with direct connect)

UPDATE 6/30/11: ESRI Support say they have reproduced the issue and have opened a bug report (NIM070156). I have determined that there is a memory leak (in unmanaged heap memory) that occurs when a ...
2
votes
1answer
185 views

Database View in Oracle 9i with SDE 9.3.1

If I have a sql statement creating a view against ArcSDE 9.3.1 on Oracle 9i, is the best practice to create the view in ArcCatalog just creating the name (kind of shell of the view) then going in to ...