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 <[email protected]
<mailto:[email protected]>>:

    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
    <[email protected] <mailto:[email protected]>>:

        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



_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Reply via email to