public static void CheckFiles(string shapeFileName)
        {
            try
            {
                MapBindTrace.Source.TraceInformation("Checking shape files");
                if (!File.Exists(shapeFileName))
                {
                    throw new ArgumentException("File " + shapeFileName + " not found!");
                }

                string dbfFilePath = ShapeFileHelper.GetdBaseFile(shapeFileName);
                if (!File.Exists(dbfFilePath))
                {
                    throw new ArgumentException("File " + dbfFilePath + " not found!");
                }

                string prjFilePath = ShapeFileHelper.GetProjectFile(shapeFileName);
                if (!File.Exists(prjFilePath))
                {
                    throw new ArgumentException("File " + prjFilePath + " not found!");
                }
            }
            catch (Exception ex)
            {
                MapBindTrace.Source.TraceEvent(TraceEventType.Error, 1, "CheckFiles: " + ex.Message);
                throw;
            }
        }
示例#2
0
        private void Init()
        {
            MapBindTrace.Source.TraceInformation("Trace started");

            // Check files
            ShapeFileHelper.CheckFiles(_shapeFile);

            // REVERSE
            SqlServerHelper.REVERSE_GEOMETRIES = null;

            // construct Sql table name
            _tableName = SqlServerModel.CleanSQLName(Path.GetFileNameWithoutExtension(_shapeFile));

            // Init reader
            using (ShapefileDataReader reader = new ShapefileDataReader(_shapeFile, GeometryFactory.Default))
            {
                // Get Shape info
                _bounds      = reader.ShapeHeader.Bounds;
                _shapeType   = reader.ShapeHeader.ShapeType;
                _recordCount = reader.RecordCount;

                _fields = new Dictionary <string, Type>();
                foreach (var field in reader.DbaseHeader.Fields)
                {
                    _fields.Add(field.Name, field.Type);
                }

                _idField   = SqlServerModel.GenerateUniqueColName("ID", ShapeFileHelper.TranslateDbfTypesToSql(reader.DbaseHeader.Fields), _tableName);
                _geomField = SqlServerModel.GenerateUniqueColName("geom", ShapeFileHelper.TranslateDbfTypesToSql(reader.DbaseHeader.Fields), _tableName);
            }
        }
        public static MultiPoint transformMultiPoint(ICoordinateTransformation trans, MultiPoint multiPoint)
        {
            if (trans == null)
            {
                return(multiPoint);
            }

            Coordinate[] coords = ShapeFileHelper.transformCoordinates(trans, multiPoint.Coordinates);


            return(new MultiPoint(coords.Select(c => new Point(c)).ToArray()));
        }
        public object GetValue(int i)
        {
            object v_ret = null;

            if (i >= _shapeFileDataReader.FieldCount)
            {
                try
                {
                    // Get shape and reproject if necessary
                    IGeometry geom = _shapeFileDataReader.Geometry;
                    if (_coordTransform != null)
                    {
                        geom = ShapeFileHelper.ReprojectGeometry(_shapeFileDataReader.Geometry, _coordTransform);
                    }


                    // Convert to sqltype
                    if (_spatialType == enSpatialType.both)
                    {
                        v_ret = SqlServerHelper.ConvertToSqlType(geom, _srid, i == _shapeFileDataReader.FieldCount + 1, _curRowIndex);
                    }
                    else
                    {
                        v_ret = SqlServerHelper.ConvertToSqlType(geom, _srid, _spatialType == enSpatialType.geography, _curRowIndex);
                    }
                }
                catch (Exception ex)
                {
                    if (_errorHandler != null)
                    {
                        var args = new ShapeImportExceptionEventArgs(ex, false, this.DumpCurrentRecord(), this.Geometry, _curRowIndex);
                        _errorHandler(this, args);
                        if (args.Ignore)
                        {
                            v_ret = null;
                        }
                    }
                    else
                    {
                        throw;
                    }
                }
            }
            else
            {
                //Type fieldType = _shapeFileDataReader.GetFieldType(i);
                v_ret = _shapeFileDataReader.GetValue(i);
            }

            return(v_ret);
        }
        public static Polygon transformPolygon(ICoordinateTransformation trans, Polygon polygon)
        {
            if (trans == null)
            {
                return(polygon);
            }

            Coordinate[] extRing = ShapeFileHelper.transformCoordinates(trans, polygon.ExteriorRing.Coordinates);

            List <LinearRing> holes = new List <LinearRing>();

            foreach (var hole in polygon.Holes)
            {
                Coordinate[] holeCoords = ShapeFileHelper.transformCoordinates(trans, hole.Coordinates);
                holes.Add(new LinearRing(holeCoords));
            }

            return(new Polygon(new LinearRing(extRing), holes.ToArray()));
        }
        public static Envelope ReprojectEnvelope(ICoordinateTransformation trans, Envelope envelope)
        {
            Envelope ret;

            try
            {
                if (trans == null)
                {
                    ret = envelope;
                }
                else
                {
                    Coordinate   nwCoord   = new Coordinate(envelope.MinX, envelope.MaxY);
                    Coordinate   seCoord   = new Coordinate(envelope.MaxX, envelope.MinY);
                    Coordinate[] retCoords = ShapeFileHelper.transformCoordinates(trans, new Coordinate[] { nwCoord, seCoord });
                    ret = new Envelope(retCoords[0], retCoords[1]);
                }
            }
            catch (Exception)
            {
                throw;
            }
            return(ret);
        }
