In this script we build on our previous code by adding a GROUP BY to our SUM of the length_m column. This will return you the entire network length for each of the different carriageway hierarchies used on your network. Steal this SQL code to try it out in RAMM SQL #SQLforRAMM

In this script we use the SUM keyword to add all the values together in the length_m column. This will return you the entire 'network length' in metres (i.e. the sum of every single carriageway record in your database). Steal this SQL code to try it out in RAMM SQL. #SQLforRAMM

Continuing to build on the NOT IN concept from our previous entry. This time round we are excluding multiple ownership types (local authority AND private) in one go, through the use of comma separated values. Steal this SQL code to try it out in RAMM SQL. #SQLforRAMM

Building on the previous entry in the series, this time we use NOT IN instead of <> to exclude carriageway sections where the asset owner is local authority. Steal this SQL code to try it out in RAMM SQL #SQLforRAMM

This SQL code will return all the carriageway sections, where the asset owner is something other than Local Authority (which is the default owner in a NZ local road database). Steal this SQL code to try it out in RAMM SQL #SQLforRAMM

Need to know the number of “roads” for each road type in your RAMM database? Then steal this SQL code to find out. Just remember the road names table in RAMM isn’t necessarily just for roads. It could include other network features like paths, car parks & reserves #SQLforRAMM

Ready to power up your RAMM use? Do you want to see some bite-sized snippets of RAMM SQL code? Looking to brush up on your RAMM SQL skills? We are launching a new little social media based project shortly…. The #SQLforRAMM project. Coming soon! #SQLforRAMM