topic MapExport MAP3D 2018 to PostgreSQL / PostGIS in AutoCAD Map 3D Forum

MapExport MAP3D 2018 to PostgreSQL / PostGIS

Anonymous — Tue, 08 Aug 2017 12:03:30 GMT

Hi..

Please let me know how to export polygon objects to PostgreSQL database from Auto desk map3d 2018

installed PostgreSQL 9.6 and postgis 2.2 on Linux host .

i am able to connect PostgreSQL from autocad map3d 2018(installed on windows) fdo connection and able to create database in

PostgreSQL.

i didn't see the PostgreSQL fdo connection with the command " Mapexportfdo " to export polygon objects to PostgreSQL database.

please help me out with the procedure to export object to PostgreSQL.

Thanks in advance

Satish

Re: MapExport MAP3D 2018 to PostgreSQL / PostGIS

braudpat — Tue, 08 Aug 2017 12:51:30 GMT

Hello from France

Welcome to the Autodesk / AutoCAD Forums

SORRY my answer is not "very positive" !?

1) I am not sure at all that ACAD MAP 20IX is able to do a MAPEXPORTFDO to a Spatial PostGIS Database !?

2) MAP 201X is able to to do a MAPEXPORTFDO to a Spatial Oracle Database for a long time ...

https://forums.autodesk.com/t5/autocad-map-3d-forum/mapexportfdo-to-fdo-oracle-with-user-defined-srid-in-oracle/td-p/4298583

3) And maybe MAP 201X is able to do the same with MS-SQL Server Spatial Database !?

Waiting for the answer of a PostGIS and MAP 201X Specialist ??

Regards, Patrice

Re: MapExport MAP3D 2018 to PostgreSQL / PostGIS

Anonymous — Tue, 08 Aug 2017 13:07:22 GMT

Hi Satish,

I have neither PostGIS nor Map 2018 - so I'm just guessing.

You said you created a database - did you create any schema/tables (I dont know how exactly PostGres/PostGIS works)?

When you connect to PostGIS through FDO - do you see any tables?

I'm not sure - maybe the connection only appears if there are any tables.

Rob

Re: MapExport MAP3D 2018 to PostgreSQL / PostGIS

Anonymous — Tue, 08 Aug 2017 14:59:39 GMT

Hi Rob..

I don't think tables are necessary to view the connection. More over I have
Connected to a sample schema which is having few tables.
In case of oracle fdo we can create spatial schema from autocad itself and
we can see it
before creating any tables in it.
In postgresql I'm able to create spatial schema and connected to that. But
when come to export I'm not able to see that.

I tried with postgresql and postgis installed in Windows. But no luck

Thanks
Satish

Re: MapExport MAP3D 2018 to PostgreSQL / PostGIS

Anonymous — Wed, 09 Aug 2017 12:28:41 GMT

Hi,

I did a quick test with Map 2017 and PostGIS (on Linux) - I have the same issue, data connection doesnt appear in the MapexportFDO dialog box.

In Map help (2017) there is one entry for "mapexportfdo" about an issue when exporting to ArcSDE. There is also a screenshot where some information is displayed about the mapexportfdo command and it reads like: "Move drawing object data into database data stores (for example Oracle, ArcSDE, SQL Server Spatial) to which you have connected in AutoCAD Map 3D.".

So, it is not clear whether PostGIS is supported or not - I would guess it is but maybe it isn't.

To move your CAD data into PostGIS you can either:

- export your drawing data as SDF/SQLite/SHP (command: mapexport)
- connect to exported data and to PostGIS database and perform a BulkCopy

- connect to PostGIS, add tables(Layers) to drawing
- in FDO layer context menu chose "new feature from geometry" and select CAD object

Second approach is suitable only if you have few CAD objects as you need to pick each CAD object on its own.

Rob

Re: MapExport MAP3D 2018 to PostgreSQL / PostGIS

braudpat — Wed, 09 Aug 2017 14:45:23 GMT

Hello

1) This FDO command has been written for Oracle Spatial (If I remember well) !

2) Not sure that it is OK for SQL-Server Spatial ?

3) And I think it is NOK for PostGIS !

Regards, Patrice

Re: MapExport MAP3D 2018 to PostgreSQL / PostGIS

Anonymous — Thu, 10 Aug 2017 04:53:03 GMT

Patrice..

Command same for Oracle and Mssql saptial , hope it is same for all FDO Connections .

waiting for more suggestions from all experts..

Thanks

Satish

Re: MapExport MAP3D 2018 to PostgreSQL / PostGIS

kajar — Thu, 10 Aug 2017 06:15:03 GMT

Command MAPEXPORTTOFDO works only with Oracle, ArcSDE and SQL Server, for PostgreSQL/Postgis you cant use it.

This is the feature I have missed a long time and its still missing in version 2018.

So you have to use bulk copy to export featured to Postgis.

Kajar

Re: MapExport MAP3D 2018 to PostgreSQL / PostGIS

braudpat — Thu, 10 Aug 2017 06:35:11 GMT

Hello Mr Kajar

Thanks for your MAPEXPORTFDO Expertise ! So Kudos for you !!

I have used it ONLY with Oracle ... And I have not any MS-SQL / ArcSDE / PostGis Server

Regards, Patrice

Re: MapExport MAP3D 2018 to PostgreSQL / PostGIS

Anonymous — Mon, 14 Aug 2017 17:16:58 GMT

Hi..

found short-term solution with qgis , imported dxf format to postgresql. and it also allows other formats like shape , dgn etc

Thanks

Satish

Re: MapExport MAP3D 2018 to PostgreSQL / PostGIS

Anonymous — Wed, 17 Oct 2018 18:09:32 GMT

Hi Satish/All,

Can someone help the export steps to PostGIS.

Thanks,
Ravi

Re: MapExport MAP3D 2018 to PostgreSQL / PostGIS

kajar — Wed, 17 Oct 2018 19:22:49 GMT

At first you must export Autocad objects to SQLITE, SHP or SDF and then use bulk copy tool for inserting features to Postgis table.

Another option is to use Qgis.

Kajar

Re: MapExport MAP3D 2018 to PostgreSQL / PostGIS

Anonymous — Thu, 18 Oct 2018 05:10:26 GMT

Hi Kajar/All,

I can connect & read data PostGIS DB successfully. when i try to Connect to FDO, I am unable to find data sources. Please advise.

Thanks,

Ravi