[Freegis-list] Re: ArcView - Exporting spatial data

[Bruce Dodson]

If you mean ArcView 3.x, the free extension AVPython can be
used to access Excel from within ArcView.  Then a very
simple script could load the geometry and IDs into a
spreadsheet.  http://avpython.sourceforge.net

In ArcView 8.x, the same could be done using VBA instead of
Python to control Excel, and again VBA (instead of Avenue)
to access the shapefiles.

----- Original Message ----- 
From: Ahmed
Newsgroups: gmane.comp.gis.freegis
Cc: Dean Howell ; Anthony O'Flaherty
Sent: Monday, August 18, 2003 9:16 PM
Subject: ArcView - Exporting spatial data


Can anybody help me if there is an easy way to export (as a
spreadsheet) the spatial coordinates of a points shapefile
from ArcView?

What I want is three columns output:

Point ID, Latitude (DD or DMS), Longitude (DD or DMS) if
shapefile is in geographic coordinates/projection

Point ID, Easting (metres), Northings (metres) if shapefile
is in local projection/datum, etc.

This information is required to assist field teams when
using a GPS to locate corresponding ground points.

Also, is there an easy formula or a worksheet to quickly
convert above DD coordinates to DMS?

Bush

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...



_______________________________________________
Freegis-list mailing list
Freegis-list at intevation.de
https://intevation.de/mailman/listinfo/freegis-list