converting an "CSV" / "ASCII Gridded XYZ" file to grid DSS

[bayejja-Med]

Hello everybody,

I wonder to know how to make a first conversion to one of the supported formats of Vortex (nc; grib; hdf; asc) in order to generate a dss dataset later.

here is my initial dataset : P_data.zip

Thanks

[tombrauer]

I looked at the files in P_data.zip and they don't have an extension. It will be difficult to impossible to do a conversion on an unknown file type. I would go back to the originator and try to determine the file type.

[bayejja-Med]

@tombrauer the data is an hourly forecasted precipitation.

Opening it in QGIS it shows this information :

Data type Float32 - Thirty two bit floating point GDAL Driver Description XYZ GDAL Driver Metadata ASCII Gridded XYZ

[tombrauer]

If the data is ASCII, add the *.asc extension to the files, and then Vortex should be able to process.

[bayejja-Med]

Unfortunately, it is still not working.

I think of using HEC MetVue which is supposed to handle this.

I remain open to other suggestions

Thanks

[bayejja-Med]

@tombrauer

I found out that my data is given in CSV format (see the screen shot below)

Each file contains the following information:

• each time step (1 hour) is given in a single CSV file,
• each CSV file contains three columns: longitude, latitude, and precipitation.
• the time interval is given in the name (see the second screenshot below)

[tombrauer]

@bayejja-Med I don't know of this as a conventional file type. Vortex has not been programmed to recognize it. I would use a programmatic approach, i.e. scripting, to get the data into HEC-DSS.

[ktarbet]

I had a similar request to convert a non-standard CSV data to DSS. I suggested first converting data to ASCII grid format; Perhaps multiple ASCII files, one for each grid. Here is an example:

https://github.com/HydrologicEngineeringCenter/DSSVue-Example-Scripts/blob/master/src/grids