Hi Jakob, I have to to the same thing except that I use DB2/Spatial Extender.
some hints 1) Configure the whole stuff using batch jobs, starting from an empty database. I developed a Java utility using geotools and jdbc to do ALL configuration actions (starting from importing shape files,creating tables and ending with Geoserver REST configuration). 2) Import your vector data. If your geometries have a lot of vertices, you may consider using http://docs.geoserver.org/stable/en/user/data/featurepregen.html 3) If you have raster data and want to store your images in postgis, consider http://docs.geoserver.org/stable/en/user/data/imagemosaicjdbc.html Btw, there is a new feature called WKT Raster. Until now, it is not supported, adding support is not a big challenge, look here http://docs.geoserver.org/stable/en/user/data/customjdbcaccess.html. Give me a ping if you want to go with WKT Raster. 4) Configure Geoserver using the REST API. 5) To join your "normal" data with geometries to generate layers, I would recommend http://gridlock.openplans.org/geoserver/trunk/doc/en/user/data/sqlview.html This avoids creating a lot of SQL Views. This feature is supported starting with Geoserver 2.1 beta. 6) Be patient :-). You cannot build a good geodata infrastructure within one week. so far, so good Christian ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
