[Geoserver-users] How should i set output transparent color ='no color' in image mosaic plug in in Geo server version 2.1x?

[Umair Majoka]

hi

How can i set output transparent color ='no color' in image mosaic plug in in 
Geo server version 2.1x?
--
Master Java SE, Java EE, Eclipse, Spring, Hibernate, JavaScript, jQuery
and much more. Keep your Java skills current with LearnJavaNow -
200+ hours of step-by-step video tutorials by Java experts.
SALE $49.99 this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122612 ___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] How to upload a shape file in geoserver

[cmaul]

Krunal,

sorry ...GUI in *my application* which ... I skipped this bit.
As Stefano said the Rest interface, but I strongly recommend to copy the
local files to some infrastructure beforehand where you control whether the
hardware is running or not.



 Cheers

Christian



-


Dr Christian Maul
Project Manager

Information Services Branch
Department of Sustainability and Environment
Level13, Marland House, 570 Bourke Street
Melbourne 3000

PO Box 500, East Melbourne Vic 3002


Telephone:+61-3-8636 2325
Telefax:  +61-3-8636 2813
--
View this message in context: 
http://osgeo-org.1560.n6.nabble.com/How-to-upload-a-shape-file-in-geoserver-tp5026060p5026272.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] gs:Heatmap problems

[Martin Davis]

Actually the Heatmap process *does* allow specifying an attribute of the
input geometries to be used as a weighting attribute (parameter
"weightAttr" - see
http://suite.opengeo.org/opengeo-docs/cartography/rt/heatmap.html).  So
maybe you have what you need already!

This still doesn't address the original problem, because:

- the output range of the Heatmap is in [0,1], rather than the units of the
input attribute (and there's no obvious way of correlating the two, AFAIK)
- since Heatmap is a density surface, the maximum value at any single point
is less than the original input value at that point.  Barnes surface also
does a certain amount of averaging, but the effect is much less.

There's a good explanation by whuber of the difference between heatmaps and
interpolation surfaces in one of the comments of the gis.stackexchange
post.  Incidentally, after reading whuber's complaint about the misuse of
the term "Heatmap" I sort of wish I'd called the process KernelDensity
instead...

M

On Tue, Jan 8, 2013 at 1:44 PM, Rahkonen Jukka wrote:

> Hi,
>
> There are also use cases for density maps weighted by a value of some
> attribute like sum of dollars lost in traffic accidents. Barnes surfaces
> does not suit for this, nor unweighted density maps. I have been creating
> such visualisations with SAGA GIS and Sextante which both have functions
> for this but the result is a static image that does not suit well for a web
> map with large scale range.
> Discussion about this and one nice image in
> http://gis.stackexchange.com/questions/39074/whats-the-best-way-to-produce-a-density-map-from-weighted-points-in-qgis
>
> It would be nice to be able to do something similar dynamically with
> Geoserver.
>
> -Jukka Rahkonen-
>
> 
> Martin Davis wrote:
>
> +1 for everything Andrea said about Heatmaps - they are density maps, not
> interpolation surfaces.
>
> Also, the output values are in the range [0,1], which is another reason
> you saw only one color in your output.
>
> On Tue, Jan 8, 2013 at 6:17 AM, Andrea Aime  > wrote:
> On Tue, Jan 8, 2013 at 3:14 PM, Chris Haste  cha...@airdata.co.uk>> wrote:
> Hi Andrea,
>
> I’m not sure I understand. Are you saying that I don’t have a sufficient
> number of points in my data? I have a regular grid of points covering the
> entire globe at 1.25 x 1.25 degree intervals. Is this not dense enough?
>
> I'm saying a heatmap shows a color based on the different concentration of
> points, not their value, so if the grid is regular it's normal that
> you get a solid color.
>
> If you want to interpolate a value contained in the attributes of the
> points instead you have to use the Barnes surface instead.
> See some docs here:
> http://suite.opengeo.org/docs/cartography/rt/barnes.html
>
> Cheers
> Andrea
>
>
> From: andrea.a...@gmail.com [mailto:
> andrea.a...@gmail.com] On Behalf Of Andrea
> Aime
> Sent: 08 January 2013 14:09
> To: Chris Haste
> Cc: geoserver-users@lists.sourceforge.net geoserver-users@lists.sourceforge.net>
> Subject: Re: [Geoserver-users] gs:Heatmap problems
>
> On Tue, Jan 8, 2013 at 3:03 PM, Chris Haste  cha...@airdata.co.uk>> wrote:
> Hi List,
>
> I have been trying to use the new heatmap transformation in version 2.2.3
> but I think I must be doing something wrong.
> I wish to display a layer defined using an SQL view. The query simply
> returns a Grid of points and for each point there is a temperature value, I
> am using the round function in the query to round the temperature value to
> the nearest integer.
>
> I am using the SLD below, copied from the example and modified to
> (hopefully) work with my data. However, the entire map is produced in one
> colour (#00) but when I query the map by clicking on it in an
> Openlayers preview it shows correct values for the Temperatures and
> different locations on the map yield different values.
>
> Any ideas?
>
> Heatmaps are about point density, if you want to interpolation function
> you should look at the Barnes surface transformation
> instead
>
> Cheers
> Andrea
>
>
> --
> ==
> Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
> information.
> ==
>
> Ing. Andrea Aime
> @geowolf
> Technical Lead
>
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054  Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax: +39 0584 1660272
> mob: +39 339 8844549
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> ---
>
> *** This communication has been sent from World Fuel Services
>
> Corporation or its subsidiaries or its affiliates for the intended
> recipient
> only and may contain proprietary, confidential or privileged information.
> If you are not the intended recipient, any review, disclosure, copying,
> use, or distribution of the information included in this communication
> and any attachme

Re: [Geoserver-users] gs:Heatmap problems

[Rahkonen Jukka]

Hi,

There are also use cases for density maps weighted by a value of some attribute 
like sum of dollars lost in traffic accidents. Barnes surfaces does not suit 
for this, nor unweighted density maps. I have been creating such visualisations 
with SAGA GIS and Sextante which both have functions for this but the result is 
a static image that does not suit well for a web map with large scale range.
Discussion about this and one nice image in 
http://gis.stackexchange.com/questions/39074/whats-the-best-way-to-produce-a-density-map-from-weighted-points-in-qgis

It would be nice to be able to do something similar dynamically with Geoserver.

-Jukka Rahkonen-


Martin Davis wrote:

+1 for everything Andrea said about Heatmaps - they are density maps, not 
interpolation surfaces.

Also, the output values are in the range [0,1], which is another reason you saw 
only one color in your output.

On Tue, Jan 8, 2013 at 6:17 AM, Andrea Aime 
mailto:andrea.a...@geo-solutions.it>> wrote:
On Tue, Jan 8, 2013 at 3:14 PM, Chris Haste 
mailto:cha...@airdata.co.uk>> wrote:
Hi Andrea,

I’m not sure I understand. Are you saying that I don’t have a sufficient number 
of points in my data? I have a regular grid of points covering the entire globe 
at 1.25 x 1.25 degree intervals. Is this not dense enough?

I'm saying a heatmap shows a color based on the different concentration of 
points, not their value, so if the grid is regular it's normal that
you get a solid color.

If you want to interpolate a value contained in the attributes of the points 
instead you have to use the Barnes surface instead.
See some docs here: http://suite.opengeo.org/docs/cartography/rt/barnes.html

Cheers
Andrea


From: andrea.a...@gmail.com 
[mailto:andrea.a...@gmail.com] On Behalf Of 
Andrea Aime
Sent: 08 January 2013 14:09
To: Chris Haste
Cc: 
geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] gs:Heatmap problems

On Tue, Jan 8, 2013 at 3:03 PM, Chris Haste 
mailto:cha...@airdata.co.uk>> wrote:
Hi List,

I have been trying to use the new heatmap transformation in version 2.2.3 but I 
think I must be doing something wrong.
I wish to display a layer defined using an SQL view. The query simply returns a 
Grid of points and for each point there is a temperature value, I am using the 
round function in the query to round the temperature value to the nearest 
integer.

I am using the SLD below, copied from the example and modified to (hopefully) 
work with my data. However, the entire map is produced in one colour (#00) 
but when I query the map by clicking on it in an Openlayers preview it shows 
correct values for the Temperatures and different locations on the map yield 
different values.

Any ideas?

Heatmaps are about point density, if you want to interpolation function you 
should look at the Barnes surface transformation
instead

Cheers
Andrea


--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more 
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---

*** This communication has been sent from World Fuel Services

Corporation or its subsidiaries or its affiliates for the intended recipient
only and may contain proprietary, confidential or privileged information.
If you are not the intended recipient, any review, disclosure, copying,
use, or distribution of the information included in this communication
and any attachments is strictly prohibited. If you have received this
communication in error, please notify us immediately by replying to this
communication and delete the communication, including any
attachments, from your computer. Electronic communications sent to or
from World Fuel Services Corporation or its subsidiaries or its affiliates
may be monitored for quality assurance and compliance purposes.***



--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more 
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---

--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
_

Re: [Geoserver-users] gs:Heatmap problems

[Martin Davis]

To try and confirm if things are working you might try something like:

Scale = 3
Convergence = default
minObservations = default
maxObservationDistance = 0 (default) - at least initially to try and get
something to show up.  This is in units of the source CRS
pixelsPerCell = 4 (bigger number means faster computation)
queryBuffer = 0 (default; for test purposes, probably want to increase this
in final design)

Also, for testing it's best to view the output in the input CRS.  There
were some issues with reprojecting the output of RTs which were fixed
recently (not sure what GS version you are using).

If you can create a layer with a small subset of your data that would be
good too.  Even better, post it and your SLD so that others can try and
reproduce the problem.

Finally, it's possible there is some bug that is preventing the result from
being computed correctly.  Stepping through in the debugger is the only way
to check this.

On Tue, Jan 8, 2013 at 9:48 AM, Chris Haste  wrote:

> Thanks for the input Martin.
>
> ** **
>
> I can understand that 41K points may be an issue but even when I request a
> much smaller bounding box in order to significantly reduce the number of
> points being used I still don’t get anything displayed.
>
> ** **
>
> The data is a regular grid of points with a 1.25 x 1.25 degree spacing.
> The CRS is EPSG:4326. Would you be able to suggest suitable values for the
> other parameters, namely:
>
> Scale, convergence, minObservations, maxObservationDistance (not sure if
> this should be meters or degrees), pixelsPerCell and queryBuffer?
>
> ** **
>
> *From:* Martin Davis [mailto:mda...@opengeo.org]
> *Sent:* 08 January 2013 17:28
> *To:* Chris Haste
> *Cc:* Andrea Aime; geoserver-users@lists.sourceforge.net
>
> *Subject:* Re: [Geoserver-users] gs:Heatmap problems
>
> ** **
>
> Looks ok as far as it goes, but the other parameters are important as well.
> 
>
> ** **
>
> 41K points is probably pushing the bounds of BarnesSurface a bit too much.
>  it's really designed to interpolate relatively few scattered observations.
> 
>
> ** **
>
> If you have a regular grid of observations there's probably better and
> faster algorithms to use (although I'm not sure what would be the best
> choice.
>
> ** **
>
> ** **
>
> ** **
>
> On Tue, Jan 8, 2013 at 7:18 AM, Chris Haste  wrote:*
> ***
>
> Well my initial attempts at this are resulting in nothing being displayed,
> so I’d like to check whether I have some of the basics correct.
>
>  
>
> I have an SQL View Layer called TemperatureMap. The SQL in this view
> returns a table of two columns: location of type Point and temperature of
> type Float.
>
>  
>
> I have set the appropriate (I think) parts of the SLD as follows:
>
>
>  TemperatureMap
>  
>
> …
>
>
>
>
>  
>data
>  
>
> . . . 
>
>  
>valueAttr
>
>
>temperature
>  
>
>  
>
> Is this correct?
>
>  
>
> *From:* Chris Haste [mailto:cha...@airdata.co.uk]
> *Sent:* 08 January 2013 14:20
> *To:* Andrea Aime
>
>
> *Cc:* geoserver-users@lists.sourceforge.net
> *Subject:* Re: [Geoserver-users] gs:Heatmap problems
>
>  
>
> Ah!
>
>  
>
> Thanks Andrea, I will go and try that one!
>
>  
>
> *From:* andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] *On Behalf
> Of *Andrea Aime
> *Sent:* 08 January 2013 14:18
> *To:* Chris Haste
> *Cc:* geoserver-users@lists.sourceforge.net
> *Subject:* Re: [Geoserver-users] gs:Heatmap problems
>
>  
>
> On Tue, Jan 8, 2013 at 3:14 PM, Chris Haste  wrote:*
> ***
>
> Hi Andrea,
>
>  
>
> I’m not sure I understand. Are you saying that I don’t have a sufficient
> number of points in my data? I have a regular grid of points covering the
> entire globe at 1.25 x 1.25 degree intervals. Is this not dense enough?***
> *
>
>  
>
> I'm saying a heatmap shows a color based on the different concentration of
> points, not their value, so if the grid is regular it's normal that
>
> you get a solid color.
>
>  
>
> If you want to interpolate a value contained in the attributes of the
> points instead you have to use the Barnes surface instead.
>
> See some docs here:
> http://suite.opengeo.org/docs/cartography/rt/barnes.html
>
>  
>
> Cheers
>
> Andrea
>
>  
>
>  
>
> *From:* andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] *On Behalf
> Of *Andrea Aime
> *Sent:* 08 January 2013 14:09
> *To:* Chris Haste
> *Cc:* geoserver-users@lists.sourceforge.net
> *Subject:* Re: [Geoserver-users] gs:Heatmap problems
>
>  
>
> On Tue, Jan 8, 2013 at 3:03 PM, Chris Haste  wrote:*
> ***
>
> Hi List,
>
>  
>
> I have been trying to use the new heatmap transformation in version 2.2.3
> but I think I must be doing something wrong.
>
> I 

Re: [Geoserver-users] gs:Heatmap problems

[Chris Haste]

Thanks for the input Martin.

I can understand that 41K points may be an issue but even when I request a much 
smaller bounding box in order to significantly reduce the number of points 
being used I still don't get anything displayed.

The data is a regular grid of points with a 1.25 x 1.25 degree spacing. The CRS 
is EPSG:4326. Would you be able to suggest suitable values for the other 
parameters, namely:
Scale, convergence, minObservations, maxObservationDistance (not sure if this 
should be meters or degrees), pixelsPerCell and queryBuffer?

From: Martin Davis [mailto:mda...@opengeo.org]
Sent: 08 January 2013 17:28
To: Chris Haste
Cc: Andrea Aime; geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] gs:Heatmap problems

Looks ok as far as it goes, but the other parameters are important as well.

41K points is probably pushing the bounds of BarnesSurface a bit too much.  
it's really designed to interpolate relatively few scattered observations.

If you have a regular grid of observations there's probably better and faster 
algorithms to use (although I'm not sure what would be the best choice.



On Tue, Jan 8, 2013 at 7:18 AM, Chris Haste 
mailto:cha...@airdata.co.uk>> wrote:
Well my initial attempts at this are resulting in nothing being displayed, so 
I'd like to check whether I have some of the basics correct.

I have an SQL View Layer called TemperatureMap. The SQL in this view returns a 
table of two columns: location of type Point and temperature of type Float.

I have set the appropriate (I think) parts of the SLD as follows:
   
 TemperatureMap
 
...
   

 
   data
 
. . .
 
   valueAttr

   temperature
 

Is this correct?

From: Chris Haste [mailto:cha...@airdata.co.uk]
Sent: 08 January 2013 14:20
To: Andrea Aime

Cc: 
geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] gs:Heatmap problems

Ah!

Thanks Andrea, I will go and try that one!

From: andrea.a...@gmail.com 
[mailto:andrea.a...@gmail.com] On Behalf Of 
Andrea Aime
Sent: 08 January 2013 14:18
To: Chris Haste
Cc: 
geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] gs:Heatmap problems

