SELECT p.provider_id, p.uddi_business_key, p.name, p.town, p.country, p.latitude, p.longitude, p.home_url, firstjoin(d.protocol_fk) as protocol, count(d.datasource_id) as num_datasources
FROM registry.provider p
LEFT JOIN registry.datasource d ON provider_id=provider_fk
WHERE active_flag = true
GROUP BY p.provider_id, p.uddi_business_key, p.name, p.town, p.country, p.latitude, p.longitude, p.home_url
ORDER BY p.name
Full list of BioCASE and DiGIR provider. This data is taken directly from the BioCASE registry based on the GBIF UDDI.
-
#name# (home)
#name#
#protocol# provider with #num_datasources# datasource(s) in #town#, #country#
-> GBRDS
