weecology / pydataweaver

The Pydata Weaver: A data Integration platform
Other
9 stars 5 forks source link

Example data joins #14

Closed ethanwhite closed 4 months ago

ethanwhite commented 7 years ago

Breeding Bird Survey routes with Bioclim (spatial)

Use the Retriever to install breed-bird-survey. The routes table has columns for latitude and longitude. Merge with the Bioclim data, which can also be downloaded with the retriever:

retriever download Bioclim

The dataset has 19 .bil files, one for each of 19 different variables.

Extract the values from one or more of the .bil rasters for each of the locations in the routes file.

Mammal Community Database with Bioclim (spatial)

Same as above but using the latitude and longitude column in the sites table in the mammal community database

Breeding Bird Survey with bird-size (tabular)

Using the species and genus columns join the two datasets to add a mass to each species in the breeding bird species table.

This can be combined with the spatial example above.

Elevation data with forest inventory analysis (spatial)

Extract elevations for every plot location in the forest-inventory-analysis data using elevation data from https://nationalmap.gov/3DEP/ (see the Get Data link).