PostGIS editing using AutoCAD Map

[agmartin]

Hi,

I am a user of LocalGIS, a Spanish GIS that works with a PostGIS database.

My objective is to edit the layers stored in PostGIS directly using the AutoCAD Map. The problem is that after adding a new feature (POINT) in AutoCAD, I try to open the layer in my GIS and I get an error. I think that something is missing in the way I am doing this cause the GEOMETRY column in the PostGIS table is filled with a WKB format string and the one created in AutocadMAP is so different from the ones previously stored in the database.

 
I explain the steps I am following just in case something is missing or wrong.

1. The PostGIS database table is as follows before starting the process (check the GEOMETRY column):
https://www.dropbox.com/s/8jrdouv4anpccm7/1.%20wkb%20tabla%20POSTGIS%20inicial.bmp

2. I load my layer in AutoCAD Map (getxo_semaforo_puntos). I define the layer as the coordinate system UTM30-ED50 which is the coordinate system I use for all my layers:
https://www.dropbox.com/s/6d9rvpvotb0pjxc/2.%20carga%20en%20AutoCad%20Map%202012.bmp

3.I add a new point by clicking on "New Feature-->Point"
https://www.dropbox.com/s/j2y8spdvtndb9j7/3.%20Insertar%20nuevo%20punto%20%2B%20check-in.bmp

4. After clicking on the "check-in" button to store the changes in the PostGIS database, the GEOMETRY stored for the new registry is quite different from the previous points. In fact, the digits from 3rd to 10th (8 digits) stand for the GEOMETRY type of the feature stored (point,linestring,polygon,multipolygon, geometry collection...) and  00000002 (POINT) is stored for all the features previously in the database and in this case it is stored as 00000008, which I don’t exactly know what it is.
https://www.dropbox.com/s/w4lof8l5mv7tq6n/4.%20wkb%20tabla%20POSTGIS%20despues.bmp

5. After I try to open this layer in my GIS I get an error (it doesn’t understand the new GEOMETRY). Even after changing the 00000008 by 000000002 I get the error, so this is not the problem I guess.
https://www.dropbox.com/s/3o38dqdp4vokkn6/5.%20error%20localgis.bmp

I don’t know what could be happening but I really need to get this PostGIS edition from AutoCAD!

Regards,
Aitor

[agmartin]

Problem solved.

The thing is that when creating a new feature from Autocad MAP the EWKB generated in the GEOMETRY column of the postgis table has the SRID=-1 where all the other objects had SRID=23030. When reading the data from my GIS in the select query i called ST_GeomFromWKB("table"."GEOMETRY", 23030) function and everything worked!

Thanks!