Skip to main content
8 votes

PostGis vs Oracle Spatial 11g performance

Oracle Spatial and Postgis both have their own pros and cons. While dealing with the spatial data Postgis always outperform Oracle Spatial. I have been working for last 2 year on Oracle Spatial and i ...
Ahsan Mukhtar's user avatar
7 votes

Rule-based symbology based on current selection in QGIS

Solution for Case 1: Add two symbol layers to the polygon layer as in the image. Open Based-on selected points rule, open expression window for Filter. Go to Function Editor tab and add the ...
Kadir Şahbaz's user avatar
6 votes
Accepted

Loading shapefile in Oracle Spatial?

The simlest tool for loading shapefile into oracle spatial database is provided by Oracle itself as Mapbuilder. You can download it from Oracle site. You need to register (free) once with Oracle. You ...
GeoSpatialEarth.in's user avatar
6 votes
Accepted

Directly edit features in non-SDE Oracle feature class?

No, it is not possible to directly edit Query Layers (in any database) using the standard graphical editing tools of ArcMap/arcpy (as if they were shapefile, file geodatabase, or enterprise-enabled ...
Vince's user avatar
  • 20.1k
5 votes

Does the OBJECTID in an Oracle Geodatabase table have a primary key constraint, by default?

By default, yes, it normally is unless someone overrode that and designed the table differently. Is this an ArcSDE database? There may also be GlobalID fields that act as primary keys across ...
GIS87's user avatar
  • 336
5 votes
Accepted

Does the OBJECTID in an Oracle Geodatabase table have a primary key constraint, by default?

I think the answer is no. The OBJECTID in an Oracle geodatabase table does not have a primary key constraint , by default. When I query an Oracle geodatabase table to return the column that has a ...
User1974's user avatar
  • 1,132
5 votes

Creating geodatabase (and st_geometry) in Oracle Express (XE) for home/personal use?

It is your plan to "add a sde.st_geometry user-defined type" that means you will need ArcGIS Server (of which ArcSDE is a component) licensed. If that is a mandatory requirement then your most cost ...
PolyGeo's user avatar
  • 65.2k
5 votes
Accepted

How to view coordinates instead of geometry object in geometry column in Oracle SQL Developer?

You can double-click one of those objects. That bring up a little pencil icon on the side. Clicking that brings up an "edit" window that shows the object content. That works fine for points. Hard to ...
Albert Godfrind's user avatar
5 votes
Accepted

Connecting to *.sde file in database IDE

The ".sde" file is simply a ESRI file format that contains the connection information required to connect to an ESRI enterprise geodatabase. Using ArcMap or ArcCatalog, you can right-click on the "....
Son of a Beach's user avatar
5 votes

Rule-based symbology based on current selection in QGIS

This script creates a rule based style which refreshes upon the selection of a feature with the logic you described.You only need to enter the layer names below and run it in QGIS. class Restyler: ...
Leon Powałka's user avatar
5 votes
Accepted

QGIS 3 SQL dialect - is UNION ALL allowed?

The error message Geometry type and srid for empty column GEOM of (entire query here) undefined is caused by a failed unique ID, as it turns out. The following query returns ~2500 rows, but a few are ...
grego's user avatar
  • 1,063
4 votes

ST_GEOMETRY to SDO_GEOMETRY

One possible solution is to get ESRI's ST_Geometry into a WKT or WKB notation, then use that to construct SDO_GEOMETRY objects. Something like this (assuming table SHAPES contains a column called ...
Albert Godfrind's user avatar
4 votes
Accepted

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

This is the question/response I got from oracle's spatial expert in Europe in 2014. q: Does oracle have the concept of an empty geometry? If so can you give me an example? Would this be a valid way ...
aileen's user avatar
  • 104
4 votes

Oracle spatial: Point cluster vs MultiPoint?

You are creating the same MultiPoint geometry with different constructor parameters for SDO_ELEM_INFO_ARRAY. You are defining the GTYPE of your geometry with the first parameter of the constructor (...
Lars's user avatar
  • 2,197
4 votes

Populating oracle sdo_geometry object using GeoJSON?

Oracle 12.1 comes with built-in support for JSON. Oracle 12.2 adds built-in support for GeoJSON: function sdo_util.from_geojson() will take a GeoJSON geometry and turn it into an SDO_GEOMETRY object. ...
Albert Godfrind's user avatar
4 votes

What is mapinfo precision on coordinates

Here is an explanation on MapInfo node precision. https://web.archive.org/web/20150418133027/www.mapinfo.com/wp-content/uploads/2013/07/Focusing-in-on-Spatial-Precision-White-Paper.pdf I don't know ...
rossnixon's user avatar
  • 528
4 votes
Accepted

Error concatenating lines in Oracle Spatial

I'll divide the answer in two parts: one covering the origin of the error and other about the solution without correcting the original data and discussion about the results of the different ...
Carlos MSF's user avatar
4 votes
Accepted

How to find closest point on a line from a point in Oracle Spatial?

What you are asking for is linear referencing. Check out the SDO_LRS package for that. First the SDO_NN operator will give you the nearest line to a given point, then SDO_LRS.PROJECT_PT() against ...
Albert Godfrind's user avatar
4 votes
Accepted

Snap a point to a line and get the line ID (Oracle Spatial or SDE.ST_GEOMETRY)

This example uses Oracle Spatial's Linear Referencing facility to project the inspection points onto the closest sidewalk like. It then updates the inspection point with: The id of the closest ...
Albert Godfrind's user avatar
3 votes
Accepted

Are ESRI spatial views regenerated whenever they are queried?

The short answer is yes. A view is basically a stored query. A couple of general things you can try to speed up you database performance. Make sure all your join fields are indexed Make sure the ...
Dowlers's user avatar
  • 2,334
3 votes

ogr2ogr: encoding issues when importing from Oracle Spatial to PostGIS

Try this Oracle environment variable: NLS_LANG=AMERICAN_AMERICA.UTF8
Martin Jensen's user avatar
3 votes

Querying for underscore character in ArcMap?

I came across this Q&A which helped me to solve why I was unable to use a where clause on an ArcPy search cursor which could restrict the cursor to just those records which contained an underscore ...
PolyGeo's user avatar
  • 65.2k
3 votes

Add and edit Oracle Spatial Layer in QGIS

We did have similar issue with Oracle Spatial. In our case we need to adding more permissios for geom-columns (or whatever column you use to store geometries). GRANT UPDATE ("GEOM") ON "MYSCHEMA"."...
posiki's user avatar
  • 61
3 votes
Accepted

Creating geodatabase (and st_geometry) in Oracle Express (XE) for home/personal use?

ESRI.ST_Geometry: To my surprise, I was able to use the Create Spatial Type tool to create st_geometry in an Oracle XE database. This worked, despite the fact that my database was not a geodatabase. ...
User1974's user avatar
  • 1,132
3 votes
Accepted

Split lines in segments based on distances in Oracle

The clear solution for that is the Linear Referencing mechanism that comes with Oracle Spatial, i.e. the SDO_LRS package. Here is an example. Setup the lines. Here the coordinates are in long/lat, ...
Albert Godfrind's user avatar
3 votes
Accepted

ArcObjects error storing long integer value to Oracle

Long is not that long according to ESRI. They say it translates to number(10), while you need a number(12) or more. The workaround is to create a double(12,0) column in ArcCatalog, with a scale of 0 (...
JGH's user avatar
  • 42.2k
3 votes
Accepted

Vector tiles for Oracle Spatial

Some alternatives which should work: 1) Use GeoServer vector tile output http://docs.geoserver.org/latest/en/user/extensions/vectortiles/index.html with Oracle datastore http://docs.geoserver.org/...
user30184's user avatar
  • 66.5k
3 votes
Accepted

Projecting features to Enterprise Geodatabase in Oracle gives ERROR 000210: Cannot create output

The 000210 error is principally caused by two potential errors: The table name is not valid (often a reserved word) One or more of the columns are not valid (reserved word or too many characters) ...
Vince's user avatar
  • 20.1k
3 votes

Snap a point to a line and get the line ID (Oracle Spatial or SDE.ST_GEOMETRY)

Here is the answer from my side using different functions with the trigger. Create Table. create table linestrings ( id number primary key, geom sdo_geometry ); create table inspection ( id ...
Muhammad Imran Siddique's user avatar
3 votes
Accepted

Delete duplicate geometries from ORACLE table

Try the answer offered here: https://community.oracle.com/thread/2538130?start=0&tstart=0 Especially look at the sql query as suggested by Luc Van Linden: DELETE FROM TOTALRECORDS where rowid ...
cm1's user avatar
  • 2,290

Only top scored, non community-wiki answers of a minimum length are eligible