Bentley Communities
Site
Search
User
Site
Search
User
Product Communities
OpenGround | gINT | Keynetix
gINT Forum
Sign In
All tags
query
gINT
output
Site Maps
SPT
SQL
Outputting query results visually (eg as site plans)
Sue D'Nymm
I have a site with a large number of boreholes and I need to assess the depth to a certain SPT value at each borehole across the site to zone it. Is it possible to create a query to identify the depth at each point and output this as a the labels on a…
Answered
over 1 year ago
OpenGround | gINT | Keynetix
gINT Forum
Re: Display soil description in Sample Table
Pat Cummings
Just looking at the SQL, there are some problems: <<Sql(SELECT (LITHOLOGY.DESCRIPTION) _ FROM LITHOLOGY _ WHERE (<<Sample.Depth>> < <<Lithology.Bottom>>) AND _ (<<Sample.depth>> >= <<lithology.depth>>) _ )>> should be: <<Sql(SELECT [LITHOLOGY…
over 10 years ago
OpenGround | gINT | Keynetix
gINT Forum
View related content throughout OpenGround | gINT | Keynetix
More
Cancel