Re: [postgis-users] Failed POST GIS on Re-boot.

2011-06-24 Thread Mark Cave-Ayland
On 23/06/11 20:25, Chris Seker wrote: Hi all. I am running PostgreSQL 9.1 and PostGIS2.0 under CENTOS. After install, the server worked fine and we spent about 2 weeks building databases, etc. Then after some routine hardware maintenance and re-boot, we get the following error. Top of Form

Re: [postgis-users] How to Store Metadata?

2011-06-24 Thread Stephen Woodbridge
On 6/24/2011 9:02 AM, Brett Antonides wrote: Hi Everybody, Could someone please tell me or send me a link describing how to best store ISO 19115/19139 metadata with my spatial data in PostGIS? Ultimately, the data will be stored in PostGIS, published via GeoServer, and cataloged in

Re: [postgis-users] How to Store Metadata?

2011-06-24 Thread Peter N. Schweitzer
On 06/24/2011 09:02 AM, Brett Antonides wrote: Could someone please tell me or send me a link describing how to best store ISO 19115/19139 metadata with my spatial data in PostGIS? Ultimately, the data will be stored in PostGIS, published via GeoServer, and cataloged in GeoNetwork. I know I

Re: [postgis-users] How to Store Metadata?

2011-06-24 Thread Nicolas Ribot
Hi, Indeed yes, GN can store its data into a PG database: geonetwork=# \d metadata Table public.metadata Column| Type |Modifiers --++- id | integer

[postgis-users] Database design for LIDAR data

2011-06-24 Thread Jonathan Greenberg
Folks: This topic I believe has been brought up before, but I thought I'd send an email since I'm a bit of a noob with POSTGIS. We have a large collection of Lidar points that I would like to perform spatial querying on (e.g. give me all points within a certain bounding box). The data (currently

Re: [postgis-users] Database design for LIDAR data

2011-06-24 Thread Howard Butler
On Jun 24, 2011, at 1:46 PM, Jonathan Greenberg wrote: Folks: This topic I believe has been brought up before, but I thought I'd send an email since I'm a bit of a noob with POSTGIS. We have a large collection of Lidar points that I would like to perform spatial querying on (e.g. give me

Re: [postgis-users] Database design for LIDAR data

2011-06-24 Thread Shaun Langley
Hi Howard, I think this is an excellent question! I'm actually in the process of developing a manuscript that outlines the different methods for storage and querying of spatial data such as LIDAR. In my situation, I'm leaning towards using triggers to create dynamic views that would allow me

Re: [postgis-users] Database design for LIDAR data

2011-06-24 Thread Jonathan Greenberg
Interesting. I came across this paper detailing the design of opentopography.org's lidar system, and they indicate they are doing something akin to load the LAS data in, and then running a spatial index (I'm too early in this game to know the difference between what they are describing and how

Re: [postgis-users] Database design for LIDAR data

2011-06-24 Thread Howard Butler
On Jun 24, 2011, at 4:04 PM, Jonathan Greenberg wrote: Interesting. I came across this paper detailing the design of opentopography.org's lidar system, and they indicate they are doing something akin to load the LAS data in, and then running a spatial index (I'm too early in this game to