C# (CSharp) OsmImportToSqlServer.Helpers.Import ConstructDataTable Examples

Example #1

File: TablesTemplates.cs Project: karavanjo/osmarser

 /// <summary>
 /// Returns the template table for imports ways in Sql Server
 /// </summary>
 /// <returns>Template table for saving way</returns>
 public static DataTable GetTableWays()
 {
     ConstructDataTable ways = new ConstructDataTable("dbo.Ways");
     ways.AddColumn("id", TypeDataTable.Int64);
     ways.AddColumn("typeGeo", TypeDataTable.Byte);
     ways.AddColumn("times", TypeDataTable.DateTime);
     return ways.GetDataTable();
 }

Example #2

File: TablesTemplates.cs Project: karavanjo/osmarser

 /// <summary>
 /// Returns the template table for imports ways and nodes in Sql Server
 /// </summary>
 /// <returns>Template table for saving way and refs (nodes in way)</returns>
 public static DataTable GetTableWaysRefs()
 {
     ConstructDataTable waysRefs = new ConstructDataTable("dbo.WaysRefs");
     waysRefs.AddColumn("idWay", TypeDataTable.Int64);
     waysRefs.AddColumn("idNode", TypeDataTable.Int64);
     waysRefs.AddColumn("orders", TypeDataTable.Int16);
     return waysRefs.GetDataTable();
 }

Example #3

File: TablesTemplates.cs Project: karavanjo/osmarser

 /// <summary>
 /// Returns the template table for imports geos as a varbinary(max) in Sql Server
 /// </summary>
 /// <returns>Template table for saving geos as a varbinary(max)</returns>
 public static DataTable GetTableGeo()
 {
     ConstructDataTable constructDataTable = new ConstructDataTable("dbo.Geo");
     constructDataTable.AddColumn("idGeo", TypeDataTable.Int64);
     constructDataTable.AddColumn("bin", TypeDataTable.ByteArray);
     constructDataTable.AddColumn("typeGeo", TypeDataTable.Int16);
     return constructDataTable.GetDataTable();
 }

Example #4

File: TablesTemplates.cs Project: karavanjo/osmarser

 /// <summary>
 /// Returns the template table for imports nodes in Sql Server
 /// </summary>
 /// <returns>Template table for saving node</returns>
 public static DataTable GetTableNodes()
 {
     ConstructDataTable nodes = new ConstructDataTable("dbo.Nodes");
     nodes.AddColumn("id", TypeDataTable.Int64);
     nodes.AddColumn("lat", TypeDataTable.Double);
     nodes.AddColumn("lon", TypeDataTable.Double);
     nodes.AddColumn("times", TypeDataTable.DateTime);
     return nodes.GetDataTable();
 }

Example #5

        /// <summary>
        /// Returns the template table for imports ways in Sql Server
        /// </summary>
        /// <returns>Template table for saving way</returns>
        public static DataTable GetTableWays()
        {
            ConstructDataTable ways = new ConstructDataTable("dbo.Ways");

            ways.AddColumn("id", TypeDataTable.Int64);
            ways.AddColumn("typeGeo", TypeDataTable.Byte);
            ways.AddColumn("times", TypeDataTable.DateTime);
            return(ways.GetDataTable());
        }

Example #6

        /// <summary>
        /// Returns the template table for imports ways and nodes in Sql Server
        /// </summary>
        /// <returns>Template table for saving way and refs (nodes in way)</returns>
        public static DataTable GetTableWaysRefs()
        {
            ConstructDataTable waysRefs = new ConstructDataTable("dbo.WaysRefs");

            waysRefs.AddColumn("idWay", TypeDataTable.Int64);
            waysRefs.AddColumn("idNode", TypeDataTable.Int64);
            waysRefs.AddColumn("orders", TypeDataTable.Int16);
            return(waysRefs.GetDataTable());
        }

Example #7

        /// <summary>
        /// Returns the template table for imports geos as a varbinary(max) in Sql Server
        /// </summary>
        /// <returns>Template table for saving geos as a varbinary(max)</returns>
        public static DataTable GetTableGeo()
        {
            ConstructDataTable constructDataTable = new ConstructDataTable("dbo.Geo");

            constructDataTable.AddColumn("idGeo", TypeDataTable.Int64);
            constructDataTable.AddColumn("bin", TypeDataTable.ByteArray);
            constructDataTable.AddColumn("typeGeo", TypeDataTable.Int16);
            return(constructDataTable.GetDataTable());
        }

Example #8

        /// <summary>
        /// Returns the template table for imports nodes in Sql Server
        /// </summary>
        /// <returns>Template table for saving node</returns>
        public static DataTable GetTableNodes()
        {
            ConstructDataTable nodes = new ConstructDataTable("dbo.Nodes");

            nodes.AddColumn("id", TypeDataTable.Int64);
            nodes.AddColumn("lat", TypeDataTable.Double);
            nodes.AddColumn("lon", TypeDataTable.Double);
            nodes.AddColumn("times", TypeDataTable.DateTime);
            return(nodes.GetDataTable());
        }

Example #9

