[Gvsig_english] gvSIG 1.1.2 and 1.9 (1245): Can't load postgis-layer

[Johannes Valenta]

Hi list,

after examining my postgis-layer more carefully I found out that I mixed up
Linestrings and Multilinestrings.
This probably caused all the trouble as gvSIG does not know how to handle
this mix.
Well, I am cleaning my layer...
Thanks all!

Johannes

2009/10/13 Johannes Valenta <spatialjoe at googlemail.com>

> Hi Fran, hi Vladimir,
>
> thanks for the input.
> I think Fran is right with changing the fieldname "length" to something
> else.
> I ruled out any typos and also the table name should be no problem.
> My server is not public and I will have a look at my database in the
> evening.
>  Regarding the geometry_columns table in Postgis everthing is fine.
>
> Many thanks so far,
>
> Johannes
> 2009/10/13 Vladimir Peric <vladimir.peric at beogis.com>
>
> Hi,
>>
>> I had the same problem and here is what solved the problem in my case. In
>> order GvSig to recognize the table as a layer candidate, there should exist
>> a table in PostreSQL, named *geometry_columns*. For each table in the
>> database that has a geometry column, a corresponding row in the table *
>> geometry_columns* should be present. The row in this table can be
>> manually added if needed.
>>
>> Hope this will help.
>>
>> Cheers,
>> Vladimir
>>
>>
>>
>>
>>
>> On Tue, Oct 13, 2009 at 9:22 AM, Johannes Valenta <
>> spatialjoe at googlemail.com> wrote:
>>
>>> Hi Virginia,
>>> thank you for responding. I am not able to choose the geometry column
>>> within the listbox - it just stays blank. That's the problem.
>>> What could be the reason?
>>> Best,
>>>
>>> Johannes
>>>
>>> 2009/10/13 virginia morales segura <morales_vir at gva.es>
>>>
>>> Hi Johannes,
>>>>
>>>> you must can to choose your geometry column at listbox of geometry. If
>>>> you say that you have the column type geometry, you should choose it.
>>>> Can you send us the layer that goes wrong.
>>>>
>>>> Regards.
>>>>
>>>>
>>>> Johannes Valenta escribió:
>>>>  > Hi list,
>>>> >
>>>> > today I encountered a strange phenomenon. I tried to load a
>>>> > postgis-layer into projects of both versions (1.1.2, 1.9 build1245)
>>>> > which did not work.
>>>> > In both versions the geometry column would not show up in the
>>>> > corresponding field although I registered the layer in the "geometry
>>>> > columns" table in postgis as usual.
>>>> > All other layers within my database work fine.
>>>> > These are the columns of my layer:
>>>> >   pid integer,
>>>> >   highway text,
>>>> >   tracktype text,
>>>> >   label3 text,
>>>> >   belag numeric,
>>>> >   wegbreite numeric,
>>>> >   landnutz numeric,
>>>> >   length double precision,
>>>> >   the_geom geometry,
>>>> >   summe integer,
>>>> >   pid1 serial NOT NULL
>>>> >
>>>> > Exporting the layer from postgis to shp and adding it to gvSIG works
>>>> > (so I obviously did not mess up the geometry type).
>>>> > Any ideas /hints?
>>>> >
>>>> > Best,
>>>> >
>>>> > Johannes
>>>> >
>>>> ------------------------------------------------------------------------
>>>> >
>>>> > _______________________________________________
>>>> > Gvsig_internacional mailing list
>>>> > Gvsig_internacional at listserv.gva.es
>>>> > http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>>>> >
>>>>
>>>> _______________________________________________
>>>> Gvsig_internacional mailing list
>>>> Gvsig_internacional at listserv.gva.es
>>>> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>>>>
>>>
>>>
>>> _______________________________________________
>>> Gvsig_internacional mailing list
>>> Gvsig_internacional at listserv.gva.es
>>> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>>>
>>>
>>
>>
>> --
>> Vladimir Perić
>> General Manager
>> BEOGIS d.o.o. Beograd
>> Milutina Milankovića 130/109, Novi Beograd
>>
>> mob:   +381642040889
>> tel:      +381112122810
>> mail:    vladimir.peric at beogis.com
>> skype: vlada.peric
>> site:     www.beogis.com
>>
>> _______________________________________________
>> Gvsig_internacional mailing list
>> Gvsig_internacional at listserv.gva.es
>> http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20091013/66356ed6/attachment.htm