I am a private sector meteorologist. I am currently using an existing application running the Google Maps API which displays weather radar data on an interactive map of the U.S. A checkbox also allows me to view location markers which indicate the locations of one of my customers, which is a school district with multiple locations. Whenever I need to send a weather alert to one or more of the school locations, I currently have to manually determine what locations are impacted by an approaching storm and manually construct an e-mail to be sent only to the impacted locations. This becomes quite time consuming, especially during periods of active weather conditions. I need to streamline/automate this process so as to be able to provide the needed information to them in a more organized and efficient manner.
With the above in mind, I need to have an interface/application developed where I can:
(1). Draw one or more polygons on my existing Google Maps interactive weather radar map and then have the application determine the resulting lat/long points of the finalized polygon. Note: I need to be able to edit the polygon before the final lat/long points are determined (i.e., click on a point and drag and drop it to reconfigure the polygon shape, etc.)
(2). Using the resulting lat/long points from item 1, have a script query my MySql database and determine if any of the locations listed within my MySql data table are located within the finalized polygon area (lat/long points of the locations are already located within my existing MySql database).
(3). If any locations within my MySql data table are present within the polygon area, the application will need to open a text editor where I can construct and/or edit a pre-configured e-mail message (or template) to send only to the users that are located at the specific locations determined to be within the polygon area.
(4). The application should display a list of current alert polygons that are in effect, and give me the ability to modify these polygons and/or send an e-mail update to the impacted locations if necessary.
(5). In addition to sending the e-mail message as described above, I would also like for a PDF version of the same e-mail message to be created and posted in the form of a link located at the top of the applicable user's page on my website. The MySql database shows the URL locations where a message should be posted for each user (when applicable). I guess it doesn't necessarily have to be in PDF format, but in any format that will be friendly across multiple browser types and devices.
I tried to be as detailed as possible in this description, but I'm sure I've left some things out or you may need for me to clarify something. Please feel free to ask specific questions and I will give all available details. I also will have mock-ups of the application selection and editing screens available for your review soon as well.
The way I see this project flowing is: (1). you respond with any follow-up questions and an initial estimate of the price range to complete this project (2). I will send you the mock ups and any other detailed information that you may request and then (3). you will present me with your final estimate. Each estimate should also include the time that you feel will be required to complete the project.
I know whether this is a "simple" or "very small" project will depend on your experience level. I also have a working knowledge of typical pricing for these types of projects out on the market, so I am flexible and will keep that in mind. Thanks in advance for your consideration, and I look forward to working with you!