Skip to content

Latest commit

 

History

History
51 lines (41 loc) · 2.1 KB

Readme.md

File metadata and controls

51 lines (41 loc) · 2.1 KB

Animal Movements to a Carto dataset

A python tool for publishing select data from the Animal Movement database (an internal SQL Server) to a hosted Carto or an on-premises Carto database. The hosted account was copied to an on-premises server in November of 2019 and is no longer active. The tool keeps track of what data has already been published, and only pushes changes. It is best run as a scheduled task.

Biologists with data in Animal Movements must elect to publish their data in Carto. Currently only the Katmai Bear data is being published. Locations are filtered by project and location (if an animal goes outside the protection of the park, its location is not published).

The services are at https://carto.nps.gov/user/nps-akro-gis. Prior to November 2019, they were at https://nationalparkservice.carto.com/u/nps-akro-gis

Build

The code is run with Python 2.7 or 3.x. It depends on the pyodbc module and the carto module. These can be installed with pip install pyodbc and pip install carto.

Copy the carto_secrets.py.example file to carto_secrets.py and edit with your cartodb account and an API Key. AKRO GIS staff can find these and a completed carto_secrets.py file in the password keeper on the team network drive.

Deploy

The code requires tables be created in the source database and on the Carto server. Those tables have already been created for the current configuration. (Using the commented out first two lines of the main function in upload.py.) If this code is being used in a new configuration, it will require a lot of modification, as the existing DB schema is hard coded throughout the file.

Using

Once the tables have been created, the upload.py script can be run as often as desired. It is running daily as a scheduled task on the AKRO GIS servers. It needs to be run with an account that has viewer privileges in the source database.