Re: [postgis-users] Checking Road Network Topology

Il 22/01/2015 01:28, Mark Wynter ha scritto: > I’m open to any ideas, leads or offers of help. I might be able to help, especially on the QGIS side; perhaps setting up Processing modules could make the workflow easier. All the best. -- Paolo Cavallini - www.faunalia.eu QGIS & PostGIS courses: h

Re: [postgis-users] Possible for ST_Intersects to not include the perimeter?

Hi, I think ST_Intersects + ST_Touches should worked for your case. Maybe you are facing a precision issue. The use of ST_SnapToGrid could help: http://postgis.net/docs/ST_SnapToGrid.html Hug ___ postgis-users mailing list postgis-users@lists.osgeo.or

Re: [postgis-users] Checking Road Network Topology

Hi List Interesting topic. I’ve developed a solution for processing large scale road networks (OSM) using techniques that strk and R?mi-C have mentioned. The solution uses PostGIS for “breaking" and “nodeing” . GRASS for snapping and patching. The PostGIS step uses a custom SQL function to br

Re: [postgis-users] Possible for ST_Intersects to not include the perimeter?

Joseph, On Wed, Jan 21, 2015 at 2:34 PM, Joseph Spenner wrote: > I have NWS polygons describing Thunderstorm Warnings, which are made up of > counties within the state. Some of those counties might be on the edge of > the state. I want to query my database to show me all Warnings which are in

Re: [postgis-users] Possible for ST_Intersects to not include the perimeter?

Pete:  Thanks for the reply!  But I just tried, and ST_Contains will miss if the alert polygon spans multiple states.  I have an example which spans a bit of California and Arizona.  When I select AZ or CA, I get nothing back.  So it appears, as the documentation states, ST_Contains will only re

Re: [postgis-users] Possible for ST_Intersects to not include the perimeter?

I believe you want ST_Contains. Using sample Census TIGER data for states and counties: SELECT COUNT(c.*) FROM prod.states s INNER JOIN prod.counties c ON (s.name = 'Georgia' AND ST_Contains(s.the_geom, c.the_geom)); --159 SELECT COUNT(*) from prod.counties WHERE state_cd = 'GA'; --159 I suppo

Re: [postgis-users] Possible for ST_Intersects to not include the perimeter?

For the record, my best guess (which didn't work) was: select ST_Asgeojson( geom ) from polys where ST_Intersects(ST_GeomFromGeoJSON('$jsonPoly'), geom)=TRUE and ST_Touches(ST_GeomFromGeoJSON('$jsonPoly'), geom)=FALSE Since 'touch' seemed to be the way to address the perimeter points.  But appa

[postgis-users] Possible for ST_Intersects to not include the perimeter?

I have a polygon as an input, and I'm trying to find all polygons which share points, but not the perimiter points themselves.  Is this possible? Real application:  I have NWS polygons describing Thunderstorm Warnings, which are made up of counties within the state.  Some of those counties might

Re: [postgis-users] Checking Road Network Topology

Yeah sure , it was discussed on the user list : http://lists.osgeo.org/pipermail/postgis-users/2014-November/039758.html I personnaly tried the grass v.clean and it is fast and efficient (altough the grass UI is terrible in my opinion) Cheers, Rémi-C 2015-01-21 14:05 GMT+01:00 Miller, Stephan :

Re: [postgis-users] Checking Road Network Topology

On Wed, Jan 21, 2015 at 09:11:16AM +0100, Rémi Cura wrote: > Hey, > we previously discussed this matter of cleaning topology. > Postgis topology is about iso topology storage and use, not cleaning. That said, you can still use PostGIS for cleaning the data you're willing to store in a topological

Re: [postgis-users] Checking Road Network Topology

Hey, we previously discussed this matter of cleaning topology. Postgis topology is about iso topology storage and use, not cleaning. There are dedicated and powerfull tools for this (like Grass ). Cheers, Rémi-C 2015-01-20 21:26 GMT+01:00 Sandro