Hi,
I have a problem with postgis layers. When I do a query selecting a point on
the map I get a result for "provincias" but not for landsat layer, the last
one is a INNER JOIN between two tables. When I use the "Search for" tool I
dont get any result, neither "provincias" nor "landsat".
Here is the mapfile:
LAYER
CONNECTIONTYPE postgis
NAME "provincias"
CONNECTION "host=localhost dbname=****** user=postgres password=*******"
TYPE polygon
DATA "the_geom from provincias"
METADATA
"DESCRIPTION" "Provincias"
"RESULT_FIELDS" "nombre"
"RESULT_HEADERS" "nombre"
END # Metadata
CLASS
Name 'Provincias'
#COLOR 126 5 206
OUTLINECOLOR 14 80 150
END # Class
END # Layer
# Start of Layer landsat postgis
LAYER
CONNECTIONTYPE postgis
NAME "landsat"
CONNECTION "host=localhost dbname=****** user=postgres password=*******"
TYPE polygon
DATA "the_geom from (SELECT * FROM landsat INNER JOIN principal ON
landsat.pr = principal.pr) as foo using unique gid using SRID=4326"
LABELITEM "path_row"
METADATA
"DESCRIPTION" "Escenas Landsat"
"RESULT_FIELDS" "pr"
"RESULT_HEADERS" "pr"
END # Metadata
CLASS
Name 'path_row'
#COLOR 171 55 10
OUTLINECOLOR 180 180 180
END # Class
Thank you very much,
Isa
--
View this message in context:
http://www.nabble.com/%22query%22-and-%22search-for%22-on-a-postgis-layer-tf3704119.html#a10358541
Sent from the pmapper users mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
