Import Latitude-Longitude coordinates as points

[demus72]

I am certain I am beating a dead horse, I apologize.

I have a list of 23 latitude longitude coordinates that were collected out in the field. I am desperately trying to import them from a comma delimited txt file as points into my state plane drawing. I've set up a point file format with Coordinate zone transform checked and entered the Zone. I used Point Number, Latitude, Longitude, and full description for columns. I've loaded the txt file and parsed it, it appears to work fine.

In my state plane drawing, I import points from file, select my txt file, it automatically selects the point file format I created, I checked Do coordinate transformation if possible and hit ok. It creates points but nowhere near my location. Do I not need to specify a Coordinate zone transformation in the point file format? Do I not need to check Do coordinate transformation if possible? I'm sure I've tried both in my panic but just can't get them to come in in the correct location.

Thanks for you help.

[demus72]

I am certain I am beating a dead horse, I apologize.

I have a list of 23 latitude longitude coordinates that were collected out in the field. I am desperately trying to import them from a comma delimited txt file as points into my state plane drawing. I've set up a point file format with Coordinate zone transform checked and entered the Zone. I used Point Number, Latitude, Longitude, and full description for columns. I've loaded the txt file and parsed it, it appears to work fine.

In my state plane drawing, I import points from file, select my txt file, it automatically selects the point file format I created, I checked Do coordinate transformation if possible and hit ok. It creates points but nowhere near my location. Do I not need to specify a Coordinate zone transformation in the point file format? Do I not need to check Do coordinate transformation if possible? I'm sure I've tried both in my panic but just can't get them to come in in the correct location.

Thanks for you help.

[Pointdump]

N,

Post your text file of lats and longs. There's a few subtleties with geographic coords.

Dave

[Pointdump]

N,

Post your text file of lats and longs. There's a few subtleties with geographic coords.

Dave

[demus72]

Attached is my txt file.

Thank you.

[demus72]

Attached is my txt file.

Thank you.

[Pointdump · Accepted solution]

N,

OK, so it looks like your coordinates are in Degrees and Decimal Minutes. That degree symbol is the fly-in-the-ointment. Replace that with a comma and then set up your Point File Format thusly:

Drawing with "P_DM_DM_Desc" Point File Format attached. Don't forget to do the "transform if possible" on import.

Dave

[Pointdump · Accepted solution]

N,

OK, so it looks like your coordinates are in Degrees and Decimal Minutes. That degree symbol is the fly-in-the-ointment. Replace that with a comma and then set up your Point File Format thusly:

Drawing with "P_DM_DM_Desc" Point File Format attached. Don't forget to do the "transform if possible" on import.

Dave

[Pointdump · Accepted solution]

N,

I just noticed something. You'll want to change the Longitude Degrees to minus, otherwise you'll place those points in Mongolia.

Dave

[Pointdump · Accepted solution]

N,

I just noticed something. You'll want to change the Longitude Degrees to minus, otherwise you'll place those points in Mongolia.

Dave

[Pointdump · Accepted solution]

N,

I imported your points into a Montana State Plane Coordinate System (HARN/MT.MTIF) and those GPS'ed points seem to follow the Concrete Ditch.

Drawing attached.

Dave

[Pointdump · Accepted solution]

N,

I imported your points into a Montana State Plane Coordinate System (HARN/MT.MTIF) and those GPS'ed points seem to follow the Concrete Ditch.

Drawing attached.

Dave

[demus72]

Dave,

Thank you very much! I modified my txt file and my point file format following your proven recommendations, then imported the point and JACKPOT!

I tried just about every combination possible but no matter what I did, I couldn't make it work.

Thanks again for taking the time to share your knowledge, very much appreciated!

Nick

[demus72]

Dave,

Thank you very much! I modified my txt file and my point file format following your proven recommendations, then imported the point and JACKPOT!

I tried just about every combination possible but no matter what I did, I couldn't make it work.

Thanks again for taking the time to share your knowledge, very much appreciated!

Nick

[CADmgrMike]

I'm having the same issue. I need to import some Lat Long points. I created a new file format, but the first column won't parse correctly. I attached a sample csv file.

[CADmgrMike]

I'm having the same issue. I need to import some Lat Long points. I created a new file format, but the first column won't parse correctly. I attached a sample csv file.

[Pointdump]

Mike,

Your CSV file is in UTF-8 format. In Excel, save as regular plain old CSV format. Then all is good.

Dave

[Pointdump]

Mike,

Your CSV file is in UTF-8 format. In Excel, save as regular plain old CSV format. Then all is good.

Dave

[Pointdump]

Mike,
Or option #2 would be to use Notepad to save as a .txt file in ANSI format:

Dave

[Pointdump]

Mike,
Or option #2 would be to use Notepad to save as a .txt file in ANSI format:

Dave

[CADmgrMike]

@Pointdump  Thanks. I didn't catch that.

[CADmgrMike]

@Pointdump  Thanks. I didn't catch that.

[CADmgrMike]

@Pointdump , ok. I saved as txt file and got C3D to recognize the file, but the point file format still giving me the message that it doesn't match.

What am I missing? (test file attached)

[CADmgrMike]

@Pointdump , ok. I saved as txt file and got C3D to recognize the file, but the point file format still giving me the message that it doesn't match.

What am I missing? (test file attached)

[Pointdump]

Mike,

In your Point File Format use DECDEG Latitude and DECDEG Longitude. Latitude and Longitude are DD.MMSSssss format.

Dave

[Pointdump]

Mike,

In your Point File Format use DECDEG Latitude and DECDEG Longitude. Latitude and Longitude are DD.MMSSssss format.

Dave

[CADmgrMike]

@Pointdump  U da man! Thanks. 🙂

[CADmgrMike]

@Pointdump  U da man! Thanks. 🙂