The TalkData Blog

TalkData is your go-to blog for all things related to data, asset management, RAMM, and information systems.

Whether you are interested in infrastructure asset management, road network management, or the land transport sector, TalkData is a perfect resource for you. But even if you just enjoy data, interesting projects, and cool tools, you'll find plenty to love at TalkData too.

And if you like what you see, why not subscribe to our newsletter? You'll get all our new articles sent straight to your inbox each month, giving you the edge you need to stay ahead in the game.

Thanks for checking out the blog!

Five of the best features in the new RAMM SQL Management app
#RAMM, #SQL The Datastack is an asset information management and digital solutions consultancy. #RAMM, #SQL The Datastack is an asset information management and digital solutions consultancy.

Five of the best features in the new RAMM SQL Management app

A new SQL app has arrived in the world of RAMM. Its called SQL Management, and it will become the successor to the mainstay classic RAMM SQL app.

In this article we take a look at five of the best features that are in the new RAMM SQL Management app. Plus there is also a little discussion about why the classic RAMM SQL still has its advantages.

Click the link to find out more.

Read More
How to customise your RAMM HTML menu
#RAMM The Datastack is an asset information management and digital solutions consultancy. #RAMM The Datastack is an asset information management and digital solutions consultancy.

How to customise your RAMM HTML menu

Do you frequently access the same RAMM apps or datasets? Did you know you can add these items as favourites in your RAMM HTML Menu?

In this article we walkthrough how to add the new SQL Management app, the RAMM Centreline Manager app, and the drainage asset table as favourite items.

Click the link to find out how to customise your RAMM HTML menu.

Read More
Level up your RAMM Map with a new base layer
#RAMM, #GIS The Datastack is an asset information management and digital solutions consultancy. #RAMM, #GIS The Datastack is an asset information management and digital solutions consultancy.

Level up your RAMM Map with a new base layer

When working with data, maps are a very powerful tool to have in your arsenal.

If you are a user of the RAMM HTML app, you will probably be familiar with the RAMM Map. This is a neat tool to visualise your data within a spatial context on your network.

In this article we walk through how you change the RAMM Map layer, to easily overlay Google satellite imagery, LINZ imagery and more.

Click the link to find out how.

Read More
How to pin a column in the RAMM HTML grid
#RAMM The Datastack is an asset information management and digital solutions consultancy. #RAMM The Datastack is an asset information management and digital solutions consultancy.

How to pin a column in the RAMM HTML grid

Have you ever wanted to keep a column on screen at all times when working in a RAMM HTML grid? Perhaps when you are scrolling through the columns of a large table, you always want to see the name of the road for each record.

The good news is you can do this by pinning a column on screen. In this article we talk about how to pin and unpin columns, automatic column ordering that RAMM will perform, and a neat drag and drop trick.

Hit the link to read more.

Read More
How to remove a core RAMM table with Table Manager
#RAMM The Datastack is an asset information management and digital solutions consultancy. #RAMM The Datastack is an asset information management and digital solutions consultancy.

How to remove a core RAMM table with Table Manager

Do you have unused or redundant core RAMM tables cluttering up your database? Did you know you can now remove these tables?

In this post we set out to remove a core RAMM table using the new Table Manager application.

First we look at how to find the RAMM Table Manager application. We then remove the Features table and look at what this means for your database (plus detail a sneaky little way to still access the table). Then we bring it back again by restoring the Features table back to our RAMM database.

Hit the link to find out more!

Read More
RAMM Download Series: Classic RAMM
#RAMM The Datastack is an asset information management and digital solutions consultancy. #RAMM The Datastack is an asset information management and digital solutions consultancy.

RAMM Download Series: Classic RAMM

The RAMM Download Series looks at some of the common and accessible ways to export your data from the RAMM System. There are two key objectives for each post in the RAMM Download Series:

  • Export the carriageway dataset (based on the TalkData network), including every record in the table.

  • Get this exported data into an Excel spreadsheet.

In this post we walk through how to download data from the Classic RAMM app, including how to customise the grid before exporting your data.

Read More
Creating an AMDS compliant SQL Server database
#AMDS, #SQL, #RAMM The Datastack is an asset information management and digital solutions consultancy. #AMDS, #SQL, #RAMM The Datastack is an asset information management and digital solutions consultancy.

Creating an AMDS compliant SQL Server database

The AMDS project is tasked with developing an Asset Management Data Standard for the New Zealand Infrastructure sector.

In this post we use one of these .sql files from the AMDS releases to create an AMDS compliant database structure in SQL Server. We then dive in to take a look at the asset and lookup tables included out of the box. Finally, if you are used to the RAMM interface, we will see how one of these tables looks in a RAMM environment.

Read More
Steal this SQL: RAMM basics volume one
#SQL, #RAMM The Datastack is an asset information management and digital solutions consultancy. #SQL, #RAMM The Datastack is an asset information management and digital solutions consultancy.

Steal this SQL: RAMM basics volume one

This is the first post in a new series of articles called ‘Steal this SQL: RAMM Basics’.

The focus here is to show some basic SQL concepts and code to use in Thinkproject’s RAMM software. It is intended to provide resources at a starter level, for those looking to get up and running with RAMM SQL for the first time, or for those after a bit of a refresher.

Read More
Easily find dependencies on a RAMM User Defined Table
#RAMM The Datastack is an asset information management and digital solutions consultancy. #RAMM The Datastack is an asset information management and digital solutions consultancy.

Easily find dependencies on a RAMM User Defined Table

User Defined Tables, or UDT’s as they are commonly referred to, are custom tables in Thinkproject’s RAMM software.

If you manage RAMM UDT's, you will want to know about this nifty little feature in UDT Manager; the References screen, to find all the dependencies on a UDT.

