Re: [mapserver-users] Does Mapserver utilise Spatialite spatial index correctly?

2012-02-13 Thread Jeff McKenna 

Quite an interesting discussion!  Thanks guys.

-jeff



On 12-02-11 5:44 PM, Even Rouault wrote:

Jukka,

I've continued playing with your OSM data.

I've got extra performance by adding attribute indexes, so that every field you
use in a WHERE clause is indexed. For example for the roadsclose, railways and
landuse layers, you could create the following indexes:

CREATE INDEX idx_osm_line_railway ON osm_line(railway)
CREATE INDEX idx_osm_line_highway ON osm_line(highway)
CREATE INDEX idx_osm_polygon_landuse ON osm_polygon(landuse)
CREATE INDEX idx_osm_polygon_leisure ON osm_polygon(leisure)
CREATE INDEX idx_osm_polygon_amenity ON osm_polygon(amenity)
CREATE INDEX idx_osm_polygon_aeroway ON osm_polygon(aeroway)
CREATE INDEX idx_osm_polygon_natural ON osm_polygon(natural)
CREATE INDEX idx_osm_polygon_highway ON osm_polygon(highway)
CREATE INDEX idx_osm_polygon_waterway ON osm_polygon(waterway)





--
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/


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

SV: [mapserver-users] Run time substitution - Like instead of =

2012-02-13 Thread Thomas Ellett 
Hi Mike,

Thanks for getting back to me. Worked a treat, thanks!!

Ended up with prosjektnu = '%pn%' or '%pn%' = '\%pn\%' on the filter

Tom

-Opprinnelig melding-
Fra: Smith, Michael ERDC-CRREL-NH [mailto:michael.sm...@usace.army.mil] 
Sendt: 3. februar 2012 17:57
Til: Thomas Ellett; mapserver-users@lists.osgeo.org
Emne: Re: [mapserver-users] Run time substitution - Like instead of =

Tom,

What I am using with a database connection is a default value of 1=1
so
that is always true, it returns all records.

Mike

-- 
Michael Smith

Remote Sensing/GIS Center
US Army Corps of Engineers



On 2/3/12  11:30 AM, tellett thomas.ell...@statkart.no wrote:

Hi All,

I'm using runtime substitution to replace the value of an expression
and
thats working fine, however, if I don't set the expression value in the
url,
I want the layer to show all the records. For example my class looks
likes
this:

CLASS
 NAME 'FKB-A'
 EXPRESSION '%pn%'
 STYLE
COLOR 254 150 254
OUTLINECOLOR 1 1 1
 END
  END

and when I use this request:

.REQUEST=GetMapSERVICE=WMSVERSION=1.3.0LAYERS=fkb_prosjektstanda
rd
STYLES=FORMAT=image/pngBGCOLOR=0xFFTRANSPARENT=TRUECRS=EPSG:432
6B
BOX=58.9930983171506,9.40049150322111,59.8470137571506,10.904184647298
WID
TH=1650HEIGHT=937pn=LACHVE11

I get back 1 record which is correct. However, if I drop the
pn=LACHVE11
of
course I get no results back. Is there any way of changing this so that
I
can get all the records of the table returned?

I thought about using the 'default_pn' option in the metadata and using
wildcards but as this is an '=' expression rather than a 'LIKE'
expression
wildcards are useless. Maybe its just because its friday afternoon, but
I
just can't see a way of doing this, help!!!

Best Regards

Tom

--
View this message in context:
http://osgeo-org.1560.n6.nabble.com/Run-time-substitution-Like-instead-
of-
tp4362317p4362317.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

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

Re: [mapserver-users] php_mapscript.so library

2012-02-13 Thread Alan Boudreault 
The php_mapscript.so will be in the mapscript/php directory IIF you 
compiled MapServer with the appropriate option. I think you can open the 
config.log file to see if you have enabled the php binding when you 
compiled MS initially.


Alan

On 12-02-10 02:37 PM, David Quinn wrote:

Hi List,

I'm following the instructions
http://www.mapserver.org/installation/php.html#obtaining-compiling-and-installing-php-and-the-php-mapscript-module
on the Mapserver website to install the PHP module, but I'm confused by
this line:

Copy the php_mapscript.so library to your PHP extensions directory, and
then use the dl() function to load the module at the beginning of your
PHP scripts. See also the PHP function extension_loaded()
http://www.php.net/manual/en/function.extension-loaded.php to check
whether an extension is already loaded.

I just re-downloaded and unzipped mapserver-6.0.1 but I don't see the
php_mapscript.so library anywhere.

Also, is there a way that I check if I compiled Mapserver with
'/–with-php=DIR' /I compiled it for CentOS Linux a few months ago and
cannot remember all of the options that I chose.

Thanks,
David


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



--
Alan Boudreault
http://www.mapgears.com/
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

RE: [mapserver-users] Does Mapserver utilise Spatialite spatial index correctly?

2012-02-13 Thread Fawcett, David (MPCA) 
A pretty good story to tell when talking about the advantages of OpenSource 
software...

-Original Message-
From: mapserver-users-boun...@lists.osgeo.org 
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Rahkonen Jukka
Sent: Saturday, February 11, 2012 3:43 PM
To: Even Rouault; mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Does Mapserver utilise Spatialite spatial index 
correctly?

 Even Rouault wrote:


 I've commited improvements in GDAL trunk for both points (


Awesome!  About 25 times faster in the evening than it was in the morning. My 
opinion is that because Spatialite seems to be, at least in this case, more 
that two times faster backend for Mapserver than PostGIS it should lead to some 
intensive and controlled testing now.

Regards,

-Jukka Rahkonen-___
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] complex label

2012-02-13 Thread Lime, Steve D (DNR) 
With existing versions you'd have to use multiple layers and offsets but it's 
possible that collision detection would mess with the 3 components and you'd be 
left with partials. 

