Re: [las_users] LAS V7 : Unable to make intermediate netCDF file.

[Roland Schweitzer <Roland.Schweitzer@xxxxxxxx>]

Efren,

Unfortunately, I cannot read these data.  However, looking at the schema it appears that the data you want to write to the netCDF file is stored in a mySQL "blob".  The database backend service does not know how to deal with blobs.   It expects the data variables to be one of the mySQL numeric data types.  Is it possible to represent these data as a numeric data type?

Roland

Serra, Mr. Efren, Contractor, Code 7542 wrote:

Roland,

 

That’s progress, I thought.  Here’s describe profiles_bak (t is supposed to be a multivalued key):

 

 

mysql> describe profiles_bak;

+----------------------+-----------------+------+-----+---------+-------+

| Field                | Type            | Null | Key | Default | Extra |

+----------------------+-----------------+------+-----+---------+-------+

| profile_id           | varchar(25)     |      |     |         |       |

| t                    | double unsigned | YES  |     | NULL    |       |

| x                    | float(6,3)      |      |     | 0.000   |       |

| y                    | float(5,3)      |      |     | 0.000   |       |

| zlo                  | smallint(6)     |      |     | 0       |       |

| zhi                  | smallint(6)     |      |     | 11000   |       |

| float_id             | varchar(10)     |      |     |         |       |

| n_levels             | smallint(6)     |      |     | 1       |       |

| dac                  | char(2)         | YES  |     | NULL    |       |

| prof_path            | varchar(80)     |      |     |         |       |

| mode                 | char(1)         |      |     |         |       |

| data_state_indicator | varchar(4)      | YES  |     | NULL    |       |

| direction            | char(1)         | YES  |     | NULL    |       |

| position_qc          | smallint(6)     | YES  |     | NULL    |       |

| profile_pres_qc      | smallint(6)     | YES  |     | NULL    |       |

| profile_temp_qc      | smallint(6)     | YES  |     | NULL    |       |

| profile_psal_qc      | smallint(6)     | YES  |     | NULL    |       |

| pres                 | blob            | YES  |     | NULL    |       |

| temp                 | blob            | YES  |     | NULL    |       |

| psal                 | blob            | YES  |     | NULL    |       |

| pres_qc              | blob            | YES  |     | NULL    |       |

| temp_qc              | blob            | YES  |     | NULL    |       |

| psal_qc              | blob            | YES  |     | NULL    |       |

+----------------------+-----------------+------+-----+---------+-------+

23 rows in set (0.00 sec)

 

mysql>

 

mysql> SELECT pres,y,x,t,temp FROM profiles_bak WHERE (temp<99999.0 OR temp>99999.0) AND ((x>=-180.0) AND (x <=179.0)) AND ((y>=-90) AND (y<=89)) AND ((pres>=0) AND

(pres<=5000)) AND ((t>=349069.0) AND (t<=349069.0));

 

| 33�@33AfffA33�A33�ff�BffB                                                                                                                                                                                                                                                                                                                                                                                                                                             | -29.946 |   35.265 | 349069 | ���A���A���A\��A�n�Aj�A��A�E�Ad;�A?5�A'1�A-�A��A��A���A��AZ�A�A�ƤA�A+�A�C�Aw��A��A���Ash�A�A�A���A�7��A��AZ�A�ĔAb�A��A��A��A��A�l�AZ�AV�AT��t�A�ȅAJ

 

[...]