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
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
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
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
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:
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
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
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:
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
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
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!
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
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
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,
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
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
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:
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
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
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
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
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
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
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
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
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
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
27 matches
Mail list logo