enable goepa columns - Giswater/giswater_dbmodel GitHub Wiki

In order to export only network ARCS & NODES ready to work with EPA, there are three columns to manage it. That columns are:

epa_type:
Epa_type is the column wich commands the EPA side. In addition, to do not export some element you can define it with epa_type 'UNDEFINED' which it means that the element haven't equivalent object on EPA side.

sector_id:
Sectors are the EPA mapzones. Only will be exported those sectors wich user has previously selected. To do not export some element, you may set sector_id wich is not selected.

state_type:
State_type is a child value for state wich you can use to define your own states. The key point is that will be exported only those elements wich have the state_type with is_operative true. Please check table value_state_type for more information.

A additional rule works for NODES on the exportation. NODES always will be exported if they are extremal nodes of some arc wich have been exported, ignoring the own values for epa_type, sector_id, and state_type detailed before.