date:20140820

[mapserver-users] Postgis Tile Index

2014-08-20 Thread Dave Barter

I want to create a WMS service from map server that has raster tiles stored in 
a postgis database

I have loaded the tiles and have a table RASTERS as follows:-

CREATE TABLE mapping_raster.streetview
(
  rid serial NOT NULL,
  rast raster,
  filename text,
  CONSTRAINT streetview_pkey PRIMARY KEY (rid)
)

I understand that Mapserver now needs two layers as per this link 
https://trac.osgeo.org/mapserver/wiki/DatabaseTileIndex

How do I create the tile index table from my raster data? The Oracle example 
query looks like:-

create or replace view my_raster_tindex as select some_attribute, 'geor: 
user/pass@tns, raster_table_DATA,'||r.raster.rasterid location, 
R.RASTER.spatialextent shape from rasters_table r;

I don’t properly understand which attribute links to the raster in the tile 
index?

TIA
Dave 

-- 
Dave Barter

Web: http://www.phased.co.uk
Email:d...@phased.co.uk
Twitter:@Citizenfishy___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Postgis Tile Index

2014-08-20 Thread Dave Barter

..just needed to read the documentation a little harder, I’m assuming it is:-

CREATE MATERIALIZED VIEW mapping_raster.streetview_tileindex AS SELECT rid as 
location, ST_ConvexHull(rast) as shape from mapping_raster.streetview 

-- 
Dave Barter

Web: http://www.phased.co.uk
Email:d...@phased.co.uk
Twitter:@Citizenfishy___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Postgis Tile Index

2014-08-20 Thread Dave Barter

Final question. How should my map file look in order to get the raster tile 
from the database not the file system?

LAYER
            # CREATE MATERIALIZED VIEW 
mapping_os_opendata_raster.streetview_tileindex AS SELECT rid as location, 
ST_ConvexHull(rast) as shape from mapping_os_opendata_raster.streetview 
            NAME streetview_tileindex
            TYPE polygon
            PROJECTION
                init=epsg:27700
            END
            CONNECTIONTYPE postgis
            CONNECTION “
            DATA shape from (SELECT shape,location FROM 
mapping_os_opendata_raster.streetview_tileindex) AS FOO USING UNIQUE location 
using srid=27700

        END

        LAYER
            #RASTER TILE LAYERS MUST RUN FROM A TILEINDEX
            NAME streetview
            TYPE RASTER
            STATUS ON
            TILEINDEX streetview_tileindex
            TILEITEM location
            OFFSITE 0 0 0 
            PROJECTION
                init=epsg:27700
            END
            DEBUG 5
            EXTENT 0 0 300 100

        END

This is not working as the layer street view returns an error:- 

msDrawMap(): Image handling error. Failed to draw layer named 'streetview'. 
msDrawRasterLayerLow(): Unable to access file. Corrupt, empty or missing file 
'654016' for layer 'street view’.

I set SHAPEFILE “” at the top of the file, but am unclear as to how the 
streetview layer will retrieve the tile ?



-- 
Dave Barter

Web: http://www.phased.co.uk
Email:d...@phased.co.uk
Twitter:@Citizenfishy___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Postgis Tile Index

2014-08-20 Thread Dave Barter

I’ve figured this out,

CREATE MATERIALIZED VIEW mapping_os_opendata_raster.streetview_tileindex AS 
SELECT rid as location, ST_ConvexHull(rast) as shape from 
mapping_os_opendata_raster.streetview 


“location needs to be a path to the database/table/raster currently it is just 
returning an ID, but I cannot find any documentation as to how to construct 
this for postgres

So nearly there?

On 20 August 2014 at 11:34:03, Dave Barter (dave.bar...@gmail.com) wrote:

Final question. How should my map file look in order to get the raster tile 
from the database not the file system?

LAYER
            # CREATE MATERIALIZED VIEW 
