Vicmap Reference Table: Column Name Mapping for Shapefiles

The MD_COLUMN_NAME_MAPPING table maps Victorian Spatial Data Library object column names longer than 10 characters to shorter names. This mapping supports the generation and importing of shapefiles, which have a 10-character column name limit. The Department of Transport and Planning maintains this reference table, last updated on 2026-04-09.

Use Cases

• Automate column name truncation for shapefile export based on the described mapping logic.
• Ensure data integrity when importing VSDL data into GIS software that uses shapefiles.
• Resolve column name conflicts in legacy systems that require short field names.
• Create custom mapping rules for specific tables, as mentioned for instances where mapping is explicitly applied.

Strengths

• Provides a unique mapping of column names, as explicitly stated in the description.
• Includes a default mapping rule (TABLE_OWNER and TABLE_NAME equal to '_DEFAULT') for broad application.
• Supports multiple file formats including SHP, GDB, TAB, MIF, and EXTENDED TAB.

Limitations

• Column-level documentation is absent; field semantics must be inferred after download.
• Row count is unknown, which may limit suitability assessment.
• Description metadata is limited; actual data quality requires manual inspection after download.

Provenance

Source

Department of Transport and Planning

Freshness

Last updated 2026-04-09 04:15:46.689494; freshness should be verified.

Geography

Victoria, Australia