How to remove a dataset?

Submitted by kamrul.kashem on Mon, 14/03/2016 - 14:22 | Updated on Mon, 14/03/2016 - 14:22

Once a dataset has been added to data.gov.uk it seems that I cannot remove it? The contact page is also ineffective as I have been waiting for a response for a very long time now.

Does anyone know how to remove a dataset? 

 Flag as offensive 

Comments

Why do you want to remove a dataset?

Posted by exstat on Tue, 15/03/2016 - 12:17

I am probably coming at this from too restricted a background (statistical) but the practice there is not to withdraw out-of-date or even incorrect datasets but to mark them as obsolete or errorneous respectively. That enables users to determine what has been revised and also enables them to replicate or refine someone else's analysis without having to worry about whether the data have since changed.

I'm not sure whether that basis principel - once published, always available - is followed elsewhere. Instinctively I feel it should be but there may be good reasons not to. So I'm asking - what are the reasons for wanting to withdraw a dataset altogether?

 Flag as offensive 

Deleting datasets

Posted by Owen Boswarva on Tue, 15/03/2016 - 19:54

Hi Kamrul,

Following is a link to the relevant page in the Data.gov.uk guidance for users, publishers and sysadmins:

http://guidance.data.gov.uk/deleting_datasets.html

This indicates that only a system administrator can delete a dataset (or more precisely the catalogue entry for a dataset).

If you cannot get a response via the contact form I suggest shouting at them on Twitter. That usually works.

-- Owen Boswarva, 15/03/2016

 Flag as offensive 

Hi Kamrul,

Posted by rossjones on Tue, 15/03/2016 - 20:53

Hi Kamrul,

If you could point me at the dataset, and explain why you think it needs removing, I can certainly take a look at that for you.  If it is INSPIRE data you should be able to talk to the publisher admin to use the 'Withdrawn' link (your administrator is listed under the people icon at https://data.gov.uk/publisher/nottingham-city-council if you're not sure who it is). 

Ross.

 Flag as offensive 

You need to call

Posted by dhoom on Wed, 23/03/2016 - 06:30

You need to call TableCollection.Remove

m_dsSet.Tables.Remove(TableName);

 Flag as offensive 

How to remove a dataset?

Posted by wijnaldumwilliam on Sat, 02/04/2016 - 06:45

before you remove the table from the dataset try to clear all its constaints, something like this:

domain.Tables["TABLE_NAME"].Constraints.Clear();
should work and you should then be able to remove it from the dataset.

if you have the issue with PK Constraint which cannot be removed try this:

        var myTable = domain.Tables["TABLE_NAME"];

        for (int i = myTable.Constraints.Count - 1; i >= 0; --i)
        {
            if (myTable.Constraints[i] is System.Data.ForeignKeyConstraint)
            {
                myTable.Constraints.Remove(myTable.Constraints[i]);
            }
        }

 Flag as offensive 

Hello :)

Posted by wmelvin on Sat, 09/04/2016 - 03:08

I'm not certain whether that premise principel - once distributed, constantly accessible - is taken after somewhere else. Naturally I feel it ought to be however there might be great reasons not to. So I'm asking - what are the explanations behind needing to pull back a dataset through and through?

 Flag as offensive 
Login to make a comment

Forum categories

General discussion

127 topics

Using data

33 topics

Publishing data

24 topics

Police.uk data

22 topics

Open Data

20 topics

Tools and Applications

11 topics

Data Portal Setup

2 topics

Food hygiene rating data

2 topics

National Information Infrastructure

2 topics

More like this