thanks Bo victor Thomsen I have tried this query and was able to add different types of geometries into my postgis however the geometry column of every tables reads as wkb_geometry geometry(MultiLineString,900914),
can anyone explain to me that what does this means, a normal geometry table only has only this argument wkb_geometry geometry, best Ibad Raza On Thu, Sep 5, 2013 at 2:49 AM, Bo Victor Thomsen < [email protected]> wrote: > Ibad - > > The problem is that MapInfo tab files can contain several types of > geometry object all mixed together - lines, polygons, points ... in a > single file. This is not allowed in Postgis tables used by QGIS. > You have to split your "multi-type" tab file into several postgis tables, > where each table only contains one type of geoobject > > Try the following on a command line (in windows): > > *for %a in (multilinestring multipolygon linestring polygon point > multipoint none) do ogr2ogr -where "OGR_GEOMETRY='%a'" -f "PostgreSQL" > PG:"host=**myserver**** user=**myuser**** dbname=**mydatabase****password= > **mypassword****" -nlt %a -nln **tablename****_%a **mytabfile.tab* > > - Replace italic text as needed > - If the commandline is put into a .cmd file: Replace every occurence of > %a with %%a > > The command will create 7 new layers for each tabfile. Each new table will > only contain one type of object (Depending on the contents of the tabfile, > some or most of the tables will be empty) > > Regards > Bo Victor Thomsen > Aestas-GIS > Denmark > > > Den 04-09-2013 21:03, ibad raza skrev: > > hello list > > I am trying to add a mapinfo file to postgis > I have tried the fwtool ogr2ogr function > but the problem is that everytime I add the file, some records are missing > these are the records with no geometry which do not get added in the final > table > > > can anyone tell me that firstlly how can I add the rows without geometry > in the table as well. > > and is there another easy way to get mapinfo file into postgis > > Thanks > Ibad Raza > > > _______________________________________________ > Qgis-user mailing > [email protected]http://lists.osgeo.org/mailman/listinfo/qgis-user > > > > _______________________________________________ > Qgis-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user >
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
