A commercial relational database management system.
1
vote
0answers
15 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
35 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...
0
votes
0answers
55 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 ...
0
votes
0answers
25 views
Oracle Feature Class Couldn't Displayed
I got problem on displaying feature class in Oracle, which successfully imported from file geodatabase using Append (Data Management) Tools, my experiment on copying it to Postgre no problem on ...
0
votes
0answers
27 views
Geoserver 2.3.0 exclamation mark on Layer
if i want to publish a Layer from Oracle Locator this becomes a yellow exclamation mark and so i can´t see in the layer preview. I use before geoserver 2.1.4 and it worked perfect.
I have attempt to ...
3
votes
1answer
79 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
152 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
3answers
131 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
130 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 ...
3
votes
1answer
157 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 ...
4
votes
2answers
175 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
93 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
211 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
87 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
155 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 ...
2
votes
2answers
255 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 ...
6
votes
1answer
98 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
2answers
139 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
1answer
204 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
256 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
32 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
3answers
306 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
166 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
227 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
541 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 ...
4
votes
2answers
185 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
119 views
How can I use the multiversion view trigger to maintain a unique id in ArcMap?
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
351 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
153 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
148 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 ...
3
votes
1answer
443 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
236 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
43 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
178 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
166 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
2k 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
331 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 ...
3
votes
1answer
294 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
269 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
367 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 ...
2
votes
3answers
559 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 ...
0
votes
1answer
1k 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
527 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
347 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
441 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
228 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 ...
4
votes
0answers
120 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
120 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
306 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
222 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 ...
