Capture GPS and AIS sentences to Database

'Harvest' is an existing Windows Forms application that captures data from a game server and writes it to an Access database.? It is written in VB.NET. This project is to enhance the functionality of Harvest such that it can capture a limited number of Global Positioning System (GPS) and Automatic Identification System (AIS) sentences from a COM port and write them to? the Harvest? database. Only the following GPS sentences need to be decoded; $GPRMC, $GPGSA.? The rest are ignored. Only AIS sentences 1,2,3 & 5 need to be decoded.? The rest are ignored. ## Deliverables Further information on decoding AIS sentences is at? <[login to view URL]>? Further information on decoding GPS sentences is at? <[login to view URL]> Constraints: The coder is not to alter any existing code other than that necessary to comply with the data flow diagrams in pages 2-5 & 14 of? the accompanying PDF. The coder is to write organic code to process the specified NMEA sentences.? Use of third party SDKs will not be acceptable. The minimum framework available on the target computer is .NET2.0.? The deliverables must not contain references to .NET3.0 or .NET3.5 assemblies. Functional Requirements: FR1? ? ? On startup, the application is to automatically connect to any feeds, the settings for which are already known. FR2? ? The application is to be capable of listening to at least two COM ports and the existing IP connection simultaneously.? NMEA traffic will only be received through COM ports.? FR3? ? ? The application is to be capable of listening to COM 1 - 99.? FR4? ? ? ? Spare FR5? ? ? ? ? The application is to feature a 'Settings' dialog which is launchable from the system tray item menu.? This dialog will contain the settings for each? COM port to which the application is required to listen? in addition to the server IP connection (IP address and port number only). FR6? ? ? ? The application is to warn the user after a period of one minute? of no valid data? being received on an enabled NMEA feed ? FR7? ? ? ? The application is to be capable of receiving a processing feeds comprising an amalgamation of GPS and AIS sentences.? ? ? ? FR8? ? ? ? The application is to be capable of parsing GPRMC and GPGSA sentences.? [When designing this code, the coder is urged to choose an implementation that will ease the process of adding support for other sentences at a later date] FR9? ? ? ? The application is to be capable of parsing AIS Messages 1, 2, 3 & 5. Note 1: When designing this code, the coder is urged to choose an implementation that will ease the process of adding support for other sentences at a later date. Note 2:? Messages 1, 2 and 3 are near identical in their content and order and should therefore require little additional effort to implement. FR10? ? ? ? Values written to the database are to be expressed in the same units as already used within the Harvest application.? Latitude, Longitude, and Timestamps? in particular will require a simple transformation before storage. Note 1: Latitude and Longitude are represented as signed doubles in the database.? Units: Degrees.? North and East are positive.? South and West are negative.? For example: 50-15.0S? (a latitude) = -50.25? 120-45.0E (a longitude)? = 120.75 Note 2: Timestamps are stored in the database? as? a single date value, representing both the time and date of a report.? GPS and AIS? sentences represent? timestamps differently and sometimes separately (GPRMC for instance separates time and date). Note 3:? ? Course is? represented as a positive double.? Units: Degrees.? North is 0.0, East is 90.0, West is 270.0 etc Note 4:? ? Speed is represented as a signed double.? Units:? Knots. ? FR11? ? ? ? The application? is be capable of listening to a COM port at the full range of? baud rates, data bits, parity settings and stop bits.? 4800bps and 38400bps will be the most commonly used baud rates FR12? ? ? ? The application? is to? store to disk? NMEA? and Server feed settings when changed.? FR13? ? ? ? The application must? faithfully? translate and store to the database the contents? of? all? valid, supported? NMEA sentences? received at an incoming baud rate of up to 38.4kbps.? ? ? FR14? ? ? ? ? The checksum of each sentence is to be validated before the sentence is passed for decoding.? Sentences failing checksum validation are to be discarded. Additional coding required to adapt existing code AC1.? ? ? ? ? Add the following two tables to the database creation code: AISVESSELPOSITIONREPORTS and AISVESSELSTATICVOYAGERPORTS.? Details of primary keys at in the attached PDF. AC2.? ? ? ? ? ? A new column is to be added to the OWNSHIPNAVIGATIONDATA table, namely SpeedOverGround. AC3.? ? ? ? ? ? ? ? The primary key of OWNSHIPNAVIGATIONDATA is to be changed to a composite of .Time and .Source.