[mapserver-users] how to display datas selected from the combobox in map

2009-03-25 Thread syed mohseen
hi,
   ia m newbie to fgs and i have created amap  all i have to do is i want to
display the name in my map when i selct the name from my combobox as it is
already saved in the database





will any help me out to overcome this problem
any help appreciated
thanks in advance
syedmohseen
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


[mapserver-users] Problems in making AGG outputformat for WMS

2009-03-25 Thread Rahkonen Jukka
Hi,
 
This MapServer version is 5.2.1 from MS4W, and it tells me for examle:
 
MapServer version 5.2.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP
OUTPUT=PDF OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG 
 
So it should support AGG rendering.  Now I have created agg OUTPUTFORMAT
about as adviced in 
http://www.mapserver.org/output/agg.html
 
  OUTPUTFORMAT
  NAME AGG
  MIMETYPE image/pngagg
  DRIVER AGG/PNG
  EXTENSION png
  IMAGEMODE RGB
  END
 
However, this mimetype is not included in the WMS 1.1.1 GetCapabilities
document
GetMap
  Formatimage/gif/Format
  Formatimage/png/Format
  Formatimage/png; mode=24bit/Format
 
If I edit OUTPUTFORMAT to have DRIVER GD/PNG then my own outputformat
is included in GetCapabilies.  
 
GetMap
  Formatimage/pngagg/Format
  Formatimage/gif/Format
  Formatimage/png/Format
  Formatimage/png; mode=24bit/Format
 
The problem is that AGG outputformat does not appear on the
GetCapabilities and thus WMS clients can not show it on menu.  If I edit
WMS getMap request manually to use FORMAT=image/pngagg it works.  For
me this looks like a small bug.  Is it perhaps reported already, or even
corrected?
 
-Jukka Rahkonen-
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


[mapserver-users] Perl mapscript installation problem

2009-03-25 Thread Alan Boudreault
Hi,

I've tried to install Perl Mapscript... i'm not familiar with perl in general. 
I've followed the instructions in the readme file and now i got this error 
when i try a script: Can't locate auto/mapscript/mapObj/swig_scale_.al in @INC 
(@INC contains: . /usr/lib/perl5/5.10.0/x86_64-linux-thread-multi 
/usr/lib/perl5/5.10.0 /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-
multi /usr/lib/perl5/site_perl/5.10.0 
/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi 
/usr/lib/perl5/vendor_perl/5.10.0 /usr/lib/perl5/vendor_perl) at 
/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/mapscript.pm line 38

I'm using an OpenSuse.

Thanks,
Alan

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


Re: [mapserver-users] Perl mapscript installation problem

2009-03-25 Thread Steve Lime
What's the script look like?

 Alan Boudreault aboudrea...@mapgears.com 03/25/09 7:39 AM 
Hi,

I've tried to install Perl Mapscript... i'm not familiar with perl in general. 
I've followed the instructions in the readme file and now i got this error 
when i try a script: Can't locate auto/mapscript/mapObj/swig_scale_.al in @INC 
(@INC contains: . /usr/lib/perl5/5.10.0/x86_64-linux-thread-multi 
/usr/lib/perl5/5.10.0 /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-
multi /usr/lib/perl5/site_perl/5.10.0 
/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi 
/usr/lib/perl5/vendor_perl/5.10.0 /usr/lib/perl5/vendor_perl) at 
/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/mapscript.pm line 38

I'm using an OpenSuse.

Thanks,
Alan

___
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] ogr connection to postgis problems

2009-03-25 Thread Travis Kirstine
I am trying to test a connection to a postgis db  using ogrinfo and am
having difficulties.  I am running the command on the same server that
hosts the postgis db.  I checked the pg_hba.config file to see if it
allows local connections and everything looks OK but I still get
Failure when connecting with ogr.

Am I missing something?


command
ogrinfo -ro PG:'host=server34 dbname=earth user=bob password=suruncle'


pg_hba.conf

# TYPE  DATABASEUSERCIDR-ADDRESS  METHOD

