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 map
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 val
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 var
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: mapserver-users-boun
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
To: mapserver-users@lists.osgeo.org
Sent: Mon, November 29, 2010 8:43:44 AM
Subject: [mapserver-users] Join from SHP file to PostgreSQL table
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.bujan
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 wro
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
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!
Flo
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 t
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, line
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 anyo
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 par
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:
http://osgeo-org.1803224.n2.nabble.com/Clipping-returned-WFS-data-to-the-reques
Florencia,
Since you are using this strategy for vector layers, I think that it could work
for rasters.
You would use gdaltindex or something else to create a polygon data set that
represented the 'footprints' of your raster files.
http://mapserver.org/optimization/tileindex.html One of t
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 q
On 11/29/2010 2:21 PM, flaviocarmo wrote:
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
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 join
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
[mailto:mapserve
All,
How about incrementally loading the SHAPE files at some predetermined
interval into POSTGIS is this feasible, are the data files to large,
etc?
bobb
>>> "Fawcett, David (MPCA)" wrote:
Your client has some pretty custom requirements. How current does the
data published by the Web s
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 'ODBC:Parcel
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
C
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
[m
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 Message-
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 pu
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
UNIQ
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
http://www.mail-archive.com/mapserver-us...@lists.umn.e
30 matches
Mail list logo
