Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 xml со схемой  [new]
В трех соснах_заблудился
Guest
Подскажите. Совсем голова поехала
имеем схему:

+

CREATE XML SCHEMA COLLECTION "TEST" AS
N'<?xml version="1.0" encoding="UTF-16"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
  <xs:element name="forecast">
    <xs:complexType>
      <xs:sequence>
        <xs:element minOccurs="0" name="fact">
          <xs:complexType>
            <xs:sequence>
              <xs:element minOccurs="0" maxOccurs="unbounded" name="station">
                <xs:complexType>
                  <xs:simpleContent>
                    <xs:extension base="xs:string">
                      <xs:attribute name="lang" type="xs:string" use="optional" />
                      <xs:attribute name="distance" type="xs:unsignedByte" use="optional" />
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <xs:element minOccurs="0" name="observation_time" type="xs:dateTime" />
              <xs:element minOccurs="0" name="temperature">
                <xs:complexType>
                  <xs:simpleContent>
                    <xs:extension base="xs:byte">
                      <xs:attribute name="color" type="xs:string" use="optional" />
                      <xs:attribute name="plate" type="xs:string" use="optional" />
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <xs:element minOccurs="0" name="weather_condition">
                <xs:complexType>
                  <xs:attribute name="code" type="xs:string" use="optional" />
                </xs:complexType>
              </xs:element>
              <xs:element minOccurs="0" name="image">
                <xs:complexType>
                  <xs:simpleContent>
                    <xs:extension base="xs:unsignedByte">
                      <xs:attribute name="type" type="xs:unsignedByte" use="optional" />
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <xs:element minOccurs="0" name="image-v2">
                <xs:complexType>
                  <xs:simpleContent>
                    <xs:extension base="xs:string">
                      <xs:attribute name="color" type="xs:string" use="optional" />
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <xs:element minOccurs="0" name="weather_type" type="xs:string" />
              <xs:element minOccurs="0" name="weather_type_short" type="xs:string" />
              <xs:element minOccurs="0" name="weather_type_tt" type="xs:string" />
              <xs:element minOccurs="0" name="weather_type_short_tt" type="xs:string" />
              <xs:element minOccurs="0" name="weather_type_kz" type="xs:string" />
              <xs:element minOccurs="0" name="weather_type_short_kz" type="xs:string" />
              <xs:element minOccurs="0" name="weather_type_ua" type="xs:string" />
              <xs:element minOccurs="0" name="weather_type_short_ua" type="xs:string" />
              <xs:element minOccurs="0" name="weather_type_by" type="xs:string" />
              <xs:element minOccurs="0" name="weather_type_short_by" type="xs:string" />
              <xs:element minOccurs="0" name="wind_direction" type="xs:string" />
              <xs:element minOccurs="0" name="wind_speed" type="xs:decimal" />
              <xs:element minOccurs="0" name="humidity" type="xs:unsignedByte" />
              <xs:element minOccurs="0" name="pressure">
                <xs:complexType>
                  <xs:simpleContent>
                    <xs:extension base="xs:unsignedShort">
                      <xs:attribute name="units" type="xs:string" use="optional" />
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <xs:element minOccurs="0" name="mslp_pressure">
                <xs:complexType>
                  <xs:simpleContent>
                    <xs:extension base="xs:unsignedShort">
                      <xs:attribute name="units" type="xs:string" use="optional" />
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <xs:element minOccurs="0" name="daytime" type="xs:string" />
              <xs:element minOccurs="0" name="season">
                <xs:complexType>
                  <xs:simpleContent>
                    <xs:extension base="xs:string">
                      <xs:attribute name="type" type="xs:string" use="optional" />
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element minOccurs="0" name="informer">
          <xs:complexType>
            <xs:sequence>
              <xs:element minOccurs="0" maxOccurs="unbounded" name="temperature">
                <xs:complexType>
                  <xs:simpleContent>
                    <xs:extension base="xs:byte">
                      <xs:attribute name="color" type="xs:string" use="optional" />
                      <xs:attribute name="type" type="xs:string" use="optional" />
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element minOccurs="0" maxOccurs="unbounded" name="day">
          <xs:complexType>
            <xs:sequence>
              <xs:element minOccurs="0" name="sunrise" type="xs:string" />
              <xs:element minOccurs="0" name="sunset" type="xs:string" />
              <xs:element minOccurs="0" name="moon_phase">
                <xs:complexType>
                  <xs:simpleContent>
                    <xs:extension base="xs:unsignedByte">
                      <xs:attribute name="code" type="xs:string" use="optional" />
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <xs:element minOccurs="0" name="moonrise" type="xs:string" />
              <xs:element minOccurs="0" name="moonset" type="xs:string" />
              <xs:element minOccurs="0" name="biomet">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element minOccurs="0" maxOccurs="unbounded" name="message">
                      <xs:complexType>
                        <xs:attribute name="code" type="xs:string" use="optional" />
                      </xs:complexType>
                    </xs:element>
                  </xs:sequence>
                  <xs:attribute name="index" type="xs:unsignedByte" use="optional" />
                  <xs:attribute name="geomag" type="xs:unsignedByte" use="optional" />
                </xs:complexType>
              </xs:element>
              <xs:element minOccurs="0" maxOccurs="unbounded" name="day_part">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element minOccurs="0" name="temperature" type="xs:byte" />
                    <xs:element minOccurs="0" name="temperature_from" type="xs:byte" />
                    <xs:element minOccurs="0" name="temperature_to" type="xs:byte" />
                    <xs:element minOccurs="0" name="weather_condition">
                      <xs:complexType>
                        <xs:attribute name="code" type="xs:string" use="optional" />
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="image">
                      <xs:complexType>
                        <xs:simpleContent>
                          <xs:extension base="xs:string">
                            <xs:attribute name="type" type="xs:unsignedByte" use="optional" />
                          </xs:extension>
                        </xs:simpleContent>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="image-v2">
                      <xs:complexType>
                        <xs:simpleContent>
                          <xs:extension base="xs:string">
                            <xs:attribute name="color" type="xs:string" use="optional" />
                          </xs:extension>
                        </xs:simpleContent>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="weather_type" type="xs:string" />
                    <xs:element minOccurs="0" name="weather_type_short" type="xs:string" />
                    <xs:element minOccurs="0" name="weather_type_tt" type="xs:string" />
                    <xs:element minOccurs="0" name="weather_type_short_tt" type="xs:string" />
                    <xs:element minOccurs="0" name="weather_type_kz" type="xs:string" />
                    <xs:element minOccurs="0" name="weather_type_short_kz" type="xs:string" />
                    <xs:element minOccurs="0" name="weather_type_ua" type="xs:string" />
                    <xs:element minOccurs="0" name="weather_type_short_ua" type="xs:string" />
                    <xs:element minOccurs="0" name="weather_type_by" type="xs:string" />
                    <xs:element minOccurs="0" name="weather_type_short_by" type="xs:string" />
                    <xs:element minOccurs="0" name="wind_direction" type="xs:string" />
                    <xs:element minOccurs="0" name="wind_speed" type="xs:decimal" />
                    <xs:element minOccurs="0" name="humidity" type="xs:unsignedByte" />
                    <xs:element minOccurs="0" name="pressure">
                      <xs:complexType>
                        <xs:simpleContent>
                          <xs:extension base="xs:unsignedShort">
                            <xs:attribute name="units" type="xs:string" use="optional" />
                          </xs:extension>
                        </xs:simpleContent>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="mslp_pressure">
                      <xs:complexType>
                        <xs:simpleContent>
                          <xs:extension base="xs:unsignedShort">
                            <xs:attribute name="units" type="xs:string" use="optional" />
                          </xs:extension>
                        </xs:simpleContent>
                      </xs:complexType>
                    </xs:element>
                  </xs:sequence>
                  <xs:attribute name="typeid" type="xs:unsignedByte" use="optional" />
                  <xs:attribute name="type" type="xs:string" use="optional" />
                </xs:complexType>
              </xs:element>
              <xs:element minOccurs="0" maxOccurs="unbounded" name="hour">
                <xs:complexType>
                  <xs:sequence>
                    <xs:element minOccurs="0" name="temperature" type="xs:byte" />
                    <xs:element minOccurs="0" name="weather_condition">
                      <xs:complexType>
                        <xs:attribute name="code" type="xs:string" use="optional" />
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="image">
                      <xs:complexType>
                        <xs:simpleContent>
                          <xs:extension base="xs:string">
                            <xs:attribute name="type" type="xs:unsignedByte" use="optional" />
                          </xs:extension>
                        </xs:simpleContent>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="image-v2">
                      <xs:complexType>
                        <xs:simpleContent>
                          <xs:extension base="xs:string">
                            <xs:attribute name="color" type="xs:string" use="optional" />
                          </xs:extension>
                        </xs:simpleContent>
                      </xs:complexType>
                    </xs:element>
                  </xs:sequence>
                  <xs:attribute name="at" type="xs:unsignedByte" use="optional" />
                </xs:complexType>
              </xs:element>
            </xs:sequence>
            <xs:attribute name="date" type="xs:date" use="optional" />
          </xs:complexType>
        </xs:element>
      </xs:sequence>
      <xs:attribute name="city" type="xs:string" use="optional" />
      <xs:attribute name="country" type="xs:string" use="optional" />
      <xs:attribute name="region" type="xs:unsignedShort" use="optional" />
      <xs:attribute name="lon" type="xs:decimal" use="optional" />
      <xs:attribute name="zoom" type="xs:unsignedByte" use="optional" />
      <xs:attribute name="id" type="xs:unsignedShort" use="optional" />
      <xs:attribute name="source" type="xs:string" use="optional" />
      <xs:attribute name="country_id" type="xs:string" use="optional" />
      <xs:attribute name="link" type="xs:string" use="optional" />
      <xs:attribute name="part_id" type="xs:string" use="optional" />
      <xs:attribute name="geoid" type="xs:unsignedShort" use="optional" />
      <xs:attribute name="lat" type="xs:decimal" use="optional" />
      <xs:attribute name="exactname" type="xs:string" use="optional" />
      <xs:attribute name="part" type="xs:string" use="optional" />
      <xs:attribute name="slug" type="xs:string" use="optional" />
    </xs:complexType>
  </xs:element>
