Scale rules in EGDI

[renatabarros]

Hello all (again),
One last thing missing to properly display GeoConnect³d data are the scale rules. Every object in our geopackages has an assigned scaleFrom and scaleTo (as 2 attributes) where it should appear/disappear from the web viewer. This is also something HIKE is doing for their faults as far as I know. However, I didn't find any tips for the code to create such rules. Could you help me out? Thanks in advance.

A more concrete example using the dataset gsi_geom.
These are the attributes within the shp:

Therefore these points should appear at scale 1:2,000,000 and disappear at scale 1:25,000 in the viewer.

And these are the scale steps we share with HIKE:

[nmtoken]

In the mapserver configuration file try adding:

MAXSCALEDENOM 2000000
MINSCALEDENOM 25000

[renatabarros]

It works, thank you!
Now if it is the case that the scaleFrom / scaleTo varies within the same layer depending on the object, is there a way to assign a field or an expression to have the correct combination for each object?

Example from another gpkg:

[nmtoken]

I don't think there's an easy way to do it.

In a mapserver configuration where I had full control, I would create two (or more depending on scales) layers from the single data source using an appropriate query, and give each layer the required scale range. Then I would group the layers, and show the grouped layer in the map.

[renatabarros]

I managed to query & show only scalefrom 4, but still unsure how to create multiple layers from the same dataset?

[nmtoken]

You can use a WHERE clause in the SELECT

Like:

DATA "wkb_geometry FROM (SELECT * FROM project_gip_p.r2rlimitst3 WHERE category = 'Contact') AS t USING UNIQUE ogc_fid SRID 3034 FILTER"

[renatabarros]

Sorry, I didn't explain well before. This is what I did, and works for one combination of scalefrom/to
DATA "wkb_geometry FROM (SELECT * FROM project_geoconnect3d.gc3dgsilimits WHERE scalefrom = 4 AND scaleto = 6) AS t USING UNIQUE ogc_fid SRID 3034 FILTER

However, I don't know how to then create the other layers to show the other scale combinations. I tried duplicating the whole LAYER code and changing the query in the second one to another scale combination, but it didn't work. This second step is what I need some help with.

[nmtoken]

can you post both full config files

[renatabarros]

Sorry I'm not sure what config files are, the mapserver code? Or the actual geopackage file?

[nmtoken]

The mapserver code.

[renatabarros]