# local is for Unix domain socket connections only
local   all all   trust
# IPv4 local connections:
hostall all 127.0.0.1/32  trust
# IPv6 local connections:
hostall all ::1/128   trust

hostall all 192.168.18.0/24 password


-- 
Travis K.

Toronto, Canada

She knows there's no success like failure
and that failure's no success at all.
-Bob Dylan-

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


Re: [mapserver-users] ogr connection to postgis problems

2009-03-25 Thread Jeff McKenna

Travis Kirstine wrote:

I am trying to test a connection to a postgis db  using ogrinfo and am
having difficulties.  I am running the command on the same server that
hosts the postgis db.  I checked the pg_hba.config file to see if it
allows local connections and everything looks OK but I still get
Failure when connecting with ogr.

Am I missing something?


command
ogrinfo -ro PG:'host=server34 dbname=earth user=bob password=suruncle'




My thoughts:

- since you are on the same server, use host=127.0.0.1
- include the port parameter (usually port=5432)

-jeff




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


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


Re: [mapserver-users] ogr connection to postgis problems

2009-03-25 Thread Stephen Woodbridge

Jeff McKenna wrote:

Travis Kirstine wrote:

I am trying to test a connection to a postgis db  using ogrinfo and am
having difficulties.  I am running the command on the same server that
hosts the postgis db.  I checked the pg_hba.config file to see if it
allows local connections and everything looks OK but I still get
Failure when connecting with ogr.

Am I missing something?


command
ogrinfo -ro PG:'host=server34 dbname=earth user=bob password=suruncle'




My thoughts:

- since you are on the same server, use host=127.0.0.1
- include the port parameter (usually port=5432)


Have you try from the command line:

psql -h server34 -U bob earth
psql -h localhost -U bob earth
psql -U bob earth

Should prompt you for the password.

Only the last on will use the local socket or named pipe. If the last 
one works the try:


ogrinfo -ro PG:'host= dbname=earth user=bob password=suruncle'
ogrinfo -ro PG:'dbname=earth user=bob password=suruncle'

and see if either of these work.

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


Re: [mapserver-users] Problems in making AGG outputformat for WMS

2009-03-25 Thread Yewondwossen Assefa

Hi There,

 It is a bug. ticket related to it is 
http://trac.osgeo.org/mapserver/ticket/2957 and should be available for 
the next MapServer release.


Best Regards,


Rahkonen Jukka wrote:

Hi,
 
This MapServer version is 5.2.1 from MS4W, and it tells me for examle:
 
MapServer version 5.2.1 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP 
OUTPUT=PDF OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG 
 
So it should support AGG rendering.  Now I have created agg OUTPUTFORMAT 
about as adviced in

http://www.mapserver.org/output/agg.html
 
  OUTPUTFORMAT

  NAME AGG
  MIMETYPE image/pngagg
  DRIVER AGG/PNG
  EXTENSION png
  IMAGEMODE RGB
  END
 
However, this mimetype is not included in the WMS 1.1.1 GetCapabilities 
document

GetMap
  Formatimage/gif/Format
  Formatimage/png/Format
  Formatimage/png; mode=24bit/Format
 
If I edit OUTPUTFORMAT to have DRIVER GD/PNG then my own outputformat 
is included in GetCapabilies. 
 
GetMap

  Formatimage/pngagg/Format
  Formatimage/gif/Format
  Formatimage/png/Format
  Formatimage/png; mode=24bit/Format
 
The problem is that AGG outputformat does not appear on the 
GetCapabilities and thus WMS clients can not show it on menu.  If I edit 
WMS getMap request manually to use FORMAT=image/pngagg it works.  For 
me this looks like a small bug.  Is it perhaps reported already, or even 
corrected?
 
-Jukka Rahkonen-





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



--

Assefa Yewondwossen
Software Analyst

Email: ass...@dmsolutions.ca
http://www.dmsolutions.ca/

Phone: (613) 565-5056 (ext 14)
Fax:   (613) 565-0925


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


[mapserver-users] WMS and transparent

