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: pmapper-users-requ...@lists.sourceforge.net [mailto:pmapper-users-requ...@lists.sourceforge.net] Gesendet: Donnerstag, 02. September 2010 21:13 An: pmapper-users@lists.sourceforge.net Betreff: pmapper-users Digest, Vol 48, Issue 1 Send pmapper-users mailing list submissions to pmapper-users@lists.sourceforge.net 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 pmapper-users-requ...@lists.sourceforge.net You can reach the person managing the list at pmapper-users-ow...@lists.sourceforge.net 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 <derealvaga...@yahoo.com> Subject: [pmapper-users] Problem with Identifying a Postgis Layer To: pmapper-users@lists.sourceforge.net Message-ID: <948599.74802...@web76803.mail.sg1.yahoo.com> 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 <s...@agt.bme.hu> Subject: Re: [pmapper-users] How to remove items from the toolbar? To: Mat?as Manuel Grandi <matiasgra...@gmail.com> Cc: pmapper-users@lists.sourceforge.net 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 <s...@agt.bme.hu>: > 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 >> pmapper-users@lists.sourceforge.net >> 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 pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users ------------------------------ Message: 3 Date: Wed, 1 Sep 2010 17:06:14 -0300 From: Mat?as Manuel Grandi <matiasgra...@gmail.com> Subject: Re: [pmapper-users] How to remove items from the toolbar? Cc: pmapper-users@lists.sourceforge.net Message-ID: <aanlktinvnnhxch2b3_sbrdex33444q9umoan0ly87...@mail.gmail.com> Content-Type: text/plain; charset=UTF-8 Thanks for your help!!! 2010/8/31 Siki Zoltan <s...@agt.bme.hu>: > 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 <s...@agt.bme.hu>: >> >> 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 >>> pmapper-users@lists.sourceforge.net >>> 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 > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users ------------------------------ Message: 4 Date: Wed, 01 Sep 2010 22:24:27 +0200 From: Thomas RAFFIN <traf...@sirap.fr> Subject: Re: [pmapper-users] problem with queries to postgis To: pmapper-users@lists.sourceforge.net Message-ID: <4c7eb67b.1060...@sirap.fr> 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 > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users > > > > > ------------------------------ Message: 5 Date: Thu, 2 Sep 2010 12:53:49 +0100 From: Chris Jackson <webturt...@gmail.com> Subject: [pmapper-users] Always on layers and legends To: pmapper-users@lists.sourceforge.net Message-ID: <aanlkti=jdy7sepjnuzemad1a6zdfetpxzx5c7svh2...@mail.gmail.com> 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 <armin.bur...@gmx.net> Subject: Re: [pmapper-users] Always on layers and legends To: pmapper-users@lists.sourceforge.net Message-ID: <4c7ff740.4090...@gmx.net> 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 pmapper-users@lists.sourceforge.net 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 pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users