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
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.
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.
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.
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.
Detecting hundreds of invalid centrelines in a single network
Today’s post is a case study look at a centreline data validation analysis project, undertaken by The Datastack, which had an amazing and somewhat surprising outcome!
The Datastack was commissioned by a professional services consultancy for this project, with the dataset in question relating to a local authority transport network.
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.