Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Viewing different Matrix types in map with SQL server version?
Options
Go to last post Go to first unread
Previous Topic Next Topic
JKW  
#1 Posted : Friday, January 11, 2013 6:44:15 PM(UTC)
JKW
Rank: Advanced Member

Reputation:

Groups: Registered
Posts: 79

In the Access version - i might have rebuilt a query on a specific project that allowed me to view 2 differnt matrix types in the one query, so i could view and compare specific things i was interested in on the map dynamically. EG - if users wanted to view GAS and Gwater results at the same time in order to assess the location of plume.

My Questions:

1. Can queries be built that are specific to a site or project in Sql server version (And is there a detailed doc on the additional schema for SQL )

2. How best to compare results of differing matricies on the ESdat map? One option is to export a Gis file (shape file) and add to map view. This is static. In Access a new query could achieve the same thing. Any thoughts on options?

Back to top

Wanna join the discussion?! Login to your ESdat Forums forum accountor Register a new forum account.
Back to top  
Warwick Wood  
#2 Posted : Friday, January 11, 2013 8:00:24 PM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

Hi Justin,

You can create custom output views in the SQL Server version of ESdat, in the same way you can in Access.

The main differences are:

  • you will need the SQL Server design interface instead of Access (SQL Server Management Studio, or SSMS)
  • you will need database permissions to add views to the database

As for the schema, Schema  "Database Diagrams" for SQL Server are included with the database, you will need SSMS to view them, just as you will need SSMS to make any customisations. 

We are happy to review any custom view you produce.

Regards,

Warwick

Back to top
WWW
JKW  
#3 Posted : Friday, January 11, 2013 8:58:37 PM(UTC)
JKW
Rank: Advanced Member

Reputation:

Groups: Registered
Posts: 79
Any thoughts on the issue of viewing different chem States in a query? Could make for a useful addition to the ChemQA queries. Mostly desired if someone wanted to directly compare results for 1 or more analytes across soil, water and gas - when looking for trends or plumes.
Back to top
Warwick Wood  
#4 Posted : Saturday, January 12, 2013 2:56:09 AM(UTC)
Warwick Wood
Rank: Administration

Reputation:

Groups: Registered, Administrators
Posts: 498
Man
Location: Byron Bay

Was thanked: 19 time(s) in 19 post(s)

Hello Justin,

To combine outputs from a mix of matrix states (liquid, gas, solid) you will need to create a custom view.

The easiest way to do it is to simply create a UNION view based on the existing views, which are per-matrix-state, and include just the columns that you need.  

Regards,

Warwick

Back to top
WWW
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF.NET | YAF.NET © 2003-2024, Yet Another Forum.NET