multiple SRIDs

[Greg]

Hi - I cannot open a postGIS layer with ZigGIS. It is giving me the
error:

'This table is not usable as a zigLayer:
View has multiple SRIDs and cannot be used.'

Incidentally, the postGIS layer opens ok in QGIS.

Any advice would be greatly appreciated,

Greg

[Bill Dollins]

PostGIS allows multiple SRIDs in a table (as per the OGC Simple Features
Specification) but ArcGIS does not support this so, therefore, neither does
zigGIS. You will need to ensure a single SRID per table/view.

Bill

[Greg]

Thanks Bill. All geometry features entered into my postGIS/postgresql
table have the same SRID. I guess it's a problem on the db side that
I'll have to explore.

[Obe, Regina]

Greg,

Did you verify this is the case by running a query on your table in question something of the form

SELECT ST_SRID(the_geom) As thesrid, COUNT(*)
FROM sometable
GROUP BY ST_SRID(the_geom)

Also make sure its registered correctly in geometry_columns table.

Hope that helps,
Regina

---

The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.

---

Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper.

[Bill Dollins]

BTW, Regina, congrats on the forthcoming book.

 

 

Bill Dollins
Zekiah Technologies, Inc.
o:  301.392.3788 x23   m:  240.298.3807   f:  301.392.3789