Join CSV table with existing shapefile dbf

RobertRRobertR GlobalMapper Fan!Posts: 284Trusted User
edited August 2012 in How I use Global Mapper
Hello all,

I was wondering if GM has a solution for the following problem:

I have a layer representing parcel data (shapefile);

I also have a separate .CSV file representing additional data for that specific shapefile;

Is it possible to join the CSV to the dbf of the shapefile if I have a common column in both of them? To be more specific, based on a common column (let's say 'CITY') I want to join the data from the CSV file into the parcel shapefile dbf.

Hope I stated somehow clearly my idea, if not, will be more that happy to give further information;\

Thank you,

Comments

  • global_mapperglobal_mapper Administrator Posts: 17,238
    edited July 2011
    It is not currently possible to join data tables in Global Mapper, although that is one of the features that we are planning on adding for the upcoming v13 release in a month or so.

    Thanks,

    Mike
    Global Mapper Support
    support@globalmapper.com
  • RobertRRobertR GlobalMapper Fan! Posts: 284Trusted User
    edited July 2011
    Wow! Great! thank you!
  • waynerwayner Global Mapper User Posts: 11
    edited August 2012
    Is this possible yet?
    RobertR wrote: »
    Hello all,

    I was wondering if GM has a solution for the following problem:

    I have a layer representing parcel data (shapefile);

    I also have a separate .CSV file representing additional data for that specific shapefile;

    Is it possible to join the CSV to the dbf of the shapefile if I have a common column in both of them? To be more specific, based on a common column (let's say 'CITY') I want to join the data from the CSV file into the parcel shapefile dbf.

    Hope I stated somehow clearly my idea, if not, will be more that happy to give further information;\

    Thank you,
  • global_mapperglobal_mapper Administrator Posts: 17,238
    edited August 2012
    Yep, that is in the v13 releases. Just load the Shapefile, then right-click on that layer in the Control Center and select to Join an attribute table to merge in the CSV attributes to the Shapefile.

    Thanks,

    Mike
    Global Mapper Guru
    gmsupport@bluemarblegeo.com
    http://www.globalmapper.com
  • zuluzulu Posts: 1
    Hi All,

    I have a similar problem. I have a shapefile and an additional data in a separate files with the same name and the following formats: .DAT, .ID, .MAP, .tab. I am hoping that the .MAP file contains information that I need to add to my shapefile. Is there a way to append the shapefile with the information from .MAP file or at least view the .MAP file to check what it contains?

    I tried the method described above but I get an error massage:

    ---------------------------
    Global Mapper v18.1.0 (b022117) [64-bit] [+Lidar]
    ---------------------------
    Error parsing join file
    ControlUtils.h - 360
    Version: v18.1.0 (64-bit)
    Build Time: Feb 21 2017 11:58:26

    Stack Trace:

    000000014028FC4F (global_mapper)

    000000014029144E (global_mapper)

    000000014066B8C7 (global_mapper)

    000000014066C78C (global_mapper)

    000000014007632E (global_mapper)

    0000000140075B3F (global_mapper)

    000007FEE6C117BE (mfc110)

    000007FEE6C11A36 (mfc110)

    000007FEE6C3881E (mfc110)

    000000014008A430 (global_mapper)

    000007FEE6CB5E94 (mfc110)

    000007FEE6A88FD5 (mfc110)

    000007FEE6CB51DE (mfc110)

    000000014008A746 (global_mapper)

    000007FEE6CB5148 (mfc110)

    ... (40 Additional Stack Items Hidden)

    Windows 7 Professional (64-bit) Memory: 4,709,072,896 of 8,493,613,056 available, GDI Usage: 393 GDI (Peak 522), 166 User (Peak 294)

    Thanks :)



  • bmg_bobbmg_bob Global Mapper Programmer Posts: 1,681
    zulu said:
    Hi All,

    I have a similar problem. I have a shapefile and an additional data in a separate files with the same name and the following formats: .DAT, .ID, .MAP, .tab. I am hoping that the .MAP file contains information that I need to add to my shapefile. Is there a way to append the shapefile with the information from .MAP file or at least view the .MAP file to check what it contains?

    I tried the method described above but I get an error massage:

    ---------------------------
    Global Mapper v18.1.0 (b022117) [64-bit] [+Lidar]
    ---------------------------
    Error parsing join file
    ControlUtils.h - 360
    Version: v18.1.0 (64-bit)
    Build Time: Feb 21 2017 11:58:26

    What file did you try to join with your shapefile?  The data set you have appears to be a MapInfo TAB file, and you can open the .TAB file directly in Global Mapper so you can see what it contains.  The attributes are stored in the .DAT file, but Global Mapper can't join attributes directly from a .DAT file.  You will need to export the attributes to a .csv file, and then join that to the shapefile.

    Cheers,
    Bob
Sign In or Register to comment.