init.sql

CREATE TABLE IF NOT EXISTS shipping_forecast.regions(
  id INTEGER PRIMARY KEY,
  name STRING,
  boundaries GEO_SHAPE INDEX USING geohash WITH (PRECISION='1m', DISTANCE_ERROR_PCT=0.025),
  forecast OBJECT(STRICT) AS (
    wind TEXT,
    sea TEXT,
    weather TEXT,
    visibility TEXT
  )
);


INSERT INTO shipping_forecast.regions (
  id, name, boundaries, forecast
) VALUES (
  1,
  'Bailey',
  'POLYGON((-16.3916015625 62.81501879409271,-15.5126953125 59.22093407615045,-11.6015625 58.90464570302001,-12.65625 61.14323525084058,-16.3916015625 62.81501879409271))',
  {
    "wind" = 'Cyclonic, mainly north, 4 to 6.',
    "sea" = 'Moderate occasionally rough.',
    "weather" = 'Rain or thundery showers.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  2,
  'Biscay',
  'POLYGON((-6.85546875 48.429200555568386,-6.85546875 43.67581809328341,-5.1416015625 43.48481212891603,-3.515625 43.48481212891603,-3.1640625 43.35713822211053,-2.8564453125 43.45291889355468,-2.2412109375 43.26120612479979,-1.669921875 43.48481212891603,-1.318359375 44.33956524809713,-1.2744140625 45.02695045318546,-1.2744140625 45.521743896993634,-1.1865234375 45.89000815866182,-1.0546875 46.34692761055676,-1.7578125 46.6795944656402,-2.0654296875 46.830133640447386,-2.109375 47.249406957888446,-2.4609375 47.30903424774781,-2.4609375 47.54687159892238,-3.076171875 47.54687159892238,-3.33984375 47.635783590864854,-3.6035156249999996 47.81315451752768,-3.9990234375 47.96050238891509,-4.2626953125 47.90161354142075,-4.6142578125 47.98992166741417,-4.74609375 48.1367666796927,-4.39453125 48.31242790407178,-4.74609375 48.48748647988415,-6.85546875 48.429200555568386))',
  {
    "wind" = 'Cyclonic becoming northwesterly, 3 to 5, occasionally 6 in north.',
    "sea" = 'Slight or moderate.',
    "weather" = 'Thundery showers.',
    "visibility" = 'Moderate or good, occasionally poor.'
  }
),
(
  3,
  'Cromarty',
  'POLYGON((-0.8349609375 58.48220919993362,-3.1201171874999996 58.50517468678928,-3.09814453125 58.35563036280967,-4.0869140625 57.87981645527841,-3.80126953125 57.87981645527841,-4.15283203125 57.57477906967285,-3.3618164062499996 57.73934950049299,-1.9116210937499998 57.7041472343419,-1.77978515625 57.504020175224646,-2.21923828125 56.92099675839104,-0.76904296875 57.00485033534416,-0.8349609375 58.48220919993362))',
  {
    "wind" = 'South becoming cyclonic 3 to 5, then west 2 to 4 later.',
    "sea" = 'Smooth or slight, becoming slight or moderate in northeast.',
    "weather" = 'Rain or thundery showers.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  4,
  'Dogger',
  'POLYGON((0.98876953125 54.226707764386695,-0.5712890625 55.801280971180454,4.350585937499999 55.96150096848812,4.41650390625 54.3549556895541,0.98876953125 54.226707764386695))',
  {
    "wind" = 'South becoming cyclonic 3 to 5, then west 2 to 4 later.',
    "sea" = 'Smooth or slight.',
    "weather" = 'Rain or thundery showers.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  5,
  'Dover',
  'POLYGON((0.439453125 50.83369767098071,1.58203125 50.233151832472245,1.494140625 50.84757295365389,1.7578125 50.94458443495011,2.48291015625 51.08282186160978,2.9443359375 51.28940590271679,1.3842773437499998 51.26191485308451,1.29638671875 51.12421275782688,1.03271484375 51.069016659603896,0.9667968749999999 50.93073802371819,0.791015625 50.958426723359935,0.439453125 50.83369767098071))',
  {
    "wind" = 'Cyclonic becoming northwest, 3 to 5, increasing 6 or 7 for a time.',
    "sea" = 'Smooth or slight.',
    "weather" = 'Squally thundery showers.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  6,
  'Faeroes',
  'POLYGON((-13.798828125 61.71070595883174,-8.61328125 64.1297836764257,-3.2958984375 62.22699603631975,-9.052734375 59.46740794183742,-13.798828125 61.71070595883174))',
  {
    "wind" = 'Cyclonic 3 to 5, becoming northeast 4 to 6 later.',
    "sea" = 'Slight or moderate.',
    "weather" = 'Rain or showers, fog patches.',
    "visibility" = 'Moderate or good, occasionally very poor.'
  }
),
(
  7,
  'Fair Isle',
  'POLYGON((-9.0087890625 59.42272750081453,-5.1416015625 58.56252272853734,0.087890625 58.47072082411973,0 61.7939003991346,-3.3837890625 62.20651189841766,-9.0087890625 59.42272750081453))',
  {
    "wind" = 'Cyclonic 3 to 5, becoming northeast 4 to 6 later.',
    "sea" = 'Slight or moderate.',
    "weather" = 'Rain or thundery showers.',
    "visibility" = 'Moderate or good, occasionally poor.'
  }
),
(
  8,
  'Fastnet',
  'POLYGON((-10.107421874999998 51.56341232867588,-10.17333984375 50.317408112618686,-6.8115234375 50.190967765585604,-6.65771484375 52.22779941887071,-6.96533203125 52.17393169256849,-7.492675781249999 52.14697334064471,-7.55859375 52.03897658307622,-7.84423828125 51.984880139916626,-7.888183593749999 51.890053935216926,-8.32763671875 51.80861475198521,-8.3935546875 51.631657349449995,-8.76708984375 51.590722643120145,-8.9208984375 51.508742458803326,-9.140625 51.508742458803326,-9.404296875 51.549751017014195,-9.73388671875 51.440312757160115,-9.6240234375 51.645294049305406,-9.51416015625 51.7406361640977,-10.107421874999998 51.56341232867588))',
  {
    "wind" = 'West or northwest 3 to 5.',
    "sea" = 'Slight or moderate.',
    "weather" = 'Showers, perhaps thundery later.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  9,
  'Fisher',
  'POLYGON((4.306640625 57.72761921621492,4.19677734375 57.73934950049299,4.37255859375 55.986091533808384,8.06396484375 56.05976947910657,8.1298828125 56.80087831233043,8.59130859375 57.124314084296195,7.580566406250001 57.7862326105289,4.306640625 57.72761921621492))',
  {
    "wind" = 'Westerly 5 at first in northeast, otherwise variable 2 to 4, becoming cyclonic 3 to 5.',
    "sea" = 'Slight occasionally moderate.',
    "weather" = 'Fair, then rain or squally thundery showers.',
    "visibility" = 'Good, occasionally poor later.'
  }
),
(
  10,
  'Fitzroy',
  'POLYGON((-8.9208984375 42.06560675405716,-14.6337890625 42.391008609205045,-14.7216796875 48.777912755501845,-6.85546875 48.516604348867475,-6.943359374999999 43.61221676817573,-7.250976562499999 43.644025847699496,-7.734374999999999 43.77109381775648,-8.3056640625 43.58039085560786,-8.3056640625 43.42100882994726,-9.184570312499998 43.29320031385282,-9.228515625 43.004647127794435,-9.0087890625 42.84375132629023,-8.9208984375 42.65012181368025,-8.876953125 42.261049162113856,-8.9208984375 42.06560675405716))',
  {
    "wind" = 'Cyclonic becoming northwesterly, 3 to 5.',
    "sea" = 'Slight or moderate.',
    "weather" = 'Showers.',
    "visibility" = 'Moderate or good.'
  }
),
(
  11,
  'Forth',
  'POLYGON((-0.791015625 56.9809114245448,-2.21923828125 56.90900226702048,-2.79052734375 56.45034902929676,-2.83447265625 56.36525013685606,-2.6806640625 56.30434864830834,-2.7685546874999996 56.1944808772697,-3.40576171875 56.04749958329888,-3.14208984375 55.94919982336744,-2.8125 56.072035471800866,-2.21923828125 55.93689476903946,-1.58203125 55.52863052257191,-0.59326171875 55.801280971180454,-0.791015625 56.9809114245448))',
  {
    "wind" = 'South becoming cyclonic 3 to 5, then west 2 to 4 later.',
    "sea" = 'Smooth or slight, becoming slight or moderate.',
    "weather" = 'Rain or thundery showers.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  12,
  'Forties',
  'POLYGON((-0.85693359375 58.48220919993362,4.04296875 58.55106062287748,4.39453125 55.93689476903946,-0.52734375 55.81362907119958,-0.791015625 57.040729838360875,-0.85693359375 58.48220919993362))',
  {
    "wind" = 'South becoming cyclonic 3 to 5, then west 2 to 4 later.',
    "sea" = 'Smooth or slight, becoming slight or moderate.',
    "weather" = 'Rain or thundery showers.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  13,
  'German Bight',
  'POLYGON((4.350585937499999 55.97379820507658,8.1298828125 56.04749958329888,8.020019531249998 55.61558902526749,8.459472656249998 55.416543608580064,8.61328125 54.92714186454645,8.7890625 54.584796743678716,8.59130859375 54.303704439898084,8.942871093749998 53.90433815627468,8.67919921875 53.87844040332883,8.4375 53.67068019347264,8.4814453125 53.592504809039376,8.06396484375 53.50111704294316,7.91015625 53.73571574532637,7.163085937499999 53.67068019347264,6.87744140625 53.46189043285914,6.481933593749999 53.605544099237974,5.3173828125 53.42262754609993,4.4384765625 54.36775852406841,4.350585937499999 55.97379820507658))',
  {
    "wind" = 'Variable 2 to 4, becoming cyclonic 3 to 5.',
    "sea" = 'Slight occasionally moderate.',
    "weather" = 'Fair, then rain or squally thundery showers.',
    "visibility" = 'Good, occasionally poor later.'
  }
),
(
  14,
  'Hebrides',
  'POLYGON((-6.064453125 57.088515327886505,-10.810546875 57.231502991478926,-12.568359375 61.05828537037916,-8.96484375 59.46740794183742,-5.07568359375 58.53959476664049,-5.44921875 58.10110549730587,-5.3173828125 57.938183012205315,-5.778808593749999 57.833054912910875,-5.8447265625 57.57477906967285,-5.69091796875 57.32652122521709,-6.064453125 57.088515327886505))',
  {
    "wind" = 'Cyclonic, mainly north, 4 to 6.',
    "sea" = 'Moderate occasionally rough.',
    "weather" = 'Rain or thundery showers.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  15,
  'Humber',
  'POLYGON((-0.15380859375 54.149567212540525,-0.19775390625 53.969012350740314,0.19775390625 53.64463782485651,0 53.63161060657857,0 53.527247970102465,0.37353515625 53.199451902831555,0.0439453125 52.948637884883205,0.263671875 52.855864177853974,0.37353515625 52.8691297276852,0.48339843749999994 53.001562274591464,1.1865234375 52.9883372533954,1.7358398437499998 52.70967533219885,4.592285156249999 52.84259457223949,4.74609375 53.238920640924974,5.295410156249999 53.4357192066942,4.4384765625 54.39335222384586,-0.15380859375 54.149567212540525))',
  {
    "wind" = 'Southeast becoming cyclonic, then northwest later, 3 to 5, increasing 6 for a time.',
    "sea" = 'Smooth or slight.',
    "weather" = 'Squally thundery showers.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  16,
  'Irish Sea',
  'POLYGON((-6.328125 55.24155203565252,-5.888671875 55.32914440840507,-5.592041015625 55.29162848682989,-5.47119140625 55.70235509327093,-5.25146484375 55.85681658243853,-4.76806640625 55.64659898563683,-4.68017578125 55.441479359140686,-5.185546875 55.00282580979323,-5.240478515625 54.92714186454645,-4.94384765625 54.648412502316695,-4.844970703125 54.629338216555766,-4.954833984374999 54.813348417419284,-4.8779296875 54.84498993218758,-4.39453125 54.667477840945715,-4.306640625 54.84498993218758,-4.031982421875 54.74364976592378,-3.504638671875 54.95869417101661,-3.262939453125 54.95238569063361,-3.504638671875 54.749990970226925,-3.658447265625 54.533832507944304,-3.2299804687499996 54.06583577161278,-3.01025390625 54.17529672404642,-2.8784179687499996 54.181726602390945,-2.98828125 53.94315470224928,-3.065185546875 53.76170183021049,-2.98828125 53.73571574532637,-3.1201171874999996 53.585983654559804,-3.05419921875 53.4357192066942,-3.218994140625 53.37677497506021,-3.076171875 53.25206880589414,-3.394775390625 53.35710874569601,-3.7353515625 53.291489065300226,-3.856201171875 53.31774904749087,-4.075927734375 53.24549522839598,-4.317626953125 53.4357192066942,-4.537353515625 53.4291738804146,-4.63623046875 53.32431151982718,-4.350585937499999 53.12040528310657,-4.74609375 52.80940281068805,-4.19677734375 52.89564866211353,-4.04296875 52.5095347703273,-4.50439453125 52.16045455774706,-5.185546875 51.944264879028765,-6.328125 52.26815737376817,-6.448974609375 52.35547370875268,-6.185302734375 52.576349937498875,-6.218261718749999 52.65639394198803,-6.009521484375 52.96849212681396,-6.141357421875 53.291489065300226,-6.240234374999999 53.34399288223422,-6.064453125 53.533778184257805,-6.26220703125 53.67068019347264,-6.26220703125 53.78118084719588,-6.26220703125 53.85900655610469,-6.361083984374999 53.91081008725409,-6.35009765625 54.02713344412541,-6.141357421875 53.98839506479995,-5.9326171875 54.1173828217967,-5.888671875 54.220284882124005,-5.679931640625 54.23312964750767,-5.4931640625 54.39974815563759,-5.438232421875 54.48280455958253,-5.548095703125 54.648412502316695,-5.60302734375 54.69288437829768,-5.877685546874999 54.629338216555766,-5.679931640625 54.7943516039205,-5.789794921875 54.87660665410869,-5.965576171875 55.00912637001031,-5.9765625 55.07836723201515,-6.04248046875 55.10351605801967,-5.987548828125 55.17259379606185,-6.097412109375 55.23528803992295,-6.207275390625 55.20395325785898,-6.328125 55.24155203565252))',
  {
    "wind" = 'West or northwest, backing southwest for a time, 3 to 5.',
    "sea" = 'Smooth or slight elsewhere.',
    "weather" = 'Showers, perhaps thundery later.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  17,
  'Lundy',
  'POLYGON((-5.6689453125 50.12057809796008,-6.78955078125 50.17689812200107,-6.61376953125 52.214338608258224,-6.39404296875 52.214338608258224,-6.3720703125 52.308478623663355,-5.20751953125 51.97134580885172,-5.20751953125 51.80861475198521,-5.2294921875 51.69979984974196,-4.9658203125 51.631657349449995,-4.41650390625 51.754240074033525,-4.19677734375 51.713416052417614,-4.28466796875 51.57706953722567,-3.93310546875 51.549751017014195,-3.49365234375 51.385495069223204,-2.70263671875 51.57706953722567,-2.96630859375 51.440312757160115,-3.01025390625 51.22064743038333,-3.6694335937500004 51.248163159055906,-4.2626953125 51.17934297928927,-4.15283203125 51.069016659603896,-4.50439453125 51.055207338584964,-4.5263671875 50.83369767098071,-4.98779296875 50.55532498251969,-5.09765625 50.45750402042058,-5.16357421875 50.331436330838834,-5.44921875 50.233151832472245,-5.6689453125 50.12057809796008))',
  {
    "wind" = 'West or northwest 3 to 5.',
    "sea" = 'Smooth or slight elsewhere.',
    "weather" = 'Showers, perhaps thundery later.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  18,
  'Malin',
  'POLYGON((-10.810546875 57.16007826737998,-10.0634765625 54.29088164657006,-9.876708984375 54.23955053156177,-9.766845703125 54.322931143263474,-9.228515625 54.31011433916155,-9.11865234375 54.16243396806779,-8.997802734375 54.29088164657006,-8.558349609375 54.265224078605655,-8.668212890625 54.3549556895541,-8.272705078125 54.48280455958253,-8.26171875 54.57206165565852,-8.8330078125 54.67383096593114,-8.4375 54.826007999094955,-8.4375 54.97761367069628,-8.28369140625 55.12864906848878,-7.294921874999999 55.35413531021057,-7.00927734375 55.27911529201561,-6.921386718749999 55.19141243527063,-5.80078125 55.32914440840507,-5.712890625 56.04749958329888,-5.712890625 56.43820369358165,-6.35009765625 56.27996083172847,-6.30615234375 56.41390137600676,-6.15234375 56.8129075187002,-5.888671875 56.83695435196053,-5.756835937499999 57.100452089370705,-6.0205078125 57.052681978717494,-6.17431640625 57.100452089370705,-10.810546875 57.16007826737998))',
  {
    "wind" = 'West or northwest backing southwest for a time, 4 to 6.',
    "sea" = 'Moderate occasionally rough.',
    "weather" = 'Rain or thundery showers.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  19,
  'North Utsire',
  'POLYGON((4.04296875 61.87687021463305,4.833984374999999 61.897577621605016,5.009765625 59.06315402462662,4.6142578125 59.0405546167585,4.0869140625 59.02924933736396,4.0869140625 58.60833366077633,4.04296875 61.87687021463305))',
  {
    "wind" = 'Variable 2 to 4, becoming easterly or southeasterly 3 to 5, occasionally 6 later.',
    "sea" = 'Slight occasionally moderate.',
    "weather" = 'Rain or thundery showers.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  20,
  'Plymouth',
  'POLYGON((-6.78955078125 50.17689812200107,-6.85546875 48.45835188280866,-4.81201171875 48.429200555568386,-4.833984374999999 48.50204750525715,-4.50439453125 48.66194284607006,-4.28466796875 48.66194284607006,-4.04296875 48.73445537176822,-3.8671874999999996 48.63290858589532,-3.8452148437499996 48.73445537176822,-3.6474609374999996 48.719961222646276,-3.53759765625 48.821332549646634,-3.7353515625 50.275298611425185,-3.97705078125 50.331436330838834,-4.1748046875 50.359480346298696,-4.50439453125 50.359480346298696,-4.72412109375 50.3454604086048,-4.85595703125 50.24720490139267,-5.09765625 50.162824333817284,-5.07568359375 50.078294547389426,-5.1416015625 49.993615462541136,-5.295410156249999 50.12057809796008,-5.4931640625 50.14874640066278,-5.625 50.02185841773444,-5.73486328125 50.064191736659104,-5.73486328125 50.13466432216696,-6.78955078125 50.17689812200107))',
  {
    "wind" = 'Cyclonic becoming northwest, 3 to 5, increasing 6 or 7 for a time.',
    "sea" = 'Smooth or slight, becoming slight or moderate later.',
    "weather" = 'Squally thundery showers.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  21,
  'Portland',
  'POLYGON((-3.69140625 50.233151832472245,-3.515625 48.80686346108517,-3.14208984375 48.8936153614802,-2.724609375 48.531157010976735,-2.373046875 48.67645370777654,-2.26318359375 48.60385760823255,-1.9335937499999998 48.705462895790575,-1.8237304687499998 48.574789910928864,-1.42822265625 48.58932584966972,-1.58203125 48.821332549646634,-1.58203125 48.96579381461063,-1.60400390625 49.23912083246698,-1.86767578125 49.439556958940855,-1.9555664062500002 49.710272582105695,-2.04345703125 50.63901028125873,-2.4169921874999996 50.6947178381929,-2.4169921874999996 50.61113171332364,-2.8125 50.75035931136963,-3.18603515625 50.72254683363231,-3.427734375 50.61113171332364,-3.53759765625 50.48547354578499,-3.69140625 50.233151832472245))',
  {
    "wind" = 'Cyclonic becoming northwest, 3 to 5, increasing 6 or 7 for a time.',
    "sea" = 'Smooth or slight, becoming slight or moderate later.',
    "weather" = 'Squally thundery showers.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  22,
  'Rockall',
  'POLYGON((-10.1513671875 54.41892996865827,-14.809570312499998 54.34214886448341,-15.556640624999998 59.22093407615045,-11.6015625 58.92733441827545,-10.8544921875 57.11238500793404,-10.1513671875 54.41892996865827))',
  {
    "wind" = 'West or northwest backing southwest for a time, 4 to 6.',
    "sea" = 'Moderate occasionally rough.',
    "weather" = 'Rain or thundery showers.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  23,
  'Shannon',
  'POLYGON((-10.21728515625 50.28933925329178,-14.7216796875 50.3734961443035,-14.831542968749998 54.34214886448341,-10.12939453125 54.41892996865827,-10.107421874999998 54.16243396806779,-9.9755859375 54.13669645687002,-10.21728515625 54.059387886623576,-10.01953125 53.93021986394,-9.6240234375 53.93021986394,-9.64599609375 53.85252660044951,-9.931640625 53.80065082633023,-9.931640625 53.69670647530323,-10.1513671875 53.579461493732296,-10.1513671875 53.409531853086435,-9.82177734375 53.291489065300226,-9.580078125 53.225768435790194,-9.0087890625 53.27835301753182,-8.98681640625 53.199451902831555,-9.25048828125 53.173119202640635,-9.47021484375 52.92215137976296,-9.5361328125 52.82932091031373,-9.8876953125 52.5897007687178,-9.931640625 52.522905940278065,-9.55810546875 52.61639023304539,-9.865722656249998 52.44261787120725,-9.865722656249998 52.348763181988105,-9.931640625 52.281601868071434,-10.43701171875 52.24125614966341,-10.43701171875 52.14697334064471,-10.21728515625 52.13348804077147,-9.931640625 52.17393169256849,-10.39306640625 51.944264879028765,-10.3271484375 51.83577752045248,-10.12939453125 51.781435604431195,-9.755859375 51.86292391360244,-10.1953125 51.57706953722567,-10.21728515625 50.28933925329178))',
  {
    "wind" = 'Northwest 3 to 5, occasionally 6 later.',
    "sea" = 'Moderate, occasionally rough later in northwest.',
    "weather" = 'Showers, perhaps thundery.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  24,
  'Sole',
  'POLYGON((-14.7216796875 50.359480346298696,-10.2392578125 50.30337575356313,-6.8115234375 50.17689812200107,-6.85546875 48.472921272487824,-14.6337890625 48.69096039092549,-14.743652343749998 50.42951794712287,-14.7216796875 50.359480346298696))',
  {
    "wind" = 'West or northwest 3 to 5.',
    "sea" = 'Slight or moderate.',
    "weather" = 'Showers, perhaps thundery later.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  25,
  'South East Iceland',
  'POLYGON((-17.885742187499996 63.450509218001095,-13.798828125 61.75233128411639,-8.701171874999998 64.11060221954631,-13.0078125 65.38514722188854,-17.885742187499996 63.450509218001095))',
  {
    "wind" = 'Northeasterly 4 to 6, becoming cyclonic 3 to 5 later.',
    "sea" = 'Moderate, occasionally slight near shore.',
    "weather" = 'Occasional rain.',
    "visibility" = 'Moderate or good, occasionally poor.'
  }
),
(
  26,
  'South Utsire',
  'POLYGON((4.130859375 59.01794033995248,5.4931640625 59.085738569819505,5.537109374999999 58.950008233357046,5.44921875 58.77959115030064,5.5810546875 58.57398108438837,7.09716796875 58.019737000187305,7.6025390625 57.76279865944121,4.306640625 57.71588512774503,4.06494140625 58.619777025081675,4.130859375 59.01794033995248))',
  {
    "wind" = 'Variable 2 to 4, becoming easterly or southeasterly 3 to 5, occasionally 6 later.',
    "sea" = 'Slight occasionally moderate.',
    "weather" = 'Rain or thundery showers.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  27,
  'Thames',
  'POLYGON((1.40625 51.27566243415853,3.01025390625 51.28940590271679,3.427734375 51.42661449707482,3.7353515625 51.754240074033525,4.21875 52.07950600379697,4.592285156249999 52.5095347703273,4.6142578125 52.82932091031373,1.64794921875 52.68304276227743,1.669921875 52.335339071889386,1.5600585937499998 52.2008737173322,1.29638671875 51.957807388715516,1.2084960937499998 51.86292391360244,0.98876953125 51.82219818336938,0.76904296875 51.57706953722567,0.52734375 51.481382896100975,0.791015625 51.467696956223385,0.9008789062499999 51.358061573190916,1.3623046875 51.358061573190916,1.40625 51.27566243415853))',
  {
    "wind" = 'Southeast becoming cyclonic, then northwest later, 3 to 5, increasing 6 for a time.',
    "sea" = 'Smooth or slight.',
    "weather" = 'Squally thundery showers.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  28,
  'Trafalgar',
  'POLYGON((-14.6337890625 42.35854391749705,-14.94140625 39.80853604144591,-9.2724609375 39.50404070558415,-9.140625 39.707186656826565,-8.9208984375 40.01078714046552,-8.8330078125 40.38002840251183,-8.7890625 40.64730356252251,-8.7451171875 40.88029480552824,-8.7451171875 41.31082388091818,-8.9208984375 41.705728515237524,-8.9208984375 41.934976500546604,-8.7451171875 42.13082130188811,-14.6337890625 42.35854391749705))',
  {
    "wind" = 'Cyclonic becoming northerly or northwesterly except in southeast, 3 to 5, increasing 6 at times.',
    "sea" = 'Slight or moderate.',
    "weather" = 'Showers, fog patches in east.',
    "visibility" = 'Moderate or good, occasionally very poor in east but poor elsewhere.'
  }
),
(
  29,
  'Tyne',
  'POLYGON((-1.60400390625 55.52863052257191,-1.2084960937499998 54.67383096593114,-0.7470703125 54.55932258743861,-0.1318359375 54.149567212540525,0.9228515625 54.20101023973888,-0.5712890625 55.801280971180454,-1.60400390625 55.52863052257191))',
  {
    "wind" = 'South becoming cyclonic 3 to 5, then west 2 to 4 later.',
    "sea" = 'Smooth or slight.',
    "weather" = 'Rain or thundery showers.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  30,
  'Viking',
  'POLYGON((0.087890625 61.83541335794044,3.955078125 61.85614879566797,4.0869140625 58.58543569119917,0.1318359375 58.47072082411973,0.087890625 61.83541335794044))',
  {
    "wind" = 'Variable 2 to 4, becoming cyclonic 4 to 6.',
    "sea" = 'Slight or moderate.',
    "weather" = 'Rain or thundery showers.',
    "visibility" = 'Good, occasionally poor.'
  }
),
(
  31,
  'Wight',
  'POLYGON((-1.9335937499999998 49.724479188713005,-1.9555664062500002 50.61113171332364,-1.9555664062500002 50.708634400828224,-1.42822265625 50.764259357116465,-1.0107421875 50.792047064406866,-0.7470703125 50.764259357116465,-0.37353515625 50.792047064406866,-0.24169921874999997 50.83369767098071,0.24169921874999997 50.764259357116465,0.46142578125 50.84757295365389,1.5380859375 50.20503326494332,1.318359375 50.02185841773444,0.87890625 49.89463439573421,0.68115234375 49.89463439573421,0.24169921874999997 49.710272582105695,0.0439453125 49.48240137826932,0.2197265625 49.41097319969587,-0.19775390625 49.23912083246698,-0.439453125 49.33944093715546,-1.03271484375 49.41097319969587,-1.12060546875 49.35375571830993,-1.29638671875 49.49667452747045,-1.23046875 49.62494564650146,-1.3842773437499998 49.710272582105695,-1.60400390625 49.63917719651036,-1.9335937499999998 49.724479188713005))',
  {
    "wind" = 'Cyclonic becoming northwest, 3 to 5, increasing 6 or 7 for a time.',
    "sea" = 'Smooth or slight.',
    "weather" = 'Squally thundery showers.',
    "visibility" = 'Good, occasionally poor.'
  }
);