Hi Deril,
try
DATA "the_geom FROM kecamatan_geom using unique gid using srid=32647"
1. with either one result field and one result header
or
2.
"RESULT_HYPERLINK" "nama_kcmtn"
"RESULT_HEADERS" "ID Kecamatan,Nama Kcamatan"
"RESULT_FIELDS" "id_kecamatan,nama_kcmtn"
the RESULT_HYPERLINK has always to be the second field in the list
Karl
-----Ursprüngliche Nachricht-----
Von: [email protected]
[mailto:[email protected]]
Gesendet: Donnerstag, 02. September 2010 21:13
An: [email protected]
Betreff: pmapper-users Digest, Vol 48, Issue 1
Send pmapper-users mailing list submissions to
[email protected]
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/pmapper-users
or, via email, send a message with subject or body 'help' to
[email protected]
You can reach the person managing the list at
[email protected]
When replying, please edit your Subject line so it is more specific than "Re:
Contents of pmapper-users digest..."
Today's Topics:
1. Problem with Identifying a Postgis Layer (Deril Alwinda)
2. Re: How to remove items from the toolbar? (Siki Zoltan)
3. Re: How to remove items from the toolbar? (Mat?as Manuel Grandi)
4. Re: problem with queries to postgis (Thomas RAFFIN)
5. Always on layers and legends (Chris Jackson)
6. Re: Always on layers and legends (Armin Burger)
----------------------------------------------------------------------
Message: 1
Date: Wed, 1 Sep 2010 04:24:00 +0800 (SGT)
From: Deril Alwinda <[email protected]>
Subject: [pmapper-users] Problem with Identifying a Postgis Layer
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=utf-8
Hi,
Please help, i'm having a problem with the identify feature. I'm using pmapper
4.0 and using postgresql 8.4 with postgis 1.4 as data source.
The problem is when i tried to use the identify feature on pmapper it doesn't
show the attribute, only the header. I checked the JSON output, the value
isn't there.
I also checked the .php files (query.php,squery.php,and x_info.php) but doesn't
really get me anywhere.
I don't know what went wrong, please help i've been having this problem for
weeks.
This is my map file look like.
MAP
EXTENT 444765.383453 380538.093750 481755.804047 424830.125000 UNITS meters
#EXTENT 98.5027 3.4879 98.8357 3.7983 #UNITS dd SIZE 600 500
SYMBOLSET "../common/symbols/symbols-pmapper.sym"
FONTSET "../common/fonts/msfontset.txt"
RESOLUTION 96
IMAGETYPE png
INTERLACE OFF
#CONFIG "PROJ_LIB" "C:/proj/nad/"
PROJECTION
"init=epsg:32647"
END
#
# Image formates for GD
#
OUTPUTFORMAT
NAME "png"
DRIVER "AGG/PNG"
MIMETYPE "image/png"
IMAGEMODE RGB
TRANSPARENT OFF
EXTENSION PNG
FORMATOPTION "QUANTIZE_FORCE=ON"
FORMATOPTION "QUANTIZE_DITHER=OFF"
FORMATOPTION "QUANTIZE_COLORS=256"
END
OUTPUTFORMAT
NAME "png32"
DRIVER "AGG/PNG"
MIMETYPE "image/png"
IMAGEMODE "rgba"
EXTENSION "png"
FORMATOPTION "transparent=on"
# TileCache can't use meta-tiling on interlaced PNG files...
FORMATOPTION "interlace=off"
END
#OUTPUTFORMAT
# NAME "png8"
#DRIVER "GD/PNG"
#MIMETYPE "image/png"
#IMAGEMODE RGB
#FORMATOPTION INTERLACE=OFF
#TRANSPARENT OFF
#EXTENSION "png"
#END
OUTPUTFORMAT
NAME "jpeg"
DRIVER "GD/JPEG"
MIMETYPE "image/jpeg"
IMAGEMODE RGB
FORMATOPTION "QUALITY=70"
EXTENSION "jpg"
END
# Image formats for AGG
#
# OUTPUTFORMAT ### 24 bit PNG
# NAME 'agg_png'
# DRIVER AGG/PNG
# IMAGEMODE RGB
# END
# OUTPUTFORMAT ### 32 bit PNG with alpha channel from transparency # NAME
'agg_pnga'
# DRIVER AGG/PNG
#IMAGEMODE RGBA
#TRANSPARENT ON
#EXTENSION "png"
#MIMETYPE "image/png"
#END
# OUTPUTFORMAT ### 8 bit PNG
# NAME 'agg_png8'
# DRIVER AGG/PNG
# IMAGEMODE RGB
# FORMATOPTION "QUANTIZE_FORCE=ON"
# FORMATOPTION "QUANTIZE_DITHER=OFF"
# FORMATOPTION "QUANTIZE_COLORS=256"
# END
# OUTPUTFORMAT
# NAME 'agg_jpeg'
# DRIVER AGG/JPEG
# IMAGEMODE RGB
# END
OUTPUTFORMAT
NAME GTiff
DRIVER "GDAL/GTiff"
MIMETYPE "image/tiff"
IMAGEMODE RGB
#FORMATOPTION "TFW=YES"
#FORMATOPTION "COMPRESS=PACKBITS"
EXTENSION "tif"
END
OUTPUTFORMAT
NAME imagemap
MIMETYPE "text/html"
FORMATOPTION SKIPENDTAG=OFF
DRIVER imagemap
END
#
# Start of web interface definition
#
WEB
TEMPLATE "map.html"
IMAGEPATH "/ms4w/tmp/ms_tmp/"
IMAGEURL "/ms_tmp/"
METADATA
"MAPFILE_ENCODING" "UTF-8"
#"ows_title" "WMS Demo Server"
#"ows_onlineresource" "http://wms.yourserver.org?owskey=test&";
#"ows_srs" "EPSG:32647"
END # Metadata
END # Web
#
# Start of Reference map definition
#
REFERENCE
EXTENT 444765.383453 385538.093750 481755.804047 419830.125000
IMAGE "../../images/medan_reference.png"
SIZE 199 149
COLOR -1 -1 -1
OUTLINECOLOR 255 0 0
END # Reference
LEGEND
END
#
# Start of ScaleBar definition
#
SCALEBAR
STATUS off
TRANSPARENT off
INTERVALS 4
SIZE 200 3
UNITS kilometers
COLOR 250 250 250
OUTLINECOLOR 0 0 0
BACKGROUNDCOLOR 100 100 100
STYLE 0
POSTLABELCACHE true
LABEL
COLOR 0 0 90
#OUTLINECOLOR 200 200 200
SIZE small
END # Label
END # Reference
# SYMBOLS USED IN PMAPPER
# - 'circle' always necessary (used e.g. for highlight) # - 'square' used in
currecnt map file # Symbols can also be defined via tag SYMBOLSET (see above)
Symbol
NAME 'circle'
TYPE ELLIPSE
FILLED TRUE
POINTS
1 1
END
END
Symbol
NAME 'square'
TYPE VECTOR
FILLED TRUE
POINTS
0 1
0 0
1 0
1 1
0 1
END
END
#================== MULAI LAYER!! =====================#
#================ LAYER KECAMATAN==========================#
LAYER
NAME "kecamatan"
TYPE POLYGON
CONNECTIONTYPE postgis
CONNECTION "host=127.0.0.1 user=postgres password=12345 dbname=medan"
DATA 'the_geom FROM (SELECT the_geom as the_geom, id_kecamatan, nama_kcmtn
FROM kecamatan_geom) AS foo USING UNIQUE id_kecamatan USING SRID=32647'
STATUS DEFAULT
TRANSPARENCY 100
LABELITEM "nama_kcmtn"
LABELMINSCALE 35000
LABELMAXSCALE 99999999
CLASSITEM "id_kecamatan"
CLASS
TEMPLATE void
NAME "Kecamatan"
STYLE
SYMBOL 0
SIZE 6
OUTLINECOLOR 255 255 255
COLOR 255 255 255
END
LABEL
FONT "FreeSansBold"
TYPE truetype
SIZE 8
POSITION CC
COLOR 255 0 0
OUTLINECOLOR 242 236 230
END
END
METADATA
"DESCRIPTION" "Administrasi Kecamatan"
"RESULT_HEADERS" "ID Kecamatan,Nama Kcamatan"
"RESULT_FIELDS" "id_kecamatan,nama_kcmtn"
"LAYER_ENCODING" "UTF-8"
END
END
END #MAP
Could anyone help ?
Thank you
Regards,
Deril
------------------------------
Message: 2
Date: Tue, 31 Aug 2010 22:40:21 +0200 (CEST)
From: Siki Zoltan <[email protected]>
Subject: Re: [pmapper-users] How to remove items from the toolbar?
To: Mat?as Manuel Grandi <[email protected]>
Cc: [email protected]
Message-ID: <pine.lnx.4.64.1008312225070.1...@bme-geod>
Content-Type: text/plain; charset="iso-8859-2"
Hello Mato,
the ui elements are defined/created in uielement.php
regards,
Zoltan
On Tue, 31 Aug 2010, Mat?as Manuel Grandi wrote:
> Thanks! Works!
BTW, do you know how to remove the "Search" menu?
Thx!
Mato.-
2010/8/31 Siki Zoltan <[email protected]>:
> Dear Matias,
>
> check js_config.php in config/default.
> PM.buttonsDefault contains the definition of tools erase or comment
> our the unneccessary tools/lines.
>
> regards,
> Zoltan
>
> On Tue, 31 Aug 2010, Mat?as Manuel Grandi wrote:
>
>> Hi!
>> I'm using p.mapper 4 and I would like to know how to remove some
>> items from the toolbar.
>>
>> Thx!!!
>> Mato.-
>>
>>
>> ---------------------------------------------------------------------
>> --------- This SF.net Dev2Dev email is sponsored by:
>>
>> Show off your parallel programming skills.
>> Enter the Intel(R) Threading Challenge 2010.
>> http://p.sf.net/sfu/intel-thread-sfd
>> _______________________________________________
>> pmapper-users mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
------------------------------
Message: 3
Date: Wed, 1 Sep 2010 17:06:14 -0300
From: Mat?as Manuel Grandi <[email protected]>
Subject: Re: [pmapper-users] How to remove items from the toolbar?
Cc: [email protected]
Message-ID:
<[email protected]>
Content-Type: text/plain; charset=UTF-8
Thanks for your help!!!
2010/8/31 Siki Zoltan <[email protected]>:
> Hello Mato,
>
> the ui elements are defined/created in uielement.php
>
> regards,
> Zoltan
>
> On Tue, 31 Aug 2010, Mat?as Manuel Grandi wrote:
>
>> Thanks! Works!
>
> BTW, do you know how to remove the "Search" menu?
>
> Thx!
> Mato.-
>
> 2010/8/31 Siki Zoltan <[email protected]>:
>>
>> Dear Matias,
>>
>> check js_config.php in config/default.
>> PM.buttonsDefault contains the definition of tools erase or comment
>> our the unneccessary tools/lines.
>>
>> regards,
>> Zoltan
>>
>> On Tue, 31 Aug 2010, Mat?as Manuel Grandi wrote:
>>
>>> Hi!
>>> I'm using p.mapper 4 and I would like to know how to remove some
>>> items from the toolbar.
>>>
>>> Thx!!!
>>> Mato.-
>>>
>>>
>>>
>>> --------------------------------------------------------------------
>>> ---------- This SF.net Dev2Dev email is sponsored by:
>>>
>>> Show off your parallel programming skills.
>>> Enter the Intel(R) Threading Challenge 2010.
>>> http://p.sf.net/sfu/intel-thread-sfd
>>> _______________________________________________
>>> pmapper-users mailing list
>>> [email protected]
>>> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>>
>
> ----------------------------------------------------------------------
> -------- This SF.net Dev2Dev email is sponsored by:
>
> Show off your parallel programming skills.
> Enter the Intel(R) Threading Challenge 2010.
> http://p.sf.net/sfu/intel-thread-sfd
> _______________________________________________
> pmapper-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
------------------------------
Message: 4
Date: Wed, 01 Sep 2010 22:24:27 +0200
From: Thomas RAFFIN <[email protected]>
Subject: Re: [pmapper-users] problem with queries to postgis
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Hi,
I read
name="Kas"
in your search definition, but your subquery in your mapfile seems to use "kas"
field and not "Kas".
I think there should be a case mistake.
Thomas
Le 27/08/2010 01:10, Sekcja Geoinformacji a ?crit :
> Dear pmapper-users,
>
> when I define queries to the shapefile, everything works correctly,
> but when I define query to the table imported from this shapefile to
> postgis database, pmapper doesn't answer. Of course I change layer type from
> 'shape'
> to 'postgis' in config_default.xml file. It's strange for me because
> it is posible to see information about object, only query doesn't work
> so connection to database is correct. I found some tips in Internet
> which could help but nothing happened after this modifications. For
> example I've tried to change definition of data in mapfile from "DATA
> "geom from stacjepkp USING UNIQUE gid USING srid=2180""
> to "DATA "geom from (SELECT geom, gid, kas, wc FROM stacjepkp) AS
> new_tab USING UNIQUE gid USING SRID=2180"".
>
> The only idea which I have now, is to change something in mapfile but
> I don't know what. Maybe could you send me some example file which
> works to compare? Now definition of the layer looks this: (I've
> changed only the
> password)
>
> LAYER
> NAME "stacjepkp"
> STATUS ON
> DUMP true
> TYPE POINT
> EXTENT 14.331985 53.838422 14.538733 53.987097
> #DATA "stacjepkp"
> CONNECTIONTYPE POSTGIS
> CONNECTION "host=skng.amu.edu.pl port=5432 dbname=postgres
> user=skng password=password"
> DATA "geom from stacjepkp USING UNIQUE gid USING srid=2180"
> #DATA "geom from (SELECT geom, gid, kas, WC FROM stacjepkp) AS
> new_tab USING UNIQUE gid USING SRID=2180"
> TOLERANCE 4 #promie? okr?gu od miejsca klikni?cia myszy
> TEMPLATE void
> CLASS
> NAME "stacjepkp"
> STYLE
> COLOR 0 0 0
> SYMBOL "pkp"
> SIZE 18
> END #koniec obiektu STYLE
> END #koniec obiektu CLASS
> METADATA
> "wms_title" "stacjepkp"
> "DESCRIPTION" "stacjepkp"
> "RESULT_FIELDS" "Kas, WC"
> "LAYER_ENCODING" "UTF-8"
> "ows_title" "stacjepkp"
> END
> PROJECTION
> "init=epsg:4326"
> END #Koniec PROJECTION
> END
>
> This is the part of default_config.xml file:
>
> <searchitem name="stacjepkp" description="stacjepkp">
> <layer type="postgis" name="stacjepkp">
> <field type="n" name="Kas" description="Kasa biletowa
> (0 - brak ; 1 - jest)" wildcard="1" />
> </layer>
> </searchitem>
>
> Please, just take a look on my website
> http://skng.amu.edu.pl/gis<http://skng.amu.edu.pl/serwer/pmapper/>and
> try to "search for ...stacjepkp" (write '0' or '1' there) and look
> what happened. Each clue will be priceless for me...
>
> Thanks a lot,
>
> Tomasz ?ukaszczyk
> Adam Mickiewicz University
> ----------------------------------------------------------------------
> -------- Sell apps to millions through the Intel(R) Atom(Tm) Developer
> Program Be part of this innovative community and reach millions of
> netbook users worldwide. Take advantage of special opportunities to
> increase revenue and speed time-to-market. Join now, and jumpstart
> your future.
> http://p.sf.net/sfu/intel-atom-d2d
> _______________________________________________
> pmapper-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>
>
>
>
>
------------------------------
Message: 5
Date: Thu, 2 Sep 2010 12:53:49 +0100
From: Chris Jackson <[email protected]>
Subject: [pmapper-users] Always on layers and legends
To: [email protected]
Message-ID:
<[email protected]>
Content-Type: text/plain; charset=ISO-8859-1
Hi
I have certain base layers that I always want to be on and then the user
superimposes other datasets. At present I can get the layers to show by using
status=on in the map file and adding the layer to the all and default groups
tag in the config xml (so they load but do not appear in the TOC list).
However I want some of these layers to appear in the legend too - any clues?
Do they have to be in the TOC for the legend to display? If so is there a way
to disable the tickbox for specific layers (without using the
mutualDisableList) so they are permanently on.
Also is it possible to load a pre-coloured raster geoTiff and load in an
associated pre-prepared legend image to match in the legend pane (I can get
uncoloured version of the geoTIFF to load and colour up based on map classes,
which builds the legend fine, but is too slow loading for a baselayer).
Thanks
Chris
------------------------------
Message: 6
Date: Thu, 02 Sep 2010 21:13:04 +0200
From: Armin Burger <[email protected]>
Subject: Re: [pmapper-users] Always on layers and legends
To: [email protected]
Message-ID: <[email protected]>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
On 02/09/2010 13:53, Chris Jackson wrote:
> Hi
>
> I have certain base layers that I always want to be on and then the
> user superimposes other datasets. At present I can get the layers to
> show by using status=on in the map file and adding the layer to the
> all and default groups tag in the config xml (so they load but do not
> appear in the TOC list). However I want some of these layers to
> appear in the legend too - any clues? Do they have to be in the TOC
> for the legend to display? If so is there a way to disable the tickbox
> for specific layers (without using the
> mutualDisableList) so they are permanently on.
not possible without changing the core code. You could do it on the PHP side in
toc.php or probably also in Javascript in pm.toc.js, but you will need some
deeper code analysis.
>
> Also is it possible to load a pre-coloured raster geoTiff and load in an
> associated pre-prepared legend image to match in the legend pane (I can get
> uncoloured version of the geoTIFF to load and colour up based on map
> classes, which builds the legend fine, but is too slow loading for a
> baselayer).
>
in order to get a legend you need to define classes for a layer. How
else should the application know which icons to add to the legend? But
you could somehow tweak the legend creation in PHP if you really want.
I'm just wondering about your problem with speed. If you do not have
100's of classes for the layer (which would not really make sense IMO),
speed should not be an issue. At least I never had problems with a 4GB
Tiff file for Corine landcover with 30 or so classes, given the Tiff
file had been prepared with overviews etc.
armin
------------------------------
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
------------------------------
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
End of pmapper-users Digest, Vol 48, Issue 1
********************************************
------------------------------------------------------------------------------
This SF.net Dev2Dev email is sponsored by:
Show off your parallel programming skills.
Enter the Intel(R) Threading Challenge 2010.
http://p.sf.net/sfu/intel-thread-sfd
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
