2014-10-28 12:04 GMT+00:00 Mark Goodge <[email protected]>: > This may be a somewhat off-topic question, but my google-fu has failed me > and I'm sure there will be someone knowledgeable on here with the answer! > > Are EU constituencies a superset of Westminster parliamentary > constituencies? That is, is every Westminster constituency wholly contained > within its applicable EU constituency? Or are there any UK constituencies > which are partly in one EU constituency and partly in another? >
European Electoral Regions are essentially groupings of counties: http://www.legislation.gov.uk/ukpga/2002/24/schedule/1 (with the obvious exceptions of Greater London, Isles of Scilly and Gibraltar). It used to be the case that constituencies could cross county boundaries, but I am not sure if that is still true. > The reason I'm asking is that this influences the database design on a > project I'm working on. If a UK constituency is only ever in one EU > constituency, then a simple eu_constituency_id field in the uk_constituency > table is sufficient. But if they can overlap more than one EU constituency, > then I'm going to need a pivot table to make the link. Wikipedia has a sparql endpoint that I've used in the past and there appears to be an "overlaps" relation from parliamentary constituencies to European Electoral Regions, so maybe that would allow you to tell. My hunch is that even if there is a 1-many relationship now, that may not be reliably true in the future. -- Francis Davey
_______________________________________________ developers-public mailing list [email protected] https://secure.mysociety.org/admin/lists/mailman/listinfo/developers-public Unsubscribe: https://secure.mysociety.org/admin/lists/mailman/options/developers-public/archive%40mail-archive.com