LAYER
 NAME "gc3d_gsi_limits"
 GROUP "egdi"
 TYPE Line
 STATUS on
 METADATA
  "ows_title" "gc3d_gsi_limits"
  "ows_abstract" "Auto generated data set"
  "ows_group_title" "EGDI"
  "ows_group_abstract" "EGDI"
  "gml_featureid" "ogc_fid"
  "ows_featureid" "ogc_fid"
  "ows_include_items" "all"
  "gml_include_items" "all"
  "gml_types" "auto"
  "ows_srs" "EPSG:3034"
  "gml_geometries" "msGeometry"
  "gml_msGeometry_type" "Line"
  "dataset_path" "/egdi/shared/datasets/geoconnect3d/gc3d_gsi_sf.gpkg"
  "ows_extent" "2629527.682252142 2895001.265000496 3056936.1140277805 3294942.869486996"
  "wms_style" "default"
  "wms_style_default_legendurl_href" "/egdi/get_legend.jsp?layer=10970"
  "wms_style_default_legendurl_format" "image/png"
  "wms_style_default_legendurl_height" "250"
  "wms_style_default_legendurl_width" "250"
  "ows_inspire_capabilities" "url"
  "ows_inspire_metadataurl_format" "application/xml"
  "ows_inspire_metadataurl_href" "https://egdi.geology.cz/record/basic/61603ba9-e7a8-46f9-9076-2eaf0a010855"
  "ows_metadataurl_format" "text/xml"
  "ows_metadataurl_href" "https://egdi.geology.cz/record/basic/61603ba9-e7a8-46f9-9076-2eaf0a010855"
  "ows_metadataurl_type" "TC211"
 END
 HEADER "templates/wms_header.html" 
 TEMPLATE "templates/std_template.html"  # Otherwise not queryable
 FOOTER "templates/wms_footer.html"
 CONNECTIONTYPE POSTGIS 
 CONNECTION "host=geusmapcachedb dbname=egdi user=gis_viewer password=view2Qis port=5432"
 DATA "wkb_geometry FROM (SELECT * FROM project_geoconnect3d.gc3dgsilimits WHERE scalefrom = 4 AND scaleto = 6) AS t USING UNIQUE ogc_fid SRID 3034 FILTER"
 LABELCACHE on
 MAXSCALEDENOM 2000000
 MINSCALEDENOM 500000
 CLASS
  NAME "gc3d_gsi_limits"
  # dummy expression has no matches
  EXPRESSION ([linetype] = -1)
  STYLE
   # Omit COLOR RGB for no colour
  END
 END
 CLASS
  EXPRESSION ([linetype] = 0 AND "[category]" = "Contact")
  STYLE
   COLOR "#000004"
   WIDTH 1
   LINEJOIN bevel
  END
  TITLE "Contact 0"
 END
 CLASS
  EXPRESSION ([linetype] = 1 AND "[category]" = "Contact")
  STYLE
   PATTERN 3 5 END
   COLOR "#000004"
   WIDTH 1
   LINEJOIN round
  END
  TITLE "Contact 1"
 END
 CLASS
  EXPRESSION ([linetype] = 0 AND "[category]" = "Crustal boundary")
  STYLE
   COLOR "#208719"
   WIDTH 1
   LINEJOIN bevel
  END
  TITLE "Crustal boundary 0"
 END
 CLASS
  EXPRESSION ([linetype] = 1 AND "[category]" = "Crustal boundary")
  STYLE
   PATTERN 3 5 END
   COLOR "#208719"
   WIDTH 1
   LINEJOIN round
  END
  TITLE "Crustal boundary 1"
 END
 CLASS
  EXPRESSION ([linetype] = 0 AND "[category]" = "Fault")
  STYLE
   COLOR "#eb0c23"
   WIDTH 1
   LINEJOIN bevel
  END
  TITLE "Fault 0"
 END
 CLASS
  EXPRESSION ([linetype] = 1 AND "[category]" = "Fault")
  STYLE
   PATTERN 3 5 END
   COLOR  "#eb0c23"
   WIDTH 1
   LINEJOIN round
  END
  TITLE "Fault 1"
 END
 CLASS
  EXPRESSION ([linetype] = 0 AND "[category]" = "Lineament")
  STYLE
   COLOR "#3cf03c"
   WIDTH 1
   LINEJOIN bevel
  END
  TITLE "Lineament 0"
 END
 CLASS
  EXPRESSION ([linetype] = 1 AND "[category]" = "Lineament")
  STYLE
   PATTERN 3 5 END
   COLOR "#3cf03c"
   WIDTH 1
   LINEJOIN round
  END
  TITLE "Lineament 1"
 END
 CLASS
  EXPRESSION ([linetype] = 0 AND "[category]" = "Orogenic front")
  STYLE
   COLOR "#35e1ed"
   WIDTH 1
   LINEJOIN bevel
  END
  TITLE "Orogenic front 0"
 END
 CLASS
  EXPRESSION ([linetype] = 1 AND "[category]" = "Orogenic front")
  STYLE
   PATTERN 3 5 END
   COLOR "#35e1ed"
   WIDTH 1
   LINEJOIN round
  END
  TITLE "Orogenic front 1"
 END
 CLASS
  EXPRESSION ([linetype] = 0 AND "[category]" = "Plate boundary")
  STYLE
   COLOR "#280c99"
   WIDTH 1
   LINEJOIN bevel
  END
  TITLE "Plate boundary 0"
 END
 CLASS
  EXPRESSION ([linetype] = 1 AND "[category]" = "Plate boundary")
  STYLE
   PATTERN 3 5 END
   COLOR "#280c99"
   WIDTH 1
   LINEJOIN round
  END
  TITLE "Plate boundary 1"
 END
 CLASS
  EXPRESSION ([linetype] = 0 AND "[category]" = "Unconformity")
  STYLE
   COLOR "#b540df"
   WIDTH 1
   LINEJOIN bevel
  END
  TITLE "Unconformity 0"
 END
 CLASS
  EXPRESSION ([linetype] = 1 AND "[category]" = "Unconformity")
  STYLE
   PATTERN 3 5 END
   COLOR "#b540df"
   WIDTH 1
   LINEJOIN round
  END
  TITLE "Unconformity 1"
 END
 PROJECTION
  "init=epsg:3034"
 END  