That said we just committed an initial implementation of RFC 77 which allows 
for the definition of multiple labels within a class. Each can draw content 
from different fields in the data and is rendered with different settings so 
you can change font, size, color etc... They're considered 1 label for 
collision detection purposes so no partials...

Configuration looks like:

LABELITEM 'big_letter'
CLASS
  ... styles ...
  LABEL
FONT 'arial-bold'
SIZE 24
POSITION CC
...
  END
  LABEL
FONT 'arial'
SIZE 8
TEXT '[subscript_number]' # behaves just like class-text
POSITION LR
OFFSET ... # probably have to play with values here
...
  END
  LABEL
FONT 'arial-bold'
SIZE 8
TEXT '([superscript_number])' # behaves just like class-text
POSITION UR
OFFSET ... # probably have to play with values here
...
  END
END

Labels can also have expressions defined so you can conditionally display label 
components.

Anyway, if you're brave you'd need to use trunk. Remember this is brand new and 
perhaps a bit buggy but any testing/feedback is appreciated.

Steve

-Original Message-
From: mapserver-users-boun...@lists.osgeo.org 
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of mmypost mmypost
Sent: Monday, February 13, 2012 1:06 AM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] complex label

Hi
Sorry for my bad English.

Can I draw complex label as attachment file by mapserver?
I think I can draw the label if I  separate the label for 3 field and apply 
offset property, but may be  exists more standard path?

Yours sincerely,
Sev

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

[mapserver-users] type Truetype error for label angle

2012-02-13 Thread maddqc 
Hi all,

I have a projet that I need to place the label with a specific angle.

But, if I understand it well, to use the angle, we need to have a TYPE
TRUETYPE, but I always get an error (pink screen of death) when I use this
type.

Seriously, I don't know how to solve this.

Thanks in advance.

Here is the error from the apache log file.

agg2GetTruetypeTextBBox(): TrueType Font error. AGG error loading font
(/opt/mapping/maps/fonts/tahoma.ttf), referer: http:.

Here is my MAPFILE

MAP
NAME Val Joli
SIZE 800 650
STATUS ON

CONFIG MS_ERRORFILE stderr
DEBUG 3

PROJECTION
init=epsg:32188
END #projection

EXTENT 414540 5040590 435170 5058350

UNITS meters

FONTSET /opt/mapping/maps/fonts/fontset.list
SYMBOLSET   /opt/mapping/maps/symbols/symbol.sym

# prevent the pink screen of death on large monitors
MAXSIZE 1

TRANSPARENT TRUE

#INCLUDE ../../mapping_globals.map

WEB
METADATA
  'ows_title'   'M.R.C. Val-St-François'
  'ows_srs' 'EPSG:26915 EPSG:900913 EPSG:32188 
EPSG:4326'
END
END

SYMBOL
NAME 'hatch-test'
TYPE HATCH
END #symbol

LAYER
NAME 'habillage1000'
DATA
'../420_MRC_Val_St_Francois/42095_ValJoli/42095_Habillage_1000_mtm8_text.shp'
STATUS ON
TYPE POINT

LABELITEM 'TEXTSTRING'
LABELCACHE ON
LABELMAXSCALE 2

CLASS
NAME 'habillage1000' 
STYLE
SIZE 7.0 
COLOR 0 0 0
END
LABEL
FONT tahoma
TYPE TRUETYPE
SIZE 12
COLOR 0 0 0
ANGLE [TEXT_ANGLE]
POSITION cc
FORCE true
ANTIALIAS true
PARTIALS true
END
END
TRANSPARENCY 100
END
END

--
View this message in context: 
http://osgeo-org.1560.n6.nabble.com/type-Truetype-error-for-label-angle-tp4465768p4465768.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

RE: [mapserver-users] type Truetype error for label angle

2012-02-13 Thread Lime, Steve D (DNR) 
If you take angles out of it do you still see the error? The message you 
reference makes me think
it's a more basic problem like a file not existing or permissions being wrong 
on that file.

Steve

-Original Message-
From: mapserver-users-boun...@lists.osgeo.org 
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of maddqc
Sent: Monday, February 13, 2012 11:29 AM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] type Truetype error for label angle

Hi all,

I have a projet that I need to place the label with a specific angle.

But, if I understand it well, to use the angle, we need to have a TYPE
TRUETYPE, but I always get an error (pink screen of death) when I use this
type.

Seriously, I don't know how to solve this.

Thanks in advance.

Here is the error from the apache log file.

agg2GetTruetypeTextBBox(): TrueType Font error. AGG error loading font
(/opt/mapping/maps/fonts/tahoma.ttf), referer: http:.

Here is my MAPFILE

MAP
NAME Val Joli
SIZE 800 650
STATUS ON

CONFIG MS_ERRORFILE stderr
DEBUG 3

PROJECTION
init=epsg:32188
END #projection

EXTENT 414540 5040590 435170 5058350

UNITS meters

FONTSET /opt/mapping/maps/fonts/fontset.list
SYMBOLSET   /opt/mapping/maps/symbols/symbol.sym

# prevent the pink screen of death on large monitors
MAXSIZE 1

TRANSPARENT TRUE

#INCLUDE ../../mapping_globals.map

WEB
METADATA
  'ows_title'   'M.R.C. Val-St-François'
  'ows_srs' 'EPSG:26915 EPSG:900913 EPSG:32188 
EPSG:4326'
END
END

SYMBOL
NAME 'hatch-test'
TYPE HATCH
END #symbol

LAYER
NAME 'habillage1000'
DATA
'../420_MRC_Val_St_Francois/42095_ValJoli/42095_Habillage_1000_mtm8_text.shp'
STATUS ON
TYPE POINT

LABELITEM 'TEXTSTRING'
LABELCACHE ON
LABELMAXSCALE 2

