Jump to content

 
Photo

Import .xml file to ArcGIS

- - - - -

  • Please log in to reply
4 replies to this topic

#1
sona

sona

    Newbie

  • Validated Member
  • Pip
  • 1 posts
  • No Country Selected

I have several .xml file that I would like to import to ArcGIS. I have 10. desktop but if you have any ideas, tips, or tricks I would like to hear them. The point locations are defined by point x=... point y = ...., I think there is a way for esri to acknowledge for visualization this data (files).
I will apreciate all help.

Thanks!

#2
frax

frax

    Hall of Fame

  • Associate Admin
  • PipPipPipPipPipPipPip
  • 2,312 posts
  • Gender:Male
  • Location:Stockholm, Sweden
  • Interests:music, hiking, friends, nature, photography, traveling. and maps!
  • Sweden

Is there any way you can transform the files to a flat database table? Using xsl/html or excel maybe? Import the files into Access? Parse the files with a custom script (like python) and output csv?
Hugo Ahlenius
Nordpil - custom maps and GIS
http://nordpil.com/
Twitter

#3
Andrew

Andrew

    Master Contributor

  • Validated Member
  • PipPipPipPip
  • 102 posts
  • Gender:Male
  • Location:Australia
  • Interests:Web development, and golf!
  • Australia

I have several .xml file that I would like to import to ArcGIS. I have 10. desktop but if you have any ideas, tips, or tricks I would like to hear them. The point locations are defined by point x=... point y = ...., I think there is a way for esri to acknowledge for visualization this data (files).
I will apreciate all help.

Thanks!


Do you have the data interop extension? There is a XML import option there that you could try.

#4
frax

frax

    Hall of Fame

  • Associate Admin
  • PipPipPipPipPipPipPip
  • 2,312 posts
  • Gender:Male
  • Location:Stockholm, Sweden
  • Interests:music, hiking, friends, nature, photography, traveling. and maps!
  • Sweden

One thing to keep in mind is that xml is not one file format, it is just a general framework. It can have any kind of layout, including non-flat ones (e.g. hierarchies in the file).

Is this a gml or kml file? (or xhtml?)

My first try would be to try to examine the file and maybe open it in excel.
Hugo Ahlenius
Nordpil - custom maps and GIS
http://nordpil.com/
Twitter

#5
Sv_BG

Sv_BG

    Contributor

  • Validated Member
  • PipPip
  • 33 posts
  • Gender:Male
  • Location:Sofia
  • Bulgaria

Hi,

Try converting it into an excel file. Than simply:

1. Open ArcMap
2. Tools menu --> Add XY data --> open the sheet of the excel file --> define the x and the y field --> produce the point features

Good luck,
Svetoslav




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

-->