27.2. Data

Data

If you want to check the layout distribution, you can go to Form Parts

The fields in the layout lyt_top_1 are:

Node Type: node_type - Node type. It is automatically populated based on nodecat_id
  • Datatype: String.
  • Mandatory: Sí.
  • Editable: No.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM cat_feature_node WHERE id IS NOT NULL
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
    • labelPosition (top): If this value is defined [top, left, none], the label will occupy the relative position with respect to the widget. By default, left is understood. If the label field is empty, labelPosition is omitted.
    • valueRelation:
      • layer: ve_cat_feature_node
      • activated: True
      • keyColumn: id
      • nullValue: False
      • valueColumn: id
      • filterExpression: None
Nodecat Id: nodecat_id - nodecat_id
  • Datatype: String.
  • Mandatory: Sí.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM cat_node WHERE id IS NOT NULL AND active IS TRUE
  • Filterc: The previous query is filtered by: AND cat_node.node_type IS NULL OR cat_node.node_type
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
    • labelPosition (top): If this value is defined [top, left, none], the label will occupy the relative position with respect to the widget. By default, left is understood. If the label field is empty, labelPosition is omitted.
    • valueRelation:
      • layer: cat_node
      • activated: True
      • keyColumn: id
      • nullValue: False
      • valueColumn: id
      • filterExpression: None
Epa Type: epa_type - Type of node to use for the hydraulic model. It is not necessary to enter it, it is automatic depending on the node type.
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM sys_feature_epa_type WHERE active AND feature_type = 'NODE'
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
    • labelPosition (top): If this value is defined [top, left, none], the label will occupy the relative position with respect to the widget. By default, left is understood. If the label field is empty, labelPosition is omitted.

The fields in the layout lyt_data_1 are:

Code: code - code
  • Datatype: Text.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Top Elev: top_elev - top_elev
  • Datatype: Double.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • autoupdateReloadFields (['sys_top_elev', 'sys_ymax', 'sys_elev']): Instantly reloads other fields if one is modified. Acts in combination with isautoupdate
Custom Top Elev: custom_top_elev - custom_top_elev
  • Datatype: Double.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • autoupdateReloadFields (['sys_top_elev', 'sys_ymax', 'sys_elev']): Instantly reloads other fields if one is modified. Acts in combination with isautoupdate
Sys Top Elev: sys_top_elev - sys_top_elev
  • Datatype: Double.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Ymax: ymax - ymax
  • Datatype: Double.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • autoupdateReloadFields (['sys_top_elev', 'sys_ymax', 'sys_elev']): Instantly reloads other fields if one is modified. Acts in combination with isautoupdate
Custom Ymax: custom_ymax - custom_ymax
  • Datatype: Double.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • autoupdateReloadFields (['sys_top_elev', 'sys_ymax', 'sys_elev']): Instantly reloads other fields if one is modified. Acts in combination with isautoupdate
Sys Ymax: sys_ymax - sys_ymax
  • Datatype: Double.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Custom Elev: custom_elev - custom_elev
  • Datatype: Double.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • autoupdateReloadFields (['sys_top_elev', 'sys_ymax', 'sys_elev']): Instantly reloads other fields if one is modified. Acts in combination with isautoupdate
Sys Elev: sys_elev - sys_elev
  • Datatype: Double.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Matcat Id: matcat_id - matcat_id
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id AS idval FROM cat_material WHERE 'NODE' = ANY(feature_type)
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
    • valueRelation:
      • nullValue: False
      • layer: cat_material
      • activated: True
      • keyColumn: id
      • valueColumn: descript
      • filterExpression: None
Workcat Id: workcat_id - Id of the construction work related to node.
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM cat_work WHERE id IS NOT NULL AND active IS TRUE
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Builtdate: builtdate - builtdate
  • Datatype: Date.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Ownercat Id: ownercat_id - ownercat_id
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM cat_owner WHERE id IS NOT NULL AND active IS TRUE
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Workcat Id End: workcat_id_end - workcat_id_end
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM cat_work WHERE id IS NOT NULL AND active IS TRUE
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Enddate: enddate - enddate
  • Datatype: Date.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Adate: adate - adate
  • Datatype: Text.
  • Mandatory: No.
  • Editable: Sí.
Adescript: adescript - adescript
  • Datatype: Text.
  • Mandatory: No.
  • Editable: Sí.
