AW: [mapserver-users] GPX format supported?
Hi, I think the 'END' keyword after 'OPACITY 100' shouldn't be there since it terminates the LAYER block. LAYER NAME 'GPS' TYPE POINT CONNECTIONTYPE OGR CONNECTION '/Applications/MAMP/d/DATA/NonGrassFiles/GPX/gpsbabel_output.gpx' DATA 'Waypoints' STATUS ON DEBUG 5 OPACITY 100 # END <-- terminates LAYER LABELITEM 'name' CLASS NAME 'name = Waypoint' STYLE SYMBOL 'circle' SIZE 8 OUTLINECOLOR 0 0 0 COLOR 255 255 0 END LABEL SIZE medium COLOR 0 0 0 ANGLE 0 BUFFER 1 END END END Von: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] Im Auftrag von b...@warbaby.com Gesendet: Montag, 12. Januar 2009 02:54 An: mapserver-users@lists.osgeo.org Betreff: [mapserver-users] GPX format supported? Hello, I am building an application with Mapserver 5.20. I am trying to include the ability for a local user to display GPX files downloaded from their GPS unit. I compiled OGR and Mapserver with the latest version of expat. I have found very few examples of how to write this layer and have ad no success in displaying the data. I have verified the GPX XML and have tried KML files as well. Has anyone had any luck with this feature? I have included the layer from the mapfile. It currently fails to parse on "LABELITEM" if that is removed it fails on "CLASS". Any help would be much appreciated! Thank You, Bean LAYER NAME 'GPS' TYPE POINT CONNECTIONTYPE OGR CONNECTION '/Applications/MAMP/d/DATA/NonGrassFiles/GPX/gpsbabel_output.gpx' DATA 'Waypoints' STATUS ON DEBUG 5 OPACITY 100 END LABELITEM 'name' CLASS NAME 'name = Waypoint' STYLE SYMBOL 'circle' SIZE 8 OUTLINECOLOR 0 0 0 COLOR 255 255 0 END LABEL SIZE medium COLOR 0 0 0 ANGLE 0 BUFFER 1 END END END ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] MapServer on Intel Atom?
I think the atom will be more than adequate... depending on the dataset. :-) Serving 100 points is significantly less intensive than serving 100 city-boundary polygons. (Oops forgot to send to the list) - Original Message > From: "kreshna_icehe...@yahoo.com" > To: mapserver-users@lists.osgeo.org > Sent: Monday, January 12, 2009 8:09:15 PM > Subject: [mapserver-users] MapServer on Intel Atom? > > I'll be doing a lot of MapServer demo in the future. I'm quite interested in > Intel Atom-based subnotebooks for the purpose (like Lenovo IdeaPad S10), > since > they are light and mobile. > > However, I wonder if Intel Atom is adequate to run MapServer. The MapServer > will > be run on either ms4w on Windows XP, or directly on Linux. The layers are > stored > on postGIS (there are fifteen layers or so), and there is also a 476 > megabytes > raster file in .TIFF format. > > Will Intel Atom be adequate for the purpose? Will 2GB of memory help? Has > anyone > ever done such thing before? > > Many thanks, > -Kresh > > > > ___ > 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] MapServer on Intel Atom?
I'll be doing a lot of MapServer demo in the future. I'm quite interested in Intel Atom-based subnotebooks for the purpose (like Lenovo IdeaPad S10), since they are light and mobile. However, I wonder if Intel Atom is adequate to run MapServer. The MapServer will be run on either ms4w on Windows XP, or directly on Linux. The layers are stored on postGIS (there are fifteen layers or so), and there is also a 476 megabytes raster file in .TIFF format. Will Intel Atom be adequate for the purpose? Will 2GB of memory help? Has anyone ever done such thing before? Many thanks, -Kresh ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Re: Conexion with postgres-postgis
thank you all, I solved the problem...
2009/1/12 Ben Madin
> I'm certainly no expert, and I'm guessing it would have helped if you had
> included more of your layer definition:
>
>
> On 13/01/2009, at 1:28 AM, mapserver-users-requ...@lists.osgeo.org wrote:
>
> msDrawMap(): Image handling error. Failed to draw layer named
>> 'chile_comuna'. prepare_database(): Query error. Error executing POSTGIS
>> DECLARE (the actual query) statement: 'DECLARE mycursor BINARY CURSOR FOR
>>
>
> Here's (essentially) the query MapServer asked of PostGIS :
>
> SELECT
>> "NAME"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text
>> from chile_comuna WHERE the_geom && setSRID('BOX3D(-71.2556639435156
>> -29.9271886101172,-71.2540857172265 -29.9256103838281)'::BOX3D,
>> find_srid('','chile_comuna','the_geom') )'
>>
>
> Here's the problem PostGIS reported with it.
>
> Postgresql reports the error as 'ERROR: column "NAME" does not exist LINE
>> 1: DECLARE mycursor BINARY CURSOR FOR SELECT "NAME"::text,asbin... ^ '
>>
>
> It looks to my inexperienced eyes that somewhere in the layer (classitem?)
> it includes a reference to a field NAME.
>
> It may be that it needs to be specified in the query. Check the table you
> imported into PostgreSQL, ie: (I made this up)
>
> # \d chile_comuna
>
> Column| Type|
> Modifiers
>
> -+-+-
> gid | integer | not null default
> nextval('gis_urban_gid_seq'::regclass)
> commune_name| character varying(24) |
> the_geom| geometry|
>
>
> More Help: Error with POSTGIS data variable. You specified 'check your .map
>> file'. Standard ways of specifiying are : (1) 'geometry_column from
>> geometry_table'
>>
>
> This is what you have used, but it only returns the_geom, you need to
> specify the table column AS name
>
> (2) 'geometry_column from (sub query) as foo using unique column name using
>> SRID=srid#' Make sure you put in the 'using unique column name' and 'using
>> SRID=#' clauses in.
>>
>
> Try also specifying the name column (assuming it does exist in the table):
>
> the_geom from (gid, the_geom, commune_name AS name from chile_comuna) as
> foo using unique column gid using SRID= 4326;
>
>
> For more help, please see http://postgis.refractions.net/documentation/
> Mappostgis.c
>> - version of Jan 23/2004.
>>
>> I use the command shp2pgsql to pass the information of the shapefile to
>> postgres table.
>>
>> MapFile
>> LAYER
>>NAME 'chile_comuna'
>>TYPE POLYGON
>>#DATA 'chile_comuna.shp'
>>CONNECTIONTYPE postgis
>> CONNECTION "user=postgres password=1234 dbname=geo_referencia
>> host=localhost"
>> DATA "the_geom from chile_comuna"
>> .
>>
>> can anyone help me? pleasee...
>>
>
> cheers
>
> Ben
>
>
>
>
> --
>
> Ben Madin
> REMOTE INFORMATION
>
> t : +61 8 9192 5455
> f : +61 8 9192 5535
> m : 0448 887 220
> Broome WA 6725
>
> b...@remoteinformation.com.au
>
>
>
>Out here, it pays to
> know...
>
>
> ___
> 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: Conexion with postgres-postgis
I'm certainly no expert, and I'm guessing it would have helped if you
had included more of your layer definition:
On 13/01/2009, at 1:28 AM, mapserver-users-requ...@lists.osgeo.org
wrote:
msDrawMap(): Image handling error. Failed to draw layer named
'chile_comuna'. prepare_database(): Query error. Error executing
POSTGIS DECLARE (the actual query) statement: 'DECLARE mycursor
BINARY CURSOR FOR
Here's (essentially) the query MapServer asked of PostGIS :
SELECT
"NAME
"::text
,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from
chile_comuna WHERE the_geom && setSRID('BOX3D(-71.2556639435156
-29.9271886101172,-71.2540857172265 -29.9256103838281)'::BOX3D,
find_srid('','chile_comuna','the_geom') )'
Here's the problem PostGIS reported with it.
Postgresql reports the error as 'ERROR: column "NAME" does not exist
LINE 1: DECLARE mycursor BINARY CURSOR FOR SELECT
"NAME"::text,asbin... ^ '
It looks to my inexperienced eyes that somewhere in the layer
(classitem?) it includes a reference to a field NAME.
It may be that it needs to be specified in the query. Check the table
you imported into PostgreSQL, ie: (I made this up)
# \d chile_comuna
Column| Type
|Modifiers
-+-
+-
gid | integer | not null default
nextval('gis_urban_gid_seq'::regclass)
commune_name| character varying(24) |
the_geom| geometry|
More Help: Error with POSTGIS data variable. You specified 'check
your .map file'. Standard ways of specifiying are : (1)
'geometry_column from geometry_table'
This is what you have used, but it only returns the_geom, you need to
specify the table column AS name
(2) 'geometry_column from (sub query) as foo using unique column
name using SRID=srid#' Make sure you put in the 'using unique column
name' and 'using SRID=#' clauses in.
Try also specifying the name column (assuming it does exist in the
table):
the_geom from (gid, the_geom, commune_name AS name from chile_comuna)
as foo using unique column gid using SRID= 4326;
For more help, please see http://postgis.refractions.net/documentation/
Mappostgis.c - version of Jan 23/2004.
I use the command shp2pgsql to pass the information of the shapefile
to postgres table.
MapFile
LAYER
NAME 'chile_comuna'
TYPE POLYGON
#DATA 'chile_comuna.shp'
CONNECTIONTYPE postgis
CONNECTION "user=postgres password=1234 dbname=geo_referencia
host=localhost"
DATA "the_geom from chile_comuna"
.
can anyone help me? pleasee...
cheers
Ben
--
Ben Madin
REMOTE INFORMATION
t : +61 8 9192 5455
f : +61 8 9192 5535
m : 0448 887 220
Broome WA 6725
b...@remoteinformation.com.au
Out here, it pays to
know...
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] website upgrade for older documentation
http://trac.osgeo.org/mapserver/ticket/2855 On 1/9/09, Stephen Woodbridge wrote: > Zach, et al, > > It might be possible to do something like you are suggesting going > forward, as the documentation is been migrated into svn and should get > tagged with each release we do. Since this was not done in the past it > is unlikely that we can go backward in time with this type a scenario. > > I think it will be up to the doc and web team to look into doing > something like this, but I believe the 1st step of having the docs in > svn is the critical pieces to be able to do anything like this. > > I think you should write a ticket in the bug tracking system and then > post the tick number so interested parties can sign up to be CC on it. > > Thanks, >-Steve > > zach cruise wrote: >> actually we just need to refer to old documentation for upgrading and >> porting, thanks though. if possible, we prefer something like >> >> http://www.mapserver.org/4.8/mapfile/map.html >> http://www.mapserver.org/5.2/mapfile/map.html >> much like >> http://www.postgresql.org/docs/8.1/interactive/sql-select.html >> http://www.postgresql.org/docs/8.1/static/sql-select.html >> http://www.postgresql.org/docs/8.2/interactive/sql-select.html >> http://www.postgresql.org/docs/8.2/static/sql-select.html >> >> On Thu, Jan 8, 2009 at 2:31 PM, Dan Little wrote: >>> Zach, >>> >>> Not trying to be a pushy guy... but is there a feature missing in 5.0 >>> prevents you from upgrading? >>> >>> - Original Message From: zach cruise To: Jeff McKenna Cc: mapserver-users@lists.osgeo.org Sent: Thursday, January 8, 2009 12:31:26 PM Subject: Re: [mapserver-users] website upgrade for older documentation thanks. any way to search 4.8 documentation? any one got archived copy other than http://web.archive.org/web/20060701050731/http://mapserver.gis.umn.edu/? On Thu, Jan 8, 2009 at 12:21 PM, Jeff McKenna wrote: > zach cruise wrote: >> On Wed, Jan 7, 2009 at 5:29 PM, zach cruise wrote: >>> great website upgrade at http://www.mapserver.org/. how can i search >>> for older documentation like with postgresql.org? > The current (5.2.1) documents should have MapServer version references > inside them for specific functionality (such as a specific mapfile > parameter > added in 5.0). > > -jeff > -- > Jeff McKenna > FOSS4G 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 ___ 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] Imagemap size doesn't match display map
David, That did the trick. Thanks. Fawcett, David wrote: > > Soren, > > I think that you are running into the issue where a WMS request can > return non-square pixels, and that the ratio of height:width in your > extent is not the same as the ratio of height:width in your image size. > > > If you can make this as a regular CGI call, you won't see this problem. > If you need to use WMS, make sure that you make the ratio's the same. > > e.g. 500/275 does not equal 60/26. > > David. > -Original Message- > From: mapserver-users-boun...@lists.osgeo.org > [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of sscottgis > Sent: Friday, January 09, 2009 12:48 PM > To: mapserver-users@lists.osgeo.org > Subject: [mapserver-users] Imagemap size doesn't match display map > > > > I have created an imagemap/image for the lower 48 states using 2 > mapfiles to define the polygons following the demo in the wiki. They > noted that if you use separate maps, the SIZE and EXTENT should be the > same. I have those set the same in both files, but the imagemap that > gets returned is vertically squished. > > Here's the map file for the imagemap layer: > > MAP > NAME "droughtplan_imgmap" > STATUS ON > SIZE 500 275 > > # set projection for map > PROJECTION > "init=epsg:4326" > END > > EXTENT -126 24 -66 50 > UNITS METERS > STATUS ON > IMAGECOLOR 255 255 255 > > WEB > IMAGEPATH "e:/ms4w/tmp/ms_tmp/" > IMAGEURL "/ms_tmp/" > END > > #QUERYMAP > # STATUS ON > # STYLE NORMAL > #END > > LAYER > NAME "droughtplans_imgmap" > STATUS DEFAULT > TYPE POLYGON > DATA "../data/droughtplans_imgmap" > TEMPLATE "planbody.html" > HEADER "planheader.html" > FOOTER "planfooter.html" > > CLASSITEM "State" > CLASS > COLOR -1 -1 -1 > NAME "State" > OUTLINECOLOR 110 110 110 > END > END > END > END > > and the file for the display layer: > MAP > NAME "droughtplan_wms" > STATUS ON > SIZE 500 275 > > # set projection for map > PROJECTION > "init=epsg:4326" > END > > EXTENT -126 24 -66 50 > UNITS METERS > STATUS ON > IMAGECOLOR 255 255 255 > > # image format > OUTPUTFORMAT > NAME png > DRIVER "GD/PNG" > MIMETYPE "image/png" > IMAGEMODE RGB > EXTENSION "png" > END > > WEB > IMAGEPATH "e:/ms4w/tmp/ms_tmp/" > IMAGEURL "/ms_tmp/" > HEADER "../templates/query_header.html" > FOOTER "../templates/query_footer.html" > END > > QUERYMAP > STATUS ON > STYLE NORMAL > END > > LAYER > NAME "droughtplans" > STATUS DEFAULT > TYPE POLYGON > DATA "../data/droughtplans" > > DUMP TRUE > > HEADER ../templates/ndmc_query_header.html > TEMPLATE ../templates/ndmc_query_body.html > > CLASSITEM "Status" > CLASS > COLOR 255 255 255 > OUTLINECOLOR 110 110 110 > EXPRESSION "0" > NAME "No Plan" > SYMBOL 0 > END > CLASS > COLOR 139 209 0 > OUTLINECOLOR 110 110 110 > EXPRESSION "1" > NAME "Emphasizing Mitigation" > SYMBOL 0 > END > CLASS > COLOR 255 255 0 > OUTLINECOLOR 110 110 110 > EXPRESSION "2" > NAME "Emphasizing Response" > SYMBOL 0 > END > CLASS > COLOR 255 128 0 > OUTLINECOLOR 110 110 110 > EXPRESSION "3" > NAME "Emphasizing Disaster" > SYMBOL 0 > END > CLASS > COLOR 255 0 0 > OUTLINECOLOR 110 110 110 > EXPRESSION "4" > NAME "Local Plans" > SYMBOL 0 > END > END > END > END > > The header and footer are the basic tags described in the wiki, > but with the map height and width set to the 500, 275 dimensions from > the files. > > Here's the body template: > href="http://myserver/Resources/state.aspx?state=[State]"; > title="[State]" alt="[State]"> > > and the call to the image layer (these are part of an ASP.NET 2.0 web > page and added as part of an httprequest): > > http://myserver/cgi-bin/mapserv.exe?map=/ms4w/apps/drmon/service/drought > plans_wms.map&SERVICE=WMS&VERSION=1.1.1&REQUEST=GetMap&LAYERS=droughtpla > ns&WIDTH=500&HEIGHT=275&srs=EPSG:4326&styles=default&format=image/png&bb > ox=-126,24,-66,50 > > I've got the extents and sizes set to the same 500, 275 dimensions > everywhere, but the imagemap is still flattened (more like a box at 500 > x 200). Everything else works fine--all of the areas are defined, the > links work,etc; it just isn't aligned properly. Is there something > missing or something else going on here? > > Any help/ideas are greatly appreciated. > Soren > -- > View this message in context: > http://n2.nabble.com/Imagemap
Re: [mapserver-users] Conexion with postgres-postgis
Hi,
is chile_comuna a table with the_geom column?
"Postgresql reports the error as 'ERROR: column "NAME" does not exist LINE
1"
the "NAME"::text,asbinary(force_collection(force_2d(the_geom)),'NDR')" doest
not exist, so maybe your table do not have a the geom column.
Did you create that column with addgeometrycolumn(...) function?
se if you have a entry in geometry_columns table.
[]'s
2009/1/12 Valeria Muñoz
> HI
>
> I am trying to connect postgres with my Mapfile, but I get the following
> error:
>
> msDrawMap(): Image handling error. Failed to draw layer named
> 'chile_comuna'. prepare_database(): Query error. Error executing POSTGIS
> DECLARE (the actual query) statement: 'DECLARE mycursor BINARY CURSOR FOR
> SELECT
> "NAME"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text
> from chile_comuna WHERE the_geom && setSRID('BOX3D(-71.2556639435156
> -29.9271886101172,-71.2540857172265 -29.9256103838281)'::BOX3D,
> find_srid('','chile_comuna','the_geom') )' Postgresql reports the error as
> 'ERROR: column "NAME" does not exist LINE 1: DECLARE mycursor BINARY CURSOR
> FOR SELECT "NAME"::text,asbin... ^ ' More Help: Error with POSTGIS data
> variable. You specified 'check your .map file'. Standard ways of specifiying
> are : (1) 'geometry_column from geometry_table' (2) 'geometry_column from
> (sub query) as foo using unique column name using SRID=srid#' Make sure you
> put in the 'using unique column name' and 'using SRID=#' clauses in. For
> more help, please see
> http://postgis.refractions.net/documentation/Mappostgis.c - version of Jan
> 23/2004.
>
> I use the command shp2pgsql to pass the information of the shapefile to
> postgres table.
>
> MapFile
> LAYER
> NAME 'chile_comuna'
> TYPE POLYGON
> #DATA 'chile_comuna.shp'
> CONNECTIONTYPE postgis
> CONNECTION "user=postgres password=1234 dbname=geo_referencia
> host=localhost"
> DATA "the_geom from chile_comuna"
> .
>
> can anyone help me? pleasee...
> rgs
>
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
--
Luigi Castro Cardeles
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Conexion with postgres-postgis
Valeria:
I think the problem is that your data statment is incomplete. You should
write something like:
DATA: "the_geom from chile_comuna as foo using unique
using srid="
Hope it helps,
Saludos
Luis
2009/1/12 Valeria Muñoz
> HI
>
> I am trying to connect postgres with my Mapfile, but I get the following
> error:
>
> msDrawMap(): Image handling error. Failed to draw layer named
> 'chile_comuna'. prepare_database(): Query error. Error executing POSTGIS
> DECLARE (the actual query) statement: 'DECLARE mycursor BINARY CURSOR FOR
> SELECT
> "NAME"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text
> from chile_comuna WHERE the_geom && setSRID('BOX3D(-71.2556639435156
> -29.9271886101172,-71.2540857172265 -29.9256103838281)'::BOX3D,
> find_srid('','chile_comuna','the_geom') )' Postgresql reports the error as
> 'ERROR: column "NAME" does not exist LINE 1: DECLARE mycursor BINARY CURSOR
> FOR SELECT "NAME"::text,asbin... ^ ' More Help: Error with POSTGIS data
> variable. You specified 'check your .map file'. Standard ways of specifiying
> are : (1) 'geometry_column from geometry_table' (2) 'geometry_column from
> (sub query) as foo using unique column name using SRID=srid#' Make sure you
> put in the 'using unique column name' and 'using SRID=#' clauses in. For
> more help, please see
> http://postgis.refractions.net/documentation/Mappostgis.c - version of Jan
> 23/2004.
>
> I use the command shp2pgsql to pass the information of the shapefile to
> postgres table.
>
> MapFile
> LAYER
> NAME 'chile_comuna'
> TYPE POLYGON
> #DATA 'chile_comuna.shp'
> CONNECTIONTYPE postgis
> CONNECTION "user=postgres password=1234 dbname=geo_referencia
> host=localhost"
> DATA "the_geom from chile_comuna"
> .
>
> can anyone help me? pleasee...
> rgs
>
> ___
> 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] Conexion with postgres-postgis
Hi Valeria,
What was the options you used with your shp2pgsql script execution ?
Did you specify a -s property ?
Alexandre
Valeria Muñoz wrote:
HI
I am trying to connect postgres with my Mapfile, but I get the
following error:
msDrawMap(): Image handling error. Failed to draw layer named
'chile_comuna'. prepare_database(): Query error. Error executing
POSTGIS DECLARE (the actual query) statement: 'DECLARE mycursor BINARY
CURSOR FOR SELECT
"NAME"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text
from chile_comuna WHERE the_geom && setSRID('BOX3D(-71.2556639435156
-29.9271886101172,-71.2540857172265 -29.9256103838281)'::BOX3D,
find_srid('','chile_comuna','the_geom') )' Postgresql reports the
error as 'ERROR: column "NAME" does not exist LINE 1: DECLARE mycursor
BINARY CURSOR FOR SELECT "NAME"::text,asbin... ^ ' More Help: Error
with POSTGIS data variable. You specified 'check your .map file'.
Standard ways of specifiying are : (1) 'geometry_column from
geometry_table' (2) 'geometry_column from (sub query) as foo using
unique column name using SRID=srid#' Make sure you put in the 'using
unique column name' and 'using SRID=#' clauses in. For more help,
please see http://postgis.refractions.net/documentation/ Mappostgis.c
- version of Jan 23/2004.
I use the command shp2pgsql to pass the information of the shapefile
to postgres table.
MapFile
LAYER
NAME 'chile_comuna'
TYPE POLYGON
#DATA 'chile_comuna.shp'
CONNECTIONTYPE postgis
CONNECTION "user=postgres password=1234 dbname=geo_referencia
host=localhost"
DATA "the_geom from chile_comuna"
.
can anyone help me? pleasee...
rgs
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
--
Alexandre Dubé
Mapgears
www.mapgears.com
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Problem with MS101 demo
Thanks that worked! -- View this message in context: http://n2.nabble.com/Problem-with-MS101-demo-tp2142314p2146974.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] how MapServer manage the hyperlinks in the shapefile data table
Yes there is. Look into the query and template functions in MapServer. In the shapefile you should try to store a minimal representation of the hyperlink. Like a ID or a relative URL. That way if the look up system, or server, changes you do not need to do a complete update of your shapefile. So, for example, say you had a column called "OBJECTID" that contained a unique identifier for the feature that is used in other systems. In a template file you can do the following: http://my.other.server/the/path/to/script.cgi?object_id=[OBJECTID]"; target="_blank">View in The Other System - Original Message > From: Geosig > To: mapserver-users@lists.osgeo.org > Sent: Friday, January 9, 2009 3:31:40 PM > Subject: [mapserver-users] how MapServer manage the hyperlinks in the > shapefile data table > > > Hi everybody > > I am new in using MapServer so excuse me if my question it seems to you > somehow... strange. > > There is any possibility to ad hyperlinks to the shapefile data table used > by MapServer, so that when we see a querry table to be capable to follow > these links? > > Thank you > -- > View this message in context: > http://n2.nabble.com/how-MapServer-manage-the-hyperlinks-in-the-shapefile-data-table-tp2135378p2135378.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] can´t get dbox demo to work
Hi Everyone, I am having a hard trying to get this demo to work. I have configured Apache web server to run Python25 via CGI and the result is a display with no errors of the itaca aplication example but without any layers loaded in the legend object. It just shows Foreground Layers: only. Any idea of what is going on? Thanks, D. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Conexion with postgres-postgis
HI
I am trying to connect postgres with my Mapfile, but I get the following
error:
msDrawMap(): Image handling error. Failed to draw layer named
'chile_comuna'. prepare_database(): Query error. Error executing POSTGIS
DECLARE (the actual query) statement: 'DECLARE mycursor BINARY CURSOR FOR
SELECT
"NAME"::text,asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text
from chile_comuna WHERE the_geom && setSRID('BOX3D(-71.2556639435156
-29.9271886101172,-71.2540857172265 -29.9256103838281)'::BOX3D,
find_srid('','chile_comuna','the_geom') )' Postgresql reports the error as
'ERROR: column "NAME" does not exist LINE 1: DECLARE mycursor BINARY CURSOR
FOR SELECT "NAME"::text,asbin... ^ ' More Help: Error with POSTGIS data
variable. You specified 'check your .map file'. Standard ways of specifiying
are : (1) 'geometry_column from geometry_table' (2) 'geometry_column from
(sub query) as foo using unique column name using SRID=srid#' Make sure you
put in the 'using unique column name' and 'using SRID=#' clauses in. For
more help, please see
http://postgis.refractions.net/documentation/Mappostgis.c - version of
Jan 23/2004.
I use the command shp2pgsql to pass the information of the shapefile to
postgres table.
MapFile
LAYER
NAME 'chile_comuna'
TYPE POLYGON
#DATA 'chile_comuna.shp'
CONNECTIONTYPE postgis
CONNECTION "user=postgres password=1234 dbname=geo_referencia
host=localhost"
DATA "the_geom from chile_comuna"
.
can anyone help me? pleasee...
rgs
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Mapserver queries for line layer
Hi All, I using Mapserver 5.0.2 and Openlayers. I had posted a query before on how to show pop up for a line layer. I am trying to use the mapserver queries for the same. I find documentation that uses a shapefile for the data and use variables from that on the template file. But all the data I've is in a postgresql DB. Can someone please give me an example as to how to query DB for the features' details and show it on the map as a pop up? And is there anything on Openlayers side that I've to do to enable this mapserver queries?( like sending a request to fetch a map) Thanks a lot for the help. Regards, Subha ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] how to set fonts in fgs
hi to all how to set fonts in fgs with the filename fontset.txt please help me thanks regards SHADAB ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] AGG libraries and mapserver
Hi, if i do a "ldd mapserv" I cannot find the reference to the AGG libraries. Are they compiled statically into mapserv binary? ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
