[mapserver-users] Bulk creation of mapfile

[Jeff McKenna]

I believe the PropertyShark team stores the layers in a mysql database, 
if I remember their presentation (but I'd rather use postgres and 
plpgsql functions as well, nice Cristiano).

-jeff


-- 
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/



On 2014-08-13 3:44 PM, Cristiano Sumariva wrote:
> I took the plpgsql way. Created a set of functions that generates the
> mapfile blocks and store the tokens in several postgresql tables(using
> traditional SQL relations).
>
> Then I invoke the mapfile( id ) from database and pass the mapfile text
> direct to mapscript.
> With this, the mapfile creation has been managed by the database and did
> not need any files.
>
> Since all layers are already at database, I do not think those
> generation steps take some much processing.
> It is working for a few layers already loaded.
>
> Current postgresql could also store them as XML. Recent mapserver could
> parse xml mapfiles. But never implemented something this way.
>
>
>
> 2014-08-13 15:08 GMT-03:00 Alex Lopes <alexlopespereira at gmail.com
> <mailto:alexlopespereira at gmail.com>>:
>
>     Thank you everybody who helped me. I'll study all the suggestions
>     and post here the complete source code of my solution.
>
>     Alex
>
>
>     2014-08-13 9:34 GMT-04:00 Jeff McKenna
>     <jmckenna at gatewaygeomatics.com <mailto:jmckenna at gatewaygeomatics.com>>:
>
>         Definitely leverage mapfile INCLUDEs
>         (http://mapserver.org/mapfile/__include.html
>         <http://mapserver.org/mapfile/include.html>). In your case, each
>         LAYER could be an include, and you could have a mapfile template
>         file that your shell script writes those include layers into.
>
>         I recently saw a presentation at FOSS4G-Europe from
>         PropertyShark, who manages thousands of layers, using includes,
>         and generates them through custom Perl scripts (you can read
>         about that discussion, or contact them, through the recent
>         Google+ discussion
>         https://plus.google.com/__communities/__103841604654304099367
>         <https://plus.google.com/communities/103841604654304099367>).
>
>         -jeff
>
>
>         --
>         Jeff McKenna
>         MapServer Consulting and Training Services
>         http://www.gatewaygeomatics.__com/
>         <http://www.gatewaygeomatics.com/>
>
>
>         On 2014-08-13 10:03 AM, Alex Lopes wrote:
>
>             Hi Everybody,
>
>
>             I need to create a script shell to build thousands of
>             mapfiles based on
>             postgis layers.
>
>             Which is the best way to accomplish this task?
>
>             Best regards,
>             Alex
>
>