Jump to content

 
Photo

Import help

- - - - -

  • Please log in to reply
13 replies to this topic

#1
Nick Springer

Nick Springer

    CartoTalk Founder Emeritus

  • Moderator
  • PipPipPipPipPipPip
  • 939 posts
  • Gender:Male
  • Location:Crosswicks, NJ
  • Interests:Cartographic Design, Print Maps, Graphic Design, Web Development, Ultimate Frisbee
  • United States

A client gave me an Excel spreadsheet (attached) with line segments as 2 lat/long pairs on each line with a name for each segment. I can't figure out how I would import this into Manifold. I don't care if I end up with a bucnh of individual line segments as I can concatenate them in Illy.

Any help?

Attached File  FSRR_Map_data.zip   30.27KB   101 downloads

Nick Springer

Director of Design and Web Applications: ALK Technologies Inc.
Owner: Springer Cartographics LLC


#2
paul

paul

    Key Contributor

  • Validated Member
  • PipPipPip
  • 75 posts
  • Location:Logan, UT
  • Interests:Running, telemark skiing, GIS
  • United States

Try importing the lat/long points into Manifold how you normally would, and then using the ScriptSequentialLines script found on Manifold's free stuff page:

http://www.manifold..../freestuff.html

This will join all the points into a line.

#3
Martin Gamache

Martin Gamache

    Ultimate Contributor

  • Associate Admin
  • PipPipPipPipPipPip
  • 980 posts
  • Gender:Male
  • Location:Washington DC
  • Interests:History of Topographic Cartography
    Topographic Mapping
    History of Relief Depiction
    Thematic Cartography
    Demographic Cartography
    Cartographic techniques, methods, and tools
    Orienteering
    Panoramic & Kite Photography
  • United States

Import as points and then use the relative neighborhood network or Spanning tree transform.

#4
Nick Springer

Nick Springer

    CartoTalk Founder Emeritus

  • Moderator
  • PipPipPipPipPipPip
  • 939 posts
  • Gender:Male
  • Location:Crosswicks, NJ
  • Interests:Cartographic Design, Print Maps, Graphic Design, Web Development, Ultimate Frisbee
  • United States

The problem is the rows have 2 points on each line so importing as points only picks up the first node of the segment.

Nick Springer

Director of Design and Web Applications: ALK Technologies Inc.
Owner: Springer Cartographics LLC


#5
frax

frax

    Hall of Fame

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

if that is the problem, then it is not too hard, just cut & paste the data so that it is in one space? see attachment...

Attached Files


Hugo Ahlenius
Nordpil - custom maps and GIS
http://nordpil.com/
Twitter

#6
Nick Springer

Nick Springer

    CartoTalk Founder Emeritus

  • Moderator
  • PipPipPipPipPipPip
  • 939 posts
  • Gender:Male
  • Location:Crosswicks, NJ
  • Interests:Cartographic Design, Print Maps, Graphic Design, Web Development, Ultimate Frisbee
  • United States

Sorry, neither Paul of Martin's solutions worked because it can't pass the attributes from the points to the lines.

Any other ideas?

Nick Springer

Director of Design and Web Applications: ALK Technologies Inc.
Owner: Springer Cartographics LLC


#7
Martin Gamache

Martin Gamache

    Ultimate Contributor

  • Associate Admin
  • PipPipPipPipPipPip
  • 980 posts
  • Gender:Male
  • Location:Washington DC
  • Interests:History of Topographic Cartography
    Topographic Mapping
    History of Relief Depiction
    Thematic Cartography
    Demographic Cartography
    Cartographic techniques, methods, and tools
    Orienteering
    Panoramic & Kite Photography
  • United States

You can probably pass the attributes by buffering the points, and then intersecting the lines with the buffers?

How many points.

mg

#8
Hans van der Maarel

Hans van der Maarel

    CartoTalk Editor-in-Chief

  • Admin
  • PipPipPipPipPipPipPip
  • 3,836 posts
  • Gender:Male
  • Location:The Netherlands
  • Interests:Cartography, GIS, history, popular science, music.
  • Netherlands

FME to the rescue :) 3 transformers:
- 2DPointReplacer, replaces the geometry-less feature read from the Excel file with a 2D point, coordinates lat1, long1.
- 2DPointAdder, adds a 2D point to every feature (lat2, long2)
- LineJoiner, joins line segments that have the rail service attribute in common.

Total time spent in putting it together: 5 minutes.
Hans van der Maarel - Cartotalk Editor
Red Geographics
Email: hans@redgeographics.com / Twitter: @redgeographics

#9
Nick Springer

Nick Springer

    CartoTalk Founder Emeritus

  • Moderator
  • PipPipPipPipPipPip
  • 939 posts
  • Gender:Male
  • Location:Crosswicks, NJ
  • Interests:Cartographic Design, Print Maps, Graphic Design, Web Development, Ultimate Frisbee
  • United States

Excellent Hans! ...except I don't have FME :)

Nick Springer

Director of Design and Web Applications: ALK Technologies Inc.
Owner: Springer Cartographics LLC


#10
GISRox

GISRox

    Master Contributor

  • Validated Member
  • PipPipPipPip
  • 104 posts
  • Gender:Male
  • Interests:Outdoors, maps, travel.
  • United States

If you don't mind doing a little editing with notepad or another text editor, I'd suggest creating a BNA file. It looks like Manifold can import this format.

Here is a link to the basic specs.

http://www.softwrigh...bna_format.html



#11
Hans van der Maarel

Hans van der Maarel

    CartoTalk Editor-in-Chief

  • Admin
  • PipPipPipPipPipPipPip
  • 3,836 posts
  • Gender:Male
  • Location:The Netherlands
  • Interests:Cartography, GIS, history, popular science, music.
  • Netherlands

Excellent Hans! ...except I don't have FME :)

<{POST_SNAPBACK}>


That's why I emailed the result to your gmail addy... ;)
Hans van der Maarel - Cartotalk Editor
Red Geographics
Email: hans@redgeographics.com / Twitter: @redgeographics

#12
Nick Springer

Nick Springer

    CartoTalk Founder Emeritus

  • Moderator
  • PipPipPipPipPipPip
  • 939 posts
  • Gender:Male
  • Location:Crosswicks, NJ
  • Interests:Cartographic Design, Print Maps, Graphic Design, Web Development, Ultimate Frisbee
  • United States

Thanks Hans, guess I should check my email more often :P

Nick Springer

Director of Design and Web Applications: ALK Technologies Inc.
Owner: Springer Cartographics LLC


#13
Nick Springer

Nick Springer

    CartoTalk Founder Emeritus

  • Moderator
  • PipPipPipPipPipPip
  • 939 posts
  • Gender:Male
  • Location:Crosswicks, NJ
  • Interests:Cartographic Design, Print Maps, Graphic Design, Web Development, Ultimate Frisbee
  • United States

If you don't mind doing a little editing with notepad or another text editor, I'd suggest creating a BNA file.  It looks like Manifold can import this format.

Here is a link to the basic specs.

http://www.softwrigh...bna_format.html

<{POST_SNAPBACK}>

I had thought about making it a MIF/MID which is similar, but I don't know where the lines begin and end in the Excel document.

Thanks for the help though Paul and Martin.

Nick Springer

Director of Design and Web Applications: ALK Technologies Inc.
Owner: Springer Cartographics LLC


#14
frax

frax

    Hall of Fame

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

Does Mainfold support MOSS or ArcInfo generate files?
Hugo Ahlenius
Nordpil - custom maps and GIS
http://nordpil.com/
Twitter




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

-->