Re: [mapserver-users] data parameter in tileindex

[Carlos Ruiz via mapserver-users]

Zmitser,
You have to have the following on a MAP file:
LAYER
...

 CONNECTION "host= ... password="CONNECTIONTYPE 

DATA " FROM  USING UNIQUE  USING SRID="
...
END
On DATA you must specify the name of the geometry column and the table, if 
you're using a database. If you are using a shape file you just have to include 
the DATA keyword with the path and the name of the SHP file.


On Tuesday, March 23, 2021, 2:34:48 AM CST, Zmitser Kozhukh via 
mapserver-users  wrote:  
 
 Dear mapserver users, I need to specify data parameter at the location item of 
tileindex.So far, I have tried many possibilities but none works:
‘host=127.0.0.1 dbname=database user=admin password=admin DATA "geom from table 
using unique id using srid=4326"’orhost=127.0.0.1 dbname=database user=admin 
password=admin data="geom from table using unique id using srid=4326"etc.Still 
I get an error :msDrawMap(): Image handling error. Failed to draw layer named 
'layer'. msPostGISLayerOpen(): Query error. Nothing specified in DATA 
statement.Could someone please tell in which format data statement should be?In 
documentation it is written vaguely:Normally the location should contain the 
path to the tile file relative to the shapepath, not relative to the tileindex 
itself. If the DATA parameter contains a value then it is added to the end of 
the location. --
Zmitser Kozhukh___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] PostgreSQL authentication method.

[Carlos Ruiz via mapserver-users]

The key is the message "authentication method 10 not supported". It seems that 
PostgreSQL client library's version is older and does not support that 
encryption method. Versions 10 and later supports it.

On Thursday, February 18, 2021, 3:49:48 PM CST, Steve Lime 
 wrote:  
 
 I wonder if that's more a function of the PostgreSQL client library 
version/capabilities. Do you know what MapServer is compiled against? You might 
try connecting to your database with psql as another test of the client lib.
On Thu, Feb 18, 2021 at 2:25 PM Moen, Paul T.  wrote:

I recently tried a Mapserver layer connected to a PostgreSQL 13.2 database that 
had password_encryption = scram-sha-256.  I was unsuccessful in getting it to 
work until I switched it to md5 and reset the passwords.  The following error 
was logged and the interesting part seems to be (authentication method 10 not 
supported).

[Thu Feb 18 13:57:02.652879 2021] [php7:warn] [pid 16668] [client 
192.168.100.4:57341] PHP Warning:  mapObj::drawQuery(): [MapServer Error]: 
msPostGISLayerOpen(): Database connection failed. Check server logs for more 
details.Is the database running? Is it allowing connections? Does the specified 
user exist? Is the password valid? Is the database on the standard port?\n in 
/Volumes/Data/WebServer/newswc/php/drawmappm.php on line 243, referer: 
http://stagmapservice.swc.nd.gov/
Database connection failed (authentication method 10 not supported
) with connect string 'user=dauser password=** dbname=swc 
host=dadatabase.blah.blah.blah port=5432'
Is the database running? Is it allowing connections? Does the specified user 
exist? Is the password valid? Is the database on the standard port? in 
msPostGISLayerOpen()msPostGISLayerOpen(): Query error. Database connection 
failed. Check server logs for more details.Is the database running? Is it 
allowing connections? Does the specified user exist? Is the password valid? Is 
the database on the standard port?
msDrawMap(): Image handling error. Failed to draw layer named 'Countries - Natl 
Atlas'.

Is this an issue with MapServer?  If so, will scram-sha-256 authentication be 
supported by Mapserver?

Thanks,

Paul

MapServer version 7.6.2 OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML SUPPORTS=PROJ 
SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=CAIRO SUPPORTS=ICONV 
SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT 
SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=GEOS 
SUPPORTS=POINT_Z_M SUPPORTS=PBF INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL 
INPUT=SHAPEFILE

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users
  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] PostGIS query problem

[Carlos Ruiz]

Hola, Fernando,
I don't know what's really going on but despite if this is a GDAL error or 
something else, I suggest you to try the following in the MAP file LAYER 
section:

PROCESSING "CLOSE_CONNECTION=DEFER"
Another question: does PostgreSQL server is running in another machine ?

MSc. Carlos Ruiz ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Validation regex question

[Carlos Ruiz]

Hello all,
Yesterday I binded Mapserver generated images on a Shiny (R) application 
through CGI and I had to include a VALIDATION section for being able to send 
values as variables for filtering. I wonder why it didn't allow me specify 
something like "^[TRUE|FALSE]$" or "^TRUE|FALSE$" to validate a boolean value 
but "^[A-Z]{4,5}$".
However, I don't know if it's possible to define some well-known regex flags in 
code like "[:INTEGER:]" for "^[0-9]+$", "[:DOUBLE:]" for "^[0-9]+[.][0-9]+$" or 
"[:BOOLEAN:]" for "^[TRUE|FALSE]$" or "^[tT|fF]$". I understand that leaving it 
open is more flexible and it's ok, but perhaps adding these flags can be easier 
to use. I don't know, what do you think ?


MSc. Carlos Ruiz
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Copy mapserv.exe problem

[Carlos Ruiz]

Stefan,
If you have several URLs then you have to assign the map CGI variable based on 
the URL request, this is done in http.conf (Apache).

   On Wednesday, October 30, 2019, 9:01:24 AM CST, StefanWebViewer 
 wrote:  
 
 Hey!
I had already formulated an entry recently in which I asked for the error
message "msCGILoadMap (): Web application error. CGI variable" map "is not
set." asked.
Now I think I have found a more accurate diagnosis. For our project we need
several mapserv.exe, because we present different maps (Mapfiles) to
different users. Every time I come up with a new copy of the mapserv.exe
this error message follows. Does anyone know this problem? Does something
have to be considered when copying this file? Thank you very much!



--
Sent from: http://osgeo-org.1560.x6.nabble.com/Mapserver-User-f4226646.html
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] dynamic line pattern

[Carlos Ruiz]

Perhaps you should define different classes in the LAYER section and draw the 
right one through the CLASSITEM tag.


Carlos Ruiz
 

On Wednesday, March 27, 2019, 11:10:33 AM CST, Sven Schroeter 
 wrote:  
 
   Hi,
 
 I have a line Layer and want to change the pattern dynamicly from the 
attribute table.
 Is it possible?
 
 
 e.g. I have this working:
 
     CLASS
  NAME "buslines"
         STYLE
             COLOR [linecolor]
             WIDTH 4
             PATTERN 40 10 END
         END
  END  # CLASS
 
 
 and I want to get the pattern from an attribute:
 
 
     CLASS
  NAME "buslines"
         STYLE
             COLOR [linecolor]
             WIDTH 4
             PATTERN [pattern] END
         END
  END  # CLASS
 
 but this dont work. Any hint?
 
 Thanks
 Sven  
  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Strange performance problem in mapserver

[Carlos Ruiz]

Ahlah,
Mapserver does the following that should take some additional 
time:encode(ST_AsBinary(ST_Force_2D("point"),'NDR'),'hex') as geomYou can 
execute the whole query in PostgreSQL and notice the increase of time.
One question: s.notice_radius FROM (SELECT * FROM roronline.settings LIMIT 1) 
AS sis equal to 750 ? or is it smaller ?
It is a good practice to sort the query before apply a limit.

Cheers,
https://www.linkedin.com/in/cruizch
On Tuesday, September 4, 2018, 7:50:39 AM CDT, ahlah 
 wrote:  
 
 I try to show a polygon on map by creating a buffer around point in Postgis
(by ST_Buffer) but Mapserver has a strange performance problem.
If I put hardcoded radius to ST_Buffer query, rendering takes about 10
seconds although query result is empty. If I set the same value to radius by
reading it from another db table, rendering takes only 300ms. Attached logs
clarifies the sequences:  map_slow.log
  , 
map_fast.log   
Problem is not in Postgis because both queries takes about 200ms if I run
them on pgAdmin.
Am I doing something wrong or is it a bug or feature in MapServer? I have
tested it in MapServer 5 and MapServer 7 and result is same.



--
Sent from: http://osgeo-org.1560.x6.nabble.com/Mapserver-User-f4226646.html
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] php mapscript problem

[Carlos Ruiz]

Sven,
I haven't worked with Mapscript and IIS. However, I always free the map before 
unsetting it on PHP
$oMap->free();unset($oMap);

Why don't you try this and see what happens


On Friday, November 24, 2017, 9:04:16 AM CST, Sven Schroeter 
 wrote:  
 
 Hi,

I write many mapfiles from an application to the file system under Windows
and IIS.
Another script loads this mapfiles and checks if it is the right syntax.
If there is an syntax error in the mapfile I'll get an exeption:

try {
    $oMap = ms_newMapobj($mymapfile);
} catch (Exception $e) {
    echo 'Exception: ',  $e->getMessage(), "\n";
    exit;
}

But after I opened the mapfile with newMapobj I can't delete (with unlink)
or update the file because of a permission denied warnings.
How can I unset the loaded mapfile? Everything I tried did not work. 
Or is there another way to check the syntax of a mapfile (with includes)?

Thanks Sven








___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] php Mapscript queryByAttributes

[Carlos Ruiz]

Regex worked as a LIKE workaround. The backend database is PostgreSQL 9.5.9.

   On Wednesday, October 11, 2017, 4:28:27 PM CDT, Lime, Steve D (MNIT) 
<steve.l...@state.mn.us> wrote:  
 
 
What’s the backend database – it’s possible the IN operator is screwy for that 
driver? For the LIKE operator I should have remembered that MapServer doesn’t 
support that operator, try a regex instead:
 
  
 
 queryByAttributes("municipio", "(‘[municipio]’ ~ 'G.*')", MS_MULTIPLE);
 
  
 
Steve
 
  
 
From: Carlos Ruiz [mailto:boolean10...@yahoo.com]
Sent: Wednesday, October 11, 2017 4:03 PM
To: mapserver-users@lists.osgeo.org; Sven Schroeter <schroe...@netgis.de>; 
Lime, Steve D (MNIT) <steve.l...@state.mn.us>
Subject: Re: RE: [mapserver-users] php Mapscript queryByAttributes
 
  
 
Hey Steve,
 
  
 
> the IN operator works off a delimited list, try queryByAttributes("gid", 
> "([gid] IN ‘100,101’)", MS_MULTIPLE);. Any whitespace > is considered part of 
> the tokens in a list.
 
  
 
I have tried this and it doesn't work. There's a query error because Mapserver 
try to add the following:and ("gid"'100,101')
 
  
 
> This is close, it’s a logical expression but you’re comparing a number 
> against a string. It should be
 
> queryByAttributes("municipio", "(‘[municipio]’ LIKE 'G%')", MS_MULTIPLE);
 
  
 
I have tried this and it doesn't work. There's a query error because Mapserver 
try to add the following:and ("municipio"::text'G%')
 
  
 
Maybe this happens because the MS4W version (3.1.3) with Mapserver CGI 7.0.1
 
  
 
  
 
On Wednesday, October 11, 2017, 2:31:41 PM CDT, Lime, Steve D (MNIT) 
<steve.l...@state.mn.us> wrote:
 
  
 
  
 
The query syntax is given in MapServer expression syntax. I think there’s a 
logical expression for why you’re seeing these results:
 
 
 
  queryByAttributes("gid", "gid > 100", MS_MULTIPLE) // does not found anything
 
 
 
is evaluated as gid = “gid > 100”. Valid but not what you’re looking for. Your 
last example is the right way to do it - queryByAttributes("gid", "([gid] > 
100)", MS_MULTIPLE);. If MapServer sees the qstring is a logical expression 
then it ignores the qitem.
 
 
 
  queryByAttributes("gid", "100", MS_MULTIPLE) // found one result
 
 
 
is evaluated as gid = 100 which makes sense.
 
 
 
  queryByAttributes("municipio", "'GUADALAJARA'", MS_MULTIPLE) // found one 
result
 
 
 
is evaluated as municipio = GUADALAJARA which makes sense. I don’t think you 
need the interior quotes around GUADALAJARA though.
 
 
 
  queryByAttributes("municipio", "municipio LIKE 'G%'", MS_MULTIPLE) // does 
not found anything
 
 
 
like the first example this evaluates as municipio = "municipio LIKE 'G%'", not 
what you want. See below…
 
 
 
  queryByAttributes("gid", "([gid] IN (100, 101))", MS_MULTIPLE); // query error
 
 
 
the IN operator works off a delimited list, try queryByAttributes("gid", 
"([gid] IN ‘100,101’)", MS_MULTIPLE);. Any whitespace is considered part of the 
tokens in a list.
 
 
 
  queryByAttributes("municipio", "([municipio] LIKE 'G%')", MS_MULTIPLE); // 
query error
 
 
 
This is close, it’s a logical expression but you’re comparing a number against 
a string. It should be queryByAttributes("municipio", "(‘[municipio]’ LIKE 
'G%')", MS_MULTIPLE);
 
 
 
Steve
 
 
 
From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org]On Behalf 
Of Carlos Ruiz
Sent: Wednesday, October 11, 2017 1:36 PM
To: mapserver-users@lists.osgeo.org; Sven Schroeter <schroe...@netgis.de>
Subject: Re: [mapserver-users] php Mapscript queryByAttributes
 
 
 
Sven,
 
 
 
Doing some tests, queryByAttributes does not accept LIKE nor IN, just single 
values or simple operators (I am using PostGIS).
 
 
 
queryByAttributes("gid", "gid > 100", MS_MULTIPLE) // does not found anything
 
queryByAttributes("gid", "100", MS_MULTIPLE) // found one result
 
queryByAttributes("municipio", "'GUADALAJARA'", MS_MULTIPLE) // found one result
 
queryByAttributes("municipio", "municipio LIKE 'G%'", MS_MULTIPLE) // does not 
found anything
 
queryByAttributes("gid", "([gid] IN (100, 101))", MS_MULTIPLE); // query error
 
queryByAttributes("municipio", "([municipio] LIKE 'G%')", MS_MULTIPLE); // 
query error
 
queryByAttributes("gid", "([gid] > 100)", MS_MULTIPLE); // found 25 results
 
 
 
MS4W version is 3.1.3
 
 
 
Try to solve it by using FILTER, which allows more complex expressions:
 
 
 
$layer->setFilter("gid IN (100, 101)");
 
 
 
 
 
Cheers
 
 
 
On Wednesday, October 11, 2017, 10:55:17 AM CDT, Sven Schroeter 

Re: [mapserver-users] php Mapscript queryByAttributes

[Carlos Ruiz]

Hey Steve,
> the IN operator works off a delimited list, tryqueryByAttributes("gid", 
> "([gid] IN ‘100,101’)", MS_MULTIPLE);. Any whitespace > is considered part of 
> the tokens in a list.
I have tried this and it doesn't work. There's a query error because Mapserver 
try to add the following: and ("gid"'100,101')
> This is close, it’s a logical expression but you’re comparing a number 
> against a string. It should be > queryByAttributes("municipio", 
> "(‘[municipio]’ LIKE 'G%')", MS_MULTIPLE);  
I have tried this and it doesn't work. There's a query error because Mapserver 
try to add the following: and ("municipio"::text'G%')

Maybe this happens because the MS4W version (3.1.3) with Mapserver CGI 7.0.1

On Wednesday, October 11, 2017, 2:31:41 PM CDT, Lime, Steve D (MNIT) 
<steve.l...@state.mn.us> wrote:  
 
 
The query syntax is given in MapServer expression syntax. I think there’s a 
logical expression for why you’re seeing these results:
 
  
 
  queryByAttributes("gid", "gid > 100", MS_MULTIPLE) // does not found anything
 
  
 
is evaluated as gid = “gid > 100”. Valid but not what you’re looking for. Your 
last example is the right way to do it -queryByAttributes("gid", "([gid] > 
100)", MS_MULTIPLE);. If MapServer sees the qstring is a logical expression 
then it ignores the qitem.
 
  
 
 queryByAttributes("gid", "100", MS_MULTIPLE) // found one result
 
  
 
is evaluated as gid = 100 which makes sense.
 
  
 
 queryByAttributes("municipio", "'GUADALAJARA'", MS_MULTIPLE) // found one 
result
 
  
 
is evaluated as municipio =GUADALAJARA which makes sense. I don’t think you 
need the interior quotes around GUADALAJARA though.
 
  
 
 queryByAttributes("municipio", "municipio LIKE 'G%'", MS_MULTIPLE) // does not 
found anything
 
  
 
like the first example this evaluates asmunicipio = "municipio LIKE 'G%'", not 
what you want. See below…
 
  
 
 queryByAttributes("gid", "([gid] IN (100, 101))", MS_MULTIPLE); // query error
 
  
 
the IN operator works off a delimited list, tryqueryByAttributes("gid", "([gid] 
IN ‘100,101’)", MS_MULTIPLE);. Any whitespace is considered part of the tokens 
in a list.
 
  
 
 queryByAttributes("municipio", "([municipio] LIKE 'G%')", MS_MULTIPLE); // 
query error
 
  
 
This is close, it’s a logical expression but you’re comparing a number against 
a string. It should bequeryByAttributes("municipio", "(‘[municipio]’ LIKE 
'G%')", MS_MULTIPLE);
 
  
 
Steve
 
  
 
From: mapserver-users [mailto:mapserver-users-boun...@lists.osgeo.org]On Behalf 
Of Carlos Ruiz
Sent: Wednesday, October 11, 2017 1:36 PM
To: mapserver-users@lists.osgeo.org; Sven Schroeter <schroe...@netgis.de>
Subject: Re: [mapserver-users] php Mapscript queryByAttributes
 
  
 
Sven,
 
  
 
Doing some tests, queryByAttributes does not accept LIKE nor IN, just single 
values or simple operators (I am using PostGIS).
 
  
 
queryByAttributes("gid", "gid > 100", MS_MULTIPLE) // does not found anything
 
queryByAttributes("gid", "100", MS_MULTIPLE) // found one result
 
queryByAttributes("municipio", "'GUADALAJARA'", MS_MULTIPLE) // found one result
 
queryByAttributes("municipio", "municipio LIKE 'G%'", MS_MULTIPLE) // does not 
found anything
 
queryByAttributes("gid", "([gid] IN (100, 101))", MS_MULTIPLE); // query error
 
queryByAttributes("municipio", "([municipio] LIKE 'G%')", MS_MULTIPLE); // 
query error
 
queryByAttributes("gid", "([gid] > 100)", MS_MULTIPLE); // found 25 results
 
  
 
MS4W version is 3.1.3
 
  
 
Try to solve it by using FILTER, which allows more complex expressions:
 
  
 
$layer->setFilter("gid IN (100, 101)");
 
  
 
  
 
Cheers
 
  
 
On Wednesday, October 11, 2017, 10:55:17 AM CDT, Sven Schroeter 
<schroe...@netgis.de> wrote:
 
  
 
  
 
Hi,
 
  
 
Old Server: PHP 5.4.36 with MS 6.4.1 (MS4W)
 
New Server: PHP 5.6.31 with MS 7.0.6 (MS4W 3.2.2)
 
  
 
My Test Script:
 
  
 
$qfield = 'gid';
 
$qstring = "gid IN (1,2,3)";
 
@$datQuery = $query_layer->queryByAttributes($qfield,$qstring,MS_MULTIPLE);
 
  
 
Works fine on the old Server, on the new Server no result.
 
  
 
I have tried to change the query expression, i.e.:
 
$qstring = "('[gid]' in '1,2,3')";
 
  
 
No result on old server and new...
 
  
 
How can I get it run on MS7?
 
  
 
  
 
  
 
Thanks + greetings 
 
Sven
 
 
 
  
 
  
 
**
 
NETGIS GbR
 
Benediktinerstr. 32a
 
54292 Trier
 
Tel.: 0651-1704731
 
Fax: 0651-1704733
 
schroe...@netgis.de
 
www.netgis.de
 
  
 
  
 
___
 
mapserver-users mailing list
 
mapserver-users@lists.osgeo.org
 
https://lists.osgeo.org/mailman/listinfo/mapserver-users
   ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] map server error message loadSymbol(): Unknown identifier. Parsing error near (GAP):(line33)

[Carlos Ruiz]

