Re: Enforcing uniqueness on [real estate/postal] addresses - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: Enforcing uniqueness on [real estate/postal] addresses
Date
Msg-id 20200512213136.GA2363@hermes.hilbert.loc
Whole thread Raw
In response to Re: Enforcing uniqueness on [real estate/postal] addresses  (Peter Devoy <peter@3xe.co.uk>)
List pgsql-general
On Tue, May 12, 2020 at 09:55:56PM +0100, Peter Devoy wrote:

> >Is is possible to have two entries which have the same
> >address_identifier_general, street and postcode, but different
> >descriptions?
>
> Unfortunately, yes.  The data comes from gov't systems to
> regulate the development/alteration of arbitrary pieces of property and
> those pieces do not always have a postal address.  E.g. a farmer may
> one year apply to erect a wind turbine in "field north of Foo Cottage"
> and the next year apply to demolish "barnhouse west of Foo Cottage".

LAT/LON ?

https://plus.codes/ ?

Best,
Karsten
--
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B



pgsql-general by date:

Previous
From: Peter Devoy
Date:
Subject: Re: Enforcing uniqueness on [real estate/postal] addresses
Next
From: TalGloz
Date:
Subject: Re: Upgrade Process Says "The database server was not shut downcleanly" but it was