All documentation is available via the SPI website . A copy of the SPI database used for data entry of wildlife observation projects. Contains data-sets that are being worked on or are waiting for final quality assurance. Finished data sets are migrated to the SPI Operational database by the person who is responsible for quality assurance. Security flags for data that is in-draft or is sensitive are set during the migration process.
Users can only access the projects that they are responsible for.
No users have SQL access to the base tables. Inventory Operational Database A copy of the SPI database that is used to query finished data sets. Most of the data is read-only. Georeference, Document References and Species-Codes may be corrected if necessary. Contains denormalized data in the Wildlife Observation table to improve the ability to query data.