Thank you! That answers my question. We need to work on the database.
On Tue, Aug 8, 2017 at 3:32 PM, Ben Caradoc-Davies <b...@transient.nz> wrote:
Advertising
> On 09/08/17 04:52, Gavin Medley wrote:
>
>> I have the data for siteName and iersDOMESNumber in Table1 and the data
>> for
>> monumentDescription and heightOfTheMonument in Table2. Can I use a single
>> XML mapping file to map those two tables to the elements of
>> siteIdentification?
>>
>
> No, there is a one-to-one relationship between a feature type and the
> database relation that provides its identity.
>
> The two workarounds that I have considered are 1) Making a new
>> feature-chained mapping file for each element that needs to be mapped
>> (ugh!) or 2) making a new view or table to bring in any data that needs to
>> be mapped to the same level of the XML schema.
>> What would you suggest?
>>
>
> If the attributes are single-valued, then a database view or table is an
> excellent solution: fast and simple. This is also an opportunity to use
> fast database-side string concatenation to construct identifiers such as
> gml:id or HTTP URIs. You can even index them for performance.
>
> Kind regards,
>
> --
> Ben Caradoc-Davies <b...@transient.nz>
> Director
> Transient Software Limited <http://transient.nz/>
> New Zealand
>
--
Gavin Medley
Software Engineer I
*UNAVCO*
6350 Nautilus Drive
Boulder, CO 80301-5394
med...@unavco.org
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
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
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