END

[nmtoken]

For grouping to work would need something like:

LAYER
    NAME "gc3d_gsi_limits_copy1"
    GROUP "gc3d_gsi_limits"
    TYPE Line
    STATUS on
    METADATA
     "ows_title" "gc3d_gsi_limits (4 to 6)"
     "ows_abstract" "A copy of gc3d_gsi_limits (scalefrom = 4 AND scaleto = 6)"
     "ows_group_title" "Geoconnect3D gsi limits"
     "ows_group_abstract" "Group of Geoconnect3D gsi limits data categorized by scalefrom and scaleto ranges"
     "gml_featureid" "ogc_fid"
     "ows_featureid" "ogc_fid"
     "ows_include_items" "all"
     "gml_include_items" "all"
     "gml_types" "auto"
     "ows_srs" "EPSG:3034 EPSG:3857 EPSG:4258 EPSG:4326"
     "gml_geometries" "msGeometry"
     "gml_msGeometry_type" "Line"
     "dataset_path" "/egdi/shared/datasets/geoconnect3d/gc3d_gsi_sf.gpkg"
     "ows_extent" "2629527.682252142 2895001.265000496 3056936.1140277805 3294942.869486996"
     "wms_style" "default"
     "wms_style_default_legendurl_href" "/egdi/get_legend.jsp?layer=10970"
     "wms_style_default_legendurl_format" "image/png"
     "wms_style_default_legendurl_height" "250"
     "wms_style_default_legendurl_width" "250"
     "ows_inspire_capabilities" "url"
     "ows_inspire_metadataurl_format" "application/xml"
     "ows_inspire_metadataurl_href" "https://egdi.geology.cz/record/xml/61603ba9-e7a8-46f9-9076-2eaf0a010855"
     "ows_metadataurl_format" "text/html"
     "ows_metadataurl_href" "https://egdi.geology.cz/record/basic/61603ba9-e7a8-46f9-9076-2eaf0a010855"
     "ows_metadataurl_type" "TC211"
    END
    HEADER "templates/wms_header.html" 
    TEMPLATE "templates/std_template.html"  # Otherwise not queryable
    FOOTER "templates/wms_footer.html"
    CONNECTIONTYPE POSTGIS 
    CONNECTION "host=geusmapcachedb dbname=egdi user=gis_viewer password=view2Qis port=5432"
    DATA "wkb_geometry FROM (SELECT * FROM project_geoconnect3d.gc3dgsilimits WHERE scalefrom = 4 AND scaleto = 6) AS t USING UNIQUE ogc_fid SRID 3034 FILTER"
    LABELCACHE on
    MAXSCALEDENOM 2000000
    MINSCALEDENOM 500000
    CLASS
     NAME "gc3d_gsi_limits"
     # dummy expression has no matches
     EXPRESSION ([linetype] = -1)
     STYLE
      # Omit COLOR RGB for no colour
     END
    END
    CLASS
     EXPRESSION ([linetype] = 0 AND "[category]" = "Contact")
     STYLE
      COLOR "#000004"
      WIDTH 1
      LINEJOIN bevel
     END
     TITLE "Contact 0"
    END
    CLASS
     EXPRESSION ([linetype] = 1 AND "[category]" = "Contact")
     STYLE
      PATTERN 3 5 END
      COLOR "#000004"
      WIDTH 1
      LINEJOIN round
     END
     TITLE "Contact 1"
    END
    CLASS
     EXPRESSION ([linetype] = 0 AND "[category]" = "Crustal boundary")
     STYLE
      COLOR "#208719"
      WIDTH 1
      LINEJOIN bevel
     END
     TITLE "Crustal boundary 0"
    END
    CLASS
     EXPRESSION ([linetype] = 1 AND "[category]" = "Crustal boundary")
     STYLE
      PATTERN 3 5 END
      COLOR "#208719"
      WIDTH 1
      LINEJOIN round
     END
     TITLE "Crustal boundary 1"
    END
    CLASS
     EXPRESSION ([linetype] = 0 AND "[category]" = "Fault")
     STYLE
      COLOR "#eb0c23"
      WIDTH 1
      LINEJOIN bevel
     END
     TITLE "Fault 0"
    END
    CLASS
     EXPRESSION ([linetype] = 1 AND "[category]" = "Fault")
     STYLE
      PATTERN 3 5 END
      COLOR  "#eb0c23"
      WIDTH 1
      LINEJOIN round
     END
     TITLE "Fault 1"
    END
    CLASS
     EXPRESSION ([linetype] = 0 AND "[category]" = "Lineament")
     STYLE
      COLOR "#3cf03c"
      WIDTH 1
      LINEJOIN bevel
     END
     TITLE "Lineament 0"
    END
    CLASS
     EXPRESSION ([linetype] = 1 AND "[category]" = "Lineament")
     STYLE
      PATTERN 3 5 END
      COLOR "#3cf03c"
      WIDTH 1
      LINEJOIN round
     END
     TITLE "Lineament 1"
    END
    CLASS
     EXPRESSION ([linetype] = 0 AND "[category]" = "Orogenic front")
     STYLE
      COLOR "#35e1ed"
      WIDTH 1
      LINEJOIN bevel
     END
     TITLE "Orogenic front 0"
    END
    CLASS
     EXPRESSION ([linetype] = 1 AND "[category]" = "Orogenic front")
     STYLE
      PATTERN 3 5 END
      COLOR "#35e1ed"
      WIDTH 1
      LINEJOIN round
     END
     TITLE "Orogenic front 1"
    END
    CLASS
     EXPRESSION ([linetype] = 0 AND "[category]" = "Plate boundary")
     STYLE
      COLOR "#280c99"
      WIDTH 1
      LINEJOIN bevel
     END
     TITLE "Plate boundary 0"
    END
    CLASS
     EXPRESSION ([linetype] = 1 AND "[category]" = "Plate boundary")
     STYLE
      PATTERN 3 5 END
      COLOR "#280c99"
      WIDTH 1
      LINEJOIN round
     END
     TITLE "Plate boundary 1"
    END
    CLASS
     EXPRESSION ([linetype] = 0 AND "[category]" = "Unconformity")
     STYLE
      COLOR "#b540df"
      WIDTH 1
      LINEJOIN bevel
     END
     TITLE "Unconformity 0"
    END
    CLASS
     EXPRESSION ([linetype] = 1 AND "[category]" = "Unconformity")
     STYLE
      PATTERN 3 5 END
      COLOR "#b540df"
      WIDTH 1
      LINEJOIN round
     END
     TITLE "Unconformity 1"
    END
    PROJECTION
     "init=epsg:3034"
    END  