On Tue, Jan 8, 2013 at 3:14 PM, Chris Haste 
mailto:cha...@airdata.co.uk>> wrote:
Hi Andrea,

I'm not sure I understand. Are you saying that I don't have a sufficient number 
of points in my data? I have a regular grid of points covering the entire globe 
at 1.25 x 1.25 degree intervals. Is this not dense enough?

I'm saying a heatmap shows a color based on the different concentration of 
points, not their value, so if the grid is regular it's normal that
you get a solid color.

If you want to interpolate a value contained in the attributes of the points 
instead you have to use the Barnes surface instead.
See some docs here: http://suite.opengeo.org/docs/cartography/rt/barnes.html

Cheers
Andrea


From: andrea.a...@gmail.com 
[mailto:andrea.a...@gmail.com] On Behalf Of 
Andrea Aime
Sent: 08 January 2013 14:09
To: Chris Haste
Cc: 
geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] gs:Heatmap problems

On Tue, Jan 8, 2013 at 3:03 PM, Chris Haste 
mailto:cha...@airdata.co.uk>> wrote:
Hi List,

I have been trying to use the new heatmap transformation in version 2.2.3 but I 
think I must be doing something wrong.
I wish to display a layer defined using an SQL view. The query simply returns a 
Grid of points and for each point there is a temperature value, I am using the 
round function in the query to round the temperature value to the nearest 
integer.

