Saving Hermann the German may cost New Ulm $11 million



Hermann the German has been watching over the southern Minnesota city of New Ulm for 129 years. The copper statue stands on top of a 102-foot tall monument, pointing a sword to the sky as it overlooks the Minnesota River Valley on top of the hill at Hermann Heights Park off Center Street.

For decades, local residents and visitors alike have climbed up the 99 circular stair steps to the top of the monument, stood beneath Hermann and taken in the stunning, 360-degree view of the city and the Minnesota River Valley from the observation platform.

“When I think of New Ulm, it’s the German heritage; and oftentimes, Hermann the German comes up,” said Holly Beckmann, 38, of Mankato. “That’s like the symbol of New Ulm is Hermann the German.”

But Hermann needs help, as decades of severe water and weather damage leaves New Ulm’s iconic symbol of German pride in need of significant repairs. The city recently got a cost estimate as stunning as the monument itself: a whopping $11.6 million.

Hermann the German Monument3
Hermann the German Monument in New Ulm, Minn. needs about $11.6 million for it to be deconstructed and built from the ground up because of severe water damage over the decades.
Hannah Yang | MPR News

Joey Schugel, director of New Ulm’s Parks and Recreation, said the city is exploring several possible funding streams to help foot the nearly $12 million bill.

“We’re really not looking to impact the local taxpayer with this project,” Schugel said. “This is a bigger project … so we are looking for some legacy dollars through the state of Minnesota or a bonding bill.”

The statue of Hermann the German himself, one of the largest copper statues in the U.S., was taken down in 2004 and refurbished. This time, the restoration project would be focused on the monument’s base, the dome and everything else that leads up to the statue.

man standing by Hermann the German Monument
New Ulm Parks and Recreation Director Joey Schugel said the repairs to Hermann the German Monument would likely be a "multi-year process" that's determined by the funding that can be secured through state appropriation, grants and other sources. It's estimated that the monument needs about $11.6 million to deconstruct and rebuild the structure.
Hannah Yang | MPR News

There’s “significant evidence of water damage” to the central stone column at the base of the monument, which is crucial to the structural integrity of the monument, according to a 2024 analysis of the damage conducted by MacDonald & Mack Architects. Flaking limestone and rusting steel components are the most visible signs of wear and tear.

The New Ulm City Council is expected to review the estimated repair and restoration costs at its next meeting on April 7.

However, that $11 million-plus cost estimate isn’t set in stone. Schugel said the actual cost might change depending if some of the columns or the steel staircase are found to be in good enough condition to be reusable.

Hermann the German stairwell
New Ulm Parks and Recreation Director Joey Schugel looks up the winding stairwell that leads to the top of Hermann the German Monument. He said that the site receives about 10,000 visitors annually and is a huge draw for guests coming into New Ulm for festivals and tourism.
Hannah Yang | MPR News

New Ulm’s city council established a “Hermann Restoration” fund a couple of years ago with $300,000 and added another $100,000 from a budget surplus in 2024. City leaders are also building momentum within the community to preserve the Hermann Monument. Schugel said there’s been interest by local groups in starting fundraising campaigns that could have a local match, and the city is seeking state and federal government grant funding for the project.

“The community is really committed to keeping Hermann around if possible,” Schugel said, “and that’s really why we’re working really hard to come up with this funding to be able to deconstruct and reconstruct.”

To many in New Ulm, the monument is much more than a symbol of pride honoring the area’s German heritage. It’s a significant economic driver for New Ulm, bringing in more than 10,000 visitors a year — many from around Minnesota and the Midwest — but some come from all around the world to see it and climb up it.

Hermann the German Monument5
Hermann the German Monument has 99 steps leading to the top of the observation platform. If New Ulm secures funding, then the monument likely would need to be deconstructed and built again due to the severe water damage the structure sustained over the years.
Hannah Yang | MPR News

It’s likely that the project — depending if funding is secured — would take a few years to complete. Schugel also said that the extensive work will likely affect Hermann the German’s historic status and will probably result in the monument being removed from the National Registry of Historic Sites.

“No matter how it was deconstructed and reconstructed it would [get removed],” he said. “It’s our understanding that once the project is completed, then we can reapply to have Hermann back on that national historic registry.”

a view over new ulm
From the observation platform at the top of Hermann the German Monument in New Ulm, Minn., one can overlook the Minnesota River Valley. Guests can see a 360-degree view of New Ulm and surrounding towns on a clear day.
Hannah Yang | MPR News

Locals react

Many New Ulm residents seem to support the effort to rehabilitate the Hermann Monument, though some note that the $11.6 million price tag is a lot, and they’d like to avoid using local tax dollars as much as possible.

“[Hermann’s] been there for as long as I’ve been alive,” said Gary Rubey, 74, of New Ulm. “It’s always, always present. It’s strange if it was gone. It’d be nice if [the city] could do it without tax money. But if that’s the final option, fine.”

