Melbourne Waterway Research-Practice Partnership, Waterway Ecosystem Research Group, School of Ecosystem and Forest Sciences, The University of Melbourne, Burnley 3121, Victoria Australia DRAFT 9 December 2019

Summary

The Melbourne Water Stream Network represents the flow paths and catchments of the streams and rivers of the Greater Melbourne Region (the region managed by Melbourne Water). The Network is a spatial dataset that :

Citation (for this report and for the use of any data downloaded from https://urbanstreams.net/tools/mwstr/: this site provides a direct interface to the data)

Kunapo, J., Walsh, C.J., Sammonds, M.J. (2019) The Melbourne Water Stream Network. Version 1.0. Melbourne Waterway Research-Practice Partnership Report 19.4. School of Ecosystem and Forest Sciences, The University of Melbourne, Melbourne. URL: https://urbanstreams.net/tools/mwstr/.

Introduction

This document describes the structure of the Melbourne Water Stream Network dataset and provides illustrations of how to extract data from the dataset. The data are available in several forms (Table 1), with the most flexible for data extraction being a relational spatial database that can be accessed through the software program R using a library of functions. A web application (in development) provides a simple interface for extracting data from the database. All data can be accessed through the web application at urbanstreams.net/tools/mwstr/.

Table 1. Melbourne Water stream network data components, structures and locations for access.

Format

Description

File

Location

ESRI shapefiles


Excel tables

Stream layer
Subcatchment layer
Subcatchment floret layer
Reachcode table
Stream Name table
MW asset table
Metadata table

mwstr_v1.0.shp
mwsubc_v1.0.shp
mwsubc_v1.0.shp
mwstr_tables.v1.0.xlsx

urbanstreams.net/resources/mwstr/mwstr_v1.0.zip

R objects

Simple features (sf) tables
that inlcude all-upstream
information
List of all-upstream vectors
for catchment calcs

mwsubc
mwsubc_florets

allupstream_list

urbanstreams.net/resources/mwstr/mwsubc_v1.0.rda
urbanstreams.net/resources/mwstr/mwsubc_florets_v1.0.rda

urbanstreams.net/resources/mwstr/allupstream_list.rda

Postgres spatial
database

Relational database with library
of R functions for data extraction
and manipulation

mwstr database
mwstr_functions.R

urbanstreams.net (external access proposed)
urbanstreams.net/resources/mwstr/mwstr_functions.R

Web application

Shiny web application permitting
extraction from the database

downloadable shapefiles

urbanstreams.net/tools/mwstr/

Documentation

This document in HTML, Word
and Rmarkdown formats,
the last containing source code
used in producing this document

MWstreamNetworkManual.html
MWstreamNetworkManual.docx
MWstreamNetworkManual.Rmd

urbanstreams.net/resources/mwstr/MWstreamNetworkManual.html
urbanstreams.net/resources/mwstr/MWStreamNetworkManual.docx
urbanstreams.net/resources/mwstr/MWstreamNetworkManual.Rmd

The tables of the database and their relationships are illustrated in Fig. 1. Each of the tables is described below.

Fig. 1. Table relationship diagram for the mwstr database, showing all fields in each table and connections between tables. Those with a geometry field are spatial tables. The ‘coast’ table is a polyline spatial table for adding a coast line to any stream-line maps.