Batch Editing

We have made much use of Batch Editing in Specify 6. It is necessary for us to be able to transition to Specify 7.

5 Likes

This is a feature we would welcome as well in Specify 7.

Batch Edit is a required feature for our workflow as well. We use this tool for quickly adding data to multiple records at once and also quality control. It would be even more useful if Batch Edit capabilities were expanded to include additional tables.

We also need batch editing in Specify7 for several of our institutions, especially those that cannot use Specify6 due to technical reasons.

Hi all,

Could you share with us examples of workflows you are using with the BatchEdit tool? We are discussing implementation and development of batch editing in Specify 7.

We use Batch Edit to help standardize and fill in missing Geography data. This is especially useful when we have many specimens with similar Locality Names, but varying levels of Geography data available on the specimen labels & database records. We conduct Georeferencing based on units in the Geography tree; when there is too much missing data in the Locality, we don’t georeference them in our typical workflow.

For example, we have many specimens with the Locality Name ‘Lake Sunapee, N.H.’, and the lake is actually on the border between Merrimack and Sullivan Counties. Without further research, these specimens are transcribed with the State and Locality name, but no County. In Batch Edit, we can add County and get these records into our typical georeferencing workflow.


1 Like

Hi Grant,

In addition to resolving duplicate localities with (numerous!) spellings and typos, we often clear up inconsistencies for easier searching. For example, the “verbatim locality” for many specimens may have been listed in one place, but was entered by sundry volunteers with different lots in different ways. One example:

These are a few items from one collecting event at one locality; “Verb Locality” needs to be the same (the Locality Names also need to be resolved).

Note that I already resolved hundreds of these in this donation using batch editing. Another example:

These are all the same locality. They do not necessarily need the same “Verb Locality”, but adding collector and collection date to the query would allow grouping them by the same verbatim location.

Thanks,

Larry J. Van Stone

Data and Mollusk Specialist

Delaware Museum of Nature and Science

I also echo the request by gholman that additional tables be made accessible to batch editing. Ideally, it would include ALL tables, but I know that the deeper in a schema a query reaches, the longer the SQL gets, so the programmers will probably need to take this in stages.