Em Andamento

Script to delete similar records in MySQL database

I need a small script written in either PHP or Perl that will process records in a MySQL table and delete similar looking records. Specifically, I have a device uploading GPS points (lat/long) into my database. When the device is sitting still, it is putting duplicate records into my database every couple of minutes. There is GPS drift, so all records do not have identical GPS coordinates.

Basically, there are two fields I am interested in filtering by in the table. One has a latitude one has a longitude. 5 of the records might look like this:

ID | LAT | LONG

------------

id1 | 27.7755386666667 | [url removed, login to view]

id2 | 27.7755173333333 | [url removed, login to view]

id3 | 27.775456 | [url removed, login to view]

id4 | 27.775424 | [url removed, login to view]

id5 | 27.7753466666667 | [url removed, login to view]

id6 | 27.711264 | [url removed, login to view]

The first five records in the above example are all basically duplicate points from when the GPS is sitting still. They are all 27.775*, [url removed, login to view]* The script needs to filter those duplicate records where the first 5 digits in the lat/long are the same and leave one of the previously duplicated records remaining. The 6th item is a different location.

The script needs to be able to handle a table that has 20,000+ records.

Should not be a difficult task once you understand what I am trying to do. Hopefully the above example is decent :)

Habilidades: Perl, PHP

Ver mais: mysql delete similar records, mysql delete double records, mysql find similar records, delete double records mysql, delete similar records, mysql remove similar records, mysql delete similar, similar records mysql, mysql find similar, mysql select similar records, perl mysql delete, similar mysql, mysql similar, delete similar records mysql, mysql similar records, remove similar records database, find similar records mysql, records will delete mysql mysql, task five, php find similar record database, mysql similar record, database similar records, lat mysql table structure, mysql database design storing single multi lat longs, select similar mysql

Acerca do Empregador:
( 1 comentário ) St. Pete Beach, United States

ID do Projeto: #157115

Premiar a:

iSandu

This is a simple task. All you have to do is to delete the records where the euclidian distance relative to a given coordinate is smaller than a value of your choice...

$30 USD em 1 dia
(13 Avaliações)
4.5

19 freelancers estão ofertando em média $41 para este trabalho

Maestros

Please check PMB

$80 USD in 3 dias
(90 Comentários)
8.2
pentium10

Professional work from professionals!

$30 USD in 0 dias
(213 Comentários)
6.8
momleetech

we can do it

$50 USD em 1 dia
(97 Comentários)
6.7
ndinfosys

Can start and finish. Thanks Andy

$45 USD in 0 dias
(47 Comentários)
6.3
jiangmiao

please check PMB.

$30 USD in 0 dias
(7 Comentários)
6.3
diegou

Hi, can do it.. now also, no big deal. Im online so if you select me we can solve this quick. Regards

$80 USD em 1 dia
(34 Comentários)
5.6
VSmartTech

Hi, Let's start now.

$30 USD in 0 dias
(29 Comentários)
5.6
msolution

Lets Do it!

$50 USD in 0 dias
(46 Comentários)
5.5
Alexian

Hello. I can do this script for you in 1 hour. I can even add an interface so that you can chose the number of digits that you want to be similar. I had a similar task just recently for an accounting database. If you w Mais

$50 USD in 0 dias
(26 Comentários)
5.2
erwyn86

Hy there. We make this in our dreams too, so we could do it for you in a few hours if you wish. Resolution Studio

$40 USD in 0 dias
(2 Comentários)
4.4
mickalo

should be a simple process to do using Perl. - Mickalo

$45 USD em 1 dia
(3 Comentários)
3.9
speedster

Hello Sir, kindly see PM! Thanks!

$30 USD in 0 dias
(9 Comentários)
3.6
Hounddog

Hello, i can provide the work for youre needs. Please read pm.

$30 USD in 0 dias
(1 Comentário)
3.4
Ellemer

Hi, please check PM, thanks

$30 USD in 0 dias
(9 Comentários)
3.2
DavidLindon

We have a great deal of experience with Perl and MySQL interfaces. We would be able to provide a reliable script within days.

$45 USD in 2 dias
(0 Comentários)
0.0
KiruSoft

Can be done, it's a simple work.

$30 USD em 1 dia
(0 Comentários)
0.0
Galatia

See PMB for details.

$30 USD in 0 dias
(0 Comentários)
0.0
kdream

Already done this work many times.

$30 USD in 0 dias
(1 Comentário)
0.0