Elipsoidal coordinat system to GAUSS-KRUGER (X, Y, Z) coordinate sytem?

[mucip]

Hi,

I have continious valuses from GPS receiver like below;

3701.72395192,N,03518.10692439,E

I need to input this values as X, Y, Z in AutoCAD Plain. Is there any VBA code or built in function to do this?

Regards,

Mucip:)

[Ed.Jobe]

If you use plain AutoCAD, there will be no coordinate system. Why not use the Map 3D toolset that comes with AutoCAD? You can probably just use the gps file as a data source and you won't need to enter any coordinates.

[mucip]

Hi,

Thanks for your kind interest.

First time I heard about "Map 3D toolset". Can I install it on Plain AutoCAD? How can I use it?

Regards,

Mucip:)

[Ed.Jobe · Accepted solution]

Go to your account at https://manage.autodesk.com and click on View Items next to your subscription for AutoCAD. That takes you to another screen that shows the different toolsets. You can install it from there.

Working with a GIS system means you first have to assign a coordinate system for your map. Then in the Task Pane, connect the map to a db source. You should be able to find a data provider for your file. This will bring in the points as a layer. You can have a base layer that displays streets, etc.

You can get more help on the Map 3D forum.

[mucip]

Dear @Ed.Jobe ,

OK. Thanks. I will check.

But I plan to read GPS tool from serial bluetooth port within Android. I search javacode to convert ENU value to XYZ inner Android. Than send it to server as XYZ.

And read XYZ values from server with VBA and put the points on the Plain Autocad.

Regards,

Mucip:)

[Ed.Jobe]

I'm sorry, but the earth is not flat, nor is it perfectly round. You can't use xyz of the cartesian coordinate system of plain AutoCAD. You need to use an elipsoidal coordinate system designed for your part of the earth.

Plain acad can use a lat/lon coordinate system the same as Google maps uses. Go to the Insert tab of the ribbon and on the far right, select Set Location>from file. Now you can select a kml file. To create this, insert your points into Google Earth and save the map as a KML file. Once you assign a map coordinate system, the ribbon will have a context sensitive GEOLOCATION tab. Here you can change the map to satellite or street view.

Once you have a MAP coordinate system assigned, it is possible to convert from one coord system to another. Map 3D can do this automatically.

Out of curiosity, what file extension does your gps device use?

[mucip]

Dear @Ed.Jobe ,

We use "SOUTH Galaxy G6 GPS" GNSS receiver and this receiver gives below data continiously on Bluetooth.

From this page I learned that the line which is start with GNGGA (bold lines) is the main information about coordinates. But as you see it is ENU (East/North/Up) format. I need to translate it in XYZ format to create points in AutoCAD.

All the problems comes from here. 🙂

I plan to use the Java code here in Android Studio. But I don't know if it is a correct formula to do this convertion?

***

$PSIC,BSI,135323.00,3702.2557731,N,03518.8388987,E,135.4240,4,0,1624*5B
$PSIC,AAT,3,26.77,78.91,148.73,26.77,-78.91,0.00,1.47,7872,0.10,787.20,0,0,0*4B
$GNGGA,135506.00,3702.24148588,N,03518.85508883,E,5,06,3.8,82.640,M,28.688,M,1.0,1624*61
$GNGST,135506.00,10.661,2.241,0.568,178.2,2.240,0.572,1.620*7E
$GNZDA,135506.01,31,08,2021,00,00*76
$GNGSA,A,3,4,3,19,9,,,,,,,,,4.2,3.8,1.8*1E
$GNGSA,A,3,71,72,,,,,,,,,,,4.2,3.8,1.8*2B
$PSIC,PST,20210831,135507.00,3702.24148588,N,03518.85508883,E,52,6,4.22,3.81,1.81,-0.0001,2.2481,0.5738,1.6253,111.3279,0.0000,1.00,1624*53
$PSIC,AAT,3,26.69,78.88,148.82,26.69,-78.88,0.00,1.47,7872,0.10,787.20,0,0,0*45
$PSIC,STA,SG6068117188105,INTERNAL,70,50.5,54.0,ROM,7441.0,7418.0,,,0,0,*3C
$PSIC,DAL,CELLULAR_NET,0,8,HSDPA,1,1,2,4,31.140.171.246,0,0*12
$PSIC,AAT,3,26.67,78.87,148.88,26.67,-78.87,0.00,1.46,7872,0.10,787.20,0,0,0*4E
$PSIC,AAT,3,26.72,78.87,148.95,26.72,-78.87,0.00,1.48,7872,0.10,787.20,0,0,0*4C
$PSIC,AAT,3,26.75,78.90,148.95,26.75,-78.90,0.00,1.46,7872,0.10,787.20,0,0,0*42
$PSIC,AAT,3,26.84,78.93,148.95,26.84,-78.93,0.00,1.46,7872,0.10,787.20,0,0,0*42
$PSIC,PST,20210831,135508.00,3702.24148044,N,03518.85509516,E,52,5,4.28,3.81,1.94,-0.0001,2.2251,0.5679,1.5861,111.3042,0.0000,1.00,1624*59
$PSIC,DAL,CELLULAR_NET,0,8,HSDPA,1,1,2,4,31.140.171.246,0,0*12
$GNGGA,135507.00,3702.24148044,N,03518.85509516,E,5,05,3.8,82.617,M,28.688,M,1.0,1624*64
$GNGST,135507.00,10.739,2.219,0.559,177.7,2.217,0.566,1.580*78
$GNZDA,135507.01,31,08,2021,00,00*77
$GNGSA,A,3,3,19,9,,,,,,,,,,4.3,3.8,1.9*2A
$GNGSA,A,3,71,72,,,,,,,,,,,4.3,3.8,1.9*2B
$PSIC,AAT,3,26.92,78.94,148.96,26.92,-78.94,0.00,1.47,7872,0.10,787.20,0,0,0*40

***

Regards,

Mucip:)