Geolocation Position Marker Data Export

[neil.stapley]

Is there are way to extract the data associated with the Geoposition Marker? I tried using dataextaction but the output just groups all the positions into a single line and doesn't show any of the data associated with each one (XY etc)

My goal is to take a list of GPS Cootdinates I have for the inlet and outlets of culverts and place them into the drawing and then have cad place a polyline between them. So I am trying to get the XY's from the geoposition markers as the first step. 

[Pointdump]

Hi Neil,
Use MAPIMPORT to bring your list of GPS coords into Map 3D and then draw lines between the points.
Dave

[ChicagoLooper]

hI @neil.stapley 

Unfortunately the phrase Geolocation Position Marker can mean different things to different users. Would it be possible to upload a screenshot of the 'entity' you refer to as Geolocation Position Marker?

If it's an object, please include the both geomarker and the Properties Palette in the screenshot, that way the geomarker itself can be diagnosed. Make sure the object is selected so its properties is displayed in the Props Palette.

If the geomarker you refer to is part a sequence of steps you perform as part of a Cad operation, please capture a screenshot of the step(s) where you wish to extract the geomarker's poosition.

Your uploaded pictures will go a long way when developing a workflow to resolve your issue.

[ChicagoLooper]

@neil.stapley 

<<...My goal is to take a list of GPS Cootdinates I have for the inlet and outlets of culverts...>>

Inlets and outlets, are you developing infrastructure? If you are, I don't think Map3D is the program you ought to be running. If you're performing geospatial analysis then Map3D is the right choice (if you want to stay within the AutoCAD family). On the other hand, if you're designing a storm sewer, then Civil3D is the program for the job, especially if you'll be collaborating with the trades.

Instead of using a geolocation marker in M3D, you should locate all your inlets and outlets using a Civil3D cogo point. (Cogo=coordinate geometry.) Once your cogo points are established, you can easily connect them using Create Line by Point # Range.

Since cogos are numbered, your line will be drawn sequentially, from a start point to end point. You can choose whatever starting and ending numbers you want. Here's a video that demonstrates the procedure. (The video demonstrates how to draw a line from cogo point-to-cogo point.  It assumes you already have inserted your cogos.) 

[neil.stapley]

This doesn't really help me if all I can use is Map3D. I just need a way to extract the XY positions of the geomarkers in the drawing so write a lisp to place the lines.

[Pointdump]

Neil,
Please post your drawing so we can see what you have.
Dave

[neil.stapley]

Here you go

[fieldguy]

Did you try unchecking the "Combine identical rows" box on dataextraction Page 5?

[neil.stapley]

I did and no cigar. the XYs are not something that was extracted neither was the text in the label

[ChicagoLooper]

Hi @neil.stapley 

There are two (2) things you fail to understand about your Workflow:

1. If you want separate rows when executing the DATAEXTRACTION command you must uncheck the box below.

 

2. The DATAEXTRACTION command does not support the extraction of Text contents or Location parameters from the object known as a geolocation Position Marker. 

I know that's not what you want to hear but that's a reality given your issue. You'll need to find another way to acquire the Lat/longs. 

OPTION 1:

For example, you can utilize an alternate method that ACCEPTS Lat/Long as the input. I'm assuming you already have a LIST of Lat/Longs and you used that list to insert the points in your drawing. For example, your list may have a format such as xlsx, csv, or txt. Map3D can easily insert a list of points expressed in Lat/Long degrees using the Map3D toolset and without lisp. Use MAPIMPORT command and supply M3D with your xlsx, csv, or txt.

OPTION 2:

If you don't have an existing list then you can manually create one from the 'information' that exists in each individual geomarker. The information in Post #4 was not provided to irritate or challenge you, it is merely 'jumping ahead' to an alternate method. I assumed you'd be fair enough to consider it a viable solution. If alternate methods are not your style then I think your problems with AutoCAD go beyond simply inserting and extracting the points. Once you've created your LIST you can 'feed it' to M3D. 

NOTE:

Whatever alternate method you use, you'll need to format you list in an acceptable format, including but not limited to, PNEZD, PENZD.

