Generating surrogates for EGrid using the new PostgreSQL Surrogate Tool

I am able to use the new PostgreSQL Surrogate Tool to generate surrogates for a RegularGrid. However, I couldn’t figure out how to use it to generate surrogates for EGrid. Is EGrid supported by the PostgreSQL Surrogate Tool?

Can you be more specific about EGrid? What is EGrid? We are not familiar with it.

Thank you very much BH for the response. EGrid is one of the three grid types supported by the Surrogate Tool. The other two are RegularGrid and Polygon, see https://github.com/CMASCenter/Spatial-Allocator/blob/master/docs/User_Manual/SA_ch05_surrogate.md#postgres.

For Egrid, each grid cell is defined by the lat,lon of the center and four corners of the grid cell. Below is the definition of the first grid cell copied from the egrid definition example file (egrid_arc.dat) included in the SA package:
1,-129.98386385,13.29411745
-130.0628510,13.26581573
-130.0104980,13.36450863
-129.9048767,13.32235336
-129.9572906,13.22372627
-130.0628510,13.26581573
end

Thanks again!

hi,
could you send me some guide for new PostgreSQL tool? I am working on the surrogate file using the old srgtools. However, it works slowly.

I don’t think it has been officially released yet. However, scripts and instruction of how to use it are included in the latest SA-TOOLS version 4.3.2 downloadable from the CMAS website https://www.cmascenter.org/sa-tools/, see also https://www.airqualitymodeling.org/index.php/PostgreSQL_Surrogate_Tool for how to install this tool. I need it to generate surrogates for processing emissions using the EPA 2014/2014/2016 emissions inventory.

Junhua, We are getting close to releasing this product. We would appreciate your feedback on how it is working for you once it is released. I don’t have the exact release date but it should be sometime in the next few weeks.

image001.jpg

image002.jpg

@junhua.zhang. Egrid is not currently tested with upcoming PosgreSQL surrogate tool yet but conceptually it can be processed through PostgreSQL tool once you set Egrid as polygon output modeling domain shape.