healthsites
healthsites copied to clipboard
Duplicated records in docker osm
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!