[mapserver-users] (no subject)

2009-04-28 Thread Pedro Briones García
 

What is the best way to map attribute data (non-geom) from Oracle (not

*  Spatial) using MapServer

 

 

Un saludo.

 

Pedro Briones García

 

TRAGSATEC 

Gerencia de SIG y Consultoría

Departamento de Cartografía

C/ Julián Camarillo 6, Edificio 6B - 2ª Pl. Sector B

28037 Madrid

mailto:p...@tragsa.es

Tfno.: +34 91 322 6489/+34 679 09 0001

 

 

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


Re: [mapserver-users] How to link Oracle attributes to SHAPEFILE

2009-04-28 Thread Roald de Wit

Hi Pedro,

A number of years ago i had a situation like you describe below. The
solution we chose was:
- Create a postgresql/postgis datawarehouse
- Import shapefiles into postgis (shp2psql or ogr2ogr)
- Import attribute info from oracle into postgresql (we needed a
commercial license for converting Oracle to Postgresql)
- Either create a view or merge tables to join the geometry and
attribute info
- Serve the lot through MapServer WFS/WMS

I hope this helps.

Regards, Roald

Pedro Briones García wrote:

Hello.

I’m working with *Oracle 10g* and *MapServer 5.2*. My geographic layers are 
SHAPEFILES and the attributes of SHAPEFILES are stored in Oracle 10g (*NOT* 
Oracle Spatial or Locator)

I need to link (or join) SHAPEFILES with attribute (NOT spatial) tables to do 3 
things:

-Draw only elements of SHAPEFILE that are related with some records in 
Oracle. A record (polygon, for example) in the SHAPEFILE should only draw if is 
related with a record in Oracle (they both have a common column).
-Make a thematic map wich classifications depending on the values of 
Oracle records.
-Draw only elements of SHAPEFILE that meet an Oracle condition





I have found lots of examples of layers wich both, geometry and
attribtes, in Oracle; or layers in Oracle Spatial, but none of how to
link and use a SHAPEFILE with Oracle (not spatial).





I too would like to do the same of the aforementioned, but in this
case with *DBF files* instead of Oracle tables. I have seen an example
in the documentation, but I don’t know distinguish SHAPEFILES and the
DBF files in the sentence.



Please, could somebody send me an example to easily understand this?



Thanks in advance.



Pedro Briones García



TRAGSATEC






--
Roald de Wit
Software Engineer
roald.de...@lisasoft.com

Commercial Support for Open Source GIS Software
http://lisasoft.com/LISAsoft/SupportedProducts/



The contents of this email are confidential and may be subject to legal or 
professional privilege and copyright. No representation is made that this email 
is free of viruses or other defects. If you have received this communication in 
error, you may not copy or distribute any part of it or otherwise disclose its 
contents to anyone. Please advise the sender of your incorrect receipt of this 
correspondence.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


RE: [mapserver-users] Inconsistency between 5.4 and 5.2.1 concerningWhichShapes()?

2009-04-28 Thread Jim Strevinas

Steve, you are absolutely right, according to #2689 i tried commenting
out the msLayerWhichItems (layer.i) prior to msLayerWhichShapes in
the 5.4 release. The item setup is thus maintained. 
While i'm afraid to mess with maplayer.c and maybe this will sound silly
,i observed that within maplayer.c in function msLayerWhichItems()
at line 402, a cleanup of the previous item selections is performed:

msLayerFreeItemInfo(layer);
if(layer-items) {
msFreeCharArray(layer-items, layer-numitems);
layer-items = NULL;
layer-numitems = 0;
}

I commented out the whole cleanup and observed that in the whole code
below whenever needed (eg if classify is true) the elements subject to a
cleanup are just safely overwritten. Moreover, commenting out the cleanup 
fixes the problem in my humble opinion. 


  steve.l...@dnr.state.mn.us wrote:
 
 What does your layer definition look like? Probably stems from the fix
 put in
 place for ticket #2689 (http://trac.osgeo.org/mapserver/ticket/2689).
 That fix
 may need more work as I imagine the msLayerWhichItems() is clobbering
 the
 item setup done when the layer is opened.
 
 Hmmm, how to fix...
 
 Steve
 
  Jim Strevinas voas_...@hotmail.com 04/27/09 8:27 PM 
 
  Hello list, I recently migrated to 5.4. I observed the following
  inconsistency 
  and I would be grateful if someone can duplicate the problem too.
  In my (mapscript python) code i manually grab layer features using:
 
  layer.open()
  status = layer.whichShapes(map.extent)
  while (1):
 shape = layer.nextShape()
 if shape==None: 
  break
 print shape.numvalues
 
  The last print returns the number of non-spatial attributes. 
   In mapserver 5.2.1 it is returned correctly but in 5.4 is always 0
  just like all the non spatial values are all null. 



_
Invite your mail contacts to join your friends list with Windows Live Spaces. 
It's easy!
http://spaces.live.com/spacesapi.aspx?wx_action=createwx_url=/friends.aspxmkt=en-us___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


Re: [mapserver-users] How to link Oracle attributes to SHAPEFILE

2009-04-28 Thread pbg

Hi Roald.

Thanks for the reply.

In this project, we are required to use SHAPEFILES and Oracle, so we can't
change this environment.


Roald de Wit wrote:
 
 Hi Pedro,
 
 A number of years ago i had a situation like you describe below. The
 solution we chose was:
 - Create a postgresql/postgis datawarehouse
 - Import shapefiles into postgis (shp2psql or ogr2ogr)
 - Import attribute info from oracle into postgresql (we needed a
 commercial license for converting Oracle to Postgresql)
 - Either create a view or merge tables to join the geometry and
 attribute info
 - Serve the lot through MapServer WFS/WMS
 
 I hope this helps.
 
 Regards, Roald
 
 Pedro Briones García wrote:
 Hello.

 I’m working with *Oracle 10g* and *MapServer 5.2*. My geographic layers
 are SHAPEFILES and the attributes of SHAPEFILES are stored in Oracle 10g
 (*NOT* Oracle Spatial or Locator)

 I need to link (or join) SHAPEFILES with attribute (NOT spatial) tables
 to do 3 things:

 -Draw only elements of SHAPEFILE that are related with some
 records in Oracle. A record (polygon, for example) in the SHAPEFILE
 should only draw if is related with a record in Oracle (they both have a
 common column).
 -Make a thematic map wich classifications depending on the values
 of Oracle records.
 -Draw only elements of SHAPEFILE that meet an Oracle condition





 I have found lots of examples of layers wich both, geometry and
 attribtes, in Oracle; or layers in Oracle Spatial, but none of how to
 link and use a SHAPEFILE with Oracle (not spatial).





 I too would like to do the same of the aforementioned, but in this
 case with *DBF files* instead of Oracle tables. I have seen an example
 in the documentation, but I don’t know distinguish SHAPEFILES and the
 DBF files in the sentence.



 Please, could somebody send me an example to easily understand this?



 Thanks in advance.



 Pedro Briones García



 TRAGSATEC



 
 
 --
 Roald de Wit
 Software Engineer
 roald.de...@lisasoft.com
 
 Commercial Support for Open Source GIS Software
 http://lisasoft.com/LISAsoft/SupportedProducts/
 
 
 
 The contents of this email are confidential and may be subject to legal or
 professional privilege and copyright. No representation is made that this
 email is free of viruses or other defects. If you have received this
 communication in error, you may not copy or distribute any part of it or
 otherwise disclose its contents to anyone. Please advise the sender of
 your incorrect receipt of this correspondence.
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users
 
 