You can get older QGIS versions just by browsing the downloads folder
Index of /downloads

| 
| 
|  | 
Index of /downloads


 |

 |

 |


QGIS 1.4 for Windows and QGIS 1.6 source code (tar.gz) are the oldest versions 
you can find there.
On Monday, September 18, 2017, 3:30:24 PM CDT, e.arapostathis 
 wrote:  
 
 Hello Jeff, To be honest I had some time to use map server and I also saw that 
the map server plugin is not available to the new qgis versions. I personally 
took some old map files I had (which were generated by that plugin) and started 
maintaining them and improving them by adding  some parameters from 
documentation and other map file templates. The 1.8 version for sure has that 
very useful plugin you mention and whoever has that version is "lucky" as it is 
not available in the official qgis site at least the last time I checked. 
PS. Whoever needs that version there is a copy in my hard drive :)


Enviado desde mi smartphone Samsung Galaxy.
 Mensaje original De: Jeff McKenna 
 Fecha: 18/9/17 16:04 (GMT+02:00) Para: 
mapserver-users@lists.osgeo.org Asunto: Re: [mapserver-users] map server error 
message loadSymbol(): Unknown identifier. Parsing error near (GAP):(line33) 
By the way Stathis, which plugin and QGIS version are you using to 
generate the mapfile?  I am not aware of a plugin that works with recent 
QGIS.

(I keep a running QGIS 1.8 here, just to have a working and reliable 
"QGIS mapfile export" tool.  I more recent "RT Mapfile Export" plugin is 
not being maintained.

However please let me know if I am incorrect.

-jeff



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



On 2017-09-18 5:34 AM, e.arapostathis wrote:
> Thank you
> 
> I have resolved it.
> 
> 
> 
> Enviado desde mi smartphone Samsung Galaxy.
> 
>  Mensaje original 
> De: Havard Tveite 
> Fecha: 18/9/17 9:49 (GMT+02:00)
> Para: mapserver-users@lists.osgeo.org
> Asunto: Re: [mapserver-users] map server error message loadSymbol(): 
> Unknown identifier. Parsing error near (GAP):(line33)
> 
> For examples see:
> 
> http://mapserver.org/mapfile/symbology/construction.html#use-of-the-pattern-and-gap-parameters
> 
> Håvard
> 
> On 15. sep. 2017 14:44, Rahkonen Jukka (MML) wrote:
>  > Hi,
>  >
>  > When I say ”GAP” I mean “GAP”. You have that in the “railway” symbol.
>  >
>  > SYMBOL
>  >
>  >      NAME 'railway'
>  >
>  >      TYPE TRUETYPE
>  >
>  >      FONT 'Tahoma'
>  >
>  >      CHARACTER '|'
>  >
>  >      GAP 10
>  >
>  >    END
>  >
>  > There are better experts on this list but I guess that GAP should not be
>  > there http://www.mapserver.org/mapfile/symbol.html.
>  >
>  > I can read from http://www.mapserver.org/mapfile/style.html#style a
>  > sentence “New in version 6.0: moved from SYMBOL”
>  >
>  > I would read migration info from 5.x -> 6.0. Perhaps there is explained
>  > what to do with “GAP” that used to be inside SYMBOL. First aid is to
>  > comment out that line. Then you should see your map or at least go
>  > further to the next error.
>  >
>  > -Jukka Rahkonen-
>  >
>  > *Lähettäjä:* Stathis Arapostathis [mailto:e.arapostat...@gmail.com]
>  > *Lähetetty:* 15. syyskuuta 2017 15:35
>  > *Vastaanottaja:* Rahkonen Jukka (MML) 
> 
>  > *Aihe:* RE: [mapserver-users] map server error message loadSymbol():
>  > Unknown identifier. Parsing error near (GAP):(line33)
>  >
>  > Hi,
>  >
>  >    When you mean “GAP”you mean something like an additional space?
>  >
>  > Here is the symbols.sym file:
>  >
>  > SYMBOLSET
>  >
>  > #markerset
>  >
>  > SYMBOL
>  >
>  >    NAME 'cities'
>  >
>  >    TYPE PIXMAP
>  >
>  >    IMAGE 'cities.gif'
>  >
>  > END
>  >
>  > SYMBOL
>  >
>  >    NAME 'mountain'
>  >
>  >    TYPE PIXMAP
>  >
>  >    IMAGE 'mountain.gif'
>  >
>  > END
>  >
>  > SYMBOL
>  >
>  >    NAME 'river'
>  >
>  >    TYPE PIXMAP
>  >
>  >    IMAGE 'river.gif'
>  >
>  > END
>  >
>  > SYMBOL
>  >
>  >    NAME 'island'
>  >
>  >    TYPE PIXMAP
>  >
>  >    IMAGE 'island.gif'
>  >
>  > END
>  >
>  > SYMBOL
>  >
>  >      NAME 'railway'
>  >
>  >      TYPE TRUETYPE
>  >
>  >      FONT 'Tahoma'
>  >
>  >      CHARACTER '|'
>  >
>  >      GAP 10
>  >
>  >    END
>  >
>  > Symbol
>  >
>  > Name 'tent'
>  >
>  > Type VECTOR
>  >
>  > FILLED TRUE
>  >
>  > Points
>  >
>  > 0 1
>  >
>  > .5 0
>  >
>  > 1 1
>  >
>  > .75 1
>  >
>  > .5 .5
>  >
>  > .25 1
>  >
>  > 0 1
>  >
>  > END
>  >
>  > END
>  >
>  > Symbol
>  >
>  > Name 'star'
>  >
>  > Type VECTOR
>  >
>  > FILLED TRUE
>  >
>  > Points
>  >
>  > 0 .375
>  >
>  > .35 .375
>  >
>  > .5 0
>  >
>  > .65 .375
>  >
>  > 1 .375
>  >
>  > .75 .625
>  >
>  > .875 1
>  >
>  > .5 .75
>  >
>  > .125 1
>  >
>  > .25 .625
>  >
>  > END
>  >
>  > END
>  >
>  > Symbol
>  >
>  > Name 'triangle'
>  >
>  > Type VECTOR
>  >
>  > FILLED TRUE
>  >
>  > Points
>  >
>  > 0 1
>  >
>  > .5 0
> 

Re: [mapserver-users] rotate and fit based on polygon

[Carlos Ruiz]

Travis,
Do you have the polygons in PostGIS ? Maybe you can get the extent by using 
st_extent(geom) and retrieve it on PHP/Python to set the map extent. You could 
also get a margin by multiplying extent b 1.1 (10%).


On Thursday, September 7, 2017, 1:27:06 PM CDT, Travis Kirstine 
 wrote:  
 
 I have a bunch of polygons that represent 8.5 x 11 printed map sheets.  I'd 
like to produce images for each sheet that best fits the polygon within the 
outputted image.  We've tried using mapscript by setting the map extent based 
on the bbox of the source polygon and rotation but results aren't great 
depending on the orientation of the source polygon.  Is there a way to set the 
"extent" based on a polygon? ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Mapserver data point on map

[Carlos Ruiz]

If you have PIXMAP symbols defined in your MAP file, be sure to assign them to 
the points by adding the following in your code:

$style->set("symbolname", "");

I remember that when adding points in a static MAP file I have to add a POINTS 
1 1 END symbol for the points to be drawn. Perhaps this is what is happening to 
you.

Best regards
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Uncaught exception 'MapScriptException'

[Carlos Ruiz]

Ankur,
Did you check the values that the $extent_to_set array have ? Are they numbers 
? Because the error message explains "mapObj::setExtent() expects parameter 1 
to be double, string given".

  From: ankur chitranshi 
 To: mapserver-users  
 Sent: Monday, August 29, 2016 1:21 AM
 Subject: [mapserver-users] Uncaught exception 'MapScriptException'
   
Dear All,

How to resolve this error,
Fatal error: Uncaught exception 'MapScriptException' with message 
'mapObj::setExtent() expects parameter 1 to be double, string given' in 
C:\ms4w\Apache\htdocs\indore\index.php:26Stack trace:#0 
C:\ms4w\Apache\htdocs\indore\index.php(26): mapObj->setExtent('minx', 'miny', 
'maxx', 'maxy')#1 C:\ms4w\Apache\htdocs\indore\index.php(386): 
zoom1(Object(mapObj), Array, -2, -1)#2 {main} thrown in 
C:\ms4w\Apache\htdocs\indore\index.php on line 26
my code is 
$map->setextent($extent_to_set[0],$extent_to_set[1],$extent_to_set[2],$extent_to_set[3]);$my_point
 = ms_newpointObj();
$my_point->setXY($_POST["map_x"],$_POST["map_y"]);$my_extent = 
ms_newrectObj();$my_extent->setextent($extent_to_set[0],$extent_to_set[1],$extent_to_set[2],$extent_to_set[3]);if($zoom!=2)$map->zoompoint($zoom_factor,$my_point,$map->width,$map->height,
 $my_extent);


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

   ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] WFS Client...

[Carlos Ruiz]

OK. If you are doing a request to a WFS layer from an OpenLayers application, 
you can see the request by pressing SHIFT+CTRL+J in FireFox and enable the 
Network toggle button.
You will see the full request when hovering the URL
GET 
http://localhost/cgi-bin/accidentes?SERVICE=WMS=1.3.0=GetMap=image%2Fpng=true=Estaciones%20Tren%20Ligero%20-%20Tipo=EPSG%3A4326==2025=962=20.624878406524658%2C-103.43881130218506%2C20.707404613494873%2C-103.26500415802002
 [HTTP/1.1 200 OK 361ms]

  From: "Lime, Steve D (MNIT)" <steve.l...@state.mn.us>
 To: Carlos Ruiz <boolean10...@yahoo.com>; "mapserver-users@lists.osgeo.org" 
<mapserver-users@lists.osgeo.org> 
 Sent: Thursday, February 18, 2016 3:06 PM
 Subject: RE: [mapserver-users] WFS Client...
   
#yiv8480966943 #yiv8480966943 -- _filtered #yiv8480966943 
{font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv8480966943 
{panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv8480966943 
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv8480966943 
#yiv8480966943 p.yiv8480966943MsoNormal, #yiv8480966943 
li.yiv8480966943MsoNormal, #yiv8480966943 div.yiv8480966943MsoNormal 
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv8480966943 a:link, 
#yiv8480966943 span.yiv8480966943MsoHyperlink 
{color:blue;text-decoration:underline;}#yiv8480966943 a:visited, #yiv8480966943 
span.yiv8480966943MsoHyperlinkFollowed 
{color:purple;text-decoration:underline;}#yiv8480966943 
p.yiv8480966943msonormal, #yiv8480966943 li.yiv8480966943msonormal, 
#yiv8480966943 div.yiv8480966943msonormal 
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv8480966943 
p.yiv8480966943msochpdefault, #yiv8480966943 li.yiv8480966943msochpdefault, 
#yiv8480966943 div.yiv8480966943msochpdefault 
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv8480966943 
span.yiv8480966943msohyperlink {}#yiv8480966943 
span.yiv8480966943msohyperlinkfollowed {}#yiv8480966943 
span.yiv8480966943emailstyle17 {}#yiv8480966943 p.yiv8480966943msonormal1, 
#yiv8480966943 li.yiv8480966943msonormal1, #yiv8480966943 
div.yiv8480966943msonormal1 
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv8480966943 
span.yiv8480966943msohyperlink1 
{color:#0563C1;text-decoration:underline;}#yiv8480966943 
span.yiv8480966943msohyperlinkfollowed1 
{color:#954F72;text-decoration:underline;}#yiv8480966943 
span.yiv8480966943emailstyle171 {color:windowtext;}#yiv8480966943 
p.yiv8480966943msochpdefault1, #yiv8480966943 li.yiv8480966943msochpdefault1, 
#yiv8480966943 div.yiv8480966943msochpdefault1 
{margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv8480966943 
span.yiv8480966943EmailStyle27 {color:#1F497D;}#yiv8480966943 
.yiv8480966943MsoChpDefault {font-size:10.0pt;} _filtered #yiv8480966943 
{margin:1.0in 1.0in 1.0in 1.0in;}#yiv8480966943 div.yiv8480966943WordSection1 
{}#yiv8480966943 The WFS server is not under my control, so no access log.    
From: Carlos Ruiz [mailto:boolean10...@yahoo.com]
Sent: Thursday, February 18, 2016 3:06 PM
To: Lime, Steve D (MNIT) <steve.l...@state.mn.us>; 
mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] WFS Client...    Steve,    You can check the 
Apache "access.log" file and watch for the HTTP GET requests. You will find 
something like this:

 

 127.0.0.1 - - [16/Dec/2015:16:59:31 -0600] "GET 
/cgi-bin/landsat8?SERVICE=WMS=1.3.0=GetMap=image%2Fpng=true=2014=256=256=EPSG%3A4326==22.5%2C-101.25%2C33.75%2C-90
 HTTP/1.1" 200 412       From: "Lime, Steve D (MNIT)" <steve.l...@state.mn.us>
To: "mapserver-users@lists.osgeo.org" <mapserver-users@lists.osgeo.org>
Sent: Thursday, February 18, 2016 3:01 PM
Subject: [mapserver-users] WFS Client...    Hi all: Is there any way to log the 
request URL and POST data associated with MapServer WFS layers? That info 
doesn’t seem to be showing up in debug logs and it would be helpful to see 
exactly what is being sent to the WFS server.   Steve 
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users 

  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] WMS layer name with spaces

[Carlos Ruiz]

I just have read about the problem when calling a WMS layer from a map file 
which has spaces in the layer's name and I want to help. I already have a local 
WMS server with Mapserver, I have several layers with spaces in their name, and 
I have made a .MAP file to test as as a WMS client. It works just fine when the 
layer name has spaces. However, when I tried to test a layer which has an 
accent in a vowel it fails.

I suppose that ArcGIS server is not decoding the URL properly (%20 for " ").___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] display only one district

[Carlos Ruiz]

Rishi,
From a MAP file approach, you can use the FILTER tag inside of the LAYER 
section:
FILTER [string]   
  - This parameter allows for data specific attribute filtering that is 
doneat the same time spatial filtering is done, but before any CLASSexpressions 
are evaluated. For OGR and shapefiles the string is simplya mapserver regular 
expression. For spatial databases the string is aSQL WHERE clause that is valid 
with respect to the underlying database.
  -

  - For example: FILTER ([type]=’road’ and [size]2)
In a static way, you will need to have two MAP files (one without FILTER and 
another with FILTER) and you have to configure each project to point to the 
right MAP file.
 Mtro. Carlos Ruiz

  From: rishi rish...@gmail.com
 To: jmcke...@gatewaygeomatics.com; mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.org 
 Sent: Friday, March 20, 2015 6:43 AM
 Subject: [mapserver-users] display only one district
   
Hi all Iam using Postgres database to diasplay districts on the google map
It is working.But now i want to display only one district instead of 50.In my 
database there are 50 districts data, but i want to display only one.And also i 
have to use the same mapfile in to 3 projects, in one project all the districts 
has to be displayed and in one project only one district has to be display.
How to do thisplz send me the code
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] change htdocs directory

[Carlos Ruiz]

TC,
If you want to change the root document path, then inside httpd.conf you must 
change the DocumentRoot value. MS4W has it like this:

DocumentRoot /ms4w/Apache/htdocs

So you could change it to
DocumentRoot /ms4w/geomoose
Then http://localhost will lead you to the /ms4w/geomoose contents. Remember 
always to restart the Apache service after modifying httpd.conf
If you want to add a path to be reached by an URL (i.e. 
http;//localhost/geomoose), then you have to create a file called 
httpd_geomoose inside the httpd.d directory with the following configuration:
Alias /geomoose /ms4w/apps/geomoose/

Directory /ms4w/apps/geomoose2/htdocs/
  AllowOverride None
  Options Indexes FollowSymLinks Multiviews
  Order allow,deny
  Allow from all
/Directory

Then restart Apache service. It is important that the file name starts with 
httpd_, because Apache looks for this pattern when it starts to load its 
configuration.

Another thing you have to watch (I think this can be happening to you) is that 
if you add a slash to the alias in the httpd_xxx file (i.e. Alias /geomoose/), 
then you have to call the URL with the slash at the end, otherwise it doesn't 
work, you will receive the HTTP 1.1 404 error. That is why I prefeer to remove 
it from alias.

Try this !

Mtro. Carlos Ruiz

  From: geo.grae...@web.de geo.grae...@web.de
 To: TC Haddad tchad...@gmail.com; mapserver-users@lists.osgeo.org 
 Sent: Friday, January 30, 2015 12:10 PM
 Subject: Re: [mapserver-users] change htdocs directory
   
Unfortunately, it still does not work.http://localhost; displays the ms4w 
start page, but http://localhost/geomoose2/geomoose.html; is empty (error 
404). Can you help me again? Thank you in advance! Gesendet: Freitag, 30. 
Januar 2015 um 18:11 Uhr
Von: TC Haddad tchad...@gmail.com
An: geo.grae...@web.de
Betreff: Re: Re: [mapserver-users] change htdocs directoryWell, the URL you 
must use will have to contain the name of the alias that you put in http.d
 so if your alias is called geomoose then your URL would be
 http://localhost/geomoose/
 Here is the example http.d file that comes with Geomoose for MS4W web mercator 
demo (http://www.geomoose.org/downloads/GeoMOOSE-2.7.1-MS4W.zip)
 -- fwd --- 
Alias /geomoose2/ /ms4w/apps/geomoose2/htdocs/

Directory /ms4w/apps/geomoose2/htdocs/
  AllowOverride None
  Options Indexes FollowSymLinks Multiviews
  Order allow,deny
  Allow from all
/Directory

 In this example the alias is called geomoose2, so the URL will be

http://localhost/geomoose2/ Normally all you have to do with the package above 
is unzip the contents into the MS4W directory and restart Apache. The package 
assumes that you did not mess with the other parts of MS4W...
 Tanya  On Fri, Jan 30, 2015 at 9:04 AM, geo.grae...@web.de wrote:
Hi Tanya, thank you for your answer! I created the file with content as 
decribed in the instruction of README_HTTPD.txt and restarted the Apache, but 
still I can not go to the changed htdocs directory. Anything else what I have 
to do?  Gesendet: Freitag, 30. Januar 2015 um 17:54 Uhr
Von: TC Haddad tchad...@gmail.com
An: geo.grae...@web.de
Betreff: Re: [mapserver-users] change htdocs directoryHi Geograefin
you have to put a file in
 ms4w/httpd.d/
 with your geomoose home location . leace the regular Apache http.conf file 
alone.
 look at the other httpd example files in ms4w for example of the syntax.
 Tanya On Fri, Jan 30, 2015 at 2:54 AM, geo.grae...@web.de wrote:
Hello, I installed the package MS4W 3.0.6. Now I will change the directory from 
ms4w/Apache/htdocs to ms4w/apps/geomoose/htdocs. Where I have to change the 
directory settings? A change in the httpd.conf file (ms4w/Apache/conf) did not 
lead to success. I would be very grateful if you help me! Thank you! Geograefin
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] erros llamar mapinfo

[Carlos Ruiz]

Eduardo,
You don't provide more information about what are you trying to do, but I can 
suggest the following. In the LAYER section you must have a TEMPLATE label 
which must refer to a HTML file.

No tengo información sobre lo que intentas hacer, pero puedo sugerir lo 
siguiente. En la sección LAYER debes de tener una etiqueta TEMPLATE, la cual 
debe hacer referencia a un archivo HTML.
LAYER
...
TEMPLATE FOO.HTML...
END

 Mtro. Carlos Ruiz

  From: Eduardo Arévalo eareval...@gmail.com
 To: mapserver-users@lists.osgeo.org 
 Sent: Monday, December 1, 2014 2:44 PM
 Subject: [mapserver-users] erros llamar mapinfo
   
hola  a todos me podrían dar algunas pistas para resolver este error:mapserv(): 
Web application error. No template provided.

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] PostGIS Connection Failure

[Carlos Ruiz]

Hi Krishna,


On Wed, 6/25/14, Krishna Priya Patury krishna.pat...@gmail.com wrote:

 Subject: Re: [mapserver-users] PostGIS Connection Failure
 To: humbe...@pastoraldacrianca.org.br
 Cc: mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
 Date: Wednesday, June 25, 2014, 10:13 AM

 Thanks for responding. Would you please tell
 me how to check that? When I go to Network Proxy on the VM,
 Direct Connection to internet is selected. 


 Both Mapserver and Postgres on the
 same VM. Do you think something might still be blocking the
 port? I am able to open a psql connection just fine using
 the same port. What is even more confusing is a Mapserver
 application outside the VM is able to connect to the
 Database on the VM just fine.

This is really weird. Are you sure the application outside of your VM that 
works has the same connection string as the one that doesn't works ? Both 
applications (the one that works and the one that doesn´t) are using the same 
version of Mapserver ? Both applications (the one that works and the one that 
doesn´t) are hosted in the same machine/VM ?


Mtro. Carlos Ruiz
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] color attribute question