CLASS
NAME 'habillage1000' 
STYLE
SIZE 7.0 
COLOR 0 0 0
END
LABEL
FONT tahoma
TYPE TRUETYPE
SIZE 12
COLOR 0 0 0
ANGLE [TEXT_ANGLE]
POSITION cc
FORCE true
ANTIALIAS true
PARTIALS true
END
END
TRANSPARENCY 100
END
END

--
View this message in context: 
http://osgeo-org.1560.n6.nabble.com/type-Truetype-error-for-label-angle-tp4465768p4465768.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

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

[mapserver-users] RE: Circles around points in miles

2012-02-13 Thread Lime, Steve D (DNR) 
Couple of options depending on version:

  1) 6.x: buffer the points using a style geomtransform
  2) all versions: use layer SIZEUNITS to draw a circle symbol in miles

I think option 1 is more flexible but option 2 is probably faster.

Steve

-Original Message-
From: mapserver-users-boun...@lists.osgeo.org 
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Ian Walberg
Sent: Saturday, February 11, 2012 10:06 PM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] Circles around points in miles


We need to draw circles of 50 and 100 miles around a list of points.

How can we do this? 

Thanks

Ian
___
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] RE: type Truetype error for label angle

2012-02-13 Thread maddqc 
Thanks for your quick reply...

but no, if I comment the angle line, the error is still there. It really
comes from the truetype line.

--
View this message in context: 
http://osgeo-org.1560.n6.nabble.com/type-Truetype-error-for-label-angle-tp4465768p4465803.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] RE: type Truetype error for label angle

2012-02-13 Thread thomas bonfort 
does /opt/mapping/maps/fonts/tahoma.ttf exist, and is it accessible by
your web user ?

On Mon, Feb 13, 2012 at 18:39, maddqc qc_...@hotmail.com wrote:
 Thanks for your quick reply...

 but no, if I comment the angle line, the error is still there. It really
 comes from the truetype line.

 --
 View this message in context: 
 http://osgeo-org.1560.n6.nabble.com/type-Truetype-error-for-label-angle-tp4465768p4465803.html
 Sent from the Mapserver - User mailing list archive at Nabble.com.
 ___
 mapserver-users mailing list
 mapserver-users@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/mapserver-users
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] RE: type Truetype error for label angle

2012-02-13 Thread Richard Greenwood 
On Mon, Feb 13, 2012 at 10:46 AM, thomas bonfort
thomas.bonf...@gmail.com wrote:
 does /opt/mapping/maps/fonts/tahoma.ttf exist, and is it accessible by
 your web user ?

Also check the case of the file name on both the file system and in
/opt/mapping/maps/fonts/fontset.list


-- 
Richard Greenwood
richard.greenw...@gmail.com
www.greenwoodmap.com
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] Re: type Truetype error for label angle

2012-02-13 Thread maddqc 
Okay...now I'm ashamed...

Haha I've already looked inside the file fontset, but I've never asked
myself if the file tahoma was existing in the folder...I thought that
GeoMOOSE/MapServer was automatically loading the Microsoft Font...

Thanks to all of you guys!!! Now it works :D

--
View this message in context: 
http://osgeo-org.1560.n6.nabble.com/type-Truetype-error-for-label-angle-tp4465768p4465889.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] mapserv 5 - 6 symbol question

2012-02-13 Thread Richard Greenwood 
I'm upgrading a site from mapserver 5.6 to 6.0 and the attached symbol
has me stumped. I can't seem to replicate the style in 6.0.

My mapserver 5.6 definition that created the attached GIF is here:

SYMBOL
 NAME 'Circle_Open'
 TYPE ELLIPSE
 FILLED false
 POINTS 1 1 END
END

LAYER
 TYPE polygon
 TRANSPARENCY alpha
 CLASS
   STYLE
     COLOR 69 158 239
     OUTLINECOLOR 0 0 255
     SYMBOL 'Circle_Open'
     SIZE 1
   END
 END
END

In mapserver 6.0 I'm using the same SYMBOL definition. I have split
the outline into a separate STYLE block. But regardless of the SIZE or
WIDTH that I specify for the STYLE all I get is a solid fill. What am
I missing?

Thanks,
Rich

--
Richard Greenwood
richard.greenw...@gmail.com
www.greenwoodmap.com
attachment: fema1.gif___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] mapserv 5 - 6 symbol question

2012-02-13 Thread Brent Fraser 

Rich,

For my Intermittent Waterways in v6, I've used


   CLASS # intermittent
  NAME 'intermittent'
  EXPRESSION '1480132'
  STYLE
SYMBOL SmallDots
COLOR 221 230 254
GAP 2
  END
  STYLE
SYMBOL dashed5
PATTERN 5 5 END
WIDTH 1
OUTLINECOLOR 0 122 194
  END
END

where the symbol def is:

  SYMBOL
NAME 'dashed5'
TYPE SIMPLE
  END
  SYMBOL
NAME 'SmallDots'
TYPE ELLIPSE
POINTS 1 1 END
  END

Best Regards,
Brent Fraser


On 2/13/2012 1:22 PM, Richard Greenwood wrote:

I'm upgrading a site from mapserver 5.6 to 6.0 and the attached symbol
has me stumped. I can't seem to replicate the style in 6.0.

My mapserver 5.6 definition that created the attached GIF is here:

SYMBOL
  NAME 'Circle_Open'
  TYPE ELLIPSE
  FILLED false
  POINTS 1 1 END
END

LAYER
  TYPE polygon
  TRANSPARENCY alpha
  CLASS
STYLE
  COLOR 69 158 239
  OUTLINECOLOR 0 0 255
  SYMBOL 'Circle_Open'
  SIZE 1
END
  END
END

In mapserver 6.0 I'm using the same SYMBOL definition. I have split
the outline into a separate STYLE block. But regardless of the SIZE or
WIDTH that I specify for the STYLE all I get is a solid fill. What am
I missing?

Thanks,
Rich

--
Richard Greenwood
richard.greenw...@gmail.com
www.greenwoodmap.com


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