-- 
View this message in context: 
http://n2.nabble.com/How-to-link-Oracle-attributes-to-SHAPEFILE-tp2731838p2732398.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


Re: [mapserver-users] mapserver error

2009-04-28 Thread Iratxe Lejarreta
On Friday 24 April 2009 12:42:46 Pano wrote:
 Hi Iratxe,
 Unfortunately I know very little about CentOS. Just a windows guy me :-)
 But let me try:
 Is it possible that you have multiple Oracle Homes setup? And sqlplus is
 using the home where oracle server is installed whereas mapserver is using
 another (oracle client?) home which does not have the tnsnames setup
 correctly? In a windows setup i would first check the PATH environment
 variable. If the oracle client install is the first on the list then this
 is what mapserver would use. You mention a path
 /usr/lib/oracle/10.2.0.3/client- does this folder also contains a
 network\admin\tnsnames.ora file? Maybe this is the one you need to change
 (again maybe talking complete rubish here as on idea abt this OS)

 Finally- another idea just to make sure its not a WFS problem. Are you able
 to get an image by simply using cgi-bin e.g.
 http://localhost/cgi-bin/mapserve?map=...,mode=map etc??

 Pano

 Iratxe Lejarreta wrote:
  On Wednesday 22 April 2009 08:54:57 Pano wrote:
  Hi Iratxe,
 
  Looks like mapserver doesnt know the TNS name 'orcl' that you have
  defined.
  I assume that the machine where mapserver runs has an oracle client
  installed? Can you log into sql plus i..e sqlplus mddata/passwd@orcl
  from
  a command prompt on this box?  I assume you will get the same TNS error.
  Which will mean that your tnsnames.ora file is not set correctly. The
  file
  should be located under $ORACLE_HOME\network\admin\tnsnames.ora. There
  should be an entry in there like:
 
  ORCL =
(DESCRIPTION =
  (ADDRESS_LIST =
(ADDRESS =
  (PROTOCOL = TCP)
  (HOST = server_name_or_IP)
  (PORT = usually_1521)
)
  )
  (CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = oracle_service_name)
  )
)
 
  Hope this helps,
  Pano
 
  Iratxe Lejarreta wrote:
   Hi,
  
   I installed MapServer-5.2.0 on CentOS 5.2 with Oracle 10g, but when I
 
  run
 
   the
   WFS service...
  
   http://localhost/cgi-
   bin/mywfs?SERVICE=WFSVERSION=1.0.0REQUEST=getfeatureTYPENAME=cities
  
   ...the result is:
   −
   ServiceExceptionReport version=1.2.0
   xsi:schemaLocation=http://www.opengis.net/ogc
   http://schemas.opengis.net/wfs/1.0.0/OGC-exception.xsd;
   −
   ServiceException code=NoApplicableCode locator=mapserv
  
   msWFSGetFeature(): WFS server error. ms_error-code not found
   msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI
   Handlers.
   Connection failure. Check the connection string. Error: ORA-12154:
   TNS:could
   not resolve the connect identifier specified
   .
   msOracleSpatialLayerOpen(): OracleSpatial error. Cannot create OCI
   Handlers.
   Connection failure. Check the connection string. Error: ORA-12154:
   TNS:could
   not resolve the connect identifier specified
   .
  
   /ServiceException
   /ServiceExceptionReport
  
  
   Mapfile:
  
   MAP
NAME WFS_TEST
STATUS ON
SIZE 400 300
EXTENT -180 -90 180 90
UNITS METERS
IMAGECOLOR 255 255 255
   WEB
METADATA
wfs_title WFS TEST
wfs_onlineresourcehttp://localhost/cgi-bin/mywfs?;
wfs_srs   EPSG:4326
END
   END
   PROJECTION
init=epsg:4326
   END
   LAYER
