+ Reply to Thread
Results 1 to 7 of 7

Thread: How to add text file or csv file to ArcGIS 10?

  1. #1
    tekie tesfagaber
    Join Date
    Apr 2011
    Posts
    2
    Points
    0
    Answers Provided
    0


    0

    Default How to add text file or csv file to ArcGIS 10?

    I have a list of x and y coordinates in a text file with txt or csv extension. I tried to add them to ArcMap document but it does not work. I have used File > Add Data > Add XY data... and then selected the text file but It does show up the field as x and y coordinate. The text file has 1.2 million rows.

    With regards,

  2. #2
    Andrew May
    Join Date
    Jul 2010
    Posts
    67
    Points
    3
    Answers Provided
    0


    0

    Default Re: How to add text file or csv file to ArcGIS 10?

    What format is your file in? Comma/space/tab delimited? And do you get the same issues when trying a smaller file?

    You've probably read it already but the following link might be useful:

    http://support.esri.com/en/knowledge...s/detail/27589

    Regards
    Senior GIS Developer, UK
    pecoanddeco@gmail.com

  3. #3
    Sisi Yan
    Join Date
    Apr 2010
    Posts
    54
    Points
    6
    Answers Provided
    1


    0

    Default Re: How to add text file or csv file to ArcGIS 10?


  4. #4
    Stephen Page
    Join Date
    Jan 2011
    Posts
    26
    Points
    1
    Answers Provided
    0


    0

    Default Re: How to add text file or csv file to ArcGIS 10?

    Hi

    My file is comma delimited, eg:
    280000.150,6183956.260,568.300
    280000.150,6183956.260,568.300
    etc

    I wish to create an (ESRI) ASCII Raster text file of the following format:

    ncols 2001
    nrows 2001
    xllcorner 281999.5
    yllcorner 6187999.5
    cellsize 1
    nodata_value -32767
    387.99 387.99 387.99 387.99 387.99 387.99 387.99 387.99 387.99 386.72
    387.99 387.99 387.99 387.99 387.99 387.99 387.99 387.99 387.99 386.72
    etc

    This can then be converted (ASCII To Raster, etc) to an ESRI Grid (AAIGrid)

    Steve

  5. #5
    Neil Sang
    Join Date
    Jan 2012
    Posts
    11
    Points
    4
    Answers Provided
    1


    0

    Default Re: How to add text file or csv file to ArcGIS 10?

    Hi

    The "Add XY" import option is for adding point data with XY Coordinates. Rasters just use the header for their spatial co-ordinates.

    I don't think there is a way to automatically add the header, just paste the header you posted to the top of the text file. Unfortunately my ArcLicence server is down so I can't check if CSV is an accepted format of if you'll need to replace commas with spaces first.

    http://help.arcgis.com/en/arcgisdesk...0000002s000000

  6. #6
    Stephen Page
    Join Date
    Jan 2011
    Posts
    26
    Points
    1
    Answers Provided
    0


    0

    Default Re: How to add text file or csv file to ArcGIS 10?

    Thanks for the reply,

    Sorry, I seem to have posted in this thread in error!

    My original post was in the Imagery and Raster Data forum

    as: "Convert Ascii csv files to ESRI ASCII Raster (grid) text files"


    I have Ascii csv files (LiDAR), and I want to create ESRI ASCII Raster (grid) text files, prior to converting to ESRI Grid.

    I've tried various converters but they require raster information.


    The csv files have been thinned and I need to get a complete coverage to create a surface model - Point to Raster leaves a very sparse grid.

    Unfortunately we do not have 3D analyst licence, as I understand I could create a terrain dataset if we had this


    The Header info I showed earlier was a dummy set copied from another file for illustration.

    Is there a way to create the headers without doing it manually? - I have Many tiles to convert!

    Also reformatting the data values would also be laborious!

    Thanks,

    steve

  7. #7
    Bruce Harold

    Join Date
    Oct 2009
    Posts
    414
    Points
    75
    Answers Provided
    10


    0

    Default Re: How to add text file or csv file to ArcGIS 10?

    Hello Stephen

    If you acquire 3D Analyst, it has tools for creation of rasters from your files. The ASCII 3D to Feature Class tool will create 3D points, then you can surface these and output a grid or TIN.

    Regards
    Bruce H.
    ESRI Redlands

+ Reply to 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