示例#7
0
        public void ImportShapeFile_Direct(string connectionString,
                                           string targetCoordSystem,
                                           bool recreateTable,
                                           enSpatialType spatialType,
                                           int SRID,
                                           string tableName,
                                           string schema,
                                           string IdColName,
                                           string geomcolName,
                                           List <string> fieldsToImport)
        {
            _worker = new BackgroundWorker();
            _worker.WorkerSupportsCancellation = true;
            _worker.WorkerReportsProgress      = true;
            _worker.RunWorkerCompleted        += new RunWorkerCompletedEventHandler(_worker_RunWorkerCompleted);
            _worker.ProgressChanged           += new ProgressChangedEventHandler(_worker_ProgressChanged);
            _worker.DoWork += new DoWorkEventHandler(delegate(object sender, DoWorkEventArgs e)
            {
                try
                {
                    #region Work
                    TraceSource traceSource = new TraceSource("MapBind.IO");
                    int recordIndex         = 1;
                    MapBindTrace.Source.TraceEvent(TraceEventType.Information, 1, "Worker started");
                    _worker.ReportProgress(0, "Starting...");

                    #region Init ICoordinateTransformation
                    _transform = null;
                    if (!string.IsNullOrWhiteSpace(targetCoordSystem))
                    {
                        //string v_targetCoordSys =  "GEOGCS[\"WGS 84\",DATUM[\"WGS_1984\",SPHEROID[\"WGS 84\",6378137,298.257223563,AUTHORITY[\"EPSG\",\"7030\"]],AUTHORITY[\"EPSG\",\"6326\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4326\"]]";

                        ICoordinateSystem csSource = ProjNet.Converters.WellKnownText.CoordinateSystemWktReader.Parse(this.CoordinateSystem) as ICoordinateSystem;
                        ICoordinateSystem csTarget = ProjNet.Converters.WellKnownText.CoordinateSystemWktReader.Parse(targetCoordSystem) as ICoordinateSystem;

                        _transform = new CoordinateTransformationFactory().CreateFromCoordinateSystems(csSource, csTarget);
                    }
                    #endregion Init ICoordinateTransformation


                    using (SqlConnection db = new SqlConnection(connectionString))
                    {
                        db.Open();
                        SqlTransaction transaction = db.BeginTransaction(IsolationLevel.Serializable);

                        using (SqlBulkCopy bulk = new SqlBulkCopy(db, SqlBulkCopyOptions.Default, transaction))
                        {
                            using (ShapeFileReaderBulk shapeDataReader = new ShapeFileReaderBulk(_shapeFile, _transform, spatialType, SRID, Internal_RaiseError))
                            {
                                try
                                {
                                    bulk.DestinationTableName = SqlServerModel.GenerateFullTableName(tableName, schema);
                                    bulk.BulkCopyTimeout      = 0;
                                    bulk.NotifyAfter          = 1;
                                    bulk.SqlRowsCopied       += (o, args) =>
                                    {
                                        recordIndex++;

                                        if (_worker.CancellationPending)
                                        {
                                            args.Abort = true;
                                        }
                                        else
                                        {
                                            _worker.ReportProgress((int)((args.RowsCopied * 100f) / this.RecordCount), string.Format("Writing {0} records", args.RowsCopied));
                                        }
                                    };

                                    MapBindTrace.Source.TraceEvent(TraceEventType.Information, 1, string.Format("Writing {0} records", 0));
                                    _worker.ReportProgress(0, string.Format("Writing {0} records", 0));

                                    #region Column mappings
                                    List <DbaseFieldDescriptor> fieldsList = new List <DbaseFieldDescriptor>();
                                    int idxSource = 0;
                                    int idxDest   = 1;
                                    foreach (DbaseFieldDescriptor desc in shapeDataReader.DbaseHeader.Fields)
                                    {
                                        if (fieldsToImport.Contains(desc.Name))
                                        {
                                            bulk.ColumnMappings.Add(desc.Name, SqlServerModel.CleanSQLName(desc.Name));
                                            fieldsList.Add(desc);
                                            idxDest++;
                                        }
                                        idxSource++;
                                    }
                                    switch (spatialType)
                                    {
                                    case enSpatialType.geometry:
                                    case enSpatialType.geography:
                                        bulk.ColumnMappings.Add("geom", geomcolName);
                                        break;

                                    case enSpatialType.both:
                                        bulk.ColumnMappings.Add("geom_geom", geomcolName + "_geom");
                                        bulk.ColumnMappings.Add("geom_geog", geomcolName + "_geog");
                                        break;
                                    }
                                    #endregion Column mappings

                                    #region create table
                                    List <SqlColumnDescriptor> sqlFields = ShapeFileHelper.TranslateDbfTypesToSql(fieldsList.ToArray());

                                    MapBindTrace.Source.TraceEvent(TraceEventType.Information, 1, "Creating table " + tableName);
                                    string sqlScriptCreateTable = SqlServerModel.GenerateCreateTableScript(tableName, schema, sqlFields, spatialType, recreateTable, geomcolName, IdColName);
                                    DataTable dataTable         = SqlServerModel.GenerateDataTable(tableName, sqlFields, spatialType, recreateTable, geomcolName, IdColName);
                                    new SqlCommand(sqlScriptCreateTable, db, transaction).ExecuteNonQuery();
                                    #endregion

                                    bool bulkInError = false;
                                    try
                                    {
                                        bulk.WriteToServer(shapeDataReader);
                                    }
                                    catch (OperationAbortedException)
                                    {
                                        bulkInError = true;
                                        MapBindTrace.Source.TraceEvent(TraceEventType.Error, 1, "SqlBulkImport throw OperationAbortedException");
                                    }
                                    catch (Exception exBulk)
                                    {
                                        MapBindTrace.Source.TraceEvent(TraceEventType.Error, 1, "SqlBulkImport throw Exception" + exBulk.Message);
                                        this.Raise_Error(new ShapeImportExceptionEventArgs(exBulk, true, shapeDataReader.DumpCurrentRecord(), shapeDataReader.Geometry, recordIndex));
                                        bulkInError = true;
                                    }

                                    bulk.Close();

                                    if (_worker.CancellationPending || bulkInError)
                                    {
                                        MapBindTrace.Source.TraceEvent(TraceEventType.Warning, 1, "Rolling back transaction");
                                        transaction.Rollback();
                                    }
                                    else
                                    {
                                        #region Create spatial index

                                        MapBindTrace.Source.TraceEvent(TraceEventType.Information, 1, "Creating spatial index...");
                                        _worker.ReportProgress(100, "Creating index...");

                                        // Create spatial index
                                        Envelope bounds                  = ShapeFileHelper.ReprojectEnvelope(_transform, this.Bounds);
                                        string sqlScriptCreateIndex      = SqlServerModel.GenerateCreateSpatialIndexScript(tableName, schema, geomcolName, SqlServerHelper.GetBoundingBox(bounds), spatialType, enSpatialIndexGridDensity.MEDIUM);
                                        SqlCommand v_createdIndexcmd     = new SqlCommand(sqlScriptCreateIndex, db, transaction);
                                        v_createdIndexcmd.CommandTimeout = 3600;
                                        v_createdIndexcmd.ExecuteNonQuery();

                                        #endregion

                                        MapBindTrace.Source.TraceEvent(TraceEventType.Information, 1, "Commit transaction");
                                        transaction.Commit();
                                    }
                                }
                                catch (Exception ex)
                                {
                                    MapBindTrace.Source.TraceEvent(TraceEventType.Error, 1, "Error : " + ex.Message);
                                    MapBindTrace.Source.TraceEvent(TraceEventType.Warning, 1, "Rolling back transaction");
                                    transaction.Rollback();
                                    this.Raise_Error(new ShapeImportExceptionEventArgs(ex, true));
                                }
                                finally
                                {
                                    MapBindTrace.Source.TraceEvent(TraceEventType.Verbose, 1, "SqlBulkCopy.Close()");
                                    bulk.Close();
                                }
                            }
                        }

                        MapBindTrace.Source.TraceEvent(TraceEventType.Verbose, 1, "db.Close()");
                        db.Close();
                    }


                    #endregion
                }
                catch (Exception ex)
                {
                    MapBindTrace.Source.TraceEvent(TraceEventType.Error, 1, "Unhandled exception : " + ex.Message);
                    this.Raise_Error(new ShapeImportExceptionEventArgs(ex, true));
                }
            });

            Trace.CorrelationManager.StartLogicalOperation("ImportShapeFile_Direct Worker");
            _worker.RunWorkerAsync();
            Trace.CorrelationManager.StartLogicalOperation("ImportShapeFile_Direct Worker");
        }
