Summary of Main Content

 

Uploading Spatial Data to SQL Server

• Utilizing GDAL for importing shapefiles and CSVs.

• Commands for uploading and managing spatial data.

​

Data Preparation and Adjustments

• Altering table columns and data types.

• Setting up primary keys and constraints.

• Removing and creating spatial indexes.

​

Data Integration and Comparison

• Joining and merging datasets from different years (2018, 2023).

• Comparing meshblock areas and handling null values.

 

Spatial Analysis and Processing

• Eliminating slivers in geometries.

• Clipping geometries within specific boundaries (e.g., Auckland DHB).

• Aggregating and dissolving geometries by codes (e.g., SA2 2023).

 

Documentation and Metadata

• Adding extended properties to spatial tables for documentation.

• Storing information about data sources, owners, and usage notes.