Search Results

Your problem is that you have excluded the public schema from the search_path. All functions and types is in the public schema (by default) So what you have to do is just include the public schema i …

Edit: field names corresponding to the questions field name SELECT polygons.id , polygons.name , coalesce(sum(points.value),0) AS sum FROM polygons LEFT JOIN points ON ST_Intersects(polygo …

As I understand your question there is no need for cursors. This is a very common and simple task to do with simple sql. If we call your two tables roadsegments and adresspoints with fields like this: …

I think this works. It is a windowing function, getting the difference between the intersection of each geometries intersection with the query box and the union of the preceding geometries. The coal …

SELECT wbn_uidn, sum(ST_Length(ST_Intersection(wgo_geom,wbn_geom))) FROM wbn, wgo WHERE ST_Intersects(wgo_geom,wbn_geom) GROUP BY wbn_uidn;

What you are talking about is not stored procedures but spatial inbuilt functions. Those functions are very powerful and you can do most of the things that you do in a desktop gis directly in the da …

This is a little trickier than you might expect. That is because there is no good way in analyzing relations for more than pairs. You cannot put three lines into a function and ask if all of them inte …

Hallo I would import it to PostGIS first. There is tools to load multiple shapes to individual tables. QGIS spit extension is one. The new graphical shp2pgsql in PostGIS trunk or experimental binarie …

If it would have been a few million points to check distance between you could consider using knn-distance with PostgreSQL 9.1 and PostGIS 2.0. But I think you should do fine with something like? …

If that is the query that is used I guess you are out of luck. Is there no WHERE-clause? I have never played with cursors, but as I understand the query, Arc-whatever fetches 1000 rows a time from …

You already have the geom type. wkb_geometry is just the name of the column. I see it is a confusing naming since thebstorage isn't wkb but a internal PostGIS format that is quite similar to wkb. I gu …

ST_Shortestline is for that purpose http://postgis.net/docs/ST_ShortestLine.html ST_Closestpoint is actually a wrapper around ST_Shortestline

Edited Take a look at the doc: http://postgis.net/docs/manual-2.1/ST_Contains.html Sorry, I misread your question first. Interesting that it didn't work with your first syntax but with _st_contain …

This is one way of doing it Find out how big fraction of the line is between the 2 points with ST_LineLocatePoint and multiply that fraction with the whole length. SELECT (ST_LineLocatePoint(l,p2)- …

Hallo Is it the QGIS rendering that makes things slow or the PostGIS query. Is the query in the definition of a view or why does it need to med evaluated more than once? If it is the PostGIS query t …