[Carlos Ruiz]

To achieve more flexibility as you want, you have to code a function with 
PL/pgSQL in PostgreSQL or with PHP/Python/Java/C# with Mapscript to define 
which is the base color (red, green, blue, yellow ...) and then to calculate 
the percent in the right RGB channel.


Cheers

Mtro. Carlos Ruiz


On Mon, 6/23/14, Do Wi dow...@gmail.com wrote:

 Subject: Re: [mapserver-users] color attribute question
 To: Carlos Ruiz boolean10...@yahoo.com
 Date: Monday, June 23, 2014, 2:56 PM
 
 thanks allot!
 Steve and another user here mentioned this path
 and it did work!only problem is that it cannot be
 changed later if for example the user chooses a blue
 gradient.
 
 how will i go about doing it with
 mapscript?
 maybe it relates to my question 
herehttp://gis.stackexchange.com/questions/102862/when-to-choose-mapscript-over-mapfile-or-vice-versa
 
 
 :-)
 thanks allot!dovi
 
 On Mon, Jun 23, 2014
 at 6:13 PM, Carlos Ruiz boolean10...@yahoo.com
 wrote:
 
 
 Do,
 If
 you want to do this without using mapscript, you can pull
 the gradient calculation as an attribute from your data
 table.
 
 
 ALTER TABLE mytable ADD COLUMN gradient_color
 VARCHAR;
 UPTATE mytable SET gradient_color = floor(gradient *
 255)::text || ' 0 0';
 
 Cheers
 
  Mtro. Carlos Ruiz
 
  

 On Monday, June 23, 2014 4:59 PM, Lime, Steve D
 (MNIT) steve.l...@state.mn.us
 wrote:
 
 
 
  
 
 You can compute a color
 string using PostgreSQL string functions: 
    
   SELECT percentage ||
 ‘ 0 0’ AS color FROM … 
    
 Steve 
    
 From: mapserver-users-boun...@lists.osgeo.org
 [mailto:mapserver-users-boun...@lists.osgeo.org]
 On Behalf Of Do Wi
 
 Sent: Sunday, June 22, 2014 3:50 PM
 
 To: mapserver-users@lists.osgeo.org
 
 Subject: [mapserver-users] color attribute
 question 
    
 
 hi! 
 
    
 
 
 i have this
 scenario: 
 
 
 i have a column in my
 postgis table which contains a double representing a
 percentage. 
 
 
    
 
 
 i want to color my
 polygons in a gradient fashion based on that
 number. 
 
 
    
 
 
 the docs states three
 ways to specify color: 
 
 
 1. three [1-255]
 numbers 
 
 
 2. hex
 string 
 
 
 3.
 [attribute] 
 
 
    
 
 
 but the attribute must
 be a string by itself in the same format as options 1 or
 2. 
 
 
    
 
 
 how can i achieve
 something like  
 
 
    
 
 
 COLOR [percentage]*255 0
 0 
 
 
 or 
 
 
 COLOR [percentage] 0
 0 
 
 
 if percentageis already
 0..255 
 
 
    
 
 
 for a red gradient for
 example?  
 
 
    
 
 
 thanks
 allot! 
 
 
 
 
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 
 http://lists.osgeo.org/mailman/listinfo/mapserver-users 
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] color attribute question

[Carlos Ruiz]

Do,

If you want to do this without using mapscript, you can pull the gradient 
calculation as an attribute from your data table.

ALTER TABLE mytable ADD COLUMN gradient_color VARCHAR;
UPTATE mytable SET gradient_color = floor(gradient * 255)::text || ' 0 0';

Cheers

 Mtro. Carlos Ruiz


On Monday, June 23, 2014 4:59 PM, Lime, Steve D (MNIT) 
steve.l...@state.mn.us wrote:
 


You can compute a color string using PostgreSQL string functions:
 
  SELECT percentage || ‘ 0 0’ AS color FROM …
 
Steve
 
From:mapserver-users-boun...@lists.osgeo.org 
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Do Wi
Sent: Sunday, June 22, 2014 3:50 PM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] color attribute question
 
hi!
 
i have this scenario:
i have a column in my postgis table which contains a double representing a 
percentage.
 
i want to color my polygons in a gradient fashion based on that number.
 
the docs states three ways to specify color:
1. three [1-255] numbers
2. hex string
3. [attribute]
 
but the attribute must be a string by itself in the same format as options 1 or 
2.
 
how can i achieve something like 
 
COLOR [percentage]*255 0 0
or
COLOR [percentage] 0 0
if percentageis already 0..255
 
for a red gradient for example? 
 
thanks allot!

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] QGIS vs Mapserver someone use wrong scale ?

[Carlos Ruiz]

Andrea,

I'm having the same problem with scales working with a WMS layer and QGIS.

I've defined my layer like this:

    
LAYER

        NAME 2011
        TYPE RASTER
        STATUS DEFAULT
        
        ...
                
        MINSCALEDENOM 25
        MAXSCALEDENOM 500

END


I can't get the image when I set the scale to 1:25. Trying with some 
discrete scales upwards, I find that the image finally shows at 1:335000.

So I don't know if is a QGIS or Mapserver problem, I'm performing some tests to 
see where the problem is, maybe that could help to find a solution.

Cheers from México


IC Carlos Ruiz




 From: Andrea Peri aperi2...@gmail.com
To: mapserver-users@lists.osgeo.org 
Sent: Monday, February 11, 2013 4:40 PM
Subject: [mapserver-users] QGIS vs Mapserver someone use wrong scale ?
 
Hi,

I set a class rule to show the label in this interval scale:

      LABEL
        COLOR 175 109 134
        OUTLINECOLOR 255 255 255
        OUTLINEWIDTH 1
        MAXSCALEDENOM 300100
        MINSCALEDENOM 1
        

After I try to test it with QGIS, but I see calling it with qgis the
show of labels in the scale are not so linear as I could guess.

infact

the label ARE NOT SHOWED at 1:299.990
the label ARE NOT SHOWED at 1:300.000
the label are showed at 1:300.001
the label are showed at 1:300.010
the label ARE NOT SHOWED at 1:300.050
the label are showed at 1:300.090
the label ARE NOT SHOWED at 1:300.100
the label ARE NOT SHOWED at 1:300.110
the label ARE NOT SHOWED at 1:300.150

So seem the limit of
1:300.100 I set in the mapfile is not so exactly used.

But I'm not able to understand if is a wrong QGIS calculation of scale
value or is a MapServer trouble.

Any hint is welcome

-- 
-
Andrea Peri
. . . . . . . . .
qwerty àèìòù
-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] MapServer and 24bit Images

[Carlos Ruiz]

José,

Yo presento imágenes de 3 bandas como WMS sin problema alguno. Debo decir que 
no uso de OUTPUTFORMAT en estos casos ya que desde los parámetros del URL se 
especifica el formato de salida (parámetro FORMAT).


Por lo que veo, estás queriendo acceder a una capa tipo raster desde una base 
de datos en Postgres.

¿ Integraste una capa raster a Postgres (gracias a que en las ultimas versiones 
de PostGIS se incluyó lo que era el proyecto WKTRaster) ? ¿ O estás queriendo 
acceder a un archivo raster directamente ? 


Desconozco si las directivas PROCESSING aplican para una capa raster en 
PostGIS, nunca he intentado trabajar con esto.


Saludos desde México



José,

I work with 3 bands images as WMS with no problem at all. I must say that i 
didn't use the OUTPUTFORMAT because I can specify the output format in the URL 
(FORMAT parameter).

As I see, you want to show a raster layer from a Postgres database.

¿ Do you added a raster layer into Postgres (thanks to the latest versions of 
PostGIS which added the WKTRaster project) ? or ¿ Do you want to access 
directly to a raster file ?

I don't know if the PROCESSING directives apply to a PostGIS raster layer, I've 
never tried to work with this.


Cheers from México

 
IC Carlos Ruiz




 From: José Pedro Santos zpsant...@hotmail.com
To: steve.l...@state.mn.us; mapserver-users@lists.osgeo.org 
Sent: Friday, December 7, 2012 8:35 AM
Subject: Re: [mapserver-users] MapServer and 24bit Images
 

 
Hi Steve, 

Thanks for the information. Basically I want only to display the layer (as WMS 
service) in the browser for testing or a real client. The layer have 3 bands 
and is a 24bit image

My MAPFILE is this one(OUTPUTFORMAT and LAYER parameters):

OUTPUTFORMAT # Parameter Outputformat
 NAME png24
 DRIVER GD/PNG
 MIMETYPE image/png;mode=24bit
 EXTENSION PNG
 IMAGEMODE RGB
END # End parameter Outputformat

LAYER # beginning of the layer parameter
 NAME fapartest
 TYPE RASTER
 STATUS ON
 DATA PG:host=localhost port=5432 dbname='mydb' user='postgres' 
password='' schema='public' table='mytable' mode='2'
 PROCESSING NODATA=0
 PROCESSING SCALE=AUTO
 PROCESSING BANDS=1,2,3
.

I don't have class parameter since I don't want to classify the map just 
visualize the information. Any idea?

Best Regards and thanks,

José Santos 




 From: steve.l...@state.mn.us
 To: zpsant...@hotmail.com; mapserver-users@lists.osgeo.org
 Subject: RE: [mapserver-users] MapServer and 24bit Images
 Date: Tue, 4 Dec 2012 19:26:01 +
 
 I display true-color imagery all the time. I suspect that's not what you're 
 trying to do though. You'll have to be more specific on format, perhaps post 
 a layer definition?
 
 Steve
 
 -Original Message-
 From: mapserver-users-boun...@lists.osgeo.org 
 [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Saint
 Sent: Monday, December 03, 2012 10:06 AM
 To: mapserver-users@lists.osgeo.org
 Subject: [mapserver-users] MapServer and 24bit Images
 
 Dear all, 
 
 I would like to have this confirmation, MapServer support 24bit image with 3 
 bands? I have one 24bit image 1 band and I can see in the browser but the 
 other with 3 bands I can't. Only appear the the outline line of the class e 
 not the image. 
 
 Many thanks
 José Santos 
 
 
 
 -
 José Santos
 GIS Analyst
 --
 View this message in context: 
 http://osgeo-org.1560.n6.nabble.com/MapServer-and-24bit-Images-tp5020409.html
 Sent from the Mapserver - User mailing list archive at Nabble.com.
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Problem with Mapserver 6.0.1 and PHP Mapscript

[Carlos Ruiz]

Nick,

Try the mapObj-save method to see what Mapserver dumps.

Cheers from México

 
IC Carlos Ruiz




 From: Nick Friedrich nick.friedr...@geolock.de
To: mapserver-users@lists.osgeo.org 
Sent: Thursday, February 16, 2012 10:25 AM
Subject: [mapserver-users] Problem with Mapserver 6.0.1 and PHP Mapscript
 
Hello,

I have a problem with Mapserver 6.0.1 and PHP Mapscript.
Until now I am working with Mapserver 5.2.

For testing purposes I created a minimal mapfile, just with name and symbolset. 
The symbolset file contains just one simple filled circle.
When I create a mapObj (tried old an new constructors) I get an empty Object 
(var_dump or print_r).  Non-object members like name or status are still there, 
when accessing them directly.
Set methods are also working for non-object members. Members, that are objects 
themselves, like projection, are not accessible.

I have no clue what could be the problem. The system configuration is the same 
as when using Mapserver 5.2.
PHP version is 5.2.17 (CGI). Version of other libraries (libpng, libgd, ...) 
meet the requirements.

Thanks for your help,
Nick


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] PostGIS query

[Carlos Ruiz]

Hi Julien,


 I usually use a view, but in this case there are a lot of tables 
 involved and I would like to avoid dozens of unnecessary JOIN


I think that you have a database design problem.

You can have a lot of tables which concerns to a different objects, but you 
need to show some information on a map which involves many of those tables. 
That's why you have to create different views or in the worst case, a super 
view as a spreadsheet.

I guess that's why you're talking about unnecessary JOINs, but in the end, 
you'll need to use them to create the multiple data sources or the super data 
source of your layers in the .MAP file.



IC Carlos Ruiz




 From: Julien Cigar jci...@ulb.ac.be
To: Carlos Ruiz boolean10...@yahoo.com 
Cc: mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org 
Sent: Wednesday, February 1, 2012 2:59 AM
Subject: Re: [mapserver-users] PostGIS query
 
On 01/31/2012 17:05, Carlos Ruiz wrote:
 Julien,

Hi Carlos,


 Have you tried with views ? When I need to map complex queries I build a
 view to just handle the where clauses.


I usually use a view, but in this case there are a lot of tables 
involved and I would like to avoid dozens of unnecessary JOIN

 Cheers from México
 IC Carlos Ruiz

 
 *From:* Julien Cigar jci...@ulb.ac.be
 *To:* mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org
 *Sent:* Tuesday, January 31, 2012 6:38 AM
 *Subject:* [mapserver-users] PostGIS query

 Hello,

 Is there a way to (deeply) modify the SQL query in a PostGIS layer?
 I would like to add some JOIN, additional WHERE clauses, etc
 As I'm afraid that Run-time Substitution isn't flexible enough for
 this case ... is there any other possibility, other than mapscript?

 I guess there is no possibility to define variables, conditions, etc in
 a .map file .. ?

 Thanks,
 Julien

 -- No trees were killed in the creation of this message.
 However, many electrons were terribly inconvenienced.

 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org mailto:mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users




-- 
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] PostGIS query

[Carlos Ruiz]

Julien,

Have you tried with views ? When I need to map complex queries I build a view 
to just handle the where clauses.

Cheers from México

 
IC Carlos Ruiz




 From: Julien Cigar jci...@ulb.ac.be
To: mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org 
Sent: Tuesday, January 31, 2012 6:38 AM
Subject: [mapserver-users] PostGIS query
 
Hello,

Is there a way to (deeply) modify the SQL query in a PostGIS layer?
I would like to add some JOIN, additional WHERE clauses, etc
As I'm afraid that Run-time Substitution isn't flexible enough for this case 
... is there any other possibility, other than mapscript?

I guess there is no possibility to define variables, conditions, etc in a .map 
file .. ?

Thanks,
Julien

-- No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] MS4W with an external Apache

[Carlos Ruiz]

Juan,

Lo que quiero entender es que tienes un servidor de producción que tiene 
instalado MS4W y además otra versión de Apache.

Nunca he intentado hacer lo que comentas. Supongo que tienes que igualar de 
alguna manera las configuraciones del archivo httpd.conf de la instalación de 
MS4W (módulos instalados, variables de entorno, etc), que se encuentra en 
/ms4w/Apache/conf.


Saludos desde México


Juan,

I want to understand that you have a production server which has MS4W installed 
and also another Apache version.

I've never tried to do something like that. I suppose that you have to match 
the MS4W httpd.conf configuration file (loaded modules, environment variables, 
etc) located at /ms4w/Apache/conf.
 


Cheers from México


IC Carlos Ruiz




 From: Juan Jesús Cremades Monserrat relic...@gmail.com
To: mapserver-users@lists.osgeo.org 
Sent: Thursday, January 19, 2012 9:37 AM
Subject: [mapserver-users] MS4W with an external Apache
 

Hi,

I have a Windows XP with an apache 2.2 installation. In my job I have been 
asked whether it is possible conect a MS4W for uses this Apache instead of the 
server which comes with the MS4W package, Is it possible? Thanks
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] PHP mapscript - how to add label style

[Carlos Ruiz]

Ian,

Why don't you post your script ?

 
IC Carlos Ruiz




From: Ian Walberg ian.walb...@airborne.aero
To: mapserver-users@lists.osgeo.org
Sent: Tuesday, September 27, 2011 5:51 PM
Subject: RE: [mapserver-users] PHP mapscript - how to add label style 


We have spent some time chasing this with no success, is anyone out there using 
PHP mapscript and mapserver 6.x?
 
Thanks
 
Ian
 
 
From:mapserver-users-boun...@lists.osgeo.org 
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Ian Walberg
Sent: Tuesday, September 27, 2011 8:21 AM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] PHP mapscript - how to add label style 
 
Hello,
 
I am sure it is staring me in the face but we cannot see how to add a style to 
a label (Mapserver 6.x) using PHP mapscript.
 
Works fine via map file and we see the open issue with the save not including 
the geotransform line.
 
What are we missing?
 
Thanks
 
Ian
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] PHP Mapscript - debugging help

[Carlos Ruiz]

Ian,

We have moved from 5.x to 6.x are chasing an issue causing a segmentation 
fault which appears to be related to the way we are 

 defining the 
symbols.

Are you talking about the SYMBOLSET file definition ? The segmentation fault 
throws when you invoke map-draw() ?


 We used to print_r the map object and then compare the one created from 
the map file and the one we had created programmatically, 

 however with 
mapserver 6.x the print_r on the map object is empty.

If you can have both map objects (the one loaded and the other one created) I 
suggest you to use the map-save(file name) method to see the differences 
between them.

Cheers from México


IC Carlos Ruiz




From: Ian Walberg ian.walb...@airborne.aero
To: mapserver-users@lists.osgeo.org
Sent: Monday, September 26, 2011 12:54 PM
Subject: [mapserver-users] PHP Mapscript - debugging help


Hello,
 
We have moved from 5.x to 6.x are chasing an issue causing a segmentation fault 
which appears to be related to the way we are defining the symbols.
 
If we create the map object from an empty map file (with just MAP and END in 
it) then we do not get a segmentation fault, sounds like something not 
initialized I know…
 
Any ideas on this appreciated but here is the real question (and it may really 
be a php question)  :-
 
We used to print_r the map object and then compare the one created from the map 
file and the one we had created programmatically, however with mapserver 6.x 
the print_r on the map object is empty.
 
I am sure this is basic PHP but any help would be appreciated.
 
Thanks
 
Ian
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Parsing error in LAYER's DATA

[Carlos Ruiz]

Hi all,

I've noticed that there's a parsing error with the layer's DATA the_geom FROM 
( ... ) AS x USING UNIQUE y USING SRID=z. If I wrote USING SRID = z 
Mapserver throws an error about the query syntax. It looks that it always must 
be SRID=z to work.


I tought it was the version (I was using 5.6.6) but I've noticed that with the 
6 versions stills the same.I know that this could sound as a silly thing but it 
took me to much time to catch and solve this simple thing.

 
IC Carlos Ruiz
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] zoom out factor as int

[Carlos Ruiz]

Puneet,

You have to handle negative integers. For example, to zoom in x2 you have to 
use +2, to zoom out you have to use -2.

Cheers from México


IC Carlos Ruiz



- Original Message -
From: Mr. Puneet Kishor punk.k...@gmail.com
To: MapServer mapserver-users@lists.osgeo.org
Cc: 
Sent: Monday, August 29, 2011 9:49 PM
Subject: [mapserver-users] zoom out factor as int

how do I express a zoom out factor in

zoomPoint( int zoomfactor, pointObj imgpoint, int width, int height, rectObj 
extent, rectObj maxextent ) : int


Obviously, 0.5 won't work as an int is expected.


--
Puneet Kishor ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Problem compiling with Mapserver 6 and GEOS 3.3.0

[Carlos Ruiz]

Hi all,