And due to the popularity of Hermann the German, Rubey said city officials might be able to raise enough in private donations or get a state grant to pay for the repairs, sparing local taxpayers.

“I think there’d probably be a lot of donations,” he said. “And if they can get it, good. It should be fixed.”

a view of New Ulm
A 360-degree view of New Ulm and the Minnesota River Valley that can be seen at the top of Hermann the German Monument from the observation platform.
Hannah Yang | MPR News

Some New Ulm residents hope that the effort to restore the monument gains more support, like Holly Beckmann. She said she hasn’t had the chance to climb up to the top of the Hermann Monument, but she enjoys having this giant historic relic in the center of town, and she doesn’t “like to see things go.”

“I’ve always wanted to take my kids there and to make sure that it is safe for little kids,” Beckmann added.

Others agree, saying Hermann the German is a huge part of the community’s identity and that they can’t imagine New Ulm without him.

“That would be horrible, because out of my bedroom window upstairs, I can see Hermann,” said Kathy Rubey, 75, of New Ulm and Gary’s wife. “I would miss looking out that bedroom window, and go, ‘There’s Hermann’.”

Hermann the German monument
Hermann the German Monument needs repairs, according to New Ulm city officials. An estimate for deconstructing and reconstructing the historic monument was projected to come in around $11.6 million. The monument is an iconic symbol for the city of New Ulm and is associated with German heritage and pride.
Hannah Yang | MPR News



Source link

Leave a Reply

Subscribe to Our Newsletter

Get our latest articles delivered straight to your inbox. No spam, we promise.

Recent Reviews


Normalization in SQL Server – Table of Content

What is Normalization?

Normalization is the organization of data using a set of rules called normal forms while designing a database. It helps improve data accuracy and integrity while reducing data redundancy and inconsistent dependency. It was developed by IBM researcher Edgar Frank Codd in the 1970s to increase data and relational clarity in a database. The process includes organizing data in tabular formats and defining relationships among them. Codd proposed the relational model of databases and introduced the Normal Forms. Most practical applications of database organization can be achieved using the Third Normal Form. But still, some dependencies could exist so in 1974, he was joined by Raymond F. Boyce to develop a stronger version of 3NF, the Boyce-Codd Normal Form.

Types of Normalization

The set of rules used to create a database are called ‘forms’, these help in measuring the level of normalization of an entity. The different types of Normalization Forms are as follows:

1. First Normal Form (1NF):

1NF divides the database into logical units called ‘tables’ consisting of unique values in each related field making it easy to search, filter, and sort the information. While normalizing a database for 1NF a Primary key i.e. a single column is allotted to each data category. It helps in the redevelopment of the raw database into a manageable record. The primary key may consist of a combination of columns and the set is known as Composite Key.

2. Second Normal Form (2NF):

 2NF is the schema of further breaking down the tables based on the partial dependency of data on the primary key. The specific units have a full functional dependency that applies to a single column of Primary key. The entity must completely comply with relationship rules of 1NF to be considered for 2NF and there shouldn’t be any partial dependency. A table with a Composite Primary Key must be split into 2 to generate a foreign key. The foreign key will be the column that references the Primary Key of the other table.

3. Third Normal Form (3NF):

 The objective of entities eligible for 3NF is to eliminate non-dependent data while addressing the update anomaly. The inconsistency of the database following an update is called transitive dependency. Removal of these transitive dependencies leads to normalization from 2NF to 3NF. This is the ideal form of normalization of almost all tables.

4. Boyce Code Normal Form (BCNF):

Redundancies arising from functional dependencies are resolved by 3NF but any anomalies arising from additional constraints are handled through BCNF, also known as 3.5NF. A 3NF table or relation without a transitive dependency is in BCNF.

5. Fourth Normal Form (4NF):

At the 4NF level there are no non-trivial multivalued dependencies other than a candidate key. A relation from a table in the BCNF, without multi-value dependency, only can be in the 4NF.

6. Fifth Normal Form (5NF):

5NF is also known as project-join normal form (PJ/NF). It reduces redundancy in relational databases by isolating semantically related multiple relationships. For a table to be in 5NF its non-trivial join dependency should be implied by candidate keys.

7. Domain/Key Normal Form (DKNF):

DKNF is a stricter normal form than 5NF and it removes any additional type of dependencies and constraints. The main requirements for a 5NF to qualify for DKNF are that each constraint on the table should be a logical consequence and non-existence of all constraints other than domain and keys. Also, there shouldn’t be any insert or delete anomalies in the database. Specifying general integrity constraints is tough so the practical use of DKNF relation is limited.

8. Sixth Normal Form (6NF):

6th normal form is not a standardized form but a table eligible for 5NF only can qualify for 6NF. To be in the 6NF a relation should not contain any non-trivial join dependencies. It is stricter and less redundant that DKNF. The relational variables of entities in this form become irreducible components.

  Become a MSBI Certified professional  by learning this HKR MSBI Training !

