[Year 12 SofDev] sofdev Digest, Vol 73, Issue 4 Post Codes
Robert Hind
robert at yinnar.com
Wed Apr 6 15:42:12 EST 2011
Thanks for that info Russell.
Have downloaded the file.
Actually the downloaded file is in .csv format, after extraction of the .zip
file, and does contain the leading zeros for NT postcodes. It is only when
you open the file in Excel that Excel assumes that postcodes are numbers and
so strips those leading zeros.
In fact you do need the leading zeros in the postcodes which means that they
have to be treated as text/character strings and not numbers, as previously
pointed out by Andrew S.
Robert Hind (Semi-retired) OOF, GOM
Ashwood and Traralgon
robert at yinnar.com
----- Original Message -----
From: "Russell Quinn" <QN at boxhillhs.vic.edu.au>
To: <sofdev at edulists.com.au>
Sent: Wednesday, April 06, 2011 3:09 PM
Subject: Re: [Year 12 SofDev] sofdev Digest, Vol 73, Issue 4 Post Codes
> Regarding post codes,
> You can pick up post codes from the postal service on the web at
>
> http://auspost.com.au/products-and-services/download-postcode-data.html
>
> It gives an excel file, which can be dumped as an ascii file and massaged
> into
> the required format. I used it a few years ago with a SAC. It illustrates
> the point
> that some post codes have 3 digits (leading zero stripped) whilst others
> have 4 -
> which becomes very obvious with the sorted file. I used them as implicit
> validation
> with the P/C component of an address - in a combo box, no typing required.
> Also it
> illustrates how business import basic data sets from external entities -
> for free. Your
> taxes at work!
>
> Regards,
>
> Russell Quinn
> ________________________________________
> From: sofdev-bounces at edulists.com.au [sofdev-bounces at edulists.com.au] On
> Behalf Of sofdev-request at edulists.com.au [sofdev-request at edulists.com.au]
> Sent: Wednesday, 6 April 2011 2:14 PM
> To: sofdev at edulists.com.au
> Subject: sofdev Digest, Vol 73, Issue 4
>
> Send sofdev mailing list submissions to
> sofdev at edulists.com.au
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://www.edulists.com.au/mailman/listinfo/sofdev
> or, via email, send a message with subject or body 'help' to
> sofdev-request at edulists.com.au
>
> You can reach the person managing the list at
> sofdev-owner at edulists.com.au
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of sofdev digest..."
>
>
> Today's Topics:
>
> 1. Places available! Swinburne's Cool Grads seminar - 28 April
> 2011 (Bianca van Meeuwen)
> 2. Re: Data dictionary - data formats (Andrew Shortell)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 6 Apr 2011 12:28:02 +1000
> From: "Bianca van Meeuwen" <BVANMEEUWEN at groupwise.swin.edu.au>
> Subject: [Year 12 SofDev] Places available! Swinburne's Cool Grads
> seminar - 28 April 2011
> To: "itapps at edulists.com.au " <itapps at edulists.com.au>,
> "sofdev at edulists.com.au " <sofdev at edulists.com.au>,
> "yr11it at edulists.com.au " <yr11it at edulists.com.au>
> Message-ID: <4D9C5C52.3E4F.00CB.1 at groupwise.swin.edu.au>
> Content-Type: text/plain; charset="utf-8"
>
> We still have places available - register now!
>
> Swinburne University Faculty of Information and Communication
> Technologies - 'Cool Grads' Seminar
>
> Have you ever wondered where ICT can take you?
>
> Join us for an afternoon session with Swinburne Graduates who will tell
> you about their 'cool' careers in ICT. From Games and animation through to
> eForensics. Expand your horizon and learn more about exciting careers in
> ICT.
>
> This session will include a series of presentations where students will
> hear from and have the opportunity to talk to role models with ICT
> careers. Swinburne ICT graduates will share what their role involves, what
> made them choose ICT and the amazing opportunities ICT offers them.
>
> The afternoon will also include an activity where students will learn more
> about how they can make a difference in today's world by using technology.
>
>
>
> Date: 28 April 2011
>
> Time: 1.30pm - 3.30pm
>
> Location: Swinburne's Hawthorn campus
>
>
>
> To register, please complete the online form by Friday 22 April:
> http://www.swinburne.edu.au/ict/events/cool-grads/
> (limited number of spaces available)
>
> We look forward to seeing you on 28 April!
>
>
>
>
> Bianca van Meeuwen
> ICT Outreach Officer
> Faculty of Information and Communication Technologies
> Swinburne University of Technology
> PO Box 218 John Street
> Hawthorn 3122
>
> bvanmeeuwen at swin.edu.au
> p: 9214 8768
> f: 9819 0823
> m: 0416 931 105
>
> Supporting Schools
> www.swinburne.edu.au/ict/schools
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://www.edulists.com.au/pipermail/sofdev/attachments/20110406/477a4b72/attachment-0001.html
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: not available
> Type: image/png
> Size: 1777 bytes
> Desc: not available
> Url :
> http://www.edulists.com.au/pipermail/sofdev/attachments/20110406/477a4b72/attachment-0004.png
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: not available
> Type: image/png
> Size: 2129 bytes
> Desc: not available
> Url :
> http://www.edulists.com.au/pipermail/sofdev/attachments/20110406/477a4b72/attachment-0005.png
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: not available
> Type: image/png
> Size: 2247 bytes
> Desc: not available
> Url :
> http://www.edulists.com.au/pipermail/sofdev/attachments/20110406/477a4b72/attachment-0006.png
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: not available
> Type: image/png
> Size: 3860 bytes
> Desc: not available
> Url :
> http://www.edulists.com.au/pipermail/sofdev/attachments/20110406/477a4b72/attachment-0007.png
>
> ------------------------------
>
> Message: 2
> Date: Wed, 06 Apr 2011 14:14:17 +1000
> From: Andrew Shortell <shortell at get2me.net>
> Subject: Re: [Year 12 SofDev] Data dictionary - data formats
> To: "Year 12 Software Development Teachers' Mailing List"
> <sofdev at edulists.com.au>
> Message-ID: <C9C225B9.3F53%shortell at get2me.net>
> Content-Type: text/plain; charset="US-ASCII"
>
> Hi Gordon
> Just by the way - northern territory postcodes start with a zero .. Thus
> cannot store postcode as number
>
> Andrew
>
> Andrew Shortell
>
> mailto:shortell at get2me.net
> Heidelberg Teaching Unit
> Ph 9470 3403
> Fax 9470 3215
>
>
> On 6/04/11 10:22 AM, "Poultney, Gordon A"
> <Poultney.Gordon.A at edumail.vic.gov.au> wrote:
>
>>
>> hi Heath et al,
>>
>> How about a table something like this for a dd?
>>
>> name
>>
>> type
>>
>> purpose
>>
>> acceptable values
>>
>> default value
>>
>> other
>>
>> postcode
>>
>> integer
>>
>> Customer postcode for use in addressing
>>
>> 4 digit
>>
>> 1000-9999
>>
>> 3400
>>
>> can not be blank
>>
>>
>> You may wish to store postcode as string instead. Under 'purpose' you may
>> relate to (DFD) processes where it is used.
>>
>> cheers
>> Gordon
>>
>> ----------------
>> Gordon Poultney
>> Horsham College
>>
>> ________________________________
>>
>> From: sofdev-bounces at edulists.com.au on behalf of Matheson, Heath A
>> Sent: Tue 5/4/11 17:32
>> To: Year 12 Software Development Teachers' Mailing List
>> Subject: [Year 12 SofDev] Data dictionary - data formats
>>
>>
>>
>> Heya All,
>>
>>
>>
>> In the outcome 2 detailed example in the study design, "students will
>> design a
>> data dictionary that shows the required data items, a description of
>> their
>> purpose, their format, their size and their data type".
>>
>>
>>
>> What goes in the format field? Is it the data structure? Is it a range or
>> acceptable values?
>>
>>
>>
>> I'm just not quite sure.
>>
>>
>>
>> Have a safe and happy holidays, hope you get lots of eggs and easter
>> buns!
>>
>>
>>
>> Heath Matheson
>>
>> Mt Beauty
>>
>> Important - This email and any attachments may be confidential. If
>> received in
>> error, please contact us and delete all copies. Before opening or using
>> attachments check them for viruses and defects. Regardless of any loss,
>> damage
>> or consequence, whether caused by the negligence of the sender or not,
>> resulting directly or indirectly from the use of any attached files our
>> liability is limited to resupplying any affected attachments. Any
>> representations or opinions expressed are those of the individual sender,
>> and
>> not necessarily those of the Department of Education and Early Childhood
>> Development.
>>
>>
>> Important - This email and any attachments may be confidential. If
>> received in
>> error, please contact us and delete all copies. Before opening or using
>> attachments check them for viruses and defects. Regardless of any loss,
>> damage
>> or consequence, whether caused by the negligence of the sender or not,
>> resulting directly or indirectly from the use of any attached files our
>> liability is limited to resupplying any affected attachments. Any
>> representations or opinions expressed are those of the individual sender,
>> and
>> not necessarily those of the Department of Education and Early Childhood
>> Development.
>> _______________________________________________
>> http://www.edulists.com.au - FAQ, Subscribe, Unsubscribe
>> IT Software Development Mailing List kindly supported by
>> http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment
>> Authority and
>> http://www.vcaa.vic.edu.au/vce/studies/infotech/softwaredevel3-4.html
>> http://www.vitta.org.au - VITTA Victorian Information Technology
>> Teachers
>> Association Inc
>
> --
> --
>
>
>
>
>
> ------------------------------
>
> _______________________________________________
> sofdev mailing list
> sofdev at edulists.com.au
> http://www.edulists.com.au/mailman/listinfo/sofdev
>
>
> End of sofdev Digest, Vol 73, Issue 4
> *************************************
>
> _______________________________________________
> http://www.edulists.com.au - FAQ, Subscribe, Unsubscribe
> IT Software Development Mailing List kindly supported by
> http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority
> and
> http://www.vcaa.vic.edu.au/vce/studies/infotech/softwaredevel3-4.html
> http://www.vitta.org.au - VITTA Victorian Information Technology Teachers
> Association Inc
>
More information about the sofdev
mailing list