<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>Can anybody help me if there is an easy way to export (as a
spreadsheet) the spatial coordinates of a points shapefile from
ArcView?</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>What I want is three columns output:</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Point ID, Latitude (DD or DMS), Longitude (DD or DMS)
if shapefile is in geographic coordinates/projection</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Point ID, Easting (metres), Northings (metres)
if shapefile is in local projection/datum, etc.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>This information is required to assist field teams when using
a GPS to locate corresponding ground points.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Also, is there an easy formula or a worksheet to quickly
convert above DD coordinates to DMS?</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Bush</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>PS. I tried an extension that converts point shapefile to dxf
and then edited the dxf file as a text file to find all the coordinates but it
takes too long if there are too many points. Also I had to manually convert DDs
to DMS...</FONT></DIV></BODY></HTML>