Hi Robin, first you need to do a bit of SQL to get the counts of crime types
POSTCODETABLE = Postcode boundary table name CRIMETYPETABLE = Crime type table name Select POSTCODETABLE.POSTCODE, CRIMETYPETABLE.CRIMETYPE, Count(*) >From POSTCODETABLE, CRIMETYPETABLE Group by 1,2 Order by 1,2 You can then use this table to do your thematic maps. HTH Regards martin ----- Original Message ----- From: "Burchfield, Robin 10088" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, February 12, 2004 11:12 AM Subject: MI-L SQL Help > Hi listers > > I have two MI tables, one contains postcode (Zipcode) boundaries and the > other contains points that are attributed with a crime type e.g. 'C1', 'C2', > 'C3' etc. > > What I require is a query that can count the number of each crime type that > fall within each postcode boundary so that I can then thematically map > these. > > Does anyone have any ideas for this? > > Thanks in advance. > > Robin Burchfield > Mapping & Data Officer > Surrey Police > Mount Browne, Sandy Lane, > Guildford, Surrey, GU3 1HG > Tel: 01483 482357 > Fax: 01483 482374 > E-mail: [EMAIL PROTECTED] > > > > Internet communications are not secure and therefore Surrey Police does not > accept legal responsibility for the contents of this message. This email > and any attachments may be confidential. They may contain privileged > information and are intended for the named addressee (s) only. They must not > be distributed without our consent. If you are not the intended recipient, > please notify us immediately and delete the message and any attachments from > your computer, do not disclose, distribute, or retain this email or any part > of it. Unless expressly stated, opinions in this email are those of the > individual sender, and not of Surrey Police. We believe but do not warrant > that this e-mail and any attachments are virus free. You must therefore take > full responsibility for virus checking. Surrey Police reserves the right to > monitor all email communications through their networks. > > > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10394
