Hi Jukka,
thank you very much for your help!
Now it works for me.
But I receive two rows with
GEOMETRYCOLLECTION EMPTY information
in the OJ layer in my example.
This selection produces empty geometries
because it intersects only one of three geometries.
Is it possible to check if the geometry is empty
and put it not to the OJ layer?
Uwe
Am 10.04.2013 15:25, schrieb Rahkonen Jukka:
> Uwe Dalluege wrote:
>>
>> Hi Jukka,
>>
>> thank you for this example.
>> Do you know whether this works? :
>>
>> select st_intersection ( geometry, ${fence:0} ) from "Bauernhof"
>>
>> The table "Bauernhof" contains a geometry-column called "geometry"
>>
> It works so that the resulting SQL for me looks like
> select ST_Intersection(geoloc,ST_GeomFromText('POLYGON ((3424728.225608409
> 6715639.342894198, 3424728.225608409 6715738.683124313, 3424855.5848777858
> 6715738.683124313, 3424855.5848777858 6715639.342894198, 3424728.225608409
> 6715639.342894198))',-1)) from test_table;
>
> You can see that the rectangular geometry of the fence itself, not any
> features inside it, is placed into the query. The number after ":" is SRID, I
> used -1 in my case. The query itself gives an error when I tested it directly
> with PSQL "found non-noded intersection between...". OpenJUMP naturally
> cannot get a result and it is also unable to show any reasonable error
> message, just a general java.sql.SQLException.
>
> -Jukka-
>
>> Inside the fence there is a polygon
>> intersects the geometry from "Bauernhof"
>> But this does not work.
>>
>> 1. I do not see an error message.
>> 2. What is the 0 after fence: ?
>>
>> Regards
>>
>> uwe
>>
>> Am 10.04.2013 11:40, schrieb Rahkonen Jukka:
>>> Hi,
>>>
>>> They are helper shortcuts for adding a spatial filter into the query.
>>> The result will be something like select * from my_layer where geoloc
>>> && ${view:4326}
>>>
>>> Thus only features intersecting the view, box drawn with the fence tool or
>> total extents of the selected features will be selected.
>>>
>>> -Jukka Rahkonen-
>>>
>>> Uwe Dalluege wrote:
>>>
>>>> Hi,
>>>>
>>>> I like to describe the
>>>> function "Run Datastore Query" in my
>>>> PostGIS tutorial but I can not find
>>>> a desciption of this.
>>>> What are the buttons
>>>> "View, Fence and Selection" good for?
>>>>
>>>>
>>>> Regards
>>>>
>>>> Uwe
>>>>
>>>> ---------------------------------------------------------------------
>>>> --------- Precog is a next-generation analytics platform capable of
>>>> advanced analytics on semi-structured data. The platform includes
>>>> APIs for building apps and a phenomenal toolset for data science.
>>>> Developers can use our toolset for easy data analysis &
>>>> visualization. Get a free account!
>>>> http://www2.precog.com/precogplatform/slashdotnewsletter
>>>> _______________________________________________
>>>> Jump-pilot-devel mailing list
>>>> Jump-pilot-devel@lists.sourceforge.net
>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>>>
>>> ----------------------------------------------------------------------
>>> -------- Precog is a next-generation analytics platform capable of
>>> advanced analytics on semi-structured data. The platform includes APIs
>>> for building apps and a phenomenal toolset for data science.
>>> Developers can use our toolset for easy data analysis & visualization.
>>> Get a free account!
>>> http://www2.precog.com/precogplatform/slashdotnewsletter
>>> _______________________________________________
>>> Jump-pilot-devel mailing list
>>> Jump-pilot-devel@lists.sourceforge.net
>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>>>
>
> ------------------------------------------------------------------------------
> Precog is a next-generation analytics platform capable of advanced
> analytics on semi-structured data. The platform includes APIs for building
> apps and a phenomenal toolset for data science. Developers can use
> our toolset for easy data analysis & visualization. Get a free account!
> http://www2.precog.com/precogplatform/slashdotnewsletter
> _______________________________________________
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>
------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
