<?xml version="1.0" encoding="utf-8"?>
<result><vid>17592</vid><uid>21</uid><title>Bathymetry Geodatabases to Assist in Wave and Tidal Energy Site Selection</title><log>Edited by Drew.</log><status>1</status><comment>1</comment><promote>0</promote><sticky>0</sticky><ds_switch></ds_switch><nid>13644</nid><type>generic_information_page</type><language>und</language><created>1453978422</created><changed>1458810901</changed><tnid>0</tnid><translate>0</translate><revision_timestamp>1458810901</revision_timestamp><revision_uid>21</revision_uid><field_description><und is_array="true"><item><value>&lt;p&gt;Marine Scotland Science has created geodatabases for the areas surveyed in the Pentland Firth and west of Lewis. The purpose of the geodatabases is to provide regional guidance to assist developers involved in identifying suitable sites for localised survey work in support of site specific developments. The parameters available to assist in the identification of sites are depth of water, seabed slope and distance offshore. All the layers available from this section of Marine Scotland Interactive can be viewed using ArcGis Explorer and are projected using British National Grid.&lt;/p&gt;&#13;
&#13;
&lt;p&gt;A number of maps have already been created using the databases and exported as grouped layer packages. The maps have been queried using depth and seabed slope e.g.&lt;/p&gt;&#13;
&#13;
&lt;p&gt;By_10_30m_Slp_0_10deg&lt;/p&gt;&#13;
&#13;
&lt;p&gt;This filename should be read as the area of seabed between 10 to 30m depth and between 0 to 10° slope. The buffer file records a series of concentric rings that extend offshore in 1 km increments. This file can be opened together with the maps in ArcGis Explorer to determine the distance offshore for the areas selected based on depth and seabed slope. Opening combinations of the maps enables comparisons to be made between the areas available for development in terms of increasing depth or increasing seabed slope.&lt;/p&gt;&#13;
</value><format>filtered_html</format><safe_value>&lt;p&gt;Marine Scotland Science has created geodatabases for the areas surveyed in the Pentland Firth and west of Lewis. The purpose of the geodatabases is to provide regional guidance to assist developers involved in identifying suitable sites for localised survey work in support of site specific developments. The parameters available to assist in the identification of sites are depth of water, seabed slope and distance offshore. All the layers available from this section of Marine Scotland Interactive can be viewed using ArcGis Explorer and are projected using British National Grid.&lt;/p&gt;
&lt;p&gt;A number of maps have already been created using the databases and exported as grouped layer packages. The maps have been queried using depth and seabed slope e.g.&lt;/p&gt;
&lt;p&gt;By_10_30m_Slp_0_10deg&lt;/p&gt;
&lt;p&gt;This filename should be read as the area of seabed between 10 to 30m depth and between 0 to 10° slope. The buffer file records a series of concentric rings that extend offshore in 1 km increments. This file can be opened together with the maps in ArcGis Explorer to determine the distance offshore for the areas selected based on depth and seabed slope. Opening combinations of the maps enables comparisons to be made between the areas available for development in terms of increasing depth or increasing seabed slope.&lt;/p&gt;
</safe_value></item></und></field_description><field_infomration_images><und is_array="true"><item><fid>265</fid><uid>21</uid><filename>lewis_geodatabase.PNG</filename><uri>public://lewis_geodatabase.PNG</uri><filemime>image/png</filemime><filesize>315479</filesize><status>1</status><timestamp>1453979524</timestamp><type>image</type><field_tags/><field_file_image_alt_text><und is_array="true"><item><value>A colour coded map of the seabed off the north-west coast of lewis</value><format/><safe_value>A colour coded map of the seabed off the north-west coast of lewis</safe_value></item></und></field_file_image_alt_text><field_file_image_title_text><und is_array="true"><item><value>Lewis Geodatabase - Copyright © Marine Scotland</value><format/><safe_value>Lewis Geodatabase - Copyright © Marine Scotland</safe_value></item></und></field_file_image_title_text><_drafty_revision_requested>FIELD_LOAD_CURRENT</_drafty_revision_requested><rdf_mapping/><title>Lewis Geodatabase - Copyright © Marine Scotland</title><alt>A colour coded map of the seabed off the north-west coast of lewis</alt><metadata/><width>800</width><height>640</height></item></und></field_infomration_images><field_infomration_data_link><und is_array="true"><item><target_id>13708</target_id></item><item><target_id>13802</target_id></item></und></field_infomration_data_link><field_information_map_link><und is_array="true"><item><target_id>13350</target_id></item></und></field_information_map_link><field_theme><und is_array="true"><item><tid>47</tid></item><item><tid>17</tid></item></und></field_theme><field_google_plus_gallery/><field_tags><und is_array="true"><item><tid>590</tid></item><item><tid>1437</tid></item><item><tid>887</tid></item><item><tid>1410</tid></item></und></field_tags><field_footer_text><und is_array="true"><item><value>&lt;p&gt;The geodatabases can also be opened using ArcGIS Explorer and queried using standard SQL commands. The values used in the geodatabases can be cross-referenced using their respective Code Book files.&lt;/p&gt;&#13;
&#13;
&lt;p&gt;&lt;strong&gt;Query Examples&lt;/strong&gt;&lt;/p&gt;&#13;
&#13;
&lt;p&gt;"BathID" in (2)&lt;/p&gt;&#13;
&#13;
&lt;p&gt;This query will select all the polygons within the geodatabase that are between 10 to 20m depth.&lt;/p&gt;&#13;
&#13;
&lt;p&gt;"BathID" in (2) AND "SlpID" in (1,2)&lt;/p&gt;&#13;
&#13;
&lt;p&gt;This query will select all polygons within the geodatabase that are between 10 to 20m depth and between 0 to 10° slope.&lt;/p&gt;&#13;
&#13;
&lt;p&gt;"BathID" in (2) AND "SlpID" in (1,2) AND "BufID" in (1,2,3)&lt;/p&gt;&#13;
&#13;
&lt;p&gt;This query will select all polygons within the geodatabase that are between 10 to 20m depth, between 0 to 10° slope and between 0 to 3km offshore.&lt;/p&gt;&#13;
&#13;
&lt;p&gt;After running the query, Arc Gis Explorer will create a map showing the spatial distribution of the areas identified based on the suite of parameters used. The map generated can be exported as a separate layer package and saved separately for viewing in ArcGis Explorer, View, Editor etc.&lt;/p&gt;&#13;
&#13;
&lt;p&gt;All of the data can be downloaded by following the links in the table below.&lt;/p&gt;&#13;
</value><format>filtered_html</format><safe_value>&lt;p&gt;The geodatabases can also be opened using ArcGIS Explorer and queried using standard SQL commands. The values used in the geodatabases can be cross-referenced using their respective Code Book files.&lt;/p&gt;
&lt;p&gt;&lt;strong&gt;Query Examples&lt;/strong&gt;&lt;/p&gt;
&lt;p&gt;"BathID" in (2)&lt;/p&gt;
&lt;p&gt;This query will select all the polygons within the geodatabase that are between 10 to 20m depth.&lt;/p&gt;
&lt;p&gt;"BathID" in (2) AND "SlpID" in (1,2)&lt;/p&gt;
&lt;p&gt;This query will select all polygons within the geodatabase that are between 10 to 20m depth and between 0 to 10° slope.&lt;/p&gt;
&lt;p&gt;"BathID" in (2) AND "SlpID" in (1,2) AND "BufID" in (1,2,3)&lt;/p&gt;
&lt;p&gt;This query will select all polygons within the geodatabase that are between 10 to 20m depth, between 0 to 10° slope and between 0 to 3km offshore.&lt;/p&gt;
&lt;p&gt;After running the query, Arc Gis Explorer will create a map showing the spatial distribution of the areas identified based on the suite of parameters used. The map generated can be exported as a separate layer package and saved separately for viewing in ArcGis Explorer, View, Editor etc.&lt;/p&gt;
&lt;p&gt;All of the data can be downloaded by following the links in the table below.&lt;/p&gt;
</safe_value></item></und></field_footer_text><field_data_owner/><field_multimedia/><field_information_related_data/><rdf_mapping><rdftype is_array="true"><item>sioc:Item</item><item>foaf:Document</item></rdftype><title><predicates is_array="true"><item>dc:title</item></predicates><type>property</type></title><created><predicates is_array="true"><item>dc:date</item><item>dc:created</item></predicates><datatype>xsd:dateTime</datatype><callback>date_iso8601</callback></created><changed><predicates is_array="true"><item>dc:modified</item></predicates><datatype>xsd:dateTime</datatype><callback>date_iso8601</callback></changed><body><predicates is_array="true"><item>content:encoded</item></predicates></body><uid><predicates is_array="true"><item>sioc:has_creator</item></predicates><type>rel</type></uid><name><predicates is_array="true"><item>foaf:name</item></predicates></name><comment_count><predicates is_array="true"><item>sioc:num_replies</item></predicates><datatype>xsd:integer</datatype></comment_count><last_activity><predicates is_array="true"><item>sioc:last_activity_date</item></predicates><datatype>xsd:dateTime</datatype><callback>date_iso8601</callback></last_activity></rdf_mapping><path>https://marine.gov.scot/?q=information/bathymetry-geodatabases-assist-wave-and-tidal-energy-site-selection</path><name>Drew</name><picture>0</picture><data>a:5:{s:16:"ckeditor_default";s:1:"t";s:20:"ckeditor_show_toggle";s:1:"t";s:14:"ckeditor_width";s:4:"100%";s:13:"ckeditor_lang";s:2:"en";s:18:"ckeditor_auto_lang";s:1:"t";}</data><workbench_moderation><current><hid>5458</hid><vid>17592</vid><nid>13644</nid><from_state>published</from_state><state>published</state><uid>21</uid><stamp>1458810901</stamp><published>1</published><is_current>1</is_current><title>Bathymetry Geodatabases to Assist in Wave and Tidal Energy Site Selection</title><timestamp>1458810901</timestamp></current><published><hid>5458</hid><vid>17592</vid><nid>13644</nid><from_state>published</from_state><state>published</state><uid>21</uid><stamp>1458810901</stamp><published>1</published><is_current>1</is_current><title>Bathymetry Geodatabases to Assist in Wave and Tidal Energy Site Selection</title><timestamp>1458810901</timestamp></published><my_revision><hid>5458</hid><vid>17592</vid><nid>13644</nid><from_state>published</from_state><state>published</state><uid>21</uid><stamp>1458810901</stamp><published>1</published><is_current>1</is_current><title>Bathymetry Geodatabases to Assist in Wave and Tidal Energy Site Selection</title><timestamp>1458810901</timestamp></my_revision></workbench_moderation></result>
