geologywalrus Posted October 24, 2013 Report Share Posted October 24, 2013 I'm a new user of ArcGIS (just started this week), I have two shape files, one is a set of polygons making up a geologic map of an area. The other is a set of latitude and longitude points with associated geochemistry. I want to combine both files so that I will have a set of points that will also tell me what polygon they lie within in the attributes table. I then want to be able to export the attributes out to excel. So far I've tried combining the files with both merge and union, but because one is a point, and the other is a polygon I haven't had success. Does anyone have any suggestions? Please feel free to ask for any additional details, like I said I'm extremely new at this. Quote Link to comment Share on other sites More sharing options...
adnan0001 Posted October 24, 2013 Report Share Posted October 24, 2013 Dear brother.. Use spatialjoin option from analysis tool -overlay-spatialjoin option give ur target file and next join feature option which u want to join give it.. done Quote Link to comment Share on other sites More sharing options...
geologywalrus Posted October 24, 2013 Author Report Share Posted October 24, 2013 Thank you so much! How can I export it as an excel file? Quote Link to comment Share on other sites More sharing options...
adnan0001 Posted October 25, 2013 Report Share Posted October 25, 2013 open the attribute table - right click - data-export it to dbf done Quote Link to comment Share on other sites More sharing options...
Arhanghelul Posted October 25, 2013 Report Share Posted October 25, 2013 (edited) open the attribute table - right click - data-export it to dbf done If you want to export easly and directly to Excell, you can also install X Tools Pro, the best ArcGIS extension for interoperability data (you need to find a crack for this tool - search on this forum) here is the link to the "oficial" web page: http://www.xtoolspro.com/ Edited October 25, 2013 by Arhanghelul Quote Link to comment Share on other sites More sharing options...
adnan0001 Posted October 25, 2013 Report Share Posted October 25, 2013 (edited) dear for arcgis 10.2 ..is there any version released with medicine Edited October 25, 2013 by adnan0001 Quote Link to comment Share on other sites More sharing options...
Arhanghelul Posted October 25, 2013 Report Share Posted October 25, 2013 dear for arcgis 10.2 ..is there any version released with medicine XTools Pro for AcGIS 10.2 with crack ? I don't know, my friend...... Quote Link to comment Share on other sites More sharing options...
souvik.gis Posted October 25, 2013 Report Share Posted October 25, 2013 XTools Pro is a good one but not necessary at-all to export data to excel. Process told by Adnan001 is the easiset way. After creating dbf, you can open in excel and save it to excel. Otherwise you can use the tool... http://www.mediafire.com/?1teeidesfobjb4r Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.