File: TablesTemplates.cs Project: karavanjo/osmarser

 public static DataTable GetTableTagsValuesTrans()
 {
     ConstructDataTable constructDataTable = new ConstructDataTable("dbo.TagsValuesTrans");
     constructDataTable.AddColumn("tagHash", TypeDataTable.Int32);
     constructDataTable.AddColumn("valueHash", TypeDataTable.Int32);
     constructDataTable.AddColumn("tagTrans", TypeDataTable.String);
     constructDataTable.AddColumn("valTrans", TypeDataTable.String);
     constructDataTable.AddColumn("LCID", TypeDataTable.Int16);
     constructDataTable.AddColumn("typeTrans", TypeDataTable.Byte);
     return constructDataTable.GetDataTable();
 }

Example #10

File: TablesTemplates.cs Project: karavanjo/osmarser

 /// <summary>
 /// Creates a table for storing tags and their values
 /// </summary>
 /// <returns>Table for storing tags and their values</returns>
 public static DataTable GetTableTagsValue()
 {
     ConstructDataTable constructDataTable = new ConstructDataTable("dbo.TagsValues");
     constructDataTable.AddColumn("idGeo", TypeDataTable.Int64);
     constructDataTable.AddColumn("tag", TypeDataTable.Int32);
     constructDataTable.AddColumn("vType", TypeDataTable.Int16);
     constructDataTable.AddColumn("vHash", TypeDataTable.Int32);
     constructDataTable.AddColumn("vString", TypeDataTable.String);
     constructDataTable.AddColumn("vInt", TypeDataTable.Int32);
     return constructDataTable.GetDataTable();
 }

Example #11

        /// <summary>
        /// Creates a table for storing tags and their values
        /// </summary>
        /// <returns>Table for storing tags and their values</returns>
        public static DataTable GetTableTagsValue()
        {
            ConstructDataTable constructDataTable = new ConstructDataTable("dbo.TagsValues");

            constructDataTable.AddColumn("idGeo", TypeDataTable.Int64);
            constructDataTable.AddColumn("tag", TypeDataTable.Int32);
            constructDataTable.AddColumn("vType", TypeDataTable.Int16);
            constructDataTable.AddColumn("vHash", TypeDataTable.Int32);
            constructDataTable.AddColumn("vString", TypeDataTable.String);
            constructDataTable.AddColumn("vInt", TypeDataTable.Int32);
            return(constructDataTable.GetDataTable());
        }

Example #12

        public static DataTable GetTableTagsValuesTrans()
        {
            ConstructDataTable constructDataTable = new ConstructDataTable("dbo.TagsValuesTrans");

            constructDataTable.AddColumn("tagHash", TypeDataTable.Int32);
            constructDataTable.AddColumn("valueHash", TypeDataTable.Int32);
            constructDataTable.AddColumn("tagTrans", TypeDataTable.String);
            constructDataTable.AddColumn("valTrans", TypeDataTable.String);
            constructDataTable.AddColumn("LCID", TypeDataTable.Int16);
            constructDataTable.AddColumn("typeTrans", TypeDataTable.Byte);
            return(constructDataTable.GetDataTable());
        }

Example #13

File: OsmImportPdbRow.cs Project: karavanjo/osmarser

 /// <summary>
 /// Returns the template table for imports ways in Sql Server
 /// </summary>
 /// <returns>Template table for saving way</returns>
 private DataTable GetTableWays()
 {
     ConstructDataTable ways = new ConstructDataTable("dbo.Ways");
     ways.AddColumn("id", TypeDataTable.Int64);
     ways.AddColumn("typeGeo", TypeDataTable.Byte);
     ways.AddColumn("orders", TypeDataTable.Int16);
     ways.AddColumn("idNode", TypeDataTable.Int64);
     ways.AddColumn("times", TypeDataTable.DateTime);
     return ways.GetDataTable();
 }

Example #14

File: OsmImportPdbRow.cs Project: karavanjo/osmarser

 /// <summary>
 /// Creates a table for storing tags and their values
 /// </summary>
 /// <returns>Table for storing tags and their values</returns>
 private DataTable GetTableTagsValue()
 {
     ConstructDataTable constructDataTable = new ConstructDataTable(_importConfigurator.DataBaseConfig.TableNameValues);
     constructDataTable.AddColumn("idGeo", TypeDataTable.Int64);
     constructDataTable.AddColumn("tag", TypeDataTable.Int32);
     constructDataTable.AddColumn("vType", TypeDataTable.Int16);
     constructDataTable.AddColumn("vHash", TypeDataTable.Int32);
     constructDataTable.AddColumn("vString", TypeDataTable.String);
     constructDataTable.AddColumn("vInt", TypeDataTable.Int32);
     return constructDataTable.GetDataTable();
 }

Example #15

File: OsmImportPdb.cs Project: karavanjo/osmarser

 /// <summary>
 /// Returns the template table for imports node as a varbinary(max) in Sql Server
 /// </summary>
 /// <returns>Template table for saving node as a varbinary(max)</returns>
 private DataTable GetTableGeo()
 {
     ConstructDataTable constructDataTable = new ConstructDataTable(_importConfigurator.DataBaseConfig.TableNameGeo);
     constructDataTable.AddColumn("idGeo", TypeDataTable.Int64);
     constructDataTable.AddColumn("bin", TypeDataTable.ByteArray);
     constructDataTable.AddColumn("typeGeo", TypeDataTable.Int16);
     return constructDataTable.GetDataTable();
 }