19.1. 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:

Gully Type: gully_type - gully_type

• 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_gully 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_gully
    • activated: True
    • keyColumn: id
    • nullValue: False
    • valueColumn: id
    • filterExpression: None

Gullycat Id: gullycat_id - gullycat_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_gully WHERE id IS NOT NULL AND active IS TRUE
• Filterc: The previous query is filtered by: AND cat_gully.gully_type IS NULL OR cat_gully.gully_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_grate
    • 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 IS TRUE AND feature_type = 'GULLY'
• 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.

Arc Id: arc_id - Arc_id

• Datatype: String.
• Mandatory: No.
• Editable: No.
• Dvquerytext: The values of this dropdown are determined by the query: SELECT arc_id as id, arc_id as idval FROM arc WHERE arc_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.

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 Elevation: top_elev - Elevation of the gully in ft or m.

• Datatype: Double.
• Mandatory: No.
• Editable: Sí.
• Widgetcontrols: Field controls

  • setMultiline (False): Sets the possibility of multiline fields for writing with enter

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

Ymax: ymax - ymax

• Datatype: Double.
• Mandatory: No.
• Editable: Sí.
• Widgetcontrols: Field controls

  • setMultiline (False): Sets the possibility of multiline fields for writing with enter

Sandbox: sandbox - sandbox

• Datatype: Double.
• Mandatory: No.
• Editable: Sí.
• Widgetcontrols: Field controls

  • setMultiline (False): Sets the possibility of multiline fields for writing with enter

Material: matcat_id - Material of the element. It cannot be filled in. The one with the matcat_id field of the corresponding catalog is used

• Datatype: String.
• Mandatory: No.
• Editable: No.
• Widgetcontrols: Field controls

  • setMultiline (False): Sets the possibility of multiline fields for writing with enter

Material: cat_grate_matcat - Material

• Datatype: String.
• Mandatory: No.
• Editable: No.
• Widgetcontrols: Field controls

  • setMultiline (False): Sets the possibility of multiline fields for writing with enter

Units: units - units

• Datatype: Text.
• Mandatory: No.
• Editable: Sí.
• Widgetcontrols: Field controls

  • setMultiline (False): Sets the possibility of multiline fields for writing with enter

Groove: groove - groove

• Datatype: Boolean.
• Mandatory: No.
• Editable: Sí.
• Widgetcontrols: Field controls

  • setMultiline (False): Sets the possibility of multiline fields for writing with enter

Siphon: siphon - siphon

• Datatype: Boolean.
• Mandatory: No.
• Editable: Sí.
• Widgetcontrols: Field controls

  • setMultiline (False): Sets the possibility of multiline fields for writing with enter

Connec Arccat Id: connec_arccat_id - connec_arccat_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_connec WHERE active IS TRUE
• Widgetcontrols: Field controls

  • setMultiline (False): Sets the possibility of multiline fields for writing with enter
  • valueRelation:

    • nullValue: False
    • layer: cat_connec
    • activated: True
    • keyColumn: id
    • valueColumn: id
    • filterExpression: None

Connec Matcat Id: connec_matcat_id - Material of a conection arc

• 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 'ARC' = ANY(feature_type) AND active

Connec Depth: connec_depth - Profundidad de la conexión

• Datatype: Double.
• Mandatory: No.
• Editable: Sí.
• Widgetcontrols: Field controls

  • setMultiline (False): Sets the possibility of multiline fields for writing with enter

Workcat Id: workcat_id - Id of the construction work related to gully.

• 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 - Id of the construction date related to gully.

• 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

Enddate: enddate - Enddate

• Datatype: Date.
• Mandatory: No.
• Editable: Sí.
• Widgetcontrols: Field controls

  • setMultiline (False): Sets the possibility of multiline fields for writing with enter

Connec Y1: connec_y1 - connec_y1

• Datatype: Double.
• Mandatory: No.
• Editable: No.

Connec Y2: connec_y2 - connec_y2

• Datatype: Double.
• Mandatory: No.
• Editable: No.

Adate: adate - adate

• Datatype: Text.
• Mandatory: No.
• Editable: Sí.

Adescript: adescript - adescript

• Datatype: Text.
• Mandatory: No.
• Editable: Sí.

Siphon Type: siphon_type - siphon_type

• Datatype: Text.
• Mandatory: No.
• Editable: Sí.

Odorflap: odorflap - odorflap

• 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í.

The fields in the layout lyt_data_2 are:

