topic Help creating a map of organisations distrcits by postcode in New to GIS Questions

Help creating a map of organisations distrcits by postcode

SamOLeary — Mon, 03 Jul 2023 05:44:36 GMT

Hi everyone,

I am trying to create a map of my organisations 'districts' in Australia.

Basically, we have the country split into about 50 districts, with certain postal areas in each district, e.g. 'North Sydney' is a disctrict comprising about 30 postcal codes / suburbs.

I want to map these districts, and have created a spreadsheet with each district name and associated postcodes.

I can't for the life of me figure out how to use this simple data: District name, postcodes, to create a map / maps of our districts.

I have played around with importing a base layer of Australian postcodes, but everytime I try import the data from excel I'm not sure what options to choose to create what I want.

I thought a map like this would be simple but a few hours later and it's driving me insane! Any help is much appreciated,

Sam

Re: Help creating a map of organisations distrcits by postcode

DanPatterson — Mon, 03 Jul 2023 07:48:01 GMT

use Join Field (Data Management)—ArcGIS Pro | Documentation

Add your spreadsheet (using Excel To Table (Conversion)—ArcGIS Pro | Documentation )

join the resultant table to the featureclass of postcodes using the postcodes fields from both datasets.

You can then use the district field for mapping

Re: Help creating a map of organisations distrcits by postcode

SamOLeary — Mon, 03 Jul 2023 23:13:13 GMT

Thanks Dan!

Re: Help creating a map of organisations distrcits by postcode

DanPatterson — Tue, 04 Jul 2023 01:05:12 GMT

No problem