MapInfo Pro

 View Only
  • 1.  Erro loading polygon in MapInfo Pro

    Posted 16 days ago

    I was getting the following error message.

    Then I added "MI_STYLE" column in the SQL Server using the following script

    ALTER TABLE <table_name>
    ADD MI_STYLE varchar(254) NULL;

    Now, I'm able to add the polygon layer to MapInfo. However, when I zoom in or pan, I get the following error message

    Please advise



    ------------------------------
    Dhan
    VIC, Australia
    ------------------------------


  • 2.  RE: Erro loading polygon in MapInfo Pro
    Best Answer

    Posted 16 days ago

    Hi Dhan,

    To find polygons that SQL Server considers invalid, execute the following in SQL Server:

    SELECT * FROM <table_name> WHERE <geometry_column_name>.STIsValid() = 0

    Where <table_name> is the problem table and <geometry_column_name> is the name of the geometry column within that table.

    You can make them valid (according to SQL Server rules) by executing the following update:

    UPDATE <table_name> SET <geometry_column_name> = <geometry_column_name>.MakeValid() WHERE <geometry_column_name>.STIsValid() = 0



    ------------------------------
    James Nolet
    GIS Manager
    Caf Consulting
    Mentone office, VIC, Australia
    ------------------------------



  • 3.  RE: Erro loading polygon in MapInfo Pro

    Posted 16 days ago

    Thank you, James! That really helped :)



    ------------------------------
    Dhan
    VIC, Australia
    ------------------------------