All Questions
Tagged with oracle-spatial postgis
27 questions
1
vote
1
answer
166
views
ST_GEOMFROMTEXT generated by ora2pg fails
I have a set of polygons inside a oracle table which represent circles. I am tryining to import these into postgres 12 using ora2pg.
An insert statement is created that translates the polygon to
...
- 2,677
0
votes
0
answers
106
views
Inconsistent results from spatial databases
I'm trying to write something agnostic to whichever database vendor is chosen between MySQL, SQL Server, Oracle, and PostgreSQL. However, I see inconsistent results in functions that return measures. ...
- 61
-1
votes
1
answer
366
views
Best and Fastest way to extract Polygon attributes of a Point [closed]
This is a comparative question, I don't know whether it is allowed to ask this type of Question here or not.
Problem: I have a shapefile of almost 1 million polygons with 20-25 attribute fields. I ...
- 3,217
0
votes
0
answers
524
views
ora2pg SDO_Geometry to st_geometry
I am trying to migrate my database (Oracle) to postgres using ora2pg (v.23.1).
Unfortunately the script converts our SDO_Geometry datatype into
shape geometry(GEOMETRY,32632)
instead of
shape ...
- 2,677
1
vote
1
answer
182
views
SDO_JOIN conversion to PostGIS
I make refactoring from Oracle to PostGIS and I found out that PostGIS doesn't support sdo_join.
How should I correct the statement below?
SELECT e.ID AS EDGE1_ID,
u.NODE_ID AS ...
- 111
1
vote
2
answers
1k
views
ArcGIS Server Featurelayer: Error on adding features via JavaScript API after switch from Oracle db to PostGIS
We have a webapp which consumes services published on ArcGIS Server. All database relevant operations are done with ESRI ArcGIS abilities.
We now switched from Oracle 11g to PostgreSQL 9.4 with ...
- 141
0
votes
0
answers
136
views
Transfer indexed Oracle geoloc table to PostgreSQL using ogr2ogr
I am copying tables using ogr2ogr from Oracle to PostGIS using
ogr2ogr -f "PostgreSQL" PG:"host=<host> port=5432 user=<user> dbname=<dbname> password=<pwd>" OCI:<USERNAME&...
- 121
1
vote
0
answers
183
views
Oracle to PostgreSQL migration with ogr2ogr only imports first geoloc column
I transfer Oracle tables to PostGIS using Oracle Wallet and
ogr2ogr -f "PostgreSQL" PG:"host=<host> port=5432 user=<user> dbname=<dbname> password=<pwd>" OCI:<USERNAME>...
- 121
8
votes
1
answer
6k
views
PostGis vs Oracle Spatial 11g performance
I am having a performance issue updating a table in Oracle Spatial 11G while converting 63,000,000 points to WKT format. I also made a comparison with Postgres. Both Postgres and Oracle run in two ...
- 199
1
vote
1
answer
135
views
Reproject vector layer in oracle or PostGIS without export!
I have some vector layers in Oracle and PostGIS, point, line and polygon, and i want to reproject those layer in a different projection but i don't want to export the projected layer, i want to do it ...
- 1,179
1
vote
0
answers
146
views
How to find closest line of polygon [closed]
I have polygon layers on my ArcGIS Server and Geoserver. I need to find the closest line length of the polygon.
For example p(x1,x1) will get the L2 length and p(x2,y2) will get the L4 length.
Can I ...
- 1,734
0
votes
1
answer
72
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 ...
- 507
1
vote
1
answer
374
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 ...
- 81
5
votes
2
answers
2k
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 ...
- 51
3
votes
2
answers
2k
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 ...
- 285
0
votes
2
answers
159
views
how to configuring geomajas wih oracle spatial db?
I have just done intial setup of the geomajas project and trying to config its data source with oracle database.
I am following the given example for sqlserver and POSTGIS.
My oracle layerroad xml ...
- 111
3
votes
1
answer
858
views
Load PostGIS or Oracle Spatial Raster Layer using PyQGIS
How do we load Rasters stored in PostgreSQL-PostGIS or Oracle Spatial 11g into QGIS using PyQGIS?
I am able to load vector layers from Oracle 11g with below code. What changes are necessary to add ...
- 1,304
3
votes
2
answers
320
views
Buffer multiple roads to find points within and compare?
What I am trying to do is buffer a main st and a side street and get all of the points that intersect that buffer, however they need to be mutually exclusive. In the example below, my results would ...
- 474
2
votes
1
answer
2k
views
Transferring data from PostGIS to Oracle Spatial
I would like transfer spatial data from PostGIS to Oracle Spatial. I want to use Python's modules psycopg2 and cx_oracle. Transfer Oracle > PostGIS is OK, but in opposite version I have problem with a ...
- 610
1
vote
1
answer
1k
views
Does ora2pg support the SDO_GEOMETRY spatial type?
I've been searching the net up and down for days now and can't find a definite answer to this question, neither on google nor on the official page (http://ora2pg.darold.net/).
Does ora2pg support ...
- 165
2
votes
0
answers
1k
views
Migrating from PostGIS to Oracle Spatial
We are now using a solution based on PostGIS extension of Postgresql database for various spatial queries. But we are now thinking about data security. This is why we have a plan to migrate existing ...
- 3,217
3
votes
4
answers
4k
views
Converting oracle geometry to PostGIS with 3d data (wkt?) [closed]
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 ...
- 551
4
votes
1
answer
381
views
Does Oracle MapViewer support PostGIS?
I use Oracle MapViewer to generate my mapping data and currently I'm using an Oracle database as my spatial back-end. I would like to move my data over the PostGIS but I can't find any references if ...
- 237
3
votes
1
answer
1k
views
Making calls the PostGIS functions with Java
We have Java stored procedure in Oracle that make calls to functions offered by Oracle Spatial to perform spatial analysis and return results. I am looking to the same in PostGIS, is this possible?
- 161
32
votes
4
answers
7k
views
When should you NOT use a spatial index?
I am asking this because I was mainly working with Oracle but for the past year I've been doubling with PostGIS and SQLServer 2008. Most spatial functions in Oracle won't work without a spatial index ...
- 2,360
12
votes
3
answers
3k
views
Future of spatial databases?
It may be a bit off-topic. I am eager to know the industry specific importance of Spatial Databases.
Is Spatial Database a very important part of any GIS system? Or will we use other technologies to ...
3
votes
2
answers
746
views
Seeking common interface for ST_Geometry SDO_Geomtry
I've worked a fair bit with Oracle Spatial and I've had some requests to transition to PostgreSQL Spatial.
Is there a common interface for SDO_Geometry and ST_Geometry? I'm working in Java with ...
- 237