[mapserver-users] Join from SHP file to PostgreSQL table

[Jeff McKenna]

Hello Flavio,

As noted on the page you referred to, this JOIN only works for executed 
queries...and I do not see a TEMPLATE in your layer.  Are you aware that 
this join only works for queries?  (see the examples in that documentation)

-jeff


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



On 10-11-29 10:43 AM, flaviocarmo wrote:
>
> Hi,
>
> I need to make a layer with a join between a shapefile and a non-spatial
> table, stored on PostgreSQL. I've found this documentation
> (http://mapserver.org/mapfile/join.html) but i could make it work, so, can u
> guys help me looking at this configuration and tell me whats wrong?
>
> LAYER
>           NAME "join_shape"
>           TYPE POLYGON
>           STATUS DEFAULT
>           DATA "join_shapefile.shp"
>           CLASS
>                 NAME "Joined Shapes"
>                 STYLE
>                   OUTLINECOLOR 120 120 120
>                   COLOR 0 30 255
>                 END
>           END
>           TOLERANCE 20
>           JOIN
>                 NAME "teste"
>                 CONNECTION "dbname='testdb' host=GSERVER1 port=5432
> user='test'
> password='test' sslmode=disable"
>                 CONNECTIONTYPE ogr
>                 TABLE '"test"."nonspatial"'
>                 FROM "code"
>                 TO "code"
>                 TYPE ONE-TO-ONE
>           END
>         END # layer
>
> In this layer, i want to show only the geometrys in the shapefile
> "join_shapefile.shp" that have a CODE column that is the same the CODE
> column in the test.nonspatial table, stored on Postgre.
>
> That is possible?