[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
>