Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages

Excel to GIS on mapinfo

Tagged: 

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • #56539 Reply
    Ali
    Guest

    Hi
    I am new in using mapinfo. Can any one help me how to convert excel data base to map in mapinfo as tab file?

    #56540 Reply
    Rex
    Guest

    Hi Ali,
    in excel file you should have coordinates (LONGITUDE and LATITUDE) in decimal format. Open MapInfo, open excel file, on “Excel Information” dialog box check “Use row above……for Column Titles”,on “Set field properties” click OK (unless you like to change field type for each field) and a table appears. That’s a TAB file. If you like to show in the map, click Table-Create Points, select the table, Get X Coordinate from Column (that is column with longitude) Get Y Coordinate from Column (that is column from latitude), click “Projection …”, Category=Longitude/Latitude, Category Members=Longitude/Latitude (WGS 84), OK, OK and that’s it. Hope it helps.

    #56541 Reply
    ali
    Guest

    Thank you very much REX for your help

    #56542 Reply
    Ali
    Guest

    Hi Rex
    Can you please help me how to solve problem of (datatype mismatch in expression) let say for BCCH.
    Hi

    #56543 Reply
    Rex
    Guest

    Hi Ali,
    I assume you’re doing some queries in MapInfo. If field type, for example BCCH, is “Character” and in the query you look for a number then you get the message you mentioned. The type of a column(field) and the type of value given in the query should be same. Check field type (such as BCCH) and declare as “Small Integer” and then run query giving the value as numbers. In MapInfo: Table-Maintenance-Table Structure …
    Hope it helps,
    Regards!

    #56544 Reply
    Ali
    Guest

    Hi Rex
    i checked it is small integer

    #56545 Reply
    Ali
    Guest

    And where can i find Query

    #56546 Reply
    Rex
    Guest

    Query-Select… (or SQL Select…)

    #56547 Reply
    Touseef
    Guest

    Dear Rex,

    I have Mapped my excel data on Mapinfo as per ur procedure. But how can i draw link/line between two sites for showing MW link?

    #56548 Reply
    alex
    Guest

    hi ali
    please explain for me about mapinfo and advantage of this field
    thanx

Viewing 10 posts - 1 through 10 (of 10 total)
Reply To: Excel to GIS on mapinfo
Your information:




<a href="" title="" rel="" target=""> <blockquote cite=""> <code> <pre class=""> <em> <strong> <del datetime="" cite=""> <ins datetime="" cite=""> <ul> <ol start=""> <li> <img src="" border="" alt="" height="" width="">