Re: [postgis-users] Windows binaries available for PostGIS 2.0, WKT Raster for PostgreSQL 8.4, 9.0

2010-09-13 Thread Andrea Peri
For those who are interested we have 32-bit binaries available for Windows for the PostGIS 2.0 trunk version http://www.postgis.org/download/windows/experimental.php http://www.postgis.org/download/windows/experimental.php The packages are for PostgreSQL 8.4 and 9.0 and include the following

[postgis-users] sum dot product of outward normal vectors of polygon segments to given direction

2010-09-13 Thread Henri De Feraudy
Hello, I'm trying to calculate how much a polygon points in a given direction. This is to calculate how much light would come from a given light source. This means that for each segment of its outer ring I want to calculate the scalar (dot) product of outward normal vector (whose magnitude is

[postgis-users] help on converting points to polygon.

2010-09-13 Thread Nicholas I
Hi, I want to create a polygon from the given points and clip the area's within the polygon. I just tried with the below one to create a polygon, \d test_polygon; Table public.test_polygon Column | Type | Modifiers

Re: [postgis-users] help on converting points to polygon.

2010-09-13 Thread Nathan Gerber
Your table is setup to accept only MULTIPOLYGONs. Either adjust your table constraint to allow regular polygons or convert your polygon to a MULTIPOLYGON. -- Nathan Gerber On Mon, Sep 13, 2010 at 6:56 AM, Nicholas I nicholas.domni...@gmail.comwrote: Hi, I want to create a polygon from the

Re: [postgis-users] pgsql2shp revision

2010-09-13 Thread Mark Cave-Ayland
strk wrote: Perhaps we could touch the pgsql2shp-core.h file but that just seems messy :( Why drop the feature ? If we want a true repository revision we should provide that in an header file (which we'd touch) and use that when we see fit. I wouldn't drop the file-specific one though, you

[postgis-users] unioning a buffer - bug?

2010-09-13 Thread Lee
So after some googling I see similar problems, but no solutions posted. I am trying to union a buffer, but the query is returning no results. Here is ultimately what I would like to achieve: select st_union(st_buffer(the_geom,0.1)) as the_geom from base.current_assessment_parcel Here are

Re: [postgis-users] unioning a buffer - bug?

2010-09-13 Thread Lee
Forgot to mention, I have tried this on a couple other polygon and polyline tables with similar results. From: Lee quim...@yahoo.com To: postgis mailing list postgis-users@postgis.refractions.net Sent: Mon, September 13, 2010 10:07:06 AM Subject:

Re: [postgis-users] Size of .dbf file produced with pgsql2shp

2010-09-13 Thread Mark Cave-Ayland
Denis Rykov wrote: I've try to get exit code with my python script: import os code = os.system(pgsql2shp -f dagestan.shp -h gis-lab.info http://gis-lab.info/ -u labinfo -P *** osm \SELECT ^^ st_intersection as geom from

Re: [postgis-users] AsSvg

2010-09-13 Thread Rick
Not sure what you are asking, but I'll take a stab in the dark. When you retrieve geometry as SVG what you get back is the contents of a path attribute node. So if an SVG path element is written path d=X/ the result of the query is X, or the value of the 'd' (data) attribute, not an XML element,

Re: [postgis-users] Size of .dbf file produced with pgsql2shp

2010-09-13 Thread Denis Rykov
Mark, thanks for quick response, I've try to do it with bash: [...@gis ~/gl/projects/osmrus]$ pgsql2shp -u pgsql -f dagestan.shp osm SELECT st_intersection as geom from dagestan_point_attr WHERE highway='bus_stop' Initializing... ERROR: Could not determine table metadata (empty table) [...@gis

Re: [postgis-users] AsSvg

2010-09-13 Thread Bob Pawley
Rick - thanks for answering. I am in the process of learning a little XML. I understood that a query such as 'Select AsSvg(the_geom) from p_id.image' went to Postgis and the return (the geometry) comes back. I think you are saying that this is also in the xml path and xml interprets this

Re: [postgis-users] AsSvg

2010-09-13 Thread Rick
On Mon, Sep 13, 2010 at 12:46 PM, Bob Pawley rjpaw...@shaw.ca wrote: Rick - thanks for answering. I am in the process of learning a little XML. I understood that a query such as 'Select AsSvg(the_geom) from p_id.image' went to Postgis and the return (the geometry) comes back. I think you

[postgis-users] (no subject)

2010-09-13 Thread Rorie Overby
http://niyutona.tripod.com/ ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users