Soilcat Id: soilcat_id - Id of the soil related to the gully.

• 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 'GULLY'=ANY(feature_type)) ) AND active IS TRUE OR 'VGULLY' = ANY(featurecat_id::text[])
• Widgetcontrols: Field controls

  • setMultiline (False): Sets the possibility of multiline fields for writing with enter

Fluid Type: fluid_type - Id of the fluid type related to gully.

• Datatype: String.
• Mandatory: Sí.
• Editable: Sí.
• 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 - category_type

• 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 'GULLY'=ANY(feature_type))) AND active IS TRUE OR 'VGULLY' = ANY(featurecat_id::text[])
• Widgetcontrols: Field controls

  • setMultiline (False): Sets the possibility of multiline fields for writing with enter

Location Type: location_type - Id of the location type related to gully.

• 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 'GULLY'=ANY(feature_type)) ) AND active IS TRUE OR 'VGULLY' = 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

Label: label - Label shown on the item form

• 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 - Y 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 Rotation: label_rotation - label_rotation

• Datatype: Double.
• Mandatory: No.
• Editable: Sí.
• Widgetcontrols: Field controls

  • setMultiline (False): Sets the possibility of multiline fields for writing with enter

Exploitation: expl_id - expl_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
  • 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_exploitation
    • activated: True
    • keyColumn: expl_id
    • nullValue: False
    • valueColumn: name
    • filterExpression: None

Workcat Id End: workcat_id_end - Id of the end of construction work.

• 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

Workcat Id Plan: workcat_id_plan - workcat_id_plan

• 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í.

Gullycat2 Id: gullycat2_id - gullycat2_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_gully WHERE id IS NOT NULL AND active IS TRUE
• Filterc: The previous query is filtered by: AND cat_gully.gully_type IS NULL OR cat_gully.gully_type
• Widgetcontrols: Field controls

  • setMultiline (False): Sets the possibility of multiline fields for writing with enter
  • valueRelation:

    • nullValue: False
    • layer: cat_grate
    • activated: True
    • keyColumn: id
    • valueColumn: id
    • filterExpression: None

Units Placement: units_placement - units_placement

• Datatype: String.
• Mandatory: No.
• Editable: Sí.
• Dvquerytext: The values of this dropdown are determined by the query: SELECT id, idval FROM edit_typevalue WHERE typevalue='gully_units_placement'

Groove Height: groove_height - groove_height

• Datatype: Double.
• Mandatory: No.
• Editable: Sí.

Groove Length: groove_length - groove_length

• Datatype: Double.
• Mandatory: No.
• Editable: Sí.

Brand Id: 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 'VGULLY' = ANY(featurecat_id::text[]) OR featurecat_id IS NULL

Model Id: 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 'VGULLY' = ANY(featurecat_id::text[]) OR featurecat_id IS NULL

The fields in the layout lyt_data_3 are:

Municipality Id: muni_id - Municipality to which the element belongs. If the configuration is not modified, the program automatically selects it based on the geometry

• 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

Street: streetname - Street identifier.

• 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

Street Number: postnumber - 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

Optional Complement Of The Street Number: postcomplement - Optional complement of the street number

• 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

Postnumber2: postnumber2 - postnumber2

• 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

Optional Complement Of The Second Street Number: postcomplement2 - Optional complement of the second street number

• Datatype: String.
• Mandatory: No.
• Editable: Sí.
• Widgetcontrols: Field controls

  • setMultiline (False): Sets the possibility of multiline fields for writing with enter

Pjoint Id: pjoint_id - pjoint_id

• Datatype: String.
• Mandatory: No.
• Editable: No.
• Widgetcontrols: Field controls

  • setMultiline (False): Sets the possibility of multiline fields for writing with enter

Pjoint Type: pjoint_type - pjoint_type

• Datatype: String.
• Mandatory: No.
• Editable: No.
• Widgetcontrols: Field controls

  • setMultiline (False): Sets the possibility of multiline fields for writing with enter

Descript: descript - Field to store additional information about the feature.

• 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 gully. Additional information

• Datatype: String.
• Mandatory: No.
• Editable: Sí.
• Widgetcontrols: Field controls

  • setMultiline (False): Sets the possibility of multiline fields for writing with enter

Observation: observ - Optional field to add observations about the element

• 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 gully

• 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 - Hydraulic sector identifier related to the primary key of sector table

• 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 of the element. To choose between the 3 types of states available

• 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 - state_type

• 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.