| From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Enforcing uniqueness on [real estate/postal] addresses |
| Date: | 2020-05-12 21:31:36 |
| Message-ID: | 20200512213136.GA2363@hermes.hilbert.loc |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 ?
Best,
Karsten
--
GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B
| From | Date | Subject | |
|---|---|---|---|
| Next Message | TalGloz | 2020-05-12 21:51:05 | Re: Upgrade Process Says "The database server was not shut down cleanly" but it was |
| Previous Message | Peter Devoy | 2020-05-12 20:55:56 | Re: Enforcing uniqueness on [real estate/postal] addresses |