[OKGIS] Is there a way

[Sheila Wilson]

Nick,

 

When I had this problem, I did a "mass update" within the database to change
the wrong names to the correct names.  In the long run, the decision to
correct the names was the right choice but the correction took a while.  To
prevent the problem in the future, you might consider a code lookup in which
users must choose the correct company name.  The code lookup isn't
appropriate for all situations but does increase the integrity of the
database.

 

Sheila

 

 

Sheila Wilson, Ph.D.

Executive Director

PODS Association, Inc

 

 <http://www.pods.org/> www.pods.org

 <mailto:sheila.wilson at pods.org> 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 Nick Nelson
Sent: Tuesday, April 08, 2008 1:40 PM
To: GIS Users Forum; okgis at gis.gis.ou.edu
Subject: [OKGIS] Is there a way

 

Hello All,

 

I have a question regarding names:

 

I have a shapefile/feature with 13812 records in it.  Many of the names
might be some like:  Ameritex OG, Ametex Ener. Amtex Ener et al, (On and On,
You get the point).  To me these are all the same.

 

Can I tell the system based on the name Ameritex to select these records?

 

So I don't have to keep going "Name = 'Ameritex OG' or Name = 'Ametex Ener.'

 

I think you get the point

 

Any help would be great.

 

Thanks,

Nick

Nicholas J. Nelson

GIS Analyst

Petro-Hunt L.L.C.

1601 Elm St, STE 3400

Dallas, TX 75201

Ph:  214-880-7141

Fax: 214-880-7171

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gis.ou.edu/pipermail/okgis/attachments/20080408/66802b3f/attachment.htm