edit attribute

HiI exsport an area to cvs, and i want to make change in the attribute in xls and then import it back The coordinate is placed in a long string in on one lane (colum) in exel I am not sucessfull to import it back - what shall i do ?

Answers

  • geomanniegeomannie Global Mapper User Posts: 161Trusted User
    Hi Lars

    You should be able to import all columns in a csv file. In the import dialogue sure that the box "Treat 3rd coordinate value as elevation" is off and that "Include attritbutes from lines with coordiate data" is ticked on.

    Does this help?
  • LarsLars Posts: 4

    geomannie said:
    Hi Lars

    You should be able to import all columns in a csv file. In the import dialogue sure that the box "Treat 3rd coordinate value as elevation" is off and that "Include attritbutes from lines with coordiate data" is ticked on.

    Does this help?

    No

    I attach e file -

  • LarsLars Posts: 4

    geomannie said:
    Hi Lars

    You should be able to import all columns in a csv file. In the import dialogue sure that the box "Treat 3rd coordinate value as elevation" is off and that "Include attritbutes from lines with coordiate data" is ticked on.

    Does this help?

    No.

    The polygon is located in the cvs in one cell and in one long string (see under)

    whwn i import it , it come as only one point on  wrong place also

    POLYGON(( 540285.788 6586812.474, 540288.270 6586807.850, 540288.530 6586807.390, 540292.230 6586803.790, 540293.720 6586802.870, 540297.710 6586800.440, 540298.270 6586800.200, 540302.360 6586798.550, 540308.270 6586797.090, 540314.130 6586795.650, 540318.270 6586794.200, 540322.090 6586792.870, 540328.270 6586790.710, 540329.070 6586790.440, 540334.510 6586788.880, 540338.270 6586788.480, 540339.820 6586788.320, 540343.810 6586785.120, 540344.340 6586782.870, 540345.260 6586779.070, 540346.000 6586773.590, 540345.950 6586772.870, 540345.640 6586768.170, 540344.680 6586762.860, 540344.590 6586762.350, 540344.160 6586755.930, 540344.660 6586752.870, 540345.110 6586750.360, 540345.040 6586745.270, 540344.340 6586742.870, 540341.910 6586734.490, 540340.980 6586732.880, 540339.240 6586729.820, 540338.270 6586728.640, 540335.360 6586725.110, 540333.640 6586722.870, 540332.390 6586721.230, 540332.170 6586720.940, 540330.090 6586716.280, 540328.270 6586714.160, 540327.160 6586712.870, 540326.490 6586712.090, 540323.330 6586707.090, 540321.170 6586702.870, 540320.950 6586702.430, 540319.070 6586697.600, 540319.110 6586692.870, 540319.120 6586691.990, 540321.590 6586682.870, 540322.320 6586680.190, 540325.400 6586673.450, 540326.040 6586672.870, 540328.270 6586670.870, 540330.610 6586668.790, 540335.580 6586666.420, 540338.270 6586664.990, 540340.450 6586663.840, 540341.560 6586662.870, 540348.270 6586657.020, 540349.140 6586656.270, 540354.970 6586652.870, 540356.040 6586652.250, 540356.450 6586651.960, 540351.320 6586642.870, 540348.270 6586637.460, 540345.930 6586633.300, 540345.650 6586632.870, 540339.250 6586622.870, 540338.270 6586621.330, 540332.850 6586612.870, 540328.270 6586605.720, 540326.440 6586602.870, 540322.670 6586596.970, 540320.400 6586597.970, 540317.710 6586600.570, 540308.710 6586606.540, 540304.900 6586606.970, 540301.270 6586606.420, 540297.820 6586605.210, 540291.280 6586601.470, 540283.700 6586600.350, 540279.890 6586601.610, 540272.730 6586605.130, 540264.930 6586607.480, 540257.640 6586609.340, 540245.710 6586611.630, 540234.120 6586614.080, 540226.480 6586616.440, 540223.320 6586617.210, 540215.710 6586619.070, 540208.730 6586621.760, 540206.700 6586624.700, 540203.300 6586630.920, 540199.240 6586636.800, 540194.020 6586643.330, 540187.980 6586649.170, 540180.250 6586657.630, 540173.490 6586667.420, 540170.400 6586674.310, 540166.330 6586681.190, 540161.450 6586687.040, 540154.600 6586691.890, 540148.590 6586696.250, 540142.580 6586700.440, 540138.770 6586701.040, 540134.650 6586700.640, 540130.320 6586700.830, 540128.790 6586707.740, 540127.190 6586714.810, 540124.240 6586721.610, 540127.360 6586722.490, 540128.960 6586725.650, 540130.990 6586732.950, 540133.030 6586739.750, 540136.980 6586750.380, 540140.340 6586757.370, 540147.880 6586771.030, 540153.240 6586776.400, 540159.590 6586780.960, 540169.230 6586788.210, 540178.030 6586795.290, 540182.000 6586794.860, 540185.490 6586793.430, 540192.480 6586789.740, 540202.300 6586784.780, 540210.110 6586781.610, 540216.600 6586778.910, 540223.720 6586777.700, 540231.150 6586777.490, 540234.600 6586778.370, 540237.700 6586780.730, 540243.060 6586786.430, 540249.680 6586795.620, 540249.790 6586799.090, 540248.910 6586802.540, 540248.090 6586806.490, 540267.260 6586811.090, 540274.510 6586812.030, 540281.450 6586811.980, 540285.788 6586812.474 ))I attach e file -

  • geomanniegeomannie Global Mapper User Posts: 161Trusted User
    Hi Lars

    I do not fully understand your workflow. If you export a CSV of point data you should get columns of of "x", "y", "attribute". The file you attach is not in that format. I can use Excel to reform the data into X,Y columns (attached as zip) to which you can add an attribute, but somehow I do not think this is your problem.
  • MykleMykle Global Mapper User Posts: 392Trusted User
    Geomannie has done the work for you to create a file in a format that GM can read. 

    Here is a description of how to do this: 

    I do not see a format offered by Global Mapper that fits your data.
    So, some editing is required to convert your data to a format that can be imported by GM.

    We need one pair of coordinates per line or row.
    When I cut-and-paste your data into EXCEL, all of the data are in cell A1.
    (You can use another spreadsheet program, but the steps may named differently.)

    Select the cell containing the data (click once on cell A1).
    Use the "Text to Columns" function, using the "Delimited" type (not Fixed width), and the comma delimiter.
    The cells for Row 1 should now contain one pair of coordinates in each cell. 

    Transpose the Row 1 cells to Column A cells:
      Select Row 1 (click on the row 1 label so the entire row is selected).
      Copy the selection (use Ctrl-C or Right-click+Copy)
      Click on cell A2, right-click and under Paste Options click on Transpose (point at each of the icons to display the name).

    Clean up:
      Delete Row A1 (select Row 1, then right-click+Delete)
      Edit the first cell to remove "POLYGON((" and leave only the first pair of coordinates)
      (the "))" after the last coordinate pair can be left, as GM will ignore them)

    Save the file as CSV (or select column A and copy the content to a text file, named CSV or TXT)
    Be sure that you close the spreadsheet program, otherwise GM will not be able to load your saved file. 
    Open the file in GM.

    This procedure resulting in an area being drawn in GM.  I assumed the UTM projection, using any zone. 
    You will need to select an appropriate datum, projection and zone.


Sign In or Register to comment.