Hi,
I think that Run Datastore Query should also stay as a general SQL tool so that
users can use exactly the same SQL in this tool, in PSQL command line or in
pgAdmin SQL window and so on. It might be nice to have a spatial SQL query
wizard with syntax highlight and help messages, menu for se
Hi Jukka,
thank you for clarification!
Uwe
Am 10.04.2013 16:08, schrieb Rahkonen Jukka:
> Hi,
>
> It is just a general SQL query tool and you must, or you have a great
> opportunity, to add the test directly into your SQL. This might get what you
> want with PostGIS 2.x
>
> select st_intersect
Hi,
> 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...". O
Hi,
Jukka gave great explanation about how to use RunDataStorePlugIn
I've also written a bit of documentation in the wiki :
http://sourceforge.net/apps/mediawiki/jump-pilot/index.php?title=Working_with_Databases
Feel free to complete,
Michaël
> Hi,
>
> It is just a general SQL query tool and you
Hi,
It is just a general SQL query tool and you must, or you have a great
opportunity, to add the test directly into your SQL. This might get what you
want with PostGIS 2.x
select st_intersection(...) AS geom ... FROM...
WHERE ST_GeometryType(geom)='ST_Polygon";
-Jukka-
Uwe Dalluege wrote:
>
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
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 li
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"
Inside the fence there is a polygon
intersects the geometry from "Bauernhof"
But this does
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.
-
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-gener
10 matches
Mail list logo
