Hi,
Your concerns mostly Postgresql/PostGIS and you will get best answers from the corresponding mailing lists. I try to give you some first aid with the two months user experience I have about PostGIS.
In order to make spatial queries fast you need to create a spatial index for your table. How to do it should be found from the documents, there are not many options in it. For fast attribute queries you probably need also other, normal indexes but for what columns etc. debends on your data and the queries you will most often run.
Spatial_ref_sys is a library about parameters needed when transforming coordinates from one system to another. In normal case you dot need to bother about this table but it is enough that you have it. You can, for example, update a whole spatial table from original projection to WGS84 lat/lon system by giving "update my_table set geom=transform(geom,4326);"
Only if some of the projections you are using is missing from the spatial_ref_sys table you need to do a bit more work by adding a new line for defining that projection.
And then geometry_columns. That table tells what data tables have columns with spatial data, what is the name of the spatial column, what type of geometric features are stored in that column (points, linestrings, polygons etc.), if they are two or three dimensional, and in what projection they are stored. Client programs (like GeoServer) are using use geometry_columns table when contacting PostGIS server for building a list about available spatial tables.
I hope this information is at least close to correct and of some value for you.
-Jukka Rahkonen-
-----Alkuperäinen viesti-----
Lähettäjä: geoserver-users-bounces@lists.sourceforge.net puolesta: Du-Feu
Lähetetty: to 28.2.2008 18:11
Vastaanottaja: geoserver-users@lists.sourceforge.net
Aihe: [Geoserver-users] WFS Datastore Setup/Design Howto?
Hi,
I'm attempting to setup GeoServer to act as a WFS to store and serve
locations of certain landmarks throughout the UK.
So far I have successfully installed the GeoServer WAR and connected to a
PostgreSQL DB that has PostGIS enabled. I even created a simple two column
table and retrieved all the data with a very basic WFS GetFeature request.
However, for my real application I obviously need to have a more complicated
table and for efficiency will need to be able to filter by bounding box.
I've spent days reading pretty much everything I can find on the GeoServer
website and various google searches but haven't been able to find any
guidelines on how to do something like this correctly.
Can someone please point me in the direction of a guide on how to use
PostgreSQL correctly? In particular how the geometry_columns and
spatial_ref_sys tables work?
Thanks
--
View this message in context: http://www.nabble.com/WFS-Datastore-Setup-Design-Howto--tp15739871p15739871.html
Sent from the GeoServer - User mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users