Hy list,
sorry for my very poor english....
i have this problem....i'm working with a large table of points inside
PostGis
I can see the map...no problem but when i try to query the map with
identify the
Results windows have the columns blank (Headers are Ok)
Inside pgadmin the db is ok, the case of fieldname is ok, the table is
not created by
shp2psql but with an hand-made program in Java to convert data from
DBase to PostGis
No errors on log file
I'm not really sure if this is a problem with p.mapper or with the map
file (sorry)
thank a lot for any suggestions...
Luca
i work with a test-server with HostGis (Php 4.3.11, mapserver 4.6.0,
apache 1.3.33)
and with P.Mapper 2.0 (no develop version)
--------------------------------------------------------------------------------------------
i have a table inside PostGis made like this
CREATE TABLE ps
(
code varchar(10),
vel float8,
coh float8,
spo float8,
data date,
per varchar(10),
pro int2,
sat int2,
orb int2,
geom geometry,
indice serial NOT NULL,
oid oid,
CONSTRAINT enforce_dims_geom CHECK (ndims(geom) = 2),
CONSTRAINT enforce_geotype_geom CHECK (geometrytype(geom) =
'POINT'::text OR geom IS NULL),
CONSTRAINT enforce_srid_geom CHECK (srid(geom) = -1)
)
WITHOUT OIDS;
ALTER TABLE ps OWNER TO postgres;
-- Index: ind
-- DROP INDEX ind;
CREATE UNIQUE INDEX ind
ON ps
USING btree
(indice);
-- Index: indice_geom
-- DROP INDEX indice_geom;
CREATE INDEX indice_geom
ON ps
USING gist
(geom);
-- Index: oid_index
-- DROP INDEX oid_index;
CREATE INDEX oid_index
ON ps
USING btree
(oid);
------------------------------------------------------------------------------------------
the layer definition inside map file is :
LAYER
NAME rsat-asc
TYPE POINT
STATUS ON
CONNECTIONTYPE postgis
CONNECTION "user=pgsql password=password dbname=ps host=localhost
port=5432"
GROUP rsat-asc
#DATA "geom FROM ps USING UNIQUE oid"
DATA "geom FROM ps"
FILTER "sat=2 AND orb=0"
TOLERANCE 5
TOLERANCEUNITS pixels
TEMPLATE "void"
METADATA
"DESCRIPTION" "Radarsat Asc."
"RESULT_FIELDS" "code,vel"
"RESULT_HEADERS" "Grafico,Velocita'"
"RESULT_HYPERLINK" "code||Cliccare per aprire il grafico"
END
CLASSITEM "vel"
CLASS
NAME "Vel < -10.0"
EXPRESSION ([vel] < -10.00)
STYLE
COLOR 176 27 27
SYMBOL "arrow-up"
SIZE 5
END
END
CLASS
NAME "-9.99 < Vel < -5.00"
EXPRESSION (([vel] > -9.99) AND ([vel] < -5.00))
STYLE
COLOR 254 0 0
SYMBOL "arrow-up"
SIZE 5
END
END
CLASS
NAME "-4.99 < Vel < -3.00"
EXPRESSION (([vel] > -4.99) AND ([vel] < -3.00))
STYLE
COLOR 254 170 0
SYMBOL "arrow-up"
SIZE 5
END
END
CLASS
NAME "-2.99 < Vel < -1.50"
EXPRESSION (([vel] > -2.99) AND ([vel] < -1.50))
STYLE
COLOR 254 254 0
SYMBOL "arrow-up"
SIZE 5
END
END
CLASS
NAME "-1.49 < Vel < 1.50"
EXPRESSION (([vel] > -1.49) AND ([vel] < 1.50))
STYLE
COLOR 85 254 0
SYMBOL "arrow-up"
SIZE 5
END
END
CLASS
NAME "1.51 < Vel < 3.00"
EXPRESSION (([vel] > 1.51) AND ([vel] < 3.00))
STYLE
COLOR 59 131 254
SYMBOL "arrow-up"
SIZE 5
END
END
CLASS
NAME "3.01 < Vel < 5.00"
EXPRESSION (([vel] > 3.01) AND ([vel] < 5.00))
STYLE
COLOR 0 0 254
SYMBOL "arrow-up"
SIZE 5
END
END
END #layer
----------------------------------------------------------------------------------
no important changes inside config.ini
