[postgis-users] postgresql 8.4 postgis installer

Hi all I am thnking if upgrading my postgresql 8.2 to the latest 8.4 and was wandering if there is an postgis 1.3.6 windows installer available yet as I cannot see one available. Can I use the 1.3.6 for postresql 8.3? Any ideas would be most welcome. Many thanks in advance Mark _

Re: [postgis-users] equal area projection

06" USE_STATS" I have finally managed to get Mollweide into postgis and its working fine, I just need to reproject and upload 20+ shapefiles now.. Once again, many thanks for the assistance! ATB Mark On Tue, Mar 17, 2009 at 9:54 AM, Mark Cave-Ayland < mark.cave-ayl...@siriusit.co.

[postgis-users] equal area projection

Hi all I am trying to add a new equal area projection into postgis (behrmann and/or Robinson). I am struggling to get this to work. From the " spatialreference.org" website I uploaded the following into postgis: INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext) values (

Re: [postgis-users] Help with query

to Plate Carree > > So should be > > ST_Intersects(pas_nat_iv_pnt.the_geom > ,ST_Transform(ST_GeomFromText(userinput,4326), > 32662) ) > > Hope that helps, > Regina > > -- > *From:* postgis-users-boun...@postgis.refractions.net [mail

[postgis-users] Help with query

Hi all I am trying to create a query that returns the features intersected by a user defined area. I can do this with the following query which works fine and returns what I want: select areaname, country FROM pas_nat_iv_pnt where ST_Intersects(pas_nat_iv_pnt.the_geom , ST_GeomFromText('POLYGON((

[postgis-users] transform geometry and calculate distance query

Hi all, I have a query I need to create that transforms the geometry from lat/long to plate carree so I can return distances of a point to nearby polygons at a specified distance (not ideal to use Plate Carree but I cannot find any other global projection that I can use within the EPSG codes). Wha

[postgis-users] Help with query

Hi All I have managed to resolve the query with the following suggestion - thanks to Rob Burgholzer's suggestion to use UNION Keeping this simple, I kept the following Layer for selecting the polygon features within the specified distances defined in the class expressions DATA "the_geom FROM (SE

[postgis-users] Help with query

Hi All I am trying to create a query that uses a mouse click to get coordinates (from mapserver) and then features within a specified distance are selected and displayed in different colours. The query I have at the moment works well, however, the problem I am trying to solve is how to indicate th

[postgis-users] help with distance query

Hi all again Thanks ever so much for your help David your suggestion works great! And thanks too MarkW for your help - exactly what I did but which kept giving me the error message: ERROR: column "azev2_1.the_geom" must appear in the GROUP BY clause or be used in an aggregate function SQL state:

[postgis-users] help with distance query

Many thanks for your help David, it works! select astext(the_geom), distance_spheroid(GeomFromText('Point(-70 20)',4326),the_geom,'SPHEROID["WGS 84",6378137,298.257223563]') from azev2_1 group by 1,2 having distance_spheroid(GeomFromText('Point(-70 20)',4326),the_geom,'SPHEROID["WGS 84",637813

[postgis-users] help with distance query

Hi all I am trying to work out how to return the distances from a user defined location but not too sure how. My query follows; select * from azev2_1 where distance_spheroid(GeomFromText('Point(-70 20)',4326),the_geom,'SPHEROID["WGS 84",6378137,298.257223563]') < 25; This provides all the po

[postgis-users] dynamic sql

Hi All I am trying to create a dynamic sql query that a user can enter latitude and longitude coordinates together with a specified distance. So far I have created the following query (not sure if correct but it does work and have also tried st_distance query) select * from azev2_1 where distance