Questions tagged [oracle-spatial]

Use for questions about the Spatial or Locator extensions to the Oracle DBMS

Filter by
Sorted by
Tagged with
1
vote
0answers
144 views

Updating location field (geometry) in Oracle Spatial using asp.net web application [closed]

I want to update a geometry column in Oracle Spatial database via Asp.net web application, I couldn't find samples for update query or datatypes that can hold geometry data in asp.net. I use C# for ...
-4
votes
1answer
82 views

Connecting ArcGIS for Desktop to Oracle without ArcGIS for Server? [duplicate]

Is it possible to connect ArcMap to Oracle without ArcGIS for Server?
0
votes
1answer
59 views

Database standards for storing and analysing raster

Vector data stored in a database is covered by OGC's Simple Features and WKT. Databases indeed implement these standards. Some databases such as Oracle, PostGIS extend their support to rasters. Is ...
1
vote
1answer
81 views

How to read oracle not spatial data using pyqgis

I'm working on a QGIS plugin. I'm trying to join a vector layer and a non-spatial table both in Oracle spatial. I add the vector layer to the map, but I can not add the table without geometry so i ...
0
votes
0answers
45 views

ArcGIS export data in Shape from Oracle [duplicate]

I connected my Oracle database to ArcGIS and added one layer to map. This layer has points and polygons. I make a selection in this layer and get 9508 selected features, which I want to export as ...
1
vote
0answers
189 views

Using Mapnik's OGR plugin for Oracle Spatial Database

Mapnik wiki page of OGR plugin says that I can use the plugin for MSSQL server in the following manner: <Layer name="mssql" srs="+proj=latlong +datum=WGS84"> <StyleName>mssql_style<...
3
votes
0answers
333 views

Oracle SDO_GEOM.SDO_MBR Wrong Bounding Box Coordinates

I am using Oracle Spatial to match geo-specific images to the appropriate country they represent. I have a table with a row for each country. Each row consists of a SDO_GEOMETRY column for 3 items: ...
2
votes
0answers
44 views

No data found error when reconciling version in sde

I got an error when reconciling a version in the sde database and it seems sde cannot find the data in one table with a specific STATE_ID (for example STATE_ID = 12345 for table abc). In the delta ...
1
vote
2answers
331 views

Connecting QGIS to Esri Enterprise Geodatabase of type Oracle Spatial

