Re: [mapserver-users] Still cannot display postGIS layers using ms4w(MapServer 5.0.2 on WinXP).
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
.map file'. Standard ways of specifiying are : (1)
'geometry_column from
geometry_table' (2) 'geometry_column from (sub
query) as foo using unique
column name using SRID=srid#' Make sure you put in
the 'using unique
column name' and 'using SRID=#' clauses
in. For more help, please see
http://postgis.refractions.net/documentation/
Mappostgis.c - version of
Jan 23/2004.
My second attempt:
==
I tried adding USING UNIQUE to my DATA line. There is
something odd with
my spatial
[MAPSERVER-USERS] mapserver does not show oracle layer
Hi,
i´m having troubles shwoing a oracle layer in mapserver.
in open layers i´ve:
map = new OpenLayers.Map( 'map' ,
{
scales: [ 400,300,200,100, 50,20,
10, 5,2,1 ],
maxExtent: new OpenLayers.Bounds(-18,34,4,45),
numZoomLevels: 10
}
);
var basemap = new OpenLayers.Layer.WMS.Untiled( MS 4.10,
http://172.18.210.67:8080/cgi-bin/mapserv.exe?;,
{
map: '/ms4w/apps/wmssrvrefer/config.map',
layers: 'border', format: 'png', 'transparent': 'on'},
{ projection:EPSG:4326 } );
map.addLayers([basemap]);
map.setCenter(new OpenLayers.LonLat(-8, 39.5), 0);
In mapfile:
EXTENT -9 36 -6 42
projection
init=epsg:4326
end
web
IMAGEPATH /ms4w/tmp/ms_tmp/
IMAGEURL /ms_tmp/
metadata
wms_title test
wms_srs EPSG:4326
end
end
## this show the layer !
layer
name major_roads_small_4
group border
type line
projection
init=epsg:4326
end
status on
data railways.shp
class
style
color 0 0 0
width 1
antialias true
end
end
end
##
this layer does not show !!
#
layer
name road_a
group border
type line
projection
init=epsg:4326
end
connectiontype oraclespatial
connection uui/pwdmydb
data geom_73 from caop_regiao using srid 4326
class
style
color 185 175 155
width 3
antialias true
end
end
end
I test with shp2img and it shows the shapelayer, but not the oracle layer.
http://www.nabble.com/file/p18847632/test.png
What´s wrong ?
--
View this message in context:
http://www.nabble.com/mapserver-does-not-show-oracle-layer-tp18847632p18847632.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 does not show oracle layer
What do you get if you use shp2img with debug info?
shp2img -all_debug 10
Best regards,
Bart
Hi,
i´m having troubles shwoing a oracle layer in mapserver.
in open layers i´ve:
map = new OpenLayers.Map( 'map' ,
{
scales: [ 400,300,200,100, 50,20,
10, 5,2,1 ],
maxExtent: new OpenLayers.Bounds(-18,34,4,45),
numZoomLevels: 10
}
);
var basemap = new OpenLayers.Layer.WMS.Untiled( MS 4.10,
http://172.18.210.67:8080/cgi-bin/mapserv.exe?;,
{
map: '/ms4w/apps/wmssrvrefer/config.map',
layers: 'border', format: 'png', 'transparent': 'on'},
{ projection:EPSG:4326 } );
map.addLayers([basemap]);
map.setCenter(new OpenLayers.LonLat(-8, 39.5), 0);
In mapfile:
EXTENT -9 36 -6 42
projection
init=epsg:4326
end
web
IMAGEPATH /ms4w/tmp/ms_tmp/
IMAGEURL /ms_tmp/
metadata
wms_title test
wms_srs EPSG:4326
end
end
## this show the layer !
layer
name major_roads_small_4
group border
type line
projection
init=epsg:4326
end
status on
data railways.shp
class
style
color 0 0 0
width 1
antialias true
end
end
end
##
this layer does not show !!
#
layer
name road_a
group border
type line
projection
init=epsg:4326
end
connectiontype oraclespatial
connection uui/pwdmydb
data geom_73 from caop_regiao using srid 4326
class
style
color 185 175 155
width 3
antialias true
end
end
end
I test with shp2img and it shows the shapelayer, but not the oracle layer.
http://www.nabble.com/file/p18847632/test.png
What´s wrong ?
--
View this message in context:
http://www.nabble.com/mapserver-does-not-show-oracle-layer-tp18847632p18847632.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] Displaying the shape files using the map server
Hi, Which programming language you are using .let me know. Thanks and regards Venkat. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of krishna mohan Sent: Wednesday, August 06, 2008 4:17 PM To: mapserver-users@lists.osgeo.org Subject: [MAPSERVER-USERS] Displaying the shape files using the map server Hi, I am very new to map server. I have installed map server and want to display the shape files using map server on internet explorer. I also have a post gis database from which I would like to display. Can some one please help me how to do that. Krishna Mohan -- View this message in context: http://www.nabble.com/Displaying-the-shape-files-using-the-map-server-tp1884 8672p18848672.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] Displaying the shape files using the map server
Hi, This is PHP with mapserver. Please have look once. http://mapserver.gis.umn.edu/docs/howto/phpmapscript-byexample Thanks and Regards Venkat -Original Message- From: Krishna Mohan [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 06, 2008 4:24 PM To: 'Venkat Rao Tammineni'; mapserver-users@lists.osgeo.org Subject: RE: [MAPSERVER-USERS] Displaying the shape files using the map server Hi, Thanks for the quick reply. I am not using any programming language. I just want to display the shape file on a web browser using the mapserver. Is it possible, Krishna Mohan -Original Message- From: Venkat Rao Tammineni [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 06, 2008 4:25 PM To: 'krishna mohan'; mapserver-users@lists.osgeo.org Subject: RE: [MAPSERVER-USERS] Displaying the shape files using the map server Hi, Which programming language you are using .let me know. Thanks and regards Venkat. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of krishna mohan Sent: Wednesday, August 06, 2008 4:17 PM To: mapserver-users@lists.osgeo.org Subject: [MAPSERVER-USERS] Displaying the shape files using the map server Hi, I am very new to map server. I have installed map server and want to display the shape files using map server on internet explorer. I also have a post gis database from which I would like to display. Can some one please help me how to do that. Krishna Mohan -- View this message in context: http://www.nabble.com/Displaying-the-shape-files-using-the-map-server-tp1884 8672p18848672.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] mapserver does not show oracle layer
Are you certain that you have Oracle client installed and MapServer compile against it? Timothy J Nolte - [EMAIL PROTECTED] Network Planning Engineer iPCS Wireless, Inc. 4717 Broadmoor Ave, Suite G Kentwood, MI 49512 Office: 616-656-5163 PCS:616-706-2438 Fax:616-554-6484 Web: www.ipcswirelessinc.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of FCampos Sent: Wednesday, August 06, 2008 5:58 AM To: mapserver-users@lists.osgeo.org Subject: Re: [MAPSERVER-USERS] mapserver does not show oracle layer That´s strange because does not appear nothing about oracle layer. C:\ms4w\apps\wmssrvrefershp2img -m config.map -o test.png -all_debug 10 msLoadMap(): 0.031s msDrawMap(): Layer 0 (major_roads_small_4), 0.000s msDrawMap(): Drawing Label Cache, 0.000s msDrawMap() total time: 0.015s msSaveImage() total time: 0.047s msFreeMap(): freeing map at 0148B288. shp2img total time: 0.109s but the connection is good because i see in the log apache, when i make a wms request. it does not give any oracle error [Wed Aug 06 10:57:18 2008] [error] [client 172.18.202.178] msDrawMap(): Layer 1 (road_a), 0.938s\r, referer: http://127.0.0.1/justtests/maps/openlayes/ -- View this message in context: http://www.nabble.com/mapserver-does-not-show-oracle-layer-tp1 8847632p18847865.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] mapserver does not show oracle layer
Yes. Mapserver, I´ve got: MapServer version 5.2.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=PDF OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICO NV SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIE NT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUP PORTS=GEOS SUPPORTS=RGBA_PNG INPUT=JPEG INPUT=POSTGIS INPUT=ORACLESPATIAL INPUT= OGR INPUT=GDAL INPUT=SHAPEFILE Oracle: instantclient 11.1 with a tnsnames.ora definition. If i put a bad sql, it gives a oci error, so it´s compiled. msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error parsing OracleSpatial DATA variable. Must be:'geometry_column FROM table_name [USING UNIQUE column SRID srid# FUNCTION]' or ... -- View this message in context: http://www.nabble.com/mapserver-does-not-show-oracle-layer-tp18847632p18849791.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] GPS to GIS
Hi, I have a table of GPS-coordinates that I want to use as POI. I've tried to find an algoritm to convert GPS-coordinates to GIS-coordinates but without luck. It would be a great help if anyone could tell me how to do this translation. Thanks! Regards Peter Falk ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [MAPSERVER-USERS] Mapserver bug when generating a tiled map with MapFish
Isn't there anyone to help me with this ? 2008/8/4 Faldor [EMAIL PROTECTED] Hi all, I use Mapserver with mapfish for the client side to display shapefiles which I generated using ogr2ogr. The problem is when I try to display a tiled layer (mapfish singleTile property set to 'false'). Some tiles are generated by mapserver entirely blank ! After a few researches I think it is due to the fact that those tiles are extended across the -180°/+180° line. For exemple, here is the imgext property from one of the calls to MapServer which render a blank tile : imgext=178.59375+-1.40625+271.40625+91.40625 Do you know of a way to fix this ? Regards, Pierre-Benoît -- View this message in context: http://www.nabble.com/Mapserver-bug-when-generating-a-tiled-map-with-MapFish-tp18813432p18813432.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] mapserver does not show oracle layer
Well, I have no problems. I'm running the same version of MapServer 5.2, however I think I'm only running IC 10.2. What I have in my map file is; LAYER GROUP Switch Boundaries NAME Kentwood TYPE POLYGON STATUS OFF CONNECTIONTYPE oraclespatial CONNECTION username/[EMAIL PROTECTED] PROCESSING CLOSE_CONNECTION=DEFER DATA geom FROM (SELECT swt.switch_descr, sgt.geom FROM ms_switch_vw swt, switch_geom_tab sgt WHERE swt.switch_id = sgt.switch_id AND swt.switch_id = 5) USING SRID 8307 LABELITEM switch_descr METADATA static_legend 1 END DUMP true TRANSPARENCY 100 CLASS MINSCALE 520 MAXSCALE 4100 STYLE SYMBOL circle OUTLINECOLOR 80 80 80 SIZE 1 END END CLASS MINSCALE 0 MAXSCALE 520 STYLE SYMBOL circle OUTLINECOLOR 80 80 80 SIZE 2 END END END I have many layers like this that work without a problem. Timothy J Nolte - [EMAIL PROTECTED] Network Planning Engineer iPCS Wireless, Inc. 4717 Broadmoor Ave, Suite G Kentwood, MI 49512 Office: 616-656-5163 PCS:616-706-2438 Fax:616-554-6484 Web: www.ipcswirelessinc.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of FCampos Sent: Wednesday, August 06, 2008 8:10 AM To: mapserver-users@lists.osgeo.org Subject: RE: [MAPSERVER-USERS] mapserver does not show oracle layer Yes. Mapserver, I´ve got: MapServer version 5.2.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=PDF OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICO NV SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIE NT SUPPORTS=WCS_SERVER SUPPORTS=SOS_SERVER SUPPORTS=FASTCGI SUPPORTS=THREADS SUP PORTS=GEOS SUPPORTS=RGBA_PNG INPUT=JPEG INPUT=POSTGIS INPUT=ORACLESPATIAL INPUT= OGR INPUT=GDAL INPUT=SHAPEFILE Oracle: instantclient 11.1 with a tnsnames.ora definition. If i put a bad sql, it gives a oci error, so it´s compiled. msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error parsing OracleSpatial DATA variable. Must be:'geometry_column FROM table_name [USING UNIQUE column SRID srid# FUNCTION]' or ... -- View this message in context: http://www.nabble.com/mapserver-does-not-show-oracle-layer-tp1 8847632p18849791.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] mapserver+postgres
Hi All, I'm new to mapserver, and tried out some examples (itasca, gmap, p.mapper, openlayers). I want to build a mapping application, where I can query points on mouseclick, that are located in a postgres/postGis Database. So far the examples I tried out only deal with shapefiles. Do you have an example for me to start out for? regards___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
re: [MAPSERVER-USERS] mapserver does not show oracle layer
Hi there, With my oracle spatial layers I use connection uui/[EMAIL PROTECTED], where the dbname is setup on your server using the oracle clients 'Net Manager'. Hope this helps, Josh Hevenor ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [MAPSERVER-USERS] mapserver does not show oracle layer
hi, how do you check the rigth srid in the oracle ? -- View this message in context: http://www.nabble.com/mapserver-does-not-show-oracle-layer-tp18847632p18850449.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: re: [MAPSERVER-USERS] mapserver does not show oracle layer
yes, that what i do ! Josh Hevenor-2 wrote: Hi there, With my oracle spatial layers I use connection uui/[EMAIL PROTECTED], where the dbname is setup on your server using the oracle clients 'Net Manager'. Hope this helps, Josh Hevenor ___ 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/mapserver-does-not-show-oracle-layer-tp18847632p18850640.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] GPS to GIS
I've used GPSBabel (http://www.gpsbabel.org) to download data from my GPS and get them into more usable formats. It can also convert between formats. I'm not sure what you mean by converting between GPS and GIS coordinates. If you have a delimited table of coordinates you should be able to import it into a GIS to create, for example, a shapefile. Subject: [mapserver-users] GPS to GIS From: Peter Falk [EMAIL PROTECTED] Date: Wed, 06 Aug 2008 14:22:00 +0200 To: mapserver-users@lists.osgeo.org To: mapserver-users@lists.osgeo.org Hi, I have a table of GPS-coordinates that I want to use as POI. I've tried to find an algoritm to convert GPS-coordinates to GIS-coordinates but without luck. It would be a great help if anyone could tell me how to do this translation. Thanks! Regards Peter Falk ___ 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] msDrawRaster(): Image handling error with sles /opensuse
Okay, I did a mapserv -v at the command line and it returned the following supported inputs: INPUT=TIFF INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE Typing gdalinfo --formats at the command line returns: GTiff (rw+): GeoTIFF amongst many other supported formats. So it should work, but it doesn't. Any ideas? Thanks John W. On 06/08/2008 at 12:57, in message [EMAIL PROTECTED], John Westwood [EMAIL PROTECTED] wrote: Hi, I have successfully compiled MapServer 5.2 on both Debian Etch and SUSE = Linux Enterprise Server (SLES) 10 SP2 . Everything works fine on Debian, = but on SUSE I receive the following error when trying to display any = raster based layers: msDrawMap(): Image handling error. Failed to draw layer named '..'.; = msDrawRaster(): Image handling error. Unrecognized or unsupported image = format; drawEPP(): Image handling error. EPPL7 support is not available. I realise that the EPPL7 reference in the error message is a red herring. = My raster layers are in geotiff format and the output format is png. = Vector layers render fine as pngs. I am using MapServer as a WMS server. I = compiled with agg, gd and gdal. I don't understand why it's not working! = Please help! Many thanks, John W. Great Britain Historical GIS Project. ___ 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).
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] GPS to GIS
I think that the way that you phrased your questions was a little confusing. 'GPS coordinates' and 'GIS coordinates' are really the same thing. It sounds more like you want to convert the format that the coordinates are stored in from the one used by your GPS to one that works in a GIS or with MapServer. I hacked up a python function to read .gpx files. I will send it to you off-list. You could then use it in conjunction with the OGR python module to write a shape file. David. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Falk Sent: Wednesday, August 06, 2008 8:58 AM To: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] GPS to GIS Thanks for your reply. My intension was to convert CPS-coords to GIS-coords on the fly and for that purpose I needed a piece of scripting (an algorithm). But if GPSBabel can convert data between these formats, I'll go for that. Christy Nieman skrev: I've used GPSBabel (http://www.gpsbabel.org) to download data from my GPS and get them into more usable formats. It can also convert between formats. I'm not sure what you mean by converting between GPS and GIS coordinates. If you have a delimited table of coordinates you should be able to import it into a GIS to create, for example, a shapefile. - --- Subject: [mapserver-users] GPS to GIS From: Peter Falk [EMAIL PROTECTED] Date: Wed, 06 Aug 2008 14:22:00 +0200 To: mapserver-users@lists.osgeo.org To: mapserver-users@lists.osgeo.org Hi, I have a table of GPS-coordinates that I want to use as POI. I've tried to find an algoritm to convert GPS-coordinates to GIS-coordinates but without luck. It would be a great help if anyone could tell me how to do this translation. Thanks! Regards Peter Falk - --- ___ 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 -- Med venlig hilsen Peter Falk Nexus Kommunikation Østre Messegade 2 2650 Hvidovre 36 77 00 46 www.nexus.dk ___ 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 bug when generating a tiled map with MapFish
Unfortunately there is no connection to internet on the platform I develop on. All is done localy. I will try to be more precise. I am trying to display a shapefile representing the whole world (it's a shapefile from Global Insight plus if it helps). I use mapfish without 'singleTile: true' so the layer is generated by tiles. There is no problem in the beggining when the map is zoomed to max extent. The problem occurs when I begin zooming in and trying to display America/Asia. One of the colums of tiles is drawn across the -180°/+180° longitude line, and those tiles are generated entirely blank (white, not even transparent). When I get the properties of the image (right-click on the blank tile - Properties) and I search in the Location of the image I can find : mapext=179.296875+44.296875+*225.703125* +90.703125imgext=179.296875+44.296875+*225.703125*+90.703125 So I guess the problem comes from that, MapServer doesn't recognise longitude greater than 180 or lower than -180. If I'm right I would appreciate any hint on how to handle this... Otherwise it may be a mapfish issue, maybe mapfish should always generate tiles with borders right on -180 / +180. This is the case at the beggining, lef tile has mapext=90+0+180+90 and right tile has mapext=-180+0+-90+90. But whenever I begin zooming in it goes awry, the border of tiles is no longer right on -180/+180 and some tiles are generated white by MapServer. If someone needs more informations I'm ready to give it. Best regards, PB 2008/8/6 Eric Lemoine [EMAIL PROTECTED] On Wed, Aug 6, 2008 at 2:28 PM, Pierre-Benoit Besse [EMAIL PROTECTED] wrote: Isn't there anyone to help me with this ? 2008/8/4 Faldor [EMAIL PROTECTED] Hi all, I use Mapserver with mapfish for the client side to display shapefiles which I generated using ogr2ogr. The problem is when I try to display a tiled layer (mapfish singleTile property set to 'false'). Some tiles are generated by mapserver entirely blank ! After a few researches I think it is due to the fact that those tiles are extended across the -180°/+180° line. For exemple, here is the imgext property from one of the calls to MapServer which render a blank tile : imgext=178.59375+-1.40625+271.40625+91.40625 Do you know of a way to fix this ? This is not enough information for anyone to help you. Could you provide a link or a web page to help people see what's going on? -- Eric ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] Network / UNC access problems
On further review with the IT department, it turns out our IIS server wasn't set up quite as expected. The anonymous web user had access to .html and .txt files, but not other file types, and only through http paths (not UNC). If it's of any interest, I was able to use some resources in mapserver by specifying the full http:// path to the file. This worked for the template, and DrawRaster seems like it would have worked if not for an unrelated problem, but DrawSHP wanted to append the http path onto the local web directory path. Once IT got the permissions sorted out, everything works. Thanks to the people who responded with suggestions. -Gabe -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Emerson, Gabe Sent: Friday, August 01, 2008 9:19 AM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] Network / UNC access problems Hello everyone, Once again I have an issue that's apparently been solved before, but doesn't work for me. Hopefully this is an ability that Mapserver still retains. I'm trying to access network resources (in an IIS environment) from mapserver. The IT people have set up the web server with a domain account, and given it access to the relevant network drives (it's Intranet only, inside our firewall). They've also set up some virtual folders pointing to the network locations, and put those into the mapserver directory. The web server has no problem accessing the files, I can browse to the data through it (as in domain.com/aeimagery/minr2c2.ecw. However, Mapserver's CGI isn't able to access the data. I've tried using the standard UNC path: DATA \\server\aeimagery\minr2c2.ecw I've also tried using the local shortcuts that IT set up, as in: DATA ../AEImagery/MINr2c2.ecw And as the full web server path: DATA D:/inetpub/gis/AEImagery/MINr2c2 I've tried /, \, all lowercase, etc. I've also confirmed that local copies of the aerials and shapefiles work. For aerials I simply get nothing to appear. For shapefiles I get the usual: msDrawMap(): Image handling error. Failed to draw layer named 'Metro_Area'. msSHPOpenFile(): Unable to access file. (\\server\data\research\esri\county) msSHPOpenFile(): Unable to access file. (\\server\data\research\esri\county) Since I'm not in control of the server config, I can't guarantee that everything in IIS is set up correctly. IT tells me that the webserver process is a domain user, and they've seen the prior mailing list posts on this topic. Since I can access the virtual folders that point at the network resources, I assume the server and its processes have the proper access. At this point I'm stumped as to what else is necessary, or what else I can ask IT to test for. Any suggestions would be appreciated! -Gabe Emerson ___ 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: Labeling
From your example I can see that your ANGLE parameter is in the wrong object it should be in the label object to rotate the text. As is you should be throwing parsing errors. the item storing the angle need not be numeric although the values must represent numbers upon conversion. Steve Jay Kapalczynski [EMAIL PROTECTED] 08/06/08 2:15 AM What I am trying to do is use annotation from a Geodatabase. From what I hear GeoMoose / Map Server will not read it. I converted the Annotation Feature Class to a Point. Then created a Polygon from the Annotation Feature Classes, pointing to the Point Feature class for the Attributes (label field, degree field) I then read the Polygons into GeoMoose and label on the field and Angle the text by Angle' Field. The ANGLE call to Map Server dosent seem to work in this case Any thoughts? From: Jay Kapalczynski Sent: Tuesday, August 05, 2008 2:48 PM To: 'mapserver-users@lists.osgeo.org' Subject: Labeling Don't know if I have to correct location. I have been successful labeling street centerlines using the ANGLE FOLLOW in the .map File This is being performed on a Shapefile Line feature I also have a Polygon Feature that has a field that I am trying to labelonce again I need the text to follow the polygon As you can see from the image the road names a following properly, but the labels for the polygons are not following... I tried the ANGLE FOLLOW on the Polygon and It will not draw.. I tried ANGLE [Angle] with Angle being a field name that holds Degree values (ex 270) does the field have to be numeric? Is there some other syntax that I have to put in the map file that will force the text to follow the Polygon? THANKS STREET MAP FILE LAYER # Maple Grove Streets Name NAME Streets_Labels DATA './GEOCODED_CENTERLINES2.shp' STATUS DEFAULT TYPE annotation MAXSCALE 6000 MINSCALE 100 LABELITEM 'STREET_NAM' LABELCACHE ON CLASS COLOR -1 -1 -1 LABEL TYPE TRUETYPE FONT vera_sans ANGLE FOLLOW POSITION AUTO MAXSIZE 10 SIZE 8 MINSIZE 8 ANTIALIAS TRUE COLOR 0 0 0 OUTLINECOLOR 255 255 192 BUFFER 2 END END END # Maple Grove Streets Name PARCELS MAP FILE THAT DOES NOT WORK LAYER # Maple Grove Parcels NAME Parcel_Labels DATA './parcels.shp' STATUS DEFAULT TYPE annotation MAXSCALE 2500 MINSCALE 100 LABELITEM 'TextString' ANGLE [Angle] POSITION AUTO PARTIALS FALSE LABELCACHE ON CLASS COLOR -1 -1 -1 LABEL TYPE TRUETYPE FONT vera_sans MAXSIZE 8 SIZE 8 MINSIZE 2 #ANTIALIAS TRUE COLOR 0 0 0 OUTLINECOLOR 255 255 128 BUFFER 2 END END END # Maple Grove Parcels ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] RE: Labeling
That was itmoved the lines inside the LABEL CLASS Credit due to the GeoMoose Forum...(Dan) But I do thank you all for your help...it is very appreciated. Especially for Green coders like myself... Thanks again Steve for your response CLASS LABEL PUT LINES HERE END END -Original Message- From: Steve Lime [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 06, 2008 9:42 AM To: Jay Kapalczynski; mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] RE: Labeling From your example I can see that your ANGLE parameter is in the wrong object it should be in the label object to rotate the text. As is you should be throwing parsing errors. the item storing the angle need not be numeric although the values must represent numbers upon conversion. Steve Jay Kapalczynski [EMAIL PROTECTED] 08/06/08 2:15 AM What I am trying to do is use annotation from a Geodatabase. From what I hear GeoMoose / Map Server will not read it. I converted the Annotation Feature Class to a Point. Then created a Polygon from the Annotation Feature Classes, pointing to the Point Feature class for the Attributes (label field, degree field) I then read the Polygons into GeoMoose and label on the field and Angle the text by Angle' Field. The ANGLE call to Map Server dosent seem to work in this case Any thoughts? From: Jay Kapalczynski Sent: Tuesday, August 05, 2008 2:48 PM To: 'mapserver-users@lists.osgeo.org' Subject: Labeling Don't know if I have to correct location. I have been successful labeling street centerlines using the ANGLE FOLLOW in the .map File This is being performed on a Shapefile Line feature I also have a Polygon Feature that has a field that I am trying to labelonce again I need the text to follow the polygon As you can see from the image the road names a following properly, but the labels for the polygons are not following... I tried the ANGLE FOLLOW on the Polygon and It will not draw.. I tried ANGLE [Angle] with Angle being a field name that holds Degree values (ex 270) does the field have to be numeric? Is there some other syntax that I have to put in the map file that will force the text to follow the Polygon? THANKS STREET MAP FILE LAYER # Maple Grove Streets Name NAME Streets_Labels DATA './GEOCODED_CENTERLINES2.shp' STATUS DEFAULT TYPE annotation MAXSCALE 6000 MINSCALE 100 LABELITEM 'STREET_NAM' LABELCACHE ON CLASS COLOR -1 -1 -1 LABEL TYPE TRUETYPE FONT vera_sans ANGLE FOLLOW POSITION AUTO MAXSIZE 10 SIZE 8 MINSIZE 8 ANTIALIAS TRUE COLOR 0 0 0 OUTLINECOLOR 255 255 192 BUFFER 2 END END END # Maple Grove Streets Name PARCELS MAP FILE THAT DOES NOT WORK LAYER # Maple Grove Parcels NAME Parcel_Labels DATA './parcels.shp' STATUS DEFAULT TYPE annotation MAXSCALE 2500 MINSCALE 100 LABELITEM 'TextString' ANGLE [Angle] POSITION AUTO PARTIALS FALSE LABELCACHE ON CLASS COLOR -1 -1 -1 LABEL TYPE TRUETYPE FONT vera_sans MAXSIZE 8 SIZE 8 MINSIZE 2 #ANTIALIAS TRUE COLOR 0 0 0 OUTLINECOLOR 255 255 128 BUFFER 2 END END END # Maple Grove Parcels ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [MAPSERVER-USERS] Road Lines with AGG
Still looking for a solution :( -Ritesh Nolte, Tim wrote: When you are using AGG for your output do not use antialias true on your layers. - Tim Timothy J Nolte - [EMAIL PROTECTED] Network Planning Engineer iPCS Wireless, Inc. 4717 Broadmoor Ave, Suite G Kentwood, MI 49512 Office: 616-656-5163 PCS:616-706-2438 Fax:616-554-6484 Web: www.ipcswirelessinc.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ritesh Ambastha Sent: Tuesday, August 05, 2008 6:53 AM To: mapserver-users@lists.osgeo.org Subject: [MAPSERVER-USERS] Road Lines with AGG http://www.nabble.com/file/p18828729/road.png In the map file, I have defined the imagetype and outputformat as: IMAGETYPE AGG OUTPUTFORMAT NAME 'AGG' DRIVER AGG/PNG IMAGEMODE RGB END My line layers are written with antialias as true. How can I correct the lines with more smoothness while keeping the same sharpness? Thanks, Ritesh Ambastha -- View this message in context: http://www.nabble.com/Road-Lines-with-AGG-tp18828729p18828729.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/Road-Lines-with-AGG-tp18828729p18853113.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 does not show oracle layer
i export the layer to shape and , and made ogrinfo and i´ve got: Geometry: Line String Feature Count: 5801 Extent: (-113613.582981, -286361.190557) - (108654.660386, 258019.490810) Layer SRS WKT: (unknown) What´s the Layer SRS WKT: (unknown) -- View this message in context: http://www.nabble.com/mapserver-does-not-show-oracle-layer-tp18847632p18853796.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] msDrawRaster(): Image handling error with sles /opensuse
John, My suggestion would be to carefully review the paths you are using, and the permissions of the server. You may find it helpful to test from the commandline to isolate cgi permissions issues, and so that you can see immediate debugging information. Best regards, John Westwood wrote: Okay, I did a mapserv -v at the command line and it returned the following supported inputs: INPUT=TIFF INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE Typing gdalinfo --formats at the command line returns: GTiff (rw+): GeoTIFF amongst many other supported formats. So it should work, but it doesn't. Any ideas? Thanks John W. On 06/08/2008 at 12:57, in message [EMAIL PROTECTED], John Westwood [EMAIL PROTECTED] wrote: Hi, I have successfully compiled MapServer 5.2 on both Debian Etch and SUSE = Linux Enterprise Server (SLES) 10 SP2 . Everything works fine on Debian, = but on SUSE I receive the following error when trying to display any = raster based layers: msDrawMap(): Image handling error. Failed to draw layer named '..'.; = msDrawRaster(): Image handling error. Unrecognized or unsupported image = format; drawEPP(): Image handling error. EPPL7 support is not available. I realise that the EPPL7 reference in the error message is a red herring. = My raster layers are in geotiff format and the output format is png. = Vector layers render fine as pngs. I am using MapServer as a WMS server. I = compiled with agg, gd and gdal. I don't understand why it's not working! = Please help! Many thanks, John W. Great Britain Historical GIS Project. ___ 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 -- ---+-- I set the clouds in motion - turn up | Frank Warmerdam, [EMAIL PROTECTED] light and sound - activate the windows | http://pobox.com/~warmerdam and watch the world go round - Rush| President OSGeo, http://osgeo.org ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] MapServer Version 5.2.0 Source Released
On Aug 6, 2008, at 10:51 AM, William Kyngesburye wrote: On Jul 20, 2008, at 3:30 PM, William Kyngesburye wrote: My OSX build is finally ready (lots of distractions this week). I added a couple things: - instructions for compiling other mapscripts that are not included in the installer. are now included took me a while to notice ;) Scratch that, misread my own writing. Where's my coffee!? - William Kyngesburye kyngchaos*at*kyngchaos*dot*com http://www.kyngchaos.com/ I ache, therefore I am. Or in my case - I am, therefore I ache. - Marvin ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[MAPSERVER-USERS] Layer SRS WKT: (unknown)
I´ve got a shape that in ogrinfo gives me: Layer SRS WKT: (unknown) What can i do to put this shape ok ? -- View this message in context: http://www.nabble.com/Layer-SRS-WKT%3A-%28unknown%29-tp18854439p18854439.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] Shp file creation
I used shapelib and particulary the shpcreate tool to create an empty shape file and then shpadd to add entriew in it. But in this way i will have to enter all data manually! Is there any other way to generate it with a more automated way? Aldo,theese tools don't produce the required .dbf file. Only .shp and .shx files appear. ---BeginMessage--- O/H Atul Dravid έγραψε: Have you tried going through shapelib documentation ? Regards, Atul Dravid -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ? ?apad Sent: Monday, August 04, 2008 11:37 PM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] Shp file creation. Hello to everyone. I want to ask about something that i have asked before but i could not find a solution. I have measured coordinates of some points in a city and i want to render them with mapserver. I have created a csv file with these values.. LONGITUTE,LATITUDE,DESCRIPTION,ADDRESS 22.561867,39.215857,Φοιτητική Λέσχη,null 22.57267,39.212835,Πανεπιστήμιο Θεσσαλιας,Κτήριο Παπαστράτος.,argonautwn 22.57070,39.212690,Caf?-Bar Drops.,argonautwn 22.565973,39.212715,Flocafe,argonautwn 22.565865,39.212754,Reef,argonautwn 22.565830,39.212776,Jam,argonautwn ........ ........ ........ Then i use a program found here ( http://www.softpedia.com/get/Programming/Other-Programming-Files/CSV-to-Shap efile-Converter.shtml ) to create the .shp, .shx and .dbf files. But as i said before i can get no points on the map. I have some other point data and they work just fine. So i guess the problem isn't in the map file but in the data. Can anyone find the problem? Thank you all for your time! Nikos Papadakis. Univercity of Thessaly. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users I used shapelib and particulary the shpcreate tool to create an empty shape file and then shpadd to add entriew in it. But in this way i will have to enter all data manually! Is there any other way to generate it with a more automated way? Aldo,theese tools don't produce the required .dbf file. Only .shp and .shx files appear. ---End Message--- ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [MAPSERVER-USERS] Layer SRS WKT: (unknown)
FCampos wrote: I´ve got a shape that in ogrinfo gives me: Layer SRS WKT: (unknown) What can i do to put this shape ok ? FCampos, First, MapServer does not normally use the coordinate system information from shapefiles (or any other format). Instead you are normally expected to redefine the coordinate system in the .map file using a PROJECTION block. So I doubt you really need to do anything to the shapefile. However, if you do want to, for some reason, the coordinate system definition is just an ascii .prj file associated with the shapefile with a normal ESRI projection engine string (roughly like OGC Well Known Text). Just copy from some other source. If you have more specific needs I can provide more details. Best regards, -- ---+-- I set the clouds in motion - turn up | Frank Warmerdam, [EMAIL PROTECTED] light and sound - activate the windows | http://pobox.com/~warmerdam and watch the world go round - Rush| President OSGeo, http://osgeo.org ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] SLD parameter not cascaded (v5.2)
Can someone verify that SLD parameters are not supposed to be passed on to a cascaded service. For example, I am requesting a cascaded layer with an SLD parameter as follows: ...SLD=http://somerul/8321daf4-fb37-44d8-876b-d7860c4eda14.xmlRULE=DefaultStyle... ...the SLD does not get applied. On the other hand if I request the layer using the SLD parameter directly to the service (i.e. not through the cascading service) the SLD gets applied. Thanks again, _ Joost van Ulden Natural Resources Canada / Ressources Naturelles Canada 625 Robson Street / 625 rue Robson Vancouver, B.C. / Vancouver (C.B.) V6B 5J3 tel/tél: 604.666.7525 fax/télécopieur: 604.666.1124 email / courriel: [EMAIL PROTECTED] ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] WMS filter with PropertyIsLike/matchCase doesn't work
Hi list, I have to make WMS and WFS CaseInsensitive requests. In this example I use a TAB file and I search a city with its name. I have a city called milla. In the TAB file the data is : Milla I have tried WMS request with filter/PropertyIsEqualTo/matchCase and it works fine ! http://localhost/cgi-bin/mapserv.exe?map=C:\mapfiles\casse_couche_locale.i2.mapLAYERS=c_COMMUNESLD_BODY=%3CStyledLayerDescriptor%20version%3D%221.0.0%22%3E%3CNamedLayer%3E%3CName%3Ec_COMMUNE%3C%2FName%3E%3CUserStyle%3E%3CFeatureTypeStyle%3E%3CRule%3E%3CFilter%3E%3CPropertyIsEqualTo%20matchCase=%22false%22%3E%3CPropertyName%3ENOM_COM%3C%2FPropertyName%3E%3CLiteral%3Emillas%3C%2FLiteral%3E%3C%2FPropertyIsEqualTo%3E%3C%2FFilter%3E%3CPolygonSymbolizer%3E%3CFill%3E%3CGraphicFill%3E%3CGraphic%3E%3CMark%3E%3CWellKnownName%3Ecross%3C%2FWellKnownName%3E%3CFill%3E%3CCssParameter%20name%3D%22fill%22%3E%23A5F38D%3C%2FCssParameter%3E%3C%2FFill%3E%3C%2FMark%3E%3CSize%3E8.0%3C%2FSize%3E%3C%2FGraphic%3E%3C%2FGraphicFill%3E%3C%2FFill%3E%3CStroke%3E%3CCssParameter%20name%3D%22stroke%22%3E%23A5F38D%3C%2FCssParameter%3E%3CCssParameter%20name%3D%22stroke-width%22%3E2.0%3C%2FCssParameter%3E%3C%2FStroke%3E%3C%2FPolygonSymbolizer%3E%3C%2FRule%3E%3C%2FFeatureTypeStyle%3E%3C%2FUserStyle%3E%3C%2FNamedLayer%3E%3C%2FStyledLayerDescriptor%3EISBASELAYER=falseTRANSPARENT=trueFORMAT=image%2FpngSERVICE=WMSVERSION=1.1.1REQUEST=GetMapSTYLES=EXCEPTIONS=application%2Fvnd.ogc.se_inimageSRS=EPSG%3A27582BBOX=626217.062495,1746065.974996,627776.087504,1747105.325002WIDTH=900HEIGHT=600 But I need to use matchCase with PropertyIsLike. I have tried but I've nothing returned ! http://localhost/cgi-bin/mapserv.exe?map=C:\mapfiles\casse_couche_locale.i2.mapLAYERS=c_COMMUNESLD_BODY=%3CStyledLayerDescriptor%20version%3D%221.0.0%22%3E%3CNamedLayer%3E%3CName%3Ec_COMMUNE%3C%2FName%3E%3CUserStyle%3E%3CFeatureTypeStyle%3E%3CRule%3E%3CFilter%3E%3CPropertyIsLike%20wildCard%3D%22*%22%20singleChar%3D%22%23%22%20escapeChar%3D%22!%22%20escape%3D%22!%22%20matchCase%3D%22false%22%3E%3CPropertyName%3ENOM_COM%3C%2FPropertyName%3E%3CLiteral%3E*milla*%3C%2FLiteral%3E%3C%2FPropertyIsLike%3E%3C%2FFilter%3E%3CPolygonSymbolizer%3E%3CFill%3E%3CGraphicFill%3E%3CGraphic%3E%3CMark%3E%3CWellKnownName%3Ecross%3C%2FWellKnownName%3E%3CFill%3E%3CCssParameter%20name%3D%22fill%22%3E%23A5F38D%3C%2FCssParameter%3E%3C%2FFill%3E%3C%2FMark%3E%3CSize%3E8.0%3C%2FSize%3E%3C%2FGraphic%3E%3C%2FGraphicFill%3E%3C%2FFill%3E%3CStroke%3E%3CCssParameter%20name%3D%22stroke%22%3E%23A5F38D%3C%2FCssParameter%3E%3CCssParameter%20name%3D%22stroke-width%22%3E2.0%3C%2FCssParameter%3E%3C%2FStroke%3E%3C%2FPolygonSymbolizer%3E%3C%2FRule%3E%3C%2FFeatureTypeStyle%3E%3C%2FUserStyle%3E%3C%2FNamedLayer%3E%3C%2FStyledLayerDescriptor%3EISBASELAYER=falseTRANSPARENT=trueFORMAT=image%2FpngSERVICE=WMSVERSION=1.1.1REQUEST=GetMapSTYLES=EXCEPTIONS=application%2Fvnd.ogc.se_inimageSRS=EPSG%3A27582BBOX=626217.062495,1746065.974996,627776.087504,1747105.325002WIDTH=900HEIGHT=600 Is it normal ? Regards Laurent ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [MAPSERVER-USERS] How to map attribute data (non-geom) from Oracle(not Spatial)?
http://www.oracle.com/technology/products/spatial/spatial_locator_features.html Shapefile Converter SQL*Loader MapServer Query? Is that all it takes? On Tue, Aug 5, 2008 at 4:01 PM, Bill Wordsworth [EMAIL PROTECTED] wrote: Tim, I didn't know you could do geom from... without Oracle Spatial, so this is great! This is my current compilation: MapServer version 4.8.3 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=PDF OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=THREADS SUPPORTS=GEOS INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE DEBUG=MSDEBUG I don't see any Oracle support. Could you shed some light on how to enable that? And how do you insert geom into Oracle Locator without Oracle Spatial- what tools? So as I understand, Oracle Spatial allows geoprocessing type queries (buffer, nearest, shortest) while Oracle Locator doesn't allow any thing that but does display geom (point, line, polygon, (raster)). Correct?? I just want to take a shapefile, insert it and then display its filtered set. Cheers, Bill On Tue, Aug 5, 2008 at 10:38 AM, Nolte, Tim [EMAIL PROTECTED] wrote: Bill, Here is a layer definition I am using for Oracle Spatial(Locator) data. LAYER GROUP Cell Sites NAME On-Air TYPE POINT STATUS ON CONNECTIONTYPE oraclespatial CONNECTION username/[EMAIL PROTECTED] PROCESSING CLOSE_CONNECTION=DEFER DATA geom FROM (SELECT st.bts_nbr, sgt.geom FROM site_tab st, site_geom_tab sgt WHERE st.site_id = sgt.site_id AND st.site_status_id IN (4,7)) USING SRID 8307 LABELITEM bts_nbr METADATA static_legend 1 END DUMP true CLASS NAME On-Air Large Scale MINSCALE 0 MAXSCALE 120 STYLE SYMBOL circle COLOR 22 129 17 OUTLINECOLOR 255 255 255 SIZE 12 END LABEL TYPE TRUETYPE FONT sans SIZE 7 POSITION CR OFFSET 0 2 ANGLE AUTO BUFFER 3 MINDISTANCE 30 MINFEATURESIZE 10 COLOR 0 0 0 OUTLINECOLOR 245 245 231 SHADOWSIZE 3 3 BACKGROUNDSHADOWSIZE 1 -1 END END CLASS NAME On-Air Small Scale MINSCALE 120 MAXSCALE 600 STYLE SYMBOL circle COLOR 22 129 17 OUTLINECOLOR 255 255 255 SIZE 8 END END END The key here is that you need to have MapServer compiled with Oracle Spatial support. And you can see from my data line that that I do standard Oracle SQL statements for building my spatial results. I'm not using any shapefiles in this instance. The spatial data is actually stored right in the database table. There are tools to import shapefiles into Oracle. If your data is points you can build insert statements to populated your geometry columns. You're probably going to want to do some reading up on Oracle spatial. - Tim Timothy J Nolte - [EMAIL PROTECTED] Network Planning Engineer iPCS Wireless, Inc. 4717 Broadmoor Ave, Suite G Kentwood, MI 49512 Office: 616-656-5163 PCS:616-706-2438 Fax:616-554-6484 Web: www.ipcswirelessinc.com -Original Message- From: Bill Wordsworth [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2008 10:25 AM To: Nolte, Tim; mapserver-users@lists.osgeo.org Subject: Re: [MAPSERVER-USERS] How to map attribute data (non-geom) from Oracle(not Spatial)? This is exciting news! I am using Oracle 10g and get Oracle Locator free but how do I map data from Oracle Locator? Are you doing a JOIN+FILTER? Can you share a LAYER snippet from your MAP file? Cheers, Bill ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [MAPSERVER-USERS] Road Lines with AGG
Hey Tim, Thanks for the code snippets :) But, whenever i use mimetype image/png, i get an error SEGMENTATION FAULTwhile seeding the tiles. Any clues? Regards, Ritesh Nolte, Tim wrote: Here is what I have used for PNG in the OUTPUFORMAT: # == # Image Output Definition # == OUTPUTFORMAT NAME png DRIVER AGG/PNG MIMETYPE image/png EXTENSION png IMAGEMODE RGB FORMATOPTION INTERLACE=ON FORMATOPTION QUALITY=90 END This has worked for me. Also, here is an example of a road layer: # == # Layer: US Small Scale Secondary Highways and Major Roads # == LAYER NAME US Small Scale Secondary Highways and Major Roads GROUP Secondary Highways STATUS ON TILEINDEX us_streets/indexes/hwy_merge_index TILEITEM location TYPE LINE SIZEUNITS PIXELS CLASSITEM NCLASS TEMPLATE ../mapserver/cgi-query-templates/ushwy.html HEADER ../mapserver/cgi-query-templates/usshwy_mroad-header.html FOOTER ../mapserver/cgi-query-templates/footer.html TOLERANCE 5 TOLERANCEUNITS PIXELS # -- # Class: US Small Scale Secondary Highways and Major Roads, Scale 10 # -- CLASS #NAME County Highways EXPRESSION A30 MINSCALE 100 MAXSCALE 300 STYLE SYMBOL circle COLOR 223 214 113 SIZE 1 END END # -- # Class: US Small Scale Secondary Highways and Major Roads, Scale 9 # -- CLASS #NAME County Highways EXPRESSION A30 MINSCALE 50 MAXSCALE 100 STYLE SYMBOL circle COLOR 192 192 91 SIZE 3 END STYLE SYMBOL circle COLOR 252 252 151 SIZE 1 END END END Timothy J Nolte - [EMAIL PROTECTED] Network Planning Engineer iPCS Wireless, Inc. 4717 Broadmoor Ave, Suite G Kentwood, MI 49512 Office: 616-656-5163 PCS:616-706-2438 Fax:616-554-6484 Web: www.ipcswirelessinc.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ritesh Ambastha Sent: Wednesday, August 06, 2008 11:01 AM To: mapserver-users@lists.osgeo.org Subject: RE: [MAPSERVER-USERS] Road Lines with AGG Still looking for a solution :( -Ritesh Nolte, Tim wrote: When you are using AGG for your output do not use antialias true on your layers. - Tim Timothy J Nolte - [EMAIL PROTECTED] Network Planning Engineer iPCS Wireless, Inc. 4717 Broadmoor Ave, Suite G Kentwood, MI 49512 Office: 616-656-5163 PCS:616-706-2438 Fax:616-554-6484 Web: www.ipcswirelessinc.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ritesh Ambastha Sent: Tuesday, August 05, 2008 6:53 AM To: mapserver-users@lists.osgeo.org Subject: [MAPSERVER-USERS] Road Lines with AGG http://www.nabble.com/file/p18828729/road.png In the map file, I have defined the imagetype and outputformat as: IMAGETYPE AGG OUTPUTFORMAT NAME 'AGG' DRIVER AGG/PNG IMAGEMODE RGB END My line layers are written with antialias as true. How can I correct the lines with more smoothness while keeping the same sharpness? Thanks, Ritesh Ambastha -- View this message in context: http://www.nabble.com/Road-Lines-with-AGG-tp18828729p18828729.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/Road-Lines-with-AGG-tp18828729p18853113.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/Road-Lines-with-AGG-tp18828729p18857318.html Sent from the Mapserver - User mailing list archive at Nabble.com.
Re: [MAPSERVER-USERS] Mapserver bug when generating a tiled map with MapFish
Hi. Do you have maxExtent set in your map options? OpenLayers shouldn't request tiles outside the max extent. If it does it's a bug in OpenLayers. Another guestion: what layer type do you use? Layer.MapServer or Layer.WMS? If you use the former, make mapserver work as a WMS server and try using Layer.WMS to see if that fixes the problem. Again the ideal would be some example so that we con easily reproduce your problem. Eric 2008/8/6, Pierre-Benoit Besse [EMAIL PROTECTED]: Unfortunately there is no connection to internet on the platform I develop on. All is done localy. I will try to be more precise. I am trying to display a shapefile representing the whole world (it's a shapefile from Global Insight plus if it helps). I use mapfish without 'singleTile: true' so the layer is generated by tiles. There is no problem in the beggining when the map is zoomed to max extent. The problem occurs when I begin zooming in and trying to display America/Asia. One of the colums of tiles is drawn across the -180°/+180° longitude line, and those tiles are generated entirely blank (white, not even transparent). When I get the properties of the image (right-click on the blank tile - Properties) and I search in the Location of the image I can find : mapext=179.296875+44.296875+*225.703125* +90.703125imgext=179.296875+44.296875+*225.703125*+90.703125 So I guess the problem comes from that, MapServer doesn't recognise longitude greater than 180 or lower than -180. If I'm right I would appreciate any hint on how to handle this... Otherwise it may be a mapfish issue, maybe mapfish should always generate tiles with borders right on -180 / +180. This is the case at the beggining, lef tile has mapext=90+0+180+90 and right tile has mapext=-180+0+-90+90. But whenever I begin zooming in it goes awry, the border of tiles is no longer right on -180/+180 and some tiles are generated white by MapServer. If someone needs more informations I'm ready to give it. Best regards, PB 2008/8/6 Eric Lemoine [EMAIL PROTECTED] On Wed, Aug 6, 2008 at 2:28 PM, Pierre-Benoit Besse [EMAIL PROTECTED] wrote: Isn't there anyone to help me with this ? 2008/8/4 Faldor [EMAIL PROTECTED] Hi all, I use Mapserver with mapfish for the client side to display shapefiles which I generated using ogr2ogr. The problem is when I try to display a tiled layer (mapfish singleTile property set to 'false'). Some tiles are generated by mapserver entirely blank ! After a few researches I think it is due to the fact that those tiles are extended across the -180°/+180° line. For exemple, here is the imgext property from one of the calls to MapServer which render a blank tile : imgext=178.59375+-1.40625+271.40625+91.40625 Do you know of a way to fix this ? This is not enough information for anyone to help you. Could you provide a link or a web page to help people see what's going on? -- Eric ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [MAPSERVER-USERS] How to map attribute data (non-geom) fromOracle(not Spatial)?
Bill, You got it. - Tim Timothy J Nolte - [EMAIL PROTECTED] Network Planning Engineer iPCS Wireless, Inc. 4717 Broadmoor Ave, Suite G Kentwood, MI 49512 Office: 616-656-5163 PCS:616-706-2438 Fax:616-554-6484 Web: www.ipcswirelessinc.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Wordsworth Sent: Wednesday, August 06, 2008 2:47 PM To: mapserver-users@lists.osgeo.org Subject: Re: [MAPSERVER-USERS] How to map attribute data (non-geom) fromOracle(not Spatial)? http://www.oracle.com/technology/products/spatial/spatial_loca tor_features.html Shapefile Converter SQL*Loader MapServer Query? Is that all it takes? On Tue, Aug 5, 2008 at 4:01 PM, Bill Wordsworth [EMAIL PROTECTED] wrote: Tim, I didn't know you could do geom from... without Oracle Spatial, so this is great! This is my current compilation: MapServer version 4.8.3 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=PDF OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=THREADS SUPPORTS=GEOS INPUT=JPEG INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE DEBUG=MSDEBUG I don't see any Oracle support. Could you shed some light on how to enable that? And how do you insert geom into Oracle Locator without Oracle Spatial- what tools? So as I understand, Oracle Spatial allows geoprocessing type queries (buffer, nearest, shortest) while Oracle Locator doesn't allow any thing that but does display geom (point, line, polygon, (raster)). Correct?? I just want to take a shapefile, insert it and then display its filtered set. Cheers, Bill On Tue, Aug 5, 2008 at 10:38 AM, Nolte, Tim [EMAIL PROTECTED] wrote: Bill, Here is a layer definition I am using for Oracle Spatial(Locator) data. LAYER GROUP Cell Sites NAME On-Air TYPE POINT STATUS ON CONNECTIONTYPE oraclespatial CONNECTION username/[EMAIL PROTECTED] PROCESSING CLOSE_CONNECTION=DEFER DATA geom FROM (SELECT st.bts_nbr, sgt.geom FROM site_tab st, site_geom_tab sgt WHERE st.site_id = sgt.site_id AND st.site_status_id IN (4,7)) USING SRID 8307 LABELITEM bts_nbr METADATA static_legend 1 END DUMP true CLASS NAME On-Air Large Scale MINSCALE 0 MAXSCALE 120 STYLE SYMBOL circle COLOR 22 129 17 OUTLINECOLOR 255 255 255 SIZE 12 END LABEL TYPE TRUETYPE FONT sans SIZE 7 POSITION CR OFFSET 0 2 ANGLE AUTO BUFFER 3 MINDISTANCE 30 MINFEATURESIZE 10 COLOR 0 0 0 OUTLINECOLOR 245 245 231 SHADOWSIZE 3 3 BACKGROUNDSHADOWSIZE 1 -1 END END CLASS NAME On-Air Small Scale MINSCALE 120 MAXSCALE 600 STYLE SYMBOL circle COLOR 22 129 17 OUTLINECOLOR 255 255 255 SIZE 8 END END END The key here is that you need to have MapServer compiled with Oracle Spatial support. And you can see from my data line that that I do standard Oracle SQL statements for building my spatial results. I'm not using any shapefiles in this instance. The spatial data is actually stored right in the database table. There are tools to import shapefiles into Oracle. If your data is points you can build insert statements to populated your geometry columns. You're probably going to want to do some reading up on Oracle spatial. - Tim Timothy J Nolte - [EMAIL PROTECTED] Network Planning Engineer iPCS Wireless, Inc. 4717 Broadmoor Ave, Suite G Kentwood, MI 49512 Office: 616-656-5163 PCS:616-706-2438 Fax:616-554-6484 Web: www.ipcswirelessinc.com -Original Message- From: Bill Wordsworth [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2008 10:25 AM To: Nolte, Tim; mapserver-users@lists.osgeo.org Subject: Re: [MAPSERVER-USERS] How to map attribute data (non-geom) from Oracle(not Spatial)? This is exciting news! I am using Oracle 10g and get Oracle Locator free but how do I map data from Oracle Locator? Are you doing a JOIN+FILTER? Can you share a LAYER snippet from your MAP file? Cheers, Bill ___ 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] Horizontal line appears at the edge with circle symbol
Dear experts, I'm upgrading Mapserver from 4.2 to 5.2 and experiencing a very annoying problem. There appears a horizontal line at the edge of the map drawn by Mapserver 5.2 when the symbol is set to circle. This didn't happen with Mapserver 4.2. When I change the symbol to square, the line doesn't appear. I've tried various settings (e.g. SIZE, ANGLE, ANTIALIAS etc.) with no luck. Does anyone have any idea what's wrong with it? ** Examples: ** Mapserver 5.2 with circle symbol: http://seamap-dev.env.duke.edu/seamap2/main/seamap2_gm.php?sid=horizontal_line_with_circlemode=draw_mapoutputformat=PNG24layer_name=dist_sp_01deglayer_type=pointmapsize=256%2B256mapext=-90%2C27.059125784374068%2C-84.375%2C31.95216223802497 Mapserver 5.2 with square symbol: http://seamap-dev.env.duke.edu/seamap2/main/seamap2_gm.php?sid=no_line_with_squaremode=draw_mapoutputformat=PNG24layer_name=dist_sp_01deglayer_type=pointmapsize=256%2B256mapext=-90%2C27.059125784374068%2C-84.375%2C31.95216223802497 ** Mapserver info. ** ./mapserv -v MapServer version 5.2.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=GEOS INPUT=EPPL7 INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE ** Mapfile exerpt ** MAP EXTENT -20001364 -15000982 20001253 15000982 IMAGECOLOR 255 255 255 IMAGETYPE gif SYMBOLSET /var/www/seamap2/map/symbolset.map SHAPEPATH /data/shapefiles/ SIZE 256 256 STATUS ON TRANSPARENT TRUE UNITS DD NAME SEAMAP ONLINE MAPPER PROJECTION init=epsg:54004 END LAYER CLASSITEM _sp_tsn CONNECTION host=*** CONNECTIONTYPE POSTGIS DATA _geom from (***) *** NAME zd_35 PROJECTION init=epsg:4326 END STATUS ON TOLERANCE 0.1 TYPE POINT CLASS NAME Anatidae EXPRESSION 174983 STYLE ANGLE 360 COLOR 255 255 0 OPACITY 50 OUTLINECOLOR 0 0 0 SIZE 9 SYMBOL circle : annoying horizontal line appears #SYMBOL square : when square is used, no horizontal line END TITLE 174983 END ... -- == Ei Fujioka Research Associate Duke University (919) 613-8021 [EMAIL PROTECTED] == ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Horizontal line appears at the edge with circle symbol
This is a know bug. I think it is: http://trac.osgeo.org/mapserver/ticket/1719 -Steve W Ei Fujioka wrote: Dear experts, I'm upgrading Mapserver from 4.2 to 5.2 and experiencing a very annoying problem. There appears a horizontal line at the edge of the map drawn by Mapserver 5.2 when the symbol is set to circle. This didn't happen with Mapserver 4.2. When I change the symbol to square, the line doesn't appear. I've tried various settings (e.g. SIZE, ANGLE, ANTIALIAS etc.) with no luck. Does anyone have any idea what's wrong with it? ** Examples: ** Mapserver 5.2 with circle symbol: http://seamap-dev.env.duke.edu/seamap2/main/seamap2_gm.php?sid=horizontal_line_with_circlemode=draw_mapoutputformat=PNG24layer_name=dist_sp_01deglayer_type=pointmapsize=256%2B256mapext=-90%2C27.059125784374068%2C-84.375%2C31.95216223802497 Mapserver 5.2 with square symbol: http://seamap-dev.env.duke.edu/seamap2/main/seamap2_gm.php?sid=no_line_with_squaremode=draw_mapoutputformat=PNG24layer_name=dist_sp_01deglayer_type=pointmapsize=256%2B256mapext=-90%2C27.059125784374068%2C-84.375%2C31.95216223802497 ** Mapserver info. ** ./mapserv -v MapServer version 5.2.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT SUPPORTS=WCS_SERVER SUPPORTS=GEOS INPUT=EPPL7 INPUT=POSTGIS INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE ** Mapfile exerpt ** MAP EXTENT -20001364 -15000982 20001253 15000982 IMAGECOLOR 255 255 255 IMAGETYPE gif SYMBOLSET /var/www/seamap2/map/symbolset.map SHAPEPATH /data/shapefiles/ SIZE 256 256 STATUS ON TRANSPARENT TRUE UNITS DD NAME SEAMAP ONLINE MAPPER PROJECTION init=epsg:54004 END LAYER CLASSITEM _sp_tsn CONNECTION host=*** CONNECTIONTYPE POSTGIS DATA _geom from (***) *** NAME zd_35 PROJECTION init=epsg:4326 END STATUS ON TOLERANCE 0.1 TYPE POINT CLASS NAME Anatidae EXPRESSION 174983 STYLE ANGLE 360 COLOR 255 255 0 OPACITY 50 OUTLINECOLOR 0 0 0 SIZE 9 SYMBOL circle : annoying horizontal line appears #SYMBOL square : when square is used, no horizontal line END TITLE 174983 END ... ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Topo Maps
Hi all, Sorry for the cross posting, but this was new to me and I thought other here might be interested. http://www.kk.org/cooltools/archives/002970.php Enjoy, -Steve W ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Projection of shape objects in MapScript
Hello, I have what I hope is an easy question: when I extract shapes from query results in PHP MapScript, what projection would the shape be in? The map object usually has its own projection defined, as can the layer object...and then there's the data source itself (presumably the same as the layer object). So if I produce WKT from the shapeObj::toWkt() function, which reference system will the coordinates be in? I know I could figure this out on my own through experimentation, but I'm hoping someone already knows the answer. If it's in the documentation, then I've missed it...and I didn't turn anything up with a few web searches. Thanks for any help, Mike ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