2009-03-25 Thread Fischer, Brian
 

I am trying to consume this  WMS service with MapServer 5.0.2 as a
client and would like to make the background transparent instead of
white.  Is this possible mapserver?  I tried the  wms_transparent
true, but that didn't seem to work.  Thanks for any suggestions.

 

  NAME '2003orthos'

  STATUS ON

  EXTENT 366751.468 5034450.028 882880.091 5434570.553

  UNITS Meters

   SIZE  600 400

   FONTSET '../fonts/fontset.list'

   SYMBOLSET '../symbols/symbol.sym'

  IMAGETYPE PNG24

  TRANSPARENT TRUE

 

WEB

IMAGEURL E:\ms4w\tmp\ms_tmp

IMAGEPATH E:\ms4w\tmp\ms_tmp

END

 

 

  LAYER

NAME ND03

TYPE RASTER

OFFSITE  0 0 0

STATUS   DEFAULT

CONNECTIONTYPE WMS

CONNECTION
http://web.apps.state.nd.us/wmsconnector/com.esri.wms.Esrimap/NDWMS_aer
ialimages?

 

#MINSCALE  1000 # only display down to this scale

#MAXSCALE 24000

 

METADATA

  wms_srs EPSG:26914

  wms_name ND03

  wms_server_version 1.1.1

  wms_format image/jpeg

  wms_styles 

  wms_exceptions application/vnd.ogc.se_inimage

END

 

  END

END

 

 

End #Map

 

Thanks,

Brian

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


Re: [mapserver-users] WMS and transparent

2009-03-25 Thread bartvde
Hi,

jpegs can not be transparent. Only if you switch to another image format
like image/png.

Best regards,
Bart



 I am trying to consume this  WMS service with MapServer 5.0.2 as a
 client and would like to make the background transparent instead of
 white.  Is this possible mapserver?  I tried the  wms_transparent
 true, but that didn't seem to work.  Thanks for any suggestions.



   NAME '2003orthos'

   STATUS ON

   EXTENT 366751.468 5034450.028 882880.091 5434570.553

   UNITS Meters

SIZE  600 400

FONTSET '../fonts/fontset.list'

SYMBOLSET '../symbols/symbol.sym'

   IMAGETYPE PNG24

   TRANSPARENT TRUE



 WEB

 IMAGEURL E:\ms4w\tmp\ms_tmp

 IMAGEPATH E:\ms4w\tmp\ms_tmp

 END





   LAYER

 NAME ND03

 TYPE RASTER

 OFFSITE  0 0 0

 STATUS   DEFAULT

 CONNECTIONTYPE WMS

 CONNECTION
 http://web.apps.state.nd.us/wmsconnector/com.esri.wms.Esrimap/NDWMS_aer
 ialimages?



 #MINSCALE  1000 # only display down to this scale

 #MAXSCALE 24000



 METADATA

   wms_srs EPSG:26914

   wms_name ND03

   wms_server_version 1.1.1

   wms_format image/jpeg

   wms_styles 

   wms_exceptions application/vnd.ogc.se_inimage

 END



   END

 END





 End #Map



 Thanks,

 Brian

 ___
 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] WMS and transparent

