[mapserver-users] MspServer Cluster Problem.

2014-01-09 Thread LewInMadrid
I'm trying to cluster a few thousand points but as I zoom out points disappear until I have an almost empty map instead of a few cluster symbols with big numbers. I'm using MapServer v6.0.2 Here's an example with 2 different zoom levels.

Re: [mapserver-users] non spatial MSSQL data in a Layer JOIN

2014-01-09 Thread Daniel Morissette
Actually, The example that Brent provided here is exactly the way I was suggesting you to do. Essentially you would setup your layer with CONNECTIONTYPE OGR, set the primary CONNECTION string to point to your shapefile, and use the DATA statement to provide the SQL statement built with

Re: [mapserver-users] non spatial MSSQL data in a Layer JOIN

2014-01-09 Thread Daniel Morissette
Errr... Please forgive the poor wording of my last response, my brain isn't finished booting up yet. On 14-01-09 9:47 AM, Daniel Morissette wrote: Actually, The example that Brent provided here is exactly the way I was suggesting you to do. Essentially you would setup your layer with

Re: [mapserver-users] MspServer Cluster Problem.

2014-01-09 Thread Jeff McKenna
On 2014-01-09 10:36 AM, LewInMadrid wrote: I'm trying to cluster a few thousand points but as I zoom out points disappear until I have an almost empty map instead of a few cluster symbols with big numbers. Odd. What happens if you copy the mapfile, and delete all other layers, keep this

Re: [mapserver-users] non spatial MSSQL data in a Layer JOIN

2014-01-09 Thread Daniel Morissette
Oh, and BTW, assuming your MSSQL connection string is MSSQL:server=myserver\myinstance;database=dbname;UID=uid;PWD=uid; and the layer name (as seen by ogrinfo) is mytable then the layer defn and SQL statement should look like this: CONNECTIONTYPE OGR CONNECTION /path/to/myshapefile.shp DATA

[mapserver-users] how to check which proj is used by mapserver

2014-01-09 Thread Andrea Giacomelli
Hi, I am using MapServer version 6.4.0 OUTPUT=PNG OUTPUT=JPEG SUPPORTS=PROJ SUPPORTS=AGG SUPPORTS=FREETYPE SUPPORTS=ICONV SUPPORTS=WMS_SERVER SUPPORTS=WCS_SERVER INPUT=JPEG INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE While overlaying two latlong point layers using a map file with an epsg:3003 output

Re: [mapserver-users] non spatial MSSQL data in a Layer JOIN

2014-01-09 Thread KenHeer1
Again thanks for all the help. We're on the same page, what I have in my mapfile definition is: CONNECTIONTYPE OGR CONNECTION C:/Path/to/shapefile.shp DATA SELECT shapefile.*, tablename.* FROM shapefile LEFT JOIN 'MSSQL:server=server\instance;database=dbname;UID=userid;PWD=password;'.tablename ON

Re: [mapserver-users] non spatial MSSQL data in a Layer JOIN

2014-01-09 Thread KenHeer1
Also, using ogrinfo, I tried this same join to a different table in the same database. The only real difference is that this new table has lat/long values in it (they are char(12) fields, not geometry fields through) and the original table does not, it's strictly attribute data. This join with the

[mapserver-users] Can MapCache address a Group on my Mapserver?

2014-01-09 Thread EVANS, JAMES R GS-13 USAF ACC 84 RADES/SCZE
Hi, Is it possible to represent a GROUP of 50 different layers on a MapServer as a single Source/TileSet on a MapCache? Does MapCache have any way of representing a grouping of layers? ___ mapserver-users mailing list

Re: [mapserver-users] Can MapCache address a Group on my Mapserver?

2014-01-09 Thread Schweitzer, Peter
I think the answer is yes--specify the group name as the layer name in your mapcache.xml, specifically the LAYERS element of the parameters within getmap within source. I'm doing this with groups of two layers each, where the two layers in each group have slightly different symbology depending on

Re: [mapserver-users] Can MapCache address a Group on my Mapserver?

2014-01-09 Thread thomas . bonfort
MapCache doesn't actually interpret the layers from your source WMS server, it just splits the returned image data into tiles. So as Peter said, you can easily use multiple WMS layers in a single mapcache tileset by specifying multiple layers in your mapcache source, e.g.: source name=foobar

Re: [mapserver-users] non spatial MSSQL data in a Layer JOIN

2014-01-09 Thread Brent Fraser
Ken, In my example note the ,basic (that's my table name): DATA SELECT * FROM t_505033 LEFT JOIN 'ODBC:Parcels_Rural,basic'.basic ON t_505033.PID=basic.PID I may have included it for performance reasons (so one that table is enumerated), but it may be required. It does seem redundant

Re: [mapserver-users] non spatial MSSQL data in a Layer JOIN

2014-01-09 Thread Jeff McKenna
and my advice is to follow what Daniel said earlier, focus on getting the join to work through ogrinfo; don't even test with MapServer until you have it working there (just too many other things could be happening with MapServer). Connect to ogrinfo to your shapefile, then pass the -sql switch

Re: [mapserver-users] MspServer Cluster Problem.

2014-01-09 Thread LewInMadrid
I've deleted the other layers and removed the PRIORITY label but there's no change. Here are couple of screen-shots showing the clustered/non-clustered data when zoomed right out. http://osgeo-org.1560.x6.nabble.com/file/n5097204/map_zoom_spain2.png

Re: [mapserver-users] non spatial MSSQL data in a Layer JOIN

2014-01-09 Thread KenHeer1
I actually caught that from your example and that was the key in getting the join to work with the other table. My statement now is: (zones is the shapefile, zone is the tablename) ogrinfo -sql select zones.*, zone.* from zones left join

Re: [mapserver-users] MspServer Cluster Problem.

2014-01-09 Thread Rahkonen Jukka
Hi, Perhaps you use something like OpenLayers as a client and it makes 256 by 256 pixel sized GetMaps? Have you tried with some GIS client like OpenJUMP or QGIS, or set OpenLayers into single tile? -Jukka Rahkonen- LewInMadrid [lcl...@genasys.com] wrote

Re: [mapserver-users] non spatial MSSQL data in a Layer JOIN

2014-01-09 Thread Daniel Morissette
On 14-01-09 1:36 PM, KenHeer1 wrote: So digging a little deeper the problem is in the data somewhere. I have the same problem when trying to do the same join within ArcMap. What is weird is that with three data sources all with the say key values I can join the shapefile to table 2 and I can

[mapserver-users] HTML template explanation

2014-01-09 Thread Stefanos Anastasiou
Hi everyone..!!! I'm super noob and I'm still struggling with initialization files and templates. :-)   Right now I'm stuck in this example  http://mapserver.org/mapfile/template.html#example-template and I'm pretty confused on it's functionality. How does the form work?  What is the connection

Re: [mapserver-users] MspServer Cluster Problem.

2014-01-09 Thread Tamas Szekeres
You are using CLASSITEM status but you have only classes defined for E and D in the layer. The status value is empty for those clusters which has mixed values of the same attribute in the individual shapes contained by the cluster and probably these clusters are not displayed. However with the