How to export displacement values from a time series in table format?

[Esteban Martinez]

Hello everyone,

I am working with a time series generated from satellite images processed with HyP3. My goal is to extract displacement values corresponding to a specific point and export them to a table (CSV, Excel, etc.) for comparison with other data.

I have reviewed the documentation, but I cannot find a straightforward way to do this. Currently, I use the cumulative displacement map and the time series tool in the data viewer, but I have not found a direct method to extract these values in a format that allows me to work with them in a spreadsheet.

Does anyone know how to efficiently extract and export these values?

Any suggestions or scripts would be greatly appreciated. Thanks in advance!

[张光辉]

save_qgis.py

QGIS - MintPy  

[Sayyed Mohammad Javad Mirzadeh]

Hi Esteban,

You can write a simple Python or Matlab code to open the time series file (in *.h5 format) and save the data with the coordinates from the "geometry.h5" file inside the "inputs" folder.

Sincerely,

Sayyed

[曹博涵]

I remember that "tsview.py" can save the timeseries table as ASCII table by assigning a point yx (or lalo).

Like the code below:

tsview.py timeseries.py --yx 1269 2669 --nodisplay

The output name will be  "y1269x2669_ts.txt", and the content will be like the attached figure.

Does it help for you?

Sayyed Mohammad Javad Mirzadeh 在 2024年11月21日 星期四中午12:30:52 [UTC+8] 的信中寫道：

[Esteban Martinez]

Thank you all for your comments! To export the data, I used the following line of code:

!save_qgis.py timeseries.h5 -g inputs/geometryGeo.h5 -o ts.sh

With this, I consider the inquiry resolved. Thanks again!