Data Integration - Map and Merge into AtomPub Format

I need a "quick and dirty" web-based app that collects a data file (feed) and merges the data into a standard GeoRSS enabled AtomPub file. The process simply grabs a CSV/XML file (or similar), parses it and structures it as a GeoRSS Atom file. The key here is to extract lat/lng coordinates and make the data accessible as an Atom file. As part of the data modeling process, I would like a simple method to manually map the fields from the source file to metadata in the final Atom file. AND, the ability to save the mapping schema as an XML file. Perhaps a point and click approach that builds the schema. The source feed will be structured in various formats: csv, xml, kml, txt. If the source feed has geo coordinate (lat/lng), I need it to map metadata based on GeoRSS standard declarations (i.e., georss:polygon, georss:line, georss:box, etc.). Attached are sample files for you to analyze. One thing to note... KML files may have polygon geo coordinates rather than points. In summary the basic idea is to provide a way to standardize a single feed into GeoRSS AtomPub format and create a data model schema as a separate file (for data integration). Later, if the source feed URL is called again, the schema file is used rather than running the data modeler component. The preferred "development" environment is a typical LAMP stack. PHP4+, Mysql 4. But, Python is probably the better approach. Source feeds are accessible from http URL. This project will be quick: 2 days max. Edit: time frame is flexible. I can assist you if needed. I'm working on the data modeler now. **This could be an ongoing project** as we build data modeling schemas for a variety of feeds. Thanks ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows? (depending on the nature? of the deliverables): a)? For web sites or? other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software? installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform LAMP stack. PHP4+, MySQL 4 OR Python