AutoCAD Map 3D Forum
Welcome to Autodesk’s AutoCAD Map 3D Forums. Share your knowledge, ask questions, and explore popular AutoCAD Map 3D topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

MAP5 Oracle Spatial advanced extension vs shp2sdo & geomedia

6 REPLIES 6
Reply
Message 1 of 7
luc_vanlinden
379 Views, 6 Replies

MAP5 Oracle Spatial advanced extension vs shp2sdo & geomedia

HEllo

We're testing the Advanced Oracle Extension for map5.
We're testing it for populating our basemaps (arcview SHP) into Oracle Spatial, and trying to use them in MAP5 and Geomedia.

1. when using the shp2sdo from Oracle, we can only use the data in Geomedia, because Map5 uses only data from Oracle Spatial via its own metadata use and definition.

2. so, if we first import the shp file into MAP5, define the feature table via the MAPOSEADMIN, and use the Advanced extension for exporting, then the data can't be used in Geomedia for a reason we cannot detect, although we 're checking all the related tables.

Question
1. Is map5 using the SDO somehow different as it should be used?
2. Has anyone used SDO data (created via map5) in other GIS softwares (as fe Geomedia)?
3. How can Existing SDO data (created via SHP2SDO) in map5 used via the advanced extension?

tx

Luc
6 REPLIES 6
Message 2 of 7
Anonymous
in reply to: luc_vanlinden

Not a solution but a question?  Have you tried
creating Oracle views on the 'raw' table data that reflect the required formats
of the Map 5 AOE or geomedia?  There is a similar views thread in the other
Map 5 newsgroup.

 

 Crispin


 


style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
HEllo

We're testing the Advanced Oracle Extension for map5.
We're testing it
for populating our basemaps (arcview SHP) into Oracle Spatial, and trying to
use them in MAP5 and Geomedia.

1. when using the shp2sdo from Oracle, we can only use the data in
Geomedia, because Map5 uses only data from Oracle Spatial via its own metadata
use and definition.

2. so, if we first import the shp file into MAP5, define the feature table
via the MAPOSEADMIN, and use the Advanced extension for exporting, then the
data can't be used in Geomedia for a reason we cannot detect, although we 're
checking all the related tables.

Question
1. Is map5 using the SDO somehow different as it should be
used?
2. Has anyone used SDO data (created via map5) in other GIS
softwares (as fe Geomedia)?
3. How can Existing SDO data (created via
SHP2SDO) in map5 used via the advanced extension?

tx

Luc

Message 3 of 7
Anonymous
in reply to: luc_vanlinden

Hi Luc

Both Geomedia and Map(and for that matter other systems) will want their own
fields to interpret the data and do things like colours etc. What I would
recommend is

Load the data with Map and look at the structure. Then load with Geomedia
and look at the structure. You have to make sure your geometry structures
are the same

MAke sure you are using the latest versions of Oracle (preferably 9, but
8.17 at least) and Geomedia. SHP2SDO will create the data in a readable
format in terms of geometry, but not in terms of other attributes that
Autocad needs


--
Johan Nel
Open Spatial Technologies
www.openspatial.com.au


"luc_vanlinden" wrote in message
news:f100f7d.-1@WebX.maYIadrTaRb...
HEllo
We're testing the Advanced Oracle Extension for map5.
We're testing it for populating our basemaps (arcview SHP) into Oracle
Spatial, and trying to use them in MAP5 and Geomedia.
1. when using the shp2sdo from Oracle, we can only use the data in Geomedia,
because Map5 uses only data from Oracle Spatial via its own metadata use and
definition.
2. so, if we first import the shp file into MAP5, define the feature table
via the MAPOSEADMIN, and use the Advanced extension for exporting, then the
data can't be used in Geomedia for a reason we cannot detect, although we
're checking all the related tables.
Question
1. Is map5 using the SDO somehow different as it should be used?
2. Has anyone used SDO data (created via map5) in other GIS softwares (as fe
Geomedia)?
3. How can Existing SDO data (created via SHP2SDO) in map5 used via the
advanced extension?
tx
Luc
Message 4 of 7

Tx Johan for your reply...In the mean time I did some more research...Map adds to the geometry tables some additional fields as you mentioned...two of them are the ADMPBLOCKSCALE & ADMPNORMAL...
They both have as datatype SDO_POINT_TYPE (in the MDSYS schema)...
When dropping these columns, the data can be used within Geomedia...Why, I haven't found out yet...I'm also runnning a request at Interg.
My guess is that maybe Geomedia has a problem when there are more than one column of a datatype 'geometry'...
tx
Luc
Message 5 of 7
Anonymous
in reply to: luc_vanlinden

Yes, Geomedia (and ArcSDE) do not like
SDO_POINT_TYPE data types.

 

Cheers,

David


style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
Tx
Johan for your reply...In the mean time I did some more research...Map adds to
the geometry tables some additional fields as you mentioned...two of them are
the ADMPBLOCKSCALE & ADMPNORMAL...
They both have as datatype
SDO_POINT_TYPE (in the MDSYS schema)...
When dropping these columns, the
data can be used within Geomedia...Why, I haven't found out yet...I'm also
runnning a request at Interg.
My guess is that maybe Geomedia has a
problem when there are more than one column of a datatype 'geometry'...
tx

Luc
Message 6 of 7

I've received the confirmation from Interg that Geomedia only support SDO_Geometry as datatype. It can not handle any another 'spatial' datatypes nor datatypes from subelements from SDO.

Also Geomedia can't handle Views (tx for the suggestion, Crispin).

Apparently SDO datatypes aren't supported in the context of 'Snapshots'...

and since map definitly can't miss it's ADMPBLOCKSCALE & ADMPNORMAL fields, I probably need tocreate two featrure tables: one for and via MAP, the other for Geomedia...great;-(

tx

Luc
Message 7 of 7

After all, Geomedia does support VIEWS, although you need to adjust Geomedia's metadata manually when working just with Geomedia (not the Pro version). When using the Pro version Interg provides a small uitlity that does the work for you...

So, make a VIEW leaving the the fields out with datatype SDO_POINT_TYPE...Update all needed metadata for Geomedia...and things are ok!

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost