[CONNECT] Import Coordinates (Latitude, Longitude) with text Labels

I have a .txt file with
-Latitude and Longitude points (degrees. minutes,seconds)
-text information associated with those coords ie: (start, wpt1, wpt2, mid point, station1...)


I want to place Cells using Latitude and Longitude.
I also want the text information displayed next to those waypoints.


I figured out how to create a .txt file and use "key-in" to place the Lat and long points in one step.  (Deg,Mins,Seconds converted to Deg.xxxx
Is there a way to add the text information associated with each of those points/cells.

I have been looking in the forum and can only information in regards to "import Coordinates", but that uses XYZ.
Using this import places the obstacles in the wrong location

...

Parents
  • The import coordinates tool has TXYZ as well but  only one text column  so you would need to edit your csv file on the fly  to change the T column .. what I do is  have  my csv in excel ( easier than txt files) as T1 X Y Z  T2 T3 T4 T5, and  run it  then set new active level called T2 text, swap order so T2 is first, then run it again and  select all T2 level and shift them all down one text height below T1, then repeat for T3 etc  be careful the text import doesnt  like many symbols or punctuation symbols .. also I prefer  to use left centre text justification seems to work better for the text import ( BTW objects is better word in english than obstacles.)

    Once you done it a few times  it gets easier... then when finished  you can select all the text and make it all in one level or leave it for ease of turning on or off..

    I have in the past found this method best for multi line text  by import  move method rather than working out the shift in xy 

    Now if you must have  it all in one line separated by a comma  then try using an odd character or Letter   like $ or Q  instead so it looks like StartQWPIQWP2Q

    Then when your done use the find replace Q  with space comma .. This works as just one import but you still have to select all the text and  shift them off the cells ...( better than calculating the shift as your csv file the same  one can be still used to place the cells via xyz just move the T to after the z column

    Test first with small sample say 5 lines or coordinates.

    As I said mstn import doesn't like punctuation characters so trial and error for  5 lines first pays off in the end. 

    oh and most important  NO headings in your csv (excel) file

    This topic has been posted before and  I think it listed exactly what text  etc microstation didn't like... but trial and error for small sample will reveal this..

    Lorys

    Started msnt work 1990 - Retired  Nov 2022 ( oh boy am I old )

    But was long time user V8iss10 (8.11.09.919) dabbler CE  update 16 (10.16.00.80) 

    MicroStation user since 1990 Melbourne Australia.
    click link to PM me 

Reply
  • The import coordinates tool has TXYZ as well but  only one text column  so you would need to edit your csv file on the fly  to change the T column .. what I do is  have  my csv in excel ( easier than txt files) as T1 X Y Z  T2 T3 T4 T5, and  run it  then set new active level called T2 text, swap order so T2 is first, then run it again and  select all T2 level and shift them all down one text height below T1, then repeat for T3 etc  be careful the text import doesnt  like many symbols or punctuation symbols .. also I prefer  to use left centre text justification seems to work better for the text import ( BTW objects is better word in english than obstacles.)

    Once you done it a few times  it gets easier... then when finished  you can select all the text and make it all in one level or leave it for ease of turning on or off..

    I have in the past found this method best for multi line text  by import  move method rather than working out the shift in xy 

    Now if you must have  it all in one line separated by a comma  then try using an odd character or Letter   like $ or Q  instead so it looks like StartQWPIQWP2Q

    Then when your done use the find replace Q  with space comma .. This works as just one import but you still have to select all the text and  shift them off the cells ...( better than calculating the shift as your csv file the same  one can be still used to place the cells via xyz just move the T to after the z column

    Test first with small sample say 5 lines or coordinates.

    As I said mstn import doesn't like punctuation characters so trial and error for  5 lines first pays off in the end. 

    oh and most important  NO headings in your csv (excel) file

    This topic has been posted before and  I think it listed exactly what text  etc microstation didn't like... but trial and error for small sample will reveal this..

    Lorys

    Started msnt work 1990 - Retired  Nov 2022 ( oh boy am I old )

    But was long time user V8iss10 (8.11.09.919) dabbler CE  update 16 (10.16.00.80) 

    MicroStation user since 1990 Melbourne Australia.
    click link to PM me 

Children
  • Thank you,

    The Import coordinates tool was useful in importing the text. I did however incorporate a few more steps to get them in the right location

    I am working with a geographic coordinate system : NAD83

    my coordinates are express as

    N51:06:54.4352  W071:45:30.4352  (Degrees,minutes,seconds)  which I then convert into  -71.7584,51.9151. (degrees) (This is still W° and N°)

    If I use the "import coords' tool, it places the point at  X= -71.7584 Y=51.9151    this is not the same location as  N51:06:54.4352  W071:45:30.4352.

    Is there a way to change the 'import coordinate" tool to import using the Geographic coordinate system I am using?

    I found this work around

    I place all my cells using the key-in @c:\folder location\xx.txt

    .txt file

    place cell

    point acsabsolute  -71.7584,51.9151;

    ...

    ...

    reset

     

    this will place my cells (obstacles/objects in the right location)  

    I then use the "export coordinate" tool with TXYZ

    this exports all my cells and coverts the W° N° into the correct X,Y location.

    I then edit this exported file in excel and change all the "T" with my text column, I then import this file back into microstation with the TXYZ.  Thanks.

    one thing that did concern me when exporting, would microstation keep the order in which the obstacles were placed.

    It seems it does.    Obstacle 1,2,3,4,....when placed is still in the correct order 1,2,3,4,.....when exported, but that is something too keep an eye on and cross check.

    Maybe there's a better way to do this? please share,  is there a key-in to import text from .txt, .csv.. with the W°, N° coords?

    Stephane

  • If I use the "import coords' tool, it places the point at  X= -71.7584 Y=51.9151    this is not the same location as  N51:06:54.4352  W071:45:30.4352.

    I think the import coordinates is expecting  meters  ... I  think we must  use long lat  as degrees units  .. but as Rod suggested  the Auxillary coord system can use Lat , long  ( x,y) .. but Doesnt  the GCS datum when set to long lat  say its changing the units from meters...?

    I've not struck this before... as usually I have it   UCM Eastings and Northings and  just use the reproject feature via  using it in a ref file  to get it  to long  lat ( and I have seen a noticeable distortion or narrowing  as you go further south) ... what GCS datum did you set it to use?

    when I started with a new file in meters no datum in meters, then I select GCS as not projected to get the NAD83 in long lat  microstation asks me to let it change the units to degrees.( when I later checked the design units they are now in degrees) ..  then if the lat long in degrees from xyz tools should work?

    Have you any survey data that you can xref  to check a coordinate from the xref reprojected into the active long lat file?

    Lorys

    Started msnt work 1990 - Retired  Nov 2022 ( oh boy am I old )

    But was long time user V8iss10 (8.11.09.919) dabbler CE  update 16 (10.16.00.80) 

    MicroStation user since 1990 Melbourne Australia.
    click link to PM me 

  • I found it easier to set-up a clean file with the LL83 GCS, set the unit format how I liked it and simply use that file for all ins and outs, referencing to and from my project file using Geographic-Reprojected. The only drawback is graphics distort, easily corrected.

    Connect r17 10.17.2.61 self-employed-Unpaid Beta tester for Bentley