[mapserver-users] Rendering OSM Data on Ubuntu 14.04 ?
Hi, I found this [1] wiki page about Rendering OSM data on Ubuntu 12.04 - well, now I would like to ask if these instructions are still valid for Ubuntu 14.04 or if I will run into problems following that guide? Also I would like to ask: does exist some script (or some recipe for any configuration management system) that automates the steps described in the wiki page, what would make it possible to set this up without too many options for errors? Thank you very much for your attention, Karma [1] https://github.com/mapserver/mapserver/wiki/Rendering-OSM-data-on-Ubuntu-12.04 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Calculate length!
Lars, I have the latest OGR GDAL 1.11.2, released 2015/02/10 Thanks! Alok On Mon, Mar 16, 2015 at 5:39 PM, Schylberg Lars lars.schylb...@saabgroup.com wrote: I guess this must be a version problem. That same command runs fine on my osgeolive8 machine. ogrinfo --version GDAL 1.10.1, released 2013/08/26 /Lars *From:* mapserver-users-boun...@lists.osgeo.org [mailto: mapserver-users-boun...@lists.osgeo.org] *On Behalf Of *alok mathur *Sent:* den 16 mars 2015 09:54 *To:* Rahkonen Jukka (MML); mapserver-users@lists.osgeo.org *Subject:* Re: [mapserver-users] Calculate length! Hi Jukka, When i am trying to run the above ogr command as mentioned by you I am getting an error ogrinfo -dialect sqlite -sql select st_length(geometry) from 'Fibertech solution' doc_test.kml INFO: Open of `doc_test.kml' using driver `LIBKML' successful. ERROR 1: In ExecuteSQL(): sqlite3_prepare(select st_length(geometry) from 'Fibertech solution'): no such function: st_length Please let me know what the issue is. I have installed both libsqlite3 and libspatialite. Thanks! Alok ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- *Alok Mathur* | Software Engineer 2A | Ciena Mobile +91 9899413266 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] polygon fill
hi all iam trying to highlight the villages based on query but only one polygon is highlighting the query is based on the area of the villages, when user enters area =** ,it is displaying 13 villages in the grid and also same time it has to highlight the villages on the map my code is aspx page protected void btnselect_Click(object sender, EventArgs e) { string query = ; query = String.Format( select gid,box(geom),villname,geom,area(geom) from villages where area(geom) + ddlsymb.SelectedValue ++ txtarea.Text + ); dt = MyClass.getData(query); if (dt == null || dt.Rows.Count == 0) { Response.Write(No record found, Try Zoom in and click close to feature.); } else { dr = dt.Rows[0]; //String selectedGID = dr[gid].ToString(); //gid = selectedGID; var layername = villages; for(int i=0;idt.Rows.Count;i++) { dr = dt.Rows[i]; String selectedGID = dr[gid].ToString(); gid = selectedGID; Response.Write(String.Format(@scriptwindow.parent.highlightnav('{0}','{1}');/script, gid, layername)); //Locate(query); } if (dt.Columns.Contains(gid)) { dt.Columns.Remove(gid); } if (dt.Columns.Contains(geom)) { dt.Columns.Remove(geom); } GridView1.DataSource = dt; GridView1.DataBind(); } } js page function highlightnav(gid,layername) { bPoint.params.gid = gid; bPoint.params.tbl = layername; //bPoint.params.getElementById = geom; bPoint.redraw(); } mapfile bpoint.map MAP EXTENT 8240841.450745 2400319.900386 9218007.463612 3107183.406947 TRANSPARENT on IMAGETYPE png SIZE 450 500 SYMBOLSET symbols.txt web metadata wms_srs EPSG:4326 EPSG:900913 end end LAYER CONNECTIONTYPE postgis CONNECTION user=postgres password=** dbname=mpdb port=5432 DATA geom FROM (select geom,gid from %tbl% where gid=%gid%)as foo using srid=900913 using unique gid STATUS Default TYPE point PROJECTION init=epsg:900913 END class style symbol 'line20' color 255 0 0 size 10 end end END END i created for loop, to highlight all the polygons, but it is highlighting only one polygon. plz tell me the code ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Calculate length!
I guess this must be a version problem. That same command runs fine on my osgeolive8 machine. ogrinfo --version GDAL 1.10.1, released 2013/08/26 /Lars From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of alok mathur Sent: den 16 mars 2015 09:54 To: Rahkonen Jukka (MML); mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Calculate length! Hi Jukka, When i am trying to run the above ogr command as mentioned by you I am getting an error ogrinfo -dialect sqlite -sql select st_length(geometry) from 'Fibertech solution' doc_test.kml INFO: Open of `doc_test.kml' using driver `LIBKML' successful. ERROR 1: In ExecuteSQL(): sqlite3_prepare(select st_length(geometry) from 'Fibertech solution'): no such function: st_length Please let me know what the issue is. I have installed both libsqlite3 and libspatialite. Thanks! Alok ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Calculate length!
Hi, The GDAL version is not what is essential but the version of the dependent Spatialite library. GDAL must be compiled with such Spatialite version that has support for ST_Length. The error means either that Spatialite is missing totally or that it is of too old version and in this case it is obvioustly the latter. However, there may be a simple solution. ST-functions are new synonyms but your older Spatialite version may support the native name that Spatialite has used for the function https://www.gaia-gis.it/gaia-sins/xmlBlob/spatialite-sql-latest.html. Try if SELECT glength(geometry) happens to work. Otherwise you must try to find a GDAL version that is compiled with more fresh Spatialite. -Jukka Rahkonen- Schylberg Lars wrote: I guess this must be a version problem. That same command runs fine on my osgeolive8 machine. ogrinfo --version GDAL 1.10.1, released 2013/08/26 /Lars From: mapserver-users-boun...@lists.osgeo.orgmailto:mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of alok mathur Sent: den 16 mars 2015 09:54 To: Rahkonen Jukka (MML); mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Calculate length! Hi Jukka, When i am trying to run the above ogr command as mentioned by you I am getting an error ogrinfo -dialect sqlite -sql select st_length(geometry) from 'Fibertech solution' doc_test.kml INFO: Open of `doc_test.kml' using driver `LIBKML' successful. ERROR 1: In ExecuteSQL(): sqlite3_prepare(select st_length(geometry) from 'Fibertech solution'): no such function: st_length Please let me know what the issue is. I have installed both libsqlite3 and libspatialite. Thanks! Alok ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] How use a spatialite as tileindex for raster
Hi Andrea, I share your feelings, it is odd. Therefore I wrote this mail and now when I am lost I can search for spatialite ogr tileindex rahkonen http://osgeo-org.1560.x6.nabble.com/How-to-use-Spatialite-as-a-TILEINDEX-td4228164.html -Jukka Rahkonen- Andrea Peri wrote: Hi, reading the mapserver docs, I understand that is possible to use every OGR datasource to access a raster catalog using tileindex. So I try to use a spatialite as tileindex. I try this setting but without success. NAME rt_ofc2k.ofc2k STATUS OFF EXTENT 555870.99 4677465.00 752890.00 4924883.05 TYPE raster CONNECTIONTYPE OGR CONNECTION /pth-to-spatialite/db.sqlite TILEINDEX 'table' TILEITEM 'location' The error reported from log is: [Mon Mar 16 16:49:58 2015].129679 msShapefileOpen(): Unable to access file. (/home//table) Perhaps is not true that an OGR spatialite can be used as tileindex source ? Thx, -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ 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] How use a spatialite as tileindex for raster
Hi, reading the mapserver docs, I understand that is possible to use every OGR datasource to access a raster catalog using tileindex. So I try to use a spatialite as tileindex. I try this setting but without success. NAME rt_ofc2k.ofc2k STATUS OFF EXTENT 555870.99 4677465.00 752890.00 4924883.05 TYPE raster CONNECTIONTYPE OGR CONNECTION /pth-to-spatialite/db.sqlite TILEINDEX 'table' TILEITEM 'location' The error reported from log is: [Mon Mar 16 16:49:58 2015].129679 msShapefileOpen(): Unable to access file. (/home//table) Perhaps is not true that an OGR spatialite can be used as tileindex source ? Thx, -- - Andrea Peri . . . . . . . . . qwerty àèìòù - ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Calculate length!
Hi Jukka, When i am trying to run the above ogr command as mentioned by you I am getting an error ogrinfo -dialect sqlite -sql select st_length(geometry) from 'Fibertech solution' doc_test.kml INFO: Open of `doc_test.kml' using driver `LIBKML' successful. ERROR 1: In ExecuteSQL(): sqlite3_prepare(select st_length(geometry) from 'Fibertech solution'): no such function: st_length Please let me know what the issue is. I have installed both libsqlite3 and libspatialite. Thanks! Alok On Fri, Mar 13, 2015 at 5:04 PM, Rahkonen Jukka (MML) jukka.rahko...@maanmittauslaitos.fi wrote: Hi, You do not need anything else than GDAL which is compiled with libraries libsqlite3 and libspatialite. If you have a suitable GDAL version you should be able to repeat this with the attached small KML file. ogrinfo -dialect sqlite -sql select st_length(geometry) from Layer0 lines.kml INFO: Open of `lines.kml' using driver `LIBKML' successful. Layer name: SELECT Geometry: None Feature Count: 2 Layer SRS WKT: (unknown) st_length(geometry): Real (0.0) OGRFeature(SELECT):0 st_length(geometry) (Real) = 38.2726390753108 OGRFeature(SELECT):1 st_length(geometry) (Real) = 34.5939953221416 -Jukka Rahkonen- alok mathur wrote: Hi Rahkonen, I have a KML as data source and I am not using sqlite or postgis. I am reading the KML from ogrinfo. is there anyway to do the length calculation without using sqlite or postgis. Thanks! Alok On Fri, Mar 13, 2015 at 3:28 PM, Rahkonen Jukka (MML) jukka.rahko...@maanmittauslaitos.fi wrote: Hi Lars, You should not underestimate GDAL. Read http://www.gdal.org/ogr_sql_sqlite.html and look at this: ogrinfo -dialect sqlite -sql select st_length(geometry) from line_demo limit 5 line_demo.shp INFO: Open of `line_demo.shp' using driver `ESRI Shapefile' successful. Layer name: SELECT Geometry: None Feature Count: 10 Layer SRS WKT: (unknown) st_length(geometry): Real (0.0) OGRFeature(SELECT):0 st_length(geometry) (Real) = 638.237633730745 OGRFeature(SELECT):1 st_length(geometry) (Real) = 32.7179011265525 OGRFeature(SELECT):2 st_length(geometry) (Real) = 4399.43983906202 OGRFeature(SELECT):3 st_length(geometry) (Real) = 480.395511976145 OGRFeature(SELECT):4 st_length(geometry) (Real) = 311.309421824364 -Jukka Rahkonen- Schylberg Lars wrote: As far as I know there is no length function in Mapserver. The only geometry function to use in Expressions is area(shape). OGR sql doesn’t provide that either as far as I can see in the documentation. So the solutions might be to convert your KML data to sqlite or postgis where such functions are available. The length of a string (number of characters in the string) can be found in OGR sql with the length function, but I am assuming You are looking for the geometric length of the linestring. /Lars *From:* mapserver-users-boun...@lists.osgeo.org [ mailto:mapserver-users-boun...@lists.osgeo.org mapserver-users-boun...@lists.osgeo.org] *On Behalf Of *alok mathur *Sent:* den 13 mars 2015 07:01 *To:* mapserver-users@lists.osgeo.org *Subject:* [mapserver-users] Calculate length! Hi, I want to calculate the length in mapserver. Is it possible. Means i have a linestring and i want to know the length for it. Also not could be suggest me how to do it. I am using data source to mapserver as KML. Thanks! -- *Alok Mathur* ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- *Alok Mathur* | Software Engineer 2A | Ciena Mobile +91 9899413266 -- *Alok Mathur* | Software Engineer 2A | Ciena Mobile +91 9899413266 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users