<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>
<div>Dear amefad and Richard,</div>
<div> </div>
<div>thanks for your ideas, i will see what i can use</div>
<div> </div>
<div>Sebastian</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, 08. März 2016 um 18:00 Uhr<br/>
<b>Von:</b> "Richard McDonnell" <richard.mcdonnell@opw.ie><br/>
<b>An:</b> qgis-user@lists.osgeo.org<br/>
<b>Betreff:</b> Re: [Qgis-user] MS Access and QGIS</div>
<div name="quoted-content">
<div style="background-color: rgb(255,255,255);">I think one option might be to put the data on something like geoserver, and utilise the geometry extent for each land parcel as a link to the web server from Access.<br/>
<br/>
So you will have a link in your access database to the web service something like:<br/>
<br/>
"<a class="moz-txt-link-freetext" href="http://localhost/geoserver/landparcels/wms?service=WMS&version=1.1.0&request=GetMap&layers=opw:osi_2500p&styles=&bbox=" target="_blank">http://localhost/geoserver/landparcels/wms?service=WMS&version=1.1.0&request=GetMap&layers=opw:osi_2500p&styles=&bbox=</a><b>30000,19000,334000,458500</b>&width=531&height=768&srs=EPSG:29903&format=application/openlayers"<br/>
<br/>
The coordinates shown above, in<b> BOLD</b>, would be the bottom left and top right extents of the land parcel.<br/>
The reason I suggest this, is that creating a link to a project in Quantum is easy, the additional zoom to the land parcel requirement is a little more difficult to do.<br/>
It is one option!!<br/>
Regards,<br/>
<br/>
Richard<br/>
<div class="moz-cite-prefix">On 08/03/2016 13:05, "Sebastian Teßmer" wrote:</div>
<blockquote>
<div style="font-family: Verdana;font-size: 12.0px;">
<div>
<div class="g-unit" id="gt-res-c">
<div id="gt-res-p">
<div id="gt-res-data">
<div id="gt-res-wrap">
<div class="almost_half_cell" id="gt-res-content">
<div>
<div id="tts_button"><span class="hps">Hello everybody,</span></div>
<br/>
<span id="result_box"><span class="hps">today</span> <span class="hps">again</span> <span class="hps">something else</span> <span class="hps">to</span> <span class="hps">ask</span><span>.</span><br/>
<span class="hps">I have an</span> <span class="hps">Access</span> <span class="hps">-</span> <span class="hps">database</span><span>,</span> <span class="hps">which is stored</span> <span class="hps">with a</span> <span class="hps">PostGIS</span> <span class="hps">database</span><span>.</span><br/>
<span class="hps">It serves</span> <span class="hps">as a kind of</span> <span class="hps">front end</span><span>.</span> <span class="hps">Now</span> <span class="hps">I want to select</span> <span class="hps">a parcel</span> <span class="hps">in</span> <span class="hps">a form</span><br/>
<span class="hps">and then</span> <span class="hps">jump right</span> <span class="hps">in</span> <span class="hps">QGIS</span> <span class="hps">then.</span><br/>
<br/>
<span class="hps">Maybe I</span> <span class="hps">would</span> <span class="hps">also select multiple</span> <span class="hps">parcels</span> <span class="hps">in</span> <span class="hps">form</span><span>,</span> <span class="hps">which</span> <span class="hps">then</span> <span class="hps">in</span> <span class="hps">QGIS</span><br/>
<span class="hps">are being emphasized.</span><br/>
<br/>
<span class="hps">I</span> <span class="hps">know that sounds</span> <span class="hps">very</span> <span class="hps">utopian</span><span>,</span> <span class="hps">but maybe</span> <span class="hps">someone</span> <span class="hps">has</span> <span class="hps">an idea how</span> <span class="hps">to go</span> <span class="hps">that can</span><br/>
<span class="hps">or perhaps</span> <span class="hps">another suggestion</span> <span class="hps">on how to</span> <span class="hps">implement</span> <span class="hps">that.</span><br/>
<br/>
<span class="hps">Thank you so much!</span><br/>
<br/>
<span class="hps">MfG</span> <span class="hps">Sebastian<span> </span></span></span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<fieldset class="mimeAttachmentHeader"> </fieldset>
<pre>_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="Qgis-user@lists.osgeo.org" target="_parent">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<div class="moz-signature">--<br/>
<b><u>Richard McDonnell</u></b><br/>
<b><small><small><small>GIS Specialist PgD GIS AssocSCSI</small></small></small></b><br/>
<b><small>OPW FRM Data Management</small></b><br/>
<b><small>52 Stephens Green, Dublin 2.</small></b><br/>
<small><small>TEL: 01 6476543</small></small></div>
<div style="font-family: Arial;font-size: 8.0pt;">OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart<br/>
OPW - Looking to the future - Caring for the past<br/>
<a href="http://www.opw.ie/" target="_blank"><img height="76" src="http://www.opw.ie/en/media/opw-email-banner.png" width="494"/></a><br/>
Email Disclaimer: <a href="http://www.opw.ie/en/disclaimer/" target="_blank">http://www.opw.ie/en/disclaimer/</a></div>
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a> Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></div>
</div>
</div>
</div>
</div></div></body></html>