#sqlforramm search results

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

Generate a list of Road Names and Road ID's in your network, with this simple little bit of SQL code. In this script we are querying the roadnames table and returning just two specific columns; road_id and road_name. #SQLforRAMM #RAMM #RAMMSoftware #RAMMAssetManagement #SQL

Kicking #SQLforRAMM off with some basics. This simple query will show you all of the carriageway sections defined in your network. Remember; the #SQLforRAMM project is showing different code and concepts available to you, not the only way / definitive way to do something.

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

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

Kicking #SQLforRAMM off with some basics. This simple query will show you all of the carriageway sections defined in your network. Remember; the #SQLforRAMM project is showing different code and concepts available to you, not the only way / definitive way to do something.

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

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

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

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

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

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

Generate a list of Road Names and Road ID's in your network, with this simple little bit of SQL code. In this script we are querying the roadnames table and returning just two specific columns; road_id and road_name. #SQLforRAMM #RAMM #RAMMSoftware #RAMMAssetManagement #SQL