Hi Michaël,
Thank you for the feedback.
I've tested the NB 2894 and it is *almost* working with PostGIS 2.0.
There are one SELECT AsEwkb("wkb_geometry") as wkb_geometry that's need
to be fixed. Besides that, it is working (I've created an alias in the
back end to allow further testing).
The query against the database is something like:
SELECT AsEwkb("wkb_geometry") as wkb_geometry,
"extrahorario2","extrahorario1","extra","horario2","horario1","fax","telefone",
"codpostal","localidade","morada","nome","url","longitude","latitude","ogc_fid"
FROM "mcdonalds" t WHERE "wkb_geometry" &&
ST_SetSRID('BOX3D(-114173.109375 -294290.625,73236.2734375
230567.109375)'::box3d,3763)
By the way (sorry for the ignorance!), OpenJUMP is not able to commit
edits back to the database, is it? I've tried that, but it suggests to
save it as another layer.
Anyway, please confirm that one AsEwkb is still around.
Thanks in advance,
Jorge
Em 09-05-2012 21:19, Michaël Michaud escreveu:
> Hi Jorge,
>
>> My name is Jorge and I'm starting to use OpenJUMP. A big thank you for
>> those who have developed it.
>>
>> I've noticed that OJ 1.5.1 is unable to open PostGIS 2.0 tables, and the
>> issue already have being discussed here, in the mailing list, by Jukka
>> and Michaël.
>>
>> Michaël probably already fixed the problem, but the solution is not
>> included in the nightly build.
>>
>> OJ uses the function to calculate the table extent:
>> CREATE OR REPLACE FUNCTION find_extent(text1, text2) RETURNS box2d AS
>> It works in PostGIS 1.5.x.
> Thanks, this is a place where I forgot to update postgis functions.
>
>> But we might change it to something like:
>> SELECT ST_Extent(text2) from text1
> I just changed extent computation that way
> (this code is executed if ST_Estimated_Extent fails, as estimation
> should be way faster than ST_Extent which does a complete scan)
>>
>> Both return a 2D BOX type.
>>
>> I'm available to help.
> Thanks, you're welcome to try extensively next NB (2894+)
> before I merge the change in 1.5.2 stable release,
> I only tested it with an old postgis 1.4 installation.
>
> Michaël
>>
>> Regards,
>>
>> Jorge
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Jump-pilot-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
--
Jorge Gustavo Rocha
Departamento de Informática
Universidade do Minho
4710-057 Braga
Tel: +351 253604480
Fax: +351 253604471
Móvel: +351 910333888
skype: nabocudnosor
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Jump-pilot-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