mapping_os_opendata_raster.streetview_tileindex AS SELECT rid as location, 
ST_ConvexHull(rast) as shape from mapping_os_opendata_raster.streetview 
            NAME streetview_tileindex
            TYPE polygon
            PROJECTION
                init=epsg:27700
            END
            CONNECTIONTYPE postgis
            CONNECTION “
            DATA shape from (SELECT shape,location FROM 
mapping_os_opendata_raster.streetview_tileindex) AS FOO USING UNIQUE location 
using srid=27700

        END

        LAYER
            #RASTER TILE LAYERS MUST RUN FROM A TILEINDEX
            NAME streetview
            TYPE RASTER
            STATUS ON
            TILEINDEX streetview_tileindex
            TILEITEM location
            OFFSITE 0 0 0 
            PROJECTION
                init=epsg:27700
            END
            DEBUG 5
            EXTENT 0 0 300 100

        END

This is not working as the layer street view returns an error:- 

msDrawMap(): Image handling error. Failed to draw layer named 'streetview'. 
msDrawRasterLayerLow(): Unable to access file. Corrupt, empty or missing file 
'654016' for layer 'street view’.

I set SHAPEFILE “” at the top of the file, but am unclear as to how the 
streetview layer will retrieve the tile ?



-- 
Dave Barter

Web: http://www.phased.co.uk
Email:d...@phased.co.uk
Twitter:@Citizenfishy___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Postgis Tile Index

2014-08-20 Thread Rahkonen Jukka (Tike)

Perhaps it is something like this (from 
http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html)

“Reading raster data from the database
If you want to use the GDAL WKT Raster driver, you must provide a connection 
string as Dataset's name. The syntax of this connection string is (the quotes 
may be ommitted):
PG:host='host' port:'port' dbname='dbname' user='user' 
password='password' [schema='schema'] [table='raster_table'] 
[where='sql_where'] [mode='working_mode']

I would test first by using the string for one image as  DATA of your raster 
layer before to continue towards TILEINDEX+TILEITEM.

-Jukka Rahkonen-

Dave Barter wrote:

I’ve figured this out,

CREATE MATERIALIZED VIEW mapping_os_opendata_raster.streetview_tileindex AS 
SELECT rid as location, ST_ConvexHull(rast) as shape from 
mapping_os_opendata_raster.streetview



“location needs to be a path to the database/table/raster currently it is just 
returning an ID, but I cannot find any documentation as to how to construct 
this for postgres
So nearly there?


On 20 August 2014 at 11:34:03, Dave Barter 
(dave.bar...@gmail.commailto:dave.bar...@gmail.com) wrote:
Final question. How should my map file look in order to get the raster tile 
from the database not the file system?

LAYER
# CREATE MATERIALIZED VIEW 
mapping_os_opendata_raster.streetview_tileindex AS SELECT rid as location, 
ST_ConvexHull(rast) as shape from mapping_os_opendata_raster.streetview
NAME streetview_tileindex
TYPE polygon
PROJECTION
init=epsg:27700
END
CONNECTIONTYPE postgis
CONNECTION “
DATA shape from (SELECT shape,location FROM 
mapping_os_opendata_raster.streetview_tileindex) AS FOO USING UNIQUE location 
using srid=27700

END

LAYER
#RASTER TILE LAYERS MUST RUN FROM A TILEINDEX
NAME streetview
TYPE RASTER
STATUS ON
TILEINDEX streetview_tileindex
TILEITEM location
OFFSITE 0 0 0
PROJECTION
init=epsg:27700
END
DEBUG 5
EXTENT 0 0 300 100

END

This is not working as the layer street view returns an error:-

msDrawMap(): Image handling error. Failed to draw layer named 'streetview'. 
msDrawRasterLayerLow(): Unable to access file. Corrupt, empty or missing file 
'654016' for layer 'street view’.

I set SHAPEFILE “” at the top of the file, but am unclear as to how the 
streetview layer will retrieve the tile ?



--
Dave Barter

Web: http://www.phased.co.ukhttp://www.phased.co.uk/
Email:d...@phased.co.ukmailto:email%3ad...@phased.co.uk
Twitter:@Citizenfishy
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] [EXTERNAL] Re: Postgis Tile Index

2014-08-20 Thread Dave Barter

I have this working now:-

