An interactive web map: visualising crash data for the Northland Region of New Zealand using ArcGIS Online
RAMM Tutorial: Using RAMM SQL to access ONRC information
Maps can be a fantastic way to visualise and communicate datasets.
Todays post has a simple embedded interactive web map, to explore NZTA crash data in the Northland region of New Zealand. A vertical time slider can be used to dynamically switch between two different financial years worth of crash data, creating a neat visual comparison tool with the data.
The map has been created using ArcGIS Pro and ArcGIS Online. Hit the link to check it out.
How to find road ONRC classifications in RAMM
Today’s post shows you how to retrieve the ONRC classifications for carriageway sections in your road network, using the RAMM SQL application.
You will get a bonus resource for your RAMM toolkit; a very quick and easy script that you can run on your own database to get this ONRC information.
The One Network Road Classification [ONRC] in New Zealand
Road networks and their associated assets are defined and managed in the RAMM database. Did you know that you can also see the ONRC classification of each carriageway section in your road network, directly within RAMM itself?
This post will show you how to find ONRC information in your RAMM database, and how to see this information visualised on a map or in grid view format.
Hit the link to find out more!
Using ArcGIS desktop on a Mac ... without Boot Camp
The One Network Road Classification, or ONRC as it’s commonly referred to, is a standardised system to classify roads in New Zealand.
This post will provide a brief introduction to the ONRC system, take a look at the different classification levels used, show you where you find the classification of roads around the country and provide links to further resources.
The 2018 Auckland RAMM User Group
Here at The Datastack I power the business with Apple hardware. And I also deploy ArcGIS on projects.
That pairing can seem a little bit odd, what with the ArcGIS desktop product suite being built for Microsoft Windows. However this apparent mismatch is not actually a barrier to using ArcGIS desktop on a Mac. Read on to find out how using an app called Parallels.
May 1 is here ... how is your valuation preparation going?
Last month the 2018 RAMM User Group was held at Eden Park in Auckland. This was a one day event put on by the good folks at RAMM Software Limited (RSL), to provide insights into where the product is heading and whats new with the software.
Enhancing the RAMM user experience with the Touch Bar
Its the first day of May, which means we are fast barrelling towards the end of the 2017/18 financial year. And with the end of the financial year typically comes some impending deadlines for the asset valuation process for many Local Authorities.
Hit the link to read more!
Photos from the RIMS Forum 2018
Utilising the power of the MacBook Pro Touch Bar, you can build some pretty powerful little workflow automations. These can help to streamline common actions when doing development work within the RAMM SQL app.
Hit the link below to read more about the current work in progress setup here at The Datastack.
RAMM Valuation Week - Day 5: Are you managing 'new' assets?
A quick update on the RIMS Forum after day one, and a link to some photos from the event!
RAMM Valuation Week - Day 4: Are your defined units of measure robust?
RAMM Valuation week wraps up with todays post about managing new assets. Hit the link below to read the final instalment in the series.
RAMM Valuation Week - Day 3: What costs are being used by which assets?
A key foundation component that can have a significant impact on the valuation outcomes. Hit the link to find out the details as RAMM Valuation week continues.
RAMM Valuation Week - Day 2: What replacement costs are you using?
Out of hundreds or thousands of standard replacement costs defined in the database, how exactly does RAMM know which unit cost to use for which specific individual asset?. Hit the link to read more for day three of RAMM Valuation week.
RAMM Valuation Week - Day 1: What assets are being valued?
It's day two of RAMM Valuation week, and today is all about standard replacement costs .... hit the link to read more.
RAMM Valuation Week is here!
What assets are you valuing in your RAMM database? Its not necessarily a clear cut answer based just on what data you are managing. Day one of RAMM Valuation week is here .... hit the link to read more.
RAMM User Group Conferences for 2018
Rather than leaving it to the last minute and dealing with the stress of understanding what needs to happen, who is going to do what, and trying to figure out where exactly that missing data is, there is still enough time to proactively take charge of the your RAMM Valuation.
This week on the blog it is RAMM Valuation Week. Click the link below to find out more!
PSA: Road Infrastructure Management Forum for 2018
Keeping on the event stream from the previous post, this is a heads up for two (FREE!) events coming up in May. Hit the link below to get the details and find links to the registration pages for both the Auckland and Perth conferences.
Date conversion in SQL Server
The Road Infrastructure Management Forum is heading to Palmerston North on Wednesday 21st and Thursday 22nd March.
Aesthetic improvements for OneDrive
Working with dates in SQL Server can require additional formatting processes to get the date to show in a certain way. This post looks at using the CONVERT method to quickly achieve some common date formatting conversions.
OneDrive is a cloud storage solution from Microsoft, where you can upload all sorts of files such as documents, pictures and videos and then access these from different devices.
The local OneDrive app on MacOS works well to show your 'space in the cloud' natively within a Finder window, appearing as just another folder or drive on your machine. However there are a couple of minor 'aesthetic issues' that can detract a little bit from the experience;
Hit the link below to find out what these issues are and the simple steps to resolve them and power-up your user experience.