Read More
Five compelling new things coming to RAMM in 2021
#RAMM The Datastack is an asset information management and digital solutions consultancy. #RAMM The Datastack is an asset information management and digital solutions consultancy.

Five compelling new things coming to RAMM in 2021

In this post we look at five compelling new things coming to Thinkproject’s RAMM platform this year. From iOS & Android support to interactive 3D assets.

Hit the Read More link below to find out more.

Read More
The RAMM feature you have always (probably) wanted is nearly here
#RAMM The Datastack is an asset information management and digital solutions consultancy. #RAMM The Datastack is an asset information management and digital solutions consultancy.

The RAMM feature you have always (probably) wanted is nearly here

Do you want to hide any unused standard tables from all database users? Do you want to modify existing standard table by adding an extra attribute or two? You need to check out this new feature coming to RAMM.

Read More
The information tool you need to try in RAMM Map
#RAMM The Datastack is an asset information management and digital solutions consultancy. #RAMM The Datastack is an asset information management and digital solutions consultancy.

The information tool you need to try in RAMM Map

Does this situation sound familiar? You have been looking at a location in RAMM Map and wondering where exactly it is within your linear network? Perhaps the number of metres that location is from the road origin, or the offset from the centreline, or both?

Great news; the Road Information tool is right there waiting to help.

Read More
RAMM Download Series: The RAMM HTML grid
#RAMM The Datastack is an asset information management and digital solutions consultancy. #RAMM The Datastack is an asset information management and digital solutions consultancy.

RAMM Download Series: The RAMM HTML grid

The RAMM Download Series looks at some of the common and accessible ways to export your data from the RAMM System. There are two key objectives for each post in the RAMM Download Series:

  • Export the carriageway dataset (based on the TalkData network), including every record in the table.

  • Get this exported data into an Excel spreadsheet.

Todays post walks through how to download data from the RAMM HTML grid.

Read More
An overview of the RAMM Download Series
#RAMM The Datastack is an asset information management and digital solutions consultancy. #RAMM The Datastack is an asset information management and digital solutions consultancy.

An overview of the RAMM Download Series

This article is the launch of a new set of posts on the TalkData blog; The RAMM Download Series. RAMM hosts a significant volume of asset information for different road controlling authorities around New Zealand, Australia and Fiji.

Assuming you have the permissions to one or more of these RAMM databases, RAMM is actually quite an 'open' system.

Read More
Filter by security zone in RAMM Map & RAMM Grid
#RAMM The Datastack is an asset information management and digital solutions consultancy. #RAMM The Datastack is an asset information management and digital solutions consultancy.

Filter by security zone in RAMM Map & RAMM Grid

RAMM security zones define sets or groupings of roads in your network. These zones can reflect things like geographic areas (e.g. North area vs South area), regulatory or political boundaries, or maintenance contract boundaries.

In this post we are going to walk through how filter your RAMM network by security zones, in both the RAMM Map and RAMM Grid apps.

Read More
RAMM SQL basics and writing a simple query
#RAMM, #SQL The Datastack is an asset information management and digital solutions consultancy. #RAMM, #SQL The Datastack is an asset information management and digital solutions consultancy.

RAMM SQL basics and writing a simple query

RAMM SQL provides a very quick and easy way to interact with your RAMM database. If you are not sure what SQL actually is, there is a very quick introduction below.

Then after that you can follow along with a step-by-step walkthrough of how to get the list of roads for your network. You will see that only a couple of lines of code are needed to get a the list of roads out of your RAMM database.

Read More
How to setup a new security zone in RAMM
#RAMM The Datastack is an asset information management and digital solutions consultancy. #RAMM The Datastack is an asset information management and digital solutions consultancy.

How to setup a new security zone in RAMM

In an earlier post we digitised a bunch of new roads in a hypothetical new roading network; the TalkData network. In today’s post we are going to add these roads to their own security zone in RAMM.

To start with though we will give a really quick overview of security zones in RAMM. We will then go through the step-by-step process of setting up the TalkData security zone, using the RAMM HTML application.

Read More
Building the TalkData network for RAMM using ArcGIS Pro and open source data
#GIS, #RAMM The Datastack is an asset information management and digital solutions consultancy. #GIS, #RAMM The Datastack is an asset information management and digital solutions consultancy.

Building the TalkData network for RAMM using ArcGIS Pro and open source data

Upcoming TalkData content is going to be getting hands on and practical with data. To help make this happen I wanted to have a 'data sandbox' to use here on the blog. The purpose of the sandbox would be to demonstrate different processes, tips and tricks for use on your own data.

So I set about creating a custom TalkData network in RAMM - a fictional transport network based in real-world environments. This post talks through the process and tools applied in the process.

Read More
No message box buttons to click in RAMM? Try this one simple trick.
#RAMM The Datastack is an asset information management and digital solutions consultancy. #RAMM The Datastack is an asset information management and digital solutions consultancy.

No message box buttons to click in RAMM? Try this one simple trick.

Have you been doing work in RAMM Grid, and a message box appears to confirm an action…… but there is no button to press to actually carry on with the job? Are you stuck and not sure what to do next?

The issue is you may be using an unsupported web browser.

Well the good news is there is a very simple trick to get around this issue.

Read More
You need to try this hybrid map layer in RAMM Map
#RAMM The Datastack is an asset information management and digital solutions consultancy. #RAMM The Datastack is an asset information management and digital solutions consultancy.

You need to try this hybrid map layer in RAMM Map

Find out all about a new base map layer option in RAMM Map, which brings you the best of both worlds from the standard and satellite map layers.

Read More

 

The latest from the TalkData blog...
direct to your inbox.

Click the button below to sign up to our monthly newsletter.
You will receive all the latest TalkData post + other news and updates.