Re: [MAPSERVER-USERS] How to map attribute data (non-geom) fromOracle(not Spatial)?
msDrawMap(): Image handling error. Failed to draw layer named 'ora'. msOracleSpatialLayerOpen(): OracleSpatial error. OracleSpatial is not supported Upgrade or perish? Can I compile support into my existing setup (4.8.3)? I've heard Hobu is great at this :). I am afraid with all the syntax changes in 5.2.x my map files will throw bigger errors. Cheers, Bill On Wed, Aug 6, 2008 at 3:20 PM, Nolte, Tim <[EMAIL PROTECTED]> wrote: > 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] >> >>> Se
Re: [mapserver-users] MapServer-packages for SuSE-derived systemsavailable
Sweet! Might be worth adding a link to http://mapserver.gis.umn.edu/download/current/? Steve >>> Stephan Holl <[EMAIL PROTECTED]> 8/29/2008 2:02 AM >>> Hello mapserver-users, while at it I built MapServer-packages for SuSE-dervied systems using opensuses build-service. Currently mapserver 5.2.0 is available for * SLE_10 (i586/x86_64) * OpenSUSE 10.2 (i586/x86_64) * OpenSUSE 10.3 (i586/x86_64) * OpenSUSE 11 (i586/x86_64) * OpenSUSE_Factory (i586/x86_64 scheduled to build) You can add the repository as add-on within your favourite package-manager. http://download.opensuse.org/repositories/Application:/Geo/ Please report back any problems. Have fun. Best regards Stephan Holl -- Stephan Holl <[EMAIL PROTECTED]>, http://intevation.de/~stephan Tel: +49 (0)541-33 50 8 32 | Intevation GmbH | AG Osnabrück - HR B 18998 Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] ArcSDE
Nelson, Yes MS4W should be able to connect to ArcSDE, as per the instructions in the README[1]. However, please note that SDE is the one part of MS4W that I cannot test before each release, as I do not have access to SDE. If someone has an idea how I could access a machine with SDE for testing purposes please contact me directly. Nelson if you run into problems in your tests, you can file a bug for MS4W[2], by first clicking on the "create a new account" link on that page. Also, note that MS4W does have its own mailing list[3] for issues such as this. [1] http://maptools.org/ms4w/index.phtml?page=README_INSTALL.html#sde [2] http://bugzilla.maptools.org/enter_bug.cgi?product=MS4W [3] http://lists.maptools.org/mailman/listinfo/ms4w-users Nelson Soto wrote: Does ms4w come compiled with ArcSDE capability or do I need to compile a version of Mapserver that incorporates this functionality? Thanks, Nelson Soto -- 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] ArcSDE
Does ms4w come compiled with ArcSDE capability or do I need to compile a version of Mapserver that incorporates this functionality? Thanks, Nelson Soto ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] reprojection
Hello Attila,
I posted the item below to the OpenLayers forum regarding a similar problem.
As noted in the posting, if the overlay is not visible by default the initial
placement of the layer is off. However, any map move that fetches the data
again fixes the problem. I have received no answers to the posting nor have I
figured it out myself yet. This posting includes the map file and the
OpenLayers example.
In addition to what is in the posting below, you need to include the Google
projection (900913) definition in the PROJ4 data file. Information on that can
be found at this posting:
http://lists.osgeo.org/pipermail/mapserver-users/2008-August/057291.html
If you are using PostGIS, you will need to do both items 1 and 2. If you are
not using PostGIS, then I believe you only need item 1. Also, thanks to Paul
Ramsey, if you add the Google projection definition to the top of the PROJ4
epsg file (as well as the definitions of the other projections/coordinate
systems you are using) MapServer will make your map faster. (Thanks Paul, this
make a perceptible difference!).
I hope this helps,
Best regards,
-Linc
--- OpenLayers Posting ---
Using an overlay layer projected by MS (OpenLayer.MapServer object) to Google
(and Virtual Earth, EPSG 900913), if the overlay layer is initially visible
(visibility: true) then the overlay layer is correctly placed. If the initial
visibility is false, then upon the first fetch of the layer, it is NOT
correctly placed. However, any subsequent map navigation that causes a fetch
of the data correctly places the overlay layer. This behavior is consistent
using the layer switcher control and manually turning the layer on and off (not
including the layer switcher control).
The relevant portions of code are below. Sorry it is a bit long, but it is
needed for completeness.
Hopefully this is a newbie error on my part.
Any ideas?
Thanks,
-Linc
MS Map File Fragment...
PROJECTION
"init=epsg:900913" #Google
END #end projection
LAYER
NAME "senate"
connectiontype postgis
connection "user= password= dbname= host= port="
data "geom from s17s0036_shapes"
PROJECTION
"init=epsg:4269"
END #end projection
TYPE polygon
STATUS OFF
CLASS
STYLE
OUTLINECOLOR 0 255 0
WIDTH 3
END #end style
END #end class
END #end layer
LAYER
NAME "senate_go"
connectiontype postgis
connection "user=xxx password=xxx dbname=xxx host=xxx port=xxx"
data "geom from s17s0036_go"
PROJECTION
"init=epsg:900913"
END #end projection
TYPE polygon
STATUS OFF
#MINSCALE 700
CLASS
STYLE
OUTLINECOLOR 255 0 0
WIDTH 3
END #end style
END #end class
END #end layer
900913 projection defined to PROJ4 and PostGIS per Subha Ramakrishnan's
MapServer posting of last week.
I used the OpenLayers Google Overlay example. I'm a newbie so it's not real
pretty In this code, I was trying to see if the layer switcher control was
the issue so I did not include it and manually toggled layer visibility.
var map;
var senate;
var senate_go;
function init() {
map = new OpenLayers.Map('map',
{});
var gmap_r = new OpenLayers.Layer.Google("Google
Streets",
{projection: "EPSG:900913"}
);
senate_go = new OpenLayers.Layer.MapServer(
"State Senate Google",
"http://xxx/cgi-bin/mywms.exe";, {map:
'wms_senate_go.map', layers: 'senate_go',
transparent: true, sphericalMercator: true
},
{ visibility: true, singleTile: true,
opacity: 0.5 } );
senate = new OpenLayers.Layer.MapServer( "State
Senate",
"http://xxx/cgi-bin/mywms.exe";, {map:
'wms_senate_go.map', layers: 'senate',
transparent: true, sphericalMercato
[mapserver-users] reprojection
Dear All, I have a lot of data in epsg:23700 (HD-72 EOV), and I try to display it as an overlay over Google Map (epsg:900913) in Openlayers trough WMS. Theoretically it is possible to do this but I have no success at all...Which projection should I define in tha main MAP part? And in the LAYER part? Have anybody done something like this before? If yes, please help me. Thanks in advance, Attila Berényi ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Parameters in memory
Le Friday 29 August 2008 10:49:01 Till Adams, vous avez écrit : > Jacolin Yves schrieb: > > Hi list, > > > > I have a strange issue using mapserv. I think this will be difficult to > > reproduced, but I try asking in the list ;) > > > > I am using mapserver as WMS service with Openlayers and tilecache. We are > > moving our application to the release 2 and so we are cleaning the > > spatial configuration. For example, we changed the SHAPEPATH parameter > > from /var/local/cartoweb/transparens_immo/cres to /var/local/spatial/. > > > > This is a very good example because my problem come from this changing. > > So we moved spatial data in this new directory and changed SHAPEPATH in > > the mapfile. This change works for almost all layers. I don't know why, > > some layers don't want to use the new SHAPEPATH and I get this kind of > > error when requesting WMS layer (here named ortho_92): > > > > > > > > > SYSTEM "http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd";> > > > > > > msDrawMap(): Image handling error. Failed to draw layer named > > 'ortho_92'. > > msDrawRaster(): Unable to access file. > > (/var/local/cartoweb/transparens_immo/cres/Referentiel/Bd_Ortho/92/92-200 > >3-0595-2415-LA2E-C07.ecw) > > > > > > > > Is this something known? I am using mapserver 4.10.1 on Debian Etch. > > Mapserver come from C2C repository. thanks for your help. > > > > Regards, > > > > Y. > > Yves, > > sounds like you are using tileindexes? Within these the path in > attribute "location" maybe wrong > because unchanged? > > Till :O Good point ! Big thanks Till !!! Y. -- Yves Jacolin --- http://softlibre.gloobe.org ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Parameters in memory
Jacolin Yves schrieb: Hi list, I have a strange issue using mapserv. I think this will be difficult to reproduced, but I try asking in the list ;) I am using mapserver as WMS service with Openlayers and tilecache. We are moving our application to the release 2 and so we are cleaning the spatial configuration. For example, we changed the SHAPEPATH parameter from /var/local/cartoweb/transparens_immo/cres to /var/local/spatial/. This is a very good example because my problem come from this changing. So we moved spatial data in this new directory and changed SHAPEPATH in the mapfile. This change works for almost all layers. I don't know why, some layers don't want to use the new SHAPEPATH and I get this kind of error when requesting WMS layer (here named ortho_92): SYSTEM "http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd";> msDrawMap(): Image handling error. Failed to draw layer named 'ortho_92'. msDrawRaster(): Unable to access file. (/var/local/cartoweb/transparens_immo/cres/Referentiel/Bd_Ortho/92/92-2003-0595-2415-LA2E-C07.ecw) Is this something known? I am using mapserver 4.10.1 on Debian Etch. Mapserver come from C2C repository. thanks for your help. Regards, Y. Yves, sounds like you are using tileindexes? Within these the path in attribute "location" maybe wrong because unchanged? Till -- -- terrestris GmbH & Co. KG Irmintrudisstrasse 17 53111 Bonn Germany Till Adams Geschäftsführung Tel: +49 (0)228 / 962 899-52 Fax: +49 (0)228 / 962 899-57 [EMAIL PROTECTED] http://www.terrestris.de Amtsgericht Bonn, HRA 6835 - Komplementärin: terrestris Verwaltungs GmbH vertreten durch: Hinrich Paulsen, Till Adams ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Parameters in memory
Hi list, I have a strange issue using mapserv. I think this will be difficult to reproduced, but I try asking in the list ;) I am using mapserver as WMS service with Openlayers and tilecache. We are moving our application to the release 2 and so we are cleaning the spatial configuration. For example, we changed the SHAPEPATH parameter from /var/local/cartoweb/transparens_immo/cres to /var/local/spatial/. This is a very good example because my problem come from this changing. So we moved spatial data in this new directory and changed SHAPEPATH in the mapfile. This change works for almost all layers. I don't know why, some layers don't want to use the new SHAPEPATH and I get this kind of error when requesting WMS layer (here named ortho_92): http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd";> msDrawMap(): Image handling error. Failed to draw layer named 'ortho_92'. msDrawRaster(): Unable to access file. (/var/local/cartoweb/transparens_immo/cres/Referentiel/Bd_Ortho/92/92-2003-0595-2415-LA2E-C07.ecw) >>> Is this something known? I am using mapserver 4.10.1 on Debian Etch. Mapserver come from C2C repository. thanks for your help. Regards, Y. -- Yves Jacolin --- http://softlibre.gloobe.org ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] MapServer-packages for SuSE-derived systems available
Hello mapserver-users, while at it I built MapServer-packages for SuSE-dervied systems using opensuses build-service. Currently mapserver 5.2.0 is available for * SLE_10 (i586/x86_64) * OpenSUSE 10.2 (i586/x86_64) * OpenSUSE 10.3 (i586/x86_64) * OpenSUSE 11 (i586/x86_64) * OpenSUSE_Factory (i586/x86_64 scheduled to build) You can add the repository as add-on within your favourite package-manager. http://download.opensuse.org/repositories/Application:/Geo/ Please report back any problems. Have fun. Best regards Stephan Holl -- Stephan Holl <[EMAIL PROTECTED]>, http://intevation.de/~stephan Tel: +49 (0)541-33 50 8 32 | Intevation GmbH | AG Osnabrück - HR B 18998 Geschäftsführer: Frank Koormann, Bernhard Reiter, Dr. Jan-Oliver Wagner signature.asc Description: PGP signature ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
