Reply To: Identifying transition group IDs

Deliver geospatial models direct to decision makers with SyncroSim › Forums › ST-Sim & State-and-Transition Simulation Models › Identifying transition group IDs › Reply To: Identifying transition group IDs

May 16, 2018 at 1:39 pm #6045
leonardo-fridleonardo-frid
Keymaster

Hi Kevin,

Yes, this is an internal code that is the primary key to the table. We are planning to have a way to access these codes that are project definition ID values in an upcoming release. In the meantime you can use the following code that requires the RSQLite package:

> library(RSQLite)
> myLibPath = “Path to your library/myLibrary.ssim”
> mySQLStatement = “Select TransitionGroupID, Name From STSim_TransitionGroup Where TransitionGroupID = 489”
> myLib = dbConnect(RSQLite::SQLite(), myLibPath)
> dbGetQuery(myLib, mySQLStatement)
TransitionGroupID Name
1 489 Fire

Note that if you remove the where clause from the SQL statement you will get all the transition groups and their corresponding ID values.

Let me know if you have any questions.

Regards,
Leonardo