Re: [mapserver-users] Openlayers + Bing Maps with Mapserver WMS projection error...
Hi, try http://trac.openlayers.org/wiki/SphericalMercator ... This can be added to /usr/share/epsg/proj, and thus MapServerhttp://trac.openlayers.org/wiki/MapServer, GDAL, etc. by adding the following line to the file: 900913 +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgri...@null +no_defs ... []'s Luigi Castro Cardeles 2010/8/11 Paul james paulj...@gmail.com Thanks for the help... I tried use spherical marcator like that: var bing= new OpenLayers.Layer.VirtualEarth(Shaded, { type: VEMapStyle.Shaded, numZoomLevels: 10,sphericalMercator: true }); And use that projection in mapfile and openlayers: PROJECTION +init=epsg:3857 Openlayers map = new OpenLayers.Map('Test', { resolutions: [0.09524345064126273, 0.0730199788249681, 0.047621725320631365, 0.031747816880420915, 0.015873908440210457, 0.009524345064126272, 0.0031747816880420914, 0.0015873908440210457, 0.0007936954220105228, 0.00031747816880420915], projection: EPSG:4326, maxExtent: new OpenLayers.Bounds(-102.2607421875, -46.142578125, 4.7021484375, 13.623046875) }); But using that, my wms layers disappear... To other projection maybe? Any idea? Thanks On Wed, Aug 11, 2010 at 12:35 PM, Edward Mac Gillavry emacgilla...@hotmail.com wrote: Bing maps is also using EPSG: 900913, EPSG:3785 or EPSG:3857 whichever is the latest... That should do the trick. HTH Edward -- Date: Wed, 11 Aug 2010 11:12:47 -0300 From: paulj...@gmail.com To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] Openlayers + Bing Maps with Mapserver WMS projection error... Hey guys... When using Bing maps as base layer, I have huge difference between my data ... Both are using WGS84 projection... The image is attached... Any idea? Thanks My WMS map: MAP ... PROJECTION +init=epsg:4326 END WEB IMAGEPATH 'D:\Temp' IMAGEURL '/tmp/' QUERYFORMAT 'text/html' METADATA wms_title WMS Server ##required wms_onlineresource http://localhost/cgi-bin/mapserv.exe?; ##required wms_srs EPSG:4269 EPSG:4326 EPSG:42304 EPSG:42101 EPSG:900913 ##recommended wms_feature_info_mime_type text/html labelcache_map_edge_buffer -10 END END ... LAYER NAME STATE METADATA wms_titleSTATE ##required wms_feature_info_mime_type text/html END TYPE polygon STATUS ON INCLUDE Connection.map DATA ... PROCESSING CLOSE_CONNECTION=DEFER PROCESSING LABEL_NO_CLIP=ON PROJECTION init=epsg:4326 END ... My Openlayers config: map = new OpenLayers.Map('Test', { resolutions: [0.09524345064126273, 0.0730199788249681, 0.047621725320631365, 0.031747816880420915, 0.015873908440210457, 0.009524345064126272, 0.0031747816880420914, 0.0015873908440210457, 0.0007936954220105228, 0.00031747816880420915], projection: EPSG:4326, displayProjection: new OpenLayers.Projection(EPSG:4326), tileSize: new OpenLayers.Size(400, 400), maxExtent: new OpenLayers.Bounds(-102.2607421875, -46.142578125, 4.7021484375, 13.623046875) }); ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Looking for advice for OGC Services Server hardware requirements
Hi, Maybe this can help you. http://2009.foss4g.org/presentations/#presentation_109 []'s Luigi Castro Cardeles 2010/3/10 Fuchs Juan Carlos jf...@indec.mecon.gov.ar: Hi David Check out Building a GIS System Architecture Design Strategies for Managers from Dave Peters - Esri Press. Just as a start point. Cheers JC -Mensaje original- De: David Alda Fernandez de Lezea [mailto:da...@ikt.es] Enviado el: Miércoles, 10 de Marzo de 2010 08:21 a.m. Para: mapserver-users@lists.osgeo.org Asunto: RV: [mapserver-users] Looking for advice for OGC Services Server hardware requirements Nobody suggests anything?? -Mensaje original- De: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] En nombre de David Alda Fernandez de Lezea Enviado el: martes, 09 de marzo de 2010 11:35 Para: mapserver-users@lists.osgeo.org Asunto: [mapserver-users] Looking for advice for OGC Services Serverhardware requirements Hello list, In our company, we are planning to set up a OGC Services Server using MapServer (we are currently using version 5.2.1, and at the moment it's working fine) to serve amounts of geographical data. We are going to serve big raster files (45 GB aprox each raster), so we need a big HDD (we know this). We are planning to have this raster files tiled with TileCache. We also are going to serve data via MapServer from another server in which we have an Oracle Spatial DataBase with very big tables and millions of rows, so we think that the communication between these 2 servers should be very fluid. All this services will be consumed by our own employees (50 aprox) or other people using desktop GIS software like gvSIG, Kosmo or ArcGIS. Besides, we are developing some web applications using OpenLayers, and this web apps will also consume those ogc services. So, our doubts have to do with the following subjects: - Processor - RAM Memory - HDD (we know that has to be large, i.e. 1TB - 2TB) - Number of network adapters (is advisable to have more than one?) - Which OS is best for MapServer, Linux or Windows 2003 (in terms of performance) - Other suggestions... IMPORTANT: Take into account that this is going to be at PRODUCTION LEVEL. Hope someone can help me. Thanks!! Un saludo, ·· David Alda Fernández de Lezea Lurralde eta Biodibertsitate Saila / Dpto. de Territorio y Biodiversidad IKT Granja Modelo s/n · 01192 · Arkaute (Araba) ·· Tlfnos.: 945-00-32-95 Fax: 945-00.32.90 ·· email: da...@ikt.es web: www.ikt.es ·· ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] how can I associate MySql and Gdal
Hi, you can use http://www.gdal.org/ogr/drv_vrt.html []'s Luigi Castro Cardeles 2010/1/14 Murat BEYHAN bey...@deprem.gov.tr Hi friends, I have installed mandriva 2010 and then installed Mysql mapserver and gdal which are coming with Mandriva one CD. But I could not read data from MySql database by using ogr because of the supported formats. How could I associate MySql with gdal in order to draw map using data stored in MySql Please help me the formats supported by gdal as follows murat ogrinfo --formats Supported Formats: - GRASS (readonly) - ESRI Shapefile (read/write) - MapInfo File (read/write) - UK .NTF (readonly) - SDTS (readonly) - TIGER (read/write) - S57 (read/write) - DGN (read/write) - VRT (readonly) - REC (readonly) - Memory (read/write) - BNA (read/write) - CSV (read/write) - GML (read/write) - GPX (read/write) - KML (read/write) - GeoJSON (read/write) - GMT (read/write) - SQLite (read/write) - ODBC (read/write) - PGeo (readonly) - OGDI (readonly) - PostgreSQL (read/write) - XPlane (readonly) - AVCBin (readonly) - AVCE00 (readonly) - Geoconcept (read/write) -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Problem trying to compile Mapserver 5.6.0 with --with-experimental-png
Hi List, Many thanks Daniel :D your help was essential. this is a test build anyway, the goal is test this features :D []'s Luigi Castro Cardeles 2010/1/8 Daniel Morissette dmorisse...@mapgears.com Try --with-png=/usr You may have to provide valid paths for a few of the other configure options. See ./configure --help and/or README.CONFIGURE. Also, it is better to turn on only the options that you require and not try to blindly try to include every possible options without looking up what they are about and which args they take. Daniel Luigi Castro Cardeles wrote: Hi List, i am trying to compile Mapserver 5.6.0 on a linux box with --with-experimental-png but the below message appears: checking if AGG support requested... checking if RGBA palette png support requested... configure: error: cannot find png headers in /root/app/mapserver-5.6.0/yes /root/app/mapserver-5.6.0 is the folder where i untar the mapserver tarball yes - i don't know what is this :P Where i put the location of png headers? This is the command line: ./configure --enable-point-z-m --with-freetype --with-zlib --with-png --with-jpeg --with-xpm --with-libiconv --with-gd --with-pdf --with-agg=/usr --with-experimental-png --with-eppl --with-proj --with-threads --with-geos --with-ogr --with-gdal --with-tiff --with-postgis --with-ming --with-wfs --with-wcs --with-wmsclient --with-wfsclient --with-sos --with-curl-config --with-xml2-config --with-fribidi-config --with-cairo --with-fastcgi --with-php=/usr/include/php If i remove --with-experimental-png, i got this: ./configure --enable-point-z-m --with-freetype --with-zlib --with-png --with-jpeg --with-xpm --with-libiconv --with-gd --with-pdf --with-agg=/usr --with-eppl --with-proj --with-threads --with-geos --with-ogr --with-gdal --with-tiff --with-postgis --with-ming --with-wfs --with-wcs --with-wmsclient --with-wfsclient --with-sos --with-curl-config --with-xml2-config --with-fribidi-config --with-cairo --with-fastcgi --with-php=/usr/include/php -- Compiler Info - C compiler:gcc -O2 -fPIC -W -Wall -Wcast-align -Wmissing-prototypes -Wstrict-prototypes -Wpointer-arith -Wreturn-type -Wmissing-declarations C++ compiler: g++ -O2 -fPIC -W -Wall -Wcast-align -Wmissing-prototypes -Wstrict-prototypes -Wpointer-arith -Wreturn-type Debug: Generic NINT: -- Renderer Settings - OpenGL support:zlib support: -DUSE_ZLIB png support:palette rgba png support: jpeg support: iconv support: -DUSE_ICONV AGG support: -DUSE_AGG Cairo (SVG,PDF) support: -DUSE_CAIRO Ming(flash) support: -DUSE_MING_FLASH PDFLib support:-DUSE_PDF -- Support Libraries - Proj.4 support:-DUSE_PROJ Libxml2 support: -DUSE_LIBXML2 FriBidi support: -DUSE_FRIBIDI -DUSE_FRIBIDI2 Curl support: -DUSE_CURL FastCGI support: -DUSE_FASTCGI Threading support: -DUSE_THREAD GEOS support: -DUSE_GEOS -DGEOS_HAS_SIMPLIFY -- Data Format Drivers --- native tiff support: -DUSE_TIFF PostGIS support: -DUSE_POSTGIS EPPL7 support: -DUSE_EPPL ArcSDE support:OGR support: -DUSE_OGR GDAL support: -DUSE_GDAL Oracle Spatial support: -- OGC Services -- WMS Server:-DUSE_WMS_SVR WMS Client:-DUSE_WMS_LYR WFS Server:-DUSE_WFS_SVR WFS Client:-DUSE_WMS_LYR WCS Server:-DUSE_WCS_SVR SOS Server:-DUSE_SOS_SVR -- MapScript - PHP MapScript: yes Any clue about this problem? Best Regard's Luigi Castro Cardeles ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Daniel Morissette http://www.mapgears.com/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Re: Is mysqlclient a dependency to compile mapserver?
Hi list, this issue happens because the gdal / ogr i was using was mysql enable (ogrinfo --formats shows MySQL (read/write)). i already solve my own mistake :P thanks :) Luigi Castro Cardeles 2010/1/8 Luigi Castro Cardeles luigi.carde...@gmail.com Hi list, another question :D even if i don't want compile mapserver with mysql suport (i don't put --with-mygis at configure) when i run make it throws a error about mysqlclient the full message: g++ -O2 -fPIC -W -Wall -Wcast-align -Wmissing-prototypes -Wstrict-prototypes -Wpointer-arith -Wreturn-type -Wmissing-declarations -DUSE_POINT_Z_M -DHAVE_VSNPRINTF -DNEED_STRLCAT -DNEED_STRRSTR -DUSE_POINT_Z_M -DUSE_FASTCGI -DUSE_CAIRO -DUSE_FRIBIDI -DUSE_FRIBIDI2 -DUSE_WMS_LYR -DUSE_WFS_LYR -DUSE_SOS_SVR -DUSE_LIBXML2 -DUSE_CURL -DUSE_WCS_SVR -DUSE_WFS_SVR -DUSE_WMS_SVR-DUSE_POSTGIS -DUSE_TIFF -DUSE_GDAL -DUSE_OGR -DUSE_GEOS -DGEOS_HAS_SIMPLIFY -DUSE_THREAD -DUSE_PROJ -DUSE_EPPL -DUSE_AGG -DUSE_FTGL -DUSE_PDF -DUSE_GD_GIF -DUSE_GD_PNG -DUSE_GD_JPEG -DUSE_GD_WBMP -DUSE_GD_FT -DGD_HAS_FTEX_XSHOW -DGD_HAS_GDIMAGEGIFPTR -DGD_HAS_GETBITMAPFONTS -DUSE_ICONV -DUSE_ZLIB -DUSE_FRIBIDI -DUSE_FRIBIDI2 -I/usr/include -I/usr/include/freetype2 -I/usr/include/FTGL/ -I/usr/include/gdal/ -I/usr/include -I/usr/include-I/usr/include/libxml2 -I/usr/include/fribidi -I/usr/include/cairo -I/usr/include/pixman-1 -I/usr/include/freetype2 -I/usr/include/libpng12 shp2img.o -L. -lmapserver -lgd -L/usr/lib64 -lgd -ljpeg -lfreetype -lpng -lz -lXpm -lX11-L/usr/lib64 -lftgl -lpdf -ltiff -ljpeg -lfreetype -lpng -lz -lXpm -lX11 -lproj -ljpeg -lpng -lgdal -L/usr/lib64 -lgeos_c -I/usr/include -lsqlite3 -lodbc -lodbcinst -L/usr/lib -lexpat -L/usr/lib -lxerces-c -lpthread -ljasper -lhdf5 -L/usr/lib64/hdf -lmfhdf -ldf -logdi -lgif -ljpeg -lgeotiff -ltiff -lpng -lnetcdf -lcfitsio -lpq -L/usr/lib64 -lpq -lz -lpthread -lm -lrt -ldl -ldap -ldapclient -ldapserver -lpthread -lrx -lcurl -lxml2 -lz -lm -lcurl -rdynamic -L/usr/lib64/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lssl -lcrypto -L/usr/lib64 -lpq -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lcrypt -ldl -lm -lcurl-L/usr/lib64 -lgeos_c -lpthread -L -lc -lfcgi -lz -lxml2 -lz -lm -lfribidi -lm -lstdc++ -lfreetype -lfontconfig -lz -lcairo -lpng12-o shp2img /usr/bin/ld: cannot find -lmysqlclient collect2: ld returned 1 exit status make: ** [shp2img] Error 1 and here is the configure i use: ./configure --enable-point-z-m --with-freetype --with-zlib --with-png --with-jpeg --with-xpm --with-libiconv --with-gd --with-pdf --with-ftgl --with-agg=/usr --with-eppl --with-proj --with-threads --with-geos --with-ogr --with-gdal --with-tiff --with-postgis --with-wfs --with-wcs --with-wmsclient --with-wfsclient --with-sos --with-curl-config --with-xml2-config --with-fribidi-config --with-cairo --with-fastcgi --with-php=/usr/include/php --with-warnings Best Regard's and sorry for the poor english Luigi Castro Cardeles ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Problem trying to compile Mapserver 5.6.0 with --with-experimental-png
Hi List, i am trying to compile Mapserver 5.6.0 on a linux box with --with-experimental-png but the below message appears: checking if AGG support requested... checking if RGBA palette png support requested... configure: error: cannot find png headers in /root/app/mapserver-5.6.0/yes /root/app/mapserver-5.6.0 is the folder where i untar the mapserver tarball yes - i don't know what is this :P Where i put the location of png headers? This is the command line: ./configure --enable-point-z-m --with-freetype --with-zlib --with-png --with-jpeg --with-xpm --with-libiconv --with-gd --with-pdf --with-agg=/usr --with-experimental-png --with-eppl --with-proj --with-threads --with-geos --with-ogr --with-gdal --with-tiff --with-postgis --with-ming --with-wfs --with-wcs --with-wmsclient --with-wfsclient --with-sos --with-curl-config --with-xml2-config --with-fribidi-config --with-cairo --with-fastcgi --with-php=/usr/include/php If i remove --with-experimental-png, i got this: ./configure --enable-point-z-m --with-freetype --with-zlib --with-png --with-jpeg --with-xpm --with-libiconv --with-gd --with-pdf --with-agg=/usr --with-eppl --with-proj --with-threads --with-geos --with-ogr --with-gdal --with-tiff --with-postgis --with-ming --with-wfs --with-wcs --with-wmsclient --with-wfsclient --with-sos --with-curl-config --with-xml2-config --with-fribidi-config --with-cairo --with-fastcgi --with-php=/usr/include/php -- Compiler Info - C compiler:gcc -O2 -fPIC -W -Wall -Wcast-align -Wmissing-prototypes -Wstrict-prototypes -Wpointer-arith -Wreturn-type -Wmissing-declarations C++ compiler: g++ -O2 -fPIC -W -Wall -Wcast-align -Wmissing-prototypes -Wstrict-prototypes -Wpointer-arith -Wreturn-type Debug: Generic NINT: -- Renderer Settings - OpenGL support: zlib support: -DUSE_ZLIB png support: palette rgba png support: jpeg support: iconv support: -DUSE_ICONV AGG support: -DUSE_AGG Cairo (SVG,PDF) support: -DUSE_CAIRO Ming(flash) support: -DUSE_MING_FLASH PDFLib support:-DUSE_PDF -- Support Libraries - Proj.4 support:-DUSE_PROJ Libxml2 support: -DUSE_LIBXML2 FriBidi support: -DUSE_FRIBIDI -DUSE_FRIBIDI2 Curl support: -DUSE_CURL FastCGI support: -DUSE_FASTCGI Threading support: -DUSE_THREAD GEOS support: -DUSE_GEOS -DGEOS_HAS_SIMPLIFY -- Data Format Drivers --- native tiff support: -DUSE_TIFF PostGIS support: -DUSE_POSTGIS EPPL7 support: -DUSE_EPPL ArcSDE support: OGR support: -DUSE_OGR GDAL support: -DUSE_GDAL Oracle Spatial support: -- OGC Services -- WMS Server:-DUSE_WMS_SVR WMS Client:-DUSE_WMS_LYR WFS Server:-DUSE_WFS_SVR WFS Client:-DUSE_WMS_LYR WCS Server:-DUSE_WCS_SVR SOS Server:-DUSE_SOS_SVR -- MapScript - PHP MapScript: yes Any clue about this problem? Best Regard's Luigi Castro Cardeles ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Re: Problem trying to compile Mapserver 5.6.0 with --with-experimental-png
addon: i have the png headers installed. []'s Luigi Castro Cardeles 2010/1/8 Luigi Castro Cardeles luigi.carde...@gmail.com Hi List, i am trying to compile Mapserver 5.6.0 on a linux box with --with-experimental-png but the below message appears: checking if AGG support requested... checking if RGBA palette png support requested... configure: error: cannot find png headers in /root/app/mapserver-5.6.0/yes /root/app/mapserver-5.6.0 is the folder where i untar the mapserver tarball yes - i don't know what is this :P Where i put the location of png headers? This is the command line: ./configure --enable-point-z-m --with-freetype --with-zlib --with-png --with-jpeg --with-xpm --with-libiconv --with-gd --with-pdf --with-agg=/usr --with-experimental-png --with-eppl --with-proj --with-threads --with-geos --with-ogr --with-gdal --with-tiff --with-postgis --with-ming --with-wfs --with-wcs --with-wmsclient --with-wfsclient --with-sos --with-curl-config --with-xml2-config --with-fribidi-config --with-cairo --with-fastcgi --with-php=/usr/include/php If i remove --with-experimental-png, i got this: ./configure --enable-point-z-m --with-freetype --with-zlib --with-png --with-jpeg --with-xpm --with-libiconv --with-gd --with-pdf --with-agg=/usr --with-eppl --with-proj --with-threads --with-geos --with-ogr --with-gdal --with-tiff --with-postgis --with-ming --with-wfs --with-wcs --with-wmsclient --with-wfsclient --with-sos --with-curl-config --with-xml2-config --with-fribidi-config --with-cairo --with-fastcgi --with-php=/usr/include/php -- Compiler Info - C compiler:gcc -O2 -fPIC -W -Wall -Wcast-align -Wmissing-prototypes -Wstrict-prototypes -Wpointer-arith -Wreturn-type -Wmissing-declarations C++ compiler: g++ -O2 -fPIC -W -Wall -Wcast-align -Wmissing-prototypes -Wstrict-prototypes -Wpointer-arith -Wreturn-type Debug: Generic NINT: -- Renderer Settings - OpenGL support: zlib support: -DUSE_ZLIB png support: palette rgba png support: jpeg support: iconv support: -DUSE_ICONV AGG support: -DUSE_AGG Cairo (SVG,PDF) support: -DUSE_CAIRO Ming(flash) support: -DUSE_MING_FLASH PDFLib support:-DUSE_PDF -- Support Libraries - Proj.4 support:-DUSE_PROJ Libxml2 support: -DUSE_LIBXML2 FriBidi support: -DUSE_FRIBIDI -DUSE_FRIBIDI2 Curl support: -DUSE_CURL FastCGI support: -DUSE_FASTCGI Threading support: -DUSE_THREAD GEOS support: -DUSE_GEOS -DGEOS_HAS_SIMPLIFY -- Data Format Drivers --- native tiff support: -DUSE_TIFF PostGIS support: -DUSE_POSTGIS EPPL7 support: -DUSE_EPPL ArcSDE support: OGR support: -DUSE_OGR GDAL support: -DUSE_GDAL Oracle Spatial support: -- OGC Services -- WMS Server:-DUSE_WMS_SVR WMS Client:-DUSE_WMS_LYR WFS Server:-DUSE_WFS_SVR WFS Client:-DUSE_WMS_LYR WCS Server:-DUSE_WCS_SVR SOS Server:-DUSE_SOS_SVR -- MapScript - PHP MapScript: yes Any clue about this problem? Best Regard's Luigi Castro Cardeles ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Is mysqlclient a dependency to compile mapserver?
Hi list, another question :D even if i don't want compile mapserver with mysql suport (i don't put --with-mygis at configure) when i run make it throws a error about mysqlclient the full message: g++ -O2 -fPIC -W -Wall -Wcast-align -Wmissing-prototypes -Wstrict-prototypes -Wpointer-arith -Wreturn-type -Wmissing-declarations -DUSE_POINT_Z_M -DHAVE_VSNPRINTF -DNEED_STRLCAT -DNEED_STRRSTR-DUSE_POINT_Z_M -DUSE_FASTCGI -DUSE_CAIRO -DUSE_FRIBIDI -DUSE_FRIBIDI2 -DUSE_WMS_LYR -DUSE_WFS_LYR -DUSE_SOS_SVR -DUSE_LIBXML2 -DUSE_CURL -DUSE_WCS_SVR -DUSE_WFS_SVR -DUSE_WMS_SVR-DUSE_POSTGIS -DUSE_TIFF -DUSE_GDAL -DUSE_OGR -DUSE_GEOS -DGEOS_HAS_SIMPLIFY -DUSE_THREAD -DUSE_PROJ -DUSE_EPPL -DUSE_AGG -DUSE_FTGL -DUSE_PDF -DUSE_GD_GIF -DUSE_GD_PNG -DUSE_GD_JPEG -DUSE_GD_WBMP -DUSE_GD_FT -DGD_HAS_FTEX_XSHOW -DGD_HAS_GDIMAGEGIFPTR -DGD_HAS_GETBITMAPFONTS -DUSE_ICONV -DUSE_ZLIB -DUSE_FRIBIDI -DUSE_FRIBIDI2 -I/usr/include -I/usr/include/freetype2 -I/usr/include/FTGL/ -I/usr/include/gdal/ -I/usr/include -I/usr/include-I/usr/include/libxml2 -I/usr/include/fribidi -I/usr/include/cairo -I/usr/include/pixman-1 -I/usr/include/freetype2 -I/usr/include/libpng12 shp2img.o -L. -lmapserver -lgd -L/usr/lib64 -lgd -ljpeg -lfreetype -lpng -lz -lXpm -lX11-L/usr/lib64 -lftgl -lpdf -ltiff -ljpeg -lfreetype -lpng -lz -lXpm -lX11 -lproj -ljpeg -lpng -lgdal -L/usr/lib64 -lgeos_c -I/usr/include -lsqlite3 -lodbc -lodbcinst -L/usr/lib -lexpat -L/usr/lib -lxerces-c -lpthread -ljasper -lhdf5 -L/usr/lib64/hdf -lmfhdf -ldf -logdi -lgif -ljpeg -lgeotiff -ltiff -lpng -lnetcdf -lcfitsio -lpq -L/usr/lib64 -lpq -lz -lpthread -lm -lrt -ldl -ldap -ldapclient -ldapserver -lpthread -lrx -lcurl -lxml2 -lz -lm -lcurl -rdynamic -L/usr/lib64/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lssl -lcrypto -L/usr/lib64 -lpq -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lcrypt -ldl -lm -lcurl-L/usr/lib64 -lgeos_c -lpthread -L -lc -lfcgi -lz -lxml2 -lz -lm -lfribidi -lm -lstdc++ -lfreetype -lfontconfig -lz -lcairo -lpng12-o shp2img /usr/bin/ld: cannot find -lmysqlclient collect2: ld returned 1 exit status make: ** [shp2img] Error 1 and here is the configure i use: ./configure --enable-point-z-m --with-freetype --with-zlib --with-png --with-jpeg --with-xpm --with-libiconv --with-gd --with-pdf --with-ftgl --with-agg=/usr --with-eppl --with-proj --with-threads --with-geos --with-ogr --with-gdal --with-tiff --with-postgis --with-wfs --with-wcs --with-wmsclient --with-wfsclient --with-sos --with-curl-config --with-xml2-config --with-fribidi-config --with-cairo --with-fastcgi --with-php=/usr/include/php --with-warnings Best Regard's and sorry for the poor english Luigi Castro Cardeles ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Unexpected behavior of wfs layer using postgis
AND colv.org_interference_fk_fk = col.id) 0))) as foo where id = 246 query 5 select id,encode(AsBinary(force_collection(force_2d(the_geom)),'NDR'),'base64') as geom,id from (select distinct parcel.id,parcel.the_geom from mapserver_parcels parcel where parcel.parcelid in(SELECT distinct col.idFROM college col WHERE col.date_exclude IS NULL AND ((25 = col.id) OR (SELECT count(*) FROM perm_group_item pagi, visual colv , perm_group pag, perm_acess pa WHERE pagi.date_exclude is null AND pag.date_exclude is null AND colv.date_exclude is null AND pa.date_exclude is null AND colv.perm_group_FK = pagi.perm_group_ AND pagi.perm_group_ = pag.id AND pag.date_exclude IS NULL ANDpagi.perm_acess_fk = pa.id AND pa.name = org_interference_fk AND colv.org_interference_fk = 25 AND colv.org_interference_fk_fk = col.id) 0))) as foo where id = 247 xx the wfs layer are returning 3 geometries (that is the expected result) but i don't understand why mapserver is generating this four queries. the first query (query 1) returns the id column (pk on my table) and the_geom (geometry column). the second query (query 2) don't return nothing. the third query (query 3) return the first id and the first the_geom values (query 1 already did that). the forth query (query 4) return the second id and the second the_geom values (query 1 already did that). the fifth query (query 5) return the third id and the third the_geom values (query 1 already did that). --- Aproximated times: query 1: 3s query 2: 18ms query 3: 2.6s query 4: 2.5s query 5: 2.7s -- The problem with this extra-queries is that they consume time so the query uses 8 seconds to bring back the information when should use 3 seconds to brinq back information. This refactory of the queries made by mapserver is alright or this is a bug? Luigi Castro Cardeles ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Unexpected behavior of wfs layer using postgis
Thanks Paul :D, is there any ticket already open about that modification? best regards, Luigi Castro Cardeles 2009/8/7 Paul Ramsey pram...@cleverelephant.ca It's not a bug, it's a feature! What you are seeing is the mapserver query life cycle. It is designed to be run on top of shape files, so when used on databases, it is very redundant. First it gathers the id's of all the features that match the criteria. Then it goes back and iterates through, getting each feature one at a time. The upcoming 5.6 release of mapserver will replace this query life cycle with one that is much more efficient for databases. P. On Fri, Aug 7, 2009 at 4:52 AM, Luigi Castro Cardelesluigi.carde...@gmail.com wrote: Hi list, I have a wfs layer (data stored at postgis) and that layer have a complex data statement mapfile ------ LISTCOIID - cgi param ## #LAYER WFS PARCEL ## LAYER NAME 'parcels' #DEBUG 5 METADATA wfs_title parcels wfs_request_method get wfs_service wfs gml_featureid id gml_include_items all wfs_encoding UTF8 END TYPE POLYGON STATUS ON DUMP TRUE CONNECTIONTYPE postgis CONNECTION host=localhost user='postgres' password=postgres_password dbname='wfs_server' DATA the_geom FROM (select distinct parcel.id,parcel.the_geom from mapserver_parcels parcel where parcel.parcelid in( SELECT distinct col.id FROM college col WHERE col.date_exclude IS NULL AND ((%LISTCOIID% = col.id) OR (SELECT count(*) FROM perm_group_item pagi, visual colv , perm_group pag, perm_acess pa WHERE pagi.date_exclude is null AND pag.date_exclude is null AND colv.date_exclude is null AND pa.date_exclude is null AND colv.perm_group_FK = pagi.perm_group_fk AND pagi.perm_group_fk = pag.idAND pag.date_exclude IS NULL AND pagi.perm_acess_fk = pa.id AND pa.name = 'Test1' AND colv.org_interference_fk = %LISTCOIID% AND colv.org_interference_fk_fk = col.id) 0))) as foo USING UNIQUE id USING SRID=4326 #PROCESSING CLOSE_CONNECTION=DEFER PROJECTION 'init=epsg:4326' # +proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs END CLASS NAME 'parcels' STYLE SYMBOL 0 SIZE 10 OUTLINECOLOR 0 0 0 COLOR 150 123 90 END END END x when i activated the postgres log, i notice a strange, don't expected behavior. Mapserver changes the query (the data statement) and refactory in 4(four) other queries: query 1: select encode(AsBinary(force_collection(force_2d(the_geom)),'NDR'),'base64') as geom,id from (select distinct parcel.id,parcel.the_geom from mapserver_parcels parcel where parcel.parcelid in(SELECT distinct col.id FROM college col WHERE col.date_exclude IS NULL AND ((25 = col.id) OR (SELECT count(*) FROM perm_group_item pagi, visual colv , perm_group pag, perm_acess pa WHERE pagi.date_exclude is null AND pag.date_exclude is null AND colv.date_exclude is null AND pa.date_exclude is null AND colv.perm_group_FK = pagi.perm_group_ AND pagi.perm_group_ = pag.id AND pag.date_exclude IS NULL AND colv.perm_group_FK = pagi.perm_group_ AND pagi.perm_group_ = pag.id AND pag.date_exclude IS NULL AND pagi.perm_acess_fk = pa.id AND pa.name = org_interference_fk AND colv.org_interference_fk = 25 AND colv.org_interference_fk_fk = col.id) 0))) as foo where the_geom GeomFromText('POLYGON((-48.05 -15.77,-48.05 -15.71,-47.85 -15.71,-47.85 -15.77,-48.05 -15.77))',4326) query 2: select * from (select distinct parcel.id,parcel.the_geom from mapserver_parcels parcel where parcel.parcelid in(SELECT distinct col.id FROM college col WHERE col.date_exclude IS NULL AND ((25 = col.id) OR (SELECT count(*) FROM perm_group_item pagi, visual colv , perm_group pag, perm_acess pa WHERE pagi.date_exclude is null AND pag.date_exclude is null AND colv.date_exclude is null AND pa.date_exclude is null AND colv.perm_group_FK = pagi.perm_group_ AND pagi.perm_group_ = pag.id AND pag.date_exclude IS NULL ANDpagi.perm_acess_fk = pa.id AND pa.name = org_interference_fk AND colv.org_interference_fk = 25 AND colv.org_interference_fk_fk = col.id) 0))) as foo where false limit 0 query 3: select id,encode(AsBinary(force_collection(force_2d(the_geom)),'NDR'),'base64') as geom,id from (select distinct parcel.id,parcel.the_geom from mapserver_parcels parcel where parcel.parcelid in(SELECT distinct col.id FROM college col WHERE col.date_exclude IS NULL AND ((25 = col.id) OR (SELECT count(*) FROM perm_group_item pagi, visual colv , perm_group pag, perm_acess pa WHERE pagi.date_exclude is null AND pag.date_exclude is null AND colv.date_exclude is null AND pa.date_exclude is null AND colv.perm_group_FK = pagi.perm_group_ AND pagi.perm_group_ = pag.id
Re: [mapserver-users] How to link Oracle attributes to SHAPEFILE
Hi list, hum, could he use ogr vrt? http://www.gdal.org/ogr/drv_vrt.html Luigi Castro Cardeles 2009/4/28 Paolo Corti pco...@gmail.com Hi Roald. Thanks for the reply. In this project, we are required to use SHAPEFILES and Oracle, so we can't change this environment. Roald de Wit wrote: Hi Pedro, A number of years ago i had a situation like you describe below. The solution we chose was: - Create a postgresql/postgis datawarehouse - Import shapefiles into postgis (shp2psql or ogr2ogr) - Import attribute info from oracle into postgresql (we needed a commercial license for converting Oracle to Postgresql) - Either create a view or merge tables to join the geometry and attribute info - Serve the lot through MapServer WFS/WMS I hope this helps. Regards, Roald Pedro, the solution Roald is proposing is IMHO the closest one you have to obtain what you need with MapServer (et alii). according to this doc: http://mapserver.org/mapfile/join.html supported formats are: * DBF/XBase files * CSV (comma delimited text file) * PostgreSQL and PostGIS tables * MySQL tables So you have 5 options: 1. shapefile + dbf (exported from Oracle tables) 2. PostGIS 3. MySQL 4. Oracle Spatial 5. Oracle + ArcSde in 2. and 3. no need to join, you could use views. in 4 you need views. with 5 there are many limits with joins, so could be the wrong way to go. Note anyway that for what you need (join to make thematic map) according to the above doc there is no way. So the only solutions to go are 3, 4 I am not aware of other map web server software, neither OS or commercial, able to make mixed (from different sources) join for thematic mapping best regards Paolo ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Mapserver native connection with oracle spatial
Hi list, I was trying to connect to a layer on oracle spatial using mapserver native connection but i find some problems: When i try to load the layer (using mapserver cgi or command line), this message appears: /var/www/cgi-bin/mapserv QUERY_STRING=map=app.mapmode=map *** glibc detected *** /var/www/cgi-bin/mapserv: free(): invalid next size (fast): 0x09c23740 *** === Backtrace: = /lib/libc.so.6[0x6c8d06] /lib/libc.so.6(cfree+0x90)[0x6cc1e0] /var/www/cgi-bin/mapserv[0x80f2b6e] /var/www/cgi-bin/mapserv[0x80706be] /var/www/cgi-bin/mapserv[0x80765e7] /var/www/cgi-bin/mapserv[0x80529ca] /var/www/cgi-bin/mapserv[0x8054ac0] /lib/libc.so.6(__libc_start_main+0xdc)[0x675dec] /var/www/cgi-bin/mapserv[0x80516f1] Configuration: CentOS 5 - 2.6.18-92.1.22.el5.centos.plus x86. Oracle 10.2.0.1 + Oracle Spatial. Mapserver 5.4.0 ./mapserv -v MapServer version 5.4.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=SOS_SERVER SUPPORTS=THREADS SUPPORTS=GEOS INPUT=TIFF INPUT=POSTGIS INPUT=ORACLESPATIAL INPUT=OGR INPUT=GDAL INPUT=MYGIS INPUT=SHAPEFILE I already set the permission of the files and enviroment variables (at /etc/profile and apache conf's). using sqlplus at that machine i can connect. That mapfile has other layers from other fonts (postgis, shp), they load without problem, I can load the oracle spatial layer using a java client without problem. Any hint? Luigi Castro Cardeles ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Re: Mapserver native connection with oracle spatial
Hi list, there are some problems with the hard drives (RAID) and maybe that is the cause. When the problem is solved and have some news, i will let you know. Thanks, Luigi Castro Cardeles 2009/4/27 Luigi Castro Cardeles luigi.carde...@gmail.com Hi list, I was trying to connect to a layer on oracle spatial using mapserver native connection but i find some problems: When i try to load the layer (using mapserver cgi or command line), this message appears: /var/www/cgi-bin/mapserv QUERY_STRING=map=app.mapmode=map *** glibc detected *** /var/www/cgi-bin/mapserv: free(): invalid next size (fast): 0x09c23740 *** === Backtrace: = /lib/libc.so.6[0x6c8d06] /lib/libc.so.6(cfree+0x90)[0x6cc1e0] /var/www/cgi-bin/mapserv[0x80f2b6e] /var/www/cgi-bin/mapserv[0x80706be] /var/www/cgi-bin/mapserv[0x80765e7] /var/www/cgi-bin/mapserv[0x80529ca] /var/www/cgi-bin/mapserv[0x8054ac0] /lib/libc.so.6(__libc_start_main+0xdc)[0x675dec] /var/www/cgi-bin/mapserv[0x80516f1] Configuration: CentOS 5 - 2.6.18-92.1.22.el5.centos.plus x86. Oracle 10.2.0.1 + Oracle Spatial. Mapserver 5.4.0 ./mapserv -v MapServer version 5.4.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=SOS_SERVER SUPPORTS=THREADS SUPPORTS=GEOS INPUT=TIFF INPUT=POSTGIS INPUT=ORACLESPATIAL INPUT=OGR INPUT=GDAL INPUT=MYGIS INPUT=SHAPEFILE I already set the permission of the files and enviroment variables (at /etc/profile and apache conf's). using sqlplus at that machine i can connect. That mapfile has other layers from other fonts (postgis, shp), they load without problem, I can load the oracle spatial layer using a java client without problem. Any hint? Luigi Castro Cardeles ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] getting error
2008/12/19 muzaffar hussain mhd.muzaf...@gmail.com hi i am getting the following error if i am executing *shp2img -m ogr.map -o test.png* *msDrawMap(): Image handling error. Failed to draw layer named 'MyAqi'. br msOGRFileOpen(): OGR error. Open failed for OGR connection in layer `MyAqi'. Fi le not found or unsupported format. br* please help out from this. thanks in advance muzaffar ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Luigi Castro Cardeles ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Poll: Do you think a standalone Mapfile editing tool is necessary?
hi, maybe we don't need a new tool. A plugin for a text editor maybe do that job. Something like a extend auto-complete (when you put the LAYER definition, the plugin also put all the optins you have - CONNECTION, CLASS etc). Sometimes i am lost with so many options (Layer - Class - Style - n options if polygon - outline color, color, etc). 1+ to cross plataform (with qt or gtk) []'s 2008/7/24 Robert W. Burgholzer [EMAIL PROTECTED]: If the standalone tool was web-based, then most definitely. :) r.b. Quoting Yves Jacolin [EMAIL PROTECTED]: Enri, Le jeudi 24 juillet 2008 02:43, enri a écrit : Anyway, this tool will puts focus on windows users I am sad to read this, can't you think to all other linux geek? :) Depends on the langage you use, might it be portable to another plateform? Regards, Y. -- Yves Jacolin - Donner la liberté aux individus ne suffit pas, il faut aussi leur donner du pouvoir, de la puissance d'agir. M Gauchet Give freedom to people is not enough, we also have to give them the power to use this freedom, to act. M Gauchet - http://yjacolin.gloobe.org http://softlibre.gloobe.org ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Robert W. Burgholzer -- Finding the occasional straw of truth awash in a great ocean of confusion and bamboozle requires intelligence, vigilance, dedication and courage. But if we don't practice these tough habits of thought, we cannot hope to solve the truly serious problems that face us -- and we risk becoming a nation of suckers, up for grabs by the next charlatan who comes along. -- Carl Sagan, The Fine Art of Baloney Detection, Parade, February 1, 1987 Web Hydrology Objects - Online Collaborative Modeling: http://sourceforge.net/projects/npsource/ Home Page: http://soulswimmer.dynalias.net/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Luigi Castro Cardeles ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Error compiling mapserver 5.2 with agg
Hi list, i tried compile mapserver 5.2 with agg 2.4-2.1 (x86_64) and i am getting this error message: mapagg.h:37: error: ISO C++ forbids declaration of 'const_row_info' with no type mapagg.h:37: error: typedef name may not be a nested-name-specifier mapagg.h:37: error: expected ';' before '' token mapagg.h:96: error: 'row_data' does not name a type and error go on to mapagg.cpp. Anyone knows how to fix it? Thanks -- Luigi Castro Cardeles ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users