I am using the SLD below, copied from the example and modified to (hopefully) 
work with my data. However, the entire map is produced in one colour (#00) 
but when I query the map by clicking on it in an Openlayers preview it shows 
correct values for the Temperatures and different locations on the map yield 
different values.

Any ideas?

Heatmaps are about point density, if you want to interpolation function you 
should look at the Barnes surface transformation
instead

Cheers
Andrea


--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more 
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---

*** This communication has been sent from World Fuel Services
Corporation or its subsidiaries or its affiliates for the intended reci

Re: [Geoserver-users] gs:Heatmap problems

[Martin Davis]

+1 for everything Andrea said about Heatmaps - they are density maps, not
interpolation surfaces.

Also, the output values are in the range [0,1], which is another reason you
saw only one color in your output.

On Tue, Jan 8, 2013 at 6:17 AM, Andrea Aime wrote:

> On Tue, Jan 8, 2013 at 3:14 PM, Chris Haste  wrote:
>
>> Hi Andrea,
>>
>> ** **
>>
>> I’m not sure I understand. Are you saying that I don’t have a sufficient
>> number of points in my data? I have a regular grid of points covering the
>> entire globe at 1.25 x 1.25 degree intervals. Is this not dense enough?
>>
>
> I'm saying a heatmap shows a color based on the different concentration of
> points, not their value, so if the grid is regular it's normal that
> you get a solid color.
>
> If you want to interpolate a value contained in the attributes of the
> points instead you have to use the Barnes surface instead.
> See some docs here:
> http://suite.opengeo.org/docs/cartography/rt/barnes.html
>
> Cheers
> Andrea
>
>
>>  
>>
>> ** **
>>
>> *From:* andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] *On Behalf
>> Of *Andrea Aime
>> *Sent:* 08 January 2013 14:09
>> *To:* Chris Haste
>> *Cc:* geoserver-users@lists.sourceforge.net
>> *Subject:* Re: [Geoserver-users] gs:Heatmap problems
>>
>> ** **
>>
>> On Tue, Jan 8, 2013 at 3:03 PM, Chris Haste  wrote:
>> 
>>
>> Hi List,
>>
>>  
>>
>> I have been trying to use the new heatmap transformation in version 2.2.3
>> but I think I must be doing something wrong.
>>
>> I wish to display a layer defined using an SQL view. The query simply
>> returns a Grid of points and for each point there is a temperature value, I
>> am using the round function in the query to round the temperature value to
>> the nearest integer.
>>
>>  
>>
>> I am using the SLD below, copied from the example and modified to
>> (hopefully) work with my data. However, the entire map is produced in one
>> colour (#00) but when I query the map by clicking on it in an
>> Openlayers preview it shows correct values for the Temperatures and
>> different locations on the map yield different values.
>>
>>  
>>
>> Any ideas?
>>
>> ** **
>>
>> Heatmaps are about point density, if you want to interpolation function
>> you should look at the Barnes surface transformation
>>
>> instead
>>
>> ** **
>>
>> Cheers
>>
>> Andrea
>>
>>  
>>
>> ** **
>>
>> -- 
>>
>> ==
>>
>> Our support, Your Success! Visit http://opensdi.geo-solutions.it for
>> more information.
>>
>> ==
>>
>> ** **
>>
>> Ing. Andrea Aime 
>>
>> @geowolf
>>
>> Technical Lead
>>
>> ** **
>>
>> GeoSolutions S.A.S.
>>
>> Via Poggio alle Viti 1187
>>
>> 55054  Massarosa (LU)
>>
>> Italy
>>
>> phone: +39 0584 962313
>>
>> fax: +39 0584 1660272
>>
>> mob: +39  339 8844549
>>
>> ** **
>>
>> http://www.geo-solutions.it
>>
>> http://twitter.com/geosolutions_it
>>
>> ** **
>>
>> ---
>>
>> *** This communication has been sent from World Fuel Services
>>  Corporation or its subsidiaries or its affiliates for the intended
>> recipient
>> only and may contain proprietary, confidential or privileged information.
>> If you are not the intended recipient, any review, disclosure, copying,
>> use, or distribution of the information included in this communication
>> and any attachments is strictly prohibited. If you have received this
>> communication in error, please notify us immediately by replying to this
>> communication and delete the communication, including any
>> attachments, from your computer. Electronic communications sent to or
>> from World Fuel Services Corporation or its subsidiaries or its
>> affiliates
>> may be monitored for quality assurance and compliance purposes.***
>>
>>
>
>
> --
> ==
> Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
> information.
> ==
>
> Ing. Andrea Aime
> @geowolf
> Technical Lead
>
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054  Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax: +39 0584 1660272
> mob: +39  339 8844549
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> ---
>
>
> --
> Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
> and more. Get SQL Server skills now (including 2012) with LearnDevNow -
> 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
> SALE $99.99 this month only - learn more at:
> http://p.sf.net/sfu/learnmore_122512
> ___
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>


-- 
Martin Davis
OpenGeo - http://opengeo.org
Expert service straight from the developers.
-

Re: [Geoserver-users] gs:Heatmap problems

[Martin Davis]

Looks ok as far as it goes, but the other parameters are important as well.

41K points is probably pushing the bounds of BarnesSurface a bit too much.
 it's really designed to interpolate relatively few scattered observations.

If you have a regular grid of observations there's probably better and
faster algorithms to use (although I'm not sure what would be the best
choice.



On Tue, Jan 8, 2013 at 7:18 AM, Chris Haste  wrote:

> Well my initial attempts at this are resulting in nothing being displayed,
> so I’d like to check whether I have some of the basics correct.
>
> ** **
>
> I have an SQL View Layer called TemperatureMap. The SQL in this view
> returns a table of two columns: location of type Point and temperature of
> type Float.
>
> ** **
>
> I have set the appropriate (I think) parts of the SLD as follows:
>
>
>  TemperatureMap
>  
>
> …
>
>
>
>  
>data
>  
>
> . . . 
>
>  
>valueAttr
>
>temperature
>  
>
> ** **
>
> Is this correct?
>
> ** **
>
> *From:* Chris Haste [mailto:cha...@airdata.co.uk]
> *Sent:* 08 January 2013 14:20
> *To:* Andrea Aime
>
> *Cc:* geoserver-users@lists.sourceforge.net
> *Subject:* Re: [Geoserver-users] gs:Heatmap problems
>
> ** **
>
> Ah!
>
> ** **
>
> Thanks Andrea, I will go and try that one!
>
> ** **
>
> *From:* andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] *On Behalf
> Of *Andrea Aime
> *Sent:* 08 January 2013 14:18
> *To:* Chris Haste
> *Cc:* geoserver-users@lists.sourceforge.net
> *Subject:* Re: [Geoserver-users] gs:Heatmap problems
>
> ** **
>
> On Tue, Jan 8, 2013 at 3:14 PM, Chris Haste  wrote:*
> ***
>
> Hi Andrea,
>
>  
>
> I’m not sure I understand. Are you saying that I don’t have a sufficient
> number of points in my data? I have a regular grid of points covering the
> entire globe at 1.25 x 1.25 degree intervals. Is this not dense enough?***
> *
>
> ** **
>
> I'm saying a heatmap shows a color based on the different concentration of
> points, not their value, so if the grid is regular it's normal that
>
> you get a solid color.
>
> ** **
>
> If you want to interpolate a value contained in the attributes of the
> points instead you have to use the Barnes surface instead.
>
> See some docs here:
> http://suite.opengeo.org/docs/cartography/rt/barnes.html
>
> ** **
>
> Cheers
>
> Andrea
>
>  
>
>  
>
> *From:* andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] *On Behalf
> Of *Andrea Aime
> *Sent:* 08 January 2013 14:09
> *To:* Chris Haste
> *Cc:* geoserver-users@lists.sourceforge.net
> *Subject:* Re: [Geoserver-users] gs:Heatmap problems
>
>  
>
> On Tue, Jan 8, 2013 at 3:03 PM, Chris Haste  wrote:*
> ***
>
> Hi List,
>
>  
>
> I have been trying to use the new heatmap transformation in version 2.2.3
> but I think I must be doing something wrong.
>
> I wish to display a layer defined using an SQL view. The query simply
> returns a Grid of points and for each point there is a temperature value, I
> am using the round function in the query to round the temperature value to
> the nearest integer.
>
>  
>
> I am using the SLD below, copied from the example and modified to
> (hopefully) work with my data. However, the entire map is produced in one
> colour (#00) but when I query the map by clicking on it in an
> Openlayers preview it shows correct values for the Temperatures and
> different locations on the map yield different values.
>
>  
>
> Any ideas?
>
>  
>
> Heatmaps are about point density, if you want to interpolation function
> you should look at the Barnes surface transformation
>
> instead
>
>  
>
> Cheers
>
> Andrea
>
>  
>
>  
>
> -- 
>
> ==
>
> Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
> information.
>
> ==
>
>  
>
> Ing. Andrea Aime 
>
> @geowolf
>
> Technical Lead
>
>  
>
> GeoSolutions S.A.S.
>
> Via Poggio alle Viti 1187
>
> 55054  Massarosa (LU)
>
> Italy
>
> phone: +39 0584 962313
>
> fax: +39 0584 1660272
>
> mob: +39  339 8844549
>
>  
>
> http://www.geo-solutions.it
>
> http://twitter.com/geosolutions_it
>
>  
>
> ---
>
> *** This communication has been sent from World Fuel Services 
>
> Corporation or its subsidiaries or its affiliates for the intended
> recipient
> only and may contain proprietary, confidential or privileged information.
> If you are not the intended recipient, any review, disclosure, copying,
> use, or distribution of the information included in this communication
> and any attachments is strictly prohibited. If you have received this
> communication in error, please notify us immediately by replying to this
> c

Re: [Geoserver-users] gs:Heatmap problems

[Chris Haste]

Another thing that may be a problem is the size of my dataset.. Worldwide it 
consists of 41,760 points. Is this too large a number for the Transformation to 
handle?

From: Chris Haste
Sent: 08 January 2013 15:18
To: Chris Haste; Andrea Aime
Cc: geoserver-users@lists.sourceforge.net
Subject: RE: [Geoserver-users] gs:Heatmap problems

Well my initial attempts at this are resulting in nothing being displayed, so 
I'd like to check whether I have some of the basics correct.

I have an SQL View Layer called TemperatureMap. The SQL in this view returns a 
table of two columns: location of type Point and temperature of type Float.

I have set the appropriate (I think) parts of the SLD as follows:
   
 TemperatureMap
 
...
   
 
   data
 
. . .
 
   valueAttr
   temperature
 

Is this correct?

From: Chris Haste [mailto:cha...@airdata.co.uk]
Sent: 08 January 2013 14:20
To: Andrea Aime
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] gs:Heatmap problems

