Navigation:  Menu Bar > Project >

Creating New Projects

This section presents information on how to create new projects, and modify the properties of existing projects. A new project is usually created with a completely new database; however, HGA is designed to also allow for managing multiple projects within a single database.

The most common workflow is to create a new database for each new project and that workflow is documented here.


Starting the New Project Wizard


The New Project Wizard can be launched in two ways:


Select Project / New from the Main Menu; OR

Click on the button on the Start Page.


The New Project Wizard will then appear. The Project Wizard contains various steps, each step appearing in a new window, with the various settings for a new project. It is designed in a sequential fashion; after defining the necessary inputs in each window, press the Next button to proceed. The Next button will only become activated after the necessary fields have been defined.


The Wizard includes the following steps:

Data Source

Select Template

Project Settings

Create Project


Data Source

The first step in the New Project Wizard provides the data source settings options.


Data Source Type

HGA allows you to store your project data base within a Microsoft SQL Server instance or within a Local Database:

If this project is intended only for you (others will not need to be given access) then the Local Database option can be used. It does not require any additional Microsoft SQL Server installation or connections - as this is already done (silently) during the HGA installation.


If however, this project will need to be accessed by multiple users, you should use the Microsoft SQL Server option. We currently support versions between Microsoft SQL Server 2012 to 2019 (Express or Full editions).


Local Database

If you have selected to use the Local Database, you only need to specify the Instance name of your local database. When it is installed with HGA, it is named "Waterloo" - however if you have another instance installed, you can use that as well. Once you have selected a local instance, you can provide a name for the database.



Please Note: If Local Database does not appear in the dropdown, consider closing and then restarting Hydro GeoAnalyst to initiate the Local Database. In some cases you may have to restart your machine.


Microsoft SQL Server

If you have selected Microsoft SQL Server you will need to select the SQL Server that will hold your project database and then provide a name for the database. You have two options for authentication:

1.Windows Authentication (default)

2.SQL Server Authentication


Windows Authentication uses your log in to authenticate you on the SQL Server while SQL Server Authentication requires you to enter an appropriate User Name and Password to be authenticated on the SQL Server.



Please Note: Appropriate permissions need to be provided to use either of the authentication options. Please contact your IT support to ensure you have appropriate permissions to create new databases or create new projects on existing databases.
Refer to Connection Problems for some troubleshooting suggestions if you cannot see your local instance of SQL Express when creating a new project, or opening an existing project.



Once you have define the Data Source information for your project, select the button to proceed to the next step in the New Project wizard.

Select Template

This step in the New Project wizard allows you to select which database template to use for your project. A <Basic Template> that can be extended is provided with Hydro GeoAnalyst.

When you select a template from the drop down list you can review the database structure in the preview below.



If you have exported a database template from another project and would like to use it to create a new project, select the browse button and browse to the location of your template (*.hgat).

Select the button to proceed to the next step in the New Project wizard.

Project Settings

This step in the New Project wizard allows you to specify a project name and location for your project folder.Additionally you can select a Material Specification and then the Projection Type and Projection to be used for your X and Y coordinates.


The Unit for your projection will be selected automatically based on the selected projection type (e.g. UTM will use m, State Planer will use feet, etc.). If the Local Projection Type option is selected, you can select the desired unit from the drop down box.


Please Note: If Local Projection Type is selected, the project coordinate system cannot be changed once the project is created. Furthermore, all imported spatial data must already be expressed in local coordinates as HGA does support conversions from projected/geographic coordinates systems to local systems.


Depending on the projection type that you select, you may also be required to select an appropriate Geotransformation for your project. If required, the following dialog will display:


Simply select the area that best represents the spatial extent of your geographic data from the list, and then click the [Ok] button. Note: You will not be able to create the project until you have selected an area. For more details on defining geotransformation settings, please refer to Appendix F: Configuring Geotransformation Settings.

Once you have specified the projects settings select the button to proceed to the final step of the New Project wizard.


Create Project

At this final step in the process, click the button to finish the setup of the new project.



Page url: