Hi,
 
I have been reading recently that Mapserver can handle cases similar to yours. 
I would suggest to ask from Mapserver users mailing list for further help.
 
-Jukka Rahkonen-

________________________________

Lähettäjä: Flavio Carmo [mailto:[email protected]] 
Lähetetty: 29. marraskuuta 2010 13:53
Vastaanottaja: [email protected]
Aihe: Re: [Geoserver-users] How to create a Layer from two joined layers?


So,

neither Mapserver worked. Im without ideas.... Anyone knows a solution? Someone 
got a problem like this?

Regards,

Flávio Carmo



On Tue, Nov 23, 2010 at 12:07, Flavio Carmo <[email protected]> 
wrote:


        No, ArcSDE is out of the table, like all others proprietary solutions, 
My client knows Geoserver and likes a lot, so he requested to find if it can be 
done. 

        I've found in Mapserver (im desperate alterady) something like what i 
want, so im trying to see if i can do this in Mapserver and the rest in 
Geoserver (Mapserver dont have my confidence, but in this case, a client 
request is a client request....)

        http://mapserver.org/mapfile/join.html - JOIN Shape to PostgreSQL Table
        
        LAYER
          NAME "prov_bound"
          TYPE POLYGON
          STATUS DEFAULT
          DATA "prov.shp"
          CLASS
            NAME "Province"
            STYLE
              OUTLINECOLOR 120 120 120
              COLOR 255 255 0
            END
          END
          TOLERANCE 20
          TEMPLATE "../htdocs/cgi-query-templates/prov.html"
          HEADER "../htdocs/cgi-query-templates/prov-header.html"
          FOOTER "../htdocs/cgi-query-templates/footer.html"
          JOIN
            NAME "test"
            CONNECTION "host=127.0.0.1 port=5432 user=postgres 
password=postgres dbname=join"
            CONNECTIONTYPE ogr
            TABLE "lookup"
            FROM "ID"
            TO "ident"
            TYPE ONE-TO-ONE
          END
        END # layer
        Thanks,

        Regards,

        
        Flavio Carmo


        On Mon, Nov 22, 2010 at 18:53, Phil Scadden <[email protected]> 
wrote:
        

                Probably not at all helpful, but you CAN do this in arcSDE and 
serve the
                view out through geoserver. However, arcSDE is serious money.
                
                Notice: This email and any attachments are confidential. If 
received in error please destroy and immediately notify us. Do not copy or 
disclose the contents.
                
                
                
------------------------------------------------------------------------------
                Increase Visibility of Your 3D Game App & Earn a Chance To Win 
$500!
                
                Tap into the largest installed PC base & get more eyes on your 
game by
                optimizing for Intel(R) Graphics Technology. Get started today 
with the
                Intel(R) Software Partner Program. Five $500 cash prizes are up 
for grabs.
                http://p.sf.net/sfu/intelisp-dev2dev
                _______________________________________________
                Geoserver-users mailing list
                [email protected]
                https://lists.sourceforge.net/lists/listinfo/geoserver-users
                



------------------------------------------------------------------------------
Increase Visibility of Your 3D Game App & Earn a Chance To Win $500!
Tap into the largest installed PC base & get more eyes on your game by
optimizing for Intel(R) Graphics Technology. Get started today with the
Intel(R) Software Partner Program. Five $500 cash prizes are up for grabs.
http://p.sf.net/sfu/intelisp-dev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to