Ah!

Thanks Andrea, I will go and try that one!

From: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] On Behalf Of Andrea 
Aime
Sent: 08 January 2013 14:18
To: Chris Haste
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] gs:Heatmap problems

On Tue, Jan 8, 2013 at 3:14 PM, Chris Haste 
mailto:cha...@airdata.co.uk>> wrote:
Hi Andrea,

I'm not sure I understand. Are you saying that I don't have a sufficient number 
of points in my data? I have a regular grid of points covering the entire globe 
at 1.25 x 1.25 degree intervals. Is this not dense enough?

I'm saying a heatmap shows a color based on the different concentration of 
points, not their value, so if the grid is regular it's normal that
you get a solid color.

If you want to interpolate a value contained in the attributes of the points 
instead you have to use the Barnes surface instead.
See some docs here: http://suite.opengeo.org/docs/cartography/rt/barnes.html

Cheers
Andrea


From: andrea.a...@gmail.com 
[mailto:andrea.a...@gmail.com] On Behalf Of 
Andrea Aime
Sent: 08 January 2013 14:09
To: Chris Haste
Cc: 
geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] gs:Heatmap problems

On Tue, Jan 8, 2013 at 3:03 PM, Chris Haste 
mailto:cha...@airdata.co.uk>> wrote:
Hi List,

I have been trying to use the new heatmap transformation in version 2.2.3 but I 
think I must be doing something wrong.
I wish to display a layer defined using an SQL view. The query simply returns a 
Grid of points and for each point there is a temperature value, I am using the 
round function in the query to round the temperature value to the nearest 
integer.

I am using the SLD below, copied from the example and modified to (hopefully) 
work with my data. However, the entire map is produced in one colour (#00) 
but when I query the map by clicking on it in an Openlayers preview it shows 
correct values for the Temperatures and different locations on the map yield 
different values.

Any ideas?

Heatmaps are about point density, if you want to interpolation function you 
should look at the Barnes surface transformation
instead

Cheers
Andrea


--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more 
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---

*** This communication has been sent from World Fuel Services
Corporation or its subsidiaries or its affiliates for the intended recipient
only and may contain proprietary, confidential or privileged information.
If you are not the intended recipient, any review, disclosure, copying,
use, or distribution of the information included in this communication
and any attachments is strictly prohibited. If you have received this
communication in error, please notify us immediately by replying to this
communication and delete the communication, including any
attachments, from your computer. Electronic communications sent to or
from World Fuel Services Corporation or its subsidiaries or its affiliates
may be monitored for quality assurance and compliance purposes.***



--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more 
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---
--

Re: [Geoserver-users] gs:Heatmap problems

[Chris Haste]

Well my initial attempts at this are resulting in nothing being displayed, so 
I'd like to check whether I have some of the basics correct.

I have an SQL View Layer called TemperatureMap. The SQL in this view returns a 
table of two columns: location of type Point and temperature of type Float.

I have set the appropriate (I think) parts of the SLD as follows:
   
 TemperatureMap
 
...
   
 
   data
 
. . .
 
   valueAttr
   temperature
 

Is this correct?

From: Chris Haste [mailto:cha...@airdata.co.uk]
Sent: 08 January 2013 14:20
To: Andrea Aime
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] gs:Heatmap problems

Ah!

Thanks Andrea, I will go and try that one!

From: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] On Behalf Of Andrea 
Aime
Sent: 08 January 2013 14:18
To: Chris Haste
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] gs:Heatmap problems

On Tue, Jan 8, 2013 at 3:14 PM, Chris Haste 
mailto:cha...@airdata.co.uk>> wrote:
Hi Andrea,

I'm not sure I understand. Are you saying that I don't have a sufficient number 
of points in my data? I have a regular grid of points covering the entire globe 
at 1.25 x 1.25 degree intervals. Is this not dense enough?

I'm saying a heatmap shows a color based on the different concentration of 
points, not their value, so if the grid is regular it's normal that
you get a solid color.

If you want to interpolate a value contained in the attributes of the points 
instead you have to use the Barnes surface instead.
See some docs here: http://suite.opengeo.org/docs/cartography/rt/barnes.html

Cheers
Andrea


From: andrea.a...@gmail.com 
[mailto:andrea.a...@gmail.com] On Behalf Of 
Andrea Aime
Sent: 08 January 2013 14:09
To: Chris Haste
Cc: 
geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] gs:Heatmap problems

On Tue, Jan 8, 2013 at 3:03 PM, Chris Haste 
mailto:cha...@airdata.co.uk>> wrote:
Hi List,

I have been trying to use the new heatmap transformation in version 2.2.3 but I 
think I must be doing something wrong.
I wish to display a layer defined using an SQL view. The query simply returns a 
Grid of points and for each point there is a temperature value, I am using the 
round function in the query to round the temperature value to the nearest 
integer.

I am using the SLD below, copied from the example and modified to (hopefully) 
work with my data. However, the entire map is produced in one colour (#00) 
but when I query the map by clicking on it in an Openlayers preview it shows 
correct values for the Temperatures and different locations on the map yield 
different values.

Any ideas?

Heatmaps are about point density, if you want to interpolation function you 
should look at the Barnes surface transformation
instead

Cheers
Andrea


--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more 
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---

*** This communication has been sent from World Fuel Services
Corporation or its subsidiaries or its affiliates for the intended recipient
only and may contain proprietary, confidential or privileged information.
If you are not the intended recipient, any review, disclosure, copying,
use, or distribution of the information included in this communication
and any attachments is strictly prohibited. If you have received this
communication in error, please notify us immediately by replying to this
communication and delete the communication, including any
attachments, from your computer. Electronic communications sent to or
from World Fuel Services Corporation or its subsidiaries or its affiliates
may be monitored for quality assurance and compliance purposes.***



--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more 
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/le

Re: [Geoserver-users] Urgent: IEEERemainder Issue

[David Winslow]

If you just want to control how close together labels may appear, then it
might be possible to use extra labelling parameters in your style instead
of filtering the data.
The "spaceAround" parameter would probably be a good first place to look:
http://docs.geoserver.org/stable/en/user/styling/sld-reference/labeling.html#overlapping-and-separating-labels-vendoroption-name-spacearound
It's called "-gt-label-padding" in CSS.

--
David Winslow
OpenGeo - http://opengeo.org/



On Tue, Jan 8, 2013 at 5:54 AM, Chris Haste  wrote:

> Hi Andrea,
>
> ** **
>
> Yes, that is the one I meant.  We can try that build tomorrow.
>
> ** **
>
> Is there a better way of doing this though? Without using the
> IEEERemainder function?
>
> ** **
>
> *From:* andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] *On Behalf
> Of *Andrea Aime
> *Sent:* 08 January 2013 10:43
> *To:* Chris Haste
> *Cc:* geoserver-users@lists.sourceforge.net
> *Subject:* Re: [Geoserver-users] Urgent: IEEERemainder Issue
>
> ** **
>
> On Tue, Jan 8, 2013 at 11:16 AM, Chris Haste  wrote:
> 
>
> Hello all,
>
>  
>
> We have recently upgraded to version 2.2.3 and as a result some of our
> SLD’s which use the IEEERemainder function no longer work. Having had a
> quick search I can see that there is a bug report listed for this back in
> Oct-2012 (we are also using an SQL layer from a PostGres DB)
>
> ** **
>
> You mean this one?
>
> http://jira.codehaus.org/browse/GEOS-5338
>
> ** **
>
> I believe I've just fixed it, can you give tomorrow's (Jan 9) nightly
> build a try when it's out?
>
> http://gridlock.opengeo.org/geoserver/2.2.x/
>
> ** **
>
> Cheers
>
> Andrea
>
>  
>
> -- 
>
> ==
>
> Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
> information.
>
> ==
>
> ** **
>
> Ing. Andrea Aime 
>
> @geowolf
>
> Technical Lead
>
> ** **
>
> GeoSolutions S.A.S.
>
> Via Poggio alle Viti 1187
>
> 55054  Massarosa (LU)
>
> Italy
>
> phone: +39 0584 962313
>
> fax: +39 0584 1660272
>
> mob: +39  339 8844549
>
> ** **
>
> http://www.geo-solutions.it
>
> http://twitter.com/geosolutions_it
>
> ** **
>
> ---
>
> *** This communication has been sent from World Fuel Services
> Corporation or its subsidiaries or its affiliates for the intended
> recipient
> only and may contain proprietary, confidential or privileged information.
> If you are not the intended recipient, any review, disclosure, copying,
> use, or distribution of the information included in this communication
> and any attachments is strictly prohibited. If you have received this
> communication in error, please notify us immediately by replying to this
> communication and delete the communication, including any
> attachments, from your computer. Electronic communications sent to or
> from World Fuel Services Corporation or its subsidiaries or its affiliates
> may be monitored for quality assurance and compliance purposes.***
>
>
>
> --
> Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
> and more. Get SQL Server skills now (including 2012) with LearnDevNow -
> 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
> SALE $99.99 this month only - learn more at:
> http://p.sf.net/sfu/learnmore_122512
> ___
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] gs:Heatmap problems

