[mapserver-users] Rendering OSM Data on Ubuntu 14.04 ?

2015-03-16 Thread Karma Kolabor 
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] How use a spatialite as tileindex for raster

2015-03-16 Thread Rahkonen Jukka (MML) 
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

2015-03-16 Thread Andrea Peri 
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!

2015-03-16 Thread Rahkonen Jukka (MML) 
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.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!

2015-03-16 Thread alok mathur 
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

Re: [mapserver-users] Calculate length!

2015-03-16 Thread Schylberg Lars 
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

[mapserver-users] polygon fill

2015-03-16 Thread rishi 
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;iwindow.parent.highlightnav('{0}','{1}');",
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!

2015-03-16 Thread alok mathur 
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
> ] *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