CREATE MATERIALIZED VIEW mapping_raster.streetview_tileindex AS 
SELECT 'PG:host=localhost port=5432 …. schema=''mapping__raster'' 
table=''streetview'' mode=''1'' where=rid='||rid as location, 
ST_ConvexHull(rast) as shape from mapping_raster.streetview 

Thanks for the help, I will update the wiki shortly

On 20 August 2014 at 12:15:48, Smith, Michael ERDC-RDE-CRREL-NH 
(michael.sm...@erdc.dren.mil) wrote:

Note that the current Wiki entry is here: 
https://github.com/mapserver/mapserver/wiki/MapServer-TILEINDEXes-with-Database-RASTERS

And when you do get this working, please update this for the other PostGIS 
users.

Mike

-- 
Michael Smith
US Army Corps
Remote Sensing GIS/Center

From: Rahkonen Jukka (Tike) jukka.rahko...@mmmtike.fi
Date: Wednesday, August 20, 2014 at 6:56 AM
To: Dave Barter dave.bar...@gmail.com, mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.org
Subject: [EXTERNAL] Re: [mapserver-users] Postgis Tile Index
Resent-From: Michael Smith michael.sm...@usace.army.mil

Perhaps it is something like this (from 
http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html)

 

“Reading raster data from the database

If you want to use the GDAL WKT Raster driver, you must provide a connection 
string as Dataset's name. The syntax of this connection string is (the quotes 
may be ommitted):

PG:host='host' port:'port' dbname='dbname' user='user' 
password='password' [schema='schema'] [table='raster_table'] 
[where='sql_where'] [mode='working_mode']

 

I would test first by using the string for one image as  DATA of your raster 
layer before to continue towards TILEINDEX+TILEITEM.

 

-Jukka Rahkonen-

 

Dave Barter wrote:

 

I’ve figured this out,

 

CREATE MATERIALIZED VIEW mapping_os_opendata_raster.streetview_tileindex AS 
SELECT rid as location, ST_ConvexHull(rast) as shape from 
mapping_os_opendata_raster.streetview 

 

“location needs to be a path to the database/table/raster currently it is just 
returning an ID, but I cannot find any documentation as to how to construct 
this for postgres

So nearly there?

 

On 20 August 2014 at 11:34:03, Dave Barter (dave.bar...@gmail.com) wrote:

Final question. How should my map file look in order to get the raster tile 
from the database not the file system?

 

LAYER

            # CREATE MATERIALIZED VIEW 
mapping_os_opendata_raster.streetview_tileindex AS SELECT rid as location, 
ST_ConvexHull(rast) as shape from mapping_os_opendata_raster.streetview 

            NAME streetview_tileindex

            TYPE polygon

            PROJECTION

                init=epsg:27700

            END

            CONNECTIONTYPE postgis

            CONNECTION “

            DATA shape from (SELECT shape,location FROM 
mapping_os_opendata_raster.streetview_tileindex) AS FOO USING UNIQUE location 
using srid=27700

 

        END

 

        LAYER

            #RASTER TILE LAYERS MUST RUN FROM A TILEINDEX

            NAME streetview

            TYPE RASTER

            STATUS ON

            TILEINDEX streetview_tileindex

            TILEITEM location

            OFFSITE 0 0 0 

            PROJECTION

                init=epsg:27700

            END

            DEBUG 5

            EXTENT 0 0 300 100

 

        END

 

This is not working as the layer street view returns an error:- 

 

msDrawMap(): Image handling error. Failed to draw layer named 'streetview'. 
msDrawRasterLayerLow(): Unable to access file. Corrupt, empty or missing file 
'654016' for layer 'street view’.

 

I set SHAPEFILE “” at the top of the file, but am unclear as to how the 
streetview layer will retrieve the tile ?

 

 

 

-- 
Dave Barter

Web: http://www.phased.co.uk
Email:d...@phased.co.uk
Twitter:@Citizenfishy___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] [EXTERNAL] Re: Postgis Tile Index

2014-08-20 Thread Smith, Michael ERDC-RDE-CRREL-NH