2009-03-25 Thread bartvde
Yeah maybe OFFSITE can do this for you, give it a try, it works for normal
rasters so why not for a WMS client layer (haven't tried though).

Best regards,
Bart

 Thanks for the reply.  I was hoping maybe MapServer could consume that
 jpeg and set the white color to transparent, then mapserver would output
 a PNG that has transparency to the web client.  Does the offsite
 parameter do this by chance or is there another trick that could be
 used?

 -Original Message-
 From: bart...@osgis.nl [mailto:bart...@osgis.nl]
 Sent: Wednesday, March 25, 2009 9:47 AM
 To: Fischer, Brian
 Cc: mapserver-users@lists.osgeo.org
 Subject: Re: [mapserver-users] WMS and transparent

 Hi,

 jpegs can not be transparent. Only if you switch to another image format
 like image/png.

 Best regards,
 Bart



 I am trying to consume this  WMS service with MapServer 5.0.2 as a
 client and would like to make the background transparent instead of
 white.  Is this possible mapserver?  I tried the  wms_transparent
 true, but that didn't seem to work.  Thanks for any suggestions.



   NAME '2003orthos'

   STATUS ON

   EXTENT 366751.468 5034450.028 882880.091 5434570.553

   UNITS Meters

SIZE  600 400

FONTSET '../fonts/fontset.list'

SYMBOLSET '../symbols/symbol.sym'

   IMAGETYPE PNG24

   TRANSPARENT TRUE



 WEB

 IMAGEURL E:\ms4w\tmp\ms_tmp

 IMAGEPATH E:\ms4w\tmp\ms_tmp

 END





   LAYER

 NAME ND03

 TYPE RASTER

 OFFSITE  0 0 0

 STATUS   DEFAULT

 CONNECTIONTYPE WMS

 CONNECTION

 http://web.apps.state.nd.us/wmsconnector/com.esri.wms.Esrimap/NDWMS_aer
 ialimages?



 #MINSCALE  1000 # only display down to this scale

 #MAXSCALE 24000



 METADATA

   wms_srs EPSG:26914

   wms_name ND03

   wms_server_version 1.1.1

   wms_format image/jpeg

   wms_styles 

   wms_exceptions application/vnd.ogc.se_inimage

 END



   END

 END





 End #Map



 Thanks,

 Brian

 ___
 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] WMS and transparent

2009-03-25 Thread Rahkonen Jukka
Hi,

Or perhaps OFFSITE will have difficulties because jpeg compression makes
totally black to almost black.  If it works the result could still be
only partially transparent image with some non-transparent pixels here
and there.

-Jukka Rahkonen-