Placement Type: placement_type - Placement Type
  • Datatype: Text.
  • Mandatory: No.
  • Editable: Sí.
Access Type: access_type - access_type
  • Datatype: Text.
  • Mandatory: No.
  • Editable: Sí.
Label Quadrant: label_quadrant - label_quadrant
  • Datatype: Text.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: select id, idval from edit_typevalue where typevalue = 'label_quadrant'
Minsector Id: minsector_id - minsector_id
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
Macrominsector Id: macrominsector_id - macrominsector_id
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
Serial Number: serial_number - serial_number
  • Datatype: Text.
  • Mandatory: No.
  • Editable: Sí.
Dma: dma_id - dma_id
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Hemisphere: hemisphere - hemisphere
  • Datatype: Text.
  • Mandatory: No.
  • Editable: Sí.

The fields in the layout lyt_data_2 are:

Unconnected: unconnected - unconnected
  • Datatype: Boolean.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Fluid Type: fluid_type - fluid_type
  • Datatype: String.
  • Mandatory: No.
  • Editable: No.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, idval FROM om_typevalue WHERE typevalue = 'fluid_type'
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Category Type: category_type - Id of the category type related to node.
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT category_type as id, category_type as idval FROM man_type_category WHERE ((featurecat_id is null AND 'NODE'=ANY(feature_type))) AND active IS TRUE OR 'JUNCTION' = ANY(featurecat_id::text[])
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Soilcat Id: soilcat_id - Relacionado con el catalogo de suelos (cat_soil)
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM cat_soil WHERE id IS NOT NULL AND active IS TRUE
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Function Type: function_type - function_type
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT function_type as id, function_type as idval FROM man_type_function WHERE ((featurecat_id is null AND 'NODE'=ANY(feature_type)) ) AND active IS TRUE OR 'JUNCTION' = ANY(featurecat_id::text[])
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Location Type: location_type - location_type
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT location_type as id, location_type as idval FROM man_type_location WHERE ((featurecat_id is null AND 'NODE'=ANY(feature_type)) ) AND active IS TRUE OR 'JUNCTION' = ANY(featurecat_id::text[])
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Rotation: rotation - Field to use in order to rotate the symbology of the GIS canvas
  • Datatype: Double.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Catalog Label: label - label
  • Datatype: String.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Label X: label_x - X coordinate of the label's location
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Label Y: label_y - label_y
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Label Rotation: label_rotation - Angle of rotation of the label
  • Datatype: Double.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Xyz Date: xyz_date - xyz_date
  • Datatype: Date.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Exploitation Id: expl_id - Exploitation Id
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT expl_id as id, name as idval FROM exploitation WHERE expl_id IS NOT NULL
  • Stylesheet: Aesthetic modifications of the field
    • label:
      • color: green
      • font-weight: bold
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
    • valueRelation:
      • layer: ve_exploitation
      • activated: True
      • keyColumn: expl_id
      • nullValue: False
      • valueColumn: name
      • filterExpression: None
Workcat Id Plan: workcat_id_plan - Item planning record
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM cat_work WHERE id IS NOT NULL
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Asset Id: asset_id - asset_id
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
Brand: brand_id - brand_id
  • Datatype: Text.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM cat_brand WHERE 'JUNCTION' = ANY(featurecat_id::text[]) OR featurecat_id IS NULL
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Model: model_id - model_id
  • Datatype: Text.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, id as idval FROM cat_brand_model WHERE 'JUNCTION' = ANY(featurecat_id::text[]) OR featurecat_id IS NULL
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter

The fields in the layout lyt_data_3 are:

