[postgis-users] [Job] : AURIN DATA ENGINEER - University of Melbourne

2012-12-09 Thread Luca Morandini
AURIN DATA ENGINEER Position no.: 0030516 Employment type: Full-time Fixed Term Campus: Parkville Department of Computing and Information Systems Melbourne School of Engineering Salary: $76,057 - $82,331 p.a. plus 17% superannuation The Australian Urban Research Infrastructure Network (AURIN) p

Re: [postgis-users] Geocoders - General thoughts and questions

2012-12-09 Thread Stephen Woodbridge
Regina, I just checked in the wrapper code and some README files to get you started. the wrappers are in .../api/psql/ folder. See the link to svn below. Thanks, -Steve On 12/9/2012 9:23 PM, Stephen Woodbridge wrote: On 12/9/2012 1:59 PM, Paragon Corporation wrote: Steve, Does the Tig

Re: [postgis-users] Geocoders - General thoughts and questions

2012-12-09 Thread Stephen Woodbridge
On 12/9/2012 1:59 PM, Paragon Corporation wrote: Steve, Does the Tiger geocoder have a set of test address that could be used for comparison? As far as test address we use, in the PostGIS code base trunk, there is a: extras\tiger_geocoder\tiger_2011\regress folder that has some normali

Re: [postgis-users] ST_Segmentize(geography) perfomance?

2012-12-09 Thread Paragon Corporation
Great team work and Paul has already fixed it :) Thanks, Regina http://www.postgis.us _ From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-boun...@lists.osgeo.org] On Behalf Of Shaun Walbridge Sent: Saturday, December 08, 2012 5:21 PM To: PostGIS Users Discussion Subjec

Re: [postgis-users] Geocoders - General thoughts and questions

2012-12-09 Thread Paragon Corporation
Steve, > Does the Tiger geocoder have a set of test address that could be used for comparison? As far as test address we use, in the PostGIS code base trunk, there is a: extras\tiger_geocoder\tiger_2011\regress folder that has some normalizer, geocode,reverse_geocode tests we run. These are

[postgis-users] plpgsql function question, equivalent sql statement?

2012-12-09 Thread Nathaniel Hunter Clay
Hi all, I am wondering if there is a better way do accomplish the following. To create an array of values between two points from a raster. This is what I have come up with. {{{ CREATE or REPLACE Function sampledArray(rast raster, bandnum integer, p1 geometry,p2 geometry, sampledistance do

[postgis-users] Geocoders - General thoughts and questions

2012-12-09 Thread Stephen Woodbridge
Hi Regina, and others interested in geocoders, There has been a more general OSGeo Labs discussion that has included OpenGeocoder. OpenGeocoder was a list I started a while back that never grew into project. I want to have a more focused discussion here. Some background: Ten years ago I wrot

Re: [postgis-users] Incorrect geometry_columns?

2012-12-09 Thread Paolo Cavallini
Il 09/12/2012 14:52, Francois Hugues ha scritto: > Hi, > > Are you sure you don't have mixed srid ? Sure: > Select st_srid(geom) from merge_strade group by st_srid(geom); st_srid 3003 Thanks. -- Paolo Cavallini - Faunalia www.faunalia.eu Full contact details at www.faunalia.eu/pc Nuovi corsi QG

Re: [postgis-users] Incorrect geometry_columns?

2012-12-09 Thread Francois Hugues
Hi, Are you sure you don't have mixed srid ? You should try this instead of limit 1 : Select st_srid(geom) from merge_strade group by st_srid(the_geom) Hugues. -- Hugues FRANÇOIS Ingénieur recherche Irstea Grenoble 2 rue de la papeterie 38400 Saint-Martin d'Hères tel : +33 (0)4.76.76.

[postgis-users] Incorrect geometry_columns?

2012-12-09 Thread Paolo Cavallini
Hi all. The geometry_columns view appears incorrect: => SELECT * from geometry_columns where f_table_name='merge_strade'; f_table_catalog|f_table_schema|f_table_name|f_geometry_column|coord_dimension|srid|type prova|public|merge_strade|geom|2|0|GEOMETRY SELECT ST_SRID(geom) FROM merge_strade LIM