Bart wrote: 
 
 Yeah maybe OFFSITE can do this for you, give it a try, it 
 works for normal rasters so why not for a WMS client layer 
 (haven't tried though).
 
 Best regards,
 Bart
 
  Thanks for the reply.  I was hoping maybe MapServer could 
 consume that 
  jpeg and set the white color to transparent, then mapserver would 
  output a PNG that has transparency to the web client.  Does the 
  offsite parameter do this by chance or is there another trick that 
  could be used?
 
  -Original Message-
  From: bart...@osgis.nl [mailto:bart...@osgis.nl]
  Sent: Wednesday, March 25, 2009 9:47 AM
  To: Fischer, Brian
  Cc: mapserver-users@lists.osgeo.org
  Subject: Re: [mapserver-users] WMS and transparent
 
  Hi,
 
  jpegs can not be transparent. Only if you switch to another image 
  format like image/png.
 
  Best regards,
  Bart
 
 
 
  I am trying to consume this  WMS service with MapServer 5.0.2 as a 
  client and would like to make the background transparent 
 instead of 
  white.  Is this possible mapserver?  I tried the  wms_transparent
  true, but that didn't seem to work.  Thanks for any suggestions.
 
 
 
NAME '2003orthos'
 
STATUS ON
 
EXTENT 366751.468 5034450.028 882880.091 5434570.553
 
UNITS Meters
 
 SIZE  600 400
 
 FONTSET '../fonts/fontset.list'
 
 SYMBOLSET '../symbols/symbol.sym'
 
IMAGETYPE PNG24
 
TRANSPARENT TRUE
 
 
 
  WEB
 
  IMAGEURL E:\ms4w\tmp\ms_tmp
 
  IMAGEPATH E:\ms4w\tmp\ms_tmp
 
  END
 
 
 
 
 
LAYER
 
  NAME ND03
 
  TYPE RASTER
 
  OFFSITE  0 0 0
 
  STATUS   DEFAULT
 
  CONNECTIONTYPE WMS
 
  CONNECTION
 
  
 http://web.apps.state.nd.us/wmsconnector/com.esri.wms.Esrimap/NDWMS_a
  er
  ialimages?
 
 
 
  #MINSCALE  1000 # only display down to this scale
 
  #MAXSCALE 24000
 
 
 
  METADATA
 
wms_srs EPSG:26914
 
wms_name ND03
 
wms_server_version 1.1.1
 
wms_format image/jpeg
 
wms_styles 
 
wms_exceptions application/vnd.ogc.se_inimage
 
  END
 
 
 
END
 
  END
 
 
 
 
 
  End #Map
 
 
 
  Thanks,
 
  Brian
 
  ___
  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


[mapserver-users] Oracle Spatial Layer + C# map script

2009-03-25 Thread Murty Maganti
Hi

 

I am using a oracle spatial layer which has roughly 100,000 features.
When I call layerObj.getExtents() function, it takes a long time to
return.  This is the query sent to oracle by map server

 

SELECT SDO_AGGR_MBR(GEOM) AS GEOM from (SELECT GEOM FROM ORSPTL.PARCELS)

 

If I run the query in database, it takes long time to execute. Is there
way to optimize this query to execute fast? Also, I see that layer
extents are stored in USER_SDO_GEOM_METADATA table. Why is map server
not querying against that.

 

Thanks

Murty

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


[mapserver-users] Installation Problems

2009-03-25 Thread Praveen Kumar Koppula

Hello,
I am having problem installing mapserver which is as follows.
I have already installed png,freetype and pthreads libraries.
configuration with libpng,zlib and freetype was successfull.
when i am trying to configure GD the error occured which is listed below for 
your reference.
** Configuration summary for gd 2.0.35:

   Support for PNG library:  yes
   Support for JPEG library: no
   Support for Freetype 2.x library: yes
   Support for Fontconfig library:   no
   Support for Xpm library:  no
   Support for pthreads: yes

configure: creating ./config.status
config.status: creating Makefile
config.status: creating config/Makefile
config.status: creating config/gdlib-config
config.status: creating test/Makefile
config.status: creating config.h
config.status: config.h is unchanged
config.status: executing depfiles commands


I have also tried installing the rpm library and it says cannot create 
transaction lock control and also when i am trying to query the installed rpm 
libraries with rpm -qa, in that list i can find all the required libraries 
installed.

Kindly help me in this regard.

Regards
Praveen


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


Re: [mapserver-users] ogr connection to postgis problems

2009-03-25 Thread Travis Kirstine
2009/3/25 Stephen Woodbridge wood...@swoodbridge.com:
 Jeff McKenna wrote:

 Travis Kirstine wrote:

 I am trying to test a connection to a postgis db  using ogrinfo and am
 having difficulties.  I am running the command on the same server that
 hosts the postgis db.  I checked the pg_hba.config file to see if it
 allows local connections and everything looks OK but I still get
 Failure when connecting with ogr.

 Am I missing something?


 command
 ogrinfo -ro PG:'host=server34 dbname=earth user=bob password=suruncle'



 My thoughts:

 - since you are on the same server, use host=127.0.0.1
 - include the port parameter (usually port=5432)

 Have you try from the command line:

 psql -h server34 -U bob earth
 psql -h localhost -U bob earth
 psql -U bob earth

 Should prompt you for the password.

 Only the last on will use the local socket or named pipe. If the last one
 works the try:

 ogrinfo -ro PG:'host= dbname=earth user=bob password=suruncle'
 ogrinfo -ro PG:'dbname=earth user=bob password=suruncle'

 and see if either of these work.


I got the query / connection to work, it seems that the -ro flag was
causing the problem
which is strange.

this works
ogrinfo -sql 'SELECT * FROM counties' PG:'host= dbname=earth user=bob
password=suruncle'

this dosen't
ogrinfo -ro -sql 'SELECT * FROM counties' PG:'host= dbname=earth
user=bob password=suruncle'

I'm not sure what the problem is as the user bob has su privileges


   List of roles
 Role name | Superuser | Create role | Create DB | Connections | Member of
---+---+-+---+-+---
 postgres  | yes   | yes | yes   | no limit|
 bob  | yes   | no  | yes   | no limit|



-- 
Travis K.

Toronto, Canada

She knows there's no success like failure
and that failure's no success at all.
-Bob Dylan-

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


Re: [mapserver-users] ogr connection to postgis problems

2009-03-25 Thread Even Rouault
Travis,

this is really weird. I've reviewed a bit the source of the PG driver and the 
influence of the read-only mode vs update mode is very thin. The only 
behavioural differences are :
1) the result of TestCapabilities() method depend on it, but ogrinfo doesn't 
request layer TestCapabilities().
2) if the PG database has no valid tables (for OGR), its opening will fail in 
read-only mode, whereas it would succeed in update mode.

