Thank you all for your input; it is much appreciated. Here's an update on
the solution. I did run a SQL Select query with the synax in the "Select
Columns" section of;
_COL2 , _COL3 , CentroidX ( obj ) , CentroidY ( obj ) , _COL4
This gave me the following table where _COL2 = US State Plane SC 83 Northing
feet, _COL3 = US State Plane SC 83 Easting feet, and _COL4 = depth in feet.
_COL2 _COL3 CentroidX(Object) CentroidY(Object) _COL4
278,149.77 2,269,873.76 -80.1237 32.5946 -5.9
278,139.94 2,269,826.74 -80.1239 32.5946 -4.7
278,140.84 2,269,824.02 -80.1239 32.5946 -4.4
278,141.51 2,269,821.20 -80.1239 32.5946 -4.2
278,141.76 2,269,818.44 -80.1239 32.5946 -3.8
0.00 0.00 -80.1244 32.5951 0.0
0.00 0.00 -80.1244 32.5951 0.0
0.00 0.00 -80.1245 32.5951 0.0
The 0.00s in _COL2 and _COL3 are the digitized points of the pond edge that
previously did not have coordinates associated with them.
I was initially concerned because the CentroidX(Object) and
CentroidY(Object) coordinates seemed to display a lower level of accuracy
with only 4 decimal places but once the query was exported in a dbf format,
6 decimal places were displayed.
I was not able to find a way to have the CentroidX(Object) and
CentroidY(Object) export in the native coordinate system which was a little
frustrating and bothersome from the standpoint of providing metadata. How
do you say that your lat/lon data is in US State Plane South Carolina 3900
(1983,feet)? Can that really work for someone importing the data?
I found a way around that was Woody Woodruff's suggestion of exporting the
.mid/.mif files. That ended up being a multi-step process though because
you have to strip the headers out of the .mif file and replace a set of
'returns' with 'tabs' using Word, then save it as a text file and open it in
Excel. Then you have to open the .mid file in Excel and copy and paste the
data that correlates with the objects. This is functional if all your
digitized data is at the end of the file. If you've added data somewhere in
the middle of 4000-5000 lines of data, it can get a bit tricky.
I tried to find the 'Coordinate Extractor' in the 'Downloads' section and
came up with a 'xyz Extractor'. It's not a .mbx but an actual .exe file and
I could never get it to work with my files. It worked with the digitized
pond edge point file but not the combined pond edge/bottom data point file.
Documentation was pretty scant so I gave up.
I didn't have time to try the Register Vector Utility. It was not in my
Tool Manager and I wasn't up for another search and download.
So, again, thanks. Figuring this out has been on my "to do" list for a
while. I knew somebody would have a solution to it.
------------------------------------------------
Norm Shea
Director, Lakes Management
Kiawah Island Community Association
20 Kestrel Court
Kiawah Island, SC 29455-5657
843-768-2315 office
843-768-0298 fax
843-708-3608 mobile
[EMAIL PROTECTED]
Confidentiality Notice:
This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential and/or legally privileged
information. If you are not the intended recipient, please contact the
sender by reply e-mail and destroy all copies of the original message. Any
unauthorized review, use, disclosure, or distribution is prohibited.
> Does anyone know of a tool that will assign coordinates to points. I have
> some bottom mapping coordinates for the water section of a pond but had to
> digitize that pond edge from a ortho and assign it a depth of 0. I then
> combined the two to create my pond. I would like to export the points but
> the digitized pond edge does not include the coordinates. Is there a tool
> that will assign the coordinates to these points?
>
> ------------------------------------------------
> Norm Shea
> Director, Lakes Management
> Kiawah Island Community Association
> 20 Kestrel Court
> Kiawah Island, SC 29455-5657
> 843-768-2315 office
> 843-768-0298 fax
> 843-708-3608 mobile
> [EMAIL PROTECTED]
>
> Confidentiality Notice:
> This e-mail message, including any attachments, is for the sole use of the
> intended recipient(s) and may contain confidential and/or legally privileged
> information. If you are not the intended recipient, please contact the
> sender by reply e-mail and destroy all copies of the original message. Any
> unauthorized review, use, disclosure, or distribution is prohibited.
>
>
> ---------------------------------------------------------------------
> List hosting provided by Directions Magazine | www.directionsmag.com |
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> Message number: 16820
>
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 16835
