Hi all, Nearly new to geoserver after quite a few years away. I have a small project I'm undertaking and want to get some advice about the most efficient methods to use.
So I've installed the basic install of geoserver and I've published some administrative boundaries using a geopackage data store. This has worked well and has been so much easier than I remember! What I need to do now is work out the most appropriate method for linking a non-spatial table to a spatial table that can be used to generate a new geoserver vector layer. 1. The non spatial table contains incidents linked to local government districts (LGD) - one incident covers multiple LGD, therefore the non spatial table has multiple records per incident. 2. The spatial table is stored as geopackage, has been published to geoserver and is a definite dataset of LGD. 3. I want to create a new dataset (incidents by LGD layer) that spatially enables the list of incidents so that each record is associated with a LGD boundary. Id like to publish this as one geoserver layer. 4. Id then like to create a second dataset that merges the incidents by LGD layer by incident id. This layer will then represent the footprint of an incident as one feature and sunmarise the numeric attributes of each LGD that forms an incident. The questions I have are: 1. Can I automate spatially enabling the non spatial data using geoserver? Or do I need to preprocess this using QGIS etc. 2. Can geoserver handle dissolving the incidents by LGD layer to create the incidents footprint? 3. Id like to keep the physical tables/data as minimal as possible and use geoserver etc to do as much on the fly processing as possible - is this possible? Apologies If this isn't clear but jut trying to understand the capability of geoserver to handle the processing of data (wfs writing to geopackage?) As well as the visualisation of data. Many thanks, James
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