I have an Esri Enterprise Geodatabase (ArcSDE 10.2.2; Oracle 10G). I am trying to connect it with QGIS 2.16. So I clicked "Add vector layer" button with "Database" Type : Oracle Spatial (I've tried ...
1
vote
1answer
169 views

request postgis to oracle sdo

My request in postgis : create table "schema1"."table1" as select p.field1 ,p.field2, l.field3, l.id from "schema1"."table2" p inner join "schema1"."table3" l on (p."GEOM" && l."GEOM" and ...
1
vote
1answer
1k views

Registering database Arcgis 10.2.2?

When I registered a database data store to ArcGIS Server in ArcCatalog, the following error occurs: Underlying DBMS error[ORA-12154: TNS:could not resolve the connect identifier specified No ...
1
vote
2answers
374 views

CreateEnterpriseGeodatabase Oracle Error

Executing: CreateEnterpriseGeodatabase Oracle \localhost\orcl # DATABASE_AUTH sys ***** SDE_SCHEMA sde ***** # C:\Users\Med\Desktop\ags103.ecp Start Time: Wed Sep 21 09:45:00 2016 User does not ...
2
votes
0answers
381 views

Oracle Spatial: Error with SDO_UNION

I have a table which contains address-points. With following sql-statement i have created a 100-meter buffer around each address-point: CREATE TABLE BUFFERPOLYGONS AS SELECT a.OBJECTID, SDO_GEOM....
2
votes
1answer
2k views

Efficient way to find geometries that intersect a given rectangle

It feels I'm missing something absolutely basic here OR there is something weird in the internals of Oracle's spatial indexing (I sincerely hope it is just me missing something basic or I am about to ...
2
votes
0answers
57 views

Geodatabase configuration keywords

I am trying to insert a new polyline dataset within my Oracle server database. The dataset in question is located within a local GDB, and is currently c420mb in size. It is taking hours and hours to ...
4
votes
2answers
1k views

Connecting to Oracle User Schema Geodatabase using ArcObjects?

I've set up an Oracle user Schema geodatabase and loaded some data into it. I now want to connect to it programmatically using ArcObjects, the problem is I don't see how. Where can I set the newly ...
3
votes
1answer
653 views

Oracle spatial: Point cluster vs MultiPoint?

I'm reading Oracle's documentation and i can't see the difference between Point cluster and MultiPoint element type. The following example code is from the documentation INSERT INTO t1 (i, d, g) ...
1
vote
1answer
308 views

QGIS doesn't display compound polygon (from a spatial oracle DB)

When I want to display the elements stored in a spatial oracle DB, the compound elements aren't display. There is no error message. The type of these compound elements is "1005". Are these elements ...
2
votes
0answers
261 views

QGIS Server 2.12.14 Errors with Oracle

We are using QGIS Server to serve Oracle SPatial (11.2.0.4) to a spatial viewer. There is 16Gb of RAM. The number of concurrent users is 100-150. QGIS Server is on Windows Server 2012 R2 with 16GB of ...
2
votes
1answer
331 views

QGIS Oracle-Spatial-GeoRaster-Plugin not working [closed]

I am having trouble with Oracle-Spatial-GeoRaster-Plugin in QGIS (running on Windows 7 Professional N 64bit). The connection to my database on an external Oracle-Server obviously works as it shows the ...
2
votes
2answers
1k views

is it possible to store empty geometries in an Oracle Database?

I'm trying to fix a GeoTools issue but I'm running into problems putting empty geometries into my Oracle database. Basically executing: select SDO_UTIL.FROM_WKTGEOMETRY('POINT EMPTY') from ...
1
vote
2answers
149 views

Loading and using 600k+ entities (from Oracle DB) in QGIS?

I'm new to QGis and working on some land register's datas. I tried to load an Oracle spatial layer, but with more than 600k rows, it took a very long time to process, when it didn't crash. After the ...
0
votes
1answer
271 views

Shapefile import used mapbuilder to oracle and publish on Geoserver but can't read '_'(underline)

environment:windows10 and oracle11g tools:oracle mapbuilder11 and geoserver2.8.2 step: 1.use mapbuilder to shp file into oracle . like this http://www.duoluodeyu.com/37.html 2.create a link with ...
1
vote
0answers
171 views

QGIS 2.14.3 can't attach oracle spatial table

when I try to attach spatial table in QGIS, the application close without errors. The tables which have problem have a UUID column: mslink NUMBER(10,0) NOT NULL, uuid RAW(16) ...
1
vote
1answer
262 views

Calculating all possible lat & long

I am new to GIA domain. I am trying to learn new concepts around mapping etc and this is my first app/implementation. I am trying to implement a store locator kind of function. I am thinking to ...
4
votes
1answer
55 views

Are ESRI spatial views regenerated whenever they are queried?

If a spatial view contains data "joined" from multiple tables, will all the tables be queried whenever a query is executed against the spatial view? We have some spatial views and whenever we run a ...
1
vote
1answer
191 views

Deleting features with arcpy on ArcGis SDE 10.0 SP5

I am new to ArcGIS and arcpy and am learning largely through trial and error. Anyway, the overall task is to delete, edit and add rows to feature classes. I thought it would be good to start with ...
1
vote
1answer
356 views

SRIDs do not match for the two geometries in Oracle Spatial

I am trying to resolve where some points from Point Geometry lying outside the Polygon geometry. I want to filter those points which are lying outside the polygon geometry. I am getting error where ...
1
vote
1answer
1k views

How to convert a compound geometry (Oracle) to a geometry made of straight line segments only?

I have an Oracle Spatial table containing compound geometries (i.e. geometries containing both straight lines segments and arcs) that I want to project in another reference system. Using SDO_CS....
0
votes
1answer
88 views

ESRI oracle multi editor schemas

Solution: The limitations of the Esri + Oracle (per 12c) were the cause. 12c Oracle will allow for Multi-Tenant DB, allowing us to have multiple SDE GeoDB as we need. This will meeting the need for ...
1
vote
1answer
252 views

Export Line Feature using ogr2ogr.

I am trying to export a line feature class from an oracle spatial database to a file geodatabase. I can export polygons with no problem, but cannot find the appropriate command '-nlt' for Line ...
5
votes
2answers
921 views

ogr2ogr: encoding issues when importing from Oracle Spatial to PostGIS

I'm trying to import some spatial tables from Oracle Spatial to PostGIS using ogr2ogr, but I can't figure out why the special characters on the attribute tables get messed up while I'm doing it. My ...
0
votes
1answer
1k views

Error in the connection to Oracle Spatial from QGIS

I am not being able to stablish the connection to an Oracle Spatial server in QGIS. Apparently I have the connection configured accordingly with QGIS documentation, but it stills gives me an error: ...
1
vote
1answer
242 views

Edits in Oracle Spatial Layers

I have an Oracle spatial layer that is built on top of a multi table view. When I make a new feature in QGIS, I get an error when I attempt to the save the edit. When I look in the database and ...
1
vote
1answer
3k views

ST_GEOMETRY to SDO_GEOMETRY

Is it possible for QGIS to read ESRI ST_GEOMETRY in an Oracle database? The ESRI geometry type looks like this: SDE.ST_GEOMETRY(260,61,491455.9942,5456922.8891,492388.3189,5457507.9101,NULL,NULL,NULL,...
0
votes
1answer
182 views

Do different RDMS use different SRID's to identify the coordinate system of a spatial object?

I'm looking for a reference that lists a standard SRID for a given CRS. Do RDMS's utilize a standardized SRID, such as OGC? Or is it unique to the RDMS?
1
vote
0answers
411 views

ArcGIS Server Rest API date issue

I am using "date '2015-8-10'" in ArcGIS Server REST API to retreive records from map services. But it returns the error "Fail to Execute". My date is stored as "10-AUG-15". When it is in the right ...
0
votes
0answers
376 views

How can I merge thousands of polygons in Oracle Spatial in faster way?

Previously I was using sdo_aggr_union(sdoaggrtype(geom, 0.005)) to get boundary polygon by merging geometries, which was taking at least 3 minutes in case of 4000 polygons. Even if I use merging of ...
0
votes
2answers
1k views

ArcGIS 10.1 crashes during connection with ArcSDE 10.2 in Oracle 11g database

I have been having this issues of ArcGIS (ArcMap and ArcCatalog) crashing on me every time I try to connect to the databases. I have updated both client and server patches for Oracle as suggested by ...
10
votes
3answers
1k views

Querying for underscore character in ArcMap?

For a standard LIKE query against an Oracle-based ArcSDE feature class, the underscore character represents a single character wildcard when used with a string. I'm trying to impose a definition ...
1
vote
0answers
75 views

Oracle Spatial: Issue with sdo_nn_distance for canada postal codes

Spatial data are available in the table st_country_postal_code with index. Inorder to get the distance between postal codes, we used the below query SELECT sdo_nn_distance (1) distance, z.* FROM ...
1
vote
0answers
228 views

Testing Oracle query produces valid results in QGIS Python Console

I have a query that searches an Oracle database using a where clause to get the geometry of an object and then zooms to the extent of that object. The value for the where clause is retrieved from a ...
3
votes
1answer
238 views

Why is query to retrieve WKB on Oracle Spatial returning null?

I am beginner on GIS, and I have loaded a shapefile to MSSQL, PostGIS and Oracle Spatial (11g) On both MSSQL and PostGIS I could create a query to return me the WKB from the table (geometry field) ...
3
votes
0answers
171 views

Geoserver ImageMosaicJDBC problem with interpolation setting

I use the ImageMosaicJDBC plugin to connect to an Oracle raster table. Maybe someone can clarify some things about the interpolation settings. There are multiple location where I can define the ...
1
vote
1answer
660 views

How geoserver calculates Native Bounding Box from Oracle Layer?

I need to know, how geoserver calculates Native Bounding Box & Lat/Lon Bounding Box. I am publishing a polygon layer from oracle spatial. In my case: Table Records: 7679477 Native Bounding Box:...
2
votes
2answers
2k views

Creating spatial view from materialized view?

I have a materialized view that runs nightly and performs an intersection of point locations and polygons. The materialized view works as designed and returns the desired results. It contains ...
4
votes
1answer
1k views

ArcSDE 10.1 Insert/Update Trigger on Adds (A) Table (Oracle 11g) and Feature Services on ArcGIS Server

I'm trying to use a trigger to update a versioned dataset in an SDE environment. Basically, I wanted to implement a system of unique ids called GISID. Initially, when a feature is created (inserted), ...
3
votes
2answers
1k views

Does Oracle Spatial calculate geodetic distance?

I've got to migrate a PostGIS database to Oracle Spatial, and am stuck on a problem: In a view, I have a column that amounts to ST_Distance(geography(geom_1), geography(geom_2)), effectively ...
2
votes
1answer
601 views

Projection Problem on Oracle Spatial

I would like to transform SDO_GEOMETRY from WGS84 projection to my custom projection in Oracle Database. Details for custom projection is as follows: +proj=lcc +lat_1=40.5 +lat_2=37.5 +lat_0=25 +...
1
vote
0answers
121 views

Need Help Creating Query Layer From Oracle For Past 365 Days [closed]

I have several Query layers that work fine for generic, long term date ranges such as: This shows all entries that have the previous YEAR in the date field. AND To_char(ds.calendar_date, 'YYYY') = ...

1 2
3
4 5
8