Re: [postgis-users] Shifting linestrings left

2010-12-23 Thread Ben Madin
G'day Sean, On 24/12/2010, at 2:07 AM, Sean wrote: > Is this just a visualization issue? You could store copies of the the > road line with attribute data indicating direction or have a separate > table with foreign keys to the geography and the direction data. > > Then, you just symbolize diff

Re: [postgis-users] Shifting linestrings left

2010-12-23 Thread Ben Madin
G'day Puneet, On 24/12/2010, at 2:17 AM, Puneet Kishor wrote: > Sean wrote: >> Is there a way to 'shift' the linestring to the left - after all, > > that would be sensible side of the road to drive on... > > Which world do you live in? After all, the right side of the road is called > the "righ

Re: [postgis-users] Point in Poly just not working

2010-12-23 Thread Paul Ramsey
Jason, You're inappropriately mixing coordinate reference systems. As an aside, you don't need to add a spatial_ref_sys entry, if you've loaded the default PostGIS spatial_ref_sys table, the entry for 29610 is NAD823/UTM10N. The key problem in your query is this part: ST_GeomFromText('POINT(-12

[postgis-users] Point in Poly just not working

2010-12-23 Thread Jason Leach
Hi: I'm just not having any luck determining if a point is in a polygon. 1. I add my SRID for NAD_1983_UTM_Zone_10N to the spatial ref. 2. Importing the City of Vancouver's boundary (MULTILINESTRING) with -s 1 (SRID=1) and load the SQL file. 3. Pick a point within the city from google map: 49.28

[postgis-users] rtpostgis errors

2010-12-23 Thread paolo
Hi all. After compiling from svn, I get a few errors while uploading rtpostgis.sql. Any hint? Thanks a lot. === $ psql -d test -f raster/rt_pg/rtpostgis.sql psql:raster/rt_pg/rtpostgis.sql:32: NOTICE: type "raster" is not yet defined DETTAGLI: Creating a shell type definition. CREATE FUNCTION psql

Re: [postgis-users] Shifting linestrings left

2010-12-23 Thread Puneet Kishor
Sean wrote: Is there a way to 'shift' the linestring to the left - after all, > that would be sensible side of the road to drive on... Which world do you live in? After all, the right side of the road is called the "right side" for a reason. ;-) -- Puneet Kishor __

Re: [postgis-users] Shifting linestrings left

2010-12-23 Thread Sean
Is this just a visualization issue? You could store copies of the the road line with attribute data indicating direction or have a separate table with foreign keys to the geography and the direction data. Then, you just symbolize differently based on the attributes. Offset the symbology not the

Re: [postgis-users] Shifting linestrings left

2010-12-23 Thread Charles Galpin
Just FYI, I have tries upgis_lineshift and in general it does a great job - at a minimum for visualizing the different paths. However I have found that sometimes the shifted line doesn't go in the direction you'd expect so you'll get situations where the shifting switches sides and this can be p

Re: [postgis-users] what to do about TopologyExceptions

2010-12-23 Thread David Kaplan
Hi, I thought I had everything figured out with respect to my problems unioning and differencing polygons, but I am running into more TopologyExceptions that have me confused. After looking at Paul Ramsey's FOSS4G presentation, I realized that what I really wanted to do was an "ArcGIS Union Ope