</xs:schema>
'



имеем xml файл:

+

<forecast xmlns="TEST" city="Test" country="Test" region="965" lon="39.823147" zoom="10" id="33278" source="Station" country_id="a36132306e4574ca78381ceaac5b9e15" link="http://pogoda/Omsk/" part_id="4c02f07488cb250358249d231c470a62" geoid="965" lat="55.907652" exactname="Test" part="Omskaya область" slug="TEst">
<fact>
<station lang="ru" distance="11">Test</station>
<station lang="en" distance="11">Test</station>
<observation_time>2012-01-23T14:00:00</observation_time>
<temperature color="E0E7EE" plate="a7c8ea">-6</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">13</image>
<image-v2 color="5c7794">ovc_-sn_-6</image-v2>
<weather_type>облачно, временами снег</weather_type>
<weather_type_short>обл., вр. снег</weather_type_short>
<weather_type_tt>болытлы, вакыты бел?н кар</weather_type_tt>
<weather_type_short_tt>бол., вак. кар</weather_type_short_tt>
<weather_type_kz>б?лы??ыр, кейде ?ар</weather_type_kz>
<weather_type_short_kz>б?лы??ыр, кейде ?ар</weather_type_short_kz>
<weather_type_ua>хмарно, часом сніг</weather_type_ua>
<weather_type_short_ua>хмарно, часом сніг</weather_type_short_ua>
<weather_type_by>воблачна, часам снег</weather_type_by>
<weather_type_short_by>вобл., часам снег</weather_type_short_by>
<wind_direction>se</wind_direction>
<wind_speed>7.0</wind_speed>
<humidity>86</humidity>
<pressure units="torr">747</pressure>
<mslp_pressure units="hPa">1015</mslp_pressure>
<daytime>d</daytime>
<season type="calendar">winter</season>
</fact>
<informer>
<temperature color="DAE5ED" type="night">-9</temperature>
<temperature color="DAE5ED" type="tomorrow">-9</temperature>
</informer>
<day date="2012-01-23">
<sunrise>07:30</sunrise>
<sunset>16:16</sunset>
<moon_phase code="new-moon">8</moon_phase>
<moonrise>07:08</moonrise>
<moonset>16:47</moonset>
<biomet index="2" geomag="2">
<message code="meteosens-likely" />
<message code="solar-minor" />
<message code="moon-full" />
</biomet>
<day_part typeid="1" type="morning">
<temperature_from>-6</temperature_from>
<temperature_to>-5</temperature_to>
<weather_condition code="overcast-and-light-snow" />
<image type="2">13</image>
<image-v2 color="5c7794">ovc_-sn_-6</image-v2>
<weather_type>облачно, небольшой снег</weather_type>
<weather_type_short>обл., неб. снег</weather_type_short>
<weather_type_tt>болытлы, аз гына кар</weather_type_tt>
<weather_type_short_tt>бол., аз гына кар</weather_type_short_tt>
<weather_type_kz>б?лы??ыр, азда?ан ?ар</weather_type_kz>
<weather_type_short_kz>б?лы??ыр, азда?ан ?ар</weather_type_short_kz>
<weather_type_ua>хмарно, невеликий сніг</weather_type_ua>
<weather_type_short_ua>хмарно, невел. сніг</weather_type_short_ua>
<weather_type_by>воблачна, слабы снег</weather_type_by>
<weather_type_short_by>вобл., сл. снег</weather_type_short_by>
<wind_direction>se</wind_direction>
<wind_speed>11.0</wind_speed>
<humidity>89</humidity>
<pressure units="torr">744</pressure>
<mslp_pressure units="hPa">1011</mslp_pressure>
</day_part>
<day_part typeid="2" type="day">
<temperature>-6</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">13</image>
<image-v2 color="5c7794">ovc_-sn_-6</image-v2>
<weather_type>облачно, временами снег</weather_type>
<weather_type_short>обл., вр. снег</weather_type_short>
<weather_type_tt>болытлы, вакыты бел?н кар</weather_type_tt>
<weather_type_short_tt>бол., вак. кар</weather_type_short_tt>
<weather_type_kz>б?лы??ыр, кейде ?ар</weather_type_kz>
<weather_type_short_kz>б?лы??ыр, кейде ?ар</weather_type_short_kz>
<weather_type_ua>хмарно, часом сніг</weather_type_ua>
<weather_type_short_ua>хмарно, часом сніг</weather_type_short_ua>
<weather_type_by>воблачна, часам снег</weather_type_by>
<weather_type_short_by>вобл., часам снег</weather_type_short_by>
<wind_direction>se</wind_direction>
<wind_speed>9.6</wind_speed>
<humidity>87</humidity>
<pressure units="torr">747</pressure>
<mslp_pressure units="hPa">1015</mslp_pressure>
</day_part>
<day_part typeid="3" type="evening">
<temperature_from>-8</temperature_from>
<temperature_to>-7</temperature_to>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">n13</image>
<image-v2 color="4f7b9f">ovc_-sn_-8</image-v2>
<weather_type>облачно, временами снег</weather_type>
<weather_type_short>обл., вр. снег</weather_type_short>
<weather_type_tt>болытлы, вакыты бел?н кар</weather_type_tt>
<weather_type_short_tt>бол., вак. кар</weather_type_short_tt>
<weather_type_kz>б?лы??ыр, кейде ?ар</weather_type_kz>
<weather_type_short_kz>б?лы??ыр, кейде ?ар</weather_type_short_kz>
<weather_type_ua>хмарно, часом сніг</weather_type_ua>
<weather_type_short_ua>хмарно, часом сніг</weather_type_short_ua>
<weather_type_by>воблачна, часам снег</weather_type_by>
<weather_type_short_by>вобл., часам снег</weather_type_short_by>
<wind_direction>se</wind_direction>
<wind_speed>8.8</wind_speed>
<humidity>88</humidity>
<pressure units="torr">749</pressure>
<mslp_pressure units="hPa">1017</mslp_pressure>
</day_part>
<day_part typeid="4" type="night">
<temperature>-9</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="4f7b9f">ovc_-sn_-8</image-v2>
<weather_type>облачно, небольшой снег</weather_type>
<weather_type_short>обл., неб. снег</weather_type_short>
<weather_type_tt>болытлы, аз гына кар</weather_type_tt>
<weather_type_short_tt>бол., аз гына кар</weather_type_short_tt>
<weather_type_kz>б?лы??ыр, азда?ан ?ар</weather_type_kz>
<weather_type_short_kz>б?лы??ыр, азда?ан ?ар</weather_type_short_kz>
<weather_type_ua>хмарно, невеликий сніг</weather_type_ua>
<weather_type_short_ua>хмарно, невел. сніг</weather_type_short_ua>
<weather_type_by>воблачна, слабы снег</weather_type_by>
<weather_type_short_by>вобл., сл. снег</weather_type_short_by>
<wind_direction>se</wind_direction>
<wind_speed>7.8</wind_speed>
<humidity>87</humidity>
<pressure units="torr">750</pressure>
<mslp_pressure units="hPa">1019</mslp_pressure>
</day_part>
<day_part typeid="5" type="day_short">
<temperature>-5</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">13</image>
<image-v2 color="657f8d">ovc_-sn_-4</image-v2>
<weather_type>облачно, временами снег</weather_type>
<weather_type_short>обл., вр. снег</weather_type_short>
<weather_type_tt>болытлы, вакыты бел?н кар</weather_type_tt>
<weather_type_short_tt>бол., вак. кар</weather_type_short_tt>
<weather_type_kz>б?лы??ыр, кейде ?ар</weather_type_kz>
<weather_type_short_kz>б?лы??ыр, кейде ?ар</weather_type_short_kz>
<weather_type_ua>хмарно, часом сніг</weather_type_ua>
<weather_type_short_ua>хмарно, часом сніг</weather_type_short_ua>
<weather_type_by>воблачна, часам снег</weather_type_by>
<weather_type_short_by>вобл., часам снег</weather_type_short_by>
<wind_direction>se</wind_direction>
<wind_speed>9.6</wind_speed>
<humidity>87</humidity>
<pressure units="torr">747</pressure>
<mslp_pressure units="hPa">1015</mslp_pressure>
</day_part>
<day_part typeid="6" type="night_short">
<temperature>-9</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="4f7b9f">ovc_-sn_-8</image-v2>
<weather_type>облачно, небольшой снег</weather_type>
<weather_type_short>обл., неб. снег</weather_type_short>
<weather_type_tt>болытлы, аз гына кар</weather_type_tt>
<weather_type_short_tt>бол., аз гына кар</weather_type_short_tt>
<weather_type_kz>б?лы??ыр, азда?ан ?ар</weather_type_kz>
<weather_type_short_kz>б?лы??ыр, азда?ан ?ар</weather_type_short_kz>
<weather_type_ua>хмарно, невеликий сніг</weather_type_ua>
<weather_type_short_ua>хмарно, невел. сніг</weather_type_short_ua>
<weather_type_by>воблачна, слабы снег</weather_type_by>
<weather_type_short_by>вобл., сл. снег</weather_type_short_by>
<wind_direction>se</wind_direction>
<wind_speed>7.8</wind_speed>
<humidity>87</humidity>
<pressure units="torr">750</pressure>
<mslp_pressure units="hPa">1019</mslp_pressure>
</day_part>
<hour at="0">
<temperature>-8</temperature>
<weather_condition code="overcast-and-snow" />
<image type="1">n2</image>
<image-v2 color="4f7b9f">ovc_sn_-8</image-v2>
</hour>
<hour at="1">
<temperature>-8</temperature>
<weather_condition code="overcast-and-snow" />
<image type="1">n2</image>
<image-v2 color="4f7b9f">ovc_sn_-8</image-v2>
</hour>
<hour at="2">
<temperature>-9</temperature>
<weather_condition code="overcast-and-snow" />
<image type="1">n2</image>
<image-v2 color="4f7b9f">ovc_sn_-8</image-v2>
</hour>
<hour at="3">
<temperature>-8</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">n13</image>
<image-v2 color="4f7b9f">ovc_-sn_-8</image-v2>
</hour>
<hour at="4">
<temperature>-7</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">n13</image>
<image-v2 color="5c7794">ovc_-sn_-6</image-v2>
</hour>
<hour at="5">
<temperature>-7</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">n13</image>
<image-v2 color="5c7794">ovc_-sn_-6</image-v2>
</hour>
<hour at="6">
<temperature>-6</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="5c7794">ovc_-sn_-6</image-v2>
</hour>
<hour at="7">
<temperature>-5</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="657f8d">ovc_-sn_-4</image-v2>
</hour>
<hour at="8">
<temperature>-6</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">13</image>
<image-v2 color="5c7794">ovc_-sn_-6</image-v2>
</hour>
<hour at="9">
<temperature>-5</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">13</image>
<image-v2 color="657f8d">ovc_-sn_-4</image-v2>
</hour>
<hour at="10">
<temperature>-5</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">13</image>
<image-v2 color="657f8d">ovc_-sn_-4</image-v2>
</hour>
<hour at="11">
<temperature>-6</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">13</image>
<image-v2 color="5c7794">ovc_-sn_-6</image-v2>
</hour>
<hour at="12">
<temperature>-6</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">13</image>
<image-v2 color="5c7794">ovc_-sn_-6</image-v2>
</hour>
<hour at="13">
<temperature>-6</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">13</image>
<image-v2 color="5c7794">ovc_-sn_-6</image-v2>
</hour>
<hour at="14">
<temperature>-6</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">13</image>
<image-v2 color="5c7794">ovc_-sn_-6</image-v2>
</hour>
<hour at="15">
<temperature>-6</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">13</image>
<image-v2 color="5c7794">ovc_-sn_-6</image-v2>
</hour>
<hour at="16">
<temperature>-6</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">13</image>
<image-v2 color="5c7794">ovc_-sn_-6</image-v2>
</hour>
<hour at="17">
<temperature>-6</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">n13</image>
<image-v2 color="5c7794">ovc_-sn_-6</image-v2>
</hour>
<hour at="18">
<temperature>-7</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">n13</image>
<image-v2 color="5c7794">ovc_-sn_-6</image-v2>
</hour>
<hour at="19">
<temperature>-7</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">n13</image>
<image-v2 color="5c7794">ovc_-sn_-6</image-v2>
</hour>
<hour at="20">
<temperature>-8</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">n13</image>
<image-v2 color="4f7b9f">ovc_-sn_-8</image-v2>
</hour>
<hour at="21">
<temperature>-8</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="4f7b9f">ovc_-sn_-8</image-v2>
</hour>
<hour at="22">
<temperature>-8</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="4f7b9f">ovc_-sn_-8</image-v2>
</hour>
<hour at="23">
<temperature>-8</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="4f7b9f">ovc_-sn_-8</image-v2>
</hour>
<hour at="0">
<temperature>-9</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="4f7b9f">ovc_-sn_-8</image-v2>
</hour>
</day>
<day date="2012-01-24">
<sunrise>07:28</sunrise>
<sunset>16:17</sunset>
<moon_phase code="growing-moon">8</moon_phase>
<moonrise>07:35</moonrise>
<moonset>18:01</moonset>
<biomet index="0" geomag="1">
<message code="meteosens-favorable" />
<message code="solar-weak" />
</biomet>
<day_part typeid="1" type="morning">
<temperature_from>-10</temperature_from>
<temperature_to>-9</temperature_to>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">13</image>
<image-v2 color="4582a5">ovc_-sn_-10</image-v2>
<weather_type>облачно, временами снег</weather_type>
<weather_type_short>обл., вр. снег</weather_type_short>
<weather_type_tt>болытлы, вакыты бел?н кар</weather_type_tt>
<weather_type_short_tt>бол., вак. кар</weather_type_short_tt>
<weather_type_kz>б?лы??ыр, кейде ?ар</weather_type_kz>
<weather_type_short_kz>б?лы??ыр, кейде ?ар</weather_type_short_kz>
<weather_type_ua>хмарно, часом сніг</weather_type_ua>
<weather_type_short_ua>хмарно, часом сніг</weather_type_short_ua>
<weather_type_by>воблачна, часам снег</weather_type_by>
<weather_type_short_by>вобл., часам снег</weather_type_short_by>
<wind_direction>se</wind_direction>
<wind_speed>7.4</wind_speed>
<humidity>87</humidity>
<pressure units="torr">752</pressure>
<mslp_pressure units="hPa">1021</mslp_pressure>
</day_part>
<day_part typeid="2" type="day">
<temperature_from>-11</temperature_from>
<temperature_to>-10</temperature_to>
<weather_condition code="overcast-and-light-snow" />
<image type="2">13</image>
<image-v2 color="4582a5">ovc_-sn_-10</image-v2>
<weather_type>облачно, небольшой снег</weather_type>
<weather_type_short>обл., неб. снег</weather_type_short>
<weather_type_tt>болытлы, аз гына кар</weather_type_tt>
<weather_type_short_tt>бол., аз гына кар</weather_type_short_tt>
<weather_type_kz>б?лы??ыр, азда?ан ?ар</weather_type_kz>
<weather_type_short_kz>б?лы??ыр, азда?ан ?ар</weather_type_short_kz>
<weather_type_ua>хмарно, невеликий сніг</weather_type_ua>
<weather_type_short_ua>хмарно, невел. сніг</weather_type_short_ua>
<weather_type_by>воблачна, слабы снег</weather_type_by>
<weather_type_short_by>вобл., сл. снег</weather_type_short_by>
<wind_direction>se</wind_direction>
<wind_speed>7.3</wind_speed>
<humidity>84</humidity>
<pressure units="torr">753</pressure>
<mslp_pressure units="hPa">1023</mslp_pressure>
</day_part>
<day_part typeid="3" type="evening">
<temperature_from>-12</temperature_from>
<temperature_to>-11</temperature_to>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="377daf">ovc_-sn_-12</image-v2>
<weather_type>облачно, небольшой снег</weather_type>
<weather_type_short>обл., неб. снег</weather_type_short>
<weather_type_tt>болытлы, аз гына кар</weather_type_tt>
<weather_type_short_tt>бол., аз гына кар</weather_type_short_tt>
<weather_type_kz>б?лы??ыр, азда?ан ?ар</weather_type_kz>
<weather_type_short_kz>б?лы??ыр, азда?ан ?ар</weather_type_short_kz>
<weather_type_ua>хмарно, невеликий сніг</weather_type_ua>
<weather_type_short_ua>хмарно, невел. сніг</weather_type_short_ua>
<weather_type_by>воблачна, слабы снег</weather_type_by>
<weather_type_short_by>вобл., сл. снег</weather_type_short_by>
<wind_direction>se</wind_direction>
<wind_speed>6.8</wind_speed>
<humidity>86</humidity>
<pressure units="torr">755</pressure>
<mslp_pressure units="hPa">1025</mslp_pressure>
</day_part>
<day_part typeid="4" type="night">
<temperature>-13</temperature>
<weather_condition code="overcast" />
<image type="1">n5</image>
<image-v2 color="377daf">ovc_-12</image-v2>
<weather_type>облачно</weather_type>
<weather_type_short>облачно</weather_type_short>
<weather_type_tt>болытлы</weather_type_tt>
<weather_type_short_tt>болытлы</weather_type_short_tt>
<weather_type_kz>б?лтты</weather_type_kz>
<weather_type_short_kz>б?лтты</weather_type_short_kz>
<weather_type_ua>хмарно</weather_type_ua>
<weather_type_short_ua>хмарно</weather_type_short_ua>
<weather_type_by>воблачна</weather_type_by>
<weather_type_short_by>воблачна</weather_type_short_by>
<wind_direction>se</wind_direction>
<wind_speed>6.4</wind_speed>
<humidity>84</humidity>
<pressure units="torr">756</pressure>
<mslp_pressure units="hPa">1027</mslp_pressure>
</day_part>
<day_part typeid="5" type="day_short">
<temperature>-9</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">13</image>
<image-v2 color="4f7b9f">ovc_-sn_-8</image-v2>
<weather_type>облачно, небольшой снег</weather_type>
<weather_type_short>обл., неб. снег</weather_type_short>
<weather_type_tt>болытлы, аз гына кар</weather_type_tt>
<weather_type_short_tt>бол., аз гына кар</weather_type_short_tt>
<weather_type_kz>б?лы??ыр, азда?ан ?ар</weather_type_kz>
<weather_type_short_kz>б?лы??ыр, азда?ан ?ар</weather_type_short_kz>
<weather_type_ua>хмарно, невеликий сніг</weather_type_ua>
<weather_type_short_ua>хмарно, невел. сніг</weather_type_short_ua>
<weather_type_by>воблачна, слабы снег</weather_type_by>
<weather_type_short_by>вобл., сл. снег</weather_type_short_by>
<wind_direction>se</wind_direction>
<wind_speed>7.3</wind_speed>
<humidity>84</humidity>
<pressure units="torr">753</pressure>
<mslp_pressure units="hPa">1023</mslp_pressure>
</day_part>
<day_part typeid="6" type="night_short">
<temperature>-13</temperature>
<weather_condition code="overcast" />
<image type="1">n5</image>
<image-v2 color="377daf">ovc_-12</image-v2>
<weather_type>облачно</weather_type>
<weather_type_short>облачно</weather_type_short>
<weather_type_tt>болытлы</weather_type_tt>
<weather_type_short_tt>болытлы</weather_type_short_tt>
<weather_type_kz>б?лтты</weather_type_kz>
<weather_type_short_kz>б?лтты</weather_type_short_kz>
<weather_type_ua>хмарно</weather_type_ua>
<weather_type_short_ua>хмарно</weather_type_short_ua>
<weather_type_by>воблачна</weather_type_by>
<weather_type_short_by>воблачна</weather_type_short_by>
<wind_direction>se</wind_direction>
<wind_speed>6.4</wind_speed>
<humidity>84</humidity>
<pressure units="torr">756</pressure>
<mslp_pressure units="hPa">1027</mslp_pressure>
</day_part>
<hour at="0">
<temperature>-9</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="4f7b9f">ovc_-sn_-8</image-v2>
</hour>
<hour at="1">
<temperature>-9</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="4f7b9f">ovc_-sn_-8</image-v2>
</hour>
<hour at="2">
<temperature>-9</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="4f7b9f">ovc_-sn_-8</image-v2>
</hour>
<hour at="3">
<temperature>-9</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="4f7b9f">ovc_-sn_-8</image-v2>
</hour>
<hour at="4">
<temperature>-9</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="4f7b9f">ovc_-sn_-8</image-v2>
</hour>
<hour at="5">
<temperature>-9</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="4f7b9f">ovc_-sn_-8</image-v2>
</hour>
<hour at="6">
<temperature>-9</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">n13</image>
<image-v2 color="4f7b9f">ovc_-sn_-8</image-v2>
</hour>
<hour at="7">
<temperature>-9</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">n13</image>
<image-v2 color="4f7b9f">ovc_-sn_-8</image-v2>
</hour>
<hour at="8">
<temperature>-10</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">13</image>
<image-v2 color="4582a5">ovc_-sn_-10</image-v2>
</hour>
<hour at="9">
<temperature>-10</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">13</image>
<image-v2 color="4582a5">ovc_-sn_-10</image-v2>
</hour>
<hour at="10">
<temperature>-10</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">13</image>
<image-v2 color="4582a5">ovc_-sn_-10</image-v2>
</hour>
<hour at="11">
<temperature>-10</temperature>
<weather_condition code="overcast-and-snow-showers" />
<image type="2">13</image>
<image-v2 color="4582a5">ovc_-sn_-10</image-v2>
</hour>
<hour at="12">
<temperature>-10</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">13</image>
<image-v2 color="4582a5">ovc_-sn_-10</image-v2>
</hour>
<hour at="13">
<temperature>-10</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">13</image>
<image-v2 color="4582a5">ovc_-sn_-10</image-v2>
</hour>
<hour at="14">
<temperature>-10</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">13</image>
<image-v2 color="4582a5">ovc_-sn_-10</image-v2>
</hour>
<hour at="15">
<temperature>-11</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">13</image>
<image-v2 color="4582a5">ovc_-sn_-10</image-v2>
</hour>
<hour at="16">
<temperature>-11</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">13</image>
<image-v2 color="4582a5">ovc_-sn_-10</image-v2>
</hour>
<hour at="17">
<temperature>-11</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="4582a5">ovc_-sn_-10</image-v2>
</hour>
<hour at="18">
<temperature>-11</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="4582a5">ovc_-sn_-10</image-v2>
</hour>
<hour at="19">
<temperature>-11</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="4582a5">ovc_-sn_-10</image-v2>
</hour>
<hour at="20">
<temperature>-11</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="4582a5">ovc_-sn_-10</image-v2>
</hour>
<hour at="21">
<temperature>-12</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="377daf">ovc_-sn_-12</image-v2>
</hour>
<hour at="22">
<temperature>-12</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="377daf">ovc_-sn_-12</image-v2>
</hour>
<hour at="23">
<temperature>-12</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="377daf">ovc_-sn_-12</image-v2>
</hour>
<hour at="0">
<temperature>-12</temperature>
<weather_condition code="overcast" />
<image type="1">n5</image>
<image-v2 color="377daf">ovc_-12</image-v2>
</hour>
</day>
<day date="2012-01-25">
<sunrise>07:27</sunrise>
<sunset>16:19</sunset>
<moon_phase code="growing-moon">9</moon_phase>
<moonrise>07:57</moonrise>
<moonset>19:13</moonset>
<day_part typeid="1" type="morning">
<temperature_from>-17</temperature_from>
<temperature_to>-15</temperature_to>
<weather_condition code="clear" />
<image type="1">7</image>
<image-v2 color="2584bc">skc_d_-16</image-v2>
<weather_type>ясно</weather_type>
<weather_type_short>ясно</weather_type_short>
<weather_type_tt>аяз</weather_type_tt>
<weather_type_short_tt>аяз</weather_type_short_tt>
<weather_type_kz>ашы?</weather_type_kz>
<weather_type_short_kz>ашы?</weather_type_short_kz>
<weather_type_ua>ясно</weather_type_ua>
<weather_type_short_ua>ясно</weather_type_short_ua>
<weather_type_by>ясна</weather_type_by>
<weather_type_short_by>ясна</weather_type_short_by>
<wind_direction>e</wind_direction>
<wind_speed>5.2</wind_speed>
<humidity>73</humidity>
<pressure units="torr">758</pressure>
<mslp_pressure units="hPa">1030</mslp_pressure>
</day_part>
<day_part typeid="2" type="day">
<temperature_from>-17</temperature_from>
<temperature_to>-16</temperature_to>
<weather_condition code="overcast" />
<image type="1">5</image>
<image-v2 color="2584bc">ovc_-16</image-v2>
<weather_type>облачно</weather_type>
<weather_type_short>облачно</weather_type_short>
<weather_type_tt>болытлы</weather_type_tt>
<weather_type_short_tt>болытлы</weather_type_short_tt>
<weather_type_kz>б?лтты</weather_type_kz>
<weather_type_short_kz>б?лтты</weather_type_short_kz>
<weather_type_ua>хмарно</weather_type_ua>
<weather_type_short_ua>хмарно</weather_type_short_ua>
<weather_type_by>воблачна</weather_type_by>
<weather_type_short_by>воблачна</weather_type_short_by>
<wind_direction>e</wind_direction>
<wind_speed>4.3</wind_speed>
<humidity>70</humidity>
<pressure units="torr">758</pressure>
<mslp_pressure units="hPa">1030</mslp_pressure>
</day_part>
<day_part typeid="3" type="evening">
<temperature_from>-16</temperature_from>
<temperature_to>-15</temperature_to>
<weather_condition code="overcast" />
<image type="1">n5</image>
<image-v2 color="2a81b9">ovc_-14</image-v2>
<weather_type>облачно</weather_type>
<weather_type_short>облачно</weather_type_short>
<weather_type_tt>болытлы</weather_type_tt>
<weather_type_short_tt>болытлы</weather_type_short_tt>
<weather_type_kz>б?лтты</weather_type_kz>
<weather_type_short_kz>б?лтты</weather_type_short_kz>
<weather_type_ua>хмарно</weather_type_ua>
<weather_type_short_ua>хмарно</weather_type_short_ua>
<weather_type_by>воблачна</weather_type_by>
<weather_type_short_by>воблачна</weather_type_short_by>
<wind_direction>e</wind_direction>
<wind_speed>4.5</wind_speed>
<humidity>73</humidity>
<pressure units="torr">759</pressure>
<mslp_pressure units="hPa">1031</mslp_pressure>
</day_part>
<day_part typeid="4" type="night">
<temperature>-17</temperature>
<weather_condition code="overcast" />
<image type="1">n5</image>
<image-v2 color="2584bc">ovc_-16</image-v2>
<weather_type>облачно</weather_type>
<weather_type_short>облачно</weather_type_short>
<weather_type_tt>болытлы</weather_type_tt>
<weather_type_short_tt>болытлы</weather_type_short_tt>
<weather_type_kz>б?лтты</weather_type_kz>
<weather_type_short_kz>б?лтты</weather_type_short_kz>
<weather_type_ua>хмарно</weather_type_ua>
<weather_type_short_ua>хмарно</weather_type_short_ua>
<weather_type_by>воблачна</weather_type_by>
<weather_type_short_by>воблачна</weather_type_short_by>
<wind_direction>e</wind_direction>
<wind_speed>4.7</wind_speed>
<humidity>78</humidity>
<pressure units="torr">760</pressure>
<mslp_pressure units="hPa">1032</mslp_pressure>
</day_part>
<day_part typeid="5" type="day_short">
<temperature>-15</temperature>
<weather_condition code="overcast" />
<image type="1">5</image>
<image-v2 color="2a81b9">ovc_-14</image-v2>
<weather_type>облачно</weather_type>
<weather_type_short>облачно</weather_type_short>
<weather_type_tt>болытлы</weather_type_tt>
<weather_type_short_tt>болытлы</weather_type_short_tt>
<weather_type_kz>б?лтты</weather_type_kz>
<weather_type_short_kz>б?лтты</weather_type_short_kz>
<weather_type_ua>хмарно</weather_type_ua>
<weather_type_short_ua>хмарно</weather_type_short_ua>
<weather_type_by>воблачна</weather_type_by>
<weather_type_short_by>воблачна</weather_type_short_by>
<wind_direction>e</wind_direction>
<wind_speed>4.3</wind_speed>
<humidity>70</humidity>
<pressure units="torr">758</pressure>
<mslp_pressure units="hPa">1030</mslp_pressure>
</day_part>
<day_part typeid="6" type="night_short">
<temperature>-17</temperature>
<weather_condition code="overcast" />
<image type="1">n5</image>
<image-v2 color="2584bc">ovc_-16</image-v2>
<weather_type>облачно</weather_type>
<weather_type_short>облачно</weather_type_short>
<weather_type_tt>болытлы</weather_type_tt>
<weather_type_short_tt>болытлы</weather_type_short_tt>
<weather_type_kz>б?лтты</weather_type_kz>
<weather_type_short_kz>б?лтты</weather_type_short_kz>
<weather_type_ua>хмарно</weather_type_ua>
<weather_type_short_ua>хмарно</weather_type_short_ua>
<weather_type_by>воблачна</weather_type_by>
<weather_type_short_by>воблачна</weather_type_short_by>
<wind_direction>e</wind_direction>
<wind_speed>4.7</wind_speed>
<humidity>78</humidity>
<pressure units="torr">760</pressure>
<mslp_pressure units="hPa">1032</mslp_pressure>
</day_part>
<hour at="0">
<temperature>-12</temperature>
<weather_condition code="overcast" />
<image type="1">n5</image>
<image-v2 color="377daf">ovc_-12</image-v2>
</hour>
<hour at="1">
<temperature>-13</temperature>
<weather_condition code="overcast" />
<image type="1">n5</image>
<image-v2 color="377daf">ovc_-12</image-v2>
</hour>
</day>
<day date="2012-01-26">
<sunrise>07:26</sunrise>
<sunset>16:21</sunset>
<moon_phase code="growing-moon">10</moon_phase>
<moonrise>08:17</moonrise>
<moonset>20:23</moonset>
<day_part typeid="5" type="day_short">
<temperature>-14</temperature>
<weather_condition code="cloudy" />
<image type="1">6</image>
<image-v2 color="2a81b9">bkn_d_-14</image-v2>
<weather_type>облачно с прояснениями</weather_type>
<weather_type_short>обл. с проясн.</weather_type_short>
<weather_type_tt>аязучан болытлы</weather_type_tt>
<weather_type_short_tt>аязуч. бол.</weather_type_short_tt>
<weather_type_kz>ауыспалы б?лтты</weather_type_kz>
<weather_type_short_kz>ауыспалы б?лтты</weather_type_short_kz>
<weather_type_ua>хмарно з проясненнями </weather_type_ua>
<weather_type_short_ua>хмарно з проясн.</weather_type_short_ua>
<weather_type_by>воблачна з праясненнямі</weather_type_by>
<weather_type_short_by>вобл. з праясн.</weather_type_short_by>
<wind_direction>e</wind_direction>
<wind_speed>5.7</wind_speed>
<humidity>69</humidity>
<pressure units="torr">761</pressure>
<mslp_pressure units="hPa">1034</mslp_pressure>
</day_part>
<day_part typeid="6" type="night_short">
<temperature>-17</temperature>
<weather_condition code="partly-cloudy" />
<image type="1">n6</image>
<image-v2 color="2584bc">bkn_n_-16</image-v2>
<weather_type>переменная облачность</weather_type>
<weather_type_short>перем. обл.</weather_type_short>
<weather_type_tt>алмашучан болытлылык</weather_type_tt>
<weather_type_short_tt>алмаш. бол.</weather_type_short_tt>
<weather_type_kz>?згермелі б?лттар</weather_type_kz>
<weather_type_short_kz>?згермелі б?лттар</weather_type_short_kz>
<weather_type_ua>мінлива хмарність</weather_type_ua>
<weather_type_short_ua>мінл. хмарн.</weather_type_short_ua>
<weather_type_by>пераменная воблачнасць</weather_type_by>
<weather_type_short_by>перам. вобл.</weather_type_short_by>
<wind_direction>e</wind_direction>
<wind_speed>5.3</wind_speed>
<humidity>81</humidity>
<pressure units="torr">764</pressure>
<mslp_pressure units="hPa">1038</mslp_pressure>
</day_part>
</day>
<day date="2012-01-27">
<sunrise>07:25</sunrise>
<sunset>16:22</sunset>
<moon_phase code="growing-moon">10</moon_phase>
<moonrise>08:36</moonrise>
<moonset>21:31</moonset>
<day_part typeid="5" type="day_short">
<temperature>-13</temperature>
<weather_condition code="clear" />
<image type="1">7</image>
<image-v2 color="377daf">skc_d_-12</image-v2>
<weather_type>ясно</weather_type>
<weather_type_short>ясно</weather_type_short>
<weather_type_tt>аяз</weather_type_tt>
<weather_type_short_tt>аяз</weather_type_short_tt>
<weather_type_kz>ашы?</weather_type_kz>
<weather_type_short_kz>ашы?</weather_type_short_kz>
<weather_type_ua>ясно</weather_type_ua>
<weather_type_short_ua>ясно</weather_type_short_ua>
<weather_type_by>ясна</weather_type_by>
<weather_type_short_by>ясна</weather_type_short_by>
<wind_direction>ne</wind_direction>
<wind_speed>4.7</wind_speed>
<humidity>73</humidity>
<pressure units="torr">765</pressure>
<mslp_pressure units="hPa">1039</mslp_pressure>
</day_part>
<day_part typeid="6" type="night_short">
<temperature>-20</temperature>
<weather_condition code="clear" />
<image type="1">n7</image>
<image-v2 color="0e7fcd">skc_n_-20</image-v2>
<weather_type>ясно</weather_type>
<weather_type_short>ясно</weather_type_short>
<weather_type_tt>аяз</weather_type_tt>
<weather_type_short_tt>аяз</weather_type_short_tt>
<weather_type_kz>ашы?</weather_type_kz>
<weather_type_short_kz>ашы?</weather_type_short_kz>
<weather_type_ua>ясно</weather_type_ua>
<weather_type_short_ua>ясно</weather_type_short_ua>
<weather_type_by>ясна</weather_type_by>
<weather_type_short_by>ясна</weather_type_short_by>
<wind_direction>ne</wind_direction>
<wind_speed>4.7</wind_speed>
<humidity>70</humidity>
<pressure units="torr">765</pressure>
<mslp_pressure units="hPa">1039</mslp_pressure>
</day_part>
</day>
<day date="2012-01-28">
<sunrise>07:23</sunrise>
<sunset>16:24</sunset>
<moon_phase code="growing-moon">11</moon_phase>
<moonrise>08:55</moonrise>
<moonset>22:37</moonset>
<day_part typeid="5" type="day_short">
<temperature>-15</temperature>
<weather_condition code="clear" />
<image type="1">7</image>
<image-v2 color="2a81b9">skc_d_-14</image-v2>
<weather_type>ясно</weather_type>
<weather_type_short>ясно</weather_type_short>
<weather_type_tt>аяз</weather_type_tt>
<weather_type_short_tt>аяз</weather_type_short_tt>
<weather_type_kz>ашы?</weather_type_kz>
<weather_type_short_kz>ашы?</weather_type_short_kz>
<weather_type_ua>ясно</weather_type_ua>
<weather_type_short_ua>ясно</weather_type_short_ua>
<weather_type_by>ясна</weather_type_by>
<weather_type_short_by>ясна</weather_type_short_by>
<wind_direction>n</wind_direction>
<wind_speed>5.3</wind_speed>
<humidity>67</humidity>
<pressure units="torr">763</pressure>
<mslp_pressure units="hPa">1036</mslp_pressure>
</day_part>
<day_part typeid="6" type="night_short">
<temperature>-16</temperature>
<weather_condition code="overcast" />
<image type="1">n5</image>
<image-v2 color="2584bc">ovc_-16</image-v2>
<weather_type>облачно</weather_type>
<weather_type_short>облачно</weather_type_short>
<weather_type_tt>болытлы</weather_type_tt>
<weather_type_short_tt>болытлы</weather_type_short_tt>
<weather_type_kz>б?лтты</weather_type_kz>
<weather_type_short_kz>б?лтты</weather_type_short_kz>
<weather_type_ua>хмарно</weather_type_ua>
<weather_type_short_ua>хмарно</weather_type_short_ua>
<weather_type_by>воблачна</weather_type_by>
<weather_type_short_by>воблачна</weather_type_short_by>
<wind_direction>n</wind_direction>
<wind_speed>5.2</wind_speed>
<humidity>84</humidity>
<pressure units="torr">761</pressure>
<mslp_pressure units="hPa">1034</mslp_pressure>
</day_part>
</day>
<day date="2012-01-29">
<sunrise>07:22</sunrise>
<sunset>16:26</sunset>
<moon_phase code="growing-moon">11</moon_phase>
<moonrise>09:16</moonrise>
<moonset>23:43</moonset>
<day_part typeid="5" type="day_short">
<temperature>-10</temperature>
<weather_condition code="overcast" />
<image type="1">5</image>
<image-v2 color="4582a5">ovc_-10</image-v2>
<weather_type>облачно</weather_type>
<weather_type_short>облачно</weather_type_short>
<weather_type_tt>болытлы</weather_type_tt>
<weather_type_short_tt>болытлы</weather_type_short_tt>
<weather_type_kz>б?лтты</weather_type_kz>
<weather_type_short_kz>б?лтты</weather_type_short_kz>
<weather_type_ua>хмарно</weather_type_ua>
<weather_type_short_ua>хмарно</weather_type_short_ua>
<weather_type_by>воблачна</weather_type_by>
<weather_type_short_by>воблачна</weather_type_short_by>
<wind_direction>ne</wind_direction>
<wind_speed>7.8</wind_speed>
<humidity>78</humidity>
<pressure units="torr">761</pressure>
<mslp_pressure units="hPa">1033</mslp_pressure>
</day_part>
<day_part typeid="6" type="night_short">
<temperature>-13</temperature>
<weather_condition code="overcast-and-light-snow" />
<image type="2">n13</image>
<image-v2 color="377daf">ovc_-sn_-12</image-v2>
<weather_type>облачно, небольшой снег</weather_type>
<weather_type_short>обл., неб. снег</weather_type_short>
<weather_type_tt>болытлы, аз гына кар</weather_type_tt>
<weather_type_short_tt>бол., аз гына кар</weather_type_short_tt>
<weather_type_kz>б?лы??ыр, азда?ан ?ар</weather_type_kz>
<weather_type_short_kz>б?лы??ыр, азда?ан ?ар</weather_type_short_kz>
<weather_type_ua>хмарно, невеликий сніг</weather_type_ua>
<weather_type_short_ua>хмарно, невел. сніг</weather_type_short_ua>
<weather_type_by>воблачна, слабы снег</weather_type_by>
<weather_type_short_by>вобл., сл. снег</weather_type_short_by>
<wind_direction>ne</wind_direction>
<wind_speed>6.2</wind_speed>
<humidity>81</humidity>
<pressure units="torr">763</pressure>
<mslp_pressure units="hPa">1036</mslp_pressure>
</day_part>
</day>
<day date="2012-01-30">
<sunrise>07:21</sunrise>
<sunset>16:28</sunset>
<moon_phase code="growing-moon">12</moon_phase>
<moonrise>09:38</moonrise>
<day_part typeid="5" type="day_short">
<temperature>-13</temperature>
<weather_condition code="mostly-clear" />
<image type="1">6</image>
<image-v2 color="377daf">bkn_d_-12</image-v2>
<weather_type>малооблачно</weather_type>
<weather_type_short>малообл.</weather_type_short>
<weather_type_tt>аз болытлы</weather_type_tt>
<weather_type_short_tt>аз болытлы</weather_type_short_tt>
<weather_type_kz>азда?ан б?лт</weather_type_kz>
<weather_type_short_kz>азда?ан б?лт</weather_type_short_kz>
<weather_type_ua>малохмарно</weather_type_ua>
<weather_type_short_ua>малохмарно</weather_type_short_ua>
<weather_type_by>малавоблачна</weather_type_by>
<weather_type_short_by>малавобл.</weather_type_short_by>
<wind_direction>ne</wind_direction>
<wind_speed>6.5</wind_speed>
<humidity>75</humidity>
<pressure units="torr">764</pressure>
<mslp_pressure units="hPa">1037</mslp_pressure>
</day_part>
<day_part typeid="6" type="night_short">
<temperature>-23</temperature>
<weather_condition code="partly-cloudy" />
<image type="1">n6</image>
<image-v2 color="0086d8">bkn_n_-22</image-v2>
<weather_type>переменная облачность</weather_type>
<weather_type_short>перем. обл.</weather_type_short>
<weather_type_tt>алмашучан болытлылык</weather_type_tt>
<weather_type_short_tt>алмаш. бол.</weather_type_short_tt>
<weather_type_kz>?згермелі б?лттар</weather_type_kz>
<weather_type_short_kz>?згермелі б?лттар</weather_type_short_kz>
<weather_type_ua>мінлива хмарність</weather_type_ua>
<weather_type_short_ua>мінл. хмарн.</weather_type_short_ua>
<weather_type_by>пераменная воблачнасць</weather_type_by>
<weather_type_short_by>перам. вобл.</weather_type_short_by>
<wind_direction>ne</wind_direction>
<wind_speed>4.5</wind_speed>
<humidity>79</humidity>
<pressure units="torr">764</pressure>
<mslp_pressure units="hPa">1037</mslp_pressure>
</day_part>
</day>
<day date="2012-01-31">
<sunrise>07:19</sunrise>
<sunset>16:29</sunset>
<moon_phase code="first-quarter">12</moon_phase>
<moonrise>10:04</moonrise>
<moonset>00:48</moonset>
<day_part typeid="5" type="day_short">
<temperature>-21</temperature>
<weather_condition code="overcast" />
<image type="1">5</image>
<image-v2 color="0e7fcd">ovc_-20</image-v2>
<weather_type>облачно</weather_type>
<weather_type_short>облачно</weather_type_short>
<weather_type_tt>болытлы</weather_type_tt>
<weather_type_short_tt>болытлы</weather_type_short_tt>
<weather_type_kz>б?лтты</weather_type_kz>
<weather_type_short_kz>б?лтты</weather_type_short_kz>
<weather_type_ua>хмарно</weather_type_ua>
<weather_type_short_ua>хмарно</weather_type_short_ua>
<weather_type_by>воблачна</weather_type_by>
<weather_type_short_by>воблачна</weather_type_short_by>
<wind_direction>ne</wind_direction>
<wind_speed>3.8</wind_speed>
<humidity>73</humidity>
<pressure units="torr">761</pressure>
<mslp_pressure units="hPa">1033</mslp_pressure>
</day_part>
<day_part typeid="6" type="night_short">
<temperature>-27</temperature>
<weather_condition code="clear" />
<image type="1">n7</image>
<image-v2 color="0083d1">skc_n_-26</image-v2>
<weather_type>ясно</weather_type>
<weather_type_short>ясно</weather_type_short>
<weather_type_tt>аяз</weather_type_tt>
<weather_type_short_tt>аяз</weather_type_short_tt>
<weather_type_kz>ашы?</weather_type_kz>
<weather_type_short_kz>ашы?</weather_type_short_kz>
<weather_type_ua>ясно</weather_type_ua>
<weather_type_short_ua>ясно</weather_type_short_ua>
<weather_type_by>ясна</weather_type_by>
<weather_type_short_by>ясна</weather_type_short_by>
<wind_direction>n</wind_direction>
<wind_speed>3.5</wind_speed>
<humidity>80</humidity>
<pressure units="torr">758</pressure>
<mslp_pressure units="hPa">1029</mslp_pressure>
</day_part>
</day>
<day date="2012-02-01">
<sunrise>07:18</sunrise>
<sunset>16:31</sunset>
<moon_phase code="growing-moon">12</moon_phase>
<moonrise>10:36</moonrise>
<moonset>01:51</moonset>
<day_part typeid="5" type="day_short">
<temperature>-16</temperature>
<weather_condition code="overcast" />
<image type="1">5</image>
<image-v2 color="2584bc">ovc_-16</image-v2>
<weather_type>облачно</weather_type>
<weather_type_short>облачно</weather_type_short>
<weather_type_tt>болытлы</weather_type_tt>
<weather_type_short_tt>болытлы</weather_type_short_tt>
<weather_type_kz>б?лтты</weather_type_kz>
<weather_type_short_kz>б?лтты</weather_type_short_kz>
<weather_type_ua>хмарно</weather_type_ua>
<weather_type_short_ua>хмарно</weather_type_short_ua>
<weather_type_by>воблачна</weather_type_by>
<weather_type_short_by>воблачна</weather_type_short_by>
<wind_direction>n</wind_direction>
<wind_speed>5.0</wind_speed>
<humidity>76</humidity>
<pressure units="torr">755</pressure>
<mslp_pressure units="hPa">1026</mslp_pressure>
</day_part>
<day_part typeid="6" type="night_short">
<temperature>-20</temperature>
<weather_condition code="overcast" />
<image type="1">n5</image>
<image-v2 color="0e7fcd">ovc_-20</image-v2>
<weather_type>облачно</weather_type>
<weather_type_short>облачно</weather_type_short>
<weather_type_tt>болытлы</weather_type_tt>
<weather_type_short_tt>болытлы</weather_type_short_tt>
<weather_type_kz>б?лтты</weather_type_kz>
<weather_type_short_kz>б?лтты</weather_type_short_kz>
<weather_type_ua>хмарно</weather_type_ua>
<weather_type_short_ua>хмарно</weather_type_short_ua>
<weather_type_by>воблачна</weather_type_by>
<weather_type_short_by>воблачна</weather_type_short_by>
<wind_direction>e</wind_direction>
<wind_speed>4.2</wind_speed>
<humidity>83</humidity>
<pressure units="torr">758</pressure>
<mslp_pressure units="hPa">1029</mslp_pressure>
</day_part>
</day>
</forecast>



