Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

This is a three-dimensional shape file, I checked in ARCGIS, where the shape attribute indicates POINT ZM, This is the table

fid        0 
shape*     point ZM
atribut1   A
atribut2      B
ESTE      500
NORTE      1000 

and when exporting to postgis from QGIS indicated in the item "CLASS OF SPACE" NULL and the following error :

"Problemas al insertar objetos espaciales del archivo: D:/gegrafo/BORRARç/COTACACHIa_Merge.shp

La base de datos dio un error mientras ejecutaba esta SQL:

SELECT AddGeometryColumn('public','COTACACHIa_Merge','the_geom',-1,'NULL',2)
El error fue:
ERROR:  Invalid type name - valid ones are:
    POINT, MULTIPOINT,
    LINESTRING, MULTILINESTRING,
    POLYGON, MULTIPOLYGON,
    CIRCULARSTRING, COMPOUNDCURVE, MULTICURVE,
    CURVEPOLYGON, MULTISURFACE,
    GEOMETRY, GEOMETRYCOLLECTION,
    POINTM, MULTIPOINTM,
    LINESTRINGM, MULTILINESTRINGM,
    POLYGONM, MULTIPOLYGONM,
    CIRCULARSTRINGM, COMPOUNDCURVEM, MULTICURVEM
    CURVEPOLYGONM, MULTISURFACEM,
    or GEOMETRYCOLLECTIONM
CONTEXT:  SQL statement "SELECT AddGeometryColumn('',$1,$2,$3,$4,$5,$6)"
función PL/pgSQL «addgeometrycolumn» en la línea 4 en sentencia SQL"
share|improve this question
    
puede llegar a más personas con la traducción que usted pregunta sobre traductor Google –  geogeek Jul 16 '12 at 19:30
    
for eg your question will be "When transforming a 3D shape to postgis archico is depliega a mistake, maybe know if QGIS does not support such exports. thanks vparra" –  geogeek Jul 16 '12 at 19:30
2  
FWIW, I suspect "archico" may be a typo for "archivo," suggesting the OP is referring to an "archived" or old shapefile. Vic: que exactamente es el error que se ocurre? –  whuber Jul 16 '12 at 20:18
add comment

1 Answer 1

I am experienced in postgis but not familiar with Qgis.

in Postgis I think PointZm could be handled with a point4d but it does not seem that you have point4d on your version of postgis.

Anyway the problem seems to be with the export, it looks like the export from Qgis to PostGis does not find a match for pointZM.

A simple trick can be to convert to PointZ or PointM if that is ok for you.

best regards,

Joaquim Muchaxo.

share|improve this answer
    
Thank you very much with GVSIG I have no problem that the file is exported without difficulty apparently the problem is with QGIS –  vic Jul 16 '12 at 22:13
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.