I have the following error while compiling Mapserver 6 and GEOS 3.3.0:undefined 
reference to `GEOSFree'.


The ./configure shows that it is using the geos-config version 3.3.0, so it is 
taking the GEOS version I was compiled just before.

I was looking at http://trac.osgeo.org/mapserver/ticket/3347 to find any help 
and I did the following:


So I have to edit the Makefile file to see what was happening. And then I 
modified the following line:

GEOS_LIB=  -L/usr/local/lib -lgeos_c

For this one:

GEOS_LIB=  -L/usr/local/lib -lgeos

And then I was able to compile Mapserver.

Is there an error with the make file ?


Thanks in advance !


IC Carlos Ruiz
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] how does mapserver determine shapefile encoding?

[Carlos Ruiz]

Lars,

When you try to load some data to a PostgreSQL server, you can specify the 
encoding to use.

This can be done with client_encoding. For example, if you want to populate a 
table with some CSV file contents, you have 

to do the following:


SET client_encoding = 'LATIN1';
COPY my_table FROM '/usr/file.csv' WITH CSV


Now, when you use shp2pgsql you can't set the client encoding, but you can set 
the default client_encoding of your 

database and every data transfer between some client and your database will be 
encoded properly:

ALTER DATABASE my_database SET client_encoding = 'LATIN1'


Hope this helps

Cheers from Guadalajara, México


IC Carlos Ruiz




From: Lars Lingner gislars+l...@googlemail.com
To: 'mapserver-users@lists.osgeo.org' mapserver-users@lists.osgeo.org
Sent: Tuesday, August 2, 2011 2:45 PM
Subject: [mapserver-users] how does mapserver determine shapefile encoding?

Hello,

I have a shapefile from which I don't really know the encoding. It might
be latin1 or ISO-8559-5. The good thing is, when MapServer is accessing
the shapefile, the labels are shown correct.
QGis is also displaying everything fine.

But when I try to convert with shp2pgsql or ogr I get only garbage back.
I tried different source encodings. Since I need the data to be in the
database I'm now trying to find out where the problem is.

I tried converting the data on different systems (Ubuntu, RedHat), with
postgis/shp2pgsql from repository as well as self compiled. Same
results. Also iconv and recode wasn't a help.

As I said QGis is displaying everything fine it fails in converting the
shapefile too. Opening the dbf in LibreOffice doesn't helped either.

Finally my (odd) questions are: Why does MapServer do everything right?
How is the encoding determined? Can I see somewhere which encoding is
used by MapServer?

Thanks in advance for any pointers.


Lars
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] how does mapserver determine shapefile encoding?

[Carlos Ruiz]

Lars,


Looking at the shp2pgsql documentation, it is possible to specify the shape 
attributes encoding with the -W parameter.
 

IC Carlos Ruiz




From: Lars Lingner gislars+l...@googlemail.com
To: 'mapserver-users@lists.osgeo.org' mapserver-users@lists.osgeo.org
Sent: Tuesday, August 2, 2011 2:45 PM
Subject: [mapserver-users] how does mapserver determine shapefile encoding?

Hello,

I have a shapefile from which I don't really know the encoding. It might
be latin1 or ISO-8559-5. The good thing is, when MapServer is accessing
the shapefile, the labels are shown correct.
QGis is also displaying everything fine.

But when I try to convert with shp2pgsql or ogr I get only garbage back.
I tried different source encodings. Since I need the data to be in the
database I'm now trying to find out where the problem is.

I tried converting the data on different systems (Ubuntu, RedHat), with
postgis/shp2pgsql from repository as well as self compiled. Same
results. Also iconv and recode wasn't a help.

As I said QGis is displaying everything fine it fails in converting the
shapefile too. Opening the dbf in LibreOffice doesn't helped either.

Finally my (odd) questions are: Why does MapServer do everything right?
How is the encoding determined? Can I see somewhere which encoding is
used by MapServer?

Thanks in advance for any pointers.


Lars
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] It takes more than 2 minutes for my map server to generate a world map

[Carlos Ruiz]

JK (?), 


One question: did you use gdaltindex ?


IC Carlos Ruiz




From: jk jk.c...@sdl.usu.edu
To: mapserver-users@lists.osgeo.org
Sent: Wednesday, July 27, 2011 6:20 PM
Subject: [mapserver-users] It takes more than 2 minutes for my map server to 
generate a world map

Hi,

I have a tile system of 4659 tiles, each is a 5 meter resolution raster
image a particular spot in the world (as you know it is sparse, the
collection of tiles do not cover the enter world). 

When I asking for a map of the world (ie, high-level view, a bbox with
values close to the lonlat boundary of the world), my map server
consistently takes long time to finish, (close to 2.5 minutes, yeah,
minutes, not seconds). This is very slow. 

If I submit a bbox that matches a particular tile, the map is returned
instantly. 

How could it take so long to generate the world map?

How to fix that?

Anything I'm missing? Any idea?

I'm not using tile cache yet. But I think 2.5 minutes for world view is way
too slow. Something must be wrong. 

If you know of any clues, let me know. 

Thanks for your help.

JK 


--
View this message in context: 
http://osgeo-org.1803224.n2.nabble.com/It-takes-more-than-2-minutes-for-my-map-server-to-generate-a-world-map-tp6628127p6628127.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] mapscript - java exception

[Carlos Ruiz]

Ahmet,

What are you trying to do ? Are you trying to store a mapObj into the user's 
session ?

This exception is thrown when an object doesn't implements the serializable 
interface.


IC Carlos Ruiz




From: ahmet temiz ahmettemi...@gmail.com
To: mapserver-users mapserver-users@lists.osgeo.org
Sent: Tuesday, July 19, 2011 3:30 AM
Subject: [mapserver-users] mapscript - java exception

hello

I am dealing with mapscript - java.

I received this error message.
Could you tell me what the reason might be ?

regards


Caused by: java.io.NotSerializableException: edu.umn.gis.mapscript.mapObj
    at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1164)
    at 
java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1518)
    at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1483)
    at 
java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1400)
    at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1158)
    at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:330)
    at 
org.apache.catalina.session.StandardSession.writeObject(StandardSession.java:1676)

-- 
Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Planlama ve Zarar Azaltma Dairesi Başkanlığı
Bilgi ve CBS grubu
Eskişehir Yolu 10. km.
Lodumlu / Ankara
Tel : 0 312 2872680 / 1535


Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] RE: mapserver-users Digest, Vol 42, Issue 39

[Carlos Ruiz]

Amr,

1 - You can show and hide a layer changing its status:oLayer-set(STATUS, 
MS_ON | MS_OFF)

2 - Yes, you can create and build a map dynamically.

The third one I don't know. I never have used Mapserver as tile server.

 
IC Carlos Ruiz




From: Amr Zakaria amrzakari...@hotmail.com
To: mapserver mapserver-users@lists.osgeo.org
Sent: Sunday, July 17, 2011 12:05 PM
Subject: [mapserver-users] RE: mapserver-users Digest, Vol 42, Issue 39


 
1- How to show and hide layer?
2- Can i create the map file dynamic?
3- Can i use MapServer as tile server?

Best VB programmer , Azz.




___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Using unique

[Carlos Ruiz]

Pena,

Can you post your query ?

You can use:

DATA the_geom FROM tablein the traditional way


Or, if you're using a query or a view datasource, you can use:

DATA the_geom FROM query|view AS alias USING UNIQUE column USING 
SRID=SRC

Cheers from México


IC Carlos Ruiz




From: Pena Kupen ku...@wippies.fi
To: mapserver-users@lists.osgeo.org
Sent: Thursday, July 14, 2011 2:59 AM
Subject: [mapserver-users] Using unique

Sorry doubleposting! There where little copy/paste-error. You can ignore 
prior...

-Pena


Hello all,

I'm just upgrading our system from mapserver 5.4.2 to 5.6.6.
In some of our layer queries, I got now error:
msPostGISParseData(): Query error. Error parsing PostGIS DATA variable. You 
must specifiy 'using unique' when supplying a subselect in the data definition.
When using 5.4.2, this is not happaning and maps are working ok.

On mapserver/postgis manual (http://mapserver.org/input/vector/postgis.html) it 
says:
The DATA parameter is used to specify the data used to draw the map. The form 
of DATA is “[geometry_column] from [table_name|sql_subquery] using unique 
[unique_key] using srid=[spatial_reference_id]”. The “using unique” and “using 
srid=” clauses are optional, but using them improves performance.

Is this a bug or why I cannot anymore use queries without using unique?

-Pena


-- Wippies-vallankumous on täällä! Varmista paikkasi vallankumouksen 
eturintamassa ja liity Wippiesiin heti!
http://www.wippies.com/

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] how to create from xyz file poloygon and display as layer

[Carlos Ruiz]

Zakaria,

You can do it with a Virtual Data Source.

Take a look at http://www.mapserver.org/input/vector/VirtualSpatialData.html

Cheers from México
 

IC Carlos Ruiz




From: Amr Zakaria amrzakari...@hotmail.com
To: mapserver mapserver-users@lists.osgeo.org
Sent: Tuesday, July 12, 2011 8:23 AM
Subject: [mapserver-users] how to create from xyz file poloygon and display as 
layer


 
i have xyz file contain lat , lon and height and i want to draw a layer in 
mapserver
Best VB programmer , Azz.

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Re: Installing PHP MapScript with MapServer 6.0.0-3 and PHP 5.3.6 on Mac OS X 10.6.8

[Carlos Ruiz]

Léo,

If you server is not a production server, please make sure that you have the 
php.ini error handling as follows:


error_reporting = E_ALL


Remember to restart Apache.

Also, in the MAP section, add something like this:

DEBUG ON
CONFIG MS_ERRORFILE /var/www/html/errores.txt

Let's see what happens.

Cheers from México


IC Carlos Ruiz




From: Léo D. leo_dum...@yahoo.fr
To: mapserver-users@lists.osgeo.org
Sent: Tuesday, July 5, 2011 11:19 AM
Subject: [mapserver-users] Re: Installing PHP MapScript with MapServer 6.0.0-3 
and PHP 5.3.6 on Mac OS X 10.6.8

Thanks to both of you for your answers.

I've allready edit my php.ini to add extension=php_mapscript.so and with a
phpinfo() I can see the section about MapScript.
Moreover when I run this script to test if the extension is loaded or not
and I have a positive result, so I think that PHP MapScript is working:

if (!extension_loaded('MapScript')) {
echoNot loaded;
}
else {
echoLoaded!;
}

But when I try to run the example script from the mapserver.org
documentation (without the dl() instruction), it doesn't work and I have no
error message, just an empty page. Here is my php code:

?php
$map = ms_newMapObj(~/macbook/Sites/mapeserver/introduction/test.map);
$image = $map-draw();
$image_url = $image-saveWebImage();

echo'html
   head
     titleExemple : Afficher un shapefile/title
   /head
   body
      '.$image_url.' 
   /body
/html';
?

And here is my mapfile:

MAP
NAME Europe en bleu
SIZE 400 400
STATUS ON
EXTENT -31.2467 27.6065 40.1199 80.762
UNITS DD
SHAPEPATH ~/macbook/Sites/mapserver/introduction/shape/
    
WEB
  IMAGEPATH '~/macbook/Sites/mapeserver/temp/'
  IMAGEURL  '/temp/'
END

LAYER
  NAME Europe
  TYPE POLYGON
  STATUS ON
  DATA europe
  CLASS
    STYLE
      COLOR 20 10 110
      OUTLINECOLOR 200 200 200
    END
  END
END

END

Maybe I've made a mistake in one of these files…
Thanks for your help !

Léo

--
View this message in context: 
http://osgeo-org.1803224.n2.nabble.com/Installing-PHP-MapScript-with-MapServer-6-0-0-3-and-PHP-5-3-6-on-Mac-OS-X-10-6-8-tp6546297p6550486.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] pie/bar graphs with labels?

[Carlos Ruiz]

Rolando,

Al parecer no es posible dibujar etiquetas en capas de tipo chart. He hecho el 
intento haciendo uso de LABELITEM y LABEL 

pero no las dibuja. Desconozco si exista una directiva en PROCESSING que 
pudiera hacer esto.

Saludos desde Guadalajara, México

It seems it's not possible to draw labels with chart type layers. I've been 
trying with LABELITEM and LABEL but it doesn't work.
I don't know if there's a PROCESSING directive to draw a label.

Cheers from Guadalajara, México

 
IC Carlos Ruiz




From: pelin pelin...@gmail.com
To: mapserver-users@lists.osgeo.org
Sent: Tuesday, July 5, 2011 6:46 AM
Subject: [mapserver-users] pie/bar graphs with labels?


estimados, como estan. 
les hago una consulta,es posible poner labels en layers que son CHART?

is feasible put labels into layers with type CHART?


Saludos!

-- 

http://blogs.hydras.com.ar/srodriguez/

 Atentamente
         Rolando Sergio Rodriguez

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] mapserver6 (was 5) postgis connection problem

[Carlos Ruiz]

Richard,

Just checking for the most common errors, and taking a look at this fragment of 
the layer's debug dump:


[Thu May 26 23:45:30 2011].568123 msPostGISLayerOpen(): Query error.
Database connection failed (could not connect to server: Permission denied
        Is the server running on host localhost and accepting
        TCP/IP connections on port 5432?
could not connect to server: Permission denied
        Is the server running on host localhost and accepting
        TCP/IP connections on port 5432?
 
Using GeoServer, you have posted this connection string:

host=localhost dbname=osm password=t user=geo

Using Mapserver, you have posted this other connection string:

host=localhost dbname=osm password=*** user=geo

You receive a Database connection failed (could not connect to server: 
Permission denied), this means that there's a problem 
with the connection parameters.

I can see a t password (5 chars) with Geoserver test and a *** 
password (7 chars) with Mapserver test, are you sure 
that you're using the same password ???

Also, if you're using HBA, you have to do the Geoserver and the Mapserver test 
in the same machine because the ip address.

Cheers from México


IC Carlos Ruiz




From: Richard Duivenvoorde rdmaili...@duif.net
To: mapserver-users@lists.osgeo.org
Sent: Friday, May 27, 2011 4:18 AM
Subject: Re: [mapserver-users] mapserver6 (was 5)  postgis connection problem

Sorry for wrong subject, I'm talking about mapserver6 here.

Ok, don't think it is a postgres/postgis problem...

Installed geoserver, and that is serving fine 

Als0 tried mapserv from command line:
./mapserv -nh QUERY_STRING=map=osmwm.mapmode=map  /tmp/test11.png
also ok

mapfile snippet:

LAYER
    NAME test
    TYPE polygon
    STATUS default
    DEBUG 5
    CONNECTIONTYPE postgis
    CONNECTION host=localhost dbname=osm password=t user=geo
    DATA way28992 from (select * from landuse2) as foo using unique
osm_id using srid=28992
    FILTER landuse in ('industrial', 'residential')
    METADATA
      WMS_TITLE                     test
      WMS_SRS                       EPSG:28992
      OWS_EXTENT                    -26000 296000 293000 634000
    END
    CLASS
    STYLE
      COLOR 255 0 0
    END
    STYLE
      OUTLINECOLOR 0 0 0
      WIDTH 3
      ANTIALIAS TRUE
    END
    END #CLASS
  END



On 05/26/2011 11:58 PM, Richard Duivenvoorde wrote:
 Like somebody else in the list I have a strange problem with MS6 on a
 fresh RHEL6 machine. Running the same data and mapfile in an older MS works.
 Below as much info I could get.
 Anybody a clue?
 I can recompile or add debug statements if nessecary (will be on irc
 tomorrow morning)
 
 Regards,
 
 Richard Duivenvoorde
 
 
 I fail to get a postgres connection log somewhere on this machine...
 
 a new installed RHEL6 machine:
 Red Hat Enterprise Linux Server release 6.0 (Santiago)
 
 running
 PostgreSQL 8.4.8 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC)
 4.4.4 20100726 (Red Hat 4.4.4-13), 64-bit
 and
 1.5 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
 
 mapserver -v gives
 MapServer version 6.0.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=KML
 SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV
 SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER
 SUPPORTS=WCS_SERVER INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
 
 I've done a gdal and mapserver compile myself
 
 A database with OSM data and mapfile with connectionstring like:
 CONNECTION host=localhost dbname=osm password= user=geo
 keeps saying:
 Permission denied Is the server running on host localhost and
 accepting TCP/IP connections on port 5432? ) with connect string
 'host=localhost dbname=osm password=*** user=geo'
 
 while:
 - I can connect with that user/password via psql
 - can use shp2img and the same mapfile (generating a map)
 - can do
 ogrinfo -ro PG:'host=localhost user=geo password=xx dbname=osm' -sql
 select count(*) from mytable
 - even tried trust for all hosts in pg_hba.conf
 
 setting debug in LAYER at 5
 
 -- first part is from wms request (failing connection):
 [Thu May 26 23:45:30 2011].566614 msPostGISLayerOpen called: way28992
 from nl_osm_point using unique osm_id using srid=28992
 [Thu May 26 23:45:30 2011].566704 msPostGISLayerOpen: No connection in
 pool, creating a fresh one.
 [Thu May 26 23:45:30 2011].568103 msPostGISLayerOpen: Connection failure.
 [Thu May 26 23:45:30 2011].568123 msPostGISLayerOpen(): Query error.
 Database connection failed (could not connect to server: Permission denied
         Is the server running on host localhost and accepting
         TCP/IP connections on port 5432?
 could not connect to server: Permission denied
         Is the server running on host localhost and accepting
         TCP/IP connections on port 5432?
 ) with connect string 'host=localhost dbname=osm password=*** user=geo'
 Is the database running? Is it allowing connections? Does the specified
 user

Re: [mapserver-users] Please help

[Carlos Ruiz]

Jude,

This is how I have it configured in my server:


    WEB
        IMAGEURL /temp/
        IMAGEPATH /var/www/html/temp/
    END


As you can see, I'm using the abolute path.


Cheers from México


IC Carlos Ruiz




From: Worth Lutz w...@mindspring.com
To: 'jude mwenda' judemwe...@gmail.com; mapserver-users@lists.osgeo.org
Sent: Monday, May 16, 2011 5:56 AM
Subject: RE: [mapserver-users] Please help


 
Try changing:
 
WEB
TEMPLATE template.html
IMAGEPATH /var/www/judemaps/output/
IMAGEURL /output/
END
 
To:
 
WEB
TEMPLATE template.html
IMAGEPATH /var/www/judemaps/output/
IMAGEURL /judemaps/output/
END
 


 
From:mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of jude mwenda
Sent: Sunday, May 15, 2011 10:17
PM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] Please
help
 
 
Hi,
I am new to mapserver. I have been able to generate images, and on viewing
images folder i can see images that have been generated by mapserver. The only
problem comes in that on loading them via template the image is a broken path.
Any pointers on resolving this,
Mapfile http://dpaste.de/4bmw/

On accessing the images via 
http://localhost/judemaps/output/parcels_map130551107432207.gif
they do load.

Any clue on what i am doing wrong.
the template has 

!-- MapServer Template --
html
headtitleSimple Mapserver Template HTML
Document/title/head
body bgcolor=#AA
h2The image below was illustrated based on the instructions sent in the
mapfile./h2
!-- When using Mapserver with a template, the Mapserver application looks
for the [img] tag within the template document to place the map --
img src=[img] border=1
/body
/html

-- 
Regards,

Jude Mwenda
Skype id: jmwenda
Twitter: www.twitter.com/judemwenda
Web: www.africangeogeek.com
    
Was ist mein Leben, wenn ich nicht mehr nützlich für andere.
Johann Wolfgang von Goethe


 
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1375 / Virus Database: 1500/3641 - Release Date: 05/16/11
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Problem with raster file and layer's getExtent method

[Carlos Ruiz]

Hi list,

I'm using the getExtent method of layer object with PHP Mapscript, works fine 
with PostGIS layers but with a 

raster files I get some troubles.

I have a DEM.IMG file, using gdalinfo -nomd dem.img throws this:

Driver: HFA/Erdas Imagine Images (.img)
...
Coordinate System is:
PROJCS[UTM Zone 13, Northern Hemisphere,
...

Corner Coordinates:
Upper Left  (  687178.570, 2247514.668) (103d12'26.04W, 20d18'59.14N)
Lower Left  (  687178.570, 2243914.668) (103d12'27.39W, 20d17'2.08N)
Upper Right (  690918.570, 2247514.668) (103d10'17.13W, 20d18'57.80N)
Lower Right (  690918.570, 2243914.668) (103d10'18.51W, 20d17'0.75N)
Center  (  689048.570, 2245714.668) (103d11'22.27W, 20d17'59.94N)
...


But $layer-getExtent() has the following extent:

-2500, -2500, 2500, 2500

Is there another way to get the raster file extent ?

Thanks in advance
 

IC Carlos Ruiz
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Client-side applications for visualizing mapfiles

[Carlos Ruiz]

Apostlolos,

If you just want to render mapfiles to learn how to configure a map file, 
there's an utility 
program called shp2img which takes a map file as input and produces the 
GIF/JPG/PNG output file.

Cheers from México

IC Carlos Ruiz


From: ΑΠΟΣΤΟΛΟΣ ΛΕΛΕΝΤΖΗΣ lelentzisaposto...@gmail.com
To: mapserver-users@lists.osgeo.org
Sent: Friday, February 18, 2011 8:35 AM
Subject: [mapserver-users] Client-side applications for visualizing mapfiles


Hello everybody

I am a new mapserver user and i need your knowledge and your experience.
I know that the heart of mapserver is the mapfile. Also, i can use html 
files and templates fro visualizing the layers of mapfile in a web-browser. 
But, i want a more interactive, flexible and quickly solution. Could you 
suggest me anything??
I know that there are many client-side applications to rend WMS and WFS 
servers like OpenLayers, Fusion, dbox, Chameleon, GMap, CartoWeb. 
However, i would like a good explanation, regarding which is the best choice!
Moreover, i am grateful, if you send me some tutorial!!

Thanks in advance
Apostolos 
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] WCS

[Carlos Ruiz]

David,

I got several WCS working. Remember that EXTENT must be specified as: 

MinX MinY MaxX MaxY

Like this:

EXTENT 667850.414115 2160714.942368 672400.414115 2165844.942368


Cheers
 
IC Carlos Ruiz




From: David Hildebrand david.hildebr...@afsc.ca
To: mapserver-users@lists.osgeo.org
Sent: Tue, February 1, 2011 5:46:01 PM
Subject: [mapserver-users] WCS

 
I am trying to develop a WCS layer (1.0.0) and I can successfully issue the 
GetCapabilities and DescribeCoverage requests.  However, when I issue a 
GetCoverage request I get a bounding box error due to bad coordinates.  The 
layer is also set up as a WMS layer (1.1.1) and a GetMap request works fine. 
 The metadata ows_srs and ows_resolution parameters are being used in the map 
file and these work fine for WMS requests.  Should I be using version 1.1.0?
 
Any ideas?
 
 
===
David V. Hildebrand
Agriculture Financial Services Corporation
(403) 782-8239   
 
www.afsc.cahttp://www.afsc.ca
This communication is intended for the use of the recipient to which it is 
addressed, and may contain confidential, personal and/or privileged 
information. 
Please contact Agriculture Financial Services Corporation immediately if you 
are 
not the intended recipient of this communication, and do not copy, distribute, 
or take action relying on it. Any communication received in error, or 
subsequent 
reply, should be deleted or destroyed. Please consider the environment before 
printing this email.


  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] long-running postgres queries initiated by mapserver

[Carlos Ruiz]

Matt,

I suggest to enhance the PostgreSQL performance at first. Each table with 
geometry must have a GiST spatial 

index. When you upload a shape file to PostgreSQL, the shp2pgsql creates this 
index specifying the -I 

parameter.

Have you uploaded your data in this way ?

If the geometry have been modified with PostGIS, you must recompute statistics 
to have the index updated.

Check if you have a spatial index in your table.

Cheers from México


IC Carlos Ruiz




From: mattmendick matt.mend...@pictometry.com
To: mapserver-users@lists.osgeo.org
Sent: Tue, December 21, 2010 8:48:19 AM
Subject: [mapserver-users] long-running postgres queries initiated by mapserver


Hi All-

I'm running mapserver 5.6.3 under centos 5.4, using fastcgi. I'm using
postgres as the data storage container, and mapserver is primarily serving
WFS requests.  Sometimes, people do WFS queries that take a very long time
(searching for virginia on a nation-wide layer) and eventually postgres
will return with the result after a long time (hours later), however the
client has cancelled the WFS request.  Is there any way for mapserver to
know that the client has cancelled the http request, and it can therefore
stop the DB query to postgres?  I tried using persistent and non-persistent
connections with this:

PROCESSING CLOSE_CONNECTION=DEFER

but that didn't change the behavior.

Thanks a lot!
-- 
View this message in context: 
http://osgeo-org.1803224.n2.nabble.com/long-running-postgres-queries-initiated-by-mapserver-tp5855539p5855539.html

Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] long-running postgres queries initiated by mapserver

[Carlos Ruiz]

Your welcome, Matt.

Now it is clear why the query is slow.

You must have indices on the columns that you're searching in (and run VACUUM 
frecuently to keep them 

updated). If you're using LIKE operator, then the indices are not useful if the 
columns are not LOCALEd.

Check if you have defined LOCALE to speed up the LIKE matching.

Also, if the data doesn't change at all, you can CLUSTER the table to improve 
the query speed.


IC Carlos Ruiz




From: Matt Mendick matt.mend...@pictometry.com
To: Carlos Ruiz boolean10...@yahoo.com; mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.org
Sent: Tue, December 21, 2010 10:43:46 AM
Subject: RE: [mapserver-users] long-running postgres queries initiated by 
mapserver

 
Carlos,
 
Thank you for your response, and indeed the tables do have  indices. The 
spatial 
search is just fine and comes back very quickly, however  the text-based 
searches do not come back quickly (propertyIsLike for  example).  I suppose I 
wasn't clear enough in my original question.   Mapserver does a case 
insensitive 
like query on the postgres server and on  tables that are very large 
(millions 
of rows), this takes too long.  We are  training the customers to search for 
things more intelligently, but we cannot  stop them entirely.  We are looking 
into a full-text indexing methodology,  but in the meantime, we need to solve 
the problem of the long-running  queries.
 
-Matt



 From: Carlos Ruiz  [mailto:boolean10...@yahoo.com] 
Sent: Tuesday, December 21, 2010  10:23 AM
To: Matt Mendick;  mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users]  long-running postgres queries initiated by 
mapserver


Matt,

I  suggest to enhance the PostgreSQL performance at first. Each table with 
geometry  must have a GiST spatial 

index. When you upload a shape file to PostgreSQL,  the shp2pgsql creates this 
index specifying the -I 

parameter.

Have  you uploaded your data in this way ?

If the geometry have been modified  with PostGIS, you must recompute statistics 
to have the index  updated.

Check if you have a spatial index in your table.

Cheers  from México


IC Carlos Ruiz




 From: mattmendick  matt.mend...@pictometry.com
To: mapserver-users@lists.osgeo.org
Sent: Tue, December 21, 2010 8:48:19  AM
Subject: [mapserver-users]  long-running postgres queries initiated by mapserver


Hi  All-

I'm running mapserver 5.6.3 under centos 5.4, using fastcgi. I'm  using
postgres as the data storage container, and mapserver is primarily  serving
WFS requests.  Sometimes, people do WFS queries that take a very  long time
(searching for virginia on a nation-wide layer) and eventually  postgres
will return with the result after a long time (hours later), however  the
client has cancelled the WFS request.  Is there any way for  mapserver to
know that the client has cancelled the http request, and it can  therefore
stop the DB query to postgres?  I tried using persistent and  non-persistent
connections with this:

PROCESSING  CLOSE_CONNECTION=DEFER

but that didn't change the  behavior.

Thanks a lot!
-- 
View this message in context: 
http://osgeo-org.1803224.n2.nabble.com/long-running-postgres-queries-initiated-by-mapserver-tp5855539p5855539.html

Sent  from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users  mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

NOTICE: This message is covered by the Electronic Communications Privacy Act, 
Title 18, United States Code, Sections 2510-2521. This e-mail and any attached 
files are the exclusive property of Pictometry International Corp., are deemed 
privileged and confidential, and are intended solely for the use of the 
individual(s) or entity to whom this e-mail is addressed. If you are not one of 
the named recipient(s) or believe that you have received this message in error, 
please delete this e-mail and any attachments and notify the sender 
immediately. 
Any other use, re-creation, dissemination, forwarding or copying of this e-mail 
is strictly prohibited and may be unlawful. 



  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] WMS image doesn't shows at major scales

[Carlos Ruiz]

After several tests, spliting in 4 file the original ECW file and using 
gdaltindex, solved the problem. The original 

ECW sizes 1.99 GB (2147420380 bytes) so I guess it was a memory matter.

Thanks to all

Cheers from Guadalajara, México
 

IC Carlos Ruiz




From: Smith, Michael D ERDC-CRREL-NH michael.sm...@usace.army.mil
To: Carlos Ruiz boolean10...@yahoo.com; mapserver-users 
mapserver-users@lists.osgeo.org
Sent: Mon, December 6, 2010 2:45:18 PM
Subject: Re: [mapserver-users] WMS image doesn't shows at major scales

Re: [mapserver-users] WMS image doesn't shows at major scales It appears that 
it 
is reading the data. Could be be that the color values are not between 0 and 
255? Perhaps you need to add a PROCESSING section?
Does this display properly is another viewer?

Also, you should reply back to the list as well. There are many people that may 
be able to help.

M


-- 
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers
Hanover, NH


On 12/6/10  3:29 PM, Carlos Ruiz boolean10...@yahoo.com wrote:


Michael,

Thanks for the reply. I've set the DEBUG 5 config key at the LAYER section, 
I've 
reproduced 

the steps to get nothing and this is the log's contents:


mapserv request processing time (msLoadMap not incl.): 0.084s
msFreeMap(): freeing map at 0xa029150.
freeLayer(): freeing layer at 0xa030a28.
mapserv request processing time (msLoadMap not incl.): 0.083s
msFreeMap(): freeing map at 0x9dd6150.
freeLayer(): freeing layer at 0x9ddda28.
msDrawMap(): kicking into non-square pixel preserving mode.
msDrawRasterLayerLow(imagen): entering.
msResampleGDALToMap in effect: cellsize = 298.004345
msDrawGDAL(imagen): using RAW_WINDOW=0 0 192034 184370, dst=0,0,1611,1546
msDrawGDAL(): red,green,blue,alpha bands = 1,2,3,0
msDrawMap(): Layer 0 (imagen), 0.897s
msDrawMap(): Drawing Label Cache, 0.000s
msDrawMap() total time: 0.898s
msSaveImage() total time: 3.291s
mapserv request processing time (msLoadMap not incl.): 4.214s
msFreeMap(): freeing map at 0x92376f0.
freeLayer(): freeing layer at 0x923efc8.
msDrawMap(): kicking into non-square pixel preserving mode.
msDrawRasterLayerLow(imagen): entering.
msResampleGDALToMap in effect: cellsize = 22.479058
msDrawGDAL(imagen): using RAW_WINDOW=70800 88927 17174 14962, dst=0,0,1910,1664
msDrawGDAL(): red,green,blue,alpha bands = 1,2,3,0
msDrawMap(): Layer 0 (imagen), 0.525s
msDrawMap(): Drawing Label Cache, 0.000s
msDrawMap() total time: 0.525s
msSaveImage() total time: 1.415s
mapserv request processing time (msLoadMap not incl.): 1.967s
msFreeMap(): freeing map at 0x8bc96f0.
freeLayer(): freeing layer at 0x8bd0fc8.
msDrawMap(): kicking into non-square pixel preserving mode.
msDrawRasterLayerLow(imagen): entering.
msResampleGDALToMap in effect: cellsize = 22.479058
msDrawGDAL(imagen): using RAW_WINDOW=70800 88927 17174 14962, dst=0,0,1910,1664
msDrawGDAL(): red,green,blue,alpha bands = 1,2,3,0
msDrawMap(): Layer 0 (imagen), 0.524s
msDrawMap(): Drawing Label Cache, 0.000s
msDrawMap() total time: 0.524s
msSaveImage() total time: 1.528s
mapserv request processing time (msLoadMap not incl.): 2.078s
msFreeMap(): freeing map at 0x99ca6f0.
freeLayer(): freeing layer at 0x99d1fc8.


I didn't noticed about the EPSG matters, thanks, I just change it using 
init=epsg:32613.

IC Carlos Ruiz



From:Smith, Michael D ERDC-CRREL-NH michael.sm...@usace.army.mil
To: Carlos Ruiz boolean10...@yahoo.com; mapserver-users 
mapserver-users@lists.osgeo.org
Sent: Mon, December 6, 2010 1:23:35 PM
Subject: Re: [mapserver-users] WMS image doesn't shows at major scales

Re: [mapserver-users] WMS image doesn't shows at major scales Carlos,

Can you set DEBUG 5 at both the LAYER and MAP level and see what shows up in 
the 
error log?

Also I note that you are specifying the projection at the WMS level in EPSG 
terms but not at the MAP and LAYER levels. You should use the EPSG code at the 
MAP and LAYER projection blocks as MapServer does not know that your 
projection 
text and the EPSG codes are equivalent so you will be undergoing reprojection 
on 
each call.

Mike




  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] WMS image doesn't shows at major scales

[Carlos Ruiz]

Hi to all,

I have a problem here with an WMS layer, and have no clue about what could be 
happening. I have an ECW file 

with the following info:

Driver: ECW/ERMapper Compressed Wavelets
Files: mosaico_spot_2009.ecw
Size is 192034, 184370
Coordinate System is `'
Origin = (425473.750,2527371.250)
Pixel Size = (2.500,-2.500)
Corner Coordinates:
Upper Left  (  425473.750, 2527371.250)
Lower Left  (  425473.750, 2066446.250)
Upper Right (  905558.750, 2527371.250)
Lower Right (  905558.750, 2066446.250)
Center  (  665516.250, 2296908.750)
Band 1 Block=192034x1 Type=Byte, ColorInterp=Red
  Overviews: arbitrary
  Metadata:
