Postgis Polygon

[Vladimir Guzmán]

Thankyou, Peter.
I'm sure, because I have a record in the spatial_ref_sys, with an id 1.
The strange thing is that it works with MULTIPOLYGON, but it doesn't
work with POLYGON.
Any ideas?

Thanks a lot,

Vladimir Ilich Guzmán R.
------------------------
http://maintask.com



Peter Bayley wrote:

> Are you sure you don't mean "SRID= -1" - in other words, no
> projection.  There is no SRID=1 in spatial_ref_sys
>
> Peter
>
> Vladimir Guzmán wrote:
>
>> Hello, list.
>>
>> I'm trying to draw a polygon layer with postgis in mapserver, but the
>> map is empty.
>> Here is the DATA section:
>> --------
>> DATA "the_geom from (select GeomFromText('POLYGON((-74.14840698
>> 4.56912851,-74.03168487 4.75130367, -74.14840698 4.75130367,
>> -74.14840698 4.56912851))',1) as the_geom,1 as oid) as data using unique
>> oid using srid=1"
>> --------
>> If I change it to:
>> --------
>> DATA "the_geom from (select GeomFromText('MULTIPOLYGON(((-74.14840698
>> 4.56912851,-74.03168487 4.75130367, -74.14840698 4.75130367,
>> -74.14840698 4.56912851)))',1) as the_geom,1 as oid) as data using
>> unique oid using srid=1"
>> --------
>> the map is displayed correctly.
>>
>> Anyone knows why is this?
>> The problem is that when I import a map with ogr2ogr, the geometries are
>> inserted as POLYGON instead of MULTIPOLYGON.
>>
>> Thanks a lot,
>>
>> --
>> Vladimir Ilich Guzmán R.
>> ------------------------
>> http://maintask.com
>>