Как со схемой получить например значение <observation_time> ?

Без схемы все понятно:

declare @x xml

set @x='<forecast city="Test" country="Test" region="965" lon="79.823147" zoom="10" id="33278" source="Station" country_id="a36132306e4574ca78381ceaac5b9e15" link="http://pogoda/Omsk/" part_id="4c02f07488cb250358249d231c470a62" geoid="965" lat="55.907652" exactname="Test" part="Omskaya область" slug="TEst">
  <fact>
    <station lang="ru" distance="11">Omsk</station>
    <station lang="en" distance="11">Omsk</station>
    <observation_time>2012-01-23T14:00:00</observation_time>
    <temperature color="E0E7EE" plate="a7c8ea">-6</temperature>
    <weather_condition code="overcast-and-snow-showers" />
    <image type="2">13</image>
    <image-v2 color="5c7794">ovc_-sn_-6</image-v2>
    <weather_type>облачно, временами снег</weather_type>
    <weather_type_short>обл., вр. снег</weather_type_short>
    <weather_type_tt>болытлы, вакыты бел?н кар</weather_type_tt>
    <weather_type_short_tt>бол., вак. кар</weather_type_short_tt>
    <weather_type_kz>б?лы??ыр, кейде ?ар</weather_type_kz>
    <weather_type_short_kz>б?лы??ыр, кейде ?ар</weather_type_short_kz>
    <weather_type_ua>хмарно, часом сніг</weather_type_ua>
    <weather_type_short_ua>хмарно, часом сніг</weather_type_short_ua>
    <weather_type_by>воблачна, часам снег</weather_type_by>
    <weather_type_short_by>вобл., часам снег</weather_type_short_by>
    <wind_direction>se</wind_direction>
    <wind_speed>7.0</wind_speed>
    <humidity>86</humidity>
    <pressure units="torr">747</pressure>
    <mslp_pressure units="hPa">1015</mslp_pressure>
    <daytime>d</daytime>
    <season type="calendar">winter</season>
  </fact>
  </forecast>'

