<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>
<div>Thank you for your answer,</div>
<div> </div>
<div>my overlay data is projected in EPSG:3857, so I changed the map file, see appendix. I proofed the creating of the image with the tool shp2img, but it detected an error:</div>
<div> </div>
<div>
<div>msDrawMap(): Image handling error. Failed to draw layer named 'unterkunft'. <br></div>
<div>msPostGISLayerOpen(): Query error. Database connection failed (invalid connectio<br/>
n option "schema"<br/>
) with connect string 'host=localhost dbname=postgis_testdb schema=public user=p<br/>
ostgres password=******** port=5432'<br/>
Is the database running? Is it allowing connections? Does the specified user exi<br/>
st? Is the password valid? Is the database on the standard port? <br></div>
<div> </div>
<div>But I am connecting with the database.</div>
<div> </div>
<div>When I leave out "schema=public" in the string of "DATA" in my map file then i get the following message:</div>
<div> </div>
<div>
<div>msDrawMap(): Image handling error. Failed to draw layer named 'unterkunft'. <br></div>
<div>msPostGISLayerWhichShapes(): Query error. Error executing query: FEHLER: Relati<br/>
on "angebote" existiert nicht<br/>
LINE 1: ...metry">,'NDR'>,'hex'> as geom,"unterkunftid" from Angebote w...</div>
<div> </div>
<div>So shall I leave in the schema attribut?</div>
<div> </div>
<div>I would be very grateful if you check my map file. Are the projections listed correctly?</div>
<div>Do you have an idea for solving the error message? I will send it also to the mailing list of MapServer.</div>
<div> </div>
<div>Thank you in advance!</div>
<div> </div>
<div>Greetings, Geograefin</div>
</div>
<div> </div>
</div>
<div>
<div name="quote" style="margin:10px 5px 5px 10px; padding: 10px 0 10px 10px; border-left:2px solid #C3D9E5; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="margin:0 0 10px 0;"><b>Gesendet:</b> Dienstag, 06. Januar 2015 um 17:01 Uhr<br/>
<b>Von:</b> "TC Haddad" <tchaddad@gmail.com><br/>
<b>An:</b> geo.graefin@web.de<br/>
<b>Cc:</b> "geomoose-users@lists.osgeo.org" <geomoose-users@lists.osgeo.org><br/>
<b>Betreff:</b> Re: [Geomoose-users] Change projection</div>
<div name="quoted-content">
<div>
<div>
<div>
<div>
<div> </div>
If you want to use public map tiles, most likely you should set GeoMoose to use 3867 as a base projection (this is the default in the demo). This means that your overlay data will be reprojected from EPSG 25833 in order to display correctly. Coordinates in the GeoMoose display will be in EPSG 3857 in this case.<br/>
</div>
How are you accessing your overlay data? If it comes from Mapserver, you can add your projection of <em>EPSG:25833 </em>to the LAYER portion in the map file so that Mapserver can access it correctly. e.g.<br/>
</div>
MAP<br/>
....<br/>
WEB<br/>
METADATA<br/>
'ows_title' 'my_map'<br/>
'ows_srs' 'EPSG:3857'<br/>
'ows_enable_request' '*'<br/>
'ows_onlineresource' '<a href="http://www.geomoose.org" target="_blank">http://www.geomoose.org</a>'<br/>
END<br/>
END<br/>
PROJECTION<br/>
<span style="background-color: rgb(255,255,0);"> 'init=epsg:3857' #projection of the map</span><br/>
END<br/>
<br/>
LAYER<br/>
NAME 'my_layer'<br/>
TYPE POLYGON<br/>
DUMP true<br/>
TEMPLATE fooOnlyForWMSGetFeatureInfo<br/>
DATA './my_data.shp'<br/>
METADATA<br/>
'ows_title' 'my_layer'<br/>
END<br/>
STATUS OFF<br/>
TRANSPARENCY 100<br/>
PROJECTION<br/>
<span style="background-color: rgb(255,255,0);"> 'init=epsg:25833' #projection of the layer</span><br/>
END<br/>
CLASS<br/>
NAME "My Layer Name"<br/>
STYLE<br/>
WIDTH 0.91<br/>
OUTLINECOLOR 180 180 180<br/>
COLOR 145 155 92<br/>
END<br/>
END<br/>
END</div>
END
<div> </div>
</div>
<div class="gmail_extra">
<div class="gmail_quote">On Tue, Jan 6, 2015 at 6:54 AM, James Klassen <span><<a href="klassen.js@gmail.com" target="_parent">klassen.js@gmail.com</a>></span> wrote:
<blockquote class="gmail_quote" style="margin: 0 0 0 0.8ex;border-left: 1.0px rgb(204,204,204) solid;padding-left: 1.0ex;">
<p>I think OSM (and most other widely available tilesets) only support 3857. The map sources you use need to support the projection you select in GeoMoose. </p>
<p>Also, tilesets only support fixed zoom levels. (Although I think there is an OpenLayers server_resolutions parameters that works around this by rescaling the tiles in the browser. I don't remember if it is accessible from GeoMoose).</p>
<div class="HOEnZb">
<div class="h5">
<div class="gmail_quote">On Jan 6, 2015 7:07 AM, <<a href="geo.graefin@web.de" target="_parent">geo.graefin@web.de</a>> wrote:
<blockquote class="gmail_quote" style="margin: 0 0 0 0.8ex;border-left: 1.0px rgb(204,204,204) solid;padding-left: 1.0ex;">
<div>
<div style="font-family: Verdana;font-size: 12.0px;">
<div>
<div>Hello,</div>
<div> </div>
<div>here more in detail what I did:</div>
<div> </div>
<div>
<div>1. I created a new js file including the declaration of the EPSG code from <a href="http://spatialreference.org" target="_blank">spatialreference.org</a> and deleted the one of EPSG:26915.</div>
<div><em>Proj4js.defs["EPSG:25833"] = "+proj=utm +zone=33 +ellps=GRS80 +units=m +no_defs";</em></div>
<div> </div>
<div>2. I referenced this new js file in geomoose.html. Beside there is another projection for the geographic coordinates (EPSG:3857). I deleted the reference of EPSG:26915.</div>
<div><em><script type="text/javascript" src="projections/EPSG3857.js"></script><br/>
<script type="text/javascript" src="projections/EPSG25833.js"></script></em></div>
<div> </div>
<div>3. I changed the parameters projection, max_extent and initial_extent in mapbook.xml.</div>
<div><em><param name="projection">EPSG:25833</param><br/>
<param name="zoomto"><![CDATA[<br/>
{<br/>
"Zoom To:" : {<br/>
"Sachsen und Niederschlesien" : [295743,5511505,709358,5755456]<br/>
}<br/>
}<br/>
]]></param><br/>
<param name="max_extent">100000,1000000,999999,9999999</param><br/>
<param name="initial_extent">295743,5511505,709358,5755456</param><br/>
<param name="measure_tool.show_area_segments">false</param><br/>
<param name="layer_controls.legend.on">false</param><br/>
<param name="layer_controls.up.on">false</param><br/>
<param name="layer_controls.down.on">false</param><br/>
<param name="layer_controls.metadata.on">false</param><br/>
<param name="layer_controls.legend.on">true</param><br/>
<param name="group_checkboxes">false</param><br/>
<param name="default_tab">Catalog</param><br/>
<param name="ground_units">m</param><br/>
<param name="maxResolution">156543.03390625</param><br/>
<param name="numZoomLevels">20</param><br/>
<param name="coordinate_display.usng">false</param><br/>
<param name="jumpto_scales"><![CDATA[<br/>
{<br/>
"1:100000" : 100000,<br/>
"1:50000" : 50000,<br/>
"1:24000" : 24000,<br/>
"1:10000" : 10000,<br/>
"1:5000" : 5000<br/>
}<br/>
]]></param></em></div>
<div> </div>
<div>When I change the coordinates of max_extent then GeoMOOSE shows another area. Maybe there is the problem? When I set the fractional_zoom to true, the osm tiles will be displayed pink.</div>
<div> </div>
<div>4. I changed the projection of the map in local_settings.ini and settings.ini:</div>
<div>
<div><em>[map]<br/>
projection=EPSG:25833</em></div>
<div> </div>
<div>That is what I have done. Is there anywhere a reference to the "old" projection of EPSG:26915? Anything I have missing?</div>
<div>Unfortunately I have no own data, that I can proof, because there is a mistake in the map file of the data's source.</div>
<div> </div>
<div>Thanks a lot for your help!</div>
<div> </div>
<div>Greetings, Geograefin</div>
</div>
<div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);">
<div style="margin: 0 0 10.0px 0;"><b>Gesendet:</b> Montag, 05. Januar 2015 um 22:16 Uhr<br/>
<b>Von:</b> "TC Haddad" <<a href="tchaddad@gmail.com" target="_parent">tchaddad@gmail.com</a>><br/>
<b>An:</b> <a href="geo.graefin@web.de" target="_parent">geo.graefin@web.de</a><br/>
<b>Betreff:</b> Re: Re: [Geomoose-users] Change projection</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div> </div>
Let's back up - can you describe your symptoms in more detail?<br/>
</div>
- You started from the demo</div>
- You made your projection changes and something didn't work<br/>
</div>
- is your data displaying correctly in the map?</div>
- do you get a pink screen when you try to view your data?
<div>- are the coordinates displaying below the map incorrect? or duplicated in 2 projections?<br/>
</div>
<div>More items to double check or try:<br/>
</div>
<div>- Did you set appropriate initial and maximum extent values in the Mapbook?</div>
<div>ie. <param name="max_extent">7110968,-610403,9234765,956456</param><br/>
<param name="initial_extent">7296650,228568,7570144,408049</param></div>
<div>- Did you set the correct units in the Mapbook?<br/>
<param name="ground_units">ft</param></div>
<div>- Did you set appropriate zoom levels in the Mapbook?<br/>
<param name="fractional_zoom">true</param><br/>
<param name="scales">0.25,0.5,1,2,4,8,16,32,64,128,256,512,1024,2048</param><br/>
</div>
</div>
<div class="gmail_extra">
<div class="gmail_quote">On Mon, Jan 5, 2015 at 11:14 AM, <span><<a href="http://geo.graefin@web.de" target="_blank">geo.graefin@web.de</a>></span> wrote:
<blockquote class="gmail_quote" style="margin: 0 0 0 0.8ex;border-left: 1.0px rgb(204,204,204) solid;padding-left: 1.0ex;">
<div>
<div style="font-family: Verdana;font-size: 12.0px;">
<div>
<div>Thank you for your answer,</div>
<div> </div>
<div>I did all the steps, including the both of your answer. I really have no idea, what is wrong. Maybe the local_settings.ini could not overwrite the settings.ini?</div>
<div>
<div style="margin: 10.0px 5.0px 5.0px 10.0px;padding: 10.0px 0 10.0px 10.0px;border-left: 2.0px solid rgb(195,217,229);">
<div style="margin: 0 0 10.0px 0;"><b>Gesendet:</b> Montag, 05. Januar 2015 um 18:10 Uhr<br/>
<b>Von:</b> "TC Haddad" <<a href="http://tchaddad@gmail.com" target="_blank">tchaddad@gmail.com</a>><br/>
<b>An:</b> <a href="http://geo.graefin@web.de" target="_blank">geo.graefin@web.de</a><br/>
<b>Betreff:</b> Re: [Geomoose-users] Change projection</div>
<div>
<div>
<div>
<div>Some ideas to check if you started from the Demo file:
<ul>
<li>Did you place the epsg25833.js file that you created in Step 2 in the projections directory?</li>
<li>Did you remove the reference to the old projection from your HTML? ie.<br/>
delete <script type=”text/javascript” src=”projections/EPSG26915.js”></script><br/>
insert <script type=”text/javascript” src=”projections/EPSG25833.js”></script></li>
</ul>
</div>
<div class="gmail_extra">
<div class="gmail_quote">On Mon, Jan 5, 2015 at 8:35 AM, <span><<a href="http://geo.graefin@web.de" target="_blank">geo.graefin@web.de</a>></span> wrote:
<blockquote class="gmail_quote" style="margin: 0 0 0 0.8ex;border-left: 1.0px rgb(204,204,204) solid;padding-left: 1.0ex;">
<div>
<div style="font-family: Verdana;font-size: 12.0px;">
<div>Dear community,</div>
<div> </div>
<div>I have problems with changing the projection of my GeoMOOSE project. I have followed the instructions at the GeoMOOSE site [<a href="http://docs.geomoose.org/2.7/docs/projections.html" target="_blank">http://docs.geomoose.org/2.7/docs/projections.html</a>]. In addition to all these steps I changed the EPSG code in local_settings.ini. But there is no effect. It still shows the projection (EPSG code 26915) of the demo, as well as the coordinates x,y at the status bar. The "new" epsg code is 25833.</div>
<div>Do you have any ideas, what instructions are missing or what i did wrong?</div>
<div> </div>
<div>I would be very grateful for help! Thank you in advance!</div>
<div> </div>
<div>Greetings, Geograefin</div>
</div>
</div>
<br/>
_______________________________________________<br/>
Geomoose-users mailing list<br/>
<a href="http://Geomoose-users@lists.osgeo.org" target="_blank">Geomoose-users@lists.osgeo.org</a><br/>
<a href="http://lists.osgeo.org/mailman/listinfo/geomoose-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/geomoose-users</a></blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br/>
_______________________________________________<br/>
Geomoose-users mailing list<br/>
<a href="Geomoose-users@lists.osgeo.org" target="_parent">Geomoose-users@lists.osgeo.org</a><br/>
<a href="http://lists.osgeo.org/mailman/listinfo/geomoose-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/geomoose-users</a></blockquote>
</div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
</div>
</div>
</div></div></body></html>