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