Monday, May 12, 2008
Bloody Knuckles with Open Layers, PostGIS and GeoServer
Posted on Monday, May 12, 2008 5:52:48 PM (Mountain Daylight Time, UTC-06:00)  Comments [2] | 
Categories: PostGIS | Web Mapping | Where 2.0

knuckles

So the session was hampered by some corrupted data on the USB sticks, and was more a loosely guided tour of the stack than anything else. I had PostGIS up and running, but could not get my data (loaded into ArcSDE on PostgreSQL using the PostGIS datatype) to load into GeoServer. Tried some other data, and same problem. Unclear what the issue is.

Many of the sample SLD's would not validate (hence could not be loaded), and I could never get the WMS group layers to work. I did get some data up in Google Earth, and open layers, but overall this session confirmed for me that the open source stack learning curve is steep from the get go. I need to get into OpenLayers as the demo's were pretty cool but until I can get the back end all working smoothly it's somewhat moot.

I think that the docs for this will be up somewhere. The software installers are below.

Downloads: http://files.opengeo.org/where2/stick/software

Tuesday, May 13, 2008 6:36:56 AM (Mountain Daylight Time, UTC-06:00)
Sorry to hear about your bumpy ride. Which are the sample SLD that do not validate? In any case, you can get unstuck by disabling SLD validation, GeoServer will load the SLD anyways and make a best effort to parse it anyways.

As for data loading on PostGIS, I fear that ArcSDE is not filling properly the contents of the metadata table geometry_columns or use non standard SRS code (standard being what comes from the EPSG, www.epsg.org). We do most of our work on PostGIS and it works very fine for us, the two things that you should make sure are that:
* the geometry_colums table is properly filled in for each geometry column you have around
* the tables do have a primary key, otherwise they won't be editable

Andrea Aime
Tuesday, May 13, 2008 10:26:49 AM (Mountain Daylight Time, UTC-06:00)
Hey, I didn't know that PostGIS with ArcSDE was out. I'd love to have a play with trying to get it up in GeoServer. I'm not too busy at Where 2.0, so try to find me and we can play. I think we'll be showing demos at the where fair, so if you don't find me before then grab me there.
Chris Holmes
Comments are closed.