Skip to main content

Integrated groundwater and surface water modeling: restore the stream index relationship

Numerical hydrology models usually require the stream index to be built prior to the actual simulation.
It is also good practice to keep them in order so it is much easier to analyse the results.

Here I have provided an examples how it could be done using some scripts and ArcMap.
After the drainage line is defined from watershed delineation process such as using Arc Hydro tool.
The resulting attribute table will be like this:

First, it is good practice to make a copy of the file. Then we need to "Delete" unwanted fields and only keep the HydroID, GridID and NextdownID fields.
Then export the attribute table into a text file and run the IDL routine "restore_drainageline_spatial_relationship", which will produce a new index for each stream segment.
You can copy the created text file content into the Microsoft Excel for next step.
Then edit the drainage shapefile feature and replace the HydroID and NextdownID fields using the just copied indices in the Excel.
After this, the spatial relationship is restored but not sorted in the attribute table. We can use the "Sort" tool is sort them using HydroID field. 

The final attribute table will be like this:
Well done! This attribute table is ready for other operations.

Please leave a comment if you have questions!
Thank you!


Popular posts from this blog

Spatial datasets operations: mask raster using region of interest

Climate change related studies usually involve spatial datasets extraction from a larger domain.
In this article, I will briefly discuss some potential issues and solutions.

In the most common scenario, we need to extract a raster file using a polygon based shapefile. And I will focus as an example.

In a typical desktop application such as ArcMap or ENVI, this is usually done with a tool called clip or extract using mask or ROI.

Before any analysis can be done, it is the best practice to project all datasets into the same projection.

If you are lucky enough, you may find that the polygon you will use actually matches up with the raster grid perfectly. But it rarely happens unless you created the shapefile using "fishnet" or other approaches.

What if luck is not with you? The algorithm within these tool usually will make the best estimate of the value based on the location. The nearest re-sample, but not limited to, will be used to calculate the value. But what about the outp…

Numerical simulation: ode/pde solver and spin-up

For Earth Science model development, I inevitably have to deal with ODE and PDE equations. I also have come across some discussion related to this topic, i.e.,

In an attempt to answer this question, as well as redefine the problem I am dealing with, I decided to organize some materials to illustrate our current state on this topic.

Models are essentially equations. In Earth Science, these equations are usually ODE or PDE. So I want to discuss this from a mathematical perspective.

Ideally, we want to solve these ODE/PDE with initial condition (IC) and boundary condition (BC) using various numerical methods.

Because of the nature of geology, everything is similar to its neighbors. So we can construct a system of equations which may have multiple equation for each single grid cell. Now we have an array of equation…

Lessons I have learnt during E3SM development

I have been involved with the E3SM development since I joined PNNL as a postdoc. Over the course of time, I have learnt a lot from the E3SM model. I also found many issues within the model, which reflects lots of similar struggles in the lifespan of software engineering.

Here I list a few major ones that we all dislike but they are around in almost every project we have worked on.

Excessive usage of existing framework even it is not meant to Working in a large project means that you should NOT re-invent the wheels if they are already there. But more often, developers tend to use existing data types and functions even when they were not designed to do so. The reason is simple: it is easier to use existing ones than to create new ones. For example, in E3SM, there was not a data type to transfer data between river and land. Instead, developers use the data type designed for atmosphere and land to do the job. While it is ok to do so, it added unnecessary confusion for future development a…