[mapserver-users] Trouble connecting to PostGIS

2012-02-13 Thread Bistrais, Bob 
First of all, let me state that I am brand new to PostGIS and don't know
much about what I'm doing with it.  That being said, I am having trouble
displaying a PostGIS layer through MapServer.

 

Right now I'm just experimenting with PostGIS and simply trying to get a
layer to display.  I installed the Postgre and PostGIS 1.5.  I used the
shapefile loader to convert a couple shapefiles to PostGIS data.
Looking in pgAdmin, I see the tables do indeed exist for these layers.

 

So I built a MapServer map file.  Here is my connection strings:

 

DATA the_geom from MylayerPoly

CONNECTION user=postgisuser password=MyPassword! dbname=postgistest
host=localhost port=5432

CONNECTIONTYPE postgis

 

But the layer does not display.  Incidentally, I'm using GeoMoose as a
front end for testing, but that shouldn't matter here.

 

I did a mapserv -v at commandline, and I see the parameter
INPUT=POSTGIS.

 

So as far as I know it should work. Can anyone offer suggestions as to
what I'm doing wrong?

 

Thanks,

Bob

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

Re: [mapserver-users] Trouble connecting to PostGIS

2012-02-13 Thread Brent Fraser 

Bob,
  Typical problems are
- the connecting user (postgisuser) does not have privilege to 
access the table
- coordinate system is not specified in data (SRID=-1) and not 
in the mapfile either

-  and others

Turn on the layer debug logging by adding

DEBUG 5

to your mapfile and looking a the log.  You can also execute the SQL 
statements shown in the log file using pgAdmin's SQL tool to see 
additional information.


Best Regards,
Brent Fraser


On 2/13/2012 2:11 PM, Bistrais, Bob wrote:


First of all, let me state that I am brand new to PostGIS and don't 
know much about what I'm doing with it.  That being said, I am having 
trouble displaying a PostGIS layer through MapServer.


Right now I'm just experimenting with PostGIS and simply trying to get 
a layer to display.  I installed the Postgre and PostGIS 1.5.  I used 
the shapefile loader to convert a couple shapefiles to PostGIS data.  
Looking in pgAdmin, I see the tables do indeed exist for these layers.


So I built a MapServer map file.  Here is my connection strings:

DATA the_geom from MylayerPoly

CONNECTION user=postgisuser password=MyPassword! dbname=postgistest 
host=localhost port=5432


CONNECTIONTYPE postgis

But the layer does not display.  Incidentally, I'm using GeoMoose as a 
front end for testing, but that shouldn't matter here.


I did a mapserv --v at commandline, and I see the parameter INPUT=POSTGIS.

So as far as I know it should work. Can anyone offer suggestions as to 
what I'm doing wrong?


Thanks,

Bob



___
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] Trouble connecting to PostGIS

2012-02-13 Thread Bistrais, Bob 
Thanks Brent.  The postgis user SHOULD have access to the table, as that
is the table's owner.  Coordinate system is in the map file under
Projection.

 

Here is what the debug log showed me (Metwp100Poly is the actual name of
the table, and MAINE is the layer name):

 

[Mon Feb 13 16:31:32 2012].453000 CGI Request 1 on process 1300

[Mon Feb 13 16:31:32 2012].687000 msPOSTGISLayerRetrievePGVersion():
Query error. Error executing POSTGIS statement
(msPOSTGISLayerRetrievePGVersion():select substring(version() from 12
for (position('on' in version()) - 13))

[Mon Feb 13 16:31:32 2012].687000 prepare_database(): Query error. Error
declaring cursor: ERROR:  relation metwp100poly does not exist

LINE 1: ...lection(force_2d(the_geom)),'NDR'),OID::text from
Metwp100Po...

 ^

 

With query string: DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from
Metwp100Poly WHERE the_geom  setSRID('BOX3D(134000
4692598.18523154,890900 5307401.81476846)'::BOX3D,
find_srid('','Metwp100Poly','the_geom') )

 

[Mon Feb 13 16:31:32 2012].687000 msDrawMap(): Image handling error.
Failed to draw layer named 'MAINE'.

[Mon Feb 13 16:31:32 2012].687000 msFreeMap(): freeing map at 015258C8.

 



From: Brent Fraser [mailto:bfra...@geoanalytic.com] 
Sent: Monday, February 13, 2012 4:25 PM
To: Bistrais, Bob
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Trouble connecting to PostGIS

 

Bob,
  Typical problems are 
- the connecting user (postgisuser) does not have privilege to
access the table
- coordinate system is not specified in data (SRID=-1) and not
in the mapfile either
-  and others

Turn on the layer debug logging by adding 

DEBUG 5

to your mapfile and looking a the log.  You can also execute the SQL
statements shown in the log file using pgAdmin's SQL tool to see
additional information.
  



Best Regards,
Brent Fraser


On 2/13/2012 2:11 PM, Bistrais, Bob wrote: 

First of all, let me state that I am brand new to PostGIS and don't know
much about what I'm doing with it.  That being said, I am having trouble
displaying a PostGIS layer through MapServer.

 

Right now I'm just experimenting with PostGIS and simply trying to get a
layer to display.  I installed the Postgre and PostGIS 1.5.  I used the
shapefile loader to convert a couple shapefiles to PostGIS data.
Looking in pgAdmin, I see the tables do indeed exist for these layers.

 

So I built a MapServer map file.  Here is my connection strings:

 

DATA the_geom from MylayerPoly

CONNECTION user=postgisuser password=MyPassword! dbname=postgistest
host=localhost port=5432

CONNECTIONTYPE postgis

 

But the layer does not display.  Incidentally, I'm using GeoMoose as a
front end for testing, but that shouldn't matter here.

 

I did a mapserv -v at commandline, and I see the parameter
INPUT=POSTGIS.

 