So in your use case, provided that there's at least one table reported by 
ogrinfo in update mode, I don't understand why it fails. What's the version 
of GDAL/OGR you're using ? 

Le Wednesday 25 March 2009 19:51:39 Travis Kirstine, vous avez écrit :
 2009/3/25 Stephen Woodbridge wood...@swoodbridge.com:
  Jeff McKenna wrote:
  Travis Kirstine wrote:
  I am trying to test a connection to a postgis db  using ogrinfo and am
  having difficulties.  I am running the command on the same server that
  hosts the postgis db.  I checked the pg_hba.config file to see if it
  allows local connections and everything looks OK but I still get
  Failure when connecting with ogr.
 
  Am I missing something?
 
 
  command
  ogrinfo -ro PG:'host=server34 dbname=earth user=bob password=suruncle'
 
  My thoughts:
 
  - since you are on the same server, use host=127.0.0.1
  - include the port parameter (usually port=5432)
 
  Have you try from the command line:
 
  psql -h server34 -U bob earth
  psql -h localhost -U bob earth
  psql -U bob earth
 
  Should prompt you for the password.
 
  Only the last on will use the local socket or named pipe. If the last one
  works the try:
 
  ogrinfo -ro PG:'host= dbname=earth user=bob password=suruncle'
  ogrinfo -ro PG:'dbname=earth user=bob password=suruncle'
 
  and see if either of these work.

 I got the query / connection to work, it seems that the -ro flag was
 causing the problem
 which is strange.

 this works
 ogrinfo -sql 'SELECT * FROM counties' PG:'host= dbname=earth user=bob
 password=suruncle'

 this dosen't
 ogrinfo -ro -sql 'SELECT * FROM counties' PG:'host= dbname=earth
 user=bob password=suruncle'

 I'm not sure what the problem is as the user bob has su privileges


List of roles
  Role name | Superuser | Create role | Create DB | Connections | Member of
 ---+---+-+---+-+---
  postgres  | yes   | yes | yes   | no limit|
  bob  | yes   | no  | yes   | no limit|


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


[mapserver-users] msOGRFileNextShape(): OGR error. TopologyException: side location conflict

2009-03-25 Thread Tamas Szekeres
Hi All,

I've found this issue when drawing a map with MapServer in a certain view.
By setting the center to a slightly different position the problem
disappears and the map is drawn correctly.

msDrawMap(): Image handling error. Failed to draw layer named
'MainStreet'.;msOGRFileNextShape(): OGR error. TopologyException: side
location conflict 19.0499 47.5334 1.7e-308

Does anyone know where this error is coming from? I've seached for these
strings in the MapServer and OGR code but didn't find any hit.


Best regards,

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


[mapserver-users] Move point symbols (water valves) along a line (waterline) depending on scale

2009-03-25 Thread boesiii

I have a point shapefile representing gate valves for waterlines and some of 
the gate valves are very close to each other and you may or may not be able to 
view them depending on scale.  Is there a way to have MapServer automatically 
adjust point symbols (water valves) along a line (waterline) so the points are 
displayed at any scale?

ArcGIS does this with a tool called cartographic representation.
-- 
View this message in context: 
http://n2.nabble.com/Move-point-symbols-%28water-valves%29-along-a-line-%28waterline%29-depending-on-scale-tp2536075p2536075.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] nquery against mysql is ignoring 1 row from resultset

2009-03-25 Thread P. R.M.

I need help figuring out why mapserver is ignoring one row from my resultset.
Ive attached all of the necessary files.
 