示例#8
0
        public void ImportShapeFile(string connectionString,
                                    string targetCoordSystem,
                                    bool recreateTable,
                                    enSpatialType spatialType,
                                    int SRID,
                                    string tableName,
                                    string schema,
                                    string IdColName,
                                    string geomcolName,
                                    List <string> fieldsToImport)
        {
            _worker = new BackgroundWorker();
            _worker.WorkerSupportsCancellation = true;
            _worker.WorkerReportsProgress      = true;
            _worker.RunWorkerCompleted        += new RunWorkerCompletedEventHandler(_worker_RunWorkerCompleted);
            _worker.ProgressChanged           += new ProgressChangedEventHandler(_worker_ProgressChanged);
            _worker.DoWork += new DoWorkEventHandler(delegate(object sender, DoWorkEventArgs e)
            {
                try
                {
                    #region Work

                    MapBindTrace.Source.TraceEvent(TraceEventType.Information, 1, "Worker started");
                    _worker.ReportProgress(0, "Starting...");

                    #region Init ICoordinateTransformation
                    _transform = null;
                    if (!string.IsNullOrWhiteSpace(targetCoordSystem))
                    {
                        //string v_targetCoordSys =  "GEOGCS[\"WGS 84\",DATUM[\"WGS_1984\",SPHEROID[\"WGS 84\",6378137,298.257223563,AUTHORITY[\"EPSG\",\"7030\"]],AUTHORITY[\"EPSG\",\"6326\"]],PRIMEM[\"Greenwich\",0,AUTHORITY[\"EPSG\",\"8901\"]],UNIT[\"degree\",0.01745329251994328,AUTHORITY[\"EPSG\",\"9122\"]],AUTHORITY[\"EPSG\",\"4326\"]]";

                        ICoordinateSystem csSource = ProjNet.Converters.WellKnownText.CoordinateSystemWktReader.Parse(this.CoordinateSystem) as ICoordinateSystem;
                        ICoordinateSystem csTarget = ProjNet.Converters.WellKnownText.CoordinateSystemWktReader.Parse(targetCoordSystem) as ICoordinateSystem;

                        _transform = new CoordinateTransformationFactory().CreateFromCoordinateSystems(csSource, csTarget);
                    }
                    #endregion Init ICoordinateTransformation


                    using (ShapefileDataReader shapeDataReader = new ShapefileDataReader(_shapeFile, GeometryFactory.Default))
                    {
                        using (SqlConnection db = new SqlConnection(connectionString))
                        {
                            MapBindTrace.Source.TraceEvent(TraceEventType.Information, 1, "Opening SQL connection");
                            db.Open();

                            SqlTransaction transaction = db.BeginTransaction(IsolationLevel.Serializable);


                            try
                            {
                                #region Create destination table



                                DbaseFieldDescriptor[] fields = (from field in shapeDataReader.DbaseHeader.Fields
                                                                 where fieldsToImport.Contains(field.Name)
                                                                 select field).ToArray();
                                List <SqlColumnDescriptor> sqlFields = ShapeFileHelper.TranslateDbfTypesToSql(fields);

                                MapBindTrace.Source.TraceEvent(TraceEventType.Information, 1, "Create SQL table " + tableName);
                                string sqlScriptCreateTable = SqlServerModel.GenerateCreateTableScript(tableName, schema, sqlFields, spatialType, recreateTable, geomcolName, IdColName);
                                DataTable dataTable         = SqlServerModel.GenerateDataTable(tableName, sqlFields, spatialType, recreateTable, geomcolName, IdColName);
                                new SqlCommand(sqlScriptCreateTable, db, transaction).ExecuteNonQuery();

                                #endregion

                                #region Read shape file

                                int numRecord = 0;
                                while (shapeDataReader.Read())
                                {
                                    numRecord++;
                                    try
                                    {
                                        #region Shape feature import

                                        if (_worker.CancellationPending)
                                        {
                                            break;
                                        }

                                        IGeometry geom    = shapeDataReader.Geometry;
                                        IGeometry geomOut = null;                                         // BUGGY GeometryTransform.TransformGeometry(GeometryFactory.Default, geom, trans.MathTransform);
                                        if (_transform == null)
                                        {
                                            geomOut = geom;
                                        }
                                        else
                                        {
                                            geomOut = ShapeFileHelper.ReprojectGeometry(geom, _transform);
                                        }

                                        #region Prepare insert

                                        // Set geom SRID
                                        geomOut.SRID = SRID;

                                        List <object> SqlNativeGeomList = new List <object>();
                                        List <object> properties        = new List <object>();

                                        switch (spatialType)
                                        {
                                            #region geography
                                        case enSpatialType.geography:
                                            try
                                            {
                                                SqlNativeGeomList.Add(SqlServerHelper.ConvertToSqlType(geomOut, SRID, true, numRecord));
                                            }
                                            catch (Exception exGeomConvert)
                                            {
                                                MapBindTrace.Source.TraceData(TraceEventType.Error, 1, "Error Converting geography : ", exGeomConvert);
                                                var args = new ShapeImportExceptionEventArgs(exGeomConvert, false, shapeDataReader.DumpCurrentRecord(), shapeDataReader.Geometry, numRecord);
                                                if (this.Raise_Error(args))
                                                {
                                                    if (args.Ignore)
                                                    {
                                                        SqlNativeGeomList = new List <object>();
                                                    }
                                                    else
                                                    {
                                                        break;
                                                    }
                                                }
                                                else
                                                {
                                                    break;
                                                }
                                            }

                                            break;

                                            #endregion
                                            #region geometry
                                        case enSpatialType.geometry:
                                            try
                                            {
                                                SqlNativeGeomList.Add(SqlServerHelper.ConvertToSqlType(geomOut, SRID, false, numRecord));
                                            }
                                            catch (Exception exGeomConvert)
                                            {
                                                MapBindTrace.Source.TraceData(TraceEventType.Error, 1, "Error Converting geometry : ", exGeomConvert);
                                                var args = new ShapeImportExceptionEventArgs(exGeomConvert, false, shapeDataReader.DumpCurrentRecord(), shapeDataReader.Geometry, numRecord);
                                                if (this.Raise_Error(args))
                                                {
                                                    if (args.Ignore)
                                                    {
                                                        SqlNativeGeomList = new List <object>();
                                                    }
                                                    else
                                                    {
                                                        break;
                                                    }
                                                }
                                                else
                                                {
                                                    break;
                                                }
                                            }

                                            break;

                                            #endregion
                                            #region both
                                        case enSpatialType.both:

                                            bool geomConverted = false;
                                            try
                                            {
                                                SqlNativeGeomList.Add(SqlServerHelper.ConvertToSqlType(geomOut, SRID, false, numRecord));
                                                geomConverted = true;
                                                SqlNativeGeomList.Add(SqlServerHelper.ConvertToSqlType(geomOut, SRID, true, numRecord));
                                            }
                                            catch (Exception exGeomConvert)
                                            {
                                                MapBindTrace.Source.TraceData(TraceEventType.Error, 1, "Error Converting geometry or geography : ", exGeomConvert);
                                                var args = new ShapeImportExceptionEventArgs(exGeomConvert, false, shapeDataReader.DumpCurrentRecord(), shapeDataReader.Geometry, numRecord);
                                                if (this.Raise_Error(args))
                                                {
                                                    if (args.Ignore)
                                                    {
                                                        if (geomConverted)
                                                        {
                                                            SqlNativeGeomList.Add(null);
                                                        }
                                                        else
                                                        {
                                                            SqlNativeGeomList.AddRange(new object[] { null, null });
                                                        }
                                                    }
                                                    else
                                                    {
                                                        break;
                                                    }
                                                }
                                                else
                                                {
                                                    break;
                                                }
                                            }

                                            break;
                                            #endregion
                                        }


                                        // Get Attributes
                                        for (int i = 0; i < fields.Length; i++)
                                        {
                                            properties.Add(shapeDataReader[fields[i].Name]);
                                        }


                                        // Fill in-memory datatable
                                        DataRow row = SqlServerModel.GetNewDataTableRow(dataTable, tableName, SqlNativeGeomList, properties);
                                        dataTable.Rows.Add(row);

                                        #endregion

                                        //if (numRecord % 10 == 0)
                                        _worker.ReportProgress((int)((numRecord * 100f) / this.RecordCount), string.Format("Reading {0} records", numRecord));

                                        #endregion
                                    }
                                    catch (Exception exGeom)
                                    {
                                        MapBindTrace.Source.TraceData(TraceEventType.Error, 1, "Error Converting geometry : ", exGeom);
                                        this.Raise_Error(new ShapeImportExceptionEventArgs(exGeom, true, shapeDataReader.DumpCurrentRecord(), shapeDataReader.Geometry, numRecord));
                                    }
                                }

                                #endregion Read shape file

                                #region Bulk insert

                                if (!_worker.CancellationPending)
                                {
                                    using (SqlBulkCopy bulk = new SqlBulkCopy(db, SqlBulkCopyOptions.Default, transaction))
                                    {
                                        try
                                        {
                                            bulk.DestinationTableName = SqlServerModel.GenerateFullTableName(tableName, schema);
                                            bulk.BulkCopyTimeout      = 3600;                                        // 1 hour timeout
                                            bulk.NotifyAfter          = 10;
                                            bulk.SqlRowsCopied       += (o, args) =>
                                            {
                                                if (_worker.CancellationPending)
                                                {
                                                    args.Abort = true;
                                                }
                                                else
                                                {
                                                    _worker.ReportProgress((int)((args.RowsCopied * 100f) / this.RecordCount), string.Format("Writing {0} records", args.RowsCopied));
                                                }
                                            };

                                            _worker.ReportProgress(0, string.Format("Writing {0} records", 0));
                                            bulk.WriteToServer(dataTable);
                                            bulk.Close();
                                        }
                                        catch (OperationAbortedException ex)
                                        {
                                            MapBindTrace.Source.TraceData(TraceEventType.Error, 1, "Error inserting: ", ex);
                                            bulk.Close();
                                        }
                                    }
                                }

                                #endregion

                                if (_worker.CancellationPending)
                                {
                                    MapBindTrace.Source.TraceEvent(TraceEventType.Warning, 1, "Rolling back transaction");
                                    transaction.Rollback();
                                }
                                else
                                {
                                    #region Create spatial index

                                    MapBindTrace.Source.TraceEvent(TraceEventType.Information, 1, "Create spatial index");
                                    _worker.ReportProgress(100, "Creating index...");

                                    // Create spatial index
                                    string sqlScriptCreateIndex      = SqlServerModel.GenerateCreateSpatialIndexScript(tableName, schema, geomcolName, SqlServerHelper.GetBoundingBox(this.Bounds), spatialType, enSpatialIndexGridDensity.MEDIUM);
                                    SqlCommand v_createdIndexcmd     = new SqlCommand(sqlScriptCreateIndex, db, transaction);
                                    v_createdIndexcmd.CommandTimeout = 3600;
                                    v_createdIndexcmd.ExecuteNonQuery();

                                    #endregion

                                    MapBindTrace.Source.TraceEvent(TraceEventType.Information, 1, "Commit transaction");
                                    transaction.Commit();
                                }
                            }
                            catch (Exception ex)
                            {
                                MapBindTrace.Source.TraceData(TraceEventType.Error, 2, "Error: ", ex);

                                MapBindTrace.Source.TraceEvent(TraceEventType.Warning, 2, "Rolling back transaction");
                                transaction.Rollback();
                                if (!this.Raise_Error(new ShapeImportExceptionEventArgs(ex, true)))
                                {
                                    throw;
                                }
                            }


                            MapBindTrace.Source.TraceEvent(TraceEventType.Verbose, 2, "closing DB");
                            db.Close();
                        }
                    }
                    #endregion
                }
                catch (Exception ex)
                {
                    MapBindTrace.Source.TraceData(TraceEventType.Error, 3, "Error: ", ex);

                    this.Raise_Error(new ShapeImportExceptionEventArgs(ex, true));
                }
            });

            Trace.CorrelationManager.StartLogicalOperation("ImportShapeFile Worker");
            _worker.RunWorkerAsync();
            Trace.CorrelationManager.StopLogicalOperation();
        }
        //TODO extract methods (reproject and shape2sql)
        public static IGeometry ReprojectGeometry(IGeometry geom, ICoordinateTransformation trans)
        {
            IGeometry geomOut = null;             // BUGGY GeometryTransform.TransformGeometry(GeometryFactory.Default, geom, trans.MathTransform);


            switch (geom.OgcGeometryType)
            {
                #region NotSupported
            case OgcGeometryType.CircularString:
            case OgcGeometryType.CompoundCurve:
            case OgcGeometryType.Curve:
            case OgcGeometryType.MultiCurve:
            case OgcGeometryType.MultiSurface:
            case OgcGeometryType.PolyhedralSurface:
            case OgcGeometryType.Surface:
            case OgcGeometryType.TIN:
            case OgcGeometryType.GeometryCollection:

                throw new NotSupportedException("Type " + geom.OgcGeometryType.ToString() + " not supported");
                #endregion NotSupported

                #region Point
            case OgcGeometryType.Point:

                Coordinate[] coordlistPoint = ShapeFileHelper.transformCoordinates(trans, ((Point)geom).Coordinates);
                geomOut = new Point(coordlistPoint[0]);

                break;
                #endregion

                #region MultiPoint
            case OgcGeometryType.MultiPoint:

                geomOut = ShapeFileHelper.transformMultiPoint(trans, ((MultiPoint)geom));

                break;
                #endregion

                #region LineString
            case OgcGeometryType.LineString:

                Coordinate[] coordlist = ShapeFileHelper.transformCoordinates(trans, ((LineString)geom).Coordinates);
                geomOut = new LineString(coordlist);

                break;
                #endregion LineString

                #region MultiLineString
            case OgcGeometryType.MultiLineString:

                List <LineString> lines = new List <LineString>();
                foreach (var lineString in ((MultiLineString)geom).Geometries)
                {
                    lines.Add(new LineString(ShapeFileHelper.transformCoordinates(trans, ((LineString)lineString).Coordinates)));
                }

                geomOut = new MultiLineString(lines.ToArray());

                break;
                #endregion LineString

                #region Polygon
            case OgcGeometryType.Polygon:

                geomOut = ShapeFileHelper.transformPolygon(trans, (Polygon)geom);

                break;
                #endregion Polygon

                #region MultiPolygon
            case OgcGeometryType.MultiPolygon:

                MultiPolygon   multiPoly = ((MultiPolygon)geom);
                List <Polygon> polygons  = new List <Polygon>();

                foreach (var poly in multiPoly.Geometries)
                {
                    polygons.Add(ShapeFileHelper.transformPolygon(trans, (Polygon)poly));
                }

                geomOut = new MultiPolygon(polygons.ToArray());

                break;
                #endregion MultiPolygon
            }


            return(geomOut);
        }