[OKGIS] Spreadsheet

[Frank, Irving]

Mike:
Great point - the best one I read yet on all of this!
Have a Great Day!
Irving Frank


-----Original Message-----
From: "mike.deming at okc.gov" <mike.deming at okc.gov>
To: "okgis at gis.gis.ou.edu" <okgis at gis.gis.ou.edu>
Sent: 1/31/08 8:32 AM
Subject: RE: [OKGIS] Spreadsheet

  
I would add one cautionary note-if you have other layers/shapefiles that
you are also showing on the map at the same time you need to be very
careful about defining coordinate systems/projections. If not you may
wind up with your highways and roadways in Oklahoma, but your oilwells
in East Egypt somewhere.
 
-----Original Message-----
From: okgis-bounces at gis.gis.ou.edu [mailto:okgis-bounces at gis.gis.ou.edu]
On Behalf Of Sheila Wilson
Sent: Thursday, January 31, 2008 8:11 AM
To: 'Oklahoma GIS Community'
Subject: RE: [OKGIS] Spreadsheet
 
KC,
 
Try these steps.  
 
*         If you haven't done this, first add the data as a table.  I
typically add it as a dbase IV table although this functionality is
going away.
*         After you've added the table, go to the Source tab (bottom),
right click and choose add x-y data; designate the correct columns to
spatially locate the information.
 
To create the attribute table, I recommend using the standard developed
by PPDM at http://www.ppdm.org/.  You will need to join the standards
organization in order to receive the data model.  The data model will
tell you what data is needed in what format.  It will also provide you
with appropriate constraints and relationships between different tables.
 
Sheila
 
 
Sheila Wilson, Ph.D.
Executive Director
PODS Association, Inc
 
www.pods.org <http://www.pods.org/> 
sheila.wilson at pods.org <mailto:sheila.wilson at pods.org> 
 
918-246-9343
866-460-7637
 
 
 
If everything could be different, what might have to remain unchanged?  
- F. W. Faller
 
The information contained in this communication may be confidential, is
intended only for the use of the recipient(s) named above, and may be
legally privileged. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution,
or copying of this communication, or any of its contents, is strictly
prohibited. If you have received this communication in error, please
return it to the sender immediately and delete the original message and
any copy of it from your computer system. If you have any questions
concerning this message, please contact the sender.
________________________________

From: okgis-bounces at gis.gis.ou.edu [mailto:okgis-bounces at gis.gis.ou.edu]
On Behalf Of Robert Stokes
Sent: Thursday, January 31, 2008 7:57 AM
To: Oklahoma GIS Community
Subject: RE: [OKGIS] Spreadsheet
 
Are you wanting to create a point shapefile out of the coordinate data
from a spreadsheet? ...sounds like you want to "Add XY Data" in
ArcMap...
 
p.s. One thing you will want to look very closely at is the actual
number of well records you are trying to put in an Excel spreadsheet. I
can't remember right of the top of my head, but from what I can remember
you are approaching the record limit for an Excel spreadsheet!
 
------------------------------------------------------
Robert Stokes
President, Topographic Mapping Company
 
OK GITA Chapter President
OK SCAUG Steering Committee
 
  <http://www.topographic.com/> 
 
From: okgis-bounces at gis.gis.ou.edu [mailto:okgis-bounces at gis.gis.ou.edu]
On Behalf Of K C Spain
Sent: Thursday, January 31, 2008 7:46 AM
To: Oklahoma GIS Community; GIS Users Forum
Subject: [OKGIS] Spreadsheet
 
OK, at this point I'm not quite sure what I'm trying to do yet, or at
least what it's called in order to look up instructions on how to do it.
I have exported a spreadsheet from Petra with my wells information in it
and I have it in Excel format (around 65,000 wells). It has 18 columns
in it, 2 of which are x y coordinates and 2 of which are lat long
coordinates. I am trying to somehow "join" or "connect" or somehow maybe
create an attribute table or something that also can read and show a
point in ArcMap for at least one set of those 2 coordinate types and be
able to choose what other columns are to be displayed on the map. What
am I trying to do? What is it called, and do you have any suggestions
that may help?
 
Thanks.........
 
 
K.C. Spain
Tech. Asst.
Stephens Production Co.
kcspain at stephenspro.com
ph.  (479) 783-4191 ext.206