Re: [postgis-users] PostGIS 2.1.1 Released

2013-11-11 Thread Devrim GÜNDÜZ
Hi, RPMs are available for PostgreSQL 9.2 and 9.3 (since Friday) at http://yum.postgresql.org Regards, Devrim On Fri, 2013-11-08 at 12:12 -0800, Paul Ramsey wrote: Get it while it's hot! http://download.osgeo.org/postgis/source/postgis-2.1.1.tar.gz * Important Changes * - #2514,

[postgis-users] Grid of points inside Polygon

2013-11-11 Thread James David Smith
Hi all, Would appreciate some advice on the best way to accomplish this please. Our situation is that we have a single polygon which has been created by buffering all of the major roads in the UK. Projection is OSGB36 (27700). Obviously it's quite a big polygon. -- SELECT st_area(geom) FROM

Re: [postgis-users] How to create user-defined C function using a postgis C function

2013-11-11 Thread Peter Tolkewitz
Hello Sandro,   thank you for your answer. For testing I wrote another main() class:   --- start main.c --- int main() {   test(0,0);   return 0; } --- end main.c ---   and compiled   cc -I/usr/include/pgsql/server -fpic -shared -o libtest.so test.c cc -llwgeom -ltest main.c -o main -L.

Re: [postgis-users] How to create user-defined C function using a postgis C function

2013-11-11 Thread Sandro Santilli
On Mon, Nov 11, 2013 at 12:27:17PM +0100, Peter Tolkewitz wrote: Hello Sandro,   thank you for your answer. For testing I wrote another main() class:   --- start main.c --- int main() {   test(0,0);   return 0; } --- end main.c ---   and compiled   cc -I/usr/include/pgsql/server

Re: [postgis-users] Grid of points inside Polygon

2013-11-11 Thread Rémi Cura
Hey, the whole point on using a sgbds like postgis is using index. If you have one line you don't use indexes... So in short, don't make one polygon with a buffer of all the road, but a table with a line for the buffer for every road, then do you computation to create grid of points inside of