I need simple software to:
(a) Download multiple KMZ files from the Internet.
(b) Extract ALL available information (text and coordinates) from the files.
(c) Access webpages using several links provided in the files, read the pages and locate the desired information.
(d) Save the info from the files and the webpage in a MySQL database.
(e) Periodically download the files. Check the info in the file, compare them and if there are discrepancies, access the webpages. Alerts/logs must be displayed when discrepancies are found.
(f) Control, via alerts, some of the information extracted. Alerts must be configured by user, according to some status.
(g) Filters must be provided to allow the selection of info from database.
(h) Polygons with different colors must be plotted on Google Earth.
Developer must have experience with Google Earth, especially with coordinates and polygons.
Before the developer is hired, I want to perform a test using the attached files to see if the objective described on item (a) above can be achieved.
Need to know price and time to completion in advance.
I am uploading a sample file (BA.kmz) that will be periodically downloaded from the address http://sigmine.dnpm.gov.br/sirgas2000/BA.kmz. In order to download a different file, one only needs to change the file name*BA* to, for example, AM. A list of possible names will be provided. When saving the file, a timestamp needs to be added to the file name. For example. The name file name will be BA.2013.09.15.kmz. It should be expected to experience blocking or proxy issues, due to periodically downloading multiple files from the same IP address.
Inside the xml, there will be an URL directing to a webpage, for example: https://sistemas.dnpm.gov.br/SCM/extra/site/admin/dadosProcesso.aspx?numero=871170&ano=2000
All info on the page needs to be scraped and saved into a database.