I wand to edit .uci file for Hydrolgical Simulation Program-Fortran (HSPF)

Machine Learning and Modeling
#1

Hello
Currently I am editing the data for the hydrological model by trying to replace the part of evapotranspiration data with my observed data.

The original data that my hydrological model accepted is .uci.

Originally I opened and manually entered the number with notepad and excel (they can be opened as txt or csv but they file will be corrupted) to edit it but it corrupted and I could not use it for modeling. Then, I tried to find program to open and edit but can't.

Therefore now I attempted to open the file with R. I used the read.delim and read.csv function but neither worked.

Please let me what kind of order I should give so that I can open the file.

#2

Hi, and welcome!

uci is a somewhat obscure file extension. Can you provide an url for one (in case you don't mean University of California Irvine data).

#3

Happy new year! I received the uci. file from the organiztion I worked with and it is not the University of California Irvine data. and I didn't download it from a link

If you want I can send you the file, I can send it to you. Thank you.

#4

Is it a plaintext file or a binary?

#5

the file is plaintext.

#6

Great! Can you cut and paste 50 or so lines in plaintext?

#7

RUN
*** Rum River Watershed Model - 01-05-2015 RESPEC

*** Simulated from 1/1/1995 to 12/31/2009 using NLCD 20016 landuse
*** Calibrated Hydrology, Sediment, Temp, DO, Nutrients

*** 2016 Extension Updates CDL
*** - Timeseries extension through 2015
*** - SCHEMATIC uses UMN RSGAL 2013 Landuse
*** - Recalibration

GLOBAL
Rum WATERSHED MODEL (RRWM)
START 1995/01/01 00:00 END 2015/12/31 24:00
RUN INTERP OUTPT LEVELS 0 0
RESUME 0 RUN 1 UNITS 1
END GLOBAL

FILES
<UN#>***<----FILE NAME------------------------------------------------->
MESSU 31 Rum.ech
WDM1 28 MissRumMet.wdm
WDM2 29 Linkage.wdm
WDM3 30 Rum_Source.wdm

       21   Rum.out

BINO 22 wshd1mo.hbn
BINO 38 wshd2mo.hbn
BINO 39 wshd3mo.hbn
***BINO 23 pltgens/rch.hbn
BINO 23 rch1mo.hbn
BINO 24 rch2mo.hbn
BINO 25 rch3mo.hbn
BINO 26 rch4mo.hbn
BINO 27 rch5mo.hbn

END FILES

OPN SEQUENCE
INGRP INDELT 01:00

*** Pervious Categories
PERLND 330
PERLND 331
PERLND 332
PERLND 333
PERLND 334
PERLND 335
PERLND 336
PERLND 337

#8

This appears to be a file format developed by EPA for its BASINS/HSPF software. The current user manual does not appear to include more than limited support for file export.

I found one mention of R in connection with this format. However, there is not HSPF-SCE package on CRAN or github, although I did find one R program to read plotfiles

The source code for the EPA software is in Visual Basic. The most promising clue to exporting data from the BASINS program may provide the ability to export the data you need.

As far as I can tell, there's no public code to pull it in from R

#9

Thank you for your information. So, if I want to edit the file without corrupting it, should I have to open it with the Visual basic, or must I use WinHSPF?

#10

No, I'm pretty sure that you have to open it with the BASIN program, see if you can find an export function and, if not, modify the source code of the program in Visual Basic to create one. If it were me, I'd track down the source data that the uci file brings in through HSPF and work with it directly. But nothing is impossible for the man who doesn't have to do it himself.

#11

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.