Re: [postgis-users] Network + Topology

2010-11-02 Thread Mauricio Miranda
Thank you very much. I'll check the list history. Cheers! -- Mauricio Miranda Chief Development Officer http://www.xoomcode.com On Nov 2, 2010, at 20:52 PM, George Silva wrote: > Ohhh, I'm sorry, did not understood that. > > The guys at the pgRouting list might have ideas on successfull ca

Re: [postgis-users] Network + Topology

2010-11-02 Thread George Silva
Ohhh, I'm sorry, did not understood that. The guys at the pgRouting list might have ideas on successfull cases. George On Tue, Nov 2, 2010 at 9:43 PM, Mauricio Miranda wrote: > Hi George, > > I know pgRouting pretty well but that's not what we need. I need a real > case where PostGIS (with pgRo

Re: [postgis-users] Network + Topology

2010-11-02 Thread Mauricio Miranda
Hi George, I know pgRouting pretty well but that's not what we need. I need a real case where PostGIS (with pgRouting or another tool) is used. As I said, I must show a successful project where this technology has been applied. Any idea? -- Mauricio Miranda Chief Development Officer http://ww

Re: [postgis-users] Network + Topology

2010-11-02 Thread George Silva
Hello Mauricio, Check pgRouting: http://pgrouting.postlbs.org/ PostGIS also has a built-in topology module, but I'm not sure how much people use it. George On Tue, Nov 2, 2010 at 7:46 PM, Mauricio Miranda wrote: > Does anyone know about a network analysis project built using PostGIS? It > sho

[postgis-users] Finding a polygon containing a specified point

2010-11-02 Thread krill
Hi all, I am attempting to import and use the Federal Electoral Districts, a shapefile provided by Elections Canada (http://geobase.ca/geobase/en/ data/admin/index.html). I converted and loaded the shapefile as follows: &dol; shp2pgsql -c -W ISO-8859-1 -s 4617 -DI FED_CA_1_0_0_ENG.shp federal_ri

Re: [postgis-users] Query using ST_transform fails

2010-11-02 Thread Mike Toews
Also, what is the source SRID of your geometry column(s)? If you're not sure, check the geometry_columns table, the constraints used in the DDL, or try: select distinct st_srid(way) from planet_osm_point; -Mike On 2 November 2010 14:09, Torsten Mohr wrote: > Hello, > > (i accidentially posted t

[postgis-users] Network + Topology

2010-11-02 Thread Mauricio Miranda
Does anyone know about a network analysis project built using PostGIS? It should have "open" documentation so I can read about the implementation: how to create the topologic relationships, how to access the data, how to query and process the data, etc I need this stuff to show to the governmen

Re: [postgis-users] Query using ST_transform fails

2010-11-02 Thread Mike Toews
It appears the grid shift files are missing. These are not necessarily installed by default. Are you using http://www.pgrpms.org/ ? Is proj-nad installed? Did you install proj.4 from source? If so, did you get the ZIP files and put them in the right place before configuring? -Mike On 2 November

[postgis-users] Query using ST_transform fails

2010-11-02 Thread Torsten Mohr
Hello, (i accidentially posted this on the openstreetmap mailing list, but it belongs here:) I once got a hint on this mailing list to use a query like this to get the lat/lon of the world capitals: A) select st_X(wayLL), st_Y(wayLL), name from (select ST_AsText(ST_Transform(way,4326)) as way

Re: [postgis-users] Check-Constraint »enforce_geot ype_poly« violated

2010-11-02 Thread Jan Saalbach
Never mind, problem solved. An ST_WITHIN check kindly helped me figured it out. The problem was not that it was not a polygon. The problem was, one was inside the other one. Regards Jan ___ postgis-users mailing list postgis-users@postgis.refraction

Re: [postgis-users] selectivity

2010-11-02 Thread strk
On Tue, Nov 02, 2010 at 03:13:14PM +0100, strk wrote: > On Mon, Nov 01, 2010 at 04:18:30PM -0700, Ben wrote: > > 2 - is there any documentation describing how they work (besides the source > > code)? i'm interested in the kind of statistics you use. > > You may find something in postgis-devel a

[postgis-users] Check-Constraint »enforce_geot ype_poly« violated

2010-11-02 Thread Jan Saalbach
Dear All, when trying to insert a polygon into a table from a plperl script by this command: my $new_poly = spi_exec_query("INSERT INTO polys1(id,poly) VALUES($new_id, ST_MakeEnvelope($xmin, $ymin , $xmax, $ymax, 31467));"); I get a "new row for relation »polys1« violates Check-Constraint

Re: [postgis-users] selectivity

2010-11-02 Thread strk
On Mon, Nov 01, 2010 at 04:18:30PM -0700, Ben wrote: > hello -- > > i am not a postgis user, but i am interested in range datatypes and gist > indexing. there are some extensions for postgresql which expose such types > (temporal, cube, etc.) but as far as i can tell all of them use the default

Re: [postgis-users] How to Subtract Polygon From Polygon

2010-11-02 Thread Jan Saalbach
Thank you very much Maxime. I knew there was a function like this, just could not remember the name. Regards Jan On 02.11.2010 14:01, Maxime van Noppen wrote: > Hi, > > ST_Difference does the trick. > > http://postgis.refractions.net/docs/ST_Difference.html _

Re: [postgis-users] How to Subtract Polygon From Polygon

2010-11-02 Thread Maxime van Noppen
On 11/02/2010 01:48 PM, Jan Saalbach wrote: > Dear All, > is there a function to easily subtract a polygon from a polygon. Both > are rectangles. > > The scenario: > Two overlapping polygons identified by ST_INTERSECTS. > Creating a third one from the overlapping area via ST_INTERSECTION. > Subtra

[postgis-users] How to Subtract Polygon From Polygon

2010-11-02 Thread Jan Saalbach
Dear All, is there a function to easily subtract a polygon from a polygon. Both are rectangles. The scenario: Two overlapping polygons identified by ST_INTERSECTS. Creating a third one from the overlapping area via ST_INTERSECTION. Subtract the overlap from the two initial polygons. Which funct