Muni Id: muni_id - muni_id
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT muni_id as id, name as idval from v_ext_municipality WHERE muni_id IS NOT NULL
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Postcode: postcode - postcode
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Streetname: streetname - streetname
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id AS id, a.descript AS idval FROM v_ext_streetaxis a JOIN ext_municipality m USING (muni_id) WHERE id IS NOT NULL
  • Filterc: The previous query is filtered by: AND m.name
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Postnumber: postnumber - postnumber
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT a.postnumber AS id, a.postnumber AS idval FROM ext_address a JOIN ext_streetaxis m ON streetaxis_id=m.id WHERE a.id IS NOT NULL
  • Filterc: The previous query is filtered by: AND m.name
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Postcomplement: postcomplement - postcomplement
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Streetname2: streetname2 - streetname2
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id AS id, a.descript AS idval FROM v_ext_streetaxis a JOIN ext_municipality m USING (muni_id) WHERE id IS NOT NULL
  • Filterc: The previous query is filtered by: AND m.name
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Second Street Number: postnumber2 - Second street number
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT a.postnumber AS id, a.postnumber AS idval FROM ext_address a JOIN ext_streetaxis m ON streetaxis_id=m.id WHERE a.id IS NOT NULL
  • Filterc: The previous query is filtered by: AND m.name
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Postcomplement2: postcomplement2 - postcomplement2
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Descript: descript - descript
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Annotation: annotation - Annotations related to node. Additional information
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Observ: observ - observ
  • Datatype: String.
  • Mandatory: No.
  • Editable: Sí.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
Link: link - Field to store link to information related to the node.
  • Datatype: Text.
  • Mandatory: No.
  • Editable: No.
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter

The fields in the layout lyt_bot_1 are:

Sector Id: sector_id - Sector_id
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT s.sector_id AS id, s.name AS idval FROM sector s WHERE s.sector_id IS NOT NULL AND s.active IS TRUE ORDER BY CASE WHEN s.sector_id = 0 THEN 1 WHEN s.sector_id = -1 THEN 3 ELSE 2 END, s.sector_id
  • Stylesheet: Aesthetic modifications of the field
    • label:
      • color: blue
      • font-weight: bold
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
    • labelPosition (top): If this value is defined [top, left, none], the label will occupy the relative position with respect to the widget. By default, left is understood. If the label field is empty, labelPosition is omitted.
    • valueRelation:
      • layer: ve_sector
      • activated: True
      • keyColumn: sector_id
      • nullValue: False
      • valueColumn: name
      • filterExpression: None
Dwfzone: dwfzone_id - dwfzone_id
  • Datatype: Integer.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT dwfzone_id as id, name as idval FROM dwfzone WHERE dwfzone_id = 0 UNION SELECT dwfzone_id as id, name as idval FROM dwfzone WHERE dwfzone_id IS NOT NULL AND active IS TRUE
  • Filterc: The previous query is filtered by: AND dwfzone.expl_id
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
    • labelPosition (top): If this value is defined [top, left, none], the label will occupy the relative position with respect to the widget. By default, left is understood. If the label field is empty, labelPosition is omitted.
    • valueRelation:
      • layer: ve_dma
      • activated: True
      • keyColumn: dma_id
      • nullValue: False
      • valueColumn: name
      • filterExpression: None
State: state - state
  • Datatype: Smallint.
  • Mandatory: No.
  • Editable: No.
  • Dvquerytext: The values of this dropdown are determined by the query: WITH psector_value AS ( SELECT value::integer AS psector_value FROM config_param_user WHERE parameter = 'plan_psector_current' AND cur_user = current_user), tg_op_value AS ( SELECT value::text AS tg_op_value FROM config_param_user WHERE parameter = 'utils_transaction_mode' AND cur_user = current_user) SELECT id::integer as id, name as idval FROM value_state WHERE id IS NOT NULL AND CASE WHEN (SELECT tg_op_value FROM tg_op_value)!='INSERT' THEN id IN (0,1,2) WHEN (SELECT tg_op_value FROM tg_op_value) ='INSERT' AND (SELECT psector_value FROM psector_value) IS NOT NULL THEN id = 2 ELSE id < 2 END
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
    • labelPosition (top): If this value is defined [top, left, none], the label will occupy the relative position with respect to the widget. By default, left is understood. If the label field is empty, labelPosition is omitted.
State Type: state_type - The state type of the element. It allows to obtain more detail of the state. To select from those available depending on the chosen state
  • Datatype: Smallint.
  • Mandatory: No.
  • Editable: Sí.
  • Dvquerytext: The values of this dropdown are determined by the query: SELECT id, name as idval FROM value_state_type WHERE id IS NOT NULL
  • Filterc: The previous query is filtered by: AND value_state_type.state
  • Widgetcontrols: Field controls
    • setMultiline (False): Sets the possibility of multiline fields for writing with enter
    • labelPosition (top): If this value is defined [top, left, none], the label will occupy the relative position with respect to the widget. By default, left is understood. If the label field is empty, labelPosition is omitted.