+ Reply to Thread
Results 1 to 8 of 8

Thread: how to merge several layers and attributes

  1. #1
    Sahoko Yui
    Join Date
    Dec 2010
    Posts
    6
    Points
    0
    Answers Provided
    0


    0

    Default how to merge several layers and attributes

    how to merge shapefiles and attribute tables...?

    so i have a parts of the world that i want to bring together. and i tried 'merge' but instead of overlaying the attributes, it just makes a more attributes.

    so, for example, i want to merge USA and Canada
    suppose there are 3 columns (both datasets have the same 3 columns) name, area, population.
    when i merge them, instead of aligning the columns, so that it makes the list longer, it creates 10 columns. does that make sense?
    so it looks like this:

    name | area | population | name_1 | area_1 | population_1 |
    usa 123 123123123 can 123 123123123

    but i want it to look like this:
    name | area | population
    usa 123 123123123
    can 123 123123123


    i just want to be able to merge them together so that the attributes also come together in the same column too .... which wouldn't be a problem to do manually if i had just one or two datasets and 3 attributes, but i'm merging together about 15 layers, each with about 18 attributes.

    do you know if there's a way to do that? i think there is a very easy way to do this, but i just can't seem to figure it out for the life of me. tips anyone? i'm looking to get this done by 12/28!

  2. #2
    Joe Borgione

    Join Date
    Apr 2010
    Posts
    1,140
    Points
    307
    Answers Provided
    31


    0

    Default Re: how to merge several layers and attributes

    May I suggest yo create your own feature class, give a projection that works for both countries and then add the fields you want. Use the simple data loader to load the usa and canada, mapping the original fields to your fields, and you'll be done with it in about 10 minutes..
    Joe Borgione
    AlpineGeographic

    If the suggestion I provide helps solve your problem, please feel free to give it a favorable review by clicking the up arrow. That's only only reward I get for sharing 20 + years of professional GIS experience.

  3. #3
    Venkata Rao Tammineni

    Join Date
    Aug 2010
    Posts
    443
    Points
    0
    Answers Provided
    0


    0

    Default Re: how to merge several layers and attributes

    Quote Originally Posted by GISstudent2010 View Post
    how to merge shapefiles and attribute tables...?

    so i have a parts of the world that i want to bring together. and i tried 'merge' but instead of overlaying the attributes, it just makes a more attributes.

    so, for example, i want to merge USA and Canada
    suppose there are 3 columns (both datasets have the same 3 columns) name, area, population.
    when i merge them, instead of aligning the columns, so that it makes the list longer, it creates 10 columns. does that make sense?
    so it looks like this:

    name | area | population | name_1 | area_1 | population_1 |
    usa 123 123123123 can 123 123123123

    but i want it to look like this:
    name | area | population
    usa 123 123123123
    can 123 123123123


    i just want to be able to merge them together so that the attributes also come together in the same column too .... which wouldn't be a problem to do manually if i had just one or two datasets and 3 attributes, but i'm merging together about 15 layers, each with about 18 attributes.

    do you know if there's a way to do that? i think there is a very easy way to do this, but i just can't seem to figure it out for the life of me. tips anyone? i'm looking to get this done by 12/28!
    http://webhelp.esri.com/arcgisdeskto...ata_Management)

    http://webhelp.esri.com/arcgisdeskto...opicname=Merge
    Thanks and Regards,

    Venkat Tammineni

    venkat@muravema.com

  4. #4
    Hardolph Wasteneys
    Join Date
    Apr 2010
    Posts
    316
    Points
    104
    Answers Provided
    17


    0

    Default Re: how to merge several layers and attributes

    Using any of Merge, Append or load data (toolbox functions) the main problem to overcome is mapping the 3 fields of the 18 data sets onto the 3 fields of the type attribute table. You probably have subtle differences in the field names that caused Merge to generate a new field even though they looked similar (perhaps same alias).

    If you use Merge start with the type attribute table and then add the others and edit the field map to map the disparate mislocated fields into the common one. With Append you need to use "No Test" for the schema type to display and edit the field map. Similarly with the simple data loader you will need to specify what field maps onto what.

    Bit tedious editing the field mapping table with 18 tables, but one shortcut would be to sort them into groups of the same for precise field alignment and merge separately then merge the groups.

    Hardolph
    Hardolph Wasteneys Ph.D., P.Geo.
    Geologist
    Vancouver Island

    hardolph@bravewolf.com

  5. #5
    Sahoko Yui
    Join Date
    Dec 2010
    Posts
    6
    Points
    0
    Answers Provided
    0


    0

    Default Re: how to merge several layers and attributes

    Quote Originally Posted by jborgion View Post
    May I suggest yo create your own feature class, give a projection that works for both countries and then add the fields you want. Use the simple data loader to load the usa and canada, mapping the original fields to your fields, and you'll be done with it in about 10 minutes..
    ah, i knew there was a simple way to do it ... thanks so much!

  6. #6
    Sahoko Yui
    Join Date
    Dec 2010
    Posts
    6
    Points
    0
    Answers Provided
    0


    0

    Default Re: how to merge several layers and attributes

    Quote Originally Posted by Hardolph View Post
    Using any of Merge, Append or load data (toolbox functions) the main problem to overcome is mapping the 3 fields of the 18 data sets onto the 3 fields of the type attribute table. You probably have subtle differences in the field names that caused Merge to generate a new field even though they looked similar (perhaps same alias).

    If you use Merge start with the type attribute table and then add the others and edit the field map to map the disparate mislocated fields into the common one. With Append you need to use "No Test" for the schema type to display and edit the field map. Similarly with the simple data loader you will need to specify what field maps onto what.

    Bit tedious editing the field mapping table with 18 tables, but one shortcut would be to sort them into groups of the same for precise field alignment and merge separately then merge the groups.

    Hardolph
    thanks, it's true some of the fields were merely 'simlilar' but not exact. i used the data loader and made some new fields to clear up any differences and worked like a charm! thanks!

  7. #7

    Join Date
    Feb 2011
    Posts
    1
    Points
    0
    Answers Provided
    0


    0

    Default Re: how to merge several layers and attributes

    hi,

    I want to mearge two shape files with different attribute table columns. Please someone suggest me a tool to do this. As far as I am reading GeoMearge can combine two shape files with same attribute table information. But in my case the two shape files have different attribute table information.

  8. #8
    Sahoko Yui
    Join Date
    Dec 2010
    Posts
    6
    Points
    0
    Answers Provided
    0


    0

    Default Re: how to merge several layers and attributes

    Did you try the Arc toolbox > Analysis tools > Overlay > Intersect ?

+ Reply to Thread

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts