ReefMaster rmdb file handling

Post tags: | bathymetry | fish_finder | hydrographic_charts | lake_mapping | mapping | reefmaster | reefmaster_rmdb | rmdp |
sqlite> .schema sonar_files
        CREATE TABLE "sonar_files" (
        "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , 
        "filename" TEXT NOT NULL, 
        "file_size" INTEGER NOT NULL, 
        "channel" INTEGER NOT NULL
        );
        
sqlite> .schema track_points
        CREATE TABLE "track_points" (
        "id" INTEGER PRIMARY KEY  AUTOINCREMENT  NOT NULL  UNIQUE , 
        "track_id" INTEGER NOT NULL , 
        "latitude" DOUBLE NOT NULL , 
        "longitude" DOUBLE NOT NULL , 
        "depth" DOUBLE NOT NULL , 
        "time_offset_ms" INTEGER , 
        "peak_sv" DOUBLE DEFAULT 0, 
        "e1" DOUBLE DEFAULT 0, 
        "e2" DOUBLE DEFAULT 0
        );
        
sqlite> .schema tracks
        CREATE TABLE "tracks" (
        "id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL ,
        "name" TEXT NOT NULL , 
        "start_time" TEXT, 
        "source_filename" TEXT,
        "cone_angle" INTEGER NOT NULL  DEFAULT (20) , 
        "tide_station_id" INTEGER, 
        "user_tide_points_id" INTEGER, 
        "tide_source" TEXT, 
        "keel_offset" INTEGER DEFAULT (0), 
        "time_zone_id" TEXT NOT NULL
        );
        
select id,source_filename from tracks where source_filename like '%sl2';
        1|\\VBOXSVR\reefmaster\Runyon_Lake\sonar_logs\Chart 09_08_2015 [0].sl2
        2|\\VBOXSVR\reefmaster\Runyon_Lake\sonar_logs\Chart 09_09_2015 [0].sl2
        3|\\VBOXSVR\reefmaster\Runyon_Lake\sonar_logs\Chart 09_09_2015 [1].sl2
        4|\\VBOXSVR\reefmaster\Runyon_Lake\sonar_logs\Chart 09_09_2015 [2].sl2
        5|\\VBOXSVR\reefmaster\Runyon_Lake\sonar_logs\Chart 09_09_2015 [3].sl2
        6|\\VBOXSVR\reefmaster\Runyon_Lake\sonar_logs\Chart 09_10_2015 [0].sl2
        
select id,source_filename from tracks where source_filename like '%sl2';
        
        SELECT
          track_points.latitude,
          track_points.longitude
        FROM
          tracks
        JOIN
          track_points
        ON
          tracks.id = track_points.track_id
        WHERE
          tracks.source_filename LIKE '%sl2'