[Chris Haste]

Ah!

Thanks Andrea, I will go and try that one!

From: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] On Behalf Of Andrea 
Aime
Sent: 08 January 2013 14:18
To: Chris Haste
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] gs:Heatmap problems

On Tue, Jan 8, 2013 at 3:14 PM, Chris Haste 
mailto:cha...@airdata.co.uk>> wrote:
Hi Andrea,

I'm not sure I understand. Are you saying that I don't have a sufficient number 
of points in my data? I have a regular grid of points covering the entire globe 
at 1.25 x 1.25 degree intervals. Is this not dense enough?

I'm saying a heatmap shows a color based on the different concentration of 
points, not their value, so if the grid is regular it's normal that
you get a solid color.

If you want to interpolate a value contained in the attributes of the points 
instead you have to use the Barnes surface instead.
See some docs here: http://suite.opengeo.org/docs/cartography/rt/barnes.html

Cheers
Andrea


From: andrea.a...@gmail.com 
[mailto:andrea.a...@gmail.com] On Behalf Of 
Andrea Aime
Sent: 08 January 2013 14:09
To: Chris Haste
Cc: 
geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] gs:Heatmap problems

On Tue, Jan 8, 2013 at 3:03 PM, Chris Haste 
mailto:cha...@airdata.co.uk>> wrote:
Hi List,

I have been trying to use the new heatmap transformation in version 2.2.3 but I 
think I must be doing something wrong.
I wish to display a layer defined using an SQL view. The query simply returns a 
Grid of points and for each point there is a temperature value, I am using the 
round function in the query to round the temperature value to the nearest 
integer.

I am using the SLD below, copied from the example and modified to (hopefully) 
work with my data. However, the entire map is produced in one colour (#00) 
but when I query the map by clicking on it in an Openlayers preview it shows 
correct values for the Temperatures and different locations on the map yield 
different values.

Any ideas?

Heatmaps are about point density, if you want to interpolation function you 
should look at the Barnes surface transformation
instead

Cheers
Andrea


--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more 
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---

*** This communication has been sent from World Fuel Services
Corporation or its subsidiaries or its affiliates for the intended recipient
only and may contain proprietary, confidential or privileged information.
If you are not the intended recipient, any review, disclosure, copying,
use, or distribution of the information included in this communication
and any attachments is strictly prohibited. If you have received this
communication in error, please notify us immediately by replying to this
communication and delete the communication, including any
attachments, from your computer. Electronic communications sent to or
from World Fuel Services Corporation or its subsidiaries or its affiliates
may be monitored for quality assurance and compliance purposes.***



--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more 
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] gs:Heatmap problems

[Andrea Aime]

On Tue, Jan 8, 2013 at 3:14 PM, Chris Haste  wrote:

> Hi Andrea,
>
> ** **
>
> I’m not sure I understand. Are you saying that I don’t have a sufficient
> number of points in my data? I have a regular grid of points covering the
> entire globe at 1.25 x 1.25 degree intervals. Is this not dense enough?
>

I'm saying a heatmap shows a color based on the different concentration of
points, not their value, so if the grid is regular it's normal that
you get a solid color.

If you want to interpolate a value contained in the attributes of the
points instead you have to use the Barnes surface instead.
See some docs here: http://suite.opengeo.org/docs/cartography/rt/barnes.html

Cheers
Andrea


> 
>
> ** **
>
> *From:* andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] *On Behalf
> Of *Andrea Aime
> *Sent:* 08 January 2013 14:09
> *To:* Chris Haste
> *Cc:* geoserver-users@lists.sourceforge.net
> *Subject:* Re: [Geoserver-users] gs:Heatmap problems
>
> ** **
>
> On Tue, Jan 8, 2013 at 3:03 PM, Chris Haste  wrote:*
> ***
>
> Hi List,
>
>  
>
> I have been trying to use the new heatmap transformation in version 2.2.3
> but I think I must be doing something wrong.
>
> I wish to display a layer defined using an SQL view. The query simply
> returns a Grid of points and for each point there is a temperature value, I
> am using the round function in the query to round the temperature value to
> the nearest integer.
>
>  
>
> I am using the SLD below, copied from the example and modified to
> (hopefully) work with my data. However, the entire map is produced in one
> colour (#00) but when I query the map by clicking on it in an
> Openlayers preview it shows correct values for the Temperatures and
> different locations on the map yield different values.
>
>  
>
> Any ideas?
>
> ** **
>
> Heatmaps are about point density, if you want to interpolation function
> you should look at the Barnes surface transformation
>
> instead
>
> ** **
>
> Cheers
>
> Andrea
>
>  
>
> ** **
>
> -- 
>
> ==
>
> Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
> information.
>
> ==
>
> ** **
>
> Ing. Andrea Aime 
>
> @geowolf
>
> Technical Lead
>
> ** **
>
> GeoSolutions S.A.S.
>
> Via Poggio alle Viti 1187
>
> 55054  Massarosa (LU)
>
> Italy
>
> phone: +39 0584 962313
>
> fax: +39 0584 1660272
>
> mob: +39  339 8844549
>
> ** **
>
> http://www.geo-solutions.it
>
> http://twitter.com/geosolutions_it
>
> ** **
>
> ---
>
> *** This communication has been sent from World Fuel Services
> Corporation or its subsidiaries or its affiliates for the intended
> recipient
> only and may contain proprietary, confidential or privileged information.
> If you are not the intended recipient, any review, disclosure, copying,
> use, or distribution of the information included in this communication
> and any attachments is strictly prohibited. If you have received this
> communication in error, please notify us immediately by replying to this
> communication and delete the communication, including any
> attachments, from your computer. Electronic communications sent to or
> from World Fuel Services Corporation or its subsidiaries or its affiliates
> may be monitored for quality assurance and compliance purposes.***
>
>


-- 
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] gs:Heatmap problems

[Chris Haste]

Hi Andrea,

I'm not sure I understand. Are you saying that I don't have a sufficient number 
of points in my data? I have a regular grid of points covering the entire globe 
at 1.25 x 1.25 degree intervals. Is this not dense enough?

From: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] On Behalf Of Andrea 
Aime
Sent: 08 January 2013 14:09
To: Chris Haste
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] gs:Heatmap problems

On Tue, Jan 8, 2013 at 3:03 PM, Chris Haste 
mailto:cha...@airdata.co.uk>> wrote:
Hi List,

I have been trying to use the new heatmap transformation in version 2.2.3 but I 
think I must be doing something wrong.
I wish to display a layer defined using an SQL view. The query simply returns a 
Grid of points and for each point there is a temperature value, I am using the 
round function in the query to round the temperature value to the nearest 
integer.

I am using the SLD below, copied from the example and modified to (hopefully) 
work with my data. However, the entire map is produced in one colour (#00) 
but when I query the map by clicking on it in an Openlayers preview it shows 
correct values for the Temperatures and different locations on the map yield 
different values.

Any ideas?

Heatmaps are about point density, if you want to interpolation function you 
should look at the Barnes surface transformation
instead

Cheers
Andrea


--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more 
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---
*** This communication has been sent from World Fuel Services 
Corporation or its subsidiaries or its affiliates for the intended recipient 
only and may contain proprietary, confidential or privileged information. 
If you are not the intended recipient, any review, disclosure, copying, 
use, or distribution of the information included in this communication 
and any attachments is strictly prohibited. If you have received this 
communication in error, please notify us immediately by replying to this 
communication and delete the communication, including any 
attachments, from your computer. Electronic communications sent to or 
from World Fuel Services Corporation or its subsidiaries or its affiliates 
may be monitored for quality assurance and compliance purposes.***

--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] gs:Heatmap problems

[Andrea Aime]

On Tue, Jan 8, 2013 at 3:03 PM, Chris Haste  wrote:

