Network representation Portal page: Incomplete representation of geo referenced records on the occurrence overview map

11661
Reporter: jlegind
Assignee: trobertson
Type: Bug
Summary: Network representation Portal page: Incomplete representation of geo referenced records on the occurrence overview map 
Priority: Major
Resolution: Fixed
Status: Closed
Created: 2012-08-09 09:48:00.686
Updated: 2013-12-17 15:23:04.106
Resolved: 2012-08-29 10:03:16.541
        
Description: The Switzerland network only displayed geo-referenced records from the MZL Lausanne publisher. This issue has been fixed manually by Tim. Network with IDs lower than 14 seem not to be affected, but the issue might resurface once we add a new network.

The issue stems from the fact that we add the maps before the network membership.

Tim R. workaround should be executed before rollover and is as follows:

-- Renews the network membership information for the country nodes
DELETE network_membership.*
FROM resource_network
JOIN network_membership ON resource_network.id = network_membership.resource_network_id
WHERE resource_network.name LIKE 'Resources hosted by%';

-- Renews the network membership information for the country nodes
-- step 2: generate new entries for network_membership based ON providers' iso country codes
INSERT INTO network_membership (data_resource_id, resource_network_id)
SELECT d.id, rn.id
FROM data_resource d
JOIN data_provider p ON d.data_provider_id = p.id
JOIN resource_network rn ON p.iso_country_code = rn.code
WHERE p.iso_country_code IS NOT NULL
AND d.deleted IS NULL;


]]>
    

Author: trobertson@gbif.org
Created: 2012-08-29 10:03:16.607
Updated: 2012-08-29 10:03:16.607
        
With http://code.google.com/p/gbif-occurrencestore/source/detail?r=1624