Re: [postgis-users] Longitude and latitude ranges

2011-08-26 Thread Ture Pålsson
2011/8/23 Jaime Casanova ja...@2ndquadrant.com: db=# update transmitter_mv set punto = st_makepoint(tx_long, tx_lat); ERROR:  Coordinate values are out of range [-180 -90, 180 90] for GEOGRAPHY type any ideas why this is happening? Perhaps this is a too-obvious question, but have you

[postgis-users] Can't find shp2pgsql after installing postgis from MacPorts.

2011-08-26 Thread Gis Mage
Hi list! I've installed postgresql90 and postgis 1.5.3 on OS X 10.7 separately from MacPorts. Everything works good, but I can't find a shp2pgsql file on my mac. Does anybody know where it can be found? Maybe there is a binary in the net somewhere? ___

Re: [postgis-users] OT Understanding slow queries

2011-08-26 Thread Paragon Corporation
Sadly it's for immediate production use and I'm forced to use windows which limits my version choices a bit given my lack of skill under windows to build postgis :( charles Charles, You know we do have pretty much latest builds of PostGIS (even trunk on PostGIS website for windows).

Re: [postgis-users] OT Understanding slow queries

2011-08-26 Thread Charles Galpin
On Aug 26, 2011, at 3:50 PM, Paragon Corporation wrote: You know we do have pretty much latest builds of PostGIS (even trunk on PostGIS website for windows). http://www.postgis.org/download/windows/experimental.php and as far as PostgreSQL -- they have released windows binaries for even

[postgis-users] Moving geometry from MySQL to PostGIS

2011-08-26 Thread Mr. Puneet Kishor
Suggestions? What is the quickest, cleanest way to do this? -- Puneet Kishor ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] Can't find shp2pgsql after installing postgis from MacPorts.

2011-08-26 Thread Mr. Puneet Kishor
On Aug 26, 2011, at 3:07 AM, Gis Mage wrote: Hi list! I've installed postgresql90 and postgis 1.5.3 on OS X 10.7 separately from MacPorts. Everything works good, but I can't find a shp2pgsql file on my mac. Does anybody know where it can be found? Maybe there is a binary in the net

Re: [postgis-users] Erase and Intersect performance questions - PostGIS way slower than ArcGIS

2011-08-26 Thread Sheara Cohen
Thanks Chris, Paul, and Martin for your thoughts. Much appreciated. ~ Sheara Sheara Cohen Planner C A L T H O R P E A S S O C I A T E S 2095 ROSE STREET, SUITE 201, BERKELEY, CALIFORNIA, 94709 USA 510 809-1165 (direct) | 510-548-6800 x35 (main) | 510 548-6848 (fax) she...@calthorpe.com

[postgis-users] PostGIS 2.0 Web adhoc query viewer for Geometry and Raster - PHP and ASP.NET

2011-08-26 Thread Paragon Corporation
For those who are interested in quick web based rendering tools for PostGIS raster and geometry. We've whipped up one for PHP and ASP.NET. These are more a proof of concept to demonstrate how to use the new raster output functions and how they help augment what you can do with postgis