So as far as I know it should work. Can anyone offer suggestions as to
what I'm doing wrong?

 

Thanks,

Bob






___
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] RE: mapserver-users Digest, Vol 49, Issue 34

2012-02-13 Thread Bistrais, Bob 
Is this a clue?  Looking at the debug, I see the following:

find_srid('','Metwp100Poly','the_geom') )

Notice the first parameter is blank.  What should be there?



-Original Message-
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of
mapserver-users-requ...@lists.osgeo.org
Sent: Monday, February 13, 2012 4:35 PM
To: mapserver-users@lists.osgeo.org
Subject: mapserver-users Digest, Vol 49, Issue 34

Send mapserver-users mailing list submissions to
mapserver-users@lists.osgeo.org

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.osgeo.org/mailman/listinfo/mapserver-users
or, via email, send a message with subject or body 'help' to
mapserver-users-requ...@lists.osgeo.org

You can reach the person managing the list at
mapserver-users-ow...@lists.osgeo.org

When replying, please edit your Subject line so it is more specific
than Re: Contents of mapserver-users digest...
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] RE: mapserver-users Digest, Vol 49, Issue 34

2012-02-13 Thread Brent Fraser 
Maybe.  I was just doing a load of a table to test TinyOWS and noticed 
the default is -1 for shp2pgsql.  So I used the -s option:


shp2pgsql -s 4269 tl_2010_27_place10.shp  public.CensusCities  
CensusCities.sql


Can you reload the table using an SRID on the commandline?

Best Regards,
Brent Fraser


On 2/13/2012 2:38 PM, Bistrais, Bob wrote:

Is this a clue?  Looking at the debug, I see the following:

find_srid('','Metwp100Poly','the_geom') )

Notice the first parameter is blank.  What should be there?



-Original Message-
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of
mapserver-users-requ...@lists.osgeo.org
Sent: Monday, February 13, 2012 4:35 PM
To: mapserver-users@lists.osgeo.org
Subject: mapserver-users Digest, Vol 49, Issue 34

Send mapserver-users mailing list submissions to
mapserver-users@lists.osgeo.org

To subscribe or unsubscribe via the World Wide Web, visit
http://lists.osgeo.org/mailman/listinfo/mapserver-users
or, via email, send a message with subject or body 'help' to
mapserver-users-requ...@lists.osgeo.org

You can reach the person managing the list at
mapserver-users-ow...@lists.osgeo.org

When replying, please edit your Subject line so it is more specific
than Re: Contents of mapserver-users digest...
___
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] Trouble connecting to PostGIS

2012-02-13 Thread Jeff McKenna 
I'd use Brent's advice of always specifying a projection when loading 
the data into PG.  Then make sure your DATA statement uses that SRID:


  DATA the_geom from test using SRID=4326 using unique id

  or

  DATA the_geom from test using SRID=-1 using unique id

I try to document my usual steps at 
http://www.mapserver.org/input/vector/postgis.html


-jeff




--
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/


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

Re: [mapserver-users] Trouble connecting to PostGIS

2012-02-13 Thread pcreso 
Hi Bob,


I suggest you try testing with QGIS.

Easy to open the native postgis table  a mapserver WFS/WMS layer concurrently 
to ensure it is all working as it should.

Also ensure you have configured your Postgis (Postgres) database to allow 
applications such as mapserver to connect. For testing purposes, set access to 
the database to trusted for all in pb_hba.conf,  enable external connections 
in postgresql.conf, then restart the server to ensure the changes are activated.

You can also enable mapserver debugging  specify a log file to see what error 
is reported.
http://mapserver.org/optimization/debugging.html

You may also need to specify the unique ID column name  the SRID you are using 
in your DATA string, much like this one:
DATA track_line from (select * from trip_track where trip_code = 'ind0701') as 
foo using unique id using srid 4326

HTH,

   Brent Wood

--- On Tue, 2/14/12, Bistrais, Bob bob.bistr...@maine.gov wrote:

From: Bistrais, Bob bob.bistr...@maine.gov
Subject: [mapserver-users] Trouble connecting to PostGIS
To: mapserver-users@lists.osgeo.org
Date: Tuesday, February 14, 2012, 10:11 AM




 
 










First of all, let me state that I am brand new to PostGIS
and don’t know much about what I’m doing with it.  That being said,
I am having trouble displaying a PostGIS layer through MapServer. 

   

Right now I’m just experimenting with PostGIS and
simply trying to get a layer to display.  I installed the Postgre and PostGIS
1.5.  I used the shapefile loader to convert a couple shapefiles to PostGIS
data.  Looking in pgAdmin, I see the tables do indeed exist for these layers. 

   

So I built a MapServer map file.  Here is my connection
strings: 

   

DATA the_geom from MylayerPoly 

CONNECTION user=postgisuser password=MyPassword!
dbname=postgistest host=localhost port=5432 

CONNECTIONTYPE postgis 

   

But the layer does not display.  Incidentally, I’m
using GeoMoose as a front end for testing, but that shouldn’t matter
here. 

   

I did a mapserv –v at commandline, and I see the
parameter INPUT=POSTGIS. 

   

So as far as I know it should work. Can anyone offer
suggestions as to what I’m doing wrong? 

   

Thanks, 

Bob 







-Inline Attachment Follows-

___
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] Trouble connecting to PostGIS

2012-02-13 Thread Puneet Kishor 

