healthsites icon indicating copy to clipboard operation
healthsites copied to clipboard

Duplicated records in docker osm

Open nixilla opened this issue 3 years ago • 0 comments

Example:

SELECT * from osm_healthcare_facilities_node WHERE osm_id = 8132683977;

returns 2 records:

-[ RECORD 1 ]-------+----------------------------------------------------------------------
id                  | 677420
osm_id              | 8132683977
amenity             | hospital
healthcare          | Operating,Theater,Laboratory,Intensive Care Unit,Emergency Department
name                | Centre de Santé de Gossas
operator            | MINISTERE DE LA SANTE ET DE L'ACTION SOCIALE
source              | #senegal #covid-19 #emergency-health-data #healthsites
speciality          |
operator_type       | Public
contact_number      |
operational_status  | Operational
opening_hours       |
beds                | 12
staff_doctors       |
staff_nurses        |
health_amenity_type |
dispensing          |
wheelchair          | yes
emergency           | yes
insurance           |
water_source        | water works
electricity         | Power grid
is_in_health_area   |
is_in_health_zone   |
url                 |
addr_housenumber    |
addr_street         |
addr_postcode       |
addr_city           |
addr_country        |
geometry            | 0101000020E61000006019CA47F91030C0D0A6092AD5FB2C40
changeset_id        | 101739681
changeset_version   | 6
changeset_timestamp | 2021-03-25 18:38:55
changeset_user      | Lamine Ndiaye
-[ RECORD 2 ]-------+----------------------------------------------------------------------
id                  | 757636
osm_id              | 8132683977
amenity             | hospital
healthcare          | Operating,Theater,Laboratory,Intensive Care Unit,Emergency Department
name                | Centre de Santé de Gossas
operator            | MINISTERE DE LA SANTE ET DE L'ACTION SOCIALE
source              | #senegal #covid-19 #emergency-health-data #healthsites
speciality          |
operator_type       | Public
contact_number      |
operational_status  | Operational
opening_hours       |
beds                | 12
staff_doctors       |
staff_nurses        |
health_amenity_type |
dispensing          |
wheelchair          | yes
emergency           | yes
insurance           |
water_source        | water works
electricity         | grid
is_in_health_area   |
is_in_health_zone   |
url                 |
addr_housenumber    |
addr_street         |
addr_postcode       |
addr_city           |
addr_country        |
geometry            | 0101000020E61000006019CA47F91030C0D0A6092AD5FB2C40
changeset_id        | 101739681
changeset_version   | 6
changeset_timestamp | 2021-03-25 18:38:55
changeset_user      | Lamine Ndiaye

And the exact error message that comes out is here:

http://sentry.kartoza.com/sentry/healtsitesio/issues/1468/

MultipleObjectsReturned get() returned more than one LocalityOSMNode -- it returned 2!

nixilla avatar Mar 30 '21 11:03 nixilla