Exporting to Statistical Programs - NAVADMC/ADSM GitHub Wiki

This page contains a few notes that could be useful when manually exporting to a Statistical program.

ADSM scenarios are stored as SQLite3 database files which can be opened by many other types of programs
ADSM Input parameters and Results are currently stored in the same file
Parameters are in tables starting with Scenariocreator_ and results are in tables starting with Results_
Scenarios are stored in the workspace /Documents/ADSM Workspace/ by default
Supplemental Files (including the Population Map) are stored in a subdirectory in the workspace using the Scenario name
In the ADSM Workspace, there is a directory of Example Database Queries which are SQL queries with documentation that can be used as a starting place for querying the results. There is also an Example R Code directory to assist with getting started using R code
You can use the built-in database browser in ADSM under Settings (the gear icon) and select "Advanced Panel"
- If you prefer tabular format, we use a variety of programs like SQLite Administrator - (discussion).
- Another query tool option is an add on to Firefox called SQLIte Manager. It is user friendly.
- Microsoft Access can be used to access the SQLite database. It requires the installation of the correct driver.

If you are looking at the raw values inside of a database file, these are the codes used for Unit status:

Programs Analysts use