Excluding PolygonZ and M in shape file using ArcGIS

To do this using tools available in ArcMap follow these steps. 

Locate the following tool - 
ArcToolbox > Conversion Tools > To Shapefile > Feature Class To Shapefile (multiple) 

Launch the tool and add your Polygon ZM shapefiles to the input features. 

Select an 'Output Folder' 

Click on the 'Environments...' button at the bottom of the dialog box. To the right of the 'OK' button. 

Click on the 'General Settings' text. 

You should see two fields marked 'Output has Z Values' and 'Output has M Values'. 

Set both fields to 'Disabled'. 

Click 'OK' to exit the Environments Settings then click 'OK' to run the tools. 

You should now have copies of your original shapefiles, without Z & M values in your new folder. 

Courtesy
http://forums.esri.com/Thread.asp?c=93&f=1730&t=296920

Geocoding Postal code

http://www.gpsvisualizer.com/geocoder/

Allows to geocode 5 postal code at a time.


Another link where all Canadian postal codes with Longitude Latitude included in single .gz file

http://geocoder.ca/?freedata=1

Using Table variables in SSIS Package

Issue:

When declaring and using T-SQL table variables in SSIS pacakge results in zero rows results.

Solution:
In the query under OLEDB source before actual query execution use "SET NOCOUNT ON".

Aggregating Spatial Data

Spatial table data can be aggregate such as to get a high level map.  This code works for tables in SQL 2012.

SELECT    [Column Name]    ,geometry::UnionAggregate(geom.MakeValid()) AS goem
FROM             
GROUP BY [Column Name]