END

LAYER
 NAME "gc3d_gsi_limits_copy2"
 GROUP "gc3d_gsi_limits"
 TYPE Line
 STATUS on
 METADATA
  "ows_title" "gc3d_gsi_limits (6 to 10)"
  "ows_abstract" "A copy of gc3d_gsi_limits (scalefrom = 6 AND scaleto = 10)"
  # group title and abstract need only be set on one member of the group
  "ows_group_title" "Geoconnect3D gsi limits"
  "ows_group_abstract" "Group of Geoconnect3D gsi limits data categorized by scalefrom and scaleto ranges"
  "gml_featureid" "ogc_fid"
  "ows_featureid" "ogc_fid"
  "ows_include_items" "all"
  "gml_include_items" "all"
  "gml_types" "auto"
  "ows_srs" "EPSG:3034 EPSG:3857 EPSG:4258 EPSG:4326"
  "gml_geometries" "msGeometry"
  "gml_msGeometry_type" "Line"
  "dataset_path" "/egdi/shared/datasets/geoconnect3d/gc3d_gsi_sf.gpkg"
  "ows_extent" "2629527.682252142 2895001.265000496 3056936.1140277805 3294942.869486996"
  "wms_style" "default"
  "wms_style_default_legendurl_href" "/egdi/get_legend.jsp?layer=10970"
  "wms_style_default_legendurl_format" "image/png"
  "wms_style_default_legendurl_height" "250"
  "wms_style_default_legendurl_width" "250"
  "ows_inspire_capabilities" "url"
  "ows_inspire_metadataurl_format" "application/xml"
  "ows_inspire_metadataurl_href" "https://egdi.geology.cz/record/xml/61603ba9-e7a8-46f9-9076-2eaf0a010855"
  "ows_metadataurl_format" "text/html"
  "ows_metadataurl_href" "https://egdi.geology.cz/record/basic/61603ba9-e7a8-46f9-9076-2eaf0a010855"
  "ows_metadataurl_type" "TC211"
 END
 HEADER "templates/wms_header.html" 
 TEMPLATE "templates/std_template.html"  # Otherwise not queryable
 FOOTER "templates/wms_footer.html"
 CONNECTIONTYPE POSTGIS 
 CONNECTION "host=geusmapcachedb dbname=egdi user=gis_viewer password=view2Qis port=5432"
 DATA "wkb_geometry FROM (SELECT * FROM project_geoconnect3d.gc3dgsilimits WHERE scalefrom = 6 AND scaleto = 10) AS t USING UNIQUE ogc_fid SRID 3034 FILTER"
 LABELCACHE on
 MAXSCALEDENOM 500000
 MINSCALEDENOM 25000
 CLASS
  NAME "gc3d_gsi_limits"
  # dummy expression has no matches
  EXPRESSION ([linetype] = -1)
  STYLE
   # Omit COLOR RGB for no colour
  END
 END
 CLASS
  EXPRESSION ([linetype] = 0 AND "[category]" = "Contact")
  STYLE
   COLOR "#000004"
   WIDTH 1
   LINEJOIN bevel
  END
  TITLE "Contact 0"
 END
 CLASS
  EXPRESSION ([linetype] = 1 AND "[category]" = "Contact")
  STYLE
   PATTERN 3 5 END
   COLOR "#000004"
   WIDTH 1
   LINEJOIN round
  END
  TITLE "Contact 1"
 END
 CLASS
  EXPRESSION ([linetype] = 0 AND "[category]" = "Crustal boundary")
  STYLE
   COLOR "#208719"
   WIDTH 1
   LINEJOIN bevel
  END
  TITLE "Crustal boundary 0"
 END
 CLASS
  EXPRESSION ([linetype] = 1 AND "[category]" = "Crustal boundary")
  STYLE
   PATTERN 3 5 END
   COLOR "#208719"
   WIDTH 1
   LINEJOIN round
  END
  TITLE "Crustal boundary 1"
 END
 CLASS
  EXPRESSION ([linetype] = 0 AND "[category]" = "Fault")
  STYLE
   COLOR "#eb0c23"
   WIDTH 1
   LINEJOIN bevel
  END
  TITLE "Fault 0"
 END
 CLASS
  EXPRESSION ([linetype] = 1 AND "[category]" = "Fault")
  STYLE
   PATTERN 3 5 END
   COLOR  "#eb0c23"
   WIDTH 1
   LINEJOIN round
  END
  TITLE "Fault 1"
 END
 CLASS
  EXPRESSION ([linetype] = 0 AND "[category]" = "Lineament")
  STYLE
   COLOR "#3cf03c"
   WIDTH 1
   LINEJOIN bevel
  END
  TITLE "Lineament 0"
 END
 CLASS
  EXPRESSION ([linetype] = 1 AND "[category]" = "Lineament")
  STYLE
   PATTERN 3 5 END
   COLOR "#3cf03c"
   WIDTH 1
   LINEJOIN round
  END
  TITLE "Lineament 1"
 END
 CLASS
  EXPRESSION ([linetype] = 0 AND "[category]" = "Orogenic front")
  STYLE
   COLOR "#35e1ed"
   WIDTH 1
   LINEJOIN bevel
  END
  TITLE "Orogenic front 0"
 END
 CLASS
  EXPRESSION ([linetype] = 1 AND "[category]" = "Orogenic front")
  STYLE
   PATTERN 3 5 END
   COLOR "#35e1ed"
   WIDTH 1
   LINEJOIN round
  END
  TITLE "Orogenic front 1"
 END
 CLASS
  EXPRESSION ([linetype] = 0 AND "[category]" = "Plate boundary")
  STYLE
   COLOR "#280c99"
   WIDTH 1
   LINEJOIN bevel
  END
  TITLE "Plate boundary 0"
 END
 CLASS
  EXPRESSION ([linetype] = 1 AND "[category]" = "Plate boundary")
  STYLE
   PATTERN 3 5 END
   COLOR "#280c99"
   WIDTH 1
   LINEJOIN round
  END
  TITLE "Plate boundary 1"
 END
 CLASS
  EXPRESSION ([linetype] = 0 AND "[category]" = "Unconformity")
  STYLE
   COLOR "#b540df"
   WIDTH 1
   LINEJOIN bevel
  END
  TITLE "Unconformity 0"
 END
 CLASS
  EXPRESSION ([linetype] = 1 AND "[category]" = "Unconformity")
  STYLE
   PATTERN 3 5 END
   COLOR "#b540df"
   WIDTH 1
   LINEJOIN round
  END
  TITLE "Unconformity 1"
 END
 PROJECTION
  "init=epsg:3034"
 END  
