GDAL ogr2ogr OracleSpatial to Shape: Multipolygons with wholes/multiparts are missingintersection between two...
Size of electromagnet needed to replicate Earth's magnetic field
Why must Chinese maps be obfuscated?
A coin is thrown until the tail is above.
How to reduce LED flash rate (frequency)
Was there a Viking Exchange as well as a Columbian one?
Pulling the rope with one hand is as heavy as with two hands?
Contradiction proof for inequality of P and NP?
What is the origin of the term "plane of the spirit level"?
Multiple options vs single option UI
Can someone publish a story that happened to you?
How much cash can I safely carry into the USA and avoid civil forfeiture?
Will tsunami waves travel forever if there was no land?
Do I have an "anti-research" personality?
How does a program know if stdout is connected to a terminal or a pipe?
Why does Mind Blank stop the Feeblemind spell?
Does a semiconductor follow Ohm's law?
Is there an official tutorial for installing Ubuntu 18.04+ on a device with an SSD and an additional internal hard drive?
Apply MapThread to all but one variable
A Note on N!
what is the sudo password for a --disabled-password user
Binary Numbers Magic Trick
What's a good approximation to the zeros of the cosine integral?
Do I have to worry about players making “bad” choices on level up?
What are the potential pitfalls when using metals as a currency?
GDAL ogr2ogr OracleSpatial to Shape: Multipolygons with wholes/multiparts are missing
intersection between two multipolygons yielding anomalous GeometryCollection object full of LineString's & Polygon's (trying to get intersect area)Load data to exists table with ogr2ogrogr2ogr does not set osm_id for all multipolygonsogr2ogr ascii --> ShapeCreate multipolygons grouped by field, ogr2ogrGdal Ogr2Ogr Split polygon shapefile by line shapefilehow to use GDAL ogr2ogrPulling Spatial Data in Geography Format From MS SQL Server 2008 Using ogr2ogrogr2ogr missing OSM featuresogr2ogr with GDAL 2.4 not reprojecting correctly
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
We're holding geodata in an Orcale database (11g) with spatial extension. I want to unload specific polygons and convert them into Shape for further local processing.
The table where I'm unloading from holds polygons/multipolygons: Oracle Spatial GeomTypes are 4003 and 4007 (4D-Polygon and 4D-Multipolygon - third and fourth axis are not used however).
For unloading and conversion I use this command within a python-script:
ogr2ogr.main(["", "-f", "ESRI Shapefile", result_path + query_result, connection_params,"-nlt", "MULTIPOLYGON", "-sql", the_sql_query_here])
Connection and convertion only seems to work for polygons with GeomType 4003 however:
Multipartpolygons or polygons with wholes (GeomType 4007) are completely ignored (white gaps). I already tried to rerun the command above with POLYGON or PROMOTE_TO_MULTI instead of MULTIPOLYGON. No change in the result though.
Any known caveats or workarounds regarding this problem?
My GDAL is v2.1.2
As requested in the comments I publish the geom-content of an object whose geometry couldn't be loaded:
MDSYS.SDO_GEOMETRY(4007,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1005,5,1,2,1,5,2,1,9,2,1,13,2,1,17,2,1,25,1005,5,25,2,1,29,2,1,33,2,1,37,2,1,41,2,1),MDSYS.SDO_ORDINATE_ARRAY(33433109.145,5711835.706,9999.9999,0,33433166.721,5711687.09,9999.9999,0,33433229.435,5711904.544,9999.9999,0,33433205.628,5711904.647,9999.9999,0,33433175.618,5711821.022,9999.9999,0,33433109.145,5711835.706,9999.9999,0,33433020.391,5711673.812,9999.9999,0,33433153.215,5711635.136,9999.9999,0,33433164.011,5711674.531,9999.9999,0,33433099.673,5711838.076,9999.9999,0,33433071.502,5711844.871,9999.9999,0,33433020.391,5711673.812,9999.9999,0))
Corresponding real life object is multipart and looks like this:
While the geometry doesn't get converted, the objects non-spatial attributes and values get fully converted to shape .
shapefile gdal polygon ogr2ogr oracle-spatial
edited Aug 18 '18 at 3:09
PolyGeo♦
54.1k1782247
asked Aug 16 '18 at 5:55
knutellaknutella
311214
bumped to the homepage by Community♦ 11 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
We're holding geodata in an Orcale database (11g) with spatial extension. I want to unload specific polygons and convert them into Shape for further local processing.
The table where I'm unloading from holds polygons/multipolygons: Oracle Spatial GeomTypes are 4003 and 4007 (4D-Polygon and 4D-Multipolygon - third and fourth axis are not used however).
For unloading and conversion I use this command within a python-script:
ogr2ogr.main(["", "-f", "ESRI Shapefile", result_path + query_result, connection_params,"-nlt", "MULTIPOLYGON", "-sql", the_sql_query_here])
Connection and convertion only seems to work for polygons with GeomType 4003 however:
Multipartpolygons or polygons with wholes (GeomType 4007) are completely ignored (white gaps). I already tried to rerun the command above with POLYGON or PROMOTE_TO_MULTI instead of MULTIPOLYGON. No change in the result though.
Any known caveats or workarounds regarding this problem?
My GDAL is v2.1.2
As requested in the comments I publish the geom-content of an object whose geometry couldn't be loaded:
MDSYS.SDO_GEOMETRY(4007,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1005,5,1,2,1,5,2,1,9,2,1,13,2,1,17,2,1,25,1005,5,25,2,1,29,2,1,33,2,1,37,2,1,41,2,1),MDSYS.SDO_ORDINATE_ARRAY(33433109.145,5711835.706,9999.9999,0,33433166.721,5711687.09,9999.9999,0,33433229.435,5711904.544,9999.9999,0,33433205.628,5711904.647,9999.9999,0,33433175.618,5711821.022,9999.9999,0,33433109.145,5711835.706,9999.9999,0,33433020.391,5711673.812,9999.9999,0,33433153.215,5711635.136,9999.9999,0,33433164.011,5711674.531,9999.9999,0,33433099.673,5711838.076,9999.9999,0,33433071.502,5711844.871,9999.9999,0,33433020.391,5711673.812,9999.9999,0))
Corresponding real life object is multipart and looks like this:
While the geometry doesn't get converted, the objects non-spatial attributes and values get fully converted to shape .
shapefile gdal polygon ogr2ogr oracle-spatial
edited Aug 18 '18 at 3:09
PolyGeo♦
54.1k1782247
asked Aug 16 '18 at 5:55
knutellaknutella
311214
bumped to the homepage by Community♦ 11 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Could you try to cast the polygons into 3D or 2D with the SQL parameter?
– user30184
Aug 16 '18 at 6:18
Thx, but I did not find any oracle-sql to cast 'on-the-fly' within a select statement. Also, regarding to role-management I am not able to create views, functions or modify table data directly. I tried the QGIS-loader (3.2.0) now, which seems to have a problem with the missing SRIDof the Oracle-geom-colums. It does not accept a NULL-value.
– knutella
Aug 16 '18 at 9:11
Oh, it probably is very complicated with oracle, see for example this spatialdbadvisor.com/oracle_spatial_tips_tricks/348/…. Could you add one such SDO_GEOMETRY as text into your question?
– user30184
Aug 16 '18 at 9:18
Added as Edit 1
– knutella
Aug 16 '18 at 9:57
For the sake of completeness: With Oracles { sdo_cs.make_2d() } -function flatening of 3D geometries into 2D works on the fly. For 4D it has to be used twice. Sadly ogr/GDAL couldn't deal with that either.
– knutella
Aug 17 '18 at 13:17
add a comment |
We're holding geodata in an Orcale database (11g) with spatial extension. I want to unload specific polygons and convert them into Shape for further local processing.
The table where I'm unloading from holds polygons/multipolygons: Oracle Spatial GeomTypes are 4003 and 4007 (4D-Polygon and 4D-Multipolygon - third and fourth axis are not used however).
For unloading and conversion I use this command within a python-script:
ogr2ogr.main(["", "-f", "ESRI Shapefile", result_path + query_result, connection_params,"-nlt", "MULTIPOLYGON", "-sql", the_sql_query_here])
Connection and convertion only seems to work for polygons with GeomType 4003 however:
Multipartpolygons or polygons with wholes (GeomType 4007) are completely ignored (white gaps). I already tried to rerun the command above with POLYGON or PROMOTE_TO_MULTI instead of MULTIPOLYGON. No change in the result though.
Any known caveats or workarounds regarding this problem?
My GDAL is v2.1.2
As requested in the comments I publish the geom-content of an object whose geometry couldn't be loaded:
MDSYS.SDO_GEOMETRY(4007,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1005,5,1,2,1,5,2,1,9,2,1,13,2,1,17,2,1,25,1005,5,25,2,1,29,2,1,33,2,1,37,2,1,41,2,1),MDSYS.SDO_ORDINATE_ARRAY(33433109.145,5711835.706,9999.9999,0,33433166.721,5711687.09,9999.9999,0,33433229.435,5711904.544,9999.9999,0,33433205.628,5711904.647,9999.9999,0,33433175.618,5711821.022,9999.9999,0,33433109.145,5711835.706,9999.9999,0,33433020.391,5711673.812,9999.9999,0,33433153.215,5711635.136,9999.9999,0,33433164.011,5711674.531,9999.9999,0,33433099.673,5711838.076,9999.9999,0,33433071.502,5711844.871,9999.9999,0,33433020.391,5711673.812,9999.9999,0))
Corresponding real life object is multipart and looks like this:
While the geometry doesn't get converted, the objects non-spatial attributes and values get fully converted to shape .
shapefile gdal polygon ogr2ogr oracle-spatial
edited Aug 18 '18 at 3:09
PolyGeo♦
54.1k1782247
asked Aug 16 '18 at 5:55
knutellaknutella
311214
We're holding geodata in an Orcale database (11g) with spatial extension. I want to unload specific polygons and convert them into Shape for further local processing.
The table where I'm unloading from holds polygons/multipolygons: Oracle Spatial GeomTypes are 4003 and 4007 (4D-Polygon and 4D-Multipolygon - third and fourth axis are not used however).
For unloading and conversion I use this command within a python-script:
ogr2ogr.main(["", "-f", "ESRI Shapefile", result_path + query_result, connection_params,"-nlt", "MULTIPOLYGON", "-sql", the_sql_query_here])
Connection and convertion only seems to work for polygons with GeomType 4003 however:
Multipartpolygons or polygons with wholes (GeomType 4007) are completely ignored (white gaps). I already tried to rerun the command above with POLYGON or PROMOTE_TO_MULTI instead of MULTIPOLYGON. No change in the result though.
Any known caveats or workarounds regarding this problem?
My GDAL is v2.1.2
As requested in the comments I publish the geom-content of an object whose geometry couldn't be loaded:
MDSYS.SDO_GEOMETRY(4007,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1005,5,1,2,1,5,2,1,9,2,1,13,2,1,17,2,1,25,1005,5,25,2,1,29,2,1,33,2,1,37,2,1,41,2,1),MDSYS.SDO_ORDINATE_ARRAY(33433109.145,5711835.706,9999.9999,0,33433166.721,5711687.09,9999.9999,0,33433229.435,5711904.544,9999.9999,0,33433205.628,5711904.647,9999.9999,0,33433175.618,5711821.022,9999.9999,0,33433109.145,5711835.706,9999.9999,0,33433020.391,5711673.812,9999.9999,0,33433153.215,5711635.136,9999.9999,0,33433164.011,5711674.531,9999.9999,0,33433099.673,5711838.076,9999.9999,0,33433071.502,5711844.871,9999.9999,0,33433020.391,5711673.812,9999.9999,0))
Corresponding real life object is multipart and looks like this:
While the geometry doesn't get converted, the objects non-spatial attributes and values get fully converted to shape .
shapefile gdal polygon ogr2ogr oracle-spatial
shapefile gdal polygon ogr2ogr oracle-spatial
edited Aug 18 '18 at 3:09
PolyGeo♦
54.1k1782247
asked Aug 16 '18 at 5:55
knutellaknutella
311214
edited Aug 18 '18 at 3:09
PolyGeo♦
54.1k1782247
asked Aug 16 '18 at 5:55
knutellaknutella
311214
edited Aug 18 '18 at 3:09
PolyGeo♦
54.1k1782247
edited Aug 18 '18 at 3:09
PolyGeo♦
54.1k1782247
edited Aug 18 '18 at 3:09
PolyGeo♦
54.1k1782247
54.1k1782247
asked Aug 16 '18 at 5:55
knutellaknutella
311214
asked Aug 16 '18 at 5:55
knutellaknutella
311214
asked Aug 16 '18 at 5:55
knutellaknutella
311214
311214
bumped to the homepage by Community♦ 11 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 11 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
Could you try to cast the polygons into 3D or 2D with the SQL parameter?
– user30184
Aug 16 '18 at 6:18
Thx, but I did not find any oracle-sql to cast 'on-the-fly' within a select statement. Also, regarding to role-management I am not able to create views, functions or modify table data directly. I tried the QGIS-loader (3.2.0) now, which seems to have a problem with the missing SRIDof the Oracle-geom-colums. It does not accept a NULL-value.
– knutella
Aug 16 '18 at 9:11
Oh, it probably is very complicated with oracle, see for example this spatialdbadvisor.com/oracle_spatial_tips_tricks/348/…. Could you add one such SDO_GEOMETRY as text into your question?
– user30184
Aug 16 '18 at 9:18
Added as Edit 1
– knutella
Aug 16 '18 at 9:57
For the sake of completeness: With Oracles { sdo_cs.make_2d() } -function flatening of 3D geometries into 2D works on the fly. For 4D it has to be used twice. Sadly ogr/GDAL couldn't deal with that either.
– knutella
Aug 17 '18 at 13:17
add a comment |
Could you try to cast the polygons into 3D or 2D with the SQL parameter?
– user30184
Aug 16 '18 at 6:18
Thx, but I did not find any oracle-sql to cast 'on-the-fly' within a select statement. Also, regarding to role-management I am not able to create views, functions or modify table data directly. I tried the QGIS-loader (3.2.0) now, which seems to have a problem with the missing SRIDof the Oracle-geom-colums. It does not accept a NULL-value.
– knutella
Aug 16 '18 at 9:11
Oh, it probably is very complicated with oracle, see for example this spatialdbadvisor.com/oracle_spatial_tips_tricks/348/…. Could you add one such SDO_GEOMETRY as text into your question?
– user30184
Aug 16 '18 at 9:18
Added as Edit 1
– knutella
Aug 16 '18 at 9:57
For the sake of completeness: With Oracles { sdo_cs.make_2d() } -function flatening of 3D geometries into 2D works on the fly. For 4D it has to be used twice. Sadly ogr/GDAL couldn't deal with that either.
– knutella
Aug 17 '18 at 13:17
Could you try to cast the polygons into 3D or 2D with the SQL parameter?
– user30184
Aug 16 '18 at 6:18
Could you try to cast the polygons into 3D or 2D with the SQL parameter?
– user30184
Aug 16 '18 at 6:18
Thx, but I did not find any oracle-sql to cast 'on-the-fly' within a select statement. Also, regarding to role-management I am not able to create views, functions or modify table data directly. I tried the QGIS-loader (3.2.0) now, which seems to have a problem with the missing SRIDof the Oracle-geom-colums. It does not accept a NULL-value.
– knutella
Aug 16 '18 at 9:11
Thx, but I did not find any oracle-sql to cast 'on-the-fly' within a select statement. Also, regarding to role-management I am not able to create views, functions or modify table data directly. I tried the QGIS-loader (3.2.0) now, which seems to have a problem with the missing SRIDof the Oracle-geom-colums. It does not accept a NULL-value.
– knutella
Aug 16 '18 at 9:11
Oh, it probably is very complicated with oracle, see for example this spatialdbadvisor.com/oracle_spatial_tips_tricks/348/…. Could you add one such SDO_GEOMETRY as text into your question?
– user30184
Aug 16 '18 at 9:18
Oh, it probably is very complicated with oracle, see for example this spatialdbadvisor.com/oracle_spatial_tips_tricks/348/…. Could you add one such SDO_GEOMETRY as text into your question?
– user30184
Aug 16 '18 at 9:18
Added as Edit 1
– knutella
Aug 16 '18 at 9:57
Added as Edit 1
– knutella
Aug 16 '18 at 9:57
For the sake of completeness: With Oracles { sdo_cs.make_2d() } -function flatening of 3D geometries into 2D works on the fly. For 4D it has to be used twice. Sadly ogr/GDAL couldn't deal with that either.
– knutella
Aug 17 '18 at 13:17
For the sake of completeness: With Oracles { sdo_cs.make_2d() } -function flatening of 3D geometries into 2D works on the fly. For 4D it has to be used twice. Sadly ogr/GDAL couldn't deal with that either.
– knutella
Aug 17 '18 at 13:17
add a comment |
1 Answer
1
active
oldest
votes
I can only confirm the issue by running this ogrinfo command:
ogrinfo OCI:user/password@database -sql "select MDSYS.SDO_GEOMETRY(4007,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1005,5,1,2,1,5,2,1,9,2,1,13,2,1,17,2,1,25,1005,5,25,2,1,29,2,1,33,2,1,37,2,1,41,2,1),MDSYS.SDO_ORDINATE_ARRAY(33433109.145,5711835.706,9999.9999,0,33433166.721,5711687.09,9999.9999,0,33433229.435,5711904.544,9999.9999,0,33433205.628,5711904.647,9999.9999,0,33433175.618,5711821.022,9999.9999,0,33433109.145,5711835.706,9999.9999,0,33433020.391,5711673.812,9999.9999,0,33433153.215,5711635.136,9999.9999,0,33433164.011,5711674.531,9999.9999,0,33433099.673,5711838.076,9999.9999,0,33433071.502,5711844.871,9999.9999,0,33433020.391,5711673.812,9999.9999,0)) as geom from dual"
The result is MULTIPOLYGON EMPTY.
Perhaps you would like to send a question to gdal-dev mailing list about this issue.
answered Aug 17 '18 at 13:42
user30184user30184
30.1k23158
Thanks you for your effort! The corresponding GDAL-DEV-thread can be found here: lists.osgeo.org/pipermail/gdal-dev/2018-August/048958.html
– knutella
Aug 22 '18 at 18:43
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "79"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f292942%2fgdal-ogr2ogr-oraclespatial-to-shape-multipolygons-with-wholes-multiparts-are-mi%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I can only confirm the issue by running this ogrinfo command:
ogrinfo OCI:user/password@database -sql "select MDSYS.SDO_GEOMETRY(4007,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1005,5,1,2,1,5,2,1,9,2,1,13,2,1,17,2,1,25,1005,5,25,2,1,29,2,1,33,2,1,37,2,1,41,2,1),MDSYS.SDO_ORDINATE_ARRAY(33433109.145,5711835.706,9999.9999,0,33433166.721,5711687.09,9999.9999,0,33433229.435,5711904.544,9999.9999,0,33433205.628,5711904.647,9999.9999,0,33433175.618,5711821.022,9999.9999,0,33433109.145,5711835.706,9999.9999,0,33433020.391,5711673.812,9999.9999,0,33433153.215,5711635.136,9999.9999,0,33433164.011,5711674.531,9999.9999,0,33433099.673,5711838.076,9999.9999,0,33433071.502,5711844.871,9999.9999,0,33433020.391,5711673.812,9999.9999,0)) as geom from dual"
The result is MULTIPOLYGON EMPTY.
Perhaps you would like to send a question to gdal-dev mailing list about this issue.
answered Aug 17 '18 at 13:42
user30184user30184
30.1k23158
Thanks you for your effort! The corresponding GDAL-DEV-thread can be found here: lists.osgeo.org/pipermail/gdal-dev/2018-August/048958.html
– knutella
Aug 22 '18 at 18:43
add a comment |
I can only confirm the issue by running this ogrinfo command:
ogrinfo OCI:user/password@database -sql "select MDSYS.SDO_GEOMETRY(4007,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1005,5,1,2,1,5,2,1,9,2,1,13,2,1,17,2,1,25,1005,5,25,2,1,29,2,1,33,2,1,37,2,1,41,2,1),MDSYS.SDO_ORDINATE_ARRAY(33433109.145,5711835.706,9999.9999,0,33433166.721,5711687.09,9999.9999,0,33433229.435,5711904.544,9999.9999,0,33433205.628,5711904.647,9999.9999,0,33433175.618,5711821.022,9999.9999,0,33433109.145,5711835.706,9999.9999,0,33433020.391,5711673.812,9999.9999,0,33433153.215,5711635.136,9999.9999,0,33433164.011,5711674.531,9999.9999,0,33433099.673,5711838.076,9999.9999,0,33433071.502,5711844.871,9999.9999,0,33433020.391,5711673.812,9999.9999,0)) as geom from dual"
The result is MULTIPOLYGON EMPTY.
Perhaps you would like to send a question to gdal-dev mailing list about this issue.
answered Aug 17 '18 at 13:42
user30184user30184
30.1k23158
Thanks you for your effort! The corresponding GDAL-DEV-thread can be found here: lists.osgeo.org/pipermail/gdal-dev/2018-August/048958.html
– knutella
Aug 22 '18 at 18:43
add a comment |
I can only confirm the issue by running this ogrinfo command:
ogrinfo OCI:user/password@database -sql "select MDSYS.SDO_GEOMETRY(4007,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1005,5,1,2,1,5,2,1,9,2,1,13,2,1,17,2,1,25,1005,5,25,2,1,29,2,1,33,2,1,37,2,1,41,2,1),MDSYS.SDO_ORDINATE_ARRAY(33433109.145,5711835.706,9999.9999,0,33433166.721,5711687.09,9999.9999,0,33433229.435,5711904.544,9999.9999,0,33433205.628,5711904.647,9999.9999,0,33433175.618,5711821.022,9999.9999,0,33433109.145,5711835.706,9999.9999,0,33433020.391,5711673.812,9999.9999,0,33433153.215,5711635.136,9999.9999,0,33433164.011,5711674.531,9999.9999,0,33433099.673,5711838.076,9999.9999,0,33433071.502,5711844.871,9999.9999,0,33433020.391,5711673.812,9999.9999,0)) as geom from dual"
The result is MULTIPOLYGON EMPTY.
Perhaps you would like to send a question to gdal-dev mailing list about this issue.
answered Aug 17 '18 at 13:42
user30184user30184
30.1k23158
I can only confirm the issue by running this ogrinfo command:
ogrinfo OCI:user/password@database -sql "select MDSYS.SDO_GEOMETRY(4007,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1005,5,1,2,1,5,2,1,9,2,1,13,2,1,17,2,1,25,1005,5,25,2,1,29,2,1,33,2,1,37,2,1,41,2,1),MDSYS.SDO_ORDINATE_ARRAY(33433109.145,5711835.706,9999.9999,0,33433166.721,5711687.09,9999.9999,0,33433229.435,5711904.544,9999.9999,0,33433205.628,5711904.647,9999.9999,0,33433175.618,5711821.022,9999.9999,0,33433109.145,5711835.706,9999.9999,0,33433020.391,5711673.812,9999.9999,0,33433153.215,5711635.136,9999.9999,0,33433164.011,5711674.531,9999.9999,0,33433099.673,5711838.076,9999.9999,0,33433071.502,5711844.871,9999.9999,0,33433020.391,5711673.812,9999.9999,0)) as geom from dual"
The result is MULTIPOLYGON EMPTY.
Perhaps you would like to send a question to gdal-dev mailing list about this issue.
answered Aug 17 '18 at 13:42
user30184user30184
30.1k23158
answered Aug 17 '18 at 13:42
user30184user30184
30.1k23158
answered Aug 17 '18 at 13:42
user30184user30184
30.1k23158
answered Aug 17 '18 at 13:42
user30184user30184
30.1k23158
30.1k23158
Thanks you for your effort! The corresponding GDAL-DEV-thread can be found here: lists.osgeo.org/pipermail/gdal-dev/2018-August/048958.html
– knutella
Aug 22 '18 at 18:43
add a comment |
Thanks you for your effort! The corresponding GDAL-DEV-thread can be found here: lists.osgeo.org/pipermail/gdal-dev/2018-August/048958.html
– knutella
Aug 22 '18 at 18:43
Thanks you for your effort! The corresponding GDAL-DEV-thread can be found here: lists.osgeo.org/pipermail/gdal-dev/2018-August/048958.html
– knutella
Aug 22 '18 at 18:43
Thanks you for your effort! The corresponding GDAL-DEV-thread can be found here: lists.osgeo.org/pipermail/gdal-dev/2018-August/048958.html
– knutella
Aug 22 '18 at 18:43
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f292942%2fgdal-ogr2ogr-oraclespatial-to-shape-multipolygons-with-wholes-multiparts-are-mi%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Could you try to cast the polygons into 3D or 2D with the SQL parameter?
– user30184
Aug 16 '18 at 6:18
Thx, but I did not find any oracle-sql to cast 'on-the-fly' within a select statement. Also, regarding to role-management I am not able to create views, functions or modify table data directly. I tried the QGIS-loader (3.2.0) now, which seems to have a problem with the missing SRIDof the Oracle-geom-colums. It does not accept a NULL-value.
– knutella
Aug 16 '18 at 9:11
Oh, it probably is very complicated with oracle, see for example this spatialdbadvisor.com/oracle_spatial_tips_tricks/348/…. Could you add one such SDO_GEOMETRY as text into your question?
– user30184
Aug 16 '18 at 9:18
Added as Edit 1
– knutella
Aug 16 '18 at 9:57
For the sake of completeness: With Oracles { sdo_cs.make_2d() } -function flatening of 3D geometries into 2D works on the fly. For 4D it has to be used twice. Sadly ogr/GDAL couldn't deal with that either.
– knutella
Aug 17 '18 at 13:17