Re: [postgis-users] shp2pgsql problems on Mac OS X Leopard

2007-12-05 Thread John Cartwright
Hi Patrick, I think I ran into the same problem, but didn't realize what the underlying issue was. Just found that shp2pgsql kept complaining about the inability to open valid shapefiles. --john On Dec 5, 2007, at 9:32 AM, Patrick Hartling wrote: I have run into a rather perplexing

Re: [postgis-users] make check failures w/ 1.3.1 on Mac OS 10.5

2007-11-30 Thread John Cartwright
(.shx) can not be opened. Any suggestions on how to proceed from here? Thanks! --john On Nov 30, 2007, at 1:10 AM, Mark Cave-Ayland wrote: On Thu, 2007-11-29 at 23:10 -0700, John Cartwright wrote: Hi Mark, Using the hourly svn snapshot, the build went fine, but make check is still failing 12

Re: [postgis-users] make check failures w/ 1.3.1 on Mac OS 10.5

2007-11-29 Thread John Cartwright
Hi Mark, Using the hourly svn snapshot, the build went fine, but make check is still failing 12 out of 37: ../loader/shp2pgsql: shape (.shp) or index files (.shx) can not be opened. --john On Nov 27, 2007, at 3:45 PM, Mark Cave-Ayland wrote: Hi William, Great detective work! I've

[postgis-users] make check failures w/ 1.3.1 on Mac OS 10.5

2007-11-25 Thread John Cartwright
Hello All, Trying to compile v1.3.1 on leopard. Compilation seems to go OK, but 35 out of 37 tests fail on the make check prior to installation. For example: loader/Point. failed (running shp2pgsql: /var/folders/v1/ v1z9PHeJEvGQIvBCSUU0QE+++TI/-Tmp-//loader.err) loader.err contains:

Re: [postgis-users] make check failures w/ 1.3.1 on Mac OS 10.5

2007-11-25 Thread John Cartwright
Thanks for looking into this William and for your suggestion. I've implemented it, but am still getting 12 failures (all loader tests), complaining that: ../loader/shp2pgsql: shape (.shp) or index files (.shx) can not be opened. I've confirmed that the shapefiles are present and should

[postgis-users] constructing new geometry from existing columns

2007-11-21 Thread John Cartwright
Hello All, I'm trying to populate a newly-added geometry column in a table using two existing columns: LON, LAT. The only way I see to do it seems a little clumsy: update grid_points set SHAPE = GeomFromText('POINT(' || lon ||' ' || lat || ')',4326); Is there a better way than