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 th
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 5739818.707843
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 eit
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
> On Sat, Jul 30, 2011 at 03:07:56PM -0300, Nicolas ( cse ) wrote:
>
> >
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 t
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, how
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 l
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 )
w
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:
**
[Sat Jul 30 01:45:34 2011].75 CGI Request 1 on process