On Feb 13, 2012, at 3:35 PM, Bistrais, Bob wrote:

 Thanks Brent.  The postgis user SHOULD have access to the table, as that
 is the table's owner.  Coordinate system is in the map file under
 Projection.
 
 
 
 Here is what the debug log showed me (Metwp100Poly is the actual name of
 the table, and MAINE is the layer name):
 
 
 
 [Mon Feb 13 16:31:32 2012].453000 CGI Request 1 on process 1300
 
 [Mon Feb 13 16:31:32 2012].687000 msPOSTGISLayerRetrievePGVersion():
 Query error. Error executing POSTGIS statement
 (msPOSTGISLayerRetrievePGVersion():select substring(version() from 12
 for (position('on' in version()) - 13))
 
 [Mon Feb 13 16:31:32 2012].687000 prepare_database(): Query error. Error
 declaring cursor: ERROR:  relation metwp100poly does not exist
 ..

The error above is telling you that it can't even find the said table. 

Can you SELECT from this table successfully in PgAdmin?

Is it in a different schema than public, and perhaps that schema is not in the 
searchpath?

Does the postgisuser have access to this table?

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

RE: [mapserver-users] RE: mapserver-users Digest, Vol 49, Issue 34

2012-02-13 Thread Bistrais, Bob 
I've been using the shapefile loader utility, and it also defaults to an
srs of -1.  I'm not sure of the command line syntax for this command,
after the shapefile name, so I was using the utility.  But entering an
SRS in that box, I still get the same thing in the error message with
the blank parameter.


-Original Message-
From: Brent Fraser [mailto:bfra...@geoanalytic.com] 
Sent: Monday, February 13, 2012 4:42 PM
To: Bistrais, Bob
Cc: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] RE: mapserver-users Digest, Vol 49, Issue
34

Maybe.  I was just doing a load of a table to test TinyOWS and noticed 
the default is -1 for shp2pgsql.  So I used the -s option:

shp2pgsql -s 4269 tl_2010_27_place10.shp  public.CensusCities  
CensusCities.sql

Can you reload the table using an SRID on the commandline?

Best Regards,
Brent Fraser


On 2/13/2012 2:38 PM, Bistrais, Bob wrote:
 Is this a clue?  Looking at the debug, I see the following:

 find_srid('','Metwp100Poly','the_geom') )

 Notice the first parameter is blank.  What should be there?



 -Original Message-
 From: mapserver-users-boun...@lists.osgeo.org
 [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of
 mapserver-users-requ...@lists.osgeo.org
 Sent: Monday, February 13, 2012 4:35 PM
 To: mapserver-users@lists.osgeo.org
 Subject: mapserver-users Digest, Vol 49, Issue 34

 Send mapserver-users mailing list submissions to
   mapserver-users@lists.osgeo.org

 To subscribe or unsubscribe via the World Wide Web, visit
   http://lists.osgeo.org/mailman/listinfo/mapserver-users
 or, via email, send a message with subject or body 'help' to
   mapserver-users-requ...@lists.osgeo.org

 You can reach the person managing the list at
   mapserver-users-ow...@lists.osgeo.org

 When replying, please edit your Subject line so it is more specific
 than Re: Contents of mapserver-users digest...
 ___
 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] Trouble connecting to PostGIS

2012-02-13 Thread Jeff McKenna 

On 12-02-13 6:05 PM, Puneet Kishor wrote:

The error above is telling you that it can't even find the said table.

Can you SELECT from this table successfully in PgAdmin?

Is it in a different schema than public, and perhaps that schema is not in the 
searchpath?

Does the postgisuser have access to this table?



For any dataset, I always always always (did I say always?) start with 
an ogrinfo command, to test the connection (in this case the connection 
to PG).  The syntax is documented on that same page: 
http://www.mapserver.org/input/vector/postgis.html  I don't ever move to 
MapServer testing before ogrinfo is happy.  (hint: you can pass SQL 
queries to your database through ogrinfo with the -sql switch)


-jeff




--
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/


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

Re: [mapserver-users] Trouble connecting to PostGIS

2012-02-13 Thread Brent Fraser 
And I seem to recall needing to give some privileges on the 
spatial_ref_sys and geometry_columns  tables to the user.


Best Regards,
Brent Fraser


On 2/13/2012 3:05 PM, Puneet Kishor wrote:

On Feb 13, 2012, at 3:35 PM, Bistrais, Bob wrote:


Thanks Brent.  The postgis user SHOULD have access to the table, as that
is the table's owner.  Coordinate system is in the map file under
Projection.



Here is what the debug log showed me (Metwp100Poly is the actual name of
the table, and MAINE is the layer name):



[Mon Feb 13 16:31:32 2012].453000 CGI Request 1 on process 1300

[Mon Feb 13 16:31:32 2012].687000 msPOSTGISLayerRetrievePGVersion():
Query error. Error executing POSTGIS statement
(msPOSTGISLayerRetrievePGVersion():select substring(version() from 12
for (position('on' in version()) - 13))

[Mon Feb 13 16:31:32 2012].687000 prepare_database(): Query error. Error
declaring cursor: ERROR:  relation metwp100poly does not exist
..

The error above is telling you that it can't even find the said table.

Can you SELECT from this table successfully in PgAdmin?

Is it in a different schema than public, and perhaps that schema is not in the 
searchpath?

Does the postgisuser have access to this table?

--
Puneet Kishor___
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] RE: Circles around points in miles

2012-02-13 Thread Ian Walberg 
Steve,

Many thanks for the help and we have just tested option 2 and that
works.

We are using 6.x but are not exactly sure how to use the geomtransform
to do this. Do you have  an example?

Regards

Ian

-Original Message-
From: Lime, Steve D (DNR) [mailto:steve.l...@state.mn.us] 
Sent: Monday, February 13, 2012 9:37 AM
To: Ian Walberg; mapserver-users@lists.osgeo.org
Subject: RE: Circles around points in miles

Couple of options depending on version:

  1) 6.x: buffer the points using a style geomtransform
  2) all versions: use layer SIZEUNITS to draw a circle symbol in miles

I think option 1 is more flexible but option 2 is probably faster.

Steve

-Original Message-
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Ian
Walberg
Sent: Saturday, February 11, 2012 10:06 PM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] Circles around points in miles


We need to draw circles of 50 and 100 miles around a list of points.

How can we do this? 

Thanks

Ian
___
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] Trouble connecting to PostGIS

