Closed

Python: Decode UDP strings and save to MySql

Hi,

Please first read this Project prior offering and writing.

Please only offer if you have detailed experience with: Python / Linux / MsSQL and Possibly PHP

I have several Ports where life (every second) strings are coming in.

Every port receives data similar to:

!AIVDM,1,1,,B,141iWb0P000`=blNGrhh0?vR0<0u,0*57 !AIVDM,2,1,2,B,541iWb400000tkKC3J05@PDp400000000000001S:0945t@P00mPC1CP,0*5F !AIVDM,2,2,2,B,jACSQDp00000000,2*4B !AIVDM,1,1,,B,841iWb0j2d>==LL=<QT0g?`06pP0,0*6C !AIVDM,1,1,,A,141iWb0P000`=bfNGrhh0?vl0<0u,0*60 !AIVDM,1,1,,B,139eVOPP00P`<FtNGpl6lgvv2HBJ,0*06 !AIVDM,1,1,,B,141iWb0P000`=blNGriP0?w:05jT,0*75 !AIVDM,1,1,,B,13bQ9t01A1P`13`NHr0mdTI>05jT,0*2F !AIVDM,1,1,,A,141iWb0P000`=c0NGri@0?wL0HK?,0*7A !AIVDM,1,1,,B,139eVOPP00P`<FtNGpl6lgwT25jT,0*6E !AIVDM,1,1,,B,141iWb0P000`=c6NGrhP0?wh0<0u,0*0F

More Data will be available for shortlisted freelancers.

They are send through the Internet to my small Cloud Server through NTP and received in my case on Port 4545 (but this can be changed). The Data are so called AIS Information.

[url removed, login to view]

Have a look at the data output here:

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

As this shall be in Python please also check:

[url removed, login to view]

[url removed, login to view]

Step 1:

Prepare a MySQL table into which the data shall be loaded. For the beginning I propose a simple MySQL database because I expect that due to massive amount of data most of them shall be scrapped in a later stage.

Step 2:

Write a program which automatically decodes all incoming ais Strings and inserts them into the MySQL table Following I would have a look at the incoming data and check which of them I really need and discuss how they shall be saved. I expect that it shall be more than 1 MySQL

Step 3:

Implement the discussion from Step 2.

Additionally:

In case there will be too many data following can be used in order to down-sample:

[url removed, login to view]

Thanks

Martin

Skills: Linux, MySQL, Python, Software Architecture

See more: python serial save mysql, python script txt csv, python script save mail attachment, script save web page txt, save email attachments python script, php python decode captcha, php form save mysql mail, ajax edit mysql edit save mysql, rss save mysql, arabic content save mysql spring hibernate, save catalog product using flash save mysql, web scraper save mysql database, webcrawler save mysql, save mysql posting paypal, browsing xls php save mysql database example, read data excel sheet using save mysql, php feed xml save mysql, triggers find avg table save mysql, python script modify file content, python script text files, script save specific location, script save php page pdf, php script save checkbox status mysql table, python script scrapes results google search, script save rss feed database

About the Employer:
( 4 reviews ) Bremen, Germany

Project ID: #16310487

24 freelancers are bidding on average €220 for this job

skrmm1

Hello. I've decided to place my bid here, because I've been working on an AIS-related project and I already own code for your task(exact same task UDP to MySQL). P.S. I do not ask for any upfront payments. P.P.S. You c More

€555 EUR in 3 days
(73 Reviews)
6.3
rajdeepa555

Hello Sir, I read your requirements regarding ais and I have expertise in all 3 technologies required for this project. actually so i idea is to capture every single ais which you get on your cloud server and and de More

€250 EUR in 7 days
(55 Reviews)
6.1
€155 EUR in 1 day
(39 Reviews)
5.7
grtdeveloper

Rich experience in handling big streams of data , sampling them and storing the information in database MySQL. Programming using python , c .

€200 EUR in 4 days
(19 Reviews)
4.9
gsoftwareinc

Interesting project. Pls, let me know when you can time to discuss the details in a call if that is OK with you.

€250 EUR in 7 days
(9 Reviews)
4.2
sunblink

Dear Sir, I read libs description and made simple app which can receive and parse data from file. I think it's not a problem to implement UDP client and database connection (I think I would to use sqlalchemy to give More

€222 EUR in 3 days
(4 Reviews)
4.4
lntrx

I can do this in Python. I have experience and I don't think it will be hard and take much time. You can count on me

€170 EUR in 3 days
(18 Reviews)
4.3
€155 EUR in 3 days
(15 Reviews)
4.2
marcellp

I have demonstrated experience on this site working with numerous Python-based networking solutions and I believe I would be an ideal candidate for this project. I have used MySQL drivers for Python and have years of e More

€111 EUR in 3 days
(20 Reviews)
4.3
koray84

Hi, below is the decoded message for the first AIS message that you provided (!AIVDM,1,1,,B,141iWb0P000`=blNGrhh0?vR0<0u,0*57 ): === Class A Position Report (1) === Repeat : 0 MMSI : 270297000 [S More

€250 EUR in 7 days
(3 Reviews)
4.3
shalala83eu

Hello, Martin. I am an experienced Python and database developer and I'd like to work with you. Regards, Alex.

€94 EUR in 7 days
(12 Reviews)
3.8
sergey4kim

I have done such project last week. I can complete this project within 36 hours. Thank you! . . .

€200 EUR in 0 days
(10 Reviews)
3.8
juinhalder

Hi !! Nice to E-meet you We have a team of experienced python, django developers. We have developed a sophisticated trading platform using python, django, postgresql. Our python/django developers also has experience in More

€154 EUR in 3 days
(1 Review)
3.2
vw2107604vw

I am an experienced software engineer in the Pacific Northwest. I'm a one-man-shop so you will know exactly who you're getting, and I'm always available during your hours to communicate about your project. I have t More

€250 EUR in 7 days
(4 Reviews)
2.6
WIFTCAP

Hi !! Nice to E-meet you We have a team of experienced python, django developers. We have developed a sophisticated trading platform([login to view URL]) using python, django, postgresql Our python/django devel More

€200 EUR in 3 days
(3 Reviews)
2.3
Creators31

Hey There, I haven't worked with AIS but had worked a lot with Python and MySql and also checked out the decoded message and the libais library it was pretty cool and this project seems Interesting. I would love to wor More

€250 EUR in 8 days
(3 Reviews)
2.4
tungvs

I will implement the software and see if it works the way you want. Please send me more AIS message samples. How often does the server receive the messages ?

€277 EUR in 7 days
(2 Reviews)
2.1
ilyavin

Greetings! I'm Ilya. For a long time, I worked on the development of emulators for ship navigation systems, processing of AIS and NMEA messages. I read your assignment and understood that it is necessary to develo More

€277 EUR in 7 days
(0 Reviews)
0.0
Shikha510

Hello, Hope you are doing well. I have analyzed your job requirements for a Python developer. I have rich skills with Python and worked on several python packages like numpy, scipy, pytables etc. I am an in More

€277 EUR in 5 days
(0 Reviews)
0.0
sandeeppradhan92

A proposal has not yet been provided

€200 EUR in 12 days
(0 Reviews)
0.0