Monitoring land availablity in Christchurch City.

Role: Research Analyst
Monitoring & Research Unit
Christchurch City Council

Monitoring Report:

The Resource Management Act (RMA) requires council to monitor the performance of the City Plan. This had been performed up until the September 2010 earthquakes, from 2001 to 2009.

My first task at Council in 2012 was to re-run the old processes, which largely turned out to be irredeemably broken as the source data had changed so much in the intervening years.

I took responsibility for redeveloping the spatial analytics using data warehousing techniques to extract transform and load information from the source transactional databases through to a snowflake schema in a monitoring data mart. Reports are produced for the intranet and can be exported from a web browser to pdf, excel, etc.

The annual indicators are now available from 2010 onwards. The vacant land register informs Orion’s capital planning.

New quarterly reports were developed for the CCC_MBIE housing accord, the Central City Recovery Report, and Residential Greenfields report. They were amalgamated into one report to meet the requirements of the proposed National Policy Statement under the RMA.

  • Rewrote outdated MapInfo scripts using MS SQL Server Management Studio
  • Designed SQL Server database containing tables, indexed views (for backwards compatability with Mapinfo), diagrams, functions, triggers, stored procedures
  • Developed spatial reports in SQL Server Report Builder 3.0

Responsibilities:

  • Identify changes in the land supply by analyzing building construction and zoning rules.
  • Develop data models and dashboards.
  • Provide quarterly and annual reports and indicator sheets: vacant land register, CCC-MBIE housing accord, Central City Recovery, Greenfield land capacity.

Technology:

  • Mapinfo, Geomedia, Google Earth
  • Microsoft SQL Server database engine (MS SQL), Report Server (SSRS).

Outcomes:

  • Design and development of a spatial data mart for built environment monitoring, to support reporting in SSRS and data cleansing in MapInfo, Geomedia, and ArcGIS.
  • Vacant Land analysis supplied to Power Network companies to plan for resential and industrial growth.

2013

Updated: