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

2010-11-29 Thread Tom van der Putte
Hi Daniel, I'm not sure if mapserver can do this for you; how I did it was to create two different shapes, and use the minscaledenom and maxscaledenom to display one of the two in different scale levels. Cheers, Tom On Sun 28/11/10 18:00 , mapserver-users-requ...@lists.osgeo.org sent: Send

Re: [mapserver-users] wfs different level of detail

2010-11-29 Thread Rahkonen Jukka
Hi, If you data are in a database it should be possible to take them out through simplify function. For PostGIS see http://postgis.refractions.net/docs/ST_Simplify.html You should define the layer DATA in the mapfile with simplifying factor as a variable and then make OpenLayers to send the

[mapserver-users] Raster Data from PostGIS

2010-11-29 Thread florencia.bujan
Hi, I have my data rasters (tif files) into my PostGIS database such as file. Any file into database is in bytea format. I want to show this raster layer from PostGIS with mapserver. My Raster Table structure and my .map code are: TABLE rasters ( id serial NOT NULL, nombre character

[mapserver-users] Join from SHP file to PostgreSQL table

2010-11-29 Thread flaviocarmo
Hi, I need to make a layer with a join between a shapefile and a non-spatial table, stored on PostgreSQL. I've found this documentation (http://mapserver.org/mapfile/join.html) but i could make it work, so, can u guys help me looking at this configuration and tell me whats wrong? LAYER

RE: [mapserver-users] Join from SHP file to PostgreSQL table

2010-11-29 Thread Fawcett, David (MPCA)
Flavio, Take a look at this page if you haven't: http://mapserver.org/mapfile/join.html Under 'Description', it mentions that you can't use joined data to 'affect the look of a map'. I am pretty sure that this rules out your case. David. -Original Message- From:

Re: [mapserver-users] Join from SHP file to PostgreSQL table

2010-11-29 Thread Jeff McKenna
Hello Flavio, As noted on the page you referred to, this JOIN only works for executed queries...and I do not see a TEMPLATE in your layer. Are you aware that this join only works for queries? (see the examples in that documentation) -jeff -- Jeff McKenna MapServer Consulting and Training

Re: [mapserver-users] Join from SHP file to PostgreSQL table

2010-11-29 Thread Carlos Ruiz
Flavio, Column names are case sensitive, have you checked this ? Cheers from México IC Carlos Ruiz From: flaviocarmo flavio.o.ca...@gmail.com To: mapserver-users@lists.osgeo.org Sent: Mon, November 29, 2010 8:43:44 AM Subject: [mapserver-users] Join from SHP

Re: [mapserver-users] Raster Data from PostGIS

2010-11-29 Thread Carlos Ruiz
Florencia, As far as I know, Mapserver only works with vectorial data on PostGIS. So having a kind of BLOB (bytea) column doesn't work. I guess you will have to had those TIF files as a file to be able to load it using a RASTER layer. Cheers from México IC Carlos Ruiz From:

Re: [mapserver-users] Raster Data from PostGIS

2010-11-29 Thread Stephen Woodbridge
Florencia, I have not tried to do this and I'm not sure it is even possible, but you might have some luck using a GDAL connection to pull your postgres raster data into mapserver. If you get this to work post a how to to the list. Thanks, -Steve W On 11/29/2010 10:34 AM, Carlos Ruiz

Re: [mapserver-users] Join from SHP file to PostgreSQL table

2010-11-29 Thread Brent Fraser
Flavio, I think that if you have CONNECTIONTYPE OGR, the connection string must have PG: (unlike the native mapserver Postgres connections?): CONNECTIONTYPE ogr CONNECTION PG:dbname='testdb' host=GSERVER1 port=5432 user='test' password='test' sslmode=disable If this works let me

[mapserver-users] Re: Raster Data from PostGIS

2010-11-29 Thread florencia.bujan
Hi Carlos, Thanks for your response. Ok, but I want to show only one layer with some rasters (more than one). I can save tif files into my system (directory into my hard disc instead of PostGIS), but I am thinking about can show a layer with more than one tif raster. Any ideas? Thanks a lot!

Re: [mapserver-users] Re: Raster Data from PostGIS

2010-11-29 Thread Carlos Ruiz
Hi Florencia, You just can show a layer per LAYER section at a time. However, you can use the GROUP label within each LAYER section of each raster you want to show, to turn on/off all those layers. Solo puedes mostrar una capa por cada sección LAYER a la vez. Sin embargo, puedes hacer uso de

Re: [mapserver-users] Re: Raster Data from PostGIS

2010-11-29 Thread Stephen Woodbridge
On 11/29/2010 10:50 AM, florencia.bujan wrote: Hi Carlos, Thanks for your response. Ok, but I want to show only one layer with some rasters (more than one). I can save tif files into my system (directory into my hard disc instead of PostGIS), but I am thinking about can show a layer with more

[mapserver-users] Re: Raster Data from PostGIS

2010-11-29 Thread florencia.bujan
Stephen, Carlos Thanks for your response again. My problem is that the group of rasters not always the same (dinamic). For example, rasters show according to the user logged (some users can see some rasters but no all), everything depends on the user. With the other types of layers (polygon,

RE: [mapserver-users] Re: Raster Data from PostGIS

2010-11-29 Thread Fawcett, David (MPCA)
If I remember correctly, you can use a PostGIS data set as a tileindex. Perhaps it would be possible to have a PostGIS polygon layer that serves as the tileindex with a where clause that only includes the footprint polygons for the rasters that a particular user should be able to see. Has

[mapserver-users] Re: Raster Data from PostGIS

2010-11-29 Thread florencia.bujan
David, Exactly. I done this with a dynamic parameter, like this: DATA the_geom from (SELECT l.* from lotes l, campos c WHERE c.id=l.idcampo AND l.idcampo=%param%) as lotes using unique gid using SRID=-1 but I want to do that with raster layer. Perhaps another solution is in the passage of

[mapserver-users] Re: Clipping returned WFS data to the requesting bounding box

2010-11-29 Thread mattmendick
Any takers? I was just thinking, is there a native way using filters to clip the returned data inside mapserver? I couldn't find any, but perhaps I was not looking in the right place. -- View this message in context:

[mapserver-users] Re: Join from SHP file to PostgreSQL table

2010-11-29 Thread flaviocarmo
Hi, Thanks all for your responses. Im a novice in Mapserver so, after reading, now i know that: - I cant use a JOIN to shown only geometrys with the CODE field stored on Postgres (or another Database) because joins cannot modify the look of a map; - I need to use a template always to show the

Re: [mapserver-users] Re: Join from SHP file to PostgreSQL table

2010-11-29 Thread Flavio Carmo
Hi, Sorry, but i cant upload the shapes to postgres. The shapefiles are modified using arcview and the data in the postgres is modified using a custom desktop software that my client uses for about 5 years. The software open the shapefiles, then using a ODBC connection with postgres, make the

RE: [mapserver-users] Re: Join from SHP file to PostgreSQL table

2010-11-29 Thread Fawcett, David (MPCA)
Your client has some pretty custom requirements. How current does the data published by the Web server need to be? Could it be refreshed nightly or hourly, or do changes to the data have to be immediately reflected in on the Web? From: mapserver-users-boun...@lists.osgeo.org

Re: [mapserver-users] Re: Join from SHP file to PostgreSQL table

2010-11-29 Thread Brent Fraser
Flavio, I'm currently experimenting with joining a shapefile to a MS Access file using OGR and ODBC (and stock mapserver v 5.2.1 from MS4W). Works ok: CONNECTIONTYPE OGR CONNECTION 'G:/GeoData/Parcels/Alberta/t_505033.shp' DATA SELECT * FROM t_505033 LEFT JOIN

[mapserver-users] RE: shpxy example

2010-11-29 Thread Lime, Steve D (DNR)
Hi John: The ids variable is used to perform a runtime substitution. It's not a MapServer specific variable, just something I used in that particular example. In the mapfile here's the county layer: LAYER NAME county STATUS OFF DATA data/bdry_counpy2_gen500 TYPE POLYGON

RE: [mapserver-users] How to set feature-level opacity?

2010-11-29 Thread Lime, Steve D (DNR)
Colors are always RGB for the moment, and unfortunately OPACITY isn't bindable at the moment. It would be a relatively easy hack though (patches gladly accepted). Feel free to create a ticket and assign it to me. Steve -Original Message- From: mapserver-users-boun...@lists.osgeo.org

RE: [mapserver-users] Re: Clipping returned WFS data to the requesting bounding box

2010-11-29 Thread Lime, Steve D (DNR)
I'm not aware of any means to do this. If you're using PostGIS perhaps there's a way to use the !BOX! hack in conjunction with some of the analytical functions but it's a long shot... (see http://www.mail-archive.com/mapserver-us...@lists.umn.edu/msg03006.html) Steve -Original

[mapserver-users] RE: shpxy example

2010-11-29 Thread Jackson, John
That makes perfect sense. One thing I would like work on is improving mapserver's documentation... (which I may try to write once I understand it more)... Not so much on specific pieces of syntax, but more on the thinking and theory of how to put use and combine multiple features together to

[mapserver-users] Re: Clipping returned WFS data to the requesting bounding box

2010-11-29 Thread mattmendick
I've actually now just discovered a way that works for me. I did forget to mention that we are using PostGIS. We now use the aforementioned: DATA wkb_geometry FROM (SELECT ST_Intersection(f.wkb_geometry, !BOX!) AS wkb_geometry, column1, column2, column3 FROM flood as f) AS subquery USING

Re: [mapserver-users] Re: Clipping returned WFS data to the requesting bounding box

2010-11-29 Thread Jan Hartmann
On 2010-11-29 22:11, Lime, Steve D (DNR) wrote: I'm not aware of any means to do this. If you're using PostGIS perhaps there's a way to use the !BOX! hack in conjunction with some of the analytical functions but it's a long shot... (see