LAYER_TYPE=athematic
Band 2 Block=192034x1 Type=Byte, ColorInterp=Green
  Overviews: arbitrary
  Metadata:
LAYER_TYPE=athematic
Band 3 Block=192034x1 Type=Byte, ColorInterp=Blue
  Metadata:
LAYER_TYPE=athematic

It is provided as a WMS and here is the MAP file contents:

MAP

NAME 'spot'
SIZE 800 600
UNITS meters

DEBUG 5
CONFIG MS_ERRORFILE /var/www/html/spot.log

EXTENT 425473 2066446 905559 2527371

PROJECTION
'proj=utm'
'ellps=WGS84'
'datum=WGS84'
'zone=13'
'north'
'nodefs'
END

OUTPUTFORMAT
NAME jpeg
DRIVER GD/JPEG
MIMETYPE image/jpeg
IMAGEMODE RGB
EXTENSION jpg
END

METADATA
'wms_title' 'SPOT'
'wms_onlineresource'
'http://sitel.jalisco.gob.mx/cgi-bin/spot'
'wms_srs'   'EPSG:32613'
'wms_fees'  'none'
'wms_contactperson' 'IC Carlos Ruiz'
'wms_contactelectronicmailaddress'  
'crui...@gmail.com'
END

LAYER

NAME 'spot'
TYPE RASTER
DATA '/var/www/html/raster/spot.ecw'
STATUS DEFAULT

PROJECTION
'proj=utm'
'ellps=WGS84'
'datum=WGS84'
'zone=13'
'north'
'no_defs'
END

METADATA
'wms_title' 'Imagen SPOT'
END

END

END

Everything works fine above the 1:152,000 scale, but when you try to reach 
major 
scales, it shows nothing. The 

map has no MINSCALEDENOM nor MAXSCALEDENOM.

Taking a look at the log file, nothing's wrong. If I set the MS_NONSQUARE 
config key throws: 


msDrawMap(): kicking into non-squarepixel preserving mode.

but nothing yet shows beyond 1:152,000.

Does anyone have a clue about what's wrong ? I'm using Mapserver 5.6.5

Thanks in advance


IC Carlos Ruiz


  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

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

[Carlos Ruiz]

Flavio,

Column names are case sensitive, have you checked this ?

Cheers from México


IC Carlos Ruiz




From: flaviocarmo flavio.o.ca...@gmail.com
To: mapserver-users@lists.osgeo.org
Sent: Mon, November 29, 2010 8:43:44 AM
Subject: [mapserver-users] Join from SHP file to PostgreSQL table


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?

Thanks again

Regards,

Flavio Carmo
-- 
View this message in context: 
http://osgeo-org.1803224.n2.nabble.com/Join-from-SHP-file-to-PostgreSQL-table-tp5784531p5784531.html

Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Raster Data from PostGIS

[Carlos Ruiz]

Florencia,

As far as I know, Mapserver only works with vectorial data on PostGIS. So 
having 
a kind of BLOB (bytea)
column doesn't work.

I guess you will have to had those TIF files as a file to be able to load it 
using a RASTER layer.

Cheers from México


IC Carlos Ruiz

From: florencia.bujan florita...@gmail.com

To: mapserver-users@lists.osgeo.org
Sent: Mon, November 29, 2010 7:46:56 AM
Subject: [mapserver-users] Raster Data from PostGIS


Hi,

I have my data rasters (tif files) into my PostGIS database such as file. 
Any file into database is in bytea format.
I want to show this raster layer from PostGIS with mapserver. My Raster
Table structure and my .map code are:

TABLE rasters (
  id serial NOT NULL,
  nombre character varying(100),
  archivo_bytea bytea,
  mime character varying(100),
  size double precision
)

LAYER
NAME 'Raster'
TYPE RASTER
CONNECTIONTYPE postgis
CONNECTION user=postgres password=... dbname=... host=...
DATA bytea FROM rasters
STATUS OFF
OFFSITE 0 0 0
TRANSPARENCY 100
END

Thanks a lot.
Regards.
Florencia
-- 
View this message in context: 
http://osgeo-org.1803224.n2.nabble.com/Raster-Data-from-PostGIS-tp5784362p5784362.html

Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Re: Raster Data from PostGIS

[Carlos Ruiz]

Hi Florencia,

You just can show a layer per LAYER section at a time. However, you can use the 
GROUP label within each 

LAYER section of each raster you want to show, to turn on/off all those layers.

Solo puedes mostrar una capa por cada sección LAYER a la vez. Sin embargo, 
puedes hacer uso de la 

etiqueta GROUP dentro de cada sección LAYER a cada uno de los archivos raster 
que quieras mostrar para 

encenderlos o apagarlos en grupo.


IC Carlos Ruiz




From: florencia.bujan florita...@gmail.com
To: mapserver-users@lists.osgeo.org
Sent: Mon, November 29, 2010 9:50:35 AM
Subject: [mapserver-users] Re: Raster Data from PostGIS


Hi Carlos,

Thanks for your response.
Ok, but I want to show only one layer with some rasters (more than one). I
can save tif files into my system (directory into my hard disc instead of
PostGIS), but I am thinking about can show a layer with more than one tif
raster.

Any ideas?
Thanks a lot!
Florencia from Uruguay
-- 
View this message in context: 
http://osgeo-org.1803224.n2.nabble.com/Raster-Data-from-PostGIS-tp5784362p5784801.html

Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] how to disappear Warning: session_start() in the page?

[Carlos Ruiz]

Elisabeth,

It's quite as simple as the session handling. You can split your code into many 
files or keep it in one single file, 

the only thing you have to know is that PHP's session_start() function call 
must 
be the first thing wrote, no 

HTML or PHP code before that.

Cheers from México

IC Carlos Ruiz





From: elisabeth theresia dbee_ka...@yahoo.com
To: mapserver-users@lists.osgeo.org
Sent: Wed, August 18, 2010 2:48:58 PM
Subject: Re: [mapserver-users] how to disappear Warning: session_start() in the 
page?


Hello Mr. Sumariva, i already did wht u said, but there's new error: error:  
Call to undefined function:  on_get_contens() in 
I:\ms4w\apps\appweb\htdocs\index_cobacham.phtml on line 2

here i put the cobachanphtml.phtml: 
?php
$html=on_get_contens();
ob_end_clean();