> Hi List,
>
> ** **
>
> I have been trying to use the new heatmap transformation in version 2.2.3
> but I think I must be doing something wrong.
>
> I wish to display a layer defined using an SQL view. The query simply
> returns a Grid of points and for each point there is a temperature value, I
> am using the round function in the query to round the temperature value to
> the nearest integer.
>
> ** **
>
> I am using the SLD below, copied from the example and modified to
> (hopefully) work with my data. However, the entire map is produced in one
> colour (#00) but when I query the map by clicking on it in an
> Openlayers preview it shows correct values for the Temperatures and
> different locations on the map yield different values.
>
> ** **
>
> Any ideas?
>

Heatmaps are about point density, if you want to interpolation function you
should look at the Barnes surface transformation
instead

Cheers
Andrea


-- 
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[Geoserver-users] gs:Heatmap problems

[Chris Haste]

Hi List,

I have been trying to use the new heatmap transformation in version 2.2.3 but I 
think I must be doing something wrong.
I wish to display a layer defined using an SQL view. The query simply returns a 
Grid of points and for each point there is a temperature value, I am using the 
round function in the query to round the temperature value to the nearest 
integer.

I am using the SLD below, copied from the example and modified to (hopefully) 
work with my data. However, the entire map is produced in one colour (#00) 
but when I query the map by clicking on it in an Openlayers preview it shows 
correct values for the Temperatures and different locations on the map yield 
different values.

Any ideas?


http://www.opengis.net/sld StyledLayerDescriptor.xsd"   
 xmlns="http://www.opengis.net/sld";
xmlns:ogc="http://www.opengis.net/ogc";
xmlns:xlink="http://www.w3.org/1999/xlink"; 
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
  
Heatmap

  Heatmap
A heatmap showing upper air temperature

  

  
data
  
  
weightAttr
temperature
  
  
radiusPixels

  radius
  100

  
  
pixelsPerCell
10
  
  
outputBBOX

  wms_bbox

  
  
outputWidth

  wms_width

  
  
outputHeight

  wms_height

  

  
  

  
  
location
  
  0.6
  











  

  

  


*** This communication has been sent from World Fuel Services 
Corporation or its subsidiaries or its affiliates for the intended recipient 
only and may contain proprietary, confidential or privileged information. 
If you are not the intended recipient, any review, disclosure, copying, 
use, or distribution of the information included in this communication 
and any attachments is strictly prohibited. If you have received this 
communication in error, please notify us immediately by replying to this 
communication and delete the communication, including any 
attachments, from your computer. Electronic communications sent to or 
from World Fuel Services Corporation or its subsidiaries or its affiliates 
may be monitored for quality assurance and compliance purposes.***

--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Geoserver Jasper Report

[Andrea Aime]

On Tue, Jan 8, 2013 at 12:51 PM, Gülsün Sahin wrote:

> Hi,
>
> can we integrate geoserver and jasper? is it possible?
> Could you give me some infos or documentations about it?
>

Err.. by developing some new code many things are possible, including I
believe
creating reports out of spatial data via jasper reports.
However, I believe there is no docs on how to do that, but you can have
a look at the existing code and learn from it, search for the WFS output
formats, assuming what you want to do is creare reports out of
spatial vector data

Cheers
Andrea


-- 
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Rasters, Tiles, and FME

[Jonathan Moules]

Hi Simone,
Thanks for the information.

The best for resampling was "Average", as it produced the smoothest image
for the pyramids, at least with all of the Ordnance Survey products I've
processed.

Number of Tiles:
I think some sort of guide may be useful. I appreciate the numbers used
will have to change depending on the latency of disk access, but some broad
over-arching numbers could be created.
For example, my largest GeoTIFF has about 56,488 inner tiles (512*512
pixels) at the root layer and subjectively at least, there's a slight lag
when serving that compared to other layers which have far fewer. It's
2.87GB with pyramids, tiles and DEFLATEd, so still quite small.

Regards,
Jonathan


On 8 January 2013 08:53, Simone Giannecchini <
simone.giannecch...@geo-solutions.it> wrote:

> Ciao Jonathan,
> please, read my answers inline below
>
> Regards,
> Simone Giannecchini
> ==
> Our support, Your Success! Visit http://opensdi.geo-solutions.it for
> more information.
> ==
>
> Ing. Simone Giannecchini
> @simogeo
> Founder/Director
>
> GeoSolutions S.A.S.
> Via Poggio alle Viti 1187
> 55054  Massarosa (LU)
> Italy
> phone: +39 0584 962313
> fax: +39 0584 1660272
> mob:   +39  333 8128928
>
> http://www.geo-solutions.it
> http://twitter.com/geosolutions_it
>
> ---
>
>
> On Wed, Jan 2, 2013 at 5:12 PM, Jonathan Moules
>  wrote:
> > Hey Simone,
> >
> > Thanks for your thorough reply. Useful!
> >
> > - Resampling:
> > I've done some experimenting with Resampling since my email and, at least
> > for the data I was testing, Nearest Neighbour came out best (though
> > obviously entirely subjective). This was for a regular RGB map (Ordnance
> > Survey MiniScale specifically). There was also a significant difference
> in
> > file sizes, with Nearest Neighbour being the smallest, and Cubic being
> the
> > largest (double!). I didn't expect such a significant difference, may be
> > worth noting somewhere.
>
> I belive your data comprises of raster with colormap (i.e each pixel
> points to an index in a colormap rather than being a real value). In
> this case the only interpolation that will retain the colormap will be
> nearest neighbor. If you apply higher order interpolation (i.e
> bilinear and so on) that do need to mash-up somehow adiacent values
> then we need to perform a color expansion which will transform the
> image from 1 band to as many band as the color model has (3 for RGB
> images). Hence the image size will explode per-se.
>
> >
> > - External Overviews:
> > Thanks, but I'd found out how to create them with GDAL. My issue is -
> how do
> > I get GeoServer to use them? Does it just pick them up automatically or
> do I
> > need some sort of particular directory structure?
> > GDAL seems to create a single, absurdly huge file, so I guess it doesn't
> > compress the external overviews. Based on what I'm seeing, I'm not sure
> if
> > FME can create them; I expected multiple separate files (one for each
> > layer), but the "external overviews" are basically identical to internal
> > overviews but minus the source data.
>
> If you are publishing single geotiff files GeoServer should use them
> automcatically, if you are using ImageMosaic, currently there is no
> way to use them.
>
> >
> > -Overviews:
> > How do you determine how many levels to create? I remember this page from
> > years ago when last I used GeoServer:
> >
> http://docs.geoserver.org/stable/en/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html#how-many-pyramids-are-needed
> > - does this carry over to GeoTIFF's overviews?
> > I may be reading this wrong, but the example in the PDF has 7 layers but
> > only really needs about 3 as after that they're smaller than the 1:1
> tiles.
>
> I had a cursory look at the formula and seems correct.
>
> >
> > Is there any point in creating pyramids with a value of 1 (as in, 1 2 4
> > 8...) ? GDAL lets you do this but if I'm understanding this correctly,
> > they're entirely superfluous (I mention it because Russ's example he
> > generously posted starts at 1).
>
> You usually do that to retile/compress/colorconvert high resolution level.
>
> >
> >
> > Tile size:
> > Might there be a formula for calculating optimal size?
> > For example, if I have a 94488*157480 pixel GeoTIFF (my largest - about
> > 2.5GB compressed), if I divide them by 512 I get
> > 184*307 tiles = 56,488 tiles
> >
> > For 256 I get:
> > 368*614 tiles = 225,952 tiles
> >
> > So if there is/was a formula, it might be easier to figure out what size
> to
> > go with, or at what point you'd want to be scaling up to ImageMosaic.
> > Based on disk seeks etc, and some experimentation, I'd guess that a
> number
> > could be contrived allowing the documentation to say:
> > "If you end up with > X,000 tiles, go with ImageMosiac" and "Aim for
> between
> > X,000 and X0,000 tiles in a GeoTIFF"
> > Just a thought, would be helpful for optimisation.
>
> Well, I guess this is part of 

[Geoserver-users] How should i set output transparent color ='no color' in image mosaic plug in in Geo server version 2.1x?

[Umair Majoka]

How should i set output transparent color ='no color' in image mosaic plug in 
in Geo server version 2.1x?--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[Geoserver-users] Geoserver Jasper Report

[Gülsün Sahin]

Hi,

can we integrate geoserver and jasper? is it possible?
Could you give me some infos or documentations about it?

thanks in advance,
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Urgent: IEEERemainder Issue

[Chris Haste]

Hi Andrea,

Yes, that is the one I meant.  We can try that build tomorrow.

Is there a better way of doing this though? Without using the IEEERemainder 
function?

From: andrea.a...@gmail.com [mailto:andrea.a...@gmail.com] On Behalf Of Andrea 
Aime
Sent: 08 January 2013 10:43
To: Chris Haste
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Urgent: IEEERemainder Issue

On Tue, Jan 8, 2013 at 11:16 AM, Chris Haste 
mailto:cha...@airdata.co.uk>> wrote:
Hello all,

We have recently upgraded to version 2.2.3 and as a result some of our SLD's 
which use the IEEERemainder function no longer work. Having had a quick search 
I can see that there is a bug report listed for this back in Oct-2012 (we are 
also using an SQL layer from a PostGres DB)

You mean this one?
http://jira.codehaus.org/browse/GEOS-5338

I believe I've just fixed it, can you give tomorrow's (Jan 9) nightly build a 
try when it's out?
http://gridlock.opengeo.org/geoserver/2.2.x/

Cheers
Andrea

--
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more 
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---
*** This communication has been sent from World Fuel Services 
Corporation or its subsidiaries or its affiliates for the intended recipient 
only and may contain proprietary, confidential or privileged information. 
If you are not the intended recipient, any review, disclosure, copying, 
use, or distribution of the information included in this communication 
and any attachments is strictly prohibited. If you have received this 
communication in error, please notify us immediately by replying to this 
communication and delete the communication, including any 
attachments, from your computer. Electronic communications sent to or 
from World Fuel Services Corporation or its subsidiaries or its affiliates 
may be monitored for quality assurance and compliance purposes.***

--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Urgent: IEEERemainder Issue

[Andrea Aime]

On Tue, Jan 8, 2013 at 11:16 AM, Chris Haste  wrote:

> Hello all,
>
> ** **
>
> We have recently upgraded to version 2.2.3 and as a result some of our
> SLD’s which use the IEEERemainder function no longer work. Having had a
> quick search I can see that there is a bug report listed for this back in
> Oct-2012 (we are also using an SQL layer from a PostGres DB)
>

You mean this one?
http://jira.codehaus.org/browse/GEOS-5338

I believe I've just fixed it, can you give tomorrow's (Jan 9) nightly build
a try when it's out?
http://gridlock.opengeo.org/geoserver/2.2.x/

Cheers
Andrea

-- 
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Rasters, Tiles, and FME

[Jonathan Moules]

Hi Jukka,
Thanks for the reply. DEFLATE is definitely the best compression for
Ordnance Survey maps, much smaller than LZW.

For reference, a scale factor of "1" does create pyramids in an internal
file (I tested it, hence my querying), and as you say, they seem to be
entirely superfluous.

Jonathan


On 7 January 2013 21:03, Rahkonen Jukka  wrote:

> Hi,
>
> About absurdly large GDAL overview file, it is so big because you ask GDAL
> to create it for you as uncompressed. Gdaladdo document page has an example
> about how to create compressed overviews.
> Page: http://www.gdal.org/gdaladdo.html
> Example:
>
> gdaladdo --config COMPRESS_OVERVIEW JPEG --config PHOTOMETRIC_OVERVIEW
> YCBCR
>  --config INTERLEAVE_OVERVIEW PIXEL rgb_dataset.ext 2 4 8 16
>
> That's good for aerial images. For Ordnance Survey rasters I guess
> --config COMPRESS_OVERVIEW DEFLATE would suit best.
>
> About number of levels, if your original has 16 pixels start dividing
> it by 2:
> 8, 4, 2, 1, 5000, 2500, 1250, 625, 312, 156 STOP
> Thus, create 10 (or 9) overview levels starting as 2 4 8...
> I am not sure but I think that 1 2 4 8 ... will lead to the same result
> because factor 1 overview level exists and it will not be created at least
> as internal overviews (the original data) but you can easily test it
> yourself. Anyway, factor 1 overview does not make sense so you can safely
> start from 2 just as you were thinking.
>
> -Jukka Rahkonen-
> 

> Lähettäjä: Jonathan Moules [jonathanmou...@warwickshire.gov.uk]
> Lähetetty: 2. tammikuuta 2013 18:12
> Vastaanottaja: Simone Giannecchini
> Kopio: geoserver-users@lists.sourceforge.net
> Aihe: Re: [Geoserver-users] Rasters, Tiles, and FME
>
> Hey Simone,
>
> Thanks for your thorough reply. Useful!
>
> - Resampling:
> I've done some experimenting with Resampling since my email and, at least
> for the data I was testing, Nearest Neighbour came out best (though
> obviously entirely subjective). This was for a regular RGB map (Ordnance
> Survey MiniScale specifically). There was also a significant difference in
> file sizes, with Nearest Neighbour being the smallest, and Cubic being the
> largest (double!). I didn't expect such a significant difference, may be
> worth noting somewhere.
>
> - External Overviews:
> Thanks, but I'd found out how to create them with GDAL. My issue is - how
> do I get GeoServer to use them? Does it just pick them up automatically or
> do I need some sort of particular directory structure?
> GDAL seems to create a single, absurdly huge file, so I guess it doesn't
> compress the external overviews. Based on what I'm seeing, I'm not sure if
> FME can create them; I expected multiple separate files (one for each
> layer), but the "external overviews" are basically identical to internal
> overviews but minus the source data.
>
> -Overviews:
> How do you determine how many levels to create? I remember this page from
> years ago when last I used GeoServer:
> http://docs.geoserver.org/stable/en/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html#how-many-pyramids-are-needed-
>  does this carry over to GeoTIFF's overviews?
> I may be reading this wrong, but the example in the PDF has 7 layers but
> only really needs about 3 as after that they're smaller than the 1:1 tiles.
>
> Is there any point in creating pyramids with a value of 1 (as in, 1 2 4
> 8...) ? GDAL lets you do this but if I'm understanding this correctly,
> they're entirely superfluous (I mention it because Russ's example he
> generously posted starts at 1).
>
>
> Tile size:
> Might there be a formula for calculating optimal size?
> For example, if I have a 94488*157480 pixel GeoTIFF (my largest - about
> 2.5GB compressed), if I divide them by 512 I get
> 184*307 tiles = 56,488 tiles
>
> For 256 I get:
> 368*614 tiles = 225,952 tiles
>
> So if there is/was a formula, it might be easier to figure out what size
> to go with, or at what point you'd want to be scaling up to ImageMosaic.
> Based on disk seeks etc, and some experimentation, I'd guess that a number
> could be contrived allowing the documentation to say:
> "If you end up with > X,000 tiles, go with ImageMosiac" and "Aim for
> between X,000 and X0,000 tiles in a GeoTIFF"
> Just a thought, would be helpful for optimisation.
>
> Documentation:
> I was considering contributing to it for this but at this point certainly
> don't know enough (you may have noticed from my above questions ;-) ).
> I would however suggest that this section of the help:
> http://docs.geoserver.org/stable/en/user/production/data.html?highlight=gdaladdo#pick-the-best-performing-coverage-formats-
>  It would gain from the info on pages 7-9 of your PDF.
>
> Cheers!
> Jonathan
>
>
> On 2 January 2013 15:03, Simone Giannecchini <
> simone.giannecch...@geo-solutions.it simone.giannecch...@geo-solutions.it>> wrote:
> Ciao Jonathan,
> please find my answers inline below...
>
> Regards,
> Simone Giannecchini
> ==
>