[fieldguy · Accepted solution]

ok - that doesn't work.  You could attach that drawing to an empty dwg and use Report Query.

Define query

Click on Options.

Query def looks like this

[Pointdump]

Hi Bevan,
Good one!
Dave

[neil.stapley]

Thank you so much

[ChicagoLooper]

@neil.stapley 

Based on drawing uploaded in post #7.....

Inserting all those geomarkers must have been time consuming. Now you’re trying to extract the GPS coordinates. Does that mean State Plane X/Y’s in feet? Or Lat/Longs in degrees? If you want X/Y/s in feet, then a block would’ve been easy to insert and easier, waaay easier, to leverage any accompanying data.

As you already know, blocks are DataExtraction friendly, geomarkers are not. Simply insert the blocks then use DataExtraction to pull the data out. If your block has attributes, such as inflow/outflow, pipe ID, and type, you can add those attributes then harvest that data during the dataextraction operation.

If you insert your blocks into a State Plane, Feet and want to pull out the Lat/Long degrees you can do that using blocks too. Here are instructions with pictures showing how:

1. Insert your blocks into a drawing with a properly assigned coordinate system, e.g. NC83F. The fastest way is to insert using a file. You may also insert them manually using your mouse. <<Create a new layer named CMP making sure all blocks so they land on this CMP layer.>> See image-1.

Image-1

2. Perform DataExtraction on the blocks. Then take this newly extracted list and arrange the columns to PNEZD or PENZD. Give this new data file a NEW name and save to your project folder in csv format. All design work like this should incorporate a UNIQUE identifier so add an additional column for Point Number. Now's a good time to fill in description, not during insertion!! The elevation can be filled in when data becomes available. For now, the Elev column is a 'placeholder' for future data. All odd point no.s are inlets. All even no.s are outlets. With creativity, the layer hosting the point can be used to denote the pipe material. See image-2.

Image-2

3. Open a brand new, clean drawing and assign NAD83 LL83, EPSG 4269. Next, use MAPIMPORT command and import the csv you saved in the previous step. Make sure you place these imported points on a dedicated layer named CMP, that way if you export to shapefile (or perform dataextraction) you can leverage the Layer name and it'll correspond to pipe material (type). See image-3.

See image-3.

4. Map3D will insert generic blocks. They’ll be very big. Select all the blocks and reduce their size. See image-4.Image-4

5. Next, perform DataExtraction on the blocks. This time, the coordinates in your extraction output will be in NAD83 LL degrees, not feet. If you wish, fill in column F with CMP, the pipe material. See image-5.

Image-5

6. (Optional) You may use MapImport to insert and view the points on this new list. Since your coordinates are Lat/Long, your import settings must look like this. See image-6.

 Image-6

7. (Also Optional) In the Properties Palette, the newly inserted blocks will display X as Long and Y as Lat, easting and northing respectively. Long is always negative in North America and Lat is always positive north of the equator. See image-7.Image-7

Notes:

• You may use a non-attributed block but you might be limited in what you can extract. Attributed blocks are definitely better.
• When saving an extracted list to csv, there are several csv formats. Select the one named CSV(comma delimited) (*.csv). Not all csv extensions are 'readable' when performing MapImport in Acad.
• When using MapImport command to insert points from a file, the imported points will land on the current layer. Make the target layer your current layer before importing.
• Give each row in your point list a unique identifier. In the exercise above, integers were used because alpha and special characters are not allowed.
• The OP’s uploaded drawing had 30 total points. At MP-090-2610 there were duplicates, two inlets and two outlets. If you delete the duplicates, the number of points drop from 30 down to 28.   
• All odd point numbers are inlets, all even points are outlets. You may, or may not, enter 1 and 0 in the elevation column to denote inlets and outlet. Or you may enter the ground elevation when it becomes available. Water will always flow downhill so the elevation at the bottom of swale will dictate which end is inflow and which is outflow.
• If you name a new column FLOW, Excel has an easy 'double-click command' that'll populate the column with either In or Out.