Note that the current Wiki entry is here: 
https://github.com/mapserver/mapserver/wiki/MapServer-TILEINDEXes-with-Database-RASTERS

And when you do get this working, please update this for the other PostGIS 
users.

Mike

--
Michael Smith
US Army Corps
Remote Sensing GIS/Center

From: Rahkonen Jukka (Tike) 
jukka.rahko...@mmmtike.fimailto:jukka.rahko...@mmmtike.fi
Date: Wednesday, August 20, 2014 at 6:56 AM
To: Dave Barter dave.bar...@gmail.commailto:dave.bar...@gmail.com, 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [EXTERNAL] Re: [mapserver-users] Postgis Tile Index
Resent-From: Michael Smith 
michael.sm...@usace.army.milmailto:michael.sm...@usace.army.mil

Perhaps it is something like this (from 
http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html)

“Reading raster data from the database
If you want to use the GDAL WKT Raster driver, you must provide a connection 
string as Dataset's name. The syntax of this connection string is (the quotes 
may be ommitted):
PG:host='host' port:'port' dbname='dbname' user='user' 
password='password' [schema='schema'] [table='raster_table'] 
[where='sql_where'] [mode='working_mode']

I would test first by using the string for one image as  DATA of your raster 
layer before to continue towards TILEINDEX+TILEITEM.

-Jukka Rahkonen-

Dave Barter wrote:

I’ve figured this out,

CREATE MATERIALIZED VIEW mapping_os_opendata_raster.streetview_tileindex AS 
SELECT rid as location, ST_ConvexHull(rast) as shape from 
mapping_os_opendata_raster.streetview



“location needs to be a path to the database/table/raster currently it is just 
returning an ID, but I cannot find any documentation as to how to construct 
this for postgres
So nearly there?


On 20 August 2014 at 11:34:03, Dave Barter 
(dave.bar...@gmail.commailto:dave.bar...@gmail.com) wrote:
Final question. How should my map file look in order to get the raster tile 
from the database not the file system?

LAYER
# CREATE MATERIALIZED VIEW 
mapping_os_opendata_raster.streetview_tileindex AS SELECT rid as location, 
ST_ConvexHull(rast) as shape from mapping_os_opendata_raster.streetview
NAME streetview_tileindex
TYPE polygon
PROJECTION
init=epsg:27700
END
CONNECTIONTYPE postgis
CONNECTION “
DATA shape from (SELECT shape,location FROM 
mapping_os_opendata_raster.streetview_tileindex) AS FOO USING UNIQUE location 
using srid=27700

END

LAYER
#RASTER TILE LAYERS MUST RUN FROM A TILEINDEX
NAME streetview
TYPE RASTER
STATUS ON
TILEINDEX streetview_tileindex
TILEITEM location
OFFSITE 0 0 0
PROJECTION
init=epsg:27700
END
DEBUG 5
EXTENT 0 0 300 100

END

This is not working as the layer street view returns an error:-

msDrawMap(): Image handling error. Failed to draw layer named 'streetview'. 
msDrawRasterLayerLow(): Unable to access file. Corrupt, empty or missing file 
'654016' for layer 'street view’.

I set SHAPEFILE “” at the top of the file, but am unclear as to how the 
streetview layer will retrieve the tile ?



--
Dave Barter

Web: http://www.phased.co.ukhttp://www.phased.co.uk/
Email:d...@phased.co.ukmailto:email%3ad...@phased.co.uk
Twitter:@Citizenfishy
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] WMS request fails when spaces are encoded as plus symbol in query part of URL

2014-08-20 Thread Moen, Paul T.

Steve,

You are right about the outcome of 1 and 2.  1 encodes the % and 2 throws the 
following error.

msBuildWMSLayerURLBase(): One of wms_onlineresource, wms_server_version, 
wms_name metadata is missing in layer USGS DRG 250k Topo Maps.  Please either 
provide a valid CONNECTION URL, or provide those values in the layer's 
metadata.\n\n

I found the function as you said and
I removed the

 if (*i == ' ')
  *j = '+';
else
from the function then recompiled.