END

[renatabarros]

So I should create a copy of the dataset for every scaleFrom/scaleTo combination I have, then list them with the corresponding rules, one LAYER after the other?

[nmtoken]

That is I think the only way to do it. Would work with or without grouping (that is assigning all the layers to a group); grouping would be neater, but I'm not sure if the configuration editor will allow it.

[renatabarros]

I cannot make it work :(

I also tried Union Layer and no luck:

LAYER
 NAME "gc3d_gsi_units_union"
 GROUP "egdi"
 TYPE Polygon
 STATUS on
 CONNECTIONTYPE UNION
 CONNECTION "gc3d_gsi_units26,gc3d_gsi_units24" #reference to source layers
 STYLEITEM "AUTO" 
 CLASS
 END
 PROJECTION
  "init=epsg:3034"
 END  
END

LAYER
 NAME "gc3d_gsi_units26"
 GROUP "egdi"
 TYPE Polygon
 STATUS off
 METADATA
  "ows_title" "gc3d_gsi_units26"
  "ows_abstract" "Auto generated data set"
  "ows_group_title" "EGDI"
  "ows_group_abstract" "EGDI"
  "gml_featureid" "ogc_fid"
  "ows_featureid" "ogc_fid"
  "ows_include_items" "all"
  "gml_include_items" "all"
  "gml_types" "auto"
  "ows_srs" "EPSG:3034"
  "gml_geometries" "msGeometry"
  "gml_msGeometry_type" "Polygon"
  "dataset_path" "/egdi/shared/datasets/geoconnect3d/gc3d_gsi_sf.gpkg"
  "ows_extent" "2658592.7609132337 2909815.2107352 3039373.5745098125 3290453.4667510046"
  "wms_style" "default"
  "wms_style_default_legendurl_href" "/egdi/get_legend.jsp?layer=10972"
  "wms_style_default_legendurl_format" "image/png"
  "wms_style_default_legendurl_height" "250"
  "wms_style_default_legendurl_width" "250"
  "ows_inspire_capabilities" "url"
  "ows_inspire_metadataurl_format" "application/xml"
  "ows_inspire_metadataurl_href" "https://egdi.geology.cz/record/basic/61603ba9-e7a8-46f9-9076-2eaf0a010855"
  "ows_metadataurl_format" "text/xml"
  "ows_metadataurl_href" "https://egdi.geology.cz/record/basic/61603ba9-e7a8-46f9-9076-2eaf0a010855"
  "ows_metadataurl_type" "TC211"
 END
 HEADER "templates/wms_header.html" 
 TEMPLATE "templates/std_template.html"  # Otherwise not queryable
 FOOTER "templates/wms_footer.html"
 CONNECTIONTYPE POSTGIS 
 CONNECTION "host=geusmapcachedb dbname=egdi user=gis_viewer password=view2Qis port=5432"
 DATA "wkb_geometry FROM (SELECT * FROM project_geoconnect3d.gc3dgsiunits WHERE scalefrom = 2 AND scaleto = 6) AS t USING UNIQUE ogc_fid SRID 3034 FILTER"
 LABELCACHE on
 CLASS
  NAME "gc3d_gsi_units26"
  STYLE
   OUTLINECOLOR 0 0 0
   COLOR 255 85 0
  END
 PROJECTION
  "init=epsg:3034"
 END  
END

LAYER
 NAME "gc3d_gsi_units24"
 GROUP "egdi"
 TYPE Polygon
 STATUS off
 METADATA
  "ows_title" "gc3d_gsi_units26"
  "ows_abstract" "Auto generated data set"
  "ows_group_title" "EGDI"
  "ows_group_abstract" "EGDI"
  "gml_featureid" "ogc_fid"
  "ows_featureid" "ogc_fid"
  "ows_include_items" "all"
  "gml_include_items" "all"
  "gml_types" "auto"
  "ows_srs" "EPSG:3034"
  "gml_geometries" "msGeometry"
  "gml_msGeometry_type" "Polygon"
  "dataset_path" "/egdi/shared/datasets/geoconnect3d/gc3d_gsi_sf.gpkg"
  "ows_extent" "2658592.7609132337 2909815.2107352 3039373.5745098125 3290453.4667510046"
  "wms_style" "default"
  "wms_style_default_legendurl_href" "/egdi/get_legend.jsp?layer=10972"
  "wms_style_default_legendurl_format" "image/png"
  "wms_style_default_legendurl_height" "250"
  "wms_style_default_legendurl_width" "250"
  "ows_inspire_capabilities" "url"
  "ows_inspire_metadataurl_format" "application/xml"
  "ows_inspire_metadataurl_href" "https://egdi.geology.cz/record/basic/61603ba9-e7a8-46f9-9076-2eaf0a010855"
  "ows_metadataurl_format" "text/xml"
  "ows_metadataurl_href" "https://egdi.geology.cz/record/basic/61603ba9-e7a8-46f9-9076-2eaf0a010855"
  "ows_metadataurl_type" "TC211"
 END
 HEADER "templates/wms_header.html" 
 TEMPLATE "templates/std_template.html"  # Otherwise not queryable
 FOOTER "templates/wms_footer.html"
 CONNECTIONTYPE POSTGIS 
 CONNECTION "host=geusmapcachedb dbname=egdi user=gis_viewer password=view2Qis port=5432"
 DATA "wkb_geometry FROM (SELECT * FROM project_geoconnect3d.gc3dgsiunits WHERE scalefrom = 2 AND scaleto = 4) AS t USING UNIQUE ogc_fid SRID 3034 FILTER"
 LABELCACHE on
 CLASS
  NAME "gc3d_gsi_units24"
  STYLE
   OUTLINECOLOR 0 0 0
   COLOR 80 0 0
  END
 PROJECTION
  "init=epsg:3034"
 END  
END

[nmtoken]

Your layers don't have min and max scale denominators in them.

When you say doesn't work, do you mean none of the layers are showing at all?
Do you get any warning message in the mapserver-definition test window?