Re: [Geoserver-users] Parameterize ColorMapEntry

[Andrea Aime]

On Mon, Jan 7, 2013 at 8:27 PM, Martin Davis  wrote:

> Agreed.  I was mostly thinking of the ability to be able to use the "env"
> function - I should have said that explicitly.
>
> It seemed like the cleanest, most general way of providing access to "env"
> was to allow CQL expressions (especially since there might well be the need
> to perform some further computation on the "env" value to adapt it to the
> quantity required for any particular band).
>

Ah, I see what you mean. Yes, it is consistent with what we already did for
"dynamic symbolizers", where
portions of CQL expressions can be included in the external graphic
location attribute:
http://blog.geoserver.org/2008/12/08/dynamic-symbolizers-part-1/

For the raster symbolizer it could be something like:



and the parser could recognize that the value is starting from ${ and parse
it as a cql expression.
Or maybe not even use it ${, check if the value is the expected literal
type, if not, parse it as a CQL
expression.

That said... someone needs to write the code for this :-)

Cheers
Andrea

-- 
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] SDO_TUNE.EXTENT_OF - Oracle

[Paolo Crosato]

Il 08/01/2013 07:18, cmaul ha scritto:
> Jonathan,
>
> I was never able to define large datasets in Oracle letting Geoserver find
> the bounding box and thought it is a Geoserver problem but it is not.
>
> As you said and Andrea confirmed in the background on the oracle level it
> must be one of these commands:
>
> SELECT SDO_TUNE.EXTENT_OF('TABLE_NAME', 'SPATIAL_COLUMN') FROM DUAL;
> or
> SELECT SDO_AGGR_MBR(SPATIAL_COLUMN) FROM TABLE_NAME;
>
> Running the SDO_TUNE.EXTENT_OF on a dataset with 3.3 million features I gave
> up after 15 mins.
> Trying the command with smaller datasets I get the following numbers.
> secs  feature numbers
> 1.6   935
> 1.9   3700
> 7.6   28000
> 30.25 105000
>
> Sort of  linear increase and atrocious performance. The 'SDO_AGGR_MBR' is
> even worse. So, I get the BBox from ArcSDE and hack it in by hand which
> infuriates me, because I think a decent spatial database should work on its
> own resources.
> Geoserver is 2.1.3 and all the tables have spatial indices.
> Anything I might do wrong with the DB or any solutions for that?
>
> Cheers
>
> Christian

Hi,

I made a short comparative study about usage of Oracle Spatial for a 
rather large dataset we are planning to use, about 100k features with . 
I tested the both bounding box, aggregate and intersection function over 
the whole dataset. It turned out performances on the db side were 
unacceptable, even on a fairly good workstation (2 quad core xeon procs, 
32G ram and SAS hds).
I had to skip Oracle in favour of PostGIS, the performances on my quad 
core development pc are order of magnitudes better.
I can confirm it's not a Geoserver issue, the same Geoserver that was 
sluggish on Oracle Spatial became blazing fast when hooked to Postgres.
I don't know if Oracle Spatial performances get better on big mainframes 
or racs, if you can afford them.

Regards,

Paolo

-- 
Paolo Crosato



--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

[Geoserver-users] Urgent: IEEERemainder Issue

[Chris Haste]

Hello all,

We have recently upgraded to version 2.2.3 and as a result some of our SLD's 
which use the IEEERemainder function no longer work. Having had a quick search 
I can see that there is a bug report listed for this back in Oct-2012 (we are 
also using an SQL layer from a PostGres DB)

We don't want to rollback to the 2.1 version so I'm hoping someone can suggest 
a work around for me.