char *msEncodeUrlExcept(const char *data, const char except)
{
  char *hex = 0123456789ABCDEF;
  const char *i;
  char  *j, *code;
  int   inc;
  unsigned char ch;

  for (inc=0, i=data; *i!='\0'; i++)
if (msEncodeChar(*i))
  inc += 2;

  code = (char*)msSmallMalloc(strlen(data)+inc+1);

  for (j=code, i=data; *i!='\0'; i++, j++) {
if ( except != '\0'  *i == except ) {
  *j = except;
} else if (msEncodeChar(*i)) {
  ch = *i;
  *j++ = '%';
  *j++ = hex[ch/16];
  *j   = hex[ch%16];
} else
  *j = *i;
  }
  *j = '\0';

  return code;
}

Everything works again after a mapserver recompile, install and finally a 
restart of apache.  Thanks so much for the path to the solution.

Paul Moen
pm...@nd.govmailto:pm...@nd.gov
701-328-2434


From: Lime, Steve D (MNIT) 
steve.l...@state.mn.usmailto:steve.l...@state.mn.us
Date: Wednesday, August 20, 2014 at 12:41 AM
To: Paul Moen pm...@nd.govmailto:pm...@nd.gov, 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: RE: [mapserver-users] WMS request fails when spaces are encoded as 
plus symbol in query part of URL

Hmmm... Nice backwards compatibility ESRI. The +'s seem to still be quite legal 
(http://tools.ietf.org/html/rfc3986 and other references) in the query string 
(but not the path). I don't have access to test and I'm guessing these ideas 
won't work but they might be worth a quick try:

  1) Try encoding the wms_name in the metadata: wms_name 
Topomap%20DRG%20250k
  2) Don't set the wms_name in the metadata but add it to the connection: 
CONNECTION 
http://ndgishub.nd.gov/arcgis/services/All_Elevation/MapServer/WMSServer?LAYERS=Topomap%20DRG%20250k;

