[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

[postgis-users] Proper usage of Schema's

2011-08-15 Thread aperi2007
Hi, The esri world work always in an unique DB schema. So a single dataset is a group of tables in the same schema of the other datasets. I don't understand why you need to use distinct schemas to separate they. However I think you could do it. You must install postgis in the public schema

[postgis-users] Distances off in the Southern US

2011-08-15 Thread Mike Hostetler
Hello, I'm somewhat new to GIS and I have a problem that I thought appeared to be simply using a wrong projection or datum, but it seems to be a bit more subtle than that. I have a table of cities in the US and I'm trying to find distances between them. When I use a city that is in the northern

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

2011-08-15 Thread Andrew Libby
Hi Bruce, I'm pretty new to GIS and PostGIS, but I'll try to offer an idea. It appears that you might not have the postgis code loaded. I'm going to guess that Nicholas' suggestion involved setting up the template_postgis database so that you might make postgis enabled databases without

Re: [postgis-users] Distances off in the Southern US

2011-08-15 Thread Nicolas Ribot
On 15 August 2011 12:50, Mike Hostetler m...@squarepegsystems.com wrote: Hello, I'm somewhat new to GIS and I have a problem that I thought appeared to be simply using a wrong projection or datum, but it seems to be a bit more subtle than that. I have a table of cities in the US and I'm

Re: [postgis-users] Distances off in the Southern US

2011-08-15 Thread Dan Putler
Hi Mike and Nicolas, The fact that Mike's two calculations resulted in the same value to 12 decimal places is more that a little fishy. I seem to remember a similar issue coming up on this list sometime ago (roughly a year ago is my, faulty, memory). The difference between southern and

[postgis-users] Postgis rasters in OpenLayers?

2011-08-15 Thread Vishal Mehta
Can anyone tell me if Postgis rasters can be displayed in OpenLayers? We are trying to develop a web-gis stack (so far Postggresql - Postgis - PhP -OpenLayers) on an external server. I'm wondering if we can have raster functionality as well as display with postgis alone as the map

Re: [postgis-users] Postgis rasters in OpenLayers?

2011-08-15 Thread Pierre Racine
I don't think there is anything in OpenLayer able to speak directly with PostGIS... You need something in between able to deliver tiles. If your php code can do that... But why trying to reinvent a tile server other than MapServer or GeoServer? Pierre -Original Message- From:

Re: [postgis-users] Postgis rasters in OpenLayers?

2011-08-15 Thread Dave Potts
On 15/08/11 18:53, Pierre Racine wrote: Use geoserver which can make a request to a postgis database and supply data as wfs or wms servers. You can then use openlayers to access the wfs/wms server I don't think there is anything in OpenLayer able to speak directly with PostGIS... You need

Re: [postgis-users] Postgis rasters in OpenLayers?

2011-08-15 Thread Vishal Mehta
Thanks Dave, Pierre, There were a couple of reasons for my qn: For an earlier application, we used postgis as a map repository and geoprocessor, php to interact dynamically with the map repository and perform gis operations, R to create graphs, and google earth as the visual frontend.

Re: [postgis-users] Distances off in the Southern US

2011-08-15 Thread Mike Hostetler
I'll try to answer everyone's suggestions: I didn't know that Yahoo's service was in 4326. That did change things up a bit. And, yes, I did copy the value from Birmingham to Miami twice. Sorry about that. . . My customer was comparing my results to a different source but it seems close to

Re: [postgis-users] Postgis rasters in OpenLayers?

2011-08-15 Thread Pierre Racine
So I wanted to check if with OpenLayers instead of Google Earth as the client, I could do the same and just have a sparse geospatial stack. The answer is in your php server. You decide... Everything depends on what is supported by the client. You had to develop a server for Google Earth.

Re: [postgis-users] Postgis rasters in OpenLayers?

2011-08-15 Thread Vishal Mehta
Thank you again Pierre, Vishal -Original Message- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Pierre Racine Sent: Monday, August 15, 2011 11:54 AM To: PostGIS Users Discussion; dave.po...@pinan.co.uk Cc: Eric

[postgis-users] Importing a shape file with NAD83 / Conus Albers

2011-08-15 Thread Javier de la Torre
Hi all, I got a shapefile with a .prj file on it. I pasted the contents to http://prj2epsg.org and got that this http://prj2epsg.org/epsg/5070 This srs does not seem to be in PostGIS so I am trying to add it. Now, the first thing I tried was sending it to spatialreference and I got this

Re: [postgis-users] Importing a shape file with NAD83 / Conus Albers

2011-08-15 Thread Paul Ramsey
Try running MorphFromESRI on the srs before generating the proj4? P On Mon, Aug 15, 2011 at 2:25 PM, Javier de la Torre jato...@vizzuality.com wrote: Hi all, I got a shapefile with a .prj file on it. I pasted the contents to http://prj2epsg.org and got that this http://prj2epsg.org/epsg/5070

Re: [postgis-users] Importing a shape file with NAD83 / Conus Albers

2011-08-15 Thread Javier de la Torre
You mean: srs.MorphFromESRI() srs.ExportToProj4() That still produce srs.ExportToProj4() ERROR 6: No translation for Albers Equal Area to PROJ.4 format is known. On Aug 15, 2011, at 5:28 PM, Paul Ramsey wrote: Try running MorphFromESRI on the srs before generating the proj4? P On Mon,

Re: [postgis-users] Importing a shape file with NAD83 / Conus Albers

2011-08-15 Thread Paul Ramsey
Very odd. Well, the proj4text you want is: +proj=aea +lon_0=-96 +lat_0=23 +lat_1=29.5 +lat_2=45.5 +datum=NAD83 But, why OGR cannot produce that? Don't know. P On Mon, Aug 15, 2011 at 2:38 PM, Javier de la Torre jato...@vizzuality.com wrote: You mean: srs.MorphFromESRI() srs.ExportToProj4()

Re: [postgis-users] Importing a shape file with NAD83 / Conus Albers

2011-08-15 Thread Javier de la Torre
Thanks Paul, Now, it is a pity there is no way to automate this to a decent level. Is there nobody working on a generic shapefile importer that can accept any sort of shapefile and try to load it using the .prj file? I will keep trying :) Javier. On Aug 15, 2011, at 5:55 PM, Paul Ramsey

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

2011-08-15 Thread Ben Madin
Bruce, On 15/08/2011, at 6:28 PM, b...@brucecallander.com wrote: $ /usr/local/pgsql-9.0/bin/psql -f /Users/bacmac/nyc_buildings.sql nyc The Geoserver instructions are not explicit about where to put the nyc_buildings.sql file so I have left it in my own user directory 'bacmac'. It