2012-02-13 Thread Bistrais, Bob 
I changed my Data statement similar to what you did here, Brent, and it
still comes up with an error, but the message shows that there is
something wrong with the select statement, so maybe this is another
clue:

 

prepare_database(): Query error. Error declaring cursor: ERROR:  syntax
error at or near select

LINE 1: ..._2d(the_geom)),'NDR'),gid::text from Metwp100Poly(select *
f...

 ^

 

With query string: DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from
Metwp100Poly(select * from Metwp100Poly where land='y') as foo WHERE
the_geom  setSRID('BOX3D(134000 4692598.18523154,890900
5307401.81476846)'::BOX3D, 26919 )

 



From: pcr...@pcreso.com [mailto:pcr...@pcreso.com] 
Sent: Monday, February 13, 2012 5:01 PM
To: mapserver-users@lists.osgeo.org; Bistrais, Bob
Subject: Re: [mapserver-users] Trouble connecting to PostGIS

 

Hi Bob,


I suggest you try testing with QGIS.

Easy to open the native postgis table  a mapserver WFS/WMS layer
concurrently to ensure it is all working as it should.

Also ensure you have configured your Postgis (Postgres) database to
allow applications such as mapserver to connect. For testing purposes,
set access to the database to trusted for all in pb_hba.conf,  enable
external connections in postgresql.conf, then restart the server to
ensure the changes are activated.

You can also enable mapserver debugging  specify a log file to see what
error is reported.
http://mapserver.org/optimization/debugging.html

You may also need to specify the unique ID column name  the SRID you
are using in your DATA string, much like this one:
DATA track_line from (select * from trip_track where trip_code =
'ind0701') as foo using unique id using srid 4326

HTH,

   Brent Wood

--- On Tue, 2/14/12, Bistrais, Bob bob.bistr...@maine.gov wrote:


From: Bistrais, Bob bob.bistr...@maine.gov
Subject: [mapserver-users] Trouble connecting to PostGIS
To: mapserver-users@lists.osgeo.org
Date: Tuesday, February 14, 2012, 10:11 AM

First of all, let me state that I am brand new to PostGIS and don't know
much about what I'm doing with it.  That being said, I am having trouble
displaying a PostGIS layer through MapServer.

 

Right now I'm just experimenting with PostGIS and simply trying to get a
layer to display.  I installed the Postgre and PostGIS 1.5.  I used the
shapefile loader to convert a couple shapefiles to PostGIS data.
Looking in pgAdmin, I see the tables do indeed exist for these layers.

 

So I built a MapServer map file.  Here is my connection strings:

 

DATA the_geom from MylayerPoly

CONNECTION user=postgisuser password=MyPassword! dbname=postgistest
host=localhost port=5432

CONNECTIONTYPE postgis

 

But the layer does not display.  Incidentally, I'm using GeoMoose as a
front end for testing, but that shouldn't matter here.

 

I did a mapserv -v at commandline, and I see the parameter
INPUT=POSTGIS.

 

So as far as I know it should work. Can anyone offer suggestions as to
what I'm doing wrong?

 

Thanks,

Bob


-Inline Attachment Follows-

___
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] Trouble connecting to PostGIS

2012-02-13 Thread Bistrais, Bob 
I think we're out of the woods, and special thanks to TC Haddad for the
solution...

 

TC suggested that I check the upper/lower case of the table name.  I had
this correct, but it gave me an idea of something to try- I created a
new table of the same shapefile, only this time the table name is all
lower case.  Using that in my map file, the map image appears correctly.

 

Thanks everyone for their input!  I'm sure it won't be the last ou hear
from me on PostGIS, but at least we're off and running!

 

BB

 

 



From: pcr...@pcreso.com [mailto:pcr...@pcreso.com] 
Sent: Monday, February 13, 2012 5:01 PM
To: mapserver-users@lists.osgeo.org; Bistrais, Bob
Subject: Re: [mapserver-users] Trouble connecting to PostGIS

 

Hi Bob,


I suggest you try testing with QGIS.

Easy to open the native postgis table  a mapserver WFS/WMS layer
concurrently to ensure it is all working as it should.

Also ensure you have configured your Postgis (Postgres) database to
allow applications such as mapserver to connect. For testing purposes,
set access to the database to trusted for all in pb_hba.conf,  enable
external connections in postgresql.conf, then restart the server to
ensure the changes are activated.

You can also enable mapserver debugging  specify a log file to see what
error is reported.
http://mapserver.org/optimization/debugging.html

You may also need to specify the unique ID column name  the SRID you
are using in your DATA string, much like this one:
DATA track_line from (select * from trip_track where trip_code =
'ind0701') as foo using unique id using srid 4326

HTH,

   Brent Wood

--- On Tue, 2/14/12, Bistrais, Bob bob.bistr...@maine.gov wrote:


From: Bistrais, Bob bob.bistr...@maine.gov
Subject: [mapserver-users] Trouble connecting to PostGIS
To: mapserver-users@lists.osgeo.org
Date: Tuesday, February 14, 2012, 10:11 AM

First of all, let me state that I am brand new to PostGIS and don't know
much about what I'm doing with it.  That being said, I am having trouble
displaying a PostGIS layer through MapServer.

 

Right now I'm just experimenting with PostGIS and simply trying to get a
layer to display.  I installed the Postgre and PostGIS 1.5.  I used the
shapefile loader to convert a couple shapefiles to PostGIS data.
Looking in pgAdmin, I see the tables do indeed exist for these layers.

 

So I built a MapServer map file.  Here is my connection strings:

 

DATA the_geom from MylayerPoly

CONNECTION user=postgisuser password=MyPassword! dbname=postgistest
host=localhost port=5432

CONNECTIONTYPE postgis

 

But the layer does not display.  Incidentally, I'm using GeoMoose as a
front end for testing, but that shouldn't matter here.

 