I'm betting MapServer will encode the %'s in 1 and throw an error in 2. 
Otherwise you could hack the MapServer source. Function is called 
msEncodeUrlExcept() in mapstring.c you can see the section to change starting 
at line 1138 in git master 
(https://github.com/mapserver/mapserver/blob/master/mapstring.c)https://github.com/mapserver/mapserver/blob/master/mapstring.c).

Maybe it's worth making this change as part of 7.0?

Steve



From: 
mapserver-users-boun...@lists.osgeo.orgmailto:mapserver-users-boun...@lists.osgeo.org
 
[mapserver-users-boun...@lists.osgeo.orgmailto:mapserver-users-boun...@lists.osgeo.org]
 on behalf of Moen, Paul T. [pm...@nd.govmailto:pm...@nd.gov]
Sent: Tuesday, August 19, 2014 4:56 PM
To: mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Subject: [mapserver-users] WMS request fails when spaces are encoded as plus 
symbol in query part of URL

Hi all,

We are consuming WMS services hosted by ESRI ArcGIS Server 10.0.  The server 
was upgraded to ArcGIS Server 10.2.2 and we no longer can access layer names 
with spaces.

This is the server’s capabilities.
http://ndgishub.nd.gov/arcgis/services/All_Elevation/MapServer/WMSServer?request=GetCapabilitiesservice=WMS

This is the layer I am using.

LAYER
# DEBUG 5
CONNECTIONTYPE WMS
CONNECTION 
http://ndgishub.nd.gov/arcgis/services/All_Elevation/MapServer/WMSServer?;
METADATA
wms_name Topomap DRG 250k
wms_format image/png
wms_server_version 1.1.1
wms_srs EPSG:2266
END
TYPE RASTER
STATUS OFF
NAME USGS DRG 250k Topo Maps
END

Mapserver encodes this request as follows.  Notice that the layer name, which 
is ‘Topomap DRG 250k’, is encoded with the spaces becoming the ‘+’ character.

http://ndgishub.nd.gov/arcgis/services/All_Elevation/MapServer/WMSServer?LAYERS=Topomap+DRG+250kREQUEST=mapWMTVER=1.0.0SERVICE=WMSFORMAT=image/pngSTYLES=HEIGHT=1146SRS=EPSG:2266WIDTH=1271BBOX=1906240.15992838,596656.59479,2119730.85012732,789150.692893686TRANSPARENT=TRUEEXCEPTIONS=INIMAGE

This returns the error in an image that says “Parameter ‘layers’ contains 
unacceptable layer names.”

When I replace the + in the layer name with %20, LAYERS=Topomap+DRG+250k become 
LAYERS=Topomap%20DRG%20250k and the request becomes the following.

http://ndgishub.nd.gov/arcgis/services/All_Elevation/MapServer/WMSServer?LAYERS=Topomap%20DRG%20250kREQUEST=mapWMTVER=1.0.0SERVICE=WMSFORMAT=image/pngSTYLES=HEIGHT=1146SRS=EPSG:2266WIDTH=1271BBOX=1906240.15992838,596656.59479,2119730.85012732,789150.692893686TRANSPARENT=TRUEEXCEPTIONS=INIMAGE

That request works.  Obviously, ESRI is no longer decoding + as a space and 
therefore does not recognize the layer name with spaces.

Is there any way I can have mapserver encode all

[mapserver-users] Postgis Raster Layer

2014-08-20 Thread Dave Barter

One final question for today!

When I use mapserver wms to serve the raster tiles from the file system, they 
look fine. But doing it from the database gives me problems with the black 
labels as can be seen by the image at 
http://phased.co.uk/wp-content/uploads/Screen-Shot-2014-08-20-at-15.49.09.png

Is there a way I can fix this? The rasters in the database are fine and not 
corrupted, I’ve checked this by exporting and viewing one.

Dave

-- 

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Postgis Raster Layer

2014-08-20 Thread Andrea Peri

AFAIK
The same problem of the label is also on lines. See in your sample the
boundaries of street.

A.
 Il 20/ago/2014 16:53 Dave Barter dave.bar...@gmail.com ha scritto:

 One final question for today!

 When I use mapserver wms to serve the raster tiles from the file system,
 they look fine. But doing it from the database gives me problems with the
 black labels as can be seen by the image at
 http://phased.co.uk/wp-content/uploads/Screen-Shot-2014-08-20-at-15.49.09.png

 Is there a way I can fix this? The rasters in the database are fine and
 not corrupted, I’ve checked this by exporting and viewing one.

 Dave

 --


 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Postgis Raster Layer

2014-08-20 Thread Andrea Peri

I guess iT is a resampling question.
My theory is that you dont see this issue with on polygon filled with solid
color because the resample strategy find the same color in all the
considered portion of polygon.
This is not true for  labels or lines.

If this theory is true, it should fail also with points and with other
colors.
Not only black.

A.
 Il 20/ago/2014 17:04 Dave Barter dave.bar...@gmail.com ha scritto:

 Yes, it appears to be related to the black colour

 On 20 August 2014 at 16:03:15, Andrea Peri (aperi2...@gmail.com) wrote:

 AFAIK
 The same problem of the label is also on lines. See in your sample the
 boundaries of street.

 A.
 Il 20/ago/2014 16:53 Dave Barter dave.bar...@gmail.com ha scritto:

  One final question for today!

  When I use mapserver wms to serve the raster tiles from the file system,
 they look fine. But doing it from the database gives me problems with the
 black labels as can be seen by the image at
 http://phased.co.uk/wp-content/uploads/Screen-Shot-2014-08-20-at-15.49.09.png

  Is there a way I can fix this? The rasters in the database are fine and
 not corrupted, I’ve checked this by exporting and viewing one.

  Dave

   --


 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users


 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Postgis Raster Layer

2014-08-20 Thread Dave Barter

Further investigation in QGIS shows that it is pixel value 161 that is not 
displaying

gdalinfo tells me that  161: 0,0,0,255 for the raster

So, can I correct this in map server, and why is it not rendering it as black?
On 20 August 2014 at 16:12:06, Andrea Peri (aperi2...@gmail.com) wrote:

I guess iT is a resampling question.
My theory is that you dont see this issue with on polygon filled with solid 
color because the resample strategy find the same color in all the considered 
portion of polygon.
This is not true for  labels or lines.

If this theory is true, it should fail also with points and with other colors.
Not only black.

A.

Il 20/ago/2014 17:04 Dave Barter dave.bar...@gmail.com ha scritto:
Yes, it appears to be related to the black colour
On 20 August 2014 at 16:03:15, Andrea Peri (aperi2...@gmail.com) wrote:

AFAIK
The same problem of the label is also on lines. See in your sample the 
boundaries of street.

A.

Il 20/ago/2014 16:53 Dave Barter dave.bar...@gmail.com ha scritto:
One final question for today!

When I use mapserver wms to serve the raster tiles from the file system, they 
look fine. But doing it from the database gives me problems with the black 
labels as can be seen by the image at 
http://phased.co.uk/wp-content/uploads/Screen-Shot-2014-08-20-at-15.49.09.png

Is there a way I can fix this? The rasters in the database are fine and not 
corrupted, I’ve checked this by exporting and viewing one.

Dave

-- 


___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] Postgis Raster Layer

