Re: [mapserver-users] PostGIS layer projection

2019-07-18 Thread Jeff McKenna
I expanded it even more with initial ogrinfo commands (great way to check extents, source projection, etc). Hope this helps the next person google-searching! Feel free to expand the wiki page with your own notes. -jeff On 2019-07-18 9:31 AM, Jeff McKenna wrote: I expanded the wiki page

Re: [mapserver-users] PostGIS layer projection

2019-07-18 Thread Jeff McKenna
I expanded the wiki page to include the output of psql's describe "\d" for that table. -jeff On 2019-07-18 8:37 AM, Jeff McKenna wrote: Hi Radim, Here is a working mapfile reprojecting a PostGIS layer: https://github.com/mapserver/mapserver/wiki/Reproject-PostGIS-Layer You ask good

Re: [mapserver-users] PostGIS layer projection

2019-07-18 Thread Jeff McKenna
Hi Radim, Here is a working mapfile reprojecting a PostGIS layer: https://github.com/mapserver/mapserver/wiki/Reproject-PostGIS-Layer You ask good questions, that could likely just be tested by checking the postgres logs and executing the raw commands from those logs at the psql commandline

Re: [mapserver-users] PostGIS layer projection

2019-07-18 Thread Radim Blazek
Hi Jeff, thanks, yes I have read that. But I also read that "using srid= is optional but improves performance" so there was a little chance that re-projection could be done anyway if a different SRID is found on geometry. If there is no further transformation, what difference "using srid="

Re: [mapserver-users] PostGIS layer projection

2019-07-18 Thread Jeff McKenna
Hi Radim, Give the Projection document a good read specifically the "Important Notes" section which I believe answers your questions: https://mapserver.org/mapfile/projection.html#important-notes There are no specific driver rules; for something like a PostGIS connection you should be able