NAME cities
TYPE POINT
CONNECTIONTYPE oraclespatial
CONNECTION MDDATA/**...@orcl
DATA GEOM FROM CITIES USING UNIQUE FID SRID 4326 VERSION 10g
METADATA
wfs_title cities
gml_featureid FID
gml_include_items all
END
STATUS ON
DUMP TRUE
CLASS
STYLE
OUTLINECOLOR 0 0 0
COLOR 0 128 128
END
END
   END # Cities
   END # Map File
  
  
   Somebody can help me?
  
   Thanks in advance.
  
   --
   Iratxe Lejarreta
   www.axios.es
  
   ___
   mapserver-users mailing list
   mapserver-users@lists.osgeo.org
   http://lists.osgeo.org/mailman/listinfo/mapserver-users
 
  Hi Pano,
 
  Firstly, thanks for your answer!
 
  I have checked all configuration but I continue with the same error:
 
  1.- I haven't got any error in logs.
 
  2.- I installed Oracle Instat Client:
  # rpm -Uvh oracle-instantclient-basic-10.2.0.4-1.i386.rpm
  I have set the library loading path:
  # export LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client/lib
 
  3.- I can access with sqlplus and sqldeveloper without any problem:
  [oracle]$ sqlplus mddata/passwd@orcl
 
  4.- $ORACLE_HOME\network\admin\tnsnames.ora file:
   ORCL =
 (DESCRIPTION =
   (ADDRESS_LIST =
 (ADDRESS =
   (PROTOCOL = TCP)
   (HOST = 192.168.2.215)
   (PORT = 1521)
 )
   )
   (CONNECT_DATA =
 (SERVER = DEDICATED)
 (SERVICE_NAME = orcl)
   )
 )
 
  5.- I try to access with the following URL:
  http://192.168.2.215/cgi-
  

[mapserver-users] Finding Lat-Long from shp file

2009-04-28 Thread Mukul Gupta
hi...
I want to know if there is any method to automatically get the lat long of
the particular point in the shape file and then store the corresponding
values in mysql database file.
Regards
Mukul
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


RE: [mapserver-users] Finding Lat-Long from shp file

2009-04-28 Thread Venkat Rao Tammineni
Hi,

 

mapObj will have  extents property ,where you can get  your map extents.

 

For example :- Alert(Map.extent.minx);

Thanks,

 

Venkat

 

 

From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Mukul Gupta
Sent: Tuesday, April 28, 2009 5:39 PM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] Finding Lat-Long from shp file

 

hi...
I want to know if there is any method to automatically get the lat long of
the particular point in the shape file and then store the corresponding
values in mysql database file.
Regards
Mukul

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


Re: [mapserver-users] How to link Oracle attributes to SHAPEFILE

2009-04-28 Thread Paolo Corti

 Hi Roald.

 Thanks for the reply.

 In this project, we are required to use SHAPEFILES and Oracle, so we can't
 change this environment.


 Roald de Wit wrote:

 Hi Pedro,

 A number of years ago i had a situation like you describe below. The
 solution we chose was:
 - Create a postgresql/postgis datawarehouse
 - Import shapefiles into postgis (shp2psql or ogr2ogr)
 - Import attribute info from oracle into postgresql (we needed a
 commercial license for converting Oracle to Postgresql)
 - Either create a view or merge tables to join the geometry and
 attribute info
 - Serve the lot through MapServer WFS/WMS

 I hope this helps.

 Regards, Roald


Pedro, the solution Roald is proposing is IMHO the closest one you
have to obtain what you need with MapServer (et alii).

according to this doc: http://mapserver.org/mapfile/join.html

supported formats are:
* DBF/XBase files
* CSV (comma delimited text file)
* PostgreSQL and PostGIS tables
* MySQL tables

So you have 5 options:
1. shapefile + dbf (exported from Oracle tables)
2. PostGIS
3. MySQL
4. Oracle Spatial
5. Oracle + ArcSde

in 2. and 3. no need to join, you could use views.
in 4 you need views.
with 5 there are many limits with joins, so could be the wrong way to go.

Note anyway that for what you need (join to make thematic map)
according to the above doc there is no way.
So the only solutions to go are 3, 4
I am not aware of other map web server software, neither OS or
commercial, able to make mixed (from different sources) join for
thematic mapping

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


RE: [mapserver-users] Inconsistency between 5.4 and 5.2.1concerningWhichShapes()?

2009-04-28 Thread Steve Lime
Stupid error on my part. I was worried about getting the right set of shapes out
and spaced the correct item list part. Ugh...

I'm not sure that removing the cleanup is the answer. Users could switch 
shapefile
sources between layer open/close or change items used to label or classify 
features
and you could leak memory. I'll look at that closer though.

I have this fixed in a sandbox for 6.0 where msLayerWhichItems() was totally 
re-written, so I just need a band-aid for 5.4. Will re-open #2689...

Steve

 Jim Strevinas voas_...@hotmail.com 04/28/09 3:05 AM 

Steve, you are absolutely right, according to #2689 i tried commenting
out the msLayerWhichItems (layer.i) prior to msLayerWhichShapes in
the 5.4 release. The item setup is thus maintained. 
While i'm afraid to mess with maplayer.c and maybe this will sound silly
,i observed that within maplayer.c in function msLayerWhichItems()
at line 402, a cleanup of the previous item selections is performed:

msLayerFreeItemInfo(layer);
if(layer-items) {
msFreeCharArray(layer-items, layer-numitems);
layer-items = NULL;
layer-numitems = 0;
}

I commented out the whole cleanup and observed that in the whole code
below whenever needed (eg if classify is true) the elements subject to a
cleanup are just safely overwritten. Moreover, commenting out the cleanup 
fixes the problem in my humble opinion. 


  steve.l...@dnr.state.mn.us wrote:
 
 What does your layer definition look like? Probably stems from the fix
 put in
 place for ticket #2689 (http://trac.osgeo.org/mapserver/ticket/2689).
 That fix
 may need more work as I imagine the msLayerWhichItems() is clobbering
 the
 item setup done when the layer is opened.
 
 Hmmm, how to fix...
 
 Steve
 
  Jim Strevinas voas_...@hotmail.com 04/27/09 8:27 PM 
 
  Hello list, I recently migrated to 5.4. I observed the following
  inconsistency 
  and I would be grateful if someone can duplicate the problem too.
  In my (mapscript python) code i manually grab layer features using:
 
  layer.open()
  status = layer.whichShapes(map.extent)
  while (1):
 shape = layer.nextShape()
 if shape==None: 
  break
 print shape.numvalues
 
  The last print returns the number of non-spatial attributes. 
   In mapserver 5.2.1 it is returned correctly but in 5.4 is always 0
  just like all the non spatial values are all null. 



_
Invite your mail contacts to join your friends list with Windows Live Spaces. 
It's easy!
http://spaces.live.com/spacesapi.aspx?wx_action=createwx_url=/friends.aspxmkt=en-us
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


[mapserver-users] PHP mapscript - QuerymapObj class

2009-04-28 Thread Worth Lutz
Is there any way to access the QuerymapObj from PHP mapscript?

 

I cannot find the reference to the object or a method to get to it in the
MapObj class.

 

Is the only way to change size or color in the mapfile if using PHP
mapscript?

 

 

Thanks in advance for your help,

 

Worth Lutz

 

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


Re: [mapserver-users] How to link Oracle attributes to SHAPEFILE

2009-04-28 Thread Luigi Castro Cardeles
Hi list,

hum, could he use ogr vrt?
http://www.gdal.org/ogr/drv_vrt.html

Luigi Castro Cardeles


2009/4/28 Paolo Corti pco...@gmail.com

 
  Hi Roald.
 
  Thanks for the reply.
 
  In this project, we are required to use SHAPEFILES and Oracle, so we
 can't
  change this environment.
 
 
  Roald de Wit wrote:
 
  Hi Pedro,
 
  A number of years ago i had a situation like you describe below. The
  solution we chose was:
  - Create a postgresql/postgis datawarehouse
  - Import shapefiles into postgis (shp2psql or ogr2ogr)
  - Import attribute info from oracle into postgresql (we needed a
  commercial license for converting Oracle to Postgresql)
  - Either create a view or merge tables to join the geometry and
  attribute info
  - Serve the lot through MapServer WFS/WMS
 
  I hope this helps.
 
  Regards, Roald
 

 Pedro, the solution Roald is proposing is IMHO the closest one you
 have to obtain what you need with MapServer (et alii).

 according to this doc: http://mapserver.org/mapfile/join.html

 supported formats are:
* DBF/XBase files
* CSV (comma delimited text file)
* PostgreSQL and PostGIS tables
* MySQL tables

 So you have 5 options:
 1. shapefile + dbf (exported from Oracle tables)
 2. PostGIS
 3. MySQL
 4. Oracle Spatial
 5. Oracle + ArcSde

 in 2. and 3. no need to join, you could use views.
 in 4 you need views.
 with 5 there are many limits with joins, so could be the wrong way to go.

 Note anyway that for what you need (join to make thematic map)
 according to the above doc there is no way.
 So the only solutions to go are 3, 4
 I am not aware of other map web server software, neither OS or
 commercial, able to make mixed (from different sources) join for
 thematic mapping

 best regards
 Paolo
 ___
 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] DescribeFeatureType

2009-04-28 Thread Iratxe Lejarreta
Hi,

I have MapServer with Oracle Spatial and when I run the request 
DescribeFeatureType, the result of types for all fiels is string.

http://localhost/cgi-
bin/mywfs?SERVICE=WFSVERSION=1.0.0REQUEST=DescribeFeatureTypeTYPENAME=layer_name

Is it possible to know the type of different fields of the layer as described 
in 
my database?

Thanks  in advance!

-- 
Iratxe Lejarreta
www.axios.es
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


Re: [mapserver-users] PHP mapscript - QuerymapObj class

2009-04-28 Thread Yewondwossen Assefa

Worth Lutz wrote:

Is there any way to access the QuerymapObj from PHP mapscript?

 

I cannot find the reference to the object or a method to get to it in 
the MapObj class.


 It should be accessible from the map object: 
http://mapserver.org/mapscript/php/index.html#querymapobj-class
 

Is the only way to change size or color in the mapfile if using PHP 
mapscript?


 

 


Thanks in advance for your help,

 


Worth Lutz

 





___
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


Re: [mapserver-users] DescribeFeatureType

2009-04-28 Thread bartvde
Hi,

sorry but Mapserver does not support this (yet).

Best regards,
Bart

 Hi,

 I have MapServer with Oracle Spatial and when I run the request
 DescribeFeatureType, the result of types for all fiels is string.

 http://localhost/cgi-
 bin/mywfs?SERVICE=WFSVERSION=1.0.0REQUEST=DescribeFeatureTypeTYPENAME=layer_name

 Is it possible to know the type of different fields of the layer as
 described in
 my database?

 Thanks  in advance!

 --
 Iratxe Lejarreta
 www.axios.es
 ___
 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 - QuerymapObj class

2009-04-28 Thread Worth Lutz
Yes, I saw the page you referenced.  That was what prompted my question.

If you look in the documentation for the map object there is no reference to
the querymapobj-class.  In other words there is no member which points to
the querymapobj and no method to get the object.

The reference map objects are gotten by a member pointing to the object and
the layer and class objects are gotten by a method.  I was looking for a
similar member or method to get the querymapobj.

Have I overlooked something?


Thanks, 
Worth

-Original Message-
From: Yewondwossen Assefa [mailto:yass...@dmsolutions.ca] 
Sent: Tuesday, April 28, 2009 9:31 AM
To: Worth Lutz
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] PHP mapscript - QuerymapObj class

Worth Lutz wrote:
 Is there any way to access the QuerymapObj from PHP mapscript?
 
  
 
 I cannot find the reference to the object or a method to get to it in 
 the MapObj class.
 
  It should be accessible from the map object: 
http://mapserver.org/mapscript/php/index.html#querymapobj-class
  
 
 Is the only way to change size or color in the mapfile if using PHP 
 mapscript?
 
  
 
  
 
 Thanks in advance for your help,
 
  
 
 Worth Lutz
 
  
 
 
 
 
 ___
 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


Re: [mapserver-users] PHP mapscript - QuerymapObj class

2009-04-28 Thread Yewondwossen Assefa

The member should be $oMap-querymap.
I will update the doc to reflect that.


Worth Lutz wrote:

Yes, I saw the page you referenced.  That was what prompted my question.

If you look in the documentation for the map object there is no reference to
the querymapobj-class.  In other words there is no member which points to
the querymapobj and no method to get the object.




The reference map objects are gotten by a member pointing to the object and
the layer and class objects are gotten by a method.  I was looking for a
similar member or method to get the querymapobj.

Have I overlooked something?


Thanks, 
Worth


-Original Message-
From: Yewondwossen Assefa [mailto:yass...@dmsolutions.ca] 
Sent: Tuesday, April 28, 2009 9:31 AM

To: Worth Lutz
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] PHP mapscript - QuerymapObj class

Worth Lutz wrote:

Is there any way to access the QuerymapObj from PHP mapscript?

 

I cannot find the reference to the object or a method to get to it in 
the MapObj class.


  It should be accessible from the map object: 
http://mapserver.org/mapscript/php/index.html#querymapobj-class
 

Is the only way to change size or color in the mapfile if using PHP 
mapscript?


 

 


Thanks in advance for your help,

 


Worth Lutz

 





___
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


RE: [mapserver-users] DescribeFeatureType

2009-04-28 Thread Kralidis,Tom [Ontario]

FYI there is an open ticket on this at
http://trac.osgeo.org/mapserver/ticket/462

..Tom
 

 -Original Message-
 From: mapserver-users-boun...@lists.osgeo.org 
 [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of 
 bart...@osgis.nl
 Sent: Tuesday, 28 April 2009 09:37
 To: Iratxe Lejarreta
 Cc: mapserver-users@lists.osgeo.org
 Subject: Re: [mapserver-users] DescribeFeatureType
 
 Hi,
 
 sorry but Mapserver does not support this (yet).
 
 Best regards,
 Bart
 
  Hi,
 
  I have MapServer with Oracle Spatial and when I run the request 
  DescribeFeatureType, the result of types for all fiels is 
 string.
 
  http://localhost/cgi-
  
 bin/mywfs?SERVICE=WFSVERSION=1.0.0REQUEST=DescribeFeatureTypeTYPENA
  ME=layer_name
 
  Is it possible to know the type of different fields of the layer as 
  described in my database?
 
  Thanks  in advance!
 
  --
  Iratxe Lejarreta
  www.axios.es
  ___
  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] DescribeFeatureType

2009-04-28 Thread Steve Lime
To clarify, the support is not automatic. The developer of the service
has the ability to define types in the service configuration but it must
be done by hand.

Steve

 bart...@osgis.nl 04/28/09 8:37 AM 
Hi,

sorry but Mapserver does not support this (yet).

Best regards,
Bart

 Hi,

 I have MapServer with Oracle Spatial and when I run the request
 DescribeFeatureType, the result of types for all fiels is string.

 http://localhost/cgi-
 bin/mywfs?SERVICE=WFSVERSION=1.0.0REQUEST=DescribeFeatureTypeTYPENAME=layer_name

 Is it possible to know the type of different fields of the layer as
 described in
 my database?

 Thanks  in advance!

 --
 Iratxe Lejarreta
 www.axios.es
 ___
 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] total values from a shapefile?

2009-04-28 Thread Mark Volz
Hello,

 

Can map server combine two fields and display a total for the values, or do
we need to total the values ahead of time in the shapefile?

 

Mark Volz

GIS Specialist

Lyon County, MN

 

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


Re: [mapserver-users] total values from a shapefile?

2009-04-28 Thread Steve Lime
Depends, are you talking about for labeling, expression evaluation or template 
display?

For labeling: No.

For expression evaluation: Yes (using logical expressions you can do EXPRESSION 
([item1] + [item2]  50)

For templates: Yes for HTML via javascript, e.g.:

script ...
  var total = [item1] + [item2];
  document.write(total);
/script

Steve

 On 4/28/2009 at 11:26 AM, in message
3d56274b4a7874468f58faddbfd09801073a3...@llmhs02.r8nssis.local, Mark Volz
markv...@co.lyon.mn.us wrote:
 Hello,
 
  
 
 Can map server combine two fields and display a total for the values, or do
 we need to total the values ahead of time in the shapefile?
 
  
 
 Mark Volz
 
 GIS Specialist
 
 Lyon County, MN
 
  

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


Re: [mapserver-users] total values from a shapefile?

2009-04-28 Thread Jeff McKenna

Mark Volz wrote:
Can map server combine two fields and display a total for the values, or 
do we need to total the values ahead of time in the shapefile?



Hi Mark,

Not that I'm aware of.  Even if it could, I would always pre-process the 
data, so MapServer doesn't have to execute those extra functions 
on-the-fly, and therefore speed up my application.


-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


[mapserver-users] Outline on the roads label boxes

2009-04-28 Thread Nelson Correia

 

Hi,

 

Do you know how to write an outline on the roads label boxes, just like the 
ones that Google Maps has? In Mapserver docs I only see an outline for the 
letters and not for the background. Does Mapserver support it?

 

You can see the labels (L2150, K2, K7) with white background and black outline 
at:

 

http://maps.google.com/maps?ie=UTF8ll=50.764911,10.953197spn=0.038979,0.11158z=14

 

Thanks,

 

Nelson

_
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


RE: [mapserver-users] total values from a shapefile?

2009-04-28 Thread Mark Volz
Steve,

Thank you for your reply.  I will be using it for templates.

Mark Volz
GIS Specialist
Lyon County, MN
-Original Message-
From: Steve Lime [mailto:steve.l...@dnr.state.mn.us] 
Sent: Tuesday, April 28, 2009 11:40 AM
To: Mark Volz; mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] total values from a shapefile?

Depends, are you talking about for labeling, expression evaluation or
template display?

For labeling: No.

For expression evaluation: Yes (using logical expressions you can do
EXPRESSION ([item1] + [item2]  50)

For templates: Yes for HTML via javascript, e.g.:

script ...
  var total = [item1] + [item2];
  document.write(total);
/script

Steve

 On 4/28/2009 at 11:26 AM, in message
3d56274b4a7874468f58faddbfd09801073a3...@llmhs02.r8nssis.local, Mark Volz
markv...@co.lyon.mn.us wrote:
 Hello,
 
  
 
 Can map server combine two fields and display a total for the values, or do
 we need to total the values ahead of time in the shapefile?
 
  
 
 Mark Volz
 
 GIS Specialist
 
 Lyon County, MN
 
  

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


Re: [mapserver-users] C# connectiontype issue

2009-04-28 Thread Frank Warmerdam
I have a raster layer in map file. When I load the map file using C# map 
script, at run time it shows layerObj.connectiontype as 
‘MS_CONNECTION_TYPE.MS_SHAPEFILE’ though it is raster image. Is there 
any syntax error with my map file definition.  I need to know exactly 
whether it is a raster or vector layer in my application. Some logic in 
my application needs to handle them differently.


 


This is the entry in map file

 


  LAYER

DATA 14m_jpg_24bit.jpg

NAME  14m Jpg 24bit

STATUS ON

TYPE RASTER

UNITS METERS

  END


Murty,

I believe the connectiontype value is left to the default for raster
layers, which happens to be MS_SHAPEFILE.  The connectiontype does not
really apply for layers of type RASTER.

I think to distingish layer types properly you will need to examine both
the TYPE and CONNECTIONTYPE fields.

Best regards,
--
---+--
I set the clouds in motion - turn up   | Frank Warmerdam, warmer...@pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush| Geospatial Programmer for Rent

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


Re: [mapserver-users] Outline on the roads label boxes

2009-04-28 Thread Thomas Bonfort
this isn't currently possible.

best regards,
thomas

On Tue, Apr 28, 2009 at 6:50 PM, Nelson Correia nelson...@hotmail.com wrote:

 Hi,

 Do you know how to write an outline on the roads label boxes, just like the
 ones that Google Maps has? In Mapserver docs I only see an outline for the
 letters and not for the background. Does Mapserver support it?

 You can see the labels (L2150, K2, K7) with white background and black
 outline at:

 http://maps.google.com/maps?ie=UTF8ll=50.764911,10.953197spn=0.038979,0.11158z=14

 Thanks,

 Nelson

 
 Get news, entertainment and everything you care about at Live.com. Check it
 out!
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users





-- 
www.camptocamp.com
+33 4 79 26 57 97
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


Re: [mapserver-users] Automatically Clearing Old Map Images

2009-04-28 Thread jchampagne2

Thank you! I did a little research, and writing a .bat file to execute as a
scheduled task
is exactly what I needed. The file is simple:

@echo off
cd C:\OSGeo4W\tmp\ms_tmp
del *.png
cls
echo Your MapServer cache has been cleared!
echo.
pause nul

Saved as 'clearCache.bat' and added it as a scheduled task through Windows
System Tools. I added the message just for diagnostic purposes, but I'll
probably delete it once I'm sure this will work. 


Gregor at HostGIS wrote:
 
 
 Yeah, typical cronjob approaches. I can't say for Windows, but for Linux 
 systems you'd create a /etc/cron.hourly file that goes something like 
 one of these, depending on your version of find:
 
 find /maps/images.tmp -mindepth 1 -ctime +1 -exec rm -f {} \;
 
 find /maps/images.tmp -mindepth 1 -ctime +1 -delete
 
 

-- 
View this message in context: 
http://n2.nabble.com/Automatically-Clearing-Old-Map-Images-tp2699631p2734870.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


Re: [mapserver-users] Outline on the roads label boxes

2009-04-28 Thread Christy Nieman

Hi,

You can use an annotation layer with a symbol.  Something like:

LAYER
 NAME labels
 TYPE ANNOTATION
 DATA /your/data/path/
 STATUS ON
 LABELITEM RD_NUM

 CLASS
   NAME road_numbers
   STYLE
 SYMBOL 'rectangle'
 COLOR 255 255 255
 OUTLINECOLOR 0 0 0
 SIZE 16
   END
   LABEL
 TYPE TRUETYPE
 ANTIALIAS TRUE
 FONT myfont
 SIZE 8
 POSITION CC
 COLOR  0 0 0
 PARTIALS FALSE
   END
 END
END

and the symbol would be something like:
SYMBOL
 NAME 'rectangle'
 TYPE VECTOR
 POINTS
   0 0
   0 14
   25 14
   25 0
   0 0
 END
 FILLED TRUE
END

Regards,
--
Christy Nieman
GIS Technician
DM Solutions Group, Inc.
Email: cnie...@dmsolutions.ca
Web: http://dmsolutions.ca
Web: http://research.dmsolutions.ca

Nelson Correia wrote:
 
Hi,
 
Do you know how to write an outline on the roads label boxes, just 
like the ones that Google Maps has? In Mapserver docs I only see an 
outline for the letters and not for the background. Does Mapserver 
support it?
 
You can see the labels (L2150, K2, K7) with white background and black 
outline at:
 
http://maps.google.com/maps?ie=UTF8ll=50.764911,10.953197spn=0.038979,0.11158z=14 
http://maps.google.com/maps?ie=UTF8ll=50.764911,10.953197spn=0.038979,0.11158z=14
 
Thanks,
 
Nelson



Get news, entertainment and everything you care about at Live.com. 
Check it out! http://www.live.com/getstarted.aspx%20



___
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] RE: Finding Lat-Long from shp file

2009-04-28 Thread Mohammed Rashad
Hi,

Here is the way you can find lat-long values from shp files. The method is
ugly.
I used this method to select lat-long values from a shape file consisting of
about 150 records. Using this method all lat-long values from a shapefile
consisting of place names of country can be selected and saved into files.
I already told method is dirty.

You can find using postgreSQL. first you should install postgis-postgresql
package.
and follow instructions in postgis manual.
you want to import some files after installing postgis such as lwpostgis.sql
etc...

I think you added necessary attributes in shape files such as name of place
etc,..

create a database in postgresql with postgis enabled (say db1)
Now import .shp files into postgresql using cmd:

you should have a database db1 with postgis support.
shp2pgsql /root/vect1.shp vect1 db1  /root/vect1.sql

now you got vect1.sql file

import sql file into postgresql.
psql -d db1 -f /root/vect1.sql

Now logon to postgresql admin tool such as phppgadmin or you can do these
thing from postgresql interactive terminal.

In the database db1 now you have another table name vect1.
vect1 has some other attributes such as gid,the_geom etc..  other than
attributes you have entered.   'the_geom' is the geometry of shape file.

select X(the_geom) from vect1; query executes to display longitude all
entries in shape files

and

select Y(the_geom) from vect1; query executes to display latitude all
entries in shape files


this data can also be inserted into table by inserting a new column for
latitude and longitude.

If you want table back to shp files using the cmd:
pgsql2shp -f vect1 -p 5432 db1 vect1

Or

You can also export column  latitude and longtiude into mysql also as you
wish


-- 
Regards,
Mohammed Rashad K.M
http://keralainfo.web4all.in/
+919605476742
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


Re: [mapserver-users] Outline on the roads label boxes

2009-04-28 Thread Steve Lime
You can however, develop separate classes based on label length. You'd have 
different
symbols to handle wide text vs. narrow. For example:

LABELITEM 'myitem'
CLASS
  EXPRESSION (length('[myitem]')  5) # use a really wide shield
  STYLE
SYMBOL 'reallywideshield'
 ...
  END
END
CLASS
  EXPRESSION (length('[myitem]')  3) # use a wide marker
  STYLE
SYMBOL 'wideshield'
 ...
  END
END
CLASS # default to a regular shield
  STYLE
SYMBOL 'shield'
 ...
  END
END

Steve

 On 4/28/2009 at 12:10 PM, in message
2922382e0904281010i47fadd9ds51346665bd481...@mail.gmail.com, Thomas Bonfort
thomas.bonf...@camptocamp.com wrote:
 this isn't currently possible.
 
 best regards,
 thomas
 
 On Tue, Apr 28, 2009 at 6:50 PM, Nelson Correia nelson...@hotmail.com wrote:

 Hi,

 Do you know how to write an outline on the roads label boxes, just like the
 ones that Google Maps has? In Mapserver docs I only see an outline for the
 letters and not for the background. Does Mapserver support it?

 You can see the labels (L2150, K2, K7) with white background and black
 outline at:

 
 http://maps.google.com/maps?ie=UTF8ll=50.764911,10.953197spn=0.038979,0.11158
  
 z=14

 Thanks,

 Nelson

 
 Get news, entertainment and everything you care about at Live.com. Check it
 out!
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org 
 http://lists.osgeo.org/mailman/listinfo/mapserver-users 


 
 
 
 -- 
 www.camptocamp.com 
 +33 4 79 26 57 97
 ___
 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] Outline on the roads label boxes

2009-04-28 Thread Thomas Bonfort
The label background is getting quite cluttered actually, we have
backgroundcolor, backgroundshadowcolor, backgroundshadowsize, and
maybe a couple of others I'm forgetting.

maybe we could add something equivalent to backgroundstyle that would
have the same syntax as a class STYLE, that would then be passed on as
a normal style to msDrawShadeSymbol, along with the shapeobj
corresponding to the background shade.

we'd then have all the goodness of mapserver styles: outlines,
symbols, opacity, etc...

just a thought,

thomas

On Tue, Apr 28, 2009 at 7:23 PM, Steve Lime steve.l...@dnr.state.mn.us wrote:
 You can however, develop separate classes based on label length. You'd have 
 different
 symbols to handle wide text vs. narrow. For example:

 LABELITEM 'myitem'
 CLASS
  EXPRESSION (length('[myitem]')  5) # use a really wide shield
  STYLE
    SYMBOL 'reallywideshield'
     ...
  END
 END
 CLASS
  EXPRESSION (length('[myitem]')  3) # use a wide marker
  STYLE
    SYMBOL 'wideshield'
     ...
  END
 END
 CLASS # default to a regular shield
  STYLE
    SYMBOL 'shield'
     ...
  END
 END

 Steve

 On 4/28/2009 at 12:10 PM, in message
 2922382e0904281010i47fadd9ds51346665bd481...@mail.gmail.com, Thomas Bonfort
 thomas.bonf...@camptocamp.com wrote:
 this isn't currently possible.

 best regards,
 thomas

 On Tue, Apr 28, 2009 at 6:50 PM, Nelson Correia nelson...@hotmail.com 
 wrote:

 Hi,

 Do you know how to write an outline on the roads label boxes, just like the
 ones that Google Maps has? In Mapserver docs I only see an outline for the
 letters and not for the background. Does Mapserver support it?

 You can see the labels (L2150, K2, K7) with white background and black
 outline at:


 http://maps.google.com/maps?ie=UTF8ll=50.764911,10.953197spn=0.038979,0.11158
 z=14

 Thanks,

 Nelson

 
 Get news, entertainment and everything you care about at Live.com. Check it
 out!
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users





 --
 www.camptocamp.com
 +33 4 79 26 57 97
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users





-- 
www.camptocamp.com
+33 4 79 26 57 97
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


RE: [mapserver-users] RE: Finding Lat-Long from shp file

2009-04-28 Thread Fawcett, David
You could also write a fairly simple python script using the gdal/ogr
python modules.

-Original Message-
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Mohammed
Rashad
Sent: Tuesday, April 28, 2009 12:17 PM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] RE: Finding Lat-Long from shp file


Hi,

Here is the way you can find lat-long values from shp files. The
method is ugly.
I used this method to select lat-long values from a shape file
consisting of about 150 records. Using this method all lat-long values
from a shapefile consisting of place names of country can be selected
and saved into files.
I already told method is dirty.

You can find using postgreSQL. first you should install
postgis-postgresql package.
and follow instructions in postgis manual. 
you want to import some files after installing postgis such as
lwpostgis.sql etc...

I think you added necessary attributes in shape files such as
name of place etc,..

create a database in postgresql with postgis enabled (say db1)
Now import .shp files into postgresql using cmd:

you should have a database db1 with postgis support.
shp2pgsql /root/vect1.shp vect1 db1  /root/vect1.sql 

now you got vect1.sql file

import sql file into postgresql.
psql -d db1 -f /root/vect1.sql

Now logon to postgresql admin tool such as phppgadmin or you can
do these thing from postgresql interactive terminal.

In the database db1 now you have another table name vect1.
vect1 has some other attributes such as gid,the_geom etc..
other than attributes you have entered.   'the_geom' is the geometry of
shape file.

select X(the_geom) from vect1; query executes to display
longitude all entries in shape files 

and

select Y(the_geom) from vect1; query executes to display
latitude all entries in shape files


this data can also be inserted into table by inserting a new
column for latitude and longitude.

If you want table back to shp files using the cmd:
pgsql2shp -f vect1 -p 5432 db1 vect1

Or 

You can also export column  latitude and longtiude into mysql
also as you wish


-- 
Regards,
Mohammed Rashad K.M
http://keralainfo.web4all.in/
+919605476742


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


Re: [mapserver-users] Automatically Clearing Old Map Images

2009-04-28 Thread Gregor at HostGIS

jchampagne2 wrote:

Thank you! I did a little research, and writing a .bat file to execute as a
scheduled task is exactly what I needed


Cool.


del *.png


Just for future planning, you may want to add *.jpg and *.gif to it. 
Otherwise, three years from now when you're also generating JPEGs you'll 
wonder why your disk has filled up.


--
HostGIS, Open Source solutions for the global GIS community
Greg Allensworth - SysAdmin, Programmer, GIS Person, Security
Network+   Server+   A+   Security+
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


[mapserver-users] avl files

2009-04-28 Thread Paul Alarcon

Hello forum does anyone know if there is a way to export the avl files from
arcview to map files? 
thanks a lot 
Paul
-- 
View this message in context: 
http://n2.nabble.com/avl-files-tp2735327p2735327.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


RE: [mapserver-users] Outline on the roads label boxes

2009-04-28 Thread Nelson Correia


I've done it with several rectangle symbols.

 

Thank you all for the quick answers! :)

 

Nelson 

 
 Date: Tue, 28 Apr 2009 19:33:01 +0200
 Subject: Re: [mapserver-users] Outline on the roads label boxes
 From: thomas.bonf...@camptocamp.com
 To: steve.l...@dnr.state.mn.us
 CC: nelson...@hotmail.com; mapserver-users@lists.osgeo.org
 
 The label background is getting quite cluttered actually, we have
 backgroundcolor, backgroundshadowcolor, backgroundshadowsize, and
 maybe a couple of others I'm forgetting.
 
 maybe we could add something equivalent to backgroundstyle that would
 have the same syntax as a class STYLE, that would then be passed on as
 a normal style to msDrawShadeSymbol, along with the shapeobj
 corresponding to the background shade.
 
 we'd then have all the goodness of mapserver styles: outlines,
 symbols, opacity, etc...
 
 just a thought,
 
 thomas
 
 On Tue, Apr 28, 2009 at 7:23 PM, Steve Lime steve.l...@dnr.state.mn.us 
 wrote:
  You can however, develop separate classes based on label length. You'd have 
  different
  symbols to handle wide text vs. narrow. For example:
 
  LABELITEM 'myitem'
  CLASS
   EXPRESSION (length('[myitem]')  5) # use a really wide shield
   STYLE
 SYMBOL 'reallywideshield'
  ...
   END
  END
  CLASS
   EXPRESSION (length('[myitem]')  3) # use a wide marker
   STYLE
 SYMBOL 'wideshield'
  ...
   END
  END
  CLASS # default to a regular shield
   STYLE
 SYMBOL 'shield'
  ...
   END
  END
 
  Steve
 
  On 4/28/2009 at 12:10 PM, in message
  2922382e0904281010i47fadd9ds51346665bd481...@mail.gmail.com, Thomas 
  Bonfort
  thomas.bonf...@camptocamp.com wrote:
  this isn't currently possible.
 
  best regards,
  thomas
 
  On Tue, Apr 28, 2009 at 6:50 PM, Nelson Correia nelson...@hotmail.com 
  wrote:
 
  Hi,
 
  Do you know how to write an outline on the roads label boxes, just like 
  the
  ones that Google Maps has? In Mapserver docs I only see an outline for the
  letters and not for the background. Does Mapserver support it?
 
  You can see the labels (L2150, K2, K7) with white background and black
  outline at:
 
 
  http://maps.google.com/maps?ie=UTF8ll=50.764911,10.953197spn=0.038979,0.11158
  z=14
 
  Thanks,
 
  Nelson
 
  
  Get news, entertainment and everything you care about at Live.com. Check 
  it
  out!
  ___
  mapserver-users mailing list
  mapserver-users@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
 
 
 
 
 
  --
  www.camptocamp.com
  +33 4 79 26 57 97
  ___
  mapserver-users mailing list
  mapserver-users@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/mapserver-users
 
 
 
 
 
 -- 
 www.camptocamp.com
 +33 4 79 26 57 97

_
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


Re: [mapserver-users] avl files

2009-04-28 Thread Bart van den Eijnden (OSGIS)

Hi,

you can try Avein:

http://sourceforge.net/projects/avein/

Best regards,
Bart

Paul Alarcon wrote:

Hello forum does anyone know if there is a way to export the avl files from
arcview to map files? 
thanks a lot 
Paul
  



--
Bart van den Eijnden
OSGIS, Open Source GIS
bart...@osgis.nl
http://www.osgis.nl

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


Re: [mapserver-users] avl files

2009-04-28 Thread Paul Alarcon

Thanks a lot Bart im going to try it and thanks for the quickly reply :-D

___




-- 
View this message in context: 
http://n2.nabble.com/avl-files-tp2735327p2736480.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


Re: [mapserver-users] avl files

2009-04-28 Thread Paul Alarcon

Helllo is me again, i tried it but it ask me for a installed mapserver on
windows and i use a linux server for mapserver, there is another software
for make it for linux server ?
___






-- 
View this message in context: 
http://n2.nabble.com/avl-files-tp2735327p2736762.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] Mapfile HDF 'DATA' element format

2009-04-28 Thread Peter Willis

Hello,

Where can I find the specification for the
'DATA' entry in mapserver MAP files where
HDF files are being used?

I am mostly interested in using these in
the context of WCS.

Here is my current non-working example of an HDF
file test in my current WCS map file:

LAYER
  NAME chlorophyll
  METADATA
wcs_label   L3MG8D9KM/Chlorophyll
wcs_rangeset_name   Range 1
wcs_rangeset_label  Chlorophyll_DN
  END
  TYPE RASTER
  STATUS ON
  DATA 'HDF4:/public/A20081932008200.L3m_8D_CHLO_9.hdf://l3m_data'
  PROCESSING   BANDS=1
  PROJECTION
init=epsg:4326
  END
  DUMP TRUE
END


I am not sure I have the format of the DATA entity correct.

Thanks for any pointers,

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


Re: [mapserver-users] Mapfile HDF 'DATA' element format

2009-04-28 Thread Frank Warmerdam

Peter Willis wrote:

Hello,

Where can I find the specification for the
'DATA' entry in mapserver MAP files where
HDF files are being used?

I am mostly interested in using these in
the context of WCS.

Here is my current non-working example of an HDF
file test in my current WCS map file:

...

  DATA 'HDF4:/public/A20081932008200.L3m_8D_CHLO_9.hdf://l3m_data'


Peter,

You need to use the gdalinfo command on the .hdf base file to get
a list of subdatasets within the file.  If the gdalinfo reports something
like:


SUBDATASET_16_NAME=HDF4_EOS:EOS_SWATH:MOD07_L2.A2000110.0220.002.2000196104217.hdf:mod07:Retrieved_Moisture_Profile
  SUBDATASET_16_DESC=[20x406x270] Retrieved_Moisture_Profile mod07 (16-bit 
integer)

SUBDATASET_17_NAME=HDF4_EOS:EOS_SWATH:MOD07_L2.A2000110.0220.002.2000196104217.hdf:mod07:Retrieved_Height_Profile
  SUBDATASET_17_DESC=[20x406x270] Retrieved_Height_Profile mod07 (16-bit 
integer)

Then you might put the following in your .map file:

  DATA 
'HDF4_EOS:EOS_SWATH:MOD07_L2.A2000110.0220.002.2000196104217.hdf:mod07:Retrieved_Moisture_Profile'



The key is to use _NAME portion of the subdatasets reported by gdalinfo.

Best regards,
--
---+--
I set the clouds in motion - turn up   | Frank Warmerdam, warmer...@pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush| Geospatial Programmer for Rent

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


Re: [mapserver-users] Mapfile HDF 'DATA' element format

2009-04-28 Thread Peter Willis

Frank Warmerdam wrote:

Peter Willis wrote:

Hello,

Where can I find the specification for the
'DATA' entry in mapserver MAP files where
HDF files are being used?

I am mostly interested in using these in
the context of WCS.

Here is my current non-working example of an HDF
file test in my current WCS map file:

...

  DATA 'HDF4:/public/A20081932008200.L3m_8D_CHLO_9.hdf://l3m_data'


Peter,

You need to use the gdalinfo command on the .hdf base file to get
a list of subdatasets within the file.  If the gdalinfo reports something
like:


SUBDATASET_16_NAME=HDF4_EOS:EOS_SWATH:MOD07_L2.A2000110.0220.002.2000196104217.hdf:mod07:Retrieved_Moisture_Profile 

  SUBDATASET_16_DESC=[20x406x270] Retrieved_Moisture_Profile mod07 
(16-bit integer)
SUBDATASET_17_NAME=HDF4_EOS:EOS_SWATH:MOD07_L2.A2000110.0220.002.2000196104217.hdf:mod07:Retrieved_Height_Profile 

  SUBDATASET_17_DESC=[20x406x270] Retrieved_Height_Profile mod07 (16-bit 
integer)


Then you might put the following in your .map file:

  DATA 
'HDF4_EOS:EOS_SWATH:MOD07_L2.A2000110.0220.002.2000196104217.hdf:mod07:Retrieved_Moisture_Profile' 




The key is to use _NAME portion of the subdatasets reported by gdalinfo.

Best regards,


Hello Frank,

I don't get any of those entries when I run gdalinfo against the file.
There is one SDS in the root of the HDF file called 'l3m_data'.

Here is an example of what I get with gdalinfo:

 some_yo...@linux-svn:/public# gdalinfo A20081932008200.L3m_8D_CHLO_9.hdf

 Driver: HDF4Image/HDF4 Dataset
 Size is 4320, 2160
 Coordinate System is `'
 Metadata:
   Product Name=A20081932008200.L3m_8D_CHLO_9
   Sensor Name=MODISA
   Sensor=
   Title=MODISA Level-3 Standard Mapped Image
   Data Center=
   Station Name=
   Station Latitude=0
   Station Longitude=0
   Mission=
   Mission Characteristics=
   Sensor Characteristics=
   Product Type=8-day
   Replacement Flag=ORIGINAL
   Software Name=smigen
   Software Version=3.60
   Processing Time=200821020255
   Input Files=A20081932008200.L3b_8D.main
   Processing Control=smigen par=A20081932008200.L3m_8D_CHLO_9.param
   Input Parameters=IFILE = 
/data1/sdpsoper/vdc/vpu4/workbuf/A20081932008200.L3b_8D.main|OFILE = 
A20081932008200.L3m_8D_CHLO_9|PFILE = |PROD = chlor_a|PALFILE = 
DEFAULT|RFLAG = ORIGINAL|MEAS = 1|STYPE = 0|DATAMIN = 0.00|DATAMAX = 
0.00|LONWEST = -180.00|LONEAST = 180.00|LATSOUTH = 
-90.00|LATNORTH = 90.00|RESOLUTION = 9km|PROJECTION = 
RECT|GAP_FILL = 0|SEAM_LON = -180.00|PRECISION=I
   L2 Flag 
Names=ATMFAIL,LAND,HILT,HISATZEN,STRAYLIGHT,CLDICE,COCCOLITH,LOWLW,CHLFAIL,PRODFAIL,CHLWARN,NAVWARN,MAXAERITER,ATMWARN,HISOLZEN,NAVFAIL,FILTER,HIGLINT

   Period Start Year=2008
   Period Start Day=193
   Period End Year=2008
   Period End Day=200
   Start Time=200819307727
   End Time=2008201023506024
   Start Year=2008
   Start Day=193
   Start Millisec=7727
   End Year=2008
   End Day=201
   End Millisec=9306024
   Start Orbit=0
   End Orbit=0
   Orbit=0
   Map Projection=Equidistant Cylindrical
   Latitude Units=degrees North
   Longitude Units=degrees East
   Northernmost Latitude=90
   Southernmost Latitude=-90
   Westernmost Longitude=-180
   Easternmost Longitude=180
   Latitude Step=0.0834
   Longitude Step=0.0834
   SW Point Latitude=-89.95834
   SW Point Longitude=-179.9583
   Data Bins=7128918
   Number of Lines=2160
   Number of Columns=4320
   Parameter=Chlorophyll a concentration
   Measure=Mean
   Units=mg m^-3
   Scaling=logarithmic
   Scaling Equation=Base**((Slope*l3m_data) + Intercept) = Parameter value
   Base=10
   Slope=5.813776e-05
   Intercept=-2
   Scaled Data Minimum=0.01
   Scaled Data Maximum=64.5654
   Data Minimum=0.005747
   Data Maximum=99.93153
   Scaling=logarithmic
   Scaling Equation=Base**((Slope*l3m_data) + Intercept) = Parameter value
   Base=10
   Slope=5.813776e-05
   Intercept=-2
 Corner Coordinates:
 Upper Left  (0.0,0.0)
 Lower Left  (0.0, 2160.0)
 Upper Right ( 4320.0,0.0)
 Lower Right ( 4320.0, 2160.0)
 Center  ( 2160.0, 1080.0)
 Band 1 Block=4320x1 Type=UInt16, ColorInterp=Gray

 some_yo...@linux-svn:/public#
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users


Re: [mapserver-users] Mapfile HDF 'DATA' element format

2009-04-28 Thread Frank Warmerdam

Peter Willis wrote:

Hello Frank,

I don't get any of those entries when I run gdalinfo against the file.
There is one SDS in the root of the HDF file called 'l3m_data'.

Here is an example of what I get with gdalinfo:

...

Peter,

Then the file appears to be a simple SDS dataset, and you don't need to do
anything special.  Just put the name of the file in the DATA statement.

The more complex syntaxes are only needed when one hdf file contains
many products.

Best regards,
--
---+--
I set the clouds in motion - turn up   | Frank Warmerdam, warmer...@pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush| Geospatial Programmer for Rent

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


Re: [mapserver-users] avl files

2009-04-28 Thread percy
give it fake directories as if you are using MS4W, then edit the mapfile 
it generates and substitute your linux paths...

percy

On 4/28/2009 1:43 PM, Paul Alarcon wrote:

Helllo is me again, i tried it but it ask me for a installed mapserver on
windows and i use a linux server for mapserver, there is another software
for make it for linux server ?
___

--
David Percy
Geospatial Data Manager
Geology Department
Portland State University
http://gisgeek.pdx.edu
503-725-3373
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users