El Sábado 30 Julio 2011, Nicolas ( cse ) escribió:
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
On Mon, Aug 01, 2011 at 08:43:06AM +0200, Maria Arias de Reyna wrote:
El Sábado 30 Julio 2011, Nicolas ( cse ) escribió:
..
ERROR: geometry requires more points
SQL state: XX000
If AsBinary returns
something hexadecimal, the encode function should have no problem, no matter
if the
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].75 CGI Request 1 on
Hey Nicholas,
I'm a newbie, but just to say that I've used the 'Spit' tool within
QGIS to load shapefiles into PostGIS - mght be worth a look. You can
also then load the table into QGIS once it is in the system to see if
it has stored it correctly?
James
On 30 July 2011 15:17, Nicolas ( cse )
On Sat, Jul 30, 2011 at 11:17:08AM -0300, Nicolas ( cse ) wrote:
ERROR: geometry requires more points
If I extract function AsBinary, there is no error:
...
Here is my question:
1) How to check if the data is correct ?
ST_IsValid, ST_IsValidReason, ST_IsValidDetail
2) do I have lo load
Hi Sandro, my second question, is because the firs time I load data using
the GUI interface of tha utility.
But I just loaded via command line, and I guet the same error ...
In the table I got 67811 records, the error means that ALL of them have a
problem ? or at leastone of them?
In that case,
On Sat, Jul 30, 2011 at 03:07:56PM -0300, Nicolas ( cse ) wrote:
In the table I got 67811 records, the error means that ALL of them have a
problem ? or at leastone of them?
In that case, how can I know wich one is?
Using ST_IsValid or ST_IsValidReason or ST_IsValidDetail.
Did you look at
Yes, sorry, sometimes I ask before try !
In the table was 134 records wrong ...
In other post I will be asking why is that ?
if the shape file is ok, why not the postgis table
Best Regards
2011/7/30 Sandro Santilli s...@keybit.net
On Sat, Jul 30, 2011 at 03:07:56PM -0300, Nicolas ( cse
On Sat, Jul 30, 2011 at 05:13:12PM -0300, Nicolas ( cse ) wrote:
Yes, sorry, sometimes I ask before try !
In the table was 134 records wrong ...
In other post I will be asking why is that ?
if the shape file is ok, why not the postgis table
My guess is that the shapefile is not ok