2014-08-20 Thread Rahkonen Jukka (Tike)

I bet that 0 0 0 is interpreted as nodata for some reason.

-Jukka Rahkonen-


Lähettäjä: Dave Bartermailto:dave.bar...@gmail.com
Lähetetty: ‎20.‎8.‎2014 19:01
Vastaanottaja: 
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
Aihe: Re: [mapserver-users] Postgis Raster Layer

Further investigation in QGIS shows that it is pixel value 161 that is not 
displaying

gdalinfo tells me that  161: 0,0,0,255 for the raster

So, can I correct this in map server, and why is it not rendering it as black?

On 20 August 2014 at 16:12:06, Andrea Peri 
(aperi2...@gmail.commailto:aperi2...@gmail.com) wrote:

I guess iT is a resampling question.
My theory is that you dont see this issue with on polygon filled with solid 
color because the resample strategy find the same color in all the considered 
portion of polygon.
This is not true for  labels or lines.

If this theory is true, it should fail also with points and with other colors.
Not only black.

A.

Il 20/ago/2014 17:04 Dave Barter 
dave.bar...@gmail.commailto:dave.bar...@gmail.com ha scritto:
Yes, it appears to be related to the black colour

On 20 August 2014 at 16:03:15, Andrea Peri 
(aperi2...@gmail.commailto:aperi2...@gmail.com) wrote:

AFAIK
The same problem of the label is also on lines. See in your sample the 
boundaries of street.

A.

Il 20/ago/2014 16:53 Dave Barter 
dave.bar...@gmail.commailto:dave.bar...@gmail.com ha scritto:
One final question for today!

When I use mapserver wms to serve the raster tiles from the file system, they 
look fine. But doing it from the database gives me problems with the black 
labels as can be seen by the image at 
http://phased.co.uk/wp-content/uploads/Screen-Shot-2014-08-20-at-15.49.09.png

Is there a way I can fix this? The rasters in the database are fine and not 
corrupted, I’ve checked this by exporting and viewing one.

Dave

--


___
mapserver-users mailing list
mapserver-users@lists.osgeo.orgmailto:mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

___
mapserver-users mailing list
mapserver-users@lists.osgeo.orgmailto: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] Postgis Tile Index

Re: [mapserver-users] Postgis Tile Index

Re: [mapserver-users] Postgis Tile Index

Re: [mapserver-users] Postgis Tile Index

Re: [mapserver-users] Postgis Tile Index

Re: [mapserver-users] [EXTERNAL] Re: Postgis Tile Index

Re: [mapserver-users] [EXTERNAL] Re: Postgis Tile Index

Re: [mapserver-users] WMS request fails when spaces are encoded as plus symbol in query part of URL

[mapserver-users] Postgis Raster Layer

Re: [mapserver-users] Postgis Raster Layer

Re: [mapserver-users] Postgis Raster Layer

Re: [mapserver-users] Postgis Raster Layer

Re: [mapserver-users] Postgis Raster Layer

13 matches

Site Navigation

Mail list logo

Footer information