[postgis-users] Mapserver with postgis, sql query error.

[Nicolas ( cse )]

Hi,
I'm a newby with this.

I have a shape file that I upload to postGis Database, with the windows
program "postgis and dbf loader".
Then I create a test with MS4W environment.

I setup a LOG in the map file.
And the error y following:

*<code>*
[Sat Jul 30 01:45:34 2011].750000 CGI Request 1 on process 4620
[Sat Jul 30 01:45:34 2011].750000 msDrawMap(): WMS/WFS set-up and query,
0.000s
[Sat Jul 30 01:45:34 2011].906000 msPostGISLayerWhichShapes(): Query error.
Error (ERROR:  geometry requires more points
) executing query: select
encode(AsBinary(force_collection(force_2d("the_geom")),'NDR'),'hex') as
geom,"gid" from t_parcelas where the_geom &&
GeomFromText('POLYGON((5600615.254754 5725111.70807103,5600615.254754
5739818.70784397,5620240.983548 5739818.70784397,5620240.983548
5725111.70807103,5600615.254754
5725111.70807103))',find_srid('','t_parcelas','the_geom'))
[Sat Jul 30 01:45:34 2011].906000 msDrawMap(): Image handling error. Failed
to draw layer named 'Parcelas'.
[Sat Jul 30 01:45:34 2011].906000 msFreeMap(): freeing map at 01DBAD80.

*</code>*

This is the layer section in the map file
*<map>*
...
 LAYER # States polygon layer begins here
    NAME         Parcelas
    CONNECTIONTYPE postgis
    CONNECTION "user=postgres password=postgres dbname=muni_gis"
    DATA "the_geom from t_parcelas"
    STATUS       DEFAULT
    TYPE         POLYGON

    PROJECTION
      "init=epsg:4221"
    END

  END # States polygon layer ends here

*</map>*

The table is populated, everything looks fine, but I can't see any map.


Then I enter the SQl Query in the SQL Window of pgAdmin III, and start to
rewrite this sql query:

select encode(AsBinary(force_collection(force_2d("the_geom")),'NDR'),'hex')
as geom,"gid" from t_parcelas where the_geom &&
GeomFromText('POLYGON((5600615.254754 5725111.70807103,5600615.254754
5739818.70784397,5620240.983548 5739818.70784397,5620240.983548
5725111.70807103,5600615.254754
5725111.70807103))',find_srid('','t_parcelas','the_geom'))
With thi error:
ERROR:  geometry requires more points

********** Error **********

ERROR: geometry requires more points
SQL state: XX000


If I extract function AsBinary, there is no error:
Total query runtime: 9625 ms.
67354 rows retrieved.


Here is my question:
1) How to check if the data is correct ?
2) do I have lo load data with shp2pgsql command line utility?
3) any idea ?

Best Regards.
Nicolas
-- 

_______________
.:Nicolás Machado
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110730/92cb80d3/attachment.html>