I did a mapserv -v at commandline, and I see the parameter
INPUT=POSTGIS.

 

So as far as I know it should work. Can anyone offer suggestions as to
what I'm doing wrong?

 

Thanks,

Bob


-Inline Attachment Follows-

___
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] RE: Circles around points in miles

2012-02-13 Thread Lime, Steve D (DNR) 
I jumped the gun on the geomtransform idea. The support is there but because it 
operates at the style level buffer distances must be given in pixels and 
there's no easy way to convert a map distance (e.g. 10 miles) to pixels. I 
really should make some runtime constants (for example, extent, scale and 
cellsize) available to expressions- then you could do this.

Glad you picked option 2 to start.

Steve

-Original Message-
From: Ian Walberg [mailto:ian.walb...@airborne.aero] 
Sent: Monday, February 13, 2012 4:38 PM
To: Lime, Steve D (DNR); mapserver-users@lists.osgeo.org
Subject: RE: Circles around points in miles

Steve,

Many thanks for the help and we have just tested option 2 and that
works.

We are using 6.x but are not exactly sure how to use the geomtransform
to do this. Do you have  an example?

Regards

Ian

-Original Message-
From: Lime, Steve D (DNR) [mailto:steve.l...@state.mn.us] 
Sent: Monday, February 13, 2012 9:37 AM
To: Ian Walberg; mapserver-users@lists.osgeo.org
Subject: RE: Circles around points in miles

Couple of options depending on version:

  1) 6.x: buffer the points using a style geomtransform
  2) all versions: use layer SIZEUNITS to draw a circle symbol in miles

I think option 1 is more flexible but option 2 is probably faster.

Steve

-Original Message-
From: mapserver-users-boun...@lists.osgeo.org
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Ian
Walberg
Sent: Saturday, February 11, 2012 10:06 PM
To: mapserver-users@lists.osgeo.org
Subject: [mapserver-users] Circles around points in miles


We need to draw circles of 50 and 100 miles around a list of points.

How can we do this? 

Thanks

Ian
___
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] Re: [gdal-dev] Re: Unreliable names for temporary files

2012-02-13 Thread Rahkonen Jukka 


Even Rouault wrote:


Le lundi 13 février 2012 06:22:31, Jukka Rahkonen a écrit :
 Even Rouault even.rouault at mines-paris.org writes:
  Le dimanche 12 février 2012 14:25:07, Jukka Rahkonen a écrit :
   Hi,
  
   I noticed a ticket http://trac.osgeo.org/gdal/ticket/4510 and started
   to wonder if something similar can happen also elsewhere. I have had
   troubles with Mapserver OGR output and they are somehow related to
   temporary files (both physisical and vsimem files). See
   http://lists.maptools.org/pipermail/ms4w-users/2012-February/001948.htm
   l for some details.
 
  Jukka,
 
  The issue with the mapfile in http://lists.maptools.org/pipermail/ms4w-
  users/2012-February/001948.html is the default filename. For the CSV
  driver to create a single file, you need to change the filename to
  something ending with .csv (for example default_outfile out.csv),
  otherwise the CSV driver will create a directory, and when MapServer
  tries to read the filename, it is confused because it finds a directory,
  and not a file.

 Now I have these outputformats

 OUTPUTFORMAT
   NAME SHAPEZIP
   DRIVER OGR/ESRI Shapefile
   MIMETYPE application/shapefile
   FORMATOPTION STORAGE=memory
   FORMATOPTION FORM=zip
   FORMATOPTION FILENAME=shape.zip
 END
 OUTPUTFORMAT
   NAME CSV
   DRIVER OGR/CSV
   MIMETYPE text/csv
   FORMATOPTION LCO:GEOMETRY=AS_WKT
   FORMATOPTION STORAGE=filesystem
   FORMATOPTION FORM=simple
   FORMATOPTION FILENAME=out.csv
 END

 You can try them:

 http://188.64.1.61/cgi-bin/mapserver_wfs?service=wfsversion=1.1.0request=
 getfeaturetypename=municipalitiesoutputformat=CSV Result is probably
 Failed to open result file

 http://188.64.1.61/cgi-bin/mapserver_wfs?service=wfsversion=1.1.0request=
 getfeaturetypename=municipalitiesoutputformat=SHAPEZIP Result is probably
 an empty zip file.

 CC'ing to mapserver-users list.

 Similar requests with the 2 above outputformats work great on my local
 mapserver instance, so I suspect something wrong in your setup. If I issue the
 CSV request on your server, I see the following error message :
 ?xml version=1.0 encoding=UTF-8?
 ows:ExceptionReport xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
 xmlns:ows=http://www.opengis.net/ows; version=1.1.0 language=en-US
 xsi:schemaLocation=http://www.opengis.net/ows
 http://schemas.opengis.net/ows/1.0.0/owsExceptionReport.xsd;
 ows:Exception exceptionCode=NoApplicableCode locator=mapserv
 ows:ExceptionTextmsOGRWriteFromQuery(): General error message. Failed to
 open result file '/usr/temp/4f3988d4_287f_0/out.csv'./ows:ExceptionText
   /ows:Exception
 /ows:ExceptionReport

 The /usr/temp/ path look suspicious to me...

Hi,

/usr/temp/ has  rights and it is good enough for the MS_ERRORFILE...

Short history of my trials:
- half a year ago tried to set up ogroutput with no success
- read a message about using temppath in the mapfile and added that parameter
- SHPZIP and CSV outpur started to work and I was happy
- but in the same evening the Failed to open result file errors came back
- never again had a new success with that Linux server
- not a single success with several Windows computers
- last week tried the new MS4W 3.0.4beta1 on Windows
- succeeded to make ogroutput to work for a while
- was suspicious and restarted Apache and started to get Failed to open 
result file errors again

It can of course be that I am just repeating my own errors but weird is that I 
have received valid CSV an SHAPEZIP outputs but only for a while.

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