select @x

select n.s.value('observation_time[1]','date') 
from @x.nodes('/forecast/fact') n(s)
23 янв 12, 22:24    [11956643]     Ответить | Цитировать Сообщить модератору
 Re: xml со схемой  [new]
Ennor Tiegael
Member

Откуда:
Сообщений: 3422
with xmlnamespaces
24 янв 12, 00:34    [11957116]     Ответить | Цитировать Сообщить модератору
 Re: xml со схемой  [new]
Mnior
Member

Откуда: Кишинёв
Сообщений: 6724
А причём тут схема?
Она разве что для XmlBulkLoad или контроля сохраняемого XML,
но разве для XQuery помогает?.
24 янв 12, 10:21    [11958118]     Ответить | Цитировать Сообщить модератору
 Re: xml со схемой  [new]
В трех соснах_заблудился
Guest
Mnior,

Без указания схемы получить значение не получАлось

получИлось только с ее указанием. Спасибо Ennor Tiegael :

;with xmlnamespaces (default 'test')
select a.b.value('observation_time[1]', 'datetime')
from @x.nodes('/forecast/fact') a(b)
24 янв 12, 12:57    [11959458]     Ответить | Цитировать Сообщить модератору
 Re: xml со схемой  [new]
Mnior
Member

Откуда: Кишинёв
Сообщений: 6724
В трех соснах_заблудился
Без указания схемы получить значение не получАлось
Плаваете вы в понятиях и нифига не поняли.

пространство имён (xmlnamespaces) - это тупо названия
XSD схема - это описание структуры

Схема к пространству имён для XQuery не имеет никакого отношения.

Но вам скорее пофигу на это.
24 янв 12, 23:54    [11964602]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить