[postgis-users] help with Microstation DGN data to PostGIS

Paul Ramsey pramsey@refractions.net
Wed Jul 9 16:28:18 2003


Since you have ArcView, and you have found that it does the 
conversion you need, I would suggest a little Avenue scripting in ArcView to 
do the repetitive conversions.

Yours,
Paul

Quoting ejansson@COLLEGES.ORG:

> 
> I've been been trying to load a number of files in Microstation DGN format
> into
> PostGIS, and was hoping someone here had some experience doing this.  I've
> been
> using the ogr2ogr utility to do this:
> 
>     ogr2ogr -lco LAUNDER=YES -f "PostgreSQL" PG:dbname=testdb 
D4d10.97.1.dgn
> 
> ..but have found that the attribute data attached to my shapes is not 
being
> loaded into the database.  I have also tried using the ogr2ogr utility to
> create
> shapefiles, and then use shp2pgsql to get that data into PostGIS:
> 
>     ogr2ogr -skipfailures -nln D4d10.97.1_polygon -skipfailures -lco
> SHPT=POLYGON -f "ESRI Shapefile" D4d10.97.1/ D4d10.97.1.dgn
> 
> ..which works, excepth that, again, the attribute data does not appear: 
the
> SHP
> file has all the geometry data, but the DBF file is empty.  When I use
> ArcView
> and do a manual "Convert to Shapefile..." all the attribute data converts
> fine.
>  The problem is, I have several hundred of these files to convert.
> 
> Sorry if this is a peripheral topic to this list--I realize most users are
> probably most concerned with shapefiles and not DGNs.  Thanks in advance 
for
> any
> help.
> 
> Eric Jansson
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>