Hello, everyone, I have a bit of a pickle, but I think that it could be a fun problem to solve. I am copying a friend of mine on this email because he and I have talked about this in the past, and I think that he'd want to see the response. If it's not an inconvenience, please do leave him on the reply line.
I have a PostGIS database with roughly 1,800 points that are to be represented as markers. I have been asked to produce anywhere from 1 to 51 maps in PNG format: one will be the entire country of the United States of America , and the rest will be for each individual state in which there is at least one marker. The request is to use a Google Maps Political map as a base layer, or something else showing basic geopolitical data, like state boundary lines, various cities, etc. What I would like to do is use either PHP or Python to (I'll assume PHP for now, but can easily switch to Python if that's what people prefer.): 1. Query the DB and find every state for which there is at least one marker, and write each one of those states to an array called $states. 2. Loop through $states, and for each one, use a WMS call to produce a PNG of each state, with markers on it, centered on the centroid of the state, with zoom set to the state level. So, this means that for each state, I have to get the WMS output of both the Google Maps layer AND the points layer, and combine into one PNG. If anyone has done something like this before, and can help me think through it, I would really appreciate it. I'm also willing to pay a bit if someone hasn't done it, but is able to, and requires a consulting fee to help. I'd prefer to get the assist gratis, as this is volunteer work for an NGO, but I understand that talent and time cost money, and the fact that I am volunteering doesn't mean that other people are. Thanks, Dheeraj
------------------------------------------------------------------------------ Gaining the trust of online customers is vital for the success of any company that requires sensitive data to be transmitted over the Web. Learn how to best implement a security strategy that keeps consumers' information secure and instills the confidence they need to proceed with transactions. http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