We use the IEEERemainder function to thin out the displayed information from a 
dataset that represents a regular grid of points. We do things like this (in 
CSS):
/*Longitude and Latitude represent the coordinates of the temperature value */
[@scale>7500][IEEERemainder(longitude, 7.5) = 0][IEEERemainder(latitude, 
7.5) = 0]{
  label:[numberFormat('P#;#',temperature)];
  font-size:8;
}

[@scale>4500][@scale<7500][IEEERemainder(longitude, 6.25) = 
0][IEEERemainder(latitude, 6.25) = 0]{
  label:[numberFormat('P#;#',temperature)];
  font-size:9;
}

[@scale>2000][@scale<4500]
[IEEERemainder(longitude, 3.75) = 0][IEEERemainder(latitude, 3.75) = 0]{
  label:[numberFormat('P#;#',temperature)];
  font-size:9;
}

Etc.

This has the effect of thinning out the displayed information at the higher 
scales.

Does anyone have a better suggestion/solution for this without using the 
IEEERemainder function?

Thanks

Chris
*** This communication has been sent from World Fuel Services 
Corporation or its subsidiaries or its affiliates for the intended recipient 
only and may contain proprietary, confidential or privileged information. 
If you are not the intended recipient, any review, disclosure, copying, 
use, or distribution of the information included in this communication 
and any attachments is strictly prohibited. If you have received this 
communication in error, please notify us immediately by replying to this 
communication and delete the communication, including any 
attachments, from your computer. Electronic communications sent to or 
from World Fuel Services Corporation or its subsidiaries or its affiliates 
may be monitored for quality assurance and compliance purposes.***

--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] SDO_TUNE.EXTENT_OF - Oracle

[Andrea Aime]

On Tue, Jan 8, 2013 at 7:18 AM, cmaul  wrote:

> Sort of  linear increase and atrocious performance. The 'SDO_AGGR_MBR' is
> even worse. So, I get the BBox from ArcSDE and hack it in by hand which
> infuriates me, because I think a decent spatial database should work on its
> own resources.
>

Ha ha, matches my experience 1-1. Oracle spatial is indeed infuriating,
espetially
when compared to how easy things are in PostGIS, both to use, and to
program against.

Cheers
Andrea

-- 
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---
--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Re: [Geoserver-users] Rasters, Tiles, and FME

[Simone Giannecchini]

Ciao Jonathan,
please, read my answers inline below

Regards,
Simone Giannecchini
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for
more information.
==

Ing. Simone Giannecchini
@simogeo
Founder/Director

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob:   +39  333 8128928

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

---


On Wed, Jan 2, 2013 at 5:12 PM, Jonathan Moules
 wrote:
> Hey Simone,
>
> Thanks for your thorough reply. Useful!
>
> - Resampling:
> I've done some experimenting with Resampling since my email and, at least
> for the data I was testing, Nearest Neighbour came out best (though
> obviously entirely subjective). This was for a regular RGB map (Ordnance
> Survey MiniScale specifically). There was also a significant difference in
> file sizes, with Nearest Neighbour being the smallest, and Cubic being the
> largest (double!). I didn't expect such a significant difference, may be
> worth noting somewhere.

I belive your data comprises of raster with colormap (i.e each pixel
points to an index in a colormap rather than being a real value). In
this case the only interpolation that will retain the colormap will be
nearest neighbor. If you apply higher order interpolation (i.e
bilinear and so on) that do need to mash-up somehow adiacent values
then we need to perform a color expansion which will transform the
image from 1 band to as many band as the color model has (3 for RGB
images). Hence the image size will explode per-se.

>
> - External Overviews:
> Thanks, but I'd found out how to create them with GDAL. My issue is - how do
> I get GeoServer to use them? Does it just pick them up automatically or do I
> need some sort of particular directory structure?
> GDAL seems to create a single, absurdly huge file, so I guess it doesn't
> compress the external overviews. Based on what I'm seeing, I'm not sure if
> FME can create them; I expected multiple separate files (one for each
> layer), but the "external overviews" are basically identical to internal
> overviews but minus the source data.

If you are publishing single geotiff files GeoServer should use them
automcatically, if you are using ImageMosaic, currently there is no
way to use them.

>
> -Overviews:
> How do you determine how many levels to create? I remember this page from
> years ago when last I used GeoServer:
> http://docs.geoserver.org/stable/en/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html#how-many-pyramids-are-needed
> - does this carry over to GeoTIFF's overviews?
> I may be reading this wrong, but the example in the PDF has 7 layers but
> only really needs about 3 as after that they're smaller than the 1:1 tiles.

I had a cursory look at the formula and seems correct.

>
> Is there any point in creating pyramids with a value of 1 (as in, 1 2 4
> 8...) ? GDAL lets you do this but if I'm understanding this correctly,
> they're entirely superfluous (I mention it because Russ's example he
> generously posted starts at 1).

You usually do that to retile/compress/colorconvert high resolution level.

>
>
> Tile size:
> Might there be a formula for calculating optimal size?
> For example, if I have a 94488*157480 pixel GeoTIFF (my largest - about
> 2.5GB compressed), if I divide them by 512 I get
> 184*307 tiles = 56,488 tiles
>
> For 256 I get:
> 368*614 tiles = 225,952 tiles
>
> So if there is/was a formula, it might be easier to figure out what size to
> go with, or at what point you'd want to be scaling up to ImageMosaic.
> Based on disk seeks etc, and some experimentation, I'd guess that a number
> could be contrived allowing the documentation to say:
> "If you end up with > X,000 tiles, go with ImageMosiac" and "Aim for between
> X,000 and X0,000 tiles in a GeoTIFF"
> Just a thought, would be helpful for optimisation.

Well, I guess this is part of testing + experience. It may very well
depend on where the data resides (local disk, SAN, NAS) how the
filesystem has been configured, if the tiles are compressed, etc. etc.
You would need to do some testing to choose the best ones.

I believe I will update the GeoServer on steroids presentation with
some numbers for different tile sizes, compressions and so on.

>
> Documentation:
> I was considering contributing to it for this but at this point certainly
> don't know enough (you may have noticed from my above questions ;-) ).
> I would however suggest that this section of the help:
> http://docs.geoserver.org/stable/en/user/production/data.html?highlight=gdaladdo#pick-the-best-performing-coverage-formats
> - It would gain from the info on pages 7-9 of your PDF.
>
> Cheers!
> Jonathan
>
>
> On 2 January 2013 15:03, Simone Giannecchini
>  wrote:
>>
>> Ciao Jonathan,
>> please find my answers inline below...
>>
>> Regards,
>> Simone Giannecchini
>> ==
>> Our support, Your Success! Visit http://ope

Re: [Geoserver-users] How to upload a shape file in geoserver

[Stefano Iacovella]

Did you read the doc about REST interface?

http://docs.geoserver.org/stable/en/user/restconfig/index.html

Using REST operation you can add a shapefile and publish it as a layer
with the desired style.
You should be able to use RESt operation in your app, you just have to
make http requests.

Kind Regards,

Stefano

---
41.95581N 12.52854E


http://www.linkedin.com/in/stefanoiacovella

http://twitter.com/#!/Iacovellas


2013/1/8 krunal :
> Thanks for answering,
>
> Your idea is very much helpful.
> But I want to add function of 'Add data' in my application.
> Using this functionality, user can add shape file from his/ her local system
> to my application for the analysis.
> So, style, publish required at a time.
>
> Regards,
> Krunal
>
>
>
> On Tue, Jan 8, 2013 at 12:08 PM, cmaul [via OSGeo.org] <[hidden email]>
> wrote:
>>
>> Krunal,
>>
>> no need to:
>>
>> Add new store ---> Shape file
>>
>> Give it a name:
>> 
>> Enter or browse for the shape file location:
>> file://U:\raetest\TR_FERRY_ROUTE.shp for example
>>
>> Save. And never turn the remote computer off.
>> For that reason rather copy your data to your Geoserver data directory.
>> where the shape file location would look something like that:
>> file:data/shapefiles/states.shp
>>
>>
>> Style, publish and you are done.
>>
>> Cheers
>>
>> Christian
>> 
>>
>> Dr Christian Maul
>> Project Manager
>>
>> Information Services Branch
>> Department of Sustainability and Environment
>> Level13, Marland House, 570 Bourke Street
>> Melbourne 3000
>>
>> PO Box 500, East Melbourne Vic 3002
>>
>>
>> Telephone:+61-3-8636 2325
>> Telefax:  +61-3-8636 2813
>>
>>
>> 
>> If you reply to this email, your message will be added to the discussion
>> below:
>>
>> http://osgeo-org.1560.n6.nabble.com/How-to-upload-a-shape-file-in-geoserver-tp5026060p5026067.html
>> To unsubscribe from How to upload a shape file in geoserver, click here.
>> NAML
>
>
>
> 
> View this message in context: Re: How to upload a shape file in geoserver
>
> Sent from the GeoServer - User mailing list archive at Nabble.com.
>
> --
> Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
> and more. Get SQL Server skills now (including 2012) with LearnDevNow -
> 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
> SALE $99.99 this month only - learn more at:
> http://p.sf.net/sfu/learnmore_122512
> ___
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>

--
Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS
and more. Get SQL Server skills now (including 2012) with LearnDevNow -
200+ hours of step-by-step video tutorials by Microsoft MVPs and experts.
SALE $99.99 this month only - learn more at:
http://p.sf.net/sfu/learnmore_122512
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users