Re: [mapserver-users] SQL Server 2012 connection
Spending lots of hours, finally i get it to work. Shortly speaking, it sounds it was all about the MS4W3.1.0beta. By changing to MS4W 3.0.6, everything works well. And my experience: 1- I tried using SQL Server 2008 express no change 2- Thanks to informative option in QGIS (Only look in geometry_columns metadata table in dialog of adding MSSQL layer), i found that there is no 'geometry_columns' and 'spatial_ref_sys' table in SQL Server. (Why the hell Microsoft does not follow standards?!!!). Although i had loaded my shapefiles via OGR, it didn't create those layers- as it supposed to do that. I found a code for adding 'geometry_columns' and when i loded another shapefile, it created 'spatial_ref_sys' table. Hint: Its a good idea for shapefiles to have specified SRS and also to specify SRID in connection string when loading shapefiles to SQL Server. 3- This error was making me crazy: ' Premature end of script headers: mapserv.exe' Changing MS4W package, now this error has been solved and i can view my layer via Mapserver. Hint: I couldnt get msplugin_mssql2008.dll to work. It sounds OGR is more mature and using OGR more reasonable than that plugin. I hope to my experince would be helpful to others wanna use MSSQL. Regards -- View this message in context: http://osgeo-org.1560.x6.nabble.com/SQL-Server-2012-connection-tp5149799p5150372.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] SQL Server 2012 connection
Hi all. I've loaded a shapefile to SQL Server 2012 (in Windows 2008 R2) as follows: ogr2ogr -f MSSQLSpatial MSSQL:server=localhost;database=mydb;trusted_connection=yes C:\streets2.shp -a_srs EPSG:26918 I can confirm that it has loaded, because i can view this layer in QGIS 1.8 and Also can export that as follows: ogr2ogr -f ESRI Shapefile C:\streets2.shp MSSQL:server=localhost;database=mydb;trusted_connection=yes; -sql SELECT ogr_geometry FROM streets2 -overwrite -lco SHPT=ARC -a_srs EPSG:26918 The problem arises when i wanna load that layer in mapfile. My mapfile is as follows: MAP NAME MyMap EXTENT562996.375999 4483049.109631 609777.312060 4529931.787066 # Geographic SIZE 800 400 IMAGECOLOR 255 255 255 SHAPEPATH '../data' FONTSET '../fonts/fonts.list' SYMBOLSET '../symbols/symbols35.txt' IMAGETYPE png CONFIG MS_ERRORFILE stdout # to send errors CONFIG CPL_DEBUG ON CONFIG PROJ_DEBUG ON# turn on debugging for projection to see PROJ4 errors DEBUG 5 LAYER NAME streets CONNECTIONTYPE OGR CONNECTION MSSQL:server=localhost;database=mydb;tables=streets2(ogr_geometry);trusted_connection=yes; STATUS ON TYPE line CLASS COLOR 0 50 50 END PROCESSING 'CLOSE_CONNECTION=DEFER' END END I get following error in error file of Apache: [Sat Jul 05 12:41:57 2014] [error] [client 127.0.0.1] malformed header from script. Bad header=[Microsoft][ODBC SQL Server Dr: mapserv.exe [Sat Jul 05 12:41:58 2014] [error] [client 127.0.0.1] OGR_MSSQLSpatial: EstablishSession(Connection:server=localhost;database=nyc;trusted_connection=yes;)\r [Sat Jul 05 12:41:58 2014] [error] [client 127.0.0.1] ODBC: SQLDriverConnect(DRIVER=SQL Server;server=localhost;database=nyc;trusted_connection=yes;)\r [Sat Jul 05 12:41:58 2014] [error] [client 127.0.0.1] ODBC: ... failed: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database nyc requested by the login. The login failed.\r [Sat Jul 05 12:41:58 2014] [error] [client 127.0.0.1] ODBC: SQLDisconnect()\r How is it possible? Login failed? I could connect already with this connection information using OGR, and now mapserver cannot connect. I also added a SQL Server authentication(username and password) and used that in connection string instead of trusted_connection=yes, but no change. Any idea? or any one encountered this problem before? Regards -- View this message in context: http://osgeo-org.1560.x6.nabble.com/SQL-Server-2012-connection-tp5149799.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] Intersect and Union with mapserver
Thanks a world for your very helpful answers. Also sorry for a bit latency. I wasn't around here for a while. I was thinking a solution like the one suggested by Brent. Thanks to him for his detailed solution. It sounds at the end i should choose a database-dependent solution, as described by Brent. About the definition of Union in ArcGIS, the best reference to understand that, is ArcGIS help. This is the entry for Union with pictures and ... : http://resources.arcgis.com/en/help/main/10.1/index.html#//0008000s00 http://resources.arcgis.com/en/help/main/10.1/index.html#//0008000s00 Finally, as Jukka talked about QGIS. This is a little confusing to me. In a web mapping application which is implemented by MapServer, Can we rely on QGIS capabilities and use the in our application? If so, how would be the connection between MapServer and QGIS. Best Regards -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Intersect-and-Union-with-mapserver-tp5095717p5096577.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] Intersect and Union with mapserver
Hi all. I wanna give users ability to do intersection and union between layers (not features). How can i do it with mapserver? Is it posssible? I'm looking for some guidelines. Should i use programming, any external library, etc. ? Regards -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Intersect-and-Union-with-mapserver-tp5095717.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] Intersect and Union with mapserver
Thanks steve. Because i'm kind of ArcGIS-oriented guy, i should explain what i see there and loonking for that here. Supppose that 2 verctor layers as input, Union analysis produces another vector layer with attributes of both input layers while features of input layers are UNIONED. I hope i have explained well what i have in my mind. (and sorry for my english, as well). Regards -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Intersect-and-Union-with-mapserver-tp5095717p5095731.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] WFS in MapServer?
I was nearly going mad. I couldn't understand why mapserver (=MS4W) does not understands MAXFEATURES parameter correctly. No matter MAXFEATURES specified by client or in map file and no matter what number specified for MAXFEATURES , mapserver always returns less features than MAXFEATURES (in response to GetFeature request). If i use MAXFEATURES without any filter, mapserver acts correctly and returned features exactly equals MAXFEATURES. But when i specify a filter, the problem shows up. If i don't use MAXFEATURES parameter, mapserver returns all records which satisfy the filter. If i use a MAXFEATURES in client request (wheter it's a direct GET request or a request made by OpenLayers), or if i use MAXFEATURES in Layer level, or if i use wfs_MAXFEATURES in Web object (in Map level or Layer level), the returned result by mapserver always is less than the number specified for MAXFEATURES (I'm sure that more features satisfy the filter). There is no error in debug file. I've also changed the data source (to another shapefile) but again no help. Then, i decided to test prevoius versions of MSW. I transfered my app from MS4W 3.0.6 (mapserver 6.0.2) to MS4W 3.0.1 (mapserver 5.6.6) and IT WORKED. It takes me a long time to understand that the problem goes back to windows version of mapserver, not my configurations. It sounds a bug for MS4W. I'm a novince and unaware of procedures for bug submitting. So, someone professional inform those guys (maybe Jeff Mckenna) at mapTools about it instead, please. Best Regards -- View this message in context: http://osgeo-org.1560.x6.nabble.com/WFS-in-MapServer-tp5050005p5052119.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] WFS in MapServer?
Jeff I tested MS4W 3.1.0 beta and it works fine regarding my issue, i.e. no problem. I'm gonna continue using this version. Regards -- View this message in context: http://osgeo-org.1560.x6.nabble.com/WFS-in-MapServer-tp5050005p5052163.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] WFS in MapServer?
-italic SIZE 10 ANTIALIAS TRUE POSITION CC PARTIALS FALSE MINDISTANCE 250 BUFFER 4 END END END # World polygon classified by continents ends here Any help would be really appreciated. Regards. From: Rahkonen Jukka jukka.rahko...@mmmtike.fi To: 'Saka Royban' sakaroy...@yahoo.com; 'MapServer' mapserver-users@lists.osgeo.org Sent: Monday, April 29, 2013 3:20 PM Subject: Re: [mapserver-users] WFS in MapServer? No, it may just be that your question is a bit hard to answer. Could you give us a bit more information about your data, mapfile and WFS request you have been using? Ogrinfo report about the datasource, layer definitions from the mapfile and at least the extents from the map level are needed. A hand written WFS url is most useful but if you can capture with Firebug or something what Openlayers is really sending if will do as well. Set also DEBUG 5 and CONFIG CPL_DEBUG ON into your layer setting in the mapfile and study what you get into the ms_errorfile. I do not believe that Mapserver WFS is 100% compliant but it may still be good enough. Speed depends usually much more on how the data in the backend is arranged than on the server. Here you can get some OpenStreetMap poinst from a very weak server http://hip.latuviitta.org/cgi-bin/ms_ows?service=wfsversion=1.0.0request=getfeaturetypename=osm_pisteetmaxfeatures=1000 and this will give you some areas http://hip.latuviitta.org/cgi-bin/ms_ows?service=wfsversion=1.0.0request=getfeaturetypename=osm_alueetmaxfeatures=1000 There is also another member in the Mapserver family, TinyOWS, which has cleared all the CITE tests for WFS and which can do also WFS-T. However, it works only with PostGIS. -Jukka Rahkonen- Saka Royban wrote Have i banned by mailing list users or admin? From:Saka Royban sakaroy...@yahoo.com To: MapServer mapserver-users@lists.osgeo.org Sent: Saturday, April 27, 2013 5:46 PM Subject: [mapserver-users] WFS in MapServer? Hi all As a newbie, i've got confused. I've set up a WFS server with mapserver and then get some queries, Once by URL and another time by using OpenLayers. But the result GML contains just part of data that it must. (I've set MaxFeatures to 100 but GML contains less than 100 while there is more than 100 features in compliance with my query) Then i got to page 560 of mapserver documentation, which says some statistics about WFS OGC test suites. So now, my question is that Is MapServer doing totally well in providing WFS? Is it in full compliance with OGC WFS specification? or we should not expectmuch from mapserver WFS server. If not so, i'm looking for some real implementation of mapserver WMS and WFS to see the speed and other things. Could u provide me some links? Thanks in advance ___ 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] WFS in MapServer?
Have i banned by mailing list users or admin? From: Saka Royban sakaroy...@yahoo.com To: MapServer mapserver-users@lists.osgeo.org Sent: Saturday, April 27, 2013 5:46 PM Subject: [mapserver-users] WFS in MapServer? Hi all As a newbie, i've got confused. I've set up a WFS server with mapserver and then get some queries, Once by URL and another time by using OpenLayers. But the result GML contains just part of data that it must. (I've set MaxFeatures to 100 but GML contains less than 100 while there is more than 100 features in compliance with my query) Then i got to page 560 of mapserver documentation, which says some statistics about WFS OGC test suites. So now, my question is that Is MapServer doing totally well in providing WFS? Is it in full compliance with OGC WFS specification? or we should not expectmuch from mapserver WFS server. If not so, i'm looking for some real implementation of mapserver WMS and WFS to see the speed and other things. Could u provide me some links? Thanks in advance ___ 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] WFS in MapServer?
Hi all As a newbie, i've got confused. I've set up a WFS server with mapserver and then get some queries, Once by URL and another time by using OpenLayers. But the result GML contains just part of data that it must. (I've set MaxFeatures to 100 but GML contains less than 100 while there is more than 100 features in compliance with my query) Then i got to page 560 of mapserver documentation, which says some statistics about WFS OGC test suites. So now, my question is that Is MapServer doing totally well in providing WFS? Is it in full compliance with OGC WFS specification? or we should not expectmuch from mapserver WFS server. If not so, i'm looking for some real implementation of mapserver WMS and WFS to see the speed and other things. Could u provide me some links? Thanks in advance ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Newbie problem with GetFeatureInfo
Hi all. I've read multiple times mapserver documentation to understand what are need parameters in GetFeatureInfo request. Is is documented anywhere? there are just 3 example links for that in documentation. Why both Layers and Query_layers must be defined in GetFeatureInfo request? Also, it sounds that QGIS cannot open GML output of GetFeatureInfo. I added OUTPUTFORMAT definition for OGR/GML and know QGIS can open that file. Is it because of version of GML? Regards. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Any way for WFS-T with SQL Server?
Thanks a lot for your help Jeff, i wasn't aware of ZOO project, so i'm gonna give it a try and see how it behaves with multiple user editing. Thaaks for your introduction Robert, I wonder if i can have a copy of your python script. If it involves some kind of licenses for your company or etc., so don't bother yourself. I'll write another one for myself, though I'm an ASP.net guy, not a python fan. Anyway, Thanks for your nice comment From: Robert Sanson robert.san...@asurequality.com To: MapServer mapserver-users@lists.osgeo.org; Saka Royban sakaroy...@yahoo.com Sent: Wednesday, April 24, 2013 1:31 AM Subject: Re: [mapserver-users] Any way for WFS-T with SQL Server? I have implemented a variation of WFS-T using dedicated Python scripts in the cgi-bin directory to run the queries against SQL-Server. The format of data between the Python scripts and my OpenLayers client that I use is GeoJSON or WKT. Mapserver is not involved directly, but can render the data in SQL-Server via OGR when the user need to print a PDF map. Regards, Robert Saka Royban sakaroy...@yahoo.com 23/04/2013 9:20 p.m. Hi all. I've asked this question in MS4W mailing list but it sounds no help. I know that mapserver uses tinyOWS for WFS-T but as appears to me, just PostGIS is supported. Is there any way to use WFS-T with backend SQL Server in MS4W (or even in Linux version of MapServer)? Regards This email and any attachments are confidential and intended solely for the addressee(s). If you are not the intended recipient, please notify us immediately and then delete this email from your system. This message has been scanned for Malware and Viruses by Websense Hosted Security. www.websense.com___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Mapserver useful for ordinary sites or not?
Hi guys After a lot of effort to use CGI mapserver in my own site and finally leaving hope to find a solution, i came here to ask whether maserver is useful just for dedicated servers or VPSs really? I (and as it sounds, most of users) have just bought some space from a host provider (i.e Linux) with a CGI-bin directory which as my host provider says is able to run CGI applications written in perl and C/C++. I have searched a lot but as it appears no one has been successful to run CGI mapserver in its CGI-bin folder. Am i right? CGI mapserver is useful just when shell access is available? Should i switch to Mapscript? Or maybe, buy a windows host with CGI capability? Your help would nicely be appreciated. I'm really got stuck and confused. Regards ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Mapserver useful for ordinary sites or not?
Thanks for your answer After lots of try, i found that i can extract mapserver binary from rpm using 7zip. I put that executable file to cgi-bin and call it via address bar but no success, just 500 Internal Server Error. (I know mapserver has some dependencies but in spite of that it everything was right it should display a nice error) Contacting with guys in host provider, they pointed me to http://mapserver.org/installation/unix.html#installation and finally told me there is no shell access to run this commands. I'm familiar with structure of mapserver cause of working with MS4W in my own computer. In addition, i've checked CGI-bin directory by running some perl script and everything is O.K. They really provide CGI capability. Now, i don't know what can i do more. (I'm not familiar with Linux, although i know what running a shell command means. I've been around computer since DOS age) Thanks in advance for helpful advices. Regards - Original Message - From: Mr. Puneet Kishor punk.k...@gmail.com To: MapServer OSGEO mapserver-users@lists.osgeo.org Cc: Sent: Wednesday, December 5, 2012 9:24 PM Subject: Re: [mapserver-users] Mapserver useful for ordinary sites or not? On Dec 5, 2012, at 9:40 AM, Saka Royban sakaroy...@yahoo.com wrote: Hi guys After a lot of effort to use CGI mapserver in my own site and finally leaving hope to find a solution, i came here to ask whether maserver is useful just for dedicated servers or VPSs really? I (and as it sounds, most of users) have just bought some space from a host provider (i.e Linux) with a CGI-bin directory which as my host provider says is able to run CGI applications written in perl and C/C++. I have searched a lot but as it appears no one has been successful to run CGI mapserver in its CGI-bin folder. Am i right? You are not right. MapServer is surprisingly easy to set up and get working, at least for basic and mid-complexity use cases. CGI mapserver is useful just when shell access is available? Should i switch to Mapscript? Or maybe, buy a windows host with CGI capability? Unless you figure out what you are doing wrong, you can't set it right. Why don't you post your issues here in detail (how you are setting things up, have you followed the tutorial, etc.) along with the errors you are getting (general description as well as specific error messages. I am sure one of us will be able to help you. Your help would nicely be appreciated. I'm really got stuck and confused. Yup, frustration is a common feeling when things don't work, but really, no need to give up. You can do it, we can help -- Puneet Kishor Science and Data Policy at Creative Commons ___ 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 useful for ordinary sites or not?
Hi Stephen It's CentOS and i've extracted that file from Enterprise Linux GIS. I ONLY have cPanel in front myself. How can i run that command? Sorry but i really don't know. Thanks - Original Message - From: Stephen Woodbridge wood...@swoodbridge.com To: mapserver-users@lists.osgeo.org Cc: Sent: Wednesday, December 5, 2012 10:01 PM Subject: Re: [mapserver-users] Mapserver useful for ordinary sites or not? It is probably failing because of missing dependency. Try this from the command line: /path/to/cgi-bin/mapserver -v This will give a more useful error message you can read. That said, extracting the binary and copying it to the cgi-bin is not going to work in most cases because the whole point of package systems like rpm it to find and install the dependencies. What version of linux is installed on your host? There is probably a one line command that we can give you to install mapserver the correct way. -Steve W On 12/5/2012 1:16 PM, Saka Royban wrote: Thanks for your answer After lots of try, i found that i can extract mapserver binary from rpm using 7zip. I put that executable file to cgi-bin and call it via address bar but no success, just 500 Internal Server Error. (I know mapserver has some dependencies but in spite of that it everything was right it should display a nice error) Contacting with guys in host provider, they pointed me to http://mapserver.org/installation/unix.html#installation and finally told me there is no shell access to run this commands. I'm familiar with structure of mapserver cause of working with MS4W in my own computer. In addition, i've checked CGI-bin directory by running some perl script and everything is O.K. They really provide CGI capability. Now, i don't know what can i do more. (I'm not familiar with Linux, although i know what running a shell command means. I've been around computer since DOS age) Thanks in advance for helpful advices. Regards - Original Message - From: Mr. Puneet Kishor punk.k...@gmail.com To: MapServer OSGEO mapserver-users@lists.osgeo.org Cc: Sent: Wednesday, December 5, 2012 9:24 PM Subject: Re: [mapserver-users] Mapserver useful for ordinary sites or not? On Dec 5, 2012, at 9:40 AM, Saka Royban sakaroy...@yahoo.com mailto:sakaroy...@yahoo.com wrote: Hi guys After a lot of effort to use CGI mapserver in my own site and finally leaving hope to find a solution, i came here to ask whether maserver is useful just for dedicated servers or VPSs really? I (and as it sounds, most of users) have just bought some space from a host provider (i.e Linux) with a CGI-bin directory which as my host provider says is able to run CGI applications written in perl and C/C++. I have searched a lot but as it appears no one has been successful to run CGI mapserver in its CGI-bin folder. Am i right? You are not right. MapServer is surprisingly easy to set up and get working, at least for basic and mid-complexity use cases. CGI mapserver is useful just when shell access is available? Should i switch to Mapscript? Or maybe, buy a windows host with CGI capability? Unless you figure out what you are doing wrong, you can't set it right. Why don't you post your issues here in detail (how you are setting things up, have you followed the tutorial, etc.) along with the errors you are getting (general description as well as specific error messages. I am sure one of us will be able to help you. Your help would nicely be appreciated. I'm really got stuck and confused. Yup, frustration is a common feeling when things don't work, but really, no need to give up. You can do it, we can help -- Puneet Kishor Science and Data Policy at Creative Commons ___ mapserver-users mailing list mapserver-users@lists.osgeo.org mailto: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] Fw: mapserver binary for CentOS?
Thanks a lot Peter for your kind help Extracting mapserv6.rpm, i got a 1.3 MB file. Now, i'm gonna test it on the server. Thanks again From: Peter Hopfgartner peter.hopfgart...@r3-gis.com To: mapserver-users@lists.osgeo.org Sent: Thursday, September 6, 2012 12:22 PM Subject: Re: [mapserver-users] Fw: mapserver binary for CentOS? On 09/05/2012 08:24 PM, Saka Royban wrote: Hi Saka Thanks a world for your helpful answer I wasn't aware that rpm could be extracted. Anyhow, in the link provided, i.e. http://elgis.argeo.org/repos/6/elgis-release-6-6_0.noarch.rpm, i can get a 11 kb file when i download above-mentioned link. This is the configuration file for enabling the whole ELGIS repo. If you're on a 64 bit machine, you propbably want http://elgis.argeo.org/repos/6/elgis/x86_64/mapserver5-5.6.7-3.el6.x86_64.rpm or http://elgis.argeo.org/repos/6/elgis/x86_64/mapserver-6.0.1-3.el6.x86_64.rpm. mapserve alone works for sure with MapServer 5.6, maybe also for MapServer 6. Regards, Peter It seems there is no mapsrev file in it. Could you guide me where can i find the whole package? Also, just mapserv is sufficient to run a simple web mapping application? no other dll? Thanks in advance From: Peter Hopfgartner peter.hopfgart...@r3-gis.com To: mapserver-users@lists.osgeo.org Sent: Wednesday, September 5, 2012 6:05 PM Subject: Re: [mapserver-users] Fw: mapserver binary for CentOS? Extracting the executable file mapserv from one of the above mentioned rpms and placing it in cgi-bin should give you a working MapServer CGI installation. Peter On 09/04/2012 04:20 PM, Saka Royban wrote: - Forwarded Message - From: Saka Royban sakaroy...@yahoo.com To: Prabu Raja prab.r...@gmail.com Sent: Tuesday, September 4, 2012 6:49 PM Subject: Re: [mapserver-users] mapserver binary for CentOS? Thanks for your help I contacted host admin and he told me they don't allow ssh access because their host is of shared (!) one. I was thinking maybe there is a way to just copy the files into cgi-bin folder, as it is for mapserv.exe and its dependencies (dlls) in MS4W package. However, it seems if i want to use MapServer in CGI mode i have to use a Windows server. Otherwise, i must switch to MapScript which is not recommended for all applications. If there is a way to use CGI Mapserver in this case, please inform me. Regards From: Prabu Raja prab.r...@gmail.com To: Peter Hopfgartner peter.hopfgart...@r3-gis.com Cc: mapserver-users@lists.osgeo.org Sent: Tuesday, September 4, 2012 12:12 PM Subject: Re: [mapserver-users] mapserver binary for CentOS? Find below the steps, which I followed to install mapserver on CentOS 6 64 bit sudo rpm -Uvh http://elgis.argeo.org/repos/6/elgis-release-6-6_0.noarch.rpm yum install mapserver sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/cfitsio-3.240-3.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/fribidi-0.19.2-2.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/libdap-3.11.0-1.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/fcgi-2.4.0-10.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/librx-1.5-14.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/libspatialite-2.4.0-0.6.RC4.el6.x86_64.rpm sudo rpm -Uvh http://mirror.centos.org/centos/6/os/x86_64/Packages/libgfortran-4.4.6-4.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/hdf5-1.8.5.patch1-7.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/netcdf-4.1.1-3.el6.2.x86_64.rpm sudo rpm -Uvh http://mirror.centos.org/centos/6/os/x86_64/Packages/expat-2.0.1-11.el6_2.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/ogdi-3.2.0-0.14.beta2.el6.x86_64.rpm yum install mapserver cp /usr/libexec/mapserv /var/www/cgi-bin/ On Tue, Sep 4, 2012 at 12:47 PM, Peter Hopfgartner peter.hopfgart...@r3-gis.com wrote: On 09/04/2012 08:33 AM, Saka Royban wrote: Hi guys I'm a newbie to mapserver and i've been using MS4W for a while. Now, i'm gonna use MapServer CGI in my website. So, I asked my host admin of the version of Linux and he replied me that CentOS is running on the server. Searching internet, unfortunately, i didn't find mapserver binary for CentOS. I just found some
Re: [mapserver-users] Fw: mapserver binary for CentOS?
So, if i want not install anything on the server, i have to switch to a windows sever, i.e. IIS. In IIS, i think there is a need to just copy mapserv.exe and some dlls. Am i right? From: Jeff Lake ad...@michiganwxsystem.com To: mapserver-users@lists.osgeo.org Sent: Wednesday, September 5, 2012 11:01 PM Subject: Re: [mapserver-users] Fw: mapserver binary for CentOS? On CentOS there is no dll's those are windows only, I'm not sure, just extracting the mapserv from the RPM is going to work?? you need everything else (gdal, geos, etc) without root or sh access, I don't see how you can run or install mapserv -Jeff Lake MichiganWxSystem.com AllisonHouse.com TheWeatherCenter.net GRLevelXStuff.com On 9/5/2012 14:24, Saka Royban wrote: Thanks a world for your helpful answer I wasn't aware that rpm could be extracted. Anyhow, in the link provided, i.e. http://elgis.argeo.org/repos/6/elgis-release-6-6_0.noarch.rpm, i can get a 11 kb file when i download above-mentioned link. It seems there is no mapsrev file in it. Could you guide me where can i find the whole package? Also, just mapserv is sufficient to run a simple web mapping application? no other dll? Thanks in advance From: Peter Hopfgartner peter.hopfgart...@r3-gis.com To: mapserver-users@lists.osgeo.org Sent: Wednesday, September 5, 2012 6:05 PM Subject: Re: [mapserver-users] Fw: mapserver binary for CentOS? Extracting the executable file mapserv from one of the above mentioned rpms and placing it in cgi-bin should give you a working MapServer CGI installation. Peter On 09/04/2012 04:20 PM, Saka Royban wrote: - Forwarded Message - From: Saka Royban sakaroy...@yahoo.com To: Prabu Raja prab.r...@gmail.com Sent: Tuesday, September 4, 2012 6:49 PM Subject: Re: [mapserver-users] mapserver binary for CentOS? Thanks for your help I contacted host admin and he told me they don't allow ssh access because their host is of shared (!) one. I was thinking maybe there is a way to just copy the files into cgi-bin folder, as it is for mapserv.exe and its dependencies (dlls) in MS4W package. However, it seems if i want to use MapServer in CGI mode i have to use a Windows server. Otherwise, i must switch to MapScript which is not recommended for all applications. If there is a way to use CGI Mapserver in this case, please inform me. Regards From: Prabu Raja prab.r...@gmail.com To: Peter Hopfgartner peter.hopfgart...@r3-gis.com Cc: mapserver-users@lists.osgeo.org Sent: Tuesday, September 4, 2012 12:12 PM Subject: Re: [mapserver-users] mapserver binary for CentOS? Find below the steps, which I followed to install mapserver on CentOS 6 64 bit sudo rpm -Uvh http://elgis.argeo.org/repos/6/elgis-release-6-6_0.noarch.rpm yum install mapserver sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/cfitsio-3.240-3.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/fribidi-0.19.2-2.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/libdap-3.11.0-1.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/fcgi-2.4.0-10.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/librx-1.5-14.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/libspatialite-2.4.0-0.6.RC4.el6.x86_64.rpm sudo rpm -Uvh http://mirror.centos.org/centos/6/os/x86_64/Packages/libgfortran-4.4.6-4.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/hdf5-1.8.5.patch1-7.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/netcdf-4.1.1-3.el6.2.x86_64.rpm sudo rpm -Uvh http://mirror.centos.org/centos/6/os/x86_64/Packages/expat-2.0.1-11.el6_2.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/ogdi-3.2.0-0.14.beta2.el6.x86_64.rpm yum install mapserver cp /usr/libexec/mapserv /var/www/cgi-bin/ On Tue, Sep 4, 2012 at 12:47 PM, Peter Hopfgartner peter.hopfgart...@r3-gis.com wrote: On 09/04/2012 08:33 AM, Saka Royban wrote: Hi guys I'm a newbie to mapserver and i've been using MS4W for a while. Now, i'm gonna use MapServer CGI in my website. So, I asked my host admin of the version of Linux and he replied me that CentOS is running on the server. Searching internet, unfortunately, i didn't find mapserver binary for CentOS. I just found some instructions
Re: [mapserver-users] Fw: mapserver binary for CentOS?
Thanks a world for your helpful answer I wasn't aware that rpm could be extracted. Anyhow, in the link provided, i.e. http://elgis.argeo.org/repos/6/elgis-release-6-6_0.noarch.rpm, i can get a 11 kb file when i download above-mentioned link. It seems there is no mapsrev file in it. Could you guide me where can i find the whole package? Also, just mapserv is sufficient to run a simple web mapping application? no other dll? Thanks in advance From: Peter Hopfgartner peter.hopfgart...@r3-gis.com To: mapserver-users@lists.osgeo.org Sent: Wednesday, September 5, 2012 6:05 PM Subject: Re: [mapserver-users] Fw: mapserver binary for CentOS? Extracting the executable file mapserv from one of the above mentioned rpms and placing it in cgi-bin should give you a working MapServer CGI installation. Peter On 09/04/2012 04:20 PM, Saka Royban wrote: - Forwarded Message - From: Saka Royban sakaroy...@yahoo.com To: Prabu Raja prab.r...@gmail.com Sent: Tuesday, September 4, 2012 6:49 PM Subject: Re: [mapserver-users] mapserver binary for CentOS? Thanks for your help I contacted host admin and he told me they don't allow ssh access because their host is of shared (!) one. I was thinking maybe there is a way to just copy the files into cgi-bin folder, as it is for mapserv.exe and its dependencies (dlls) in MS4W package. However, it seems if i want to use MapServer in CGI mode i have to use a Windows server. Otherwise, i must switch to MapScript which is not recommended for all applications. If there is a way to use CGI Mapserver in this case, please inform me. Regards From: Prabu Raja prab.r...@gmail.com To: Peter Hopfgartner peter.hopfgart...@r3-gis.com Cc: mapserver-users@lists.osgeo.org Sent: Tuesday, September 4, 2012 12:12 PM Subject: Re: [mapserver-users] mapserver binary for CentOS? Find below the steps, which I followed to install mapserver on CentOS 6 64 bit sudo rpm -Uvh http://elgis.argeo.org/repos/6/elgis-release-6-6_0.noarch.rpm yum install mapserver sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/cfitsio-3.240-3.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/fribidi-0.19.2-2.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/libdap-3.11.0-1.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/fcgi-2.4.0-10.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/librx-1.5-14.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/libspatialite-2.4.0-0.6.RC4.el6.x86_64.rpm sudo rpm -Uvh http://mirror.centos.org/centos/6/os/x86_64/Packages/libgfortran-4.4.6-4.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/hdf5-1.8.5.patch1-7.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/netcdf-4.1.1-3.el6.2.x86_64.rpm sudo rpm -Uvh http://mirror.centos.org/centos/6/os/x86_64/Packages/expat-2.0.1-11.el6_2.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/ogdi-3.2.0-0.14.beta2.el6.x86_64.rpm yum install mapserver cp /usr/libexec/mapserv /var/www/cgi-bin/ On Tue, Sep 4, 2012 at 12:47 PM, Peter Hopfgartner peter.hopfgart...@r3-gis.com wrote: On 09/04/2012 08:33 AM, Saka Royban wrote: Hi guys I'm a newbie to mapserver and i've been using MS4W for a while. Now, i'm gonna use MapServer CGI in my website. So, I asked my host admin of the version of Linux and he replied me that CentOS is running on the server. Searching internet, unfortunately, i didn't find mapserver binary for CentOS. I just found some instructions for building mapserver in Linux but i'm a windows follower and hence, not familiar with Linux. My host provider supports CGI applications. How can i get a binary MapServer compatible with Centos? Best Regards ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users You'll find some GIS packages here: http://elgis.argeo.org/ -- Peter Hopfgartner web : http://www.r3-gis.com ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Regards, Prabu Raja ___ 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 -- Peter Hopfgartner web : http://www.r3-gis.com
[mapserver-users] mapserver binary for CentOS?
Hi guys I'm a newbie to mapserver and i've been using MS4W for a while. Now, i'm gonna use MapServer CGI in my website. So, I asked my host admin of the version of Linux and he replied me that CentOS is running on the server. Searching internet, unfortunately, i didn't find mapserver binary for CentOS. I just found some instructions for building mapserver in Linux but i'm a windows follower and hence, not familiar with Linux. My host provider supports CGI applications. How can i get a binary MapServer compatible with Centos? Best Regards ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Fw: mapserver binary for CentOS?
- Forwarded Message - From: Saka Royban sakaroy...@yahoo.com To: Prabu Raja prab.r...@gmail.com Sent: Tuesday, September 4, 2012 6:49 PM Subject: Re: [mapserver-users] mapserver binary for CentOS? Thanks for your help I contacted host admin and he told me they don't allow ssh access because their host is of shared (!) one. I was thinking maybe there is a way to just copy the files into cgi-bin folder, as it is for mapserv.exe and its dependencies (dlls) in MS4W package. However, it seems if i want to use MapServer in CGI mode i have to use a Windows server. Otherwise, i must switch to MapScript which is not recommended for all applications. If there is a way to use CGI Mapserver in this case, please inform me. Regards From: Prabu Raja prab.r...@gmail.com To: Peter Hopfgartner peter.hopfgart...@r3-gis.com Cc: mapserver-users@lists.osgeo.org Sent: Tuesday, September 4, 2012 12:12 PM Subject: Re: [mapserver-users] mapserver binary for CentOS? Find below the steps, which I followed to install mapserver on CentOS 6 64 bit sudo rpm -Uvh http://elgis.argeo.org/repos/6/elgis-release-6-6_0.noarch.rpm yum install mapserver sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/cfitsio-3.240-3.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/fribidi-0.19.2-2.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/libdap-3.11.0-1.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/fcgi-2.4.0-10.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/librx-1.5-14.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/libspatialite-2.4.0-0.6.RC4.el6.x86_64.rpm sudo rpm -Uvh http://mirror.centos.org/centos/6/os/x86_64/Packages/libgfortran-4.4.6-4.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/hdf5-1.8.5.patch1-7.el6.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/netcdf-4.1.1-3.el6.2.x86_64.rpm sudo rpm -Uvh http://mirror.centos.org/centos/6/os/x86_64/Packages/expat-2.0.1-11.el6_2.x86_64.rpm sudo rpm -Uvh http://dl.fedoraproject.org/pub/epel/6/x86_64/ogdi-3.2.0-0.14.beta2.el6.x86_64.rpm yum install mapserver cp /usr/libexec/mapserv /var/www/cgi-bin/ On Tue, Sep 4, 2012 at 12:47 PM, Peter Hopfgartner peter.hopfgart...@r3-gis.com wrote: On 09/04/2012 08:33 AM, Saka Royban wrote: Hi guys I'm a newbie to mapserver and i've been using MS4W for a while. Now, i'm gonna use MapServer CGI in my website. So, I asked my host admin of the version of Linux and he replied me that CentOS is running on the server. Searching internet, unfortunately, i didn't find mapserver binary for CentOS. I just found some instructions for building mapserver in Linux but i'm a windows follower and hence, not familiar with Linux. My host provider supports CGI applications. How can i get a binary MapServer compatible with Centos? Best Regards ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users You'll find some GIS packages here: http://elgis.argeo.org/ -- Peter Hopfgartner web : http://www.r3-gis.com ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- Regards, Prabu Raja ___ 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] Simple Question: using HTML templates with OpenLayers?
Hi all I have a nearly beginner question. Is there any usage for using HTML templates with OpenLayers? i.e. Why and in which case w may need templating while we use openlayers as a viewer? (the reason is that before starting openlayers, i was working with templates. and now it sounds to me that openlayers completely overrides templates, in use.) Regards ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Simple Question: using HTML templates with OpenLayers?
Thanks a lot Steve so informative. however, Could u guide me to some of possible needs of query templates when using openlayers? From: Lime, Steve D (DNR) steve.l...@state.mn.us To: Saka Royban sakaroy...@yahoo.com; MapServer mapserver-users@lists.osgeo.org Sent: Fri, June 24, 2011 9:41:41 AM Subject: RE: [mapserver-users] Simple Question: using HTML templates with OpenLayers? Browse templates are pretty much useless with OpenLayers. Query templates, on the other hand, are very useful for a number of things w/OpenLayers. Steve From: mapserver-users-boun...@lists.osgeo.org [mapserver-users-boun...@lists.osgeo.org] On Behalf Of Saka Royban [sakaroy...@yahoo.com] Sent: Thursday, June 23, 2011 11:57 PM To: MapServer Subject: [mapserver-users] Simple Question: using HTML templates with OpenLayers? Hi all I have a nearly beginner question. Is there any usage for using HTML templates with OpenLayers? i.e. Why and in which case w may need templating while we use openlayers as a viewer? (the reason is that before starting openlayers, i was working with templates. and now it sounds to me that openlayers completely overrides templates, in use.) Regards___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Asking for guidelines about a project
Thanks a lot for your informative answers. As u mentioned, it's going to be off topic (of mapserver, Postgis list sounds a better place for it), but unfortunately I'm still confused. According to what i understood from your Select(s), you are saving all vehicles with their points and timestamps in one table. Why not to partition this into some tables for preventing a large table? (because i have to deal a growing number of vehicles, this is of importance to me) Dear Ben Also, I'm so sorry, but i didn't find Regina Obe comments on running tracks in internet. Do u have any more information? With best wishes Best Regards From: Ben Madin li...@remoteinformation.com.au To: mapserver-users@lists.osgeo.org Sent: Tue, June 21, 2011 8:59:46 AM Subject: Re: [mapserver-users] Asking for guidelines about a project Brent et al, Becoming off topic, but ours went something like : DATA the_move FROM (select ST_MakeLine(the_geom) as the_move, sq.polltime FROM (SELECT the_geom, CAST(polltime AS date) as polltime FROM vms WHERE vesselname like '%pg_sql%' ORDER BY polltime LIMIT 36) sq GROUP BY sq.polltime) AS foo USING UNIQUE polltime USING SRID=4326 but all credit for the concept goes to Regina Obe - I think she was showing running tracks! try postgresonline or the postgis list. cheers Ben On 21/06/2011, at 11:15 AM, mapserver-users-requ...@lists.osgeo.org wrote: From: Brent Fraser bfra...@geoanalytic.com Date: 20 June 2011 11:43:52 PM AEST To: Ben Madin li...@remoteinformation.com.au Cc: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Asking for guidelines about a project Ben, Our setup was similar. We had a current_location table and a archive_location table. To filter the archive_location for positions in the last 24 hours we had a view: CREATE VIEW archive_v AS SELECT archive_location.vessel_id, archive_location.time_fix, archive_location.speed, archive_location.heading, archive_location.vessel_coordinate, archive_location.archive_sequence, vessel_cfg.vessel_name, owner.org_name FROM archive_location,owner,vessel_cfg WHERE archive_location.owner_id=owner.org_id AND archive_location.vessel_id=vessel_cfg.vessel_id AND ((now() AT TIME ZONE 'utc') - (archive_location.time_fix)) = '24 hour'; I can't recall how we created linestrings for the tracks from the above view, but I think we used the archive_sequence number (this was assigned at insert time, per vessel) to order the points into lines. Best Regards, Brent Fraser ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Asking for guidelines about a project
There is at least (and for now) 100 vehicles with update rate of 5-15 minute. That' why i'm so careful abut table design. Anyway, thanks a million for all your helpful answers. Regards From: Brent Fraser bfra...@geoanalytic.com To: Saka Royban sakaroy...@yahoo.com Cc: MapServer mapserver-users@lists.osgeo.org Sent: Tue, June 21, 2011 11:14:14 PM Subject: Re: [mapserver-users] Asking for guidelines about a project Mainly because adding a new vehicle is trivial from a site maintenance perspective if you have all vehicles in one table. Adding a table would likely mean you would need to add a layer in Mapserver, but it depends on your user interface needs. For my first implementation, I did have some concerns regarding performance if I put all the historical positions in a table with the current positions. That's why I had two tables: current_position table with about 6 to 20 rows (since I have 6 to 20 vehicles), and an archive_positions table that grew over time. Since the user was usually just concerned with displaying the current position, queries were handled very quickly. As it turned out, the archive_positions table grew to only several hundred thousand records (maybe a million?), and Postgresql had no problems with that. So if I did it again, I'd likely use one table, containing the current and historical positions. But as I mentioned earlier, it might depend on how may vehicles you anticipate tracking, and how often they report (and to some extent how fast they move). Do you have that information? Best Regards, Brent Fraser On 6/21/2011 12:21 PM, Saka Royban wrote: Thanks a lot for your informative answers. As u mentioned, it's going to be off topic (of mapserver, Postgis list sounds a better place for it), but unfortunately I'm still confused. According to what i understood from your Select(s), you are saving all vehicles with their points and timestamps in one table. Why not to partition this into some tables for preventing a large table? (because i have to deal a growing number of vehicles, this is of importance to me) Dear Ben Also, I'm so sorry, but i didn't find Regina Obe comments on running tracks in internet. Do u have any more information? With best wishes Best Regards From: Ben Madin li...@remoteinformation.com.au To: mapserver-users@lists.osgeo.org Sent: Tue, June 21, 2011 8:59:46 AM Subject: Re: [mapserver-users] Asking for guidelines about a project Brent et al, Becoming off topic, but ours went something like : DATA the_move FROM (select ST_MakeLine(the_geom) as the_move, sq.polltime FROM (SELECT the_geom, CAST(polltime AS date) as polltime FROM vms WHERE vesselname like '%pg_sql%' ORDER BY polltime LIMIT 36) sq GROUP BY sq.polltime) AS foo USING UNIQUE polltime USING SRID=4326 but all credit for the concept goes to Regina Obe - I think she was showing running tracks! try postgresonline or the postgis list. cheers Ben On 21/06/2011, at 11:15 AM, mapserver-users-requ...@lists.osgeo.org wrote: From: Brent Fraser bfra...@geoanalytic.com Date: 20 June 2011 11:43:52 PM AEST To: Ben Madin li...@remoteinformation.com.au Cc: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Asking for guidelines about a project Ben, Our setup was similar. We had a current_location table and a archive_location table. To filter the archive_location for positions in the last 24 hours we had a view: CREATE VIEW archive_v AS SELECT archive_location.vessel_id, archive_location.time_fix, archive_location.speed, archive_location.heading, archive_location.vessel_coordinate, archive_location.archive_sequence, vessel_cfg.vessel_name, owner.org_name FROM archive_location,owner,vessel_cfg WHERE archive_location.owner_id=owner.org_id AND archive_location.vessel_id=vessel_cfg.vessel_id AND ((now() AT TIME ZONE 'utc') - (archive_location.time_fix)) = '24 hour'; I can't recall how we created linestrings for the tracks from the above view, but I think we used the archive_sequence number (this was assigned at insert time, per vessel) to order the points into lines. Best Regards, Brent Fraser
Re: [mapserver-users] Asking for guidelines about a project
I don't know how to express my thanks to your helpful answer and Brent Fraser, as well. specially, i wasn't careful about using views in this application. You don't need a table per vehicle, as all share the same columns, you just need to have a vehicle id column to be able to select the required vehicle from the table. I didn't get what ur meaning. No table per vehicle? while i have to store every point with its time, so it means 1 record for each point. (Can i have an array of time in one cell? if so, it means i have a line of points in one cell, and corresponding array of times in another cell) Do you want a fixed map extent just show vehicles in that region? Do you want to have the map automatically zoom to an extent covering all currently displayed vehicles? Do you want the map to automatically recenter on a vehicle point as the point nears an edge of the map? Of course, user selects some vehicles, and if not in current displayed region, map automatically changes the displayed extent. Around recentering map when a vehicle reaches map edges, I think (if i'm wrong Plz correct me) it would be done via Openlayers with some scripting. As it knows current extent and new position of vehicles, it is possible computing whether vehicle reaches edge or not. Best Regards Saka From: Brent Wood pcr...@yahoo.com To: MapServer mapserver-users@lists.osgeo.org; Saka Royban sakaroy...@yahoo.com Sent: Sat, June 18, 2011 3:08:47 AM Subject: Re: [mapserver-users] Asking for guidelines about a project Given how these sorts of things tend to grow, it may also be worth planning for a system to store the vehicle/points/times, as well as maintain the live table of vehicle positions. In fact the table of live positions can simply be a view on the historic table providing the current situation instead of a physical table. From this you can automatically generate hourly or daily tracklines (linestrings made up from the points within an interval ordered by time) which can also be made available by mapserver, via an interface allowing users to select vehicles start/end times to show where they have been as well as where they are, or where were they at a specified time. With respect to automatic on screen map updates, it can get complicated: Do you want a fixed map extent just show vehicles in that region? Do you want to have the map automatically zoom to an extent covering all currently displayed vehicles? Do you want the map to automatically recenter on a vehicle point as the point nears an edge of the map? A fixed extent is relatively easy, can be done with a just mapfile HTML (have the web page retrieve the map automatically as a URL via WMS as often as desired) You don't need a table per vehicle, as all share the same columns, you just need to have a vehicle id column to be able to select the required vehicle from the table. More powerful flexible approaches are more complicated, but can be done. It very much depends on what you want to do. Cheers, Brent Wood --- On Sat, 6/18/11, Saka Royban sakaroy...@yahoo.com wrote: From: Saka Royban sakaroy...@yahoo.com Subject: Re: [mapserver-users] Asking for guidelines about a project To: MapServer mapserver-users@lists.osgeo.org Date: Saturday, June 18, 2011, 4:56 AM Thanks for ur answer and also Josh's answer. In fact, i should be able to display path of vehicles (usually more than 1 vehicle in display area) and also be able to save points passed by vehicles and time of passing (for some queries). Cause of that, i thought maybe i need one table per vehicle. Do u think any more idea? Best Regards From: Brent Fraser bfra...@geoanalytic.com To: Saka Royban sakaroy...@yahoo.com Cc: MapServer mapserver-users@lists.osgeo.org Sent: Fri, June 17, 2011 7:49:20 PM Subject: Re: [mapserver-users] Asking for guidelines about a project The database schema depends on what you want to do with the data (display current position? A track of historical positions?), and how much data you expect (how may objects will be tracked? how often will they report?). A simple schema would have one table (e.g. vehicles), with one row per tracked object Table: Vehicles ID:Name: Position: Status: UpdateTime: 1 My Carpoint(51,-115) active2011-06-16 10:23:54+02 2 Another Car point(52,-116) inactive 2010-05-15 11:13:12+02 With this schema, when a new position arrives for My Car, an update statement is issued to change the row's Position and UpdateTime (and possibly Status). The table is treated as a PostGIS point layer by mapserver. In my implementations, the position data was updated every 30 to 60 minutes (they were ships and construction vehicles), so there was no need to ask mapserver to regenerate a graphic every second; an updated map was shown whenever
Re: [mapserver-users] Asking for guidelines about a project
Thanks for ur answer and also Josh's answer. In fact, i should be able to display path of vehicles (usually more than 1 vehicle in display area) and also be able to save points passed by vehicles and time of passing (for some queries). Cause of that, i thought maybe i need one table per vehicle. Do u think any more idea? Best Regards From: Brent Fraser bfra...@geoanalytic.com To: Saka Royban sakaroy...@yahoo.com Cc: MapServer mapserver-users@lists.osgeo.org Sent: Fri, June 17, 2011 7:49:20 PM Subject: Re: [mapserver-users] Asking for guidelines about a project The database schema depends on what you want to do with the data (display current position? A track of historical positions?), and how much data you expect (how may objects will be tracked? how often will they report?). A simple schema would have one table (e.g. vehicles), with one row per tracked object Table: Vehicles ID:Name: Position: Status: UpdateTime: 1 My Carpoint(51,-115) active2011-06-16 10:23:54+02 2 Another Car point(52,-116) inactive 2010-05-15 11:13:12+02 With this schema, when a new position arrives for My Car, an update statement is issued to change the row's Position and UpdateTime (and possibly Status). The table is treated as a PostGIS point layer by mapserver. In my implementations, the position data was updated every 30 to 60 minutes (they were ships and construction vehicles), so there was no need to ask mapserver to regenerate a graphic every second; an updated map was shown whenever a user did a pan or zoom. You may be able to configure OpenLayers to do a CGI request to mapserver every few seconds, but I've never done that. Best Regards, Brent Fraser On 6/16/2011 11:52 PM, Saka Royban wrote: Thanks a lot brent I checked provided link and i;m gonna give it a try. About ur helpful advices, i'm confused about how to save data in PostGIS? with what schema? I mean i have to keep track of each paced point by moving objects. Should i record each point as a record, so it means one table per moving object ? Also for displaying these varaiant data, there should some sort of plan. I don't think i'm able to say to MapServer CGI at each second connect to PostGIS and read the new data, then i have to use MapScript. Am i right? (Can this process be done via OpenLayers?) Best Regards From: Brent Fraser bfra...@geoanalytic.com To: Saka Royban sakaroy...@yahoo.com Cc: MapServer mapserver-users@lists.osgeo.org Sent: Tue, June 14, 2011 7:14:08 PM Subject: Re: [mapserver-users] Asking for guidelines about a project Saka, I've had good success using PostGIS for data storage in implementing tracking systems. While you'll need to create your own code for updating the positions in the database, mapserver can read points from PostGIS and can render the points into a map image for use with the OpenLayers client. There are other solutions too, like OpenGTS (http://opengts.sourceforge.net/index.html) Best Regards, Brent Fraser On 6/14/2011 12:08 AM, Saka Royban wrote: Hi all. Strictly Speaking, i have a project that i should display some moving objects on a map via browser. Generally, i don't know how to start? i mean how should i save these time-based objects in DB and how to retrieve and display them via Mapserver? where should i use client side scripting like OpneLayers? Any help woudbe greatly appreciated. Thanks in advance ___ 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] Asking for guidelines about a project
Hi all. Strictly Speaking, i have a project that i should display some moving objects on a map via browser. Generally, i don't know how to start? i mean how should i save these time-based objects in DB and how to retrieve and display them via Mapserver? where should i use client side scripting like OpneLayers? Any help woudbe greatly appreciated. Thanks in advance ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: AW: [mapserver-users] Problem in extent using openlayers withMapserver
Very very thanks.
It worked fine.
but one strange point: Why they don't easily compute this maxRsolution in their
lib using with of map element (instead of supposing all map elements to be in
256*256 size)?
Anyway, your helpful point is totally appreciated.
From: Arnd Wippermann arnd.wipperm...@web.de
To: Saka Royban sakaroy...@yahoo.com
Cc: us...@openlayers.org
Sent: Thu, June 9, 2011 1:59:10 AM
Subject: AW: [mapserver-users] Problem in extent using openlayers withMapserver
when you request MapServer via Url, then Mapserver delivers the image as
defined by the mapfile (extent, imagesize) = resolution = 0.45.
If you request MapServer via OpenLayers.WMS, then the mapoptions are the
point.
By default is the maxResolution = 1.40625 and the other resolutions are
maxResolution/2^zoom. (1.40625 , 0.703125, 0.3515625, ...)
map.zoomToMaxExtent() uses the resolution =
0.703125, because that is the best resolution to display maxExtent
(-180,-90,180,90). For the next resolution the map would not display in whole.
You can set maxResolution=0.45 in the mapoptions. Then the layer should fill
the whole map.
Arnd
Von: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] Im Auftrag von Saka Royban
Gesendet: Mittwoch, 8. Juni 2011 15:10
An: MapServer
Betreff: Re: [mapserver-users] Problem in extent using openlayers withMapserver
- Forwarded Message
From: Saka Royban sakaroy...@yahoo.com
To: Stephen Woodbridge wood...@swoodbridge.com
Sent: Wed, June 8, 2011 5:38:17 PM
Subject: Re: [mapserver-users] Problem in extent using openlayers with
Mapserver
Thanks stephen for ur help (and sorry for bit abit latency in reply)
I've already tried that, i.e. constructing map object without any argument but
no result.
In fact, in first step i created map without any extra argument and faced that
problem and after that i added some arguments to maybe solve the problem.
Any idea now?
From: Stephen Woodbridge wood...@swoodbridge.com
To: mapserver-users@lists.osgeo.org
Sent: Sat, June 4, 2011 10:04:29 PM
Subject: Re: [mapserver-users] Problem in extent using openlayers with
Mapserver
try just using:
map = new OpenLayers.Map( 'map' );
-Steve
On 6/4/2011 1:21 PM, Saka Royban wrote:
Hi all.
I've really got stuck in this problem and need some help as i'm a newbie
using openlayers with mapserver.
In mapfile i've set output to be:
EXTENT -180 -90 180 90 # Geographic
SIZE 800 400
IMAGECOLOR 128 128 255
when i request mapserver through URL, i recieve a complete 800*400
image, but when i use openlayers i get a 800*400 image which original
map fills 512*256 of the center and other pixels are filled with IMAGECOLOR.
this is my code:
map = new OpenLayers.Map( 'map',{'tileSize': new
OpenLayers.Size(400,400)} );
layer = new OpenLayers.Layer.MapServer( World Map,
http://localhost/cgi-bin/mapserv.exe;, {map:
'/ms4w/apps/ms101/htdocs/ms101.map',layers: 'world_poly', height: 400,
width: 800}, {singleTile: true} );
map.addLayer(layer);
map.zoomToMaxExtent();
I asked this question in openlayers mailing list with no success. It
sounds it is related to mapserver.
Any help would be greatly appreciated
Regards (also sorry if my english is not very good)
___
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] Problem in extent using openlayers with Mapserver
- Forwarded Message
From: Saka Royban sakaroy...@yahoo.com
To: Stephen Woodbridge wood...@swoodbridge.com
Sent: Wed, June 8, 2011 5:38:17 PM
Subject: Re: [mapserver-users] Problem in extent using openlayers with Mapserver
Thanks stephen for ur help (and sorry for bit abit latency in reply)
I've already tried that, i.e. constructing map object without any argument but
no result.
In fact, in first step i created map without any extra argument and faced that
problem and after that i added some arguments to maybe solve the problem.
Any idea now?
From: Stephen Woodbridge wood...@swoodbridge.com
To: mapserver-users@lists.osgeo.org
Sent: Sat, June 4, 2011 10:04:29 PM
Subject: Re: [mapserver-users] Problem in extent using openlayers with Mapserver
try just using:
map = new OpenLayers.Map( 'map' );
-Steve
On 6/4/2011 1:21 PM, Saka Royban wrote:
Hi all.
I've really got stuck in this problem and need some help as i'm a newbie
using openlayers with mapserver.
In mapfile i've set output to be:
EXTENT -180 -90 180 90 # Geographic
SIZE 800 400
IMAGECOLOR 128 128 255
when i request mapserver through URL, i recieve a complete 800*400
image, but when i use openlayers i get a 800*400 image which original
map fills 512*256 of the center and other pixels are filled with IMAGECOLOR.
this is my code:
map = new OpenLayers.Map( 'map',{'tileSize': new
OpenLayers.Size(400,400)} );
layer = new OpenLayers.Layer.MapServer( World Map,
http://localhost/cgi-bin/mapserv.exe;, {map:
'/ms4w/apps/ms101/htdocs/ms101.map',layers: 'world_poly', height: 400,
width: 800}, {singleTile: true} );
map.addLayer(layer);
map.zoomToMaxExtent();
I asked this question in openlayers mailing list with no success. It
sounds it is related to mapserver.
Any help would be greatly appreciated
Regards (also sorry if my english is not very good)
___
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] Problem in extent using openlayers with Mapserver
Hi all.
I've really got stuck in this problem and need some help as i'm a newbie using
openlayers with mapserver.
In mapfile i've set output to be:
EXTENT-180 -90 180 90 # Geographic
SIZE 800 400
IMAGECOLOR 128 128 255
when i request mapserver through URL, i recieve a complete 800*400 image, but
when i use openlayers i get a 800*400 image which original map fills 512*256
of
the center and other pixels are filled with IMAGECOLOR.
this is my code:
map = new OpenLayers.Map( 'map',{'tileSize': new OpenLayers.Size(400,400)}
);
layer = new OpenLayers.Layer.MapServer( World Map,
http://localhost/cgi-bin/mapserv.exe;, {map:
'/ms4w/apps/ms101/htdocs/ms101.map',layers: 'world_poly', height: 400, width:
800}, {singleTile: true} );
map.addLayer(layer);
map.zoomToMaxExtent();
I asked this question in openlayers mailing list with no success. It sounds it
is related to mapserver.
Any help would be greatly appreciated
Regards (also sorry if my english is not very good)
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] MapServer and GRASS integration?
Hi all. I just wanna know if it is possible to integrate Mapserver and GRASS, beside showing GRASS layers with Mapserver on the web, use power of GRASS in analysis and then display the result of analysis via Mapserver. I've found some examples of using GRASS with Mapserver in internet search but limited to viewing locations of GRASS. Any one aware of using GRASS analysis with Mapserver? !!! If it is possible, How to do it? Thx in advance for your help. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] dBox problem (with Python mapscript)?
Hi all I'm gonna use dBox, start using dbox0.9a1 example which is based on python2.4, although mapscript is built with python2.5 in latest version of MS4W. for legend, i just see one node at top with no layer(dBox uses yahoo treeview). this is error i get from firebug: Traceback (most recent call last): File D:\ms4w\Apache\cgi-bin\make_dlegend_xml_cgi.py, line 36, in lt;modulegt; make_dlegend_xml.write_xml(mapfile, server) File D:\ms4w\Apache\cgi-bin\make_dlegend_xml.py, line 278, in write_xml (minscale, maxscale) = get_group_minscale_and_maxscale(mapp, layer_indexes) File D:\ms4w\Apache\cgi-bin\make_dlegend_xml.py, line 204, in get_group_minscale_and_maxscale if layer.minscale == -1: File D:\ms4w\Apache\cgi-bin\mapscript.py, line 1006, in lt;lambdagt; __getattr__ = lambda self, name: _swig_getattr(self, layerObj, name) File D:\ms4w\Apache\cgi-bin\mapscript.py, line 34, in _swig_getattr raise AttributeError,name AttributeError: minscale anyone has idea about this? Isn't is because minscale ( maxscale) is deprecated (replaced with minsclaedenom)? ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] CGI (FastCGI) mode versus Mapscript?
Hi all. i couldn't get good answers from web seach. i read more and more about CGI,FastCGI and dynamic pages like ASP,JSP, and i don't know why mapserver shouldbe used in CGI or FastCGI mode. So, what is the difference of using mapserver in CGI mode or in dynamic pages via mapscript really, regarding performance and speed? ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Dynamin SQL with mapserver CGI?
Hi all I'm looking for a way to change SQL dynamically via URL parameters. it sounds from doc that changing DATA element in map file is impossible. Is there any other way? ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Fw: [mapserver-users] Looking for instances of Mapserver implementation?
Thnaks what i'm really looking for is a detailed architecture of their implementation. anyone knows or has any docs around it? Thanks in advance - Forwarded Message From: percy per...@pdx.edu To: Saka Royban srph...@yahoo.com Cc: MapServer mapserver-users@lists.osgeo.org Sent: Friday, January 23, 2009 9:19:29 PM Subject: Re: [mapserver-users] Looking for instances of Mapserver implementation? http://roguemap.geos.pdx.edu/ is our newest development... Percy Saka Royban wrote: Hi I'm looking for some information of using UMN Mapserver in different applications. i mean sth like architecture or anything else. i could not find anything in its website, as other softwares usually have a 'gallery' section in their website for some instances of implementation. any information would be apperciated Thanks in advance ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- David Percy Geospatial Data Manager Geology Department Portland State University http://gisgeek.pdx.edu 503-725-3373 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Looking for instances of Mapserver implementation?
Hi I'm looking for some information of using UMN Mapserver in different applications. i mean sth like architecture or anything else. i could not find anything in its website, as other softwares usually have a 'gallery' section in their website for some instances of implementation. any information would be apperciated Thanks in advance ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] newbie: Error in first atttempt to use postgis with mapserver?
Thanks alot
you are right. although i could understand from error message to have a OID
column (it is gid in my table), my mistake was about ignoring 'USING' in 'USING
UNIQUE gid).
thanks again to help me
From: Dan Little danlit...@yahoo.com
To: Venkat Rao Tammineni vtammin...@roulacglobal.com; Saka Royban
srph...@yahoo.com; MapServer mapserver-users@lists.osgeo.org
Sent: Thursday, January 15, 2009 10:17:06 PM
Subject: Re: [mapserver-users] newbie: Error in first atttempt to use postgis
with mapserver?
Newer versions of Postgres do not automatically create an OID column, as it was
a limited 32-bit construct.
Try add using unique XXX where XXX is the column name of the primary key (or
at least a unique key). If you've uploaded the layer from a shapefile using
ogr2ogr you can use the column ogc_fid
From: Venkat Rao Tammineni vtammin...@roulacglobal.com
To: Saka Royban srph...@yahoo.com; MapServer mapserver-users@lists.osgeo.org
Sent: Thursday, January 15, 2009 5:33:35 AM
Subject: RE: [mapserver-users] newbie: Error in first atttempt to use postgis
with mapserver?
Hi,
I think OID column may not be with your table…Can
you check that ..
Thanks
Venkat.
From:mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Saka
Royban
Sent: Thursday, January 15, 2009 3:36 PM
To: MapServer
Subject: [mapserver-users] newbie: Error in first atttempt to use
postgis with mapserver?
Hi everyone.
i've used workshop material of FOSS4G2007 (PostGIS workshop)to learn postgis
along with its data. but there is a problem
i got this error in first attempt to retrieve data from postgis:
msDrawMap(): Image handling error. Failed to draw layer named
'bc_municipality'. prepare_database(): Query error. Error declaring cursor:
ERROR: column oid does not exist LINE 1:
...inary(force_collection(force_2d(the_geom)),'NDR'),OID::text ... ^ With query
string: DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from
bc_municipality WHERE the_geom setSRID('BOX3D(458426.1
260651.497368421,1943216.4 1373313.90263158)'::BOX3D,
find_srid('','bc_municipality ','the_geom') ) msPOSTGISLayerRetrievePGVersion():
Query error. Error executing POSTGIS statement
(msPOSTGISLayerRetrievePGVersion():select substring(version() from 12 for
(position('on' in version()) - 13))
i don't know what causes the problem although it sounds easy.
THX
-Inline Attachment Follows-
___
postgis-users mailing list
postgis-us...@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Problem in replacing Template parameter via URL!!!
hi everyone. i have some problem in replacing Template parameter via URL to alter the whole html template file. I have tested both template=Cadatsre and map_web_template=Cadastre but no diffrence. Although templatepattern is set to Cad* anyone knows what is the problem. maybe i'm unaware of a particular configuration Thanks in advance ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Arabic labeling problem again?!!!
Hi all. I've asked this problem in MS4W mailing list but no success. it sounds it originally relates to mapserver According to what History.txt for MS4W2.2.8 says, problem for arabic and hebrew languages has been solved by using UTF8. But i couldn't get a good result. In fact, UTF8 doesn't show letters correctly (just some symbols). i have tried lots of fonts but the same result. in current version, the problem of joining letters have been solved because i can get result using 'ISO8859-6' encoding which is for arabic but now this encoding changes some of letters with each other. In last version, 'Windows-1256' encoding (for arabic) worked well for showing letters just they were separate not joint. but in cuurent versions this encoding just shows some symbols. I'm confused. maybe i should setup sth which i don't do or i don't know sth else. that would be my appreciate to help me because it is really a need. Maps without labels have less usage. Thanks in advance (See attachments) My Mapfile: LABEL TYPE TrueType FONT timesnewromans ENCODING 'windows-1256' SIZE 12 END attachment: UTF-8.pngattachment: Windows-1256.pngattachment: ISO8859-6.png___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Arabic-Farsi-Hebrew support?
Hi all. I'm new to Mapserver. I want to know if Mapserver is able to handle Arabic-Farsi(Persian) and Hebrew correctly (using gettext). In these languages letter join to each other to form a word not like others which letters are separate with no problem. also they are written right to left not left to right. This is an important point for labeling. Searching nabble.com, i found a post some months ago discussing around this problem and associated ticket. That would be my pleasure to know the result if any knows. Thanks in advance ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] MapServer Integration options?
Hi all. I'm doing a search to find out which softwares/packages/libraries i can use with mapserver for a more featureful webgis. for e.g. i know that i can use spatial database PostGIS to hold my data as a back-end or use pgRouting for best path analysis. but what about other features? I'm really interested to hear about other's experiences. Regards ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