MSBI Training

  • Master Your Craft
  • Lifetime LMS & Faculty Access
  • 24/7 online expert support
  • Real-world & Project Based Learning

Importance of Database Normalization

Normalization of operational data stores (ODSs) and data warehouses (DWs) helps in the following ways:

1. Consistency: As all information is stored in a single place, any chances of inconsistency are ruled out.

2. Object-to-data mapping: Normalized data schemas help with object-oriented goals.

3. Flexibility: Data values can be easily added to rows.

4. Accessibility:  Normalized data can be easily accessed, processed, and understood.

5. Uniqueness: Data redundancy is minimized.

Advantages of Normalization

Database Normalization is used to design an organized and managed database to maintain accuracy and enhance productivity. The main advantages of normalizing a database are:

  • Organization of the database through normalization improves data accuracy and reduces redundant data.
  • Data consistency and flexibility improves the logical usage of data.
  • Enhanced database security.
  • All necessary functional dependencies are handled during the normalization process.
  • Makes Index searching easier as the indexes tend to be narrow and short.

What is TSQL?

TSQL is an abbreviation for Transact-SQL or T-SQL. It is a set of proprietary extensions to SQL (Structured Query Language) created by Sybase and owned by Microsoft since 1987. This procedural language expands the Microsoft SQL Server standard with extra features such as declared variables, transaction control, stored procedures, error and exception handling, triggers, string operations, etc. TSQL is used to operate SQL server-based relational databases. It is easier to understand and Turing complete. All interactions with a SQL Server through an application are carried out by T-SQL.

The dominant features of TSQL are:

1. It is a procedural programming language used to create applications.

2. Generates compact and readable codes that are less vulnerable.

3. Support functions for string processing, date and time processing, and mathematics operations.

4. Availability of user-defined custom functions.

5. Offers developers flexible control over the application flow through local variables.

TSQL Functions

Functions can be defined using TSQL beyond the built-in functions of SQL Server.

There are four types of T-SQL functions:

Aggregate functions: 

These deterministic functions operate on a collection of values to calculate one summary value. The values of multiple rows are submitted as input to obtain a more significant value.

Ranking functions:

These are nondeterministic functions that return a ranking value for every row in a partition. The ranks for rows with the same values will be the same.  

Rowset functions:

These nondeterministic functions return an object that can be used as a view or table reference in SQL statements. Their results may vary against the same set of input values.

Scalar functions:

These user-defined functions operate on a single value and return a single value. It helps in simplifying a code but cannot be used to update data.

Analytical functions:

These functions support TSQL to perform complex tasks and enable expression of common analysis such as ranking, percentiles, moving averages, and cumulative sums in a single SQL statement.

 Want to know more about MSBI,visit here MSBI Tutorial.

HKR Trainings Logo

Subscribe to our YouTube channel to get new updates..!

Differences between SQL and T-SQL

The differences between SQL and T-SQL are:

  • SQL is an open-format programming language that works for various data providers and TSQL is its proprietary extension designed specifically for Microsoft SQL Server.
  • SQL is used for implementing reporting techniques while TSQL is useful for the installation of Microsoft SQL servers using applications.
  • SQL is a data-oriented language as it operates over data sets while TSQL is a transactional language.
  • SQL can process basic queries but TSQL can be used to create applications and add services to them.
  • At a given time only a single statement can be processed using SQL while a load of statements can be processed using different control and iteration structures of T-SQL.
  • SQL can be embedded into TSQL but the vice versa isn’t possible.
  • Unlike SQL, TSQL is Turing complete and more robust.
  • Unlike SQL, T-SQL offers easy integration with Microsoft Business Intelligence tools like PowerBI.

Advantages of TSQL

TSQL helps in fast-paced development through better interaction with the SQL Server. The advantages of using TSQL are:   

  • TSQL offers modular programming and its extensions enhance its programmability.
  • Increased reliability and proprietary security of the server.
  • Efficient handling of sensitive data to reduce security threats.
  • Minimizes traffic over the server while easily managing complex tasks.
  • Allows incorporation of programming logic into the database.
  • Provides better control over the database instance.

Click here to get latest MSBI Interview Questions and Answers for 2022

MSBI Training

Weekday / Weekend Batches

 Conclusion

Normalization aids in the easy organization of a database and TSQL assists in writing compact codes. Using these two concepts together makes the database and codes more readable and less vulnerable. The main areas of focus while using these will be designing tables as per the database architecture, reviewing and optimizing Query performance, and scaling the database by implementing it on the cloud. Using these in combination will help developers integrate Microsoft Business Intelligence for business analytics.

Other Related Articles:

1. SSIS Interview Questions

2. MSBI Interview Questions

3. Jaspersoft Training



Source link