include(./chameleon.php);
$szTemplate=./template_werror.html;
$szMapFile=../map/kelur_cobacham.map;
class SampleApp extends Chameleon //SampleApp merupakan turunan dari 
Chameleon
{
function SampleApp() //Nama fungsi
{
parent::Chameleon(); //Menjalankan konstruktor class Chameleon
$this-moMapSession=new MapSession_RW; //Mbwt instance obj map 
session
 $this-moMapSession-setTempDir 
(getSessionSavePath()); //Mendefinisikan dir temporer yg akn digunk olh 
obj map 
session
}
}

$oApp= new SampleApp(); //Membut instance obj SampleApp
$oApp-registerSkin('skins/sample'); //mendefinisikan skin utk obj SampleApp
$oApp-CWCInitialize($szTemplate, $szMapFile); //MEnginisialisasi obj Lat01 
dg  file template dan file 
.map
$oApp-CWCExecute(); //Menjalankan app dg memangil fs CWCExecute

?

So, what should i do?
 Thanks a lot for the attention, sorry reply not direct.





From: Cristiano Sumariva sumar...@gmail.com
To: elisabeth theresia dbee_ka...@yahoo.com
Sent: Tue, August 17, 2010 12:34:39 AM
Subject: Re: [mapserver-users] how to disappear Warning: session_start() in the 
page?

Well, you can turn the things by other way.
Put at top of HTML file in the ob_start() function to tell PHP to buffer all 
output.
Change your your index_cobachan by adding
$html = ob_get_contens();
ob_end_clean();

Now all the content that would be sent to browser is available at $html string 
variable.
After the includes in your index_cobachan print the contents of $html var.
Now do your application logic.
THen append the rest of HTML file.


Another option is to turn your HTML file into a template and add a special mark 
to signal template engine to replace some content but this would be another 
aproach.


2010/8/13 elisabeth theresia dbee_ka...@yahoo.com

Thanks Mr.Sumariva for the advice but, session_start() in the page already 
embed 
in Chameleon framework at its folder in \htdocs\common\session

the coding at line 509 (that shown error in the page):

//start the session
session_start();
register_shutdown_function( session_write_close );

  
// set IP if a new session
if ( $bNewSession ) $_SESSION[gszRemoteAdd] = $_SERVER[REMOTE_ADDR];

/* 
 * Check IP to see if it is the same
 *  = 
*/

// check if the IP has been set and validate
if ( isset( $_SESSION[gszRemoteAdd] ) 
   strlen(trim($_SESSION[gszRemoteAdd]))  0 
)
{
// check if IP matches current client
if ( trim( $_SESSION[gszRemoteAdd] ) !=
   trim( $_SERVER[REMOTE_ADDR] ) 
)
{
// possible security breach void session
/* if the session address is the loopback interface then it is
 * likely that the application was configured to use an external
 * address but someone is trying to test locally using localhost
 */
if ($_SESSION['gszRemoteAdd'] != '127.0.0.1')
{
$bSessionOK = false;
}
}
}
else
{
// possible security breach void session
$bSessionOK = false;
}

// return success or failure and set global so we
// know session has been inited.
if ($bSessionOK)
{
$GLOBALS['session_started'] = true;
}


return $bSessionOK;

// end intializeSession() function
}

function getSessionSavePath()
{
$szReturn  = ini_get(session.save_path)./sess_.session_id()./;
$szReturn = str_replace( \\, /, $szReturn );
return $szReturn;
}


Really need advice again Mr. 
Thanks



From: Cristiano Sumariva sumar...@gmail.com
To: elisabeth theresia dbee_ka...@yahoo.com
Sent: Sat, August 14, 2010 8:57:29  AM
Subject: Re: [mapserver

Re: [mapserver-users] UMN + Postsgis, features skipped

[Carlos Ruiz]

Andreas,

First, try to run SELECT DISTINCT(type) FROM 
av_mopublic.land_cover_lcsurface to ensure that all the 

types that you're classifying exists. I know this sounds silly but we must 
check 
if the type column contains 

all the types you're looking for.

When some features are missing, it means that the expression type doesn't 
exists 
and then, it's not 

rendered.

I've noticed that expressions are case sensitive, and sometimes, it doesn't 
works with special characters, 

maybe this could be happening too.

Cheers from México

IC Carlos Ruiz




From: Andreas Neumann a.neum...@carto.net
To: mapserver-users@lists.osgeo.org
Sent: Mon, July 12, 2010 7:58:16 AM
Subject: [mapserver-users] UMN + Postsgis, features skipped

Hi all,

I have troubles with the UMN/Postgis combo. When I just draw the layer
with a single class, it draws fine, but as soon as I use classification
with an EXPRESSION (simple string comparison), a lot of features are
skipped.

Attached I am sending a mapfile with just one class (buildings from a
landcover table). Most buildings are skipped, only a few are drawn.

I have no idea why.

The same table draws fine without problems in QGIS.

Any idea why the classification is skipping many features?

Thanks a lot,
Andreas

-- 
Andreas Neumann
http://www.carto.net/neumann/
http://www.svgopen.org/


  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] WFS Error column = 1 on msPostGISLayerGetShape

[Carlos Ruiz]

The cell_id column is of the integer type ? or character varying type ? It must 
be integer to be able to 

compare.
 

IC Carlos Ruiz




From: Andy Colson a...@squeakycode.net
To: Benoit PESTY tch...@hotmail.com
Cc: mapserver-users@lists.osgeo.org
Sent: Fri, July 9, 2010 10:23:39 AM
Subject: Re: [mapserver-users] WFS Error column = 1 on msPostGISLayerGetShape

On 7/9/2010 10:16 AM, Benoit PESTY wrote:
 Hello,

 I have a problem configuring a WFS Service.

 My layer is defined like this:

 LAYER
 NAME  forest_plot_layer
 TYPE POLYGON
 STATUS ON
 METADATA
 WFS_TITLE Forest Plots
 gml_include_items all
 gml_featureid cell_id
 END
 DUMP TRUE
 CONNECTIONTYPE postgis
 CONNECTION xx
 DATA the_geom FROM forest_plot_layer
 CLASS
 NAME Forest Plot
 STYLE
 SIZE 3
 COLOR 0 255 0
 OUTLINECOLOR 0 255 0
 END
 END
 PROJECTION
 init=epsg:3035
 END
 END


 And I have the follwing error :
 --
 [Tue Jul 6 18:49:16 2010].228958 msPostGISLayerGetShape(): Query error.
 Error (ERROR: operator does not exist: character varying = integer LINE
 1: ...l_id from forest_plot_layer where cell_id = 1
 ^
 HINT: No operator matches the given name and argument type(s). You might
 need to add explicit type casts.
 --

 My forest_plot_layer table only has a cell_id column which is the PK
 and a the_geom column.

 The WMS service works correctly.

 Does anyone have an idea?

 Thanks,

This: gml_featureid cell_id

Seems to be the culprit.  I'm not sure what that does, if you dont need 
it, delete it.

If you do need it, then I'd guess changing your sql to this would help:


DATA the_geom FROM (select cell_id, the_geom from forest_plot_layer) as 
subq

... unrelated, I see you dont have using unique on your DATA line... I 
believe it'll speed things up if you use it.  (although I have never 
actually tested the claim).

from: http://mapserver.org/input/vector/postgis.html

-Andy

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] about thematics maps

[Carlos Ruiz]

No, puedes hacer uso de un mismo archivo .MAP pero definiendo diferentes 
secciones LAYER con nombres 
diferentes para que puedas encender o apagar el temático que desees presentar.

Saludos desde México

 
IC Carlos Ruiz




From: salas fsa...@geocuba.cu
To: mapserver-users@lists.osgeo.org
Sent: Tue, June 8, 2010 12:12:58 PM
Subject: [mapserver-users] about thematics maps

 
Hi, i need obtain various thematic maps , using the same layer.
For this work i have to use different map(.map) file? 
bets regards Salas


  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Escape caracter on Mapfile

[Carlos Ruiz]

Cristiano,

Lo que dice la documentación ad literam es: If this is a PostGIS layer, the 
parameter should be in the form of
“columnname from tablename”, where “columnname” is the 
name of the
column containing the geometry objects and “tablename” is the name of 
the
table from which the geometry data will be read.

Por lo que creo que no es válido hacer uso de caracteres de escape.

Yo en lo personal, he tenido problemas con el escape de comillas dobles y 
simples dentro de las expresiones 
en las etiquetas EXPRESSION, supongo que tal vez esto del escape no funcione de 
manera estática (desde 
el archivo MAP) sino de manera dinámica (Haciendo uso de Mapscript).

Saludos desde México


IC Carlos Ruiz




From: Cristiano Sumariva sumar...@gmail.com
To: mapserver-users@lists.osgeo.org
Sent: Tue, June 8, 2010 2:24:35 PM
Subject: [mapserver-users] Escape caracter on Mapfile

People I got on this situation: mixing single quotes with double quotes.
Mapserver say at following page :
http://mapserver.org/mapfile/expressions.html
that for expressions it allow escape.
Do it allow escape on other mapfile attributes ?

Current mapserver version  is 5.4.1

I need the following string layer data attribute to create an query to perform 
a column concat since address is a compound information and has some null 
values.
I know some will say fix your data.

It is stopping at CATEG: Parsing error near (CATEG)

data the_geom from ( select oid, *, \CATEG\||( CASE WHEN \PREP\ is null 
THEN ' '::text ELSE \PREP\ END )||\LOGR\ as full_address from 
street_main_dissolv_utm ) as street_main_address_with_length_over_ten_kilometer


Postgresql lexer rules are:
 Identifiers are quoted with double quotes. 
 A column name is an identifier.
 And column name identifiers not quoted are lower cased.
 So need the double quotes around those upper case identifiers.
 
 Text strings are quoted in single quotes.
 || is string concat operator



  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] numeric label without decimal ?

[Carlos Ruiz]

Tonton,

This is because de data domain,there's no way to apply a format with the LABEL 
tag, you have to change the 
data domain from the data source directly


IC Carlos Ruiz




From: Tonton to.ton...@gmail.com
To: mapserver-users@lists.osgeo.org
Sent: Fri, June 4, 2010 8:05:30 AM
Subject: [mapserver-users] numeric label without decimal ?

hello 

i use shapefile  to render a map in wms layer. 
it is working good but ... 

the  column i use TXT  have number  ( 12 30 255 etc...) 

so i see with 10 digits after the point ( 12.  30.0 
255.0 etc...) 

if anybody know how to set that my label was text or integer and not decimal ? 
i haven't found it in mapserver documentation 

Tonton 

next the layer 

LAYER
NAME LabelParcelle.shp
DATA LabelParcelle.shp
TYPE POINT
DEBUG 5
DUMP TRUE
LABELCACHE ON
METADATA
WMS_TITLE LabelParcelle.shp
WMS_SRS EPSG:27572

WFS_TITLE LabelParcelle.shp
WFS_SRS EPSG:27572
END
LABELITEM TXT
CLASS
NAME LabelParcelle.shp
STYLE
SYMBOL 7
SIZE 2
OUTLINECOLOR 0 0 0
COLOR 0 0 0
END
LABEL
TYPE BITMAP
POSITION AUTO
SIZE MEDIUM
COLOR 0 0 0
End #LABEL
END
END #Layer


  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] mapserver.org down?

[Carlos Ruiz]

Hi,

Me neither. Cheers from México

 
IC Carlos Ruiz




From: Jan Hartmann j.l.h.hartm...@uva.nl
To: mapserver-users@lists.osgeo.org
Sent: Mon, April 26, 2010 10:38:55 AM
Subject: [mapserver-users] mapserver.org down?

Hi all,

Am I the only one that doesn't get through to mapserver.org? Pages take ages to 
load and then break off with a timeout.

Jan Hartmann
Amsterdam
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Multiples shapefiles, one LAYER

[Carlos Ruiz]

Conociendo más a fondo tu situación, pudiera ser que exista una alternativa si 
en vez de archivos SHP hicieras
uso de bases de datos relacionales como PostgreSQL, MySQL u Oracle.

Mi idea consiste en que cada propietario integrara su información en una base 
de datos, en donde podrían 
actualizar cuando quisieran. Tú por tu parte, creas una vista en la que unes 
(JOIN) las diferentes tablas de cada 
propietario, si y solo si la representación geometrica es la misma. Ya solo 
generas un archivo MAP con una 
sola capa haciendo referencia a la vista.

Yo en lo personal trabajo con PostgreSQL+PostGIS y ha resultado una excelente 
opción. Con afán de que 
conozcas un poco más de mi proyecto y veas si existe alguna relación hasta 
cierto punto en lo que estás 
trabajando, te hago llegar el siguiente vínculo:

http://www.postgis.org/documentation/casestudies/sitel/

Saludos !

IC Carlos Ruiz




From: Carmen Delia Hernández Pérez cdhernan...@tenerife.es
To: Carlos Ruiz boolean10...@yahoo.com
Sent: Fri, March 19, 2010 2:15:25 AM
Subject: RE: [mapserver-users] Multiples shapefiles, one LAYER

 
Hola!!
 
Sí, lo de fusionar los shapefiles en uno previamente es la solución que
ya había pensado. En el caso de capas de la misma topología me serviría, lo que
quería es ver si no tenía que hacer esa fusión previa y mantener los distintos
shp  ya que son ficheros que no son creados por mí y así conservo la
estructura original que me hacen llegar. Pero bueno, me parece que optaré
finalmente por esta opción.
 
Muchas gracias.
Saludos.
 
De:Carlos Ruiz
[mailto:boolean10...@yahoo.com] 
Enviado el: jueves, 18 de marzo de 2010 
15:52
Para: Carmen Delia Hernández Pérez
Asunto: Re: [mapserver-users]
Multiples shapefiles, one LAYER
 
Carmen,

Es imposible que quieras manejar múltiples archivos SHP y tratarlos como una
sola capa. Primeramente, por 
la representación, tal vez, algunas de las capas se representan con puntos y
otras con líneas, por lo que la 
estructura de la simbología es distinta.

Si todas las capas tienen la misma representación y los mismos atributos, por
qué no pensar en fusionarlas en 
un solo archivo SHP ?

Saludos desde México
 
IC
Carlos Ruiz
 


 
From:Carmen
Delia Hernández Pérez cdhernan...@tenerife.es
To: mapserver-users@lists.osgeo.org
Sent: Thu, March 18, 2010 9:05: 14 AM
Subject: [mapserver-users]
Multiples shapefiles, one LAYER
Hello!!
 
