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
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_
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
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