On Fri, Jun 10, 2011 at 11:13 AM, Angel Cervera Claudio <[email protected]> wrote: > > POLYGON
I've just tested and I cannot reproduce, if the geometry is polygon in
the database it's polygon
in GeoServer too.
What I did:
- found a shapefile that contains polygons
- imported it with -S which forces the creation of simple geometries
shp2pgsql -I -s 4269 -S bc_2m_lakes.shp bclakes
- checked in postgis it is actually polygon:
\d bclakes;
Tabella "public.bclakes"
Colonna | Tipo | Modificatori
----------+------------------+------------------------------------------------------------
gid | integer | not null preimpostato
nextval('bclakes_gid_seq'::regclass)
lakes_id | integer |
area | double precision |
the_geom | geometry |
Indici:
"bclakes_pkey" PRIMARY KEY, btree (gid)
"bclakes_the_geom_gist" gist (the_geom)
Vincoli di controllo:
"enforce_dims_the_geom" CHECK (st_ndims(the_geom) = 2)
"enforce_geotype_the_geom" CHECK (geometrytype(the_geom) =
'POLYGON'::text OR the_geom IS NULL)
"enforce_srid_the_geom" CHECK (st_srid(the_geom) = 4269)
select * from geometry_columns where f_table_name = 'bclakes';
f_table_catalog | f_table_schema | f_table_name | f_geometry_column |
coord_dimension | srid | type
-----------------+----------------+--------------+-------------------+-----------------+------+---------
| public | bclakes | the_geom |
2 | 4269 | POLYGON
select distinct(geometryType(the_geom)) from bclakes;
geometrytype
--------------
POLYGON
(1 riga)
Configured in GeoServer, the column is recognized as polygon there
too, see attached screenshot.
Checked the WFS DescribeFeatureType output, it says
PolygonPropertyType in 1.0 and
SurfacesPropertyType in 1.1
So, it works for me. Not sure why it doesn't over there, maybe
permission issues?
Cheers
Andrea
--
-------------------------------------------------------
Ing. Andrea Aime
GeoSolutions S.A.S.
Tech lead
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 962313
http://www.geo-solutions.it
http://geo-solutions.blogspot.com/
http://www.youtube.com/user/GeoSolutionsIT
http://www.linkedin.com/in/andreaaime
http://twitter.com/geowolf
-------------------------------------------------------
<<attachment: polygon-nq8.png>>
------------------------------------------------------------------------------ EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