I need help. I´m using Mapserver  and  I`ve
some shapefiles of the “same region” but I would like only appear as a single
layer. I tried with GROUP property but I don´t want it to appear the individual
layers. Use TILEINDEX does not help me because they are of the same region. I
don´t know if it´s possible to do. For example I´ve some text shapefiles with
different styles but I would like they were activated as a single layer.
 
Any solution? 
 
 
Thanks.


  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Something odd with queries in 5.6.1

[Carlos Ruiz]

Thanks Daniel, 

I was reading the mapscript documentation before the post of this message and I 
found this:

layer.getShape(int tileindex, int shapeindex)) has been deprecated and
renamed to layer.getFeature(int shapeindex [, int tileindex = -1]) to
match the SWIG MapScript equivalent. Note that the order of the 
arguments
is reversed since tileindex is optional in getFeature().

But I didn't look the Mapserver RFC 52.

Thanks once again !


IC Carlos Ruiz




From: Daniel Morissette dmorisse...@mapgears.com
To: mapserver-users mapserver-users@lists.osgeo.org
Sent: Wed, March 10, 2010 4:54:09 PM
Subject: Re: [mapserver-users] Something odd with queries in 5.6.1

Carlos Ruiz wrote:
 Hi all,
 
 I noticed something odd when I do a query with the new 5.6.1 version.
 
 The getFeature method seems to return a NULL value, when it was working good 
 before the new version update.
 

Due to a change in the handling of queries in version 5.6, ols scripts must be 
updated to use the new $layer-resultsGetShape() method instead of 
$layer-GetShape() or $layer-GetFeature() to read query results.

There is a mention of this change in the migration guide, but it may not be 
clear enough (contributions welcome):
http://trac.osgeo.org/mapserver/browser/branches/branch-5-6/mapserver/MIGRATION_GUIDE.TXT

Daniel
-- Daniel Morissette
http://www.mapgears.com/
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Documentation - Re: [mapserver-users] Something odd with queries in 5.6.1

[Carlos Ruiz]

Maybe the PHP Mapscript documentation must specify in the getFeature method 
description of the 
LayerObj Class section 
(http://www.mapserver.org/mapscript/php/index.html#layerobj-class) that it's 
deprecated since version 5.6.1, as the getShape method description:

Deprecated in v5.0, use getFeature() instead (note that the order
of the arguments is reversed since 
tileindex is optional in
getFeature())




IC Carlos Ruiz




From: Daniel Morissette dmorisse...@mapgears.com
To: mapserver-users mapserver-users@lists.osgeo.org
Sent: Wed, March 10, 2010 4:54:09 PM
Subject: Re: [mapserver-users] Something odd with queries in 5.6.1

Carlos Ruiz wrote:
 Hi all,
 
 I noticed something odd when I do a query with the new 5.6.1 version.
 
 The getFeature method seems to return a NULL value, when it was working good 
 before the new version update.
 

Due to a change in the handling of queries in version 5.6, ols scripts must be 
updated to use the new $layer-resultsGetShape() method instead of 
$layer-GetShape() or $layer-GetFeature() to read query results.

There is a mention of this change in the migration guide, but it may not be 
clear enough (contributions welcome):
http://trac.osgeo.org/mapserver/browser/branches/branch-5-6/mapserver/MIGRATION_GUIDE.TXT

Daniel
-- Daniel Morissette
http://www.mapgears.com/
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Something odd with queries in 5.6.1

[Carlos Ruiz]

Hi all,

I noticed something odd when I do a query with the new 5.6.1 version.

The getFeature method seems to return a NULL value, when it was working good 
before the new version update.

Here's the code:

$n = $map-numlayers;

for ($i = 0; $i  $n; $i++) {

$theme = $map-GetLayer($i);

if ($tema-isVisible()) {
if (($regs = $theme-getNumResults()) == 0) {
continue;
}
}
else {
continue;
}

$theme-open();
$values = $theme-getitems();

unset($atts);

for ($reg = 0; $reg  $regs; $reg++) {

$result = $theme-getResult($reg);
// getFeature is returning NULL with the 5.6.1 version
$element = $theme-getFeature($result-shapeindex, $result-tileindex);

for ($value = 0; $value  count($values); $value++) {
$atts[] = $values[$value] .   . $element-values[$values[$value]];
}

// php crash because $element is a non object
$element-free();

}

$theme-close();

...

}

Any help or idea will be appreciated.

Thanks in advance


IC Carlos Ruiz


  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] VRT / CSV data sources are not displayed in a layer

[Carlos Ruiz]

Stefan, 

I asked you about your MAP definition to do some tests. This is what I tried 
and it works: It seems that you have to consider the following:

1. The name of the CSV file has to be the same as the layer name (layer boden 
and file name boden.csv).
2. You have to add the SrcLayer tag into your VRT file like this:

OGRVRTDataSource
OGRVRTLayer name=boden
SrcDataSourceboden.csv/SrcDataSource
SrcLayerboden/SrcLayer
GeometryTypewkbPoint/GeometryType
GeometryField encoding=PointFromColumns x=x-utm y=y-utm/
  /OGRVRTLayer
/OGRVRTDataSource


Try it !

Greetings from México

IC Carlos Ruiz




From: Stefan Schantz sscha...@bfs.de
To: Carlos Ruiz boolean10...@yahoo.com
Cc: mapserver-users@lists.osgeo.org
Sent: Thu, January 21, 2010 1:31:43 AM
Subject: Re: [mapserver-users] VRT / CSV data sources are not displayed in a 
layer

Well, here is the MAP definition, but the same mapfile works with the 
Shapefile, which I have transformed from the CSV/VRT-files, so I think, that 
the mapfile shouldn't be the issue.
Stefan
-
MAP
NAME rodos_bgefirst
STATUS ON
EXTENT 458690.8459237 1746161.3670216 6216440.5477323 6216440.5477323
UNITS METERS

DEBUG 5
CONFIG  MS_ERRORFILE /data/tmp/ms_debug.log

SYMBOLSET ../symbols/symbols.sym
FONTSET ../fonts/fonts.list
SHAPEPATH /daten/rasterkarten/

PROJECTION
   init=epsg:3035
END
 OUTPUTFORMAT
   NAME png
   DRIVER GD/PNG
   MIMETYPE image/png
   EXTENSION PNG
   IMAGEMODE PC256TRANSPARENT ON  END
   WEB
   IMAGEPATH /data/tmp/
   IMAGEURL http://10.162.18.107/tmp/;
   METADATA
 WMS_ACCESSCONSTRAINTSnone
 WMS_SRS   EPSG:4326 EPSG:32632 EPSG:25832 EPSG:31466 EPSG:31467 
EPSG:31468 EPSG:3035  WMS_ONLINERESOURCE
http://10.162.18.107/cgi-bin/mapserv?map=/data/umn/bfs/map/rodos_bgefirst_ssh.map;
 
 WMS_TITLERODOS Prognose Karte interpoliert
 WMS_FEATURE_INFO_MIME_TYPEtext/html
 WMS_ABSTRACTRODOS Prognose Karte
   END
END

INCLUDE ../include/legend_rodos.map
---
Carlos Ruiz schrieb:
 Can you show me the MAP definition ? Maybe I can find something there
 
 IC Carlos Ruiz
 
 
 *From:* Stefan Schantz sscha...@bfs.de
 *To:* Carlos Ruiz boolean10...@yahoo.com
 *Cc:* mapserver-users@lists.osgeo.org
 *Sent:* Wed, January 20, 2010 12:01:40 PM
 *Subject:* Re: [mapserver-users] VRT / CSV data sources are not displayed in 
 a layer
 
 Hello Carlos,
 my CSV-file ans VRT-file looks like your examples:
 
 My CSV is
 x-utm,y-utm,Wert
   742226.,  5374978., 0.00E+00
   743422.,  5375072., 0.00E+00
   744620.,  5375166., 0.00E+00
 ...
 
 and my VTR is
 OGRVRTDataSource
   OGRVRTLayer name=boden
   SrcDataSource/daten/csv/boden.csv/SrcDataSource
   GeometryTypewkbPoint/GeometryType
   GeometryField encoding=PointFromColumns x=x-utm y=y-utm/
   /OGRVRTLayer
 /OGRVRTDataSource
 
 and as I wrote, ogr2ogr could read my vrt/csv data and transform it into a 
 shapefile..
 
 Stefan
 
 Carlos Ruiz schrieb:
  Check that you have your CSV like this:
 
  Lat,Lng,House
  48.1,0.25,My house
  49.2,1.1,My girlfriend's house
  47.5,0.75,My mother in law's house
 
  And that you have your VTR like this:
 
  OGRVRTDataSource
  OGRVRTLayer name=neighborhood
 SrcDataSource[FILE]/SrcDataSource
 GeometryTypewkbPoint/GeometryType
 LayerSRS[YOUR SRS]/LayerSRS
 GeometryField encoding=PointFromColumns x=Lng y=Lat/
  /OGRVRTLayer
  /OGRVRTDataSource
 IC Carlos Ruiz
 
  
  *From:* Stefan Schantz sscha...@bfs.de mailto:sscha...@bfs.de
  *To:* mapserver-users@lists.osgeo.org 
  mailto:mapserver-users@lists.osgeo.org
  *Sent:* Wed, January 20, 2010 9:32:12 AM
  *Subject:* [mapserver-users] VRT / CSV data sources are not displayed in a 
  layer
 
  Hello List,
 
  The following layer uses a CSV-file (together with a VRT-File (Virtual 
  Format) ) as datasource . When I try to visualize the layer, nothing is 
  shown (neither the data nor error messages; shp2img shows also nothing)
 
  LAYER
   NAME boden
   DEBUG on
   STATUS ON
   TYPE POINT
  # DATA /daten/csv/boden/boden # Datenquelle Shapefile
   CONNECTION  /daten/csv/boden.vrt
   CONNECTIONTYPE OGR
 
   PROJECTION
   init=epsg:25832
   END
 METADATA
   WMS_TITLEtest
   WMS_SRS  EPSG:25832
   WMS_ABSTRACTtest
   WMS_FEATURE_INFO_MIME_TYPE 'text/html'
   END
 
   CLASS
   NAME test
   STYLE
   SYMBOL circle
   SIZE 15  COLOR 90 90 90
   END
   END  END
 
 
  But if I transform the CSV/VRT-file into a Shapefile  via ogr2ogr
 
  ogr2ogr -s_srs EPSG:25832 -t_srs EPSG:25832 -f ESRI Shapefile boden 
  boden.vrt
 
 
  the layer displays the data.
  What is wrong with my VRT/CSV-datasource

Re: [mapserver-users] VRT / CSV data sources are not displayed in a layer

[Carlos Ruiz]

Check that you have your CSV like this:

Lat,Lng,House
48.1,0.25,My house
49.2,1.1,My girlfriend's house
47.5,0.75,My mother in law's house

And that you have your VTR like this:

OGRVRTDataSource
OGRVRTLayer name=neighborhood
SrcDataSource[FILE]/SrcDataSource
GeometryTypewkbPoint/GeometryType
LayerSRS[YOUR SRS]/LayerSRS
GeometryField encoding=PointFromColumns x=Lng y=Lat/
/OGRVRTLayer
/OGRVRTDataSource

 
IC Carlos Ruiz



From: Stefan Schantz sscha...@bfs.de
To: mapserver-users@lists.osgeo.org
Sent: Wed, January 20, 2010 9:32:12 AM
Subject: [mapserver-users] VRT / CSV data sources are not displayed in a layer

Hello List,

The following layer uses a CSV-file (together with a VRT-File (Virtual Format) 
) as datasource . When I try to visualize the layer, nothing is shown (neither 
the data nor error messages; shp2img shows also nothing)

LAYER
   NAME boden
   DEBUG on
   STATUS ON
   TYPE POINT
# DATA /daten/csv/boden/boden # Datenquelle Shapefile
   CONNECTION   /daten/csv/boden.vrt
   CONNECTIONTYPE OGR

   PROJECTION
   init=epsg:25832
   END
 METADATA
   WMS_TITLEtest
   WMS_SRS   EPSG:25832
   WMS_ABSTRACTtest
   WMS_FEATURE_INFO_MIME_TYPE 'text/html'
   END

   CLASS
  NAME test
  STYLE
   SYMBOL circle
   SIZE 15  COLOR 90 90 90
  END
   END   END


But if I transform the CSV/VRT-file into a Shapefile  via ogr2ogr

ogr2ogr -s_srs EPSG:25832 -t_srs EPSG:25832 -f ESRI Shapefile boden boden.vrt


the layer displays the data.
What is wrong with my VRT/CSV-datasource in the mapfile?

Thanks for any idea.

Best regards
Stefan
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] 5.6.1 version and labels

[Carlos Ruiz]

Thanks Steve,

Lets see something simple that is changing in the new Mapserver version, here's 
the LAYER definition:

LAYER

NAME my name
TYPE annotation
STATUS ON
TRANSFORM ll
UNITS PIXELS

  FEATURE
  POINTS
  135 -10
END
TEXT my text
  END
  
  CLASS
LABEL
  FONT arial
  TYPE TRUETYPE
  SIZE 8
  BUFFER 1
  COLOR 0 0 0
  BACKGROUNDCOLOR 255 255 255
  FORCE TRUE
END
END
  
END

And now the MAP definition:

MAP

EXTENT 427469.4518 2086656.9173 860880.8507 2523277.2962
FONTSET fonts/fonts.txt
SYMBOLSET symbols.txt
SIZE 640 480
STATUS ON

OUTPUTFORMAT
NAME jpeg
DRIVER GD/JPEG
MIMETYPE image/jpeg
IMAGEMODE RGB
EXTENSION jpg
FORMATOPTION QUALITY=80
END

QUERYMAP
COLOR 255 255 0
STYLE NORMAL
END

RESOLUTION 99

UNITS meters

I've attached how it looks with the 5.4 version (before.jpg) and how it looks 
now with the 5.6.1 version (after.jpg).

Hope this helps you to find this strange behavior

Thanks in advance !


IC Carlos Ruiz


From: Lime, Steve D (DNR) steve.l...@state.mn.us
To: Carlos Ruiz boolean10...@yahoo.com; mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.org
Sent: Mon, January 11, 2010 3:55:08 PM
Subject: RE: [mapserver-users] 5.6.1 version and labels

 
What does your layer def look like? What renderer are you using?
Are you setting a specific RESOLUTION? There may be some subtle sizing changes 
but
I haven’t run across anything significant yet.
 
Before and after images are helpful too.
 
Steve
 
From:mapserver-users-boun...@lists.osgeo.org 
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Carlos Ruiz
Sent: Monday, January 11, 2010 3:43 PM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] 5.6.1 version and labels
 
Hi all, 

I have updated my Mapserver version from 5.4 to 5.6.0 (and later to 5.6.1
because the queries). There's something odd with the labels because appears
bigger than i had defined.

Does anybody knows why ?

Thanks in advance
IC
Carlos Ruiz


  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] 5.6.1 version and labels

[Carlos Ruiz]

Hey Alan, 


Using DEFRESOLUTION 99 now makes all the labels smaller than they was. 

Any other idea ?
Thanks for helping me on this issue


IC Carlos Ruiz




From: Alan Boudreault aboudrea...@mapgears.com
To: mapserver-users@lists.osgeo.org
Cc: Carlos Ruiz boolean10...@yahoo.com; Lime, Steve D (DNR) 
steve.l...@state.mn.us
Sent: Tue, January 12, 2010 1:43:48 PM
Subject: Re: [mapserver-users] 5.6.1 version and labels

Carlos, you haven't attached the images.

What's happen if you add the following line into your map definition:

DEFRESOLUTION 99

Alan

On January 12, 2010 02:26:18 pm Carlos Ruiz wrote:
 Thanks Steve,
 
 Lets see something simple that is changing in the new Mapserver version,
  here's the LAYER definition:
 
 LAYER
 
 NAME my name
 TYPE annotation
 STATUS ON
 TRANSFORM ll
 UNITS PIXELS
 
   FEATURE
   POINTS
   135 -10
 END
 TEXT my text
   END
 
   CLASS
 LABEL
   FONT arial
   TYPE TRUETYPE
   SIZE 8
   BUFFER 1
   COLOR 0 0 0
   BACKGROUNDCOLOR 255 255 255
   FORCE TRUE
 END
 END
 
 END
 
 And now the MAP definition:
 
 MAP
 
 EXTENT 427469.4518 2086656.9173 860880.8507 2523277.2962
 FONTSET fonts/fonts.txt
 SYMBOLSET symbols.txt
 SIZE 640 480
 STATUS ON
 
 OUTPUTFORMAT
 NAME jpeg
 DRIVER GD/JPEG
 MIMETYPE image/jpeg
 IMAGEMODE RGB
 EXTENSION jpg
 FORMATOPTION QUALITY=80
 END
 
 QUERYMAP
 COLOR 255 255 0
 STYLE NORMAL
 END
 
 RESOLUTION 99
 
 UNITS meters
 
 I've attached how it looks with the 5.4 version (before.jpg) and how it
  looks now with the 5.6.1 version (after.jpg).
 
 Hope this helps you to find this strange behavior
 
 Thanks in advance !
 
 
 IC Carlos Ruiz
 
 
 From: Lime, Steve D (DNR) steve.l...@state.mn.us
 To: Carlos Ruiz boolean10...@yahoo.com; mapserver-users@lists.osgeo.org
  mapserver-users@lists.osgeo.org Sent: Mon, January 11, 2010 3:55:08 PM
 Subject: RE: [mapserver-users] 5.6.1 version and labels
 
 
 What does your layer def look like? What renderer are you using?
 Are you setting a specific RESOLUTION? There may be some subtle sizing
  changes but I haven’t run across anything significant yet.
 
 Before and after images are helpful too.
 
 Steve
 
 From:mapserver-users-boun...@lists.osgeo.org
  [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Carlos Ruiz
  Sent: Monday, January 11, 2010 3:43 PM
 To: mapserver-users@lists.osgeo.org
 Subject: [mapserver-users] 5.6.1 version and labels
 
 Hi all,
 
 I have updated my Mapserver version from 5.4 to 5.6.0 (and later to 5.6.1
 because the queries). There's something odd with the labels because appears
 bigger than i had defined.
 
 Does anybody knows why ?
 
 Thanks in advance
 IC
 Carlos Ruiz
 

-- 
Alan Boudreault
Mapgears
http://www.mapgears.com



  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] 5.6.1 version and labels

[Carlos Ruiz]

Oh, I tought it was one or the other. Adding DEFRESOLUTION fixes the label's 
visual size. 

Why do I need now to add this tag if I never used before ?

Thanks for all, Alan

 
IC Carlos Ruiz

From: Alan Boudreault aboudrea...@mapgears.com

To: Carlos Ruiz boolean10...@yahoo.com
Cc: mapserver-users mapserver-users@lists.osgeo.org
Sent: Tue, January 12, 2010 2:37:46 PM
Subject: Re: [mapserver-users] 5.6.1 version and labels

emm, I mean, did you *added* the DEFRESOLUTION 99 ? and not replaced the 
RESOLUTION 99. You should have both.

Alan

On January 12, 2010 03:35:00 pm Carlos Ruiz wrote:
 Hey Alan,
 
 
 Using DEFRESOLUTION 99 now makes all the labels smaller than they was.
 
 Any other idea ?
 Thanks for helping me on this issue
 
 
 IC Carlos Ruiz
 
 
 
 
 From: Alan Boudreault aboudrea...@mapgears.com
 To: mapserver-users@lists.osgeo.org
 Cc: Carlos Ruiz boolean10...@yahoo.com; Lime, Steve D (DNR)
  steve.l...@state.mn.us Sent: Tue, January 12, 2010 1:43:48 PM
 Subject: Re: [mapserver-users] 5.6.1 version and labels
 
 Carlos, you haven't attached the images.
 
 What's happen if you add the following line into your map definition:
 
 DEFRESOLUTION 99
 
 Alan
 
 On January 12, 2010 02:26:18 pm Carlos Ruiz wrote:
  Thanks Steve,
 
  Lets see something simple that is changing in the new Mapserver version,
   here's the LAYER definition:
 
  LAYER
 
  NAME my name
  TYPE annotation
  STATUS ON
  TRANSFORM ll
  UNITS PIXELS
 
FEATURE
POINTS
135 -10
  END
  TEXT my text
END
 
CLASS
  LABEL
FONT arial
TYPE TRUETYPE
SIZE 8
BUFFER 1
COLOR 0 0 0
BACKGROUNDCOLOR 255 255 255
FORCE TRUE
  END
  END
 
  END
 
  And now the MAP definition:
 
  MAP
 
  EXTENT 427469.4518 2086656.9173 860880.8507 2523277.2962
  FONTSET fonts/fonts.txt
  SYMBOLSET symbols.txt
  SIZE 640 480
  STATUS ON
 
  OUTPUTFORMAT
  NAME jpeg
  DRIVER GD/JPEG
  MIMETYPE image/jpeg
  IMAGEMODE RGB
  EXTENSION jpg
  FORMATOPTION QUALITY=80
  END
 
  QUERYMAP
  COLOR 255 255 0
  STYLE NORMAL
  END
 
  RESOLUTION 99
 
  UNITS meters
 
  I've attached how it looks with the 5.4 version (before.jpg) and how it
   looks now with the 5.6.1 version (after.jpg).
 
  Hope this helps you to find this strange behavior
 
  Thanks in advance !
 
 
  IC Carlos Ruiz
 
  
  From: Lime, Steve D (DNR) steve.l...@state.mn.us
  To: Carlos Ruiz boolean10...@yahoo.com;
  mapserver-users@lists.osgeo.org mapserver-users@lists.osgeo.org Sent:
  Mon, January 11, 2010 3:55:08 PM Subject: RE: [mapserver-users] 5.6.1
  version and labels
 
 
  What does your layer def look like? What renderer are you using?
  Are you setting a specific RESOLUTION? There may be some subtle sizing
   changes but I haven’t run across anything significant yet.
 
  Before and after images are helpful too.
 
  Steve
 
  From:mapserver-users-boun...@lists.osgeo.org
   [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Carlos
  Ruiz Sent: Monday, January 11, 2010 3:43 PM
  To: mapserver-users@lists.osgeo.org
  Subject: [mapserver-users] 5.6.1 version and labels
 
  Hi all,
 
  I have updated my Mapserver version from 5.4 to 5.6.0 (and later to 5.6.1
  because the queries). There's something odd with the labels because
  appears bigger than i had defined.
 
  Does anybody knows why ?
 
  Thanks in advance
  IC
  Carlos Ruiz
 

-- 
Alan Boudreault
Mapgears
http://www.mapgears.com



  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] 5.6.1 version and labels

[Carlos Ruiz]

Hi all, 

I have updated my Mapserver version from 5.4 to 5.6.0 (and later to 5.6.1 
because the queries). There's something odd with the labels because appears 
bigger than i had defined.

Does anybody knows why ?

Thanks in advance


IC Carlos Ruiz


  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Polygon filled and with an image in the center ?

[Carlos Ruiz]

Hi list,

Does someone knows how to fill a polygon and put an image in the centroid 
within the same 
layer ?

Thanks in advance

IC Carlos Ruiz 


  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Postgis query

[Carlos Ruiz]

I guess the problem resides in the use of INNER and LEFT joins. Also, the order 
of the 
tables is important. The first tables specified in a query within the 
joins must be the ones 
which stablish the records agrupation or discrimination.

IC Carlos Ruiz
 

--- On Tue, 12/2/08, mark balman [EMAIL PROTECTED] wrote:

From: mark balman [EMAIL PROTECTED]
Subject: [mapserver-users] Postgis query
To: mapserver-users@lists.osgeo.org
Date: Tuesday, December 2, 2008, 4:37 AM

Hi All

I am trying to output a query from postgis using three tables and it
is not quite working.

First table is a quarter degree grid (spatial table)
Second table is a table with each grid cell id along with many species
id per grid cell
Third table is list of species

My query definition works well as the following (using two tables only)

select fid_1, the_geom AS the_geom, spcgrid.id as gid, spcid
from spcdensity
left join spcgrid on spcdensity.fid_1 = spcgrid.fid

This produces exactly what I want through mapserver, query a grid cell
and it returns a list of species within that grid cell

My problem is that I want to return a list of species names so my
query at present is defined as:

select spcid, spccommonname, fid_1, spcdensity.the_geom, spcid as gid
from spcgrid left join species on spcgrid.spcid = species.spcrecid
inner join spcdensity on spcdensity.fid_1 = spcgrid.fid

Although the query works when run in pgadmin, when I query a grid cell
I get a list of one species repeated. I am slightly confused as to
what I am missing here, can anyone provide me with some pointers?

Thanks in advance

Mark
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Mapserver doesn't compile for WMS/WFS client support

[Carlos Ruiz]

Hi list, 

I'm configuring Mapserver to support WMS/WFS Server and client features, but it 
doesn't 
works. 

I execute the ./configure script and this is what i get : 

MapServer is now configured for

 -- Compiler Info -
  C compiler:    gcc -O2 -fPIC -Wall
  C++ compiler:  g++ -O2 -fPIC -Wall
  Debug:  -DNEED_NONBLOCKING_STDERR
  Generic NINT:
  Threading support:

 -- Renderer Settings -
  zlib support:  -DUSE_ZLIB
  png support:
  jpeg support:
  iconv support: -DUSE_ICONV
  AGG support:
  AGG Freetype support:
  Ming(flash) support:
  PDFLib support:

 -- Data Format Drivers ---
  native tiff support:
  PostGIS support:   -DUSE_POSTGIS
  Proj.4 support:    -DUSE_PROJ
  EPPL7 support: -DUSE_EPPL
  ArcSDE support:
  OGR support:   -DUSE_OGR
  GDAL support:  -DUSE_GDAL
  GEOS support:  -DUSE_GEOS
  Oracle Spatial support:
  FastCGI support:

 -- OGC Services --
  WMS Server:    -DUSE_WMS_SVR
  WMS Client:    -DUSE_WMS_LYR
  WFS Server:    -DUSE_WFS_SVR
  WFS Client:    -DUSE_WMS_LYR
  WCS Server:
  SOS Server:

 -- MapScript -
  PHP MapScript: yes

Once I execute the make script and then check with ./mapserver -v, this is what 
i get :

MapServer version 5.0.2 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG 
OUTPUT=WBMP OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE 
SUPPORTS=WMS_SERVER SUPPORTS=GEOS INPUT=EPPL7 INPUT=POSTGIS 
INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE

But it doesn't shows SUPPORTS=WMS_CLIENT nor SUPPORTS=WFS_SERVER nor 
SUPPORT=WFS_CLIENT


Does anyone knows how to solve this ?

Thanks in advance

IC Carlos Ruiz 

--- On Thu, 9/18/08, Steve Lime [EMAIL PROTECTED] wrote:
From: Steve Lime [EMAIL PROTECTED]
Subject: Re: [mapserver-users] Mapserver (CGI/FastCGI) crashes when querying 
amap
To: mapserver-users@lists.osgeo.org, [EMAIL PROTECTED]
Date: Thursday, September 18, 2008, 1:54 PM

You're going to have to be more specific what the hell you're trying to
do. ;-)

 On 9/18/2008 at 1:43 PM, in message
[EMAIL PROTECTED], Carlos Ruiz
[EMAIL PROTECTED] wrote:
 Hi list,
 
 I have Mapserver 5.0.2 installed on Win32, when I do some queries to my
map, 
 the response 
 takes so long and then a window appears saying that CGI/FastCGI crashes.
Can 
 someone 
 have some idea why the hell is crashing ?
 
 Thanks in advance
 
 IC Carlos Ruiz
 
 
   




  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

RE: [mapserver-users] Mapserver doesn't compile for WMS/WFS clientsupport

[Carlos Ruiz]

Hi Tom,

Yes, i specify --the with-curl-config parameter. This is my configure string :



./configure --with-proj=/usr/lib --with-geos=/usr/bin/geos-config 
--with-ogr=/usr/local/bin/gdal-config --with-gdal=/usr/local/bin/gdal-config
--with-wms-server --with-wmsclient --with-wfs --with-wfsclient 
--with-postgis=/usr/local/pgsql/bin/pg_config 
--with-curl-config=/usr/bin/curl-config
--with-httpd=/usr/local/apache2/bin/httpd --with-php=/usr/local/php-5.2.6 

IC Carlos Ruiz 

--- On Thu, 11/13/08, Kralidis,Tom [Ontario] [EMAIL PROTECTED] wrote:
From: Kralidis,Tom [Ontario] [EMAIL PROTECTED]
Subject: RE: [mapserver-users] Mapserver doesn't compile for WMS/WFS 
clientsupport
To: [EMAIL PROTECTED], mapserver-users@lists.osgeo.org
Date: Thursday, November 13, 2008, 1:10 PM

 

 -Original Message-
 From: [EMAIL PROTECTED] 
 [mailto:[EMAIL PROTECTED] On Behalf Of 
 Carlos Ruiz
 Sent: Thursday, November 13, 2008 1:21 PM
 To: mapserver-users@lists.osgeo.org
 Subject: [mapserver-users] Mapserver doesn't compile for 
 WMS/WFS clientsupport
 
 Hi list, 
 
 I'm configuring Mapserver to support WMS/WFS Server and 
 client features, but it doesn't works. 
 
 I execute the ./configure script and this is what i get : 
 
 MapServer is now configured for
 
  -- Compiler Info -
   C compiler:gcc -O2 -fPIC -Wall
   C++ compiler:  g++ -O2 -fPIC -Wall
   Debug:  -DNEED_NONBLOCKING_STDERR
   Generic NINT:
   Threading support:
 
  -- Renderer Settings -
   zlib support:  -DUSE_ZLIB
   png support:
   jpeg support:
   iconv support: -DUSE_ICONV
   AGG support:
   AGG Freetype support:
   Ming(flash) support:
   PDFLib support:
 
  -- Data Format Drivers ---
   native tiff support:
   PostGIS support:   -DUSE_POSTGIS
   Proj.4 support:-DUSE_PROJ
   EPPL7 support: -DUSE_EPPL
   ArcSDE support:
   OGR support:   -DUSE_OGR
   GDAL support:  -DUSE_GDAL
   GEOS support:  -DUSE_GEOS
   Oracle Spatial support:
   FastCGI support:
 
  -- OGC Services --
   WMS Server:-DUSE_WMS_SVR
   WMS Client:-DUSE_WMS_LYR
   WFS Server:-DUSE_WFS_SVR
   WFS Client:-DUSE_WMS_LYR
   WCS Server:
   SOS Server:
 
  -- MapScript -
   PHP MapScript: yes
 
 
 Once I execute the make script and then check with 
 ./mapserver -v, this is what i get :
 
 MapServer version 5.0.2 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG 
 OUTPUT=WBMP OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE 
 SUPPORTS=WMS_SERVER SUPPORTS=GEOS INPUT=EPPL7 INPUT=POSTGIS 
 INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE
 
 But it doesn't shows SUPPORTS=WMS_CLIENT nor 
 SUPPORTS=WFS_SERVER nor SUPPORT=WFS_CLIENT
 
 Does anyone knows how to solve this ?
 
 Thanks in advance
 
 IC Carlos Ruiz
 

What does your ./configure look like?  Did you specify
--with-curl-config=PATH ?

..Tom



  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Mapserver (CGI/FastCGI) crashes when querying a map

[Carlos Ruiz]

Hi list,

I have Mapserver 5.0.2 installed on Win32, when I do some queries to my map, 
the response 
takes so long and then a window appears saying that CGI/FastCGI crashes. Can 
someone 
have some idea why the hell is crashing ?

Thanks in advance

IC Carlos Ruiz


  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

RE: [mapserver-users] Doubt

[Carlos Ruiz]

Ramya,

Please check the FEATURE section within LAYER section.

LAYER
...
FEATURE
POINTS x y END
END
...
END

OR

LAYER

...

FEATURE
WKT POINT(2000 2500)END

...


END


Greetings from México

IC Carlos Ruiz 

--- On Tue, 8/12/08, Venkat Rao Tammineni [EMAIL PROTECTED] wrote:
From: Venkat Rao Tammineni [EMAIL PROTECTED]
Subject: RE: [mapserver-users] Doubt
To: 'ramya srinivasan' [EMAIL PROTECTED], mapserver-users@lists.osgeo.org
Date: Tuesday, August 12, 2008, 3:32 AM




 
 






Hi, 

    Please check this url. 

   

     http://mapserver.gis.umn.edu/docs/reference/vector_data/VirtualSpatialData 

   

I hope it will help you… 

Thanks and Regards 

Venkat. 

   

   



From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of ramya
srinivasan

Sent: Tuesday, August 12, 2008 1:29 PM

To: mapserver-users@lists.osgeo.org

Subject: [mapserver-users] Doubt 



   



Hi,

i will have to display point in a map given its co-ordinates.The co-ordinates
has to be given manually.What do i have to do for that? 





 

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Still cannot display postGIS layers using ms4w(MapServer 5.0.2 on WinXP).

[Carlos Ruiz]

It seems that if you specify an empty filter like FILTER , Mapserver take it 
instead to ignore it. 

That means Mapserver construct a SQL statement with the WHERE clause empty 
(without conditionants).

IC Carlos Ruiz 

--- On Wed, 8/6/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
Subject: Re: [mapserver-users] Still cannot display postGIS layers using 
ms4w(MapServer 5.0.2 on WinXP).
To: Kusum [EMAIL PROTECTED]
Cc: mapserver-users@lists.osgeo.org
Date: Wednesday, August 6, 2008, 4:20 AM

I am an idiot.

Well I don't have a database named postgis on the first place (only
template_postgis), but I tried to apply your first DATA line to my own database
(test_mapserv).

Then I realized: your file don't have FILTER  clause. At the
same time, someone from postGIS mailing list told me that an empty FILTER clause
will just confuse postGIS. So I remove it from my mapfile and suddenly
everything works!

Thanks,
-Kresh


--- On Wed, 8/6/08, Kusum [EMAIL PROTECTED] wrote:

 From: Kusum [EMAIL PROTECTED]
 Subject: Re: [mapserver-users] Still cannot display postGIS layers using
ms4w(MapServer 5.0.2 on WinXP).
 To: [EMAIL PROTECTED]
 Date: Wednesday, August 6, 2008, 3:18 AM
 Try this format :-
 LAYER
   NAME route
   STATUS ON
   TYPE line
   CONNECTIONTYPE postgis
   CONNECTION user=postgres dbname=postgis
 host=localhost port=5432 
 password=postgres
   DATA the_geom from ind_road
 #DATA the_geom from (SELECT the_geom, gid from 
 shortest_path_as_geometry('hr_road', 1, 50)) as
 route using unique gid using 
 srid=-1
 #DATA the_geom from (SELECT the_geom from
 routing_results) as thing using 
 unique gid using srid=-1
  #DATA the_geom from (SELECT gid, the_geom from
 routing_results) as foo 
 using unique gid using srid=-1
 
  TEMPLATE t
   PROJECTION
 proj=latlong
 ellps=WGS84
  datum=WGS84
   END
 
 --
 From: [EMAIL PROTECTED]
 Sent: Wednesday, August 06, 2008 12:40 PM
 To: mapserver-users@lists.osgeo.org
 Subject: [mapserver-users] Still cannot display postGIS
 layers using 
 ms4w(MapServer 5.0.2 on WinXP).
 
  Help. Somebody please help. Somebody. Anybody. :-(
 
  I am using postgreSQL 8.2.5 for Windows with postGIS.
 The database was 
  installed using Windows .msi installation package. I
 am also using ms4w 
  2.2.7 that comes with MapServer 5.0.2. All installed
 on Windows XP Service 
  Pack 2.
 
  The MapServer does support postGIS. When I executed
 mapserv -v, I got the 
  following:
  MapServer version 5.0.2 OUTPUT=GIF OUTPUT=PNG
 OUTPUT=JPEG OUTPUT=WBMP 
  OUTPUT=PDF OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ
 SUPPORTS=AGG 
  SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER
 SUPPORTS=WMS_CLIENT 
  SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT
 SUPPORTS=WCS_SERVER 
  SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS
 SUPPORTS=GEOS 
  INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL
 INPUT=SHAPEFILE
 
  In the postgreSQL database, I have created a database
 named test_mapserv. 
  I also created a schema named rencana, and a table
 named kawasanbencana. 
  The name of the geometry column is the_geom.
  I have created a spatial index (kawasanbencanaspix) on
 the geometry 
  column. I also use lowercase to write the
 'from' statement.
 
  The problem is: MapServer always gives the
 ..Query error. Error executing 
  POSTGIS DECLARE.. error message, no matter what
 I do. And I have tried 
  everything ad nauseam.
 
  I have tried specifying the DATA line without USING
 UNIQUE ... USING SRID 
  line. I have tried specifying the DATA line with USING
 UNIQUE ...USING 
  SRID. I have tried using double apostrophe ()
 and single apostrophe ('). 
  It doesn't matter. Everything I have tried has
 failed, and I still get the 
  error message no matter what I did.
 
  My mapfiles are attached in this mail. Each reflect my
 futile attempt, and 
  all of them generated the error message.
 
 
  My first attempt:
  =
 
  This is my first attempt. I have both the mapfile and
 the error message 
  attached on this mail.
 CONNECTIONTYPE postgis
 CONNECTION 'host=localhost user=rtrw
 password=123456 port=5432 
  dbname=test_mapserver'
 DATA 'the_geom from rencana.kawasanbencana'
 
  And I got the following error message:
  msDrawMap(): Image handling error. Failed to draw
 layer named 
  'kawasanbencana'. prepare_database(): Query
 error. Error executing POSTGIS 
  DECLARE (the actual query) statement: 'DECLARE
 mycursor BINARY CURSOR FOR 
  SELECT
 asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text
 from 
  rencana.kawasanbencana WHERE () and (the_geom
  setSRID( 
  'BOX3D(528635.525378392 9074209,609092.162121608 
 

9134520)'::BOX3D,find_srid('','rencana.kawasanbencana','the_geom')
 ))' 
  Postgresql reports the error as 'ERROR: syntax
 error at or near ) LINE 
  1: ...DR'),gid::text from rencana.kawasanbencana
 WHERE () and (the... ^ ' 
  More Help: Error with POSTGIS data variable. You
 specified 'check your

Re: [mapserver-users] Ploblems with labels.

[Carlos Ruiz]

Te recomiendo que en el directorio donde se encuentra tu archivo .MAP, crea un 
directorio
llamado fuentes en donde copies los archivos .TTF para que en el archivo 
FONTS.LIST solo hagas referencia a /fuentes/nombre_archivo.ttf

I suggest you to create a folder named fuentes within the place where your 
.MAP file is, and then, copy the .TTF files there. Then, in the FONTS.LIST file 
you just put the /fonts/file_name.ttf reference.



IC Carlos Ruiz 

--- On Thu, 7/31/08, Stephen Woodbridge [EMAIL PROTECTED] wrote:
From: Stephen Woodbridge [EMAIL PROTECTED]
Subject: Re: [mapserver-users] Ploblems with labels.
To: David Martinez Morata [EMAIL PROTECTED]
Cc: mapserver mapserver-users@lists.osgeo.org
Date: Thursday, July 31, 2008, 11:47 AM

David Martinez Morata wrote:
 Hello list.
 I try to conect ArcGIS with a WMS server.
 But when I try to render Labels in other Font type tha the first of my 
 font.list arcgis send an error
 msGetLabelSize() TrueType Font error. Request (arial-bold-italic)not found
 
 My fonts.list file its:
 
 arial  
C:\WINDOWS\Fonts\arial.ttf
   arial-italic   
C:\WINDOWS\Fonts\ariali.ttf
   arial-bold-italic  
C:\WINDOWS\Fonts\arialbi.ttf
 
 Thanks

try changing you \ to / in the file paths. Also confirm that the file 
actually exists ar the cmd promopt:

dir C:\WINDOWS\Fonts\arialbi.ttf

-Steve W
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users



  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Problems with Postgres table's name in LAYER'S DATA

[Carlos Ruiz]

Hi all,

I have several tables wich begins with 0 or 1 like 001_street_names. I don't 
know how to 
handle it within DATA, because specifying the_geom FROM 001_street_names 
doesn't
work.

So, it must be written as the_geom FROM 001_street_names but the parser 
complains, is there a way to handle this ?

Thanks in advance

IC Carlos Ruiz




  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] cannot get data from postgis by querybypoint

[Carlos Ruiz]

Do you set the TEMPLATE item within that LAYER ? Because queries doesn't work 
if you
don't have set it. A template is an HTML file wich allows you to format the 
result of the 
queries you made.

IC Carlos Ruiz 

--- On Sun, 7/20/08, orkun [EMAIL PROTECTED] wrote:
From: orkun [EMAIL PROTECTED]
Subject: [mapserver-users] cannot get data from postgis by querybypoint
To: mapserver mapserver-users@lists.osgeo.org
Date: Sunday, July 20, 2008, 5:31 AM

hello

My postgis layer creates map properly. I think
it means database runs normally and any 
errors are not seen postgre's log file.
I have adjusted tcp listening to all.


But, I cannot get data from it by querybypoint,
although I followed same procedure to shape file layer
from which I can get data by querybypoint.

what might the reason be ?

any hint ?

regards


-- 
Ahmet Temiz
Jeo. Müh.
Afet İşleri Gen. Md.lüğü
Deprem Ar. D.

Ahmet Temiz
Geo. Eng.
General Dir. of 
Disaster Affairs



-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] queryByPoint + PostGIS layers + USING statement

[Carlos Ruiz]

If you want to retrieve geometry with a specify projection, i suggest you to 
set it inside the
postgres geometry_columns table, to simplify the query in the map file.

When you upload some shape file to the database via shp2pgsql utility, you can 
specify 
the SRID of the projection, if not, SRID sets to -1.

If you're an expert user, you can alter the values of the geometry_columns 
table.

IC Carlos Ruiz 

--- On Mon, 7/21/08, Stefan Schwarzer [EMAIL PROTECTED] wrote:
From: Stefan Schwarzer [EMAIL PROTECTED]
Subject: [mapserver-users] queryByPoint + PostGIS layers + USING statement
To: mapserver-users@lists.osgeo.org
Date: Monday, July 21, 2008, 8:00 AM

Hi there,

it seems that it's mandatory for postgis layers to use the
USING  
statement in the query.

My layer parameters look a bit like this:

DATA 'the_geom FROM ( SELECT  FROM xxx LEFT JOIN  WHERE xxx)  
AS foo USING UNIQUE uid USING srid=4326) '

But nevertheless, mapserver doesn't like it...

Can anyone give me a hint what is wrong with that?

Thanks for any advice,

Stef
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

RE: [MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema

[Carlos Ruiz]

Ritesh,
 
There's a way to stablish the default schema to a postgres user when it 
connects, maybe this can help you to pull the data from postgres.
 
To check what's the current default user's schema, you need to execute this:
 
SHOW search_path
 
It must throw $user, public
 
So, to set the default user's schema, you execute this:
 
ALTER USER user_name SET search_path TO schema_name
 
I suggest you to create a new role to connect to the database via map file, and 
then 
change its default schema.
 
Another thing (maybe this was the first step) is to check if the user postgres 
is the owner 
of the schema, and if it's not, then check if it haves the USAGE privilege on 
it.
 
Hope this information helps

IC Carlos Ruiz
 

--- On Wed, 7/16/08, Ritesh Ambastha [EMAIL PROTECTED] wrote:

From: Ritesh Ambastha [EMAIL PROTECTED]
Subject: RE: [MAPSERVER-USERS] Connection parameter errors while using Postgres 
DB Schema
To: mapserver-users@lists.osgeo.org
Date: Wednesday, July 16, 2008, 4:37 AM

Hey Venkat,

Thanks for the details. 
I understand the standard way to write a connection parameter. 

I am sure that this table rgp_gis_gmm_100_metros is stored in
public
schema of your database. 

My question is, what will you write if you keep this table in some other
schema?

Regards,


Venkatrao wrote:
 
 Hi,
 Here is my Example .I think it helps you.
 
 Layer # Layer starts here
   Name GMM 100 #name of the layer
   ConnectionType POSTGIS #connection type
   Connection host=192.168.1.158 dbname=GIS password=administrator
 user=postgres port=5432 #connection type.
   Data the_geom from rgp_gis_gmm_100_metros   #table name
 
 Thanks and Regards
 Venkat.
 
 
 
 
 
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED] On Behalf Of Ritesh
 Ambastha
 Sent: Wednesday, July 16, 2008 2:44 PM
 To: mapserver-users@lists.osgeo.org
 Subject: [MAPSERVER-USERS] Connection parameter errors while using
 Postgres
 DB Schema
 
 
 Hello Readers, 
 
 I am facing a problem in defining the DATA path in mapserver while using
 PostGIS. 
 
 I have two schemas, lets say 'a' and 'b' in a database
'd'
 
 Now, I want to access tables of schema 'a' in the mapserver layer.

 
 I define DATA path like this: 
 
 DATA the_geom FROM a.table_name USING UNIQUE id SRID -1 
 
 Please pour in your thoughts for defining schema in the connection/data
 parameters.
 
 Thanks,
 Ritesh Ambastha
 -- 
 View this message in context:

http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Sc
 hema-tp18483547p18483547.html
 Sent from the Mapserver - User mailing list archive at Nabble.com.
 
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users
 
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users
 
 

-- 
View this message in context:
http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Schema-tp18483547p18483876.html
Sent from the Mapserver - User mailing list archive at Nabble.com.

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Problems with simboloy using fonts

[Carlos Ruiz]

 
Greetings list,
 
I'm using some ESRI true type fonts to make some simbology for my layers. 
Mapserver 
renders multiple characters instead the ones i choose.
 
This is what i have:
 
symbol
   name layer_1
   type truetype
   font ers_infrastructures_stage_01
   character #67
end

ers_infraestructures_stage_01 is an alias of the 
ers_v2_infraestructures_st1.ttf file.
 
Can someone knows what's happening and how to solve this ?
 
Thanks in advance
 
 
IC Carlos Ruiz
 


  ___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users