yes, i tried that also but it didn't worked until and without adding option -skipfailures.<br>Now command<br> ogr2ogr -nlt POINT -skipfailures<span style="font-weight: bold;"> </span> -f PostgreSQL PG:dbname=mydb /home/prince/mainfo_dgn/44g1
<br>works.<br>but this way i can produce shape file and correspondent entry in Postgis for element of type POINT only. For geometry type LINESTRING , POLYGOM, MULTILINE, MULTIPOLYGON etc i have run this command separately which resulted in several shape files and several table creation in databse for same map.
<br>Is this way i have to live with it. I also don't know whether dgn file i am holding is of version 7 or 8. Also while using this qgis ( i havenot noiced exact steps) a warning ,multiple times, occurs which results in seg fault sometimes.
<br>" Warning: This code (file qgsVectorLayer.cpp, line 1260) should never be reached, problem may occur."<br><br>thanks<br>quick nitin<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
</blockquote><br><br><div><span class="gmail_quote">On 6/23/06, <b class="gmail_sendername">Gary Sherman</b> <<a href="mailto:sherman@mrcc.com">sherman@mrcc.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
nitin quick wrote:<br>> i tried this also but not of use.<br>> here is some of the commands which i tried and corresponding output<br>> which i got.<br>><br>> ogr2ogr -nlt POINT -f PostgreSQL PG:dbname=mydb
<br>> /home/prince/mainfo_dgn/44g1.dgn<br>> ERROR 1: INSERT command for new feature failed.<br>> ERROR: new row for relation "elements" violates check constraint<br>> "enforce_geotype_wkb_geometry"
<br>><br>> Command: INSERT INTO "elements" (wkb_geometry , "type", "level",<br>> "graphicgroup", "colorindex", "weight", "style") VALUES<br>> (GeomFromEWKT('SRID=-1;LINESTRING (-
0.055 -0.025,0.055 -0.025)'::TEXT)<br>> , 3, 27, 0, 3, 2, 0)<br>> ERROR 1: Terminating translation prematurely after failed<br>> translation of layer elements<br>Notice that your INSERT statement is attempting to create a feature of
<br>type LINESTRING.<br><br>Did you try using -nlt LINESTRING?<br><br><br>--<br>-gary<br><br>-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-<br>Gary Sherman<br>Micro Resources: <a href="http://mrcc.com">http://mrcc.com</a><br> *Geospatial Hosting
<br> *Web Site Hosting<br>"We work virtually everywhere"<br>-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-_-<br></blockquote></div><br>