[postgis-users] Missing template_postgis file

2011-08-14 Thread b...@brucecallander.com
I have downloaded and installed PostGIS 1.5 on my MacBook Pro running Snow Leopard v10.6.8 (having pre-installed Postgres 9.0, Geo 3, Proj ..) I am using the Getting Started instructions in Geoserver in order to create a PostGIS table, but I have been unable to create a test database using the

[postgis-users] Difficulty importing example file nyc_buildings.sql

2011-08-15 Thread b...@brucecallander.com
I am following the Geoserver Getting Started documentation in order to create an example PostGIS table. I am working on a MacBook running Snow Leopard v10.6.8 Thanks to previous advice from the forum (Nicolas Ribot) I was able to create the sample database 'nyc' based on the template 'template_

Re: [postgis-users] PostGIS to Web Map?

2011-08-17 Thread b...@brucecallander.com
James - My guess is that the straightforward answer is to use Geoserver or similar. Writing the software to extract data from PostGIS and turn it into a web service seems like unnecessary pain. I have come at this from the opposite point of view. I wanted to learn more about how WMS, WFS, WCS w

Re: [postgis-users] Difficulty importing example file nyc_buildings.sql

2011-08-17 Thread b...@brucecallander.com
Thanks to Ben Madin for advice. I removed the apostrophes from the SRID in nyc_buildings.sql (using TextEdit) and re-ran the command /usr/local/pgsql-9.0/bin/psql -f /Users/bacmac/nyc_buildings.sql nyc Unfortunately it produced the same result: BEGIN psql:/Users/bacmac/nyc_buildings.sql:3: NOT