testdata.sql - sql commands to setup a simple mysql table with some test data
test.map - my mapfile
test.ovf - the ogr/mysql file
testmap.html - the html template file
out.html - the resulting html output
 
my output, out.html, should be an html imagemap with 4 'areas'that match the 4 
rows in my db table, but only three areas are being created. 
 
mapserver is correctly drawing 4 symbols for the 4 rows in my database table, 
but it misses the 2nd row in the output when parsing the 
[featureset][/featureset] sections of the html template file.
 
Can anyone reproduce this problem?
 
Im running the latest version of mapserver on linux, built from source.
 
Please help,
Thanks
P.Romero
_
Internet Explorer 8 – Now Available. Faster, safer, easier.
http://clk.atdmt.com/MRT/go/141323790/direct/01/Title: Simple Template For Imagemaps

  
  














Title: Simple Template For Imagemaps

  
  

[resultset layer=mypoints]
[feature]

[/feature]
[/resultset]




# example map file for creating image maps with mapserver
MAP
  NAME 'basic'
  SIZE 600 600
  EXTENT -100 10  -60 30
  IMAGECOLOR 167 200 255
  SHAPEPATH /data/shp
  UNITS DD
  
  PROJECTION
init=epsg:4326
  END

  IMAGETYPE AGG
  
  OUTPUTFORMAT
NAME 'AGG'
DRIVER AGG/PNG
IMAGEMODE RGB
  END
  
  OUTPUTFORMAT
NAME 'html'
DRIVER 'TEMPLATE'
MIMETYPE 'text/html'
FORMATOPTION 'FILE=/data/www/html/test/testmap.html'
  END


  QUERYMAP
STATUS ON
STYLE NORMAL
  END

  WEB
QUERYFORMAT 'html'  
  END

  WEB
IMAGEPATH /tmp/
IMAGEURL /tmp/
MAXSCALE 1550
  END

LAYER
  NAME mypoints
  STATUS DEFAULT
CONNECTIONTYPE OGR
CONNECTION test.ovf
DATA mypoints
  TYPE POINT
  TEMPLATE /data/www/html/test/testmap.html
CLASS 
   NAME None
   STYLE
   SYMBOL 'circle'
   SIZE 14
   COLOR 0 255 0
   END
END

END

# Symbols ###

SYMBOL
  NAME 'circle'
  TYPE ELLIPSE
  POINTS 1 1 END
  FILLED TRUE
END

ENDOGRVRTDataSource
OGRVRTLayer name=mypoints

SrcDataSourceMYSQL:surf,user=root,password='',host=localhost,port=3306,tables=testdata/SrcDataSource
SrcSQLSELECT * FROM surf.testdata order by id asc/SrcSQL
GeometryTypewkbPoint/GeometryType
GeometryField encoding=PointFromColumns x=lng y=lat/
/OGRVRTLayer
/OGRVRTDataSource-- phpMyAdmin SQL Dump
-- version 3.1.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 25, 2009 at 11:35 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

SET SQL_MODE=NO_AUTO_VALUE_ON_ZERO;

--
-- Database: `surf`
--

-- 

--
-- Table structure for table `testdata`
--

CREATE TABLE IF NOT EXISTS `testdata` (
  `id` int(11) NOT NULL auto_increment,
  `name` char(10) NOT NULL,
  `lat` double NOT NULL,
  `lng` double NOT NULL,
  `angl` double NOT NULL,
  `val1` double NOT NULL,
  `val2` double NOT NULL,
  `val3` double NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `testdata`
--

INSERT INTO `testdata` (`id`, `name`, `lat`, `lng`, `angl`, `val1`, `val2`, 
`val3`) VALUES
(1, 'test1', 21.25, -86.75, 190, 20.5, 12, 5),
(2, 'test2', 30.5, -80.3, 50, 12, 5, 2),
(3, 'test3', 27, -95, 33, 3365, 4, 3),
(4, 'test4', 17, -90, 15, 74, 4, 6);
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users