Hi,
It may be qgis (version 1.5) problem during export of shapefile. last year i
face the same problem, but now we are using mapviewer to load into oracle
tables. It automatically gives multipolygon in the geometry list and we were
editing that geometry type manually in SPIT plugin of qgis.
Note: It happens often, but not every time, as per my observation.
Regards,
Hari.
On Sat, Jun 18, 2011 at 4:39 PM, Andrea Aime
<[email protected]>wrote:
> 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
>
> -------------------------------------------------------
>
>
> ------------------------------------------------------------------------------
> 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
>
>
------------------------------------------------------------------------------
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
