Moloney

The Moloney Assset Management System manages the condition assessment of road and bridge assets.

Moloney stores its asset data in advanced spreadsheets. Pozi dynamically extracts asset attributes directly from the spreadsheets for any selected features in compatible map layers. The map layer needs only an asset id field (eg, road segment id) to be populated.

Pozi displays the attributes of a selected road segment directly from the Moloney spreadsheet

Data Connection

Create a St-data2.vrt file with the following contents and place it in the same folder as the source St-data2.xlsm file.

St-data2.vrt

<?xml version="1.0" encoding="UTF-8"?>
<OGRVRTDataSource>
    <OGRVRTLayer name="stdata2">
        <SrcDataSource relativeToVRT="1">St-data2.xlsm</SrcDataSource>
        <SrcSql dialect="sqlite">select * from 'MASTER SHEET' where Field1 != '' limit 999999 offset 21</SrcSql>
        <Field name="Seg_ID" src="Field1" type="Integer"/>
        <Field name="Road_Name" src="Field2" type="String"/>
        <Field name="From_Desc" src="Field3" type="String"/>
        <Field name="From_Dist_m" src="Field4" type="Real"/>
        <Field name="To_Desc" src="Field5" type="String"/>
        <Field name="To_Desc_m" src="Field6" type="Real"/>
        <Field name="Pavement_Length" src="Field7" type="Real"/>
        <Field name="Reserve_Width_m" src="Field8" type="Real"/>
        <Field name="L_Fpath_Code_Type" src="Field13" type="String"/>
        <Field name="L_Fpath_Width_m" src="Field14" type="Real"/>
        <Field name="L_Fpath_Cond_0_10" src="Field16" type="Real"/>
        <Field name="L_Fpath_Const_M_Y" src="Field19" type="Date"/>
        <Field name="R_Fpath_Code_Type" src="Field27" type="String"/>
        <Field name="R_Fpath_Width_m" src="Field28" type="Real"/>
        <Field name="R_Fpath_Cond_0_10" src="Field30" type="Real"/>
        <Field name="R_Fpath_Const_M_Y" src="Field33" type="Date"/>
        <Field name="Date_Fpath_Insp" src="Field41" type="Date"/>
        <Field name="Fpath_Comments" src="Field42" type="String"/>
        <Field name="Fpath_Nxt_Trtmnt_Cde_Typ" src="Field43" type="String"/>
        <Field name="L_KC_Code_Type" src="Field46" type="String"/>
        <Field name="L_KC_Cond_0_10" src="Field48" type="Real"/>
        <Field name="L_KC_Const_M_Y" src="Field51" type="Date"/>
        <Field name="R_KC_Code_Type" src="Field58" type="String"/>
        <Field name="R_KC_Cond_0_10" src="Field60" type="Real"/>
        <Field name="R_KC_Const_M_Y" src="Field63" type="Date"/>
        <Field name="Date_KC_Insp" src="Field70" type="Date"/>
        <Field name="KC_Comments" src="Field71" type="String"/>
        <Field name="KC_Nxt_Trtmnt_Cde_Typ" src="Field72" type="String"/>
        <Field name="Formn_Code_Type" src="Field120" type="String"/>
        <Field name="Formn_Width_m" src="Field121" type="Real"/>
        <Field name="Formn_Area_sqm" src="Field131" type="Real"/>
        <Field name="Date_Formn_Insp" src="Field132" type="Date"/>
        <Field name="Formn_Comments" src="Field133" type="String"/>
        <Field name="Pavt_Code_Type" src="Field137" type="String"/>
        <Field name="Pavt_Width_m" src="Field138" type="Real"/>
        <Field name="Pavt_Cond_0_10" src="Field141" type="Real"/>
        <Field name="Pavt_Area_sqm" src="Field154" type="Real"/>
        <Field name="Date_Pavt_Insp" src="Field165" type="Date"/>
        <Field name="Pavt_Comments" src="Field166" type="String"/>
        <Field name="Pavt_Nxt_Trtmnt_Cde_Type" src="Field167" type="String"/>
        <Field name="Pavt_Nxt_Trtmnt_Width" src="Field168" type="String"/>
        <Field name="Seal_Weight_Cond_0_10" src="Field177" type="Real"/>
        <Field name="Seal_Area" src="Field191" type="Real"/>
        <Field name="Seal_Last_Trtmnt_Code" src="Field192" type="String"/>
        <Field name="Seal_Last_Trtmnt_Date_M_Y" src="Field193" type="String"/>
        <Field name="Seal_Prop_Trtmnt_Code" src="Field194" type="String"/>
        <Field name="Seal_Prop_Trtmnt_Date_M_Y" src="Field195" type="Date"/>
        <Field name="Seal_Date_Insp" src="Field198" type="Date"/>
        <Field name="Seal_Comments" src="Field199" type="String"/>
        <Field name="General_Comments" src="Field200" type="String"/>
        <Field name="Rural_or_Town" src="Field203" type="String"/>
        <Field name="Sealed_or_Unsealed" src="Field204" type="String"/>
        <Field name="Township" src="Field206" type="String"/>
        <Field name="Road_Status_1" src="Field207" type="String"/>
        <Field name="Traf_Cnt_ADT" src="Field208" type="Real"/>
        <Field name="Traf_Cnt_Perc_Hvy_Veh" src="Field209" type="Real"/>
        <Field name="Location_Year" src="Field210" type="String"/>
        <Field name="Road_Hierarchy" src="Field211" type="String"/>
        <Field name="Road_Status_User_Defined" src="Field212" type="String"/>
        <Field name="Road_Hierarchy_2" src="Field213" type="String"/>
        <Field name="Strategic_or_Bus_Route" src="Field214" type="String"/>
        <Field name="Map_Ref" src="Field216" type="String"/>
        <Field name="Map_Grid_1" src="Field217" type="String"/>
        <Field name="Map_Grid_2" src="Field218" type="String"/>
        <Field name="Public_Road" src="Field225" type="String"/>
        <Field name="Date_Proclaimed_Public" src="Field226" type="Date"/>
        <Field name="Road_Register_Class" src="Field228" type="String"/>
        <Field name="Ref_To_Boundaries" src="Field229" type="String"/>
        <Field name="Ref_To_Agreements" src="Field231" type="String"/>
        <Field name="Infr_On_Public_Roads" src="Field234" type="String"/>
        <Field name="LSC_RRA" src="Field237" type="String"/>
        <Field name="Other_CRA" src="Field238" type="String"/>
        <Field name="Notes" src="Field239" type="String"/>
    </OGRVRTLayer>
</OGRVRTDataSource>

QGIS Configuration

Add the VRT file as a vector dataset to your QGIS project and configure the layer as follows:

Layer Properties > QGIS Server > Keyword list

parent=Roads, parameter=EXP_FILTER=Seg_ID in ('[SegmentID]')

…where Roads is the name of your spatial layer and SegmentID is the name of the road segment id field in the roads layer.

Remember to enable the layer for WFS in the project properties.

Last updated on 29 Sep 2025

MAGIQ Nearmap