[mapserver-users] OSGeo Local Chapter (aka TCMUG) Meeting

2019-03-06 Thread Basques, Bob (CI-StPaul)
All, I’m mailing out an early reminder on the next OSGeo Chapter (TCMUG) Meeting. I’ll send another out the week of, as usual. This presentation by Howard is looking like something that is applicable to a lot of new data collecting that is going on in the area related to LIDAR presentation

[mapserver-users] Is it possible to have a different width for a polygon outline in the legend than what is on the map?

2019-03-06 Thread Mark Volz
Hello, Is it possible to have a different width for a polygon outline in the legend than what is on the map? On a particular layer I am working on the polygon width on the map looks fine, however it is much too thick on the legend. As a result I cannot see the color of the polygon in the

Re: [mapserver-users] Arc symbol.

2019-03-06 Thread lars . schylberg
Hi Marek, This is a way of making arcs in Mapserver that is based on using VRTs and sql The data source doesn't need to be in spatialite though. It can be a shapefile or a CSV file or anything that gdal can handle. Simon Mercier at Mapgears and I developed this for making litehouse circles for

Re: [mapserver-users] Help debugging PostGIS raster connection

2019-03-06 Thread Jeff McKenna
Great work Thomas! thank you! -jeff On 2019-03-06 1:08 PM, Thomas Horner wrote: These findings, along with my entire solution for querying rows of a table with a raster column based on timestamp in the WMS GET parameter, has been added to the MapServer wiki Tips and Tricks section which

Re: [mapserver-users] Help debugging PostGIS raster connection

2019-03-06 Thread Thomas Horner
These findings, along with my entire solution for querying rows of a table with a raster column based on timestamp in the WMS GET parameter, has been added to the MapServer wiki Tips and Tricks section which links to this page:

Re: [mapserver-users] Arc symbol.

2019-03-06 Thread Basques, Bob (CI-StPaul)
Marek, Landing your data into Postgres/PostGIS enables a bunch of capabilities. Combined with MapServer as an output/convertor, you can essentially filter to your hearts content as well as reproject to just about any EPSG code with Ease. We’ve even added to the EPSG lists in PostGIS for our

Re: [mapserver-users] Error While Generating Tiles

2019-03-06 Thread parsis presswala
I have improve Postgresql configuration shared_buffer = 2 MB and work_mem = 500 MB. Is this configuration fine or I need to improve more? On Wed, Mar 6, 2019 at 7:53 PM parsis presswala wrote: > No, not yet. > > On Wed, Mar 6, 2019 at 7:49 PM Yves Jacolin > wrote: > >> Did you improve

Re: [mapserver-users] Error While Generating Tiles

2019-03-06 Thread parsis presswala
No, not yet. On Wed, Mar 6, 2019 at 7:49 PM Yves Jacolin wrote: > Did you improve Postgresql configuration (shared_buffer and work_mem > parameters) ? > > Y. > > Le mer. 6 mars 2019 à 15:15, parsis presswala > a écrit : > >> Hello, >> >> I have already created indexing on some fields. Here is

Re: [mapserver-users] Error While Generating Tiles

2019-03-06 Thread Yves Jacolin
Did you improve Postgresql configuration (shared_buffer and work_mem parameters) ? Y. Le mer. 6 mars 2019 à 15:15, parsis presswala a écrit : > Hello, > > I have already created indexing on some fields. Here is my indexed fields. > CREATE INDEX planet_osm_polygon_idx > ON

Re: [mapserver-users] Arc symbol.

2019-03-06 Thread Seth G
Hi Marek, I had a similar question last year - http://osgeo-org.1560.x6.nabble.com/Curves-in-MapServer-td5377180.html You can add/draw CIRCULARSTRING geometries to MapServer using OGR - see the sample rainbow image at https://github.com/geographika/mappyfile-colors The sample map file is:

Re: [mapserver-users] Error While Generating Tiles

2019-03-06 Thread parsis presswala
Hello, I have already created indexing on some fields. Here is my indexed fields. CREATE INDEX planet_osm_polygon_idx ON public.planet_osm_polygon USING btree (waterway COLLATE pg_catalog."default", "natural" COLLATE pg_catalog."default", landuse COLLATE pg_catalog."default", building

Re: [mapserver-users] Error While Generating Tiles

2019-03-06 Thread Yves Jacolin
You probablty needs to create index(es) on leisure, landuse and amenity. Probably both of all but you need to do some test. Second, you probably needs to improve PostgreSQL configuration to let PostgreSQL use your 61 GB of RAM :) shared_buffers and work_mem are good parameters to look for. Y.

Re: [mapserver-users] Error While Generating Tiles

2019-03-06 Thread parsis presswala
Hello, Yes I am using OSM data. I have imported it using osm2pgsql. Database: asiadb and tables are planet_osm_line, planet_osm_point, planet_osm_polygon, planet_osm_roads. I have imported data of whole planet using 40 GB .osm.pbf file. First I have only imported data of Asia and created map

Re: [mapserver-users] Error While Generating Tiles

2019-03-06 Thread Yves Jacolin
Some questions that can help you :) is it OSM data? How do you import them? What is the extent of the data? Could you check if spatial indexes exist? Could you run EXPLAIN and analyze it? Y. Le mer. 6 mars 2019 à 14:29, parsis presswala a écrit : > Hello, > > Here is a log of PostgreSQL. I

Re: [mapserver-users] Error While Generating Tiles

2019-03-06 Thread parsis presswala
Hello, Here is a log of PostgreSQL. I consider that PostgreSQL takes very long time to execute query on polygon. What should I do fot it? 2019-03-06 11:23:49.620 UTC [2302] parsis@asiadb STATEMENT: select

Re: [mapserver-users] Help debugging PostGIS raster connection

2019-03-06 Thread Jeff McKenna
Great news Thomas. I also think (for good karma) all of your steps and hints for PGraster could be added to a new wiki page in the "Tricks, Tips, and HowTos" section of https://github.com/mapserver/mapserver/wiki (that way people don't have to troll through thousands of email messages to

Re: [mapserver-users] Error While Generating Tiles

2019-03-06 Thread Yves Jacolin
Hello, Did you try to curl the request and see what happens: timeout, etc. If so, try to get some log (mapserver or postgresql log) and see where is the bottleneck. Y. Le mer. 6 mars 2019 à 13:58, parsis presswala a écrit : > Hello, > I am getting following error while generating tiles. I