Daily Archives: September 27, 2022

Carlson’s .CRDB Format Notes

The Carlson .CRD format has been around for a long time and it is fairly well documented.

The .CRDB format was released around version 5.04, but really become dependable and useful with the release of 5.06 in August 2017. The ‘new’ .CRDB format expands the size of the point name from 9-characters and the size of the point description from 31-characters to 255 characters each.

If you change the extension of the .CRDB file from .CRDB to .SQLite, then you can use any standard SQLite client (like ‘DB Browser’: https://sqlitebrowser.org/dl/#windows ) to view the structure:

The structure of a .CRDB (aka .SQLite) file.

and the contents:

Typical contents of a .CRDB file.

I am not sure if point names longer than 9 characters are a good thing and I personally have preferred 4-character point names in the range 0000 to 9999 for years, but I guess I understand STK1024, but extending the descriptions to 255 characters is certainly welcome.

There are also a lot of open source SQLite clients that make reading, writing, sorting, searching, record deletion, db compressing and cleaning for SQLite files very dependable and fast.

I don’t think there any disadvantages to making .CRDB files other than very old versions of SurvCE won’t be able to open them and many 3rd party tools are not .CRDB aware.

3 Comments

Filed under Carlson